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 (7218415, 7218276, 7218272, 7218264, 7218122, 7217294, 7217232, 7216018, 7215984, 7215342, 7214073, 7212986, 7212168, 7212068, 7212049, 7211793, 7211432, 7210523, 7209503, 7208233, 7206580, 7206023, 7205756, 7204810, 7203709, 7201997, 7201778, 7201477, 7200373, 7199412, 7199304, 7199005, 7198644, 7198369, 7198344, 7198340, 7196793, 7195591, 7193249, 7193035, 7192753, 7192335, 7191633, 7191516, 7190987, 7190090, 7189629, 7188935, 7187866, 7187786, 7187524, 7187337, 7186945, 7186394, 7185681, 7185112, 7184646, 7184437, 7184098, 7183708, 7183499, 7183244, 7182903, 7182428, 7182086, 7181241, 7180099, 7178831, 7178228, 7177999, 7177894, 7177664, 7177538, 7177535, 7177489, 7176956, 7176517, 7176452, 7176306, 7174538, 7174467, 7174307, 7173329, 7172734, 7171858, 7171660, 7171437, 7170727, 7170553, 7170190, 7170001, 7169478, 7169059, 7168513, 7163814, 7163245, 7161803, 7160654, 7159205, 7158006, 7157624, 7157455, 7157121, 7155914, 7155411, 7154769, 7153169, 7152501, 7151270, 7151020, 7150099, 7149369, 7148519, 7148476, 7148075, 7147814, 7147605, 7147581, 7147324, 7147213, 7145959, 7143939, 7143524, 7143426, 7143162, 7142650, 7142313, 7141943, 7141887, 7140965, 7140397, 7140132, 7139968, 7139691, 7138988, 7138345, 7137848, 7137645, 7137582, 7137581, 7137304, 7137061, 7136609, 7136559, 7136271, 7135743, 7135684, 7134959, 7134862, 7134522, 7133277, 7133276, 7133072, 7132787, 7131923, 7131917, 7131204, 7130817, 7130814, 7130089, 7129037, 7128782, 7126364, 7125762, 7125410, 7124754, 7124673, 7124474, 7123565, 7122597, 7122141, 7120065, 7119607, 7119587, 7115357, 7114734, 7114614, 7114313, 7114305, 7114215, 7113875, 7112450, 7112416, 7109623, 7109179, 7109123, 7108530, 7108403, 7108063, 7107550, 7106769, 7106672, 7106627, 7106388, 7106259, 7106252, 7106020, 7105956, 7105850))
Run Time: 0.013517
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: 64, 0, 1715809305, {"thread-7218415":["thread",7218415],"thread-7218276":["thread",7218276],"thread-7218272":["thread",7218272],"thread-7218264":["thread",7218264],"thread-7218122":["thread",7218122],"thread-7217294":["thread",7217294],"thread-7217232":["thread",7217232],"thread-7216018":["thread",7216018],"thread-7215984":["thread",7215984],"thread-7215342":["thread",7215342],"thread-7214073":["thread",7214073],"thread-7212986":["thread",7212986],"thread-7212168":["thread",7212168],"thread-7212068":["thread",7212068],"thread-7212049":["thread",7212049],"thread-7211793":["thread",7211793],"thread-7211432":["thread",7211432],"thread-7210523":["thread",7210523],"thread-7209503":["thread",7209503],"thread-7208233":["thread",7208233],"thread-7206580":["thread",7206580],"thread-7206023":["thread",7206023],"thread-7205756":["thread",7205756],"thread-7204810":["thread",7204810],"xfmg_media-3950":["xfmg_media",3950],"thread-7203709":["thread",7203709],"thread-7201997":["thread",7201997],"thread-7201778":["thread",7201778],"thread-7201477":["thread",7201477],"thread-7200373":["thread",7200373],"thread-7199412":["thread",7199412],"thread-7199304":["thread",7199304],"thread-7199005":["thread",7199005],"thread-7198644":["thread",7198644],"thread-7198369":["thread",7198369],"thread-7198344":["thread",7198344],"thread-7198340":["thread",7198340],"thread-7196793":["thread",7196793],"thread-7195591":["thread",7195591],"thread-7193249":["thread",7193249],"thread-7193035":["thread",7193035],"thread-7192753":["thread",7192753],"thread-7192335":["thread",7192335],"thread-7191633":["thread",7191633],"thread-7191516":["thread",7191516],"thread-7190987":["thread",7190987],"thread-7190090":["thread",7190090],"thread-7189629":["thread",7189629],"thread-7187866":["thread",7187866],"thread-7187786":["thread",7187786],"thread-7187524":["thread",7187524],"thread-7187337":["thread",7187337],"thread-7186945":["thread",7186945],"thread-7186394":["thread",7186394],"thread-7185681":["thread",7185681],"thread-7185112":["thread",7185112],"thread-7184646":["thread",7184646],"thread-7184437":["thread",7184437],"thread-7184098":["thread",7184098],"thread-7183708":["thread",7183708],"thread-7183499":["thread",7183499],"thread-7183244":["thread",7183244],"thread-7182903":["thread",7182903],"thread-7182428":["thread",7182428],"thread-7182086":["thread",7182086],"thread-7181241":["thread",7181241],"thread-7180099":["thread",7180099],"thread-7178831":["thread",7178831],"thread-7178228":["thread",7178228],"thread-7177999":["thread",7177999],"thread-7177894":["thread",7177894],"thread-7177664":["thread",7177664],"thread-7177538":["thread",7177538],"thread-7177535":["thread",7177535],"thread-7177489":["thread",7177489],"thread-7176956":["thread",7176956],"thread-7176517":["thread",7176517],"thread-7176452":["thread",7176452],"thread-7176306":["thread",7176306],"thread-7174538":["thread",7174538],"thread-7174467":["thread",7174467],"thread-7174307":["thread",7174307],"thread-7173329":["thread",7173329],"thread-7172734":["thread",7172734],"thread-7171858":["thread",7171858],"thread-7171660":["thread",7171660],"thread-7171437":["thread",7171437],"thread-7170727":["thread",7170727],"thread-7170553":["thread",7170553],"thread-7170190":["thread",7170190],"thread-7170001":["thread",7170001],"thread-7169478":["thread",7169478],"thread-7169059":["thread",7169059],"thread-7168513":["thread",7168513],"thread-7163814":["thread",7163814],"thread-7163245":["thread",7163245],"thread-7161803":["thread",7161803],"thread-7160654":["thread",7160654],"thread-7159205":["thread",7159205],"thread-7158006":["thread",7158006],"thread-7157624":["thread",7157624],"thread-7157455":["thread",7157455],"thread-7157121":["thread",7157121],"thread-7155914":["thread",7155914],"thread-7155411":["thread",7155411],"thread-7154769":["thread",7154769],"thread-7153169":["thread",7153169],"thread-7152501":["thread",7152501],"thread-7151270":["thread",7151270],"thread-7151020":["thread",7151020],"thread-7150099":["thread",7150099],"thread-7149369":["thread",7149369],"thread-7148519":["thread",7148519],"thread-7148476":["thread",7148476],"thread-7148075":["thread",7148075],"thread-7147814":["thread",7147814],"thread-7147605":["thread",7147605],"thread-7147581":["thread",7147581],"thread-7147324":["thread",7147324],"thread-7147213":["thread",7147213],"thread-7145959":["thread",7145959],"thread-7143939":["thread",7143939],"thread-7143524":["thread",7143524],"thread-7143426":["thread",7143426],"thread-7143162":["thread",7143162],"thread-7142650":["thread",7142650],"thread-7142313":["thread",7142313],"thread-7141943":["thread",7141943],"thread-7141887":["thread",7141887],"thread-7140965":["thread",7140965],"thread-7140397":["thread",7140397],"thread-7140132":["thread",7140132],"thread-7139968":["thread",7139968],"thread-7139691":["thread",7139691],"thread-7138988":["thread",7138988],"thread-7138345":["thread",7138345],"thread-7137848":["thread",7137848],"thread-7137645":["thread",7137645],"thread-7137582":["thread",7137582],"thread-7137581":["thread",7137581],"thread-7137304":["thread",7137304],"thread-7137061":["thread",7137061],"thread-7136609":["thread",7136609],"thread-7136559":["thread",7136559],"thread-7136271":["thread",7136271],"thread-7135743":["thread",7135743],"thread-7135684":["thread",7135684],"thread-7134959":["thread",7134959],"thread-7134862":["thread",7134862],"thread-7134522":["thread",7134522],"thread-7133277":["thread",7133277],"thread-7133276":["thread",7133276],"thread-7133072":["thread",7133072],"thread-7132787":["thread",7132787],"thread-7131923":["thread",7131923],"thread-7131917":["thread",7131917],"thread-7131204":["thread",7131204],"thread-7130817":["thread",7130817],"thread-7130814":["thread",7130814],"thread-7130089":["thread",7130089],"thread-7129037":["thread",7129037],"thread-7128782":["thread",7128782],"thread-7126364":["thread",7126364],"thread-7125762":["thread",7125762],"thread-7125410":["thread",7125410],"thread-7124754":["thread",7124754],"thread-7124673":["thread",7124673],"thread-7124474":["thread",7124474],"thread-7123565":["thread",7123565],"thread-7122597":["thread",7122597],"thread-7122141":["thread",7122141],"thread-7120065":["thread",7120065],"thread-7119607":["thread",7119607],"thread-7119587":["thread",7119587],"thread-7115357":["thread",7115357],"thread-7114734":["thread",7114734],"thread-7114614":["thread",7114614],"thread-7114313":["thread",7114313],"thread-7114305":["thread",7114305],"thread-7114215":["thread",7114215],"thread-7113875":["thread",7113875],"thread-7112450":["thread",7112450],"thread-7112416":["thread",7112416],"thread-7109623":["thread",7109623],"thread-7109179":["thread",7109179],"thread-7109123":["thread",7109123],"thread-7108530":["thread",7108530],"thread-7108403":["thread",7108403],"thread-7108063":["thread",7108063],"thread-7107550":["thread",7107550],"thread-7106769":["thread",7106769],"thread-7106672":["thread",7106672],"thread-7106627":["thread",7106627],"thread-7106388":["thread",7106388],"thread-7106259":["thread",7106259],"thread-7106252":["thread",7106252],"thread-7106020":["thread",7106020],"thread-7105956":["thread",7105956],"thread-7105850":["thread",7105850]}, NULL, 1715805705
Run Time: 0.000586
- 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