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 (7217327, 7217322, 7217294, 7217232, 7216454, 7216099, 7215342, 7215185, 7214368, 7212939, 7212350, 7212291, 7209617, 7208944, 7208126, 7208003, 7207922, 7207736, 7207527, 7206580, 7205999, 7205527, 7205193, 7202855, 7199560, 7199543, 7199005, 7198854, 7196576, 7195863, 7194064, 7193822, 7191516, 7190238, 7190022, 7188461, 7188455, 7188098, 7186945, 7185681, 7185112, 7184710, 7184651, 7184634, 7183337, 7182862, 7182751, 7182245, 7181227, 7180522, 7179596, 7178012, 7177664, 7176707, 7176268, 7176263, 7175592, 7174307, 7173364, 7173036, 7171887, 7170727, 7168927, 7168683, 7168555, 7168536, 7167928, 7164803, 7164413, 7163815, 7163814, 7161264, 7161012, 7160677, 7160303, 7158332, 7157798, 7157695, 7157455, 7156665, 7156034, 7155871, 7154713, 7154436, 7152244, 7151270, 7149781, 7149547, 7148636, 7148538, 7148512, 7147537, 7145532, 7145055, 7144258, 7144229, 7141905, 7141722, 7141547, 7138558, 7137726, 7136609, 7136394, 7135743, 7135407, 7135074, 7134862, 7134847, 7133256, 7132842, 7130217, 7128572, 7126605, 7126432, 7124754, 7124308, 7123565, 7122609, 7122597, 7120718, 7118941, 7117942, 7116099, 7115426, 7115247, 7114853, 7112361, 7112168, 7110811, 7109839, 7109179, 7108530, 7107823, 7106627, 7106478, 7106148, 7106020, 7105096, 7104279, 7101940, 7101530, 7100073, 7098835, 7098688, 7095733, 7095031, 7095026, 7092732, 7092301, 7092189, 7089165, 7085592, 7083912, 7082998, 7075600, 7074765, 7073343, 7073211, 7072443, 7072167, 7071098, 7069262, 7068777, 7066663, 7066190, 7066084, 7065478, 7065289, 7062289, 7061627, 7053648, 7052973, 7051877, 7045679, 7040147, 7037964, 7036431, 7022389, 7020476, 7015764, 7014297, 7010330, 7007472, 7007471, 7004961, 7002042, 7001952, 6998468, 6997212, 6996976, 6996975, 6992005, 6991164, 6990617, 6988544, 6987879, 6986845, 6986553, 6985187, 6979364))
Run Time: 0.023393
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: 423, 0, 1714910328, {"thread-7217327":["thread",7217327],"thread-7217322":["thread",7217322],"thread-7217294":["thread",7217294],"thread-7217232":["thread",7217232],"thread-7216454":["thread",7216454],"thread-7216099":["thread",7216099],"thread-7215342":["thread",7215342],"thread-7215185":["thread",7215185],"thread-7214368":["thread",7214368],"thread-7212939":["thread",7212939],"thread-7212350":["thread",7212350],"thread-7212291":["thread",7212291],"thread-7209617":["thread",7209617],"thread-7208944":["thread",7208944],"thread-7208126":["thread",7208126],"thread-7208003":["thread",7208003],"thread-7207922":["thread",7207922],"thread-7207736":["thread",7207736],"thread-7207527":["thread",7207527],"thread-7206580":["thread",7206580],"thread-7205999":["thread",7205999],"thread-7205527":["thread",7205527],"thread-7205193":["thread",7205193],"thread-7202855":["thread",7202855],"thread-7199560":["thread",7199560],"thread-7199543":["thread",7199543],"thread-7199005":["thread",7199005],"thread-7198854":["thread",7198854],"thread-7196576":["thread",7196576],"thread-7195863":["thread",7195863],"thread-7194064":["thread",7194064],"thread-7193822":["thread",7193822],"thread-7191516":["thread",7191516],"thread-7190238":["thread",7190238],"thread-7190022":["thread",7190022],"thread-7188461":["thread",7188461],"thread-7188455":["thread",7188455],"thread-7188098":["thread",7188098],"thread-7186945":["thread",7186945],"thread-7185681":["thread",7185681],"thread-7185112":["thread",7185112],"thread-7184710":["thread",7184710],"thread-7184651":["thread",7184651],"thread-7184634":["thread",7184634],"thread-7183337":["thread",7183337],"thread-7182862":["thread",7182862],"thread-7182751":["thread",7182751],"thread-7182245":["thread",7182245],"thread-7181227":["thread",7181227],"thread-7180522":["thread",7180522],"thread-7179596":["thread",7179596],"thread-7178012":["thread",7178012],"thread-7177664":["thread",7177664],"thread-7176707":["thread",7176707],"thread-7176268":["thread",7176268],"thread-7176263":["thread",7176263],"thread-7175592":["thread",7175592],"thread-7174307":["thread",7174307],"thread-7173364":["thread",7173364],"thread-7173036":["thread",7173036],"thread-7171887":["thread",7171887],"thread-7170727":["thread",7170727],"thread-7168927":["thread",7168927],"thread-7168683":["thread",7168683],"thread-7168555":["thread",7168555],"thread-7168536":["thread",7168536],"thread-7167928":["thread",7167928],"thread-7164803":["thread",7164803],"thread-7164413":["thread",7164413],"thread-7163815":["thread",7163815],"thread-7163814":["thread",7163814],"thread-7161264":["thread",7161264],"thread-7161012":["thread",7161012],"thread-7160677":["thread",7160677],"thread-7160303":["thread",7160303],"thread-7158332":["thread",7158332],"thread-7157798":["thread",7157798],"thread-7157695":["thread",7157695],"thread-7157455":["thread",7157455],"thread-7156665":["thread",7156665],"thread-7156034":["thread",7156034],"thread-7155871":["thread",7155871],"thread-7154713":["thread",7154713],"thread-7154436":["thread",7154436],"thread-7152244":["thread",7152244],"thread-7151270":["thread",7151270],"thread-7149781":["thread",7149781],"thread-7149547":["thread",7149547],"thread-7148636":["thread",7148636],"thread-7148538":["thread",7148538],"thread-7148512":["thread",7148512],"thread-7147537":["thread",7147537],"thread-7145532":["thread",7145532],"thread-7145055":["thread",7145055],"thread-7144258":["thread",7144258],"thread-7144229":["thread",7144229],"thread-7141905":["thread",7141905],"thread-7141722":["thread",7141722],"thread-7141547":["thread",7141547],"thread-7138558":["thread",7138558],"thread-7137726":["thread",7137726],"thread-7136609":["thread",7136609],"thread-7136394":["thread",7136394],"thread-7135743":["thread",7135743],"thread-7135407":["thread",7135407],"thread-7135074":["thread",7135074],"thread-7134862":["thread",7134862],"thread-7134847":["thread",7134847],"thread-7133256":["thread",7133256],"thread-7132842":["thread",7132842],"thread-7130217":["thread",7130217],"thread-7128572":["thread",7128572],"thread-7126605":["thread",7126605],"thread-7126432":["thread",7126432],"thread-7124754":["thread",7124754],"thread-7124308":["thread",7124308],"thread-7123565":["thread",7123565],"thread-7122609":["thread",7122609],"thread-7122597":["thread",7122597],"thread-7120718":["thread",7120718],"thread-7118941":["thread",7118941],"thread-7117942":["thread",7117942],"thread-7116099":["thread",7116099],"thread-7115426":["thread",7115426],"thread-7115247":["thread",7115247],"thread-7114853":["thread",7114853],"thread-7112361":["thread",7112361],"thread-7112168":["thread",7112168],"thread-7110811":["thread",7110811],"thread-7109839":["thread",7109839],"thread-7109179":["thread",7109179],"thread-7108530":["thread",7108530],"thread-7107823":["thread",7107823],"thread-7106627":["thread",7106627],"thread-7106478":["thread",7106478],"thread-7106148":["thread",7106148],"thread-7106020":["thread",7106020],"thread-7105096":["thread",7105096],"thread-7104279":["thread",7104279],"thread-7101940":["thread",7101940],"thread-7101530":["thread",7101530],"thread-7100073":["thread",7100073],"thread-7098835":["thread",7098835],"thread-7098688":["thread",7098688],"thread-7095733":["thread",7095733],"thread-7095031":["thread",7095031],"thread-7095026":["thread",7095026],"thread-7092732":["thread",7092732],"thread-7092301":["thread",7092301],"thread-7092189":["thread",7092189],"thread-7089165":["thread",7089165],"thread-7085592":["thread",7085592],"thread-7083912":["thread",7083912],"thread-7082998":["thread",7082998],"thread-7075600":["thread",7075600],"thread-7074765":["thread",7074765],"thread-7073343":["thread",7073343],"thread-7073211":["thread",7073211],"thread-7072443":["thread",7072443],"thread-7072167":["thread",7072167],"thread-7071098":["thread",7071098],"thread-7069262":["thread",7069262],"thread-7068777":["thread",7068777],"thread-7066663":["thread",7066663],"thread-7066190":["thread",7066190],"thread-7066084":["thread",7066084],"thread-7065478":["thread",7065478],"thread-7065289":["thread",7065289],"thread-7062289":["thread",7062289],"thread-7061627":["thread",7061627],"thread-7053648":["thread",7053648],"thread-7052973":["thread",7052973],"thread-7051877":["thread",7051877],"thread-7045679":["thread",7045679],"thread-7040147":["thread",7040147],"thread-7037964":["thread",7037964],"thread-7036431":["thread",7036431],"thread-7022389":["thread",7022389],"thread-7020476":["thread",7020476],"thread-7015764":["thread",7015764],"thread-7014297":["thread",7014297],"thread-7010330":["thread",7010330],"thread-7007472":["thread",7007472],"thread-7007471":["thread",7007471],"thread-7004961":["thread",7004961],"thread-7002042":["thread",7002042],"thread-7001952":["thread",7001952],"thread-6998468":["thread",6998468],"thread-6997212":["thread",6997212],"thread-6996976":["thread",6996976],"thread-6996975":["thread",6996975],"thread-6992005":["thread",6992005],"thread-6991164":["thread",6991164],"thread-6990617":["thread",6990617],"thread-6988544":["thread",6988544],"thread-6987879":["thread",6987879],"thread-6986845":["thread",6986845],"thread-6986553":["thread",6986553],"thread-6985187":["thread",6985187],"thread-6979364":["thread",6979364]}, NULL, 1714906728
Run Time: 0.000817
- 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