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 (7216466, 7215038, 7213117, 7212024, 7207199, 7204810, 7196949, 7192605, 7185925, 7184322, 7183540, 7155738, 7149128, 7148180, 7139877, 7136656, 7130848, 7130842, 7129106, 7129005, 7129002, 7128259, 7127590, 7127588, 7127553, 7122364, 7120016, 7119968, 7118065, 7117067, 7117063, 7117021, 7114302, 7113826, 7113284, 7111608, 7111090, 7111078, 7107983, 7107157, 7090029, 7088950, 7088730, 7086881, 7084857, 7082484, 7081245, 7080387, 7075638, 7065409, 7046268, 7046211, 7041716, 7033100, 7013231, 6989434, 6972090, 6722994, 6630009, 226953, 222245, 214103, 213546, 205591, 200573, 199878, 198583, 198156, 190373, 189063, 188983, 180277, 176331, 172119, 13703, 13505, 13368, 13294, 12396, 12162, 12105, 11370, 10773, 10758, 9325, 8975, 8962, 8217, 8197, 7956, 7800, 7697, 7635, 7596, 7256, 6898, 6828, 6539, 6318, 6294, 5937, 5727, 5591, 5405, 4476, 4468, 4183, 4025, 3974, 3731, 3590, 3539, 3464, 3108, 2954, 2943, 2760, 2747, 2717, 2451))
Run Time: 0.009165
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 120 | 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: 2659, 0, 1716265939, {"thread-7216466":["thread",7216466],"thread-7215038":["thread",7215038],"thread-7213117":["thread",7213117],"thread-7212024":["thread",7212024],"thread-7207199":["thread",7207199],"thread-7204810":["thread",7204810],"thread-7196949":["thread",7196949],"thread-7192605":["thread",7192605],"thread-7185925":["thread",7185925],"thread-7184322":["thread",7184322],"thread-7183540":["thread",7183540],"thread-7155738":["thread",7155738],"thread-7149128":["thread",7149128],"thread-7148180":["thread",7148180],"thread-7139877":["thread",7139877],"thread-7136656":["thread",7136656],"thread-7130848":["thread",7130848],"thread-7130842":["thread",7130842],"thread-7129106":["thread",7129106],"thread-7129005":["thread",7129005],"thread-7129002":["thread",7129002],"thread-7128259":["thread",7128259],"thread-7127590":["thread",7127590],"thread-7127588":["thread",7127588],"thread-7127553":["thread",7127553],"thread-7122364":["thread",7122364],"thread-7120016":["thread",7120016],"thread-7119968":["thread",7119968],"thread-7118065":["thread",7118065],"thread-7117067":["thread",7117067],"thread-7117063":["thread",7117063],"thread-7117021":["thread",7117021],"thread-7114302":["thread",7114302],"thread-7113826":["thread",7113826],"thread-7113284":["thread",7113284],"thread-7111608":["thread",7111608],"thread-7111090":["thread",7111090],"thread-7111078":["thread",7111078],"thread-7107983":["thread",7107983],"thread-7107157":["thread",7107157],"thread-7090029":["thread",7090029],"thread-7088950":["thread",7088950],"thread-7088730":["thread",7088730],"thread-7086881":["thread",7086881],"thread-7084857":["thread",7084857],"thread-7082484":["thread",7082484],"thread-7081245":["thread",7081245],"thread-7080387":["thread",7080387],"thread-7075638":["thread",7075638],"thread-7065409":["thread",7065409],"thread-7046268":["thread",7046268],"thread-7046211":["thread",7046211],"thread-7041716":["thread",7041716],"thread-7033100":["thread",7033100],"thread-7013231":["thread",7013231],"thread-6989434":["thread",6989434],"thread-6972090":["thread",6972090],"thread-6722994":["thread",6722994],"thread-6630009":["thread",6630009],"thread-226953":["thread",226953],"thread-222245":["thread",222245],"thread-214103":["thread",214103],"thread-213546":["thread",213546],"thread-205591":["thread",205591],"thread-200573":["thread",200573],"thread-199878":["thread",199878],"thread-198583":["thread",198583],"thread-198156":["thread",198156],"thread-190373":["thread",190373],"thread-189063":["thread",189063],"thread-188983":["thread",188983],"thread-180277":["thread",180277],"thread-176331":["thread",176331],"thread-172119":["thread",172119],"thread-13703":["thread",13703],"thread-13505":["thread",13505],"thread-13368":["thread",13368],"thread-13294":["thread",13294],"thread-12396":["thread",12396],"thread-12162":["thread",12162],"thread-12105":["thread",12105],"thread-11370":["thread",11370],"thread-10773":["thread",10773],"thread-10758":["thread",10758],"thread-9325":["thread",9325],"thread-8975":["thread",8975],"thread-8962":["thread",8962],"thread-8217":["thread",8217],"thread-8197":["thread",8197],"thread-7956":["thread",7956],"thread-7800":["thread",7800],"thread-7697":["thread",7697],"thread-7635":["thread",7635],"thread-7596":["thread",7596],"thread-7256":["thread",7256],"thread-6898":["thread",6898],"thread-6828":["thread",6828],"thread-6539":["thread",6539],"thread-6318":["thread",6318],"thread-6294":["thread",6294],"thread-5937":["thread",5937],"thread-5727":["thread",5727],"thread-5591":["thread",5591],"thread-5405":["thread",5405],"thread-4476":["thread",4476],"thread-4468":["thread",4468],"thread-4183":["thread",4183],"thread-4025":["thread",4025],"thread-3974":["thread",3974],"thread-3731":["thread",3731],"thread-3590":["thread",3590],"thread-3539":["thread",3539],"thread-3464":["thread",3464],"thread-3108":["thread",3108],"thread-2954":["thread",2954],"thread-2943":["thread",2943],"thread-2760":["thread",2760],"thread-2747":["thread",2747],"thread-2717":["thread",2717],"thread-2451":["thread",2451]}, NULL, 1716262339
Run Time: 0.001094
- 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