- 论坛徽章:
- 4
|
腐败网 发表于 2012-01-11 13:55 ![]()
回复 22# 小版主杀手
# Query_time: 18.385875 Lock_time: 0.000162 Rows_sent: 20 Rows_examined: 10650
use finerbuy_com;
SET timestamp=1326166655;
SELECT bn,name,cat_id,price,store,marketable,brand_id,weight,d_order,uptime,type_id,supplier_id,goods_id,image_default,thumbnail_pic,brief,pdt_desc,mktprice,big_pic FROM ex_goods WHERE brand_id = 16 AND ex_goods.disabled = 'false' AND ex_goods.marketable='true' AND ex_goods.goods_type='normal' ORDER BY d_order DESC ,p_order DESC LIMIT 0, 20;
explain 这条语句,你用的phpmyadmin吧,会显示一些信息的,然后对照着优化,索引啊、联合啊什么的,你是DBA吗?可以把这些东西给你们开发应用的看看
|
|