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, 166710, 166709, 166135, 165047, 165045, 164787, 164772, 163732, 163026, 159711, 159562, 158573, 158551, 158379, 156804, 153796, 153418, 153247, 153190, 150945, 150887, 149324, 148653, 148317, 147731, 147177, 142819, 139757, 136017, 134870, 134827, 131454, 130682, 130673, 130562, 130317, 130233, 129612, 129022, 128969, 128572, 128412, 127987, 127986, 127303, 127227, 127210, 126752, 125246, 125051, 124912, 124639, 124604, 124510, 124429, 124427, 123968, 123136, 123001, 122643, 122608, 121990, 121855, 121570, 120765, 120617, 120461, 120460, 120437, 119341, 119209, 119093, 119034, 118361, 118007, 117969, 116464, 116384, 114767, 114660, 114657, 114648, 113951, 113669, 113390, 113191, 112822, 112758, 112433, 112432, 112289, 112039, 111559, 111501, 111461, 111446, 111241, 111174, 110648, 110581, 110535, 110122, 110069, 109778, 109735, 109643, 108752, 108111, 107884, 107702, 107051, 107049, 106942, 106554, 106370, 106116, 106096, 106093, 106038, 104534, 104372, 104276, 104260, 104226, 101865, 100250, 99142, 98146, 98017, 96943, 96333, 74385, 67898, 60869, 60463, 56799))
Run Time: 0.102333
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 137 | 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: 9537, 0, 1716061103, {"thread-182294":["thread",182294],"tl_group-381":["tl_group",381],"thread-166710":["thread",166710],"thread-166709":["thread",166709],"ams_article-4717":["ams_article",4717],"tl_group-237":["tl_group",237],"thread-166135":["thread",166135],"thread-165047":["thread",165047],"thread-165045":["thread",165045],"thread-164787":["thread",164787],"thread-164772":["thread",164772],"tl_group-216":["tl_group",216],"ams_article-4556":["ams_article",4556],"thread-163732":["thread",163732],"thread-163026":["thread",163026],"thread-159711":["thread",159711],"thread-159562":["thread",159562],"thread-158573":["thread",158573],"thread-158551":["thread",158551],"thread-158379":["thread",158379],"thread-156804":["thread",156804],"thread-153796":["thread",153796],"thread-153418":["thread",153418],"thread-153247":["thread",153247],"thread-153190":["thread",153190],"ams_article-4004":["ams_article",4004],"tl_group-1":["tl_group",1],"thread-150945":["thread",150945],"thread-150887":["thread",150887],"ams_article-3833":["ams_article",3833],"ams_article-3821":["ams_article",3821],"thread-149324":["thread",149324],"thread-148653":["thread",148653],"thread-148317":["thread",148317],"thread-147731":["thread",147731],"thread-147177":["thread",147177],"thread-142819":["thread",142819],"thread-139757":["thread",139757],"ams_article-3135":["ams_article",3135],"ams_article-3007":["ams_article",3007],"thread-136017":["thread",136017],"thread-134870":["thread",134870],"thread-134827":["thread",134827],"thread-131454":["thread",131454],"thread-130682":["thread",130682],"thread-130673":["thread",130673],"thread-130562":["thread",130562],"thread-130317":["thread",130317],"thread-130233":["thread",130233],"thread-129612":["thread",129612],"thread-129022":["thread",129022],"thread-128969":["thread",128969],"thread-128572":["thread",128572],"thread-128412":["thread",128412],"thread-127987":["thread",127987],"thread-127986":["thread",127986],"thread-127303":["thread",127303],"thread-127227":["thread",127227],"thread-127210":["thread",127210],"thread-126752":["thread",126752],"thread-125246":["thread",125246],"thread-125051":["thread",125051],"thread-124912":["thread",124912],"thread-124639":["thread",124639],"thread-124604":["thread",124604],"thread-124510":["thread",124510],"thread-124429":["thread",124429],"thread-124427":["thread",124427],"thread-123968":["thread",123968],"thread-123136":["thread",123136],"thread-123001":["thread",123001],"thread-122643":["thread",122643],"thread-122608":["thread",122608],"thread-121990":["thread",121990],"thread-121855":["thread",121855],"thread-121570":["thread",121570],"thread-120765":["thread",120765],"thread-120617":["thread",120617],"thread-120461":["thread",120461],"thread-120460":["thread",120460],"thread-120437":["thread",120437],"thread-119341":["thread",119341],"thread-119209":["thread",119209],"thread-119093":["thread",119093],"thread-119034":["thread",119034],"thread-118361":["thread",118361],"thread-118007":["thread",118007],"thread-117969":["thread",117969],"thread-116464":["thread",116464],"thread-116384":["thread",116384],"thread-114767":["thread",114767],"thread-114660":["thread",114660],"thread-114657":["thread",114657],"thread-114648":["thread",114648],"thread-113951":["thread",113951],"thread-113669":["thread",113669],"thread-113390":["thread",113390],"thread-113191":["thread",113191],"thread-112822":["thread",112822],"thread-112758":["thread",112758],"thread-112433":["thread",112433],"thread-112432":["thread",112432],"thread-112289":["thread",112289],"thread-112039":["thread",112039],"thread-111559":["thread",111559],"thread-111501":["thread",111501],"thread-111461":["thread",111461],"thread-111446":["thread",111446],"thread-111241":["thread",111241],"thread-111174":["thread",111174],"thread-110648":["thread",110648],"thread-110581":["thread",110581],"thread-110535":["thread",110535],"thread-110122":["thread",110122],"thread-110069":["thread",110069],"thread-109778":["thread",109778],"thread-109735":["thread",109735],"thread-109643":["thread",109643],"thread-108752":["thread",108752],"thread-108111":["thread",108111],"thread-107884":["thread",107884],"thread-107702":["thread",107702],"thread-107051":["thread",107051],"thread-107049":["thread",107049],"thread-106942":["thread",106942],"thread-106554":["thread",106554],"thread-106370":["thread",106370],"thread-106116":["thread",106116],"thread-106096":["thread",106096],"thread-106093":["thread",106093],"thread-106038":["thread",106038],"thread-104534":["thread",104534],"thread-104372":["thread",104372],"thread-104276":["thread",104276],"thread-104260":["thread",104260],"thread-104226":["thread",104226],"thread-101865":["thread",101865],"thread-100250":["thread",100250],"thread-99142":["thread",99142],"thread-98146":["thread",98146],"thread-98017":["thread",98017],"thread-96943":["thread",96943],"thread-96333":["thread",96333],"thread-74385":["thread",74385],"thread-67898":["thread",67898],"thread-60869":["thread",60869],"thread-60463":["thread",60463],"thread-56799":["thread",56799]}, , 1716057503
Run Time: 0.000238
- 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