set session ob_enable_show_trace = on;

explain extended_noaddr
SELECT
	date_format( pom.order_time_cn, '%Y-%m-%d' ) AS "order_time",
	sspa.plat_code AS "plant",
	sspa.sell_leader_name AS "sales_leader",
	ifnull( IF ( su.login_name = '', '无数据', su.login_name ), '无数据' ) AS "team_leader",
	pom.shipping_country_code,
	pom.shipping_country_cn_name,
	sspa.store_acct AS "store",
	sspa.salesperson AS "sales_person",
	pom.logis_type_id,
	count( 1 ) AS "orders",
	sum( pom.prod_quantity ) AS "sales_volume",
	sum( pom.plat_order_amt * pom.exchange_rate ) AS "order_amt_cny",
	sum( pom.prod_cost ) AS "cost_cny",
	sum( pom.profit ) AS "profit_cny",
	sum(
	ifnull( pom.plat_shipping_cost, pom.shipping_cost )) AS "shipping_cost_cny",
	sum(
	IF
	( pom.profit < 0, 1, 0 )) AS "negative_profit_orders",
	sum(
	IF
	( pom.profit < 0, pom.profit, 0 )) AS "negative_profit_cny",
	sum(
	IF
	( pom.sku_quantity = 1, 1, 0 )) AS "single_sku_ordes",
	sum(
	IF
	( pom.sku_quantity = 1, pom.profit, 0 )) AS "single_sku_profit",
	( SELECT exch_rate FROM sys_exch_rate ser WHERE ser.src_cy_code = 'USD' AND tar_cy_code = 'CNY' ) AS "usd_to_cny" 
FROM
	plat_order_main pom
	LEFT JOIN sys_sales_plat_acct sspa ON pom.store_acct_id = sspa.id
	LEFT JOIN sys_sales_acct_config ssac ON pom.store_acct_id = ssac.store_acct_id
	LEFT JOIN sys_user su ON ssac.leader_id = su.id 
WHERE
	pom.process_status NOT IN ( 501, 503, 504, 500 ) 
	AND pom.order_time_cn BETWEEN DATE_ADD( curdate(), INTERVAL - 10 DAY ) 
	AND DATE_ADD( now(), INTERVAL 0 DAY ) 
GROUP BY
	date_format( pom.order_time_cn, '%Y-%m-%d' ),
	pom.store_acct_id,
	pom.shipping_country_code,
	pom.logis_type_id;

SELECT
	date_format( pom.order_time_cn, '%Y-%m-%d' ) AS "order_time",
	sspa.plat_code AS "plant",
	sspa.sell_leader_name AS "sales_leader",
	ifnull( IF ( su.login_name = '', '无数据', su.login_name ), '无数据' ) AS "team_leader",
	pom.shipping_country_code,
	pom.shipping_country_cn_name,
	sspa.store_acct AS "store",
	sspa.salesperson AS "sales_person",
	pom.logis_type_id,
	count( 1 ) AS "orders",
	sum( pom.prod_quantity ) AS "sales_volume",
	sum( pom.plat_order_amt * pom.exchange_rate ) AS "order_amt_cny",
	sum( pom.prod_cost ) AS "cost_cny",
	sum( pom.profit ) AS "profit_cny",
	sum(
	ifnull( pom.plat_shipping_cost, pom.shipping_cost )) AS "shipping_cost_cny",
	sum(
	IF
	( pom.profit < 0, 1, 0 )) AS "negative_profit_orders",
	sum(
	IF
	( pom.profit < 0, pom.profit, 0 )) AS "negative_profit_cny",
	sum(
	IF
	( pom.sku_quantity = 1, 1, 0 )) AS "single_sku_ordes",
	sum(
	IF
	( pom.sku_quantity = 1, pom.profit, 0 )) AS "single_sku_profit",
	( SELECT exch_rate FROM sys_exch_rate ser WHERE ser.src_cy_code = 'USD' AND tar_cy_code = 'CNY' ) AS "usd_to_cny" 
FROM
	plat_order_main pom
	LEFT JOIN sys_sales_plat_acct sspa ON pom.store_acct_id = sspa.id
	LEFT JOIN sys_sales_acct_config ssac ON pom.store_acct_id = ssac.store_acct_id
	LEFT JOIN sys_user su ON ssac.leader_id = su.id 
WHERE
	pom.process_status NOT IN ( 501, 503, 504, 500 ) 
	AND pom.order_time_cn BETWEEN DATE_ADD( curdate(), INTERVAL - 10 DAY ) 
	AND DATE_ADD( now(), INTERVAL 0 DAY ) 
GROUP BY
	date_format( pom.order_time_cn, '%Y-%m-%d' ),
	pom.store_acct_id,
	pom.shipping_country_code,
	pom.logis_type_id;

