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 (172827, 170774, 166138, 157173, 143567, 140336, 140318, 139702, 138890, 138452, 137349, 137348, 137223, 137118, 136940, 136635, 136283, 136282, 135936, 135761, 135593, 135544, 135168, 134986, 134686, 134280, 133818, 133244, 132383, 132189, 131948, 131798, 131739, 131732, 131368, 131291, 131118, 131117, 131085, 131059, 130986, 130917, 130830, 130828, 130732, 130652, 130634, 130576, 130558, 130540, 130517, 130412, 130360, 130130, 130046, 129912, 129878, 129803, 129754, 129753, 129658, 129625, 129420, 129340, 129190, 129176, 128988, 128916, 128867, 128844, 128829, 128816, 128779, 128744, 128444, 128403, 128375, 128242, 128238, 128144, 127978, 127854, 127729, 127728, 127377, 127297, 127296, 127295, 127294, 127293, 127270, 127261, 127193, 127176, 127015, 127012, 126958, 126908, 126885, 126548, 126495, 126447, 126405, 126365, 126299, 126254, 126210, 126096, 126077, 126070, 125722, 125702, 125636, 125583, 125527, 125357, 125097, 125096, 125095, 125084, 125036, 124903, 124802, 124725, 124721, 124623, 124615, 124513, 124507, 124429, 124360, 124170, 124169, 124168, 123979, 123966, 123950, 123936, 123915, 123909, 123902, 123892, 123881, 123671, 123621, 123466, 123453, 123422, 123177, 123144, 123140, 123137, 123068, 122735, 122502, 122201, 122187, 122186, 122141, 122131, 122051, 122033, 121934, 121511, 121509, 121476, 121343, 121258, 121235, 121168, 120965, 120905, 120799, 120476, 119875, 119770, 119736, 119735, 119662, 119650, 119548, 119501, 119435, 119341, 119236, 119226, 119201, 119147, 118904, 118764, 118577, 118561, 118408, 118391, 118380, 118318))
Run Time: 0.109783
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 196 | 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: 2652, 0, 1714650677, {"thread-172827":["thread",172827],"thread-170774":["thread",170774],"thread-166138":["thread",166138],"thread-157173":["thread",157173],"thread-143567":["thread",143567],"ams_article-3236":["ams_article",3236],"ams_article-3183":["ams_article",3183],"thread-140336":["thread",140336],"thread-140318":["thread",140318],"thread-139702":["thread",139702],"thread-138890":["thread",138890],"thread-138452":["thread",138452],"thread-137349":["thread",137349],"thread-137348":["thread",137348],"thread-137223":["thread",137223],"thread-137118":["thread",137118],"ams_article-3002":["ams_article",3002],"thread-136940":["thread",136940],"thread-136635":["thread",136635],"thread-136283":["thread",136283],"thread-136282":["thread",136282],"thread-135936":["thread",135936],"thread-135761":["thread",135761],"thread-135593":["thread",135593],"thread-135544":["thread",135544],"thread-135168":["thread",135168],"thread-134986":["thread",134986],"ams_article-2972":["ams_article",2972],"thread-134686":["thread",134686],"thread-134280":["thread",134280],"thread-133818":["thread",133818],"thread-133244":["thread",133244],"thread-132383":["thread",132383],"thread-132189":["thread",132189],"thread-131948":["thread",131948],"thread-131798":["thread",131798],"thread-131739":["thread",131739],"thread-131732":["thread",131732],"thread-131368":["thread",131368],"thread-131291":["thread",131291],"thread-131118":["thread",131118],"thread-131117":["thread",131117],"thread-131085":["thread",131085],"thread-131059":["thread",131059],"thread-130986":["thread",130986],"thread-130917":["thread",130917],"thread-130830":["thread",130830],"thread-130828":["thread",130828],"thread-130732":["thread",130732],"thread-130652":["thread",130652],"thread-130634":["thread",130634],"thread-130576":["thread",130576],"thread-130558":["thread",130558],"thread-130540":["thread",130540],"thread-130517":["thread",130517],"thread-130412":["thread",130412],"thread-130360":["thread",130360],"thread-130130":["thread",130130],"thread-130046":["thread",130046],"thread-129912":["thread",129912],"thread-129878":["thread",129878],"thread-129803":["thread",129803],"thread-129754":["thread",129754],"thread-129753":["thread",129753],"thread-129658":["thread",129658],"thread-129625":["thread",129625],"thread-129420":["thread",129420],"thread-129340":["thread",129340],"thread-129190":["thread",129190],"thread-129176":["thread",129176],"thread-128988":["thread",128988],"thread-128916":["thread",128916],"thread-128867":["thread",128867],"thread-128844":["thread",128844],"thread-128829":["thread",128829],"thread-128816":["thread",128816],"thread-128779":["thread",128779],"thread-128744":["thread",128744],"thread-128444":["thread",128444],"thread-128403":["thread",128403],"thread-128375":["thread",128375],"thread-128242":["thread",128242],"thread-128238":["thread",128238],"thread-128144":["thread",128144],"thread-127978":["thread",127978],"thread-127854":["thread",127854],"thread-127729":["thread",127729],"thread-127728":["thread",127728],"thread-127377":["thread",127377],"thread-127297":["thread",127297],"thread-127296":["thread",127296],"thread-127295":["thread",127295],"thread-127294":["thread",127294],"thread-127293":["thread",127293],"thread-127270":["thread",127270],"thread-127261":["thread",127261],"thread-127193":["thread",127193],"thread-127176":["thread",127176],"thread-127015":["thread",127015],"thread-127012":["thread",127012],"thread-126958":["thread",126958],"thread-126908":["thread",126908],"thread-126885":["thread",126885],"thread-126548":["thread",126548],"thread-126495":["thread",126495],"thread-126447":["thread",126447],"thread-126405":["thread",126405],"thread-126365":["thread",126365],"thread-126299":["thread",126299],"thread-126254":["thread",126254],"thread-126210":["thread",126210],"thread-126096":["thread",126096],"thread-126077":["thread",126077],"thread-126070":["thread",126070],"thread-125722":["thread",125722],"thread-125702":["thread",125702],"thread-125636":["thread",125636],"thread-125583":["thread",125583],"thread-125527":["thread",125527],"thread-125357":["thread",125357],"thread-125097":["thread",125097],"thread-125096":["thread",125096],"thread-125095":["thread",125095],"thread-125084":["thread",125084],"thread-125036":["thread",125036],"thread-124903":["thread",124903],"thread-124802":["thread",124802],"thread-124725":["thread",124725],"thread-124721":["thread",124721],"thread-124623":["thread",124623],"thread-124615":["thread",124615],"thread-124513":["thread",124513],"thread-124507":["thread",124507],"thread-124429":["thread",124429],"thread-124360":["thread",124360],"thread-124170":["thread",124170],"thread-124169":["thread",124169],"thread-124168":["thread",124168],"thread-123979":["thread",123979],"thread-123966":["thread",123966],"thread-123950":["thread",123950],"thread-123936":["thread",123936],"thread-123915":["thread",123915],"thread-123909":["thread",123909],"thread-123902":["thread",123902],"thread-123892":["thread",123892],"thread-123881":["thread",123881],"thread-123671":["thread",123671],"thread-123621":["thread",123621],"thread-123466":["thread",123466],"thread-123453":["thread",123453],"thread-123422":["thread",123422],"thread-123177":["thread",123177],"thread-123144":["thread",123144],"thread-123140":["thread",123140],"thread-123137":["thread",123137],"thread-123068":["thread",123068],"thread-122735":["thread",122735],"thread-122502":["thread",122502],"thread-122201":["thread",122201],"thread-122187":["thread",122187],"thread-122186":["thread",122186],"thread-122141":["thread",122141],"thread-122131":["thread",122131],"thread-122051":["thread",122051],"thread-122033":["thread",122033],"thread-121934":["thread",121934],"thread-121511":["thread",121511],"thread-121509":["thread",121509],"thread-121476":["thread",121476],"thread-121343":["thread",121343],"thread-121258":["thread",121258],"thread-121235":["thread",121235],"thread-121168":["thread",121168],"thread-120965":["thread",120965],"thread-120905":["thread",120905],"thread-120799":["thread",120799],"thread-120476":["thread",120476],"thread-119875":["thread",119875],"thread-119770":["thread",119770],"thread-119736":["thread",119736],"thread-119735":["thread",119735],"thread-119662":["thread",119662],"thread-119650":["thread",119650],"thread-119548":["thread",119548],"thread-119501":["thread",119501],"thread-119435":["thread",119435],"thread-119341":["thread",119341],"thread-119236":["thread",119236],"thread-119226":["thread",119226],"thread-119201":["thread",119201],"thread-119147":["thread",119147],"thread-118904":["thread",118904],"thread-118764":["thread",118764],"thread-118577":["thread",118577],"thread-118561":["thread",118561],"thread-118408":["thread",118408],"thread-118391":["thread",118391],"thread-118380":["thread",118380],"thread-118318":["thread",118318]}, , 1714647077
Run Time: 0.000697
- 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