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 (182790, 182697, 182115, 181685, 181421, 180643, 180367, 179949, 179803, 179740, 179277, 178275, 177969, 177272, 177271, 176591, 176590, 176381, 176182, 175978, 175392, 175379, 174416, 174320, 173268, 173107, 173029, 171289, 171068, 170955, 170894, 170881, 170850, 170517, 169555, 168274, 167810, 166503, 166430, 166072, 165215, 165190, 164826, 163696, 163581, 163466, 163146, 162511, 162190, 161752, 159996, 159801, 159423, 158613, 158207, 157939, 157826, 157718, 156911, 156645, 156495, 155905, 155792, 155147, 154222, 152616, 152430, 152336, 131728, 130986, 129915, 125799, 125775, 125561, 123114, 121731, 119319, 117959, 115553, 114224, 112096, 109425, 108011, 105226, 102594, 100672, 100671, 98127, 89965, 86547, 83826, 80581, 78164, 78049, 77642, 74901, 74747, 74742, 73305, 71372, 69521, 50025, 49728, 45490, 45465, 38406, 33751, 29171, 23343, 9527, 2424))
Run Time: 0.059064
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 111 | 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: 641, 0, 1716179671, {"thread-182790":["thread",182790],"thread-182697":["thread",182697],"thread-182115":["thread",182115],"thread-181685":["thread",181685],"thread-181421":["thread",181421],"thread-180643":["thread",180643],"thread-180367":["thread",180367],"thread-179949":["thread",179949],"thread-179803":["thread",179803],"thread-179740":["thread",179740],"thread-179277":["thread",179277],"thread-178275":["thread",178275],"thread-177969":["thread",177969],"thread-177272":["thread",177272],"thread-177271":["thread",177271],"thread-176591":["thread",176591],"thread-176590":["thread",176590],"thread-176381":["thread",176381],"thread-176182":["thread",176182],"thread-175978":["thread",175978],"thread-175392":["thread",175392],"thread-175379":["thread",175379],"thread-174416":["thread",174416],"thread-174320":["thread",174320],"thread-173268":["thread",173268],"thread-173107":["thread",173107],"thread-173029":["thread",173029],"thread-171289":["thread",171289],"thread-171068":["thread",171068],"thread-170955":["thread",170955],"thread-170894":["thread",170894],"thread-170881":["thread",170881],"thread-170850":["thread",170850],"thread-170517":["thread",170517],"thread-169555":["thread",169555],"thread-168274":["thread",168274],"thread-167810":["thread",167810],"thread-166503":["thread",166503],"thread-166430":["thread",166430],"thread-166072":["thread",166072],"thread-165215":["thread",165215],"thread-165190":["thread",165190],"thread-164826":["thread",164826],"thread-163696":["thread",163696],"thread-163581":["thread",163581],"thread-163466":["thread",163466],"thread-163146":["thread",163146],"thread-162511":["thread",162511],"thread-162190":["thread",162190],"thread-161752":["thread",161752],"thread-159996":["thread",159996],"thread-159801":["thread",159801],"thread-159423":["thread",159423],"thread-158613":["thread",158613],"thread-158207":["thread",158207],"thread-157939":["thread",157939],"thread-157826":["thread",157826],"thread-157718":["thread",157718],"thread-156911":["thread",156911],"thread-156645":["thread",156645],"thread-156495":["thread",156495],"thread-155905":["thread",155905],"thread-155792":["thread",155792],"thread-155147":["thread",155147],"thread-154222":["thread",154222],"thread-152616":["thread",152616],"thread-152430":["thread",152430],"thread-152336":["thread",152336],"thread-131728":["thread",131728],"thread-130986":["thread",130986],"thread-129915":["thread",129915],"thread-125799":["thread",125799],"thread-125775":["thread",125775],"thread-125561":["thread",125561],"thread-123114":["thread",123114],"thread-121731":["thread",121731],"thread-119319":["thread",119319],"thread-117959":["thread",117959],"thread-115553":["thread",115553],"thread-114224":["thread",114224],"thread-112096":["thread",112096],"thread-109425":["thread",109425],"thread-108011":["thread",108011],"thread-105226":["thread",105226],"thread-102594":["thread",102594],"thread-100672":["thread",100672],"thread-100671":["thread",100671],"thread-98127":["thread",98127],"thread-89965":["thread",89965],"thread-86547":["thread",86547],"thread-83826":["thread",83826],"thread-80581":["thread",80581],"thread-78164":["thread",78164],"thread-78049":["thread",78049],"thread-77642":["thread",77642],"thread-74901":["thread",74901],"thread-74747":["thread",74747],"thread-74742":["thread",74742],"thread-73305":["thread",73305],"thread-71372":["thread",71372],"thread-69521":["thread",69521],"thread-50025":["thread",50025],"thread-49728":["thread",49728],"thread-45490":["thread",45490],"thread-45465":["thread",45465],"thread-38406":["thread",38406],"thread-33751":["thread",33751],"thread-29171":["thread",29171],"thread-23343":["thread",23343],"thread-9527":["thread",9527],"thread-2424":["thread",2424]}, , 1716176071
Run Time: 0.000405
- 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