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 (180932, 169812, 167402, 164806, 163191, 161775, 161013, 160080, 160043, 159952, 159671, 155224, 153836, 152355, 152341, 152039, 151470, 150943, 150870, 150446, 149620, 148351, 148240, 142160, 142158, 141690, 141079, 141071, 140874, 140099, 140084, 138210, 138156, 136405, 136379, 133956, 132306, 130839, 128735, 127441, 126369, 125752, 125498, 124993, 122239, 121200, 119465, 117772, 115693, 115337, 114872, 114114, 114011, 112769, 111309, 111203, 110965, 110764, 110469, 110332, 109949, 109934, 108698, 108675, 108528, 106511, 106462, 104938, 102258, 100776, 99776, 99350, 98471, 96422, 96117, 95999, 95622, 95052, 94994, 94601, 94054, 93702, 93627, 93508, 93405, 93223, 92919, 92636, 92208, 91869, 91794, 91440, 91439, 91438, 91081, 89071, 86735, 85904, 85502, 84772, 84218, 83341, 83338, 82984, 80201, 79291, 79277, 78632, 78573, 77376, 76398, 75955, 74783, 74760, 74640, 74552, 72930, 72924, 72854, 72799, 72317, 70483, 70380, 69975, 69952, 69676, 69590, 68496, 68137, 67370, 67178, 66929, 66922, 66920, 66332, 65542, 65139, 63327, 62273, 58107, 57417, 57168, 56836, 55615, 55612, 54935, 54369, 54249, 54246, 54060, 53780, 53773, 53511, 53141, 52755, 52654, 51655, 51573, 50974, 50968, 50668, 50570, 50481, 50352, 50334, 50282, 50211, 50080, 49909, 49839, 49750, 49592, 48452, 48308, 47777, 47619, 47614, 47548, 47483, 47223, 46358, 43996, 28105, 23165, 21871, 21064, 20202, 17434, 1336))
Run Time: 0.128956
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 189 | 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: 336, 0, 1715151763, {"thread-180932":["thread",180932],"thread-169812":["thread",169812],"thread-167402":["thread",167402],"thread-164806":["thread",164806],"thread-163191":["thread",163191],"thread-161775":["thread",161775],"thread-161013":["thread",161013],"thread-160080":["thread",160080],"thread-160043":["thread",160043],"thread-159952":["thread",159952],"thread-159671":["thread",159671],"thread-155224":["thread",155224],"thread-153836":["thread",153836],"thread-152355":["thread",152355],"thread-152341":["thread",152341],"thread-152039":["thread",152039],"ams_article-3917":["ams_article",3917],"thread-151470":["thread",151470],"thread-150943":["thread",150943],"thread-150870":["thread",150870],"thread-150446":["thread",150446],"thread-149620":["thread",149620],"thread-148351":["thread",148351],"thread-148240":["thread",148240],"thread-142160":["thread",142160],"thread-142158":["thread",142158],"thread-141690":["thread",141690],"thread-141079":["thread",141079],"thread-141071":["thread",141071],"thread-140874":["thread",140874],"thread-140099":["thread",140099],"thread-140084":["thread",140084],"thread-138210":["thread",138210],"thread-138156":["thread",138156],"thread-136405":["thread",136405],"thread-136379":["thread",136379],"thread-133956":["thread",133956],"thread-132306":["thread",132306],"thread-130839":["thread",130839],"thread-128735":["thread",128735],"thread-127441":["thread",127441],"thread-126369":["thread",126369],"thread-125752":["thread",125752],"thread-125498":["thread",125498],"thread-124993":["thread",124993],"thread-122239":["thread",122239],"thread-121200":["thread",121200],"thread-119465":["thread",119465],"thread-117772":["thread",117772],"thread-115693":["thread",115693],"thread-115337":["thread",115337],"thread-114872":["thread",114872],"thread-114114":["thread",114114],"thread-114011":["thread",114011],"thread-112769":["thread",112769],"thread-111309":["thread",111309],"thread-111203":["thread",111203],"thread-110965":["thread",110965],"thread-110764":["thread",110764],"thread-110469":["thread",110469],"thread-110332":["thread",110332],"thread-109949":["thread",109949],"thread-109934":["thread",109934],"thread-108698":["thread",108698],"thread-108675":["thread",108675],"thread-108528":["thread",108528],"thread-106511":["thread",106511],"thread-106462":["thread",106462],"thread-104938":["thread",104938],"thread-102258":["thread",102258],"thread-100776":["thread",100776],"thread-99776":["thread",99776],"thread-99350":["thread",99350],"thread-98471":["thread",98471],"thread-96422":["thread",96422],"thread-96117":["thread",96117],"thread-95999":["thread",95999],"thread-95622":["thread",95622],"thread-95052":["thread",95052],"thread-94994":["thread",94994],"thread-94601":["thread",94601],"thread-94054":["thread",94054],"thread-93702":["thread",93702],"thread-93627":["thread",93627],"thread-93508":["thread",93508],"thread-93405":["thread",93405],"thread-93223":["thread",93223],"thread-92919":["thread",92919],"thread-92636":["thread",92636],"thread-92208":["thread",92208],"thread-91869":["thread",91869],"thread-91794":["thread",91794],"thread-91440":["thread",91440],"thread-91439":["thread",91439],"thread-91438":["thread",91438],"thread-91081":["thread",91081],"thread-89071":["thread",89071],"thread-86735":["thread",86735],"thread-85904":["thread",85904],"thread-85502":["thread",85502],"thread-84772":["thread",84772],"thread-84218":["thread",84218],"thread-83341":["thread",83341],"thread-83338":["thread",83338],"thread-82984":["thread",82984],"thread-80201":["thread",80201],"thread-79291":["thread",79291],"thread-79277":["thread",79277],"thread-78632":["thread",78632],"thread-78573":["thread",78573],"thread-77376":["thread",77376],"thread-76398":["thread",76398],"thread-75955":["thread",75955],"thread-74783":["thread",74783],"thread-74760":["thread",74760],"thread-74640":["thread",74640],"thread-74552":["thread",74552],"thread-72930":["thread",72930],"thread-72924":["thread",72924],"thread-72854":["thread",72854],"thread-72799":["thread",72799],"thread-72317":["thread",72317],"thread-70483":["thread",70483],"thread-70380":["thread",70380],"thread-69975":["thread",69975],"thread-69952":["thread",69952],"thread-69676":["thread",69676],"thread-69590":["thread",69590],"thread-68496":["thread",68496],"thread-68137":["thread",68137],"thread-67370":["thread",67370],"thread-67178":["thread",67178],"thread-66929":["thread",66929],"thread-66922":["thread",66922],"thread-66920":["thread",66920],"thread-66332":["thread",66332],"thread-65542":["thread",65542],"thread-65139":["thread",65139],"thread-63327":["thread",63327],"thread-62273":["thread",62273],"thread-58107":["thread",58107],"thread-57417":["thread",57417],"thread-57168":["thread",57168],"thread-56836":["thread",56836],"thread-55615":["thread",55615],"thread-55612":["thread",55612],"thread-54935":["thread",54935],"thread-54369":["thread",54369],"thread-54249":["thread",54249],"thread-54246":["thread",54246],"thread-54060":["thread",54060],"thread-53780":["thread",53780],"thread-53773":["thread",53773],"thread-53511":["thread",53511],"thread-53141":["thread",53141],"thread-52755":["thread",52755],"thread-52654":["thread",52654],"thread-51655":["thread",51655],"thread-51573":["thread",51573],"thread-50974":["thread",50974],"thread-50968":["thread",50968],"thread-50668":["thread",50668],"thread-50570":["thread",50570],"thread-50481":["thread",50481],"thread-50352":["thread",50352],"thread-50334":["thread",50334],"thread-50282":["thread",50282],"thread-50211":["thread",50211],"thread-50080":["thread",50080],"thread-49909":["thread",49909],"thread-49839":["thread",49839],"thread-49750":["thread",49750],"thread-49592":["thread",49592],"thread-48452":["thread",48452],"thread-48308":["thread",48308],"thread-47777":["thread",47777],"thread-47619":["thread",47619],"thread-47614":["thread",47614],"thread-47548":["thread",47548],"thread-47483":["thread",47483],"thread-47223":["thread",47223],"thread-46358":["thread",46358],"thread-43996":["thread",43996],"thread-28105":["thread",28105],"thread-23165":["thread",23165],"thread-21871":["thread",21871],"thread-21064":["thread",21064],"thread-20202":["thread",20202],"thread-17434":["thread",17434],"thread-1336":["thread",1336]}, , 1715148163
Run Time: 0.000747
- 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