商品基本都是供应链API接口对接过来的,商品但凡多了,前端商品详情加载就慢,有没有比较好的解决方案?
SQL语句 | 表名 | 平均执行耗时(ms) | 耗时比例 | 总执行次数 | 总扫描行数 | 执行次数比例 | 平均扫描行数 |
UPDATE `eb_store_product` SET `is_show`=? WHERE `is_del`=? AND `is_show`=? AND `auto_off_time`<>? AND `auto_off_time`<? | eb_store_product | 361.1976 | 93.71% | 362 | 7788068 | 8.71% | 21514 |
SELECT * FROM `eb_store_product` WHERE `is_presale_product`=? AND `is_del`=? AND (`presale_end_time`<?) AND `presale_status`=? ORDER BY `add_time` DESC | eb_store_product | 109.3151 | 2.82% | 36 | 774666 | 0.87% | 21518.5 |
SELECT COUNT(*) AS think_count FROM `eb_store_product` WHERE `is_presale_product`=? AND `is_del`=? AND (`presale_end_time`<?) AND `presale_status`=? | eb_store_product | 55.7287 | 1.44% | 36 | 774666 | 0.87% | 21518.5 |