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 (182783, 182768, 182352, 182030, 182006, 181816, 180739, 177110, 177028, 176510, 176350, 176235, 176136, 176071, 176030, 176010, 175927, 175366, 174841, 174553, 173677, 173155, 168011, 166144, 165974, 165211, 162683, 162637, 162631, 162618, 162115, 161271, 160703, 160415, 159933, 159764, 159291, 159290, 158896, 156486, 154830, 153241, 152352, 151886, 147044, 145433, 136522, 136342, 131016, 130487, 130484, 129791, 127657, 127361, 126924, 126804, 126534, 126357, 126355, 126088, 125821, 125704, 125587, 125416, 125075, 125067, 124618, 124530, 124504, 124267, 124056, 123818, 123656, 123440, 123439, 122832, 122601, 122285, 122214, 121739, 121733, 121481, 120274, 118952, 118573, 114334, 113912, 113638, 113607, 112831, 112804, 111936, 111678, 111057, 109925, 109680, 109485, 109401, 109124, 109118, 108854, 108852, 108780, 108462, 108246, 107241, 106933, 105988, 105777, 105761, 105756, 105512, 104284, 103163, 98787, 94687, 94212, 93539, 91906, 91834, 90943, 90699, 90600, 85900, 82949, 79964, 77347, 75425, 75424, 75421, 75410, 75407, 75213, 75134, 75123, 75117, 72957, 72856, 72309, 63267, 61668, 58895, 57250, 56960, 45552, 27761, 17790, 12902, 1396, 503, 447))
Run Time: 0.095561
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 151 | 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: 149, 0, 1716436739, {"thread-182783":["thread",182783],"thread-182768":["thread",182768],"thread-182352":["thread",182352],"thread-182030":["thread",182030],"thread-182006":["thread",182006],"thread-181816":["thread",181816],"thread-180739":["thread",180739],"thread-177110":["thread",177110],"thread-177028":["thread",177028],"thread-176510":["thread",176510],"thread-176350":["thread",176350],"thread-176235":["thread",176235],"thread-176136":["thread",176136],"thread-176071":["thread",176071],"thread-176030":["thread",176030],"thread-176010":["thread",176010],"thread-175927":["thread",175927],"thread-175366":["thread",175366],"thread-174841":["thread",174841],"thread-174553":["thread",174553],"thread-173677":["thread",173677],"thread-173155":["thread",173155],"ams_article-4823":["ams_article",4823],"thread-168011":["thread",168011],"thread-166144":["thread",166144],"thread-165974":["thread",165974],"thread-165211":["thread",165211],"thread-162683":["thread",162683],"thread-162637":["thread",162637],"thread-162631":["thread",162631],"thread-162618":["thread",162618],"thread-162115":["thread",162115],"thread-161271":["thread",161271],"thread-160703":["thread",160703],"thread-160415":["thread",160415],"thread-159933":["thread",159933],"thread-159764":["thread",159764],"thread-159291":["thread",159291],"thread-159290":["thread",159290],"thread-158896":["thread",158896],"thread-156486":["thread",156486],"thread-154830":["thread",154830],"thread-153241":["thread",153241],"thread-152352":["thread",152352],"thread-151886":["thread",151886],"thread-147044":["thread",147044],"thread-145433":["thread",145433],"thread-136522":["thread",136522],"thread-136342":["thread",136342],"thread-131016":["thread",131016],"thread-130487":["thread",130487],"thread-130484":["thread",130484],"thread-129791":["thread",129791],"thread-127657":["thread",127657],"thread-127361":["thread",127361],"thread-126924":["thread",126924],"thread-126804":["thread",126804],"thread-126534":["thread",126534],"thread-126357":["thread",126357],"thread-126355":["thread",126355],"thread-126088":["thread",126088],"thread-125821":["thread",125821],"thread-125704":["thread",125704],"thread-125587":["thread",125587],"thread-125416":["thread",125416],"thread-125075":["thread",125075],"thread-125067":["thread",125067],"thread-124618":["thread",124618],"thread-124530":["thread",124530],"thread-124504":["thread",124504],"thread-124267":["thread",124267],"thread-124056":["thread",124056],"thread-123818":["thread",123818],"thread-123656":["thread",123656],"thread-123440":["thread",123440],"thread-123439":["thread",123439],"thread-122832":["thread",122832],"thread-122601":["thread",122601],"thread-122285":["thread",122285],"thread-122214":["thread",122214],"thread-121739":["thread",121739],"thread-121733":["thread",121733],"thread-121481":["thread",121481],"thread-120274":["thread",120274],"thread-118952":["thread",118952],"thread-118573":["thread",118573],"thread-114334":["thread",114334],"thread-113912":["thread",113912],"thread-113638":["thread",113638],"thread-113607":["thread",113607],"thread-112831":["thread",112831],"thread-112804":["thread",112804],"thread-111936":["thread",111936],"thread-111678":["thread",111678],"thread-111057":["thread",111057],"thread-109925":["thread",109925],"thread-109680":["thread",109680],"thread-109485":["thread",109485],"thread-109401":["thread",109401],"thread-109124":["thread",109124],"thread-109118":["thread",109118],"thread-108854":["thread",108854],"thread-108852":["thread",108852],"thread-108780":["thread",108780],"thread-108462":["thread",108462],"thread-108246":["thread",108246],"thread-107241":["thread",107241],"thread-106933":["thread",106933],"thread-105988":["thread",105988],"thread-105777":["thread",105777],"thread-105761":["thread",105761],"thread-105756":["thread",105756],"thread-105512":["thread",105512],"thread-104284":["thread",104284],"thread-103163":["thread",103163],"thread-98787":["thread",98787],"thread-94687":["thread",94687],"thread-94212":["thread",94212],"thread-93539":["thread",93539],"thread-91906":["thread",91906],"thread-91834":["thread",91834],"thread-90943":["thread",90943],"thread-90699":["thread",90699],"thread-90600":["thread",90600],"thread-85900":["thread",85900],"thread-82949":["thread",82949],"thread-79964":["thread",79964],"thread-77347":["thread",77347],"thread-75425":["thread",75425],"thread-75424":["thread",75424],"thread-75421":["thread",75421],"thread-75410":["thread",75410],"thread-75407":["thread",75407],"thread-75213":["thread",75213],"thread-75134":["thread",75134],"thread-75123":["thread",75123],"thread-75117":["thread",75117],"thread-72957":["thread",72957],"thread-72856":["thread",72856],"thread-72309":["thread",72309],"thread-63267":["thread",63267],"thread-61668":["thread",61668],"thread-58895":["thread",58895],"thread-57250":["thread",57250],"thread-56960":["thread",56960],"thread-45552":["thread",45552],"thread-27761":["thread",27761],"thread-17790":["thread",17790],"thread-12902":["thread",12902],"thread-1396":["thread",1396],"thread-503":["thread",503],"thread-447":["thread",447]}, , 1716433139
Run Time: 0.000214
- 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