这段代码占用服务器cup过高,请问如何优化?
2016-07-07 15:22 来源:www.chinab4c.com 作者:ecshop专家
Count: 4955Time=0.00s (0s)Lock=0.00s (0s)Rows=2.0 (9910), cntea[cntea]@[1 16.6.76.126] SELECT rank_id, IFNULL(mp.user_price, r.discount * N / N) AS price, r.rank_name, r.discount FROM `cntea`.`ecs_user_rank` AS r LEFT JOIN `cntea`.`ecs_member_pric e` AS mp ON mp.goods_id = 'S' AND mp.user_rank = r.rank_id WHERE r.show_price = N O R r.special_rank = N Count: 4907Time=0.00s (1s)Lock=0.00s (0s)Rows=0.9 (4205), cntea[cntea]@[1 16.6.76.126] SELECT rank_id, IFNULL(mp.user_price, r.discount * N / N) AS price, r.rank_name, r.discount FROM `cntea`.`ecs_user_rank` AS r LEFT JOIN `cntea`.`ecs_member_pric e` AS mp ON mp.goods_id = 'S' AND mp.user_rank = r.rank_id WHERE r.show_price = N O |
回答:
顶顶,求解 |
最近更新
常用插件
- ecshop供应商插件免费下载
ecshop供应商插件免费下载...
- ecshop按分类筛选销售排行
ecshop按分类筛选销售排行...
- ecshop快递发货单打印商品
ecshop快递发货单打印商品信息,大家都知道ecshop快递单打印的时候,只能...
- ecshop选择下单时间插件
ecshop选择下单时间插件主要是根据不同的下单配送要求,在ecshop购物车...
- ecshop二次开发售后维修卡
插件介绍: 本插件是用于专门从事电子,信息,软件等售后服务关键比...
ecshop热门问答
ecshop热门资料
zencart分类树
ecshopgetting
ecshop弹出效果
ecshop老天
ecshop转跳
ecshop1103
ecshopecp
ecshop淘宝网店
ecshopMALLCOOL
ecshop请示
ecshop排行榜
ecshop淘宝数据
ecshopflash
ecshop短信服务
ecshop原意
ecshop公告栏
最土注册功能
ecshop什么时候
ecshopblock
ecshopInternal
ecshop清理
ecshop精神分裂
ecshop订单红包
ecshop訂單管理
ecshop卡巴斯基
ecshop备份失败
ecshop楼层
ecshop快递查询
ecshop没有问题
ecshop形成