SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_post_FirstPost_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_4` ON (`xf_post_FirstPost_4`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (128270, 126869, 116974, 107655, 105784, 103559, 103558, 102727, 102426, 101702, 101694, 101600, 101576, 101575, 101320, 100939, 100869, 100827, 100543, 100505, 100453, 100263, 99704, 98803, 98764, 98731, 98730, 98682, 98447, 98440, 98327, 98249, 98243, 98131, 96331, 95238, 94846, 94785, 94762, 94697, 94651, 94647, 94533, 94401, 93871, 93556, 92780, 91877, 91744, 91084, 90586, 90355, 90348, 90337))
Run Time: 0.031216
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 54 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1387
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2729
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 731
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 137
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
INSERT INTO `xf_tag_result_cache` (`tag_id`, `user_id`, `expiry_date`, `results`, `result_cache_id`, `cache_date`) VALUES (?, ?, ?, ?, ?, ?)
Params: 19768, 0, 1714261234, {"thread-128270":["thread",128270],"thread-126869":["thread",126869],"thread-116974":["thread",116974],"thread-107655":["thread",107655],"thread-105784":["thread",105784],"thread-103559":["thread",103559],"thread-103558":["thread",103558],"thread-102727":["thread",102727],"thread-102426":["thread",102426],"thread-101702":["thread",101702],"thread-101694":["thread",101694],"thread-101600":["thread",101600],"thread-101576":["thread",101576],"thread-101575":["thread",101575],"thread-101320":["thread",101320],"thread-100939":["thread",100939],"thread-100869":["thread",100869],"thread-100827":["thread",100827],"thread-100543":["thread",100543],"thread-100505":["thread",100505],"thread-100453":["thread",100453],"thread-100263":["thread",100263],"thread-99704":["thread",99704],"thread-98803":["thread",98803],"thread-98764":["thread",98764],"thread-98731":["thread",98731],"thread-98730":["thread",98730],"thread-98682":["thread",98682],"thread-98447":["thread",98447],"thread-98440":["thread",98440],"thread-98327":["thread",98327],"thread-98249":["thread",98249],"thread-98243":["thread",98243],"thread-98131":["thread",98131],"thread-96331":["thread",96331],"thread-95238":["thread",95238],"thread-94846":["thread",94846],"thread-94785":["thread",94785],"thread-94762":["thread",94762],"thread-94697":["thread",94697],"thread-94651":["thread",94651],"thread-94647":["thread",94647],"thread-94533":["thread",94533],"thread-94401":["thread",94401],"thread-93871":["thread",93871],"thread-93556":["thread",93556],"thread-92780":["thread",92780],"thread-91877":["thread",91877],"thread-91744":["thread",91744],"thread-91084":["thread",91084],"thread-90586":["thread",90586],"thread-90355":["thread",90355],"thread-90348":["thread",90348],"thread-90337":["thread",90337]}, , 1714257634
Run Time: 0.000517
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 220
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 150
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20