obclient(rd_read@woqu)[cprint]> EXPLAIN EXTENDED SELECT /*+NO_USE_DAS(@"SEL$3" "s"@"SEL$3") NO_USE_DAS(@"SEL$4" "s"@"SEL$4")*/ -> *, -> ( CASE WHEN t.if_color_num = 0 THEN 1 WHEN t.order_count = t.if_color_num THEN 2 ELSE 3 END ) color_type -> FROM ( -> SELECT -> a.order_name, -> a.order_id, -> a.cust_id, -> a.use_type, -> a.state, -> a.create_time, -> a.state_date, -> a.dev_id, -> a.print_class, -> a.exec_print_flag, -> a.checked_flag, -> a.station_ver, -> g.pay_method, -> g.amount, -> g.bean_amt, -> g.channel_amt, -> (SELECT mobile FROM t_cust cust WHERE cust.cust_id = a.cust_id) mobile, -> d.station_id, -> d.station_name, -> d.merchant_id, -> d.set_id, -> e.merchant_name, -> e.merchant_short_name, -> g.return_amt AS return_fee, -> s.set_name, -> a.checked_ops_name, -> a.checked_time, -> a.print_mode, -> ( SELECT w.total_set_name FROM t_total_set w WHERE w.total_set_id = s.total_set_id ) total_set_name, -> ( SELECT SUM( g.printed_page ) FROM t_order_file g WHERE g.order_id = a.order_id ) printed_page, -> ( SELECT SUM(CEILING(g.page_num / g.shrink_plate_num) * g.copy_num) FROM t_order_file g WHERE g.order_id = -> a.order_id ) page_num, -> ( SELECT SUM( g.if_color ) FROM t_order_file g WHERE g.order_id = a.order_id ) if_color_num, -> ( SELECT COUNT( 1 ) FROM t_order_file g WHERE g.order_id = a.order_id ) order_count, -> '' AS startPage, -> '' AS endPage, -> ( SELECT GROUP_CONCAT(CONCAT(t.file_id, ':', t.err_msg) SEPARATOR ';$$$') FROM t_order_file_msg t WHERE -> t.order_id = -> a.order_id -> AND err_msg != '') errMsgConcat, -> ( SELECT GROUP_CONCAT(CONCAT('退款描述',t.return_id,':', t.problem_desc) SEPARATOR ';$$$') FROM t_order_return t -> WHERE t.order_id = a.order_id -> AND problem_desc != '') problemDescConcat -> FROM -> t_order a -> LEFT JOIN t_station d ON a.station_id = d.station_id -> LEFT JOIN t_device c ON a.dev_id = c.dev_id -> LEFT JOIN t_set s ON a.set_id = s.set_id -> LEFT JOIN t_merchant e ON s.merchant_id = e.merchant_id -> LEFT JOIN t_pay g ON a.pay_id = g.pay_id -> WHERE -> 1 = 1 -> AND a.create_time >= '2025-09-23 00:00:00' -> AND a.create_time <= '2025-09-23 23:59:59' -> AND ( -> EXISTS (SELECT 1 FROM t_order_file_msg s WHERE s.order_id = a.order_id AND s.err_msg!='' AND s.err_msg LIKE -> CONCAT('%','重复','%')) -> OR EXISTS (SELECT 1 FROM t_order_return s WHERE s.order_id = a.order_id AND s.problem_desc!='' AND -> s.problem_desc LIKE -> CONCAT('%','重复','%')) -> ) -> AND a.station_id IS NOT NULL -> ) t WHERE 1=1 -> ORDER BY create_time DESC, order_id DESC LIMIT 0,30; +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Query Plan | +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | ============================================================================================== | | |ID|OPERATOR |NAME |EST.ROWS|EST.TIME(us)| | | ---------------------------------------------------------------------------------------------- | | |0 |SORT | |31 |1870316 | | | |1 |└─SUBPLAN FILTER | |31 |1870274 | | | |2 | ├─PX COORDINATOR | |31 |1788334 | | | |3 | │ └─EXCHANGE OUT DISTR |:EX10004 |31 |1788146 | | | |4 | │ └─NESTED-LOOP OUTER JOIN | |31 |1787722 | | | |5 | │ ├─NESTED-LOOP OUTER JOIN | |31 |1787225 | | | |6 | │ │ ├─EXCHANGE IN DISTR | |31 |1786727 | | | |7 | │ │ │ └─EXCHANGE OUT DISTR (BC2HOST) |:EX10003 |31 |1786586 | | | |8 | │ │ │ └─HASH OUTER JOIN | |31 |1786268 | | | |9 | │ │ │ ├─SUBPLAN SCAN |VIEW4 |30 |1785100 | | | |10| │ │ │ │ └─LIMIT | |30 |1785100 | | | |11| │ │ │ │ └─TOP-N SORT | |30 |1785100 | | | |12| │ │ │ │ └─HASH RIGHT SEMI JOIN | |73936 |1781501 | | | |13| │ │ │ │ ├─SUBPLAN SCAN |VIEW3 |202559 |668763 | | | |14| │ │ │ │ │ └─UNION ALL | |202559 |668227 | | | |15| │ │ │ │ │ ├─EXCHANGE IN DISTR | |191320 |588817 | | | |16| │ │ │ │ │ │ └─EXCHANGE OUT DISTR|:EX10000 |191320 |421908 | | | |17| │ │ │ │ │ │ └─TABLE FULL SCAN |s |191320 |46731 | | | |18| │ │ │ │ │ └─TABLE FULL SCAN |s |11240 |78874 | | | |19| │ │ │ │ └─EXCHANGE IN DISTR | |73936 |1070506 | | | |20| │ │ │ │ └─EXCHANGE OUT DISTR |:EX10001 |73936 |837548 | | | |21| │ │ │ │ └─TABLE RANGE SCAN |a(idx_2,Reverse)|73936 |313267 | | | |22| │ │ │ └─HASH RIGHT OUTER JOIN | |343 |1112 | | | |23| │ │ │ ├─TABLE FULL SCAN |e |59 |6 | | | |24| │ │ │ └─EXCHANGE IN DISTR | |337 |1050 | | | |25| │ │ │ └─EXCHANGE OUT DISTR |:EX10002 |337 |737 | | | |26| │ │ │ └─TABLE FULL SCAN |s |337 |33 | | | |27| │ │ └─TABLE GET |d |1 |16 | | | |28| │ └─TABLE GET |g |1 |16 | | | |29| ├─TABLE GET |cust |1 |18 | | | |30| ├─PX COORDINATOR | |1 |20 | | | |31| │ └─EXCHANGE OUT DISTR |:EX20000 |1 |20 | | | |32| │ └─TABLE GET |w |1 |18 | | | |33| ├─PX COORDINATOR | |1 |46 | | | |34| │ └─EXCHANGE OUT DISTR |:EX30000 |1 |46 | | | |35| │ └─SCALAR GROUP BY | |1 |45 | | | |36| │ └─TABLE RANGE SCAN |g(idx_1) |5 |45 | | | |37| ├─PX COORDINATOR | |1 |47 | | | |38| │ └─EXCHANGE OUT DISTR |:EX40000 |1 |47 | | | |39| │ └─SCALAR GROUP BY | |1 |46 | | | |40| │ └─TABLE RANGE SCAN |g(idx_1) |5 |46 | | | |41| ├─PX COORDINATOR | |1 |46 | | | |42| │ └─EXCHANGE OUT DISTR |:EX50000 |1 |46 | | | |43| │ └─SCALAR GROUP BY | |1 |45 | | | |44| │ └─TABLE RANGE SCAN |g(idx_1) |5 |45 | | | |45| ├─PX COORDINATOR | |1 |19 | | | |46| │ └─EXCHANGE OUT DISTR |:EX60000 |1 |19 | | | |47| │ └─SCALAR GROUP BY | |1 |19 | | | |48| │ └─TABLE RANGE SCAN |g(idx_1) |5 |18 | | | |49| ├─PX COORDINATOR | |1 |40 | | | |50| │ └─EXCHANGE OUT DISTR |:EX70000 |1 |39 | | | |51| │ └─SCALAR GROUP BY | |1 |38 | | | |52| │ └─TABLE RANGE SCAN |t(i_order_id) |3 |38 | | | |53| └─SCALAR GROUP BY | |1 |31 | | | |54| └─TABLE RANGE SCAN |t(idx_order_id) |1 |31 | | | ============================================================================================== | | Outputs & filters: | | ------------------------------------- | | 0 - output([VIEW4.a.order_name(0x7fa2bd1ddde0)], [VIEW4.a.order_id(0x7fa2bd1ddc40)], [VIEW4.a.cust_id(0x7fa2bd1ddf80)], [VIEW4.a.use_type(0x7fa2bd1de120)], | | [VIEW4.a.state(0x7fa2bd1de2c0)], [VIEW4.a.create_time(0x7fa2bd1ddaa0)], [VIEW4.a.state_date(0x7fa2bd1de460)], [VIEW4.a.dev_id(0x7fa2bd1de600)], [VIEW4.a.print_class(0x7fa2bd1de7a0)], | | [VIEW4.a.exec_print_flag(0x7fa2bd1de950)], [VIEW4.a.checked_flag(0x7fa2bd1deaf0)], [VIEW4.a.station_ver(0x7fa2bd1dec90)], [g.pay_method(0x7fa3a7cbdd10)], | | [g.amount(0x7fa3a7cbe060)], [g.bean_amt(0x7fa3a7cbe3b0)], [g.channel_amt(0x7fa3a7cbe700)], [subquery(1)(0x7fa3a7cbe8a0)], [d.station_id(0x7fa3a7c71a60)], | | [d.station_name(0x7fa3a7ceedb0)], [d.merchant_id(0x7fa3a7cef100)], [d.set_id(0x7fa3a7cef450)], [e.merchant_name(0x7fa3a7cef7a0)], [e.merchant_short_name(0x7fa3a7cefaf0)], | | [g.return_amt(0x7fa3a7cefe40)], [s.set_name(0x7fa3a7cf0190)], [VIEW4.a.checked_ops_name(0x7fa2bd1dee40)], [VIEW4.a.checked_time(0x7fa2bd1ec8f0)], [VIEW4.a.print_mode(0x7fa2bd1eca90)], | | [subquery(2)(0x7fa3a7cf0d20)], [subquery(3)(0x7fa3a7d04610)], [subquery(4)(0x7fa3a7d21300)], [subquery(5)(0x7fa3a7d38460)], [subquery(6)(0x7fa3a7d5d3f0)], | | [''(0x7fa3a7d70c20)], [''(0x7fa3a7d70d80)], [subquery(7)(0x7fa3a7d70ee0)], [subquery(8)(0x7fa3a7da3270)], [CASE WHEN subquery(5)(0x7fa3a7d38460) = cast(0(0x7fa20102d070), | | DECIMAL_INT(33, 0))(0x7fa20102e560)(0x7fa20102d1c0) THEN 1(0x7fa20102d310) WHEN cast(subquery(6)(0x7fa3a7d5d3f0), DECIMAL_INT(33, 0))(0x7fa20102ea20) = | | subquery(5)(0x7fa3a7d38460)(0x7fa20102d7c0) THEN 2(0x7fa20102d910) ELSE 3(0x7fa20102da60) END(0x7fa20102cb80)]), filter(nil), rowset=256 | | sort_keys([VIEW4.a.create_time(0x7fa2bd1ddaa0), DESC], [VIEW4.a.order_id(0x7fa2bd1ddc40), DESC]) | | 1 - output([VIEW4.a.create_time(0x7fa2bd1ddaa0)], [VIEW4.a.order_id(0x7fa2bd1ddc40)], [VIEW4.a.order_name(0x7fa2bd1ddde0)], [VIEW4.a.cust_id(0x7fa2bd1ddf80)], | | [VIEW4.a.use_type(0x7fa2bd1de120)], [VIEW4.a.state(0x7fa2bd1de2c0)], [VIEW4.a.state_date(0x7fa2bd1de460)], [VIEW4.a.dev_id(0x7fa2bd1de600)], [VIEW4.a.print_class(0x7fa2bd1de7a0)], | | [VIEW4.a.exec_print_flag(0x7fa2bd1de950)], [VIEW4.a.checked_flag(0x7fa2bd1deaf0)], [VIEW4.a.station_ver(0x7fa2bd1dec90)], [g.pay_method(0x7fa3a7cbdd10)], | | [g.amount(0x7fa3a7cbe060)], [g.bean_amt(0x7fa3a7cbe3b0)], [g.channel_amt(0x7fa3a7cbe700)], [subquery(1)(0x7fa3a7cbe8a0)], [d.station_id(0x7fa3a7c71a60)], | | [d.station_name(0x7fa3a7ceedb0)], [d.merchant_id(0x7fa3a7cef100)], [d.set_id(0x7fa3a7cef450)], [e.merchant_name(0x7fa3a7cef7a0)], [e.merchant_short_name(0x7fa3a7cefaf0)], | | [g.return_amt(0x7fa3a7cefe40)], [s.set_name(0x7fa3a7cf0190)], [VIEW4.a.checked_ops_name(0x7fa2bd1dee40)], [VIEW4.a.checked_time(0x7fa2bd1ec8f0)], [VIEW4.a.print_mode(0x7fa2bd1eca90)], | | [subquery(2)(0x7fa3a7cf0d20)], [subquery(3)(0x7fa3a7d04610)], [subquery(4)(0x7fa3a7d21300)], [subquery(5)(0x7fa3a7d38460)], [subquery(6)(0x7fa3a7d5d3f0)], | | [subquery(7)(0x7fa3a7d70ee0)], [subquery(8)(0x7fa3a7da3270)]), filter(nil), rowset=256 | | exec_params_([VIEW4.a.cust_id(0x7fa2bd1ddf80)(:0(0x7fa3a7ce0a90))], [s.total_set_id(0x7fa3a7d03de0)(:1(0x7fa3a7d03f70))], [VIEW4.a.order_id(0x7fa2bd1ddc40)(:2(0x7fa3a7d1ea90))], | | [VIEW4.a.order_id(0x7fa2bd1ddc40)(:3(0x7fa3a7d362d0))], [VIEW4.a.order_id(0x7fa2bd1ddc40)(:4(0x7fa3a7d5ca90))], [VIEW4.a.order_id(0x7fa2bd1ddc40)(:5(0x7fa3a7d704b0))], | | [VIEW4.a.order_id(0x7fa2bd1ddc40)(:6(0x7fa3a7d84060))], [VIEW4.a.order_id(0x7fa2bd1ddc40)(:7(0x7fa3a7db63e0))]), onetime_exprs_(nil), init_plan_idxs_(nil), | | use_batch=false | | 2 - output([VIEW4.a.create_time(0x7fa2bd1ddaa0)], [VIEW4.a.order_id(0x7fa2bd1ddc40)], [VIEW4.a.order_name(0x7fa2bd1ddde0)], [VIEW4.a.cust_id(0x7fa2bd1ddf80)], | | [VIEW4.a.use_type(0x7fa2bd1de120)], [VIEW4.a.state(0x7fa2bd1de2c0)], [VIEW4.a.state_date(0x7fa2bd1de460)], [VIEW4.a.dev_id(0x7fa2bd1de600)], [VIEW4.a.print_class(0x7fa2bd1de7a0)], | | [VIEW4.a.exec_print_flag(0x7fa2bd1de950)], [VIEW4.a.checked_flag(0x7fa2bd1deaf0)], [VIEW4.a.station_ver(0x7fa2bd1dec90)], [g.pay_method(0x7fa3a7cbdd10)], | | [g.amount(0x7fa3a7cbe060)], [g.bean_amt(0x7fa3a7cbe3b0)], [g.channel_amt(0x7fa3a7cbe700)], [d.station_id(0x7fa3a7c71a60)], [d.station_name(0x7fa3a7ceedb0)], | | [d.merchant_id(0x7fa3a7cef100)], [d.set_id(0x7fa3a7cef450)], [e.merchant_name(0x7fa3a7cef7a0)], [e.merchant_short_name(0x7fa3a7cefaf0)], [g.return_amt(0x7fa3a7cefe40)], | | [s.set_name(0x7fa3a7cf0190)], [VIEW4.a.checked_ops_name(0x7fa2bd1dee40)], [VIEW4.a.checked_time(0x7fa2bd1ec8f0)], [VIEW4.a.print_mode(0x7fa2bd1eca90)], | | [s.total_set_id(0x7fa3a7d03de0)]), filter(nil), rowset=256 | | 3 - output([VIEW4.a.create_time(0x7fa2bd1ddaa0)], [VIEW4.a.order_id(0x7fa2bd1ddc40)], [VIEW4.a.order_name(0x7fa2bd1ddde0)], [VIEW4.a.cust_id(0x7fa2bd1ddf80)], | | [VIEW4.a.use_type(0x7fa2bd1de120)], [VIEW4.a.state(0x7fa2bd1de2c0)], [VIEW4.a.state_date(0x7fa2bd1de460)], [VIEW4.a.dev_id(0x7fa2bd1de600)], [VIEW4.a.print_class(0x7fa2bd1de7a0)], | | [VIEW4.a.exec_print_flag(0x7fa2bd1de950)], [VIEW4.a.checked_flag(0x7fa2bd1deaf0)], [VIEW4.a.station_ver(0x7fa2bd1dec90)], [g.pay_method(0x7fa3a7cbdd10)], | | [g.amount(0x7fa3a7cbe060)], [g.bean_amt(0x7fa3a7cbe3b0)], [g.channel_amt(0x7fa3a7cbe700)], [d.station_id(0x7fa3a7c71a60)], [d.station_name(0x7fa3a7ceedb0)], | | [d.merchant_id(0x7fa3a7cef100)], [d.set_id(0x7fa3a7cef450)], [e.merchant_name(0x7fa3a7cef7a0)], [e.merchant_short_name(0x7fa3a7cefaf0)], [g.return_amt(0x7fa3a7cefe40)], | | [s.set_name(0x7fa3a7cf0190)], [VIEW4.a.checked_ops_name(0x7fa2bd1dee40)], [VIEW4.a.checked_time(0x7fa2bd1ec8f0)], [VIEW4.a.print_mode(0x7fa2bd1eca90)], | | [s.total_set_id(0x7fa3a7d03de0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 4 - output([VIEW4.a.create_time(0x7fa2bd1ddaa0)], [VIEW4.a.order_id(0x7fa2bd1ddc40)], [VIEW4.a.order_name(0x7fa2bd1ddde0)], [VIEW4.a.cust_id(0x7fa2bd1ddf80)], | | [VIEW4.a.use_type(0x7fa2bd1de120)], [VIEW4.a.state(0x7fa2bd1de2c0)], [VIEW4.a.state_date(0x7fa2bd1de460)], [VIEW4.a.dev_id(0x7fa2bd1de600)], [VIEW4.a.print_class(0x7fa2bd1de7a0)], | | [VIEW4.a.exec_print_flag(0x7fa2bd1de950)], [VIEW4.a.checked_flag(0x7fa2bd1deaf0)], [VIEW4.a.station_ver(0x7fa2bd1dec90)], [g.pay_method(0x7fa3a7cbdd10)], | | [g.amount(0x7fa3a7cbe060)], [g.bean_amt(0x7fa3a7cbe3b0)], [g.channel_amt(0x7fa3a7cbe700)], [d.station_id(0x7fa3a7c71a60)], [d.station_name(0x7fa3a7ceedb0)], | | [d.merchant_id(0x7fa3a7cef100)], [d.set_id(0x7fa3a7cef450)], [e.merchant_name(0x7fa3a7cef7a0)], [e.merchant_short_name(0x7fa3a7cefaf0)], [g.return_amt(0x7fa3a7cefe40)], | | [s.set_name(0x7fa3a7cf0190)], [VIEW4.a.checked_ops_name(0x7fa2bd1dee40)], [VIEW4.a.checked_time(0x7fa2bd1ec8f0)], [VIEW4.a.print_mode(0x7fa2bd1eca90)], | | [s.total_set_id(0x7fa3a7d03de0)]), filter(nil), rowset=256 | | conds(nil), nl_params_([VIEW4.a.pay_id(0x7fa2bd1dd5c0)(:11(0x7fa2892aad70))]), use_batch=true | | 5 - output([VIEW4.a.create_time(0x7fa2bd1ddaa0)], [VIEW4.a.order_id(0x7fa2bd1ddc40)], [VIEW4.a.order_name(0x7fa2bd1ddde0)], [VIEW4.a.cust_id(0x7fa2bd1ddf80)], | | [VIEW4.a.use_type(0x7fa2bd1de120)], [VIEW4.a.state(0x7fa2bd1de2c0)], [VIEW4.a.state_date(0x7fa2bd1de460)], [VIEW4.a.dev_id(0x7fa2bd1de600)], [VIEW4.a.print_class(0x7fa2bd1de7a0)], | | [VIEW4.a.exec_print_flag(0x7fa2bd1de950)], [VIEW4.a.checked_flag(0x7fa2bd1deaf0)], [VIEW4.a.station_ver(0x7fa2bd1dec90)], [d.station_id(0x7fa3a7c71a60)], | | [d.station_name(0x7fa3a7ceedb0)], [d.merchant_id(0x7fa3a7cef100)], [d.set_id(0x7fa3a7cef450)], [e.merchant_name(0x7fa3a7cef7a0)], [e.merchant_short_name(0x7fa3a7cefaf0)], | | [s.set_name(0x7fa3a7cf0190)], [VIEW4.a.checked_ops_name(0x7fa2bd1dee40)], [VIEW4.a.checked_time(0x7fa2bd1ec8f0)], [VIEW4.a.print_mode(0x7fa2bd1eca90)], | | [s.total_set_id(0x7fa3a7d03de0)], [VIEW4.a.pay_id(0x7fa2bd1dd5c0)]), filter(nil), rowset=256 | | conds(nil), nl_params_([VIEW4.a.station_id(0x7fa2bd1dd900)(:9(0x7fa289283490))]), use_batch=true | | 6 - output([VIEW4.a.create_time(0x7fa2bd1ddaa0)], [VIEW4.a.order_id(0x7fa2bd1ddc40)], [VIEW4.a.order_name(0x7fa2bd1ddde0)], [VIEW4.a.cust_id(0x7fa2bd1ddf80)], | | [VIEW4.a.use_type(0x7fa2bd1de120)], [VIEW4.a.state(0x7fa2bd1de2c0)], [VIEW4.a.state_date(0x7fa2bd1de460)], [VIEW4.a.dev_id(0x7fa2bd1de600)], [VIEW4.a.print_class(0x7fa2bd1de7a0)], | | [VIEW4.a.exec_print_flag(0x7fa2bd1de950)], [VIEW4.a.checked_flag(0x7fa2bd1deaf0)], [VIEW4.a.station_ver(0x7fa2bd1dec90)], [e.merchant_name(0x7fa3a7cef7a0)], | | [e.merchant_short_name(0x7fa3a7cefaf0)], [s.set_name(0x7fa3a7cf0190)], [VIEW4.a.checked_ops_name(0x7fa2bd1dee40)], [VIEW4.a.checked_time(0x7fa2bd1ec8f0)], | | [VIEW4.a.print_mode(0x7fa2bd1eca90)], [s.total_set_id(0x7fa3a7d03de0)], [VIEW4.a.pay_id(0x7fa2bd1dd5c0)], [VIEW4.a.station_id(0x7fa2bd1dd900)]), filter(nil), rowset=256 | | 7 - output([VIEW4.a.create_time(0x7fa2bd1ddaa0)], [VIEW4.a.order_id(0x7fa2bd1ddc40)], [VIEW4.a.order_name(0x7fa2bd1ddde0)], [VIEW4.a.cust_id(0x7fa2bd1ddf80)], | | [VIEW4.a.use_type(0x7fa2bd1de120)], [VIEW4.a.state(0x7fa2bd1de2c0)], [VIEW4.a.state_date(0x7fa2bd1de460)], [VIEW4.a.dev_id(0x7fa2bd1de600)], [VIEW4.a.print_class(0x7fa2bd1de7a0)], | | [VIEW4.a.exec_print_flag(0x7fa2bd1de950)], [VIEW4.a.checked_flag(0x7fa2bd1deaf0)], [VIEW4.a.station_ver(0x7fa2bd1dec90)], [e.merchant_name(0x7fa3a7cef7a0)], | | [e.merchant_short_name(0x7fa3a7cefaf0)], [s.set_name(0x7fa3a7cf0190)], [VIEW4.a.checked_ops_name(0x7fa2bd1dee40)], [VIEW4.a.checked_time(0x7fa2bd1ec8f0)], | | [VIEW4.a.print_mode(0x7fa2bd1eca90)], [s.total_set_id(0x7fa3a7d03de0)], [VIEW4.a.pay_id(0x7fa2bd1dd5c0)], [VIEW4.a.station_id(0x7fa2bd1dd900)]), filter(nil), rowset=256 | | is_single, dop=1 | | 8 - output([VIEW4.a.create_time(0x7fa2bd1ddaa0)], [VIEW4.a.order_id(0x7fa2bd1ddc40)], [VIEW4.a.order_name(0x7fa2bd1ddde0)], [VIEW4.a.cust_id(0x7fa2bd1ddf80)], | | [VIEW4.a.use_type(0x7fa2bd1de120)], [VIEW4.a.state(0x7fa2bd1de2c0)], [VIEW4.a.state_date(0x7fa2bd1de460)], [VIEW4.a.dev_id(0x7fa2bd1de600)], [VIEW4.a.print_class(0x7fa2bd1de7a0)], | | [VIEW4.a.exec_print_flag(0x7fa2bd1de950)], [VIEW4.a.checked_flag(0x7fa2bd1deaf0)], [VIEW4.a.station_ver(0x7fa2bd1dec90)], [e.merchant_name(0x7fa3a7cef7a0)], | | [e.merchant_short_name(0x7fa3a7cefaf0)], [s.set_name(0x7fa3a7cf0190)], [VIEW4.a.checked_ops_name(0x7fa2bd1dee40)], [VIEW4.a.checked_time(0x7fa2bd1ec8f0)], | | [VIEW4.a.print_mode(0x7fa2bd1eca90)], [s.total_set_id(0x7fa3a7d03de0)], [VIEW4.a.pay_id(0x7fa2bd1dd5c0)], [VIEW4.a.station_id(0x7fa2bd1dd900)]), filter(nil), rowset=256 | | equal_conds([VIEW4.a.set_id(0x7fa2bd1dd760) = s.set_id(0x7fa3a7c75390)(0x7fa3a7c75090)]), other_conds(nil) | | 9 - output([VIEW4.a.pay_id(0x7fa2bd1dd5c0)], [VIEW4.a.set_id(0x7fa2bd1dd760)], [VIEW4.a.station_id(0x7fa2bd1dd900)], [VIEW4.a.create_time(0x7fa2bd1ddaa0)], | | [VIEW4.a.order_id(0x7fa2bd1ddc40)], [VIEW4.a.order_name(0x7fa2bd1ddde0)], [VIEW4.a.cust_id(0x7fa2bd1ddf80)], [VIEW4.a.use_type(0x7fa2bd1de120)], [VIEW4.a.state(0x7fa2bd1de2c0)], | | [VIEW4.a.state_date(0x7fa2bd1de460)], [VIEW4.a.dev_id(0x7fa2bd1de600)], [VIEW4.a.print_class(0x7fa2bd1de7a0)], [VIEW4.a.exec_print_flag(0x7fa2bd1de950)], | | [VIEW4.a.checked_flag(0x7fa2bd1deaf0)], [VIEW4.a.station_ver(0x7fa2bd1dec90)], [VIEW4.a.checked_ops_name(0x7fa2bd1dee40)], [VIEW4.a.checked_time(0x7fa2bd1ec8f0)], | | [VIEW4.a.print_mode(0x7fa2bd1eca90)]), filter(nil), rowset=256 | | access([VIEW4.a.pay_id(0x7fa2bd1dd5c0)], [VIEW4.a.set_id(0x7fa2bd1dd760)], [VIEW4.a.station_id(0x7fa2bd1dd900)], [VIEW4.a.create_time(0x7fa2bd1ddaa0)], | | [VIEW4.a.order_id(0x7fa2bd1ddc40)], [VIEW4.a.order_name(0x7fa2bd1ddde0)], [VIEW4.a.cust_id(0x7fa2bd1ddf80)], [VIEW4.a.use_type(0x7fa2bd1de120)], [VIEW4.a.state(0x7fa2bd1de2c0)], | | [VIEW4.a.state_date(0x7fa2bd1de460)], [VIEW4.a.dev_id(0x7fa2bd1de600)], [VIEW4.a.print_class(0x7fa2bd1de7a0)], [VIEW4.a.exec_print_flag(0x7fa2bd1de950)], | | [VIEW4.a.checked_flag(0x7fa2bd1deaf0)], [VIEW4.a.station_ver(0x7fa2bd1dec90)], [VIEW4.a.checked_ops_name(0x7fa2bd1dee40)], [VIEW4.a.checked_time(0x7fa2bd1ec8f0)], | | [VIEW4.a.print_mode(0x7fa2bd1eca90)]) | | 10 - output([a.pay_id(0x7fa3a7c7aa40)], [a.set_id(0x7fa3a7c75200)], [a.station_id(0x7fa3a7c718d0)], [a.create_time(0x7fa3a7c7ba10)], [a.order_id(0x7fa3a7ca2b80)], | | [a.order_name(0x7fa3a7cb9af0)], [a.cust_id(0x7fa3a7cba000)], [a.use_type(0x7fa3a7cba350)], [a.state(0x7fa3a7cba6a0)], [a.state_date(0x7fa3a7cbabb0)], [a.dev_id(0x7fa3a7c744f0)], | | [a.print_class(0x7fa3a7cbcfd0)], [a.exec_print_flag(0x7fa3a7cbd320)], [a.checked_flag(0x7fa3a7cbd670)], [a.station_ver(0x7fa3a7cbd9c0)], [a.checked_ops_name(0x7fa3a7cf04e0)], | | [a.checked_time(0x7fa3a7cf0830)], [a.print_mode(0x7fa3a7cf0b80)]), filter(nil), rowset=256 | | limit(30(0x7fa20102e250)), offset(0(0x7fa20102e0f0)) | | 11 - output([a.pay_id(0x7fa3a7c7aa40)], [a.set_id(0x7fa3a7c75200)], [a.station_id(0x7fa3a7c718d0)], [a.create_time(0x7fa3a7c7ba10)], [a.order_id(0x7fa3a7ca2b80)], | | [a.order_name(0x7fa3a7cb9af0)], [a.cust_id(0x7fa3a7cba000)], [a.use_type(0x7fa3a7cba350)], [a.state(0x7fa3a7cba6a0)], [a.state_date(0x7fa3a7cbabb0)], [a.dev_id(0x7fa3a7c744f0)], | | [a.print_class(0x7fa3a7cbcfd0)], [a.exec_print_flag(0x7fa3a7cbd320)], [a.checked_flag(0x7fa3a7cbd670)], [a.station_ver(0x7fa3a7cbd9c0)], [a.checked_ops_name(0x7fa3a7cf04e0)], | | [a.checked_time(0x7fa3a7cf0830)], [a.print_mode(0x7fa3a7cf0b80)]), filter(nil), rowset=256 | | sort_keys([a.create_time(0x7fa3a7c7ba10), DESC], [a.order_id(0x7fa3a7ca2b80), DESC]), topn(30(0x7fa20102e250) + 0(0x7fa20102e0f0)(0x7fa289229d70)) | | 12 - output([a.pay_id(0x7fa3a7c7aa40)], [a.set_id(0x7fa3a7c75200)], [a.station_id(0x7fa3a7c718d0)], [a.create_time(0x7fa3a7c7ba10)], [a.order_id(0x7fa3a7ca2b80)], | | [a.order_name(0x7fa3a7cb9af0)], [a.cust_id(0x7fa3a7cba000)], [a.use_type(0x7fa3a7cba350)], [a.state(0x7fa3a7cba6a0)], [a.state_date(0x7fa3a7cbabb0)], [a.dev_id(0x7fa3a7c744f0)], | | [a.print_class(0x7fa3a7cbcfd0)], [a.exec_print_flag(0x7fa3a7cbd320)], [a.checked_flag(0x7fa3a7cbd670)], [a.station_ver(0x7fa3a7cbd9c0)], [a.checked_ops_name(0x7fa3a7cf04e0)], | | [a.checked_time(0x7fa3a7cf0830)], [a.print_mode(0x7fa3a7cf0b80)]), filter(nil), rowset=256 | | equal_conds([VIEW3.VIEW1.s.order_id(0x7fa201093090) = a.order_id(0x7fa3a7ca2b80)(0x7fa201093220)]), other_conds(nil) | | 13 - output([VIEW3.VIEW1.s.order_id(0x7fa201093090)]), filter(nil), rowset=256 | | access([VIEW3.VIEW1.s.order_id(0x7fa201093090)]) | | 14 - output([UNION([1])(0x7fa2010929c0)]), filter(nil), rowset=256 | | 15 - output([s.order_id(0x7fa3a7ca29f0)]), filter(nil), rowset=256 | | 16 - output([s.order_id(0x7fa3a7ca29f0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 17 - output([s.order_id(0x7fa3a7ca29f0)]), filter([(T_OP_LIKE, s.err_msg(0x7fa3a7ca3460), CONCAT('%'(0x7fa3a7ca3bd0), '重复'(0x7fa3a7ca3d20), '%'(0x7fa3a7ca3e70))(0x7fa3a7ca3a60), | | '\\')(0x7fa3a7ca3760)], [s.err_msg(0x7fa3a7ca3460) != ''(0x7fa3a7ca31a0)(0x7fa3a7ca32f0)]), rowset=256 | | access([s.order_id(0x7fa3a7ca29f0)], [s.err_msg(0x7fa3a7ca3460)]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false,false], | | range_key([s.order_file_id(0x7fa201035040)]), range(MIN ; MAX)always true | | 18 - output([s.order_id(0x7fa3a7cb7140)]), filter([(T_OP_LIKE, s.problem_desc(0x7fa3a7cb7a20), CONCAT('%'(0x7fa3a7cb8190), '重复'(0x7fa3a7cb82e0), '%'(0x7fa3a7cb8430))(0x7fa3a7cb8020), | | '\\')(0x7fa3a7cb7d20)], [s.problem_desc(0x7fa3a7cb7a20) != ''(0x7fa3a7cb7760)(0x7fa3a7cb78b0)]), rowset=256 | | access([s.order_id(0x7fa3a7cb7140)], [s.problem_desc(0x7fa3a7cb7a20)]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false,false], | | range_key([s.return_id(0x7fa201035450)]), range(MIN ; MAX)always true | | 19 - output([a.pay_id(0x7fa3a7c7aa40)], [a.set_id(0x7fa3a7c75200)], [a.station_id(0x7fa3a7c718d0)], [a.create_time(0x7fa3a7c7ba10)], [a.order_id(0x7fa3a7ca2b80)], | | [a.order_name(0x7fa3a7cb9af0)], [a.cust_id(0x7fa3a7cba000)], [a.use_type(0x7fa3a7cba350)], [a.state(0x7fa3a7cba6a0)], [a.state_date(0x7fa3a7cbabb0)], [a.dev_id(0x7fa3a7c744f0)], | | [a.print_class(0x7fa3a7cbcfd0)], [a.exec_print_flag(0x7fa3a7cbd320)], [a.checked_flag(0x7fa3a7cbd670)], [a.station_ver(0x7fa3a7cbd9c0)], [a.checked_ops_name(0x7fa3a7cf04e0)], | | [a.checked_time(0x7fa3a7cf0830)], [a.print_mode(0x7fa3a7cf0b80)]), filter(nil), rowset=256 | | 20 - output([a.pay_id(0x7fa3a7c7aa40)], [a.set_id(0x7fa3a7c75200)], [a.station_id(0x7fa3a7c718d0)], [a.create_time(0x7fa3a7c7ba10)], [a.order_id(0x7fa3a7ca2b80)], | | [a.order_name(0x7fa3a7cb9af0)], [a.cust_id(0x7fa3a7cba000)], [a.use_type(0x7fa3a7cba350)], [a.state(0x7fa3a7cba6a0)], [a.state_date(0x7fa3a7cbabb0)], [a.dev_id(0x7fa3a7c744f0)], | | [a.print_class(0x7fa3a7cbcfd0)], [a.exec_print_flag(0x7fa3a7cbd320)], [a.checked_flag(0x7fa3a7cbd670)], [a.station_ver(0x7fa3a7cbd9c0)], [a.checked_ops_name(0x7fa3a7cf04e0)], | | [a.checked_time(0x7fa3a7cf0830)], [a.print_mode(0x7fa3a7cf0b80)]), filter(nil), rowset=256 | | is_single, dop=1 | | 21 - output([a.order_id(0x7fa3a7ca2b80)], [a.station_id(0x7fa3a7c718d0)], [a.dev_id(0x7fa3a7c744f0)], [a.set_id(0x7fa3a7c75200)], [a.pay_id(0x7fa3a7c7aa40)], | | [a.create_time(0x7fa3a7c7ba10)], [a.order_name(0x7fa3a7cb9af0)], [a.cust_id(0x7fa3a7cba000)], [a.use_type(0x7fa3a7cba350)], [a.state(0x7fa3a7cba6a0)], | | [a.state_date(0x7fa3a7cbabb0)], [a.print_class(0x7fa3a7cbcfd0)], [a.exec_print_flag(0x7fa3a7cbd320)], [a.checked_flag(0x7fa3a7cbd670)], [a.station_ver(0x7fa3a7cbd9c0)], | | [a.checked_ops_name(0x7fa3a7cf04e0)], [a.checked_time(0x7fa3a7cf0830)], [a.print_mode(0x7fa3a7cf0b80)]), filter([a.station_id(0x7fa3a7c718d0) IS NOT NULL(0x7fa3a7cb94b0)]), rowset=256 | | access([a.order_id(0x7fa3a7ca2b80)], [a.station_id(0x7fa3a7c718d0)], [a.dev_id(0x7fa3a7c744f0)], [a.set_id(0x7fa3a7c75200)], [a.pay_id(0x7fa3a7c7aa40)], | | [a.create_time(0x7fa3a7c7ba10)], [a.order_name(0x7fa3a7cb9af0)], [a.cust_id(0x7fa3a7cba000)], [a.use_type(0x7fa3a7cba350)], [a.state(0x7fa3a7cba6a0)], | | [a.state_date(0x7fa3a7cbabb0)], [a.print_class(0x7fa3a7cbcfd0)], [a.exec_print_flag(0x7fa3a7cbd320)], [a.checked_flag(0x7fa3a7cbd670)], [a.station_ver(0x7fa3a7cbd9c0)], | | [a.checked_ops_name(0x7fa3a7cf04e0)], [a.checked_time(0x7fa3a7cf0830)], [a.print_mode(0x7fa3a7cf0b80)]), partitions(p0) | | is_index_back=true, is_global_index=false, filter_before_indexback[false], | | range_key([a.create_time(0x7fa3a7c7ba10)], [a.order_id(0x7fa3a7ca2b80)]), range(2025-09-23 00:00:00.000000,MIN ; 2025-09-23 23:59:59.000000,MAX), | | | | range_cond([a.create_time(0x7fa3a7c7ba10) >= cast('2025-09-23 00:00:00'(0x7fa284018050), MYSQL_DATETIME(-1, -1))(0x7fa284017de0)(0x7fa284017b70)], | | [a.create_time(0x7fa3a7c7ba10) <= cast('2025-09-23 23:59:59'(0x7fa284018830), MYSQL_DATETIME(-1, -1))(0x7fa2840185c0)(0x7fa284018350)]) | | 22 - output([e.merchant_name(0x7fa3a7cef7a0)], [e.merchant_short_name(0x7fa3a7cefaf0)], [s.set_name(0x7fa3a7cf0190)], [s.total_set_id(0x7fa3a7d03de0)], | | [s.set_id(0x7fa3a7c75390)]), filter(nil), rowset=256 | | equal_conds([s.merchant_id(0x7fa3a7c77e20) = e.merchant_id(0x7fa3a7c77fb0)(0x7fa3a7c77cb0)]), other_conds(nil) | | 23 - output([e.merchant_id(0x7fa3a7c77fb0)], [e.merchant_name(0x7fa3a7cef7a0)], [e.merchant_short_name(0x7fa3a7cefaf0)]), filter(nil), rowset=256 | | access([e.merchant_id(0x7fa3a7c77fb0)], [e.merchant_name(0x7fa3a7cef7a0)], [e.merchant_short_name(0x7fa3a7cefaf0)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([e.merchant_id(0x7fa3a7c77fb0)]), range(MIN ; MAX)always true | | 24 - output([s.set_name(0x7fa3a7cf0190)], [s.total_set_id(0x7fa3a7d03de0)], [s.set_id(0x7fa3a7c75390)], [s.merchant_id(0x7fa3a7c77e20)]), filter(nil), rowset=256 | | 25 - output([s.set_name(0x7fa3a7cf0190)], [s.total_set_id(0x7fa3a7d03de0)], [s.set_id(0x7fa3a7c75390)], [s.merchant_id(0x7fa3a7c77e20)]), filter(nil), rowset=256 | | is_single, dop=1 | | 26 - output([s.set_id(0x7fa3a7c75390)], [s.merchant_id(0x7fa3a7c77e20)], [s.set_name(0x7fa3a7cf0190)], [s.total_set_id(0x7fa3a7d03de0)]), filter(nil), rowset=256 | | access([s.set_id(0x7fa3a7c75390)], [s.merchant_id(0x7fa3a7c77e20)], [s.set_name(0x7fa3a7cf0190)], [s.total_set_id(0x7fa3a7d03de0)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([s.set_id(0x7fa3a7c75390)]), range(MIN ; MAX)always true | | 27 - output([d.station_id(0x7fa3a7c71a60)], [d.station_name(0x7fa3a7ceedb0)], [d.merchant_id(0x7fa3a7cef100)], [d.set_id(0x7fa3a7cef450)]), filter(nil), rowset=256 | | access([GROUP_ID(0x7fa50d5f0d10)], [d.station_id(0x7fa3a7c71a60)], [d.station_name(0x7fa3a7ceedb0)], [d.merchant_id(0x7fa3a7cef100)], [d.set_id(0x7fa3a7cef450)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([d.station_id(0x7fa3a7c71a60)]), range(MIN ; MAX), | | range_cond([:9(0x7fa289283490) = d.station_id(0x7fa3a7c71a60)(0x7fa284018b30)]), is_fast_range = true | | 28 - output([g.pay_method(0x7fa3a7cbdd10)], [g.amount(0x7fa3a7cbe060)], [g.bean_amt(0x7fa3a7cbe3b0)], [g.channel_amt(0x7fa3a7cbe700)], [g.return_amt(0x7fa3a7cefe40)]), filter(nil), rowset=256 | | access([GROUP_ID(0x7fa284007e70)], [g.pay_method(0x7fa3a7cbdd10)], [g.amount(0x7fa3a7cbe060)], [g.bean_amt(0x7fa3a7cbe3b0)], [g.channel_amt(0x7fa3a7cbe700)], | | [g.return_amt(0x7fa3a7cefe40)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([g.pay_id(0x7fa3a7c7abd0)]), range(MIN ; MAX), | | range_cond([:11(0x7fa2892aad70) = g.pay_id(0x7fa3a7c7abd0)(0x7fa284018d70)]), is_fast_range = true | | 29 - output([cust.mobile(0x7fa3a7ce0f30)]), filter(nil), rowset=256 | | access([cust.mobile(0x7fa3a7ce0f30)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([cust.cust_id(0x7fa3a7ce0900)]), range(MIN ; MAX)always true, | | range_cond([cust.cust_id(0x7fa3a7ce0900) = :0(0x7fa3a7ce0a90)(0x7fa284018fb0)]), is_fast_range = true | | 30 - output([w.total_set_name(0x7fa3a7d04410)]), filter(nil), rowset=256 | | 31 - output([w.total_set_name(0x7fa3a7d04410)]), filter(nil), rowset=256 | | is_single, dop=1 | | 32 - output([w.total_set_name(0x7fa3a7d04410)]), filter(nil), rowset=256 | | access([w.total_set_name(0x7fa3a7d04410)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([w.total_set_id(0x7fa3a7d03c50)]), range(MIN ; MAX)always true, | | range_cond([w.total_set_id(0x7fa3a7d03c50) = :1(0x7fa3a7d03f70)(0x7fa2840191f0)]), is_fast_range = true | | 33 - output([T_FUN_SUM(g.printed_page(0x7fa3a7d1f1a0))(0x7fa3a7d1ed80)]), filter(nil), rowset=256 | | 34 - output([T_FUN_SUM(g.printed_page(0x7fa3a7d1f1a0))(0x7fa3a7d1ed80)]), filter(nil), rowset=256 | | is_single, dop=1 | | 35 - output([T_FUN_SUM(g.printed_page(0x7fa3a7d1f1a0))(0x7fa3a7d1ed80)]), filter(nil), rowset=256 | | group(nil), agg_func([T_FUN_SUM(g.printed_page(0x7fa3a7d1f1a0))(0x7fa3a7d1ed80)]) | | 36 - output([g.printed_page(0x7fa3a7d1f1a0)]), filter(nil), rowset=256 | | access([g.order_file_id(0x7fa201035960)], [g.printed_page(0x7fa3a7d1f1a0)]), partitions(p0) | | is_index_back=true, is_global_index=false, | | range_key([g.order_id(0x7fa3a7d1e900)], [g.order_file_id(0x7fa201035960)]), range(MIN,MIN ; MAX,MAX)always true, | | range_cond([g.order_id(0x7fa3a7d1e900) = :2(0x7fa3a7d1ea90)(0x7fa284019430)]), is_fast_range = true | | 37 - output([T_FUN_SUM(CEILING(cast(g.page_num(0x7fa3a7d37270), DECIMAL_INT(27, 16))(0x7fa3a7d379e0) / cast(g.shrink_plate_num(0x7fa3a7d37400), DECIMAL_INT(4, | | 0))(0x7fa3a7d37db0)(0x7fa3a7d36ce0))(0x7fa3a7d36820) * g.copy_num(0x7fa3a7d37590)(0x7fa3a7d370c0))(0x7fa3a7d365c0)]), filter(nil), rowset=256 | | 38 - output([T_FUN_SUM(CEILING(cast(g.page_num(0x7fa3a7d37270), DECIMAL_INT(27, 16))(0x7fa3a7d379e0) / cast(g.shrink_plate_num(0x7fa3a7d37400), DECIMAL_INT(4, | | 0))(0x7fa3a7d37db0)(0x7fa3a7d36ce0))(0x7fa3a7d36820) * g.copy_num(0x7fa3a7d37590)(0x7fa3a7d370c0))(0x7fa3a7d365c0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 39 - output([T_FUN_SUM(CEILING(cast(g.page_num(0x7fa3a7d37270), DECIMAL_INT(27, 16))(0x7fa3a7d379e0) / cast(g.shrink_plate_num(0x7fa3a7d37400), DECIMAL_INT(4, | | 0))(0x7fa3a7d37db0)(0x7fa3a7d36ce0))(0x7fa3a7d36820) * g.copy_num(0x7fa3a7d37590)(0x7fa3a7d370c0))(0x7fa3a7d365c0)]), filter(nil), rowset=256 | | group(nil), agg_func([T_FUN_SUM(CEILING(cast(g.page_num(0x7fa3a7d37270), DECIMAL_INT(27, 16))(0x7fa3a7d379e0) / cast(g.shrink_plate_num(0x7fa3a7d37400), | | DECIMAL_INT(4, 0))(0x7fa3a7d37db0)(0x7fa3a7d36ce0))(0x7fa3a7d36820) * g.copy_num(0x7fa3a7d37590)(0x7fa3a7d370c0))(0x7fa3a7d365c0)]) | | 40 - output([g.page_num(0x7fa3a7d37270)], [g.shrink_plate_num(0x7fa3a7d37400)], [g.copy_num(0x7fa3a7d37590)]), filter(nil), rowset=256 | | access([g.order_file_id(0x7fa201035bb0)], [g.page_num(0x7fa3a7d37270)], [g.shrink_plate_num(0x7fa3a7d37400)], [g.copy_num(0x7fa3a7d37590)]), partitions(p0) | | is_index_back=true, is_global_index=false, | | range_key([g.order_id(0x7fa3a7d36140)], [g.order_file_id(0x7fa201035bb0)]), range(MIN,MIN ; MAX,MAX)always true, | | range_cond([g.order_id(0x7fa3a7d36140) = :3(0x7fa3a7d362d0)(0x7fa284019670)]), is_fast_range = true | | 41 - output([T_FUN_SUM(g.if_color(0x7fa3a7d5d1a0))(0x7fa3a7d5cd80)]), filter(nil), rowset=256 | | 42 - output([T_FUN_SUM(g.if_color(0x7fa3a7d5d1a0))(0x7fa3a7d5cd80)]), filter(nil), rowset=256 | | is_single, dop=1 | | 43 - output([T_FUN_SUM(g.if_color(0x7fa3a7d5d1a0))(0x7fa3a7d5cd80)]), filter(nil), rowset=256 | | group(nil), agg_func([T_FUN_SUM(g.if_color(0x7fa3a7d5d1a0))(0x7fa3a7d5cd80)]) | | 44 - output([g.if_color(0x7fa3a7d5d1a0)]), filter(nil), rowset=256 | | access([g.order_file_id(0x7fa201036180)], [g.if_color(0x7fa3a7d5d1a0)]), partitions(p0) | | is_index_back=true, is_global_index=false, | | range_key([g.order_id(0x7fa3a7d5c900)], [g.order_file_id(0x7fa201036180)]), range(MIN,MIN ; MAX,MAX)always true, | | range_cond([g.order_id(0x7fa3a7d5c900) = :4(0x7fa3a7d5ca90)(0x7fa2840198b0)]), is_fast_range = true | | 45 - output([T_FUN_COUNT_SUM(T_FUN_COUNT(*)(0x7fa3a7d707a0))(0x7fa50d5462a0)]), filter(nil), rowset=256 | | 46 - output([T_FUN_COUNT_SUM(T_FUN_COUNT(*)(0x7fa3a7d707a0))(0x7fa50d5462a0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 47 - output([T_FUN_COUNT_SUM(T_FUN_COUNT(*)(0x7fa3a7d707a0))(0x7fa50d5462a0)]), filter(nil), rowset=256 | | group(nil), agg_func([T_FUN_COUNT_SUM(T_FUN_COUNT(*)(0x7fa3a7d707a0))(0x7fa50d5462a0)]) | | 48 - output([T_FUN_COUNT(*)(0x7fa3a7d707a0)]), filter(nil), rowset=256 | | access(nil), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([g.order_id(0x7fa3a7d70320)], [g.order_file_id(0x7fa2010363d0)]), range(MIN,MIN ; MAX,MAX)always true, | | range_cond([g.order_id(0x7fa3a7d70320) = :5(0x7fa3a7d704b0)(0x7fa3a7d701b0)]), is_fast_range = true, | | pushdown_aggregation([T_FUN_COUNT(*)(0x7fa3a7d707a0)]) | | 49 - output([T_FUN_GROUP_CONCAT(CONCAT(cast(t.file_id(0x7fa3a7d855e0), VARCHAR(1048576))(0x7fa3a7d85930), ':'(0x7fa3a7d85060), t.err_msg(0x7fa3a7d847b0))(0x7fa3a7d84d40)) | | separator_param_expr(';$$$'(0x7fa3a7d85440))(0x7fa3a7d84ae0)]), filter(nil), rowset=256 | | 50 - output([T_FUN_GROUP_CONCAT(CONCAT(cast(t.file_id(0x7fa3a7d855e0), VARCHAR(1048576))(0x7fa3a7d85930), ':'(0x7fa3a7d85060), t.err_msg(0x7fa3a7d847b0))(0x7fa3a7d84d40)) | | separator_param_expr(';$$$'(0x7fa3a7d85440))(0x7fa3a7d84ae0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 51 - output([T_FUN_GROUP_CONCAT(CONCAT(cast(t.file_id(0x7fa3a7d855e0), VARCHAR(1048576))(0x7fa3a7d85930), ':'(0x7fa3a7d85060), t.err_msg(0x7fa3a7d847b0))(0x7fa3a7d84d40)) | | separator_param_expr(';$$$'(0x7fa3a7d85440))(0x7fa3a7d84ae0)]), filter(nil), rowset=256 | | group(nil), agg_func([T_FUN_GROUP_CONCAT(CONCAT(cast(t.file_id(0x7fa3a7d855e0), VARCHAR(1048576))(0x7fa3a7d85930), ':'(0x7fa3a7d85060), t.err_msg(0x7fa3a7d847b0))(0x7fa3a7d84d40)) | | separator_param_expr(';$$$'(0x7fa3a7d85440))(0x7fa3a7d84ae0)]) | | 52 - output([t.err_msg(0x7fa3a7d847b0)], [t.file_id(0x7fa3a7d855e0)]), filter([t.err_msg(0x7fa3a7d847b0) != ''(0x7fa3a7d844f0)(0x7fa3a7d84640)]), rowset=256 | | access([t.order_file_id(0x7fa201036620)], [t.err_msg(0x7fa3a7d847b0)], [t.file_id(0x7fa3a7d855e0)]), partitions(p0) | | is_index_back=true, is_global_index=false, filter_before_indexback[false], | | range_key([t.order_id(0x7fa3a7d83ed0)], [t.file_id(0x7fa3a7d855e0)], [t.order_file_id(0x7fa201036620)]), range(MIN,MIN,MIN ; MAX,MAX,MAX)always true, | | | | range_cond([t.order_id(0x7fa3a7d83ed0) = :6(0x7fa3a7d84060)(0x7fa284019af0)]), is_fast_range = true | | 53 - output([T_FUN_GROUP_CONCAT(CONCAT('退款描述'(0x7fa3a7db7240), cast(t.return_id(0x7fa3a7db7ad0), VARCHAR(1048576))(0x7fa3a7db7e60), ':'(0x7fa3a7db7540), | | t.problem_desc(0x7fa3a7db6b30))(0x7fa3a7db70c0)) separator_param_expr(';$$$'(0x7fa3a7db7920))(0x7fa3a7db6e60)]), filter(nil), rowset=256 | | group(nil), agg_func([T_FUN_GROUP_CONCAT(CONCAT('退款描述'(0x7fa3a7db7240), cast(t.return_id(0x7fa3a7db7ad0), VARCHAR(1048576))(0x7fa3a7db7e60), | | ':'(0x7fa3a7db7540), t.problem_desc(0x7fa3a7db6b30))(0x7fa3a7db70c0)) separator_param_expr(';$$$'(0x7fa3a7db7920))(0x7fa3a7db6e60)]) | | 54 - output([t.return_id(0x7fa3a7db7ad0)], [t.problem_desc(0x7fa3a7db6b30)]), filter([t.problem_desc(0x7fa3a7db6b30) != ''(0x7fa3a7db6870)(0x7fa3a7db69c0)]), rowset=256 | | access([t.return_id(0x7fa3a7db7ad0)], [t.problem_desc(0x7fa3a7db6b30)]), partitions(p0) | | is_index_back=true, is_global_index=false, filter_before_indexback[false], | | range_key([t.order_id(0x7fa3a7db6250)], [t.return_id(0x7fa3a7db7ad0)]), range(MIN,MIN ; MAX,MAX)always true, | | range_cond([t.order_id(0x7fa3a7db6250) = :7(0x7fa3a7db63e0)(0x7fa284019d30)]), is_fast_range = true | | Used Hint: | | ------------------------------------- | | /*+ | | | | NO_USE_DAS(@"SEL$3" "s"@"SEL$3") | | NO_USE_DAS(@"SEL$4" "s"@"SEL$4") | | */ | | Qb name trace: | | ------------------------------------- | | stmt_id:0, stmt_type:T_EXPLAIN | | stmt_id:1, SEL$1 > SEL$F8C4A4E7 | | stmt_id:2, SEL$2 > SEL$A3D39CCF > SEL$2500BE6D > SEL$FB402869 > SEL$810145F0 > SEL$4934EF32 > SEL$39525290 | | stmt_id:3, SEL$3 | | stmt_id:4, SEL$4 | | stmt_id:5, SEL$5 | | stmt_id:6, SEL$6 | | stmt_id:7, SEL$7 | | stmt_id:8, SEL$8 | | stmt_id:9, SEL$9 | | stmt_id:10, SEL$10 > SEL$BDFD150D | | stmt_id:11, SEL$11 | | stmt_id:12, SEL$12 | | stmt_id:13, parent:SEL$A3D39CCF > SET$2DD2A5F2 > SET$4F3B16EA | | stmt_id:14, parent:SEL$2500BE6D > SEL$DDCA7861 | | stmt_id:15, parent:SEL$2500BE6D > SEL$DDCA7862 | | stmt_id:16, parent:SEL$4934EF32 > SEL$3952528F | | Outline Data: | | ------------------------------------- | | /*+ | | BEGIN_OUTLINE_DATA | | PQ_SUBQUERY(@"SEL$39525290" ("SEL$5" "SEL$6" "SEL$7" "SEL$8" "SEL$9" "SEL$BDFD150D" "SEL$11" "SEL$12") LOCAL LOCAL) | | LEADING(@"SEL$39525290" ((("VIEW4"@"SEL$4934EF32" ("e"@"SEL$2" "s"@"SEL$2")) "d"@"SEL$2") "g"@"SEL$2")) | | USE_NL(@"SEL$39525290" "g"@"SEL$2") | | USE_NL(@"SEL$39525290" "d"@"SEL$2") | | PQ_DISTRIBUTE(@"SEL$39525290" "d"@"SEL$2" BC2HOST NONE) | | USE_HASH(@"SEL$39525290" ("s"@"SEL$2" "e"@"SEL$2")) | | LEADING(@"SEL$3952528F" ("VIEW3"@"SEL$2500BE6D" "a"@"SEL$2")) | | USE_HASH(@"SEL$3952528F" "a"@"SEL$2") | | PQ_DISTRIBUTE(@"SEL$3952528F" "a"@"SEL$2" LOCAL LOCAL) | | PQ_SET(@"SET$4F3B16EA" LOCAL LOCAL) | | FULL(@"SEL$3" "s"@"SEL$3") | | FULL(@"SEL$4" "s"@"SEL$4") | | INDEX_DESC(@"SEL$3952528F" "a"@"SEL$2" "idx_2") | | USE_HASH(@"SEL$39525290" "s"@"SEL$2") | | PQ_DISTRIBUTE(@"SEL$39525290" "s"@"SEL$2" LOCAL LOCAL) | | FULL(@"SEL$39525290" "e"@"SEL$2") | | FULL(@"SEL$39525290" "s"@"SEL$2") | | INDEX(@"SEL$39525290" "d"@"SEL$2" "primary") | | INDEX(@"SEL$39525290" "g"@"SEL$2" "primary") | | INDEX(@"SEL$5" "cust"@"SEL$5" "primary") | | INDEX(@"SEL$6" "w"@"SEL$6" "primary") | | INDEX(@"SEL$7" "g"@"SEL$7" "idx_1") | | INDEX(@"SEL$8" "g"@"SEL$8" "idx_1") | | INDEX(@"SEL$9" "g"@"SEL$9" "idx_1") | | INDEX(@"SEL$BDFD150D" "g"@"SEL$10" "idx_1") | | INDEX(@"SEL$11" "t"@"SEL$11" "i_order_id") | | INDEX(@"SEL$12" "t"@"SEL$12" "idx_order_id") | | SIMPLIFY_EXPR(@"SEL$2") | | SIMPLIFY_EXPR(@"SEL$1") | | SIMPLIFY_GROUP_BY(@"SEL$10") | | COALESCE_SQ(@"SEL$A3D39CCF" ("SEL$3", "SEL$4")) | | UNNEST(@"SET$2DD2A5F2") | | MERGE(@"SET$2DD2A5F2" < "SEL$DDCA7861") | | MERGE(@"SEL$FB402869" < "SEL$F8C4A4E7") | | ELIMINATE_JOIN(@"SEL$810145F0" "c"@"SEL$2") | | PUSH_LIMIT(@"SEL$4934EF32") | | OPTIMIZER_FEATURES_ENABLE('4.3.5.3') | | END_OUTLINE_DATA | | */ | | Optimization Info: | | ------------------------------------- | | s: | | table_rows:591109 | | physical_range_rows:626195 | | logical_range_rows:625025 | | index_back_rows:0 | | output_rows:191319 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[i_order_id, t_order_file_msg] | | pruned_index_name:[i_order_id] | | stats info:[version=2025-09-18 22:02:20.024632, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS, STORAGE] | | s: | | table_rows:1020661 | | physical_range_rows:1041954 | | logical_range_rows:1041872 | | index_back_rows:0 | | output_rows:11239 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[idx_2, idx_order_id, idx_return_audit_time, t_order_return] | | pruned_index_name:[idx_2, idx_order_id, idx_return_audit_time] | | stats info:[version=2025-08-14 18:38:38.085277, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS, STORAGE] | | a: | | table_rows:6768587 | | physical_range_rows:75004 | | logical_range_rows:75004 | | index_back_rows:75004 | | output_rows:73935 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[idx_1, idx_2, idx_3, idx_6, idx_7, idx_8, idx_dev_id, idx_exec_print_time, idx_group, idx_merchant_id, idx_set_id, idx_10, idx_9, i_station_create_time, t_order] | | pruned_index_name:[idx_1, idx_3, idx_6, idx_7, idx_8, idx_dev_id, idx_exec_print_time, idx_group, idx_merchant_id, idx_set_id, idx_10, idx_9, i_station_create_time] | | stats info:[version=2025-09-22 22:01:07.523453, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS, STORAGE] | | e: | | table_rows:58 | | physical_range_rows:59 | | logical_range_rows:59 | | index_back_rows:0 | | output_rows:59 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[t_merchant] | | stats info:[version=2025-09-01 22:01:01.092774, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS, STORAGE] | | s: | | table_rows:333 | | physical_range_rows:337 | | logical_range_rows:337 | | index_back_rows:0 | | output_rows:337 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[idx_1, idx_real_merchant_id, idx_total_set_id, t_set] | | pruned_index_name:[idx_real_merchant_id, idx_total_set_id] | | stats info:[version=2025-09-14 22:01:33.278220, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS, STORAGE] | | d: | | table_rows:2205 | | physical_range_rows:1 | | logical_range_rows:1 | | index_back_rows:0 | | output_rows:1 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[idx_set_id, t_station] | | pruned_index_name:[idx_set_id] | | stats info:[version=2025-09-23 17:14:01.872868, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS] | | g: | | table_rows:10516137 | | physical_range_rows:1 | | logical_range_rows:1 | | index_back_rows:0 | | output_rows:1 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[udx_1, idx_2, idx_3, idx_4, idx_6, i_state, udx_5, t_pay] | | pruned_index_name:[udx_1, idx_2, idx_3, idx_4, idx_6, i_state, udx_5] | | stats info:[version=2025-09-21 22:02:45.875288, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS] | | cust: | | table_rows:3811082 | | physical_range_rows:1 | | logical_range_rows:1 | | index_back_rows:0 | | output_rows:1 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[idx_2, idx_set_id, udx_moblie_henant, t_cust] | | pruned_index_name:[idx_2, idx_set_id, udx_moblie_henant] | | stats info:[version=2025-09-21 22:00:50.079900, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS, STORAGE] | | w: | | table_rows:211 | | physical_range_rows:1 | | logical_range_rows:1 | | index_back_rows:0 | | output_rows:1 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[t_total_set] | | stats info:[version=2025-08-14 18:46:44.758155, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS, STORAGE] | | g: | | table_rows:17230673 | | physical_range_rows:4 | | logical_range_rows:4 | | index_back_rows:4 | | output_rows:4 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[idx_1, idx_2, idx_3, idx_4, idx_print_state, idx_update_time, idx_update_time_speed, t_order_file] | | pruned_index_name:[idx_2, idx_3, idx_4, idx_print_state, idx_update_time, idx_update_time_speed] | | unstable_index_name:[t_order_file] | | stats info:[version=2025-09-22 22:01:36.920892, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS, STORAGE] | | g: | | table_rows:17230673 | | physical_range_rows:4 | | logical_range_rows:4 | | index_back_rows:4 | | output_rows:4 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[idx_1, idx_2, idx_3, idx_4, idx_print_state, idx_update_time, idx_update_time_speed, t_order_file] | | pruned_index_name:[idx_2, idx_3, idx_4, idx_print_state, idx_update_time, idx_update_time_speed] | | unstable_index_name:[t_order_file] | | stats info:[version=2025-09-22 22:01:36.920892, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS, STORAGE] | | g: | | table_rows:17230673 | | physical_range_rows:4 | | logical_range_rows:4 | | index_back_rows:4 | | output_rows:4 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[idx_1, idx_2, idx_3, idx_4, idx_print_state, idx_update_time, idx_update_time_speed, t_order_file] | | pruned_index_name:[idx_2, idx_3, idx_4, idx_print_state, idx_update_time, idx_update_time_speed] | | unstable_index_name:[t_order_file] | | stats info:[version=2025-09-22 22:01:36.920892, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS, STORAGE] | | g: | | table_rows:17230673 | | physical_range_rows:4 | | logical_range_rows:4 | | index_back_rows:0 | | output_rows:4 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[idx_1, idx_2, idx_3, idx_4, idx_print_state, idx_update_time, idx_update_time_speed, t_order_file] | | pruned_index_name:[idx_2, idx_3, idx_4, idx_print_state, idx_update_time, idx_update_time_speed, t_order_file] | | stats info:[version=2025-09-22 22:01:36.920892, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS, STORAGE] | | t: | | table_rows:591109 | | physical_range_rows:2 | | logical_range_rows:2 | | index_back_rows:2 | | output_rows:2 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[i_order_id, t_order_file_msg] | | unstable_index_name:[t_order_file_msg] | | stats info:[version=2025-09-18 22:02:20.024632, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS, STORAGE] | | t: | | table_rows:1020661 | | physical_range_rows:1 | | logical_range_rows:1 | | index_back_rows:1 | | output_rows:0 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[idx_2, idx_order_id, idx_return_audit_time, t_order_return] | | pruned_index_name:[idx_2, idx_return_audit_time] | | unstable_index_name:[t_order_return] | | stats info:[version=2025-08-14 18:38:38.085277, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS, STORAGE] | | Plan Type: | | DISTRIBUTED | | Parameters: | | :0 => 0 | | :1 => 1 | | :2 => 2 | | :3 => 3 | | :4 => 1 | | :5 => '' | | :6 => '' | | :7 => ':' | | :8 => ';$$$' | | :9 => '' | | :10 => '退款描述' | | :11 => ':' | | :12 => ';$$$' | | :13 => '' | | :14 => 1 | | :15 => 1 | | :16 => '2025-09-23 00:00:00' | | :17 => '2025-09-23 23:59:59' | | :18 => 1 | | :19 => '' | | :20 => '%' | | :21 => '重复' | | :22 => '%' | | :23 => 1 | | :24 => '' | | :25 => '%' | | :26 => '重复' | | :27 => '%' | | :28 => 1 | | :29 => 1 | | :30 => 0 | | :31 => 30 | | Note: | | Degree of Parallelisim is 1 because of table property | | Const Parameter Constraints: | | :4 = 1 | | Expr Constraints: | | 1 = 1 result is TRUE | | 1 = 1 result is TRUE | +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 611 rows in set (0.062 sec) obclient(rd_read@woqu)[cprint]>