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 (7214507, 7209663, 7205220, 7204972, 7201944, 7201656, 7199339, 7199331, 7198398, 7198352, 7197833, 7195634, 7194240, 7193827, 7190897, 7188672, 7177133, 7175975, 7175480, 7174018, 7171365, 7166965, 7162785, 7153732, 7152179, 7150918, 7146218, 7145363, 7144002, 7143393, 7143161, 7142188, 7141732, 7139968, 7138959, 7129278, 7129215, 7127680, 7123739, 7109720, 7108186, 7108057, 7106581, 7105865, 7100630, 7100374, 7078877, 7057923, 7057364, 7049999, 7048731, 7043048, 7041515, 7036855, 7036636, 6982364, 6972308))
Run Time: 0.004972
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 57 | 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: 10791, 0, 1715980651, {"thread-7214507":["thread",7214507],"thread-7209663":["thread",7209663],"thread-7205220":["thread",7205220],"thread-7204972":["thread",7204972],"thread-7201944":["thread",7201944],"thread-7201656":["thread",7201656],"thread-7199339":["thread",7199339],"thread-7199331":["thread",7199331],"thread-7198398":["thread",7198398],"thread-7198352":["thread",7198352],"thread-7197833":["thread",7197833],"thread-7195634":["thread",7195634],"thread-7194240":["thread",7194240],"thread-7193827":["thread",7193827],"thread-7190897":["thread",7190897],"thread-7188672":["thread",7188672],"thread-7177133":["thread",7177133],"thread-7175975":["thread",7175975],"thread-7175480":["thread",7175480],"thread-7174018":["thread",7174018],"thread-7171365":["thread",7171365],"thread-7166965":["thread",7166965],"thread-7162785":["thread",7162785],"thread-7153732":["thread",7153732],"thread-7152179":["thread",7152179],"thread-7150918":["thread",7150918],"thread-7146218":["thread",7146218],"thread-7145363":["thread",7145363],"thread-7144002":["thread",7144002],"thread-7143393":["thread",7143393],"thread-7143161":["thread",7143161],"thread-7142188":["thread",7142188],"thread-7141732":["thread",7141732],"thread-7139968":["thread",7139968],"thread-7138959":["thread",7138959],"thread-7129278":["thread",7129278],"thread-7129215":["thread",7129215],"thread-7127680":["thread",7127680],"thread-7123739":["thread",7123739],"thread-7109720":["thread",7109720],"thread-7108186":["thread",7108186],"thread-7108057":["thread",7108057],"thread-7106581":["thread",7106581],"thread-7105865":["thread",7105865],"thread-7100630":["thread",7100630],"thread-7100374":["thread",7100374],"thread-7078877":["thread",7078877],"thread-7057923":["thread",7057923],"thread-7057364":["thread",7057364],"thread-7049999":["thread",7049999],"thread-7048731":["thread",7048731],"thread-7043048":["thread",7043048],"thread-7041515":["thread",7041515],"thread-7036855":["thread",7036855],"thread-7036636":["thread",7036636],"thread-6982364":["thread",6982364],"thread-6972308":["thread",6972308]}, NULL, 1715977051
Run Time: 0.000346
- 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