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 (7216843, 7214687, 7210209, 7194183, 7188284, 7187182, 7185615, 7174687, 7170849, 7164542, 7149781, 7138570, 7111833, 7105042, 7095152, 7091546, 7073553, 7071583, 7070505, 7054332, 7053308, 7051299, 7030305, 7019269, 7009121, 7000329, 6986513, 6967126, 171466, 166696, 13609, 13425, 13033, 12578, 12512, 12472, 12470, 12445, 12364, 11850, 11595, 11434, 11323, 11169, 10769, 10449, 10278, 9967, 9931, 9866, 9786, 9589, 9544, 9009, 7763, 6761, 6378, 6377, 6282, 6241, 5319, 5164, 4986, 4759, 4106, 3904, 3687, 3363, 3041, 2995, 2696, 2473, 1301, 1297, 637))
Run Time: 0.004665
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 75 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,production_xf.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 1430
- 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 2870
- 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 138
- 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 2487
- XF\App->run() in src/XF.php at line 524
- 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: 754, 0, 1714905759, {"thread-7216843":["thread",7216843],"thread-7214687":["thread",7214687],"thread-7210209":["thread",7210209],"thread-7194183":["thread",7194183],"thread-7188284":["thread",7188284],"thread-7187182":["thread",7187182],"thread-7185615":["thread",7185615],"thread-7174687":["thread",7174687],"thread-7170849":["thread",7170849],"thread-7164542":["thread",7164542],"thread-7149781":["thread",7149781],"thread-7138570":["thread",7138570],"thread-7111833":["thread",7111833],"thread-7105042":["thread",7105042],"thread-7095152":["thread",7095152],"thread-7091546":["thread",7091546],"thread-7073553":["thread",7073553],"thread-7071583":["thread",7071583],"thread-7070505":["thread",7070505],"thread-7054332":["thread",7054332],"thread-7053308":["thread",7053308],"thread-7051299":["thread",7051299],"thread-7030305":["thread",7030305],"thread-7019269":["thread",7019269],"thread-7009121":["thread",7009121],"thread-7000329":["thread",7000329],"thread-6986513":["thread",6986513],"thread-6967126":["thread",6967126],"thread-171466":["thread",171466],"thread-166696":["thread",166696],"thread-13609":["thread",13609],"thread-13425":["thread",13425],"thread-13033":["thread",13033],"thread-12578":["thread",12578],"thread-12512":["thread",12512],"thread-12472":["thread",12472],"thread-12470":["thread",12470],"thread-12445":["thread",12445],"thread-12364":["thread",12364],"thread-11850":["thread",11850],"thread-11595":["thread",11595],"thread-11434":["thread",11434],"thread-11323":["thread",11323],"thread-11169":["thread",11169],"thread-10769":["thread",10769],"thread-10449":["thread",10449],"thread-10278":["thread",10278],"thread-9967":["thread",9967],"thread-9931":["thread",9931],"thread-9866":["thread",9866],"thread-9786":["thread",9786],"thread-9589":["thread",9589],"thread-9544":["thread",9544],"thread-9009":["thread",9009],"thread-7763":["thread",7763],"thread-6761":["thread",6761],"thread-6378":["thread",6378],"thread-6377":["thread",6377],"thread-6282":["thread",6282],"thread-6241":["thread",6241],"thread-5319":["thread",5319],"thread-5164":["thread",5164],"thread-4986":["thread",4986],"thread-4759":["thread",4759],"thread-4106":["thread",4106],"thread-3904":["thread",3904],"thread-3687":["thread",3687],"thread-3363":["thread",3363],"thread-3041":["thread",3041],"thread-2995":["thread",2995],"thread-2696":["thread",2696],"thread-2473":["thread",2473],"thread-1301":["thread",1301],"thread-1297":["thread",1297],"thread-637":["thread",637]}, NULL, 1714902159
Run Time: 0.000464
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20