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 (183227, 182757, 182610, 182338, 182092, 181848, 181846, 181336, 181201, 181051, 180950, 180938, 180059, 179876, 179414, 178842, 177304, 176230, 175240, 175173, 175061, 174420, 174196, 173896, 173205, 170453, 169623, 169138, 167942, 167920, 167647, 166840, 166506, 166498, 163529, 162591, 160981, 160778, 158982, 158122, 157926, 157844, 157830, 157472, 157404, 157401, 157213, 156639, 153747, 153022, 152900, 152810, 151688, 149611, 145140, 141314, 136765, 136634, 136393, 130838, 129980, 129742, 128948, 128224, 126143, 120124, 119802, 119779, 114997, 112793, 112622, 111950, 111279, 109803, 109487, 108990, 107411, 104232, 103158, 102307, 98327, 93911, 80814, 77772, 77771, 71420, 64536, 63987, 62415, 48472, 8400))
Run Time: 0.068418
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 91 | 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: 7679, 0, 1715935615, {"thread-183227":["thread",183227],"thread-182757":["thread",182757],"thread-182610":["thread",182610],"thread-182338":["thread",182338],"thread-182092":["thread",182092],"thread-181848":["thread",181848],"thread-181846":["thread",181846],"thread-181336":["thread",181336],"thread-181201":["thread",181201],"thread-181051":["thread",181051],"thread-180950":["thread",180950],"thread-180938":["thread",180938],"thread-180059":["thread",180059],"thread-179876":["thread",179876],"thread-179414":["thread",179414],"thread-178842":["thread",178842],"thread-177304":["thread",177304],"thread-176230":["thread",176230],"thread-175240":["thread",175240],"thread-175173":["thread",175173],"thread-175061":["thread",175061],"thread-174420":["thread",174420],"thread-174196":["thread",174196],"thread-173896":["thread",173896],"thread-173205":["thread",173205],"thread-170453":["thread",170453],"thread-169623":["thread",169623],"thread-169138":["thread",169138],"thread-167942":["thread",167942],"thread-167920":["thread",167920],"thread-167647":["thread",167647],"thread-166840":["thread",166840],"thread-166506":["thread",166506],"thread-166498":["thread",166498],"thread-163529":["thread",163529],"thread-162591":["thread",162591],"thread-160981":["thread",160981],"thread-160778":["thread",160778],"thread-158982":["thread",158982],"thread-158122":["thread",158122],"thread-157926":["thread",157926],"thread-157844":["thread",157844],"thread-157830":["thread",157830],"thread-157472":["thread",157472],"thread-157404":["thread",157404],"thread-157401":["thread",157401],"thread-157213":["thread",157213],"thread-156639":["thread",156639],"thread-153747":["thread",153747],"thread-153022":["thread",153022],"thread-152900":["thread",152900],"thread-152810":["thread",152810],"thread-151688":["thread",151688],"thread-149611":["thread",149611],"thread-145140":["thread",145140],"thread-141314":["thread",141314],"thread-136765":["thread",136765],"thread-136634":["thread",136634],"thread-136393":["thread",136393],"thread-130838":["thread",130838],"thread-129980":["thread",129980],"thread-129742":["thread",129742],"thread-128948":["thread",128948],"thread-128224":["thread",128224],"thread-126143":["thread",126143],"thread-120124":["thread",120124],"thread-119802":["thread",119802],"thread-119779":["thread",119779],"thread-114997":["thread",114997],"thread-112793":["thread",112793],"thread-112622":["thread",112622],"thread-111950":["thread",111950],"thread-111279":["thread",111279],"thread-109803":["thread",109803],"thread-109487":["thread",109487],"thread-108990":["thread",108990],"thread-107411":["thread",107411],"thread-104232":["thread",104232],"thread-103158":["thread",103158],"thread-102307":["thread",102307],"thread-98327":["thread",98327],"thread-93911":["thread",93911],"thread-80814":["thread",80814],"thread-77772":["thread",77772],"thread-77771":["thread",77771],"thread-71420":["thread",71420],"thread-64536":["thread",64536],"thread-63987":["thread",63987],"thread-62415":["thread",62415],"thread-48472":["thread",48472],"thread-8400":["thread",8400]}, , 1715932015
Run Time: 0.000766
- 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