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 (182294, 175592, 175017, 174941, 144751, 141470, 137594, 133927, 132053, 131951, 131066, 130949, 130770, 130642, 130640, 130458, 130318, 130145, 129753, 129586, 129528, 128816, 128703, 128694, 128661, 128660, 128474, 128440, 128425, 128326, 128067, 128060, 128021, 127983, 127840, 127791, 127661, 127541, 127473, 127412, 127312, 127068, 126868, 126824, 126448, 126331, 126084, 125790, 125703, 125509, 125423, 125060, 124243, 124130, 123976, 123259, 122875, 122706, 122699, 122585, 122365, 122308, 122236, 121981, 121717, 121678, 121597, 121406, 121394, 121385, 121220, 121181, 121177, 120925, 120501, 120247, 119827, 119676, 119663, 119352, 119307, 119227, 118951, 118903, 118787, 118759, 118725, 118632, 118492, 117850, 117835, 117826, 117795, 117668, 117234, 116813, 116744, 116700, 116568, 116458, 116400, 116001, 115872, 115802, 115666, 115554, 115301, 115030, 114887, 114786, 114544, 114456, 114447, 113892, 113878, 113728, 113707, 113449, 113364, 113046, 112827, 112549, 112150, 112067, 111995, 111928, 111927, 111917, 111907, 111799, 111774, 111620, 111582, 111402, 111358, 111148, 111079, 110939, 110762, 110616, 109447, 109291, 109288, 108956, 108909, 108799, 108616, 108389, 108334, 107978, 107926, 107923, 107724, 107343, 107322, 107177, 106938, 106874, 106823, 106646, 106361, 106236, 105689, 105646, 105405, 105332, 105132, 104460, 104337, 104243, 104187, 104098, 103629, 103389, 103323, 103249, 102679, 102676, 102642, 102529, 102401, 102298, 101980, 101676, 100915, 99734, 99228, 99178, 99158, 99041, 98890, 98880, 98798, 98694, 98654))
Run Time: 0.112484
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 195 | 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: 11505, 0, 1715149768, {"thread-182294":["thread",182294],"thread-175592":["thread",175592],"thread-175017":["thread",175017],"thread-174941":["thread",174941],"ams_article-4019":["ams_article",4019],"ams_article-3572":["ams_article",3572],"ams_article-3426":["ams_article",3426],"thread-144751":["thread",144751],"ams_article-3303":["ams_article",3303],"ams_article-3269":["ams_article",3269],"thread-141470":["thread",141470],"thread-137594":["thread",137594],"thread-133927":["thread",133927],"thread-132053":["thread",132053],"thread-131951":["thread",131951],"thread-131066":["thread",131066],"thread-130949":["thread",130949],"thread-130770":["thread",130770],"thread-130642":["thread",130642],"thread-130640":["thread",130640],"thread-130458":["thread",130458],"thread-130318":["thread",130318],"thread-130145":["thread",130145],"thread-129753":["thread",129753],"thread-129586":["thread",129586],"thread-129528":["thread",129528],"thread-128816":["thread",128816],"thread-128703":["thread",128703],"thread-128694":["thread",128694],"thread-128661":["thread",128661],"thread-128660":["thread",128660],"thread-128474":["thread",128474],"thread-128440":["thread",128440],"thread-128425":["thread",128425],"thread-128326":["thread",128326],"thread-128067":["thread",128067],"thread-128060":["thread",128060],"thread-128021":["thread",128021],"thread-127983":["thread",127983],"thread-127840":["thread",127840],"thread-127791":["thread",127791],"thread-127661":["thread",127661],"thread-127541":["thread",127541],"thread-127473":["thread",127473],"thread-127412":["thread",127412],"thread-127312":["thread",127312],"thread-127068":["thread",127068],"thread-126868":["thread",126868],"thread-126824":["thread",126824],"thread-126448":["thread",126448],"thread-126331":["thread",126331],"thread-126084":["thread",126084],"thread-125790":["thread",125790],"thread-125703":["thread",125703],"thread-125509":["thread",125509],"thread-125423":["thread",125423],"thread-125060":["thread",125060],"thread-124243":["thread",124243],"thread-124130":["thread",124130],"thread-123976":["thread",123976],"thread-123259":["thread",123259],"thread-122875":["thread",122875],"thread-122706":["thread",122706],"thread-122699":["thread",122699],"thread-122585":["thread",122585],"thread-122365":["thread",122365],"thread-122308":["thread",122308],"thread-122236":["thread",122236],"thread-121981":["thread",121981],"thread-121717":["thread",121717],"thread-121678":["thread",121678],"thread-121597":["thread",121597],"thread-121406":["thread",121406],"thread-121394":["thread",121394],"thread-121385":["thread",121385],"thread-121220":["thread",121220],"thread-121181":["thread",121181],"thread-121177":["thread",121177],"thread-120925":["thread",120925],"thread-120501":["thread",120501],"thread-120247":["thread",120247],"thread-119827":["thread",119827],"thread-119676":["thread",119676],"thread-119663":["thread",119663],"thread-119352":["thread",119352],"thread-119307":["thread",119307],"thread-119227":["thread",119227],"thread-118951":["thread",118951],"thread-118903":["thread",118903],"thread-118787":["thread",118787],"thread-118759":["thread",118759],"thread-118725":["thread",118725],"thread-118632":["thread",118632],"thread-118492":["thread",118492],"thread-117850":["thread",117850],"thread-117835":["thread",117835],"thread-117826":["thread",117826],"thread-117795":["thread",117795],"thread-117668":["thread",117668],"thread-117234":["thread",117234],"thread-116813":["thread",116813],"thread-116744":["thread",116744],"thread-116700":["thread",116700],"thread-116568":["thread",116568],"thread-116458":["thread",116458],"thread-116400":["thread",116400],"thread-116001":["thread",116001],"thread-115872":["thread",115872],"thread-115802":["thread",115802],"thread-115666":["thread",115666],"thread-115554":["thread",115554],"thread-115301":["thread",115301],"thread-115030":["thread",115030],"thread-114887":["thread",114887],"thread-114786":["thread",114786],"thread-114544":["thread",114544],"thread-114456":["thread",114456],"thread-114447":["thread",114447],"thread-113892":["thread",113892],"thread-113878":["thread",113878],"thread-113728":["thread",113728],"thread-113707":["thread",113707],"thread-113449":["thread",113449],"thread-113364":["thread",113364],"thread-113046":["thread",113046],"thread-112827":["thread",112827],"thread-112549":["thread",112549],"thread-112150":["thread",112150],"thread-112067":["thread",112067],"thread-111995":["thread",111995],"thread-111928":["thread",111928],"thread-111927":["thread",111927],"thread-111917":["thread",111917],"thread-111907":["thread",111907],"thread-111799":["thread",111799],"thread-111774":["thread",111774],"thread-111620":["thread",111620],"thread-111582":["thread",111582],"thread-111402":["thread",111402],"thread-111358":["thread",111358],"thread-111148":["thread",111148],"thread-111079":["thread",111079],"thread-110939":["thread",110939],"thread-110762":["thread",110762],"thread-110616":["thread",110616],"thread-109447":["thread",109447],"thread-109291":["thread",109291],"thread-109288":["thread",109288],"thread-108956":["thread",108956],"thread-108909":["thread",108909],"thread-108799":["thread",108799],"thread-108616":["thread",108616],"thread-108389":["thread",108389],"thread-108334":["thread",108334],"thread-107978":["thread",107978],"thread-107926":["thread",107926],"thread-107923":["thread",107923],"thread-107724":["thread",107724],"thread-107343":["thread",107343],"thread-107322":["thread",107322],"thread-107177":["thread",107177],"thread-106938":["thread",106938],"thread-106874":["thread",106874],"thread-106823":["thread",106823],"thread-106646":["thread",106646],"thread-106361":["thread",106361],"thread-106236":["thread",106236],"thread-105689":["thread",105689],"thread-105646":["thread",105646],"thread-105405":["thread",105405],"thread-105332":["thread",105332],"thread-105132":["thread",105132],"thread-104460":["thread",104460],"thread-104337":["thread",104337],"thread-104243":["thread",104243],"thread-104187":["thread",104187],"thread-104098":["thread",104098],"thread-103629":["thread",103629],"thread-103389":["thread",103389],"thread-103323":["thread",103323],"thread-103249":["thread",103249],"thread-102679":["thread",102679],"thread-102676":["thread",102676],"thread-102642":["thread",102642],"thread-102529":["thread",102529],"thread-102401":["thread",102401],"thread-102298":["thread",102298],"thread-101980":["thread",101980],"thread-101676":["thread",101676],"thread-100915":["thread",100915],"thread-99734":["thread",99734],"thread-99228":["thread",99228],"thread-99178":["thread",99178],"thread-99158":["thread",99158],"thread-99041":["thread",99041],"thread-98890":["thread",98890],"thread-98880":["thread",98880],"thread-98798":["thread",98798],"thread-98694":["thread",98694],"thread-98654":["thread",98654]}, , 1715146168
Run Time: 0.000190
- 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