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 (182955, 182766, 182493, 181944, 181294, 181194, 181093, 178306, 178148, 177853, 176327, 175586, 173727, 169178, 166724, 166564, 166503, 166430, 166406, 165418, 165379, 164622, 164109, 163010, 162564, 162126, 161366, 159368, 159257, 159256, 158040, 157795, 157145, 156474, 156417, 156286, 155841, 155398, 154323, 152533, 152368, 152007, 140163, 140095, 136711, 136577, 136539, 135783, 134680, 134169, 132136, 131643, 131396, 131113, 131050, 130879, 129984, 129794, 129741, 129714, 129712, 129621, 129409, 127755, 127190, 127136, 126504, 125172, 125167, 125128, 124934, 124922, 124475, 124134, 124086, 124009, 123930, 123869, 123788, 123672, 123617, 123125, 123000, 122894, 122884, 122442, 121940, 121664, 121662, 121380, 120068, 119743, 119718, 119281, 118959, 118916, 118849, 118771, 118742, 118158, 117564, 117465, 117207, 117150, 115516, 114788, 114438, 114353, 113577, 112918, 112915, 112294, 111735, 111713, 111695, 111683, 111660, 111321, 110999, 110944, 110495, 110467, 109005, 108894, 107727, 107306, 106781, 106437, 106254, 106062, 105796, 105664, 105663, 105324, 105071, 104617, 104428, 104232, 103678, 103383, 103231, 103170, 101867, 98422, 98327, 97538, 95155, 92606, 92523, 90431, 90284, 89436, 87082, 86273, 86025, 85664, 85571, 84829, 83764, 81098, 78688, 78412, 78012, 74253, 74180, 73367, 73362, 69102, 66482, 65394, 64739, 61403, 58000, 57213, 56643, 56350, 56330, 56304, 54735, 49577, 48774, 48302, 46483, 46056, 45923))
Run Time: 0.100526
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 185 | 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: 6779, 0, 1715082698, {"thread-182955":["thread",182955],"thread-182766":["thread",182766],"thread-182493":["thread",182493],"thread-181944":["thread",181944],"thread-181294":["thread",181294],"thread-181194":["thread",181194],"thread-181093":["thread",181093],"thread-178306":["thread",178306],"thread-178148":["thread",178148],"thread-177853":["thread",177853],"thread-176327":["thread",176327],"thread-175586":["thread",175586],"thread-173727":["thread",173727],"thread-169178":["thread",169178],"thread-166724":["thread",166724],"thread-166564":["thread",166564],"thread-166503":["thread",166503],"thread-166430":["thread",166430],"thread-166406":["thread",166406],"thread-165418":["thread",165418],"thread-165379":["thread",165379],"thread-164109":["thread",164109],"thread-163010":["thread",163010],"thread-162564":["thread",162564],"thread-162126":["thread",162126],"thread-161366":["thread",161366],"thread-159368":["thread",159368],"thread-159257":["thread",159257],"thread-159256":["thread",159256],"thread-158040":["thread",158040],"thread-157795":["thread",157795],"thread-157145":["thread",157145],"thread-156474":["thread",156474],"thread-156417":["thread",156417],"thread-156286":["thread",156286],"thread-155841":["thread",155841],"thread-155398":["thread",155398],"thread-154323":["thread",154323],"thread-152533":["thread",152533],"thread-152368":["thread",152368],"thread-152007":["thread",152007],"thread-140163":["thread",140163],"thread-140095":["thread",140095],"thread-136711":["thread",136711],"thread-136577":["thread",136577],"thread-136539":["thread",136539],"thread-135783":["thread",135783],"thread-134680":["thread",134680],"thread-134169":["thread",134169],"thread-132136":["thread",132136],"thread-131643":["thread",131643],"thread-131396":["thread",131396],"thread-131113":["thread",131113],"thread-131050":["thread",131050],"thread-130879":["thread",130879],"thread-129984":["thread",129984],"thread-129794":["thread",129794],"thread-129741":["thread",129741],"thread-129714":["thread",129714],"thread-129712":["thread",129712],"thread-129621":["thread",129621],"thread-129409":["thread",129409],"thread-127755":["thread",127755],"thread-127190":["thread",127190],"thread-127136":["thread",127136],"thread-126504":["thread",126504],"thread-125172":["thread",125172],"thread-125167":["thread",125167],"thread-125128":["thread",125128],"thread-124934":["thread",124934],"thread-124922":["thread",124922],"thread-124475":["thread",124475],"thread-124134":["thread",124134],"thread-124086":["thread",124086],"thread-124009":["thread",124009],"thread-123930":["thread",123930],"thread-123869":["thread",123869],"thread-123788":["thread",123788],"thread-123672":["thread",123672],"thread-123617":["thread",123617],"thread-123125":["thread",123125],"thread-123000":["thread",123000],"thread-122894":["thread",122894],"thread-122884":["thread",122884],"thread-122442":["thread",122442],"thread-121940":["thread",121940],"thread-121664":["thread",121664],"thread-121662":["thread",121662],"thread-121380":["thread",121380],"thread-120068":["thread",120068],"thread-119743":["thread",119743],"thread-119718":["thread",119718],"thread-119281":["thread",119281],"thread-118959":["thread",118959],"thread-118916":["thread",118916],"thread-118849":["thread",118849],"thread-118771":["thread",118771],"thread-118742":["thread",118742],"thread-118158":["thread",118158],"thread-117564":["thread",117564],"thread-117465":["thread",117465],"thread-117207":["thread",117207],"thread-117150":["thread",117150],"thread-115516":["thread",115516],"thread-114788":["thread",114788],"thread-114438":["thread",114438],"thread-114353":["thread",114353],"thread-113577":["thread",113577],"thread-112918":["thread",112918],"thread-112915":["thread",112915],"thread-112294":["thread",112294],"thread-111735":["thread",111735],"thread-111713":["thread",111713],"thread-111695":["thread",111695],"thread-111683":["thread",111683],"thread-111660":["thread",111660],"thread-111321":["thread",111321],"thread-110999":["thread",110999],"thread-110944":["thread",110944],"thread-110495":["thread",110495],"thread-110467":["thread",110467],"thread-109005":["thread",109005],"thread-108894":["thread",108894],"thread-107727":["thread",107727],"thread-107306":["thread",107306],"thread-106781":["thread",106781],"thread-106437":["thread",106437],"thread-106254":["thread",106254],"thread-106062":["thread",106062],"thread-105796":["thread",105796],"thread-105664":["thread",105664],"thread-105663":["thread",105663],"thread-105324":["thread",105324],"thread-105071":["thread",105071],"thread-104617":["thread",104617],"thread-104428":["thread",104428],"thread-104232":["thread",104232],"thread-103678":["thread",103678],"thread-103383":["thread",103383],"thread-103231":["thread",103231],"thread-103170":["thread",103170],"thread-101867":["thread",101867],"thread-98422":["thread",98422],"thread-98327":["thread",98327],"thread-97538":["thread",97538],"thread-95155":["thread",95155],"thread-92606":["thread",92606],"thread-92523":["thread",92523],"thread-90431":["thread",90431],"thread-90284":["thread",90284],"thread-89436":["thread",89436],"thread-87082":["thread",87082],"thread-86273":["thread",86273],"thread-86025":["thread",86025],"thread-85664":["thread",85664],"thread-85571":["thread",85571],"thread-84829":["thread",84829],"thread-83764":["thread",83764],"thread-81098":["thread",81098],"thread-78688":["thread",78688],"thread-78412":["thread",78412],"thread-78012":["thread",78012],"thread-74253":["thread",74253],"thread-74180":["thread",74180],"thread-73367":["thread",73367],"thread-73362":["thread",73362],"thread-69102":["thread",69102],"thread-66482":["thread",66482],"thread-65394":["thread",65394],"thread-64739":["thread",64739],"thread-61403":["thread",61403],"thread-58000":["thread",58000],"thread-57213":["thread",57213],"thread-56643":["thread",56643],"thread-56350":["thread",56350],"thread-56330":["thread",56330],"thread-56304":["thread",56304],"thread-54735":["thread",54735],"thread-49577":["thread",49577],"thread-48774":["thread",48774],"thread-48302":["thread",48302],"thread-46483":["thread",46483],"thread-46056":["thread",46056],"thread-45923":["thread",45923]}, , 1715079098
Run Time: 0.002682
- 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