30万数据 动态查出用户拥有对应 skuid 数量

article/2025/9/7 20:39:43

项目场景：

提示：30万数据 动态查出用户拥有对应 skuid 数量：
如 skuid1 skuid2 skuid3 skuid4 …
在这里插入图片描述
表结构如下

CREATE TABLE `eb_nft_user` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`skuId` varchar(255) NOT NULL DEFAULT '' COMMENT '商品编码',`nftId` varchar(255) NOT NULL DEFAULT '' COMMENT '的唯编码',`skuName` varchar(255) NOT NULL DEFAULT '' COMMENT '商品的名称',`add_time` varchar(50) DEFAULT NULL,`user_id` int(10) DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE,KEY `skuId` (`skuId`) USING BTREE,KEY `user_id` (`user_id`) USING BTREE,KEY `nftId` (`nftId`) USING BTREE,KEY `idx_user_sku` (`user_id`,`skuId`),KEY `idx_eb_nft_user_user_sku` (`user_id`,`skuId`)
) ENGINE=InnoDB AUTO_INCREMENT=340998 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户拥有的id';

原有在加索引情况下 查询160个分类 大概需要 7到8秒 这是业务不能接受的

代码如下

SELECT`user_id`,SUM( CASE WHEN skuId = 26330 THEN 1 ELSE 0 END ) AS a_26330,SUM( CASE WHEN skuId = 26329 THEN 1 ELSE 0 END ) AS a_26329,SUM( CASE WHEN skuId = 26328 THEN 1 ELSE 0 END ) AS a_26328,SUM( CASE WHEN skuId = 26327 THEN 1 ELSE 0 END ) AS a_26327,SUM( CASE WHEN skuId = 26326 THEN 1 ELSE 0 END ) AS a_26326,SUM( CASE WHEN skuId = 26322 THEN 1 ELSE 0 END ) AS a_26322,SUM( CASE WHEN skuId = 25182 THEN 1 ELSE 0 END ) AS a_25182,SUM( CASE WHEN skuId = 25133 THEN 1 ELSE 0 END ) AS a_25133,SUM( CASE WHEN skuId = 24293 THEN 1 ELSE 0 END ) AS a_24293,SUM( CASE WHEN skuId = 24288 THEN 1 ELSE 0 END ) AS a_24288,SUM( CASE WHEN skuId = 24286 THEN 1 ELSE 0 END ) AS a_24286,SUM( CASE WHEN skuId = 24285 THEN 1 ELSE 0 END ) AS a_24285,SUM( CASE WHEN skuId = 24261 THEN 1 ELSE 0 END ) AS a_24261,SUM( CASE WHEN skuId = 24260 THEN 1 ELSE 0 END ) AS a_24260,SUM( CASE WHEN skuId = 23006 THEN 1 ELSE 0 END ) AS a_23006,SUM( CASE WHEN skuId = 23005 THEN 1 ELSE 0 END ) AS a_23005,SUM( CASE WHEN skuId = 22631 THEN 1 ELSE 0 END ) AS a_22631,SUM( CASE WHEN skuId = 22628 THEN 1 ELSE 0 END ) AS a_22628,SUM( CASE WHEN skuId = 22317 THEN 1 ELSE 0 END ) AS a_22317,SUM( CASE WHEN skuId = 22156 THEN 1 ELSE 0 END ) AS a_22156,SUM( CASE WHEN skuId = 22153 THEN 1 ELSE 0 END ) AS a_22153,SUM( CASE WHEN skuId = 22152 THEN 1 ELSE 0 END ) AS a_22152,SUM( CASE WHEN skuId = 22151 THEN 1 ELSE 0 END ) AS a_22151,SUM( CASE WHEN skuId = 21801 THEN 1 ELSE 0 END ) AS a_21801,SUM( CASE WHEN skuId = 21481 THEN 1 ELSE 0 END ) AS a_21481,SUM( CASE WHEN skuId = 21480 THEN 1 ELSE 0 END ) AS a_21480,SUM( CASE WHEN skuId = 21479 THEN 1 ELSE 0 END ) AS a_21479,SUM( CASE WHEN skuId = 21478 THEN 1 ELSE 0 END ) AS a_21478,SUM( CASE WHEN skuId = 21279 THEN 1 ELSE 0 END ) AS a_21279,SUM( CASE WHEN skuId = 20650 THEN 1 ELSE 0 END ) AS a_20650,SUM( CASE WHEN skuId = 20649 THEN 1 ELSE 0 END ) AS a_20649,SUM( CASE WHEN skuId = 20648 THEN 1 ELSE 0 END ) AS a_20648,SUM( CASE WHEN skuId = 20647 THEN 1 ELSE 0 END ) AS a_20647,SUM( CASE WHEN skuId = 20509 THEN 1 ELSE 0 END ) AS a_20509,SUM( CASE WHEN skuId = 20403 THEN 1 ELSE 0 END ) AS a_20403,SUM( CASE WHEN skuId = 20106 THEN 1 ELSE 0 END ) AS a_20106,SUM( CASE WHEN skuId = 19882 THEN 1 ELSE 0 END ) AS a_19882,SUM( CASE WHEN skuId = 19506 THEN 1 ELSE 0 END ) AS a_19506,SUM( CASE WHEN skuId = 19505 THEN 1 ELSE 0 END ) AS a_19505,SUM( CASE WHEN skuId = 19437 THEN 1 ELSE 0 END ) AS a_19437,SUM( CASE WHEN skuId = 19401 THEN 1 ELSE 0 END ) AS a_19401,SUM( CASE WHEN skuId = 19400 THEN 1 ELSE 0 END ) AS a_19400,SUM( CASE WHEN skuId = 19399 THEN 1 ELSE 0 END ) AS a_19399,SUM( CASE WHEN skuId = 19128 THEN 1 ELSE 0 END ) AS a_19128,SUM( CASE WHEN skuId = 18926 THEN 1 ELSE 0 END ) AS a_18926,SUM( CASE WHEN skuId = 18925 THEN 1 ELSE 0 END ) AS a_18925,SUM( CASE WHEN skuId = 18924 THEN 1 ELSE 0 END ) AS a_18924,SUM( CASE WHEN skuId = 18923 THEN 1 ELSE 0 END ) AS a_18923,SUM( CASE WHEN skuId = 18864 THEN 1 ELSE 0 END ) AS a_18864,SUM( CASE WHEN skuId = 18789 THEN 1 ELSE 0 END ) AS a_18789,SUM( CASE WHEN skuId = 18788 THEN 1 ELSE 0 END ) AS a_18788,SUM( CASE WHEN skuId = 18538 THEN 1 ELSE 0 END ) AS a_18538,SUM( CASE WHEN skuId = 18404 THEN 1 ELSE 0 END ) AS a_18404,SUM( CASE WHEN skuId = 18403 THEN 1 ELSE 0 END ) AS a_18403,SUM( CASE WHEN skuId = 18402 THEN 1 ELSE 0 END ) AS a_18402,SUM( CASE WHEN skuId = 18400 THEN 1 ELSE 0 END ) AS a_18400,SUM( CASE WHEN skuId = 18365 THEN 1 ELSE 0 END ) AS a_18365,SUM( CASE WHEN skuId = 18131 THEN 1 ELSE 0 END ) AS a_18131,SUM( CASE WHEN skuId = 18017 THEN 1 ELSE 0 END ) AS a_18017,SUM( CASE WHEN skuId = 18016 THEN 1 ELSE 0 END ) AS a_18016,SUM( CASE WHEN skuId = 18015 THEN 1 ELSE 0 END ) AS a_18015,SUM( CASE WHEN skuId = 18014 THEN 1 ELSE 0 END ) AS a_18014,SUM( CASE WHEN skuId = 17931 THEN 1 ELSE 0 END ) AS a_17931,SUM( CASE WHEN skuId = 17744 THEN 1 ELSE 0 END ) AS a_17744,SUM( CASE WHEN skuId = 17743 THEN 1 ELSE 0 END ) AS a_17743,SUM( CASE WHEN skuId = 17742 THEN 1 ELSE 0 END ) AS a_17742,SUM( CASE WHEN skuId = 17741 THEN 1 ELSE 0 END ) AS a_17741,SUM( CASE WHEN skuId = 17599 THEN 1 ELSE 0 END ) AS a_17599,SUM( CASE WHEN skuId = 17357 THEN 1 ELSE 0 END ) AS a_17357,SUM( CASE WHEN skuId = 17356 THEN 1 ELSE 0 END ) AS a_17356,SUM( CASE WHEN skuId = 17355 THEN 1 ELSE 0 END ) AS a_17355,SUM( CASE WHEN skuId = 17354 THEN 1 ELSE 0 END ) AS a_17354,SUM( CASE WHEN skuId = 17216 THEN 1 ELSE 0 END ) AS a_17216,SUM( CASE WHEN skuId = 17199 THEN 1 ELSE 0 END ) AS a_17199,SUM( CASE WHEN skuId = 16924 THEN 1 ELSE 0 END ) AS a_16924,SUM( CASE WHEN skuId = 16884 THEN 1 ELSE 0 END ) AS a_16884,SUM( CASE WHEN skuId = 16502 THEN 1 ELSE 0 END ) AS a_16502,SUM( CASE WHEN skuId = 16501 THEN 1 ELSE 0 END ) AS a_16501,SUM( CASE WHEN skuId = 16500 THEN 1 ELSE 0 END ) AS a_16500,SUM( CASE WHEN skuId = 16499 THEN 1 ELSE 0 END ) AS a_16499,SUM( CASE WHEN skuId = 16451 THEN 1 ELSE 0 END ) AS a_16451,SUM( CASE WHEN skuId = 16450 THEN 1 ELSE 0 END ) AS a_16450,SUM( CASE WHEN skuId = 16449 THEN 1 ELSE 0 END ) AS a_16449,SUM( CASE WHEN skuId = 16448 THEN 1 ELSE 0 END ) AS a_16448,SUM( CASE WHEN skuId = 16100 THEN 1 ELSE 0 END ) AS a_16100,SUM( CASE WHEN skuId = 16099 THEN 1 ELSE 0 END ) AS a_16099,SUM( CASE WHEN skuId = 15879 THEN 1 ELSE 0 END ) AS a_15879,SUM( CASE WHEN skuId = 15733 THEN 1 ELSE 0 END ) AS a_15733,SUM( CASE WHEN skuId = 15732 THEN 1 ELSE 0 END ) AS a_15732,SUM( CASE WHEN skuId = 15731 THEN 1 ELSE 0 END ) AS a_15731,SUM( CASE WHEN skuId = 15730 THEN 1 ELSE 0 END ) AS a_15730,SUM( CASE WHEN skuId = 15594 THEN 1 ELSE 0 END ) AS a_15594,SUM( CASE WHEN skuId = 15361 THEN 1 ELSE 0 END ) AS a_15361,SUM( CASE WHEN skuId = 15141 THEN 1 ELSE 0 END ) AS a_15141,SUM( CASE WHEN skuId = 15110 THEN 1 ELSE 0 END ) AS a_15110,SUM( CASE WHEN skuId = 15040 THEN 1 ELSE 0 END ) AS a_15040,SUM( CASE WHEN skuId = 14965 THEN 1 ELSE 0 END ) AS a_14965,SUM( CASE WHEN skuId = 14873 THEN 1 ELSE 0 END ) AS a_14873,SUM( CASE WHEN skuId = 14872 THEN 1 ELSE 0 END ) AS a_14872,SUM( CASE WHEN skuId = 14871 THEN 1 ELSE 0 END ) AS a_14871,SUM( CASE WHEN skuId = 14870 THEN 1 ELSE 0 END ) AS a_14870,SUM( CASE WHEN skuId = 14670 THEN 1 ELSE 0 END ) AS a_14670,SUM( CASE WHEN skuId = 14668 THEN 1 ELSE 0 END ) AS a_14668,SUM( CASE WHEN skuId = 14667 THEN 1 ELSE 0 END ) AS a_14667,SUM( CASE WHEN skuId = 14666 THEN 1 ELSE 0 END ) AS a_14666,SUM( CASE WHEN skuId = 14665 THEN 1 ELSE 0 END ) AS a_14665,SUM( CASE WHEN skuId = 14664 THEN 1 ELSE 0 END ) AS a_14664,SUM( CASE WHEN skuId = 14568 THEN 1 ELSE 0 END ) AS a_14568,SUM( CASE WHEN skuId = 14517 THEN 1 ELSE 0 END ) AS a_14517,SUM( CASE WHEN skuId = 14253 THEN 1 ELSE 0 END ) AS a_14253,SUM( CASE WHEN skuId = 14252 THEN 1 ELSE 0 END ) AS a_14252,SUM( CASE WHEN skuId = 14251 THEN 1 ELSE 0 END ) AS a_14251,SUM( CASE WHEN skuId = 14250 THEN 1 ELSE 0 END ) AS a_14250,SUM( CASE WHEN skuId = 14249 THEN 1 ELSE 0 END ) AS a_14249,SUM( CASE WHEN skuId = 14248 THEN 1 ELSE 0 END ) AS a_14248,SUM( CASE WHEN skuId = 14247 THEN 1 ELSE 0 END ) AS a_14247,SUM( CASE WHEN skuId = 14145 THEN 1 ELSE 0 END ) AS a_14145,SUM( CASE WHEN skuId = 14115 THEN 1 ELSE 0 END ) AS a_14115,SUM( CASE WHEN skuId = 14113 THEN 1 ELSE 0 END ) AS a_14113,SUM( CASE WHEN skuId = 14099 THEN 1 ELSE 0 END ) AS a_14099,SUM( CASE WHEN skuId = 13983 THEN 1 ELSE 0 END ) AS a_13983,SUM( CASE WHEN skuId = 13980 THEN 1 ELSE 0 END ) AS a_13980,SUM( CASE WHEN skuId = 13916 THEN 1 ELSE 0 END ) AS a_13916,SUM( CASE WHEN skuId = 13915 THEN 1 ELSE 0 END ) AS a_13915,SUM( CASE WHEN skuId = 13914 THEN 1 ELSE 0 END ) AS a_13914,SUM( CASE WHEN skuId = 13913 THEN 1 ELSE 0 END ) AS a_13913,SUM( CASE WHEN skuId = 13912 THEN 1 ELSE 0 END ) AS a_13912,SUM( CASE WHEN skuId = 13857 THEN 1 ELSE 0 END ) AS a_13857,SUM( CASE WHEN skuId = 13856 THEN 1 ELSE 0 END ) AS a_13856,SUM( CASE WHEN skuId = 13855 THEN 1 ELSE 0 END ) AS a_13855,SUM( CASE WHEN skuId = 13853 THEN 1 ELSE 0 END ) AS a_13853,SUM( CASE WHEN skuId = 13835 THEN 1 ELSE 0 END ) AS a_13835,SUM( CASE WHEN skuId = 13763 THEN 1 ELSE 0 END ) AS a_13763,SUM( CASE WHEN skuId = 13762 THEN 1 ELSE 0 END ) AS a_13762,SUM( CASE WHEN skuId = 13761 THEN 1 ELSE 0 END ) AS a_13761,SUM( CASE WHEN skuId = 13760 THEN 1 ELSE 0 END ) AS a_13760,SUM( CASE WHEN skuId = 13626 THEN 1 ELSE 0 END ) AS a_13626,SUM( CASE WHEN skuId = 13624 THEN 1 ELSE 0 END ) AS a_13624,SUM( CASE WHEN skuId = 13623 THEN 1 ELSE 0 END ) AS a_13623,SUM( CASE WHEN skuId = 13622 THEN 1 ELSE 0 END ) AS a_13622,SUM( CASE WHEN skuId = 13608 THEN 1 ELSE 0 END ) AS a_13608,SUM( CASE WHEN skuId = 13527 THEN 1 ELSE 0 END ) AS a_13527,SUM( CASE WHEN skuId = 13483 THEN 1 ELSE 0 END ) AS a_13483,SUM( CASE WHEN skuId = 13454 THEN 1 ELSE 0 END ) AS a_13454,SUM( CASE WHEN skuId = 13381 THEN 1 ELSE 0 END ) AS a_13381,SUM( CASE WHEN skuId = 21802 THEN 1 ELSE 0 END ) AS a_21802,SUM( CASE WHEN skuId = 26331 THEN 1 ELSE 0 END ) AS a_26331,SUM( CASE WHEN skuId = 26332 THEN 1 ELSE 0 END ) AS a_26332,SUM( CASE WHEN skuId = 26333 THEN 1 ELSE 0 END ) AS a_26333 
FROM`eb_nft_user` 
GROUP BY`user_id` 
HAVINGSUM( CASE WHEN skuId = 26330 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 26329 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 26328 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 26327 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 26326 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 26322 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 25182 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 25133 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 24293 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 24288 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 24286 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 24285 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 24261 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 24260 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 23006 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 23005 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 22631 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 22628 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 22317 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 22156 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 22153 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 22152 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 22151 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 21801 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 21481 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 21480 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 21479 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 21478 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 21279 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 20650 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 20649 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 20648 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 20647 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 20509 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 20403 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 20106 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 19882 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 19506 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 19505 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 19437 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 19401 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 19400 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 19399 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 19128 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 18926 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 18925 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 18924 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 18923 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 18864 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 18789 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 18788 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 18538 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 18404 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 18403 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 18402 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 18400 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 18365 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 18131 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 18017 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 18016 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 18015 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 18014 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 17931 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 17744 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 17743 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 17742 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 17741 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 17599 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 17357 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 17356 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 17355 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 17354 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 17216 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 17199 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 16924 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 16884 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 16502 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 16501 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 16500 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 16499 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 16451 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 16450 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 16449 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 16448 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 16100 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 16099 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 15879 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 15733 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 15732 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 15731 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 15730 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 15594 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 15361 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 15141 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 15110 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 15040 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14965 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14873 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14872 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14871 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14870 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14670 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14668 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14667 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14666 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14665 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14664 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14568 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14517 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14253 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14252 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14251 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14250 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14249 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14248 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14247 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14145 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14115 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14113 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 14099 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13983 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13980 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13916 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13915 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13914 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13913 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13912 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13857 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13856 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13855 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13853 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13835 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13763 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13762 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13761 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13760 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13626 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13624 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13623 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13622 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13608 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13527 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13483 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13454 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 13381 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 21802 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 26331 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 26332 THEN 1 ELSE 0 END ) >= 1 AND SUM( CASE WHEN skuId = 26333 THEN 1 ELSE 0 END ) >=1

