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 (183603, 183466, 182980, 182907, 182693, 182550, 182549, 182361, 182191, 181756, 181749, 181098, 181095, 181020, 181011, 181010, 180939, 180798, 180760, 180616, 180219, 180218, 179747, 179634, 179462, 179366, 179351, 179318, 179316, 179314, 178950, 178879, 178877, 178818, 178808, 178807, 178804, 178684, 178586, 178551, 178503, 178469, 178440, 178244, 178209, 178167, 177940, 177584, 177378, 177261, 177232, 177188, 177085, 177071, 176916, 176877, 176874, 176668, 176576, 176561, 176258, 176239, 176117, 175861, 175581, 175411, 175041, 175006, 174791, 174399, 174381, 174380, 174377, 174116, 173794, 173663, 173587, 172766, 172740, 172410, 172385, 172360, 172216, 172212, 172119, 171891, 171681, 171678, 171652, 171615, 171607, 171406, 171404, 171343, 171335, 171334, 170859, 170639, 170509, 170436, 170324, 170005, 169897, 169853, 169829, 169820, 169787, 169785, 169758, 169743, 169742, 169721, 169720, 169674, 169512, 169445, 169418, 169085, 168979, 168963, 168822, 168659, 168614, 168607, 168515, 168502, 168484, 168437, 168381, 168331, 168026, 167890, 167835, 167814, 167790, 167753, 167614, 167606, 167333, 167077, 166547, 166442, 166431, 166400, 166306, 166206, 166201, 166154, 166071, 166016, 166013, 165852, 165688, 165580, 165530, 165508, 165498, 165419, 165334, 165206, 165184, 165001, 164948, 164678, 164593, 164533, 164532, 164447, 164438, 164114, 163981, 163855, 163768, 163470, 163007, 162966, 162944, 162842, 162266, 162089, 161880, 161828, 161704, 161703, 161608, 161607, 161569, 161518, 161517, 161450, 161393, 161390, 161290, 161245, 161166, 161130, 160327, 160326, 160325, 160324))
Run Time: 0.330483
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 | 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: 337, 0, 1716190093, {"thread-183603":["thread",183603],"thread-183466":["thread",183466],"thread-182980":["thread",182980],"thread-182907":["thread",182907],"thread-182693":["thread",182693],"thread-182550":["thread",182550],"thread-182549":["thread",182549],"thread-182361":["thread",182361],"thread-182191":["thread",182191],"thread-181756":["thread",181756],"thread-181749":["thread",181749],"thread-181098":["thread",181098],"thread-181095":["thread",181095],"thread-181020":["thread",181020],"thread-181011":["thread",181011],"thread-181010":["thread",181010],"thread-180939":["thread",180939],"thread-180798":["thread",180798],"thread-180760":["thread",180760],"thread-180616":["thread",180616],"thread-180219":["thread",180219],"thread-180218":["thread",180218],"thread-179747":["thread",179747],"thread-179634":["thread",179634],"thread-179462":["thread",179462],"thread-179366":["thread",179366],"thread-179351":["thread",179351],"thread-179318":["thread",179318],"thread-179316":["thread",179316],"thread-179314":["thread",179314],"thread-178950":["thread",178950],"thread-178879":["thread",178879],"thread-178877":["thread",178877],"thread-178818":["thread",178818],"thread-178808":["thread",178808],"thread-178807":["thread",178807],"thread-178804":["thread",178804],"thread-178684":["thread",178684],"thread-178586":["thread",178586],"thread-178551":["thread",178551],"thread-178503":["thread",178503],"thread-178469":["thread",178469],"thread-178440":["thread",178440],"thread-178244":["thread",178244],"thread-178209":["thread",178209],"thread-178167":["thread",178167],"thread-177940":["thread",177940],"thread-177584":["thread",177584],"thread-177378":["thread",177378],"thread-177261":["thread",177261],"thread-177232":["thread",177232],"thread-177188":["thread",177188],"thread-177085":["thread",177085],"thread-177071":["thread",177071],"thread-176916":["thread",176916],"thread-176877":["thread",176877],"thread-176874":["thread",176874],"thread-176668":["thread",176668],"thread-176576":["thread",176576],"thread-176561":["thread",176561],"thread-176258":["thread",176258],"thread-176239":["thread",176239],"thread-176117":["thread",176117],"thread-175861":["thread",175861],"thread-175581":["thread",175581],"thread-175411":["thread",175411],"thread-175041":["thread",175041],"thread-175006":["thread",175006],"thread-174791":["thread",174791],"thread-174399":["thread",174399],"thread-174381":["thread",174381],"thread-174380":["thread",174380],"thread-174377":["thread",174377],"thread-174116":["thread",174116],"thread-173794":["thread",173794],"thread-173663":["thread",173663],"thread-173587":["thread",173587],"thread-172766":["thread",172766],"thread-172740":["thread",172740],"thread-172410":["thread",172410],"thread-172385":["thread",172385],"thread-172360":["thread",172360],"thread-172216":["thread",172216],"thread-172212":["thread",172212],"thread-172119":["thread",172119],"thread-171891":["thread",171891],"thread-171681":["thread",171681],"thread-171678":["thread",171678],"thread-171652":["thread",171652],"thread-171615":["thread",171615],"thread-171607":["thread",171607],"thread-171406":["thread",171406],"thread-171404":["thread",171404],"thread-171343":["thread",171343],"thread-171335":["thread",171335],"thread-171334":["thread",171334],"thread-170859":["thread",170859],"thread-170639":["thread",170639],"thread-170509":["thread",170509],"thread-170436":["thread",170436],"thread-170324":["thread",170324],"thread-170005":["thread",170005],"thread-169897":["thread",169897],"thread-169853":["thread",169853],"thread-169829":["thread",169829],"thread-169820":["thread",169820],"thread-169787":["thread",169787],"thread-169785":["thread",169785],"thread-169758":["thread",169758],"thread-169743":["thread",169743],"thread-169742":["thread",169742],"thread-169721":["thread",169721],"thread-169720":["thread",169720],"thread-169674":["thread",169674],"thread-169512":["thread",169512],"thread-169445":["thread",169445],"thread-169418":["thread",169418],"thread-169085":["thread",169085],"thread-168979":["thread",168979],"thread-168963":["thread",168963],"thread-168822":["thread",168822],"thread-168659":["thread",168659],"thread-168614":["thread",168614],"thread-168607":["thread",168607],"thread-168515":["thread",168515],"thread-168502":["thread",168502],"thread-168484":["thread",168484],"thread-168437":["thread",168437],"thread-168381":["thread",168381],"thread-168331":["thread",168331],"thread-168026":["thread",168026],"thread-167890":["thread",167890],"thread-167835":["thread",167835],"thread-167814":["thread",167814],"thread-167790":["thread",167790],"thread-167753":["thread",167753],"thread-167614":["thread",167614],"thread-167606":["thread",167606],"thread-167333":["thread",167333],"thread-167077":["thread",167077],"thread-166547":["thread",166547],"thread-166442":["thread",166442],"thread-166431":["thread",166431],"thread-166400":["thread",166400],"thread-166306":["thread",166306],"thread-166206":["thread",166206],"thread-166201":["thread",166201],"thread-166154":["thread",166154],"thread-166071":["thread",166071],"thread-166016":["thread",166016],"thread-166013":["thread",166013],"thread-165852":["thread",165852],"thread-165688":["thread",165688],"thread-165580":["thread",165580],"thread-165530":["thread",165530],"thread-165508":["thread",165508],"thread-165498":["thread",165498],"thread-165419":["thread",165419],"thread-165334":["thread",165334],"thread-165206":["thread",165206],"thread-165184":["thread",165184],"thread-165001":["thread",165001],"thread-164948":["thread",164948],"thread-164678":["thread",164678],"thread-164593":["thread",164593],"thread-164447":["thread",164447],"thread-164438":["thread",164438],"thread-164114":["thread",164114],"thread-163981":["thread",163981],"thread-163855":["thread",163855],"thread-163768":["thread",163768],"thread-163470":["thread",163470],"thread-163007":["thread",163007],"thread-162966":["thread",162966],"thread-162944":["thread",162944],"thread-162842":["thread",162842],"thread-162266":["thread",162266],"thread-162089":["thread",162089],"thread-161880":["thread",161880],"thread-161828":["thread",161828],"thread-161704":["thread",161704],"thread-161703":["thread",161703],"thread-161608":["thread",161608],"thread-161607":["thread",161607],"thread-161569":["thread",161569],"thread-161518":["thread",161518],"thread-161517":["thread",161517],"thread-161450":["thread",161450],"thread-161393":["thread",161393],"thread-161390":["thread",161390],"thread-161290":["thread",161290],"thread-161245":["thread",161245],"thread-161166":["thread",161166],"thread-161130":["thread",161130],"thread-160327":["thread",160327],"thread-160326":["thread",160326],"thread-160325":["thread",160325],"thread-160324":["thread",160324]}, , 1716186493
Run Time: 0.000982
- 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