[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: select p.seq as plantSeq, p.plantName, p.plantStatus, p.supplyPower, p.weatherCode, p.pmsStatus, p.pcsMaker, p.pcsQuantity, d.seq, d.pcsIdx, d.timetableSeq, d.inputDate, d.inputHour, d.inputMinute, d.chargePower, d.dischargePower, d.pvPower, d.dayPvPower, (p.pcsVolume * p.pcsQuantity) as supplyPcsPower, (p.batteryVolume * p.batteryQuantity) as supplyBatteryPower, d.data1, d.data2, d.data3, d.data4, d.data5, d.data6, d.data7, d.data8, d.data9, d.data10, d.data11, d.data12, d.data13, d.data14, d.data15, d.data16, d.data17, d.data18, d.data19, d.data20, d.data21, d.data22, d.data23, d.data24, d.data25, d.data26, d.data27, d.data28, d.data29, d.data30, d.data31, d.data32, d.data33, d.data34, d.data35, d.data36, d.data51, d.data52, d.data53, d.data54, d.data55, d.data56, d.data57, d.data58, d.data59, d.data60, d.data61, d.data62, d.data63, d.data64, d.data65, d.data66, d.data67, d.data68, d.data69, d.data70, d.createDatetime, d.count, d.max15 from ( select p.seq, p.name as plantName, p.plantStatus, p.supplyPower, p.weatherCode, pm.pmsStatus, pm.pcsMaker, pm.pcsQuantity, pm.pcsVolume, pm.batteryQuantity, pm.batteryVolume from t_plant p, t_pms pm where p.seq = pm.plantSeq and p.plantStatus = ? and pm.pmsStatus = ? ) p left join ( select d.*, d2.count, d2.max15 from t_pmsdata_2025 d, ( select plantSeq, max(seq) as seq, max(timetableSeq) as timetableSeq, count(seq) as count, max(data15) as max15 from t_pmsdata_2025 where inputDate = ? and pcsIdx=? group by plantSeq, pcsIdx ) d2 where d.plantSeq = d2.plantSeq and d.timetableSeq = d2.timetableSeq and d.seq = d2.seq and d.inputDate = ? and d.pcsIdx=? group by d.plantSeq, d.pcsIdx ) d on p.seq = d.plantSeq order by p.seq desc, d.pcsIdx asc 
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 01(String), 01(String), 2025-12-13(String), 0(Integer), 2025-12-13(String), 0(Integer)
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 53
[00:03:05] [DEBUG] controller.MonitoringController - selectPlantPmsDataAvgPcsList : 쿼리조회시간 : 16
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: select p.name as plantName, d.* from t_pmsdata_2025 d, t_plant p where d.plantSeq = p.seq and d.inputDate=? and d.pcsIdx > 0 and ( d.data28 > 0 or d.data29 > 0 or d.data69 > 0 or d.data70 > 0) and d.timetableSeq = (select currSeq from t_sequence where seq=10) order by p.seq asc, d.pcsIdx asc 
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: SELECT R1.* FROM ( select p.name as plantName, d.*, m.pcsMaker as 'plant.pcsMaker', m.batteryMaker as 'plant.batteryMaker', m.msgGroupPcs as 'plant.msgGroupPcs', m.msgGroupBattery as 'plant.msgGroupBattery', m.pcsQuantity as 'plant.pcsQuantity', m.batteryQuantity as 'plant.batteryQuantity' from t_pmsdata_2025 d, t_plant p, t_pms m where p.seq = d.plantSeq and p.seq = m.plantSeq and d.pcsIdx > 0 and (d.data25 > 0 or d.data62 > 0 or d.data63 > 0 or d.data64 > 0 or d.data28 > 0 or d.data29 > 0 or d.data69 > 0 or d.data70 > 0 ) and d.inputDate between ? and ? and p.plantStatus = ? order by d.inputDate desc, d.inputHour desc, d.inputMinute desc, d.plantSeq asc ) R1 LIMIT ?, ? 
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 2025-12-13(String)
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 2025-12-13(String), 2025-12-13(String), 01(String), 0(Integer), 10(Integer)
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 0
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 0
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: SELECT R1.* FROM ( select p.name as plantName, d.*, m.pcsMaker as 'plant.pcsMaker', m.batteryMaker as 'plant.batteryMaker', m.msgGroupPcs as 'plant.msgGroupPcs', m.msgGroupBattery as 'plant.msgGroupBattery', m.pcsQuantity as 'plant.pcsQuantity', m.batteryQuantity as 'plant.batteryQuantity' from t_pmsdata_2025 d, t_plant p, t_pms m where p.seq = d.plantSeq and p.seq = m.plantSeq and d.pcsIdx > 0 and d.data52 <> 0 and d.data53 <> 0 and d.data57 <> 0 and d.data58 <> 0 and ( d.data52 < ? or d.data52 > ? or d.data53 < ? or d.data53 > ? or (d.data54 <> 0 and d.data54 < ? ) or d.data54 > ? or (d.data55 <> 0 and d.data55 < ?) or d.data55 > ? or d.data57 < ? or d.data57 > ? or d.data58 < ? or d.data58 > ? ) and d.pcsIdx = ? and d.inputDate between ? and ? and p.plantStatus = ? order by d.inputDate desc, d.inputHour desc, d.inputMinute desc, d.plantSeq asc ) R1 LIMIT ?, ? 
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 180(Integer), 320(Integer), 180(Integer), 320(Integer), 180(Integer), 320(Integer), 180(Integer), 320(Integer), 30(Integer), 970(Integer), 30(Integer), 970(Integer), 1(Integer), 2025-12-13(String), 2025-12-13(String), 01(String), 0(Integer), 10(Integer)
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 1
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: select c.*, p.name as plantName from t_cs c, t_plant p where c.plantSeq = p.seq and c.procStatus = ? and c.inputDate between ? and ? order by c.inputDate desc, c.seq desc 
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 10(String), 2025-12-06(String), 2025-12-13(String)
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: select p.seq as plantSeq, p.name as plantName, p.weatherCode, p.geox, p.geoy, w.inputYmd, w.inputHour, w.temp, w.humi, w.rain, w.cloud, w.wind from t_plant p left join t_weather_2021 w on w.weatherCode = p.weatherCode and inputYmd= ? and w.inputHour = ( select max(inputHour) from t_weather_2021 where inputYmd=? ) where p.plantStatus='01' order by p.seq desc 
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 2025-12-13(String), 2025-12-13(String)
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 95
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: select * from ( select p.name as plantName, '1' as str1, 'warning' as str2, d.* from t_pmsdata_2025 d, t_plant p where d.plantSeq = p.seq and d.inputDate=? and d.pcsIdx > 0 and ( d.data26 > 0 or d.data66 > 0 or d.data67 > 0 or d.data68 > 0) and d.timetableSeq = (select currSeq from t_sequence where seq=10) union all select p.name as plantName, '2' as str1, 'danger' as str2, d.* from t_pmsdata_2025 d, t_plant p where d.plantSeq = p.seq and d.inputDate=? and d.pcsIdx > 0 and ( d.data25 > 0 or d.data62 > 0 or d.data63 > 0 or d.data64 > 0) and d.timetableSeq = (select currSeq from t_sequence where seq=10) ) d order by d.str1 asc, d.plantSeq asc, d.pcsIdx asc 
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 2025-12-13(String), 2025-12-13(String)
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 17
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 0
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: select c.*, p.name as plantName from t_cs c, t_plant p where c.plantSeq = p.seq and c.procStatus > 10 and c.procStatus < 90 and c.inputDate between ? and ? order by c.inputDate desc, c.seq desc 
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 2025-12-06(String), 2025-12-13(String)
[00:03:05] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 0
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: select p.seq as plantSeq, p.plantName, p.plantStatus, p.supplyPower, p.weatherCode, p.pmsStatus, p.pcsMaker, p.pcsQuantity, d.seq, d.pcsIdx, d.timetableSeq, d.inputDate, d.inputHour, d.inputMinute, d.chargePower, d.dischargePower, d.pvPower, d.dayPvPower, (p.pcsVolume * p.pcsQuantity) as supplyPcsPower, (p.batteryVolume * p.batteryQuantity) as supplyBatteryPower, d.data1, d.data2, d.data3, d.data4, d.data5, d.data6, d.data7, d.data8, d.data9, d.data10, d.data11, d.data12, d.data13, d.data14, d.data15, d.data16, d.data17, d.data18, d.data19, d.data20, d.data21, d.data22, d.data23, d.data24, d.data25, d.data26, d.data27, d.data28, d.data29, d.data30, d.data31, d.data32, d.data33, d.data34, d.data35, d.data36, d.data51, d.data52, d.data53, d.data54, d.data55, d.data56, d.data57, d.data58, d.data59, d.data60, d.data61, d.data62, d.data63, d.data64, d.data65, d.data66, d.data67, d.data68, d.data69, d.data70, d.createDatetime, d.count, d.max15 from ( select p.seq, p.name as plantName, p.plantStatus, p.supplyPower, p.weatherCode, pm.pmsStatus, pm.pcsMaker, pm.pcsQuantity, pm.pcsVolume, pm.batteryQuantity, pm.batteryVolume from t_plant p, t_pms pm where p.seq = pm.plantSeq and p.plantStatus = ? and pm.pmsStatus = ? ) p left join ( select d.*, d2.count, d2.max15 from t_pmsdata_2025 d, ( select plantSeq, max(seq) as seq, max(timetableSeq) as timetableSeq, count(seq) as count, max(data15) as max15 from t_pmsdata_2025 where inputDate = ? and pcsIdx=? group by plantSeq, pcsIdx ) d2 where d.plantSeq = d2.plantSeq and d.timetableSeq = d2.timetableSeq and d.seq = d2.seq and d.inputDate = ? and d.pcsIdx=? group by d.plantSeq, d.pcsIdx ) d on p.seq = d.plantSeq order by p.seq desc, d.pcsIdx asc 
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 01(String), 01(String), 2025-12-13(String), 0(Integer), 2025-12-13(String), 0(Integer)
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 53
[00:13:05] [DEBUG] controller.MonitoringController - selectPlantPmsDataAvgPcsList : 쿼리조회시간 : 16
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: select p.name as plantName, d.* from t_pmsdata_2025 d, t_plant p where d.plantSeq = p.seq and d.inputDate=? and d.pcsIdx > 0 and ( d.data28 > 0 or d.data29 > 0 or d.data69 > 0 or d.data70 > 0) and d.timetableSeq = (select currSeq from t_sequence where seq=10) order by p.seq asc, d.pcsIdx asc 
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: select * from ( select p.name as plantName, '1' as str1, 'warning' as str2, d.* from t_pmsdata_2025 d, t_plant p where d.plantSeq = p.seq and d.inputDate=? and d.pcsIdx > 0 and ( d.data26 > 0 or d.data66 > 0 or d.data67 > 0 or d.data68 > 0) and d.timetableSeq = (select currSeq from t_sequence where seq=10) union all select p.name as plantName, '2' as str1, 'danger' as str2, d.* from t_pmsdata_2025 d, t_plant p where d.plantSeq = p.seq and d.inputDate=? and d.pcsIdx > 0 and ( d.data25 > 0 or d.data62 > 0 or d.data63 > 0 or d.data64 > 0) and d.timetableSeq = (select currSeq from t_sequence where seq=10) ) d order by d.str1 asc, d.plantSeq asc, d.pcsIdx asc 
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 2025-12-13(String)
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 2025-12-13(String), 2025-12-13(String)
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 0
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 0
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: SELECT R1.* FROM ( select p.name as plantName, d.*, m.pcsMaker as 'plant.pcsMaker', m.batteryMaker as 'plant.batteryMaker', m.msgGroupPcs as 'plant.msgGroupPcs', m.msgGroupBattery as 'plant.msgGroupBattery', m.pcsQuantity as 'plant.pcsQuantity', m.batteryQuantity as 'plant.batteryQuantity' from t_pmsdata_2025 d, t_plant p, t_pms m where p.seq = d.plantSeq and p.seq = m.plantSeq and d.pcsIdx > 0 and (d.data25 > 0 or d.data62 > 0 or d.data63 > 0 or d.data64 > 0 or d.data28 > 0 or d.data29 > 0 or d.data69 > 0 or d.data70 > 0 ) and d.inputDate between ? and ? and p.plantStatus = ? order by d.inputDate desc, d.inputHour desc, d.inputMinute desc, d.plantSeq asc ) R1 LIMIT ?, ? 
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 2025-12-13(String), 2025-12-13(String), 01(String), 0(Integer), 10(Integer)
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: select p.seq as plantSeq, p.name as plantName, p.weatherCode, p.geox, p.geoy, w.inputYmd, w.inputHour, w.temp, w.humi, w.rain, w.cloud, w.wind from t_plant p left join t_weather_2021 w on w.weatherCode = p.weatherCode and inputYmd= ? and w.inputHour = ( select max(inputHour) from t_weather_2021 where inputYmd=? ) where p.plantStatus='01' order by p.seq desc 
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 2025-12-13(String), 2025-12-13(String)
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 0
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 95
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: SELECT R1.* FROM ( select p.name as plantName, d.*, m.pcsMaker as 'plant.pcsMaker', m.batteryMaker as 'plant.batteryMaker', m.msgGroupPcs as 'plant.msgGroupPcs', m.msgGroupBattery as 'plant.msgGroupBattery', m.pcsQuantity as 'plant.pcsQuantity', m.batteryQuantity as 'plant.batteryQuantity' from t_pmsdata_2025 d, t_plant p, t_pms m where p.seq = d.plantSeq and p.seq = m.plantSeq and d.pcsIdx > 0 and d.data52 <> 0 and d.data53 <> 0 and d.data57 <> 0 and d.data58 <> 0 and ( d.data52 < ? or d.data52 > ? or d.data53 < ? or d.data53 > ? or (d.data54 <> 0 and d.data54 < ? ) or d.data54 > ? or (d.data55 <> 0 and d.data55 < ?) or d.data55 > ? or d.data57 < ? or d.data57 > ? or d.data58 < ? or d.data58 > ? ) and d.pcsIdx = ? and d.inputDate between ? and ? and p.plantStatus = ? order by d.inputDate desc, d.inputHour desc, d.inputMinute desc, d.plantSeq asc ) R1 LIMIT ?, ? 
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 180(Integer), 320(Integer), 180(Integer), 320(Integer), 180(Integer), 320(Integer), 180(Integer), 320(Integer), 30(Integer), 970(Integer), 30(Integer), 970(Integer), 1(Integer), 2025-12-13(String), 2025-12-13(String), 01(String), 0(Integer), 10(Integer)
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 1
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: select c.*, p.name as plantName from t_cs c, t_plant p where c.plantSeq = p.seq and c.procStatus = ? and c.inputDate between ? and ? order by c.inputDate desc, c.seq desc 
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 10(String), 2025-12-06(String), 2025-12-13(String)
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 17
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: select c.*, p.name as plantName from t_cs c, t_plant p where c.plantSeq = p.seq and c.procStatus > 10 and c.procStatus < 90 and c.inputDate between ? and ? order by c.inputDate desc, c.seq desc 
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 2025-12-06(String), 2025-12-13(String)
[00:13:05] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 0
[00:23:05] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: select p.seq as plantSeq, p.plantName, p.plantStatus, p.supplyPower, p.weatherCode, p.pmsStatus, p.pcsMaker, p.pcsQuantity, d.seq, d.pcsIdx, d.timetableSeq, d.inputDate, d.inputHour, d.inputMinute, d.chargePower, d.dischargePower, d.pvPower, d.dayPvPower, (p.pcsVolume * p.pcsQuantity) as supplyPcsPower, (p.batteryVolume * p.batteryQuantity) as supplyBatteryPower, d.data1, d.data2, d.data3, d.data4, d.data5, d.data6, d.data7, d.data8, d.data9, d.data10, d.data11, d.data12, d.data13, d.data14, d.data15, d.data16, d.data17, d.data18, d.data19, d.data20, d.data21, d.data22, d.data23, d.data24, d.data25, d.data26, d.data27, d.data28, d.data29, d.data30, d.data31, d.data32, d.data33, d.data34, d.data35, d.data36, d.data51, d.data52, d.data53, d.data54, d.data55, d.data56, d.data57, d.data58, d.data59, d.data60, d.data61, d.data62, d.data63, d.data64, d.data65, d.data66, d.data67, d.data68, d.data69, d.data70, d.createDatetime, d.count, d.max15 from ( select p.seq, p.name as plantName, p.plantStatus, p.supplyPower, p.weatherCode, pm.pmsStatus, pm.pcsMaker, pm.pcsQuantity, pm.pcsVolume, pm.batteryQuantity, pm.batteryVolume from t_plant p, t_pms pm where p.seq = pm.plantSeq and p.plantStatus = ? and pm.pmsStatus = ? ) p left join ( select d.*, d2.count, d2.max15 from t_pmsdata_2025 d, ( select plantSeq, max(seq) as seq, max(timetableSeq) as timetableSeq, count(seq) as count, max(data15) as max15 from t_pmsdata_2025 where inputDate = ? and pcsIdx=? group by plantSeq, pcsIdx ) d2 where d.plantSeq = d2.plantSeq and d.timetableSeq = d2.timetableSeq and d.seq = d2.seq and d.inputDate = ? and d.pcsIdx=? group by d.plantSeq, d.pcsIdx ) d on p.seq = d.plantSeq order by p.seq desc, d.pcsIdx asc 
[00:23:05] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 01(String), 01(String), 2025-12-13(String), 0(Integer), 2025-12-13(String), 0(Integer)
[00:23:05] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 53
[00:23:05] [DEBUG] controller.MonitoringController - selectPlantPmsDataAvgPcsList : 쿼리조회시간 : 16
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: select * from ( select p.name as plantName, '1' as str1, 'warning' as str2, d.* from t_pmsdata_2025 d, t_plant p where d.plantSeq = p.seq and d.inputDate=? and d.pcsIdx > 0 and ( d.data26 > 0 or d.data66 > 0 or d.data67 > 0 or d.data68 > 0) and d.timetableSeq = (select currSeq from t_sequence where seq=10) union all select p.name as plantName, '2' as str1, 'danger' as str2, d.* from t_pmsdata_2025 d, t_plant p where d.plantSeq = p.seq and d.inputDate=? and d.pcsIdx > 0 and ( d.data25 > 0 or d.data62 > 0 or d.data63 > 0 or d.data64 > 0) and d.timetableSeq = (select currSeq from t_sequence where seq=10) ) d order by d.str1 asc, d.plantSeq asc, d.pcsIdx asc 
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: select p.name as plantName, d.* from t_pmsdata_2025 d, t_plant p where d.plantSeq = p.seq and d.inputDate=? and d.pcsIdx > 0 and ( d.data28 > 0 or d.data29 > 0 or d.data69 > 0 or d.data70 > 0) and d.timetableSeq = (select currSeq from t_sequence where seq=10) order by p.seq asc, d.pcsIdx asc 
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 2025-12-13(String), 2025-12-13(String)
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 2025-12-13(String)
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 0
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 0
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: SELECT R1.* FROM ( select p.name as plantName, d.*, m.pcsMaker as 'plant.pcsMaker', m.batteryMaker as 'plant.batteryMaker', m.msgGroupPcs as 'plant.msgGroupPcs', m.msgGroupBattery as 'plant.msgGroupBattery', m.pcsQuantity as 'plant.pcsQuantity', m.batteryQuantity as 'plant.batteryQuantity' from t_pmsdata_2025 d, t_plant p, t_pms m where p.seq = d.plantSeq and p.seq = m.plantSeq and d.pcsIdx > 0 and (d.data25 > 0 or d.data62 > 0 or d.data63 > 0 or d.data64 > 0 or d.data28 > 0 or d.data29 > 0 or d.data69 > 0 or d.data70 > 0 ) and d.inputDate between ? and ? and p.plantStatus = ? order by d.inputDate desc, d.inputHour desc, d.inputMinute desc, d.plantSeq asc ) R1 LIMIT ?, ? 
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: select p.seq as plantSeq, p.name as plantName, p.weatherCode, p.geox, p.geoy, w.inputYmd, w.inputHour, w.temp, w.humi, w.rain, w.cloud, w.wind from t_plant p left join t_weather_2021 w on w.weatherCode = p.weatherCode and inputYmd= ? and w.inputHour = ( select max(inputHour) from t_weather_2021 where inputYmd=? ) where p.plantStatus='01' order by p.seq desc 
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 2025-12-13(String), 2025-12-13(String), 01(String), 0(Integer), 10(Integer)
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 2025-12-13(String), 2025-12-13(String)
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 0
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 95
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: SELECT R1.* FROM ( select p.name as plantName, d.*, m.pcsMaker as 'plant.pcsMaker', m.batteryMaker as 'plant.batteryMaker', m.msgGroupPcs as 'plant.msgGroupPcs', m.msgGroupBattery as 'plant.msgGroupBattery', m.pcsQuantity as 'plant.pcsQuantity', m.batteryQuantity as 'plant.batteryQuantity' from t_pmsdata_2025 d, t_plant p, t_pms m where p.seq = d.plantSeq and p.seq = m.plantSeq and d.pcsIdx > 0 and d.data52 <> 0 and d.data53 <> 0 and d.data57 <> 0 and d.data58 <> 0 and ( d.data52 < ? or d.data52 > ? or d.data53 < ? or d.data53 > ? or (d.data54 <> 0 and d.data54 < ? ) or d.data54 > ? or (d.data55 <> 0 and d.data55 < ?) or d.data55 > ? or d.data57 < ? or d.data57 > ? or d.data58 < ? or d.data58 > ? ) and d.pcsIdx = ? and d.inputDate between ? and ? and p.plantStatus = ? order by d.inputDate desc, d.inputHour desc, d.inputMinute desc, d.plantSeq asc ) R1 LIMIT ?, ? 
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 180(Integer), 320(Integer), 180(Integer), 320(Integer), 180(Integer), 320(Integer), 180(Integer), 320(Integer), 30(Integer), 970(Integer), 30(Integer), 970(Integer), 1(Integer), 2025-12-13(String), 2025-12-13(String), 01(String), 0(Integer), 10(Integer)
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 1
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: select c.*, p.name as plantName from t_cs c, t_plant p where c.plantSeq = p.seq and c.procStatus = ? and c.inputDate between ? and ? order by c.inputDate desc, c.seq desc 
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 10(String), 2025-12-06(String), 2025-12-13(String)
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 17
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - ==>  Preparing: select c.*, p.name as plantName from t_cs c, t_plant p where c.plantSeq = p.seq and c.procStatus > 10 and c.procStatus < 90 and c.inputDate between ? and ? order by c.inputDate desc, c.seq desc 
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - ==> Parameters: 2025-12-06(String), 2025-12-13(String)
[00:23:06] [DEBUG] jdbc.BaseJdbcLogger - <==      Total: 0