Symfony Profiler

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

Query Metrics

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?

[
  "14"
  "fr"
  "App\Entity\Category"
]

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '14' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Category';

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.whatsapp_number AS whatsapp_number_7, t0.phone AS phone_8, t0.address AS address_9, t0.avatar AS avatar_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.username AS username_13, t14.id AS id_15, t14.speciality AS speciality_16, t14.created_at AS created_at_17, t14.updated_at AS updated_at_18, t14.user_id AS user_id_19, t0.ville_id AS ville_id_20, t0.region_id AS region_id_21, t22.id AS id_23, t22.created_at AS created_at_24, t22.updated_at AS updated_at_25, t22.user_id AS user_id_26 FROM user t0 LEFT JOIN artisan t14 ON t14.user_id = t0.id LEFT JOIN client t22 ON t22.user_id = t0.id WHERE t0.id = ?

[
  16
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.whatsapp_number AS whatsapp_number_7,
  t0.phone AS phone_8,
  t0.address AS address_9,
  t0.avatar AS avatar_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.username AS username_13,
  t14.id AS id_15,
  t14.speciality AS speciality_16,
  t14.created_at AS created_at_17,
  t14.updated_at AS updated_at_18,
  t14.user_id AS user_id_19,
  t0.ville_id AS ville_id_20,
  t0.region_id AS region_id_21,
  t22.id AS id_23,
  t22.created_at AS created_at_24,
  t22.updated_at AS updated_at_25,
  t22.user_id AS user_id_26
FROM
  user t0
  LEFT JOIN artisan t14 ON t14.user_id = t0.id
  LEFT JOIN client t22 ON t22.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.whatsapp_number AS whatsapp_number_7, t0.phone AS phone_8, t0.address AS address_9, t0.avatar AS avatar_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.username AS username_13, t14.id AS id_15, t14.speciality AS speciality_16, t14.created_at AS created_at_17, t14.updated_at AS updated_at_18, t14.user_id AS user_id_19, t0.ville_id AS ville_id_20, t0.region_id AS region_id_21, t22.id AS id_23, t22.created_at AS created_at_24, t22.updated_at AS updated_at_25, t22.user_id AS user_id_26 FROM user t0 LEFT JOIN artisan t14 ON t14.user_id = t0.id LEFT JOIN client t22 ON t22.user_id = t0.id WHERE t0.id = 16;

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.budget AS budget_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.expires_on AS expires_on_6, c0_.slug AS slug_7, c0_.deleted_at AS deleted_at_8, c0_.views AS views_9, c0_.phone_click_count AS phone_click_count_10, c0_.phone_reveal_count AS phone_reveal_count_11, c0_.client_id AS client_id_12, c0_.service_category_id AS service_category_id_13, c0_.ville_id AS ville_id_14, c0_.region_id AS region_id_15, c0_.status_id AS status_id_16, c0_.assigned_artisan_id AS assigned_artisan_id_17 FROM client_request c0_ LEFT JOIN ville v1_ ON c0_.ville_id = v1_.id ORDER BY c0_.created_at DESC

[]

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.description AS description_2,
  c0_.budget AS budget_3,
  c0_.created_at AS created_at_4,
  c0_.updated_at AS updated_at_5,
  c0_.expires_on AS expires_on_6,
  c0_.slug AS slug_7,
  c0_.deleted_at AS deleted_at_8,
  c0_.views AS views_9,
  c0_.phone_click_count AS phone_click_count_10,
  c0_.phone_reveal_count AS phone_reveal_count_11,
  c0_.client_id AS client_id_12,
  c0_.service_category_id AS service_category_id_13,
  c0_.ville_id AS ville_id_14,
  c0_.region_id AS region_id_15,
  c0_.status_id AS status_id_16,
  c0_.assigned_artisan_id AS assigned_artisan_id_17
FROM
  client_request c0_
  LEFT JOIN ville v1_ ON c0_.ville_id = v1_.id
ORDER BY
  c0_.created_at DESC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.budget AS budget_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.expires_on AS expires_on_6, c0_.slug AS slug_7, c0_.deleted_at AS deleted_at_8, c0_.views AS views_9, c0_.phone_click_count AS phone_click_count_10, c0_.phone_reveal_count AS phone_reveal_count_11, c0_.client_id AS client_id_12, c0_.service_category_id AS service_category_id_13, c0_.ville_id AS ville_id_14, c0_.region_id AS region_id_15, c0_.status_id AS status_id_16, c0_.assigned_artisan_id AS assigned_artisan_id_17 FROM client_request c0_ LEFT JOIN ville v1_ ON c0_.ville_id = v1_.id ORDER BY c0_.created_at DESC;

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4 FROM client t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.user_id AS user_id_4
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4 FROM client t0 WHERE t0.id = 1;

SELECT c0_.id AS id_0, c0_.name AS name_1, COUNT(a1_.id) AS sclr_2 FROM artisan_post a1_ INNER JOIN category c0_ ON a1_.category_id = c0_.id GROUP BY c0_.id, c0_.name ORDER BY sclr_2 DESC LIMIT 5

[]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  COUNT(a1_.id) AS sclr_2
FROM
  artisan_post a1_
  INNER JOIN category c0_ ON a1_.category_id = c0_.id
GROUP BY
  c0_.id,
  c0_.name
ORDER BY
  sclr_2 DESC
LIMIT
  5

SELECT c0_.id AS id_0, c0_.name AS name_1, COUNT(a1_.id) AS sclr_2 FROM artisan_post a1_ INNER JOIN category c0_ ON a1_.category_id = c0_.id GROUP BY c0_.id, c0_.name ORDER BY sclr_2 DESC LIMIT 5;

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.menu_order AS menu_order_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.icon AS icon_8, t0.parent_category_id AS parent_category_id_9 FROM category t0 ORDER BY t0.menu_order ASC LIMIT 10

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.menu_order AS menu_order_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.status AS status_7,
  t0.icon AS icon_8,
  t0.parent_category_id AS parent_category_id_9
FROM
  category t0
ORDER BY
  t0.menu_order ASC
LIMIT
  10

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.menu_order AS menu_order_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.icon AS icon_8, t0.parent_category_id AS parent_category_id_9 FROM category t0 ORDER BY t0.menu_order ASC LIMIT 10;

SELECT t0.id AS id_1, t0.name AS name_2, t0.postal_code AS postal_code_3 FROM ville t0 ORDER BY t0.id ASC LIMIT 10

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.postal_code AS postal_code_3
FROM
  ville t0
ORDER BY
  t0.id ASC
LIMIT
  10

SELECT t0.id AS id_1, t0.name AS name_2, t0.postal_code AS postal_code_3 FROM ville t0 ORDER BY t0.id ASC LIMIT 10;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.menu_order AS menu_order_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.status AS status_6, c0_.icon AS icon_7, c0_.parent_category_id AS parent_category_id_8 FROM category c0_

[]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.menu_order AS menu_order_3,
  c0_.created_at AS created_at_4,
  c0_.updated_at AS updated_at_5,
  c0_.status AS status_6,
  c0_.icon AS icon_7,
  c0_.parent_category_id AS parent_category_id_8
FROM
  category c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.menu_order AS menu_order_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.status AS status_6, c0_.icon AS icon_7, c0_.parent_category_id AS parent_category_id_8 FROM category c0_;

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.postal_code AS postal_code_2 FROM ville v0_

[]

SELECT
  v0_.id AS id_0,
  v0_.name AS name_1,
  v0_.postal_code AS postal_code_2
FROM
  ville v0_

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.postal_code AS postal_code_2 FROM ville v0_;