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 (182891, 181841, 181795, 181767, 180958, 150485, 114231, 110703, 110068, 109374, 109332, 109092, 109038, 99880, 87317, 80532, 66658, 64345, 63730, 61328, 61104, 61100, 61005, 61002, 60994, 60887, 60833, 60419, 60418, 60332, 60148, 59734, 59119, 58313, 56227, 56221, 55117, 54662, 54162, 53460, 53063, 52601, 52587, 52570, 52529, 52191, 51738, 51527, 41368, 41270, 41269, 41268, 41267, 41135, 41096, 40560, 40216, 40197, 39828, 39794, 39790, 39542, 39104, 39094, 39090, 39086, 38572, 34944, 33742, 30337, 30024, 29907, 29895, 29892, 29688, 29619, 29471, 29354, 28841, 27612, 27609, 26356, 25495, 24789, 23685, 21617, 20842, 20277, 20163, 19844, 19708, 4601, 3141, 1345))
Run Time: 0.028076
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 94 | 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
UPDATE `xf_tag_result_cache` SET `expiry_date` = ?, `results` = ? WHERE `result_cache_id` = 802958
Params: 1715116060, {"thread-182891":["thread",182891],"thread-181841":["thread",181841],"thread-181795":["thread",181795],"thread-181767":["thread",181767],"thread-180958":["thread",180958],"tl_group-363":["tl_group",363],"thread-150485":["thread",150485],"thread-114231":["thread",114231],"thread-110703":["thread",110703],"thread-110068":["thread",110068],"thread-109374":["thread",109374],"thread-109332":["thread",109332],"thread-109092":["thread",109092],"thread-109038":["thread",109038],"thread-99880":["thread",99880],"thread-87317":["thread",87317],"thread-80532":["thread",80532],"thread-66658":["thread",66658],"thread-64345":["thread",64345],"thread-63730":["thread",63730],"thread-61328":["thread",61328],"thread-61104":["thread",61104],"thread-61100":["thread",61100],"thread-61005":["thread",61005],"thread-61002":["thread",61002],"thread-60994":["thread",60994],"thread-60887":["thread",60887],"thread-60833":["thread",60833],"thread-60419":["thread",60419],"thread-60418":["thread",60418],"thread-60332":["thread",60332],"thread-60148":["thread",60148],"thread-59734":["thread",59734],"thread-59119":["thread",59119],"thread-58313":["thread",58313],"thread-56227":["thread",56227],"thread-56221":["thread",56221],"thread-55117":["thread",55117],"thread-54662":["thread",54662],"thread-54162":["thread",54162],"thread-53460":["thread",53460],"thread-53063":["thread",53063],"thread-52601":["thread",52601],"thread-52587":["thread",52587],"thread-52570":["thread",52570],"thread-52529":["thread",52529],"thread-52191":["thread",52191],"thread-51738":["thread",51738],"thread-51527":["thread",51527],"thread-41368":["thread",41368],"thread-41270":["thread",41270],"thread-41269":["thread",41269],"thread-41268":["thread",41268],"thread-41267":["thread",41267],"thread-41135":["thread",41135],"thread-41096":["thread",41096],"thread-40560":["thread",40560],"thread-40216":["thread",40216],"thread-40197":["thread",40197],"thread-39828":["thread",39828],"thread-39794":["thread",39794],"thread-39790":["thread",39790],"thread-39542":["thread",39542],"thread-39104":["thread",39104],"thread-39094":["thread",39094],"thread-39090":["thread",39090],"thread-39086":["thread",39086],"thread-38572":["thread",38572],"thread-34944":["thread",34944],"thread-33742":["thread",33742],"thread-30337":["thread",30337],"thread-30024":["thread",30024],"thread-29907":["thread",29907],"thread-29895":["thread",29895],"thread-29892":["thread",29892],"thread-29688":["thread",29688],"thread-29619":["thread",29619],"thread-29471":["thread",29471],"thread-29354":["thread",29354],"thread-28841":["thread",28841],"thread-27612":["thread",27612],"thread-27609":["thread",27609],"thread-26356":["thread",26356],"thread-25495":["thread",25495],"thread-24789":["thread",24789],"thread-23685":["thread",23685],"thread-21617":["thread",21617],"thread-20842":["thread",20842],"thread-20277":["thread",20277],"thread-20163":["thread",20163],"thread-19844":["thread",19844],"thread-19708":["thread",19708],"thread-4601":["thread",4601],"thread-3141":["thread",3141],"thread-1345":["thread",1345]}
Run Time: 0.000279
- 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 324
- XF\Db\AbstractAdapter->update() in src/XF/Mvc/Entity/Entity.php at line 1519
- 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