Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 7
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• VichUploader
• Configuration

Query Metrics

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.slug AS slug_2, r0_.description AS description_3, r0_.address AS address_4, r0_.city AS city_5, r0_.postal_code AS postal_code_6, r0_.country AS country_7, r0_.latitude AS latitude_8, r0_.longitude AS longitude_9, r0_.phone AS phone_10, r0_.email AS email_11, r0_.website AS website_12, r0_.logo AS logo_13, r0_.cover_image AS cover_image_14, r0_.opening_hours AS opening_hours_15, r0_.is_active AS is_active_16, r0_.is_verified AS is_verified_17, r0_.subscription_type AS subscription_type_18, r0_.subscription_expires_at AS subscription_expires_at_19, r0_.created_at AS created_at_20, r0_.updated_at AS updated_at_21, r0_.source_provider AS source_provider_22, r0_.source_external_id AS source_external_id_23, r0_.imported_at AS imported_at_24, r0_.contribution_status AS contribution_status_25, r0_.owner_id AS owner_id_26, r0_.contributed_by_id AS contributed_by_id_27 FROM restaurant r0_ WHERE r0_.is_active = ? AND r0_.city = ? ORDER BY r0_.name ASC

[
  1
  "Paris"
]

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.slug AS slug_2,
  r0_.description AS description_3,
  r0_.address AS address_4,
  r0_.city AS city_5,
  r0_.postal_code AS postal_code_6,
  r0_.country AS country_7,
  r0_.latitude AS latitude_8,
  r0_.longitude AS longitude_9,
  r0_.phone AS phone_10,
  r0_.email AS email_11,
  r0_.website AS website_12,
  r0_.logo AS logo_13,
  r0_.cover_image AS cover_image_14,
  r0_.opening_hours AS opening_hours_15,
  r0_.is_active AS is_active_16,
  r0_.is_verified AS is_verified_17,
  r0_.subscription_type AS subscription_type_18,
  r0_.subscription_expires_at AS subscription_expires_at_19,
  r0_.created_at AS created_at_20,
  r0_.updated_at AS updated_at_21,
  r0_.source_provider AS source_provider_22,
  r0_.source_external_id AS source_external_id_23,
  r0_.imported_at AS imported_at_24,
  r0_.contribution_status AS contribution_status_25,
  r0_.owner_id AS owner_id_26,
  r0_.contributed_by_id AS contributed_by_id_27
FROM
  restaurant r0_
WHERE
  r0_.is_active = ?
  AND r0_.city = ?
ORDER BY
  r0_.name ASC

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.slug AS slug_2, r0_.description AS description_3, r0_.address AS address_4, r0_.city AS city_5, r0_.postal_code AS postal_code_6, r0_.country AS country_7, r0_.latitude AS latitude_8, r0_.longitude AS longitude_9, r0_.phone AS phone_10, r0_.email AS email_11, r0_.website AS website_12, r0_.logo AS logo_13, r0_.cover_image AS cover_image_14, r0_.opening_hours AS opening_hours_15, r0_.is_active AS is_active_16, r0_.is_verified AS is_verified_17, r0_.subscription_type AS subscription_type_18, r0_.subscription_expires_at AS subscription_expires_at_19, r0_.created_at AS created_at_20, r0_.updated_at AS updated_at_21, r0_.source_provider AS source_provider_22, r0_.source_external_id AS source_external_id_23, r0_.imported_at AS imported_at_24, r0_.contribution_status AS contribution_status_25, r0_.owner_id AS owner_id_26, r0_.contributed_by_id AS contributed_by_id_27 FROM restaurant r0_ WHERE r0_.is_active = 1 AND r0_.city = 'Paris' ORDER BY r0_.name ASC;

SELECT DISTINCT r0_.city AS city_0 FROM restaurant r0_ WHERE r0_.is_active = ? ORDER BY r0_.city ASC

[
  1
]

SELECT
  DISTINCT r0_.city AS city_0
FROM
  restaurant r0_
WHERE
  r0_.is_active = ?
ORDER BY
  r0_.city ASC

SELECT DISTINCT r0_.city AS city_0 FROM restaurant r0_ WHERE r0_.is_active = 1 ORDER BY r0_.city ASC;