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 (7217837, 7215179, 7214679, 7214334, 7210914, 7207202, 7206753, 7206351, 7199413, 7199206, 7198794, 7198495, 7196484, 7192926, 7192461, 7192454, 7183364, 7181773, 7181619, 7181518, 7181130, 7178714, 7174645, 7174313, 7173025, 7171525, 7170130, 7167656, 7164545, 7161801, 7159576, 7159024, 7159000, 7158423, 7155749, 7153746, 7147788, 7146170, 7143459, 7140965, 7138730, 7138627, 7136156, 7135718, 7134286, 7131125, 7130856, 7130710, 7129994, 7129987, 7129837, 7128217, 7122195, 7117217, 7108597, 7101779, 7099245, 7090604, 7089397, 7086139, 7085812, 7085071, 7080218, 7078854, 7078320, 7077364, 7071289, 7068477, 7066233, 7060565, 7049437, 7047489, 7035504, 7031489, 7023595, 7003031, 7002971, 7001856, 6998353, 6972151, 6967177, 13662, 12437, 10733, 10542, 9816, 9045, 8940, 8918, 7791, 7759, 6695, 5553, 5357, 4936, 4316, 2435, 2184, 2068, 1887, 1345))
Run Time: 0.006768
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 101 | 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: 1635, 0, 1716079884, {"thread-7217837":["thread",7217837],"thread-7215179":["thread",7215179],"thread-7214679":["thread",7214679],"thread-7214334":["thread",7214334],"thread-7210914":["thread",7210914],"thread-7207202":["thread",7207202],"thread-7206753":["thread",7206753],"thread-7206351":["thread",7206351],"thread-7199413":["thread",7199413],"thread-7199206":["thread",7199206],"thread-7198794":["thread",7198794],"thread-7198495":["thread",7198495],"thread-7196484":["thread",7196484],"thread-7192926":["thread",7192926],"thread-7192461":["thread",7192461],"thread-7192454":["thread",7192454],"thread-7183364":["thread",7183364],"thread-7181773":["thread",7181773],"thread-7181619":["thread",7181619],"thread-7181518":["thread",7181518],"thread-7181130":["thread",7181130],"thread-7178714":["thread",7178714],"thread-7174645":["thread",7174645],"thread-7174313":["thread",7174313],"thread-7173025":["thread",7173025],"thread-7171525":["thread",7171525],"thread-7170130":["thread",7170130],"thread-7167656":["thread",7167656],"thread-7164545":["thread",7164545],"thread-7161801":["thread",7161801],"thread-7159576":["thread",7159576],"thread-7159024":["thread",7159024],"thread-7159000":["thread",7159000],"thread-7158423":["thread",7158423],"thread-7155749":["thread",7155749],"thread-7153746":["thread",7153746],"thread-7147788":["thread",7147788],"thread-7146170":["thread",7146170],"thread-7143459":["thread",7143459],"thread-7140965":["thread",7140965],"thread-7138730":["thread",7138730],"thread-7138627":["thread",7138627],"thread-7136156":["thread",7136156],"thread-7135718":["thread",7135718],"thread-7134286":["thread",7134286],"thread-7131125":["thread",7131125],"thread-7130856":["thread",7130856],"thread-7130710":["thread",7130710],"thread-7129994":["thread",7129994],"thread-7129987":["thread",7129987],"thread-7129837":["thread",7129837],"thread-7128217":["thread",7128217],"thread-7122195":["thread",7122195],"thread-7117217":["thread",7117217],"thread-7108597":["thread",7108597],"thread-7101779":["thread",7101779],"thread-7099245":["thread",7099245],"thread-7090604":["thread",7090604],"thread-7089397":["thread",7089397],"thread-7086139":["thread",7086139],"thread-7085812":["thread",7085812],"thread-7085071":["thread",7085071],"thread-7080218":["thread",7080218],"thread-7078854":["thread",7078854],"thread-7078320":["thread",7078320],"thread-7077364":["thread",7077364],"thread-7071289":["thread",7071289],"thread-7068477":["thread",7068477],"thread-7066233":["thread",7066233],"thread-7060565":["thread",7060565],"thread-7049437":["thread",7049437],"thread-7047489":["thread",7047489],"thread-7035504":["thread",7035504],"thread-7031489":["thread",7031489],"thread-7023595":["thread",7023595],"thread-7003031":["thread",7003031],"thread-7002971":["thread",7002971],"thread-7001856":["thread",7001856],"thread-6998353":["thread",6998353],"thread-6972151":["thread",6972151],"thread-6967177":["thread",6967177],"thread-13662":["thread",13662],"thread-12437":["thread",12437],"thread-10733":["thread",10733],"thread-10542":["thread",10542],"thread-9816":["thread",9816],"thread-9045":["thread",9045],"thread-8940":["thread",8940],"thread-8918":["thread",8918],"thread-7791":["thread",7791],"thread-7759":["thread",7759],"thread-6695":["thread",6695],"thread-5553":["thread",5553],"thread-5357":["thread",5357],"thread-4936":["thread",4936],"thread-4316":["thread",4316],"thread-2435":["thread",2435],"thread-2184":["thread",2184],"thread-2068":["thread",2068],"thread-1887":["thread",1887],"thread-1345":["thread",1345]}, NULL, 1716076284
Run Time: 0.000491
- 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