索引也都正常添加 命中率也是 100%

业务复杂度相当于 n(用户) * skuid * num(数量) n的3次方
在这里插入图片描述
想到可以利用视图 将复杂度降低 n(用户) * skuid

CREATETEMPORARY TABLE temp_sku_counts AS
SELECT user_id,skuId,COUNT(*) as count
FROM eb_nft_user
GROUP BY user_id, skuId;
#建立复合索引 
CREATE INDEX idx_temp_user_sku ON temp_sku_counts(user_id, skuId);

查询的时候直接查询视图

SELECTuser_id,SUM(IF( skuId = 26330, count, 0 )) AS a_26330,SUM(IF( skuId = 26329, count, 0 )) AS a_26329,SUM(IF( skuId = 26328, count, 0 )) AS a_26328,SUM(IF( skuId = 26327, count, 0 )) AS a_26327,SUM(IF( skuId = 26326, count, 0 )) AS a_26326,SUM(IF( skuId = 26322, count, 0 )) AS a_26322,SUM(IF( skuId = 25182, count, 0 )) AS a_25182,SUM(IF( skuId = 25133, count, 0 )) AS a_25133,SUM(IF( skuId = 24293, count, 0 )) AS a_24293,SUM(IF( skuId = 24288, count, 0 )) AS a_24288,SUM(IF( skuId = 24286, count, 0 )) AS a_24286,SUM(IF( skuId = 24285, count, 0 )) AS a_24285,SUM(IF( skuId = 24261, count, 0 )) AS a_24261,SUM(IF( skuId = 24260, count, 0 )) AS a_24260,SUM(IF( skuId = 23006, count, 0 )) AS a_23006,SUM(IF( skuId = 23005, count, 0 )) AS a_23005,SUM(IF( skuId = 22631, count, 0 )) AS a_22631,SUM(IF( skuId = 22628, count, 0 )) AS a_22628,SUM(IF( skuId = 22317, count, 0 )) AS a_22317,SUM(IF( skuId = 22156, count, 0 )) AS a_22156,SUM(IF( skuId = 22153, count, 0 )) AS a_22153,SUM(IF( skuId = 22152, count, 0 )) AS a_22152,SUM(IF( skuId = 22151, count, 0 )) AS a_22151,SUM(IF( skuId = 21801, count, 0 )) AS a_21801,SUM(IF( skuId = 21481, count, 0 )) AS a_21481,SUM(IF( skuId = 21480, count, 0 )) AS a_21480,SUM(IF( skuId = 21479, count, 0 )) AS a_21479,SUM(IF( skuId = 21478, count, 0 )) AS a_21478,SUM(IF( skuId = 21279, count, 0 )) AS a_21279,SUM(IF( skuId = 20650, count, 0 )) AS a_20650,SUM(IF( skuId = 20649, count, 0 )) AS a_20649,SUM(IF( skuId = 20648, count, 0 )) AS a_20648,SUM(IF( skuId = 20647, count, 0 )) AS a_20647,SUM(IF( skuId = 20509, count, 0 )) AS a_20509,SUM(IF( skuId = 20403, count, 0 )) AS a_20403,SUM(IF( skuId = 20106, count, 0 )) AS a_20106,SUM(IF( skuId = 19882, count, 0 )) AS a_19882,SUM(IF( skuId = 19506, count, 0 )) AS a_19506,SUM(IF( skuId = 19505, count, 0 )) AS a_19505,SUM(IF( skuId = 19437, count, 0 )) AS a_19437,SUM(IF( skuId = 19401, count, 0 )) AS a_19401,SUM(IF( skuId = 19400, count, 0 )) AS a_19400,SUM(IF( skuId = 19399, count, 0 )) AS a_19399,SUM(IF( skuId = 19128, count, 0 )) AS a_19128,SUM(IF( skuId = 18926, count, 0 )) AS a_18926,SUM(IF( skuId = 18925, count, 0 )) AS a_18925,SUM(IF( skuId = 18924, count, 0 )) AS a_18924,SUM(IF( skuId = 18923, count, 0 )) AS a_18923,SUM(IF( skuId = 18864, count, 0 )) AS a_18864,SUM(IF( skuId = 18789, count, 0 )) AS a_18789,SUM(IF( skuId = 18788, count, 0 )) AS a_18788,SUM(IF( skuId = 18538, count, 0 )) AS a_18538,SUM(IF( skuId = 18404, count, 0 )) AS a_18404,SUM(IF( skuId = 18403, count, 0 )) AS a_18403,SUM(IF( skuId = 18402, count, 0 )) AS a_18402,SUM(IF( skuId = 18400, count, 0 )) AS a_18400,SUM(IF( skuId = 18365, count, 0 )) AS a_18365,SUM(IF( skuId = 18131, count, 0 )) AS a_18131,SUM(IF( skuId = 18017, count, 0 )) AS a_18017,SUM(IF( skuId = 18016, count, 0 )) AS a_18016,SUM(IF( skuId = 18015, count, 0 )) AS a_18015,SUM(IF( skuId = 18014, count, 0 )) AS a_18014,SUM(IF( skuId = 17931, count, 0 )) AS a_17931,SUM(IF( skuId = 17744, count, 0 )) AS a_17744,SUM(IF( skuId = 17743, count, 0 )) AS a_17743,SUM(IF( skuId = 17742, count, 0 )) AS a_17742,SUM(IF( skuId = 17741, count, 0 )) AS a_17741,SUM(IF( skuId = 17599, count, 0 )) AS a_17599,SUM(IF( skuId = 17357, count, 0 )) AS a_17357,SUM(IF( skuId = 17356, count, 0 )) AS a_17356,SUM(IF( skuId = 17355, count, 0 )) AS a_17355,SUM(IF( skuId = 17354, count, 0 )) AS a_17354,SUM(IF( skuId = 17216, count, 0 )) AS a_17216,SUM(IF( skuId = 17199, count, 0 )) AS a_17199,SUM(IF( skuId = 16924, count, 0 )) AS a_16924,SUM(IF( skuId = 16884, count, 0 )) AS a_16884,SUM(IF( skuId = 16502, count, 0 )) AS a_16502,SUM(IF( skuId = 16501, count, 0 )) AS a_16501,SUM(IF( skuId = 16500, count, 0 )) AS a_16500,SUM(IF( skuId = 16499, count, 0 )) AS a_16499,SUM(IF( skuId = 16451, count, 0 )) AS a_16451,SUM(IF( skuId = 16450, count, 0 )) AS a_16450,SUM(IF( skuId = 16449, count, 0 )) AS a_16449,SUM(IF( skuId = 16448, count, 0 )) AS a_16448,SUM(IF( skuId = 16100, count, 0 )) AS a_16100,SUM(IF( skuId = 16099, count, 0 )) AS a_16099,SUM(IF( skuId = 15879, count, 0 )) AS a_15879,SUM(IF( skuId = 15733, count, 0 )) AS a_15733,SUM(IF( skuId = 15732, count, 0 )) AS a_15732,SUM(IF( skuId = 15731, count, 0 )) AS a_15731,SUM(IF( skuId = 15730, count, 0 )) AS a_15730,SUM(IF( skuId = 15594, count, 0 )) AS a_15594,SUM(IF( skuId = 15361, count, 0 )) AS a_15361,SUM(IF( skuId = 15141, count, 0 )) AS a_15141,SUM(IF( skuId = 15110, count, 0 )) AS a_15110,SUM(IF( skuId = 15040, count, 0 )) AS a_15040,SUM(IF( skuId = 14965, count, 0 )) AS a_14965,SUM(IF( skuId = 14873, count, 0 )) AS a_14873,SUM(IF( skuId = 14872, count, 0 )) AS a_14872,SUM(IF( skuId = 14871, count, 0 )) AS a_14871,SUM(IF( skuId = 14870, count, 0 )) AS a_14870,SUM(IF( skuId = 14670, count, 0 )) AS a_14670,SUM(IF( skuId = 14668, count, 0 )) AS a_14668,SUM(IF( skuId = 14667, count, 0 )) AS a_14667,SUM(IF( skuId = 14666, count, 0 )) AS a_14666,SUM(IF( skuId = 14665, count, 0 )) AS a_14665,SUM(IF( skuId = 14664, count, 0 )) AS a_14664,SUM(IF( skuId = 14568, count, 0 )) AS a_14568,SUM(IF( skuId = 14517, count, 0 )) AS a_14517,SUM(IF( skuId = 14253, count, 0 )) AS a_14253,SUM(IF( skuId = 14252, count, 0 )) AS a_14252,SUM(IF( skuId = 14251, count, 0 )) AS a_14251,SUM(IF( skuId = 14250, count, 0 )) AS a_14250,SUM(IF( skuId = 14249, count, 0 )) AS a_14249,SUM(IF( skuId = 14248, count, 0 )) AS a_14248,SUM(IF( skuId = 14247, count, 0 )) AS a_14247,SUM(IF( skuId = 14145, count, 0 )) AS a_14145,SUM(IF( skuId = 14115, count, 0 )) AS a_14115,SUM(IF( skuId = 14113, count, 0 )) AS a_14113,SUM(IF( skuId = 14099, count, 0 )) AS a_14099,SUM(IF( skuId = 13983, count, 0 )) AS a_13983,SUM(IF( skuId = 13980, count, 0 )) AS a_13980,SUM(IF( skuId = 13916, count, 0 )) AS a_13916,SUM(IF( skuId = 13915, count, 0 )) AS a_13915,SUM(IF( skuId = 13914, count, 0 )) AS a_13914,SUM(IF( skuId = 13913, count, 0 )) AS a_13913,SUM(IF( skuId = 13912, count, 0 )) AS a_13912,SUM(IF( skuId = 13857, count, 0 )) AS a_13857,SUM(IF( skuId = 13856, count, 0 )) AS a_13856,SUM(IF( skuId = 13855, count, 0 )) AS a_13855,SUM(IF( skuId = 13853, count, 0 )) AS a_13853,SUM(IF( skuId = 13835, count, 0 )) AS a_13835,SUM(IF( skuId = 13763, count, 0 )) AS a_13763,SUM(IF( skuId = 13762, count, 0 )) AS a_13762,SUM(IF( skuId = 13761, count, 0 )) AS a_13761,SUM(IF( skuId = 13760, count, 0 )) AS a_13760,SUM(IF( skuId = 13626, count, 0 )) AS a_13626,SUM(IF( skuId = 13624, count, 0 )) AS a_13624,SUM(IF( skuId = 13623, count, 0 )) AS a_13623,SUM(IF( skuId = 13622, count, 0 )) AS a_13622,SUM(IF( skuId = 13608, count, 0 )) AS a_13608,SUM(IF( skuId = 13527, count, 0 )) AS a_13527,SUM(IF( skuId = 13483, count, 0 )) AS a_13483,SUM(IF( skuId = 13454, count, 0 )) AS a_13454,SUM(IF( skuId = 13381, count, 0 )) AS a_13381,SUM(IF( skuId = 21802, count, 0 )) AS a_21802,SUM(IF( skuId = 26331, count, 0 )) AS a_26331,SUM(IF( skuId = 26332, count, 0 )) AS a_26332,SUM(IF( skuId = 26333, count, 0 )) AS a_26333 
FROMeb_temp_sku_counts 
GROUP BYuser_id 
HAVINGa_26330 >= 1 AND a_26329 >= 1 AND a_26328 >= 1 AND a_26327 >= 1 AND a_26326 >= 1 AND a_26322 >= 1 AND a_25182 >= 1 AND a_25133 >= 1 AND a_24293 >= 1 AND a_24288 >= 1 AND a_24286 >= 1 AND a_24285 >= 1 AND a_24261 >= 1 AND a_24260 >= 1 AND a_23006 >= 1 AND a_23005 >= 1 AND a_22631 >= 1 AND a_22628 >= 1 AND a_22317 >= 1 AND a_22156 >= 1 AND a_22153 >= 1 AND a_22152 >= 1 AND a_22151 >= 1 AND a_21801 >= 1 AND a_21481 >= 1 AND a_21480 >= 1 AND a_21479 >= 1 AND a_21478 >= 1 AND a_21279 >= 1 AND a_20650 >= 1 AND a_20649 >= 1 AND a_20648 >= 1 AND a_20647 >= 1 AND a_20509 >= 1 AND a_20403 >= 1 AND a_20106 >= 1 AND a_19882 >= 1 AND a_19506 >= 1 AND a_19505 >= 1 AND a_19437 >= 1 AND a_19401 >= 1 AND a_19400 >= 1 AND a_19399 >= 1 AND a_19128 >= 1 AND a_18926 >= 1 AND a_18925 >= 1 AND a_18924 >= 1 AND a_18923 >= 1 AND a_18864 >= 1 AND a_18789 >= 1 AND a_18788 >= 1 AND a_18538 >= 1 AND a_18404 >= 1 AND a_18403 >= 1 AND a_18402 >= 1 AND a_18400 >= 1 AND a_18365 >= 1 AND a_18131 >= 1 AND a_18017 >= 1 AND a_18016 >= 1 AND a_18015 >= 1 AND a_18014 >= 1 AND a_17931 >= 1 AND a_17744 >= 1 AND a_17743 >= 1 AND a_17742 >= 1 AND a_17741 >= 1 AND a_17599 >= 1 AND a_17357 >= 1 AND a_17356 >= 1 AND a_17355 >= 1 AND a_17354 >= 1 AND a_17216 >= 1 AND a_17199 >= 1 AND a_16924 >= 1 AND a_16884 >= 1 AND a_16502 >= 1 AND a_16501 >= 1 AND a_16500 >= 1 AND a_16499 >= 1 AND a_16451 >= 1 AND a_16450 >= 1 AND a_16449 >= 1 AND a_16448 >= 1 AND a_16100 >= 1 AND a_16099 >= 1 AND a_15879 >= 1 AND a_15733 >= 1 AND a_15732 >= 1 AND a_15731 >= 1 AND a_15730 >= 1 AND a_15594 >= 1 AND a_15361 >= 1 AND a_15141 >= 1 AND a_15110 >= 1 AND a_15040 >= 1 AND a_14965 >= 1 AND a_14873 >= 1 AND a_14872 >= 1 AND a_14871 >= 1 AND a_14870 >= 1 AND a_14670 >= 1 AND a_14668 >= 1 AND a_14667 >= 1 AND a_14666 >= 1 AND a_14665 >= 1 AND a_14664 >= 1 AND a_14568 >= 1 AND a_14517 >= 1 AND a_14253 >= 1 AND a_14252 >= 1 AND a_14251 >= 1 AND a_14250 >= 1 AND a_14249 >= 1 AND a_14248 >= 1 AND a_14247 >= 1 AND a_14145 >= 1 AND a_14115 >= 1 AND a_14113 >= 1 AND a_14099 >= 1 AND a_13983 >= 1 AND a_13980 >= 1 AND a_13916 >= 1 AND a_13915 >= 1 AND a_13914 >= 1 AND a_13913 >= 1 AND a_13912 >= 1 AND a_13857 >= 1 AND a_13856 >= 1 AND a_13855 >= 1 AND a_13853 >= 1 AND a_13835 >= 1 AND a_13763 >= 1 AND a_13762 >= 1 AND a_13761 >= 1 AND a_13760 >= 1 AND a_13626 >= 1 AND a_13624 >= 1 AND a_13623 >= 1 AND a_13622 >= 1 AND a_13608 >= 1 AND a_13527 >= 1 AND a_13483 >= 1 AND a_13454 >= 1 AND a_13381 >= 1 AND a_21802 >= 1 AND a_26331 >= 1 AND a_26332 >= 1 AND a_26333 >= 1

