Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine
• Migrations
• Messages
• Emails
• Notifications
• Serializer
• JMS Serializer 0 + 0
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = ? LIMIT 1

[
  "module_order_delivery_info"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.upload AS upload_4,
  t0.description AS description_5
FROM
  environment_parameter t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = 'module_order_delivery_info' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.upload AS upload_4,
  t0.description AS description_5
FROM
  environment_parameter t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0;

SELECT COUNT(s0_.id) AS sclr_0 FROM sales_lead s0_ LEFT JOIN sales_lead_log s1_ ON s0_.id = s1_.sales_lead_id LEFT JOIN sales_lead_log s2_ ON s0_.id = s2_.sales_lead_id AND (s0_.id = s2_.sales_lead_id AND s1_.id < s2_.id AND s2_.is_deleted = 0) WHERE s2_.id IS NULL AND s0_.is_deleted = 0 AND s0_.lead_responsible_id = ? AND ((s1_.is_deleted = 0 AND s1_.is_finished = 0) OR s1_.id IS NULL)

[
  1
]

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  sales_lead s0_
  LEFT JOIN sales_lead_log s1_ ON s0_.id = s1_.sales_lead_id
  LEFT JOIN sales_lead_log s2_ ON s0_.id = s2_.sales_lead_id
  AND (
    s0_.id = s2_.sales_lead_id
    AND s1_.id < s2_.id
    AND s2_.is_deleted = 0
  )
WHERE
  s2_.id IS NULL
  AND s0_.is_deleted = 0
  AND s0_.lead_responsible_id = ?
  AND (
    (
      s1_.is_deleted = 0
      AND s1_.is_finished = 0
    )
    OR s1_.id IS NULL
  )

SELECT COUNT(s0_.id) AS sclr_0 FROM sales_lead s0_ LEFT JOIN sales_lead_log s1_ ON s0_.id = s1_.sales_lead_id LEFT JOIN sales_lead_log s2_ ON s0_.id = s2_.sales_lead_id AND (s0_.id = s2_.sales_lead_id AND s1_.id < s2_.id AND s2_.is_deleted = 0) WHERE s2_.id IS NULL AND s0_.is_deleted = 0 AND s0_.lead_responsible_id = 1 AND ((s1_.is_deleted = 0 AND s1_.is_finished = 0) OR s1_.id IS NULL);

SELECT t0.id AS id_1, t0.username AS username_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.email AS email_7, t0.mobile AS mobile_8, t0.phone AS phone_9, t0.profile_picture AS profile_picture_10, t0.shiftbase_identification AS shiftbase_identification_11, t0.default_office_calendar AS default_office_calendar_12, t0.default_office_category AS default_office_category_13, t0.counter_display_mode AS counter_display_mode_14, t0.create_date AS create_date_15, t0.modify_date AS modify_date_16, t0.is_deleted AS is_deleted_17, t0.enable_call_notifications AS enable_call_notifications_18, t0.enable_call_end_notifications AS enable_call_end_notifications_19, t0.is_api_user AS is_api_user_20, t0.allowed_ip_addresses AS allowed_ip_addresses_21, t0.created_by_user_id AS created_by_user_id_22, t0.modified_by_user_id AS modified_by_user_id_23 FROM user t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.username AS username_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.email AS email_7,
  t0.mobile AS mobile_8,
  t0.phone AS phone_9,
  t0.profile_picture AS profile_picture_10,
  t0.shiftbase_identification AS shiftbase_identification_11,
  t0.default_office_calendar AS default_office_calendar_12,
  t0.default_office_category AS default_office_category_13,
  t0.counter_display_mode AS counter_display_mode_14,
  t0.create_date AS create_date_15,
  t0.modify_date AS modify_date_16,
  t0.is_deleted AS is_deleted_17,
  t0.enable_call_notifications AS enable_call_notifications_18,
  t0.enable_call_end_notifications AS enable_call_end_notifications_19,
  t0.is_api_user AS is_api_user_20,
  t0.allowed_ip_addresses AS allowed_ip_addresses_21,
  t0.created_by_user_id AS created_by_user_id_22,
  t0.modified_by_user_id AS modified_by_user_id_23
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_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.email AS email_7, t0.mobile AS mobile_8, t0.phone AS phone_9, t0.profile_picture AS profile_picture_10, t0.shiftbase_identification AS shiftbase_identification_11, t0.default_office_calendar AS default_office_calendar_12, t0.default_office_category AS default_office_category_13, t0.counter_display_mode AS counter_display_mode_14, t0.create_date AS create_date_15, t0.modify_date AS modify_date_16, t0.is_deleted AS is_deleted_17, t0.enable_call_notifications AS enable_call_notifications_18, t0.enable_call_end_notifications AS enable_call_end_notifications_19, t0.is_api_user AS is_api_user_20, t0.allowed_ip_addresses AS allowed_ip_addresses_21, t0.created_by_user_id AS created_by_user_id_22, t0.modified_by_user_id AS modified_by_user_id_23 FROM user t0 WHERE t0.id = 1;