spawn ssh -o StrictHostKeyChecking=no opsuser@8.147.119.215 cat > /tmp/csfzx_final_rerun_db.sql <<'SQL'
SELECT pay_status, source, COUNT(*) cnt, MIN(create_time) min_create, MAX(create_time) max_create FROM ydy_meal_order GROUP BY pay_status, source ORDER BY pay_status, source;
SELECT COUNT(*) pending_total FROM ydy_meal_order WHERE pay_status=10 AND source=1 AND is_delete=0;
SELECT COUNT(*) pending_old_enough FROM ydy_meal_order WHERE pay_status=10 AND source=1 AND is_delete=0 AND last_meal_time <= DATE_SUB(NOW(), INTERVAL 30 MINUTE);
SELECT COUNT(*) today_orders FROM ydy_meal_order WHERE meal_date=CURDATE();
SELECT COUNT(*) today_initial_menu FROM ydy_initial_menu WHERE menu_date=CURDATE();
SELECT COUNT(DISTINCT code) distinct_plates_today FROM ydy_initial_menu WHERE menu_date=CURDATE();
SQL
obclient -h127.0.0.1 -P2883 -uzhct_user@sys#city_subcenter_ob -pZhct_OB_20260615 -Dzhct_csfzx < /tmp/csfzx_final_rerun_db.sql

opsuser@8.147.119.215's password:
pay_status	source	cnt	min_create	max_create
10	1	3008	2026-06-23 14:49:16	2026-06-23 14:55:04
20	1	18646	2026-06-22 18:19:41	2026-06-23 13:36:27
pending_total
3008
pending_old_enough
0
today_orders
20154
today_initial_menu
92590
distinct_plates_today
1