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 (7192680, 7183445, 7183094, 7180945, 7175447, 7171462, 7163042, 7130729, 7122366, 7121342, 7118957, 7117398, 7116361, 7115193, 7100919, 7099497, 7097611, 7096518, 7093289, 7085406, 7079237, 7074613, 7071205, 7069703, 7068840, 7064733, 7063369, 7062893, 7061901, 7055390, 7054738, 7054581, 7052868, 7045692, 7021849, 6957326, 191136, 13649, 13612, 13597, 13551, 13365, 13312, 13296, 13132, 13127, 13049, 12846, 12839, 12625, 12617, 12576, 12398, 12340, 12306, 11920, 11874, 11857, 11678, 11658, 11656, 11649, 11532, 11498, 11492, 11491, 11430, 11398, 11242, 11130, 11081, 11075, 10982, 10977, 10894, 10813, 10649, 10614, 10585, 10516, 10312, 9928, 9870, 9859, 9735, 9637, 9591, 9240, 9212, 9106, 8853, 8841, 8835, 8805, 8763, 8761, 8688, 8592, 8473, 8411, 8379, 8342, 8299, 8197, 8069, 7966, 7963, 7956, 7946, 7932, 7920, 7800, 7624, 7616, 7596, 7513, 7402, 7390, 7366, 7257, 7256, 7106, 7062, 7036, 7023, 7022, 6979, 6898, 6863, 6828, 6808, 6774, 6759, 6591, 6560, 6495, 6388, 6310, 6294, 6277, 6217, 6010, 5980, 5976, 5940, 5937, 5920, 5914, 5752, 5572, 5543, 5531, 5479, 5470, 5462, 5446, 5428, 5229, 5228, 5154, 5145, 5081, 4976, 4873, 4841, 4724, 4574, 4468, 4455, 4363, 4320, 4306, 4265, 4183, 4156, 4087, 3935, 3765, 3590, 3567, 3525, 3511, 3359, 3329, 3320, 3255, 3240, 3146, 3127, 2969, 2943, 2936, 2829, 2807, 2798, 2714, 2628, 2613, 2612, 2462))
Run Time: 0.052286
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: 405, 0, 1714944170, {"thread-7192680":["thread",7192680],"thread-7183445":["thread",7183445],"thread-7183094":["thread",7183094],"thread-7180945":["thread",7180945],"thread-7175447":["thread",7175447],"thread-7171462":["thread",7171462],"thread-7163042":["thread",7163042],"thread-7130729":["thread",7130729],"thread-7122366":["thread",7122366],"thread-7121342":["thread",7121342],"thread-7118957":["thread",7118957],"thread-7117398":["thread",7117398],"thread-7116361":["thread",7116361],"thread-7115193":["thread",7115193],"thread-7100919":["thread",7100919],"thread-7099497":["thread",7099497],"thread-7097611":["thread",7097611],"thread-7096518":["thread",7096518],"thread-7093289":["thread",7093289],"thread-7085406":["thread",7085406],"thread-7079237":["thread",7079237],"thread-7074613":["thread",7074613],"thread-7071205":["thread",7071205],"thread-7069703":["thread",7069703],"thread-7068840":["thread",7068840],"thread-7064733":["thread",7064733],"thread-7063369":["thread",7063369],"thread-7062893":["thread",7062893],"thread-7061901":["thread",7061901],"thread-7055390":["thread",7055390],"thread-7054738":["thread",7054738],"thread-7054581":["thread",7054581],"thread-7052868":["thread",7052868],"thread-7045692":["thread",7045692],"thread-7021849":["thread",7021849],"thread-6957326":["thread",6957326],"thread-191136":["thread",191136],"thread-13649":["thread",13649],"thread-13612":["thread",13612],"thread-13597":["thread",13597],"thread-13551":["thread",13551],"thread-13365":["thread",13365],"thread-13312":["thread",13312],"thread-13296":["thread",13296],"thread-13132":["thread",13132],"thread-13127":["thread",13127],"thread-13049":["thread",13049],"thread-12846":["thread",12846],"thread-12839":["thread",12839],"thread-12625":["thread",12625],"thread-12617":["thread",12617],"thread-12576":["thread",12576],"thread-12398":["thread",12398],"thread-12340":["thread",12340],"thread-12306":["thread",12306],"thread-11920":["thread",11920],"thread-11874":["thread",11874],"thread-11857":["thread",11857],"thread-11678":["thread",11678],"thread-11658":["thread",11658],"thread-11656":["thread",11656],"thread-11649":["thread",11649],"thread-11532":["thread",11532],"thread-11498":["thread",11498],"thread-11492":["thread",11492],"thread-11491":["thread",11491],"thread-11430":["thread",11430],"thread-11398":["thread",11398],"thread-11242":["thread",11242],"thread-11130":["thread",11130],"thread-11081":["thread",11081],"thread-11075":["thread",11075],"thread-10982":["thread",10982],"thread-10977":["thread",10977],"thread-10894":["thread",10894],"thread-10813":["thread",10813],"thread-10649":["thread",10649],"thread-10614":["thread",10614],"thread-10585":["thread",10585],"thread-10516":["thread",10516],"thread-10312":["thread",10312],"thread-9928":["thread",9928],"thread-9870":["thread",9870],"thread-9859":["thread",9859],"thread-9735":["thread",9735],"thread-9637":["thread",9637],"thread-9591":["thread",9591],"thread-9240":["thread",9240],"thread-9212":["thread",9212],"thread-9106":["thread",9106],"thread-8853":["thread",8853],"thread-8841":["thread",8841],"thread-8835":["thread",8835],"thread-8805":["thread",8805],"thread-8763":["thread",8763],"thread-8761":["thread",8761],"thread-8688":["thread",8688],"thread-8592":["thread",8592],"thread-8473":["thread",8473],"thread-8411":["thread",8411],"thread-8379":["thread",8379],"thread-8342":["thread",8342],"thread-8299":["thread",8299],"thread-8197":["thread",8197],"thread-8069":["thread",8069],"thread-7966":["thread",7966],"thread-7963":["thread",7963],"thread-7956":["thread",7956],"thread-7946":["thread",7946],"thread-7932":["thread",7932],"thread-7920":["thread",7920],"thread-7800":["thread",7800],"thread-7624":["thread",7624],"thread-7616":["thread",7616],"thread-7596":["thread",7596],"thread-7513":["thread",7513],"thread-7402":["thread",7402],"thread-7390":["thread",7390],"thread-7366":["thread",7366],"thread-7257":["thread",7257],"thread-7256":["thread",7256],"thread-7106":["thread",7106],"thread-7062":["thread",7062],"thread-7036":["thread",7036],"thread-7023":["thread",7023],"thread-7022":["thread",7022],"thread-6979":["thread",6979],"thread-6898":["thread",6898],"thread-6863":["thread",6863],"thread-6828":["thread",6828],"thread-6808":["thread",6808],"thread-6774":["thread",6774],"thread-6759":["thread",6759],"thread-6591":["thread",6591],"thread-6560":["thread",6560],"thread-6495":["thread",6495],"thread-6388":["thread",6388],"thread-6310":["thread",6310],"thread-6294":["thread",6294],"thread-6277":["thread",6277],"thread-6217":["thread",6217],"thread-6010":["thread",6010],"thread-5980":["thread",5980],"thread-5976":["thread",5976],"thread-5940":["thread",5940],"thread-5937":["thread",5937],"thread-5920":["thread",5920],"thread-5914":["thread",5914],"thread-5752":["thread",5752],"thread-5572":["thread",5572],"thread-5543":["thread",5543],"thread-5531":["thread",5531],"thread-5479":["thread",5479],"thread-5470":["thread",5470],"thread-5462":["thread",5462],"thread-5446":["thread",5446],"thread-5428":["thread",5428],"thread-5229":["thread",5229],"thread-5228":["thread",5228],"thread-5154":["thread",5154],"thread-5145":["thread",5145],"thread-5081":["thread",5081],"thread-4976":["thread",4976],"thread-4873":["thread",4873],"thread-4841":["thread",4841],"thread-4724":["thread",4724],"thread-4574":["thread",4574],"thread-4468":["thread",4468],"thread-4455":["thread",4455],"thread-4363":["thread",4363],"thread-4320":["thread",4320],"thread-4306":["thread",4306],"thread-4265":["thread",4265],"thread-4183":["thread",4183],"thread-4156":["thread",4156],"thread-4087":["thread",4087],"thread-3935":["thread",3935],"thread-3765":["thread",3765],"thread-3590":["thread",3590],"thread-3567":["thread",3567],"thread-3525":["thread",3525],"thread-3511":["thread",3511],"thread-3359":["thread",3359],"thread-3329":["thread",3329],"thread-3320":["thread",3320],"thread-3255":["thread",3255],"thread-3240":["thread",3240],"thread-3146":["thread",3146],"thread-3127":["thread",3127],"thread-2969":["thread",2969],"thread-2943":["thread",2943],"thread-2936":["thread",2936],"thread-2829":["thread",2829],"thread-2807":["thread",2807],"thread-2798":["thread",2798],"thread-2714":["thread",2714],"thread-2628":["thread",2628],"thread-2613":["thread",2613],"thread-2612":["thread",2612],"thread-2462":["thread",2462]}, NULL, 1714940570
Run Time: 0.003321
- 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