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 (182199, 181781, 180792, 179893, 179840, 177826, 177672, 177509, 177340, 177281, 177163, 176937, 176847, 176202, 175294, 175067, 174979, 172456, 172435, 170456, 170334, 170159, 170034, 169027, 168032, 166843, 166720, 165731, 165593, 165573, 164535, 164534, 163670, 162570, 162471, 162190, 161667, 161578, 161496, 161259, 159220, 158472, 158095, 154894, 154555, 154159, 154106, 153221, 152963, 152574, 128439, 127732, 122289, 117714, 114327, 113580, 106002, 105923, 105650, 104926, 103545, 94038, 93984, 88244, 87020, 85966, 85637, 82027, 81628, 79726, 77685, 68925, 63589, 24356, 1893))
Run Time: 0.037926
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 75 | 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: 540, 0, 1716192604, {"thread-182199":["thread",182199],"thread-181781":["thread",181781],"thread-180792":["thread",180792],"thread-179893":["thread",179893],"thread-179840":["thread",179840],"thread-177826":["thread",177826],"thread-177672":["thread",177672],"thread-177509":["thread",177509],"thread-177340":["thread",177340],"thread-177281":["thread",177281],"thread-177163":["thread",177163],"thread-176937":["thread",176937],"thread-176847":["thread",176847],"thread-176202":["thread",176202],"thread-175294":["thread",175294],"thread-175067":["thread",175067],"thread-174979":["thread",174979],"thread-172456":["thread",172456],"thread-172435":["thread",172435],"thread-170456":["thread",170456],"thread-170334":["thread",170334],"thread-170159":["thread",170159],"thread-170034":["thread",170034],"tl_group-266":["tl_group",266],"thread-169027":["thread",169027],"thread-168032":["thread",168032],"thread-166843":["thread",166843],"thread-166720":["thread",166720],"thread-165731":["thread",165731],"thread-165593":["thread",165593],"thread-165573":["thread",165573],"thread-164535":["thread",164535],"thread-164534":["thread",164534],"thread-163670":["thread",163670],"thread-162570":["thread",162570],"thread-162471":["thread",162471],"thread-162190":["thread",162190],"thread-161667":["thread",161667],"thread-161578":["thread",161578],"thread-161496":["thread",161496],"thread-161259":["thread",161259],"thread-159220":["thread",159220],"thread-158472":["thread",158472],"thread-158095":["thread",158095],"thread-154894":["thread",154894],"thread-154555":["thread",154555],"thread-154159":["thread",154159],"thread-154106":["thread",154106],"thread-153221":["thread",153221],"thread-152963":["thread",152963],"thread-152574":["thread",152574],"ams_article-3613":["ams_article",3613],"ams_article-3595":["ams_article",3595],"thread-128439":["thread",128439],"thread-127732":["thread",127732],"thread-122289":["thread",122289],"thread-117714":["thread",117714],"thread-114327":["thread",114327],"thread-113580":["thread",113580],"thread-106002":["thread",106002],"thread-105923":["thread",105923],"thread-105650":["thread",105650],"thread-104926":["thread",104926],"thread-103545":["thread",103545],"thread-94038":["thread",94038],"thread-93984":["thread",93984],"thread-88244":["thread",88244],"thread-87020":["thread",87020],"thread-85966":["thread",85966],"thread-85637":["thread",85637],"thread-82027":["thread",82027],"thread-81628":["thread",81628],"thread-79726":["thread",79726],"thread-77685":["thread",77685],"thread-68925":["thread",68925],"thread-63589":["thread",63589],"thread-24356":["thread",24356],"thread-1893":["thread",1893]}, , 1716189004
Run Time: 0.000548
- 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