2026-01-06 08:10:39 - Input: {"hospital_id":1,"token_number":"1","patient_id":208}
Hospital ID: 1, Token: 1, Patient ID: 208
SQL Query: SELECT 
                    p.*,
                    pt.name as patient_name,
                    pt.mobile as patient_mobile,
                    pt.age as patient_age,
                    pt.gender as patient_gender,
                    pt.blood_group,
                    d.name as doctor_name,
                    d.specialization as doctor_specialization
                FROM prescriptions p
                LEFT JOIN patients pt ON p.patient_id = pt.id
                LEFT JOIN doctors d ON p.doctor_id = d.id
                WHERE p.hospital_id = 1 AND p.token_number = '1'
                ORDER BY p.prescribed_date DESC, p.id DESC
                LIMIT 1
No prescription found
2026-01-06 08:10:42 - Input: {"hospital_id":1,"token_number":"1","patient_id":208}
Hospital ID: 1, Token: 1, Patient ID: 208
SQL Query: SELECT 
                    p.*,
                    pt.name as patient_name,
                    pt.mobile as patient_mobile,
                    pt.age as patient_age,
                    pt.gender as patient_gender,
                    pt.blood_group,
                    d.name as doctor_name,
                    d.specialization as doctor_specialization
                FROM prescriptions p
                LEFT JOIN patients pt ON p.patient_id = pt.id
                LEFT JOIN doctors d ON p.doctor_id = d.id
                WHERE p.hospital_id = 1 AND p.token_number = '1'
                ORDER BY p.prescribed_date DESC, p.id DESC
                LIMIT 1
No prescription found
2026-01-06 08:11:39 - Input: {"hospital_id":1,"token_number":"1","patient_id":208}
Hospital ID: 1, Token: 1, Patient ID: 208
SQL Query: SELECT 
                    p.*,
                    pt.name as patient_name,
                    pt.mobile as patient_mobile,
                    pt.age as patient_age,
                    pt.gender as patient_gender,
                    pt.blood_group,
                    d.name as doctor_name,
                    d.specialization as doctor_specialization
                FROM prescriptions p
                LEFT JOIN patients pt ON p.patient_id = pt.id
                LEFT JOIN doctors d ON p.doctor_id = d.id
                WHERE p.hospital_id = 1 AND p.token_number = '1'
                ORDER BY p.prescribed_date DESC, p.id DESC
                LIMIT 1
No prescription found
2026-01-06 08:13:42 - Input: {"hospital_id":1,"token_number":"1","patient_id":208}
Hospital ID: 1, Token: 1, Patient ID: 208
SQL Query: SELECT 
                    p.*,
                    pt.name as patient_name,
                    pt.mobile as patient_mobile,
                    pt.age as patient_age,
                    pt.gender as patient_gender,
                    pt.blood_group,
                    d.name as doctor_name,
                    d.specialization as doctor_specialization
                FROM prescriptions p
                LEFT JOIN patients pt ON p.patient_id = pt.id
                LEFT JOIN doctors d ON p.doctor_id = d.id
                WHERE p.hospital_id = 1 AND p.token_number = '1'
                ORDER BY p.prescribed_date DESC, p.id DESC
                LIMIT 1
No prescription found
2026-01-06 08:18:00 - Input: {"hospital_id":1,"token_number":"1","patient_id":208}
Hospital ID: 1, Token: '1', Patient ID: 208
Searching for: hospital_id=1, patient_id=208, token='1'
Count SQL: SELECT COUNT(*) as count FROM prescriptions p WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
Found 1 prescriptions
Main SQL Query: SELECT 
                    p.*,
                    pt.name as patient_name,
                    pt.mobile as patient_mobile,
                    pt.age as patient_age,
                    pt.gender as patient_gender,
                    pt.blood_group,
                    d.name as doctor_name,
                    d.specialization as doctor_specialization
                FROM prescriptions p
                LEFT JOIN patients pt ON p.patient_id = pt.id
                LEFT JOIN doctors d ON p.doctor_id = d.id
                WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
                ORDER BY p.prescribed_date DESC, p.id DESC
                LIMIT 1
