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 (182934, 182818, 182337, 182205, 182130, 182124, 182061, 181925, 181609, 181556, 181501, 181491, 181408, 181372, 181355, 181306, 181245, 181232, 181056, 180921, 180905, 180904, 180853, 180818, 180688, 180589, 180516, 180515, 180502, 180488, 180339, 180298, 180210, 180172, 180108, 180105, 179888, 179796, 179404, 179351, 179089, 179057, 179046, 179005, 179003, 179002, 178732, 178730, 178704, 178694, 178329, 178287, 178061, 177880, 177851, 177717, 177680, 177151, 177037, 177012, 176754, 176713, 176581, 176513, 176472, 176433, 176432, 176313, 176309, 176244, 176239, 176205, 176107, 176060, 176058, 176055, 176054, 176041, 176006, 176002, 175993, 175984, 175973, 175940, 175908, 175834, 175761, 175669, 175661, 175660, 175497, 175489, 175485, 175481, 175473, 175464, 175462, 175460, 175453, 175449, 175446, 175444, 175442, 175441, 175436, 175358, 175356, 175342, 175336, 175309, 175308, 175307, 175297, 175277, 175274, 175241, 175236, 175202, 175173, 175148, 175144, 175129, 175052, 174872, 174854, 174108, 173921, 173920, 173808, 173642, 173526, 173503, 173126, 173095, 172691, 172491, 172382, 171836, 171664, 171471, 171464, 171448, 171309, 171299, 171153, 170707, 170639, 170617, 170292, 170271, 170246, 170067, 169884, 169772, 169742, 169735, 169721, 169720, 169677, 169126, 169056, 169005, 168998, 168985, 168748, 168712, 168567, 168552, 168547, 168313))
Run Time: 0.066051
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 170 | 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: 5870, 0, 1714376330, {"thread-182934":["thread",182934],"thread-182818":["thread",182818],"thread-182337":["thread",182337],"thread-182205":["thread",182205],"thread-182130":["thread",182130],"thread-182124":["thread",182124],"ams_article-5307":["ams_article",5307],"ams_article-5305":["ams_article",5305],"thread-182061":["thread",182061],"thread-181925":["thread",181925],"tl_group-376":["tl_group",376],"thread-181609":["thread",181609],"thread-181556":["thread",181556],"thread-181501":["thread",181501],"thread-181491":["thread",181491],"thread-181408":["thread",181408],"thread-181355":["thread",181355],"thread-181306":["thread",181306],"thread-181245":["thread",181245],"thread-181232":["thread",181232],"thread-181056":["thread",181056],"thread-180921":["thread",180921],"ams_article-5250":["ams_article",5250],"thread-180905":["thread",180905],"thread-180904":["thread",180904],"thread-180853":["thread",180853],"thread-180818":["thread",180818],"thread-180688":["thread",180688],"thread-180589":["thread",180589],"thread-180516":["thread",180516],"thread-180515":["thread",180515],"thread-180502":["thread",180502],"thread-180488":["thread",180488],"thread-180339":["thread",180339],"thread-180298":["thread",180298],"thread-180210":["thread",180210],"thread-180172":["thread",180172],"thread-180108":["thread",180108],"thread-180105":["thread",180105],"thread-179888":["thread",179888],"thread-179796":["thread",179796],"thread-179404":["thread",179404],"thread-179351":["thread",179351],"thread-179089":["thread",179089],"thread-179057":["thread",179057],"thread-179046":["thread",179046],"thread-179005":["thread",179005],"thread-179003":["thread",179003],"thread-179002":["thread",179002],"thread-178732":["thread",178732],"thread-178730":["thread",178730],"thread-178704":["thread",178704],"thread-178694":["thread",178694],"tl_group-336":["tl_group",336],"thread-178329":["thread",178329],"thread-178287":["thread",178287],"tl_group-332":["tl_group",332],"thread-178061":["thread",178061],"thread-177880":["thread",177880],"thread-177851":["thread",177851],"thread-177717":["thread",177717],"thread-177680":["thread",177680],"thread-177151":["thread",177151],"thread-177037":["thread",177037],"thread-177012":["thread",177012],"ams_article-5125":["ams_article",5125],"thread-176713":["thread",176713],"thread-176581":["thread",176581],"thread-176513":["thread",176513],"thread-176472":["thread",176472],"thread-176433":["thread",176433],"thread-176432":["thread",176432],"thread-176313":["thread",176313],"thread-176309":["thread",176309],"thread-176244":["thread",176244],"thread-176239":["thread",176239],"thread-176205":["thread",176205],"thread-176107":["thread",176107],"thread-176060":["thread",176060],"thread-176058":["thread",176058],"thread-176055":["thread",176055],"thread-176054":["thread",176054],"thread-176041":["thread",176041],"thread-176006":["thread",176006],"thread-176002":["thread",176002],"thread-175993":["thread",175993],"thread-175984":["thread",175984],"thread-175973":["thread",175973],"tl_group-316":["tl_group",316],"thread-175940":["thread",175940],"thread-175908":["thread",175908],"thread-175834":["thread",175834],"thread-175761":["thread",175761],"ams_article-5083":["ams_article",5083],"thread-175669":["thread",175669],"thread-175661":["thread",175661],"thread-175660":["thread",175660],"ams_article-5078":["ams_article",5078],"thread-175497":["thread",175497],"thread-175489":["thread",175489],"thread-175485":["thread",175485],"thread-175481":["thread",175481],"thread-175473":["thread",175473],"thread-175464":["thread",175464],"thread-175462":["thread",175462],"thread-175460":["thread",175460],"thread-175453":["thread",175453],"thread-175449":["thread",175449],"thread-175446":["thread",175446],"thread-175444":["thread",175444],"thread-175442":["thread",175442],"thread-175441":["thread",175441],"ams_article-5076":["ams_article",5076],"thread-175436":["thread",175436],"thread-175358":["thread",175358],"thread-175356":["thread",175356],"thread-175342":["thread",175342],"thread-175336":["thread",175336],"ams_article-5075":["ams_article",5075],"ams_article-5074":["ams_article",5074],"thread-175309":["thread",175309],"thread-175308":["thread",175308],"thread-175307":["thread",175307],"thread-175297":["thread",175297],"thread-175277":["thread",175277],"thread-175274":["thread",175274],"thread-175241":["thread",175241],"thread-175236":["thread",175236],"thread-175202":["thread",175202],"thread-175173":["thread",175173],"thread-175148":["thread",175148],"thread-175144":["thread",175144],"thread-175129":["thread",175129],"thread-175052":["thread",175052],"ams_article-5058":["ams_article",5058],"thread-174872":["thread",174872],"thread-174854":["thread",174854],"ams_article-4985":["ams_article",4985],"thread-174108":["thread",174108],"thread-173921":["thread",173921],"thread-173920":["thread",173920],"thread-173808":["thread",173808],"thread-173642":["thread",173642],"thread-173526":["thread",173526],"thread-173503":["thread",173503],"thread-173126":["thread",173126],"thread-173095":["thread",173095],"thread-172691":["thread",172691],"thread-172491":["thread",172491],"thread-172382":["thread",172382],"thread-171836":["thread",171836],"thread-171471":["thread",171471],"thread-171464":["thread",171464],"thread-171448":["thread",171448],"thread-171309":["thread",171309],"thread-171299":["thread",171299],"thread-171153":["thread",171153],"thread-170707":["thread",170707],"thread-170639":["thread",170639],"thread-170617":["thread",170617],"thread-170292":["thread",170292],"thread-170271":["thread",170271],"thread-170246":["thread",170246],"thread-170067":["thread",170067],"tl_group-266":["tl_group",266],"thread-169884":["thread",169884],"thread-169772":["thread",169772],"thread-169742":["thread",169742],"thread-169735":["thread",169735],"thread-169721":["thread",169721],"thread-169720":["thread",169720],"thread-169677":["thread",169677],"thread-169126":["thread",169126],"thread-169056":["thread",169056],"thread-169005":["thread",169005],"thread-168998":["thread",168998],"thread-168985":["thread",168985],"thread-168748":["thread",168748],"thread-168712":["thread",168712],"thread-168567":["thread",168567],"thread-168552":["thread",168552],"thread-168547":["thread",168547],"thread-168313":["thread",168313]}, , 1714372730
Run Time: 0.000605
- 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