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 (988524, 988416, 988400, 988387, 988345, 988291, 988257, 988148, 988142, 988131, 988129, 988128, 988125, 988085, 988045, 987998, 987982, 987979, 987971, 987931, 987925, 987918, 987915, 987898, 987889, 987874, 987871, 987870, 987862, 987860, 987859, 987832, 987822, 987821, 987799, 987793, 987723, 987720, 987708, 987701, 987690, 987671, 987665, 987655, 987631, 987620, 987606, 987595, 987578, 987577, 987556, 987554, 987535, 987525, 987522, 987517, 987462, 987431, 987407, 987365, 987351, 987302, 987276, 987263, 987206, 987177, 987161, 987141, 985381, 985120, 985027, 984829, 984814, 984813))
Run Time: 0.231346
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 74 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,cmclubcom_xf2xx.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: 28917, 0, 1714846111, {"thread-988524":["thread",988524],"thread-988416":["thread",988416],"thread-988400":["thread",988400],"thread-988387":["thread",988387],"thread-988345":["thread",988345],"thread-988291":["thread",988291],"thread-988257":["thread",988257],"thread-988148":["thread",988148],"thread-988142":["thread",988142],"thread-988131":["thread",988131],"thread-988129":["thread",988129],"thread-988128":["thread",988128],"thread-988125":["thread",988125],"thread-988085":["thread",988085],"thread-988045":["thread",988045],"thread-987998":["thread",987998],"thread-987982":["thread",987982],"thread-987979":["thread",987979],"thread-987971":["thread",987971],"thread-987931":["thread",987931],"thread-987925":["thread",987925],"thread-987918":["thread",987918],"thread-987915":["thread",987915],"thread-987898":["thread",987898],"thread-987889":["thread",987889],"thread-987874":["thread",987874],"thread-987871":["thread",987871],"thread-987870":["thread",987870],"thread-987862":["thread",987862],"thread-987860":["thread",987860],"thread-987859":["thread",987859],"thread-987832":["thread",987832],"thread-987822":["thread",987822],"thread-987821":["thread",987821],"thread-987799":["thread",987799],"thread-987793":["thread",987793],"thread-987723":["thread",987723],"thread-987720":["thread",987720],"thread-987708":["thread",987708],"thread-987701":["thread",987701],"thread-987690":["thread",987690],"thread-987671":["thread",987671],"thread-987665":["thread",987665],"thread-987655":["thread",987655],"thread-987631":["thread",987631],"thread-987620":["thread",987620],"thread-987606":["thread",987606],"thread-987595":["thread",987595],"thread-987578":["thread",987578],"thread-987577":["thread",987577],"thread-987556":["thread",987556],"thread-987554":["thread",987554],"thread-987535":["thread",987535],"thread-987525":["thread",987525],"thread-987522":["thread",987522],"thread-987517":["thread",987517],"thread-987462":["thread",987462],"thread-987431":["thread",987431],"thread-987407":["thread",987407],"thread-987365":["thread",987365],"thread-987351":["thread",987351],"thread-987302":["thread",987302],"thread-987276":["thread",987276],"thread-987263":["thread",987263],"thread-987206":["thread",987206],"thread-987177":["thread",987177],"thread-987161":["thread",987161],"thread-987141":["thread",987141],"thread-985381":["thread",985381],"thread-985120":["thread",985120],"thread-985027":["thread",985027],"thread-984829":["thread",984829],"thread-984814":["thread",984814],"thread-984813":["thread",984813]}, NULL, 1714842511
Run Time: 0.020624
- 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 1526
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1258
- 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