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 (183478, 182459, 180824, 178196, 178167, 176876, 175807, 175617, 175295, 168779, 168114, 167333, 162325, 162323, 161040, 159756, 157451, 156373, 155682, 155374, 155261, 155072, 154352, 151817, 146207, 139207, 131576, 131002, 130681, 130288, 130279, 129504, 129155, 127653, 126854, 126816, 126502, 126501, 126089, 125456, 124872, 124488, 124133, 123843, 123478, 121959, 121790, 121534, 117480, 115051, 115048, 114179, 113925, 113487, 113319, 111659, 109879, 109552, 109396, 107426, 106368, 105224, 105006, 101666, 98320, 97189, 94324, 90974, 85436, 84669, 83692, 81167, 78662, 75842, 74021, 72597, 70642, 68430, 62861, 59561, 59063, 58648, 56745, 56659, 56657, 56283, 55733, 48736, 41130, 34816, 29965, 25386, 24620, 19724, 12902, 4729, 3738, 2955, 2080))
Run Time: 0.048795
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 99 | 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: 572, 0, 1715929375, {"thread-183478":["thread",183478],"thread-182459":["thread",182459],"thread-180824":["thread",180824],"thread-178196":["thread",178196],"thread-178167":["thread",178167],"thread-176876":["thread",176876],"thread-175807":["thread",175807],"thread-175617":["thread",175617],"thread-175295":["thread",175295],"thread-168779":["thread",168779],"thread-168114":["thread",168114],"thread-167333":["thread",167333],"thread-162325":["thread",162325],"thread-162323":["thread",162323],"thread-161040":["thread",161040],"thread-159756":["thread",159756],"thread-157451":["thread",157451],"thread-156373":["thread",156373],"thread-155682":["thread",155682],"thread-155374":["thread",155374],"thread-155261":["thread",155261],"thread-155072":["thread",155072],"thread-154352":["thread",154352],"thread-146207":["thread",146207],"thread-139207":["thread",139207],"thread-131576":["thread",131576],"thread-131002":["thread",131002],"thread-130681":["thread",130681],"thread-130288":["thread",130288],"thread-130279":["thread",130279],"thread-129504":["thread",129504],"thread-129155":["thread",129155],"thread-127653":["thread",127653],"thread-126854":["thread",126854],"thread-126816":["thread",126816],"thread-126502":["thread",126502],"thread-126501":["thread",126501],"thread-126089":["thread",126089],"thread-125456":["thread",125456],"thread-124872":["thread",124872],"thread-124488":["thread",124488],"thread-124133":["thread",124133],"thread-123843":["thread",123843],"thread-123478":["thread",123478],"thread-121959":["thread",121959],"thread-121790":["thread",121790],"thread-121534":["thread",121534],"thread-117480":["thread",117480],"thread-115051":["thread",115051],"thread-115048":["thread",115048],"thread-114179":["thread",114179],"thread-113925":["thread",113925],"thread-113487":["thread",113487],"thread-113319":["thread",113319],"thread-111659":["thread",111659],"thread-109879":["thread",109879],"thread-109552":["thread",109552],"thread-109396":["thread",109396],"thread-107426":["thread",107426],"thread-106368":["thread",106368],"thread-105224":["thread",105224],"thread-105006":["thread",105006],"thread-101666":["thread",101666],"thread-98320":["thread",98320],"thread-97189":["thread",97189],"thread-94324":["thread",94324],"thread-90974":["thread",90974],"thread-85436":["thread",85436],"thread-84669":["thread",84669],"thread-83692":["thread",83692],"thread-81167":["thread",81167],"thread-78662":["thread",78662],"thread-75842":["thread",75842],"thread-74021":["thread",74021],"thread-72597":["thread",72597],"thread-70642":["thread",70642],"thread-68430":["thread",68430],"thread-62861":["thread",62861],"thread-59561":["thread",59561],"thread-59063":["thread",59063],"thread-58648":["thread",58648],"thread-56745":["thread",56745],"thread-56659":["thread",56659],"thread-56657":["thread",56657],"thread-56283":["thread",56283],"thread-55733":["thread",55733],"thread-48736":["thread",48736],"thread-41130":["thread",41130],"thread-34816":["thread",34816],"thread-29965":["thread",29965],"thread-25386":["thread",25386],"thread-24620":["thread",24620],"thread-19724":["thread",19724],"thread-12902":["thread",12902],"thread-4729":["thread",4729],"thread-3738":["thread",3738],"thread-2955":["thread",2955],"thread-2080":["thread",2080]}, , 1715925775
Run Time: 0.000153
- 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