Symfony Profiler

Query Metrics

31 Database Queries

2 Different statements

150.08 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,
        (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
AND (EXISTS (
                SELECT 1
                FROM jsonb_array_elements_text(w.practice_type_keys::jsonb) AS p(val)
                WHERE p.val = :practice_raw_0 OR p.val = :practice_stripped_0
            )) 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	23.50 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, (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 AND (EXISTS ( SELECT 1 FROM jsonb_array_elements_text(w.practice_type_keys::jsonb) AS p(val) WHERE p.val = :practice_raw_0 OR p.val = :practice_stripped_0 )) ORDER BY w.next_available_date ASC NULLS LAST, distance_km ASC NULLS LAST LIMIT :limit Parameters: [`"lat" => 45.764043 "lng" => 4.835659 "status" => "status.public" "radiusKm" => 20 "practice_raw_0" => "supported_practice_type.leisure" "practice_stripped_0" => "leisure" "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, ( 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 AND ( EXISTS ( SELECT 1 FROM jsonb_array_elements_text(w.practice_type_keys :: jsonb) AS p(val) WHERE p.val = :practice_raw_0 OR p.val = :practice_stripped_0 ) ) 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, (6371 * acos( cos(radians(45.764043)) * cos(radians(w.lat)) * cos(radians(w.lng) - radians(4.835659)) + sin(radians(45.764043)) * sin(radians(w.lat)) )) AS distance_km FROM workshop w WHERE 1=1 AND w.status = 'status.public' AND ( 6371 * acos( cos(radians(45.764043)) * cos(radians(w.lat)) * cos(radians(w.lng) - radians(4.835659)) + sin(radians(45.764043)) * sin(radians(w.lat)) ) ) <= 20 AND (EXISTS ( SELECT 1 FROM jsonb_array_elements_text(w.practice_type_keys::jsonb) AS p(val) WHERE p.val = 'supported_practice_type.leisure' OR p.val = 'leisure' )) ORDER BY w.next_available_date ASC NULLS LAST, distance_km ASC NULLS LAST LIMIT 30;
2	2.92 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: [`"3334ab13-d6f5-44a0-bfdc-5245617aa4e0" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '3334ab13-d6f5-44a0-bfdc-5245617aa4e0' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
3	10.91 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: [`"2b60bbcf-3dab-4915-8bcc-202049cc40ed" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '2b60bbcf-3dab-4915-8bcc-202049cc40ed' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
4	4.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: [`"ed1fc250-cd77-483d-bf09-0169945cb60e" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = 'ed1fc250-cd77-483d-bf09-0169945cb60e' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
5	5.29 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: [`"b7536877-5928-479d-a842-1241329cbf06" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = 'b7536877-5928-479d-a842-1241329cbf06' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
6	5.12 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: [`"68d9d634-613f-49ff-b176-0f5776ba2af9" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '68d9d634-613f-49ff-b176-0f5776ba2af9' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
7	12.87 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: [`"0ee3ff93-329a-4bea-8e56-f8e4046ac45b" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '0ee3ff93-329a-4bea-8e56-f8e4046ac45b' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
8	5.29 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: [`"1f1133cc-ede7-6d74-a2bd-e32d40dbf090" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '1f1133cc-ede7-6d74-a2bd-e32d40dbf090' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
9	1.84 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: [`"2696f4e4-3f79-4a32-9117-7d5a399ae045" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '2696f4e4-3f79-4a32-9117-7d5a399ae045' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
10	1.79 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: [`"0a189bf9-1f18-4cd8-8b8b-6e63bd1a0845" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '0a189bf9-1f18-4cd8-8b8b-6e63bd1a0845' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
11	5.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: [`"0461c60d-d08a-46df-9a91-131088bfda8e" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '0461c60d-d08a-46df-9a91-131088bfda8e' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
12	6.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: [`"09a55498-44c1-41ac-962c-0ad2fa2458bb" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '09a55498-44c1-41ac-962c-0ad2fa2458bb' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
13	1.88 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: [`"c466804d-f3ed-439c-a943-c3a5eb706713" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = 'c466804d-f3ed-439c-a943-c3a5eb706713' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
14	8.29 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: [`"1acd701f-0d05-4bbd-9cd2-45755d3a3f4d" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '1acd701f-0d05-4bbd-9cd2-45755d3a3f4d' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
15	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: [`"1f108f1f-9de9-6e6e-9f49-9df777e13847" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '1f108f1f-9de9-6e6e-9f49-9df777e13847' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' 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: [`"30a6eea4-6ae6-45b9-9e3d-4142643d895d" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '30a6eea4-6ae6-45b9-9e3d-4142643d895d' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
17	9.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: [`"8e3c8cc4-ea02-41ea-994d-3e82e829cd38" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '8e3c8cc4-ea02-41ea-994d-3e82e829cd38' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
18	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: [`"39477471-bbd0-49ad-85e5-0a78f0afa0ac" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '39477471-bbd0-49ad-85e5-0a78f0afa0ac' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
19	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: [`"1f1133c9-9b4d-6256-a5fe-238cf71d37c4" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '1f1133c9-9b4d-6256-a5fe-238cf71d37c4' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
20	4.82 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: [`"0fd53aec-8900-4dba-abf2-52ca0d98e660" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '0fd53aec-8900-4dba-abf2-52ca0d98e660' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
21	1.72 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: [`"1e7b34cd-5923-4e7b-8012-b78c9fa41703" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '1e7b34cd-5923-4e7b-8012-b78c9fa41703' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
22	6.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: [`"18ef259d-db9b-41d2-8787-f28ee34c06f0" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '18ef259d-db9b-41d2-8787-f28ee34c06f0' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
23	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: [`"5eda0cc8-e1a4-4272-aaa7-0390ed1b28f6" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '5eda0cc8-e1a4-4272-aaa7-0390ed1b28f6' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
24	7.68 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: [`"294f7e6c-9a88-4c13-a957-eaee3e945a8a" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '294f7e6c-9a88-4c13-a957-eaee3e945a8a' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' 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: [`"686cfc11-89f1-4d16-b6a6-7894919b127d" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '686cfc11-89f1-4d16-b6a6-7894919b127d' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
26	8.75 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: [`"4f666020-6d51-4aca-8803-24a9943d85fb" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '4f666020-6d51-4aca-8803-24a9943d85fb' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
27	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: [`"b25bd8d2-7890-42b6-8bf4-e6ce345ca475" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = 'b25bd8d2-7890-42b6-8bf4-e6ce345ca475' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
28	6.98 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: [`"9872c189-ce06-44e8-b275-736e8eb9675e" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '9872c189-ce06-44e8-b275-736e8eb9675e' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
29	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: [`"807038d9-8f9c-452e-99e9-88a752f4cd06" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '807038d9-8f9c-452e-99e9-88a752f4cd06' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
30	3.97 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: [`"b324bb53-a49f-40ec-b9cc-9a754150f76d" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = 'b324bb53-a49f-40ec-b9cc-9a754150f76d' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
31	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: [`"0ac33391-304f-4b9e-8c00-2951b616e50f" "2026-03-15 00:00:00" "2026-06-16 16:34:43" "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 = '0ac33391-304f-4b9e-8c00-2951b616e50f' AND a0_.start_date >= '2026-03-15 00:00:00' AND a0_.start_date <= '2026-06-16 16:34:43' 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 https://recette.junglebike.fr/search/workshop?_locale=fr&latitude=45.764043&location=Lyon%2C%20France&longitude=4.835659&practiceType=supported_practice_type.le…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping