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 (183337, 183114, 182714, 182417, 179735, 177663, 176311, 175626, 175624, 174707, 174616, 174291, 171901, 171851, 171546, 170524, 168791, 168588, 168007, 167052, 165478, 165012, 165008, 164396, 164070, 163315, 163263, 163260, 163043, 163033, 162995, 162991, 162739, 162712, 162704, 162028, 161523, 161402, 161262, 161256, 160651, 160624, 160439, 160349, 160204, 160202, 160108, 160083, 159990, 159984, 159692, 159675, 159569, 159549, 159514, 158965, 158479, 156448, 155954, 154891, 153900, 144751, 141191, 136742, 136668, 134784, 132625, 128661, 128590, 128570, 128481, 128425, 127858, 127265, 127166, 126250, 126035, 125955, 125477, 125472, 125396, 123807, 123467, 122078, 119990, 119573, 119544, 118670, 117512, 116976, 115753, 115298, 113579, 109308, 106872, 102742, 100645, 99103, 99009, 97853, 97781, 97591, 97554, 97461, 97460, 97459, 97401, 97068, 96874, 95506, 90402, 87498, 85882, 85094, 81305, 80436, 80417, 80276, 79671, 79658, 79317, 79307, 75476, 48681, 8217))
Run Time: 0.065941
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 125 | 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: 1456, 0, 1715758576, {"thread-183337":["thread",183337],"thread-183114":["thread",183114],"thread-182714":["thread",182714],"thread-182417":["thread",182417],"thread-179735":["thread",179735],"thread-177663":["thread",177663],"thread-176311":["thread",176311],"thread-175626":["thread",175626],"thread-175624":["thread",175624],"thread-174707":["thread",174707],"thread-174616":["thread",174616],"thread-174291":["thread",174291],"ams_article-4944":["ams_article",4944],"ams_article-4883":["ams_article",4883],"thread-171901":["thread",171901],"thread-171851":["thread",171851],"thread-171546":["thread",171546],"thread-170524":["thread",170524],"thread-168791":["thread",168791],"thread-168588":["thread",168588],"thread-168007":["thread",168007],"thread-167052":["thread",167052],"thread-165478":["thread",165478],"thread-165012":["thread",165012],"thread-165008":["thread",165008],"ams_article-4610":["ams_article",4610],"thread-164396":["thread",164396],"thread-164070":["thread",164070],"ams_article-4543":["ams_article",4543],"thread-163315":["thread",163315],"thread-163263":["thread",163263],"thread-163260":["thread",163260],"thread-163043":["thread",163043],"thread-163033":["thread",163033],"thread-162995":["thread",162995],"thread-162991":["thread",162991],"thread-162739":["thread",162739],"thread-162712":["thread",162712],"thread-162704":["thread",162704],"thread-162028":["thread",162028],"thread-161523":["thread",161523],"thread-161402":["thread",161402],"thread-161262":["thread",161262],"thread-161256":["thread",161256],"thread-160651":["thread",160651],"thread-160624":["thread",160624],"ams_article-4424":["ams_article",4424],"thread-160439":["thread",160439],"ams_article-4422":["ams_article",4422],"thread-160349":["thread",160349],"thread-160204":["thread",160204],"thread-160202":["thread",160202],"thread-160108":["thread",160108],"thread-160083":["thread",160083],"thread-159990":["thread",159990],"thread-159984":["thread",159984],"tl_group-166":["tl_group",166],"ams_article-4395":["ams_article",4395],"tl_group-162":["tl_group",162],"thread-159692":["thread",159692],"thread-159675":["thread",159675],"thread-159569":["thread",159569],"thread-159549":["thread",159549],"thread-158965":["thread",158965],"thread-158479":["thread",158479],"tl_group-137":["tl_group",137],"thread-156448":["thread",156448],"thread-155954":["thread",155954],"thread-154891":["thread",154891],"thread-153900":["thread",153900],"ams_article-3912":["ams_article",3912],"tl_group-7":["tl_group",7],"ams_article-3626":["ams_article",3626],"thread-144751":["thread",144751],"thread-141191":["thread",141191],"thread-136742":["thread",136742],"thread-136668":["thread",136668],"thread-134784":["thread",134784],"thread-132625":["thread",132625],"thread-128661":["thread",128661],"thread-128590":["thread",128590],"thread-128570":["thread",128570],"thread-128481":["thread",128481],"thread-128425":["thread",128425],"thread-127858":["thread",127858],"thread-127265":["thread",127265],"thread-127166":["thread",127166],"thread-126250":["thread",126250],"thread-126035":["thread",126035],"thread-125955":["thread",125955],"thread-125477":["thread",125477],"thread-125472":["thread",125472],"thread-125396":["thread",125396],"thread-123807":["thread",123807],"thread-123467":["thread",123467],"thread-122078":["thread",122078],"thread-119990":["thread",119990],"thread-119573":["thread",119573],"thread-119544":["thread",119544],"thread-118670":["thread",118670],"thread-117512":["thread",117512],"thread-116976":["thread",116976],"thread-115753":["thread",115753],"thread-115298":["thread",115298],"thread-113579":["thread",113579],"thread-109308":["thread",109308],"thread-106872":["thread",106872],"thread-102742":["thread",102742],"thread-100645":["thread",100645],"thread-99103":["thread",99103],"thread-99009":["thread",99009],"thread-97853":["thread",97853],"thread-97781":["thread",97781],"thread-97591":["thread",97591],"thread-97554":["thread",97554],"thread-97461":["thread",97461],"thread-97460":["thread",97460],"thread-97459":["thread",97459],"thread-97401":["thread",97401],"thread-97068":["thread",97068],"thread-96874":["thread",96874],"thread-95506":["thread",95506],"thread-90402":["thread",90402],"thread-87498":["thread",87498],"thread-85882":["thread",85882],"thread-85094":["thread",85094],"thread-81305":["thread",81305],"thread-80436":["thread",80436],"thread-80417":["thread",80417],"thread-80276":["thread",80276],"thread-79671":["thread",79671],"thread-79658":["thread",79658],"thread-79317":["thread",79317],"thread-79307":["thread",79307],"thread-75476":["thread",75476],"thread-48681":["thread",48681],"thread-8217":["thread",8217]}, , 1715754976
Run Time: 0.000404
- 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