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 (115192, 114943, 113488, 112730, 112695, 112492, 111581, 110799, 110687, 110556, 109396, 107984, 107603, 107296, 104916, 104737, 104717, 104457, 103599, 102254, 102122, 101811, 101696, 101462, 101207, 101206, 101093, 100090, 99528, 99190, 99022, 98691, 97839, 97557, 95031, 94979, 93969, 93936, 93498, 92859, 92444, 91963, 91605, 91440, 90386, 90002, 89738, 89661, 89498, 89306, 89191, 89116, 84975, 84669, 82991, 82538, 82251, 80843, 80841, 80422, 80221, 80144, 78578, 78036, 77988, 77484, 76828, 76577, 76371, 75793, 75778, 75700, 75115, 74643, 74021, 72345, 71560, 67234, 64223, 63964, 63198, 62805, 62532, 62422, 62404, 62145, 61963, 61430, 61415, 60919, 60510, 60414, 60214, 59979, 58751, 57372, 56988, 56118, 54186, 53513, 53277, 53216, 53177, 51607, 49322, 49265, 48972, 47357, 47057, 46790, 46742, 46537, 45186, 44928, 44543, 43769, 43310, 43112, 43039, 42292, 42048, 41738, 41557, 41254, 41219, 40765, 40568, 40434, 40302, 39855, 38821, 38651, 38360, 37996, 37938, 37722, 37368, 36995, 36991, 36404, 36357, 36294, 34742, 34460, 33806, 33523, 33511, 32948, 32851, 32639, 32596, 32195, 31668, 30942, 30348, 30275, 30122, 29561, 29365, 28483, 28440, 28208, 28079, 27942, 27706, 27563, 26992, 25438, 25076, 25058, 24688, 24599, 24481, 24362, 24023, 23761, 23715, 23683, 23357, 23336, 22761, 22543, 22220, 21374, 21356, 21336, 21111, 20209, 19590, 19532, 19516, 19317, 18863, 17506, 17304, 17168, 16805, 16383, 16283, 16149))
Run Time: 0.163406
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: 9239, 0, 1716043330, {"thread-115192":["thread",115192],"thread-114943":["thread",114943],"thread-113488":["thread",113488],"thread-112730":["thread",112730],"thread-112695":["thread",112695],"thread-112492":["thread",112492],"thread-111581":["thread",111581],"thread-110799":["thread",110799],"thread-110687":["thread",110687],"thread-110556":["thread",110556],"thread-109396":["thread",109396],"thread-107984":["thread",107984],"thread-107603":["thread",107603],"thread-107296":["thread",107296],"thread-104916":["thread",104916],"thread-104737":["thread",104737],"thread-104717":["thread",104717],"thread-104457":["thread",104457],"thread-103599":["thread",103599],"thread-102254":["thread",102254],"thread-102122":["thread",102122],"thread-101811":["thread",101811],"thread-101696":["thread",101696],"thread-101462":["thread",101462],"thread-101207":["thread",101207],"thread-101206":["thread",101206],"thread-101093":["thread",101093],"thread-100090":["thread",100090],"thread-99528":["thread",99528],"thread-99190":["thread",99190],"thread-99022":["thread",99022],"thread-98691":["thread",98691],"thread-97839":["thread",97839],"thread-97557":["thread",97557],"thread-95031":["thread",95031],"thread-94979":["thread",94979],"thread-93969":["thread",93969],"thread-93936":["thread",93936],"thread-93498":["thread",93498],"thread-92859":["thread",92859],"thread-92444":["thread",92444],"thread-91963":["thread",91963],"thread-91605":["thread",91605],"thread-91440":["thread",91440],"thread-90386":["thread",90386],"thread-90002":["thread",90002],"thread-89738":["thread",89738],"thread-89661":["thread",89661],"thread-89498":["thread",89498],"thread-89306":["thread",89306],"thread-89191":["thread",89191],"thread-89116":["thread",89116],"thread-84975":["thread",84975],"thread-84669":["thread",84669],"thread-82991":["thread",82991],"thread-82538":["thread",82538],"thread-82251":["thread",82251],"thread-80843":["thread",80843],"thread-80841":["thread",80841],"thread-80422":["thread",80422],"thread-80221":["thread",80221],"thread-80144":["thread",80144],"thread-78578":["thread",78578],"thread-78036":["thread",78036],"thread-77988":["thread",77988],"thread-77484":["thread",77484],"thread-76828":["thread",76828],"thread-76577":["thread",76577],"thread-76371":["thread",76371],"thread-75793":["thread",75793],"thread-75778":["thread",75778],"thread-75700":["thread",75700],"thread-75115":["thread",75115],"thread-74643":["thread",74643],"thread-74021":["thread",74021],"thread-72345":["thread",72345],"thread-71560":["thread",71560],"thread-67234":["thread",67234],"thread-64223":["thread",64223],"thread-63964":["thread",63964],"thread-63198":["thread",63198],"thread-62805":["thread",62805],"thread-62532":["thread",62532],"thread-62422":["thread",62422],"thread-62404":["thread",62404],"thread-62145":["thread",62145],"thread-61963":["thread",61963],"thread-61430":["thread",61430],"thread-61415":["thread",61415],"thread-60919":["thread",60919],"thread-60510":["thread",60510],"thread-60414":["thread",60414],"thread-60214":["thread",60214],"thread-59979":["thread",59979],"thread-58751":["thread",58751],"thread-57372":["thread",57372],"thread-56988":["thread",56988],"thread-56118":["thread",56118],"thread-54186":["thread",54186],"thread-53513":["thread",53513],"thread-53277":["thread",53277],"thread-53216":["thread",53216],"thread-53177":["thread",53177],"thread-51607":["thread",51607],"thread-49322":["thread",49322],"thread-49265":["thread",49265],"thread-48972":["thread",48972],"thread-47357":["thread",47357],"thread-47057":["thread",47057],"thread-46790":["thread",46790],"thread-46742":["thread",46742],"thread-46537":["thread",46537],"thread-45186":["thread",45186],"thread-44928":["thread",44928],"thread-44543":["thread",44543],"thread-43769":["thread",43769],"thread-43310":["thread",43310],"thread-43112":["thread",43112],"thread-43039":["thread",43039],"thread-42292":["thread",42292],"thread-42048":["thread",42048],"thread-41738":["thread",41738],"thread-41557":["thread",41557],"thread-41254":["thread",41254],"thread-41219":["thread",41219],"thread-40765":["thread",40765],"thread-40568":["thread",40568],"thread-40434":["thread",40434],"thread-40302":["thread",40302],"thread-39855":["thread",39855],"thread-38821":["thread",38821],"thread-38651":["thread",38651],"thread-38360":["thread",38360],"thread-37996":["thread",37996],"thread-37938":["thread",37938],"thread-37722":["thread",37722],"thread-37368":["thread",37368],"thread-36995":["thread",36995],"thread-36991":["thread",36991],"thread-36404":["thread",36404],"thread-36357":["thread",36357],"thread-36294":["thread",36294],"thread-34742":["thread",34742],"thread-34460":["thread",34460],"thread-33806":["thread",33806],"thread-33523":["thread",33523],"thread-33511":["thread",33511],"thread-32948":["thread",32948],"thread-32851":["thread",32851],"thread-32639":["thread",32639],"thread-32596":["thread",32596],"thread-32195":["thread",32195],"thread-31668":["thread",31668],"thread-30942":["thread",30942],"thread-30348":["thread",30348],"thread-30275":["thread",30275],"thread-30122":["thread",30122],"thread-29561":["thread",29561],"thread-29365":["thread",29365],"thread-28483":["thread",28483],"thread-28440":["thread",28440],"thread-28208":["thread",28208],"thread-28079":["thread",28079],"thread-27942":["thread",27942],"thread-27706":["thread",27706],"thread-27563":["thread",27563],"thread-26992":["thread",26992],"thread-25438":["thread",25438],"thread-25076":["thread",25076],"thread-25058":["thread",25058],"thread-24688":["thread",24688],"thread-24599":["thread",24599],"thread-24481":["thread",24481],"thread-24362":["thread",24362],"thread-24023":["thread",24023],"thread-23761":["thread",23761],"thread-23715":["thread",23715],"thread-23683":["thread",23683],"thread-23357":["thread",23357],"thread-23336":["thread",23336],"thread-22761":["thread",22761],"thread-22543":["thread",22543],"thread-22220":["thread",22220],"thread-21374":["thread",21374],"thread-21356":["thread",21356],"thread-21336":["thread",21336],"thread-21111":["thread",21111],"thread-20209":["thread",20209],"thread-19590":["thread",19590],"thread-19532":["thread",19532],"thread-19516":["thread",19516],"thread-19317":["thread",19317],"thread-18863":["thread",18863],"thread-17506":["thread",17506],"thread-17304":["thread",17304],"thread-17168":["thread",17168],"thread-16805":["thread",16805],"thread-16383":["thread",16383],"thread-16283":["thread",16283],"thread-16149":["thread",16149]}, , 1716039730
Run Time: 0.001835
- 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