🔍 Analyze Excess Appointments

⚠️ Overlapping Appointments (Same Time Slot)
❌ Found 50 overlapping appointment pairs!
These appointments are scheduled for the same time slot.
Time Slot Appointment 1 Appointment 2 Actions
2026-08-25 16:00 ID: 01M0RNQYZR5RNSNSRBEN02XDA5
Client: Test Customer
Status: PENDING 		ID: 01M0RY9SP016G67J7H25ENE2KF
Client: Test Customer
Status: PENDING
2026-08-22 16:00 ID: 01M0GNNK8GW10SM5AQNHYEH2V3
Client: Test Customer
Status: PENDING 		ID: 01M0JR0B0012ZNPGBC627NR38C
Client: Test Customer
Status: PENDING
2026-08-21 16:00 ID: 01M0FSJKP0SCTV294RD4STVQH1
Client: Test Customer
Status: PENDING 		ID: 01M0FTAT38MQKA9WCCP534J4KN
Client: Test Customer
Status: PENDING
2026-08-08 16:00 ID: 01KZCT839R8V0YKGREG6Q84YEY
Client: Test Customer
Status: PENDING 		ID: 01KZEXHY50QAAEXK2F3BWG0CGR
Client: Test Customer
Status: PENDING
2026-08-06 16:00 ID: 01KZ80E3CRVAWZQZ6ECEAYJEQJ
Client: Test Customer
Status: PENDING 		ID: 01KZ814K40JNJS6YGKB9S5BY97
Client: Test Customer
Status: PENDING
2026-08-06 16:00 ID: 01KZ7HSN58F55G52V0X47DAN3R
Client: Test Customer
Status: PENDING 		ID: 01KZ80E3CRVAWZQZ6ECEAYJEQJ
Client: Test Customer
Status: PENDING
2026-08-06 16:00 ID: 01KZ7HSN58F55G52V0X47DAN3R
Client: Test Customer
Status: PENDING 		ID: 01KZ814K40JNJS6YGKB9S5BY97
Client: Test Customer
Status: PENDING
2026-08-05 16:00 ID: 01KZ4ZA4A8APQ88PFBFJ56F5MH
Client: Test Customer
Status: PENDING 		ID: 01KZ5E3FS0DYJCH1JJJTC72TDZ
Client: Test Customer
Status: PENDING
2026-08-04 16:00 ID: 01KZ295MA0PKW7EMN4RAZJDG23
Client: Test Customer
Status: PENDING 		ID: 01KZ2J5YW0JRPG2JYRTM87B3MW
Client: Test Customer
Status: PENDING
2026-08-03 16:00 ID: 01KYZZVJ30B0AQ2XPXVVD192J0
Client: Test Customer
Status: PENDING 		ID: 01KZ0HHX4GS87CRHF10GQP2K5Y
Client: Test Customer
Status: PENDING
2026-08-03 16:00 ID: 01KYZPQ3P8B68G09ZBGC4VAQPV
Client: Test Customer
Status: PENDING 		ID: 01KYZZVJ30B0AQ2XPXVVD192J0
Client: Test Customer
Status: PENDING
2026-08-03 16:00 ID: 01KYZPQ3P8B68G09ZBGC4VAQPV
Client: Test Customer
Status: PENDING 		ID: 01KZ0HHX4GS87CRHF10GQP2K5Y
Client: Test Customer
Status: PENDING
2026-08-02 16:00 ID: 01KYXDCB0GXY5GDNCPVRH77TSH
Client: Test Customer
Status: PENDING 		ID: 01KYZ7W1HGT2QXX94JWBSXE83K
Client: Test Customer
Status: PENDING
2026-08-02 16:00 ID: 01KYX4E9P8EVKA95KCQV6WXKME
Client: Test Customer
Status: PENDING 		ID: 01KYXDCB0GXY5GDNCPVRH77TSH
Client: Test Customer
Status: PENDING
2026-08-02 16:00 ID: 01KYX4E9P8EVKA95KCQV6WXKME
Client: Test Customer
Status: PENDING 		ID: 01KYZ7W1HGT2QXX94JWBSXE83K
Client: Test Customer
Status: PENDING
2026-08-01 16:00 ID: 01KYTPQSAR0ZV2Z88C397W69VG
Client: Test Customer
Status: PENDING 		ID: 01KYTZWT98BD1GVT1MWVY40HQE
Client: Test Customer
Status: PENDING
2026-07-31 16:00 ID: 01KYT79VNGJASA17HMVQF3VAGF
Client: Test Customer
Status: PENDING 		ID: 01KYT7VH38GKHJD26ZTVES21VP
Client: Test Customer
Status: PENDING
2026-07-31 16:00 ID: 01KYT5H47R18WGP1FV8BEXZTF0
Client: Test Customer
Status: PENDING 		ID: 01KYT79VNGJASA17HMVQF3VAGF
Client: Test Customer
Status: PENDING
2026-07-31 16:00 ID: 01KYT5H47R18WGP1FV8BEXZTF0
Client: Test Customer
Status: PENDING 		ID: 01KYT7VH38GKHJD26ZTVES21VP
Client: Test Customer
Status: PENDING
2026-07-31 16:00 ID: 01KYRWXAFRDRGATT6G2428RNRF
Client: Test Customer
Status: PENDING 		ID: 01KYT5H47R18WGP1FV8BEXZTF0
Client: Test Customer
Status: PENDING
2026-07-31 16:00 ID: 01KYRWXAFRDRGATT6G2428RNRF
Client: Test Customer
Status: PENDING 		ID: 01KYT79VNGJASA17HMVQF3VAGF
Client: Test Customer
Status: PENDING
2026-07-31 16:00 ID: 01KYRWXAFRDRGATT6G2428RNRF
Client: Test Customer
Status: PENDING 		ID: 01KYT7VH38GKHJD26ZTVES21VP
Client: Test Customer
Status: PENDING
2026-07-30 16:00 ID: 01KYQ1T9SGDN3DBG6K3PB9W2GH
Client: Test Customer
Status: PENDING 		ID: 01KYQN42B8VTMM9NYKY5NBZ8XT
Client: Test Customer
Status: PENDING
2026-07-30 16:00 ID: 01KYPKW4EG391MMRQSDEXJ9EB9
Client: Test Customer
Status: PENDING 		ID: 01KYQ1T9SGDN3DBG6K3PB9W2GH
Client: Test Customer
Status: PENDING
2026-07-30 16:00 ID: 01KYPKW4EG391MMRQSDEXJ9EB9
Client: Test Customer
Status: PENDING 		ID: 01KYQN42B8VTMM9NYKY5NBZ8XT
Client: Test Customer
Status: PENDING
2026-07-29 16:00 ID: 01KYJX18283JJPYXCXZ6R6JCZH
Client: Test Customer
Status: PENDING 		ID: 01KYMP2J78TN1EH2DVQBA5W3TZ
Client: Test Customer
Status: PENDING
2026-07-28 16:00 ID: 01KYGQWZ3805PS14HCFQA995AX
Client: Test Customer
Status: PENDING 		ID: 01KYGY9NW87GXJRGA20TTM6HKV
Client: Test Customer
Status: PENDING
2026-07-27 16:00 ID: 01KYESNT9REM05W138BDJC9G78
Client: Test Customer
Status: PENDING 		ID: 01KYF8VT20RW4SK68QM4KS17Z4
Client: Test Customer
Status: PENDING
2026-07-26 16:00 ID: 01KYB7HM602TA56TM4M2YHXKXW
Client: Test Customer
Status: PENDING 		ID: 01KYBJQW1RWV4V7AVF23SJ66YS
Client: Test Customer
Status: PENDING
2026-07-24 16:00 ID: 01KY660ZPG2564XAM30Q39S5S8
Client: Test Customer
Status: PENDING 		ID: 01KY8EM7EG4N1S5TNYTJ0AGM8Z
Client: Test Customer
Status: PENDING
2026-07-22 16:00 ID: 01KY15ZGZGZ7NERH5QPGXQAFCX
Client: Test Customer
Status: PENDING 		ID: 01KY388SV0ABA737ZJBNEHV90G
Client: Test Customer
Status: PENDING
2026-07-21 16:00 ID: 01KXZM2BKGH37ZWA5734HPPW1V
Client: Test Customer
Status: PENDING 		ID: 01KY09WJC8T8ENQG1H4K997NH7
Client: Test Customer
Status: PENDING
2026-07-21 16:00 ID: 01KXYP7B20Y8J9MH41FM7GA0FD
Client: Test Customer
Status: PENDING 		ID: 01KXZM2BKGH37ZWA5734HPPW1V
Client: Test Customer
Status: PENDING
2026-07-21 16:00 ID: 01KXYP7B20Y8J9MH41FM7GA0FD
Client: Test Customer
Status: PENDING 		ID: 01KY09WJC8T8ENQG1H4K997NH7
Client: Test Customer
Status: PENDING
2026-07-20 16:00 ID: 01KXW0AF684DT8D7JAK06XPKDJ
Client: Test Customer
Status: PENDING 		ID: 01KXXANDK0AHKSD6Q4JMVMDA9V
Client: Test Customer
Status: PENDING
2026-07-18 16:00 ID: 01KXRHHNK864SGV1FJR8TVAQFG
Client: Test Customer
Status: PENDING 		ID: 01KXRZ8DMGSZCBJZJMB1XNJR11
Client: Test Customer
Status: PENDING
2026-07-18 16:00 ID: 01KXRCQJY0MJN1ZY8Y220QSFGF
Client: Test Customer
Status: PENDING 		ID: 01KXRHHNK864SGV1FJR8TVAQFG
Client: Test Customer
Status: PENDING
2026-07-18 16:00 ID: 01KXRCQJY0MJN1ZY8Y220QSFGF
Client: Test Customer
Status: PENDING 		ID: 01KXRZ8DMGSZCBJZJMB1XNJR11
Client: Test Customer
Status: PENDING
2026-07-18 16:00 ID: 01KXQWN328H1ZP8D1J62EE4Y56
Client: Test Customer
Status: PENDING 		ID: 01KXRCQJY0MJN1ZY8Y220QSFGF
Client: Test Customer
Status: PENDING
2026-07-18 16:00 ID: 01KXQWN328H1ZP8D1J62EE4Y56
Client: Test Customer
Status: PENDING 		ID: 01KXRHHNK864SGV1FJR8TVAQFG
Client: Test Customer
Status: PENDING
2026-07-18 16:00 ID: 01KXQWN328H1ZP8D1J62EE4Y56
Client: Test Customer
Status: PENDING 		ID: 01KXRZ8DMGSZCBJZJMB1XNJR11
Client: Test Customer
Status: PENDING
2026-07-18 16:00 ID: 01KXQTREMGZ75M5SCXXBNRJ36Q
Client: Test Customer
Status: PENDING 		ID: 01KXQWN328H1ZP8D1J62EE4Y56
Client: Test Customer
Status: PENDING
2026-07-18 16:00 ID: 01KXQTREMGZ75M5SCXXBNRJ36Q
Client: Test Customer
Status: PENDING 		ID: 01KXRCQJY0MJN1ZY8Y220QSFGF
Client: Test Customer
Status: PENDING
2026-07-18 16:00 ID: 01KXQTREMGZ75M5SCXXBNRJ36Q
Client: Test Customer
Status: PENDING 		ID: 01KXRHHNK864SGV1FJR8TVAQFG
Client: Test Customer
Status: PENDING
2026-07-18 16:00 ID: 01KXQTREMGZ75M5SCXXBNRJ36Q
Client: Test Customer
Status: PENDING 		ID: 01KXRZ8DMGSZCBJZJMB1XNJR11
Client: Test Customer
Status: PENDING
2026-07-18 16:00 ID: 01KXPZ3K6R8M3A2D4HTXR325X9
Client: Test Customer
Status: PENDING 		ID: 01KXQTREMGZ75M5SCXXBNRJ36Q
Client: Test Customer
Status: PENDING
2026-07-18 16:00 ID: 01KXPZ3K6R8M3A2D4HTXR325X9
Client: Test Customer
Status: PENDING 		ID: 01KXQWN328H1ZP8D1J62EE4Y56
Client: Test Customer
Status: PENDING
2026-07-18 16:00 ID: 01KXPZ3K6R8M3A2D4HTXR325X9
Client: Test Customer
Status: PENDING 		ID: 01KXRCQJY0MJN1ZY8Y220QSFGF
Client: Test Customer
Status: PENDING
2026-07-18 16:00 ID: 01KXPZ3K6R8M3A2D4HTXR325X9
Client: Test Customer
Status: PENDING 		ID: 01KXRHHNK864SGV1FJR8TVAQFG
Client: Test Customer
Status: PENDING
2026-07-18 16:00 ID: 01KXPZ3K6R8M3A2D4HTXR325X9
Client: Test Customer
Status: PENDING 		ID: 01KXRZ8DMGSZCBJZJMB1XNJR11
Client: Test Customer
Status: PENDING
📊 Appointments Count Per Time Slot
⚠️ Found 1 time slots with multiple appointments!
Date Time Count Booking IDs Statuses
Tue, Aug 25 16:00:00 2 01M0RNQYZR5RNSNSRBEN02XDA5, 01M0RY9SP016G67J7H25ENE2KF PENDING, PENDING
👥 Duplicate Bookings by Same Customer
No customers with multiple active bookings.
⚙️ System Configuration Issues

❌ Error

Failed to analyze appointments: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'slot_start' in 'field list'