Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 4
• Events
• Routing
• Cache
• Security
• Twig
• Doctrine
• Debug
• Emails
• Configuration

Query Metrics

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.short_description AS short_description_4, b0_.phone AS phone_5, b0_.email AS email_6, b0_.website AS website_7, b0_.address AS address_8, b0_.city AS city_9, b0_.postal_code AS postal_code_10, b0_.latitude AS latitude_11, b0_.longitude AS longitude_12, b0_.facebook_url AS facebook_url_13, b0_.instagram_url AS instagram_url_14, b0_.working_hours AS working_hours_15, b0_.is_active AS is_active_16, b0_.is_featured AS is_featured_17, b0_.booking_enabled AS booking_enabled_18, b0_.auto_accept_bookings AS auto_accept_bookings_19, b0_.max_daily_appointments AS max_daily_appointments_20, b0_.created_at AS created_at_21, b0_.updated_at AS updated_at_22, b0_.owner_id AS owner_id_23, b0_.category_id AS category_id_24 FROM businesses b0_ WHERE b0_.is_active = ? AND b0_.is_featured = ? ORDER BY b0_.created_at DESC LIMIT 6

[
  1
  1
]

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.slug AS slug_2,
  b0_.description AS description_3,
  b0_.short_description AS short_description_4,
  b0_.phone AS phone_5,
  b0_.email AS email_6,
  b0_.website AS website_7,
  b0_.address AS address_8,
  b0_.city AS city_9,
  b0_.postal_code AS postal_code_10,
  b0_.latitude AS latitude_11,
  b0_.longitude AS longitude_12,
  b0_.facebook_url AS facebook_url_13,
  b0_.instagram_url AS instagram_url_14,
  b0_.working_hours AS working_hours_15,
  b0_.is_active AS is_active_16,
  b0_.is_featured AS is_featured_17,
  b0_.booking_enabled AS booking_enabled_18,
  b0_.auto_accept_bookings AS auto_accept_bookings_19,
  b0_.max_daily_appointments AS max_daily_appointments_20,
  b0_.created_at AS created_at_21,
  b0_.updated_at AS updated_at_22,
  b0_.owner_id AS owner_id_23,
  b0_.category_id AS category_id_24
FROM
  businesses b0_
WHERE
  b0_.is_active = ?
  AND b0_.is_featured = ?
ORDER BY
  b0_.created_at DESC
LIMIT
  6

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.short_description AS short_description_4, b0_.phone AS phone_5, b0_.email AS email_6, b0_.website AS website_7, b0_.address AS address_8, b0_.city AS city_9, b0_.postal_code AS postal_code_10, b0_.latitude AS latitude_11, b0_.longitude AS longitude_12, b0_.facebook_url AS facebook_url_13, b0_.instagram_url AS instagram_url_14, b0_.working_hours AS working_hours_15, b0_.is_active AS is_active_16, b0_.is_featured AS is_featured_17, b0_.booking_enabled AS booking_enabled_18, b0_.auto_accept_bookings AS auto_accept_bookings_19, b0_.max_daily_appointments AS max_daily_appointments_20, b0_.created_at AS created_at_21, b0_.updated_at AS updated_at_22, b0_.owner_id AS owner_id_23, b0_.category_id AS category_id_24 FROM businesses b0_ WHERE b0_.is_active = 1 AND b0_.is_featured = 1 ORDER BY b0_.created_at DESC LIMIT 6;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.icon AS icon_3, c0_.sort_order AS sort_order_4 FROM categories c0_ ORDER BY c0_.sort_order ASC

[]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.icon AS icon_3,
  c0_.sort_order AS sort_order_4
FROM
  categories c0_
