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 (7215228, 7215037, 7214811, 7209675, 7207377, 7206596, 7202265, 7201656, 7197833, 7194391, 7192745, 7192136, 7192035, 7188906, 7185901, 7182695, 7182063, 7173066, 7171416, 7170297, 7170124, 7162785, 7154791, 7152179, 7147244, 7144002, 7142188, 7140423, 7138959, 7137857, 7136344, 7133395, 7132528, 7131942, 7128666, 7128138, 7124912, 7124064, 7123958, 7120172, 7118381, 7117229, 7112270, 7111185, 7108057, 7105865, 7103637, 7096376, 7093379, 7082526, 7080331, 7079582, 7079466, 7078823, 7078411, 7077949, 7071706, 7063627, 7057574, 7053494, 7053149, 7050439, 7044995, 7044420, 7041719, 7041716, 7001811, 6991230, 6982364, 6978679, 6972308, 6970444, 6765006, 178651, 174245, 13509, 13280, 13173, 13119, 12985, 12780, 12564, 11971, 11967, 11922, 11590, 11576, 11247, 11160, 10931, 10843, 10279, 10182, 9984, 9809, 9723, 9324, 8829, 8614, 8276, 8239, 8147, 8123, 8121, 7933, 7925, 7419, 7337, 6895, 6809, 6664, 6521, 6414, 6370, 5938, 5806, 5790, 5785, 5671, 5648, 5625, 5525, 5432, 5102, 4776, 4473, 4467, 4312, 3280, 3204, 3040, 2867, 2591, 2064, 1209, 935, 494, 240))
Run Time: 0.007751
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 138 | 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: 193, 0, 1714280998, {"thread-7215228":["thread",7215228],"thread-7215037":["thread",7215037],"thread-7214811":["thread",7214811],"thread-7209675":["thread",7209675],"thread-7207377":["thread",7207377],"thread-7206596":["thread",7206596],"thread-7202265":["thread",7202265],"thread-7201656":["thread",7201656],"thread-7197833":["thread",7197833],"thread-7194391":["thread",7194391],"thread-7192745":["thread",7192745],"thread-7192136":["thread",7192136],"thread-7192035":["thread",7192035],"thread-7188906":["thread",7188906],"thread-7185901":["thread",7185901],"thread-7182695":["thread",7182695],"thread-7182063":["thread",7182063],"thread-7173066":["thread",7173066],"thread-7171416":["thread",7171416],"thread-7170297":["thread",7170297],"thread-7170124":["thread",7170124],"thread-7162785":["thread",7162785],"thread-7154791":["thread",7154791],"thread-7152179":["thread",7152179],"thread-7147244":["thread",7147244],"thread-7144002":["thread",7144002],"thread-7142188":["thread",7142188],"thread-7140423":["thread",7140423],"thread-7138959":["thread",7138959],"thread-7137857":["thread",7137857],"thread-7136344":["thread",7136344],"thread-7133395":["thread",7133395],"thread-7132528":["thread",7132528],"thread-7131942":["thread",7131942],"thread-7128666":["thread",7128666],"thread-7128138":["thread",7128138],"thread-7124912":["thread",7124912],"thread-7124064":["thread",7124064],"thread-7123958":["thread",7123958],"thread-7120172":["thread",7120172],"thread-7118381":["thread",7118381],"thread-7117229":["thread",7117229],"thread-7112270":["thread",7112270],"thread-7111185":["thread",7111185],"thread-7108057":["thread",7108057],"thread-7105865":["thread",7105865],"thread-7103637":["thread",7103637],"thread-7096376":["thread",7096376],"thread-7093379":["thread",7093379],"thread-7082526":["thread",7082526],"thread-7080331":["thread",7080331],"thread-7079582":["thread",7079582],"thread-7079466":["thread",7079466],"thread-7078823":["thread",7078823],"thread-7078411":["thread",7078411],"thread-7077949":["thread",7077949],"thread-7071706":["thread",7071706],"thread-7063627":["thread",7063627],"thread-7057574":["thread",7057574],"thread-7053494":["thread",7053494],"thread-7053149":["thread",7053149],"thread-7050439":["thread",7050439],"thread-7044995":["thread",7044995],"thread-7044420":["thread",7044420],"thread-7041719":["thread",7041719],"thread-7041716":["thread",7041716],"thread-7001811":["thread",7001811],"thread-6991230":["thread",6991230],"thread-6982364":["thread",6982364],"thread-6978679":["thread",6978679],"thread-6972308":["thread",6972308],"thread-6970444":["thread",6970444],"thread-6765006":["thread",6765006],"thread-178651":["thread",178651],"thread-174245":["thread",174245],"thread-13509":["thread",13509],"thread-13280":["thread",13280],"thread-13173":["thread",13173],"thread-13119":["thread",13119],"thread-12985":["thread",12985],"thread-12780":["thread",12780],"thread-12564":["thread",12564],"thread-11971":["thread",11971],"thread-11967":["thread",11967],"thread-11922":["thread",11922],"thread-11590":["thread",11590],"thread-11576":["thread",11576],"thread-11247":["thread",11247],"thread-11160":["thread",11160],"thread-10931":["thread",10931],"thread-10843":["thread",10843],"thread-10279":["thread",10279],"thread-10182":["thread",10182],"thread-9984":["thread",9984],"thread-9809":["thread",9809],"thread-9723":["thread",9723],"thread-9324":["thread",9324],"thread-8829":["thread",8829],"thread-8614":["thread",8614],"thread-8276":["thread",8276],"thread-8239":["thread",8239],"thread-8147":["thread",8147],"thread-8123":["thread",8123],"thread-8121":["thread",8121],"thread-7933":["thread",7933],"thread-7925":["thread",7925],"thread-7419":["thread",7419],"thread-7337":["thread",7337],"thread-6895":["thread",6895],"thread-6809":["thread",6809],"thread-6664":["thread",6664],"thread-6521":["thread",6521],"thread-6414":["thread",6414],"thread-6370":["thread",6370],"thread-5938":["thread",5938],"thread-5806":["thread",5806],"thread-5790":["thread",5790],"thread-5785":["thread",5785],"thread-5671":["thread",5671],"thread-5648":["thread",5648],"thread-5625":["thread",5625],"thread-5525":["thread",5525],"thread-5432":["thread",5432],"thread-5102":["thread",5102],"thread-4776":["thread",4776],"thread-4473":["thread",4473],"thread-4467":["thread",4467],"thread-4312":["thread",4312],"thread-3280":["thread",3280],"thread-3204":["thread",3204],"thread-3040":["thread",3040],"thread-2867":["thread",2867],"thread-2591":["thread",2591],"thread-2064":["thread",2064],"thread-1209":["thread",1209],"thread-935":["thread",935],"thread-494":["thread",494],"thread-240":["thread",240]}, NULL, 1714277398
Run Time: 0.000796
- 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