Symfony Profiler

• Request / Response
• Performance
• Validator
• Exception
• Logs
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine 1
• Emails
• Serializer
• Configuration

Query Metrics

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, NULL AS distance_km FROM workshop w WHERE 1=1 AND w.status = :status AND (
            LOWER(w.city)        LIKE LOWER(:locationLike)
            OR LOWER(w.postal_code) LIKE LOWER(:locationLike)
            OR LOWER(w.address)  LIKE LOWER(:locationLike)
            OR LOWER(w.country)  LIKE LOWER(:locationLike)
        ) ORDER BY w.created_at DESC NULLS LAST LIMIT :limit

[
  "status" => "status.public"
  "locationLike" => "%latitude=bordeaux%"
  "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,
  NULL AS distance_km
FROM
  workshop w
WHERE
  1 = 1
  AND w.status = :status
  AND (
    LOWER(w.city) LIKE LOWER(:locationLike)
    OR LOWER(w.postal_code) LIKE LOWER(:locationLike)
    OR LOWER(w.address) LIKE LOWER(:locationLike)
    OR LOWER(w.country) LIKE LOWER(:locationLike)
  )
ORDER BY
  w.created_at DESC 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, NULL AS distance_km FROM workshop w WHERE 1=1 AND w.status = 'status.public' AND (
            LOWER(w.city)        LIKE LOWER('%latitude=bordeaux%')
            OR LOWER(w.postal_code) LIKE LOWER('%latitude=bordeaux%')
            OR LOWER(w.address)  LIKE LOWER('%latitude=bordeaux%')
            OR LOWER(w.country)  LIKE LOWER('%latitude=bordeaux%')
        ) ORDER BY w.created_at DESC NULLS LAST LIMIT 30;