Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 33
• Events
• Routing
• Cache
• Translation 1
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• VichUploader
• JMS Serializer 0 + 0
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.description AS description_4, t0.comment AS comment_5, t0.slug AS slug_6, t0.active AS active_7, t0.phone AS phone_8, t0.primary_color AS primary_color_9, t0.secondary_color AS secondary_color_10, t0.subdomain AS subdomain_11, t0.website AS website_12, t0.deleted_at AS deleted_at_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.logo_id AS logo_id_16, t0.logo_small_id AS logo_small_id_17, t0.parent_id AS parent_id_18, t0.splash_image_id AS splash_image_id_19, t0.address_id AS address_id_20, t0.deleted_by_id AS deleted_by_id_21, t0.created_by_id AS created_by_id_22, t0.updated_by_id AS updated_by_id_23 FROM company t0 WHERE t0.active = ? AND t0.deleted_at IS NULL

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.description AS description_4,
  t0.comment AS comment_5,
  t0.slug AS slug_6,
  t0.active AS active_7,
  t0.phone AS phone_8,
  t0.primary_color AS primary_color_9,
  t0.secondary_color AS secondary_color_10,
  t0.subdomain AS subdomain_11,
  t0.website AS website_12,
  t0.deleted_at AS deleted_at_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.logo_id AS logo_id_16,
  t0.logo_small_id AS logo_small_id_17,
  t0.parent_id AS parent_id_18,
  t0.splash_image_id AS splash_image_id_19,
  t0.address_id AS address_id_20,
  t0.deleted_by_id AS deleted_by_id_21,
  t0.created_by_id AS created_by_id_22,
  t0.updated_by_id AS updated_by_id_23
FROM
  company t0
WHERE
  t0.active = ?
  AND t0.deleted_at IS NULL

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.description AS description_4, t0.comment AS comment_5, t0.slug AS slug_6, t0.active AS active_7, t0.phone AS phone_8, t0.primary_color AS primary_color_9, t0.secondary_color AS secondary_color_10, t0.subdomain AS subdomain_11, t0.website AS website_12, t0.deleted_at AS deleted_at_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.logo_id AS logo_id_16, t0.logo_small_id AS logo_small_id_17, t0.parent_id AS parent_id_18, t0.splash_image_id AS splash_image_id_19, t0.address_id AS address_id_20, t0.deleted_by_id AS deleted_by_id_21, t0.created_by_id AS created_by_id_22, t0.updated_by_id AS updated_by_id_23 FROM company t0 WHERE t0.active = 1 AND t0.deleted_at IS NULL;

SELECT t1.id AS id_2, t1.gender AS gender_3, t1.email AS email_4, t1.roles AS roles_5, t1.password AS password_6, t1.last_logged_at AS last_logged_at_7, t1.firstname AS firstname_8, t1.lastname AS lastname_9, t1.active AS active_10, t1.phone AS phone_11, t1.job AS job_12, t1.language AS language_13, t1.slug AS slug_14, t1.comment AS comment_15, t1.deleted_at AS deleted_at_16, t1.created_at AS created_at_17, t1.updated_at AS updated_at_18, t1.image_id AS image_id_19, t1.address_id AS address_id_20, t1.deleted_by_id AS deleted_by_id_21, t1.created_by_id AS created_by_id_22, t1.updated_by_id AS updated_by_id_23, t1.type FROM user_administrator t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = ?

[
  1
]

SELECT
  t1.id AS id_2,
  t1.gender AS gender_3,
  t1.email AS email_4,
  t1.roles AS roles_5,
  t1.password AS password_6,
  t1.last_logged_at AS last_logged_at_7,
  t1.firstname AS firstname_8,
  t1.lastname AS lastname_9,
  t1.active AS active_10,
  t1.phone AS phone_11,
  t1.job AS job_12,
  t1.language AS language_13,
  t1.slug AS slug_14,
  t1.comment AS comment_15,
  t1.deleted_at AS deleted_at_16,
  t1.created_at AS created_at_17,
  t1.updated_at AS updated_at_18,
  t1.image_id AS image_id_19,
  t1.address_id AS address_id_20,
  t1.deleted_by_id AS deleted_by_id_21,
  t1.created_by_id AS created_by_id_22,
  t1.updated_by_id AS updated_by_id_23,
  t1.type
