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 (7218781, 7215177, 7198397, 7172697, 7170062, 7153262, 7148767, 7127091, 7110664, 7104664, 7069879, 7062892, 7036152, 6983830, 6983368, 6964682, 6296912, 197009, 173583, 172634, 160877, 13832, 13787, 13754, 13749, 13744, 13713, 13708, 13685, 13390, 13340, 13323, 13234, 13221, 13126, 13092, 12825, 12684, 12275, 12227, 12208, 12111, 12110, 12078, 12043, 12039, 12029, 11452, 11447, 11445, 11417, 11382, 11375, 11289, 11236, 11135, 11104, 10734, 10594, 10591, 10547, 10522, 10499, 10339, 10324, 10316, 10036, 10003, 9996, 9967, 9856, 9808, 9659, 9316, 9315, 9312, 9217, 9207, 9086, 9009, 8950, 8743, 8597, 8526, 8507, 8499, 8442, 8260, 8214, 8144, 8133, 7952, 7949, 7827, 7792, 7610, 7578, 7568, 7481, 7351, 7233, 7087, 6902, 6690, 6654, 6566, 6449, 6406, 6393, 6375, 6328, 6254, 6132, 6104, 5823, 5754, 5666, 5470, 5466, 5464, 5164, 5061, 4900, 4808, 4710, 4464, 4422, 4414, 4340, 4259, 4218, 4211, 4042, 3793, 3725, 3545, 3384, 3375, 3278, 3245, 3236, 3231, 3229, 3139, 2998, 2995, 2824, 2811, 2796, 2795, 2699, 2661, 2483, 2398, 2385, 2333, 2207, 2151, 2127, 2115, 2071, 1948, 1847, 1665, 1599, 1545, 1437, 1164, 1092, 1025, 874, 747, 745, 550, 516, 478, 287, 279, 264))
Run Time: 0.010287
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 179 | 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: 239, 0, 1716306326, {"thread-7218781":["thread",7218781],"thread-7215177":["thread",7215177],"thread-7198397":["thread",7198397],"thread-7172697":["thread",7172697],"thread-7170062":["thread",7170062],"thread-7153262":["thread",7153262],"thread-7148767":["thread",7148767],"thread-7127091":["thread",7127091],"thread-7110664":["thread",7110664],"thread-7104664":["thread",7104664],"thread-7069879":["thread",7069879],"thread-7062892":["thread",7062892],"thread-7036152":["thread",7036152],"thread-6983830":["thread",6983830],"thread-6983368":["thread",6983368],"thread-6964682":["thread",6964682],"thread-6296912":["thread",6296912],"thread-197009":["thread",197009],"thread-173583":["thread",173583],"thread-172634":["thread",172634],"thread-160877":["thread",160877],"thread-13832":["thread",13832],"thread-13787":["thread",13787],"thread-13754":["thread",13754],"thread-13749":["thread",13749],"thread-13744":["thread",13744],"thread-13713":["thread",13713],"thread-13708":["thread",13708],"thread-13685":["thread",13685],"thread-13390":["thread",13390],"thread-13340":["thread",13340],"thread-13323":["thread",13323],"thread-13234":["thread",13234],"thread-13221":["thread",13221],"thread-13126":["thread",13126],"thread-13092":["thread",13092],"thread-12825":["thread",12825],"thread-12684":["thread",12684],"thread-12275":["thread",12275],"thread-12227":["thread",12227],"thread-12208":["thread",12208],"thread-12111":["thread",12111],"thread-12110":["thread",12110],"thread-12078":["thread",12078],"thread-12043":["thread",12043],"thread-12039":["thread",12039],"thread-12029":["thread",12029],"thread-11452":["thread",11452],"thread-11447":["thread",11447],"thread-11445":["thread",11445],"thread-11417":["thread",11417],"thread-11382":["thread",11382],"thread-11375":["thread",11375],"thread-11289":["thread",11289],"thread-11236":["thread",11236],"thread-11135":["thread",11135],"thread-11104":["thread",11104],"thread-10734":["thread",10734],"thread-10594":["thread",10594],"thread-10591":["thread",10591],"thread-10547":["thread",10547],"thread-10522":["thread",10522],"thread-10499":["thread",10499],"thread-10339":["thread",10339],"thread-10324":["thread",10324],"thread-10316":["thread",10316],"thread-10036":["thread",10036],"thread-10003":["thread",10003],"thread-9996":["thread",9996],"thread-9967":["thread",9967],"thread-9856":["thread",9856],"thread-9808":["thread",9808],"thread-9659":["thread",9659],"thread-9316":["thread",9316],"thread-9315":["thread",9315],"thread-9312":["thread",9312],"thread-9217":["thread",9217],"thread-9207":["thread",9207],"thread-9086":["thread",9086],"thread-9009":["thread",9009],"thread-8950":["thread",8950],"thread-8743":["thread",8743],"thread-8597":["thread",8597],"thread-8526":["thread",8526],"thread-8507":["thread",8507],"thread-8499":["thread",8499],"thread-8442":["thread",8442],"thread-8260":["thread",8260],"thread-8214":["thread",8214],"thread-8144":["thread",8144],"thread-8133":["thread",8133],"thread-7952":["thread",7952],"thread-7949":["thread",7949],"thread-7827":["thread",7827],"thread-7792":["thread",7792],"thread-7610":["thread",7610],"thread-7578":["thread",7578],"thread-7568":["thread",7568],"thread-7481":["thread",7481],"thread-7351":["thread",7351],"thread-7233":["thread",7233],"thread-7087":["thread",7087],"thread-6902":["thread",6902],"thread-6690":["thread",6690],"thread-6654":["thread",6654],"thread-6566":["thread",6566],"thread-6449":["thread",6449],"thread-6406":["thread",6406],"thread-6393":["thread",6393],"thread-6375":["thread",6375],"thread-6328":["thread",6328],"thread-6254":["thread",6254],"thread-6132":["thread",6132],"thread-6104":["thread",6104],"thread-5823":["thread",5823],"thread-5754":["thread",5754],"thread-5666":["thread",5666],"thread-5470":["thread",5470],"thread-5466":["thread",5466],"thread-5464":["thread",5464],"thread-5164":["thread",5164],"thread-5061":["thread",5061],"thread-4900":["thread",4900],"thread-4808":["thread",4808],"thread-4710":["thread",4710],"thread-4464":["thread",4464],"thread-4422":["thread",4422],"thread-4414":["thread",4414],"thread-4340":["thread",4340],"thread-4259":["thread",4259],"thread-4218":["thread",4218],"thread-4211":["thread",4211],"thread-4042":["thread",4042],"thread-3793":["thread",3793],"thread-3725":["thread",3725],"thread-3545":["thread",3545],"thread-3384":["thread",3384],"thread-3375":["thread",3375],"thread-3278":["thread",3278],"thread-3245":["thread",3245],"thread-3236":["thread",3236],"thread-3231":["thread",3231],"thread-3229":["thread",3229],"thread-3139":["thread",3139],"thread-2998":["thread",2998],"thread-2995":["thread",2995],"thread-2824":["thread",2824],"thread-2811":["thread",2811],"thread-2796":["thread",2796],"thread-2795":["thread",2795],"thread-2699":["thread",2699],"thread-2661":["thread",2661],"thread-2483":["thread",2483],"thread-2398":["thread",2398],"thread-2385":["thread",2385],"thread-2333":["thread",2333],"thread-2207":["thread",2207],"thread-2151":["thread",2151],"thread-2127":["thread",2127],"thread-2115":["thread",2115],"thread-2071":["thread",2071],"thread-1948":["thread",1948],"thread-1847":["thread",1847],"thread-1665":["thread",1665],"thread-1599":["thread",1599],"thread-1545":["thread",1545],"thread-1437":["thread",1437],"thread-1164":["thread",1164],"thread-1092":["thread",1092],"thread-1025":["thread",1025],"thread-874":["thread",874],"thread-747":["thread",747],"thread-745":["thread",745],"thread-550":["thread",550],"thread-516":["thread",516],"thread-478":["thread",478],"thread-287":["thread",287],"thread-279":["thread",279],"thread-264":["thread",264]}, NULL, 1716302726
Run Time: 0.000438
- 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