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 (14297, 14296, 14295, 14097, 14096, 13794, 13793, 13731, 13729, 13497, 13475, 13381, 13214, 13041, 12854, 12828, 12538, 12433, 12085, 12014, 11879, 11830, 11796, 11726, 11595, 11593, 11585, 11518, 11517, 11466, 11383, 11363, 11347, 11275, 11224, 11080, 11056, 10899, 10702, 10677, 10663, 10661, 10646, 10589, 10576, 10534, 10532, 10530, 10521, 10520, 10503, 10482, 10480, 10473, 10468, 10466, 10447, 10444, 10438, 10412, 10365, 10364, 10272, 10261, 10101, 10092, 9671, 9337, 9331, 9136, 8835, 8829, 8766, 8632, 8631, 8610, 8580, 8532, 8507, 8335, 8332, 8331, 8317, 8316, 8315, 8308, 8283, 8280, 8279, 8257, 8244, 8228, 8218, 8217, 8207, 8202, 8193, 8189, 8128, 8115, 8053, 7905, 7142, 6581, 6569, 6414, 6371, 6357, 6355, 6337, 6287, 6275, 6248, 6177, 6161, 6160, 6159, 6158, 6156, 6144, 6123, 6106, 6090, 5820, 5719, 5714, 5674, 5658, 5656, 5036, 4939, 4938, 4911, 4910, 4909, 4891, 4769, 4768, 4767, 4665, 4664, 4624, 4623, 4622, 4587, 4586, 4527, 4526, 4525, 4513, 4512, 4511, 4487, 4486, 4485, 4457, 4454, 4451, 4428, 4427, 4426, 4400, 4396, 4364, 4362, 4361, 4359, 4358, 4339, 4338, 4337, 4319, 4318, 4317, 4288, 4287, 4286, 4285, 4255, 4254, 4210, 4197, 4195, 4193, 4192, 4182, 4160, 4159, 4153, 4134, 4131, 4130, 4104, 4103, 4102, 4092, 4091, 4090, 4083, 4073))
Run Time: 0.002803
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 | foru_12.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | foru_12.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | foru_12.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | foru_12.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,foru_12.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: 33, 0, 1715923025, {"thread-14297":["thread",14297],"thread-14296":["thread",14296],"thread-14295":["thread",14295],"thread-14097":["thread",14097],"thread-14096":["thread",14096],"thread-13794":["thread",13794],"thread-13793":["thread",13793],"thread-13731":["thread",13731],"thread-13729":["thread",13729],"thread-13497":["thread",13497],"thread-13475":["thread",13475],"thread-13381":["thread",13381],"thread-13214":["thread",13214],"thread-13041":["thread",13041],"thread-12854":["thread",12854],"thread-12828":["thread",12828],"thread-12538":["thread",12538],"thread-12433":["thread",12433],"thread-12085":["thread",12085],"thread-12014":["thread",12014],"thread-11879":["thread",11879],"thread-11830":["thread",11830],"thread-11796":["thread",11796],"thread-11726":["thread",11726],"thread-11595":["thread",11595],"thread-11593":["thread",11593],"thread-11585":["thread",11585],"thread-11518":["thread",11518],"thread-11517":["thread",11517],"thread-11466":["thread",11466],"thread-11383":["thread",11383],"thread-11363":["thread",11363],"thread-11347":["thread",11347],"thread-11275":["thread",11275],"thread-11224":["thread",11224],"thread-11080":["thread",11080],"thread-11056":["thread",11056],"thread-10899":["thread",10899],"thread-10677":["thread",10677],"thread-10663":["thread",10663],"thread-10661":["thread",10661],"thread-10646":["thread",10646],"thread-10589":["thread",10589],"thread-10576":["thread",10576],"thread-10534":["thread",10534],"thread-10530":["thread",10530],"thread-10521":["thread",10521],"thread-10520":["thread",10520],"thread-10503":["thread",10503],"thread-10482":["thread",10482],"thread-10480":["thread",10480],"thread-10473":["thread",10473],"thread-10468":["thread",10468],"thread-10466":["thread",10466],"thread-10447":["thread",10447],"thread-10444":["thread",10444],"thread-10438":["thread",10438],"thread-10412":["thread",10412],"thread-10365":["thread",10365],"thread-10364":["thread",10364],"thread-10272":["thread",10272],"thread-10261":["thread",10261],"thread-10101":["thread",10101],"thread-10092":["thread",10092],"thread-9671":["thread",9671],"thread-9337":["thread",9337],"thread-9331":["thread",9331],"thread-9136":["thread",9136],"thread-8835":["thread",8835],"thread-8829":["thread",8829],"thread-8766":["thread",8766],"thread-8632":["thread",8632],"thread-8631":["thread",8631],"thread-8610":["thread",8610],"thread-8580":["thread",8580],"thread-8532":["thread",8532],"thread-8507":["thread",8507],"thread-8335":["thread",8335],"thread-8332":["thread",8332],"thread-8331":["thread",8331],"thread-8317":["thread",8317],"thread-8316":["thread",8316],"thread-8315":["thread",8315],"thread-8308":["thread",8308],"thread-8283":["thread",8283],"thread-8280":["thread",8280],"thread-8279":["thread",8279],"thread-8257":["thread",8257],"thread-8244":["thread",8244],"thread-8228":["thread",8228],"thread-8218":["thread",8218],"thread-8217":["thread",8217],"thread-8207":["thread",8207],"thread-8202":["thread",8202],"thread-8193":["thread",8193],"thread-8189":["thread",8189],"thread-8128":["thread",8128],"thread-8115":["thread",8115],"thread-8053":["thread",8053],"thread-7905":["thread",7905],"thread-7142":["thread",7142],"thread-6581":["thread",6581],"thread-6569":["thread",6569],"thread-6414":["thread",6414],"thread-6371":["thread",6371],"thread-6357":["thread",6357],"thread-6355":["thread",6355],"thread-6337":["thread",6337],"thread-6287":["thread",6287],"thread-6275":["thread",6275],"thread-6248":["thread",6248],"thread-6177":["thread",6177],"thread-6161":["thread",6161],"thread-6160":["thread",6160],"thread-6159":["thread",6159],"thread-6158":["thread",6158],"thread-6156":["thread",6156],"thread-6123":["thread",6123],"thread-6106":["thread",6106],"thread-6090":["thread",6090],"thread-5820":["thread",5820],"thread-5719":["thread",5719],"thread-5714":["thread",5714],"thread-5674":["thread",5674],"thread-5658":["thread",5658],"thread-5656":["thread",5656],"thread-5036":["thread",5036],"thread-4939":["thread",4939],"thread-4938":["thread",4938],"thread-4911":["thread",4911],"thread-4910":["thread",4910],"thread-4909":["thread",4909],"thread-4891":["thread",4891],"thread-4769":["thread",4769],"thread-4768":["thread",4768],"thread-4767":["thread",4767],"thread-4665":["thread",4665],"thread-4664":["thread",4664],"thread-4624":["thread",4624],"thread-4623":["thread",4623],"thread-4622":["thread",4622],"thread-4587":["thread",4587],"thread-4586":["thread",4586],"thread-4527":["thread",4527],"thread-4526":["thread",4526],"thread-4525":["thread",4525],"thread-4513":["thread",4513],"thread-4512":["thread",4512],"thread-4511":["thread",4511],"thread-4487":["thread",4487],"thread-4486":["thread",4486],"thread-4485":["thread",4485],"thread-4457":["thread",4457],"thread-4454":["thread",4454],"thread-4451":["thread",4451],"thread-4428":["thread",4428],"thread-4427":["thread",4427],"thread-4426":["thread",4426],"thread-4400":["thread",4400],"thread-4396":["thread",4396],"thread-4364":["thread",4364],"thread-4362":["thread",4362],"thread-4361":["thread",4361],"thread-4359":["thread",4359],"thread-4358":["thread",4358],"thread-4339":["thread",4339],"thread-4338":["thread",4338],"thread-4337":["thread",4337],"thread-4319":["thread",4319],"thread-4318":["thread",4318],"thread-4317":["thread",4317],"thread-4288":["thread",4288],"thread-4287":["thread",4287],"thread-4286":["thread",4286],"thread-4285":["thread",4285],"thread-4255":["thread",4255],"thread-4254":["thread",4254],"thread-4210":["thread",4210],"thread-4197":["thread",4197],"thread-4195":["thread",4195],"thread-4193":["thread",4193],"thread-4192":["thread",4192],"thread-4182":["thread",4182],"thread-4160":["thread",4160],"thread-4159":["thread",4159],"thread-4153":["thread",4153],"thread-4134":["thread",4134],"thread-4131":["thread",4131],"thread-4130":["thread",4130],"thread-4104":["thread",4104],"thread-4103":["thread",4103],"thread-4102":["thread",4102],"thread-4092":["thread",4092],"thread-4091":["thread",4091],"thread-4090":["thread",4090],"thread-4083":["thread",4083],"thread-4073":["thread",4073]}, NULL, 1715919425
Run Time: 0.000429
- 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