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 (180892, 180776, 179546, 179542, 179540, 178422, 178046, 178045, 177752, 177351, 177105, 168801, 168513, 163889, 161460, 160373, 160365, 157476, 157468, 157150, 155602, 151964, 149101, 145605, 140466, 139998, 139885, 139021, 137004, 134302, 130791, 130217, 129547, 129211, 128329, 126982, 125736, 121278, 117581, 113591, 112910, 112347, 112345, 112223, 112091, 112050, 111610, 111184, 111181, 110942, 110766, 110601, 110590, 110503, 110461, 110453, 110289, 110169, 107313, 106855, 106766, 106440, 103967, 103806, 103337, 101522, 101063, 98702, 98008, 95876, 94979, 94873, 93220, 93137, 83315, 75388, 74822, 73101, 72219, 70313, 70184, 70182, 70180, 69096, 68958, 68246, 67450, 67444, 65437, 63290, 63286, 58325, 56220, 56035, 48806, 48611, 48524, 41091, 28144, 24992, 24116, 24026, 22481, 22480, 21318, 20335, 17163, 12442, 12256, 12168, 8670, 7866, 3360, 2862, 2818, 2814, 2631, 2444, 2021, 2014, 2013, 1826, 1677, 1589, 1583, 1394, 1347))
Run Time: 0.073422
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 127 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.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: 460, 0, 1714406108, {"thread-180892":["thread",180892],"thread-180776":["thread",180776],"thread-179546":["thread",179546],"thread-179542":["thread",179542],"thread-179540":["thread",179540],"tl_group-354":["tl_group",354],"thread-178422":["thread",178422],"thread-178046":["thread",178046],"thread-178045":["thread",178045],"thread-177752":["thread",177752],"thread-177351":["thread",177351],"thread-177105":["thread",177105],"ams_article-4836":["ams_article",4836],"thread-168801":["thread",168801],"thread-168513":["thread",168513],"thread-163889":["thread",163889],"thread-161460":["thread",161460],"thread-160373":["thread",160373],"thread-157476":["thread",157476],"thread-157468":["thread",157468],"thread-157150":["thread",157150],"thread-155602":["thread",155602],"thread-151964":["thread",151964],"thread-149101":["thread",149101],"thread-145605":["thread",145605],"thread-140466":["thread",140466],"thread-139998":["thread",139998],"thread-139885":["thread",139885],"thread-139021":["thread",139021],"thread-137004":["thread",137004],"thread-134302":["thread",134302],"thread-130791":["thread",130791],"thread-130217":["thread",130217],"thread-129547":["thread",129547],"thread-129211":["thread",129211],"thread-128329":["thread",128329],"thread-126982":["thread",126982],"thread-125736":["thread",125736],"thread-121278":["thread",121278],"thread-117581":["thread",117581],"thread-113591":["thread",113591],"thread-112910":["thread",112910],"thread-112347":["thread",112347],"thread-112345":["thread",112345],"thread-112223":["thread",112223],"thread-112091":["thread",112091],"thread-112050":["thread",112050],"thread-111610":["thread",111610],"thread-111184":["thread",111184],"thread-111181":["thread",111181],"thread-110942":["thread",110942],"thread-110766":["thread",110766],"thread-110601":["thread",110601],"thread-110590":["thread",110590],"thread-110503":["thread",110503],"thread-110461":["thread",110461],"thread-110453":["thread",110453],"thread-110289":["thread",110289],"thread-110169":["thread",110169],"thread-107313":["thread",107313],"thread-106855":["thread",106855],"thread-106766":["thread",106766],"thread-106440":["thread",106440],"thread-103967":["thread",103967],"thread-103806":["thread",103806],"thread-103337":["thread",103337],"thread-101522":["thread",101522],"thread-101063":["thread",101063],"thread-98702":["thread",98702],"thread-98008":["thread",98008],"thread-95876":["thread",95876],"thread-94979":["thread",94979],"thread-94873":["thread",94873],"thread-93220":["thread",93220],"thread-93137":["thread",93137],"thread-83315":["thread",83315],"thread-75388":["thread",75388],"thread-74822":["thread",74822],"thread-73101":["thread",73101],"thread-72219":["thread",72219],"thread-70313":["thread",70313],"thread-70184":["thread",70184],"thread-70182":["thread",70182],"thread-70180":["thread",70180],"thread-69096":["thread",69096],"thread-68958":["thread",68958],"thread-68246":["thread",68246],"thread-67450":["thread",67450],"thread-67444":["thread",67444],"thread-65437":["thread",65437],"thread-63290":["thread",63290],"thread-63286":["thread",63286],"thread-58325":["thread",58325],"thread-56220":["thread",56220],"thread-56035":["thread",56035],"thread-48806":["thread",48806],"thread-48611":["thread",48611],"thread-48524":["thread",48524],"thread-41091":["thread",41091],"thread-28144":["thread",28144],"thread-24992":["thread",24992],"thread-24116":["thread",24116],"thread-24026":["thread",24026],"thread-22481":["thread",22481],"thread-22480":["thread",22480],"thread-21318":["thread",21318],"thread-20335":["thread",20335],"thread-17163":["thread",17163],"thread-12442":["thread",12442],"thread-12256":["thread",12256],"thread-12168":["thread",12168],"thread-8670":["thread",8670],"thread-7866":["thread",7866],"thread-3360":["thread",3360],"thread-2862":["thread",2862],"thread-2818":["thread",2818],"thread-2814":["thread",2814],"thread-2631":["thread",2631],"thread-2444":["thread",2444],"thread-2021":["thread",2021],"thread-2014":["thread",2014],"thread-2013":["thread",2013],"thread-1826":["thread",1826],"thread-1677":["thread",1677],"thread-1589":["thread",1589],"thread-1583":["thread",1583],"thread-1394":["thread",1394],"thread-1347":["thread",1347]}, , 1714402508
Run Time: 0.000598
- 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