在这里插入图片描述
查询时间快了 五秒左右 勉强还能接受


http://www.hkcw.cn/article/QcslVRugHT.shtml

相关文章

快递物流查询接口如何用C#进行调用？

快递物流查询接口如何用C#进行调用？

一、什么是快递物流查询接口 支持国内外1500快递公司跟踪服务，包括顺丰、圆通、韵达等主流快递公司。快递物流查询接口为连接电商平台、物流企业与终端用户之间的桥梁，正在发挥着不可替代的作用。它不仅帮助用户实时掌握包裹动态，也为物流企…
阅读更多...
【C语言】函数指针及其应用

【C语言】函数指针及其应用

目录 1.1 函数指针的概念和应用 1.2 赋值与内存模型 1.3 调用方式与注意事项 二、函数指针的使用 2.1 函数指针的定义和访问 2.2 动态调度：用户输入驱动函数执行 2.3 函数指针数组进阶应用 2.4 函数作为参数的高阶抽象 三、回调函数 3.1 指针函数…
阅读更多...
第十三章：预处理

第十三章：预处理

预处理功能是C语言特有的功能，可以使用预处理和具有预处理的功能是C 语言和其他高级语言的区别之一。预处理程序包含许多有用的功能，如宏定义、条件编译等，使用预处理功能便于程序的修改、阅读、移植和调试，也便于实现模块化程序设计。 通过本章的学习，您可以： 1、掌握…
阅读更多...
9.4 Q1|复旦大学CHARLS发文 | 老年人肌肉减少症和轻度认知障碍

