求高手指点怎么加索引
111
- 有容乃大2018-06-14论坛元老4171
localhost [127.0.0.1]
Query_time: 3.249581 Lock_time: 0.000032 Rows_sent: 1 Rows_examined: 1
SET timestamp=1528871421;
SELECTcredit1FROMims_mc_membersWHEREuid= '197217' LIMIT 1;Time: 180613 14:34:41
User@Host: dd__cn[dd__cn] @ localhost [127.0.0.1]
Query_time: 10.723859 Lock_time: 0.000046 Rows_sent: 1 Rows_examined: 1036
SET timestamp=1528871681;
SELECT SUM(shouru_yongjin) as sum FROMims_bsht_tbk_orderWHERE uniacid = '221' AND shopid = '1039' AND UNIX_TIMESTAMP(ctime) >= '1528819200' AND UNIX_TIMESTAMP(ctime)