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 (183426, 183321, 183100, 181721, 181628, 181491, 181426, 181216, 180391, 179153, 178456, 178218, 178184, 178111, 177651, 177499, 177112, 176679, 176358, 176085, 176010, 175946, 175881, 175674, 174641, 174045, 173880, 173012, 171588, 169443, 167975, 166056, 164982, 164885, 161200, 159014, 158984, 154940, 154795, 154125, 153973, 153860, 153717, 153562, 153114, 152772, 151789, 149909, 142919, 140308, 139492, 139450, 138635, 138620, 138617, 136722, 136425, 135716, 135226, 134992, 133901, 132556, 132486, 131720, 130925, 130827, 130609, 130598, 130515, 130339, 130178, 130170, 129600, 128864, 128692, 128407, 127174, 126908, 125937, 125382, 125269, 125023, 123071, 121484, 120397, 120120, 119067, 118829, 118727, 118497, 118058, 117711, 117487, 117397, 115130, 114655, 114464, 114105, 113541, 113401, 113247, 112006, 110060, 109808, 109283, 108979, 108308, 107267, 107264, 105503, 105381, 103710, 103540, 103512, 103043, 101511, 98708, 97531, 95916, 91485, 90009, 89557, 86621, 86070, 85468, 84985, 84984, 83761, 81967, 78613, 78070, 74202, 71747, 70408, 69533, 67634, 66282, 64151, 60758, 59999, 58389, 58015, 57741, 55289, 49626, 34428, 25630, 14432, 11386, 10884, 5089, 1823))
Run Time: 0.115294
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 152 | 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: 1323, 0, 1715587505, {"thread-183426":["thread",183426],"thread-183321":["thread",183321],"thread-183100":["thread",183100],"thread-181721":["thread",181721],"thread-181628":["thread",181628],"thread-181491":["thread",181491],"thread-181426":["thread",181426],"thread-181216":["thread",181216],"thread-180391":["thread",180391],"thread-179153":["thread",179153],"thread-178456":["thread",178456],"thread-178218":["thread",178218],"thread-178184":["thread",178184],"thread-178111":["thread",178111],"thread-177651":["thread",177651],"thread-177499":["thread",177499],"thread-177112":["thread",177112],"thread-176679":["thread",176679],"thread-176358":["thread",176358],"thread-176085":["thread",176085],"thread-176010":["thread",176010],"thread-175946":["thread",175946],"thread-175881":["thread",175881],"thread-175674":["thread",175674],"thread-174641":["thread",174641],"thread-174045":["thread",174045],"thread-173880":["thread",173880],"thread-173012":["thread",173012],"thread-171588":["thread",171588],"thread-169443":["thread",169443],"thread-167975":["thread",167975],"thread-166056":["thread",166056],"thread-164982":["thread",164982],"thread-164885":["thread",164885],"thread-161200":["thread",161200],"thread-159014":["thread",159014],"thread-158984":["thread",158984],"thread-154940":["thread",154940],"thread-154795":["thread",154795],"thread-154125":["thread",154125],"thread-153973":["thread",153973],"thread-153860":["thread",153860],"thread-153717":["thread",153717],"thread-153562":["thread",153562],"thread-153114":["thread",153114],"thread-152772":["thread",152772],"thread-151789":["thread",151789],"thread-149909":["thread",149909],"thread-142919":["thread",142919],"thread-140308":["thread",140308],"thread-139492":["thread",139492],"thread-139450":["thread",139450],"thread-138635":["thread",138635],"thread-138620":["thread",138620],"thread-138617":["thread",138617],"thread-136722":["thread",136722],"thread-136425":["thread",136425],"thread-135716":["thread",135716],"thread-135226":["thread",135226],"thread-134992":["thread",134992],"thread-133901":["thread",133901],"thread-132556":["thread",132556],"thread-132486":["thread",132486],"thread-131720":["thread",131720],"thread-130925":["thread",130925],"thread-130827":["thread",130827],"thread-130609":["thread",130609],"thread-130598":["thread",130598],"thread-130515":["thread",130515],"thread-130339":["thread",130339],"thread-130178":["thread",130178],"thread-130170":["thread",130170],"thread-129600":["thread",129600],"thread-128864":["thread",128864],"thread-128692":["thread",128692],"thread-128407":["thread",128407],"thread-127174":["thread",127174],"thread-126908":["thread",126908],"thread-125937":["thread",125937],"thread-125382":["thread",125382],"thread-125269":["thread",125269],"thread-125023":["thread",125023],"thread-123071":["thread",123071],"thread-121484":["thread",121484],"thread-120397":["thread",120397],"thread-120120":["thread",120120],"thread-119067":["thread",119067],"thread-118829":["thread",118829],"thread-118727":["thread",118727],"thread-118497":["thread",118497],"thread-118058":["thread",118058],"thread-117711":["thread",117711],"thread-117487":["thread",117487],"thread-117397":["thread",117397],"thread-115130":["thread",115130],"thread-114655":["thread",114655],"thread-114464":["thread",114464],"thread-114105":["thread",114105],"thread-113541":["thread",113541],"thread-113401":["thread",113401],"thread-113247":["thread",113247],"thread-112006":["thread",112006],"thread-110060":["thread",110060],"thread-109808":["thread",109808],"thread-109283":["thread",109283],"thread-108979":["thread",108979],"thread-108308":["thread",108308],"thread-107267":["thread",107267],"thread-107264":["thread",107264],"thread-105503":["thread",105503],"thread-105381":["thread",105381],"thread-103710":["thread",103710],"thread-103540":["thread",103540],"thread-103512":["thread",103512],"thread-103043":["thread",103043],"thread-101511":["thread",101511],"thread-98708":["thread",98708],"thread-97531":["thread",97531],"thread-95916":["thread",95916],"thread-91485":["thread",91485],"thread-90009":["thread",90009],"thread-89557":["thread",89557],"thread-86621":["thread",86621],"thread-86070":["thread",86070],"thread-85468":["thread",85468],"thread-84985":["thread",84985],"thread-84984":["thread",84984],"thread-83761":["thread",83761],"thread-81967":["thread",81967],"thread-78613":["thread",78613],"thread-78070":["thread",78070],"thread-74202":["thread",74202],"thread-71747":["thread",71747],"thread-70408":["thread",70408],"thread-69533":["thread",69533],"thread-67634":["thread",67634],"thread-66282":["thread",66282],"thread-64151":["thread",64151],"thread-60758":["thread",60758],"thread-59999":["thread",59999],"thread-58389":["thread",58389],"thread-58015":["thread",58015],"thread-57741":["thread",57741],"thread-55289":["thread",55289],"thread-49626":["thread",49626],"thread-34428":["thread",34428],"thread-25630":["thread",25630],"thread-14432":["thread",14432],"thread-11386":["thread",11386],"thread-10884":["thread",10884],"thread-5089":["thread",5089],"thread-1823":["thread",1823]}, , 1715583905
Run Time: 0.000474
- 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