ORDER BY
  c0_.sort_order ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.icon AS icon_3, c0_.sort_order AS sort_order_4 FROM categories c0_ ORDER BY c0_.sort_order ASC;

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.short_description AS short_description_4, b0_.phone AS phone_5, b0_.email AS email_6, b0_.website AS website_7, b0_.address AS address_8, b0_.city AS city_9, b0_.postal_code AS postal_code_10, b0_.latitude AS latitude_11, b0_.longitude AS longitude_12, b0_.facebook_url AS facebook_url_13, b0_.instagram_url AS instagram_url_14, b0_.working_hours AS working_hours_15, b0_.is_active AS is_active_16, b0_.is_featured AS is_featured_17, b0_.booking_enabled AS booking_enabled_18, b0_.auto_accept_bookings AS auto_accept_bookings_19, b0_.max_daily_appointments AS max_daily_appointments_20, b0_.created_at AS created_at_21, b0_.updated_at AS updated_at_22, b0_.owner_id AS owner_id_23, b0_.category_id AS category_id_24 FROM businesses b0_ WHERE b0_.is_active = ? ORDER BY b0_.is_featured DESC, b0_.created_at DESC LIMIT 8

[
  1
]

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.slug AS slug_2,
  b0_.description AS description_3,
  b0_.short_description AS short_description_4,
  b0_.phone AS phone_5,
  b0_.email AS email_6,
  b0_.website AS website_7,
  b0_.address AS address_8,
  b0_.city AS city_9,
  b0_.postal_code AS postal_code_10,
  b0_.latitude AS latitude_11,
  b0_.longitude AS longitude_12,
  b0_.facebook_url AS facebook_url_13,
  b0_.instagram_url AS instagram_url_14,
  b0_.working_hours AS working_hours_15,
  b0_.is_active AS is_active_16,
  b0_.is_featured AS is_featured_17,
  b0_.booking_enabled AS booking_enabled_18,
  b0_.auto_accept_bookings AS auto_accept_bookings_19,
  b0_.max_daily_appointments AS max_daily_appointments_20,
  b0_.created_at AS created_at_21,
  b0_.updated_at AS updated_at_22,
  b0_.owner_id AS owner_id_23,
  b0_.category_id AS category_id_24
FROM
  businesses b0_
WHERE
  b0_.is_active = ?
ORDER BY
  b0_.is_featured DESC,
  b0_.created_at DESC
LIMIT
  8

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.short_description AS short_description_4, b0_.phone AS phone_5, b0_.email AS email_6, b0_.website AS website_7, b0_.address AS address_8, b0_.city AS city_9, b0_.postal_code AS postal_code_10, b0_.latitude AS latitude_11, b0_.longitude AS longitude_12, b0_.facebook_url AS facebook_url_13, b0_.instagram_url AS instagram_url_14, b0_.working_hours AS working_hours_15, b0_.is_active AS is_active_16, b0_.is_featured AS is_featured_17, b0_.booking_enabled AS booking_enabled_18, b0_.auto_accept_bookings AS auto_accept_bookings_19, b0_.max_daily_appointments AS max_daily_appointments_20, b0_.created_at AS created_at_21, b0_.updated_at AS updated_at_22, b0_.owner_id AS owner_id_23, b0_.category_id AS category_id_24 FROM businesses b0_ WHERE b0_.is_active = 1 ORDER BY b0_.is_featured DESC, b0_.created_at DESC LIMIT 8;

SELECT COUNT(b0_.id) AS sclr_0 FROM businesses b0_ WHERE b0_.is_active = ?

[
  1
]

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  businesses b0_
WHERE
  b0_.is_active = ?

SELECT COUNT(b0_.id) AS sclr_0 FROM businesses b0_ WHERE b0_.is_active = 1;

SELECT DISTINCT b0_.city AS city_0 FROM businesses b0_ WHERE b0_.is_active = ? ORDER BY b0_.city ASC

[
  1
]

SELECT
  DISTINCT b0_.city AS city_0
FROM
  businesses b0_
WHERE
  b0_.is_active = ?
ORDER BY
  b0_.city ASC

SELECT DISTINCT b0_.city AS city_0 FROM businesses b0_ WHERE b0_.is_active = 1 ORDER BY b0_.city ASC;