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 (45086, 45078, 45072, 44928, 44813, 43589, 43417, 43410, 43184, 42945, 42927, 42918, 42851, 42781, 42725, 42610, 42603, 42328, 41969, 41807, 41408, 41370, 41151, 40702, 40250, 40210, 40135, 39728, 39581, 39568, 38960, 38590, 38587, 38553, 38459, 38232, 37483, 37298, 37287, 36908, 36590, 36553, 36470, 36020, 35894, 35812, 35053, 34908, 34710, 34629, 34359, 34196, 34059, 33800, 33553, 33470, 33418, 33416, 32876, 32800, 32423, 32395, 32282, 32268, 32254, 32110, 32108, 31586, 31463, 31011, 30820, 30475, 30366, 30236, 29663, 29655, 29605, 29349, 29211, 29138, 29092, 29007, 28620, 28557, 28504, 28497, 27942, 27858, 27608, 27597, 27567, 27394, 27382, 27339, 27276, 27144, 26589, 26522, 26488, 25746, 25639, 25546, 24805, 24781, 24464, 24320, 24317, 23685, 23589, 22754, 22745, 22448, 22303, 22196, 22053, 21254, 20798, 20364, 20332, 20131, 19501, 19410, 19220, 19180, 18609, 18565, 18501, 32794, 18411, 17702, 17548, 16857, 16725, 16696, 16355, 16180, 16022, 15944, 15612, 14897, 14671, 12731, 12725, 12549, 10331, 10050, 9949, 8065, 7952, 7571, 6985, 6653, 5416, 5198, 5187, 5074, 4801, 4555, 3854, 3838, 3685, 3513, 3006, 2601, 2411, 2402, 1707, 1602, 1567, 1359, 1219, 1204, 769, 721, 508, 476, 56, 44, 43))
Run Time: 0.055998
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 179 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,squattheplanet.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 2866
- 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 2483
- 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: 183, 0, 1714504437, {"thread-45086":["thread",45086],"thread-45078":["thread",45078],"thread-45072":["thread",45072],"thread-44928":["thread",44928],"thread-44813":["thread",44813],"thread-43589":["thread",43589],"thread-43410":["thread",43410],"thread-42945":["thread",42945],"thread-42927":["thread",42927],"thread-42918":["thread",42918],"thread-42781":["thread",42781],"thread-42725":["thread",42725],"thread-42610":["thread",42610],"thread-42603":["thread",42603],"thread-42328":["thread",42328],"thread-41969":["thread",41969],"thread-41807":["thread",41807],"thread-41408":["thread",41408],"thread-41370":["thread",41370],"thread-41151":["thread",41151],"thread-40250":["thread",40250],"thread-40210":["thread",40210],"thread-40135":["thread",40135],"thread-39728":["thread",39728],"thread-39581":["thread",39581],"thread-38960":["thread",38960],"thread-38590":["thread",38590],"thread-38587":["thread",38587],"thread-38553":["thread",38553],"thread-38459":["thread",38459],"thread-38232":["thread",38232],"thread-37483":["thread",37483],"thread-37298":["thread",37298],"thread-37287":["thread",37287],"thread-36908":["thread",36908],"thread-36590":["thread",36590],"thread-36553":["thread",36553],"thread-36470":["thread",36470],"thread-36020":["thread",36020],"thread-35894":["thread",35894],"thread-35812":["thread",35812],"thread-35053":["thread",35053],"thread-34908":["thread",34908],"thread-34710":["thread",34710],"thread-34629":["thread",34629],"thread-34359":["thread",34359],"thread-34196":["thread",34196],"thread-34059":["thread",34059],"thread-33800":["thread",33800],"thread-33553":["thread",33553],"thread-33470":["thread",33470],"thread-33418":["thread",33418],"thread-33416":["thread",33416],"thread-32876":["thread",32876],"thread-32800":["thread",32800],"thread-32395":["thread",32395],"thread-32282":["thread",32282],"thread-32268":["thread",32268],"thread-32254":["thread",32254],"thread-32110":["thread",32110],"thread-32108":["thread",32108],"thread-31586":["thread",31586],"thread-31463":["thread",31463],"thread-31011":["thread",31011],"thread-30820":["thread",30820],"thread-30475":["thread",30475],"thread-30366":["thread",30366],"thread-30236":["thread",30236],"thread-29655":["thread",29655],"thread-29605":["thread",29605],"thread-29349":["thread",29349],"thread-29211":["thread",29211],"thread-29138":["thread",29138],"thread-29092":["thread",29092],"thread-29007":["thread",29007],"thread-28620":["thread",28620],"thread-28557":["thread",28557],"thread-28504":["thread",28504],"thread-28497":["thread",28497],"thread-27942":["thread",27942],"thread-27858":["thread",27858],"thread-27608":["thread",27608],"thread-27597":["thread",27597],"thread-27567":["thread",27567],"thread-27394":["thread",27394],"thread-27382":["thread",27382],"thread-27339":["thread",27339],"thread-27276":["thread",27276],"thread-27144":["thread",27144],"thread-26589":["thread",26589],"thread-26522":["thread",26522],"thread-26488":["thread",26488],"thread-25746":["thread",25746],"thread-25639":["thread",25639],"thread-25546":["thread",25546],"thread-24805":["thread",24805],"thread-24781":["thread",24781],"thread-24320":["thread",24320],"thread-24317":["thread",24317],"thread-23685":["thread",23685],"thread-23589":["thread",23589],"thread-22754":["thread",22754],"thread-22745":["thread",22745],"thread-22448":["thread",22448],"thread-22303":["thread",22303],"thread-22196":["thread",22196],"thread-22053":["thread",22053],"thread-21254":["thread",21254],"thread-20798":["thread",20798],"thread-20364":["thread",20364],"thread-20332":["thread",20332],"thread-20131":["thread",20131],"thread-19501":["thread",19501],"thread-19410":["thread",19410],"thread-19220":["thread",19220],"thread-19180":["thread",19180],"thread-18609":["thread",18609],"thread-18565":["thread",18565],"thread-18501":["thread",18501],"thread-32794":["thread",32794],"thread-18411":["thread",18411],"thread-17702":["thread",17702],"thread-17548":["thread",17548],"thread-16857":["thread",16857],"thread-16725":["thread",16725],"thread-16696":["thread",16696],"thread-16355":["thread",16355],"thread-16022":["thread",16022],"thread-15944":["thread",15944],"thread-15612":["thread",15612],"thread-14897":["thread",14897],"thread-14671":["thread",14671],"thread-12731":["thread",12731],"thread-12725":["thread",12725],"thread-12549":["thread",12549],"thread-10331":["thread",10331],"thread-10050":["thread",10050],"thread-9949":["thread",9949],"thread-8065":["thread",8065],"thread-7952":["thread",7952],"thread-7571":["thread",7571],"thread-6985":["thread",6985],"thread-6653":["thread",6653],"thread-5416":["thread",5416],"thread-5198":["thread",5198],"thread-5187":["thread",5187],"thread-5074":["thread",5074],"thread-4801":["thread",4801],"thread-4555":["thread",4555],"thread-3854":["thread",3854],"thread-3838":["thread",3838],"thread-3685":["thread",3685],"thread-3513":["thread",3513],"thread-3006":["thread",3006],"thread-2601":["thread",2601],"thread-2411":["thread",2411],"thread-2402":["thread",2402],"thread-1707":["thread",1707],"thread-1602":["thread",1602],"thread-1567":["thread",1567],"thread-1359":["thread",1359],"thread-1219":["thread",1219],"thread-1204":["thread",1204],"thread-769":["thread",769],"thread-721":["thread",721],"thread-508":["thread",508],"thread-476":["thread",476],"thread-56":["thread",56],"thread-44":["thread",44],"thread-43":["thread",43]}, NULL, 1714500837
Run Time: 0.000606
- 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 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 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20