- 有容乃大2018-04-11论坛元老4171
- 本帖最后由 有容乃大 于 2018-4-11 21:13 编辑 *
Time: 180411 20:46:21
User@Host: dd_27zz_cn[dd_27zz_cn] @ localhost [127.0.0.1]
Query_time: 720.989055 Lock_time: 692.488665 Rows_sent: 0 Rows_examined: 3132523
SET timestamp=1523450781;
SELECT id,itempic,itemfee,itemfee2 FROMims_bsht_tbk_all_itemWHERE status=1 AND istop=1 AND isms!=1 AND uniacid='137' ORDER BY id LIMIT 6;User@Host: dd_27zz_cn[dd_27zz_cn] @ localhost [127.0.0.1]
Query_time: 675.764059 Lock_time: 647.256765 Rows_sent: 0 Rows_examined: 3132523
SET timestamp=1523450781;
SELECT id,itempic,itemfee,itemfee2 FROMims_bsht_tbk_all_itemWHERE status=1 AND istop=1 AND isms!=1 AND uniacid='137' ORDER BY id LIMIT 6;数据库卡死,求大佬看看怎么优化 !索引?