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 (7216417, 7215236, 7215230, 7214334, 7212024, 7209303, 7209278, 7208468, 7206281, 7205507, 7198397, 7195001, 7194636, 7192736, 7192680, 7190826, 7189788, 7189126, 7188284, 7185615, 7185082, 7181006, 7174687, 7174683, 7174616, 7174328, 7174313, 7172632, 7166328, 7165884, 7165763, 7165138, 7158854, 7158784, 7158423, 7158266, 7154655, 7154305, 7154298, 7151280, 7150619, 7149781, 7144570, 7141570, 7140088, 7139498, 7139443, 7138724, 7138660, 7138657, 7138654, 7138637, 7138632, 7138570, 7137857, 7137217, 7135858, 7134641, 7134070, 7131793, 7131776, 7130980, 7130856, 7130291, 7128151, 7124978, 7121400, 7118077, 7115294, 7114829, 7114523, 7113595, 7112277, 7110001, 7108332, 7105601, 7103397, 7102202, 7097157, 7096518, 7095539, 7094289, 7091546, 7085848, 7080928, 7080390, 7080121, 7080082, 7079791, 7079769, 7071583, 7071205, 7071099, 7070700, 7070505, 7069698, 7064322, 7063972, 7062904, 7060619, 7060182, 7059984, 7057516, 7057221, 7056340, 7055397, 7054947, 7054942, 7054019, 7053548, 7053308, 7052868, 7052806, 7052671, 7052486, 7052163, 7051810, 7051299, 7050488, 7050385, 7050020, 7048185, 7048118, 7047436, 7047434, 7047188, 7046542, 7040231, 7040034, 7038412, 7036335, 7023315, 7015346, 7012185, 7011199, 7010997, 7009653, 7006962, 7006912, 7004761, 7003764, 6996978, 6993154, 6989469, 6989134, 6986133, 6986131, 6984897, 6981701, 6979789, 6968123, 6965760, 6962850, 6960787, 6957612, 6957326, 6955439, 6852912, 6509887, 6448663, 236266, 232132, 222489, 215098, 210071, 202882, 201533, 200593, 192117, 191298, 188088, 182880, 171466, 170322, 168758, 166696, 166439, 166378, 13846, 13730, 13339, 13237, 13192, 13010, 12997, 12669, 12624, 12537, 12333, 12303, 12289, 12197, 12111, 12025, 11948, 11580, 11570, 11492, 11434, 11422))
Run Time: 0.010255
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 | 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: 51, 0, 1714386323, {"thread-7216417":["thread",7216417],"thread-7215236":["thread",7215236],"thread-7215230":["thread",7215230],"thread-7214334":["thread",7214334],"thread-7212024":["thread",7212024],"thread-7209303":["thread",7209303],"thread-7209278":["thread",7209278],"thread-7208468":["thread",7208468],"thread-7206281":["thread",7206281],"thread-7205507":["thread",7205507],"thread-7198397":["thread",7198397],"thread-7195001":["thread",7195001],"thread-7194636":["thread",7194636],"thread-7192736":["thread",7192736],"thread-7192680":["thread",7192680],"thread-7190826":["thread",7190826],"thread-7189788":["thread",7189788],"thread-7189126":["thread",7189126],"thread-7188284":["thread",7188284],"thread-7185615":["thread",7185615],"thread-7185082":["thread",7185082],"thread-7181006":["thread",7181006],"thread-7174687":["thread",7174687],"thread-7174683":["thread",7174683],"thread-7174616":["thread",7174616],"thread-7174328":["thread",7174328],"thread-7174313":["thread",7174313],"thread-7172632":["thread",7172632],"thread-7166328":["thread",7166328],"thread-7165884":["thread",7165884],"thread-7165763":["thread",7165763],"thread-7165138":["thread",7165138],"thread-7158854":["thread",7158854],"thread-7158784":["thread",7158784],"thread-7158423":["thread",7158423],"thread-7158266":["thread",7158266],"thread-7154655":["thread",7154655],"thread-7154305":["thread",7154305],"thread-7154298":["thread",7154298],"thread-7151280":["thread",7151280],"thread-7150619":["thread",7150619],"thread-7149781":["thread",7149781],"thread-7144570":["thread",7144570],"thread-7141570":["thread",7141570],"thread-7140088":["thread",7140088],"thread-7139498":["thread",7139498],"thread-7139443":["thread",7139443],"thread-7138724":["thread",7138724],"thread-7138660":["thread",7138660],"thread-7138657":["thread",7138657],"thread-7138654":["thread",7138654],"thread-7138637":["thread",7138637],"thread-7138632":["thread",7138632],"thread-7138570":["thread",7138570],"thread-7137857":["thread",7137857],"thread-7137217":["thread",7137217],"thread-7135858":["thread",7135858],"thread-7134641":["thread",7134641],"thread-7134070":["thread",7134070],"thread-7131793":["thread",7131793],"thread-7131776":["thread",7131776],"thread-7130980":["thread",7130980],"thread-7130856":["thread",7130856],"thread-7130291":["thread",7130291],"thread-7128151":["thread",7128151],"thread-7124978":["thread",7124978],"thread-7121400":["thread",7121400],"thread-7118077":["thread",7118077],"thread-7115294":["thread",7115294],"thread-7114829":["thread",7114829],"thread-7114523":["thread",7114523],"thread-7113595":["thread",7113595],"thread-7112277":["thread",7112277],"thread-7110001":["thread",7110001],"thread-7108332":["thread",7108332],"thread-7105601":["thread",7105601],"thread-7103397":["thread",7103397],"thread-7102202":["thread",7102202],"thread-7097157":["thread",7097157],"thread-7096518":["thread",7096518],"thread-7095539":["thread",7095539],"thread-7094289":["thread",7094289],"thread-7091546":["thread",7091546],"thread-7085848":["thread",7085848],"thread-7080928":["thread",7080928],"thread-7080390":["thread",7080390],"thread-7080121":["thread",7080121],"thread-7080082":["thread",7080082],"thread-7079791":["thread",7079791],"thread-7079769":["thread",7079769],"thread-7071583":["thread",7071583],"thread-7071205":["thread",7071205],"thread-7071099":["thread",7071099],"thread-7070700":["thread",7070700],"thread-7070505":["thread",7070505],"thread-7069698":["thread",7069698],"thread-7064322":["thread",7064322],"thread-7063972":["thread",7063972],"thread-7062904":["thread",7062904],"thread-7060619":["thread",7060619],"thread-7060182":["thread",7060182],"thread-7059984":["thread",7059984],"thread-7057516":["thread",7057516],"thread-7057221":["thread",7057221],"thread-7056340":["thread",7056340],"thread-7055397":["thread",7055397],"thread-7054947":["thread",7054947],"thread-7054942":["thread",7054942],"thread-7054019":["thread",7054019],"thread-7053548":["thread",7053548],"thread-7053308":["thread",7053308],"thread-7052868":["thread",7052868],"thread-7052806":["thread",7052806],"thread-7052671":["thread",7052671],"thread-7052486":["thread",7052486],"thread-7052163":["thread",7052163],"thread-7051810":["thread",7051810],"thread-7051299":["thread",7051299],"thread-7050488":["thread",7050488],"thread-7050385":["thread",7050385],"thread-7050020":["thread",7050020],"thread-7048185":["thread",7048185],"thread-7048118":["thread",7048118],"thread-7047436":["thread",7047436],"thread-7047434":["thread",7047434],"thread-7047188":["thread",7047188],"thread-7046542":["thread",7046542],"thread-7040231":["thread",7040231],"thread-7040034":["thread",7040034],"thread-7038412":["thread",7038412],"thread-7036335":["thread",7036335],"thread-7023315":["thread",7023315],"thread-7015346":["thread",7015346],"thread-7012185":["thread",7012185],"thread-7011199":["thread",7011199],"thread-7010997":["thread",7010997],"thread-7009653":["thread",7009653],"thread-7006962":["thread",7006962],"thread-7006912":["thread",7006912],"thread-7004761":["thread",7004761],"thread-7003764":["thread",7003764],"thread-6996978":["thread",6996978],"thread-6993154":["thread",6993154],"thread-6989469":["thread",6989469],"thread-6989134":["thread",6989134],"thread-6986133":["thread",6986133],"thread-6986131":["thread",6986131],"thread-6984897":["thread",6984897],"thread-6981701":["thread",6981701],"thread-6979789":["thread",6979789],"thread-6968123":["thread",6968123],"thread-6965760":["thread",6965760],"thread-6962850":["thread",6962850],"thread-6960787":["thread",6960787],"thread-6957612":["thread",6957612],"thread-6957326":["thread",6957326],"thread-6955439":["thread",6955439],"thread-6852912":["thread",6852912],"thread-6509887":["thread",6509887],"thread-6448663":["thread",6448663],"thread-236266":["thread",236266],"thread-232132":["thread",232132],"thread-222489":["thread",222489],"thread-215098":["thread",215098],"thread-210071":["thread",210071],"thread-202882":["thread",202882],"thread-201533":["thread",201533],"thread-200593":["thread",200593],"thread-192117":["thread",192117],"thread-191298":["thread",191298],"thread-188088":["thread",188088],"thread-182880":["thread",182880],"thread-171466":["thread",171466],"thread-170322":["thread",170322],"thread-168758":["thread",168758],"thread-166696":["thread",166696],"thread-166439":["thread",166439],"thread-166378":["thread",166378],"thread-13846":["thread",13846],"thread-13730":["thread",13730],"thread-13339":["thread",13339],"thread-13237":["thread",13237],"thread-13192":["thread",13192],"thread-13010":["thread",13010],"thread-12997":["thread",12997],"thread-12669":["thread",12669],"thread-12624":["thread",12624],"thread-12537":["thread",12537],"thread-12333":["thread",12333],"thread-12303":["thread",12303],"thread-12289":["thread",12289],"thread-12197":["thread",12197],"thread-12111":["thread",12111],"thread-12025":["thread",12025],"thread-11948":["thread",11948],"thread-11580":["thread",11580],"thread-11570":["thread",11570],"thread-11492":["thread",11492],"thread-11434":["thread",11434],"thread-11422":["thread",11422]}, NULL, 1714382723
Run Time: 0.000603
- 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