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 (182940, 182740, 182371, 182336, 182018, 181665, 181543, 181414, 180883, 180826, 180822, 180755, 180638, 180450, 180004, 179965, 179358, 179112, 179110, 179096, 178835, 178322, 177957, 177932, 177914, 177552, 177539, 177432, 177172, 176720, 176712, 176560, 176444, 176082, 174831, 174415, 173944, 173876, 173090, 172697, 172689, 172545, 172524, 172412, 171996, 171979, 171654, 171570, 171521, 171316, 171190, 171153, 171142, 171115, 170939, 170817, 170710, 170586, 170420, 170291, 170246, 170027, 169405, 169232, 169117, 168998, 168706, 168692, 168631, 168258, 168044, 168031, 167587, 167033, 166885, 166814, 166504, 166465, 166236, 165887, 165705, 165661, 165209, 164720, 164660, 164592, 164510, 164185, 164059, 163929, 163717, 163360, 163120, 162812, 162393, 162370, 161975, 161909, 161499, 160615, 160484, 160475, 160105, 160054, 159559, 159418, 159402, 158943, 158576, 158573, 158559, 158554, 158553, 158043, 158020, 157913, 157838, 157743, 157730, 157713, 157623, 157608, 157584, 157455, 157389, 157179, 157165, 157105, 156904, 156650, 156593, 156023, 155687, 155684, 155542, 155366, 155357, 155306, 155153, 155113, 154968, 154961, 154922, 154668, 154598, 154366, 154290, 154018, 153882, 153711, 153362, 153305, 153255, 153194, 153192, 153151, 153136, 152952, 152819, 152776, 152683, 152643, 152347, 152332, 152248, 152148, 152115, 151852, 147136, 147065, 146714, 146394, 140710, 140509, 139893, 139513, 138203, 138095, 136981, 136108, 135508, 135175, 134338, 133779, 133258, 132660, 132524, 132453, 131623, 131456, 131454, 131373, 131192, 131179, 130894, 130893, 130810, 130806, 130805))
Run Time: 0.109515
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 199 | 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: 138, 0, 1714830258, {"thread-182940":["thread",182940],"thread-182740":["thread",182740],"thread-182371":["thread",182371],"thread-182336":["thread",182336],"thread-182018":["thread",182018],"thread-181665":["thread",181665],"thread-181543":["thread",181543],"thread-181414":["thread",181414],"thread-180883":["thread",180883],"thread-180826":["thread",180826],"thread-180822":["thread",180822],"thread-180755":["thread",180755],"thread-180638":["thread",180638],"thread-180450":["thread",180450],"thread-180004":["thread",180004],"thread-179965":["thread",179965],"thread-179358":["thread",179358],"thread-179112":["thread",179112],"thread-179110":["thread",179110],"thread-179096":["thread",179096],"thread-178835":["thread",178835],"thread-178322":["thread",178322],"thread-177957":["thread",177957],"thread-177932":["thread",177932],"thread-177914":["thread",177914],"thread-177552":["thread",177552],"thread-177539":["thread",177539],"thread-177432":["thread",177432],"thread-177172":["thread",177172],"thread-176720":["thread",176720],"thread-176712":["thread",176712],"thread-176560":["thread",176560],"thread-176444":["thread",176444],"thread-176082":["thread",176082],"thread-174831":["thread",174831],"thread-174415":["thread",174415],"thread-173944":["thread",173944],"thread-173876":["thread",173876],"thread-173090":["thread",173090],"thread-172697":["thread",172697],"thread-172689":["thread",172689],"thread-172545":["thread",172545],"thread-172524":["thread",172524],"thread-172412":["thread",172412],"thread-171996":["thread",171996],"thread-171979":["thread",171979],"thread-171654":["thread",171654],"thread-171570":["thread",171570],"thread-171521":["thread",171521],"thread-171316":["thread",171316],"thread-171190":["thread",171190],"thread-171153":["thread",171153],"thread-171142":["thread",171142],"thread-171115":["thread",171115],"thread-170939":["thread",170939],"thread-170817":["thread",170817],"thread-170710":["thread",170710],"thread-170586":["thread",170586],"thread-170420":["thread",170420],"thread-170291":["thread",170291],"thread-170246":["thread",170246],"thread-170027":["thread",170027],"thread-169405":["thread",169405],"thread-169232":["thread",169232],"thread-169117":["thread",169117],"thread-168998":["thread",168998],"thread-168706":["thread",168706],"thread-168692":["thread",168692],"thread-168631":["thread",168631],"thread-168258":["thread",168258],"thread-168044":["thread",168044],"thread-168031":["thread",168031],"thread-167587":["thread",167587],"thread-167033":["thread",167033],"thread-166885":["thread",166885],"thread-166814":["thread",166814],"thread-166504":["thread",166504],"thread-166465":["thread",166465],"thread-166236":["thread",166236],"thread-165887":["thread",165887],"thread-165705":["thread",165705],"thread-165661":["thread",165661],"thread-165209":["thread",165209],"thread-164720":["thread",164720],"thread-164660":["thread",164660],"thread-164592":["thread",164592],"thread-164510":["thread",164510],"thread-164185":["thread",164185],"thread-164059":["thread",164059],"thread-163929":["thread",163929],"thread-163717":["thread",163717],"thread-163360":["thread",163360],"thread-163120":["thread",163120],"thread-162812":["thread",162812],"thread-162393":["thread",162393],"thread-162370":["thread",162370],"thread-161975":["thread",161975],"thread-161909":["thread",161909],"thread-161499":["thread",161499],"thread-160615":["thread",160615],"thread-160484":["thread",160484],"thread-160475":["thread",160475],"thread-160105":["thread",160105],"thread-160054":["thread",160054],"thread-159559":["thread",159559],"thread-159418":["thread",159418],"thread-159402":["thread",159402],"thread-158943":["thread",158943],"thread-158576":["thread",158576],"thread-158573":["thread",158573],"thread-158559":["thread",158559],"thread-158554":["thread",158554],"thread-158553":["thread",158553],"thread-158043":["thread",158043],"thread-158020":["thread",158020],"thread-157913":["thread",157913],"thread-157838":["thread",157838],"thread-157743":["thread",157743],"thread-157730":["thread",157730],"thread-157713":["thread",157713],"thread-157623":["thread",157623],"thread-157608":["thread",157608],"thread-157584":["thread",157584],"thread-157455":["thread",157455],"thread-157389":["thread",157389],"thread-157179":["thread",157179],"thread-157165":["thread",157165],"thread-157105":["thread",157105],"thread-156904":["thread",156904],"thread-156650":["thread",156650],"thread-156593":["thread",156593],"thread-156023":["thread",156023],"thread-155687":["thread",155687],"thread-155684":["thread",155684],"thread-155542":["thread",155542],"thread-155357":["thread",155357],"thread-155306":["thread",155306],"thread-155153":["thread",155153],"thread-155113":["thread",155113],"thread-154968":["thread",154968],"thread-154961":["thread",154961],"thread-154922":["thread",154922],"thread-154668":["thread",154668],"thread-154598":["thread",154598],"thread-154366":["thread",154366],"thread-154290":["thread",154290],"thread-154018":["thread",154018],"thread-153882":["thread",153882],"thread-153711":["thread",153711],"thread-153362":["thread",153362],"thread-153305":["thread",153305],"thread-153255":["thread",153255],"thread-153194":["thread",153194],"thread-153192":["thread",153192],"thread-153151":["thread",153151],"thread-153136":["thread",153136],"thread-152952":["thread",152952],"thread-152819":["thread",152819],"thread-152776":["thread",152776],"thread-152683":["thread",152683],"thread-152643":["thread",152643],"thread-152347":["thread",152347],"thread-152332":["thread",152332],"thread-152248":["thread",152248],"thread-152148":["thread",152148],"thread-152115":["thread",152115],"thread-151852":["thread",151852],"thread-147136":["thread",147136],"thread-147065":["thread",147065],"thread-146714":["thread",146714],"thread-146394":["thread",146394],"thread-140710":["thread",140710],"thread-140509":["thread",140509],"thread-139893":["thread",139893],"thread-139513":["thread",139513],"thread-138203":["thread",138203],"thread-138095":["thread",138095],"thread-136981":["thread",136981],"thread-136108":["thread",136108],"thread-135508":["thread",135508],"thread-135175":["thread",135175],"thread-134338":["thread",134338],"thread-133779":["thread",133779],"thread-133258":["thread",133258],"thread-132660":["thread",132660],"thread-132524":["thread",132524],"thread-132453":["thread",132453],"thread-131623":["thread",131623],"thread-131456":["thread",131456],"thread-131454":["thread",131454],"thread-131373":["thread",131373],"thread-131192":["thread",131192],"thread-131179":["thread",131179],"thread-130894":["thread",130894],"thread-130893":["thread",130893],"thread-130810":["thread",130810],"thread-130806":["thread",130806],"thread-130805":["thread",130805]}, , 1714826658
Run Time: 0.000385
- 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