Symfony Profiler

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

Query Metrics

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.published AS published_2, t0_.position AS position_3 FROM type_of_work t0_ WHERE t0_.published = 1 ORDER BY t0_.position ASC

[]

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.published AS published_2,
  t0_.position AS position_3
FROM
  type_of_work t0_
WHERE
  t0_.published = 1
ORDER BY
  t0_.position ASC

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.published AS published_2, t0_.position AS position_3 FROM type_of_work t0_ WHERE t0_.published = 1 ORDER BY t0_.position ASC;

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.country_name AS country_name_5, t0.zip_code AS zip_code_6, t0.phone AS phone_7, t0.email AS email_8, t0.address AS address_9, t0.published AS published_10 FROM location t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.country_name AS country_name_5,
  t0.zip_code AS zip_code_6,
  t0.phone AS phone_7,
  t0.email AS email_8,
  t0.address AS address_9,
  t0.published AS published_10
FROM
  location t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.country_name AS country_name_5, t0.zip_code AS zip_code_6, t0.phone AS phone_7, t0.email AS email_8, t0.address AS address_9, t0.published AS published_10 FROM location t0 WHERE t0.id = 2;

SELECT t0.id AS id_1, t0.title AS title_2, t0.thumbnail AS thumbnail_3, t0.seo_title AS seo_title_4, t0.slug AS slug_5, t0.brief AS brief_6, t0.content AS content_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM page t0 WHERE t0.slug = ? LIMIT 1

[
  "clients"
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.thumbnail AS thumbnail_3,
  t0.seo_title AS seo_title_4,
  t0.slug AS slug_5,
  t0.brief AS brief_6,
  t0.content AS content_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  page t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.thumbnail AS thumbnail_3, t0.seo_title AS seo_title_4, t0.slug AS slug_5, t0.brief AS brief_6, t0.content AS content_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM page t0 WHERE t0.slug = 'clients' LIMIT 1;

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.postal_code AS postal_code_4, t0.client_photo AS client_photo_5, t0.before_work_photo AS before_work_photo_6, t0.after_work_photo AS after_work_photo_7, t0.work_types AS work_types_8, t0.google_review_online AS google_review_online_9, t0.agency_concerned AS agency_concerned_10, t0.rating AS rating_11, t0.review_source AS review_source_12, t0.publish_online AS publish_online_13, t0.month AS month_14, t0.position AS position_15, t0.created_at AS created_at_16, t0.location_id AS location_id_17 FROM client t0 WHERE t0.publish_online = ? ORDER BY t0.position ASC LIMIT 102

[
  1
]

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.postal_code AS postal_code_4,
  t0.client_photo AS client_photo_5,
  t0.before_work_photo AS before_work_photo_6,
  t0.after_work_photo AS after_work_photo_7,
  t0.work_types AS work_types_8,
  t0.google_review_online AS google_review_online_9,
  t0.agency_concerned AS agency_concerned_10,
  t0.rating AS rating_11,
  t0.review_source AS review_source_12,
  t0.publish_online AS publish_online_13,
  t0.month AS month_14,
  t0.position AS position_15,
  t0.created_at AS created_at_16,
  t0.location_id AS location_id_17
FROM
  client t0
WHERE
  t0.publish_online = ?
ORDER BY
  t0.position ASC
LIMIT
  102

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.postal_code AS postal_code_4, t0.client_photo AS client_photo_5, t0.before_work_photo AS before_work_photo_6, t0.after_work_photo AS after_work_photo_7, t0.work_types AS work_types_8, t0.google_review_online AS google_review_online_9, t0.agency_concerned AS agency_concerned_10, t0.rating AS rating_11, t0.review_source AS review_source_12, t0.publish_online AS publish_online_13, t0.month AS month_14, t0.position AS position_15, t0.created_at AS created_at_16, t0.location_id AS location_id_17 FROM client t0 WHERE t0.publish_online = 1 ORDER BY t0.position ASC LIMIT 102;

SELECT DISTINCT SUBSTRING(c0_.postal_code FROM 1 FOR 2) AS sclr_0 FROM client c0_ WHERE c0_.publish_online = ? AND c0_.postal_code IS NOT NULL ORDER BY sclr_0 ASC

[
  1
]

SELECT
  DISTINCT SUBSTRING(
    c0_.postal_code
    FROM
      1 FOR 2
  ) AS sclr_0
FROM
  client c0_
WHERE
  c0_.publish_online = ?
  AND c0_.postal_code IS NOT NULL
ORDER BY
  sclr_0 ASC

SELECT DISTINCT SUBSTRING(c0_.postal_code FROM 1 FOR 2) AS sclr_0 FROM client c0_ WHERE c0_.publish_online = 1 AND c0_.postal_code IS NOT NULL ORDER BY sclr_0 ASC;