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 (14581, 14554, 14513, 14296, 14295, 14294, 14292, 14156, 14131, 14096, 13498, 13497, 13470, 13381, 13323, 13251, 13041, 12902, 12854, 12726, 12538, 12433, 12432, 12214, 12085, 12014, 11944, 11879, 11830, 11724, 11644, 11595, 11594, 11593, 11589, 11518, 11517, 11466, 11457, 11446, 11435, 11430, 11429, 11402, 11400, 11394, 11383, 11371, 11369, 11363, 11360, 11347, 11346, 11340, 11332, 11329, 11309, 11304, 11296, 11295, 11290, 11283, 11282, 11275, 11274, 11255, 11247, 11246, 11224, 11213, 11200, 11194, 11191, 11178, 11168, 11167, 11165, 11160, 11159, 11152, 11148, 11147, 11145, 11144, 11129, 11121, 11080, 11075, 11064, 11031, 11012, 11002, 10981, 10959, 10899, 10872, 10796, 10776, 10679, 10579, 10533, 10532, 10530, 10527, 10505, 10502, 10495, 10474, 10467, 10441, 10362, 10359, 10335, 10260, 10259, 10208, 10200, 10199, 10198, 10171, 10155, 10065, 10048, 10044, 10038, 8808, 8762, 8669, 8586, 8584, 8380, 8336, 8320, 8305, 8289, 8282, 8241, 8196, 8035, 8013, 7934, 7669, 6590, 6389, 6371, 6349, 6272, 6205, 6127, 6036, 5991, 5945, 5937, 5897, 5823, 5718, 5715, 5711, 5703, 5653, 4971, 4892, 4763, 4503, 4483, 4447, 4419, 4417, 4387, 4386, 4333, 4201, 4189, 4123, 4107, 4089, 4083, 4065, 4060, 4049, 4047, 4026, 4021, 4017, 4009, 3995, 3986, 3982, 3981, 3975, 3958, 3957, 3918, 3861, 3857, 3856, 3829, 3826, 3793, 3728))
Run Time: 0.003142
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: 181, 0, 1715758198, {"thread-14581":["thread",14581],"thread-14554":["thread",14554],"thread-14513":["thread",14513],"thread-14296":["thread",14296],"thread-14295":["thread",14295],"thread-14294":["thread",14294],"thread-14292":["thread",14292],"thread-14156":["thread",14156],"thread-14131":["thread",14131],"thread-14096":["thread",14096],"thread-13498":["thread",13498],"thread-13497":["thread",13497],"thread-13470":["thread",13470],"thread-13381":["thread",13381],"thread-13323":["thread",13323],"thread-13251":["thread",13251],"thread-13041":["thread",13041],"thread-12902":["thread",12902],"thread-12854":["thread",12854],"thread-12726":["thread",12726],"thread-12538":["thread",12538],"thread-12433":["thread",12433],"thread-12432":["thread",12432],"thread-12214":["thread",12214],"thread-12085":["thread",12085],"thread-12014":["thread",12014],"thread-11944":["thread",11944],"thread-11879":["thread",11879],"thread-11830":["thread",11830],"thread-11724":["thread",11724],"thread-11644":["thread",11644],"thread-11595":["thread",11595],"thread-11594":["thread",11594],"thread-11593":["thread",11593],"thread-11589":["thread",11589],"thread-11518":["thread",11518],"thread-11517":["thread",11517],"thread-11466":["thread",11466],"thread-11457":["thread",11457],"thread-11446":["thread",11446],"thread-11435":["thread",11435],"thread-11430":["thread",11430],"thread-11429":["thread",11429],"thread-11402":["thread",11402],"thread-11400":["thread",11400],"thread-11394":["thread",11394],"thread-11383":["thread",11383],"thread-11371":["thread",11371],"thread-11369":["thread",11369],"thread-11363":["thread",11363],"thread-11360":["thread",11360],"thread-11347":["thread",11347],"thread-11346":["thread",11346],"thread-11340":["thread",11340],"thread-11332":["thread",11332],"thread-11329":["thread",11329],"thread-11309":["thread",11309],"thread-11304":["thread",11304],"thread-11296":["thread",11296],"thread-11295":["thread",11295],"thread-11290":["thread",11290],"thread-11283":["thread",11283],"thread-11282":["thread",11282],"thread-11275":["thread",11275],"thread-11274":["thread",11274],"thread-11255":["thread",11255],"thread-11247":["thread",11247],"thread-11246":["thread",11246],"thread-11224":["thread",11224],"thread-11213":["thread",11213],"thread-11200":["thread",11200],"thread-11194":["thread",11194],"thread-11191":["thread",11191],"thread-11178":["thread",11178],"thread-11168":["thread",11168],"thread-11167":["thread",11167],"thread-11165":["thread",11165],"thread-11160":["thread",11160],"thread-11159":["thread",11159],"thread-11148":["thread",11148],"thread-11147":["thread",11147],"thread-11145":["thread",11145],"thread-11144":["thread",11144],"thread-11129":["thread",11129],"thread-11121":["thread",11121],"thread-11080":["thread",11080],"thread-11075":["thread",11075],"thread-11064":["thread",11064],"thread-11031":["thread",11031],"thread-11012":["thread",11012],"thread-11002":["thread",11002],"thread-10981":["thread",10981],"thread-10959":["thread",10959],"thread-10899":["thread",10899],"thread-10872":["thread",10872],"thread-10776":["thread",10776],"thread-10579":["thread",10579],"thread-10533":["thread",10533],"thread-10530":["thread",10530],"thread-10527":["thread",10527],"thread-10505":["thread",10505],"thread-10502":["thread",10502],"thread-10495":["thread",10495],"thread-10474":["thread",10474],"thread-10467":["thread",10467],"thread-10441":["thread",10441],"thread-10362":["thread",10362],"thread-10359":["thread",10359],"thread-10335":["thread",10335],"thread-10260":["thread",10260],"thread-10259":["thread",10259],"thread-10208":["thread",10208],"thread-10200":["thread",10200],"thread-10199":["thread",10199],"thread-10198":["thread",10198],"thread-10171":["thread",10171],"thread-10155":["thread",10155],"thread-10065":["thread",10065],"thread-10048":["thread",10048],"thread-10044":["thread",10044],"thread-10038":["thread",10038],"thread-8808":["thread",8808],"thread-8762":["thread",8762],"thread-8669":["thread",8669],"thread-8586":["thread",8586],"thread-8584":["thread",8584],"thread-8380":["thread",8380],"thread-8336":["thread",8336],"thread-8320":["thread",8320],"thread-8305":["thread",8305],"thread-8289":["thread",8289],"thread-8282":["thread",8282],"thread-8241":["thread",8241],"thread-8196":["thread",8196],"thread-8035":["thread",8035],"thread-8013":["thread",8013],"thread-7934":["thread",7934],"thread-7669":["thread",7669],"thread-6590":["thread",6590],"thread-6389":["thread",6389],"thread-6371":["thread",6371],"thread-6349":["thread",6349],"thread-6272":["thread",6272],"thread-6205":["thread",6205],"thread-6127":["thread",6127],"thread-6036":["thread",6036],"thread-5991":["thread",5991],"thread-5945":["thread",5945],"thread-5937":["thread",5937],"thread-5897":["thread",5897],"thread-5823":["thread",5823],"thread-5715":["thread",5715],"thread-5711":["thread",5711],"thread-5703":["thread",5703],"thread-5653":["thread",5653],"thread-4971":["thread",4971],"thread-4892":["thread",4892],"thread-4763":["thread",4763],"thread-4503":["thread",4503],"thread-4483":["thread",4483],"thread-4447":["thread",4447],"thread-4419":["thread",4419],"thread-4417":["thread",4417],"thread-4387":["thread",4387],"thread-4386":["thread",4386],"thread-4333":["thread",4333],"thread-4201":["thread",4201],"thread-4189":["thread",4189],"thread-4123":["thread",4123],"thread-4107":["thread",4107],"thread-4089":["thread",4089],"thread-4083":["thread",4083],"thread-4065":["thread",4065],"thread-4060":["thread",4060],"thread-4049":["thread",4049],"thread-4047":["thread",4047],"thread-4026":["thread",4026],"thread-4021":["thread",4021],"thread-4017":["thread",4017],"thread-4009":["thread",4009],"thread-3995":["thread",3995],"thread-3986":["thread",3986],"thread-3982":["thread",3982],"thread-3981":["thread",3981],"thread-3975":["thread",3975],"thread-3958":["thread",3958],"thread-3957":["thread",3957],"thread-3918":["thread",3918],"thread-3861":["thread",3861],"thread-3857":["thread",3857],"thread-3856":["thread",3856],"thread-3829":["thread",3829],"thread-3826":["thread",3826],"thread-3793":["thread",3793],"thread-3728":["thread",3728]}, NULL, 1715754598
Run Time: 0.000152
- 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