sql文本:EXPLAIN ANALYZE SELECT
m.,
b.
FROM
PLC_RISKMAINCONFIG m,
PLC_RISKDETAILCOFIG b
WHERE
1 = 1
AND m.id = b.parentId
AND m.coeffCategoryTwoCode = ‘1’
AND m.viewFlag = ‘0’
AND b.intervalBig < ‘1’ AND b.intervalSmall > ‘1’
AND productcode = ‘27010001’