Symfony Profiler

Query Metrics

31 Database Queries

2 Different statements

30.71 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.31 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" => 43.2962 "lng" => 5.3698 "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(43.2962)) * cos(radians(w.lat)) * cos(radians(w.lng) - radians(5.3698)) + sin(radians(43.2962)) * sin(radians(w.lat)) )) AS distance_km FROM workshop w WHERE 1=1 AND w.status = 'status.public' AND ( 6371 * acos( cos(radians(43.2962)) * cos(radians(w.lat)) * cos(radians(w.lng) - radians(5.3698)) + sin(radians(43.2962)) * sin(radians(w.lat)) ) ) <= 20 ORDER BY w.next_available_date ASC NULLS LAST, distance_km ASC NULLS LAST LIMIT 30;
2	1.60 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: [`"597e6afe-b244-41d4-858f-a7162abcf5b1" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = '597e6afe-b244-41d4-858f-a7162abcf5b1' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
3	2.34 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: [`"1ecfa6fc-b469-4e8a-a372-3f8a66a1b7ca" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = '1ecfa6fc-b469-4e8a-a372-3f8a66a1b7ca' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
4	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: [`"d56c4391-d4ec-4eea-b730-9d33d5b52c08" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = 'd56c4391-d4ec-4eea-b730-9d33d5b52c08' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
5	1.11 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: [`"836822bd-2dfb-4060-acb5-85d496dbbc7e" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = '836822bd-2dfb-4060-acb5-85d496dbbc7e' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
6	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: [`"d23fe628-9271-4aec-9062-0dad031abbfe" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = 'd23fe628-9271-4aec-9062-0dad031abbfe' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
7	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: [`"63c686b6-3ab0-4a9d-b01f-f57f85306990" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = '63c686b6-3ab0-4a9d-b01f-f57f85306990' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
8	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: [`"42bc9681-a62c-42bd-a1fb-149059b52d5e" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = '42bc9681-a62c-42bd-a1fb-149059b52d5e' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
9	0.50 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: [`"74a8183c-30e9-451f-8af7-e11149c0d606" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = '74a8183c-30e9-451f-8af7-e11149c0d606' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
10	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: [`"b71167bf-a2d6-44ce-b16f-7ba07f7c6c95" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = 'b71167bf-a2d6-44ce-b16f-7ba07f7c6c95' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
11	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: [`"da741ba4-3113-46e5-b2c0-6c15c21403d4" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = 'da741ba4-3113-46e5-b2c0-6c15c21403d4' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
12	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: [`"b13d7b08-2bc9-4271-bbca-36396ec4a722" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = 'b13d7b08-2bc9-4271-bbca-36396ec4a722' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
13	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: [`"40350466-a55a-476e-8b5b-a86d2dc5cf7d" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = '40350466-a55a-476e-8b5b-a86d2dc5cf7d' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
14	0.54 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: [`"4c74e710-2df3-4ae0-bf1f-f193ab39de22" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = '4c74e710-2df3-4ae0-bf1f-f193ab39de22' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
15	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: [`"abaffd0b-6c51-4d61-a652-e53cb32db04e" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = 'abaffd0b-6c51-4d61-a652-e53cb32db04e' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
16	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: [`"34a7bc14-b3f7-4602-80f5-12800ae2e614" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = '34a7bc14-b3f7-4602-80f5-12800ae2e614' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' 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: [`"65283a45-70b9-492a-b122-625d4b21d409" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = '65283a45-70b9-492a-b122-625d4b21d409' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
18	0.40 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: [`"9a8cf640-907c-449f-b8f6-9f6f0937c267" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = '9a8cf640-907c-449f-b8f6-9f6f0937c267' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
19	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: [`"6986846e-e5ab-4b78-908d-896d3a81dba6" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = '6986846e-e5ab-4b78-908d-896d3a81dba6' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
20	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: [`"7c532d75-eb7e-4c13-8a2f-3431cc4f58f1" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = '7c532d75-eb7e-4c13-8a2f-3431cc4f58f1' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
21	0.40 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: [`"fc372198-c4f0-44da-bf88-31215d0ffeeb" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = 'fc372198-c4f0-44da-bf88-31215d0ffeeb' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
22	0.40 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: [`"8ee71aab-4527-44ac-a4ab-5dd9ee1c8430" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = '8ee71aab-4527-44ac-a4ab-5dd9ee1c8430' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
23	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: [`"9474dc82-5b07-4dcb-9052-2ba2fb0c930e" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = '9474dc82-5b07-4dcb-9052-2ba2fb0c930e' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
24	0.55 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: [`"dda4f133-9e9f-4269-a815-4ff71a83844c" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = 'dda4f133-9e9f-4269-a815-4ff71a83844c' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
25	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: [`"2f7f9a56-e1c3-436c-bb8e-fd6cb94c7571" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = '2f7f9a56-e1c3-436c-bb8e-fd6cb94c7571' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
26	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: [`"412e4e7f-b458-4c3a-ad7f-aed5e4baf415" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = '412e4e7f-b458-4c3a-ad7f-aed5e4baf415' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
27	0.50 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: [`"e589b772-22c4-4d48-a96d-c805b4c76c7f" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = 'e589b772-22c4-4d48-a96d-c805b4c76c7f' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
28	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: [`"e598e571-31d5-49ce-b948-ffa161322298" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = 'e598e571-31d5-49ce-b948-ffa161322298' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
29	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: [`"2fad8d30-ffb6-407d-9b73-95f0f66f1729" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = '2fad8d30-ffb6-407d-9b73-95f0f66f1729' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
30	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: [`"13b8a52a-c5d5-4398-bfeb-1f2df87befe5" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = '13b8a52a-c5d5-4398-bfeb-1f2df87befe5' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
31	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: [`"4c6fd43f-7366-4f4a-9a58-682e35ac774b" "2026-09-02 00:00:00" "2026-12-03 07:13:07" "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 = '4c6fd43f-7366-4f4a-9a58-682e35ac774b' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 07:13:07' 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/search/workshop?latitude=43.2962&location=marseille&longitude=5.3698

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping