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 (7216389, 7212946, 7210012, 7207458, 7207314, 7204810, 7203709, 7199412, 7194262, 7191263, 7189736, 7187583, 7184940, 7183672, 7182867, 7178384, 7177909, 7175518, 7168052, 7155421, 7148512, 7137657, 7134160, 7132883, 7129556, 7129370, 7127588, 7127553, 7122502, 7119613, 7117215, 7116866, 7115423, 7113532, 7110811, 7109476, 7097638, 7084902, 7084282, 7082961, 7079776, 7075650, 7073236, 7073232, 7072562, 7071719, 7071557, 7068414, 7067313, 7062077, 7054020, 7009023, 7007977, 6999658, 6996073, 6995892, 6994334, 6991829, 6990138, 6988726, 6988206, 6987636, 6972414, 6962789, 231624, 176286, 160768, 13279, 11750, 11486, 9443, 8870, 8352, 8092, 6313, 5854, 5178, 4096, 3432, 3209, 2960, 2950, 2841, 1536, 584))
Run Time: 0.005252
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 85 | 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: 680, 0, 1714630975, {"thread-7216389":["thread",7216389],"thread-7212946":["thread",7212946],"thread-7210012":["thread",7210012],"thread-7207458":["thread",7207458],"thread-7207314":["thread",7207314],"thread-7204810":["thread",7204810],"xfmg_media-3950":["xfmg_media",3950],"thread-7203709":["thread",7203709],"thread-7199412":["thread",7199412],"thread-7194262":["thread",7194262],"thread-7191263":["thread",7191263],"thread-7189736":["thread",7189736],"thread-7187583":["thread",7187583],"thread-7184940":["thread",7184940],"thread-7183672":["thread",7183672],"thread-7182867":["thread",7182867],"thread-7178384":["thread",7178384],"thread-7177909":["thread",7177909],"thread-7175518":["thread",7175518],"thread-7168052":["thread",7168052],"thread-7155421":["thread",7155421],"thread-7148512":["thread",7148512],"thread-7137657":["thread",7137657],"thread-7134160":["thread",7134160],"thread-7132883":["thread",7132883],"thread-7129556":["thread",7129556],"thread-7129370":["thread",7129370],"thread-7127588":["thread",7127588],"thread-7127553":["thread",7127553],"thread-7122502":["thread",7122502],"thread-7119613":["thread",7119613],"thread-7117215":["thread",7117215],"thread-7116866":["thread",7116866],"thread-7115423":["thread",7115423],"thread-7113532":["thread",7113532],"thread-7110811":["thread",7110811],"thread-7109476":["thread",7109476],"thread-7097638":["thread",7097638],"thread-7084902":["thread",7084902],"thread-7084282":["thread",7084282],"thread-7082961":["thread",7082961],"thread-7079776":["thread",7079776],"thread-7075650":["thread",7075650],"thread-7073236":["thread",7073236],"thread-7073232":["thread",7073232],"thread-7072562":["thread",7072562],"thread-7071719":["thread",7071719],"thread-7071557":["thread",7071557],"thread-7068414":["thread",7068414],"thread-7067313":["thread",7067313],"thread-7062077":["thread",7062077],"thread-7054020":["thread",7054020],"thread-7009023":["thread",7009023],"thread-7007977":["thread",7007977],"thread-6999658":["thread",6999658],"thread-6996073":["thread",6996073],"thread-6995892":["thread",6995892],"thread-6994334":["thread",6994334],"thread-6991829":["thread",6991829],"thread-6990138":["thread",6990138],"thread-6988726":["thread",6988726],"thread-6988206":["thread",6988206],"thread-6987636":["thread",6987636],"thread-6972414":["thread",6972414],"thread-6962789":["thread",6962789],"thread-231624":["thread",231624],"thread-176286":["thread",176286],"thread-160768":["thread",160768],"thread-13279":["thread",13279],"thread-11750":["thread",11750],"thread-11486":["thread",11486],"thread-9443":["thread",9443],"thread-8870":["thread",8870],"thread-8352":["thread",8352],"thread-8092":["thread",8092],"thread-6313":["thread",6313],"thread-5854":["thread",5854],"thread-5178":["thread",5178],"thread-4096":["thread",4096],"thread-3432":["thread",3432],"thread-3209":["thread",3209],"thread-2960":["thread",2960],"thread-2950":["thread",2950],"thread-2841":["thread",2841],"thread-1536":["thread",1536],"thread-584":["thread",584]}, NULL, 1714627375
Run Time: 0.000615
- 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