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 (131409, 129864, 129176, 126294, 125878, 124631, 124284, 123921, 123895, 123350, 122939, 122506, 121980, 121767, 121507, 113132, 112064, 111913, 111554, 111410, 109720, 109067, 109026, 109003, 108794, 108706, 107116, 106571, 106125, 106031, 104648, 104290, 103982, 103448, 102785, 102337, 101842, 101141, 100711, 100487, 100446, 100307, 100225, 100201, 99960, 99822, 99761, 99454, 99318, 98812, 97972, 97467, 96998, 96815, 96679, 96556, 95832, 95399, 94858, 93826, 93169, 93152, 93080, 92690, 91686, 91621, 90617, 90225, 90130, 89668, 88671, 88187, 88116, 88030, 87947, 87610, 87515, 87512, 87279, 87263, 86051, 85981, 85960, 85921, 85258, 84603, 84525, 84013, 82729, 82644, 82404))
Run Time: 0.050901
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 91 | 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: 17409, 0, 1715851438, {"thread-131409":["thread",131409],"thread-129864":["thread",129864],"thread-129176":["thread",129176],"thread-126294":["thread",126294],"thread-125878":["thread",125878],"thread-124631":["thread",124631],"thread-124284":["thread",124284],"thread-123921":["thread",123921],"thread-123895":["thread",123895],"thread-123350":["thread",123350],"thread-122939":["thread",122939],"thread-122506":["thread",122506],"thread-121980":["thread",121980],"thread-121767":["thread",121767],"thread-121507":["thread",121507],"thread-113132":["thread",113132],"thread-112064":["thread",112064],"thread-111913":["thread",111913],"thread-111554":["thread",111554],"thread-111410":["thread",111410],"thread-109720":["thread",109720],"thread-109067":["thread",109067],"thread-109026":["thread",109026],"thread-109003":["thread",109003],"thread-108794":["thread",108794],"thread-108706":["thread",108706],"thread-107116":["thread",107116],"thread-106571":["thread",106571],"thread-106125":["thread",106125],"thread-106031":["thread",106031],"thread-104648":["thread",104648],"thread-104290":["thread",104290],"thread-103982":["thread",103982],"thread-103448":["thread",103448],"thread-102785":["thread",102785],"thread-102337":["thread",102337],"thread-101842":["thread",101842],"thread-101141":["thread",101141],"thread-100711":["thread",100711],"thread-100487":["thread",100487],"thread-100446":["thread",100446],"thread-100307":["thread",100307],"thread-100225":["thread",100225],"thread-100201":["thread",100201],"thread-99960":["thread",99960],"thread-99822":["thread",99822],"thread-99761":["thread",99761],"thread-99454":["thread",99454],"thread-99318":["thread",99318],"thread-98812":["thread",98812],"thread-97972":["thread",97972],"thread-97467":["thread",97467],"thread-96998":["thread",96998],"thread-96815":["thread",96815],"thread-96679":["thread",96679],"thread-96556":["thread",96556],"thread-95832":["thread",95832],"thread-95399":["thread",95399],"thread-94858":["thread",94858],"thread-93826":["thread",93826],"thread-93169":["thread",93169],"thread-93152":["thread",93152],"thread-93080":["thread",93080],"thread-92690":["thread",92690],"thread-91686":["thread",91686],"thread-91621":["thread",91621],"thread-90617":["thread",90617],"thread-90225":["thread",90225],"thread-90130":["thread",90130],"thread-89668":["thread",89668],"thread-88671":["thread",88671],"thread-88187":["thread",88187],"thread-88116":["thread",88116],"thread-88030":["thread",88030],"thread-87947":["thread",87947],"thread-87610":["thread",87610],"thread-87515":["thread",87515],"thread-87512":["thread",87512],"thread-87279":["thread",87279],"thread-87263":["thread",87263],"thread-86051":["thread",86051],"thread-85981":["thread",85981],"thread-85960":["thread",85960],"thread-85921":["thread",85921],"thread-85258":["thread",85258],"thread-84603":["thread",84603],"thread-84525":["thread",84525],"thread-84013":["thread",84013],"thread-82729":["thread",82729],"thread-82644":["thread",82644],"thread-82404":["thread",82404]}, , 1715847838
Run Time: 0.000269
- 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