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 (178287, 173447, 160254, 152799, 148272, 147430, 147207, 147184, 146933, 143965, 135100, 132346, 131702, 131604, 131542, 131401, 131377, 131263, 131017, 130735, 130638, 130530, 129497, 128979, 128908, 127837, 123731, 123134, 122759, 119808, 115526, 115040, 113978, 113617, 113616, 113615, 112798, 112125, 112101, 112014, 111072, 110674, 110387, 110280, 108537, 108165, 108164, 107204, 106935, 106848, 106783, 106764, 106674, 106500, 106405, 106380, 106252, 105737, 105469, 104523, 104197, 104025, 98706, 98421, 98419, 98198, 97837, 97268, 96781, 95429, 95310, 95072, 94888, 94185, 94184, 93335, 93207, 93178, 92733, 92466, 92264, 92224, 91802, 91015, 90732, 90232, 89795, 89341, 88662, 88544, 88003, 87896, 87890, 87883, 87806, 87002, 85778, 78713, 74508, 61949, 61099, 47284, 42861, 42857, 42772, 41512, 40841, 35821, 32106, 30881, 29223, 28487, 27218, 27204, 27014, 25963, 24271, 24072, 23174, 23173, 23072, 22832, 22675, 21818, 21436, 21342, 21298, 20769, 20276, 19793, 19215, 18602, 18115, 17883, 17821, 17563, 17491, 17071, 16976, 16777, 16774, 15322, 13257, 12862, 12236, 12103, 12046, 11215, 10252, 10225, 9955, 9843, 9810, 9708, 8881, 8128, 7955, 7846, 6973, 5378, 3687, 3663, 3105, 3068, 1160))
Run Time: 0.099691
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 165 | 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: 476, 0, 1714912045, {"thread-178287":["thread",178287],"thread-173447":["thread",173447],"thread-160254":["thread",160254],"thread-152799":["thread",152799],"thread-148272":["thread",148272],"thread-147430":["thread",147430],"thread-147207":["thread",147207],"thread-147184":["thread",147184],"thread-146933":["thread",146933],"thread-143965":["thread",143965],"thread-135100":["thread",135100],"thread-132346":["thread",132346],"thread-131702":["thread",131702],"thread-131604":["thread",131604],"thread-131542":["thread",131542],"thread-131401":["thread",131401],"thread-131377":["thread",131377],"thread-131263":["thread",131263],"thread-131017":["thread",131017],"thread-130735":["thread",130735],"thread-130638":["thread",130638],"thread-130530":["thread",130530],"thread-129497":["thread",129497],"thread-128979":["thread",128979],"thread-128908":["thread",128908],"thread-127837":["thread",127837],"thread-123731":["thread",123731],"thread-123134":["thread",123134],"thread-122759":["thread",122759],"thread-119808":["thread",119808],"thread-115526":["thread",115526],"thread-115040":["thread",115040],"thread-113978":["thread",113978],"thread-113617":["thread",113617],"thread-113616":["thread",113616],"thread-113615":["thread",113615],"thread-112798":["thread",112798],"thread-112125":["thread",112125],"thread-112101":["thread",112101],"thread-112014":["thread",112014],"thread-111072":["thread",111072],"thread-110674":["thread",110674],"thread-110387":["thread",110387],"thread-110280":["thread",110280],"thread-108537":["thread",108537],"thread-108165":["thread",108165],"thread-108164":["thread",108164],"thread-107204":["thread",107204],"thread-106935":["thread",106935],"thread-106848":["thread",106848],"thread-106783":["thread",106783],"thread-106764":["thread",106764],"thread-106674":["thread",106674],"thread-106500":["thread",106500],"thread-106405":["thread",106405],"thread-106380":["thread",106380],"thread-106252":["thread",106252],"thread-105737":["thread",105737],"thread-105469":["thread",105469],"thread-104523":["thread",104523],"thread-104197":["thread",104197],"thread-104025":["thread",104025],"thread-98706":["thread",98706],"thread-98421":["thread",98421],"thread-98419":["thread",98419],"thread-98198":["thread",98198],"thread-97837":["thread",97837],"thread-97268":["thread",97268],"thread-96781":["thread",96781],"thread-95429":["thread",95429],"thread-95310":["thread",95310],"thread-95072":["thread",95072],"thread-94888":["thread",94888],"thread-94185":["thread",94185],"thread-94184":["thread",94184],"thread-93335":["thread",93335],"thread-93207":["thread",93207],"thread-93178":["thread",93178],"thread-92733":["thread",92733],"thread-92466":["thread",92466],"thread-92264":["thread",92264],"thread-92224":["thread",92224],"thread-91802":["thread",91802],"thread-91015":["thread",91015],"thread-90732":["thread",90732],"thread-90232":["thread",90232],"thread-89795":["thread",89795],"thread-89341":["thread",89341],"thread-88662":["thread",88662],"thread-88544":["thread",88544],"thread-88003":["thread",88003],"thread-87896":["thread",87896],"thread-87890":["thread",87890],"thread-87883":["thread",87883],"thread-87806":["thread",87806],"thread-87002":["thread",87002],"thread-85778":["thread",85778],"thread-78713":["thread",78713],"thread-74508":["thread",74508],"thread-61949":["thread",61949],"thread-61099":["thread",61099],"thread-47284":["thread",47284],"thread-42861":["thread",42861],"thread-42857":["thread",42857],"thread-42772":["thread",42772],"thread-41512":["thread",41512],"thread-40841":["thread",40841],"thread-35821":["thread",35821],"thread-32106":["thread",32106],"thread-30881":["thread",30881],"thread-29223":["thread",29223],"thread-28487":["thread",28487],"thread-27218":["thread",27218],"thread-27204":["thread",27204],"thread-27014":["thread",27014],"thread-25963":["thread",25963],"thread-24271":["thread",24271],"thread-24072":["thread",24072],"thread-23174":["thread",23174],"thread-23173":["thread",23173],"thread-23072":["thread",23072],"thread-22832":["thread",22832],"thread-22675":["thread",22675],"thread-21818":["thread",21818],"thread-21436":["thread",21436],"thread-21342":["thread",21342],"thread-21298":["thread",21298],"thread-20769":["thread",20769],"thread-20276":["thread",20276],"thread-19793":["thread",19793],"thread-19215":["thread",19215],"thread-18602":["thread",18602],"thread-18115":["thread",18115],"thread-17883":["thread",17883],"thread-17821":["thread",17821],"thread-17563":["thread",17563],"thread-17491":["thread",17491],"thread-17071":["thread",17071],"thread-16976":["thread",16976],"thread-16777":["thread",16777],"thread-16774":["thread",16774],"thread-15322":["thread",15322],"thread-13257":["thread",13257],"thread-12862":["thread",12862],"thread-12236":["thread",12236],"thread-12103":["thread",12103],"thread-12046":["thread",12046],"thread-11215":["thread",11215],"thread-10252":["thread",10252],"thread-10225":["thread",10225],"thread-9955":["thread",9955],"thread-9843":["thread",9843],"thread-9810":["thread",9810],"thread-9708":["thread",9708],"thread-8881":["thread",8881],"thread-8128":["thread",8128],"thread-7955":["thread",7955],"thread-7846":["thread",7846],"thread-6973":["thread",6973],"thread-5378":["thread",5378],"thread-3687":["thread",3687],"thread-3663":["thread",3663],"thread-3105":["thread",3105],"thread-3068":["thread",3068],"thread-1160":["thread",1160]}, , 1714908445
Run Time: 0.000375
- 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