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 (146278, 143360, 137970, 136914, 133990, 132216, 131092, 131050, 128008, 127820, 127608, 126000, 125707, 125538, 125535, 123885, 123882, 123881, 123853, 123844, 123843, 123841, 123840, 123839, 123838, 123143, 119954, 119361, 118995, 118981, 117133, 117098, 117046, 117040, 116407, 114780, 113327, 113308, 113168, 113159, 112237, 112220, 112217, 112091, 111970, 111967, 111966, 111928, 111880, 111808, 111748, 111630, 111591, 111500, 111437, 111419, 111144, 111141, 111128, 111118, 110770, 110743, 110742, 110738, 110664, 110046, 109190, 108356, 108133, 107821, 106941, 101427, 99591, 99449, 99039, 96205, 95817, 95413, 93210, 92326, 90221, 90812, 90614, 90430, 90401, 89041, 88390, 47249, 43656, 37533, 15198))
Run Time: 0.203983
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 91 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,carder_admin_bd.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 1392
- 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 2731
- 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 2353
- XF\App->run() in src/XF.php at line 524
- 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: 657, 0, 1716232843, {"thread-146278":["thread",146278],"thread-143360":["thread",143360],"thread-137970":["thread",137970],"thread-136914":["thread",136914],"thread-133990":["thread",133990],"thread-132216":["thread",132216],"thread-131092":["thread",131092],"thread-131050":["thread",131050],"thread-128008":["thread",128008],"thread-127820":["thread",127820],"thread-127608":["thread",127608],"thread-126000":["thread",126000],"thread-125707":["thread",125707],"thread-125538":["thread",125538],"thread-125535":["thread",125535],"thread-123885":["thread",123885],"thread-123882":["thread",123882],"thread-123881":["thread",123881],"thread-123853":["thread",123853],"thread-123844":["thread",123844],"thread-123843":["thread",123843],"thread-123841":["thread",123841],"thread-123840":["thread",123840],"thread-123839":["thread",123839],"thread-123838":["thread",123838],"thread-123143":["thread",123143],"thread-119954":["thread",119954],"thread-119361":["thread",119361],"thread-118995":["thread",118995],"thread-118981":["thread",118981],"thread-117133":["thread",117133],"thread-117098":["thread",117098],"thread-117046":["thread",117046],"thread-117040":["thread",117040],"thread-116407":["thread",116407],"thread-114780":["thread",114780],"thread-113327":["thread",113327],"thread-113308":["thread",113308],"thread-113168":["thread",113168],"thread-113159":["thread",113159],"thread-112237":["thread",112237],"thread-112220":["thread",112220],"thread-112217":["thread",112217],"thread-112091":["thread",112091],"thread-111970":["thread",111970],"thread-111967":["thread",111967],"thread-111966":["thread",111966],"thread-111928":["thread",111928],"thread-111880":["thread",111880],"thread-111808":["thread",111808],"thread-111748":["thread",111748],"thread-111630":["thread",111630],"thread-111591":["thread",111591],"thread-111500":["thread",111500],"thread-111437":["thread",111437],"thread-111419":["thread",111419],"thread-111144":["thread",111144],"thread-111141":["thread",111141],"thread-111128":["thread",111128],"thread-111118":["thread",111118],"thread-110770":["thread",110770],"thread-110743":["thread",110743],"thread-110742":["thread",110742],"thread-110738":["thread",110738],"thread-110664":["thread",110664],"thread-110046":["thread",110046],"thread-109190":["thread",109190],"thread-108356":["thread",108356],"thread-108133":["thread",108133],"thread-107821":["thread",107821],"thread-106941":["thread",106941],"thread-101427":["thread",101427],"thread-99591":["thread",99591],"thread-99449":["thread",99449],"thread-99039":["thread",99039],"xfmg_media-178":["xfmg_media",178],"thread-96205":["thread",96205],"thread-95817":["thread",95817],"thread-95413":["thread",95413],"thread-93210":["thread",93210],"xfmg_media-139":["xfmg_media",139],"thread-92326":["thread",92326],"xfmg_media-98":["xfmg_media",98],"xfmg_media-91":["xfmg_media",91],"xfmg_media-83":["xfmg_media",83],"xfmg_media-82":["xfmg_media",82],"xfmg_media-81":["xfmg_media",81],"xfmg_media-80":["xfmg_media",80],"xfmg_media-75":["xfmg_media",75],"xfmg_media-74":["xfmg_media",74],"xfmg_media-64":["xfmg_media",64],"thread-90221":["thread",90221],"xfmg_media-3":["xfmg_media",3],"xfmg_media-4":["xfmg_media",4],"xfmg_media-5":["xfmg_media",5],"xfmg_media-12":["xfmg_media",12],"xfmg_media-19":["xfmg_media",19],"xfmg_media-20":["xfmg_media",20],"xfmg_media-22":["xfmg_media",22],"xfmg_media-24":["xfmg_media",24],"xfmg_media-1":["xfmg_media",1],"xfmg_media-2":["xfmg_media",2],"thread-90812":["thread",90812],"thread-90614":["thread",90614],"thread-90430":["thread",90430],"thread-90401":["thread",90401],"thread-89041":["thread",89041],"thread-88390":["thread",88390],"thread-47249":["thread",47249],"thread-43656":["thread",43656],"thread-37533":["thread",37533],"thread-15198":["thread",15198]}, NULL, 1716229243
Run Time: 0.001103
- 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 1516
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1248
- 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 2353
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20