9.4 Q1|复旦大学CHARLS发文 | 老年人肌肉减少症和轻度认知障碍

1.第一段-文章基本信息 文章题目：Sarcopenia and mild cognitive impairment among elderly adults: The first longitudinal evidence from CHARLS 中文标题：老年人肌肉减少症和轻度认知障碍：来自CHARLS 的第一个纵向证据 发表杂志&#x…
阅读更多...
python h5py 读取mat文件的＜HDF5 object reference＞ 问题

python h5py 读取mat文件的＜HDF5 object reference＞ 问题

我用python加载matlab的mat文件 mat文件： 加载方式： mat_file h5py.File(base_dir str(N) _nodes_dataset_snr- str(snr) _M_ str(M) .mat, r) Signals mat_file["Signals"][()] Tp mat_file["Tp"][()] Tp_list mat_fil…
阅读更多...
【数据结构】图论核心算法解析：深度优先搜索（DFS）的纵深遍历与生成树实战指南​

【数据结构】图论核心算法解析：深度优先搜索（DFS）的纵深遍历与生成树实战指南​

深度优先搜索 导读：从广度到深度，探索图的遍历奥秘一、深度优先搜索二、算法思路三、算法逻辑四、算法评价五、深度优先生成树六、有向图与无向图结语：深潜与回溯，揭开图论世界的另一面 导读：从广度到深度，…
阅读更多...
扫地机产品异物进入吸尘口堵塞异常检测方案

