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 (182539, 182355, 181749, 181718, 181333, 181095, 180981, 180769, 180765, 180310, 180072, 179919, 178876, 178660, 178586, 178551, 178232, 178182, 178180, 178178, 178177, 177853, 176873, 176474, 176473, 175880, 175602, 175580, 172701, 172306, 170509, 169785, 169548, 168647, 167856, 167115, 166435, 166217, 165938, 164898, 164416, 164352, 164157, 164148, 163902, 163823, 163820, 163783, 163720, 163521, 163381, 163361, 162126, 161826, 161509, 161245, 159749, 159470, 159389, 159257, 159219, 157926, 157821, 157372, 156950, 156600, 155839, 155499, 155297, 153845, 152673, 152368, 138954, 131808, 131367, 129030, 129005, 128985, 128821, 128769, 128735, 128430, 127490, 127427, 126680, 126654, 126617, 126444, 125992, 125969, 125874, 125838, 125836, 125281, 125089, 125000, 124458, 123176, 122985, 121395, 119567, 119521, 119465, 119444, 118639, 118638, 118060, 118057, 115357, 114872, 114587, 113090, 112329, 111816, 110661, 107947, 107292, 107105, 106922, 106812, 105467, 104799, 104632, 104579, 104329, 104177, 103628, 103160, 103149, 103125, 103106, 103075, 103056, 103040, 102434, 102388, 102275, 102248, 102062, 101797, 101781, 101276, 100902, 100310, 98381, 97499, 97242, 96819, 96231, 95839, 95661, 95622, 95582, 95510, 94438, 94396, 94322, 94074, 94049, 93925, 93431, 93405, 93229, 93167, 92914, 92633, 91881, 91812, 91513, 91414, 91229, 91036, 90712, 90623, 90553, 90217, 89749, 89107, 87360, 87342, 86401, 86255, 86091, 86078, 86042, 86025, 85999, 85996, 85847, 85794, 85791, 85776, 85478, 85475, 85256, 85154, 84926, 84726, 83175, 83148))
Run Time: 0.099660
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | 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: 2265, 0, 1714374151, {"thread-182539":["thread",182539],"thread-182355":["thread",182355],"thread-181749":["thread",181749],"thread-181718":["thread",181718],"thread-181333":["thread",181333],"thread-181095":["thread",181095],"thread-180981":["thread",180981],"thread-180769":["thread",180769],"thread-180765":["thread",180765],"thread-180310":["thread",180310],"thread-180072":["thread",180072],"thread-179919":["thread",179919],"thread-178876":["thread",178876],"thread-178660":["thread",178660],"thread-178586":["thread",178586],"thread-178551":["thread",178551],"thread-178232":["thread",178232],"thread-178182":["thread",178182],"thread-178180":["thread",178180],"thread-178178":["thread",178178],"thread-178177":["thread",178177],"thread-177853":["thread",177853],"thread-176873":["thread",176873],"thread-176474":["thread",176474],"thread-176473":["thread",176473],"thread-175880":["thread",175880],"thread-175602":["thread",175602],"thread-175580":["thread",175580],"thread-172701":["thread",172701],"thread-172306":["thread",172306],"thread-170509":["thread",170509],"thread-169785":["thread",169785],"thread-169548":["thread",169548],"thread-168647":["thread",168647],"thread-167856":["thread",167856],"thread-167115":["thread",167115],"thread-166435":["thread",166435],"thread-166217":["thread",166217],"thread-165938":["thread",165938],"thread-164898":["thread",164898],"thread-164416":["thread",164416],"thread-164352":["thread",164352],"thread-164157":["thread",164157],"thread-164148":["thread",164148],"thread-163902":["thread",163902],"thread-163823":["thread",163823],"thread-163820":["thread",163820],"thread-163783":["thread",163783],"thread-163720":["thread",163720],"thread-163521":["thread",163521],"thread-163381":["thread",163381],"thread-163361":["thread",163361],"thread-162126":["thread",162126],"thread-161826":["thread",161826],"thread-161509":["thread",161509],"thread-161245":["thread",161245],"thread-159749":["thread",159749],"thread-159470":["thread",159470],"thread-159389":["thread",159389],"thread-159257":["thread",159257],"thread-159219":["thread",159219],"thread-157926":["thread",157926],"thread-157821":["thread",157821],"thread-157372":["thread",157372],"thread-156950":["thread",156950],"thread-155839":["thread",155839],"thread-155499":["thread",155499],"thread-155297":["thread",155297],"thread-153845":["thread",153845],"thread-152673":["thread",152673],"thread-152368":["thread",152368],"thread-138954":["thread",138954],"thread-131808":["thread",131808],"thread-131367":["thread",131367],"thread-129030":["thread",129030],"thread-129005":["thread",129005],"thread-128985":["thread",128985],"thread-128821":["thread",128821],"thread-128769":["thread",128769],"thread-128735":["thread",128735],"thread-128430":["thread",128430],"thread-127490":["thread",127490],"thread-127427":["thread",127427],"thread-126680":["thread",126680],"thread-126654":["thread",126654],"thread-126617":["thread",126617],"thread-126444":["thread",126444],"thread-125992":["thread",125992],"thread-125969":["thread",125969],"thread-125874":["thread",125874],"thread-125838":["thread",125838],"thread-125836":["thread",125836],"thread-125281":["thread",125281],"thread-125089":["thread",125089],"thread-125000":["thread",125000],"thread-124458":["thread",124458],"thread-123176":["thread",123176],"thread-122985":["thread",122985],"thread-121395":["thread",121395],"thread-119567":["thread",119567],"thread-119521":["thread",119521],"thread-119465":["thread",119465],"thread-119444":["thread",119444],"thread-118639":["thread",118639],"thread-118638":["thread",118638],"thread-118060":["thread",118060],"thread-118057":["thread",118057],"thread-115357":["thread",115357],"thread-114872":["thread",114872],"thread-114587":["thread",114587],"thread-113090":["thread",113090],"thread-112329":["thread",112329],"thread-111816":["thread",111816],"thread-110661":["thread",110661],"thread-107947":["thread",107947],"thread-107292":["thread",107292],"thread-107105":["thread",107105],"thread-106922":["thread",106922],"thread-106812":["thread",106812],"thread-105467":["thread",105467],"thread-104799":["thread",104799],"thread-104632":["thread",104632],"thread-104579":["thread",104579],"thread-104329":["thread",104329],"thread-104177":["thread",104177],"thread-103628":["thread",103628],"thread-103160":["thread",103160],"thread-103149":["thread",103149],"thread-103125":["thread",103125],"thread-103106":["thread",103106],"thread-103075":["thread",103075],"thread-103056":["thread",103056],"thread-103040":["thread",103040],"thread-102434":["thread",102434],"thread-102388":["thread",102388],"thread-102275":["thread",102275],"thread-102248":["thread",102248],"thread-102062":["thread",102062],"thread-101797":["thread",101797],"thread-101781":["thread",101781],"thread-101276":["thread",101276],"thread-100902":["thread",100902],"thread-100310":["thread",100310],"thread-98381":["thread",98381],"thread-97499":["thread",97499],"thread-97242":["thread",97242],"thread-96819":["thread",96819],"thread-96231":["thread",96231],"thread-95839":["thread",95839],"thread-95661":["thread",95661],"thread-95622":["thread",95622],"thread-95582":["thread",95582],"thread-95510":["thread",95510],"thread-94438":["thread",94438],"thread-94396":["thread",94396],"thread-94322":["thread",94322],"thread-94074":["thread",94074],"thread-94049":["thread",94049],"thread-93925":["thread",93925],"thread-93431":["thread",93431],"thread-93405":["thread",93405],"thread-93229":["thread",93229],"thread-93167":["thread",93167],"thread-92914":["thread",92914],"thread-92633":["thread",92633],"thread-91881":["thread",91881],"thread-91812":["thread",91812],"thread-91513":["thread",91513],"thread-91414":["thread",91414],"thread-91229":["thread",91229],"thread-91036":["thread",91036],"thread-90712":["thread",90712],"thread-90623":["thread",90623],"thread-90553":["thread",90553],"thread-90217":["thread",90217],"thread-89749":["thread",89749],"thread-89107":["thread",89107],"thread-87360":["thread",87360],"thread-87342":["thread",87342],"thread-86401":["thread",86401],"thread-86255":["thread",86255],"thread-86091":["thread",86091],"thread-86078":["thread",86078],"thread-86042":["thread",86042],"thread-86025":["thread",86025],"thread-85999":["thread",85999],"thread-85996":["thread",85996],"thread-85847":["thread",85847],"thread-85794":["thread",85794],"thread-85791":["thread",85791],"thread-85776":["thread",85776],"thread-85478":["thread",85478],"thread-85475":["thread",85475],"thread-85256":["thread",85256],"thread-85154":["thread",85154],"thread-84926":["thread",84926],"thread-84726":["thread",84726],"thread-83175":["thread",83175],"thread-83148":["thread",83148]}, , 1714370551
Run Time: 0.000459
- 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