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 (143470, 141042, 139625, 139011, 137743, 137601, 136630, 136598, 136572, 136526, 136525, 136316, 135830, 135828, 135311, 134831, 134308, 134151, 134113, 133125, 133124, 132667, 132500, 132399, 131868, 130956, 130876, 130832, 130324, 130243, 130214, 130188, 129875, 129566, 129409, 129089, 128833, 128191, 127884, 127817, 127682, 127382, 126437, 126083, 125749, 125151, 125104, 124603, 124173, 124170, 124169, 124168, 124020, 124017, 124015, 123551, 123508, 123445, 123404, 123373, 122682, 122606, 122600, 122527, 121661, 121630, 121619, 121589, 121588, 121587, 121586, 121585, 121584, 120945, 120590, 120455, 120228, 120188, 120179, 120116, 119453, 119380, 118195, 117090, 117019, 115735, 115576, 115121, 114862, 114607, 114441, 114098, 113591, 113417, 113048, 113006, 112591, 112477, 112316, 111937, 110458, 110361, 110356, 109228, 109179, 108899, 108744, 106389, 106167, 106064, 105225, 105057, 104310, 104292))
Run Time: 0.227691
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 114 | 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: 24261, 0, 1716182744, {"thread-143470":["thread",143470],"thread-141042":["thread",141042],"thread-139625":["thread",139625],"thread-139011":["thread",139011],"thread-137743":["thread",137743],"thread-137601":["thread",137601],"thread-136630":["thread",136630],"thread-136598":["thread",136598],"thread-136572":["thread",136572],"thread-136526":["thread",136526],"thread-136525":["thread",136525],"thread-136316":["thread",136316],"thread-135830":["thread",135830],"thread-135828":["thread",135828],"thread-135311":["thread",135311],"thread-134831":["thread",134831],"thread-134308":["thread",134308],"thread-134151":["thread",134151],"thread-134113":["thread",134113],"thread-133125":["thread",133125],"thread-133124":["thread",133124],"thread-132667":["thread",132667],"thread-132500":["thread",132500],"thread-132399":["thread",132399],"thread-131868":["thread",131868],"thread-130956":["thread",130956],"thread-130876":["thread",130876],"thread-130832":["thread",130832],"thread-130324":["thread",130324],"thread-130243":["thread",130243],"thread-130214":["thread",130214],"thread-130188":["thread",130188],"thread-129875":["thread",129875],"thread-129566":["thread",129566],"thread-129409":["thread",129409],"thread-129089":["thread",129089],"thread-128833":["thread",128833],"thread-128191":["thread",128191],"thread-127884":["thread",127884],"thread-127817":["thread",127817],"thread-127682":["thread",127682],"thread-127382":["thread",127382],"thread-126437":["thread",126437],"thread-126083":["thread",126083],"thread-125749":["thread",125749],"thread-125151":["thread",125151],"thread-125104":["thread",125104],"thread-124603":["thread",124603],"thread-124173":["thread",124173],"thread-124170":["thread",124170],"thread-124169":["thread",124169],"thread-124168":["thread",124168],"thread-124020":["thread",124020],"thread-124017":["thread",124017],"thread-124015":["thread",124015],"thread-123551":["thread",123551],"thread-123508":["thread",123508],"thread-123445":["thread",123445],"thread-123404":["thread",123404],"thread-123373":["thread",123373],"thread-122682":["thread",122682],"thread-122606":["thread",122606],"thread-122600":["thread",122600],"thread-122527":["thread",122527],"thread-121661":["thread",121661],"thread-121630":["thread",121630],"thread-121619":["thread",121619],"thread-121589":["thread",121589],"thread-121588":["thread",121588],"thread-121587":["thread",121587],"thread-121586":["thread",121586],"thread-121585":["thread",121585],"thread-121584":["thread",121584],"thread-120945":["thread",120945],"thread-120590":["thread",120590],"thread-120455":["thread",120455],"thread-120228":["thread",120228],"thread-120188":["thread",120188],"thread-120179":["thread",120179],"thread-120116":["thread",120116],"thread-119453":["thread",119453],"thread-119380":["thread",119380],"thread-118195":["thread",118195],"thread-117090":["thread",117090],"thread-117019":["thread",117019],"thread-115735":["thread",115735],"thread-115576":["thread",115576],"thread-115121":["thread",115121],"thread-114862":["thread",114862],"thread-114607":["thread",114607],"thread-114441":["thread",114441],"thread-114098":["thread",114098],"thread-113591":["thread",113591],"thread-113417":["thread",113417],"thread-113048":["thread",113048],"thread-113006":["thread",113006],"thread-112591":["thread",112591],"thread-112477":["thread",112477],"thread-112316":["thread",112316],"thread-111937":["thread",111937],"thread-110458":["thread",110458],"thread-110361":["thread",110361],"thread-110356":["thread",110356],"thread-109228":["thread",109228],"thread-109179":["thread",109179],"thread-108899":["thread",108899],"thread-108744":["thread",108744],"thread-106389":["thread",106389],"thread-106167":["thread",106167],"thread-106064":["thread",106064],"thread-105225":["thread",105225],"thread-105057":["thread",105057],"thread-104310":["thread",104310],"thread-104292":["thread",104292]}, , 1716179144
Run Time: 0.005774
- 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