扫地机产品异物进入吸尘口堵塞异常检测方案

扫地机产品异物进入吸尘口堵塞异常的检测方案 文章目录 扫地机产品异物进入吸尘口堵塞异常的检测方案一.背景二.石头的音频异常检测的方案2.1 音频检测触发点2.1.1时间周期2.1.2根据清洁机器人清扫模式或清扫区域污渍类型，即当清扫模式为深度清洁模式 或清扫区域污渍类型为重度…
阅读更多...
【Mini-F5265-OB开发板试用测评】RT-Thread的移植（调通串口+LED）

【Mini-F5265-OB开发板试用测评】RT-Thread的移植（调通串口+LED）

前言 近期，笔者有幸获得灵动微MM32F5265开发板的体验资格。MM32F5260搭载了arm china "Star-MC1 内核"处理器，拥有高性能，主打家电和工业等高可靠性应用领域。 总结一下，有以下亮点： 本土团队打造&#x…
阅读更多...
MySQL8.4组复制

MySQL8.4组复制

https://dev.mysql.com/doc/refman/8.4/en/group-replication.html 1 什么是组复制 组复制主要解决了传统异步复制主机宕机时可能造成主从节点数据不一致问题MySQL Group Replication，简称MGR将原有的gtid复制功能进行可增强，支持单主模式和多主模式组复…
阅读更多...
【笔记】Trae+Andrioid Studio+Kotlin开发安卓WebView应用

