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 (182607, 181226, 179986, 179684, 179679, 179678, 177299, 176290, 175762, 175474, 174535, 174492, 174176, 174105, 173988, 173975, 173717, 173619, 172954, 172216, 171938, 171762, 171614, 171503, 171236, 170965, 170461, 169914, 167797, 166946, 165796, 165435, 163020, 161981, 161748, 161382, 161296, 160489, 159060, 158544, 158354, 157715, 157099, 154229, 141876, 131986, 128975, 128912, 127213, 120090, 112590, 111786, 104107, 103315, 92853, 92371, 89776, 85745, 85679, 85596, 84305, 83978, 81609, 80160, 71244, 70394, 70338, 66731, 46036, 31326, 2003))
Run Time: 0.031068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 71 | 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: 557, 0, 1716134855, {"thread-182607":["thread",182607],"tl_group-384":["tl_group",384],"thread-181226":["thread",181226],"thread-179986":["thread",179986],"thread-179684":["thread",179684],"thread-179679":["thread",179679],"thread-179678":["thread",179678],"ams_article-5161":["ams_article",5161],"thread-177299":["thread",177299],"thread-176290":["thread",176290],"tl_group-320":["tl_group",320],"thread-175762":["thread",175762],"thread-175474":["thread",175474],"thread-174535":["thread",174535],"thread-174492":["thread",174492],"thread-174176":["thread",174176],"thread-174105":["thread",174105],"thread-173988":["thread",173988],"thread-173975":["thread",173975],"thread-173717":["thread",173717],"thread-173619":["thread",173619],"thread-172954":["thread",172954],"ams_article-4900":["ams_article",4900],"thread-172216":["thread",172216],"thread-171938":["thread",171938],"thread-171762":["thread",171762],"thread-171614":["thread",171614],"thread-171503":["thread",171503],"ams_article-4862":["ams_article",4862],"thread-171236":["thread",171236],"thread-170965":["thread",170965],"thread-170461":["thread",170461],"thread-169914":["thread",169914],"ams_article-4785":["ams_article",4785],"thread-167797":["thread",167797],"ams_article-4731":["ams_article",4731],"thread-166946":["thread",166946],"thread-165796":["thread",165796],"thread-165435":["thread",165435],"ams_article-4578":["ams_article",4578],"thread-163020":["thread",163020],"thread-161981":["thread",161981],"thread-161748":["thread",161748],"thread-161382":["thread",161382],"thread-161296":["thread",161296],"thread-160489":["thread",160489],"thread-159060":["thread",159060],"thread-158544":["thread",158544],"thread-158354":["thread",158354],"thread-157715":["thread",157715],"thread-157099":["thread",157099],"thread-154229":["thread",154229],"thread-141876":["thread",141876],"thread-131986":["thread",131986],"thread-128975":["thread",128975],"thread-128912":["thread",128912],"thread-127213":["thread",127213],"thread-120090":["thread",120090],"thread-112590":["thread",112590],"thread-111786":["thread",111786],"thread-104107":["thread",104107],"thread-103315":["thread",103315],"thread-92853":["thread",92853],"thread-92371":["thread",92371],"thread-89776":["thread",89776],"thread-85745":["thread",85745],"thread-85679":["thread",85679],"thread-85596":["thread",85596],"thread-84305":["thread",84305],"thread-83978":["thread",83978],"thread-81609":["thread",81609],"thread-80160":["thread",80160],"thread-71244":["thread",71244],"thread-70394":["thread",70394],"thread-70338":["thread",70338],"thread-66731":["thread",66731],"thread-46036":["thread",46036],"thread-31326":["thread",31326],"thread-2003":["thread",2003]}, , 1716131255
Run Time: 0.000192
- 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