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 (7216686, 7213645, 7209273, 7200207, 7198543, 7198412, 7171660, 7151998, 7151839, 7143939, 7142520, 7142101, 7141282, 7139896, 7137028, 7133379, 7071360, 7013490, 7002856, 6990387, 6981734, 6978679, 6509887, 220183, 185026, 179801, 13828, 13827, 13800, 13786, 13698, 13384, 13349, 13285, 13108, 13102, 12907, 12706, 12654, 12596, 12589, 12527, 12474, 12045, 12007, 11997, 11852, 11590, 11521, 11423, 11295, 11268, 11252, 11177, 10932, 10921, 10793, 10753, 10489, 10333, 10135, 10051, 10044, 10029, 10017, 9775, 9620, 9582, 9429, 9426, 9351, 9338, 9329, 9301, 9243, 9222, 9074, 9043, 8907, 8599, 8589, 8580, 8279, 8258, 8043, 7976, 7877, 7875, 7829, 7824, 7778, 7712, 7439, 7387, 7357, 7348, 7322, 7303, 7162, 7078, 7020, 6934, 6763, 6721, 6446, 6399, 6398, 6251, 6200, 6163, 6069, 5956, 5820, 5753, 5303, 5226, 5177, 5172, 5066, 5024, 5012, 5010, 4966, 4959, 4880, 4849, 4762, 4666, 4515, 4483, 4441, 4411, 4393, 4379, 4301, 4192, 4168, 4134, 4050, 4049, 4014, 3995, 3987, 3943, 3877, 3850, 3799, 3761, 3710, 3614, 3546, 3219, 3134, 2997, 2952, 2720, 2716, 2579, 2573, 2484, 2278, 1919, 1818, 1776, 1716, 1679, 1677, 1606, 1544, 1485, 1457, 1158, 1144, 1097, 1060, 1012, 871, 770, 691, 654, 549, 539, 534, 511, 379, 368))
Run Time: 0.008706
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 186 | 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: 397, 0, 1715589821, {"thread-7216686":["thread",7216686],"thread-7213645":["thread",7213645],"thread-7209273":["thread",7209273],"thread-7200207":["thread",7200207],"thread-7198543":["thread",7198543],"thread-7198412":["thread",7198412],"thread-7171660":["thread",7171660],"thread-7151998":["thread",7151998],"thread-7151839":["thread",7151839],"thread-7143939":["thread",7143939],"thread-7142520":["thread",7142520],"thread-7142101":["thread",7142101],"thread-7141282":["thread",7141282],"thread-7139896":["thread",7139896],"thread-7137028":["thread",7137028],"thread-7133379":["thread",7133379],"thread-7071360":["thread",7071360],"xfmg_media-3495":["xfmg_media",3495],"thread-7013490":["thread",7013490],"thread-7002856":["thread",7002856],"thread-6990387":["thread",6990387],"thread-6981734":["thread",6981734],"thread-6978679":["thread",6978679],"thread-6509887":["thread",6509887],"thread-220183":["thread",220183],"thread-185026":["thread",185026],"thread-179801":["thread",179801],"thread-13828":["thread",13828],"thread-13827":["thread",13827],"thread-13800":["thread",13800],"thread-13786":["thread",13786],"thread-13698":["thread",13698],"thread-13384":["thread",13384],"thread-13349":["thread",13349],"thread-13285":["thread",13285],"thread-13108":["thread",13108],"thread-13102":["thread",13102],"thread-12907":["thread",12907],"thread-12706":["thread",12706],"thread-12654":["thread",12654],"thread-12596":["thread",12596],"thread-12589":["thread",12589],"thread-12527":["thread",12527],"thread-12474":["thread",12474],"thread-12045":["thread",12045],"thread-12007":["thread",12007],"thread-11997":["thread",11997],"thread-11852":["thread",11852],"thread-11590":["thread",11590],"thread-11521":["thread",11521],"thread-11423":["thread",11423],"thread-11295":["thread",11295],"thread-11268":["thread",11268],"thread-11252":["thread",11252],"thread-11177":["thread",11177],"thread-10932":["thread",10932],"thread-10921":["thread",10921],"thread-10793":["thread",10793],"thread-10753":["thread",10753],"thread-10489":["thread",10489],"thread-10333":["thread",10333],"thread-10135":["thread",10135],"thread-10051":["thread",10051],"thread-10044":["thread",10044],"thread-10029":["thread",10029],"thread-10017":["thread",10017],"thread-9775":["thread",9775],"thread-9620":["thread",9620],"thread-9582":["thread",9582],"thread-9429":["thread",9429],"thread-9426":["thread",9426],"thread-9351":["thread",9351],"thread-9338":["thread",9338],"thread-9329":["thread",9329],"thread-9301":["thread",9301],"thread-9243":["thread",9243],"thread-9222":["thread",9222],"thread-9074":["thread",9074],"thread-9043":["thread",9043],"thread-8907":["thread",8907],"thread-8599":["thread",8599],"thread-8589":["thread",8589],"thread-8580":["thread",8580],"thread-8279":["thread",8279],"thread-8258":["thread",8258],"thread-8043":["thread",8043],"thread-7976":["thread",7976],"thread-7877":["thread",7877],"thread-7875":["thread",7875],"thread-7829":["thread",7829],"thread-7824":["thread",7824],"thread-7778":["thread",7778],"thread-7712":["thread",7712],"thread-7439":["thread",7439],"thread-7387":["thread",7387],"thread-7357":["thread",7357],"thread-7348":["thread",7348],"thread-7322":["thread",7322],"thread-7303":["thread",7303],"thread-7162":["thread",7162],"thread-7078":["thread",7078],"thread-7020":["thread",7020],"thread-6934":["thread",6934],"thread-6763":["thread",6763],"thread-6721":["thread",6721],"thread-6446":["thread",6446],"thread-6399":["thread",6399],"thread-6398":["thread",6398],"thread-6251":["thread",6251],"thread-6200":["thread",6200],"thread-6163":["thread",6163],"thread-6069":["thread",6069],"thread-5956":["thread",5956],"thread-5820":["thread",5820],"thread-5753":["thread",5753],"thread-5303":["thread",5303],"thread-5226":["thread",5226],"thread-5177":["thread",5177],"thread-5172":["thread",5172],"thread-5066":["thread",5066],"thread-5024":["thread",5024],"thread-5012":["thread",5012],"thread-5010":["thread",5010],"thread-4966":["thread",4966],"thread-4959":["thread",4959],"thread-4880":["thread",4880],"thread-4849":["thread",4849],"thread-4762":["thread",4762],"thread-4666":["thread",4666],"thread-4515":["thread",4515],"thread-4483":["thread",4483],"thread-4441":["thread",4441],"thread-4411":["thread",4411],"thread-4393":["thread",4393],"thread-4379":["thread",4379],"thread-4301":["thread",4301],"thread-4192":["thread",4192],"thread-4168":["thread",4168],"thread-4134":["thread",4134],"thread-4050":["thread",4050],"thread-4049":["thread",4049],"thread-4014":["thread",4014],"thread-3995":["thread",3995],"thread-3987":["thread",3987],"thread-3943":["thread",3943],"thread-3877":["thread",3877],"thread-3850":["thread",3850],"thread-3799":["thread",3799],"thread-3761":["thread",3761],"thread-3710":["thread",3710],"thread-3614":["thread",3614],"thread-3546":["thread",3546],"thread-3219":["thread",3219],"thread-3134":["thread",3134],"thread-2997":["thread",2997],"thread-2952":["thread",2952],"thread-2720":["thread",2720],"thread-2716":["thread",2716],"thread-2579":["thread",2579],"thread-2573":["thread",2573],"thread-2484":["thread",2484],"thread-2278":["thread",2278],"thread-1919":["thread",1919],"thread-1818":["thread",1818],"thread-1776":["thread",1776],"thread-1716":["thread",1716],"thread-1679":["thread",1679],"thread-1677":["thread",1677],"thread-1606":["thread",1606],"thread-1544":["thread",1544],"thread-1485":["thread",1485],"thread-1457":["thread",1457],"thread-1158":["thread",1158],"thread-1144":["thread",1144],"thread-1097":["thread",1097],"thread-1060":["thread",1060],"thread-1012":["thread",1012],"thread-871":["thread",871],"thread-770":["thread",770],"thread-691":["thread",691],"thread-654":["thread",654],"thread-549":["thread",549],"thread-539":["thread",539],"thread-534":["thread",534],"thread-511":["thread",511],"thread-379":["thread",379],"thread-368":["thread",368]}, NULL, 1715586221
Run Time: 0.000721
- 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