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 (178587, 164331, 131390, 129788, 129607, 127987, 127353, 126566, 125515, 124104, 123463, 122817, 122579, 122168, 122019, 121911, 121497, 121363, 120639, 119924, 119263, 119206, 118908, 117152, 116621, 116539, 116479, 116478, 116417, 116174, 115260, 115222, 113586, 110779, 108781, 108497, 108053, 107258, 106249, 105850, 104707, 104703, 103331, 101478, 101226, 100843, 100783, 100701, 100699, 99710, 97480, 97474, 97309, 96786, 93928, 93716, 93682, 91986, 91497, 91258, 89624, 89014, 86642, 85832, 85824, 85823, 85820, 85801, 85795, 85785, 85784, 85482, 84837, 83998, 83786, 82799, 82182, 81444, 81300, 80893, 79066, 78897, 74616, 73332, 73276, 72947, 71339, 70196, 70116, 68427, 68342, 68287, 68180, 68071, 68068, 67624, 66958, 66192, 65824, 65580, 64276, 62573, 61436, 61305, 59834, 59638, 58506, 58187, 57506, 54288, 53601, 53169, 51715, 51429, 51122, 44883, 41528, 40146, 39982, 36298, 36285, 35748, 34595, 33987, 32918, 32558, 32520, 29846, 23748, 23122, 21050, 20928, 20839, 20490, 19471, 18641, 18293, 18278, 18197, 18186, 17951, 17890, 17077, 16635, 16029, 15671, 15595, 15177, 14702, 13869, 13507, 13248, 13216, 12240, 10957, 10644, 10418, 8198, 8086, 7549, 6483, 6202, 6174, 6064, 5818, 5758, 5509, 5482, 3943, 3939, 3091, 2864, 2747, 2616, 2178, 2177, 2109, 2107, 1082, 972))
Run Time: 0.090194
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 180 | 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: 240, 0, 1715915522, {"thread-178587":["thread",178587],"thread-164331":["thread",164331],"thread-131390":["thread",131390],"thread-129788":["thread",129788],"thread-129607":["thread",129607],"thread-127987":["thread",127987],"thread-127353":["thread",127353],"thread-126566":["thread",126566],"thread-125515":["thread",125515],"thread-124104":["thread",124104],"thread-123463":["thread",123463],"thread-122817":["thread",122817],"thread-122579":["thread",122579],"thread-122168":["thread",122168],"thread-122019":["thread",122019],"thread-121911":["thread",121911],"thread-121497":["thread",121497],"thread-121363":["thread",121363],"thread-120639":["thread",120639],"thread-119924":["thread",119924],"thread-119263":["thread",119263],"thread-119206":["thread",119206],"thread-118908":["thread",118908],"thread-117152":["thread",117152],"thread-116621":["thread",116621],"thread-116539":["thread",116539],"thread-116479":["thread",116479],"thread-116478":["thread",116478],"thread-116417":["thread",116417],"thread-116174":["thread",116174],"thread-115260":["thread",115260],"thread-115222":["thread",115222],"thread-113586":["thread",113586],"thread-110779":["thread",110779],"thread-108781":["thread",108781],"thread-108497":["thread",108497],"thread-108053":["thread",108053],"thread-107258":["thread",107258],"thread-106249":["thread",106249],"thread-105850":["thread",105850],"thread-104707":["thread",104707],"thread-104703":["thread",104703],"thread-103331":["thread",103331],"thread-101478":["thread",101478],"thread-101226":["thread",101226],"thread-100843":["thread",100843],"thread-100783":["thread",100783],"thread-100701":["thread",100701],"thread-100699":["thread",100699],"thread-99710":["thread",99710],"thread-97480":["thread",97480],"thread-97474":["thread",97474],"thread-97309":["thread",97309],"thread-96786":["thread",96786],"thread-93928":["thread",93928],"thread-93716":["thread",93716],"thread-93682":["thread",93682],"thread-91986":["thread",91986],"thread-91497":["thread",91497],"thread-91258":["thread",91258],"thread-89624":["thread",89624],"thread-89014":["thread",89014],"thread-86642":["thread",86642],"thread-85832":["thread",85832],"thread-85824":["thread",85824],"thread-85823":["thread",85823],"thread-85820":["thread",85820],"thread-85801":["thread",85801],"thread-85795":["thread",85795],"thread-85785":["thread",85785],"thread-85784":["thread",85784],"thread-85482":["thread",85482],"thread-84837":["thread",84837],"thread-83998":["thread",83998],"thread-83786":["thread",83786],"thread-82799":["thread",82799],"thread-82182":["thread",82182],"thread-81444":["thread",81444],"thread-81300":["thread",81300],"thread-80893":["thread",80893],"thread-79066":["thread",79066],"thread-78897":["thread",78897],"thread-74616":["thread",74616],"thread-73332":["thread",73332],"thread-73276":["thread",73276],"thread-72947":["thread",72947],"thread-71339":["thread",71339],"thread-70196":["thread",70196],"thread-70116":["thread",70116],"thread-68427":["thread",68427],"thread-68342":["thread",68342],"thread-68287":["thread",68287],"thread-68180":["thread",68180],"thread-68071":["thread",68071],"thread-68068":["thread",68068],"thread-67624":["thread",67624],"thread-66958":["thread",66958],"thread-66192":["thread",66192],"thread-65824":["thread",65824],"thread-65580":["thread",65580],"thread-64276":["thread",64276],"thread-62573":["thread",62573],"thread-61436":["thread",61436],"thread-61305":["thread",61305],"thread-59834":["thread",59834],"thread-59638":["thread",59638],"thread-58506":["thread",58506],"thread-58187":["thread",58187],"thread-57506":["thread",57506],"thread-54288":["thread",54288],"thread-53601":["thread",53601],"thread-53169":["thread",53169],"thread-51715":["thread",51715],"thread-51429":["thread",51429],"thread-51122":["thread",51122],"thread-44883":["thread",44883],"thread-41528":["thread",41528],"thread-40146":["thread",40146],"thread-39982":["thread",39982],"thread-36298":["thread",36298],"thread-36285":["thread",36285],"thread-35748":["thread",35748],"thread-34595":["thread",34595],"thread-33987":["thread",33987],"thread-32918":["thread",32918],"thread-32558":["thread",32558],"thread-32520":["thread",32520],"thread-29846":["thread",29846],"thread-23748":["thread",23748],"thread-23122":["thread",23122],"thread-21050":["thread",21050],"thread-20928":["thread",20928],"thread-20839":["thread",20839],"thread-20490":["thread",20490],"thread-19471":["thread",19471],"thread-18641":["thread",18641],"thread-18293":["thread",18293],"thread-18278":["thread",18278],"thread-18197":["thread",18197],"thread-18186":["thread",18186],"thread-17951":["thread",17951],"thread-17890":["thread",17890],"thread-17077":["thread",17077],"thread-16635":["thread",16635],"thread-16029":["thread",16029],"thread-15671":["thread",15671],"thread-15595":["thread",15595],"thread-15177":["thread",15177],"thread-14702":["thread",14702],"thread-13869":["thread",13869],"thread-13507":["thread",13507],"thread-13248":["thread",13248],"thread-13216":["thread",13216],"thread-12240":["thread",12240],"thread-10957":["thread",10957],"thread-10644":["thread",10644],"thread-10418":["thread",10418],"thread-8198":["thread",8198],"thread-8086":["thread",8086],"thread-7549":["thread",7549],"thread-6483":["thread",6483],"thread-6202":["thread",6202],"thread-6174":["thread",6174],"thread-6064":["thread",6064],"thread-5818":["thread",5818],"thread-5758":["thread",5758],"thread-5509":["thread",5509],"thread-5482":["thread",5482],"thread-3943":["thread",3943],"thread-3939":["thread",3939],"thread-3091":["thread",3091],"thread-2864":["thread",2864],"thread-2747":["thread",2747],"thread-2616":["thread",2616],"thread-2178":["thread",2178],"thread-2177":["thread",2177],"thread-2109":["thread",2109],"thread-2107":["thread",2107],"thread-1082":["thread",1082],"thread-972":["thread",972]}, , 1715911922
Run Time: 0.000685
- 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