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, 7216113, 7215803, 7215402, 7215269, 7214679, 7214334, 7213347, 7213078, 7212951, 7209278, 7207652, 7204879, 7204617, 7202831, 7201899, 7201783, 7200981, 7198793, 7198532, 7195894, 7195864, 7192335, 7192135, 7190159, 7189736, 7188558, 7185925, 7184759, 7184633, 7184531, 7184059, 7181465, 7180710, 7180375, 7180209, 7179498, 7178719, 7177539, 7177537, 7177536, 7177532, 7177048, 7175914, 7174936, 7173939, 7171433, 7169484, 7167935, 7167016, 7162682, 7160440, 7159360, 7156704, 7153934, 7152781, 7151203, 7150000, 7148424, 7147930, 7145264, 7144693, 7144258, 7143607, 7142520, 7140337, 7140132, 7139999, 7139542, 7136844, 7136034, 7135432, 7133732, 7133297, 7132525, 7132295, 7132241, 7130922, 7130917, 7130128, 7129994, 7129741, 7129520, 7127773, 7124925, 7124374, 7122295, 7120543, 7120492, 7120008, 7119984, 7118065, 7115142, 7114609, 7114220, 7113630, 7112416, 7112407, 7110551, 7108884, 7108803, 7107618, 7107445, 7106788, 7104032, 7101028, 7098509, 7097767, 7091690, 7091490, 7090579, 7090029, 7088761, 7088730, 7086819, 7085216, 7082750, 7080758, 7080528, 7079769, 7078429, 7077859, 7072653, 7067167, 7065743, 7065466, 7063627, 7059201, 7057302, 7056341, 7047565, 7047562, 7046105, 7044954, 7044316, 7030089, 7029390, 7028887, 7026975, 7024010, 7023398, 7019271, 7017061, 7014297, 7013231, 7012837, 7010843, 7007422, 7003171, 6997696, 6990634, 6978008, 6975360, 6973231, 236878, 232534, 223504, 222245, 193323, 192776, 189088, 188198, 182839, 176461, 176331, 162333, 162328, 160186, 13845, 13788, 13277, 13183, 12952, 12861, 12826, 12556, 12367, 12203, 12006, 11890, 11550, 11478, 11351, 11008, 10829, 10598, 10469, 10442, 10372, 10236, 10118, 10029, 9974, 9846, 9494, 9448, 9301, 9227, 9118))
Run Time: 0.009896
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: 654, 0, 1714894659, {"thread-7216417":["thread",7216417],"thread-7216113":["thread",7216113],"thread-7215803":["thread",7215803],"thread-7215402":["thread",7215402],"thread-7215269":["thread",7215269],"thread-7214679":["thread",7214679],"thread-7214334":["thread",7214334],"thread-7213347":["thread",7213347],"thread-7213078":["thread",7213078],"thread-7212951":["thread",7212951],"thread-7209278":["thread",7209278],"thread-7207652":["thread",7207652],"thread-7204879":["thread",7204879],"thread-7204617":["thread",7204617],"thread-7202831":["thread",7202831],"thread-7201899":["thread",7201899],"thread-7201783":["thread",7201783],"thread-7200981":["thread",7200981],"thread-7198793":["thread",7198793],"thread-7198532":["thread",7198532],"thread-7195894":["thread",7195894],"thread-7195864":["thread",7195864],"thread-7192335":["thread",7192335],"thread-7192135":["thread",7192135],"thread-7190159":["thread",7190159],"thread-7189736":["thread",7189736],"thread-7188558":["thread",7188558],"thread-7185925":["thread",7185925],"thread-7184759":["thread",7184759],"thread-7184633":["thread",7184633],"thread-7184531":["thread",7184531],"thread-7184059":["thread",7184059],"thread-7181465":["thread",7181465],"thread-7180710":["thread",7180710],"thread-7180375":["thread",7180375],"thread-7180209":["thread",7180209],"thread-7179498":["thread",7179498],"thread-7178719":["thread",7178719],"thread-7177539":["thread",7177539],"thread-7177537":["thread",7177537],"thread-7177536":["thread",7177536],"thread-7177532":["thread",7177532],"thread-7177048":["thread",7177048],"thread-7175914":["thread",7175914],"thread-7174936":["thread",7174936],"thread-7173939":["thread",7173939],"thread-7171433":["thread",7171433],"thread-7169484":["thread",7169484],"thread-7167935":["thread",7167935],"thread-7167016":["thread",7167016],"thread-7162682":["thread",7162682],"thread-7160440":["thread",7160440],"thread-7159360":["thread",7159360],"thread-7156704":["thread",7156704],"thread-7153934":["thread",7153934],"thread-7152781":["thread",7152781],"thread-7151203":["thread",7151203],"thread-7150000":["thread",7150000],"thread-7148424":["thread",7148424],"thread-7147930":["thread",7147930],"thread-7145264":["thread",7145264],"thread-7144693":["thread",7144693],"thread-7144258":["thread",7144258],"thread-7143607":["thread",7143607],"thread-7142520":["thread",7142520],"thread-7140337":["thread",7140337],"thread-7140132":["thread",7140132],"thread-7139999":["thread",7139999],"thread-7139542":["thread",7139542],"thread-7136844":["thread",7136844],"thread-7136034":["thread",7136034],"thread-7135432":["thread",7135432],"thread-7133732":["thread",7133732],"thread-7133297":["thread",7133297],"thread-7132525":["thread",7132525],"thread-7132295":["thread",7132295],"thread-7132241":["thread",7132241],"thread-7130922":["thread",7130922],"thread-7130917":["thread",7130917],"thread-7130128":["thread",7130128],"thread-7129994":["thread",7129994],"thread-7129741":["thread",7129741],"thread-7129520":["thread",7129520],"thread-7127773":["thread",7127773],"thread-7124925":["thread",7124925],"thread-7124374":["thread",7124374],"thread-7122295":["thread",7122295],"thread-7120543":["thread",7120543],"thread-7120492":["thread",7120492],"thread-7120008":["thread",7120008],"thread-7119984":["thread",7119984],"thread-7118065":["thread",7118065],"thread-7115142":["thread",7115142],"thread-7114609":["thread",7114609],"thread-7114220":["thread",7114220],"thread-7113630":["thread",7113630],"thread-7112416":["thread",7112416],"thread-7112407":["thread",7112407],"thread-7110551":["thread",7110551],"thread-7108884":["thread",7108884],"thread-7108803":["thread",7108803],"thread-7107618":["thread",7107618],"thread-7107445":["thread",7107445],"thread-7106788":["thread",7106788],"thread-7104032":["thread",7104032],"thread-7101028":["thread",7101028],"thread-7098509":["thread",7098509],"thread-7097767":["thread",7097767],"thread-7091690":["thread",7091690],"thread-7091490":["thread",7091490],"thread-7090579":["thread",7090579],"thread-7090029":["thread",7090029],"thread-7088761":["thread",7088761],"thread-7088730":["thread",7088730],"thread-7086819":["thread",7086819],"thread-7085216":["thread",7085216],"thread-7082750":["thread",7082750],"thread-7080758":["thread",7080758],"thread-7080528":["thread",7080528],"thread-7079769":["thread",7079769],"thread-7078429":["thread",7078429],"thread-7077859":["thread",7077859],"thread-7072653":["thread",7072653],"thread-7067167":["thread",7067167],"thread-7065743":["thread",7065743],"thread-7065466":["thread",7065466],"thread-7063627":["thread",7063627],"thread-7059201":["thread",7059201],"thread-7057302":["thread",7057302],"thread-7056341":["thread",7056341],"thread-7047565":["thread",7047565],"thread-7047562":["thread",7047562],"thread-7046105":["thread",7046105],"thread-7044954":["thread",7044954],"thread-7044316":["thread",7044316],"thread-7030089":["thread",7030089],"thread-7029390":["thread",7029390],"thread-7028887":["thread",7028887],"thread-7026975":["thread",7026975],"thread-7024010":["thread",7024010],"thread-7023398":["thread",7023398],"thread-7019271":["thread",7019271],"thread-7017061":["thread",7017061],"thread-7014297":["thread",7014297],"thread-7013231":["thread",7013231],"thread-7012837":["thread",7012837],"thread-7010843":["thread",7010843],"thread-7007422":["thread",7007422],"thread-7003171":["thread",7003171],"thread-6997696":["thread",6997696],"thread-6990634":["thread",6990634],"thread-6978008":["thread",6978008],"thread-6975360":["thread",6975360],"thread-6973231":["thread",6973231],"xfmg_media-1665":["xfmg_media",1665],"thread-236878":["thread",236878],"thread-232534":["thread",232534],"thread-223504":["thread",223504],"thread-222245":["thread",222245],"thread-193323":["thread",193323],"thread-192776":["thread",192776],"thread-189088":["thread",189088],"thread-188198":["thread",188198],"thread-182839":["thread",182839],"thread-176461":["thread",176461],"thread-176331":["thread",176331],"thread-162333":["thread",162333],"thread-162328":["thread",162328],"thread-160186":["thread",160186],"thread-13845":["thread",13845],"thread-13788":["thread",13788],"thread-13277":["thread",13277],"thread-13183":["thread",13183],"thread-12952":["thread",12952],"thread-12861":["thread",12861],"thread-12826":["thread",12826],"thread-12556":["thread",12556],"thread-12367":["thread",12367],"thread-12203":["thread",12203],"thread-12006":["thread",12006],"thread-11890":["thread",11890],"thread-11550":["thread",11550],"thread-11478":["thread",11478],"thread-11351":["thread",11351],"thread-11008":["thread",11008],"thread-10829":["thread",10829],"thread-10598":["thread",10598],"thread-10469":["thread",10469],"thread-10442":["thread",10442],"thread-10372":["thread",10372],"thread-10236":["thread",10236],"thread-10118":["thread",10118],"thread-10029":["thread",10029],"thread-9974":["thread",9974],"thread-9846":["thread",9846],"thread-9494":["thread",9494],"thread-9448":["thread",9448],"thread-9301":["thread",9301],"thread-9227":["thread",9227],"thread-9118":["thread",9118]}, NULL, 1714891059
Run Time: 0.000529
- 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