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 (183498, 183496, 183285, 183116, 183067, 183042, 183038, 181801, 181702, 181638, 181613, 181506, 181106, 180620, 179827, 178381, 178145, 178144, 175828, 172327, 171933, 171613, 171537, 169594, 169416, 168507, 167885, 167108, 166861, 164331, 164163, 163893, 163108, 162799, 162028, 161971, 159019, 158997, 158815, 158812, 158792, 158693, 158638, 158600, 158102, 158101, 157857, 157854, 157101, 156461, 156441, 156269, 156242, 156230, 156170, 155656, 155449, 155170, 155168, 154404, 154012, 153945, 153906, 153886, 153828, 153813, 153733, 153534, 153527, 153526, 153521, 153493, 153235, 153230, 153163, 152915, 152669, 152237, 152200, 151714, 151114, 151113, 148378, 147999, 147424, 146353, 146061, 143567, 140336, 140082, 139442, 139389, 139294, 139254, 138865, 138328, 137844, 137012, 133818, 133244, 129607, 129285, 129135, 129132, 129068, 128674, 128459, 128243, 128142, 128071, 127863, 127815, 127734, 127728, 127535, 127479, 127442, 127328, 127270, 127222, 127156, 127067, 126933, 126506, 126296, 125212, 124908, 124365, 123319, 123140, 123092, 123069, 123019, 122919, 122918, 122895, 122590, 122588, 122581, 122350, 121922, 121582, 121057, 120991, 120959, 120691, 120399, 120396, 119062, 115967, 114930, 114528, 113138, 112774, 112111, 111583, 110992, 108167, 106588, 106523, 105200, 104882, 104881, 104876, 104700, 104588, 104499, 104478, 104137, 104135, 104081, 103929, 103635, 103545, 103103, 103093, 102972, 101992, 101828, 101486, 101485, 101483, 101157, 101107, 101079, 101078, 101077, 101049, 101047, 101043, 99337, 98338, 98325, 97979))
Run Time: 0.110149
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 194 | 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: 199, 0, 1715957870, {"thread-183498":["thread",183498],"thread-183285":["thread",183285],"thread-183067":["thread",183067],"thread-183042":["thread",183042],"thread-183038":["thread",183038],"thread-181801":["thread",181801],"thread-181638":["thread",181638],"thread-181613":["thread",181613],"thread-181506":["thread",181506],"thread-181106":["thread",181106],"thread-180620":["thread",180620],"thread-179827":["thread",179827],"thread-178381":["thread",178381],"ams_article-5150":["ams_article",5150],"thread-178145":["thread",178145],"thread-178144":["thread",178144],"thread-175828":["thread",175828],"thread-172327":["thread",172327],"thread-171933":["thread",171933],"thread-171613":["thread",171613],"thread-171537":["thread",171537],"thread-169594":["thread",169594],"thread-169416":["thread",169416],"ams_article-4796":["ams_article",4796],"thread-168507":["thread",168507],"thread-167885":["thread",167885],"thread-167108":["thread",167108],"thread-166861":["thread",166861],"thread-164331":["thread",164331],"thread-164163":["thread",164163],"thread-163893":["thread",163893],"thread-163108":["thread",163108],"thread-162799":["thread",162799],"thread-162028":["thread",162028],"thread-161971":["thread",161971],"thread-159019":["thread",159019],"thread-158997":["thread",158997],"thread-158815":["thread",158815],"thread-158812":["thread",158812],"thread-158792":["thread",158792],"thread-158693":["thread",158693],"thread-158600":["thread",158600],"thread-158102":["thread",158102],"thread-158101":["thread",158101],"thread-157857":["thread",157857],"thread-157854":["thread",157854],"thread-157101":["thread",157101],"thread-156461":["thread",156461],"thread-156441":["thread",156441],"thread-156269":["thread",156269],"thread-156242":["thread",156242],"thread-156230":["thread",156230],"thread-155656":["thread",155656],"thread-155449":["thread",155449],"thread-155170":["thread",155170],"thread-155168":["thread",155168],"thread-154404":["thread",154404],"thread-154012":["thread",154012],"thread-153945":["thread",153945],"thread-153906":["thread",153906],"thread-153886":["thread",153886],"thread-153828":["thread",153828],"thread-153813":["thread",153813],"thread-153733":["thread",153733],"thread-153534":["thread",153534],"thread-153527":["thread",153527],"thread-153526":["thread",153526],"thread-153521":["thread",153521],"thread-153493":["thread",153493],"thread-153235":["thread",153235],"thread-153163":["thread",153163],"thread-152915":["thread",152915],"thread-152669":["thread",152669],"thread-152237":["thread",152237],"thread-152200":["thread",152200],"thread-151714":["thread",151714],"ams_article-3880":["ams_article",3880],"thread-151114":["thread",151114],"thread-151113":["thread",151113],"thread-148378":["thread",148378],"thread-147999":["thread",147999],"thread-147424":["thread",147424],"thread-146353":["thread",146353],"thread-146061":["thread",146061],"ams_article-3479":["ams_article",3479],"thread-143567":["thread",143567],"thread-140336":["thread",140336],"thread-140082":["thread",140082],"ams_article-3130":["ams_article",3130],"ams_article-3129":["ams_article",3129],"thread-139442":["thread",139442],"thread-139389":["thread",139389],"thread-139294":["thread",139294],"thread-139254":["thread",139254],"thread-138865":["thread",138865],"thread-138328":["thread",138328],"thread-137844":["thread",137844],"thread-137012":["thread",137012],"thread-133818":["thread",133818],"thread-133244":["thread",133244],"thread-129607":["thread",129607],"thread-129285":["thread",129285],"thread-129135":["thread",129135],"thread-129132":["thread",129132],"thread-129068":["thread",129068],"thread-128674":["thread",128674],"thread-128459":["thread",128459],"thread-128243":["thread",128243],"thread-128142":["thread",128142],"thread-128071":["thread",128071],"thread-127863":["thread",127863],"thread-127815":["thread",127815],"thread-127734":["thread",127734],"thread-127728":["thread",127728],"thread-127535":["thread",127535],"thread-127479":["thread",127479],"thread-127442":["thread",127442],"thread-127328":["thread",127328],"thread-127270":["thread",127270],"thread-127222":["thread",127222],"thread-127156":["thread",127156],"thread-127067":["thread",127067],"thread-126933":["thread",126933],"thread-126506":["thread",126506],"thread-126296":["thread",126296],"thread-125212":["thread",125212],"thread-124908":["thread",124908],"thread-124365":["thread",124365],"thread-123319":["thread",123319],"thread-123140":["thread",123140],"thread-123092":["thread",123092],"thread-123069":["thread",123069],"thread-123019":["thread",123019],"thread-122919":["thread",122919],"thread-122918":["thread",122918],"thread-122895":["thread",122895],"thread-122590":["thread",122590],"thread-122588":["thread",122588],"thread-122581":["thread",122581],"thread-122350":["thread",122350],"thread-121922":["thread",121922],"thread-121582":["thread",121582],"thread-121057":["thread",121057],"thread-120991":["thread",120991],"thread-120959":["thread",120959],"thread-120691":["thread",120691],"thread-120399":["thread",120399],"thread-120396":["thread",120396],"thread-119062":["thread",119062],"thread-115967":["thread",115967],"thread-114930":["thread",114930],"thread-114528":["thread",114528],"thread-113138":["thread",113138],"thread-112774":["thread",112774],"thread-112111":["thread",112111],"thread-111583":["thread",111583],"thread-110992":["thread",110992],"thread-108167":["thread",108167],"thread-106588":["thread",106588],"thread-106523":["thread",106523],"thread-105200":["thread",105200],"thread-104882":["thread",104882],"thread-104881":["thread",104881],"thread-104876":["thread",104876],"thread-104700":["thread",104700],"thread-104588":["thread",104588],"thread-104499":["thread",104499],"thread-104478":["thread",104478],"thread-104137":["thread",104137],"thread-104135":["thread",104135],"thread-104081":["thread",104081],"thread-103929":["thread",103929],"thread-103635":["thread",103635],"thread-103545":["thread",103545],"thread-103103":["thread",103103],"thread-103093":["thread",103093],"thread-102972":["thread",102972],"thread-101992":["thread",101992],"thread-101828":["thread",101828],"thread-101486":["thread",101486],"thread-101485":["thread",101485],"thread-101483":["thread",101483],"thread-101157":["thread",101157],"thread-101107":["thread",101107],"thread-101079":["thread",101079],"thread-101078":["thread",101078],"thread-101077":["thread",101077],"thread-101049":["thread",101049],"thread-101047":["thread",101047],"thread-101043":["thread",101043],"thread-99337":["thread",99337],"thread-98338":["thread",98338],"thread-98325":["thread",98325],"thread-97979":["thread",97979]}, , 1715954270
Run Time: 0.000723
- 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