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 (7217294, 7216999, 7216300, 7213280, 7213001, 7212350, 7212291, 7209503, 7208003, 7207569, 7206677, 7205756, 7202717, 7196638, 7194649, 7194075, 7191423, 7185466, 7181241, 7180854, 7180851, 7177499, 7174303, 7170728, 7165927, 7157873, 7151270, 7148476, 7143300, 7137761, 7133276, 7132222, 7132204, 7132069, 7130565, 7129547, 7128239, 7126137, 7117770, 7116847, 7113719, 7108717, 7102548, 7100719, 7097991, 7095506, 7093526, 7089896, 7089113, 7086683, 7085322, 7084906, 7081676, 7074943, 7065534, 7062804, 7057927, 7049996, 7037581, 7034662, 7034462, 7031229, 7026959, 7025924, 7021449, 7019071, 7018720, 7011816, 7010455, 7009620, 7007018, 7006689, 7004728, 6998942, 6998237, 6998030, 6995892, 6990934, 6986749, 6980874, 6978037, 6971011, 6966305, 6964667, 6963115, 216144, 210495, 191067, 187092, 167817, 160205, 13740, 13369, 13208, 13201, 13135, 13052, 13035, 12873, 12789, 12461, 12152, 12013, 11982, 11884, 11349, 11341, 11250, 11248, 11246, 11064, 10825, 10771, 10742, 10642, 10534, 10532, 10438, 10394, 10375, 10323, 10306, 10159, 10142, 10041, 9909, 9776, 9749, 9719, 9715, 9670, 9551, 9539, 9466, 9462, 9388, 9169, 9115, 9088, 9048, 8913, 8863, 8843, 8748, 8727, 8547, 8489, 8461, 8459, 8392, 8277, 7703, 7690, 7587, 7463, 7312, 7284, 7275, 7207, 7173, 7112, 7065, 6751, 6716, 6710, 6708, 6673, 6592, 6417, 6195, 6166, 6130, 5838, 5593, 5068, 5006, 4952, 4924, 4842, 4790, 4697, 4651, 4602, 4543, 4522, 4446, 4356, 4275, 4201, 4058, 4034, 3953, 3908, 3871, 3861, 3653, 3645, 3569, 3257, 3064))
Run Time: 0.019243
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: 736, 0, 1715104063, {"thread-7217294":["thread",7217294],"thread-7216999":["thread",7216999],"thread-7216300":["thread",7216300],"thread-7213280":["thread",7213280],"thread-7213001":["thread",7213001],"thread-7212350":["thread",7212350],"thread-7212291":["thread",7212291],"thread-7209503":["thread",7209503],"thread-7208003":["thread",7208003],"thread-7207569":["thread",7207569],"thread-7206677":["thread",7206677],"thread-7205756":["thread",7205756],"thread-7202717":["thread",7202717],"thread-7196638":["thread",7196638],"thread-7194649":["thread",7194649],"thread-7194075":["thread",7194075],"thread-7191423":["thread",7191423],"thread-7185466":["thread",7185466],"thread-7181241":["thread",7181241],"thread-7180854":["thread",7180854],"thread-7180851":["thread",7180851],"thread-7177499":["thread",7177499],"thread-7174303":["thread",7174303],"thread-7170728":["thread",7170728],"thread-7165927":["thread",7165927],"thread-7157873":["thread",7157873],"thread-7151270":["thread",7151270],"thread-7148476":["thread",7148476],"thread-7143300":["thread",7143300],"thread-7137761":["thread",7137761],"thread-7133276":["thread",7133276],"thread-7132222":["thread",7132222],"thread-7132204":["thread",7132204],"thread-7132069":["thread",7132069],"thread-7130565":["thread",7130565],"thread-7129547":["thread",7129547],"thread-7128239":["thread",7128239],"thread-7126137":["thread",7126137],"thread-7117770":["thread",7117770],"thread-7116847":["thread",7116847],"thread-7113719":["thread",7113719],"thread-7108717":["thread",7108717],"thread-7102548":["thread",7102548],"thread-7100719":["thread",7100719],"thread-7097991":["thread",7097991],"thread-7095506":["thread",7095506],"thread-7093526":["thread",7093526],"thread-7089896":["thread",7089896],"thread-7089113":["thread",7089113],"thread-7086683":["thread",7086683],"thread-7085322":["thread",7085322],"thread-7084906":["thread",7084906],"thread-7081676":["thread",7081676],"thread-7074943":["thread",7074943],"thread-7065534":["thread",7065534],"thread-7062804":["thread",7062804],"thread-7057927":["thread",7057927],"thread-7049996":["thread",7049996],"thread-7037581":["thread",7037581],"thread-7034662":["thread",7034662],"thread-7034462":["thread",7034462],"thread-7031229":["thread",7031229],"thread-7026959":["thread",7026959],"thread-7025924":["thread",7025924],"thread-7021449":["thread",7021449],"thread-7019071":["thread",7019071],"thread-7018720":["thread",7018720],"thread-7011816":["thread",7011816],"thread-7010455":["thread",7010455],"thread-7009620":["thread",7009620],"thread-7007018":["thread",7007018],"thread-7006689":["thread",7006689],"thread-7004728":["thread",7004728],"thread-6998942":["thread",6998942],"thread-6998237":["thread",6998237],"thread-6998030":["thread",6998030],"thread-6995892":["thread",6995892],"thread-6990934":["thread",6990934],"thread-6986749":["thread",6986749],"thread-6980874":["thread",6980874],"thread-6978037":["thread",6978037],"thread-6971011":["thread",6971011],"thread-6966305":["thread",6966305],"thread-6964667":["thread",6964667],"thread-6963115":["thread",6963115],"thread-216144":["thread",216144],"thread-210495":["thread",210495],"thread-191067":["thread",191067],"thread-187092":["thread",187092],"thread-167817":["thread",167817],"thread-160205":["thread",160205],"thread-13740":["thread",13740],"thread-13369":["thread",13369],"thread-13208":["thread",13208],"thread-13201":["thread",13201],"thread-13135":["thread",13135],"thread-13052":["thread",13052],"thread-13035":["thread",13035],"thread-12873":["thread",12873],"thread-12789":["thread",12789],"thread-12461":["thread",12461],"thread-12152":["thread",12152],"thread-12013":["thread",12013],"thread-11982":["thread",11982],"thread-11884":["thread",11884],"thread-11349":["thread",11349],"thread-11341":["thread",11341],"thread-11250":["thread",11250],"thread-11248":["thread",11248],"thread-11246":["thread",11246],"thread-11064":["thread",11064],"thread-10825":["thread",10825],"thread-10771":["thread",10771],"thread-10742":["thread",10742],"thread-10642":["thread",10642],"thread-10534":["thread",10534],"thread-10532":["thread",10532],"thread-10438":["thread",10438],"thread-10394":["thread",10394],"thread-10375":["thread",10375],"thread-10323":["thread",10323],"thread-10306":["thread",10306],"thread-10159":["thread",10159],"thread-10142":["thread",10142],"thread-10041":["thread",10041],"thread-9909":["thread",9909],"thread-9776":["thread",9776],"thread-9749":["thread",9749],"thread-9719":["thread",9719],"thread-9715":["thread",9715],"thread-9670":["thread",9670],"thread-9551":["thread",9551],"thread-9539":["thread",9539],"thread-9466":["thread",9466],"thread-9462":["thread",9462],"thread-9388":["thread",9388],"thread-9169":["thread",9169],"thread-9115":["thread",9115],"thread-9088":["thread",9088],"thread-9048":["thread",9048],"thread-8913":["thread",8913],"thread-8863":["thread",8863],"thread-8843":["thread",8843],"thread-8748":["thread",8748],"thread-8727":["thread",8727],"thread-8547":["thread",8547],"thread-8489":["thread",8489],"thread-8461":["thread",8461],"thread-8459":["thread",8459],"thread-8392":["thread",8392],"thread-8277":["thread",8277],"thread-7703":["thread",7703],"thread-7690":["thread",7690],"thread-7587":["thread",7587],"thread-7463":["thread",7463],"thread-7312":["thread",7312],"thread-7284":["thread",7284],"thread-7275":["thread",7275],"thread-7207":["thread",7207],"thread-7173":["thread",7173],"thread-7112":["thread",7112],"thread-7065":["thread",7065],"thread-6751":["thread",6751],"thread-6716":["thread",6716],"thread-6710":["thread",6710],"thread-6708":["thread",6708],"thread-6673":["thread",6673],"thread-6592":["thread",6592],"thread-6417":["thread",6417],"thread-6195":["thread",6195],"thread-6166":["thread",6166],"thread-6130":["thread",6130],"thread-5838":["thread",5838],"thread-5593":["thread",5593],"thread-5068":["thread",5068],"thread-5006":["thread",5006],"thread-4952":["thread",4952],"thread-4924":["thread",4924],"thread-4842":["thread",4842],"thread-4790":["thread",4790],"thread-4697":["thread",4697],"thread-4651":["thread",4651],"thread-4602":["thread",4602],"thread-4543":["thread",4543],"thread-4522":["thread",4522],"thread-4446":["thread",4446],"thread-4356":["thread",4356],"thread-4275":["thread",4275],"thread-4201":["thread",4201],"thread-4058":["thread",4058],"thread-4034":["thread",4034],"thread-3953":["thread",3953],"thread-3908":["thread",3908],"thread-3871":["thread",3871],"thread-3861":["thread",3861],"thread-3653":["thread",3653],"thread-3645":["thread",3645],"thread-3569":["thread",3569],"thread-3257":["thread",3257],"thread-3064":["thread",3064]}, NULL, 1715100463
Run Time: 0.001191
- 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