56,677
社区成员
发帖
与我相关
我的任务
分享
SELECT
c.*
FROM
b_car c
WHERE c.enterpriseCode = '20180403001'
AND c.assign = 0
AND c.lastCityId IN ('320000')
AND c.lastCompanyCode IN ('PICC')
AND c.lastEndDate >= '2018-05-17'
AND c.lastEndDate <= '2018-05-31'
ORDER BY c.createDate ASC
LIMIT 0, 1
select c.* from b_car c
force index(b_car_enterpriseAssign)
WHERE c.enterpriseCode = '20180403001'
AND c.assign = 0
AND c.lastCityId IN ('320000')
AND c.lastCompanyCode IN ('PICC')
AND c.lastEndDate >= '2018-05-17'
AND c.lastEndDate <= '2018-05-31'
ORDER BY c.createDate ASC
LIMIT 0, 1