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 (7215115, 7205198, 7197298, 7194721, 7190222, 7185267, 7177592, 7172697, 7152999, 7150322, 7150200, 7147498, 7134740, 7129112, 7129108, 7122752, 7118490, 7116964, 7116963, 7113198, 7111169, 7108752, 7102971, 7098247, 7097025, 7096881, 7093097, 7087105, 7086860, 7083331, 7047554, 7035934, 7028256, 7018509, 7016619, 7016196, 7014066, 6996910, 6967143, 6962109, 6960472, 6956905, 6956322, 6822170, 6789130, 6410590, 6274365, 234568, 231101, 225812, 223842, 189578, 185161, 161040, 13748, 13335, 12911, 12900, 12788, 12128, 11976, 11791, 11717, 11709, 11676, 11576, 11487, 11237, 11146, 10610, 9942, 9092, 8578, 8487, 8311, 7722, 7636, 7533, 7532, 7440, 7227, 6638, 5955, 5887, 5791, 5526, 5402, 5284, 5233, 5207, 4472, 4222, 4196, 4004, 3720, 3592, 3519, 3295, 2289, 2247, 2173, 1491, 1289, 1091, 1071, 885, 116))
Run Time: 0.006969
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 107 | 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: 85, 0, 1714712764, {"thread-7215115":["thread",7215115],"thread-7205198":["thread",7205198],"thread-7197298":["thread",7197298],"thread-7194721":["thread",7194721],"thread-7190222":["thread",7190222],"thread-7185267":["thread",7185267],"thread-7177592":["thread",7177592],"thread-7172697":["thread",7172697],"thread-7152999":["thread",7152999],"thread-7150322":["thread",7150322],"thread-7150200":["thread",7150200],"thread-7147498":["thread",7147498],"thread-7134740":["thread",7134740],"thread-7129112":["thread",7129112],"thread-7129108":["thread",7129108],"thread-7122752":["thread",7122752],"thread-7118490":["thread",7118490],"thread-7116964":["thread",7116964],"thread-7116963":["thread",7116963],"thread-7113198":["thread",7113198],"thread-7111169":["thread",7111169],"thread-7108752":["thread",7108752],"thread-7102971":["thread",7102971],"thread-7098247":["thread",7098247],"thread-7097025":["thread",7097025],"thread-7096881":["thread",7096881],"thread-7093097":["thread",7093097],"thread-7087105":["thread",7087105],"thread-7086860":["thread",7086860],"thread-7083331":["thread",7083331],"thread-7047554":["thread",7047554],"thread-7035934":["thread",7035934],"thread-7028256":["thread",7028256],"thread-7018509":["thread",7018509],"thread-7016619":["thread",7016619],"thread-7016196":["thread",7016196],"thread-7014066":["thread",7014066],"thread-6996910":["thread",6996910],"thread-6967143":["thread",6967143],"thread-6962109":["thread",6962109],"thread-6960472":["thread",6960472],"thread-6956905":["thread",6956905],"thread-6956322":["thread",6956322],"thread-6822170":["thread",6822170],"thread-6789130":["thread",6789130],"thread-6274365":["thread",6274365],"thread-234568":["thread",234568],"thread-231101":["thread",231101],"thread-225812":["thread",225812],"thread-223842":["thread",223842],"thread-189578":["thread",189578],"thread-185161":["thread",185161],"thread-161040":["thread",161040],"thread-13748":["thread",13748],"thread-13335":["thread",13335],"thread-12911":["thread",12911],"thread-12900":["thread",12900],"thread-12788":["thread",12788],"thread-12128":["thread",12128],"thread-11976":["thread",11976],"thread-11791":["thread",11791],"thread-11717":["thread",11717],"thread-11709":["thread",11709],"thread-11676":["thread",11676],"thread-11576":["thread",11576],"thread-11487":["thread",11487],"thread-11237":["thread",11237],"thread-11146":["thread",11146],"thread-10610":["thread",10610],"thread-9942":["thread",9942],"thread-9092":["thread",9092],"thread-8578":["thread",8578],"thread-8487":["thread",8487],"thread-8311":["thread",8311],"thread-7722":["thread",7722],"thread-7636":["thread",7636],"thread-7533":["thread",7533],"thread-7532":["thread",7532],"thread-7440":["thread",7440],"thread-7227":["thread",7227],"thread-6638":["thread",6638],"thread-5955":["thread",5955],"thread-5887":["thread",5887],"thread-5791":["thread",5791],"thread-5526":["thread",5526],"thread-5402":["thread",5402],"thread-5284":["thread",5284],"thread-5233":["thread",5233],"thread-5207":["thread",5207],"thread-4472":["thread",4472],"thread-4222":["thread",4222],"thread-4196":["thread",4196],"thread-4004":["thread",4004],"thread-3720":["thread",3720],"thread-3592":["thread",3592],"thread-3519":["thread",3519],"thread-3295":["thread",3295],"thread-2289":["thread",2289],"thread-2247":["thread",2247],"thread-2173":["thread",2173],"thread-1491":["thread",1491],"thread-1289":["thread",1289],"thread-1091":["thread",1091],"thread-1071":["thread",1071],"thread-885":["thread",885],"thread-116":["thread",116]}, NULL, 1714709164
Run Time: 0.012618
- 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