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 (7181594, 7181141, 7177398, 7145638, 7089035, 6868184, 6822561, 6787583, 6630009, 6410888, 6322458, 6281142, 90914, 13827, 13751, 13750, 13736, 13661, 13606, 13605, 13574, 13573, 13503, 13491, 13485, 13484, 13467, 13438, 13415, 13400, 13399, 13344, 13325, 13292, 13208, 13195, 13185, 13124, 13110, 13107, 13096, 13088, 13087, 13077, 13066, 12997, 12983, 12860, 12834, 12826, 12777, 12726, 12722, 12643, 12611, 12609, 12582, 12474, 12450, 12447, 12446, 12419, 12389, 12388, 12372, 12368, 12357, 12332, 12326, 12299, 12255, 12213, 12006, 12004, 11981, 11947, 11886, 11878, 11867, 11855, 11829, 11776, 11768, 11758, 11742, 11724, 11718, 11655, 11631, 11616, 11615, 11608, 11605, 11594, 11593, 11591, 11586, 11421, 11347, 11345, 11336, 11332, 11318, 11298, 11185, 11152, 11135, 11132, 11068, 11051, 11022, 11017, 10985, 10970, 10907, 10900, 10897, 10861, 10849, 10796, 10784, 10778, 10773, 10760, 10686, 10677, 10601, 10597, 10565, 10554, 10521, 10502, 10478, 10427, 10414, 10379, 10348, 10290, 10267, 10256, 10245, 10184, 10110, 10104, 10087, 10077, 10054, 10037, 10033, 10016, 9981, 9970, 9964, 9963, 9961, 9943, 9930, 9925, 9855, 9835, 9785, 9767, 9766, 9742, 9726, 9707, 9677, 9610, 9552, 9514, 9458, 9404, 9337, 9314, 9287, 9249, 9223, 9191, 9169, 9162, 9110, 9082, 9071, 8956, 8936, 8924, 8909, 8898, 8869, 8865, 8817, 8802, 8796, 8789, 8788, 8759, 8754, 8753, 8734, 8680))
Run Time: 0.009727
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | 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: 83, 0, 1714806738, {"thread-7181594":["thread",7181594],"thread-7181141":["thread",7181141],"thread-7177398":["thread",7177398],"thread-7145638":["thread",7145638],"thread-7089035":["thread",7089035],"thread-6868184":["thread",6868184],"thread-6822561":["thread",6822561],"thread-6787583":["thread",6787583],"thread-6630009":["thread",6630009],"thread-6410888":["thread",6410888],"thread-6322458":["thread",6322458],"thread-6281142":["thread",6281142],"thread-90914":["thread",90914],"thread-13827":["thread",13827],"thread-13751":["thread",13751],"thread-13750":["thread",13750],"thread-13736":["thread",13736],"thread-13661":["thread",13661],"thread-13606":["thread",13606],"thread-13605":["thread",13605],"thread-13574":["thread",13574],"thread-13573":["thread",13573],"thread-13503":["thread",13503],"thread-13491":["thread",13491],"thread-13485":["thread",13485],"thread-13484":["thread",13484],"thread-13467":["thread",13467],"thread-13438":["thread",13438],"thread-13415":["thread",13415],"thread-13400":["thread",13400],"thread-13399":["thread",13399],"thread-13344":["thread",13344],"thread-13325":["thread",13325],"thread-13292":["thread",13292],"thread-13208":["thread",13208],"thread-13195":["thread",13195],"thread-13185":["thread",13185],"thread-13124":["thread",13124],"thread-13110":["thread",13110],"thread-13107":["thread",13107],"thread-13096":["thread",13096],"thread-13088":["thread",13088],"thread-13087":["thread",13087],"thread-13077":["thread",13077],"thread-13066":["thread",13066],"thread-12997":["thread",12997],"thread-12983":["thread",12983],"thread-12860":["thread",12860],"thread-12834":["thread",12834],"thread-12826":["thread",12826],"thread-12777":["thread",12777],"thread-12726":["thread",12726],"thread-12722":["thread",12722],"thread-12643":["thread",12643],"thread-12611":["thread",12611],"thread-12609":["thread",12609],"thread-12582":["thread",12582],"thread-12474":["thread",12474],"thread-12450":["thread",12450],"thread-12447":["thread",12447],"thread-12446":["thread",12446],"thread-12419":["thread",12419],"thread-12389":["thread",12389],"thread-12388":["thread",12388],"thread-12372":["thread",12372],"thread-12368":["thread",12368],"thread-12357":["thread",12357],"thread-12332":["thread",12332],"thread-12326":["thread",12326],"thread-12299":["thread",12299],"thread-12255":["thread",12255],"thread-12213":["thread",12213],"thread-12006":["thread",12006],"thread-12004":["thread",12004],"thread-11981":["thread",11981],"thread-11947":["thread",11947],"thread-11886":["thread",11886],"thread-11878":["thread",11878],"thread-11867":["thread",11867],"thread-11855":["thread",11855],"thread-11829":["thread",11829],"thread-11776":["thread",11776],"thread-11768":["thread",11768],"thread-11758":["thread",11758],"thread-11742":["thread",11742],"thread-11724":["thread",11724],"thread-11718":["thread",11718],"thread-11655":["thread",11655],"thread-11631":["thread",11631],"thread-11616":["thread",11616],"thread-11615":["thread",11615],"thread-11608":["thread",11608],"thread-11605":["thread",11605],"thread-11594":["thread",11594],"thread-11593":["thread",11593],"thread-11591":["thread",11591],"thread-11586":["thread",11586],"thread-11421":["thread",11421],"thread-11347":["thread",11347],"thread-11345":["thread",11345],"thread-11336":["thread",11336],"thread-11332":["thread",11332],"thread-11318":["thread",11318],"thread-11298":["thread",11298],"thread-11185":["thread",11185],"thread-11152":["thread",11152],"thread-11135":["thread",11135],"thread-11132":["thread",11132],"thread-11068":["thread",11068],"thread-11051":["thread",11051],"thread-11022":["thread",11022],"thread-11017":["thread",11017],"thread-10985":["thread",10985],"thread-10970":["thread",10970],"thread-10907":["thread",10907],"thread-10900":["thread",10900],"thread-10897":["thread",10897],"thread-10861":["thread",10861],"thread-10849":["thread",10849],"thread-10796":["thread",10796],"thread-10784":["thread",10784],"thread-10778":["thread",10778],"thread-10773":["thread",10773],"thread-10760":["thread",10760],"thread-10686":["thread",10686],"thread-10677":["thread",10677],"thread-10601":["thread",10601],"thread-10597":["thread",10597],"thread-10565":["thread",10565],"thread-10554":["thread",10554],"thread-10521":["thread",10521],"thread-10502":["thread",10502],"thread-10478":["thread",10478],"thread-10427":["thread",10427],"thread-10414":["thread",10414],"thread-10379":["thread",10379],"thread-10348":["thread",10348],"thread-10290":["thread",10290],"thread-10267":["thread",10267],"thread-10256":["thread",10256],"thread-10245":["thread",10245],"thread-10184":["thread",10184],"thread-10110":["thread",10110],"thread-10104":["thread",10104],"thread-10087":["thread",10087],"thread-10077":["thread",10077],"thread-10054":["thread",10054],"thread-10037":["thread",10037],"thread-10033":["thread",10033],"thread-10016":["thread",10016],"thread-9981":["thread",9981],"thread-9970":["thread",9970],"thread-9964":["thread",9964],"thread-9963":["thread",9963],"thread-9961":["thread",9961],"thread-9943":["thread",9943],"thread-9930":["thread",9930],"thread-9925":["thread",9925],"thread-9855":["thread",9855],"thread-9835":["thread",9835],"thread-9785":["thread",9785],"thread-9767":["thread",9767],"thread-9766":["thread",9766],"thread-9742":["thread",9742],"thread-9726":["thread",9726],"thread-9707":["thread",9707],"thread-9677":["thread",9677],"thread-9610":["thread",9610],"thread-9552":["thread",9552],"thread-9514":["thread",9514],"thread-9458":["thread",9458],"thread-9404":["thread",9404],"thread-9337":["thread",9337],"thread-9314":["thread",9314],"thread-9287":["thread",9287],"thread-9249":["thread",9249],"thread-9223":["thread",9223],"thread-9191":["thread",9191],"thread-9169":["thread",9169],"thread-9162":["thread",9162],"thread-9110":["thread",9110],"thread-9082":["thread",9082],"thread-9071":["thread",9071],"thread-8956":["thread",8956],"thread-8936":["thread",8936],"thread-8924":["thread",8924],"thread-8909":["thread",8909],"thread-8898":["thread",8898],"thread-8869":["thread",8869],"thread-8865":["thread",8865],"thread-8817":["thread",8817],"thread-8802":["thread",8802],"thread-8796":["thread",8796],"thread-8789":["thread",8789],"thread-8788":["thread",8788],"thread-8759":["thread",8759],"thread-8754":["thread",8754],"thread-8753":["thread",8753],"thread-8734":["thread",8734],"thread-8680":["thread",8680]}, NULL, 1714803138
Run Time: 0.000670
- 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