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 (7215975, 7215546, 7215179, 7204837, 7202777, 7200725, 7199811, 7198886, 7198156, 7195943, 7195001, 7191616, 7190678, 7190091, 7189590, 7189073, 7188920, 7184520, 7182918, 7180305, 7175295, 7174467, 7167862, 7166598, 7163146, 7160124, 7155171, 7153787, 7151606, 7147091, 7143821, 7140263, 7137423, 7130114, 7120596, 7114523, 7104850, 7104478, 7100052, 7097198, 7088181, 7087564, 7085102, 7084579, 7082999, 7079722, 7068529, 7068416, 7062904, 7062510, 7060830, 7060194, 7054374, 7053159, 7052253, 7048945, 7048137, 7047188, 7044575, 7022532, 7009490, 7003713, 6975802, 6966383, 241638, 238594, 236803, 228996, 227057, 225489, 220378, 213615, 211524, 203361, 202882, 202333, 201060, 199104, 194409, 190937, 190641, 189829, 186899, 184886, 182680, 181258, 177034, 176666, 172065, 171466, 170455, 170323, 168694, 166648, 165937, 163728, 162500, 160974, 160773))
Run Time: 0.006160
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 99 | 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: 8367, 0, 1714361132, {"thread-7215975":["thread",7215975],"thread-7215546":["thread",7215546],"thread-7215179":["thread",7215179],"thread-7204837":["thread",7204837],"thread-7202777":["thread",7202777],"thread-7200725":["thread",7200725],"thread-7199811":["thread",7199811],"thread-7198886":["thread",7198886],"thread-7198156":["thread",7198156],"thread-7195943":["thread",7195943],"thread-7195001":["thread",7195001],"thread-7191616":["thread",7191616],"thread-7190678":["thread",7190678],"thread-7190091":["thread",7190091],"thread-7189590":["thread",7189590],"thread-7189073":["thread",7189073],"thread-7188920":["thread",7188920],"thread-7184520":["thread",7184520],"thread-7182918":["thread",7182918],"thread-7180305":["thread",7180305],"thread-7175295":["thread",7175295],"thread-7174467":["thread",7174467],"thread-7167862":["thread",7167862],"thread-7166598":["thread",7166598],"thread-7163146":["thread",7163146],"thread-7160124":["thread",7160124],"thread-7155171":["thread",7155171],"thread-7153787":["thread",7153787],"thread-7151606":["thread",7151606],"thread-7147091":["thread",7147091],"thread-7143821":["thread",7143821],"thread-7140263":["thread",7140263],"thread-7137423":["thread",7137423],"thread-7130114":["thread",7130114],"thread-7120596":["thread",7120596],"thread-7114523":["thread",7114523],"thread-7104850":["thread",7104850],"thread-7104478":["thread",7104478],"thread-7100052":["thread",7100052],"thread-7097198":["thread",7097198],"thread-7088181":["thread",7088181],"thread-7087564":["thread",7087564],"thread-7085102":["thread",7085102],"thread-7084579":["thread",7084579],"thread-7082999":["thread",7082999],"thread-7079722":["thread",7079722],"thread-7068529":["thread",7068529],"thread-7068416":["thread",7068416],"thread-7062904":["thread",7062904],"thread-7062510":["thread",7062510],"thread-7060830":["thread",7060830],"thread-7060194":["thread",7060194],"thread-7054374":["thread",7054374],"thread-7053159":["thread",7053159],"thread-7052253":["thread",7052253],"thread-7048945":["thread",7048945],"thread-7048137":["thread",7048137],"thread-7047188":["thread",7047188],"thread-7044575":["thread",7044575],"thread-7022532":["thread",7022532],"thread-7009490":["thread",7009490],"thread-7003713":["thread",7003713],"thread-6975802":["thread",6975802],"thread-6966383":["thread",6966383],"thread-241638":["thread",241638],"thread-238594":["thread",238594],"thread-236803":["thread",236803],"thread-228996":["thread",228996],"thread-227057":["thread",227057],"thread-225489":["thread",225489],"thread-220378":["thread",220378],"thread-213615":["thread",213615],"thread-211524":["thread",211524],"thread-203361":["thread",203361],"thread-202882":["thread",202882],"thread-202333":["thread",202333],"thread-201060":["thread",201060],"thread-199104":["thread",199104],"thread-194409":["thread",194409],"thread-190937":["thread",190937],"thread-190641":["thread",190641],"thread-189829":["thread",189829],"thread-186899":["thread",186899],"thread-184886":["thread",184886],"thread-182680":["thread",182680],"thread-181258":["thread",181258],"thread-177034":["thread",177034],"thread-176666":["thread",176666],"thread-172065":["thread",172065],"thread-171466":["thread",171466],"thread-170455":["thread",170455],"thread-170323":["thread",170323],"thread-168694":["thread",168694],"thread-166648":["thread",166648],"thread-165937":["thread",165937],"thread-163728":["thread",163728],"thread-162500":["thread",162500],"thread-160974":["thread",160974],"thread-160773":["thread",160773]}, NULL, 1714357532
Run Time: 0.000413
- 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