QQ扫一扫联系
# Query_time: 3.330494 Lock_time: 0.000200 Rows_sent: 0 Rows_examined: 88962
SET timestamp=1725680049;
select `id`, `hash`, `created_at`, `memberUserId`, `categoryId`, `title`, `description`, `status`, `convertStatus`, `cover`, `pageCount`, `viewCount`, `commentCount`, `scoreAvg`, `downloadCount`, `favoriteCount`, `likeCount`, `viewCountBase`, `downloadCountBase`, `favoriteCountBase`, `likeCountBase`, `vipFreeDownloadEnable`, `creditCost`, `moneyCost`, `rateAvg`, `tags`, `previewData`, `ext`, `fileSize`, `pagePreviews` from `mzwenku_doc` where (`status` = '5' and `isDeleted` = '0') and `categoryId` in ('9', '4', '39', '29', '30', '58', '65') and (select count(*) from `mzwenku_doc_cat_map` where `mzwenku_doc_cat_map`.`docId` = `mzwenku_doc`.`id` and (`catId` = '20')) >= 1 and (select count(*) from `mzwenku_doc_cat_map` where `mzwenku_doc_cat_map`.`docId` = `mzwenku_doc`.`id` and (`catId` = '40')) >= 1 and (select count(*) from `mzwenku_doc_cat_map` where `mzwenku_doc_cat_map`.`docId` = `mzwenku_doc`.`id` and (`catId` = '133')) >= 1 and (select count(*) from `mzwenku_doc_cat_map` where `mzwenku_doc_cat_map`.`docId` = `mzwenku_doc`.`id` and (`catId` = '142')) >= 1 and (select count(*) from `mzwenku_doc_cat_map` where `mzwenku_doc_cat_map`.`docId` = `mzwenku_doc`.`id` and (`catId` = '144')) >= 1 and `ext` in ('doc', 'docx') order by `id` desc limit 24 offset 0;
升级数据库,索引已经优化了,辅助分类用多了是这样的
@ModStart: 数据库怎么升级
给数据库独立的服务器,升级为8C16G、16C32G,根据数据量大小来调整。
我现在都把辅助分类全部删除,辅助分类很耗资源