【笔记】Trae+Andrioid Studio+Kotlin开发安卓WebView应用

文章目录 简介依赖步骤AS(Andriod Studio)创建项目AS创建虚拟机TRAE CN 修改项目新增按键捕获功能 新增WebViewWebView加载本地资源在按键回调中向WebView注入JS代码 最终关键代码吐槽 简介 使用Trae配合Andriod Studio开发一个内嵌WebView的安卓应用, 在WebView中加载本地资源…
阅读更多...
kibana解析Excel文件，生成mapping es导入Excel

kibana解析Excel文件，生成mapping es导入Excel

一、Excel转为CSV格式 在线免费网站：EXCEL转CSV - 免费在线将EXCEL文件转换成CSV (cdkm.com) 二、登录kibana 点击左边菜单栏找到Machine Learning， 进入后上面菜单选择Data Visualizer，然后上穿转好的csv格式的Excel 点击导入输入建立的m…
阅读更多...
4d毫米波雷达开源算法4DRadarSLAM运行

4d毫米波雷达开源算法4DRadarSLAM运行

1.开源代码和论文 （1）论文名称： 4DRadarSLAM: A 4D Imaging Radar SLAM System for Large-scale Environments based on Pose Graph Optimization （2）开源代码国内下载地址 https://gitcode.com/gh_mirrors/4d/4DRada…
阅读更多...
安卓手机照片在这个目录/storage/emulated/999/DCIM/Camera下的导出解决方案

