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 (166962, 162794, 157235, 154875, 153778, 150734, 149852, 148847, 148639, 146593, 144414, 142970, 142321, 142157, 138456, 137999, 137106, 136776, 136711, 136577, 136539, 135783, 135709, 135367, 134964, 134680, 134062, 134021, 133577, 133535, 133210, 133208, 133206, 131947, 131864, 131835, 131738, 131681, 131643, 131554, 131549, 131196, 131113, 131050, 131026, 130974, 130408, 130182, 130177, 130147, 130114, 130017, 129994, 129843, 129823, 129742, 129726, 129281, 128456, 128414, 128363, 128213, 128203, 127945, 127891, 127755, 127726, 127682, 127615, 127583, 127511, 127509, 127235, 127198, 127195, 127190, 127163, 127140, 127136, 126609, 126608, 126365, 126313, 126025, 125249, 125141, 123874, 123788, 123618, 123617, 123294, 122651, 122267, 122225, 122110, 121664, 121662, 120448, 120366, 120355, 120133, 119743, 118929, 118899, 118849, 118847, 118663, 118486, 117526, 117443, 117185, 117087, 115580, 115516, 114788, 114526, 114483, 113666, 113183, 112994, 112992, 112726, 112299, 112186, 112106, 111758, 111321, 110495, 110274, 110154, 109788, 108894, 108736, 108690, 108557, 108121, 108075, 107802, 107774, 107446, 107053, 107009, 106583, 106204, 106009, 105800, 105796, 105319, 105071, 104543, 104487, 104232, 104105, 103850, 103726, 103672, 103528, 103483, 103476, 103430, 103383, 103170, 103153, 103084, 103080, 103077, 102471, 102348, 102232, 102226, 102166, 102164, 102093, 101925, 101826, 101706))
Run Time: 0.126636
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 176 | 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: 23597, 0, 1714798769, {"thread-166962":["thread",166962],"thread-162794":["thread",162794],"tl_group-149":["tl_group",149],"thread-157235":["thread",157235],"thread-154875":["thread",154875],"thread-153778":["thread",153778],"thread-150734":["thread",150734],"thread-149852":["thread",149852],"thread-148847":["thread",148847],"thread-148639":["thread",148639],"thread-146593":["thread",146593],"thread-144414":["thread",144414],"thread-142970":["thread",142970],"thread-142321":["thread",142321],"thread-142157":["thread",142157],"thread-138456":["thread",138456],"ams_article-3065":["ams_article",3065],"thread-137999":["thread",137999],"thread-137106":["thread",137106],"thread-136776":["thread",136776],"thread-136711":["thread",136711],"thread-136577":["thread",136577],"thread-136539":["thread",136539],"thread-135783":["thread",135783],"thread-135709":["thread",135709],"thread-135367":["thread",135367],"thread-134964":["thread",134964],"thread-134680":["thread",134680],"thread-134062":["thread",134062],"thread-134021":["thread",134021],"thread-133577":["thread",133577],"thread-133535":["thread",133535],"thread-133210":["thread",133210],"thread-133208":["thread",133208],"thread-133206":["thread",133206],"thread-131947":["thread",131947],"thread-131864":["thread",131864],"thread-131835":["thread",131835],"thread-131738":["thread",131738],"thread-131681":["thread",131681],"thread-131643":["thread",131643],"thread-131554":["thread",131554],"thread-131549":["thread",131549],"thread-131196":["thread",131196],"thread-131113":["thread",131113],"thread-131050":["thread",131050],"thread-131026":["thread",131026],"thread-130974":["thread",130974],"thread-130408":["thread",130408],"thread-130182":["thread",130182],"thread-130177":["thread",130177],"thread-130147":["thread",130147],"thread-130114":["thread",130114],"thread-130017":["thread",130017],"thread-129994":["thread",129994],"thread-129843":["thread",129843],"thread-129823":["thread",129823],"thread-129742":["thread",129742],"thread-129726":["thread",129726],"thread-129281":["thread",129281],"thread-128456":["thread",128456],"thread-128414":["thread",128414],"thread-128363":["thread",128363],"thread-128213":["thread",128213],"thread-128203":["thread",128203],"thread-127945":["thread",127945],"thread-127891":["thread",127891],"thread-127755":["thread",127755],"thread-127726":["thread",127726],"thread-127682":["thread",127682],"thread-127615":["thread",127615],"thread-127583":["thread",127583],"thread-127511":["thread",127511],"thread-127509":["thread",127509],"thread-127235":["thread",127235],"thread-127198":["thread",127198],"thread-127195":["thread",127195],"thread-127190":["thread",127190],"thread-127163":["thread",127163],"thread-127140":["thread",127140],"thread-127136":["thread",127136],"thread-126609":["thread",126609],"thread-126608":["thread",126608],"thread-126365":["thread",126365],"thread-126313":["thread",126313],"thread-126025":["thread",126025],"thread-125249":["thread",125249],"thread-125141":["thread",125141],"thread-123874":["thread",123874],"thread-123788":["thread",123788],"thread-123618":["thread",123618],"thread-123617":["thread",123617],"thread-123294":["thread",123294],"thread-122651":["thread",122651],"thread-122267":["thread",122267],"thread-122225":["thread",122225],"thread-122110":["thread",122110],"thread-121664":["thread",121664],"thread-121662":["thread",121662],"thread-120448":["thread",120448],"thread-120366":["thread",120366],"thread-120355":["thread",120355],"thread-120133":["thread",120133],"thread-119743":["thread",119743],"thread-118929":["thread",118929],"thread-118899":["thread",118899],"thread-118849":["thread",118849],"thread-118847":["thread",118847],"thread-118663":["thread",118663],"thread-118486":["thread",118486],"thread-117526":["thread",117526],"thread-117443":["thread",117443],"thread-117185":["thread",117185],"thread-117087":["thread",117087],"thread-115580":["thread",115580],"thread-115516":["thread",115516],"thread-114788":["thread",114788],"thread-114526":["thread",114526],"thread-114483":["thread",114483],"thread-113666":["thread",113666],"thread-113183":["thread",113183],"thread-112994":["thread",112994],"thread-112992":["thread",112992],"thread-112726":["thread",112726],"thread-112299":["thread",112299],"thread-112186":["thread",112186],"thread-112106":["thread",112106],"thread-111758":["thread",111758],"thread-111321":["thread",111321],"thread-110495":["thread",110495],"thread-110274":["thread",110274],"thread-110154":["thread",110154],"thread-109788":["thread",109788],"thread-108894":["thread",108894],"thread-108736":["thread",108736],"thread-108690":["thread",108690],"thread-108557":["thread",108557],"thread-108121":["thread",108121],"thread-108075":["thread",108075],"thread-107802":["thread",107802],"thread-107774":["thread",107774],"thread-107446":["thread",107446],"thread-107053":["thread",107053],"thread-107009":["thread",107009],"thread-106583":["thread",106583],"thread-106204":["thread",106204],"thread-106009":["thread",106009],"thread-105800":["thread",105800],"thread-105796":["thread",105796],"thread-105319":["thread",105319],"thread-105071":["thread",105071],"thread-104543":["thread",104543],"thread-104487":["thread",104487],"thread-104232":["thread",104232],"thread-104105":["thread",104105],"thread-103850":["thread",103850],"thread-103726":["thread",103726],"thread-103672":["thread",103672],"thread-103528":["thread",103528],"thread-103483":["thread",103483],"thread-103476":["thread",103476],"thread-103430":["thread",103430],"thread-103383":["thread",103383],"thread-103170":["thread",103170],"thread-103153":["thread",103153],"thread-103084":["thread",103084],"thread-103080":["thread",103080],"thread-103077":["thread",103077],"thread-102471":["thread",102471],"thread-102348":["thread",102348],"thread-102232":["thread",102232],"thread-102226":["thread",102226],"thread-102166":["thread",102166],"thread-102164":["thread",102164],"thread-102093":["thread",102093],"thread-101925":["thread",101925],"thread-101826":["thread",101826],"thread-101706":["thread",101706]}, , 1714795169
Run Time: 0.000280
- 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