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 (7209485, 7198789, 7191654, 7191536, 7186031, 7185407, 7181208, 7179220, 7162304, 7162271, 7159991, 7141946, 7141943, 7141674, 7140234, 7135600, 7134993, 7134079, 7133279, 7126131, 7118179, 7112342, 7107893, 7100371, 7099313, 7097560, 7096220, 7093691, 7087809, 7087259, 7086539, 7082778, 7077845, 7076060, 7075823, 7075786, 7075216, 7075151, 7074573, 7069524, 7064853, 7062835, 7044419, 7044127, 7042420, 7034768, 7033497, 7031609, 7031547, 7028842, 7026756, 7019074, 7012386, 6999954, 6998837, 6997827, 6995405, 6991632, 6979276, 6957462, 6956031, 12893, 6694))
Run Time: 0.004104
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 63 | 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: 5316, 0, 1714933633, {"thread-7209485":["thread",7209485],"thread-7198789":["thread",7198789],"thread-7191654":["thread",7191654],"thread-7191536":["thread",7191536],"thread-7186031":["thread",7186031],"thread-7185407":["thread",7185407],"thread-7181208":["thread",7181208],"thread-7179220":["thread",7179220],"thread-7162304":["thread",7162304],"thread-7162271":["thread",7162271],"thread-7159991":["thread",7159991],"thread-7141946":["thread",7141946],"thread-7141943":["thread",7141943],"thread-7141674":["thread",7141674],"thread-7140234":["thread",7140234],"thread-7135600":["thread",7135600],"thread-7134993":["thread",7134993],"thread-7134079":["thread",7134079],"thread-7133279":["thread",7133279],"thread-7126131":["thread",7126131],"thread-7118179":["thread",7118179],"thread-7112342":["thread",7112342],"thread-7107893":["thread",7107893],"thread-7100371":["thread",7100371],"thread-7099313":["thread",7099313],"thread-7097560":["thread",7097560],"thread-7096220":["thread",7096220],"thread-7093691":["thread",7093691],"thread-7087809":["thread",7087809],"thread-7087259":["thread",7087259],"thread-7086539":["thread",7086539],"thread-7082778":["thread",7082778],"thread-7077845":["thread",7077845],"thread-7076060":["thread",7076060],"thread-7075823":["thread",7075823],"thread-7075786":["thread",7075786],"thread-7075216":["thread",7075216],"thread-7075151":["thread",7075151],"thread-7074573":["thread",7074573],"thread-7069524":["thread",7069524],"thread-7064853":["thread",7064853],"thread-7062835":["thread",7062835],"thread-7044419":["thread",7044419],"thread-7044127":["thread",7044127],"thread-7042420":["thread",7042420],"thread-7034768":["thread",7034768],"thread-7033497":["thread",7033497],"thread-7031609":["thread",7031609],"thread-7031547":["thread",7031547],"thread-7028842":["thread",7028842],"thread-7026756":["thread",7026756],"thread-7019074":["thread",7019074],"thread-7012386":["thread",7012386],"thread-6999954":["thread",6999954],"thread-6998837":["thread",6998837],"thread-6997827":["thread",6997827],"thread-6995405":["thread",6995405],"thread-6991632":["thread",6991632],"thread-6979276":["thread",6979276],"thread-6957462":["thread",6957462],"thread-6956031":["thread",6956031],"thread-12893":["thread",12893],"thread-6694":["thread",6694]}, NULL, 1714930033
Run Time: 0.000356
- 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