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 (178068, 176125, 160429, 150684, 150547, 149774, 149219, 148007, 147999, 147972, 147327, 146460, 145971, 145817, 145374, 145263, 145142, 144412, 144088, 143605, 143566, 141573, 141503, 140145, 140058, 140057, 140056, 140049, 139807, 139677, 139639, 139578, 139577, 139575, 139572, 138095, 137888, 137548, 137292, 137139, 136485, 136405, 136046, 135238, 135007, 134847, 134801, 134302, 134242, 133777, 132026, 131881, 131397, 131372, 131347, 131129, 131124, 131122, 130957, 130631, 130471, 130460, 130434, 129109, 128458, 128421, 128243, 128210, 127766, 127754, 127482, 127024, 125729, 124149, 124148, 123308, 122547, 122176, 121956, 121570, 121200, 120774, 119813, 119774, 119758, 119741, 119731, 119627, 118743, 118712, 118422, 118421, 118039, 117777, 117720, 117595, 117591, 117456, 116705, 116518, 116489, 116390, 116382, 116080, 116027, 115509, 115479, 115445, 115363, 115339, 115233, 115147, 114781, 114547, 114455, 113813, 113753, 112971, 112962, 112943, 112939, 112886, 112885, 112833, 112653, 112630, 112623, 112609, 111829, 111729, 111047, 110995, 110889, 110768, 110084, 110063, 110060, 110058, 109875, 109808, 109737, 109414, 108759, 108159, 108156, 107908, 107803, 107611, 107567, 107205, 107184, 106858, 106002, 105806, 105528, 104636, 104369, 103853, 103209, 102013, 101847, 101102, 101078, 100427, 99633, 99593, 99004, 98822, 98029, 97979, 97738, 97641, 97575, 97047, 97006, 96420, 96319, 96278, 95213, 95078, 94880, 94792, 88086, 86473, 71455, 70383))
Run Time: 0.125015
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 186 | 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: 163, 0, 1716265053, {"thread-178068":["thread",178068],"thread-176125":["thread",176125],"ams_article-5088":["ams_article",5088],"thread-160429":["thread",160429],"ams_article-4177":["ams_article",4177],"ams_article-4123":["ams_article",4123],"tl_group-108":["tl_group",108],"ams_article-4050":["ams_article",4050],"ams_article-3869":["ams_article",3869],"thread-150684":["thread",150684],"thread-150547":["thread",150547],"thread-149774":["thread",149774],"thread-149219":["thread",149219],"thread-148007":["thread",148007],"thread-147999":["thread",147999],"thread-147972":["thread",147972],"thread-147327":["thread",147327],"thread-146460":["thread",146460],"ams_article-3479":["ams_article",3479],"thread-145971":["thread",145971],"ams_article-3471":["ams_article",3471],"thread-145817":["thread",145817],"thread-145374":["thread",145374],"thread-145263":["thread",145263],"thread-145142":["thread",145142],"thread-144412":["thread",144412],"thread-144088":["thread",144088],"thread-143605":["thread",143605],"thread-143566":["thread",143566],"ams_article-3322":["ams_article",3322],"thread-141573":["thread",141573],"thread-141503":["thread",141503],"thread-140145":["thread",140145],"thread-140058":["thread",140058],"thread-140057":["thread",140057],"thread-140056":["thread",140056],"thread-140049":["thread",140049],"thread-139807":["thread",139807],"ams_article-3137":["ams_article",3137],"thread-139677":["thread",139677],"thread-139639":["thread",139639],"thread-139578":["thread",139578],"thread-139577":["thread",139577],"thread-139575":["thread",139575],"thread-139572":["thread",139572],"ams_article-3093":["ams_article",3093],"thread-138095":["thread",138095],"thread-137888":["thread",137888],"thread-137548":["thread",137548],"thread-137292":["thread",137292],"thread-137139":["thread",137139],"thread-136485":["thread",136485],"thread-136405":["thread",136405],"thread-136046":["thread",136046],"thread-135238":["thread",135238],"thread-135007":["thread",135007],"thread-134847":["thread",134847],"thread-134801":["thread",134801],"thread-134302":["thread",134302],"thread-134242":["thread",134242],"thread-133777":["thread",133777],"thread-132026":["thread",132026],"thread-131881":["thread",131881],"thread-131397":["thread",131397],"thread-131372":["thread",131372],"thread-131347":["thread",131347],"thread-131129":["thread",131129],"thread-131124":["thread",131124],"thread-131122":["thread",131122],"thread-130957":["thread",130957],"thread-130631":["thread",130631],"thread-130471":["thread",130471],"thread-130460":["thread",130460],"thread-130434":["thread",130434],"thread-129109":["thread",129109],"thread-128458":["thread",128458],"thread-128421":["thread",128421],"thread-128243":["thread",128243],"thread-128210":["thread",128210],"thread-127766":["thread",127766],"thread-127754":["thread",127754],"thread-127482":["thread",127482],"thread-127024":["thread",127024],"thread-125729":["thread",125729],"thread-124149":["thread",124149],"thread-124148":["thread",124148],"thread-123308":["thread",123308],"thread-122547":["thread",122547],"thread-122176":["thread",122176],"thread-121956":["thread",121956],"thread-121570":["thread",121570],"thread-121200":["thread",121200],"thread-120774":["thread",120774],"thread-119813":["thread",119813],"thread-119774":["thread",119774],"thread-119758":["thread",119758],"thread-119741":["thread",119741],"thread-119731":["thread",119731],"thread-119627":["thread",119627],"thread-118743":["thread",118743],"thread-118712":["thread",118712],"thread-118422":["thread",118422],"thread-118421":["thread",118421],"thread-118039":["thread",118039],"thread-117777":["thread",117777],"thread-117720":["thread",117720],"thread-117595":["thread",117595],"thread-117591":["thread",117591],"thread-117456":["thread",117456],"thread-116705":["thread",116705],"thread-116518":["thread",116518],"thread-116489":["thread",116489],"thread-116390":["thread",116390],"thread-116382":["thread",116382],"thread-116080":["thread",116080],"thread-116027":["thread",116027],"thread-115509":["thread",115509],"thread-115479":["thread",115479],"thread-115445":["thread",115445],"thread-115363":["thread",115363],"thread-115339":["thread",115339],"thread-115233":["thread",115233],"thread-115147":["thread",115147],"thread-114781":["thread",114781],"thread-114547":["thread",114547],"thread-114455":["thread",114455],"thread-113813":["thread",113813],"thread-113753":["thread",113753],"thread-112971":["thread",112971],"thread-112962":["thread",112962],"thread-112943":["thread",112943],"thread-112939":["thread",112939],"thread-112886":["thread",112886],"thread-112885":["thread",112885],"thread-112833":["thread",112833],"thread-112653":["thread",112653],"thread-112630":["thread",112630],"thread-112623":["thread",112623],"thread-112609":["thread",112609],"thread-111829":["thread",111829],"thread-111729":["thread",111729],"thread-111047":["thread",111047],"thread-110995":["thread",110995],"thread-110889":["thread",110889],"thread-110768":["thread",110768],"thread-110084":["thread",110084],"thread-110063":["thread",110063],"thread-110060":["thread",110060],"thread-110058":["thread",110058],"thread-109875":["thread",109875],"thread-109808":["thread",109808],"thread-109737":["thread",109737],"thread-109414":["thread",109414],"thread-108759":["thread",108759],"thread-108159":["thread",108159],"thread-108156":["thread",108156],"thread-107908":["thread",107908],"thread-107803":["thread",107803],"thread-107611":["thread",107611],"thread-107567":["thread",107567],"thread-107205":["thread",107205],"thread-107184":["thread",107184],"thread-106858":["thread",106858],"thread-106002":["thread",106002],"thread-105806":["thread",105806],"thread-105528":["thread",105528],"thread-104636":["thread",104636],"thread-104369":["thread",104369],"thread-103853":["thread",103853],"thread-103209":["thread",103209],"thread-102013":["thread",102013],"thread-101847":["thread",101847],"thread-101102":["thread",101102],"thread-101078":["thread",101078],"thread-100427":["thread",100427],"thread-99633":["thread",99633],"thread-99593":["thread",99593],"thread-99004":["thread",99004],"thread-98822":["thread",98822],"thread-98029":["thread",98029],"thread-97979":["thread",97979],"thread-97738":["thread",97738],"thread-97641":["thread",97641],"thread-97575":["thread",97575],"thread-97047":["thread",97047],"thread-97006":["thread",97006],"thread-96420":["thread",96420],"thread-96319":["thread",96319],"thread-96278":["thread",96278],"thread-95213":["thread",95213],"thread-95078":["thread",95078],"thread-94880":["thread",94880],"thread-94792":["thread",94792],"thread-88086":["thread",88086],"thread-86473":["thread",86473],"thread-71455":["thread",71455],"thread-70383":["thread",70383]}, , 1716261453
Run Time: 0.000622
- 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