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 (158582, 158269, 158076, 157884, 155181, 154892, 148012, 144490, 143591, 143459, 141727, 133974, 133967, 133741, 132642, 132621, 132571, 131851, 131750, 131722, 131640, 130838, 130808, 130761, 129025, 128521, 128494, 128362, 128340, 128339, 128336, 128312, 128259, 127498, 127373, 127358, 127282, 127126, 127053, 123725, 123646, 123443, 123432, 123316, 123313, 123192, 123187, 123182, 123167, 123130, 123102, 122733, 122466, 121187, 120397, 120390, 120385, 120378, 120365, 120350, 120287, 120109, 119404, 119364, 119334, 119277, 119149, 119142, 119127, 119125, 119123, 119122, 119120, 119007, 118668, 118496, 118126, 117847, 117693, 117350, 117253, 117020, 117015, 114471, 114460, 114231, 110230, 109055, 108657, 108593, 108458, 107865, 106964, 106821, 105307, 105221, 104037, 104023, 103819, 103682, 103681))
Run Time: 0.096849
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 101 | 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: 24047, 0, 1716643211, {"thread-158582":["thread",158582],"thread-158269":["thread",158269],"thread-158076":["thread",158076],"thread-157884":["thread",157884],"thread-155181":["thread",155181],"thread-154892":["thread",154892],"ams_article-3682":["ams_article",3682],"thread-148012":["thread",148012],"thread-144490":["thread",144490],"thread-143591":["thread",143591],"thread-143459":["thread",143459],"thread-141727":["thread",141727],"ams_article-3039":["ams_article",3039],"ams_article-3036":["ams_article",3036],"ams_article-3031":["ams_article",3031],"thread-133974":["thread",133974],"thread-133967":["thread",133967],"thread-133741":["thread",133741],"thread-132642":["thread",132642],"thread-132621":["thread",132621],"thread-132571":["thread",132571],"thread-131851":["thread",131851],"thread-131750":["thread",131750],"thread-131722":["thread",131722],"thread-131640":["thread",131640],"thread-130838":["thread",130838],"thread-130808":["thread",130808],"thread-130761":["thread",130761],"thread-129025":["thread",129025],"thread-128521":["thread",128521],"thread-128494":["thread",128494],"thread-128362":["thread",128362],"thread-128340":["thread",128340],"thread-128339":["thread",128339],"thread-128336":["thread",128336],"thread-128312":["thread",128312],"thread-128259":["thread",128259],"thread-127498":["thread",127498],"thread-127373":["thread",127373],"thread-127358":["thread",127358],"thread-127282":["thread",127282],"thread-127126":["thread",127126],"thread-127053":["thread",127053],"thread-123725":["thread",123725],"thread-123646":["thread",123646],"thread-123443":["thread",123443],"thread-123432":["thread",123432],"thread-123316":["thread",123316],"thread-123313":["thread",123313],"thread-123192":["thread",123192],"thread-123187":["thread",123187],"thread-123182":["thread",123182],"thread-123167":["thread",123167],"thread-123130":["thread",123130],"thread-123102":["thread",123102],"thread-122733":["thread",122733],"thread-122466":["thread",122466],"thread-121187":["thread",121187],"thread-120397":["thread",120397],"thread-120390":["thread",120390],"thread-120385":["thread",120385],"thread-120378":["thread",120378],"thread-120365":["thread",120365],"thread-120350":["thread",120350],"thread-120287":["thread",120287],"thread-120109":["thread",120109],"thread-119404":["thread",119404],"thread-119364":["thread",119364],"thread-119334":["thread",119334],"thread-119277":["thread",119277],"thread-119149":["thread",119149],"thread-119142":["thread",119142],"thread-119127":["thread",119127],"thread-119125":["thread",119125],"thread-119123":["thread",119123],"thread-119122":["thread",119122],"thread-119120":["thread",119120],"thread-119007":["thread",119007],"thread-118668":["thread",118668],"thread-118496":["thread",118496],"thread-118126":["thread",118126],"thread-117847":["thread",117847],"thread-117693":["thread",117693],"thread-117350":["thread",117350],"thread-117253":["thread",117253],"thread-117020":["thread",117020],"thread-117015":["thread",117015],"thread-114471":["thread",114471],"thread-114460":["thread",114460],"thread-114231":["thread",114231],"thread-110230":["thread",110230],"thread-109055":["thread",109055],"thread-108657":["thread",108657],"thread-108593":["thread",108593],"thread-108458":["thread",108458],"thread-107865":["thread",107865],"thread-106964":["thread",106964],"thread-106821":["thread",106821],"thread-105307":["thread",105307],"thread-105221":["thread",105221],"thread-104037":["thread",104037],"thread-104023":["thread",104023],"thread-103819":["thread",103819],"thread-103682":["thread",103682],"thread-103681":["thread",103681]}, , 1716639611
Run Time: 0.000620
- 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