No rows found. SQL error: Unknown column 'pt.name' in 'field list'
2026-01-06 08:18:01 - Input: {"hospital_id":1,"token_number":"1","patient_id":208}
Hospital ID: 1, Token: '1', Patient ID: 208
Searching for: hospital_id=1, patient_id=208, token='1'
Count SQL: SELECT COUNT(*) as count FROM prescriptions p WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
Found 1 prescriptions
Main SQL Query: SELECT 
                    p.*,
                    pt.name as patient_name,
                    pt.mobile as patient_mobile,
                    pt.age as patient_age,
                    pt.gender as patient_gender,
                    pt.blood_group,
                    d.name as doctor_name,
                    d.specialization as doctor_specialization
                FROM prescriptions p
                LEFT JOIN patients pt ON p.patient_id = pt.id
                LEFT JOIN doctors d ON p.doctor_id = d.id
                WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
                ORDER BY p.prescribed_date DESC, p.id DESC
                LIMIT 1
No rows found. SQL error: Unknown column 'pt.name' in 'field list'
2026-01-06 08:18:01 - Input: {"hospital_id":1,"token_number":"1","patient_id":208}
Hospital ID: 1, Token: '1', Patient ID: 208
Searching for: hospital_id=1, patient_id=208, token='1'
Count SQL: SELECT COUNT(*) as count FROM prescriptions p WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
Found 1 prescriptions
Main SQL Query: SELECT 
                    p.*,
                    pt.name as patient_name,
                    pt.mobile as patient_mobile,
                    pt.age as patient_age,
                    pt.gender as patient_gender,
                    pt.blood_group,
                    d.name as doctor_name,
                    d.specialization as doctor_specialization
                FROM prescriptions p
                LEFT JOIN patients pt ON p.patient_id = pt.id
                LEFT JOIN doctors d ON p.doctor_id = d.id
                WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
                ORDER BY p.prescribed_date DESC, p.id DESC
                LIMIT 1
No rows found. SQL error: Unknown column 'pt.name' in 'field list'
2026-01-06 08:18:02 - Input: {"hospital_id":1,"token_number":"1","patient_id":208}
Hospital ID: 1, Token: '1', Patient ID: 208
Searching for: hospital_id=1, patient_id=208, token='1'
Count SQL: SELECT COUNT(*) as count FROM prescriptions p WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
Found 1 prescriptions
Main SQL Query: SELECT 
                    p.*,
                    pt.name as patient_name,
                    pt.mobile as patient_mobile,
                    pt.age as patient_age,
                    pt.gender as patient_gender,
                    pt.blood_group,
                    d.name as doctor_name,
                    d.specialization as doctor_specialization
                FROM prescriptions p
                LEFT JOIN patients pt ON p.patient_id = pt.id
                LEFT JOIN doctors d ON p.doctor_id = d.id
                WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
                ORDER BY p.prescribed_date DESC, p.id DESC
                LIMIT 1
No rows found. SQL error: Unknown column 'pt.name' in 'field list'
2026-01-06 08:18:02 - Input: {"hospital_id":1,"token_number":"1","patient_id":208}
Hospital ID: 1, Token: '1', Patient ID: 208
Searching for: hospital_id=1, patient_id=208, token='1'
Count SQL: SELECT COUNT(*) as count FROM prescriptions p WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
Found 1 prescriptions
Main SQL Query: SELECT 
                    p.*,
                    pt.name as patient_name,
                    pt.mobile as patient_mobile,
                    pt.age as patient_age,
                    pt.gender as patient_gender,
                    pt.blood_group,
                    d.name as doctor_name,
                    d.specialization as doctor_specialization
                FROM prescriptions p
                LEFT JOIN patients pt ON p.patient_id = pt.id
                LEFT JOIN doctors d ON p.doctor_id = d.id
                WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
                ORDER BY p.prescribed_date DESC, p.id DESC
                LIMIT 1
No rows found. SQL error: Unknown column 'pt.name' in 'field list'
2026-01-06 08:18:02 - Input: {"hospital_id":1,"token_number":"1","patient_id":208}
Hospital ID: 1, Token: '1', Patient ID: 208
Searching for: hospital_id=1, patient_id=208, token='1'
Count SQL: SELECT COUNT(*) as count FROM prescriptions p WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
Found 1 prescriptions
Main SQL Query: SELECT 
                    p.*,
                    pt.name as patient_name,
                    pt.mobile as patient_mobile,
                    pt.age as patient_age,
                    pt.gender as patient_gender,
                    pt.blood_group,
                    d.name as doctor_name,
                    d.specialization as doctor_specialization
                FROM prescriptions p
                LEFT JOIN patients pt ON p.patient_id = pt.id
                LEFT JOIN doctors d ON p.doctor_id = d.id
                WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
                ORDER BY p.prescribed_date DESC, p.id DESC
                LIMIT 1
