🔍 Analyze Excess Appointments

⚠️ Overlapping Appointments (Same Time Slot)
❌ Found 49 overlapping appointment pairs!
These appointments are scheduled for the same time slot.
Time Slot Appointment 1 Appointment 2 Actions
2026-06-26 16:00 ID: 01KVYHZ1CGV0MD0TX3Q2HVAE3N
Client: Test Customer
Status: PENDING 		ID: 01KVYQR298WJWYERT9BSGW1H99
Client: Test Customer
Status: PENDING
2026-06-20 16:00 ID: 01KVF7FAP8HSETPHHRGKA4SZKC
Client: Test Customer
Status: PENDING 		ID: 01KVG35RX0P3625D34H2G9FAQA
Client: Test Customer
Status: PENDING
2026-06-20 16:00 ID: 01KVF78EZ0J71FGF5H6EW4V0NQ
Client: Test Customer
Status: PENDING 		ID: 01KVF7FAP8HSETPHHRGKA4SZKC
Client: Test Customer
Status: PENDING
2026-06-20 16:00 ID: 01KVF78EZ0J71FGF5H6EW4V0NQ
Client: Test Customer
Status: PENDING 		ID: 01KVG35RX0P3625D34H2G9FAQA
Client: Test Customer
Status: PENDING
2026-06-20 16:00 ID: 01KVEZYCQGBGNJ1GWNDTMSBQWG
Client: Test Customer
Status: PENDING 		ID: 01KVF78EZ0J71FGF5H6EW4V0NQ
Client: Test Customer
Status: PENDING
2026-06-20 16:00 ID: 01KVEZYCQGBGNJ1GWNDTMSBQWG
Client: Test Customer
Status: PENDING 		ID: 01KVF7FAP8HSETPHHRGKA4SZKC
Client: Test Customer
Status: PENDING
2026-06-20 16:00 ID: 01KVEZYCQGBGNJ1GWNDTMSBQWG
Client: Test Customer
Status: PENDING 		ID: 01KVG35RX0P3625D34H2G9FAQA
Client: Test Customer
Status: PENDING
2026-06-20 16:00 ID: 01KVEZXMA8SPSCATW1YKDNVVK8
Client: Test Customer
Status: PENDING 		ID: 01KVEZYCQGBGNJ1GWNDTMSBQWG
Client: Test Customer
Status: PENDING
2026-06-20 16:00 ID: 01KVEZXMA8SPSCATW1YKDNVVK8
Client: Test Customer
Status: PENDING 		ID: 01KVF78EZ0J71FGF5H6EW4V0NQ
Client: Test Customer
Status: PENDING
2026-06-20 16:00 ID: 01KVEZXMA8SPSCATW1YKDNVVK8
Client: Test Customer
Status: PENDING 		ID: 01KVF7FAP8HSETPHHRGKA4SZKC
Client: Test Customer
Status: PENDING
2026-06-20 16:00 ID: 01KVEZXMA8SPSCATW1YKDNVVK8
Client: Test Customer
Status: PENDING 		ID: 01KVG35RX0P3625D34H2G9FAQA
Client: Test Customer
Status: PENDING
2026-06-20 16:00 ID: 01KVEWENH8KACG5TMVRP9TKBFF
Client: Test Customer
Status: PENDING 		ID: 01KVEZXMA8SPSCATW1YKDNVVK8
Client: Test Customer
Status: PENDING
2026-06-20 16:00 ID: 01KVEWENH8KACG5TMVRP9TKBFF
Client: Test Customer
Status: PENDING 		ID: 01KVEZYCQGBGNJ1GWNDTMSBQWG
Client: Test Customer
Status: PENDING
2026-06-20 16:00 ID: 01KVEWENH8KACG5TMVRP9TKBFF
Client: Test Customer
Status: PENDING 		ID: 01KVF78EZ0J71FGF5H6EW4V0NQ
Client: Test Customer
Status: PENDING
2026-06-20 16:00 ID: 01KVEWENH8KACG5TMVRP9TKBFF
Client: Test Customer
Status: PENDING 		ID: 01KVF7FAP8HSETPHHRGKA4SZKC
Client: Test Customer
Status: PENDING
2026-06-20 16:00 ID: 01KVEWENH8KACG5TMVRP9TKBFF
Client: Test Customer
Status: PENDING 		ID: 01KVG35RX0P3625D34H2G9FAQA
Client: Test Customer
Status: PENDING
2026-06-18 16:00 ID: 01KVB38TQ01QQ1XM2YK70KWF6C
Client: Test Customer
Status: PENDING 		ID: 01KVB3CJTRKDGPDF95SE9216B3
Client: Test Customer
Status: PENDING
2026-06-14 16:00 ID: 01KV0E4KC8907DAG8PMNYH0EHH
Client: Test Customer
Status: PENDING 		ID: 01KV1B2H8GK5JF0K6KN5JBHSV6
Client: Test Customer
Status: PENDING
2026-05-25 16:00 ID: 01KSBPBGBRDKVPA0DQQSEZNVCC
Client: Test Customer
Status: PENDING 		ID: 01KSC6WNYRQ1MSZB92JT09Q9AP
Client: Test Customer
Status: PENDING
2026-05-21 16:00 ID: 01KS1EJ74GR69PJDP1Y2021FDP
Client: Test Customer
Status: PENDING 		ID: 01KS24BMGRRXY229C2TZXFZVXN
Client: Test Customer
Status: PENDING
2026-05-20 16:00 ID: 01KRZ56F6R0EYMJRYBMYJ17KAY
Client: Test Customer
Status: PENDING 		ID: 01KS0J3RC07X3Q2QQYJB3HHES7
Client: Test Customer
Status: PENDING
2026-05-16 16:00 ID: 01KRMZH1VGD924A4PWHYRQBMWW
Client: Test Customer
Status: PENDING 		ID: 01KRNBG9H08H393HHA12M1ZB6D
Client: Test Customer
Status: PENDING
2026-05-15 16:00 ID: 01KRK6HAFG90BEK7C5MFJDF2VN
Client: Test Customer
Status: PENDING 		ID: 01KRKNZJWGTNS2GNR4VQH9X4ZD
Client: Test Customer
Status: PENDING
2026-05-14 16:00 ID: 01KRGV1PNRQ3AMCBD9SCJKTA0D
Client: Test Customer
Status: PENDING 		ID: 01KRHKSBP02SDJJ4D6KCYK1938
Client: Test Customer
Status: PENDING
2026-05-09 16:00 ID: 01KR4B302RHRKNQPSEWBMM9Z59
Client: Test Customer
Status: PENDING 		ID: 01KR4BNKS8RN77A18NEJQGSZA9
Client: Test Customer
Status: PENDING
2026-05-06 16:00 ID: 01KQTYNZW0SYWCW0GNGM3354G4
Client: Test Customer
Status: PENDING 		ID: 01KQX186VRR52736PVQK5A9M50
Client: Test Customer
Status: PENDING
2026-04-26 16:00 ID: 01KQ1GR340QVB2CX8JDDB8S0SJ
Client: Test Customer
Status: PENDING 		ID: 01KQ2Q24GRJY0DFYJE0CY3V6QS
Client: Test Customer
Status: PENDING
2026-04-22 16:00 ID: 01KPQQZ318BJJGTAMZMYYFP5ZM
Client: Test Customer
Status: PENDING 		ID: 01KPR3T018QSZZ87NF9W1YYS88
Client: Test Customer
Status: PENDING
2026-04-20 16:00 ID: 01KPJXBHR0TZTHHMFP4T6C7QGW
Client: Test Customer
Status: PENDING 		ID: 01KPK09VAGKGPTGMFX3EVS4KHB
Client: Test Customer
Status: PENDING
2026-04-17 16:00 ID: 01KP9YH6Q06G3K8W478C75EE1X
Client: Test Customer
Status: PENDING 		ID: 01KPASWJE0MC5X1X1SEPN0YBWB
Client: Test Customer
Status: PENDING
2026-04-14 16:00 ID: 01KP24NMA8MCHH7Q41SFEBK2SK
Client: Test Customer
Status: PENDING 		ID: 01KP268VZ0YB3G0A4WTD3EW3HR
Client: Test Customer
Status: PENDING
2026-04-11 16:00 ID: 01KNVRZM4RHFS71J892G8EWVFB
Client: Test Customer
Status: PENDING 		ID: 01KNWD2GD8QCKCCEZP02FD1D3G
Client: Test Customer
Status: PENDING
2026-04-11 16:00 ID: 01KNVD5V90Q5PK41JS650X9VC4
Client: Test Customer
Status: PENDING 		ID: 01KNVRZM4RHFS71J892G8EWVFB
Client: Test Customer
Status: PENDING
2026-04-11 16:00 ID: 01KNVD5V90Q5PK41JS650X9VC4
Client: Test Customer
Status: PENDING 		ID: 01KNWD2GD8QCKCCEZP02FD1D3G
Client: Test Customer
Status: PENDING
2026-04-06 16:00 ID: 01KND8ASD81QQ27ABA6DPHKJE5
Client: Test Customer
Status: PENDING 		ID: 01KNESWPE08J2YE68FETDX8JG3
Client: Test Customer
Status: PENDING
2026-04-01 16:00 ID: 01KN0KHDK8VG81XRAVC2Z9AQ0G
Client: Test Customer
Status: PENDING 		ID: 01KN225SERTEZMQPP73YT6ESFG
Client: Test Customer
Status: PENDING
2026-04-01 16:00 ID: 01KN0CP9W8JC1C7G1XT2JNP8PS
Client: Test Customer
Status: PENDING 		ID: 01KN0KHDK8VG81XRAVC2Z9AQ0G
Client: Test Customer
Status: PENDING
2026-04-01 16:00 ID: 01KN0CP9W8JC1C7G1XT2JNP8PS
Client: Test Customer
Status: PENDING 		ID: 01KN225SERTEZMQPP73YT6ESFG
Client: Test Customer
Status: PENDING
2026-03-27 15:00 ID: 01KMKVFF3GTB5PAQJABZTHN5QK
Client: Test Customer
Status: PENDING 		ID: 01KMN4MHK080F0FVGB15S459DB
Client: Test Customer
Status: PENDING
2026-03-26 15:00 ID: 01KMK4DYGRGW89BPAE2Q6E6R1D
Client: Test Customer
Status: PENDING 		ID: 01KMK4GQCGYJPZDENACAP209GE
Client: Test Customer
Status: PENDING
2026-03-22 15:00 ID: 01KM6Y59SR1H3ZD26QYB332GZQ
Client: Test Customer
Status: PENDING 		ID: 01KM89B5H0KV7JJGXFHVF07JBB
Client: Test Customer
Status: PENDING
2026-03-17 15:00 ID: 01KKSWS69GCS43F394PCASKJ9T
Client: Test Customer
Status: PENDING 		ID: 01KKVA38MGT9NQCY4JQN0MDFDQ
Client: Test Customer
Status: PENDING
2026-02-10 15:00 ID: 01KH075EZRPZFPPEK81EB06R2A
Client: Test Customer
Status: PENDING 		ID: 01KH1HP21RFS6MBKCVEMNB7HXG
Client: Test Customer
Status: PENDING
2026-02-10 15:00 ID: 01KH06388GX289QVRXQVB0DGSV
Client: Test Customer
Status: PENDING 		ID: 01KH075EZRPZFPPEK81EB06R2A
Client: Test Customer
Status: PENDING
2026-02-10 15:00 ID: 01KH06388GX289QVRXQVB0DGSV
Client: Test Customer
Status: PENDING 		ID: 01KH1HP21RFS6MBKCVEMNB7HXG
Client: Test Customer
Status: PENDING
2025-12-31 15:00 ID: 01KDPB7SP0NP66SQR2WEREGZV7
Client: Test Customer
Status: PENDING 		ID: 01KDQDBVZ8PG447ZSJ5B1MKA1K
Client: Test Customer
Status: PENDING
2025-10-22 16:00 ID: 01K8267NDRPAA8GPV2D873M94T
Client: Test Customer
Status: PENDING 		ID: 01K82JMHM06NQ8VWZHPM0MZZHD
Client: Test Customer
Status: PENDING
2025-10-01 12:00 ID: RDV_68da715e9b478
Client: Emma Michel
Status: PENDING 		ID: RDV_68da9048ef337
Client: Pierre Moreau
Status: PENDING
2025-09-12 14:30 ID: 01K4MM0DEGF1EDBMQW9YQVAKPW
Client: Sophie Simon
Status: CONFIRMED 		ID: 01K4MSQXGRHWJYGPH9DFM4M3J4
Client: Marie Michel
Status: CONFIRMED
📊 Appointments Count Per Time Slot
⚠️ Found 1 time slots with multiple appointments!
Date Time Count Booking IDs Statuses
Fri, Jun 26 16:00:00 2 01KVYHZ1CGV0MD0TX3Q2HVAE3N, 01KVYQR298WJWYERT9BSGW1H99 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'