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 (14632, 13820, 13544, 13113, 12926, 12548, 12493, 12387, 12205, 12016, 11687, 11500, 11284, 11195, 11124, 11076, 10647, 9905, 9202, 8649, 8374, 8280, 8182, 7942, 7934, 7892, 7772, 7720, 6956, 6850, 6711, 6562, 6253, 6226, 6076, 6013, 5883, 5568, 5486, 5266, 5263, 5173, 5156, 5016, 4916, 4494, 3842, 3829, 3476, 3449, 3117, 2878, 2415, 2387, 2371, 2227, 1994, 1890, 1886, 1792, 1482, 1335, 1308, 1206, 820, 762, 299))
Run Time: 0.005632
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: 304, 0, 1714371368, {"thread-14632":["thread",14632],"thread-13820":["thread",13820],"thread-13544":["thread",13544],"thread-13113":["thread",13113],"thread-12926":["thread",12926],"thread-12548":["thread",12548],"thread-12493":["thread",12493],"thread-12387":["thread",12387],"thread-12205":["thread",12205],"thread-12016":["thread",12016],"thread-11687":["thread",11687],"thread-11500":["thread",11500],"thread-11284":["thread",11284],"thread-11195":["thread",11195],"thread-11124":["thread",11124],"thread-11076":["thread",11076],"thread-10647":["thread",10647],"thread-9905":["thread",9905],"thread-9202":["thread",9202],"thread-8649":["thread",8649],"thread-8374":["thread",8374],"thread-8280":["thread",8280],"thread-8182":["thread",8182],"thread-7942":["thread",7942],"thread-7934":["thread",7934],"thread-7892":["thread",7892],"thread-7772":["thread",7772],"thread-7720":["thread",7720],"thread-6956":["thread",6956],"thread-6850":["thread",6850],"thread-6711":["thread",6711],"thread-6562":["thread",6562],"thread-6253":["thread",6253],"thread-6226":["thread",6226],"thread-6076":["thread",6076],"thread-6013":["thread",6013],"thread-5883":["thread",5883],"thread-5568":["thread",5568],"thread-5486":["thread",5486],"thread-5266":["thread",5266],"thread-5263":["thread",5263],"thread-5173":["thread",5173],"thread-5156":["thread",5156],"thread-5016":["thread",5016],"thread-4916":["thread",4916],"thread-4494":["thread",4494],"thread-3842":["thread",3842],"thread-3829":["thread",3829],"thread-3476":["thread",3476],"thread-3449":["thread",3449],"thread-3117":["thread",3117],"thread-2878":["thread",2878],"thread-2415":["thread",2415],"thread-2387":["thread",2387],"thread-2371":["thread",2371],"thread-2227":["thread",2227],"thread-1994":["thread",1994],"thread-1890":["thread",1890],"thread-1886":["thread",1886],"thread-1792":["thread",1792],"thread-1482":["thread",1482],"thread-1335":["thread",1335],"thread-1308":["thread",1308],"thread-1206":["thread",1206],"thread-820":["thread",820],"thread-762":["thread",762],"thread-299":["thread",299]}, NULL, 1714367768
Run Time: 0.000330
- 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