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 (7214679, 7198230, 7157377, 7151046, 7150636, 7107291, 7106669, 7101028, 7093023, 7065563, 7059072, 7058630, 7044704, 7031289, 7018258, 7010448, 6997396, 6992379, 6989628, 6981317, 6980855, 6974513, 6842011, 6840696, 6811829, 6805386, 6787583, 6773901, 6656267, 6484137, 6281142, 237396, 223842, 220378, 219781, 202333, 186552, 186551, 174450, 165393, 160320, 13652, 13578, 13534, 13454, 13078, 13004, 12884, 12877, 12843, 12835, 12775, 12728, 12463, 12268, 12264, 12119, 12061, 12029, 11723, 11550, 11485, 11449, 11276, 11264, 11181, 11101, 10972, 10961, 10829, 10543, 10542, 10502, 10485, 10448, 10276, 10209, 10185, 10178, 10143, 10060, 10046, 10037, 10016, 10014, 9973, 9949, 9916, 9856, 9808, 9255, 9221, 9089, 8991, 8965, 8932, 8781, 8505, 8493, 8103, 8091, 7937, 7536, 7455, 7399, 7316, 7288, 7275, 7273, 7174, 7076, 6869, 6754, 6675, 6567, 6506, 6499, 6406, 6295, 6215, 6174, 6080, 6067, 6026, 5991, 5951, 5942, 5778, 5727, 5703, 5668, 5563, 5552, 5426, 5424, 5372, 5331, 5328, 5275, 5224, 5159, 5004, 4933, 4807, 4721, 4669, 4666, 4562, 4552, 4542, 4447, 4406, 4378, 4112, 4088, 4044, 3870, 3746, 3694, 3397, 3396, 3343, 3342, 3113, 2860, 2842, 2796, 2795, 2636, 2574, 2544, 2497, 2486, 2479, 2397, 2319, 2304, 2269, 2233, 1949, 1918, 1876, 1847, 1757, 1718, 1471, 1436, 1433, 1300, 1291, 1252, 1147, 1090, 1037, 946, 945, 779, 725, 449, 296))
Run Time: 0.013621
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: 62, 0, 1714633505, {"thread-7214679":["thread",7214679],"thread-7198230":["thread",7198230],"thread-7157377":["thread",7157377],"thread-7151046":["thread",7151046],"thread-7150636":["thread",7150636],"thread-7107291":["thread",7107291],"thread-7106669":["thread",7106669],"thread-7101028":["thread",7101028],"thread-7093023":["thread",7093023],"thread-7065563":["thread",7065563],"thread-7059072":["thread",7059072],"thread-7058630":["thread",7058630],"thread-7044704":["thread",7044704],"thread-7031289":["thread",7031289],"thread-7018258":["thread",7018258],"thread-7010448":["thread",7010448],"thread-6997396":["thread",6997396],"thread-6992379":["thread",6992379],"thread-6989628":["thread",6989628],"thread-6981317":["thread",6981317],"thread-6980855":["thread",6980855],"thread-6974513":["thread",6974513],"thread-6842011":["thread",6842011],"thread-6840696":["thread",6840696],"thread-6811829":["thread",6811829],"thread-6805386":["thread",6805386],"thread-6787583":["thread",6787583],"thread-6773901":["thread",6773901],"thread-6656267":["thread",6656267],"thread-6484137":["thread",6484137],"thread-6281142":["thread",6281142],"thread-237396":["thread",237396],"thread-223842":["thread",223842],"thread-220378":["thread",220378],"thread-219781":["thread",219781],"thread-202333":["thread",202333],"thread-186552":["thread",186552],"thread-186551":["thread",186551],"thread-174450":["thread",174450],"thread-165393":["thread",165393],"thread-160320":["thread",160320],"thread-13652":["thread",13652],"thread-13578":["thread",13578],"thread-13534":["thread",13534],"thread-13454":["thread",13454],"thread-13078":["thread",13078],"thread-13004":["thread",13004],"thread-12884":["thread",12884],"thread-12877":["thread",12877],"thread-12843":["thread",12843],"thread-12835":["thread",12835],"thread-12775":["thread",12775],"thread-12728":["thread",12728],"thread-12463":["thread",12463],"thread-12268":["thread",12268],"thread-12264":["thread",12264],"thread-12119":["thread",12119],"thread-12061":["thread",12061],"thread-12029":["thread",12029],"thread-11723":["thread",11723],"thread-11550":["thread",11550],"thread-11485":["thread",11485],"thread-11449":["thread",11449],"thread-11276":["thread",11276],"thread-11264":["thread",11264],"thread-11181":["thread",11181],"thread-11101":["thread",11101],"thread-10972":["thread",10972],"thread-10961":["thread",10961],"thread-10829":["thread",10829],"thread-10543":["thread",10543],"thread-10542":["thread",10542],"thread-10502":["thread",10502],"thread-10485":["thread",10485],"thread-10448":["thread",10448],"thread-10276":["thread",10276],"thread-10209":["thread",10209],"thread-10185":["thread",10185],"thread-10178":["thread",10178],"thread-10143":["thread",10143],"thread-10060":["thread",10060],"thread-10046":["thread",10046],"thread-10037":["thread",10037],"thread-10016":["thread",10016],"thread-10014":["thread",10014],"thread-9973":["thread",9973],"thread-9949":["thread",9949],"thread-9916":["thread",9916],"thread-9856":["thread",9856],"thread-9808":["thread",9808],"thread-9255":["thread",9255],"thread-9221":["thread",9221],"thread-9089":["thread",9089],"thread-8991":["thread",8991],"thread-8965":["thread",8965],"thread-8932":["thread",8932],"thread-8781":["thread",8781],"thread-8505":["thread",8505],"thread-8493":["thread",8493],"thread-8103":["thread",8103],"thread-8091":["thread",8091],"thread-7937":["thread",7937],"thread-7536":["thread",7536],"thread-7455":["thread",7455],"thread-7399":["thread",7399],"thread-7316":["thread",7316],"thread-7288":["thread",7288],"thread-7275":["thread",7275],"thread-7273":["thread",7273],"thread-7174":["thread",7174],"thread-7076":["thread",7076],"thread-6869":["thread",6869],"thread-6754":["thread",6754],"thread-6675":["thread",6675],"thread-6567":["thread",6567],"thread-6506":["thread",6506],"thread-6499":["thread",6499],"thread-6406":["thread",6406],"thread-6295":["thread",6295],"thread-6215":["thread",6215],"thread-6174":["thread",6174],"thread-6080":["thread",6080],"thread-6067":["thread",6067],"thread-6026":["thread",6026],"thread-5991":["thread",5991],"thread-5951":["thread",5951],"thread-5942":["thread",5942],"thread-5778":["thread",5778],"thread-5727":["thread",5727],"thread-5703":["thread",5703],"thread-5668":["thread",5668],"thread-5563":["thread",5563],"thread-5552":["thread",5552],"thread-5426":["thread",5426],"thread-5424":["thread",5424],"thread-5372":["thread",5372],"thread-5331":["thread",5331],"thread-5328":["thread",5328],"thread-5275":["thread",5275],"thread-5224":["thread",5224],"thread-5159":["thread",5159],"thread-5004":["thread",5004],"thread-4933":["thread",4933],"thread-4807":["thread",4807],"thread-4721":["thread",4721],"thread-4669":["thread",4669],"thread-4666":["thread",4666],"thread-4562":["thread",4562],"thread-4552":["thread",4552],"thread-4542":["thread",4542],"thread-4447":["thread",4447],"thread-4406":["thread",4406],"thread-4378":["thread",4378],"thread-4112":["thread",4112],"thread-4088":["thread",4088],"thread-4044":["thread",4044],"thread-3870":["thread",3870],"thread-3746":["thread",3746],"thread-3694":["thread",3694],"thread-3397":["thread",3397],"thread-3396":["thread",3396],"thread-3343":["thread",3343],"thread-3342":["thread",3342],"thread-3113":["thread",3113],"thread-2860":["thread",2860],"thread-2842":["thread",2842],"thread-2796":["thread",2796],"thread-2795":["thread",2795],"thread-2636":["thread",2636],"thread-2574":["thread",2574],"thread-2544":["thread",2544],"thread-2497":["thread",2497],"thread-2486":["thread",2486],"thread-2479":["thread",2479],"thread-2397":["thread",2397],"thread-2319":["thread",2319],"thread-2304":["thread",2304],"thread-2269":["thread",2269],"thread-2233":["thread",2233],"thread-1949":["thread",1949],"thread-1918":["thread",1918],"thread-1876":["thread",1876],"thread-1847":["thread",1847],"thread-1757":["thread",1757],"thread-1718":["thread",1718],"thread-1471":["thread",1471],"thread-1436":["thread",1436],"thread-1433":["thread",1433],"thread-1300":["thread",1300],"thread-1291":["thread",1291],"thread-1252":["thread",1252],"thread-1147":["thread",1147],"thread-1090":["thread",1090],"thread-1037":["thread",1037],"thread-946":["thread",946],"thread-945":["thread",945],"thread-779":["thread",779],"thread-725":["thread",725],"thread-449":["thread",449],"thread-296":["thread",296]}, NULL, 1714629905
Run Time: 0.000555
- 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