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 (177410, 173875, 159540, 155205, 131116, 129270, 128269, 126486, 122250, 121620, 118558, 118406, 118121, 116964, 116354, 116347, 116346, 116316, 116305, 115520, 115481, 115266, 115093, 114620, 114369, 112456, 111858, 111771, 110209, 109912, 109907, 109894, 109786, 109779, 109503, 108810, 108746, 108666, 107616, 105593, 105582, 101885, 101417, 99326, 98723, 93536, 93315, 93031, 91618, 89215, 88573, 88567, 88564, 87828, 85016, 81434, 80949, 80721, 80524, 79717, 79699, 79638, 78198, 77738, 77202, 74477, 73742, 73719, 73360, 73322, 73315, 72720, 72719, 72158, 71162, 70849, 70772, 70729, 70533, 70454, 70431, 70378, 70194, 69106, 68292, 68251, 68183, 67652, 66868, 66718, 66179, 63581, 63409, 62531, 62486, 61361, 61309, 60818, 60804, 60785, 60517, 60514, 60435, 58874, 58832, 58758, 58672, 58465, 58345, 57906, 57891, 57047, 55878, 55413, 55355, 55222, 55183, 54971, 54442, 54201, 53507, 53472, 53070, 53035, 52537, 52536, 52452, 52055, 51845, 50988, 45444, 44930, 44923, 44008, 40870, 40141, 39965, 39853, 39185, 39140, 39060, 39053, 38863, 38832, 38642, 38570, 38462, 38366, 38329, 38033, 37992, 37347, 37102, 36900, 36888, 36883, 36863, 36861, 36831, 36798, 36785, 36767, 36759, 36758, 36752, 36744, 36743, 36741, 36739, 36737, 36735, 36733, 36731, 36727, 36722, 36721, 36720, 36719, 36705, 36703, 36702, 36701, 36699, 36698, 36695, 36690, 36689, 36687, 36686, 36685, 36683, 36682, 36680))
Run Time: 0.080682
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 193 | 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: 5202, 0, 1715752413, {"thread-177410":["thread",177410],"thread-173875":["thread",173875],"thread-159540":["thread",159540],"thread-155205":["thread",155205],"thread-131116":["thread",131116],"thread-129270":["thread",129270],"thread-128269":["thread",128269],"thread-126486":["thread",126486],"thread-122250":["thread",122250],"thread-121620":["thread",121620],"thread-118558":["thread",118558],"thread-118406":["thread",118406],"thread-118121":["thread",118121],"thread-116964":["thread",116964],"thread-116354":["thread",116354],"thread-116347":["thread",116347],"thread-116346":["thread",116346],"thread-116316":["thread",116316],"thread-116305":["thread",116305],"thread-115520":["thread",115520],"thread-115481":["thread",115481],"thread-115266":["thread",115266],"thread-115093":["thread",115093],"thread-114620":["thread",114620],"thread-114369":["thread",114369],"thread-112456":["thread",112456],"thread-111858":["thread",111858],"thread-111771":["thread",111771],"thread-110209":["thread",110209],"thread-109912":["thread",109912],"thread-109907":["thread",109907],"thread-109894":["thread",109894],"thread-109786":["thread",109786],"thread-109779":["thread",109779],"thread-109503":["thread",109503],"thread-108810":["thread",108810],"thread-108746":["thread",108746],"thread-108666":["thread",108666],"thread-107616":["thread",107616],"thread-105593":["thread",105593],"thread-105582":["thread",105582],"thread-101885":["thread",101885],"thread-101417":["thread",101417],"thread-99326":["thread",99326],"thread-98723":["thread",98723],"thread-93536":["thread",93536],"thread-93315":["thread",93315],"thread-93031":["thread",93031],"thread-91618":["thread",91618],"thread-89215":["thread",89215],"thread-88573":["thread",88573],"thread-88567":["thread",88567],"thread-88564":["thread",88564],"thread-87828":["thread",87828],"thread-85016":["thread",85016],"thread-81434":["thread",81434],"thread-80949":["thread",80949],"thread-80721":["thread",80721],"thread-80524":["thread",80524],"thread-79717":["thread",79717],"thread-79699":["thread",79699],"thread-79638":["thread",79638],"thread-78198":["thread",78198],"thread-77738":["thread",77738],"thread-77202":["thread",77202],"thread-74477":["thread",74477],"thread-73742":["thread",73742],"thread-73719":["thread",73719],"thread-73360":["thread",73360],"thread-73322":["thread",73322],"thread-73315":["thread",73315],"thread-72720":["thread",72720],"thread-72719":["thread",72719],"thread-72158":["thread",72158],"thread-71162":["thread",71162],"thread-70849":["thread",70849],"thread-70772":["thread",70772],"thread-70729":["thread",70729],"thread-70533":["thread",70533],"thread-70454":["thread",70454],"thread-70431":["thread",70431],"thread-70378":["thread",70378],"thread-70194":["thread",70194],"thread-69106":["thread",69106],"thread-68292":["thread",68292],"thread-68251":["thread",68251],"thread-68183":["thread",68183],"thread-67652":["thread",67652],"thread-66868":["thread",66868],"thread-66718":["thread",66718],"thread-66179":["thread",66179],"thread-63581":["thread",63581],"thread-63409":["thread",63409],"thread-62531":["thread",62531],"thread-62486":["thread",62486],"thread-61361":["thread",61361],"thread-61309":["thread",61309],"thread-60818":["thread",60818],"thread-60804":["thread",60804],"thread-60785":["thread",60785],"thread-60517":["thread",60517],"thread-60514":["thread",60514],"thread-60435":["thread",60435],"thread-58874":["thread",58874],"thread-58832":["thread",58832],"thread-58758":["thread",58758],"thread-58672":["thread",58672],"thread-58465":["thread",58465],"thread-58345":["thread",58345],"thread-57906":["thread",57906],"thread-57891":["thread",57891],"thread-57047":["thread",57047],"thread-55878":["thread",55878],"thread-55413":["thread",55413],"thread-55355":["thread",55355],"thread-55222":["thread",55222],"thread-55183":["thread",55183],"thread-54971":["thread",54971],"thread-54442":["thread",54442],"thread-54201":["thread",54201],"thread-53507":["thread",53507],"thread-53472":["thread",53472],"thread-53070":["thread",53070],"thread-53035":["thread",53035],"thread-52537":["thread",52537],"thread-52536":["thread",52536],"thread-52452":["thread",52452],"thread-52055":["thread",52055],"thread-51845":["thread",51845],"thread-50988":["thread",50988],"thread-45444":["thread",45444],"thread-44930":["thread",44930],"thread-44923":["thread",44923],"thread-44008":["thread",44008],"thread-40870":["thread",40870],"thread-40141":["thread",40141],"thread-39965":["thread",39965],"thread-39853":["thread",39853],"thread-39185":["thread",39185],"thread-39140":["thread",39140],"thread-39060":["thread",39060],"thread-39053":["thread",39053],"thread-38863":["thread",38863],"thread-38832":["thread",38832],"thread-38642":["thread",38642],"thread-38570":["thread",38570],"thread-38462":["thread",38462],"thread-38366":["thread",38366],"thread-38329":["thread",38329],"thread-38033":["thread",38033],"thread-37992":["thread",37992],"thread-37347":["thread",37347],"thread-37102":["thread",37102],"thread-36900":["thread",36900],"thread-36888":["thread",36888],"thread-36883":["thread",36883],"thread-36863":["thread",36863],"thread-36861":["thread",36861],"thread-36831":["thread",36831],"thread-36798":["thread",36798],"thread-36785":["thread",36785],"thread-36767":["thread",36767],"thread-36759":["thread",36759],"thread-36758":["thread",36758],"thread-36752":["thread",36752],"thread-36744":["thread",36744],"thread-36743":["thread",36743],"thread-36741":["thread",36741],"thread-36739":["thread",36739],"thread-36737":["thread",36737],"thread-36735":["thread",36735],"thread-36733":["thread",36733],"thread-36731":["thread",36731],"thread-36727":["thread",36727],"thread-36722":["thread",36722],"thread-36721":["thread",36721],"thread-36720":["thread",36720],"thread-36719":["thread",36719],"thread-36705":["thread",36705],"thread-36703":["thread",36703],"thread-36702":["thread",36702],"thread-36701":["thread",36701],"thread-36699":["thread",36699],"thread-36698":["thread",36698],"thread-36695":["thread",36695],"thread-36690":["thread",36690],"thread-36689":["thread",36689],"thread-36687":["thread",36687],"thread-36686":["thread",36686],"thread-36685":["thread",36685],"thread-36683":["thread",36683],"thread-36682":["thread",36682],"thread-36680":["thread",36680]}, , 1715748813
Run Time: 0.000621
- 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