1776320814129|21|statement|connection 0|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320814244|10|statement|connection 1|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320814343|10|statement|connection 2|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320814447|13|statement|connection 3|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320814554|10|statement|connection 4|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320814653|9|statement|connection 5|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320814753|9|statement|connection 6|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320814853|10|statement|connection 7|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320814953|10|statement|connection 8|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320815054|10|statement|connection 9|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320815154|10|statement|connection 10|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320815253|10|statement|connection 11|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320815363|10|statement|connection 12|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320815463|9|statement|connection 13|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320815576|22|statement|connection 14|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320815672|9|statement|connection 15|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320815773|9|statement|connection 16|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320815873|7|statement|connection 17|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320815973|10|statement|connection 18|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320816073|9|statement|connection 19|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320816173|9|statement|connection 20|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320816273|9|statement|connection 21|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320816373|9|statement|connection 22|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320816483|10|statement|connection 23|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320816584|10|statement|connection 24|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320816683|9|statement|connection 25|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320816784|10|statement|connection 26|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320816883|10|statement|connection 27|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320816983|10|statement|connection 28|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320817083|10|statement|connection 29|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320880003|7|statement|connection 29|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT 'x'|SELECT 'x' 1776320880053|21|statement|connection 29|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT COUNT(*) FROM (SELECT a.wind_turbine_number, a.wind_turbine_name, b.brand, b.brand_type, b.function_type_name, b.sort_num, max(a.status_1) AS status FROM WOF043800107_wave a INNER JOIN (SELECT t.brand, t.brand_type, t.detection_point_cn, t.detection_point_en, t.sort_num, SUBSTRING_INDEX(SUBSTRING(t.function_type_name, LOCATE('1_', t.function_type_name) + 2), ',', 1) AS function_type_name FROM detection_point_dic t WHERE t.function_type_name LIKE '%1\\_%') b ON a.mesure_point_name = b.detection_point_en WHERE a.diag_flag = 1 AND a.time_stamp BETWEEN ? AND ? AND a.rotational_speed > 0 AND a.wind_turbine_number = ? GROUP BY a.wind_turbine_number, a.wind_turbine_name, b.brand, b.brand_type, b.function_type_name, b.sort_num) TOTAL|SELECT COUNT(*) FROM (SELECT a.wind_turbine_number, a.wind_turbine_name, b.brand, b.brand_type, b.function_type_name, b.sort_num, max(a.status_1) AS status FROM WOF043800107_wave a INNER JOIN (SELECT t.brand, t.brand_type, t.detection_point_cn, t.detection_point_en, t.sort_num, SUBSTRING_INDEX(SUBSTRING(t.function_type_name, LOCATE('1_', t.function_type_name) + 2), ',', 1) AS function_type_name FROM detection_point_dic t WHERE t.function_type_name LIKE '%1\\_%') b ON a.mesure_point_name = b.detection_point_en WHERE a.diag_flag = 1 AND a.time_stamp BETWEEN '2026-04-04 16:05:25' AND '2026-04-06 16:05:25' AND a.rotational_speed > 0 AND a.wind_turbine_number = 'WOG00228' GROUP BY a.wind_turbine_number, a.wind_turbine_name, b.brand, b.brand_type, b.function_type_name, b.sort_num) TOTAL 1776320880083|14|statement|connection 29|url jdbc:p6spy:mysql://192.168.50.235:30306/energy_data_qianan?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false|SELECT a.wind_turbine_number, a.wind_turbine_name, b.brand, b.brand_type, b.function_type_name, b.sort_num, max(a.status_1) as status FROM WOF043800107_wave a INNER JOIN (SELECT t.brand, t.brand_type, t.detection_point_cn, t.detection_point_en, t.sort_num, SUBSTRING_INDEX( SUBSTRING(t.function_type_name, LOCATE('1_', t.function_type_name) + 2), ',', -- 遇到逗号就停止截取 1 ) AS function_type_name FROM detection_point_dic t WHERE t.function_type_name LIKE '%1\\_%') b ON a.mesure_point_name = b.detection_point_en where a.diag_flag = 1 and a.time_stamp between ? and ? and a.rotational_speed > 0 and a.wind_turbine_number = ? group by a.wind_turbine_number, a.wind_turbine_name, b.brand, b.brand_type, b.function_type_name,b.sort_num order by b.sort_num LIMIT ?|SELECT a.wind_turbine_number, a.wind_turbine_name, b.brand, b.brand_type, b.function_type_name, b.sort_num, max(a.status_1) as status FROM WOF043800107_wave a INNER JOIN (SELECT t.brand, t.brand_type, t.detection_point_cn, t.detection_point_en, t.sort_num, SUBSTRING_INDEX( SUBSTRING(t.function_type_name, LOCATE('1_', t.function_type_name) + 2), ',', -- 遇到逗号就停止截取 1 ) AS function_type_name FROM detection_point_dic t WHERE t.function_type_name LIKE '%1\\_%') b ON a.mesure_point_name = b.detection_point_en where a.diag_flag = 1 and a.time_stamp between '2026-04-04 16:05:25' and '2026-04-06 16:05:25' and a.rotational_speed > 0 and a.wind_turbine_number = 'WOG00228' group by a.wind_turbine_number, a.wind_turbine_name, b.brand, b.brand_type, b.function_type_name,b.sort_num order by b.sort_num LIMIT 10