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 (182632, 182589, 182286, 181420, 181052, 180226, 180192, 180123, 176201, 175630, 175576, 174751, 174048, 174019, 168809, 168266, 163545, 163170, 162211, 161706, 160681, 157528, 156530, 155446, 154945, 153941, 153935, 153934, 152702, 151887, 150628, 150624, 149224, 145446, 139771, 136455, 136054, 131939, 131911, 128076, 124208, 122889, 121866, 119688, 118229, 117076, 117038, 114075, 113027, 112947, 112926, 112170, 111868, 111831, 111780, 111685, 111613, 110442, 110376, 109623, 109111, 108650, 108320, 108080, 107207, 106623, 106216, 105214, 105166, 90991, 90859, 90856, 90244, 90238, 90235, 86822, 85764, 82011, 76712, 76640, 76627, 75359, 73325, 73265, 73260, 73098, 71745, 71475, 70623, 70276, 70262, 70101, 70075, 69597, 68116, 67886, 67375, 66958, 66286, 64193, 64186, 64164, 62140, 60691, 59453, 59100, 58934, 58583, 57618, 57617, 57614, 57613, 57608, 57522, 56872, 55955, 54935, 53404, 51071, 50836, 48431, 47017, 47010, 45096, 44639, 41083, 40418, 36056, 34349, 32339, 21732, 20071, 20064, 14765, 8068, 5140))
Run Time: 0.086106
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 136 | 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: 1305, 0, 1716032543, {"thread-182632":["thread",182632],"thread-182589":["thread",182589],"thread-182286":["thread",182286],"thread-181420":["thread",181420],"thread-181052":["thread",181052],"thread-180226":["thread",180226],"thread-180192":["thread",180192],"thread-180123":["thread",180123],"thread-176201":["thread",176201],"thread-175630":["thread",175630],"thread-175576":["thread",175576],"thread-174751":["thread",174751],"thread-174048":["thread",174048],"thread-174019":["thread",174019],"thread-168809":["thread",168809],"thread-168266":["thread",168266],"ams_article-4667":["ams_article",4667],"thread-163545":["thread",163545],"thread-163170":["thread",163170],"thread-162211":["thread",162211],"thread-161706":["thread",161706],"thread-160681":["thread",160681],"thread-157528":["thread",157528],"thread-156530":["thread",156530],"thread-155446":["thread",155446],"thread-154945":["thread",154945],"thread-153941":["thread",153941],"thread-153935":["thread",153935],"thread-153934":["thread",153934],"thread-152702":["thread",152702],"thread-151887":["thread",151887],"thread-150628":["thread",150628],"thread-150624":["thread",150624],"thread-149224":["thread",149224],"ams_article-3563":["ams_article",3563],"thread-145446":["thread",145446],"ams_article-3201":["ams_article",3201],"thread-139771":["thread",139771],"thread-136455":["thread",136455],"thread-136054":["thread",136054],"thread-131939":["thread",131939],"thread-131911":["thread",131911],"thread-128076":["thread",128076],"thread-124208":["thread",124208],"thread-122889":["thread",122889],"thread-121866":["thread",121866],"thread-119688":["thread",119688],"thread-118229":["thread",118229],"thread-117076":["thread",117076],"thread-117038":["thread",117038],"thread-114075":["thread",114075],"thread-113027":["thread",113027],"thread-112947":["thread",112947],"thread-112926":["thread",112926],"thread-112170":["thread",112170],"thread-111868":["thread",111868],"thread-111831":["thread",111831],"thread-111780":["thread",111780],"thread-111685":["thread",111685],"thread-111613":["thread",111613],"thread-110442":["thread",110442],"thread-110376":["thread",110376],"thread-109623":["thread",109623],"thread-109111":["thread",109111],"thread-108650":["thread",108650],"thread-108320":["thread",108320],"thread-108080":["thread",108080],"thread-107207":["thread",107207],"thread-106623":["thread",106623],"thread-106216":["thread",106216],"thread-105214":["thread",105214],"thread-105166":["thread",105166],"thread-90991":["thread",90991],"thread-90859":["thread",90859],"thread-90856":["thread",90856],"thread-90244":["thread",90244],"thread-90238":["thread",90238],"thread-90235":["thread",90235],"thread-86822":["thread",86822],"thread-85764":["thread",85764],"thread-82011":["thread",82011],"thread-76712":["thread",76712],"thread-76640":["thread",76640],"thread-76627":["thread",76627],"thread-75359":["thread",75359],"thread-73325":["thread",73325],"thread-73265":["thread",73265],"thread-73260":["thread",73260],"thread-73098":["thread",73098],"thread-71745":["thread",71745],"thread-71475":["thread",71475],"thread-70623":["thread",70623],"thread-70276":["thread",70276],"thread-70262":["thread",70262],"thread-70101":["thread",70101],"thread-70075":["thread",70075],"thread-69597":["thread",69597],"thread-68116":["thread",68116],"thread-67886":["thread",67886],"thread-67375":["thread",67375],"thread-66958":["thread",66958],"thread-66286":["thread",66286],"thread-64193":["thread",64193],"thread-64186":["thread",64186],"thread-64164":["thread",64164],"thread-62140":["thread",62140],"thread-60691":["thread",60691],"thread-59453":["thread",59453],"thread-59100":["thread",59100],"thread-58934":["thread",58934],"thread-58583":["thread",58583],"thread-57618":["thread",57618],"thread-57617":["thread",57617],"thread-57614":["thread",57614],"thread-57613":["thread",57613],"thread-57608":["thread",57608],"thread-57522":["thread",57522],"thread-56872":["thread",56872],"thread-55955":["thread",55955],"thread-54935":["thread",54935],"thread-53404":["thread",53404],"thread-51071":["thread",51071],"thread-50836":["thread",50836],"thread-48431":["thread",48431],"thread-47017":["thread",47017],"thread-47010":["thread",47010],"thread-45096":["thread",45096],"thread-44639":["thread",44639],"thread-41083":["thread",41083],"thread-40418":["thread",40418],"thread-36056":["thread",36056],"thread-34349":["thread",34349],"thread-32339":["thread",32339],"thread-21732":["thread",21732],"thread-20071":["thread",20071],"thread-20064":["thread",20064],"thread-14765":["thread",14765],"thread-8068":["thread",8068],"thread-5140":["thread",5140]}, , 1716028943
Run Time: 0.000249
- 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