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 (182294, 177486, 166132, 163034, 163023, 160196, 159562, 153690, 153257, 153247, 153204, 153190, 147658, 147285, 145714, 145456, 145184, 144932, 144720, 144402, 144360, 144071, 143427, 143408, 142966, 141334, 139389, 139231, 138328, 135960, 134563, 132824, 131788, 131167, 131136, 130915, 130861, 130783, 130159, 130155, 129980, 129699, 129331, 129329, 129139, 128765, 128486, 128142, 128045, 127883, 127328, 127249, 127067, 126959, 126003, 126002, 126001, 125932, 125006, 124994, 124749, 124740, 124717, 124577, 124512, 124244, 124146, 123867, 123859, 123658, 123492, 123386, 123319, 123092, 123072, 122919, 122918, 121922, 121057, 120745, 120525, 120392, 120391, 119738, 119220, 118766, 118564, 117771, 114070, 112693, 112304, 111152, 110664, 110496, 110329, 109776, 109166, 109048, 108565, 108302, 107884, 106625, 106491, 105798, 105770, 104406, 104118, 103314, 100532, 96898, 96308, 96225, 61813, 19046, 18815, 18524, 18471, 17747, 17150, 17071, 15852, 14794, 14500, 14432, 14324, 14123, 14014, 12590, 12588, 12577, 12574, 12541, 12467, 12462, 11828, 11785, 11386, 11302, 10884, 10853, 7365, 4277, 282))
Run Time: 0.177916
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 143 | 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: 1362, 0, 1716045499, {"thread-182294":["thread",182294],"thread-177486":["thread",177486],"thread-166132":["thread",166132],"thread-163034":["thread",163034],"thread-163023":["thread",163023],"thread-160196":["thread",160196],"ams_article-4415":["ams_article",4415],"thread-159562":["thread",159562],"ams_article-4344":["ams_article",4344],"ams_article-4143":["ams_article",4143],"thread-153690":["thread",153690],"ams_article-4045":["ams_article",4045],"thread-153257":["thread",153257],"thread-153247":["thread",153247],"thread-153204":["thread",153204],"thread-153190":["thread",153190],"thread-147658":["thread",147658],"thread-147285":["thread",147285],"ams_article-3534":["ams_article",3534],"ams_article-3531":["ams_article",3531],"ams_article-3494":["ams_article",3494],"ams_article-3483":["ams_article",3483],"ams_article-3481":["ams_article",3481],"thread-145714":["thread",145714],"thread-145456":["thread",145456],"thread-145184":["thread",145184],"thread-144932":["thread",144932],"thread-144720":["thread",144720],"thread-144402":["thread",144402],"thread-144360":["thread",144360],"thread-144071":["thread",144071],"thread-143427":["thread",143427],"thread-143408":["thread",143408],"thread-142966":["thread",142966],"thread-141334":["thread",141334],"thread-139389":["thread",139389],"thread-139231":["thread",139231],"thread-138328":["thread",138328],"ams_article-3003":["ams_article",3003],"thread-135960":["thread",135960],"thread-134563":["thread",134563],"thread-132824":["thread",132824],"thread-131788":["thread",131788],"thread-131167":["thread",131167],"thread-131136":["thread",131136],"thread-130915":["thread",130915],"thread-130861":["thread",130861],"thread-130783":["thread",130783],"thread-130159":["thread",130159],"thread-130155":["thread",130155],"thread-129980":["thread",129980],"thread-129699":["thread",129699],"thread-129331":["thread",129331],"thread-129329":["thread",129329],"thread-129139":["thread",129139],"thread-128765":["thread",128765],"thread-128486":["thread",128486],"thread-128142":["thread",128142],"thread-128045":["thread",128045],"thread-127883":["thread",127883],"thread-127328":["thread",127328],"thread-127249":["thread",127249],"thread-127067":["thread",127067],"thread-126959":["thread",126959],"thread-126003":["thread",126003],"thread-126002":["thread",126002],"thread-126001":["thread",126001],"thread-125932":["thread",125932],"thread-125006":["thread",125006],"thread-124994":["thread",124994],"thread-124749":["thread",124749],"thread-124740":["thread",124740],"thread-124717":["thread",124717],"thread-124577":["thread",124577],"thread-124512":["thread",124512],"thread-124244":["thread",124244],"thread-124146":["thread",124146],"thread-123867":["thread",123867],"thread-123859":["thread",123859],"thread-123658":["thread",123658],"thread-123492":["thread",123492],"thread-123386":["thread",123386],"thread-123319":["thread",123319],"thread-123092":["thread",123092],"thread-123072":["thread",123072],"thread-122919":["thread",122919],"thread-122918":["thread",122918],"thread-121922":["thread",121922],"thread-121057":["thread",121057],"thread-120745":["thread",120745],"thread-120525":["thread",120525],"thread-120392":["thread",120392],"thread-120391":["thread",120391],"thread-119738":["thread",119738],"thread-119220":["thread",119220],"thread-118766":["thread",118766],"thread-118564":["thread",118564],"thread-117771":["thread",117771],"thread-114070":["thread",114070],"thread-112693":["thread",112693],"thread-112304":["thread",112304],"thread-111152":["thread",111152],"thread-110664":["thread",110664],"thread-110496":["thread",110496],"thread-110329":["thread",110329],"thread-109776":["thread",109776],"thread-109166":["thread",109166],"thread-109048":["thread",109048],"thread-108565":["thread",108565],"thread-108302":["thread",108302],"thread-107884":["thread",107884],"thread-106625":["thread",106625],"thread-106491":["thread",106491],"thread-105798":["thread",105798],"thread-105770":["thread",105770],"thread-104406":["thread",104406],"thread-104118":["thread",104118],"thread-103314":["thread",103314],"thread-100532":["thread",100532],"thread-96898":["thread",96898],"thread-96308":["thread",96308],"thread-96225":["thread",96225],"thread-61813":["thread",61813],"thread-19046":["thread",19046],"thread-18815":["thread",18815],"thread-18524":["thread",18524],"thread-18471":["thread",18471],"thread-17747":["thread",17747],"thread-17150":["thread",17150],"thread-17071":["thread",17071],"thread-15852":["thread",15852],"thread-14794":["thread",14794],"thread-14500":["thread",14500],"thread-14432":["thread",14432],"thread-14324":["thread",14324],"thread-14123":["thread",14123],"thread-14014":["thread",14014],"thread-12590":["thread",12590],"thread-12588":["thread",12588],"thread-12577":["thread",12577],"thread-12574":["thread",12574],"thread-12541":["thread",12541],"thread-12467":["thread",12467],"thread-12462":["thread",12462],"thread-11828":["thread",11828],"thread-11785":["thread",11785],"thread-11386":["thread",11386],"thread-11302":["thread",11302],"thread-10884":["thread",10884],"thread-10853":["thread",10853],"thread-7365":["thread",7365],"thread-4277":["thread",4277],"thread-282":["thread",282]}, , 1716041899
Run Time: 0.013767
- 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