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 (183538, 183389, 182710, 182655, 182511, 182325, 181441, 179757, 179745, 179733, 179396, 179084, 176365, 176238, 174064, 173987, 173617, 172935, 172589, 172580, 171657, 171554, 170023, 167770, 167719, 166417, 166365, 165356, 164691, 163667, 162231, 161915, 161602, 161520, 161327, 161093, 161034, 160925, 160882, 160717, 160002, 159401, 158077, 158059, 157373, 156799, 156685, 156228, 155820, 154945, 153957, 153201, 152070, 151925, 151916, 151552, 148201, 131937, 130255, 130253, 129357, 129344, 129326, 129198, 127238, 126463, 126276, 125967, 125149, 125064, 124832, 123290, 123289, 123018, 122245, 121240, 121137, 121136, 120436, 120177, 119968, 119636, 119595, 117472, 117447, 116908, 116654, 115396, 115215, 115019, 114718, 114473, 114205, 114114, 112876, 112377, 111911, 111715, 111299, 110785, 110480, 110455, 110450, 109217, 108082, 107544, 106576, 106214, 106019, 105643, 105413, 105113, 105026, 104734, 104550, 104402, 103488, 103401, 99456, 99455, 99311, 98935, 97632, 96114, 95785, 95084, 94959, 94619, 94541, 93271, 92730, 92729, 92728, 91011, 90176, 89282, 89278, 89086, 89079, 88967, 88964, 88963, 88687, 88199, 88148, 87994, 87456, 86267, 86145, 85885, 85568, 83739, 83275, 82788, 82632, 82293, 82257, 82256, 82255, 81817, 81080, 80687, 80674, 80488, 79810, 79709, 77908, 76548, 76546, 76539, 76425, 76283, 76279, 76145, 75959, 75234, 73756, 72692, 70806, 68372, 67077, 60874, 59540, 59098, 57674, 56865, 56497, 55283, 55023, 53901, 53753, 49547, 49545, 48590, 48389, 48347, 48251, 41824, 40890))
Run Time: 0.099661
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 199 | 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: 4630, 0, 1716179361, {"thread-183538":["thread",183538],"thread-183389":["thread",183389],"thread-182710":["thread",182710],"thread-182655":["thread",182655],"thread-182511":["thread",182511],"thread-182325":["thread",182325],"thread-181441":["thread",181441],"thread-179757":["thread",179757],"thread-179745":["thread",179745],"thread-179733":["thread",179733],"thread-179396":["thread",179396],"thread-179084":["thread",179084],"thread-176365":["thread",176365],"thread-176238":["thread",176238],"thread-174064":["thread",174064],"thread-173987":["thread",173987],"thread-173617":["thread",173617],"thread-172935":["thread",172935],"thread-172589":["thread",172589],"thread-172580":["thread",172580],"thread-171657":["thread",171657],"thread-171554":["thread",171554],"thread-170023":["thread",170023],"thread-167770":["thread",167770],"thread-167719":["thread",167719],"thread-166417":["thread",166417],"thread-166365":["thread",166365],"thread-165356":["thread",165356],"thread-164691":["thread",164691],"thread-163667":["thread",163667],"thread-162231":["thread",162231],"thread-161915":["thread",161915],"thread-161520":["thread",161520],"tl_group_event-18":["tl_group_event",18],"thread-161327":["thread",161327],"thread-161093":["thread",161093],"thread-161034":["thread",161034],"thread-160925":["thread",160925],"thread-160882":["thread",160882],"thread-160717":["thread",160717],"thread-160002":["thread",160002],"thread-159401":["thread",159401],"thread-158077":["thread",158077],"thread-158059":["thread",158059],"thread-157373":["thread",157373],"thread-156799":["thread",156799],"thread-156685":["thread",156685],"thread-155820":["thread",155820],"thread-154945":["thread",154945],"thread-153201":["thread",153201],"thread-151916":["thread",151916],"thread-148201":["thread",148201],"thread-131937":["thread",131937],"thread-129357":["thread",129357],"thread-129344":["thread",129344],"thread-129326":["thread",129326],"thread-129198":["thread",129198],"thread-127238":["thread",127238],"thread-126463":["thread",126463],"thread-125967":["thread",125967],"thread-125149":["thread",125149],"thread-124832":["thread",124832],"thread-123290":["thread",123290],"thread-123289":["thread",123289],"thread-123018":["thread",123018],"thread-122245":["thread",122245],"thread-121240":["thread",121240],"thread-121137":["thread",121137],"thread-121136":["thread",121136],"thread-120436":["thread",120436],"thread-120177":["thread",120177],"thread-119968":["thread",119968],"thread-119636":["thread",119636],"thread-119595":["thread",119595],"thread-117472":["thread",117472],"thread-117447":["thread",117447],"thread-116908":["thread",116908],"thread-116654":["thread",116654],"thread-115396":["thread",115396],"thread-115215":["thread",115215],"thread-115019":["thread",115019],"thread-114718":["thread",114718],"thread-114473":["thread",114473],"thread-114205":["thread",114205],"thread-114114":["thread",114114],"thread-112876":["thread",112876],"thread-112377":["thread",112377],"thread-111911":["thread",111911],"thread-111715":["thread",111715],"thread-111299":["thread",111299],"thread-110480":["thread",110480],"thread-110455":["thread",110455],"thread-110450":["thread",110450],"thread-109217":["thread",109217],"thread-107544":["thread",107544],"thread-106576":["thread",106576],"thread-106214":["thread",106214],"thread-106019":["thread",106019],"thread-105413":["thread",105413],"thread-105026":["thread",105026],"thread-104734":["thread",104734],"thread-104550":["thread",104550],"thread-104402":["thread",104402],"thread-103488":["thread",103488],"thread-103401":["thread",103401],"thread-99456":["thread",99456],"thread-99455":["thread",99455],"thread-99311":["thread",99311],"thread-98935":["thread",98935],"thread-97632":["thread",97632],"thread-96114":["thread",96114],"thread-95785":["thread",95785],"thread-95084":["thread",95084],"thread-94959":["thread",94959],"thread-94619":["thread",94619],"thread-94541":["thread",94541],"thread-93271":["thread",93271],"thread-92730":["thread",92730],"thread-92729":["thread",92729],"thread-92728":["thread",92728],"thread-91011":["thread",91011],"thread-90176":["thread",90176],"thread-89282":["thread",89282],"thread-89086":["thread",89086],"thread-89079":["thread",89079],"thread-88967":["thread",88967],"thread-88964":["thread",88964],"thread-88963":["thread",88963],"thread-88687":["thread",88687],"thread-88148":["thread",88148],"thread-87994":["thread",87994],"thread-86145":["thread",86145],"thread-85885":["thread",85885],"thread-83739":["thread",83739],"thread-83275":["thread",83275],"thread-82788":["thread",82788],"thread-82632":["thread",82632],"thread-82293":["thread",82293],"thread-82257":["thread",82257],"thread-82256":["thread",82256],"thread-82255":["thread",82255],"thread-81817":["thread",81817],"thread-81080":["thread",81080],"thread-80687":["thread",80687],"thread-80674":["thread",80674],"thread-80488":["thread",80488],"thread-79810":["thread",79810],"thread-77908":["thread",77908],"thread-76548":["thread",76548],"thread-76546":["thread",76546],"thread-76539":["thread",76539],"thread-76425":["thread",76425],"thread-76283":["thread",76283],"thread-76145":["thread",76145],"thread-75234":["thread",75234],"thread-73756":["thread",73756],"thread-72692":["thread",72692],"thread-70806":["thread",70806],"thread-68372":["thread",68372],"thread-67077":["thread",67077],"thread-60874":["thread",60874],"thread-59540":["thread",59540],"thread-59098":["thread",59098],"thread-57674":["thread",57674],"thread-56865":["thread",56865],"thread-56497":["thread",56497],"thread-55283":["thread",55283],"thread-55023":["thread",55023],"thread-53901":["thread",53901],"thread-53753":["thread",53753],"thread-49547":["thread",49547],"thread-48590":["thread",48590],"thread-48389":["thread",48389],"thread-48347":["thread",48347],"thread-48251":["thread",48251],"thread-41824":["thread",41824],"thread-40890":["thread",40890]}, , 1716175761
Run Time: 0.000506
- 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