安卓手机照片在这个目录/storage/emulated/999/DCIM/Camera下的导出解决方案

这里写自定义目录标题 背景解决方案导出过程 导出的成功照片展示 背景 想导出手机的相册照片,发现部分照片无法导出 ，原因是在文件管理根本找不到这个目录/storage/emulated/999/DCIM/ 。 照片位置截图： 对应的安卓手机的文件管理截图如下 发现没有…
阅读更多...
C++进阶--C++11（04）

C++进阶--C++11（04）

文章目录 C进阶--C11（04）lambdalambda表达式语法捕捉列表lambda的应用lambda的原理 包装器functionbind 总结结语 很高兴和大家见面，给生活加点impetus！！开启今天的编程之路！！ 今天我们进一步c…
阅读更多...
动态设置微信小程序页面标题（navigationBarTitleText属性）

动态设置微信小程序页面标题（navigationBarTitleText属性）

前言： 最近在公司进行小程序研发的时候，产品给出了一个动态加载页面标题的需求，经过调研之后将结果在这里与各位伙伴进行分享。 代码展示： 在.json文件中进行初始配置： { "usingComponents": {}, &q…
阅读更多...
PostgreSQL数据库配置SSL操作说明书

PostgreSQL数据库配置SSL操作说明书

背景： 因为postgresql或者mysql目前通过docker安装，只需要输入主机IP、用户名、密码即可访问成功，这样其实是不安全的，可能会通过一些手段获取到用户名密码导致数据被窃取。而ES、kafka等也是通过用户名/密码方式连接，…
阅读更多...
基于python 将图像上同一行距离相近的矩形框融合

基于python 将图像上同一行距离相近的矩形框融合

import os import cv2 import numpy as npdef get_files(path):""" 获取指定路径下所有文件名称 """files []for filename in os.listdir(path):if os.path.isfile(os.path.join(path, filename)):files.append(filename)return filesdef split…
阅读更多...
拉取gitlab项目

拉取gitlab项目

一、下载nvm管理node 先下载配置好nvm,再用nvm下载node 下载链接：开始 下载nvm - nvm中文官网 情况：npm i 下载依赖缓慢，可能是node版本不对，可能node版本太高 可能得问题：使用nvm 下载低版本的node时，…
阅读更多...
Opencv4 c++ 自用笔记 01 Mat类

Opencv4 c++ 自用笔记 01 Mat类

Mat类 Mat类用来保存矩阵类型的数据，包括向量、矩阵、灰度、通道数。主要分为两部分，矩阵头和矩阵指针。 （单通道为灰度图像，3通道或4通道为彩色图像） 矩阵头中包含矩阵形状、存储方法、地址、引用次数等。矩阵指针…
阅读更多...
Linux `|` 管道符与 `grep` 命令深度解析与高阶应用指南

Linux `|` 管道符与 `grep` 命令深度解析与高阶应用指南

Linux `|` 管道符与 `grep` 命令深度解析与高阶应用指南 一、核心机制深度解析1. 管道符 `|` 的底层原理2. grep 的匹配引擎二、高阶组合应用技巧1. 多级过滤管道2. 实时监控与告警3. 结构化数据处理三、企业级应用场景1. 安全审计系统2. 性能监控告警3. 日志关联分析四、性能优…
阅读更多...
推荐文章

Copyright @ 2022~2023