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 (156038, 136939, 136812, 136791, 136790, 136789, 136788, 136787, 136372, 136352, 136220, 135906, 135588, 135577, 135429, 131604, 131520, 131513, 130570, 130000, 129161, 129033, 129032, 129029, 128723, 128533, 128523, 128320, 128284, 128241, 127746, 127003, 126234, 125937, 124444, 124357, 123847, 123021, 122893, 122087, 120931, 119318, 119278, 119275, 119273, 119163, 118652, 118467, 118433, 118146, 117937, 117692, 117685, 117538, 117392, 117265, 116141, 115972, 115774, 115371, 114065, 113848, 113541, 113401, 112977, 112903, 112748, 112594, 111417, 111405, 110680, 110344, 110314, 110136, 110132, 106546, 105970, 105813, 96807, 90043, 87011, 86910, 76661, 76226, 75164))
Run Time: 0.079363
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 85 | 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: 15436, 0, 1714623613, {"thread-156038":["thread",156038],"thread-136939":["thread",136939],"thread-136812":["thread",136812],"thread-136791":["thread",136791],"thread-136790":["thread",136790],"thread-136789":["thread",136789],"thread-136788":["thread",136788],"thread-136787":["thread",136787],"thread-136372":["thread",136372],"thread-136352":["thread",136352],"thread-136220":["thread",136220],"thread-135906":["thread",135906],"thread-135588":["thread",135588],"thread-135577":["thread",135577],"thread-135429":["thread",135429],"thread-131604":["thread",131604],"thread-131520":["thread",131520],"thread-131513":["thread",131513],"thread-130570":["thread",130570],"thread-130000":["thread",130000],"thread-129161":["thread",129161],"thread-129033":["thread",129033],"thread-129032":["thread",129032],"thread-129029":["thread",129029],"thread-128723":["thread",128723],"thread-128533":["thread",128533],"thread-128523":["thread",128523],"thread-128320":["thread",128320],"thread-128284":["thread",128284],"thread-128241":["thread",128241],"thread-127746":["thread",127746],"thread-127003":["thread",127003],"thread-126234":["thread",126234],"thread-125937":["thread",125937],"thread-124444":["thread",124444],"thread-124357":["thread",124357],"thread-123847":["thread",123847],"thread-123021":["thread",123021],"thread-122893":["thread",122893],"thread-122087":["thread",122087],"thread-120931":["thread",120931],"thread-119318":["thread",119318],"thread-119278":["thread",119278],"thread-119275":["thread",119275],"thread-119273":["thread",119273],"thread-119163":["thread",119163],"thread-118652":["thread",118652],"thread-118467":["thread",118467],"thread-118433":["thread",118433],"thread-118146":["thread",118146],"thread-117937":["thread",117937],"thread-117692":["thread",117692],"thread-117685":["thread",117685],"thread-117538":["thread",117538],"thread-117392":["thread",117392],"thread-117265":["thread",117265],"thread-116141":["thread",116141],"thread-115972":["thread",115972],"thread-115774":["thread",115774],"thread-115371":["thread",115371],"thread-114065":["thread",114065],"thread-113848":["thread",113848],"thread-113541":["thread",113541],"thread-113401":["thread",113401],"thread-112977":["thread",112977],"thread-112903":["thread",112903],"thread-112748":["thread",112748],"thread-112594":["thread",112594],"thread-111417":["thread",111417],"thread-111405":["thread",111405],"thread-110680":["thread",110680],"thread-110344":["thread",110344],"thread-110314":["thread",110314],"thread-110136":["thread",110136],"thread-110132":["thread",110132],"thread-106546":["thread",106546],"thread-105970":["thread",105970],"thread-105813":["thread",105813],"thread-96807":["thread",96807],"thread-90043":["thread",90043],"thread-87011":["thread",87011],"thread-86910":["thread",86910],"thread-76661":["thread",76661],"thread-76226":["thread",76226],"thread-75164":["thread",75164]}, , 1714620013
Run Time: 0.000216
- 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