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 (181774, 181302, 180974, 180966, 180935, 180276, 180272, 179993, 176149, 174854, 174752, 173937, 173227, 170274, 170139, 166355, 165214, 163644, 163210, 160257, 160232, 159870, 157978, 156267, 154979, 154307, 153756, 153555, 151835, 141230, 130130, 128144, 127205, 127156, 126495, 126077, 122582, 122201, 121567, 119909, 118940, 117672, 114532, 112432, 108323, 106272, 103372, 102885, 85059, 74347, 69783, 55992, 54855, 54339, 54217, 54184, 53760, 31514, 12754, 11890))
Run Time: 0.030883
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: 1870, 0, 1716083703, {"thread-181774":["thread",181774],"thread-181302":["thread",181302],"thread-180974":["thread",180974],"thread-180966":["thread",180966],"thread-180935":["thread",180935],"thread-180276":["thread",180276],"thread-180272":["thread",180272],"thread-179993":["thread",179993],"thread-176149":["thread",176149],"thread-174854":["thread",174854],"thread-174752":["thread",174752],"thread-173937":["thread",173937],"thread-173227":["thread",173227],"thread-170274":["thread",170274],"thread-170139":["thread",170139],"thread-166355":["thread",166355],"thread-165214":["thread",165214],"thread-163644":["thread",163644],"thread-163210":["thread",163210],"thread-160257":["thread",160257],"thread-160232":["thread",160232],"thread-159870":["thread",159870],"thread-157978":["thread",157978],"thread-156267":["thread",156267],"thread-154979":["thread",154979],"thread-154307":["thread",154307],"thread-153756":["thread",153756],"thread-153555":["thread",153555],"thread-151835":["thread",151835],"thread-141230":["thread",141230],"thread-130130":["thread",130130],"thread-128144":["thread",128144],"thread-127205":["thread",127205],"thread-127156":["thread",127156],"thread-126495":["thread",126495],"thread-126077":["thread",126077],"thread-122582":["thread",122582],"thread-122201":["thread",122201],"thread-121567":["thread",121567],"thread-119909":["thread",119909],"thread-118940":["thread",118940],"thread-117672":["thread",117672],"thread-114532":["thread",114532],"thread-112432":["thread",112432],"thread-108323":["thread",108323],"thread-106272":["thread",106272],"thread-103372":["thread",103372],"thread-102885":["thread",102885],"thread-85059":["thread",85059],"thread-74347":["thread",74347],"thread-69783":["thread",69783],"thread-55992":["thread",55992],"thread-54855":["thread",54855],"thread-54339":["thread",54339],"thread-54217":["thread",54217],"thread-54184":["thread",54184],"thread-53760":["thread",53760],"thread-31514":["thread",31514],"thread-12754":["thread",12754],"thread-11890":["thread",11890]}, , 1716080103
Run Time: 0.000225
- 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