select * from risk_temp_with_old_business_watermelon_score where pici =(
	SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=46559 ORDER BY id desc limit 1
) and user_id=46559



ALTER TABLE `risk_temp_with_old_business_watermelon_score` 
ADD INDEX `index_risk_temp_with_old_business_watermelon_score_user_id`(`user_id`) USING BTREE,
ADD INDEX `index_risk_temp_with_old_business_watermelon_score_userId_pici`(`pici`, `user_id`) USING BTREE;



log 记录 

com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:39:58,342 -- WARN -- 耗时：89 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=47205 ORDER BY id desc limit 1 ) And sysState='true' and user_id=47205 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:40:03,716 -- WARN -- 耗时：82 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=47205 ORDER BY id desc limit 1 ) And sysState='true' and user_id=47205 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:40:13,951 -- WARN -- 耗时：80 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=47205 ORDER BY id desc limit 1 ) And sysState='true' and user_id=47205 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:40:22,474 -- WARN -- 耗时：80 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=47205 ORDER BY id desc limit 1 ) And sysState='true' and user_id=47205 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:41:13,264 -- WARN -- 耗时：121 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=47214 ORDER BY id desc limit 1 ) And sysState='true' and user_id=47214 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:41:18,959 -- WARN -- 耗时：123 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=47214 ORDER BY id desc limit 1 ) And sysState='true' and user_id=47214 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:41:19,535 -- WARN -- 耗时：81 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=17522 ORDER BY id desc limit 1 ) And sysState='true' and user_id=17522 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:41:19,766 -- WARN -- 耗时：83 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=17522 ORDER BY id desc limit 1 ) And sysState='true' and user_id=17522 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:41:20,851 -- WARN -- 耗时：123 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=47214 ORDER BY id desc limit 1 ) And sysState='true' and user_id=47214 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:41:42,411 -- WARN -- 耗时：100 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=37738 ORDER BY id desc limit 1 ) And sysState='true' and user_id=37738 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:42:01,535 -- WARN -- 耗时：121 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=47216 ORDER BY id desc limit 1 ) And sysState='true' and user_id=47216 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:42:08,312 -- WARN -- 耗时：80 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=47112 ORDER BY id desc limit 1 ) And sysState='true' and user_id=47112 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:42:08,959 -- WARN -- 耗时：83 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=47112 ORDER BY id desc limit 1 ) And sysState='true' and user_id=47112 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:42:21,954 -- WARN -- 耗时：100 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=37738 ORDER BY id desc limit 1 ) And sysState='true' and user_id=37738 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:42:26,398 -- WARN -- 耗时：98 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=37738 ORDER BY id desc limit 1 ) And sysState='true' and user_id=37738 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:42:56,972 -- WARN -- 耗时：100 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=37738 ORDER BY id desc limit 1 ) And sysState='true' and user_id=37738 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:42:57,629 -- WARN -- 耗时：120 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=47216 ORDER BY id desc limit 1 ) And sysState='true' and user_id=47216 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:43:46,078 -- WARN -- 耗时：121 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=24284 ORDER BY id desc limit 1 ) And sysState='true' and user_id=24284 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:43:47,295 -- WARN -- 耗时：122 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=24284 ORDER BY id desc limit 1 ) And sysState='true' and user_id=24284 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:43:52,824 -- WARN -- 耗时：3 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=42302 ORDER BY id desc limit 1 ) And sysState='true' and user_id=42302 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:43:56,831 -- WARN -- 耗时：1 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=44671 ORDER BY id desc limit 1 ) And sysState='true' and user_id=44671 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:43:57,122 -- WARN -- 耗时：1 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=44671 ORDER BY id desc limit 1 ) And sysState='true' and user_id=44671 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:44:04,118 -- WARN -- 耗时：1 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=44671 ORDER BY id desc limit 1 ) And sysState='true' and user_id=44671 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:44:05,271 -- WARN -- 耗时：2 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=44671 ORDER BY id desc limit 1 ) And sysState='true' and user_id=44671 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:44:11,508 -- WARN -- 耗时：1 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=47212 ORDER BY id desc limit 1 ) And sysState='true' and user_id=47212 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:44:31,925 -- WARN -- 耗时：2 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=42302 ORDER BY id desc limit 1 ) And sysState='true' and user_id=42302 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:44:40,926 -- WARN -- 耗时：1 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=35003 ORDER BY id desc limit 1 ) And sysState='true' and user_id=35003 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:44:46,456 -- WARN -- 耗时：1 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=42302 ORDER BY id desc limit 1 ) And sysState='true' and user_id=42302 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:45:15,674 -- WARN -- 耗时：2 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=42302 ORDER BY id desc limit 1 ) And sysState='true' and user_id=42302 GROUP BY syncedType
com.fuyin.lima.dao.SqlStatementInterceptor2 2020-11-27 15:45:15,798 -- WARN -- 耗时：2 ms - id:com.example.demo.db.mapper.WykjReportMapper.getLastWatermelonNotifyByUserId - SQL:select * from risk_temp_with_old_business_watermelon_score where pici = ( SELECT pici from risk_temp_with_old_business_watermelon_score where user_id=42302 ORDER BY id desc limit 1 ) And sysState='true' and user_id=42302 GROUP BY syncedType