Symfony Profiler

Query Metrics

31 Database Queries

2 Different statements

28.20 ms Query time

2 Invalid entities

0 Managed entities

Queries


SELECT 
        w.id,
        w.name,
        w.city,
        w.address,
        w.country,
        w.postal_code,
        w.lat,
        w.lng,
        w.radius AS radius_km,
        w.avatar_path,
        w.description,
        w.electric_bike_accepted,
        w.next_available_date,
        w.status,
        w.booking_type,
        w.bike_type_keys,
        w.services_provided_keys,
        w.services_provided,
        w.practice_type_keys,
        w.motor_brands,
        w.motor_positions,
        w.activity,
        w.location,
        w.contact,
        w.schedule,
        w.availability_calendar,
        w.created_at,
        w.gallery,
        w.supported_bike_type,
        w.supported_practice_type,
        w.time_slots,
        (w.booking_type = 'external_booking') AS external_booking_enabled,
        w.external_booking_url,
        (6371 * acos(
            cos(radians(:lat)) *
            cos(radians(w.lat)) *
            cos(radians(w.lng) - radians(:lng)) +
            sin(radians(:lat)) *
            sin(radians(w.lat))
        )) AS distance_km FROM workshop w WHERE 1=1 AND w.status = :status AND (
        6371 * acos(
            cos(radians(:lat)) *
            cos(radians(w.lat)) *
            cos(radians(w.lng) - radians(:lng)) +
            sin(radians(:lat)) *
            sin(radians(w.lat))
        )
    ) <= :radiusKm ORDER BY w.next_available_date ASC NULLS LAST, distance_km ASC NULLS LAST LIMIT :limit
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC

