{
    "data": {
        "monthlyTrend": [],
        "customerGrades": [],
        "ageGender": [],
        "topDiagnosis": [],
        "topTreatments": [],
        "weeklyAnalysis": [],
        "doctorAnalysis": [],
        "staffAnalysis": [],
        "avgVisitsByGrade": [],
        "revisitRateByGrade": []
    },
    "debug": {
        "data": {
            "sql": [
                "[SYNC] SELECT LEFT(DS08, 7) as month, COUNT(*) as count FROM DS WHERE DS.DS02 = 1 AND DS.DS03 = 1 AND DS.DS08 BETWEEN '2026-10-01' AND '2026-10-23' AND DS.DS19 = '0' GROUP BY month ORDER BY month ASC",
                "[SYNC] SELECT IF(NULLIF(CS.CS16, '') IS NULL, '미지정', CS.CS16) as grade, COUNT(DS.DS01) as count FROM DS LEFT JOIN CS ON DS.DS07 = CS.CS01 WHERE DS.DS02 = 1 AND DS.DS03 = 1 AND DS.DS08 BETWEEN '2026-10-01' AND '2026-10-23' AND DS.DS19 = '0' GROUP BY grade ORDER BY count DESC",
                "[SYNC] SELECT CASE WHEN CS.CS12 < 10 THEN ' 10대 미만' WHEN CS.CS12 >= 70 THEN '70대 이상' ELSE CONCAT(FLOOR(CS.CS12 \/ 10) * 10, '대') END as age_group, CS.CS11 as gender, COUNT(*) as count FROM DS LEFT JOIN CS ON DS.DS07 = CS.CS01 WHERE DS.DS02 = 1 AND DS.DS03 = 1 AND DS.DS08 BETWEEN '2026-10-01' AND '2026-10-23' AND DS.DS19 = '0' GROUP BY age_group, gender ORDER BY age_group ASC",
                "[SYNC] SELECT DS16 FROM DS WHERE DS.DS02 = 1 AND DS.DS03 = 1 AND DS.DS08 BETWEEN '2026-10-01' AND '2026-10-23' AND DS.DS19 = '0'",
                "[SYNC] SELECT DAYOFWEEK(DS08) as wday, COUNT(*) as count FROM DS WHERE DS.DS02 = 1 AND DS.DS03 = 1 AND DS.DS08 BETWEEN '2026-10-01' AND '2026-10-23' AND DS.DS19 = '0' GROUP BY wday ORDER BY wday ASC",
                "[SYNC] SELECT DS13 as name, COUNT(*) as count FROM DS WHERE DS.DS02 = 1 AND DS.DS03 = 1 AND DS.DS08 BETWEEN '2026-10-01' AND '2026-10-23' AND DS.DS19 = '0' AND DS13 != '' GROUP BY DS13 ORDER BY count DESC LIMIT 5",
                "[SYNC] SELECT DS15 as name, COUNT(*) as count FROM DS WHERE DS.DS02 = 1 AND DS.DS03 = 1 AND DS.DS08 BETWEEN '2026-10-01' AND '2026-10-23' AND DS.DS19 = '0' AND DS15 != '' GROUP BY DS15 ORDER BY count DESC LIMIT 5",
                "[SYNC] SELECT IF(NULLIF(CS.CS16, '') IS NULL, '미지정', CS.CS16) as grade, COUNT(DS.DS01) as total_visits, COUNT(DISTINCT DS.DS07) as unique_patients, SUM(CASE WHEN DS.DS08 > CS.CS21 THEN 1 ELSE 0 END) as revisit_count FROM DS LEFT JOIN CS ON DS.DS07 = CS.CS01 WHERE DS.DS02 = 1 AND DS.DS03 = 1 AND DS.DS08 BETWEEN '2026-10-01' AND '2026-10-23' AND DS.DS19 = '0' GROUP BY grade"
            ],
            "debug_client": false,
            "debug_server": true,
            "trace_log": false,
            "query_log": true,
            "sms_log": true,
            "sms_send": false,
            "delaytime": "0.0488s"
        },
        "post": []
    }
}