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 (7216993, 7216887, 7216884, 7212914, 7212132, 7210863, 7207929, 7207567, 7206590, 7202606, 7200597, 7200204, 7197041, 7194856, 7194391, 7189637, 7189109, 7188829, 7187921, 7185927, 7184628, 7181689, 7179604, 7177952, 7173025, 7171660, 7170045, 7169109, 7168614, 7166138, 7163497, 7159760, 7154770, 7154429, 7151951, 7143205, 7141290, 7141085, 7139863, 7137322, 7136984, 7127659, 7120042, 7119528, 7117793, 7115076, 7112561, 7108516, 7103005, 7102393, 7100275, 7096136, 7086174, 7086172, 7086053, 7077187, 7075789, 7065018, 7063427, 7052749, 7013128, 7007651, 7003275, 6983150, 6974663, 6970410, 6957180))
Run Time: 0.005673
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 67 | 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: 10547, 0, 1714802039, {"thread-7216993":["thread",7216993],"thread-7216887":["thread",7216887],"thread-7216884":["thread",7216884],"thread-7212914":["thread",7212914],"thread-7212132":["thread",7212132],"thread-7210863":["thread",7210863],"thread-7207929":["thread",7207929],"thread-7207567":["thread",7207567],"thread-7206590":["thread",7206590],"thread-7202606":["thread",7202606],"thread-7200597":["thread",7200597],"thread-7200204":["thread",7200204],"thread-7197041":["thread",7197041],"thread-7194856":["thread",7194856],"thread-7194391":["thread",7194391],"thread-7189637":["thread",7189637],"thread-7189109":["thread",7189109],"thread-7188829":["thread",7188829],"thread-7187921":["thread",7187921],"thread-7185927":["thread",7185927],"thread-7184628":["thread",7184628],"thread-7181689":["thread",7181689],"thread-7179604":["thread",7179604],"thread-7177952":["thread",7177952],"thread-7173025":["thread",7173025],"thread-7171660":["thread",7171660],"thread-7170045":["thread",7170045],"thread-7169109":["thread",7169109],"thread-7168614":["thread",7168614],"thread-7166138":["thread",7166138],"thread-7163497":["thread",7163497],"thread-7159760":["thread",7159760],"thread-7154770":["thread",7154770],"thread-7154429":["thread",7154429],"thread-7151951":["thread",7151951],"thread-7143205":["thread",7143205],"thread-7141290":["thread",7141290],"thread-7141085":["thread",7141085],"thread-7139863":["thread",7139863],"thread-7137322":["thread",7137322],"thread-7136984":["thread",7136984],"thread-7127659":["thread",7127659],"thread-7120042":["thread",7120042],"thread-7119528":["thread",7119528],"thread-7117793":["thread",7117793],"thread-7115076":["thread",7115076],"thread-7112561":["thread",7112561],"thread-7108516":["thread",7108516],"thread-7103005":["thread",7103005],"thread-7102393":["thread",7102393],"thread-7100275":["thread",7100275],"thread-7096136":["thread",7096136],"thread-7086174":["thread",7086174],"thread-7086172":["thread",7086172],"thread-7086053":["thread",7086053],"thread-7077187":["thread",7077187],"thread-7075789":["thread",7075789],"thread-7065018":["thread",7065018],"thread-7063427":["thread",7063427],"thread-7052749":["thread",7052749],"thread-7013128":["thread",7013128],"thread-7007651":["thread",7007651],"thread-7003275":["thread",7003275],"thread-6983150":["thread",6983150],"thread-6974663":["thread",6974663],"thread-6970410":["thread",6970410],"thread-6957180":["thread",6957180]}, NULL, 1714798439
Run Time: 0.000375
- 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