Symfony Profiler

• Request / Response
• Performance
• Validator
• Exception
• Logs 16
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 2
• Emails
• Serializer
• Vite
• Configuration

Query Metrics

SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC

[
  "40350466-a55a-476e-8b5b-a86d2dc5cf7d"
  "2026-04-03 00:00:00"
  "2026-07-04 09:04:58"
  "CANCELED"
]

SELECT
  a0_.start_date AS start_date_0,
  a0_.end_date AS end_date_1
FROM
  appointment a0_
  INNER JOIN workshop w1_ ON a0_.workshop_id = 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-04-03 00:00:00' AND a0_.start_date <= '2026-07-04 09:04:58' AND a0_.status NOT IN ('CANCELED') ORDER BY a0_.start_date ASC;

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 ORDER BY w.next_available_date ASC NULLS LAST, distance_km ASC NULLS LAST LIMIT :limit

[
  "lat" => 43.2962
  "lng" => 5.3698
  "status" => "status.public"
  "radiusKm" => 20
  "limit" => 30
]

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
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(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;