商品基本都是供應(yīng)鏈API接口對(duì)接過來的，商品但凡多了，前端商品詳情加載就慢，有沒有比較好的解決方案？
| SQL語句 | 表名 | 平均執(zhí)行耗時(shí)(ms) | 耗時(shí)比例 | 總執(zhí)行次數(shù) | 總掃描行數(shù) | 執(zhí)行次數(shù)比例 | 平均掃描行數(shù) |
| 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 |
