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 (7215115, 7214689, 7213772, 7211730, 7210650, 7209508, 7209176, 7208819, 7205251, 7205198, 7201476, 7200595, 7198756, 7197619, 7194019, 7193828, 7192926, 7190222, 7188940, 7188578, 7187345, 7185822, 7185163, 7185127, 7184051, 7183444, 7183025, 7182772, 7182151, 7179598, 7179163, 7177499, 7177310, 7177308, 7176093, 7175295, 7174943, 7173754, 7172484, 7171808, 7171487, 7170204, 7169794, 7169705, 7166138, 7163894, 7163333, 7161429, 7157215, 7155873, 7155095, 7154952, 7154022, 7154014, 7151249, 7150200, 7150174, 7146908, 7144015, 7143162, 7139650, 7137753, 7137322, 7137033, 7137004, 7136563, 7136143, 7135177, 7134740, 7134532, 7132876, 7132295, 7129449, 7129255, 7125537, 7124100, 7123231, 7118490, 7118144, 7117456, 7117211, 7116537, 7114735, 7114571, 7113630, 7111834, 7111169, 7109653, 7107655, 7105795, 7104754, 7104288, 7103603, 7103223, 7102978, 7102971, 7101942, 7099130, 7098536, 7098247, 7097025, 7096561, 7096136, 7093098, 7092537, 7090546, 7089059, 7089035, 7088404, 7088398, 7087899, 7087884, 7087883, 7087073, 7086174, 7082750, 7080471, 7077184, 7076409, 7076139, 7074230, 7071642, 7071526, 7067329, 7066759, 7065405, 7064608, 7064303, 7060615, 7055658, 7055270, 7052866, 7049053, 7048562, 7047554, 7037363, 7036107, 7035944, 7018967, 7016196, 7008946, 7004780, 6996719, 6994021, 6992612, 6983349, 6982032, 6981300, 6978992, 6973808, 6973648, 6973481, 6970398, 6964898, 6964555, 6962109, 6961994, 6864773, 6852936, 6822170, 6576481, 6388894, 6281142, 242631, 239614, 234568, 210688, 199617, 186685, 185978, 185724, 162740, 160205, 159465, 13817, 13728, 13707, 13581, 13540, 13501, 13483, 13406, 13365, 13352, 13335, 13331, 13215, 13129, 13071, 13069, 12960, 12943, 12911, 12900, 12882, 12879, 12860, 12844, 12842))
Run Time: 0.010297
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 199 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,production_xf.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 1430
- 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 2870
- 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 138
- 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 2487
- XF\App->run() in src/XF.php at line 524
- 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: 186, 0, 1714260172, {"thread-7215115":["thread",7215115],"thread-7214689":["thread",7214689],"thread-7213772":["thread",7213772],"thread-7211730":["thread",7211730],"thread-7210650":["thread",7210650],"thread-7209508":["thread",7209508],"thread-7209176":["thread",7209176],"thread-7208819":["thread",7208819],"thread-7205251":["thread",7205251],"thread-7205198":["thread",7205198],"thread-7201476":["thread",7201476],"thread-7200595":["thread",7200595],"thread-7198756":["thread",7198756],"thread-7197619":["thread",7197619],"thread-7194019":["thread",7194019],"thread-7193828":["thread",7193828],"thread-7192926":["thread",7192926],"thread-7190222":["thread",7190222],"thread-7188940":["thread",7188940],"thread-7188578":["thread",7188578],"thread-7187345":["thread",7187345],"thread-7185822":["thread",7185822],"thread-7185163":["thread",7185163],"thread-7185127":["thread",7185127],"thread-7184051":["thread",7184051],"thread-7183444":["thread",7183444],"thread-7183025":["thread",7183025],"thread-7182772":["thread",7182772],"thread-7182151":["thread",7182151],"thread-7179598":["thread",7179598],"thread-7179163":["thread",7179163],"thread-7177499":["thread",7177499],"thread-7177310":["thread",7177310],"thread-7177308":["thread",7177308],"thread-7176093":["thread",7176093],"thread-7175295":["thread",7175295],"thread-7174943":["thread",7174943],"thread-7173754":["thread",7173754],"thread-7172484":["thread",7172484],"thread-7171808":["thread",7171808],"thread-7171487":["thread",7171487],"thread-7170204":["thread",7170204],"thread-7169794":["thread",7169794],"thread-7169705":["thread",7169705],"thread-7166138":["thread",7166138],"thread-7163894":["thread",7163894],"thread-7163333":["thread",7163333],"thread-7161429":["thread",7161429],"thread-7157215":["thread",7157215],"thread-7155873":["thread",7155873],"thread-7155095":["thread",7155095],"thread-7154952":["thread",7154952],"thread-7154022":["thread",7154022],"thread-7154014":["thread",7154014],"thread-7151249":["thread",7151249],"thread-7150200":["thread",7150200],"thread-7150174":["thread",7150174],"thread-7146908":["thread",7146908],"thread-7144015":["thread",7144015],"thread-7143162":["thread",7143162],"thread-7139650":["thread",7139650],"thread-7137753":["thread",7137753],"thread-7137322":["thread",7137322],"thread-7137033":["thread",7137033],"thread-7137004":["thread",7137004],"thread-7136563":["thread",7136563],"thread-7136143":["thread",7136143],"thread-7135177":["thread",7135177],"thread-7134740":["thread",7134740],"thread-7134532":["thread",7134532],"thread-7132876":["thread",7132876],"thread-7132295":["thread",7132295],"thread-7129449":["thread",7129449],"thread-7129255":["thread",7129255],"thread-7125537":["thread",7125537],"thread-7124100":["thread",7124100],"thread-7123231":["thread",7123231],"thread-7118490":["thread",7118490],"thread-7118144":["thread",7118144],"thread-7117456":["thread",7117456],"thread-7117211":["thread",7117211],"thread-7116537":["thread",7116537],"thread-7114735":["thread",7114735],"thread-7114571":["thread",7114571],"thread-7113630":["thread",7113630],"thread-7111834":["thread",7111834],"thread-7111169":["thread",7111169],"thread-7109653":["thread",7109653],"thread-7107655":["thread",7107655],"thread-7105795":["thread",7105795],"thread-7104754":["thread",7104754],"thread-7104288":["thread",7104288],"thread-7103603":["thread",7103603],"thread-7103223":["thread",7103223],"thread-7102978":["thread",7102978],"thread-7102971":["thread",7102971],"thread-7101942":["thread",7101942],"thread-7099130":["thread",7099130],"thread-7098536":["thread",7098536],"thread-7098247":["thread",7098247],"thread-7097025":["thread",7097025],"thread-7096561":["thread",7096561],"thread-7096136":["thread",7096136],"thread-7093098":["thread",7093098],"thread-7092537":["thread",7092537],"thread-7090546":["thread",7090546],"thread-7089059":["thread",7089059],"thread-7089035":["thread",7089035],"thread-7088404":["thread",7088404],"thread-7088398":["thread",7088398],"thread-7087899":["thread",7087899],"thread-7087884":["thread",7087884],"thread-7087883":["thread",7087883],"thread-7087073":["thread",7087073],"thread-7086174":["thread",7086174],"thread-7082750":["thread",7082750],"thread-7080471":["thread",7080471],"thread-7077184":["thread",7077184],"thread-7076409":["thread",7076409],"thread-7076139":["thread",7076139],"thread-7074230":["thread",7074230],"thread-7071642":["thread",7071642],"thread-7071526":["thread",7071526],"thread-7067329":["thread",7067329],"thread-7066759":["thread",7066759],"thread-7065405":["thread",7065405],"thread-7064608":["thread",7064608],"thread-7064303":["thread",7064303],"thread-7060615":["thread",7060615],"thread-7055658":["thread",7055658],"thread-7055270":["thread",7055270],"thread-7052866":["thread",7052866],"xfmg_media-3615":["xfmg_media",3615],"thread-7049053":["thread",7049053],"thread-7048562":["thread",7048562],"thread-7047554":["thread",7047554],"thread-7037363":["thread",7037363],"thread-7036107":["thread",7036107],"thread-7035944":["thread",7035944],"thread-7018967":["thread",7018967],"thread-7016196":["thread",7016196],"thread-7008946":["thread",7008946],"thread-7004780":["thread",7004780],"thread-6996719":["thread",6996719],"thread-6994021":["thread",6994021],"thread-6992612":["thread",6992612],"thread-6983349":["thread",6983349],"thread-6982032":["thread",6982032],"thread-6981300":["thread",6981300],"thread-6978992":["thread",6978992],"thread-6973808":["thread",6973808],"thread-6973648":["thread",6973648],"thread-6973481":["thread",6973481],"thread-6970398":["thread",6970398],"thread-6964898":["thread",6964898],"thread-6964555":["thread",6964555],"thread-6962109":["thread",6962109],"thread-6961994":["thread",6961994],"thread-6864773":["thread",6864773],"thread-6852936":["thread",6852936],"thread-6822170":["thread",6822170],"thread-6576481":["thread",6576481],"thread-6388894":["thread",6388894],"thread-6281142":["thread",6281142],"thread-242631":["thread",242631],"thread-239614":["thread",239614],"thread-234568":["thread",234568],"thread-210688":["thread",210688],"thread-199617":["thread",199617],"thread-186685":["thread",186685],"thread-185978":["thread",185978],"thread-185724":["thread",185724],"thread-162740":["thread",162740],"thread-160205":["thread",160205],"thread-159465":["thread",159465],"thread-13817":["thread",13817],"thread-13728":["thread",13728],"thread-13707":["thread",13707],"thread-13581":["thread",13581],"thread-13540":["thread",13540],"thread-13501":["thread",13501],"thread-13483":["thread",13483],"thread-13406":["thread",13406],"thread-13365":["thread",13365],"thread-13352":["thread",13352],"thread-13335":["thread",13335],"thread-13331":["thread",13331],"thread-13215":["thread",13215],"thread-13129":["thread",13129],"thread-13071":["thread",13071],"thread-13069":["thread",13069],"thread-12960":["thread",12960],"thread-12943":["thread",12943],"thread-12911":["thread",12911],"thread-12900":["thread",12900],"thread-12882":["thread",12882],"thread-12879":["thread",12879],"thread-12860":["thread",12860],"thread-12844":["thread",12844],"thread-12842":["thread",12842]}, NULL, 1714256572
Run Time: 0.000703
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20