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 (182713, 181935, 181459, 181314, 181002, 180576, 180057, 179837, 179805, 178623, 178602, 177900, 177261, 177232, 177085, 177071, 176964, 176628, 176576, 176499, 176490, 175936, 173126, 171220, 170371, 169973, 169494, 168682, 168504, 168251, 168026, 167602, 166989, 166988, 164528, 164526, 164490, 164489, 164223, 164204, 164012, 163951, 163294, 163053, 163022, 162839, 159597, 159343, 159206, 157915, 156757, 156674, 154145, 153268, 152524, 152063, 110865, 110860, 93774, 38930))
Run Time: 0.025234
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 60 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.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 1387
- 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 2729
- 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 137
- 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 2351
- XF\App->run() in src/XF.php at line 517
- 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: 5560, 0, 1714785431, {"thread-182713":["thread",182713],"thread-181935":["thread",181935],"thread-181459":["thread",181459],"thread-181314":["thread",181314],"thread-181002":["thread",181002],"thread-180576":["thread",180576],"thread-180057":["thread",180057],"thread-179837":["thread",179837],"thread-179805":["thread",179805],"thread-178623":["thread",178623],"thread-178602":["thread",178602],"thread-177900":["thread",177900],"thread-177261":["thread",177261],"thread-177232":["thread",177232],"thread-177085":["thread",177085],"thread-177071":["thread",177071],"thread-176964":["thread",176964],"thread-176628":["thread",176628],"thread-176576":["thread",176576],"thread-176499":["thread",176499],"thread-176490":["thread",176490],"thread-175936":["thread",175936],"thread-173126":["thread",173126],"thread-171220":["thread",171220],"thread-170371":["thread",170371],"thread-169973":["thread",169973],"thread-169494":["thread",169494],"thread-168682":["thread",168682],"thread-168504":["thread",168504],"thread-168251":["thread",168251],"thread-168026":["thread",168026],"thread-167602":["thread",167602],"thread-166989":["thread",166989],"thread-166988":["thread",166988],"thread-164528":["thread",164528],"thread-164526":["thread",164526],"thread-164490":["thread",164490],"thread-164489":["thread",164489],"thread-164223":["thread",164223],"thread-164204":["thread",164204],"thread-164012":["thread",164012],"thread-163951":["thread",163951],"thread-163294":["thread",163294],"thread-163053":["thread",163053],"thread-163022":["thread",163022],"thread-162839":["thread",162839],"thread-159597":["thread",159597],"thread-159343":["thread",159343],"thread-159206":["thread",159206],"thread-157915":["thread",157915],"thread-156757":["thread",156757],"thread-156674":["thread",156674],"thread-154145":["thread",154145],"thread-153268":["thread",153268],"thread-152524":["thread",152524],"thread-152063":["thread",152063],"thread-110865":["thread",110865],"thread-110860":["thread",110860],"thread-93774":["thread",93774],"thread-38930":["thread",38930]}, , 1714781831
Run Time: 0.000274
- 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 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 150
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20