Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.user_id AS user_id_3, t0.car AS car_4, t0.date AS date_5, t0.receipt AS receipt_6, t0.status AS status_7, t0.sms AS sms_8, t0.sms_order_end AS sms_order_end_9, t0.sms_order_end_permission AS sms_order_end_permission_10, t0.photo AS photo_11, t0.mileage AS mileage_12, t0.order_type AS order_type_13, t0.client_id AS client_id_14, t0.car_id AS car_id_15, t0.photos AS photos_16, t0.invoice_number AS invoice_number_17, t0.fiscal_receipt_status AS fiscal_receipt_status_18, t0.declaration AS declaration_19, t0.detailing AS detailing_20, t0.complaint AS complaint_21, t0.consultant AS consultant_22, t0.tools AS tools_23, t0.explains AS explains_24, t0.special_verification AS special_verification_25, t0.finished AS finished_26, t0.is_waiting AS is_waiting_27, t0.stop_order AS stop_order_28, t0.dateset AS dateset_29, t0.dateend AS dateend_30, t0.datein AS datein_31, t0.suggested_repair_date AS suggested_repair_date_32, t0.repair_start AS repair_start_33, t0.suggested_repair_date_approval AS suggested_repair_date_approval_34, t0.reservation AS reservation_35, t0.user_id AS user_id_36, t0.consultant AS consultant_37 FROM orders t0 WHERE t0.id = ?

[
  59191
]

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.user_id AS user_id_3,
  t0.car AS car_4,
  t0.date AS date_5,
  t0.receipt AS receipt_6,
  t0.status AS status_7,
  t0.sms AS sms_8,
  t0.sms_order_end AS sms_order_end_9,
  t0.sms_order_end_permission AS sms_order_end_permission_10,
  t0.photo AS photo_11,
  t0.mileage AS mileage_12,
  t0.order_type AS order_type_13,
  t0.client_id AS client_id_14,
  t0.car_id AS car_id_15,
  t0.photos AS photos_16,
  t0.invoice_number AS invoice_number_17,
  t0.fiscal_receipt_status AS fiscal_receipt_status_18,
  t0.declaration AS declaration_19,
  t0.detailing AS detailing_20,
  t0.complaint AS complaint_21,
  t0.consultant AS consultant_22,
  t0.tools AS tools_23,
  t0.explains AS explains_24,
  t0.special_verification AS special_verification_25,
  t0.finished AS finished_26,
  t0.is_waiting AS is_waiting_27,
  t0.stop_order AS stop_order_28,
  t0.dateset AS dateset_29,
  t0.dateend AS dateend_30,
  t0.datein AS datein_31,
  t0.suggested_repair_date AS suggested_repair_date_32,
  t0.repair_start AS repair_start_33,
  t0.suggested_repair_date_approval AS suggested_repair_date_approval_34,
  t0.reservation AS reservation_35,
  t0.user_id AS user_id_36,
  t0.consultant AS consultant_37
FROM
  orders t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.user_id AS user_id_3, t0.car AS car_4, t0.date AS date_5, t0.receipt AS receipt_6, t0.status AS status_7, t0.sms AS sms_8, t0.sms_order_end AS sms_order_end_9, t0.sms_order_end_permission AS sms_order_end_permission_10, t0.photo AS photo_11, t0.mileage AS mileage_12, t0.order_type AS order_type_13, t0.client_id AS client_id_14, t0.car_id AS car_id_15, t0.photos AS photos_16, t0.invoice_number AS invoice_number_17, t0.fiscal_receipt_status AS fiscal_receipt_status_18, t0.declaration AS declaration_19, t0.detailing AS detailing_20, t0.complaint AS complaint_21, t0.consultant AS consultant_22, t0.tools AS tools_23, t0.explains AS explains_24, t0.special_verification AS special_verification_25, t0.finished AS finished_26, t0.is_waiting AS is_waiting_27, t0.stop_order AS stop_order_28, t0.dateset AS dateset_29, t0.dateend AS dateend_30, t0.datein AS datein_31, t0.suggested_repair_date AS suggested_repair_date_32, t0.repair_start AS repair_start_33, t0.suggested_repair_date_approval AS suggested_repair_date_approval_34, t0.reservation AS reservation_35, t0.user_id AS user_id_36, t0.consultant AS consultant_37 FROM orders t0 WHERE t0.id = 59191;

SELECT t0.id AS id_1, t0.kontrahent AS kontrahent_2, t0.name AS name_3, t0.phone AS phone_4, t0.city AS city_5, t0.code AS code_6, t0.street AS street_7, t0.tax AS tax_8, t0.newsletter AS newsletter_9, t0.active AS active_10, t0.firstname AS firstname_11, t0.lastname AS lastname_12, t0.fleet AS fleet_13 FROM clients t0 WHERE t0.id = ?

[
  1588
]

SELECT
  t0.id AS id_1,
  t0.kontrahent AS kontrahent_2,
  t0.name AS name_3,
  t0.phone AS phone_4,
  t0.city AS city_5,
  t0.code AS code_6,
  t0.street AS street_7,
  t0.tax AS tax_8,
  t0.newsletter AS newsletter_9,
  t0.active AS active_10,
  t0.firstname AS firstname_11,
  t0.lastname AS lastname_12,
  t0.fleet AS fleet_13
