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 (8507, 8432, 8403, 8364, 8303, 8274, 8257, 8250, 8238, 8205, 8177, 8153, 8142, 8127, 8120, 8114, 8113, 8103, 8097, 8095, 8092, 8087, 8085, 8075, 8073, 8068, 8065, 8059, 8017, 8000, 7997, 7993, 7977, 7970, 7968, 7954, 7943, 7935, 7923, 7910, 7903, 7894, 7878, 7864, 7855, 7840, 7817, 7801, 7794, 7771, 7747, 7728, 7717, 7702, 7701, 7692, 7675, 7655, 7631, 7603, 7578, 7550, 7524, 7495, 7473, 7451, 7432, 7405, 7378, 7342, 7318, 7296, 7268, 7227, 7202, 7162, 7082, 7054, 7021, 6994, 6955, 6936, 6900, 6863, 6835, 6780, 6733, 6691, 6647, 6605, 6557, 6479, 6458, 6426, 6404, 6358, 6337, 6303, 6177, 5624, 5570, 5257, 5216, 5167, 5131, 4910, 4768, 4664, 4622, 4587, 4525, 4511, 4485, 4454, 4427, 4400, 4359, 4338, 4317, 4285, 4255, 4193, 4159, 4131, 4103, 4092, 4072, 4061, 4036, 4008, 3991, 3974, 3948, 3915, 3890, 3809, 3757, 3724, 3708, 3675, 3661, 3636, 3618, 3505, 3433, 3392, 3372, 3353, 3335, 3308, 3268, 3240, 3226, 3209, 3201, 3181, 3167, 3151, 3137, 3113, 3106, 3093, 3078, 3068, 3059, 3039, 3027, 3015, 3004, 2938, 2921, 2904, 2886, 2875, 2856, 2846, 2827, 2811, 2790, 2764, 2754))
Run Time: 0.003419
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 181 | 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: 211, 0, 1714821300, {"thread-8507":["thread",8507],"thread-8432":["thread",8432],"thread-8403":["thread",8403],"thread-8364":["thread",8364],"thread-8303":["thread",8303],"thread-8274":["thread",8274],"thread-8257":["thread",8257],"thread-8250":["thread",8250],"thread-8238":["thread",8238],"thread-8205":["thread",8205],"thread-8177":["thread",8177],"thread-8153":["thread",8153],"thread-8142":["thread",8142],"thread-8127":["thread",8127],"thread-8120":["thread",8120],"thread-8114":["thread",8114],"thread-8113":["thread",8113],"thread-8103":["thread",8103],"thread-8097":["thread",8097],"thread-8095":["thread",8095],"thread-8092":["thread",8092],"thread-8087":["thread",8087],"thread-8085":["thread",8085],"thread-8075":["thread",8075],"thread-8073":["thread",8073],"thread-8068":["thread",8068],"thread-8065":["thread",8065],"thread-8059":["thread",8059],"thread-8017":["thread",8017],"thread-8000":["thread",8000],"thread-7997":["thread",7997],"thread-7993":["thread",7993],"thread-7977":["thread",7977],"thread-7970":["thread",7970],"thread-7968":["thread",7968],"thread-7954":["thread",7954],"thread-7943":["thread",7943],"thread-7935":["thread",7935],"thread-7923":["thread",7923],"thread-7910":["thread",7910],"thread-7903":["thread",7903],"thread-7894":["thread",7894],"thread-7878":["thread",7878],"thread-7864":["thread",7864],"thread-7855":["thread",7855],"thread-7840":["thread",7840],"thread-7817":["thread",7817],"thread-7801":["thread",7801],"thread-7794":["thread",7794],"thread-7771":["thread",7771],"thread-7747":["thread",7747],"thread-7728":["thread",7728],"thread-7717":["thread",7717],"thread-7692":["thread",7692],"thread-7675":["thread",7675],"thread-7655":["thread",7655],"thread-7631":["thread",7631],"thread-7603":["thread",7603],"thread-7578":["thread",7578],"thread-7550":["thread",7550],"thread-7524":["thread",7524],"thread-7495":["thread",7495],"thread-7473":["thread",7473],"thread-7451":["thread",7451],"thread-7432":["thread",7432],"thread-7405":["thread",7405],"thread-7378":["thread",7378],"thread-7342":["thread",7342],"thread-7318":["thread",7318],"thread-7296":["thread",7296],"thread-7268":["thread",7268],"thread-7227":["thread",7227],"thread-7202":["thread",7202],"thread-7162":["thread",7162],"thread-7082":["thread",7082],"thread-7054":["thread",7054],"thread-7021":["thread",7021],"thread-6994":["thread",6994],"thread-6955":["thread",6955],"thread-6936":["thread",6936],"thread-6900":["thread",6900],"thread-6863":["thread",6863],"thread-6835":["thread",6835],"thread-6780":["thread",6780],"thread-6733":["thread",6733],"thread-6691":["thread",6691],"thread-6647":["thread",6647],"thread-6605":["thread",6605],"thread-6557":["thread",6557],"thread-6479":["thread",6479],"thread-6458":["thread",6458],"thread-6426":["thread",6426],"thread-6404":["thread",6404],"thread-6358":["thread",6358],"thread-6337":["thread",6337],"thread-6303":["thread",6303],"thread-6177":["thread",6177],"thread-5624":["thread",5624],"thread-5570":["thread",5570],"thread-5257":["thread",5257],"thread-5216":["thread",5216],"thread-5167":["thread",5167],"thread-5131":["thread",5131],"thread-4910":["thread",4910],"thread-4768":["thread",4768],"thread-4664":["thread",4664],"thread-4622":["thread",4622],"thread-4587":["thread",4587],"thread-4525":["thread",4525],"thread-4511":["thread",4511],"thread-4485":["thread",4485],"thread-4454":["thread",4454],"thread-4427":["thread",4427],"thread-4400":["thread",4400],"thread-4359":["thread",4359],"thread-4338":["thread",4338],"thread-4317":["thread",4317],"thread-4285":["thread",4285],"thread-4255":["thread",4255],"thread-4193":["thread",4193],"thread-4159":["thread",4159],"thread-4131":["thread",4131],"thread-4103":["thread",4103],"thread-4092":["thread",4092],"thread-4072":["thread",4072],"thread-4061":["thread",4061],"thread-4036":["thread",4036],"thread-4008":["thread",4008],"thread-3991":["thread",3991],"thread-3974":["thread",3974],"thread-3948":["thread",3948],"thread-3915":["thread",3915],"thread-3890":["thread",3890],"thread-3809":["thread",3809],"thread-3757":["thread",3757],"thread-3724":["thread",3724],"thread-3708":["thread",3708],"thread-3675":["thread",3675],"thread-3661":["thread",3661],"thread-3636":["thread",3636],"thread-3618":["thread",3618],"thread-3505":["thread",3505],"thread-3433":["thread",3433],"thread-3392":["thread",3392],"thread-3372":["thread",3372],"thread-3353":["thread",3353],"thread-3335":["thread",3335],"thread-3308":["thread",3308],"thread-3268":["thread",3268],"thread-3240":["thread",3240],"thread-3226":["thread",3226],"thread-3201":["thread",3201],"thread-3181":["thread",3181],"thread-3167":["thread",3167],"thread-3151":["thread",3151],"thread-3137":["thread",3137],"thread-3113":["thread",3113],"thread-3106":["thread",3106],"thread-3093":["thread",3093],"thread-3078":["thread",3078],"thread-3068":["thread",3068],"thread-3059":["thread",3059],"thread-3039":["thread",3039],"thread-3027":["thread",3027],"thread-3015":["thread",3015],"thread-3004":["thread",3004],"thread-2938":["thread",2938],"thread-2921":["thread",2921],"thread-2904":["thread",2904],"thread-2886":["thread",2886],"thread-2875":["thread",2875],"thread-2856":["thread",2856],"thread-2846":["thread",2846],"thread-2827":["thread",2827],"thread-2811":["thread",2811],"thread-2790":["thread",2790],"thread-2764":["thread",2764],"thread-2754":["thread",2754]}, NULL, 1714817700
Run Time: 0.000204
- 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