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 (7173982, 7140757, 7057638, 6466843, 237393, 219908, 212680, 187664, 13800, 13675, 13617, 13533, 13080, 12976, 12934, 12923, 12858, 12519, 12173, 12052, 11696, 11686, 11294, 11284, 11050, 10996, 10652, 10589, 10498, 10119, 10038, 9973, 9617, 9570, 9281, 8113, 7943, 7753, 7429, 7210, 7143, 6855, 6424, 6067, 5939, 5923, 5774, 5643, 5552, 5300, 5050, 4778, 4637, 4407, 4131, 3982, 3862, 3706, 3607, 3483, 3397, 3396, 2695, 2491, 2422, 2170, 1729, 1656, 1626, 1350, 1131, 872, 864, 851, 844, 742, 616, 610, 564, 519, 451, 399, 141))
Run Time: 0.005949
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 83 | 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: 130, 0, 1715590622, {"thread-7173982":["thread",7173982],"thread-7140757":["thread",7140757],"thread-7057638":["thread",7057638],"thread-6466843":["thread",6466843],"thread-237393":["thread",237393],"thread-219908":["thread",219908],"thread-212680":["thread",212680],"thread-187664":["thread",187664],"thread-13800":["thread",13800],"thread-13675":["thread",13675],"thread-13617":["thread",13617],"thread-13533":["thread",13533],"thread-13080":["thread",13080],"thread-12976":["thread",12976],"thread-12934":["thread",12934],"thread-12923":["thread",12923],"thread-12858":["thread",12858],"thread-12519":["thread",12519],"thread-12173":["thread",12173],"thread-12052":["thread",12052],"thread-11696":["thread",11696],"thread-11686":["thread",11686],"thread-11294":["thread",11294],"thread-11284":["thread",11284],"thread-11050":["thread",11050],"thread-10996":["thread",10996],"thread-10652":["thread",10652],"thread-10589":["thread",10589],"thread-10498":["thread",10498],"thread-10119":["thread",10119],"thread-10038":["thread",10038],"thread-9973":["thread",9973],"thread-9617":["thread",9617],"thread-9570":["thread",9570],"thread-9281":["thread",9281],"thread-8113":["thread",8113],"thread-7943":["thread",7943],"thread-7753":["thread",7753],"thread-7429":["thread",7429],"thread-7210":["thread",7210],"thread-7143":["thread",7143],"thread-6855":["thread",6855],"thread-6424":["thread",6424],"thread-6067":["thread",6067],"thread-5939":["thread",5939],"thread-5923":["thread",5923],"thread-5774":["thread",5774],"thread-5643":["thread",5643],"thread-5552":["thread",5552],"thread-5300":["thread",5300],"thread-5050":["thread",5050],"thread-4778":["thread",4778],"thread-4637":["thread",4637],"thread-4407":["thread",4407],"thread-4131":["thread",4131],"thread-3982":["thread",3982],"thread-3862":["thread",3862],"thread-3706":["thread",3706],"thread-3607":["thread",3607],"thread-3483":["thread",3483],"thread-3397":["thread",3397],"thread-3396":["thread",3396],"thread-2695":["thread",2695],"thread-2491":["thread",2491],"thread-2422":["thread",2422],"thread-2170":["thread",2170],"thread-1729":["thread",1729],"thread-1656":["thread",1656],"thread-1626":["thread",1626],"thread-1350":["thread",1350],"thread-1131":["thread",1131],"thread-872":["thread",872],"thread-864":["thread",864],"thread-851":["thread",851],"thread-844":["thread",844],"thread-742":["thread",742],"thread-616":["thread",616],"thread-610":["thread",610],"thread-564":["thread",564],"thread-519":["thread",519],"thread-451":["thread",451],"thread-399":["thread",399],"thread-141":["thread",141]}, NULL, 1715587022
Run Time: 0.000501
- 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