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 (183224, 180092, 178629, 178547, 178115, 177090, 176205, 176117, 175789, 175460, 175024, 174173, 172104, 170472, 169488, 168799, 168635, 166950, 166450, 165777, 163668, 162619, 161653, 161527, 160053, 159592, 156774, 156267, 154315, 153268, 152514, 149627, 147808, 147198, 147137, 142679, 132307, 131342, 131336, 129688, 127208, 126420, 124072, 123491, 123435, 121984, 117844, 117048, 115525, 115386, 113220, 112910, 112649, 112629, 110646, 109199, 108071, 106798, 105393, 103960, 102848, 100166, 99516, 98641, 98144, 98053, 95954, 93969, 89117, 84704, 83128, 81549, 80799, 80668, 80520, 80505, 80499, 80123, 79857, 79840, 79839, 79586, 75657, 55410, 54855, 51080, 50237, 49099, 46479, 38348, 33039, 33011, 31203, 30856, 24204, 16984, 5098, 5091))
Run Time: 0.078230
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 98 | 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: 1099, 0, 1715772246, {"thread-183224":["thread",183224],"thread-180092":["thread",180092],"thread-178629":["thread",178629],"thread-178547":["thread",178547],"thread-178115":["thread",178115],"thread-177090":["thread",177090],"thread-176205":["thread",176205],"thread-176117":["thread",176117],"thread-175789":["thread",175789],"thread-175460":["thread",175460],"thread-175024":["thread",175024],"thread-174173":["thread",174173],"thread-172104":["thread",172104],"thread-170472":["thread",170472],"thread-169488":["thread",169488],"thread-168799":["thread",168799],"thread-168635":["thread",168635],"thread-166950":["thread",166950],"thread-166450":["thread",166450],"thread-165777":["thread",165777],"tl_group-202":["tl_group",202],"thread-163668":["thread",163668],"thread-162619":["thread",162619],"thread-161653":["thread",161653],"thread-161527":["thread",161527],"thread-160053":["thread",160053],"thread-159592":["thread",159592],"thread-156774":["thread",156774],"thread-156267":["thread",156267],"thread-154315":["thread",154315],"thread-153268":["thread",153268],"thread-152514":["thread",152514],"thread-149627":["thread",149627],"thread-147808":["thread",147808],"thread-147198":["thread",147198],"thread-147137":["thread",147137],"thread-142679":["thread",142679],"ams_article-3187":["ams_article",3187],"thread-132307":["thread",132307],"thread-131342":["thread",131342],"thread-131336":["thread",131336],"thread-129688":["thread",129688],"thread-127208":["thread",127208],"thread-126420":["thread",126420],"thread-124072":["thread",124072],"thread-123491":["thread",123491],"thread-123435":["thread",123435],"thread-121984":["thread",121984],"thread-117844":["thread",117844],"thread-117048":["thread",117048],"thread-115525":["thread",115525],"thread-115386":["thread",115386],"thread-113220":["thread",113220],"thread-112910":["thread",112910],"thread-112649":["thread",112649],"thread-112629":["thread",112629],"thread-110646":["thread",110646],"thread-109199":["thread",109199],"thread-108071":["thread",108071],"thread-106798":["thread",106798],"thread-105393":["thread",105393],"thread-103960":["thread",103960],"thread-102848":["thread",102848],"thread-100166":["thread",100166],"thread-99516":["thread",99516],"thread-98641":["thread",98641],"thread-98144":["thread",98144],"thread-98053":["thread",98053],"thread-95954":["thread",95954],"thread-93969":["thread",93969],"thread-89117":["thread",89117],"thread-84704":["thread",84704],"thread-83128":["thread",83128],"thread-81549":["thread",81549],"thread-80799":["thread",80799],"thread-80668":["thread",80668],"thread-80520":["thread",80520],"thread-80505":["thread",80505],"thread-80499":["thread",80499],"thread-80123":["thread",80123],"thread-79857":["thread",79857],"thread-79840":["thread",79840],"thread-79839":["thread",79839],"thread-79586":["thread",79586],"thread-75657":["thread",75657],"thread-55410":["thread",55410],"thread-54855":["thread",54855],"thread-51080":["thread",51080],"thread-50237":["thread",50237],"thread-49099":["thread",49099],"thread-46479":["thread",46479],"thread-38348":["thread",38348],"thread-33039":["thread",33039],"thread-33011":["thread",33011],"thread-31203":["thread",31203],"thread-30856":["thread",30856],"thread-24204":["thread",24204],"thread-16984":["thread",16984],"thread-5098":["thread",5098],"thread-5091":["thread",5091]}, , 1715768646
Run Time: 0.000165
- 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