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 (7216874, 7216164, 7215579, 7215493, 7215437, 7211098, 7210209, 7207356, 7207202, 7206753, 7205703, 7205507, 7203758, 7201695, 7198945, 7198794, 7198343, 7194529, 7190295, 7188669, 7186303, 7184947, 7180949, 7180610, 7178811, 7178736, 7172723, 7171295, 7170740, 7164681, 7164566, 7164545, 7160611, 7160126, 7160124, 7158784, 7156768, 7154436, 7152265, 7149379, 7148767, 7147692, 7143127, 7142072, 7139773, 7138632, 7133493, 7132335, 7132272, 7131776, 7130890, 7130856, 7130822, 7128151, 7123477, 7122364, 7121400, 7118239, 7116604, 7114616, 7112838, 7112794, 7112728, 7110227, 7105601, 7103888, 7101507, 7101061, 7099693, 7098484, 7097611, 7096604, 7096121, 7095179, 7095176, 7095103, 7094995, 7089023, 7086352, 7086089, 7086000, 7085812, 7085578, 7084507, 7084331, 7080390, 7080263, 7080082, 7080058, 7079295, 7079234, 7073027, 7071583, 7071099, 7070505, 7069960, 7066233, 7066159, 7063972, 7063313, 7063202, 7060986, 7060888, 7060619, 7059653, 7057133, 7052249, 7051547, 7047458, 7047434, 7047373, 7044416, 7042377, 7030305, 7029333, 7019269, 7019267, 7018135, 7015764, 7010979, 6998453, 6986133, 6983500, 6342074, 6327146, 6258224, 214621, 211084, 204422, 203958, 13717, 13692, 13243, 12845, 12586, 12558, 12086, 11441, 11088, 11005, 10177, 10005, 9953, 9763, 9480, 9452, 9297, 9045, 7972, 7144, 6987, 6868, 6777, 6449, 6363, 5728, 5635, 4592, 4397, 4194, 3690, 3425, 3156, 3007, 2883, 2580, 2452, 2151, 2147, 1726, 1624, 1551, 1154, 1103, 1050, 657, 638, 560))
Run Time: 0.015641
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 178 | 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: 639, 0, 1714798843, {"thread-7216874":["thread",7216874],"thread-7216164":["thread",7216164],"thread-7215579":["thread",7215579],"thread-7215493":["thread",7215493],"thread-7215437":["thread",7215437],"thread-7211098":["thread",7211098],"thread-7210209":["thread",7210209],"thread-7207356":["thread",7207356],"thread-7207202":["thread",7207202],"thread-7206753":["thread",7206753],"thread-7205703":["thread",7205703],"thread-7205507":["thread",7205507],"thread-7203758":["thread",7203758],"thread-7201695":["thread",7201695],"thread-7198945":["thread",7198945],"thread-7198794":["thread",7198794],"thread-7198343":["thread",7198343],"thread-7194529":["thread",7194529],"thread-7190295":["thread",7190295],"thread-7188669":["thread",7188669],"thread-7186303":["thread",7186303],"thread-7184947":["thread",7184947],"thread-7180949":["thread",7180949],"thread-7180610":["thread",7180610],"thread-7178811":["thread",7178811],"thread-7178736":["thread",7178736],"thread-7172723":["thread",7172723],"thread-7171295":["thread",7171295],"thread-7170740":["thread",7170740],"thread-7164681":["thread",7164681],"thread-7164566":["thread",7164566],"thread-7164545":["thread",7164545],"thread-7160611":["thread",7160611],"thread-7160126":["thread",7160126],"thread-7160124":["thread",7160124],"thread-7158784":["thread",7158784],"thread-7156768":["thread",7156768],"thread-7154436":["thread",7154436],"thread-7152265":["thread",7152265],"thread-7149379":["thread",7149379],"thread-7148767":["thread",7148767],"thread-7147692":["thread",7147692],"thread-7143127":["thread",7143127],"thread-7142072":["thread",7142072],"thread-7139773":["thread",7139773],"thread-7138632":["thread",7138632],"thread-7133493":["thread",7133493],"thread-7132335":["thread",7132335],"thread-7132272":["thread",7132272],"thread-7131776":["thread",7131776],"thread-7130890":["thread",7130890],"thread-7130856":["thread",7130856],"thread-7130822":["thread",7130822],"thread-7128151":["thread",7128151],"thread-7123477":["thread",7123477],"thread-7122364":["thread",7122364],"thread-7121400":["thread",7121400],"thread-7118239":["thread",7118239],"thread-7116604":["thread",7116604],"thread-7114616":["thread",7114616],"thread-7112838":["thread",7112838],"thread-7112794":["thread",7112794],"thread-7112728":["thread",7112728],"thread-7110227":["thread",7110227],"thread-7105601":["thread",7105601],"thread-7103888":["thread",7103888],"thread-7101507":["thread",7101507],"thread-7101061":["thread",7101061],"thread-7099693":["thread",7099693],"thread-7098484":["thread",7098484],"thread-7097611":["thread",7097611],"thread-7096604":["thread",7096604],"thread-7096121":["thread",7096121],"thread-7095179":["thread",7095179],"thread-7095176":["thread",7095176],"thread-7095103":["thread",7095103],"thread-7094995":["thread",7094995],"thread-7089023":["thread",7089023],"thread-7086352":["thread",7086352],"thread-7086089":["thread",7086089],"thread-7086000":["thread",7086000],"thread-7085812":["thread",7085812],"thread-7085578":["thread",7085578],"thread-7084507":["thread",7084507],"thread-7084331":["thread",7084331],"thread-7080390":["thread",7080390],"thread-7080263":["thread",7080263],"thread-7080082":["thread",7080082],"thread-7080058":["thread",7080058],"thread-7079295":["thread",7079295],"thread-7079234":["thread",7079234],"thread-7073027":["thread",7073027],"thread-7071583":["thread",7071583],"thread-7071099":["thread",7071099],"thread-7070505":["thread",7070505],"thread-7069960":["thread",7069960],"thread-7066233":["thread",7066233],"thread-7066159":["thread",7066159],"thread-7063972":["thread",7063972],"thread-7063313":["thread",7063313],"thread-7063202":["thread",7063202],"thread-7060986":["thread",7060986],"thread-7060888":["thread",7060888],"thread-7060619":["thread",7060619],"thread-7059653":["thread",7059653],"thread-7057133":["thread",7057133],"thread-7052249":["thread",7052249],"thread-7051547":["thread",7051547],"thread-7047458":["thread",7047458],"thread-7047434":["thread",7047434],"thread-7047373":["thread",7047373],"thread-7044416":["thread",7044416],"thread-7042377":["thread",7042377],"thread-7030305":["thread",7030305],"thread-7029333":["thread",7029333],"thread-7019269":["thread",7019269],"thread-7019267":["thread",7019267],"thread-7018135":["thread",7018135],"thread-7015764":["thread",7015764],"thread-7010979":["thread",7010979],"thread-6998453":["thread",6998453],"thread-6986133":["thread",6986133],"thread-6983500":["thread",6983500],"thread-6342074":["thread",6342074],"thread-6327146":["thread",6327146],"thread-6258224":["thread",6258224],"thread-214621":["thread",214621],"thread-211084":["thread",211084],"thread-204422":["thread",204422],"thread-203958":["thread",203958],"thread-13717":["thread",13717],"thread-13692":["thread",13692],"thread-13243":["thread",13243],"thread-12845":["thread",12845],"thread-12586":["thread",12586],"thread-12558":["thread",12558],"thread-12086":["thread",12086],"thread-11441":["thread",11441],"thread-11088":["thread",11088],"thread-11005":["thread",11005],"thread-10177":["thread",10177],"thread-10005":["thread",10005],"thread-9953":["thread",9953],"thread-9763":["thread",9763],"thread-9480":["thread",9480],"thread-9452":["thread",9452],"thread-9297":["thread",9297],"thread-9045":["thread",9045],"thread-7972":["thread",7972],"thread-7144":["thread",7144],"thread-6987":["thread",6987],"thread-6868":["thread",6868],"thread-6777":["thread",6777],"thread-6449":["thread",6449],"thread-6363":["thread",6363],"thread-5728":["thread",5728],"thread-5635":["thread",5635],"thread-4592":["thread",4592],"thread-4397":["thread",4397],"thread-4194":["thread",4194],"thread-3690":["thread",3690],"thread-3425":["thread",3425],"thread-3156":["thread",3156],"thread-3007":["thread",3007],"thread-2883":["thread",2883],"thread-2580":["thread",2580],"thread-2452":["thread",2452],"thread-2151":["thread",2151],"thread-2147":["thread",2147],"thread-1726":["thread",1726],"thread-1624":["thread",1624],"thread-1551":["thread",1551],"thread-1154":["thread",1154],"thread-1103":["thread",1103],"thread-1050":["thread",1050],"thread-657":["thread",657],"thread-638":["thread",638],"thread-560":["thread",560]}, NULL, 1714795243
Run Time: 0.000699
- 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