show trace;

explain extended_Noaddr
SELECT
	date_format( pom.order_time_cn, '%Y-%m-%d' ) AS "order_time",
	sspa.plat_code AS "plant",
	sspa.sell_leader_name AS "sales_leader",
	ifnull( IF ( su.login_name = '', '无数据', su.login_name ), '无数据' ) AS "team_leader",
	pom.shipping_country_code,
	pom.shipping_country_cn_name,
	sspa.store_acct AS "store",
	sspa.salesperson AS "sales_person",
	pom.logis_type_id,
	count( 1 ) AS "orders",
	sum( pom.prod_quantity ) AS "sales_volume",
	sum( pom.plat_order_amt * pom.exchange_rate ) AS "order_amt_cny",
	sum( pom.prod_cost ) AS "cost_cny",
	sum( pom.profit ) AS "profit_cny",
	sum(
	ifnull( pom.plat_shipping_cost, pom.shipping_cost )) AS "shipping_cost_cny",
	sum(
	IF
	( pom.profit < 0, 1, 0 )) AS "negative_profit_orders",
	sum(
	IF
	( pom.profit < 0, pom.profit, 0 )) AS "negative_profit_cny",
	sum(
	IF
	( pom.sku_quantity = 1, 1, 0 )) AS "single_sku_ordes",
	sum(
	IF
	( pom.sku_quantity = 1, pom.profit, 0 )) AS "single_sku_profit",
	( SELECT exch_rate FROM sys_exch_rate ser WHERE ser.src_cy_code = 'USD' AND tar_cy_code = 'CNY' ) AS "usd_to_cny" 
FROM
	plat_order_main pom
	LEFT JOIN sys_sales_plat_acct sspa ON pom.store_acct_id = sspa.id
	LEFT JOIN sys_sales_acct_config ssac ON pom.store_acct_id = ssac.store_acct_id
	LEFT JOIN sys_user su ON ssac.leader_id = su.id 
WHERE
	pom.process_status NOT IN ( 501, 503, 504, 500 ) 
	AND pom.order_time_cn BETWEEN DATE_ADD( curdate(), INTERVAL - 1 DAY ) 
	AND DATE_ADD( now(), INTERVAL 0 DAY ) 
GROUP BY
	date_format( pom.order_time_cn, '%Y-%m-%d' ),
	pom.store_acct_id,
	pom.shipping_country_code,
	pom.logis_type_id;
	 
SELECT
	date_format( pom.order_time_cn, '%Y-%m-%d' ) AS "order_time",
	sspa.plat_code AS "plant",
	sspa.sell_leader_name AS "sales_leader",
	ifnull( IF ( su.login_name = '', '无数据', su.login_name ), '无数据' ) AS "team_leader",
	pom.shipping_country_code,
	pom.shipping_country_cn_name,
	sspa.store_acct AS "store",
	sspa.salesperson AS "sales_person",
	pom.logis_type_id,
	count( 1 ) AS "orders",
	sum( pom.prod_quantity ) AS "sales_volume",
	sum( pom.plat_order_amt * pom.exchange_rate ) AS "order_amt_cny",
	sum( pom.prod_cost ) AS "cost_cny",
	sum( pom.profit ) AS "profit_cny",
	sum(
	ifnull( pom.plat_shipping_cost, pom.shipping_cost )) AS "shipping_cost_cny",
	sum(
	IF
	( pom.profit < 0, 1, 0 )) AS "negative_profit_orders",
	sum(
	IF
	( pom.profit < 0, pom.profit, 0 )) AS "negative_profit_cny",
	sum(
	IF
	( pom.sku_quantity = 1, 1, 0 )) AS "single_sku_ordes",
	sum(
	IF
	( pom.sku_quantity = 1, pom.profit, 0 )) AS "single_sku_profit",
	( SELECT exch_rate FROM sys_exch_rate ser WHERE ser.src_cy_code = 'USD' AND tar_cy_code = 'CNY' ) AS "usd_to_cny" 
FROM
	plat_order_main pom
	LEFT JOIN sys_sales_plat_acct sspa ON pom.store_acct_id = sspa.id
	LEFT JOIN sys_sales_acct_config ssac ON pom.store_acct_id = ssac.store_acct_id
	LEFT JOIN sys_user su ON ssac.leader_id = su.id 
WHERE
	pom.process_status NOT IN ( 501, 503, 504, 500 ) 
	AND pom.order_time_cn BETWEEN DATE_ADD( curdate(), INTERVAL - 1 DAY ) 
	AND DATE_ADD( now(), INTERVAL 0 DAY ) 
GROUP BY
	date_format( pom.order_time_cn, '%Y-%m-%d' ),
	pom.store_acct_id,
	pom.shipping_country_code,
	pom.logis_type_id;
	
show trace;