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 (12031, 11854, 11848, 11774, 11496, 11409, 11321, 11210, 11075, 10818, 10490, 10361, 10341, 9962, 9840, 9811, 9365, 9326, 9256, 8981, 8958, 8927, 8926, 8925, 8788, 8747, 8503, 8396, 8240, 8022, 7975, 7957, 7939, 7779, 7723, 7649, 7618, 7578, 7504, 7170, 7162, 7156, 7154, 7147, 7088, 7042, 7032, 6980, 6921, 6888, 6762, 6689, 6576, 6470, 6281, 6266, 6196, 5922, 5880, 5877, 5709, 5707, 5657, 5652, 5646, 5407, 5369, 5328, 5196, 5194, 5114, 4954, 4812, 4779, 4656, 4547, 4521, 4480, 4471, 4466, 4340, 4307, 3989, 3963, 3874, 3821, 3807, 3804, 3652, 3608, 3579, 3481, 3447, 3245, 3154, 3120, 3106, 3048, 3030, 3013, 2909, 2845, 2779, 2629, 2626, 861, 830, 753, 721, 677, 588, 522, 473, 100))
Run Time: 0.005621
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 114 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xencybim.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xencybim.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xencybim.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xencybim.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xencybim.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: 208, 0, 1715145381, {"thread-12031":["thread",12031],"thread-11854":["thread",11854],"thread-11848":["thread",11848],"thread-11774":["thread",11774],"thread-11496":["thread",11496],"thread-11409":["thread",11409],"thread-11321":["thread",11321],"thread-11210":["thread",11210],"thread-11075":["thread",11075],"thread-10818":["thread",10818],"thread-10490":["thread",10490],"thread-10361":["thread",10361],"thread-10341":["thread",10341],"thread-9962":["thread",9962],"thread-9840":["thread",9840],"thread-9811":["thread",9811],"thread-9365":["thread",9365],"thread-9326":["thread",9326],"thread-9256":["thread",9256],"thread-8981":["thread",8981],"thread-8958":["thread",8958],"thread-8927":["thread",8927],"thread-8926":["thread",8926],"thread-8925":["thread",8925],"thread-8788":["thread",8788],"thread-8747":["thread",8747],"thread-8503":["thread",8503],"thread-8396":["thread",8396],"thread-8240":["thread",8240],"thread-8022":["thread",8022],"thread-7975":["thread",7975],"thread-7957":["thread",7957],"thread-7939":["thread",7939],"thread-7779":["thread",7779],"thread-7723":["thread",7723],"thread-7649":["thread",7649],"thread-7618":["thread",7618],"thread-7578":["thread",7578],"thread-7504":["thread",7504],"thread-7170":["thread",7170],"thread-7162":["thread",7162],"thread-7156":["thread",7156],"thread-7154":["thread",7154],"thread-7147":["thread",7147],"thread-7088":["thread",7088],"thread-7042":["thread",7042],"thread-7032":["thread",7032],"thread-6980":["thread",6980],"thread-6921":["thread",6921],"thread-6888":["thread",6888],"thread-6762":["thread",6762],"thread-6689":["thread",6689],"thread-6576":["thread",6576],"thread-6470":["thread",6470],"thread-6281":["thread",6281],"thread-6266":["thread",6266],"thread-6196":["thread",6196],"thread-5922":["thread",5922],"thread-5880":["thread",5880],"thread-5877":["thread",5877],"thread-5709":["thread",5709],"thread-5707":["thread",5707],"thread-5657":["thread",5657],"thread-5652":["thread",5652],"thread-5646":["thread",5646],"thread-5407":["thread",5407],"thread-5369":["thread",5369],"thread-5328":["thread",5328],"thread-5196":["thread",5196],"thread-5194":["thread",5194],"thread-5114":["thread",5114],"thread-4954":["thread",4954],"thread-4812":["thread",4812],"thread-4779":["thread",4779],"thread-4656":["thread",4656],"thread-4547":["thread",4547],"thread-4521":["thread",4521],"thread-4480":["thread",4480],"thread-4471":["thread",4471],"thread-4466":["thread",4466],"thread-4340":["thread",4340],"thread-4307":["thread",4307],"thread-3989":["thread",3989],"thread-3963":["thread",3963],"thread-3874":["thread",3874],"thread-3821":["thread",3821],"thread-3807":["thread",3807],"thread-3804":["thread",3804],"thread-3652":["thread",3652],"thread-3608":["thread",3608],"thread-3579":["thread",3579],"thread-3481":["thread",3481],"thread-3447":["thread",3447],"thread-3245":["thread",3245],"thread-3154":["thread",3154],"thread-3120":["thread",3120],"thread-3106":["thread",3106],"thread-3048":["thread",3048],"thread-3030":["thread",3030],"thread-3013":["thread",3013],"thread-2909":["thread",2909],"thread-2845":["thread",2845],"thread-2779":["thread",2779],"thread-2629":["thread",2629],"thread-2626":["thread",2626],"thread-861":["thread",861],"thread-830":["thread",830],"thread-753":["thread",753],"thread-721":["thread",721],"thread-677":["thread",677],"thread-588":["thread",588],"thread-522":["thread",522],"thread-473":["thread",473],"thread-100":["thread",100]}, , 1715141781
Run Time: 0.000397
- 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