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 (183560, 182870, 182765, 182562, 182344, 182280, 182238, 182094, 181676, 180864, 179361, 178343, 178181, 177573, 176889, 176434, 176257, 176108, 175622, 175527, 175526, 175322, 175122, 174790, 174661, 174025, 173258, 172884, 172421, 171463, 170826, 170134, 169353, 168399, 168303, 168108, 168105, 168104, 167872, 167747, 166249, 166213, 166192, 164592, 163942, 163941, 163872, 163485, 162788, 160852, 160822, 160819, 160734, 160564, 160205, 160155, 159531, 159529, 157891, 157246, 155826, 155008, 154466, 154048, 154017, 152805, 152459, 146101, 145796, 143704, 139394, 138518, 138001, 137788, 137785, 137043, 135389, 134428, 132914, 132562, 131818, 131635, 131175, 131124, 130569, 130154, 129124, 128774, 128625, 128278, 127263, 124880, 124786, 122899, 122344, 122057, 121472, 120521, 120026, 119960, 118874, 118873, 118709, 117392, 112204, 111697, 109951, 109107, 108855, 107951, 105209, 104546, 103471, 103430, 103368, 103108, 103099, 101747, 100097, 99977, 97320, 97047, 95723, 95147, 91152, 91144, 90683, 81599, 80309, 76713, 68888, 68864, 68085, 65681, 64255, 62361, 58980, 50075, 49883, 46782, 46671, 33597, 24973, 12743, 12467, 5009, 423))
Run Time: 0.112457
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 147 | 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: 1279, 0, 1716033758, {"thread-183560":["thread",183560],"thread-182870":["thread",182870],"thread-182765":["thread",182765],"thread-182562":["thread",182562],"thread-182344":["thread",182344],"thread-182280":["thread",182280],"thread-182238":["thread",182238],"thread-182094":["thread",182094],"thread-181676":["thread",181676],"thread-180864":["thread",180864],"thread-179361":["thread",179361],"thread-178343":["thread",178343],"thread-178181":["thread",178181],"thread-177573":["thread",177573],"thread-176889":["thread",176889],"thread-176434":["thread",176434],"thread-176257":["thread",176257],"thread-176108":["thread",176108],"thread-175622":["thread",175622],"thread-175527":["thread",175527],"thread-175526":["thread",175526],"thread-175322":["thread",175322],"thread-175122":["thread",175122],"thread-174790":["thread",174790],"thread-174661":["thread",174661],"thread-174025":["thread",174025],"thread-173258":["thread",173258],"thread-172884":["thread",172884],"thread-172421":["thread",172421],"thread-171463":["thread",171463],"thread-170826":["thread",170826],"thread-170134":["thread",170134],"thread-169353":["thread",169353],"thread-168399":["thread",168399],"thread-168303":["thread",168303],"thread-168108":["thread",168108],"thread-168105":["thread",168105],"thread-168104":["thread",168104],"thread-167872":["thread",167872],"thread-167747":["thread",167747],"thread-166249":["thread",166249],"thread-166213":["thread",166213],"thread-166192":["thread",166192],"thread-164592":["thread",164592],"thread-163942":["thread",163942],"thread-163941":["thread",163941],"thread-163872":["thread",163872],"thread-163485":["thread",163485],"thread-162788":["thread",162788],"thread-160852":["thread",160852],"thread-160822":["thread",160822],"thread-160819":["thread",160819],"thread-160734":["thread",160734],"thread-160564":["thread",160564],"thread-160205":["thread",160205],"thread-160155":["thread",160155],"thread-159531":["thread",159531],"thread-159529":["thread",159529],"thread-157891":["thread",157891],"thread-157246":["thread",157246],"thread-155826":["thread",155826],"thread-155008":["thread",155008],"thread-154466":["thread",154466],"thread-154048":["thread",154048],"thread-154017":["thread",154017],"thread-152805":["thread",152805],"thread-152459":["thread",152459],"thread-146101":["thread",146101],"thread-145796":["thread",145796],"thread-143704":["thread",143704],"thread-139394":["thread",139394],"thread-138518":["thread",138518],"thread-138001":["thread",138001],"thread-137788":["thread",137788],"thread-137785":["thread",137785],"thread-137043":["thread",137043],"thread-135389":["thread",135389],"thread-134428":["thread",134428],"thread-132914":["thread",132914],"thread-132562":["thread",132562],"thread-131818":["thread",131818],"thread-131635":["thread",131635],"thread-131175":["thread",131175],"thread-131124":["thread",131124],"thread-130569":["thread",130569],"thread-130154":["thread",130154],"thread-129124":["thread",129124],"thread-128774":["thread",128774],"thread-128625":["thread",128625],"thread-128278":["thread",128278],"thread-127263":["thread",127263],"thread-124880":["thread",124880],"thread-124786":["thread",124786],"thread-122899":["thread",122899],"thread-122344":["thread",122344],"thread-122057":["thread",122057],"thread-121472":["thread",121472],"thread-120521":["thread",120521],"thread-120026":["thread",120026],"thread-119960":["thread",119960],"thread-118874":["thread",118874],"thread-118873":["thread",118873],"thread-118709":["thread",118709],"thread-117392":["thread",117392],"thread-112204":["thread",112204],"thread-111697":["thread",111697],"thread-109951":["thread",109951],"thread-109107":["thread",109107],"thread-108855":["thread",108855],"thread-107951":["thread",107951],"thread-105209":["thread",105209],"thread-104546":["thread",104546],"thread-103471":["thread",103471],"thread-103430":["thread",103430],"thread-103368":["thread",103368],"thread-103108":["thread",103108],"thread-103099":["thread",103099],"thread-101747":["thread",101747],"thread-100097":["thread",100097],"thread-99977":["thread",99977],"thread-97320":["thread",97320],"thread-97047":["thread",97047],"thread-95723":["thread",95723],"thread-95147":["thread",95147],"thread-91152":["thread",91152],"thread-91144":["thread",91144],"thread-90683":["thread",90683],"thread-81599":["thread",81599],"thread-80309":["thread",80309],"thread-76713":["thread",76713],"thread-68888":["thread",68888],"thread-68864":["thread",68864],"thread-68085":["thread",68085],"thread-65681":["thread",65681],"thread-64255":["thread",64255],"thread-62361":["thread",62361],"thread-58980":["thread",58980],"thread-50075":["thread",50075],"thread-49883":["thread",49883],"thread-46782":["thread",46782],"thread-46671":["thread",46671],"thread-33597":["thread",33597],"thread-24973":["thread",24973],"thread-12743":["thread",12743],"thread-12467":["thread",12467],"thread-5009":["thread",5009],"thread-423":["thread",423]}, , 1716030158
Run Time: 0.000869
- 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