Symfony Profiler

Query Metrics

31 Database Queries

2 Different statements

25.04 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	11.73 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" => 45.7578 "lng" => 4.832 "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(45.7578)) * cos(radians(w.lat)) * cos(radians(w.lng) - radians(4.832)) + sin(radians(45.7578)) * sin(radians(w.lat)) )) AS distance_km FROM workshop w WHERE 1=1 AND w.status = 'status.public' AND ( 6371 * acos( cos(radians(45.7578)) * cos(radians(w.lat)) * cos(radians(w.lng) - radians(4.832)) + sin(radians(45.7578)) * sin(radians(w.lat)) ) ) <= 20 ORDER BY w.next_available_date ASC NULLS LAST, distance_km ASC NULLS LAST LIMIT 30;
2	1.01 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-09-02 00:00:00" "2026-12-03 01:12: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 = '0ee3ff93-329a-4bea-8e56-f8e4046ac45b' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
3	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: [`"32dfae3e-184b-4204-a646-17bf690534c1" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = '32dfae3e-184b-4204-a646-17bf690534c1' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' 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: [`"2696f4e4-3f79-4a32-9117-7d5a399ae045" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = '2696f4e4-3f79-4a32-9117-7d5a399ae045' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
5	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: [`"807038d9-8f9c-452e-99e9-88a752f4cd06" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = '807038d9-8f9c-452e-99e9-88a752f4cd06' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
6	0.39 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: [`"e58fa7e9-8f84-449f-868b-9eed142b3bc7" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = 'e58fa7e9-8f84-449f-868b-9eed142b3bc7' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
7	0.39 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-09-02 00:00:00" "2026-12-03 01:12: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 = '3334ab13-d6f5-44a0-bfdc-5245617aa4e0' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
8	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: [`"2b60bbcf-3dab-4915-8bcc-202049cc40ed" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = '2b60bbcf-3dab-4915-8bcc-202049cc40ed' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
9	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: [`"a4a57fe2-397e-49e9-9b31-8915b196bae7" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = 'a4a57fe2-397e-49e9-9b31-8915b196bae7' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
10	0.39 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: [`"5fb1edcb-3f9c-4c82-9540-bea3495f12a0" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = '5fb1edcb-3f9c-4c82-9540-bea3495f12a0' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
11	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: [`"b324bb53-a49f-40ec-b9cc-9a754150f76d" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = 'b324bb53-a49f-40ec-b9cc-9a754150f76d' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
12	0.39 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: [`"3b6c8063-e407-4e7a-b7c1-3f6c6f56e10a" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = '3b6c8063-e407-4e7a-b7c1-3f6c6f56e10a' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
13	0.57 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-09-02 00:00:00" "2026-12-03 01:12: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 = 'ed1fc250-cd77-483d-bf09-0169945cb60e' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
14	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: [`"dca46f03-ea64-4653-af3d-eaca2ba93753" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = 'dca46f03-ea64-4653-af3d-eaca2ba93753' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
15	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: [`"03880e35-bf18-4d8f-9e2e-32047c1eacce" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = '03880e35-bf18-4d8f-9e2e-32047c1eacce' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
16	0.39 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: [`"3afbf747-bf6b-46d8-a6d9-fac3b61cd1bd" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = '3afbf747-bf6b-46d8-a6d9-fac3b61cd1bd' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
17	0.39 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-09-02 00:00:00" "2026-12-03 01:12: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 = '0a189bf9-1f18-4cd8-8b8b-6e63bd1a0845' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
18	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: [`"e08431a3-35e3-4ac7-9cbd-446ee46b2675" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = 'e08431a3-35e3-4ac7-9cbd-446ee46b2675' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
19	0.38 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: [`"57bf1f97-c698-44cd-b638-f9bc4ab393be" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = '57bf1f97-c698-44cd-b638-f9bc4ab393be' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12: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: [`"b7536877-5928-479d-a842-1241329cbf06" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = 'b7536877-5928-479d-a842-1241329cbf06' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
21	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: [`"0461c60d-d08a-46df-9a91-131088bfda8e" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = '0461c60d-d08a-46df-9a91-131088bfda8e' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
22	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: [`"fcdcfb80-b501-4d24-b70d-b15ba83a070b" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = 'fcdcfb80-b501-4d24-b70d-b15ba83a070b' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
23	0.39 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: [`"11313790-e93f-43fc-82a0-c6b174301bda" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = '11313790-e93f-43fc-82a0-c6b174301bda' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
24	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: [`"68d9d634-613f-49ff-b176-0f5776ba2af9" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = '68d9d634-613f-49ff-b176-0f5776ba2af9' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' 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: [`"f802b828-911f-47ca-a0f6-b0d1e3d43a81" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = 'f802b828-911f-47ca-a0f6-b0d1e3d43a81' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
26	0.38 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: [`"f54fe60d-6091-4d95-a430-11c8a7a8b6c5" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = 'f54fe60d-6091-4d95-a430-11c8a7a8b6c5' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
27	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: [`"0d78c502-3a2d-4d37-adb3-a85a9fd343c0" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = '0d78c502-3a2d-4d37-adb3-a85a9fd343c0' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
28	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: [`"09a55498-44c1-41ac-962c-0ad2fa2458bb" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = '09a55498-44c1-41ac-962c-0ad2fa2458bb' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
29	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: [`"142b479d-d808-4519-bfa0-86c63fd6987b" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = '142b479d-d808-4519-bfa0-86c63fd6987b' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;
30	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: [`"87eae0f7-a2ad-4446-93e5-faa3a8321cb5" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = '87eae0f7-a2ad-4446-93e5-faa3a8321cb5' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12:07' 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: [`"8e3c8cc4-ea02-41ea-994d-3e82e829cd38" "2026-09-02 00:00:00" "2026-12-03 01:12: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 = '8e3c8cc4-ea02-41ea-994d-3e82e829cd38' AND a0_.start_date >= '2026-09-02 00:00:00' AND a0_.start_date <= '2026-12-03 01:12: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?_locale=fr&latitude=45.7578&location=lyon&longitude=4.832

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping