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 (182662, 182661, 182383, 182227, 181872, 174578, 167429, 165529, 165490, 161263, 160585, 160249, 154548, 154424, 153128, 151975, 151873, 151236, 150133, 147732, 135119, 133933, 133570, 133566, 133562, 133560, 133559, 133530, 133147, 133058, 133000, 128718, 128551, 128223, 128119, 128039, 125707, 125577, 125575, 125513, 124072, 123779, 123749, 123736, 123722, 123715, 123607, 123586, 123419, 123339, 123308, 123273, 123267, 123205, 123204, 123202, 123163, 123150, 123117, 123076, 123075, 123011, 122890, 122796, 122616, 122337, 122330, 122273, 122251, 121996, 121935, 121570, 121493, 121491, 121490, 121484, 121460, 121444, 121368, 121361, 121316, 121313, 121008, 120962, 120958, 120957, 120949, 120948, 120947, 120941, 120940, 120938, 120925, 120875, 120858, 120853, 120849, 120846, 120841, 120822, 120818, 120793, 120534, 120494, 120292, 120000, 119999, 119943, 115364, 115123, 114901, 110526, 110272, 109642, 109593, 109582, 109283, 109282, 109269, 109177, 109079, 108979, 108976, 108967, 108778, 108734, 108722, 108686, 108639, 108570, 108556, 108494, 108480, 108444, 108328, 108325, 108239, 87669, 50930, 50917, 50715, 50596, 50466, 50425, 50377, 50315, 50223))
Run Time: 0.086872
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 147 | 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: 7877, 0, 1716268040, {"thread-182662":["thread",182662],"thread-182661":["thread",182661],"thread-182383":["thread",182383],"thread-182227":["thread",182227],"thread-181872":["thread",181872],"thread-174578":["thread",174578],"thread-167429":["thread",167429],"thread-165529":["thread",165529],"thread-165490":["thread",165490],"thread-161263":["thread",161263],"thread-160585":["thread",160585],"tl_group-173":["tl_group",173],"thread-160249":["thread",160249],"thread-154548":["thread",154548],"thread-154424":["thread",154424],"thread-153128":["thread",153128],"thread-151975":["thread",151975],"thread-151873":["thread",151873],"thread-151236":["thread",151236],"thread-150133":["thread",150133],"thread-147732":["thread",147732],"thread-135119":["thread",135119],"thread-133933":["thread",133933],"thread-133570":["thread",133570],"thread-133566":["thread",133566],"thread-133562":["thread",133562],"thread-133560":["thread",133560],"thread-133559":["thread",133559],"thread-133530":["thread",133530],"thread-133147":["thread",133147],"thread-133058":["thread",133058],"thread-133000":["thread",133000],"thread-128718":["thread",128718],"thread-128551":["thread",128551],"thread-128223":["thread",128223],"thread-128119":["thread",128119],"thread-128039":["thread",128039],"thread-125707":["thread",125707],"thread-125577":["thread",125577],"thread-125575":["thread",125575],"thread-125513":["thread",125513],"thread-124072":["thread",124072],"thread-123779":["thread",123779],"thread-123749":["thread",123749],"thread-123736":["thread",123736],"thread-123722":["thread",123722],"thread-123715":["thread",123715],"thread-123607":["thread",123607],"thread-123586":["thread",123586],"thread-123419":["thread",123419],"thread-123339":["thread",123339],"thread-123308":["thread",123308],"thread-123273":["thread",123273],"thread-123267":["thread",123267],"thread-123205":["thread",123205],"thread-123204":["thread",123204],"thread-123202":["thread",123202],"thread-123163":["thread",123163],"thread-123150":["thread",123150],"thread-123117":["thread",123117],"thread-123076":["thread",123076],"thread-123075":["thread",123075],"thread-123011":["thread",123011],"thread-122890":["thread",122890],"thread-122796":["thread",122796],"thread-122616":["thread",122616],"thread-122337":["thread",122337],"thread-122330":["thread",122330],"thread-122273":["thread",122273],"thread-122251":["thread",122251],"thread-121996":["thread",121996],"thread-121935":["thread",121935],"thread-121570":["thread",121570],"thread-121493":["thread",121493],"thread-121491":["thread",121491],"thread-121490":["thread",121490],"thread-121484":["thread",121484],"thread-121460":["thread",121460],"thread-121444":["thread",121444],"thread-121368":["thread",121368],"thread-121361":["thread",121361],"thread-121316":["thread",121316],"thread-121313":["thread",121313],"thread-121008":["thread",121008],"thread-120962":["thread",120962],"thread-120958":["thread",120958],"thread-120957":["thread",120957],"thread-120949":["thread",120949],"thread-120948":["thread",120948],"thread-120947":["thread",120947],"thread-120941":["thread",120941],"thread-120940":["thread",120940],"thread-120938":["thread",120938],"thread-120925":["thread",120925],"thread-120875":["thread",120875],"thread-120858":["thread",120858],"thread-120853":["thread",120853],"thread-120849":["thread",120849],"thread-120846":["thread",120846],"thread-120841":["thread",120841],"thread-120822":["thread",120822],"thread-120818":["thread",120818],"thread-120793":["thread",120793],"thread-120534":["thread",120534],"thread-120494":["thread",120494],"thread-120292":["thread",120292],"thread-120000":["thread",120000],"thread-119999":["thread",119999],"thread-119943":["thread",119943],"thread-115364":["thread",115364],"thread-115123":["thread",115123],"thread-114901":["thread",114901],"thread-110526":["thread",110526],"thread-110272":["thread",110272],"thread-109642":["thread",109642],"thread-109593":["thread",109593],"thread-109582":["thread",109582],"thread-109283":["thread",109283],"thread-109282":["thread",109282],"thread-109269":["thread",109269],"thread-109177":["thread",109177],"thread-109079":["thread",109079],"thread-108979":["thread",108979],"thread-108976":["thread",108976],"thread-108967":["thread",108967],"thread-108778":["thread",108778],"thread-108734":["thread",108734],"thread-108722":["thread",108722],"thread-108686":["thread",108686],"thread-108639":["thread",108639],"thread-108570":["thread",108570],"thread-108556":["thread",108556],"thread-108494":["thread",108494],"thread-108480":["thread",108480],"thread-108444":["thread",108444],"thread-108328":["thread",108328],"thread-108325":["thread",108325],"thread-108239":["thread",108239],"thread-87669":["thread",87669],"thread-50930":["thread",50930],"thread-50917":["thread",50917],"thread-50715":["thread",50715],"thread-50596":["thread",50596],"thread-50466":["thread",50466],"thread-50425":["thread",50425],"thread-50377":["thread",50377],"thread-50315":["thread",50315],"thread-50223":["thread",50223]}, , 1716264440
Run Time: 0.000488
- 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