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 (146895, 145223, 144886, 143678, 142605, 141767, 140835, 140789, 139345, 137773, 135473, 135251, 128879, 128414, 128348, 128246, 126345, 126087, 125985, 125984, 125432, 121682, 121560, 120979, 115599, 115584, 114399, 114398, 113527, 113372, 112611, 112474, 112415, 108734, 108221, 101072, 98004, 97835, 95585, 95584, 95441, 95373, 94703, 94701, 94690, 94689, 94688, 94268, 93526, 93069, 92471, 92460, 92439, 92437, 92411, 92410, 92409, 92362, 92028, 91943, 91763, 91665, 91212, 91204, 90593, 90523, 90522, 90296, 90217, 90216, 90215, 90214, 90213, 90151, 90159, 89816, 89753, 89602, 89335, 89107, 89103, 89085, 89029, 88380, 88376, 81822, 77571, 74784, 55785, 48597, 12838, 8986, 8696, 4577))
Run Time: 0.030160
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 94 | 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: 423, 0, 1716233917, {"thread-146895":["thread",146895],"thread-145223":["thread",145223],"thread-144886":["thread",144886],"thread-143678":["thread",143678],"thread-142605":["thread",142605],"thread-141767":["thread",141767],"thread-140835":["thread",140835],"thread-140789":["thread",140789],"thread-139345":["thread",139345],"thread-137773":["thread",137773],"thread-135473":["thread",135473],"thread-135251":["thread",135251],"thread-128879":["thread",128879],"thread-128414":["thread",128414],"thread-128348":["thread",128348],"thread-128246":["thread",128246],"thread-126345":["thread",126345],"thread-126087":["thread",126087],"thread-125985":["thread",125985],"thread-125984":["thread",125984],"thread-125432":["thread",125432],"thread-121682":["thread",121682],"thread-121560":["thread",121560],"thread-120979":["thread",120979],"thread-115599":["thread",115599],"thread-115584":["thread",115584],"thread-114399":["thread",114399],"thread-114398":["thread",114398],"thread-113527":["thread",113527],"thread-113372":["thread",113372],"thread-112611":["thread",112611],"thread-112474":["thread",112474],"thread-112415":["thread",112415],"thread-108734":["thread",108734],"thread-108221":["thread",108221],"thread-101072":["thread",101072],"thread-98004":["thread",98004],"thread-97835":["thread",97835],"resource-122":["resource",122],"resource-110":["resource",110],"xfmg_media-176":["xfmg_media",176],"thread-95585":["thread",95585],"thread-95584":["thread",95584],"thread-95441":["thread",95441],"thread-95373":["thread",95373],"thread-94703":["thread",94703],"thread-94701":["thread",94701],"thread-94690":["thread",94690],"thread-94689":["thread",94689],"thread-94688":["thread",94688],"thread-94268":["thread",94268],"thread-93526":["thread",93526],"thread-93069":["thread",93069],"thread-92471":["thread",92471],"thread-92460":["thread",92460],"thread-92439":["thread",92439],"thread-92437":["thread",92437],"xfmg_media-135":["xfmg_media",135],"thread-92411":["thread",92411],"thread-92410":["thread",92410],"thread-92409":["thread",92409],"xfmg_media-106":["xfmg_media",106],"thread-92362":["thread",92362],"thread-92028":["thread",92028],"thread-91943":["thread",91943],"thread-91763":["thread",91763],"thread-91665":["thread",91665],"thread-91212":["thread",91212],"thread-91204":["thread",91204],"thread-90593":["thread",90593],"thread-90523":["thread",90523],"thread-90522":["thread",90522],"thread-90296":["thread",90296],"thread-90217":["thread",90217],"thread-90216":["thread",90216],"thread-90215":["thread",90215],"thread-90214":["thread",90214],"thread-90213":["thread",90213],"thread-90151":["thread",90151],"thread-90159":["thread",90159],"thread-89816":["thread",89816],"thread-89753":["thread",89753],"thread-89602":["thread",89602],"thread-89335":["thread",89335],"thread-89107":["thread",89107],"thread-89103":["thread",89103],"thread-89085":["thread",89085],"thread-89029":["thread",89029],"thread-88380":["thread",88380],"thread-88376":["thread",88376],"thread-81822":["thread",81822],"thread-77571":["thread",77571],"thread-74784":["thread",74784],"thread-55785":["thread",55785],"thread-48597":["thread",48597],"thread-12838":["thread",12838],"thread-8986":["thread",8986],"thread-8696":["thread",8696],"thread-4577":["thread",4577]}, NULL, 1716230317
Run Time: 0.002447
- 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