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 (182503, 182473, 181775, 181404, 181280, 181110, 179346, 177401, 175750, 172925, 170966, 170603, 170284, 166704, 165589, 164397, 162252, 161954, 158126, 157647, 155837, 155785, 155583, 154879, 154316, 154245, 151995, 146892, 145947, 144986, 134665, 133235, 130951, 129275, 127657, 127549, 127359, 125306, 125269, 125267, 125068, 125023, 125015, 124267, 121733, 121049, 118948, 118401, 117668, 116775, 115509, 115429, 110010, 109514, 109513, 108081, 107488, 106835, 106476, 102299, 100978, 99794, 97738, 95850, 94278, 91680, 88106, 84143, 82748, 80519, 79620, 79180, 78195, 78011, 76367, 68133, 56349, 54554, 52507, 52430, 51339, 47588, 41373, 39669, 34972, 26033, 25372, 25369, 24773, 24194, 18776, 3008, 2312))
Run Time: 0.067366
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 93 | 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: 621, 0, 1714282118, {"thread-182503":["thread",182503],"thread-182473":["thread",182473],"thread-181775":["thread",181775],"thread-181404":["thread",181404],"thread-181280":["thread",181280],"thread-181110":["thread",181110],"thread-179346":["thread",179346],"thread-177401":["thread",177401],"thread-175750":["thread",175750],"thread-172925":["thread",172925],"thread-170966":["thread",170966],"thread-170603":["thread",170603],"thread-170284":["thread",170284],"thread-166704":["thread",166704],"thread-165589":["thread",165589],"thread-164397":["thread",164397],"tl_group-204":["tl_group",204],"thread-162252":["thread",162252],"thread-161954":["thread",161954],"thread-158126":["thread",158126],"thread-157647":["thread",157647],"thread-155837":["thread",155837],"thread-155785":["thread",155785],"thread-155583":["thread",155583],"thread-154879":["thread",154879],"thread-154316":["thread",154316],"thread-154245":["thread",154245],"thread-151995":["thread",151995],"tl_group-61":["tl_group",61],"thread-146892":["thread",146892],"thread-145947":["thread",145947],"thread-144986":["thread",144986],"thread-134665":["thread",134665],"thread-133235":["thread",133235],"thread-130951":["thread",130951],"thread-129275":["thread",129275],"thread-127657":["thread",127657],"thread-127549":["thread",127549],"thread-127359":["thread",127359],"thread-125306":["thread",125306],"thread-125269":["thread",125269],"thread-125267":["thread",125267],"thread-125068":["thread",125068],"thread-125023":["thread",125023],"thread-125015":["thread",125015],"thread-124267":["thread",124267],"thread-121733":["thread",121733],"thread-121049":["thread",121049],"thread-118948":["thread",118948],"thread-118401":["thread",118401],"thread-117668":["thread",117668],"thread-116775":["thread",116775],"thread-115509":["thread",115509],"thread-115429":["thread",115429],"thread-110010":["thread",110010],"thread-109514":["thread",109514],"thread-109513":["thread",109513],"thread-108081":["thread",108081],"thread-107488":["thread",107488],"thread-106835":["thread",106835],"thread-106476":["thread",106476],"thread-102299":["thread",102299],"thread-100978":["thread",100978],"thread-99794":["thread",99794],"thread-97738":["thread",97738],"thread-95850":["thread",95850],"thread-94278":["thread",94278],"thread-91680":["thread",91680],"thread-88106":["thread",88106],"thread-84143":["thread",84143],"thread-82748":["thread",82748],"thread-80519":["thread",80519],"thread-79620":["thread",79620],"thread-79180":["thread",79180],"thread-78195":["thread",78195],"thread-78011":["thread",78011],"thread-76367":["thread",76367],"thread-68133":["thread",68133],"thread-56349":["thread",56349],"thread-54554":["thread",54554],"thread-52507":["thread",52507],"thread-52430":["thread",52430],"thread-51339":["thread",51339],"thread-47588":["thread",47588],"thread-41373":["thread",41373],"thread-39669":["thread",39669],"thread-34972":["thread",34972],"thread-26033":["thread",26033],"thread-25372":["thread",25372],"thread-25369":["thread",25369],"thread-24773":["thread",24773],"thread-24194":["thread",24194],"thread-18776":["thread",18776],"thread-3008":["thread",3008],"thread-2312":["thread",2312]}, , 1714278518
Run Time: 0.000630
- 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