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 (7217194, 7215162, 7214679, 7214334, 7213250, 7212024, 7209176, 7208421, 7207738, 7204837, 7204617, 7204343, 7202798, 7199832, 7199067, 7198412, 7197838, 7196433, 7194546, 7194355, 7193141, 7192926, 7192914, 7192035, 7191679, 7191118, 7189128, 7187223, 7183540, 7183445, 7181465, 7180894, 7180486, 7177430, 7177412, 7176956, 7173025, 7172734, 7171660, 7171492, 7170250, 7170124, 7169936, 7169071, 7165927, 7165919, 7165223, 7162673, 7158049, 7155926, 7154342, 7152775, 7150583, 7145576, 7142232, 7140965, 7140397, 7139783, 7138988, 7138903, 7136844, 7136179, 7131923, 7131816, 7130847, 7122813, 7120033, 7115946, 7113074, 7110021, 7107120, 7106788, 7106669, 7106292, 7086565, 7085071, 7083060, 7079479, 7078541, 7078411, 7071421, 7071360, 7070066, 7061907, 7052534, 7049514, 7034348, 7032911, 7024085, 7015317, 7013930, 7007805, 7003251, 6849152, 6841382, 6779617, 6732690, 6656267, 6517092, 6384557, 6296912, 6279873, 6266664, 6266315, 217124, 215847, 201283, 198697, 198583, 195525, 191115, 190172, 184966, 181341, 177033, 174966, 174225, 167263, 163600, 160917, 160421, 160385, 160299, 6252516, 13714, 13711, 13655, 13646, 13645, 13620, 13578, 13553, 13528, 13509, 13476, 13461, 13443, 13433, 13380, 13379, 13368, 13276, 13242, 13240, 13196, 13147, 13143, 13136, 13078, 13069, 13020, 13017, 13014, 12992, 12966, 12884, 12869, 12838, 12784, 12775, 12728, 12690, 12671, 12663, 12638, 12636, 12631, 12629, 12625, 12623, 12608, 12596, 12584, 12570, 12488, 12463, 12459, 12398, 12396, 12335, 12324, 12208, 12177, 12115, 12078, 12068, 12044, 12023, 12019, 12016, 11969, 11954, 11949, 11922, 11891, 11876, 11874, 11866, 11754))
Run Time: 0.011423
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 199 | 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: 4, 0, 1715562923, {"thread-7217194":["thread",7217194],"thread-7215162":["thread",7215162],"thread-7214679":["thread",7214679],"thread-7214334":["thread",7214334],"thread-7213250":["thread",7213250],"thread-7212024":["thread",7212024],"thread-7209176":["thread",7209176],"thread-7208421":["thread",7208421],"thread-7207738":["thread",7207738],"thread-7204837":["thread",7204837],"thread-7204617":["thread",7204617],"thread-7204343":["thread",7204343],"thread-7202798":["thread",7202798],"thread-7199832":["thread",7199832],"thread-7199067":["thread",7199067],"thread-7198412":["thread",7198412],"thread-7197838":["thread",7197838],"thread-7196433":["thread",7196433],"thread-7194546":["thread",7194546],"thread-7194355":["thread",7194355],"thread-7193141":["thread",7193141],"thread-7192926":["thread",7192926],"thread-7192914":["thread",7192914],"thread-7192035":["thread",7192035],"thread-7191679":["thread",7191679],"thread-7191118":["thread",7191118],"thread-7189128":["thread",7189128],"thread-7187223":["thread",7187223],"thread-7183540":["thread",7183540],"thread-7183445":["thread",7183445],"thread-7181465":["thread",7181465],"thread-7180894":["thread",7180894],"thread-7180486":["thread",7180486],"thread-7177430":["thread",7177430],"thread-7177412":["thread",7177412],"thread-7176956":["thread",7176956],"thread-7173025":["thread",7173025],"thread-7172734":["thread",7172734],"thread-7171660":["thread",7171660],"thread-7171492":["thread",7171492],"thread-7170250":["thread",7170250],"thread-7170124":["thread",7170124],"thread-7169936":["thread",7169936],"thread-7169071":["thread",7169071],"thread-7165927":["thread",7165927],"thread-7165919":["thread",7165919],"thread-7165223":["thread",7165223],"thread-7162673":["thread",7162673],"thread-7158049":["thread",7158049],"thread-7155926":["thread",7155926],"thread-7154342":["thread",7154342],"thread-7152775":["thread",7152775],"thread-7150583":["thread",7150583],"thread-7145576":["thread",7145576],"thread-7142232":["thread",7142232],"thread-7140965":["thread",7140965],"thread-7140397":["thread",7140397],"thread-7139783":["thread",7139783],"thread-7138988":["thread",7138988],"thread-7138903":["thread",7138903],"thread-7136844":["thread",7136844],"thread-7136179":["thread",7136179],"thread-7131923":["thread",7131923],"thread-7131816":["thread",7131816],"thread-7130847":["thread",7130847],"thread-7122813":["thread",7122813],"thread-7120033":["thread",7120033],"thread-7115946":["thread",7115946],"thread-7113074":["thread",7113074],"thread-7110021":["thread",7110021],"thread-7107120":["thread",7107120],"thread-7106788":["thread",7106788],"thread-7106669":["thread",7106669],"thread-7106292":["thread",7106292],"thread-7086565":["thread",7086565],"thread-7085071":["thread",7085071],"thread-7083060":["thread",7083060],"thread-7079479":["thread",7079479],"thread-7078541":["thread",7078541],"thread-7078411":["thread",7078411],"thread-7071421":["thread",7071421],"thread-7071360":["thread",7071360],"thread-7070066":["thread",7070066],"thread-7061907":["thread",7061907],"thread-7052534":["thread",7052534],"thread-7049514":["thread",7049514],"thread-7034348":["thread",7034348],"thread-7032911":["thread",7032911],"thread-7024085":["thread",7024085],"thread-7015317":["thread",7015317],"thread-7013930":["thread",7013930],"thread-7007805":["thread",7007805],"thread-7003251":["thread",7003251],"xfmg_media-1389":["xfmg_media",1389],"thread-6849152":["thread",6849152],"thread-6841382":["thread",6841382],"thread-6779617":["thread",6779617],"thread-6732690":["thread",6732690],"thread-6656267":["thread",6656267],"thread-6517092":["thread",6517092],"thread-6384557":["thread",6384557],"thread-6296912":["thread",6296912],"thread-6279873":["thread",6279873],"thread-6266664":["thread",6266664],"thread-6266315":["thread",6266315],"thread-217124":["thread",217124],"thread-201283":["thread",201283],"thread-198697":["thread",198697],"thread-198583":["thread",198583],"thread-195525":["thread",195525],"thread-191115":["thread",191115],"thread-190172":["thread",190172],"thread-184966":["thread",184966],"thread-181341":["thread",181341],"thread-177033":["thread",177033],"thread-174966":["thread",174966],"thread-174225":["thread",174225],"thread-167263":["thread",167263],"thread-163600":["thread",163600],"thread-160421":["thread",160421],"thread-160385":["thread",160385],"thread-160299":["thread",160299],"thread-6252516":["thread",6252516],"thread-13714":["thread",13714],"thread-13711":["thread",13711],"thread-13655":["thread",13655],"thread-13646":["thread",13646],"thread-13645":["thread",13645],"thread-13620":["thread",13620],"thread-13578":["thread",13578],"thread-13553":["thread",13553],"thread-13528":["thread",13528],"thread-13509":["thread",13509],"thread-13476":["thread",13476],"thread-13461":["thread",13461],"thread-13443":["thread",13443],"thread-13433":["thread",13433],"thread-13380":["thread",13380],"thread-13379":["thread",13379],"thread-13368":["thread",13368],"thread-13276":["thread",13276],"thread-13242":["thread",13242],"thread-13240":["thread",13240],"thread-13196":["thread",13196],"thread-13147":["thread",13147],"thread-13143":["thread",13143],"thread-13136":["thread",13136],"thread-13078":["thread",13078],"thread-13069":["thread",13069],"thread-13020":["thread",13020],"thread-13017":["thread",13017],"thread-13014":["thread",13014],"thread-12992":["thread",12992],"thread-12966":["thread",12966],"thread-12884":["thread",12884],"thread-12869":["thread",12869],"thread-12838":["thread",12838],"thread-12784":["thread",12784],"thread-12775":["thread",12775],"thread-12728":["thread",12728],"thread-12690":["thread",12690],"thread-12671":["thread",12671],"thread-12663":["thread",12663],"thread-12638":["thread",12638],"thread-12636":["thread",12636],"thread-12631":["thread",12631],"thread-12629":["thread",12629],"thread-12625":["thread",12625],"thread-12623":["thread",12623],"thread-12608":["thread",12608],"thread-12596":["thread",12596],"thread-12584":["thread",12584],"thread-12570":["thread",12570],"thread-12488":["thread",12488],"thread-12463":["thread",12463],"thread-12459":["thread",12459],"thread-12398":["thread",12398],"thread-12396":["thread",12396],"thread-12335":["thread",12335],"thread-12324":["thread",12324],"thread-12208":["thread",12208],"thread-12177":["thread",12177],"thread-12115":["thread",12115],"thread-12078":["thread",12078],"thread-12068":["thread",12068],"thread-12044":["thread",12044],"thread-12023":["thread",12023],"thread-12019":["thread",12019],"thread-12016":["thread",12016],"thread-11969":["thread",11969],"thread-11954":["thread",11954],"thread-11949":["thread",11949],"thread-11922":["thread",11922],"thread-11891":["thread",11891],"thread-11876":["thread",11876],"thread-11874":["thread",11874],"thread-11866":["thread",11866],"thread-11754":["thread",11754]}, NULL, 1715559323
Run Time: 0.000573
- 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