FROM
  user_administrator t0
  INNER JOIN user t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.gender AS gender_3, t1.email AS email_4, t1.roles AS roles_5, t1.password AS password_6, t1.last_logged_at AS last_logged_at_7, t1.firstname AS firstname_8, t1.lastname AS lastname_9, t1.active AS active_10, t1.phone AS phone_11, t1.job AS job_12, t1.language AS language_13, t1.slug AS slug_14, t1.comment AS comment_15, t1.deleted_at AS deleted_at_16, t1.created_at AS created_at_17, t1.updated_at AS updated_at_18, t1.image_id AS image_id_19, t1.address_id AS address_id_20, t1.deleted_by_id AS deleted_by_id_21, t1.created_by_id AS created_by_id_22, t1.updated_by_id AS updated_by_id_23, t1.type FROM user_administrator t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.description AS description_4, t0.comment AS comment_5, t0.slug AS slug_6, t0.active AS active_7, t0.phone AS phone_8, t0.primary_color AS primary_color_9, t0.secondary_color AS secondary_color_10, t0.subdomain AS subdomain_11, t0.website AS website_12, t0.deleted_at AS deleted_at_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.logo_id AS logo_id_16, t0.logo_small_id AS logo_small_id_17, t0.parent_id AS parent_id_18, t0.splash_image_id AS splash_image_id_19, t0.address_id AS address_id_20, t0.deleted_by_id AS deleted_by_id_21, t0.created_by_id AS created_by_id_22, t0.updated_by_id AS updated_by_id_23 FROM company t0 WHERE t0.active = ? AND t0.deleted_at IS NULL

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.description AS description_4,
  t0.comment AS comment_5,
  t0.slug AS slug_6,
  t0.active AS active_7,
  t0.phone AS phone_8,
  t0.primary_color AS primary_color_9,
  t0.secondary_color AS secondary_color_10,
  t0.subdomain AS subdomain_11,
  t0.website AS website_12,
  t0.deleted_at AS deleted_at_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.logo_id AS logo_id_16,
  t0.logo_small_id AS logo_small_id_17,
  t0.parent_id AS parent_id_18,
  t0.splash_image_id AS splash_image_id_19,
  t0.address_id AS address_id_20,
  t0.deleted_by_id AS deleted_by_id_21,
  t0.created_by_id AS created_by_id_22,
  t0.updated_by_id AS updated_by_id_23
FROM
  company t0
WHERE
  t0.active = ?
  AND t0.deleted_at IS NULL

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.description AS description_4, t0.comment AS comment_5, t0.slug AS slug_6, t0.active AS active_7, t0.phone AS phone_8, t0.primary_color AS primary_color_9, t0.secondary_color AS secondary_color_10, t0.subdomain AS subdomain_11, t0.website AS website_12, t0.deleted_at AS deleted_at_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.logo_id AS logo_id_16, t0.logo_small_id AS logo_small_id_17, t0.parent_id AS parent_id_18, t0.splash_image_id AS splash_image_id_19, t0.address_id AS address_id_20, t0.deleted_by_id AS deleted_by_id_21, t0.created_by_id AS created_by_id_22, t0.updated_by_id AS updated_by_id_23 FROM company t0 WHERE t0.active = 1 AND t0.deleted_at IS NULL;

SELECT n0_.criticity AS criticity_0, n0_.name AS name_1, n0_.content_text AS content_text_2, n1_.created_at AS created_at_3, n1_.id AS id_4, n1_.updated_at AS updated_at_5 FROM notification n1_ INNER JOIN notification_type n0_ ON n1_.notification_type_id = n0_.id WHERE n1_.user_id = ? AND n0_.is_app = 1 AND n1_.is_viewed = 0 AND n0_.deleted_at IS NULL ORDER BY n1_.created_at DESC

[
  1
]

SELECT
  n0_.criticity AS criticity_0,
  n0_.name AS name_1,
  n0_.content_text AS content_text_2,
  n1_.created_at AS created_at_3,
  n1_.id AS id_4,
  n1_.updated_at AS updated_at_5
FROM
  notification n1_
  INNER JOIN notification_type n0_ ON n1_.notification_type_id = n0_.id
WHERE
  n1_.user_id = ?
  AND n0_.is_app = 1
  AND n1_.is_viewed = 0
  AND n0_.deleted_at IS NULL
ORDER BY
  n1_.created_at DESC

SELECT n0_.criticity AS criticity_0, n0_.name AS name_1, n0_.content_text AS content_text_2, n1_.created_at AS created_at_3, n1_.id AS id_4, n1_.updated_at AS updated_at_5 FROM notification n1_ INNER JOIN notification_type n0_ ON n1_.notification_type_id = n0_.id WHERE n1_.user_id = 1 AND n0_.is_app = 1 AND n1_.is_viewed = 0 AND n0_.deleted_at IS NULL ORDER BY n1_.created_at DESC;

SELECT t0.id AS id_1, t0.is_viewed AS is_viewed_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.notification_type_id AS notification_type_id_5, t0.user_id AS user_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM notification t0 WHERE t0.id = ?

[
  4
]

SELECT
  t0.id AS id_1,
  t0.is_viewed AS is_viewed_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.notification_type_id AS notification_type_id_5,
  t0.user_id AS user_id_6,
  t0.created_by_id AS created_by_id_7,
  t0.updated_by_id AS updated_by_id_8
FROM
  notification t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.is_viewed AS is_viewed_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.notification_type_id AS notification_type_id_5, t0.user_id AS user_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM notification t0 WHERE t0.id = 4;