FROM
  clients t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.kontrahent AS kontrahent_2, t0.name AS name_3, t0.phone AS phone_4, t0.city AS city_5, t0.code AS code_6, t0.street AS street_7, t0.tax AS tax_8, t0.newsletter AS newsletter_9, t0.active AS active_10, t0.firstname AS firstname_11, t0.lastname AS lastname_12, t0.fleet AS fleet_13 FROM clients t0 WHERE t0.id = 1588;

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.enabled AS enabled_8, t0.company_phone AS company_phone_9, t0.last_login AS last_login_10, t0.last_password_change AS last_password_change_11, t0.daily_access_code AS daily_access_code_12, t0.department_id AS department_id_13, t0.payment_rule_id AS payment_rule_id_14 FROM crm_users t0 WHERE t0.id = ?

[
  304
]

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.email AS email_7,
  t0.enabled AS enabled_8,
  t0.company_phone AS company_phone_9,
  t0.last_login AS last_login_10,
  t0.last_password_change AS last_password_change_11,
  t0.daily_access_code AS daily_access_code_12,
  t0.department_id AS department_id_13,
  t0.payment_rule_id AS payment_rule_id_14
FROM
  crm_users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.enabled AS enabled_8, t0.company_phone AS company_phone_9, t0.last_login AS last_login_10, t0.last_password_change AS last_password_change_11, t0.daily_access_code AS daily_access_code_12, t0.department_id AS department_id_13, t0.payment_rule_id AS payment_rule_id_14 FROM crm_users t0 WHERE t0.id = 304;

SELECT c0_.id AS id_0, c0_.short_token AS short_token_1, c0_.status AS status_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.closed_at AS closed_at_5, c0_.last_read_at_consultant AS last_read_at_consultant_6, c0_.last_read_at_client AS last_read_at_client_7, c0_.sms_chat_created_message AS sms_chat_created_message_8, c0_.fleet_channel AS fleet_channel_9, COUNT(c1_.id) AS sclr_10, MAX(c1_.created_at) AS sclr_11, c0_.client_id AS client_id_12, c0_.order_number_id AS order_number_id_13, c0_.consultant_id AS consultant_id_14, c0_.client_device_id AS client_device_id_15 FROM crm_chat_thread c0_ INNER JOIN crm_chat_message c1_ ON (c1_.thread_id = c0_.id) GROUP BY c0_.id ORDER BY sclr_11 DESC LIMIT 50

[]

SELECT
  c0_.id AS id_0,
  c0_.short_token AS short_token_1,
  c0_.status AS status_2,
  c0_.created_at AS created_at_3,
  c0_.updated_at AS updated_at_4,
  c0_.closed_at AS closed_at_5,
  c0_.last_read_at_consultant AS last_read_at_consultant_6,
  c0_.last_read_at_client AS last_read_at_client_7,
  c0_.sms_chat_created_message AS sms_chat_created_message_8,
  c0_.fleet_channel AS fleet_channel_9,
  COUNT(c1_.id) AS sclr_10,
  MAX(c1_.created_at) AS sclr_11,
  c0_.client_id AS client_id_12,
  c0_.order_number_id AS order_number_id_13,
  c0_.consultant_id AS consultant_id_14,
  c0_.client_device_id AS client_device_id_15
FROM
  crm_chat_thread c0_
  INNER JOIN crm_chat_message c1_ ON (c1_.thread_id = c0_.id)
GROUP BY
  c0_.id
ORDER BY
  sclr_11 DESC
LIMIT
  50

SELECT c0_.id AS id_0, c0_.short_token AS short_token_1, c0_.status AS status_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.closed_at AS closed_at_5, c0_.last_read_at_consultant AS last_read_at_consultant_6, c0_.last_read_at_client AS last_read_at_client_7, c0_.sms_chat_created_message AS sms_chat_created_message_8, c0_.fleet_channel AS fleet_channel_9, COUNT(c1_.id) AS sclr_10, MAX(c1_.created_at) AS sclr_11, c0_.client_id AS client_id_12, c0_.order_number_id AS order_number_id_13, c0_.consultant_id AS consultant_id_14, c0_.client_device_id AS client_device_id_15 FROM crm_chat_thread c0_ INNER JOIN crm_chat_message c1_ ON (c1_.thread_id = c0_.id) GROUP BY c0_.id ORDER BY sclr_11 DESC LIMIT 50;

SELECT t0.id AS id_1, t0.name AS name_2, t0.department AS department_3, t0.enabled AS enabled_4, t0.schedule_panel AS schedule_panel_5, t0.color AS color_6 FROM crm_departments t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.department AS department_3,
  t0.enabled AS enabled_4,
  t0.schedule_panel AS schedule_panel_5,
  t0.color AS color_6
FROM
  crm_departments t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.department AS department_3, t0.enabled AS enabled_4, t0.schedule_panel AS schedule_panel_5, t0.color AS color_6 FROM crm_departments t0 WHERE t0.id = 2;