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 (182495, 182432, 182376, 182330, 181710, 181160, 180753, 180713, 180485, 180458, 179962, 179827, 179603, 179165, 178672, 178498, 177868, 177470, 176691, 176688, 175405, 175335, 175253, 174664, 174656, 174533, 174470, 174324, 174038, 173653, 173641, 173585, 173529, 173237, 173097, 173060, 172945, 172453, 172396, 171554, 170214, 169524, 169150, 168914, 168458, 167656, 167362, 167157, 166694, 166261, 165558, 165442, 164494, 164434, 163656, 163440, 162935, 160680, 160260, 159025, 158556, 158374, 157783, 157674, 157146, 156081, 154112, 152261, 151689, 147333, 139885, 131755, 131237, 128654, 127768, 126830, 126754, 124701, 124338, 124120, 122049, 121706, 120861, 119625, 118841, 117118, 116087, 114317, 110287, 110089, 110076, 109165, 107600, 107293, 107004, 106014, 104982, 101802, 101742, 101568, 101416, 100544, 100044, 99893, 99887, 98552, 97453, 97293, 96993, 95295, 94226, 93529, 93528, 92967, 92682, 92654, 91964, 91617, 91364, 91185, 88315, 86620, 86425, 86275, 86033, 86005, 85213, 84177, 83459, 82952, 82849, 82725, 80623, 80302, 79729, 79440, 78066, 78037, 77071, 76557, 76327, 74064, 73981, 73743, 72241, 71609, 71534, 69842, 68485, 67965, 66827, 65903, 65725, 64833, 64163, 62658, 62286, 61682, 59732, 59344, 58859, 58180, 57986, 57866, 57519, 57297, 56387, 55042, 54901, 54432, 54114, 53594, 53128, 53095, 52592, 52304, 51057, 50604, 50467, 50446, 50343, 50079, 50009, 49537, 49424, 48738, 48726, 48650, 47599, 47538, 47309, 46941, 46852, 46836, 46496, 46427, 46394, 46136, 46019, 44989))
Run Time: 0.085180
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: 669, 0, 1714772069, {"thread-182495":["thread",182495],"thread-182432":["thread",182432],"thread-182376":["thread",182376],"thread-182330":["thread",182330],"thread-181710":["thread",181710],"thread-181160":["thread",181160],"thread-180753":["thread",180753],"thread-180713":["thread",180713],"thread-180485":["thread",180485],"thread-180458":["thread",180458],"thread-179962":["thread",179962],"thread-179827":["thread",179827],"thread-179603":["thread",179603],"thread-179165":["thread",179165],"thread-178672":["thread",178672],"thread-178498":["thread",178498],"thread-177868":["thread",177868],"thread-177470":["thread",177470],"thread-176691":["thread",176691],"thread-176688":["thread",176688],"thread-175405":["thread",175405],"thread-175335":["thread",175335],"thread-175253":["thread",175253],"thread-174664":["thread",174664],"thread-174656":["thread",174656],"thread-174533":["thread",174533],"thread-174470":["thread",174470],"thread-174324":["thread",174324],"thread-174038":["thread",174038],"thread-173653":["thread",173653],"thread-173641":["thread",173641],"thread-173585":["thread",173585],"thread-173529":["thread",173529],"thread-173237":["thread",173237],"thread-173097":["thread",173097],"thread-173060":["thread",173060],"thread-172945":["thread",172945],"thread-172453":["thread",172453],"thread-172396":["thread",172396],"thread-171554":["thread",171554],"thread-170214":["thread",170214],"thread-169524":["thread",169524],"thread-169150":["thread",169150],"thread-168914":["thread",168914],"thread-168458":["thread",168458],"thread-167656":["thread",167656],"thread-167362":["thread",167362],"thread-167157":["thread",167157],"thread-166694":["thread",166694],"thread-166261":["thread",166261],"thread-165558":["thread",165558],"thread-165442":["thread",165442],"thread-164494":["thread",164494],"thread-164434":["thread",164434],"thread-163656":["thread",163656],"thread-163440":["thread",163440],"thread-162935":["thread",162935],"thread-160680":["thread",160680],"thread-160260":["thread",160260],"thread-159025":["thread",159025],"thread-158556":["thread",158556],"thread-158374":["thread",158374],"thread-157783":["thread",157783],"thread-157674":["thread",157674],"thread-157146":["thread",157146],"thread-156081":["thread",156081],"thread-154112":["thread",154112],"thread-152261":["thread",152261],"thread-151689":["thread",151689],"thread-147333":["thread",147333],"thread-139885":["thread",139885],"thread-131755":["thread",131755],"thread-131237":["thread",131237],"thread-128654":["thread",128654],"thread-127768":["thread",127768],"thread-126830":["thread",126830],"thread-126754":["thread",126754],"thread-124701":["thread",124701],"thread-124338":["thread",124338],"thread-124120":["thread",124120],"thread-122049":["thread",122049],"thread-121706":["thread",121706],"thread-120861":["thread",120861],"thread-119625":["thread",119625],"thread-118841":["thread",118841],"thread-117118":["thread",117118],"thread-116087":["thread",116087],"thread-114317":["thread",114317],"thread-110287":["thread",110287],"thread-110089":["thread",110089],"thread-110076":["thread",110076],"thread-109165":["thread",109165],"thread-107600":["thread",107600],"thread-107293":["thread",107293],"thread-107004":["thread",107004],"thread-106014":["thread",106014],"thread-104982":["thread",104982],"thread-101802":["thread",101802],"thread-101742":["thread",101742],"thread-101568":["thread",101568],"thread-101416":["thread",101416],"thread-100544":["thread",100544],"thread-100044":["thread",100044],"thread-99893":["thread",99893],"thread-99887":["thread",99887],"thread-98552":["thread",98552],"thread-97453":["thread",97453],"thread-97293":["thread",97293],"thread-96993":["thread",96993],"thread-95295":["thread",95295],"thread-94226":["thread",94226],"thread-93529":["thread",93529],"thread-93528":["thread",93528],"thread-92967":["thread",92967],"thread-92682":["thread",92682],"thread-92654":["thread",92654],"thread-91964":["thread",91964],"thread-91617":["thread",91617],"thread-91364":["thread",91364],"thread-91185":["thread",91185],"thread-88315":["thread",88315],"thread-86620":["thread",86620],"thread-86425":["thread",86425],"thread-86275":["thread",86275],"thread-86033":["thread",86033],"thread-86005":["thread",86005],"thread-85213":["thread",85213],"thread-84177":["thread",84177],"thread-83459":["thread",83459],"thread-82952":["thread",82952],"thread-82849":["thread",82849],"thread-82725":["thread",82725],"thread-80623":["thread",80623],"thread-80302":["thread",80302],"thread-79729":["thread",79729],"thread-79440":["thread",79440],"thread-78066":["thread",78066],"thread-78037":["thread",78037],"thread-77071":["thread",77071],"thread-76557":["thread",76557],"thread-76327":["thread",76327],"thread-74064":["thread",74064],"thread-73981":["thread",73981],"thread-73743":["thread",73743],"thread-72241":["thread",72241],"thread-71609":["thread",71609],"thread-71534":["thread",71534],"thread-69842":["thread",69842],"thread-68485":["thread",68485],"thread-67965":["thread",67965],"thread-66827":["thread",66827],"thread-65903":["thread",65903],"thread-65725":["thread",65725],"thread-64833":["thread",64833],"thread-64163":["thread",64163],"thread-62658":["thread",62658],"thread-62286":["thread",62286],"thread-61682":["thread",61682],"thread-59732":["thread",59732],"thread-59344":["thread",59344],"thread-58859":["thread",58859],"thread-58180":["thread",58180],"thread-57986":["thread",57986],"thread-57866":["thread",57866],"thread-57519":["thread",57519],"thread-57297":["thread",57297],"thread-56387":["thread",56387],"thread-55042":["thread",55042],"thread-54901":["thread",54901],"thread-54432":["thread",54432],"thread-54114":["thread",54114],"thread-53594":["thread",53594],"thread-53128":["thread",53128],"thread-53095":["thread",53095],"thread-52592":["thread",52592],"thread-52304":["thread",52304],"thread-51057":["thread",51057],"thread-50604":["thread",50604],"thread-50467":["thread",50467],"thread-50446":["thread",50446],"thread-50343":["thread",50343],"thread-50079":["thread",50079],"thread-50009":["thread",50009],"thread-49537":["thread",49537],"thread-49424":["thread",49424],"thread-48738":["thread",48738],"thread-48726":["thread",48726],"thread-48650":["thread",48650],"thread-47599":["thread",47599],"thread-47538":["thread",47538],"thread-47309":["thread",47309],"thread-46941":["thread",46941],"thread-46852":["thread",46852],"thread-46836":["thread",46836],"thread-46496":["thread",46496],"thread-46427":["thread",46427],"thread-46394":["thread",46394],"thread-46136":["thread",46136],"thread-46019":["thread",46019],"thread-44989":["thread",44989]}, , 1714768469
Run Time: 0.000854
- 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