No rows found. SQL error: Unknown column 'pt.name' in 'field list'
2026-01-06 08:18:02 - Input: {"hospital_id":1,"token_number":"1","patient_id":208}
Hospital ID: 1, Token: '1', Patient ID: 208
Searching for: hospital_id=1, patient_id=208, token='1'
Count SQL: SELECT COUNT(*) as count FROM prescriptions p WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
Found 1 prescriptions
Main SQL Query: SELECT 
                    p.*,
                    pt.name as patient_name,
                    pt.mobile as patient_mobile,
                    pt.age as patient_age,
                    pt.gender as patient_gender,
                    pt.blood_group,
                    d.name as doctor_name,
                    d.specialization as doctor_specialization
                FROM prescriptions p
                LEFT JOIN patients pt ON p.patient_id = pt.id
                LEFT JOIN doctors d ON p.doctor_id = d.id
                WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
                ORDER BY p.prescribed_date DESC, p.id DESC
                LIMIT 1
No rows found. SQL error: Unknown column 'pt.name' in 'field list'
2026-01-06 08:18:02 - Input: {"hospital_id":1,"token_number":"1","patient_id":208}
Hospital ID: 1, Token: '1', Patient ID: 208
Searching for: hospital_id=1, patient_id=208, token='1'
Count SQL: SELECT COUNT(*) as count FROM prescriptions p WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
Found 1 prescriptions
Main SQL Query: SELECT 
                    p.*,
                    pt.name as patient_name,
                    pt.mobile as patient_mobile,
                    pt.age as patient_age,
                    pt.gender as patient_gender,
                    pt.blood_group,
                    d.name as doctor_name,
                    d.specialization as doctor_specialization
                FROM prescriptions p
                LEFT JOIN patients pt ON p.patient_id = pt.id
                LEFT JOIN doctors d ON p.doctor_id = d.id
                WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
                ORDER BY p.prescribed_date DESC, p.id DESC
                LIMIT 1
No rows found. SQL error: Unknown column 'pt.name' in 'field list'
2026-01-06 08:18:03 - Input: {"hospital_id":1,"token_number":"1","patient_id":208}
Hospital ID: 1, Token: '1', Patient ID: 208
Searching for: hospital_id=1, patient_id=208, token='1'
Count SQL: SELECT COUNT(*) as count FROM prescriptions p WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
Found 1 prescriptions
Main SQL Query: SELECT 
                    p.*,
                    pt.name as patient_name,
                    pt.mobile as patient_mobile,
                    pt.age as patient_age,
                    pt.gender as patient_gender,
                    pt.blood_group,
                    d.name as doctor_name,
                    d.specialization as doctor_specialization
                FROM prescriptions p
                LEFT JOIN patients pt ON p.patient_id = pt.id
                LEFT JOIN doctors d ON p.doctor_id = d.id
                WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
                ORDER BY p.prescribed_date DESC, p.id DESC
                LIMIT 1
No rows found. SQL error: Unknown column 'pt.name' in 'field list'
2026-01-06 08:18:03 - Input: {"hospital_id":1,"token_number":"1","patient_id":208}
Hospital ID: 1, Token: '1', Patient ID: 208
Searching for: hospital_id=1, patient_id=208, token='1'
Count SQL: SELECT COUNT(*) as count FROM prescriptions p WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
Found 1 prescriptions
Main SQL Query: SELECT 
                    p.*,
                    pt.name as patient_name,
                    pt.mobile as patient_mobile,
                    pt.age as patient_age,
                    pt.gender as patient_gender,
                    pt.blood_group,
                    d.name as doctor_name,
                    d.specialization as doctor_specialization
                FROM prescriptions p
                LEFT JOIN patients pt ON p.patient_id = pt.id
                LEFT JOIN doctors d ON p.doctor_id = d.id
                WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
                ORDER BY p.prescribed_date DESC, p.id DESC
                LIMIT 1