#▲	Time	Info
1	13.69 ms	SELECT w.id, w.name, w.city, w.address, w.country, w.postal_code, w.lat, w.lng, w.radius AS radius_km, w.avatar_path, w.description, w.electric_bike_accepted, w.next_available_date, w.status, w.booking_type, w.bike_type_keys, w.services_provided_keys, w.services_provided, w.practice_type_keys, w.motor_brands, w.motor_positions, w.activity, w.location, w.contact, w.schedule, w.availability_calendar, w.created_at, w.gallery, w.supported_bike_type, w.supported_practice_type, w.time_slots, (w.booking_type = 'external_booking') AS external_booking_enabled, w.external_booking_url, (6371 * acos( cos(radians(:lat)) * cos(radians(w.lat)) * cos(radians(w.lng) - radians(:lng)) + sin(radians(:lat)) * sin(radians(w.lat)) )) AS distance_km FROM workshop w WHERE 1=1 AND w.status = :status AND ( 6371 * acos( cos(radians(:lat)) * cos(radians(w.lat)) * cos(radians(w.lng) - radians(:lng)) + sin(radians(:lat)) * sin(radians(w.lat)) ) ) <= :radiusKm ORDER BY w.next_available_date ASC NULLS LAST, distance_km ASC NULLS LAST LIMIT :limit Parameters: [`"lat" => 48.8566 "lng" => 2.3522 "status" => "status.public" "radiusKm" => 20 "limit" => 30`] View formatted query View runnable query Explain query SELECT w.id, w.name, w.city, w.address, w.country, w.postal_code, w.lat, w.lng, w.radius AS radius_km, w.avatar_path, w.description, w.electric_bike_accepted, w.next_available_date, w.status, w.booking_type, w.bike_type_keys, w.services_provided_keys, w.services_provided, w.practice_type_keys, w.motor_brands, w.motor_positions, w.activity, w.location, w.contact, w.schedule, w.availability_calendar, w.created_at, w.gallery, w.supported_bike_type, w.supported_practice_type, w.time_slots, ( w.booking_type = 'external_booking' ) AS external_booking_enabled, w.external_booking_url, ( 6371 * acos( cos( radians(:lat) ) * cos( radians(w.lat) ) * cos( radians(w.lng) - radians(:lng) ) + sin( radians(:lat) ) * sin( radians(w.lat) ) ) ) AS distance_km FROM workshop w WHERE 1 = 1 AND w.status = :status AND ( 6371 * acos( cos( radians(:lat) ) * cos( radians(w.lat) ) * cos( radians(w.lng) - radians(:lng) ) + sin( radians(:lat) ) * sin( radians(w.lat) ) ) ) <= :radiusKm ORDER BY w.next_available_date ASC NULLS LAST, distance_km ASC NULLS LAST LIMIT :limit SELECT w.id, w.name, w.city, w.address, w.country, w.postal_code, w.lat, w.lng, w.radius AS radius_km, w.avatar_path, w.description, w.electric_bike_accepted, w.next_available_date, w.status, w.booking_type, w.bike_type_keys, w.services_provided_keys, w.services_provided, w.practice_type_keys, w.motor_brands, w.motor_positions, w.activity, w.location, w.contact, w.schedule, w.availability_calendar, w.created_at, w.gallery, w.supported_bike_type, w.supported_practice_type, w.time_slots, (w.booking_type = 'external_booking') AS external_booking_enabled, w.external_booking_url, (6371 * acos( cos(radians(48.8566)) * cos(radians(w.lat)) * cos(radians(w.lng) - radians(2.3522)) + sin(radians(48.8566)) * sin(radians(w.lat)) )) AS distance_km FROM workshop w WHERE 1=1 AND w.status = 'status.public' AND ( 6371 * acos( cos(radians(48.8566)) * cos(radians(w.lat)) * cos(radians(w.lng) - radians(2.3522)) + sin(radians(48.8566)) * sin(radians(w.lat)) ) ) <= 20 ORDER BY w.next_available_date ASC NULLS LAST, distance_km ASC NULLS LAST LIMIT 30;
2	1.31 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"a650dae1-15dd-464f-bdbc-3d3ea8480170" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = 'a650dae1-15dd-464f-bdbc-3d3ea8480170' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
3	0.47 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"f5f90fc5-21ab-4d67-a008-0a34b8d9ebaa" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = 'f5f90fc5-21ab-4d67-a008-0a34b8d9ebaa' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
4	0.44 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"43c8768d-e269-422e-a5e0-049b9705bfd9" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = '43c8768d-e269-422e-a5e0-049b9705bfd9' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
5	0.45 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"64ff6ab4-9433-4b6a-b33c-95b88ed75a94" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = '64ff6ab4-9433-4b6a-b33c-95b88ed75a94' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
6	0.59 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"3e1d4502-dcc7-41da-8b2f-123050edb3cc" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = '3e1d4502-dcc7-41da-8b2f-123050edb3cc' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
7	0.45 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"6c52a012-fb9c-4e4e-841c-f8c69a3a52bd" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = '6c52a012-fb9c-4e4e-841c-f8c69a3a52bd' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
8	0.45 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"59ec3ea4-e1b6-4fb7-9667-b31f34d075c3" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = '59ec3ea4-e1b6-4fb7-9667-b31f34d075c3' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
9	0.42 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"02146358-ea1f-4f77-af55-1b5b08be4acb" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = '02146358-ea1f-4f77-af55-1b5b08be4acb' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
10	0.47 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"1e09ec02-bc6f-4902-94b7-ed6880f5f957" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = '1e09ec02-bc6f-4902-94b7-ed6880f5f957' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
11	0.41 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"c5222517-f8fc-4b7e-a579-5de726e6c494" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = 'c5222517-f8fc-4b7e-a579-5de726e6c494' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
12	0.45 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"ca0f42e6-4632-4e9c-8aeb-aa0adaf72187" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = 'ca0f42e6-4632-4e9c-8aeb-aa0adaf72187' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
13	0.47 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"76e52c93-ae1c-47d5-999c-dae0393b8948" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = '76e52c93-ae1c-47d5-999c-dae0393b8948' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
14	0.49 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"39d40f8d-447c-497b-81d5-ce31a0f476d7" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = '39d40f8d-447c-497b-81d5-ce31a0f476d7' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
15	0.48 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"dab90814-6bab-4eb2-ba4b-c5bad3763bd7" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = 'dab90814-6bab-4eb2-ba4b-c5bad3763bd7' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
16	0.44 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"d2ae404c-406c-4a69-bc5a-e5ad543f4f7d" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = 'd2ae404c-406c-4a69-bc5a-e5ad543f4f7d' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
17	0.41 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"d20ddfb2-3737-4986-886d-669b4dc408c1" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = 'd20ddfb2-3737-4986-886d-669b4dc408c1' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
18	0.43 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"81e80c11-51b5-47a2-8681-76b7620c6640" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = '81e80c11-51b5-47a2-8681-76b7620c6640' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
19	0.47 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"0ab28ce6-ae18-4410-9c96-baa03b74927e" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = '0ab28ce6-ae18-4410-9c96-baa03b74927e' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
20	0.45 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"a326e9a6-2eae-4375-a874-5ccb264a65f0" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = 'a326e9a6-2eae-4375-a874-5ccb264a65f0' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
21	0.47 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"180bf87b-2ce0-4daa-b5a1-f6115d5f68b1" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = '180bf87b-2ce0-4daa-b5a1-f6115d5f68b1' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
22	0.51 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"6ecf88f0-f5a7-4697-ad9d-a67b54e96d25" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = '6ecf88f0-f5a7-4697-ad9d-a67b54e96d25' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
23	0.46 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"dcbe1aeb-353b-4ca9-8fe1-f95f9eb222b6" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = 'dcbe1aeb-353b-4ca9-8fe1-f95f9eb222b6' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
24	0.45 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"8fcf692e-a790-49d8-8805-e7e302971e6c" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = '8fcf692e-a790-49d8-8805-e7e302971e6c' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
25	0.41 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"1c367b86-19b3-4432-b8b9-05aa0edc526d" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = '1c367b86-19b3-4432-b8b9-05aa0edc526d' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
26	0.46 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"29083b93-cbb0-4b59-a2a6-7ce575b54809" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = '29083b93-cbb0-4b59-a2a6-7ce575b54809' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
27	0.43 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"f960b132-bbe2-43fd-8a5f-428b40da65ec" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = 'f960b132-bbe2-43fd-8a5f-428b40da65ec' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
28	0.47 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"c6c508a9-8602-4227-b065-b05ffe8c6d89" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = 'c6c508a9-8602-4227-b065-b05ffe8c6d89' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
29	0.41 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"9b0aea12-b4dd-4118-8ccf-148c1d8b719f" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = '9b0aea12-b4dd-4118-8ccf-148c1d8b719f' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
30	0.43 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"6d3c8f4c-67d5-44e6-af14-676dbe1e9335" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = '6d3c8f4c-67d5-44e6-af14-676dbe1e9335' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
31	0.45 ms	SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC Parameters: [`"0bdb9945-5748-40e2-ade4-e7d969a11fe6" "2026-09-02 00:00:00" "2026-12-03 16:01:26" "CANCELED"`] View formatted query View runnable query Explain query SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = '0bdb9945-5748-40e2-ade4-e7d969a11fe6' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 16:01:26' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

Class	Mapping errors
App\Entity\Workshop	The association App\Entity\Workshop#users refers to the inverse side field App\Entity\User#workshops which does not exist.
App\Entity\Appointment	The mappings App\Entity\Appointment#fleet and App\Entity\Fleet#appointments are inconsistent with each other.

Symfony Profiler

GET http://152.228.230.208:8080/search/workshop?latitude=48.8566&location=paris&longitude=2.3522

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping