===================================================================================================== |ID|OPERATOR |NAME |EST. ROWS|COST | ----------------------------------------------------------------------------------------------------- |0 |TEMP TABLE TRANSFORMATION | |8 |2427 | |1 | PX COORDINATOR | |1 |1721 | |2 | EXCHANGE OUT DISTR |:EX10000 |1 |1721 | |3 | TEMP TABLE INSERT |TEMP1 |1 |1721 | |4 | NESTED-LOOP JOIN | |1 |1721 | |5 | PX BLOCK ITERATOR | |38 |1712 | |6 | TABLE SCAN |gj |38 |1712 | |7 | DISTRIBUTED TABLE SCAN |logical_standing_alarm(codeOrName)|1 |28 | |8 | PX COORDINATOR MERGE SORT | |8 |707 | |9 | EXCHANGE OUT DISTR |:EX20013 |8 |691 | |10| SORT | |8 |690 | |11| HASH GROUP BY | |8 |690 | |12| EXCHANGE IN DISTR | |115 |690 | |13| EXCHANGE OUT DISTR (HASH) |:EX20012 |115 |688 | |14| HASH GROUP BY | |115 |683 | |15| SHARED HASH RIGHT OUTER JOIN | |18 |682 | |16| EXCHANGE IN DISTR | |1 |3 | |17| EXCHANGE OUT DISTR (BC2HOST) |:EX20001 |1 |3 | |18| SUBPLAN SCAN |k |1 |3 | |19| HASH GROUP BY | |1 |3 | |20| EXCHANGE IN DISTR | |115 |3 | |21| EXCHANGE OUT DISTR (HASH) |:EX20000 |115 |2 | |22| HASH GROUP BY | |115 |1 | |23| TEMP TABLE ACCESS |VIEW3(TEMP1) |1 |1 | |24| SHARED HASH RIGHT OUTER JOIN | |18 |679 | |25| EXCHANGE IN DISTR | |1 |3 | |26| EXCHANGE OUT DISTR (BC2HOST) |:EX20003 |1 |3 | |27| SUBPLAN SCAN |cd |1 |3 | |28| HASH GROUP BY | |1 |3 | |29| EXCHANGE IN DISTR | |115 |3 | |30| EXCHANGE OUT DISTR (HASH) |:EX20002 |115 |2 | |31| HASH GROUP BY | |115 |1 | |32| TEMP TABLE ACCESS |VIEW2(TEMP1) |1 |1 | |33| SHARED HASH RIGHT OUTER JOIN | |18 |677 | |34| EXCHANGE IN DISTR | |1 |1 | |35| EXCHANGE OUT DISTR (BC2HOST) |:EX20005 |1 |1 | |36| SUBPLAN SCAN |w |1 |1 | |37| HASH GROUP BY | |1 |1 | |38| EXCHANGE IN DISTR | |115 |1 | |39| EXCHANGE OUT DISTR (HASH) |:EX20004 |115 |1 | |40| HASH GROUP BY | |115 |1 | |41| TEMP TABLE ACCESS |VIEW6(TEMP1) |1 |1 | |42| SHARED HASH RIGHT OUTER JOIN | |18 |676 | |43| EXCHANGE IN DISTR | |0 |671 | |44| EXCHANGE OUT DISTR (BC2HOST) |:EX20007 |0 |671 | |45| SUBPLAN SCAN |cp |0 |671 | |46| HASH GROUP BY | |0 |671 | |47| SUBPLAN SCAN |VIEW1 |0 |671 | |48| HASH GROUP BY | |0 |671 | |49| NESTED-LOOP OUTER JOIN | |0 |671 | |50| NESTED-LOOP OUTER JOIN | |0 |671 | |51| MATERIAL | |0 |671 | |52| EXCHANGE IN DISTR | |0 |671 | |53| EXCHANGE OUT DISTR |:EX20006 |0 |671 | |54| PX BLOCK ITERATOR | |0 |671 | |55| TABLE SCAN |gj(eventDay) |0 |671 | |56| PX COORDINATOR | |1 |1 | |57| EXCHANGE OUT DISTR |:EX30000 |1 |1 | |58| PX BLOCK ITERATOR | |1 |1 | |59| TABLE SCAN |logical_standing_alarm(codeOrName)|1 |1 | |60| SUBPLAN SCAN |dc |115 |15999| |61| MERGE GROUP BY | |115 |15999| |62| DISTRIBUTED TABLE SCAN |logical_standing_alarm(gridName) |1256 |15999| |63| SHARED HASH RIGHT OUTER JOIN | |18 |5 | |64| EXCHANGE IN DISTR | |1 |3 | |65| EXCHANGE OUT DISTR (BC2HOST) |:EX20009 |1 |3 | |66| SUBPLAN SCAN |gzscdb |1 |3 | |67| HASH GROUP BY | |1 |3 | |68| EXCHANGE IN DISTR | |115 |3 | |69| EXCHANGE OUT DISTR (HASH) |:EX20008 |115 |2 | |70| HASH GROUP BY | |115 |1 | |71| TEMP TABLE ACCESS |VIEW4(TEMP1) |1 |1 | |72| SHARED HASH RIGHT OUTER JOIN | |18 |3 | |73| EXCHANGE IN DISTR | |0 |2 | |74| EXCHANGE OUT DISTR (BC2HOST) |:EX20011 |0 |2 | |75| NESTED-LOOP OUTER JOIN | |0 |2 | |76| SUBPLAN SCAN |k |0 |2 | |77| HASH GROUP BY | |0 |2 | |78| EXCHANGE IN DISTR | |115 |2 | |79| EXCHANGE OUT DISTR (HASH)|:EX20010 |115 |2 | |80| HASH GROUP BY | |115 |1 | |81| TEMP TABLE ACCESS |VIEW5(TEMP1) |0 |1 | |82| SUBPLAN SCAN |w |115 |16370| |83| MERGE GROUP BY | |115 |16370| |84| DISTRIBUTED TABLE SCAN |logical_standing_alarm(gridName) |4553 |16368| |85| PX BLOCK ITERATOR | |12 |1 | |86| TABLE SCAN |tbl_org(orgname) |12 |1 | ===================================================================================================== Outputs & filters: ------------------------------------- 0 - output([tbl_org.allname], [CASE WHEN (T_OP_IS, CASE WHEN (T_OP_IS_NOT, k.gridName, NULL, 0) THEN round(cast(k.cctfxq4g + k.cctfxq5g, DECIMAL(21, 0)) / cast(w.whxq4g + w.whxq5g, DECIMAL(21, 0)) * cast(100, DECIMAL(3, 0)), 2) ELSE cast(NULL, DECIMAL(27, 2)) END, NULL, 0) OR CASE WHEN (T_OP_IS_NOT, k.gridName, NULL, 0) THEN round(cast(k.cctfxq4g + k.cctfxq5g, DECIMAL(21, 0)) / cast(w.whxq4g + w.whxq5g, DECIMAL(21, 0)) * cast(100, DECIMAL(3, 0)), 2) ELSE cast(NULL, DECIMAL(27, 2)) END = cast('', DECIMAL(1, -1)) THEN cast(0, DECIMAL(1, 0)) ELSE CASE WHEN (T_OP_IS_NOT, k.gridName, NULL, 0) THEN round(cast(k.cctfxq4g + k.cctfxq5g, DECIMAL(21, 0)) / cast(w.whxq4g + w.whxq5g, DECIMAL(21, 0)) * cast(100, DECIMAL(3, 0)), 2) ELSE cast(NULL, DECIMAL(27, 2)) END END], [CASE WHEN (T_OP_IS_NOT, w.gridName, NULL, 0) THEN T_FUN_COUNT_SUM(T_FUN_COUNT(*)) ELSE cast(NULL, BIGINT(20, 0)) END], [cp.cpdzbl], [cd.cdcsbl], [CASE WHEN (T_OP_IS, k.gzhfscdbbl, NULL, 0) THEN round(100.00, 2) ELSE k.gzhfscdbbl END], [gzscdb.pjdzsc]), filter(nil), rowset=256 1 - output(nil), filter(nil), rowset=256 2 - output(nil), filter(nil), rowset=256, dop=115 3 - output(nil), filter(nil), rowset=256 4 - output([gj.dzOrXq], [gj.eventDay], [gj.clearTime], [gj.eventH], [gj.dzMinute], [logical_standing_alarm.isXq], [logical_standing_alarm.gridName], [gj.eventTime], [logical_standing_alarm.standardZsName]), filter(nil), rowset=256, conds(nil), nl_params_([gj.dzOrXq = 0], [gj.eventDay >= 20221125], [gj.dzOrXq = 0], [gj.eventDay >= 20221125], [gj.dzOrXq = 0], [gj.eventH > 5], [gj.eventDay >= 20221125], [(T_OP_IS_NOT, gj.clearTime, NULL, 0) AND gj.dzMinute > 0 OR (T_OP_IS, gj.clearTime, NULL, 0) AND timestampdiff(2, cast(gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))) > 0], [gj.dzOrXq = 0], [gj.eventH > 5], [gj.eventDay >= 20221125], [(T_OP_IS_NOT, gj.clearTime, NULL, 0) AND truncate(cast(timestampdiff(1, cast(gj.eventTime, TIMESTAMP(19, 0)), cast(gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) > cast(1, DECIMAL(1, 0)) OR (T_OP_IS, gj.clearTime, NULL, 0) AND timestampdiff(2, cast(gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))) > 0], [gj.dzOrXq = 1], [timestampdiff(2, cast(gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))) > 2879], [gj.eventDay >= 20221101], [(T_OP_IS, gj.clearTime, NULL, 0)], [gj.codeOrName], [gj.dzOrXq]) 5 - output([gj.dzOrXq], [gj.eventDay], [gj.codeOrName], [gj.clearTime], [gj.eventH], [gj.dzMinute], [gj.eventTime], [gj.dzOrXq = 0], [gj.eventDay >= 20221125], [gj.dzOrXq = 0], [gj.eventDay >= 20221125], [gj.dzOrXq = 0], [gj.eventH > 5], [gj.eventDay >= 20221125], [(T_OP_IS_NOT, gj.clearTime, NULL, 0) AND gj.dzMinute > 0 OR (T_OP_IS, gj.clearTime, NULL, 0) AND timestampdiff(2, cast(gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))) > 0], [gj.dzOrXq = 0], [gj.eventH > 5], [gj.eventDay >= 20221125], [(T_OP_IS_NOT, gj.clearTime, NULL, 0) AND truncate(cast(timestampdiff(1, cast(gj.eventTime, TIMESTAMP(19, 0)), cast(gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) > cast(1, DECIMAL(1, 0)) OR (T_OP_IS, gj.clearTime, NULL, 0) AND timestampdiff(2, cast(gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))) > 0], [gj.dzOrXq = 1], [timestampdiff(2, cast(gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))) > 2879], [gj.eventDay >= 20221101], [(T_OP_IS, gj.clearTime, NULL, 0)]), filter(nil), rowset=256 6 - output([gj.dzOrXq], [gj.eventDay], [gj.codeOrName], [gj.clearTime], [gj.eventH], [gj.dzMinute], [gj.eventTime], [gj.dzOrXq = 0], [gj.eventDay >= 20221125], [gj.dzOrXq = 0], [gj.eventDay >= 20221125], [gj.dzOrXq = 0], [gj.eventH > 5], [gj.eventDay >= 20221125], [(T_OP_IS_NOT, gj.clearTime, NULL, 0) AND gj.dzMinute > 0 OR (T_OP_IS, gj.clearTime, NULL, 0) AND timestampdiff(2, cast(gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))) > 0], [gj.dzOrXq = 0], [gj.eventH > 5], [gj.eventDay >= 20221125], [(T_OP_IS_NOT, gj.clearTime, NULL, 0) AND truncate(cast(timestampdiff(1, cast(gj.eventTime, TIMESTAMP(19, 0)), cast(gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) > cast(1, DECIMAL(1, 0)) OR (T_OP_IS, gj.clearTime, NULL, 0) AND timestampdiff(2, cast(gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))) > 0], [gj.dzOrXq = 1], [timestampdiff(2, cast(gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))) > 2879], [gj.eventDay >= 20221101], [(T_OP_IS, gj.clearTime, NULL, 0)]), filter([(T_OP_OR, gj.dzOrXq = 0 AND gj.eventDay >= 20221125, gj.dzOrXq = 0 AND gj.eventDay >= 20221125, (T_OP_AND, gj.dzOrXq = 0, gj.eventH > 5, gj.eventDay >= 20221125, (T_OP_IS_NOT, gj.clearTime, NULL, 0) AND gj.dzMinute > 0 OR (T_OP_IS, gj.clearTime, NULL, 0) AND timestampdiff(2, cast(gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))) > 0), (T_OP_AND, gj.dzOrXq = 0, gj.eventH > 5, gj.eventDay >= 20221125, (T_OP_IS_NOT, gj.clearTime, NULL, 0) AND truncate(cast(timestampdiff(1, cast(gj.eventTime, TIMESTAMP(19, 0)), cast(gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) > cast(1, DECIMAL(1, 0)) OR (T_OP_IS, gj.clearTime, NULL, 0) AND timestampdiff(2, cast(gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))) > 0), (T_OP_AND, gj.dzOrXq = 1, timestampdiff(2, cast(gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))) > 2879, gj.eventDay >= 20221101, (T_OP_IS, gj.clearTime, NULL, 0)))], [gj.eventDay <= 20221125]), rowset=256, access([gj.dzOrXq], [gj.eventDay], [gj.codeOrName], [gj.clearTime], [gj.eventH], [gj.dzMinute], [gj.eventTime]), partitions(p0) 7 - output([logical_standing_alarm.isXq], [logical_standing_alarm.gridName], [logical_standing_alarm.standardZsName]), filter([(T_OP_OR, (T_OP_AND, ?, ?, logical_standing_alarm.isXq = 0), (T_OP_AND, ?, ?, logical_standing_alarm.isXq = 0), (T_OP_AND, ?, ?, ?, logical_standing_alarm.isXq = 0, ?), (T_OP_AND, ?, ?, ?, logical_standing_alarm.isXq = 0, ?), (T_OP_AND, ?, ?, ?, logical_standing_alarm.isXq = 1, ?))], [? = logical_standing_alarm.isXq], [(T_OP_IS_NOT, logical_standing_alarm.gridName, NULL, 0)], [(T_OP_OR, logical_standing_alarm.isXq = 0, logical_standing_alarm.isXq = 0, logical_standing_alarm.isXq = 0, logical_standing_alarm.isXq = 0, logical_standing_alarm.isXq = 1)]), rowset=256, access([logical_standing_alarm.id], [logical_standing_alarm.isXq], [logical_standing_alarm.gridName], [logical_standing_alarm.standardZsName]), partitions(p0) 8 - output([tbl_org.allname], [cp.cpdzbl], [cd.cdcsbl], [gzscdb.pjdzsc], [w.gridName], [T_FUN_COUNT_SUM(T_FUN_COUNT(*))], [k.gzhfscdbbl], [k.gridName], [k.cctfxq4g], [k.cctfxq5g], [w.whxq4g], [w.whxq5g]), filter(nil), rowset=256, sort_keys([tbl_org.sort, ASC]) 9 - output([tbl_org.allname], [cp.cpdzbl], [cd.cdcsbl], [gzscdb.pjdzsc], [tbl_org.sort], [w.gridName], [T_FUN_COUNT_SUM(T_FUN_COUNT(*))], [k.gzhfscdbbl], [k.gridName], [k.cctfxq4g], [k.cctfxq5g], [w.whxq4g], [w.whxq5g]), filter(nil), rowset=256, dop=115 10 - output([tbl_org.allname], [cp.cpdzbl], [cd.cdcsbl], [gzscdb.pjdzsc], [tbl_org.sort], [w.gridName], [T_FUN_COUNT_SUM(T_FUN_COUNT(*))], [k.gzhfscdbbl], [k.gridName], [k.cctfxq4g], [k.cctfxq5g], [w.whxq4g], [w.whxq5g]), filter(nil), rowset=256, sort_keys([tbl_org.sort, ASC]) 11 - output([tbl_org.allname], [cp.cpdzbl], [cd.cdcsbl], [gzscdb.pjdzsc], [tbl_org.sort], [w.gridName], [T_FUN_COUNT_SUM(T_FUN_COUNT(*))], [k.gzhfscdbbl], [k.gridName], [k.cctfxq4g], [k.cctfxq5g], [w.whxq4g], [w.whxq5g]), filter(nil), rowset=256, group([tbl_org.id], [w.gridName]), agg_func([T_FUN_COUNT_SUM(T_FUN_COUNT(*))]) 12 - output([tbl_org.allname], [cp.cpdzbl], [cd.cdcsbl], [gzscdb.pjdzsc], [tbl_org.sort], [w.gridName], [tbl_org.id], [T_FUN_COUNT(*)], [k.gzhfscdbbl], [k.gridName], [k.cctfxq4g], [k.cctfxq5g], [w.whxq4g], [w.whxq5g]), filter(nil), rowset=256 13 - (#keys=2, [tbl_org.id], [w.gridName]), output([tbl_org.allname], [cp.cpdzbl], [cd.cdcsbl], [gzscdb.pjdzsc], [tbl_org.sort], [w.gridName], [tbl_org.id], [T_FUN_COUNT(*)], [k.gzhfscdbbl], [k.gridName], [k.cctfxq4g], [k.cctfxq5g], [w.whxq4g], [w.whxq5g]), filter(nil), rowset=256, dop=115 14 - output([tbl_org.allname], [cp.cpdzbl], [cd.cdcsbl], [gzscdb.pjdzsc], [tbl_org.sort], [w.gridName], [tbl_org.id], [T_FUN_COUNT(*)], [k.gzhfscdbbl], [k.gridName], [k.cctfxq4g], [k.cctfxq5g], [w.whxq4g], [w.whxq5g]), filter(nil), rowset=256, group([tbl_org.id], [w.gridName]), agg_func([T_FUN_COUNT(*)]) 15 - output([tbl_org.allname], [cp.cpdzbl], [cd.cdcsbl], [gzscdb.pjdzsc], [tbl_org.sort], [w.gridName], [tbl_org.id], [k.gzhfscdbbl], [k.gridName], [k.cctfxq4g], [k.cctfxq5g], [w.whxq4g], [w.whxq5g]), filter(nil), rowset=256, equal_conds([tbl_org.orgname = k.gridName]), other_conds(nil) 16 - output([k.gridName], [k.gzhfscdbbl]), filter(nil), rowset=256 17 - output([k.gridName], [k.gzhfscdbbl]), filter(nil), rowset=256, dop=115 18 - output([k.gridName], [k.gzhfscdbbl]), filter(nil), rowset=256, access([k.gridName], [k.gzhfscdbbl]) 19 - output([VIEW3.logical_standing_alarm.gridName], [round(cast(1, DECIMAL(1, 0)) - T_FUN_SUM(T_FUN_SUM(CASE WHEN CASE WHEN CASE WHEN (T_OP_IS, VIEW3.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW3.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(480, DECIMAL(3, 0)) THEN 8 ELSE 0 END >= 8 THEN 1 ELSE 0 END)) / T_FUN_SUM(T_FUN_SUM(CASE WHEN CASE WHEN (T_OP_IS, VIEW3.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW3.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(1, DECIMAL(1, 0)) THEN 1 ELSE 0 END)) * cast(100, DECIMAL(3, 0)), 2)]), filter(nil), rowset=256, group([VIEW3.logical_standing_alarm.gridName]), agg_func([T_FUN_SUM(T_FUN_SUM(CASE WHEN CASE WHEN CASE WHEN (T_OP_IS, VIEW3.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW3.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(480, DECIMAL(3, 0)) THEN 8 ELSE 0 END >= 8 THEN 1 ELSE 0 END))], [T_FUN_SUM(T_FUN_SUM(CASE WHEN CASE WHEN (T_OP_IS, VIEW3.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW3.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(1, DECIMAL(1, 0)) THEN 1 ELSE 0 END))]) 20 - output([VIEW3.logical_standing_alarm.gridName], [T_FUN_SUM(CASE WHEN CASE WHEN CASE WHEN (T_OP_IS, VIEW3.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW3.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(480, DECIMAL(3, 0)) THEN 8 ELSE 0 END >= 8 THEN 1 ELSE 0 END)], [T_FUN_SUM(CASE WHEN CASE WHEN (T_OP_IS, VIEW3.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW3.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(1, DECIMAL(1, 0)) THEN 1 ELSE 0 END)]), filter(nil), rowset=256 21 - (#keys=1, [VIEW3.logical_standing_alarm.gridName]), output([VIEW3.logical_standing_alarm.gridName], [T_FUN_SUM(CASE WHEN CASE WHEN CASE WHEN (T_OP_IS, VIEW3.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW3.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(480, DECIMAL(3, 0)) THEN 8 ELSE 0 END >= 8 THEN 1 ELSE 0 END)], [T_FUN_SUM(CASE WHEN CASE WHEN (T_OP_IS, VIEW3.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW3.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(1, DECIMAL(1, 0)) THEN 1 ELSE 0 END)]), filter(nil), rowset=256, dop=115 22 - output([VIEW3.logical_standing_alarm.gridName], [T_FUN_SUM(CASE WHEN CASE WHEN CASE WHEN (T_OP_IS, VIEW3.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW3.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(480, DECIMAL(3, 0)) THEN 8 ELSE 0 END >= 8 THEN 1 ELSE 0 END)], [T_FUN_SUM(CASE WHEN CASE WHEN (T_OP_IS, VIEW3.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW3.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(1, DECIMAL(1, 0)) THEN 1 ELSE 0 END)]), filter(nil), rowset=256, group([VIEW3.logical_standing_alarm.gridName]), agg_func([T_FUN_SUM(CASE WHEN CASE WHEN CASE WHEN (T_OP_IS, VIEW3.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW3.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(480, DECIMAL(3, 0)) THEN 8 ELSE 0 END >= 8 THEN 1 ELSE 0 END)], [T_FUN_SUM(CASE WHEN CASE WHEN (T_OP_IS, VIEW3.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW3.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(1, DECIMAL(1, 0)) THEN 1 ELSE 0 END)]) 23 - output([VIEW3.gj.clearTime], [VIEW3.gj.eventTime], [VIEW3.logical_standing_alarm.gridName]), filter([VIEW3.gj.eventH > 5], [VIEW3.gj.eventDay >= 20221125], [(T_OP_IS_NOT, VIEW3.gj.clearTime, NULL, 0) AND VIEW3.gj.dzMinute > 0 OR (T_OP_IS, VIEW3.gj.clearTime, NULL, 0) AND timestampdiff(2, cast(VIEW3.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))) > 0], [VIEW3.gj.dzOrXq = 0], [VIEW3.logical_standing_alarm.isXq = 0]), rowset=256, access([VIEW3.gj.dzOrXq], [VIEW3.gj.eventH], [VIEW3.gj.clearTime], [VIEW3.gj.dzMinute], [VIEW3.gj.eventTime], [VIEW3.gj.eventDay], [VIEW3.logical_standing_alarm.isXq], [VIEW3.logical_standing_alarm.gridName]) 24 - output([tbl_org.allname], [cp.cpdzbl], [cd.cdcsbl], [gzscdb.pjdzsc], [tbl_org.sort], [w.gridName], [tbl_org.id], [tbl_org.orgname], [k.gridName], [k.cctfxq4g], [k.cctfxq5g], [w.whxq4g], [w.whxq5g]), filter(nil), rowset=256, equal_conds([tbl_org.orgname = cd.gridName]), other_conds(nil) 25 - output([cd.cdcsbl], [cd.gridName]), filter(nil), rowset=256 26 - output([cd.cdcsbl], [cd.gridName]), filter(nil), rowset=256, dop=115 27 - output([cd.gridName], [cd.cdcsbl]), filter(nil), rowset=256, access([cd.gridName], [cd.cdcsbl]) 28 - output([VIEW2.logical_standing_alarm.gridName], [round(T_FUN_SUM(T_FUN_SUM(CASE WHEN VIEW2.gj.eventH > 5 AND (T_OP_IS_NOT, VIEW2.gj.clearTime, NULL, 0) AND VIEW2.gj.dzMinute = 0 THEN 1 ELSE 0 END)) / cast(T_FUN_COUNT_SUM(T_FUN_COUNT(*)), DECIMAL(20, 0)) * cast(100, DECIMAL(3, 0)), 2)]), filter(nil), rowset=256, group([VIEW2.logical_standing_alarm.gridName]), agg_func([T_FUN_SUM(T_FUN_SUM(CASE WHEN VIEW2.gj.eventH > 5 AND (T_OP_IS_NOT, VIEW2.gj.clearTime, NULL, 0) AND VIEW2.gj.dzMinute = 0 THEN 1 ELSE 0 END))], [T_FUN_COUNT_SUM(T_FUN_COUNT(*))]) 29 - output([VIEW2.logical_standing_alarm.gridName], [T_FUN_SUM(CASE WHEN VIEW2.gj.eventH > 5 AND (T_OP_IS_NOT, VIEW2.gj.clearTime, NULL, 0) AND VIEW2.gj.dzMinute = 0 THEN 1 ELSE 0 END)], [T_FUN_COUNT(*)]), filter(nil), rowset=256 30 - (#keys=1, [VIEW2.logical_standing_alarm.gridName]), output([VIEW2.logical_standing_alarm.gridName], [T_FUN_SUM(CASE WHEN VIEW2.gj.eventH > 5 AND (T_OP_IS_NOT, VIEW2.gj.clearTime, NULL, 0) AND VIEW2.gj.dzMinute = 0 THEN 1 ELSE 0 END)], [T_FUN_COUNT(*)]), filter(nil), rowset=256, dop=115 31 - output([VIEW2.logical_standing_alarm.gridName], [T_FUN_SUM(CASE WHEN VIEW2.gj.eventH > 5 AND (T_OP_IS_NOT, VIEW2.gj.clearTime, NULL, 0) AND VIEW2.gj.dzMinute = 0 THEN 1 ELSE 0 END)], [T_FUN_COUNT(*)]), filter(nil), rowset=256, group([VIEW2.logical_standing_alarm.gridName]), agg_func([T_FUN_SUM(CASE WHEN VIEW2.gj.eventH > 5 AND (T_OP_IS_NOT, VIEW2.gj.clearTime, NULL, 0) AND VIEW2.gj.dzMinute = 0 THEN 1 ELSE 0 END)], [T_FUN_COUNT(*)]) 32 - output([VIEW2.gj.clearTime], [VIEW2.gj.eventH], [VIEW2.gj.dzMinute], [VIEW2.logical_standing_alarm.gridName]), filter([VIEW2.gj.eventDay >= 20221125], [VIEW2.gj.dzOrXq = 0], [VIEW2.logical_standing_alarm.isXq = 0]), rowset=256, access([VIEW2.gj.dzOrXq], [VIEW2.gj.eventDay], [VIEW2.gj.clearTime], [VIEW2.gj.eventH], [VIEW2.gj.dzMinute], [VIEW2.logical_standing_alarm.isXq], [VIEW2.logical_standing_alarm.gridName]) 33 - output([tbl_org.allname], [cp.cpdzbl], [gzscdb.pjdzsc], [tbl_org.sort], [w.gridName], [tbl_org.id], [tbl_org.orgname], [k.gridName], [k.cctfxq4g], [k.cctfxq5g], [w.whxq4g], [w.whxq5g]), filter(nil), rowset=256, equal_conds([tbl_org.orgname = w.gridName]), other_conds(nil) 34 - output([w.gridName]), filter(nil), rowset=256 35 - output([w.gridName]), filter(nil), rowset=256, dop=115 36 - output([w.gridName]), filter(nil), rowset=256, access([w.gridName]) 37 - output([VIEW6.logical_standing_alarm.gridName]), filter([T_FUN_COUNT_SUM(T_FUN_COUNT(*)) > 4]), rowset=256, group([DATE_FORMAT(VIEW6.gj.eventTime, '%Y-%m-%d %H:%i')], [VIEW6.logical_standing_alarm.gridName]), agg_func([T_FUN_COUNT_SUM(T_FUN_COUNT(*))]) 38 - output([DATE_FORMAT(VIEW6.gj.eventTime, '%Y-%m-%d %H:%i')], [VIEW6.logical_standing_alarm.gridName], [T_FUN_COUNT(*)]), filter(nil), rowset=256 39 - (#keys=2, [DATE_FORMAT(VIEW6.gj.eventTime, '%Y-%m-%d %H:%i')], [VIEW6.logical_standing_alarm.gridName]), output([DATE_FORMAT(VIEW6.gj.eventTime, '%Y-%m-%d %H:%i')], [VIEW6.logical_standing_alarm.gridName], [T_FUN_COUNT(*)]), filter(nil), rowset=256, dop=115 40 - output([DATE_FORMAT(VIEW6.gj.eventTime, '%Y-%m-%d %H:%i')], [VIEW6.logical_standing_alarm.gridName], [T_FUN_COUNT(*)]), filter(nil), rowset=256, group([DATE_FORMAT(VIEW6.gj.eventTime, '%Y-%m-%d %H:%i')], [VIEW6.logical_standing_alarm.gridName]), agg_func([T_FUN_COUNT(*)]) 41 - output([VIEW6.gj.eventTime], [VIEW6.logical_standing_alarm.gridName]), filter([VIEW6.gj.eventDay >= 20221125], [VIEW6.gj.dzOrXq = 0], [VIEW6.logical_standing_alarm.isXq = 0]), rowset=256, access([VIEW6.gj.dzOrXq], [VIEW6.gj.eventDay], [VIEW6.gj.eventTime], [VIEW6.logical_standing_alarm.isXq], [VIEW6.logical_standing_alarm.gridName]) 42 - output([tbl_org.allname], [cp.cpdzbl], [gzscdb.pjdzsc], [tbl_org.sort], [tbl_org.id], [tbl_org.orgname], [k.gridName], [k.cctfxq4g], [k.cctfxq5g], [w.whxq4g], [w.whxq5g]), filter(nil), rowset=256, equal_conds([tbl_org.orgname = cp.gridName]), other_conds(nil) 43 - output([cp.cpdzbl], [cp.gridName]), filter(nil), rowset=256 44 - output([cp.cpdzbl], [cp.gridName]), filter(nil), rowset=256, is_single, dop=1 45 - output([cp.gridName], [cp.cpdzbl]), filter(nil), rowset=256, access([cp.gridName], [cp.cpdzbl]) 46 - output([VIEW1.logical_standing_alarm.gridName], [round(T_FUN_SUM(1) / cast(VIEW1.dc.zcount, DECIMAL(20, 0)) * cast(100, DECIMAL(3, 0)), 2)]), filter(nil), rowset=256, group([VIEW1.logical_standing_alarm.gridName]), agg_func([T_FUN_SUM(1)]) 47 - output([VIEW1.dc.zcount], [VIEW1.logical_standing_alarm.gridName]), filter(nil), rowset=256, access([VIEW1.dc.zcount], [VIEW1.logical_standing_alarm.gridName]) 48 - output([dc.zcount], [logical_standing_alarm.gridName]), filter([T_FUN_COUNT(*) > 4]), rowset=256, group([dc.gridName], [dc.zcount], [logical_standing_alarm.id], [gj.codeOrName], [gj.eventDay]), agg_func([T_FUN_COUNT(*)]) 49 - output([dc.gridName], [dc.zcount], [logical_standing_alarm.id], [gj.codeOrName], [gj.eventDay], [logical_standing_alarm.gridName]), filter(nil), rowset=256, conds(nil), nl_params_([logical_standing_alarm.gridName]) 50 - output([logical_standing_alarm.id], [gj.codeOrName], [gj.eventDay], [logical_standing_alarm.gridName]), filter(nil), rowset=256, conds(nil), nl_params_([gj.codeOrName]) 51 - output([gj.codeOrName], [gj.eventDay]), filter(nil), rowset=256 52 - output([gj.codeOrName], [gj.eventDay]), filter(nil), rowset=256 53 - output([gj.codeOrName], [gj.eventDay]), filter(nil), rowset=256, dop=115 54 - output([gj.eventDay], [gj.codeOrName]), filter(nil), rowset=256 55 - output([gj.eventDay], [gj.codeOrName]), filter([gj.dzOrXq = 0], [(T_OP_IS_NOT, gj.clearTime, NULL, 0) AND gj.dzMinute > 0 OR (T_OP_IS, gj.clearTime, NULL, 0) AND timestampdiff(2, cast(gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))) > 0], [gj.eventH > 5], [gj.gridName != '']), rowset=256, access([gj.__pk_increment], [gj.dzOrXq], [gj.gridName], [gj.eventDay], [gj.eventH], [gj.clearTime], [gj.dzMinute], [gj.eventTime], [gj.codeOrName]), partitions(p0) 56 - output([logical_standing_alarm.id], [logical_standing_alarm.gridName]), filter(nil), rowset=256 57 - output([logical_standing_alarm.id], [logical_standing_alarm.gridName]), filter(nil), rowset=256, dop=115 58 - output([logical_standing_alarm.id], [logical_standing_alarm.gridName]), filter(nil), rowset=256 59 - output([logical_standing_alarm.id], [logical_standing_alarm.gridName]), filter([logical_standing_alarm.isXq = 0]), rowset=256, access([logical_standing_alarm.id], [logical_standing_alarm.isXq], [logical_standing_alarm.gridName]), partitions(p0) 60 - output([dc.gridName], [dc.zcount]), filter(nil), rowset=256, access([dc.gridName], [dc.zcount]) 61 - output([logical_standing_alarm.gridName], [T_FUN_COUNT(*)]), filter(nil), rowset=256, group(nil), agg_func([T_FUN_COUNT(*)]) 62 - output([logical_standing_alarm.gridName]), filter([logical_standing_alarm.isXq = 0]), rowset=256, access([GROUP_ID], [logical_standing_alarm.id], [logical_standing_alarm.isXq], [logical_standing_alarm.gridName]), partitions(p0) 63 - output([tbl_org.allname], [gzscdb.pjdzsc], [tbl_org.sort], [tbl_org.id], [tbl_org.orgname], [k.gridName], [k.cctfxq4g], [k.cctfxq5g], [w.whxq4g], [w.whxq5g]), filter(nil), rowset=256, equal_conds([tbl_org.orgname = gzscdb.gridName]), other_conds(nil) 64 - output([gzscdb.pjdzsc], [gzscdb.gridName]), filter(nil), rowset=256 65 - output([gzscdb.pjdzsc], [gzscdb.gridName]), filter(nil), rowset=256, dop=115 66 - output([gzscdb.gridName], [gzscdb.pjdzsc]), filter(nil), rowset=256, access([gzscdb.gridName], [gzscdb.pjdzsc]) 67 - output([VIEW4.logical_standing_alarm.gridName], [round(T_FUN_SUM(T_FUN_SUM(CASE WHEN CASE WHEN (T_OP_IS, VIEW4.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW4.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(1, DECIMAL(1, 0)) THEN CASE WHEN (T_OP_IS, VIEW4.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW4.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END ELSE cast(0, DECIMAL(1, 0)) END)) / T_FUN_SUM(T_FUN_SUM(CASE WHEN CASE WHEN (T_OP_IS, VIEW4.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW4.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(1, DECIMAL(1, 0)) THEN 1 ELSE 0 END)), 2)]), filter(nil), rowset=256, group([VIEW4.logical_standing_alarm.gridName]), agg_func([T_FUN_SUM(T_FUN_SUM(CASE WHEN CASE WHEN (T_OP_IS, VIEW4.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW4.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(1, DECIMAL(1, 0)) THEN CASE WHEN (T_OP_IS, VIEW4.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW4.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END ELSE cast(0, DECIMAL(1, 0)) END))], [T_FUN_SUM(T_FUN_SUM(CASE WHEN CASE WHEN (T_OP_IS, VIEW4.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW4.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(1, DECIMAL(1, 0)) THEN 1 ELSE 0 END))]) 68 - output([VIEW4.logical_standing_alarm.gridName], [T_FUN_SUM(CASE WHEN CASE WHEN (T_OP_IS, VIEW4.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW4.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(1, DECIMAL(1, 0)) THEN CASE WHEN (T_OP_IS, VIEW4.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW4.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END ELSE cast(0, DECIMAL(1, 0)) END)], [T_FUN_SUM(CASE WHEN CASE WHEN (T_OP_IS, VIEW4.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW4.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(1, DECIMAL(1, 0)) THEN 1 ELSE 0 END)]), filter(nil), rowset=256 69 - (#keys=1, [VIEW4.logical_standing_alarm.gridName]), output([VIEW4.logical_standing_alarm.gridName], [T_FUN_SUM(CASE WHEN CASE WHEN (T_OP_IS, VIEW4.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW4.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(1, DECIMAL(1, 0)) THEN CASE WHEN (T_OP_IS, VIEW4.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW4.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END ELSE cast(0, DECIMAL(1, 0)) END)], [T_FUN_SUM(CASE WHEN CASE WHEN (T_OP_IS, VIEW4.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW4.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(1, DECIMAL(1, 0)) THEN 1 ELSE 0 END)]), filter(nil), rowset=256, dop=115 70 - output([VIEW4.logical_standing_alarm.gridName], [T_FUN_SUM(CASE WHEN CASE WHEN (T_OP_IS, VIEW4.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW4.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(1, DECIMAL(1, 0)) THEN CASE WHEN (T_OP_IS, VIEW4.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW4.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END ELSE cast(0, DECIMAL(1, 0)) END)], [T_FUN_SUM(CASE WHEN CASE WHEN (T_OP_IS, VIEW4.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW4.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(1, DECIMAL(1, 0)) THEN 1 ELSE 0 END)]), filter(nil), rowset=256, group([VIEW4.logical_standing_alarm.gridName]), agg_func([T_FUN_SUM(CASE WHEN CASE WHEN (T_OP_IS, VIEW4.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW4.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(1, DECIMAL(1, 0)) THEN CASE WHEN (T_OP_IS, VIEW4.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW4.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END ELSE cast(0, DECIMAL(1, 0)) END)], [T_FUN_SUM(CASE WHEN CASE WHEN (T_OP_IS, VIEW4.gj.clearTime, NULL, 0) THEN truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) ELSE truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW4.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) END > cast(1, DECIMAL(1, 0)) THEN 1 ELSE 0 END)]) 71 - output([VIEW4.gj.clearTime], [VIEW4.gj.eventTime], [VIEW4.logical_standing_alarm.gridName]), filter([VIEW4.gj.eventH > 5], [VIEW4.gj.eventDay >= 20221125], [(T_OP_IS_NOT, VIEW4.gj.clearTime, NULL, 0) AND truncate(cast(timestampdiff(1, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(VIEW4.gj.clearTime, TIMESTAMP(19, 0))), DECIMAL(20, 0)) / cast(60, DECIMAL(2, 0)), 4) > cast(1, DECIMAL(1, 0)) OR (T_OP_IS, VIEW4.gj.clearTime, NULL, 0) AND timestampdiff(2, cast(VIEW4.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))) > 0], [VIEW4.gj.dzOrXq = 0], [VIEW4.logical_standing_alarm.isXq = 0]), rowset=256, access([VIEW4.gj.dzOrXq], [VIEW4.gj.eventH], [VIEW4.gj.clearTime], [VIEW4.gj.eventTime], [VIEW4.gj.eventDay], [VIEW4.logical_standing_alarm.isXq], [VIEW4.logical_standing_alarm.gridName]) 72 - output([tbl_org.allname], [tbl_org.sort], [tbl_org.id], [tbl_org.orgname], [k.gridName], [k.cctfxq4g], [k.cctfxq5g], [w.whxq4g], [w.whxq5g]), filter(nil), rowset=256, equal_conds([tbl_org.orgname = k.gridName]), other_conds(nil) 73 - output([k.gridName], [k.cctfxq4g], [k.cctfxq5g], [w.whxq4g], [w.whxq5g]), filter(nil), rowset=256 74 - output([k.gridName], [k.cctfxq4g], [k.cctfxq5g], [w.whxq4g], [w.whxq5g]), filter(nil), rowset=256, dop=115 75 - output([k.gridName], [k.cctfxq4g], [k.cctfxq5g], [w.whxq4g], [w.whxq5g]), filter(nil), rowset=256, conds(nil), nl_params_([k.gridName]) 76 - output([k.gridName], [k.cctfxq4g], [k.cctfxq5g]), filter(nil), rowset=256, access([k.gridName], [k.cctfxq4g], [k.cctfxq5g]) 77 - output([VIEW5.logical_standing_alarm.gridName], [CASE WHEN T_FUN_COUNT_SUM(T_FUN_COUNT(CASE WHEN VIEW5.logical_standing_alarm.standardZsName = '4G' THEN 1 ELSE NULL END)) > 0 THEN T_FUN_COUNT_SUM(T_FUN_COUNT(CASE WHEN VIEW5.logical_standing_alarm.standardZsName = '4G' THEN 1 ELSE NULL END)) ELSE 0 END], [CASE WHEN T_FUN_COUNT_SUM(T_FUN_COUNT(CASE WHEN VIEW5.logical_standing_alarm.standardZsName = '5G' THEN 1 ELSE NULL END)) > 0 THEN T_FUN_COUNT_SUM(T_FUN_COUNT(CASE WHEN VIEW5.logical_standing_alarm.standardZsName = '5G' THEN 1 ELSE NULL END)) ELSE 0 END]), filter(nil), rowset=256, group([VIEW5.logical_standing_alarm.gridName]), agg_func([T_FUN_COUNT_SUM(T_FUN_COUNT(CASE WHEN VIEW5.logical_standing_alarm.standardZsName = '4G' THEN 1 ELSE NULL END))], [T_FUN_COUNT_SUM(T_FUN_COUNT(CASE WHEN VIEW5.logical_standing_alarm.standardZsName = '5G' THEN 1 ELSE NULL END))]) 78 - output([VIEW5.logical_standing_alarm.gridName], [T_FUN_COUNT(CASE WHEN VIEW5.logical_standing_alarm.standardZsName = '4G' THEN 1 ELSE NULL END)], [T_FUN_COUNT(CASE WHEN VIEW5.logical_standing_alarm.standardZsName = '5G' THEN 1 ELSE NULL END)]), filter(nil), rowset=256 79 - (#keys=1, [VIEW5.logical_standing_alarm.gridName]), output([VIEW5.logical_standing_alarm.gridName], [T_FUN_COUNT(CASE WHEN VIEW5.logical_standing_alarm.standardZsName = '4G' THEN 1 ELSE NULL END)], [T_FUN_COUNT(CASE WHEN VIEW5.logical_standing_alarm.standardZsName = '5G' THEN 1 ELSE NULL END)]), filter(nil), rowset=256, dop=115 80 - output([VIEW5.logical_standing_alarm.gridName], [T_FUN_COUNT(CASE WHEN VIEW5.logical_standing_alarm.standardZsName = '4G' THEN 1 ELSE NULL END)], [T_FUN_COUNT(CASE WHEN VIEW5.logical_standing_alarm.standardZsName = '5G' THEN 1 ELSE NULL END)]), filter(nil), rowset=256, group([VIEW5.logical_standing_alarm.gridName]), agg_func([T_FUN_COUNT(CASE WHEN VIEW5.logical_standing_alarm.standardZsName = '4G' THEN 1 ELSE NULL END)], [T_FUN_COUNT(CASE WHEN VIEW5.logical_standing_alarm.standardZsName = '5G' THEN 1 ELSE NULL END)]) 81 - output([VIEW5.logical_standing_alarm.gridName], [VIEW5.logical_standing_alarm.standardZsName]), filter([(T_OP_IS, VIEW5.gj.clearTime, NULL, 0)], [VIEW5.gj.eventDay >= 20221101], [timestampdiff(2, cast(VIEW5.gj.eventTime, TIMESTAMP(19, 0)), cast(current_timestamp(), TIMESTAMP(-1, 0))) > 2879], [VIEW5.gj.dzOrXq = 1], [VIEW5.logical_standing_alarm.isXq = 1]), rowset=256, access([VIEW5.gj.dzOrXq], [VIEW5.gj.clearTime], [VIEW5.gj.eventTime], [VIEW5.gj.eventDay], [VIEW5.logical_standing_alarm.isXq], [VIEW5.logical_standing_alarm.gridName], [VIEW5.logical_standing_alarm.standardZsName]) 82 - output([w.whxq4g], [w.whxq5g]), filter(nil), rowset=256, access([w.whxq4g], [w.whxq5g]) 83 - output([logical_standing_alarm.gridName], [T_FUN_COUNT(CASE WHEN logical_standing_alarm.standardZsName = '4G' THEN 1 ELSE NULL END)], [T_FUN_COUNT(CASE WHEN logical_standing_alarm.standardZsName = '5G' THEN 1 ELSE NULL END)]), filter(nil), rowset=256, group(nil), agg_func([T_FUN_COUNT(CASE WHEN logical_standing_alarm.standardZsName = '4G' THEN 1 ELSE NULL END)], [T_FUN_COUNT(CASE WHEN logical_standing_alarm.standardZsName = '5G' THEN 1 ELSE NULL END)]) 84 - output([logical_standing_alarm.gridName], [logical_standing_alarm.standardZsName]), filter([logical_standing_alarm.isXq = 1], [(T_OP_IS_NOT, logical_standing_alarm.gridName, NULL, 0)]), rowset=256, access([GROUP_ID], [logical_standing_alarm.id], [logical_standing_alarm.isXq], [logical_standing_alarm.gridName], [logical_standing_alarm.standardZsName]), partitions(p0) 85 - output([tbl_org.id], [tbl_org.orgname], [tbl_org.allname], [tbl_org.sort]), filter(nil), rowset=256 86 - output([tbl_org.id], [tbl_org.orgname], [tbl_org.allname], [tbl_org.sort]), filter([tbl_org.pid != '0'], [tbl_org.orgkind != '']), rowset=256, access([tbl_org.id], [tbl_org.pid], [tbl_org.orgkind], [tbl_org.orgname], [tbl_org.allname], [tbl_org.sort]), partitions(p0)