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 (117662, 112185, 112100, 112099, 111344, 110985, 110920, 110843, 110779, 110733, 109532, 83076, 81737, 81516, 81379, 81176, 81162, 76303, 75782, 72601, 72373, 72285, 72188, 72032, 71414, 71413, 70035, 61842, 61714, 61711, 60214, 59837, 59379, 59375, 58755, 58644, 58360, 58351, 58348, 57602, 57593, 57375, 55713, 55432, 55430, 48186, 34283, 34250, 33084, 32613, 32573, 32567, 32362, 31890, 31803, 31519, 31486, 31405, 31401, 31398, 30879, 30819, 30529, 30527, 30522, 30422, 30153, 30053, 30052, 30034, 29882, 29876, 29866, 29831, 29830, 29827, 29813, 29301, 29289, 29100, 29096, 29072, 28275, 25342, 25182, 25025, 24428, 24422, 23923, 23920, 23301, 23192, 22588, 22443, 22441, 22306, 22254, 22077, 21789, 20697, 20694, 20440, 19998, 19973, 19678, 19675, 19523, 19499, 19455, 18954, 18948, 18907, 18905, 18902, 18100, 17994, 16990, 16677, 16511, 16154, 15968, 15882, 15877, 14418, 14063, 13735, 12480, 12353, 12236, 11858, 11820, 11798, 11738, 11542, 11506, 11366, 11287, 11140, 11133, 11132, 10984, 10791, 10769, 10587, 10562))
Run Time: 0.083162
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 145 | 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: 1721, 0, 1714893118, {"thread-117662":["thread",117662],"thread-112185":["thread",112185],"thread-112100":["thread",112100],"thread-112099":["thread",112099],"thread-111344":["thread",111344],"thread-110985":["thread",110985],"thread-110920":["thread",110920],"thread-110843":["thread",110843],"thread-110779":["thread",110779],"thread-110733":["thread",110733],"thread-109532":["thread",109532],"thread-83076":["thread",83076],"thread-81737":["thread",81737],"thread-81516":["thread",81516],"thread-81379":["thread",81379],"thread-81176":["thread",81176],"thread-81162":["thread",81162],"thread-76303":["thread",76303],"thread-75782":["thread",75782],"thread-72601":["thread",72601],"thread-72373":["thread",72373],"thread-72285":["thread",72285],"thread-72188":["thread",72188],"thread-72032":["thread",72032],"thread-71414":["thread",71414],"thread-71413":["thread",71413],"thread-70035":["thread",70035],"thread-61842":["thread",61842],"thread-61714":["thread",61714],"thread-61711":["thread",61711],"thread-60214":["thread",60214],"thread-59837":["thread",59837],"thread-59379":["thread",59379],"thread-59375":["thread",59375],"thread-58755":["thread",58755],"thread-58644":["thread",58644],"thread-58360":["thread",58360],"thread-58351":["thread",58351],"thread-58348":["thread",58348],"thread-57602":["thread",57602],"thread-57593":["thread",57593],"thread-57375":["thread",57375],"thread-55713":["thread",55713],"thread-55432":["thread",55432],"thread-55430":["thread",55430],"thread-48186":["thread",48186],"thread-34283":["thread",34283],"thread-34250":["thread",34250],"thread-33084":["thread",33084],"thread-32613":["thread",32613],"thread-32573":["thread",32573],"thread-32567":["thread",32567],"thread-32362":["thread",32362],"thread-31890":["thread",31890],"thread-31803":["thread",31803],"thread-31519":["thread",31519],"thread-31486":["thread",31486],"thread-31405":["thread",31405],"thread-31401":["thread",31401],"thread-31398":["thread",31398],"thread-30879":["thread",30879],"thread-30819":["thread",30819],"thread-30529":["thread",30529],"thread-30527":["thread",30527],"thread-30522":["thread",30522],"thread-30422":["thread",30422],"thread-30153":["thread",30153],"thread-30053":["thread",30053],"thread-30052":["thread",30052],"thread-30034":["thread",30034],"thread-29882":["thread",29882],"thread-29876":["thread",29876],"thread-29866":["thread",29866],"thread-29831":["thread",29831],"thread-29830":["thread",29830],"thread-29827":["thread",29827],"thread-29813":["thread",29813],"thread-29301":["thread",29301],"thread-29289":["thread",29289],"thread-29100":["thread",29100],"thread-29096":["thread",29096],"thread-29072":["thread",29072],"thread-28275":["thread",28275],"thread-25342":["thread",25342],"thread-25182":["thread",25182],"thread-25025":["thread",25025],"thread-24428":["thread",24428],"thread-24422":["thread",24422],"thread-23923":["thread",23923],"thread-23920":["thread",23920],"thread-23301":["thread",23301],"thread-23192":["thread",23192],"thread-22588":["thread",22588],"thread-22443":["thread",22443],"thread-22441":["thread",22441],"thread-22306":["thread",22306],"thread-22254":["thread",22254],"thread-22077":["thread",22077],"thread-21789":["thread",21789],"thread-20697":["thread",20697],"thread-20694":["thread",20694],"thread-20440":["thread",20440],"thread-19998":["thread",19998],"thread-19973":["thread",19973],"thread-19678":["thread",19678],"thread-19675":["thread",19675],"thread-19523":["thread",19523],"thread-19499":["thread",19499],"thread-19455":["thread",19455],"thread-18954":["thread",18954],"thread-18948":["thread",18948],"thread-18907":["thread",18907],"thread-18905":["thread",18905],"thread-18902":["thread",18902],"thread-18100":["thread",18100],"thread-17994":["thread",17994],"thread-16990":["thread",16990],"thread-16677":["thread",16677],"thread-16511":["thread",16511],"thread-16154":["thread",16154],"thread-15968":["thread",15968],"thread-15882":["thread",15882],"thread-15877":["thread",15877],"thread-14418":["thread",14418],"thread-14063":["thread",14063],"thread-13735":["thread",13735],"thread-12480":["thread",12480],"thread-12353":["thread",12353],"thread-12236":["thread",12236],"thread-11858":["thread",11858],"thread-11820":["thread",11820],"thread-11798":["thread",11798],"thread-11738":["thread",11738],"thread-11542":["thread",11542],"thread-11506":["thread",11506],"thread-11366":["thread",11366],"thread-11287":["thread",11287],"thread-11140":["thread",11140],"thread-11133":["thread",11133],"thread-11132":["thread",11132],"thread-10984":["thread",10984],"thread-10791":["thread",10791],"thread-10769":["thread",10769],"thread-10587":["thread",10587],"thread-10562":["thread",10562]}, , 1714889518
Run Time: 0.000794
- 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