No rows found. SQL error: Unknown column 'pt.name' in 'field list'
2026-01-06 08:18:03 - Input: {"hospital_id":1,"token_number":"1","patient_id":208}
Hospital ID: 1, Token: '1', Patient ID: 208
Searching for: hospital_id=1, patient_id=208, token='1'
Count SQL: SELECT COUNT(*) as count FROM prescriptions p WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
Found 1 prescriptions
Main SQL Query: SELECT 
                    p.*,
                    pt.name as patient_name,
                    pt.mobile as patient_mobile,
                    pt.age as patient_age,
                    pt.gender as patient_gender,
                    pt.blood_group,
                    d.name as doctor_name,
                    d.specialization as doctor_specialization
                FROM prescriptions p
                LEFT JOIN patients pt ON p.patient_id = pt.id
                LEFT JOIN doctors d ON p.doctor_id = d.id
                WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
                ORDER BY p.prescribed_date DESC, p.id DESC
                LIMIT 1
No rows found. SQL error: Unknown column 'pt.name' in 'field list'
2026-01-06 08:18:03 - Input: {"hospital_id":1,"token_number":"1","patient_id":208}
Hospital ID: 1, Token: '1', Patient ID: 208
Searching for: hospital_id=1, patient_id=208, token='1'
Count SQL: SELECT COUNT(*) as count FROM prescriptions p WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
Found 1 prescriptions
Main SQL Query: SELECT 
                    p.*,
                    pt.name as patient_name,
                    pt.mobile as patient_mobile,
                    pt.age as patient_age,
                    pt.gender as patient_gender,
                    pt.blood_group,
                    d.name as doctor_name,
                    d.specialization as doctor_specialization
                FROM prescriptions p
                LEFT JOIN patients pt ON p.patient_id = pt.id
                LEFT JOIN doctors d ON p.doctor_id = d.id
                WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
                ORDER BY p.prescribed_date DESC, p.id DESC
                LIMIT 1
No rows found. SQL error: Unknown column 'pt.name' in 'field list'
2026-01-06 08:18:06 - Input: {"hospital_id":1,"token_number":"1","patient_id":208}
Hospital ID: 1, Token: '1', Patient ID: 208
Searching for: hospital_id=1, patient_id=208, token='1'
Count SQL: SELECT COUNT(*) as count FROM prescriptions p WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
Found 1 prescriptions
Main SQL Query: SELECT 
                    p.*,
                    pt.name as patient_name,
                    pt.mobile as patient_mobile,
                    pt.age as patient_age,
                    pt.gender as patient_gender,
                    pt.blood_group,
                    d.name as doctor_name,
                    d.specialization as doctor_specialization
                FROM prescriptions p
                LEFT JOIN patients pt ON p.patient_id = pt.id
                LEFT JOIN doctors d ON p.doctor_id = d.id
                WHERE p.hospital_id = 1 AND p.token_number = '1' AND p.patient_id = 208
                ORDER BY p.prescribed_date DESC, p.id DESC
                LIMIT 1
No rows found. SQL error: Unknown column 'pt.name' in 'field list'
2026-01-06 08:18:39 - Input: {"hospital_id":1,"patient_id":208}
Hospital ID: 1, Token: '', Patient ID: 208
Searching for: hospital_id=1, patient_id=208, token=''
Count SQL: SELECT COUNT(*) as count FROM prescriptions p WHERE p.hospital_id = 1 AND p.patient_id = 208
Found 1 prescriptions
Main SQL Query: SELECT 
                    p.*,
                    pt.name as patient_name,
                    pt.mobile as patient_mobile,
                    pt.age as patient_age,
                    pt.gender as patient_gender,
                    pt.blood_group,
                    d.name as doctor_name,
                    d.specialization as doctor_specialization
                FROM prescriptions p
                LEFT JOIN patients pt ON p.patient_id = pt.id
                LEFT JOIN doctors d ON p.doctor_id = d.id
                WHERE p.hospital_id = 1 AND p.patient_id = 208
                ORDER BY p.prescribed_date DESC, p.id DESC
                LIMIT 1
No rows found. SQL error: Unknown column 'pt.name' in 'field list'