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 (182953, 182673, 182014, 180329, 179595, 177885, 175831, 175778, 175157, 174702, 174292, 174131, 174110, 173885, 173811, 172290, 171772, 171006, 170389, 167087, 166788, 165421, 163197, 162840, 162033, 161592, 159690, 158940, 157945, 157895, 157337, 156462, 154709, 153898, 152832, 151690, 132070, 130580, 103010, 89949, 85860, 85672, 77491, 77444, 75851, 72450, 71545, 66740, 66378, 59479, 58997, 54348, 53005, 26754, 22610, 18683))
Run Time: 0.020031
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 56 | 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: 2537, 0, 1716170689, {"thread-182953":["thread",182953],"thread-182673":["thread",182673],"thread-182014":["thread",182014],"thread-180329":["thread",180329],"thread-179595":["thread",179595],"thread-177885":["thread",177885],"thread-175831":["thread",175831],"thread-175778":["thread",175778],"thread-175157":["thread",175157],"thread-174702":["thread",174702],"thread-174292":["thread",174292],"thread-174131":["thread",174131],"thread-174110":["thread",174110],"thread-173885":["thread",173885],"thread-173811":["thread",173811],"thread-172290":["thread",172290],"thread-171772":["thread",171772],"thread-171006":["thread",171006],"thread-170389":["thread",170389],"thread-167087":["thread",167087],"thread-166788":["thread",166788],"thread-165421":["thread",165421],"thread-163197":["thread",163197],"thread-162840":["thread",162840],"thread-162033":["thread",162033],"thread-161592":["thread",161592],"thread-159690":["thread",159690],"thread-158940":["thread",158940],"thread-157945":["thread",157945],"thread-157337":["thread",157337],"thread-156462":["thread",156462],"thread-154709":["thread",154709],"thread-153898":["thread",153898],"thread-152832":["thread",152832],"thread-151690":["thread",151690],"thread-132070":["thread",132070],"thread-130580":["thread",130580],"thread-103010":["thread",103010],"thread-89949":["thread",89949],"thread-85860":["thread",85860],"thread-85672":["thread",85672],"thread-77491":["thread",77491],"thread-77444":["thread",77444],"thread-75851":["thread",75851],"thread-72450":["thread",72450],"thread-71545":["thread",71545],"thread-66740":["thread",66740],"thread-66378":["thread",66378],"thread-59479":["thread",59479],"thread-58997":["thread",58997],"thread-54348":["thread",54348],"thread-53005":["thread",53005],"thread-26754":["thread",26754],"thread-22610":["thread",22610],"thread-18683":["thread",18683]}, , 1716167089
Run Time: 0.000629
- 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