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 (172299, 158678, 126879, 117053, 112498, 112391, 111473, 111125, 111124, 111094, 109681, 109235, 108097, 105495, 104940, 104919, 103881, 103158, 103100, 102594, 102307, 101088, 101087, 100801, 100797, 100795, 100794, 100496, 100469, 100211, 100099, 99853, 99706, 99656, 99550, 99546, 98407, 98404, 98362, 97511, 97465, 97283, 97215, 97155, 97151, 97122, 97118, 97069, 97029, 96885, 96765, 96694, 96569, 96340, 96174, 96149, 96017, 95973, 95671, 95516, 95479, 95407, 95241, 95150, 95100, 94985, 94916, 94905, 94807, 94803, 94786, 94348, 94232, 94201, 94175, 94174, 94172, 94142, 94103, 93995, 93994, 93993, 93868, 93850, 93842, 93720, 93561, 93523, 93463, 93047, 91796, 91742, 91702, 91666, 91657, 91533, 91530, 75736, 74604, 74590))
Run Time: 0.058877
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 100 | 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: 14786, 0, 1714811836, {"thread-172299":["thread",172299],"thread-158678":["thread",158678],"thread-126879":["thread",126879],"thread-117053":["thread",117053],"thread-112498":["thread",112498],"thread-112391":["thread",112391],"thread-111473":["thread",111473],"thread-111125":["thread",111125],"thread-111124":["thread",111124],"thread-111094":["thread",111094],"thread-109681":["thread",109681],"thread-109235":["thread",109235],"thread-108097":["thread",108097],"thread-105495":["thread",105495],"thread-104940":["thread",104940],"thread-104919":["thread",104919],"thread-103881":["thread",103881],"thread-103158":["thread",103158],"thread-103100":["thread",103100],"thread-102594":["thread",102594],"thread-102307":["thread",102307],"thread-101088":["thread",101088],"thread-101087":["thread",101087],"thread-100801":["thread",100801],"thread-100797":["thread",100797],"thread-100795":["thread",100795],"thread-100794":["thread",100794],"thread-100496":["thread",100496],"thread-100469":["thread",100469],"thread-100211":["thread",100211],"thread-100099":["thread",100099],"thread-99853":["thread",99853],"thread-99706":["thread",99706],"thread-99656":["thread",99656],"thread-99550":["thread",99550],"thread-99546":["thread",99546],"thread-98407":["thread",98407],"thread-98404":["thread",98404],"thread-98362":["thread",98362],"thread-97511":["thread",97511],"thread-97465":["thread",97465],"thread-97283":["thread",97283],"thread-97215":["thread",97215],"thread-97155":["thread",97155],"thread-97151":["thread",97151],"thread-97122":["thread",97122],"thread-97118":["thread",97118],"thread-97069":["thread",97069],"thread-97029":["thread",97029],"thread-96885":["thread",96885],"thread-96765":["thread",96765],"thread-96694":["thread",96694],"thread-96569":["thread",96569],"thread-96340":["thread",96340],"thread-96174":["thread",96174],"thread-96149":["thread",96149],"thread-96017":["thread",96017],"thread-95973":["thread",95973],"thread-95671":["thread",95671],"thread-95516":["thread",95516],"thread-95479":["thread",95479],"thread-95407":["thread",95407],"thread-95241":["thread",95241],"thread-95150":["thread",95150],"thread-95100":["thread",95100],"thread-94985":["thread",94985],"thread-94916":["thread",94916],"thread-94905":["thread",94905],"thread-94807":["thread",94807],"thread-94803":["thread",94803],"thread-94786":["thread",94786],"thread-94348":["thread",94348],"thread-94232":["thread",94232],"thread-94201":["thread",94201],"thread-94175":["thread",94175],"thread-94174":["thread",94174],"thread-94172":["thread",94172],"thread-94142":["thread",94142],"thread-94103":["thread",94103],"thread-93995":["thread",93995],"thread-93994":["thread",93994],"thread-93993":["thread",93993],"thread-93868":["thread",93868],"thread-93850":["thread",93850],"thread-93842":["thread",93842],"thread-93720":["thread",93720],"thread-93561":["thread",93561],"thread-93523":["thread",93523],"thread-93463":["thread",93463],"thread-93047":["thread",93047],"thread-91796":["thread",91796],"thread-91742":["thread",91742],"thread-91702":["thread",91702],"thread-91666":["thread",91666],"thread-91657":["thread",91657],"thread-91533":["thread",91533],"thread-91530":["thread",91530],"thread-75736":["thread",75736],"thread-74604":["thread",74604],"thread-74590":["thread",74590]}, , 1714808236
Run Time: 0.000117
- 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