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 (183023, 182734, 182301, 182215, 182208, 182185, 181894, 181885, 181420, 181298, 181086, 180748, 180717, 180670, 180258, 180238, 179759, 179743, 179708, 179704, 179502, 179148, 179053, 179015, 178305, 178257, 177877, 177844, 176148, 176028, 175995, 175480, 175113, 175103, 175007, 174510, 174494, 173245, 173044, 173031, 172990, 172959, 172772, 172726, 171527, 171514, 171506, 170948, 170810, 170794, 170775, 170748, 170732, 170722, 170560, 170547, 170490, 170333, 170264, 170037, 169556, 169292, 169213, 168154, 168144, 167729, 166827, 166800, 165936, 165825, 165504, 165376, 165373, 164171, 163865, 163593, 163431, 163241, 162999, 162658, 162593, 162513, 162359, 161850, 161427, 161082, 160668, 160664, 160535, 160432, 160353, 160329, 160327, 160326, 160238, 160050, 159975, 159617, 159278, 159111, 159110, 158579, 157629, 157129, 156863, 156827, 156650, 156590, 156582, 156294, 156208, 155540, 155030, 154947, 154786, 154715, 154556, 154383, 154212, 153677, 153523, 153495, 152351, 152001, 151847, 151773, 145699, 123395, 116172, 114804, 113819, 113573, 110778, 109100, 107664, 107592, 102581, 102229, 102131, 101522, 99167, 98594, 97974, 97199, 96952, 95224, 95000, 94595, 88168, 88093, 87071, 86988, 86002, 85736, 84160, 83651, 83314, 82924, 82023, 81126, 79804, 79337, 73547, 71480, 70029, 69916, 65851, 64554, 54479, 54437, 54015, 53094, 47640, 42788, 39660, 39658, 34436, 33112, 32972, 32274, 31403, 30790, 24649, 22576, 20522, 12090, 9234, 2920, 2716, 1678, 1356, 814, 743, 494, 311))
Run Time: 0.091504
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 195 | 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: 24, 0, 1715000365, {"thread-183023":["thread",183023],"thread-182734":["thread",182734],"thread-182301":["thread",182301],"thread-182215":["thread",182215],"thread-182208":["thread",182208],"thread-182185":["thread",182185],"thread-181894":["thread",181894],"thread-181885":["thread",181885],"thread-181420":["thread",181420],"thread-181298":["thread",181298],"thread-181086":["thread",181086],"thread-180748":["thread",180748],"thread-180717":["thread",180717],"thread-180670":["thread",180670],"thread-180258":["thread",180258],"thread-180238":["thread",180238],"thread-179759":["thread",179759],"thread-179743":["thread",179743],"thread-179708":["thread",179708],"thread-179704":["thread",179704],"thread-179502":["thread",179502],"thread-179148":["thread",179148],"thread-179053":["thread",179053],"thread-179015":["thread",179015],"thread-178305":["thread",178305],"thread-178257":["thread",178257],"thread-177877":["thread",177877],"thread-177844":["thread",177844],"thread-176148":["thread",176148],"thread-176028":["thread",176028],"thread-175995":["thread",175995],"thread-175480":["thread",175480],"thread-175113":["thread",175113],"thread-175103":["thread",175103],"thread-175007":["thread",175007],"thread-174510":["thread",174510],"thread-174494":["thread",174494],"thread-173245":["thread",173245],"thread-173044":["thread",173044],"thread-173031":["thread",173031],"thread-172990":["thread",172990],"thread-172959":["thread",172959],"thread-172772":["thread",172772],"thread-172726":["thread",172726],"thread-171527":["thread",171527],"thread-171514":["thread",171514],"thread-171506":["thread",171506],"thread-170948":["thread",170948],"thread-170810":["thread",170810],"thread-170794":["thread",170794],"thread-170775":["thread",170775],"thread-170748":["thread",170748],"thread-170732":["thread",170732],"thread-170722":["thread",170722],"thread-170560":["thread",170560],"thread-170547":["thread",170547],"thread-170490":["thread",170490],"thread-170333":["thread",170333],"thread-170264":["thread",170264],"thread-170037":["thread",170037],"thread-169556":["thread",169556],"thread-169292":["thread",169292],"thread-169213":["thread",169213],"thread-168154":["thread",168154],"thread-168144":["thread",168144],"thread-167729":["thread",167729],"ams_article-4731":["ams_article",4731],"thread-166827":["thread",166827],"thread-166800":["thread",166800],"thread-165936":["thread",165936],"thread-165825":["thread",165825],"thread-165504":["thread",165504],"thread-165376":["thread",165376],"thread-165373":["thread",165373],"thread-164171":["thread",164171],"thread-163865":["thread",163865],"thread-163593":["thread",163593],"thread-163431":["thread",163431],"thread-163241":["thread",163241],"thread-162999":["thread",162999],"thread-162658":["thread",162658],"thread-162593":["thread",162593],"thread-162513":["thread",162513],"thread-162359":["thread",162359],"thread-161850":["thread",161850],"thread-161427":["thread",161427],"thread-161082":["thread",161082],"thread-160668":["thread",160668],"thread-160664":["thread",160664],"thread-160535":["thread",160535],"thread-160432":["thread",160432],"thread-160353":["thread",160353],"thread-160329":["thread",160329],"thread-160327":["thread",160327],"thread-160326":["thread",160326],"thread-160238":["thread",160238],"thread-160050":["thread",160050],"thread-159975":["thread",159975],"thread-159617":["thread",159617],"thread-159278":["thread",159278],"thread-159111":["thread",159111],"thread-159110":["thread",159110],"thread-158579":["thread",158579],"thread-157629":["thread",157629],"thread-157129":["thread",157129],"thread-156863":["thread",156863],"thread-156827":["thread",156827],"thread-156650":["thread",156650],"thread-156590":["thread",156590],"thread-156582":["thread",156582],"thread-156294":["thread",156294],"thread-156208":["thread",156208],"thread-155540":["thread",155540],"thread-155030":["thread",155030],"thread-154947":["thread",154947],"thread-154786":["thread",154786],"thread-154715":["thread",154715],"thread-154556":["thread",154556],"thread-154383":["thread",154383],"thread-154212":["thread",154212],"thread-153677":["thread",153677],"thread-153523":["thread",153523],"thread-153495":["thread",153495],"thread-152351":["thread",152351],"thread-152001":["thread",152001],"thread-151847":["thread",151847],"thread-151773":["thread",151773],"thread-145699":["thread",145699],"thread-123395":["thread",123395],"thread-116172":["thread",116172],"thread-114804":["thread",114804],"thread-113819":["thread",113819],"thread-113573":["thread",113573],"thread-110778":["thread",110778],"thread-109100":["thread",109100],"thread-107664":["thread",107664],"thread-107592":["thread",107592],"thread-102581":["thread",102581],"thread-102229":["thread",102229],"thread-102131":["thread",102131],"thread-101522":["thread",101522],"thread-99167":["thread",99167],"thread-98594":["thread",98594],"thread-97974":["thread",97974],"thread-97199":["thread",97199],"thread-96952":["thread",96952],"thread-95224":["thread",95224],"thread-95000":["thread",95000],"thread-94595":["thread",94595],"thread-88168":["thread",88168],"thread-88093":["thread",88093],"thread-87071":["thread",87071],"thread-86988":["thread",86988],"thread-86002":["thread",86002],"thread-85736":["thread",85736],"thread-84160":["thread",84160],"thread-83651":["thread",83651],"thread-83314":["thread",83314],"thread-82924":["thread",82924],"thread-82023":["thread",82023],"thread-81126":["thread",81126],"thread-79804":["thread",79804],"thread-79337":["thread",79337],"thread-73547":["thread",73547],"thread-71480":["thread",71480],"thread-70029":["thread",70029],"thread-65851":["thread",65851],"thread-64554":["thread",64554],"thread-54479":["thread",54479],"thread-54437":["thread",54437],"thread-54015":["thread",54015],"thread-47640":["thread",47640],"thread-42788":["thread",42788],"thread-39660":["thread",39660],"thread-39658":["thread",39658],"thread-34436":["thread",34436],"thread-33112":["thread",33112],"thread-32972":["thread",32972],"thread-32274":["thread",32274],"thread-31403":["thread",31403],"thread-30790":["thread",30790],"thread-24649":["thread",24649],"thread-22576":["thread",22576],"thread-20522":["thread",20522],"thread-12090":["thread",12090],"thread-9234":["thread",9234],"thread-2920":["thread",2920],"thread-2716":["thread",2716],"thread-1678":["thread",1678],"thread-1356":["thread",1356],"thread-814":["thread",814],"thread-743":["thread",743],"thread-494":["thread",494],"thread-311":["thread",311]}, , 1714996765
Run Time: 0.000458
- 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