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 (7216843, 7216731, 7214687, 7209675, 7204997, 7203357, 7200135, 7197468, 7192745, 7184520, 7184394, 7172467, 7171237, 7170529, 7160434, 7160088, 7153273, 7152265, 7149390, 7149121, 7146469, 7146177, 7142072, 7141387, 7138724, 7138654, 7136932, 7133567, 7132525, 7128995, 7124307, 7119808, 7115957, 7115771, 7110122, 7109748, 7094894, 7088135, 7086090, 7086000, 7081458, 7080534, 7075370, 7057638, 7054939, 7053458, 7036152, 7031366, 7007862, 7001856, 7001304, 6986517, 6983368, 6970381, 242411, 220183, 195585, 182813, 182264, 181480, 169338, 160877, 13801, 13754, 13744, 13460, 13450, 13346, 13323, 13221, 13051, 12562, 12333, 12227, 12208, 12111, 12110, 12039, 12028, 11594, 11445, 11333, 11236, 11155, 11104, 11012, 10733, 10594, 10591, 10499, 10428, 10324, 10253, 10036, 10014, 9996, 9967, 9946, 9945, 9808, 9659, 9422, 9316, 9315, 9312, 9298, 9286, 9250, 9217, 9207, 9077, 8991, 8922, 8859, 8726, 8653, 8597, 8507, 8503, 8499, 8455, 8442, 8214, 8183, 8144, 7949, 7916, 7598, 7582, 7569, 7432, 7351, 7346, 7233, 7215, 7143, 7087, 7056, 6985, 6932, 6902, 6860, 6799, 6406, 6375, 6328, 6254, 6132, 5464, 5461, 5386, 5380, 5202, 5164, 5061, 5049, 4993, 4900, 4868, 4464, 4426, 4422, 4340, 4316, 4218, 4211, 4203, 4038, 4020, 3884, 3707, 3663, 3376, 3375, 3285, 3229, 3197, 3139, 2998, 2995, 2840, 2826, 2811, 2796, 2699, 2695, 2654, 2483, 2422, 2398, 2333, 2207, 2197, 1871, 1665, 1587, 1344, 1258, 1239, 1164))
Run Time: 0.014580
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: 240, 0, 1714650005, {"thread-7216843":["thread",7216843],"thread-7216731":["thread",7216731],"thread-7214687":["thread",7214687],"thread-7209675":["thread",7209675],"thread-7204997":["thread",7204997],"thread-7203357":["thread",7203357],"thread-7200135":["thread",7200135],"thread-7197468":["thread",7197468],"thread-7192745":["thread",7192745],"thread-7184520":["thread",7184520],"thread-7184394":["thread",7184394],"thread-7172467":["thread",7172467],"thread-7171237":["thread",7171237],"thread-7170529":["thread",7170529],"thread-7160434":["thread",7160434],"thread-7160088":["thread",7160088],"thread-7153273":["thread",7153273],"thread-7152265":["thread",7152265],"thread-7149390":["thread",7149390],"thread-7149121":["thread",7149121],"thread-7146469":["thread",7146469],"thread-7146177":["thread",7146177],"thread-7142072":["thread",7142072],"thread-7141387":["thread",7141387],"thread-7138724":["thread",7138724],"thread-7138654":["thread",7138654],"thread-7136932":["thread",7136932],"thread-7133567":["thread",7133567],"thread-7132525":["thread",7132525],"thread-7128995":["thread",7128995],"thread-7124307":["thread",7124307],"thread-7119808":["thread",7119808],"thread-7115957":["thread",7115957],"thread-7115771":["thread",7115771],"thread-7110122":["thread",7110122],"thread-7109748":["thread",7109748],"thread-7094894":["thread",7094894],"thread-7088135":["thread",7088135],"thread-7086090":["thread",7086090],"thread-7086000":["thread",7086000],"thread-7081458":["thread",7081458],"thread-7080534":["thread",7080534],"thread-7075370":["thread",7075370],"thread-7057638":["thread",7057638],"thread-7054939":["thread",7054939],"thread-7053458":["thread",7053458],"thread-7036152":["thread",7036152],"thread-7031366":["thread",7031366],"thread-7007862":["thread",7007862],"thread-7001856":["thread",7001856],"thread-7001304":["thread",7001304],"thread-6986517":["thread",6986517],"thread-6983368":["thread",6983368],"thread-6970381":["thread",6970381],"thread-242411":["thread",242411],"thread-220183":["thread",220183],"thread-195585":["thread",195585],"thread-182813":["thread",182813],"thread-182264":["thread",182264],"thread-181480":["thread",181480],"thread-169338":["thread",169338],"thread-160877":["thread",160877],"thread-13801":["thread",13801],"thread-13754":["thread",13754],"thread-13744":["thread",13744],"thread-13460":["thread",13460],"thread-13450":["thread",13450],"thread-13346":["thread",13346],"thread-13323":["thread",13323],"thread-13221":["thread",13221],"thread-13051":["thread",13051],"thread-12562":["thread",12562],"thread-12333":["thread",12333],"thread-12227":["thread",12227],"thread-12208":["thread",12208],"thread-12111":["thread",12111],"thread-12110":["thread",12110],"thread-12039":["thread",12039],"thread-12028":["thread",12028],"thread-11594":["thread",11594],"thread-11445":["thread",11445],"thread-11333":["thread",11333],"thread-11236":["thread",11236],"thread-11155":["thread",11155],"thread-11104":["thread",11104],"thread-11012":["thread",11012],"thread-10733":["thread",10733],"thread-10594":["thread",10594],"thread-10591":["thread",10591],"thread-10499":["thread",10499],"thread-10428":["thread",10428],"thread-10324":["thread",10324],"thread-10253":["thread",10253],"thread-10036":["thread",10036],"thread-10014":["thread",10014],"thread-9996":["thread",9996],"thread-9967":["thread",9967],"thread-9946":["thread",9946],"thread-9945":["thread",9945],"thread-9808":["thread",9808],"thread-9659":["thread",9659],"thread-9422":["thread",9422],"thread-9316":["thread",9316],"thread-9315":["thread",9315],"thread-9312":["thread",9312],"thread-9298":["thread",9298],"thread-9286":["thread",9286],"thread-9250":["thread",9250],"thread-9217":["thread",9217],"thread-9207":["thread",9207],"thread-9077":["thread",9077],"thread-8991":["thread",8991],"thread-8922":["thread",8922],"thread-8859":["thread",8859],"thread-8726":["thread",8726],"thread-8653":["thread",8653],"thread-8597":["thread",8597],"thread-8507":["thread",8507],"thread-8503":["thread",8503],"thread-8499":["thread",8499],"thread-8455":["thread",8455],"thread-8442":["thread",8442],"thread-8214":["thread",8214],"thread-8183":["thread",8183],"thread-8144":["thread",8144],"thread-7949":["thread",7949],"thread-7916":["thread",7916],"thread-7598":["thread",7598],"thread-7582":["thread",7582],"thread-7569":["thread",7569],"thread-7432":["thread",7432],"thread-7351":["thread",7351],"thread-7346":["thread",7346],"thread-7233":["thread",7233],"thread-7215":["thread",7215],"thread-7143":["thread",7143],"thread-7087":["thread",7087],"thread-7056":["thread",7056],"thread-6985":["thread",6985],"thread-6932":["thread",6932],"thread-6902":["thread",6902],"thread-6860":["thread",6860],"thread-6799":["thread",6799],"thread-6406":["thread",6406],"thread-6375":["thread",6375],"thread-6328":["thread",6328],"thread-6254":["thread",6254],"thread-6132":["thread",6132],"thread-5464":["thread",5464],"thread-5461":["thread",5461],"thread-5386":["thread",5386],"thread-5380":["thread",5380],"thread-5202":["thread",5202],"thread-5164":["thread",5164],"thread-5061":["thread",5061],"thread-5049":["thread",5049],"thread-4993":["thread",4993],"thread-4900":["thread",4900],"thread-4868":["thread",4868],"thread-4464":["thread",4464],"thread-4426":["thread",4426],"thread-4422":["thread",4422],"thread-4340":["thread",4340],"thread-4316":["thread",4316],"thread-4218":["thread",4218],"thread-4211":["thread",4211],"thread-4203":["thread",4203],"thread-4038":["thread",4038],"thread-4020":["thread",4020],"thread-3884":["thread",3884],"thread-3707":["thread",3707],"thread-3663":["thread",3663],"thread-3376":["thread",3376],"thread-3375":["thread",3375],"thread-3285":["thread",3285],"thread-3229":["thread",3229],"thread-3197":["thread",3197],"thread-3139":["thread",3139],"thread-2998":["thread",2998],"thread-2995":["thread",2995],"thread-2840":["thread",2840],"thread-2826":["thread",2826],"thread-2811":["thread",2811],"thread-2796":["thread",2796],"thread-2699":["thread",2699],"thread-2695":["thread",2695],"thread-2654":["thread",2654],"thread-2483":["thread",2483],"thread-2422":["thread",2422],"thread-2398":["thread",2398],"thread-2333":["thread",2333],"thread-2207":["thread",2207],"thread-2197":["thread",2197],"thread-1871":["thread",1871],"thread-1665":["thread",1665],"thread-1587":["thread",1587],"thread-1344":["thread",1344],"thread-1258":["thread",1258],"thread-1239":["thread",1239],"thread-1164":["thread",1164]}, NULL, 1714646405
Run Time: 0.000562
- 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