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 (7218783, 7198484, 7173329, 7153303, 7129963, 7117769, 191067, 176015, 13690, 13686, 13682, 13306, 13299, 13040, 12726, 12643, 12641, 12508, 12456, 12343, 12204, 11959, 11768, 11705, 11590, 11419, 11391, 11349, 11322, 11272, 11249, 11248, 11246, 11077, 10820, 10723, 10656, 10532, 10375, 10274, 10159, 10032, 10013, 9823, 9810, 9619, 9539, 9466, 9462, 9451, 9421, 9320, 9310, 9299, 8922, 8895, 8748, 8727, 8519, 8334, 8276, 8054, 8042, 7922, 7798, 7703, 7656, 7623, 7530, 7528, 7317, 7284, 7275, 7222, 7184, 7063, 6981, 6876, 6716, 6700, 6673, 6592, 6469, 6323, 6195, 6188, 6048, 5867, 5784, 5746, 5720, 5667, 5610, 5582, 5411, 5217, 5070, 5021, 4991, 4431, 4409, 4208, 3951, 3887, 3871, 3742, 3649, 3574, 3325, 3075, 2930, 2890, 2692, 2470, 2429, 2066, 2046, 1595, 1326, 1167, 1109, 884, 637, 292))
Run Time: 0.009728
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 124 | 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: 290, 0, 1716354055, {"thread-7218783":["thread",7218783],"thread-7198484":["thread",7198484],"thread-7173329":["thread",7173329],"thread-7153303":["thread",7153303],"thread-7129963":["thread",7129963],"thread-7117769":["thread",7117769],"thread-191067":["thread",191067],"thread-176015":["thread",176015],"thread-13690":["thread",13690],"thread-13686":["thread",13686],"thread-13682":["thread",13682],"thread-13306":["thread",13306],"thread-13299":["thread",13299],"thread-13040":["thread",13040],"thread-12726":["thread",12726],"thread-12643":["thread",12643],"thread-12641":["thread",12641],"thread-12508":["thread",12508],"thread-12456":["thread",12456],"thread-12343":["thread",12343],"thread-12204":["thread",12204],"thread-11959":["thread",11959],"thread-11768":["thread",11768],"thread-11705":["thread",11705],"thread-11590":["thread",11590],"thread-11419":["thread",11419],"thread-11391":["thread",11391],"thread-11349":["thread",11349],"thread-11322":["thread",11322],"thread-11272":["thread",11272],"thread-11249":["thread",11249],"thread-11248":["thread",11248],"thread-11246":["thread",11246],"thread-11077":["thread",11077],"thread-10820":["thread",10820],"thread-10723":["thread",10723],"thread-10656":["thread",10656],"thread-10532":["thread",10532],"thread-10375":["thread",10375],"thread-10274":["thread",10274],"thread-10159":["thread",10159],"thread-10032":["thread",10032],"thread-10013":["thread",10013],"thread-9823":["thread",9823],"thread-9810":["thread",9810],"thread-9619":["thread",9619],"thread-9539":["thread",9539],"thread-9466":["thread",9466],"thread-9462":["thread",9462],"thread-9451":["thread",9451],"thread-9421":["thread",9421],"thread-9320":["thread",9320],"thread-9310":["thread",9310],"thread-9299":["thread",9299],"thread-8922":["thread",8922],"thread-8895":["thread",8895],"thread-8748":["thread",8748],"thread-8727":["thread",8727],"thread-8519":["thread",8519],"thread-8334":["thread",8334],"thread-8276":["thread",8276],"thread-8054":["thread",8054],"thread-8042":["thread",8042],"thread-7922":["thread",7922],"thread-7798":["thread",7798],"thread-7703":["thread",7703],"thread-7656":["thread",7656],"thread-7623":["thread",7623],"thread-7530":["thread",7530],"thread-7528":["thread",7528],"thread-7317":["thread",7317],"thread-7284":["thread",7284],"thread-7275":["thread",7275],"thread-7222":["thread",7222],"thread-7184":["thread",7184],"thread-7063":["thread",7063],"thread-6981":["thread",6981],"thread-6876":["thread",6876],"thread-6716":["thread",6716],"thread-6700":["thread",6700],"thread-6673":["thread",6673],"thread-6592":["thread",6592],"thread-6469":["thread",6469],"thread-6323":["thread",6323],"thread-6195":["thread",6195],"thread-6188":["thread",6188],"thread-6048":["thread",6048],"thread-5867":["thread",5867],"thread-5784":["thread",5784],"thread-5746":["thread",5746],"thread-5720":["thread",5720],"thread-5667":["thread",5667],"thread-5610":["thread",5610],"thread-5582":["thread",5582],"thread-5411":["thread",5411],"thread-5217":["thread",5217],"thread-5070":["thread",5070],"thread-5021":["thread",5021],"thread-4991":["thread",4991],"thread-4431":["thread",4431],"thread-4409":["thread",4409],"thread-4208":["thread",4208],"thread-3951":["thread",3951],"thread-3887":["thread",3887],"thread-3871":["thread",3871],"thread-3742":["thread",3742],"thread-3649":["thread",3649],"thread-3574":["thread",3574],"thread-3325":["thread",3325],"thread-3075":["thread",3075],"thread-2930":["thread",2930],"thread-2890":["thread",2890],"thread-2692":["thread",2692],"thread-2470":["thread",2470],"thread-2429":["thread",2429],"thread-2066":["thread",2066],"thread-2046":["thread",2046],"thread-1595":["thread",1595],"thread-1326":["thread",1326],"thread-1167":["thread",1167],"thread-1109":["thread",1109],"thread-884":["thread",884],"thread-637":["thread",637],"thread-292":["thread",292]}, NULL, 1716350455
Run Time: 0.000421
- 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