Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 32
• Events
• Routing
• Cache
• Translation 38
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Messages
• Serializer
• EasyAdmin
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?

[
  4396
]

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.created_at AS created_at_3,
  t0.user_id AS user_id_4
FROM
  user_agreement t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = 4396;

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.remote_auth AS remote_auth_2, u0_.is_approved AS is_approved_3, u0_.pwd AS pwd_4, u0_.auth_key AS auth_key_5, u0_.trust_level_id AS trust_level_id_6, u0_.temp_key AS temp_key_7, u0_.is_deleted AS is_deleted_8, u0_.interface AS interface_9, u0_.company AS company_10, u0_.traf_cat AS traf_cat_11, u0_.min_balance AS min_balance_12, u0_.login_attempts AS login_attempts_13, u0_.subscribe_active AS subscribe_active_14, u0_.contact_phone AS contact_phone_15, u0_.is_invoice_auto_link AS is_invoice_auto_link_16, u0_.time_zone AS time_zone_17, u0_.country_id AS country_id_18, u0_.reg_site_id AS reg_site_id_19, u0_.mobile_push_token AS mobile_push_token_20, u0_.fname AS fname_21, u0_.sname AS sname_22, u0_.is_active AS is_active_23, u0_.user_role_id AS user_role_id_24, u0_.office AS office_25, u0_.currency_id AS currency_id_26 FROM user u0_ WHERE u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY u0_.id DESC

[
  4396
  4395
  4394
  4393
  4392
  4391
  4390
  4389
  4388
  4387
  4386
  4385
  4384
  4383
  4382
  4381
  4380
  4379
  4378
  4377
]

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.remote_auth AS remote_auth_2,
  u0_.is_approved AS is_approved_3,
  u0_.pwd AS pwd_4,
  u0_.auth_key AS auth_key_5,
  u0_.trust_level_id AS trust_level_id_6,
  u0_.temp_key AS temp_key_7,
  u0_.is_deleted AS is_deleted_8,
  u0_.interface AS interface_9,
  u0_.company AS company_10,
  u0_.traf_cat AS traf_cat_11,
  u0_.min_balance AS min_balance_12,
  u0_.login_attempts AS login_attempts_13,
  u0_.subscribe_active AS subscribe_active_14,
  u0_.contact_phone AS contact_phone_15,
  u0_.is_invoice_auto_link AS is_invoice_auto_link_16,
  u0_.time_zone AS time_zone_17,
  u0_.country_id AS country_id_18,
  u0_.reg_site_id AS reg_site_id_19,
  u0_.mobile_push_token AS mobile_push_token_20,
  u0_.fname AS fname_21,
  u0_.sname AS sname_22,
  u0_.is_active AS is_active_23,
  u0_.user_role_id AS user_role_id_24,
  u0_.office AS office_25,
  u0_.currency_id AS currency_id_26
FROM
  user u0_
WHERE
  u0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  u0_.id DESC

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.remote_auth AS remote_auth_2, u0_.is_approved AS is_approved_3, u0_.pwd AS pwd_4, u0_.auth_key AS auth_key_5, u0_.trust_level_id AS trust_level_id_6, u0_.temp_key AS temp_key_7, u0_.is_deleted AS is_deleted_8, u0_.interface AS interface_9, u0_.company AS company_10, u0_.traf_cat AS traf_cat_11, u0_.min_balance AS min_balance_12, u0_.login_attempts AS login_attempts_13, u0_.subscribe_active AS subscribe_active_14, u0_.contact_phone AS contact_phone_15, u0_.is_invoice_auto_link AS is_invoice_auto_link_16, u0_.time_zone AS time_zone_17, u0_.country_id AS country_id_18, u0_.reg_site_id AS reg_site_id_19, u0_.mobile_push_token AS mobile_push_token_20, u0_.fname AS fname_21, u0_.sname AS sname_22, u0_.is_active AS is_active_23, u0_.user_role_id AS user_role_id_24, u0_.office AS office_25, u0_.currency_id AS currency_id_26 FROM user u0_ WHERE u0_.id IN (4396, 4395, 4394, 4393, 4392, 4391, 4390, 4389, 4388, 4387, 4386, 4385, 4384, 4383, 4382, 4381, 4380, 4379, 4378, 4377) ORDER BY u0_.id DESC;

SELECT DISTINCT u0_.id AS id_0, u0_.id AS id_1 FROM user u0_ ORDER BY u0_.id DESC LIMIT 20 OFFSET 100

[]

SELECT
  DISTINCT u0_.id AS id_0,
  u0_.id AS id_1
FROM
  user u0_
ORDER BY
  u0_.id DESC
LIMIT
  20
OFFSET
  100

SELECT DISTINCT u0_.id AS id_0, u0_.id AS id_1 FROM user u0_ ORDER BY u0_.id DESC LIMIT 20 OFFSET 100;

SELECT t0.id AS id_1, t0.email AS email_2, t0.remote_auth AS remote_auth_3, t0.is_approved AS is_approved_4, t0.pwd AS pwd_5, t0.auth_key AS auth_key_6, t0.trust_level_id AS trust_level_id_7, t0.temp_key AS temp_key_8, t0.is_deleted AS is_deleted_9, t0.interface AS interface_10, t0.company AS company_11, t0.traf_cat AS traf_cat_12, t0.min_balance AS min_balance_13, t0.login_attempts AS login_attempts_14, t0.subscribe_active AS subscribe_active_15, t0.contact_phone AS contact_phone_16, t0.is_invoice_auto_link AS is_invoice_auto_link_17, t0.time_zone AS time_zone_18, t0.country_id AS country_id_19, t0.reg_site_id AS reg_site_id_20, t0.mobile_push_token AS mobile_push_token_21, t0.fname AS fname_22, t0.sname AS sname_23, t0.is_active AS is_active_24, t0.user_role_id AS user_role_id_25, t0.office AS office_26, t0.currency_id AS currency_id_27, t28.id AS id_29, t28.ip AS ip_30, t28.created_at AS created_at_31, t28.user_id AS user_id_32 FROM user t0 LEFT JOIN user_agreement t28 ON t28.user_id = t0.id WHERE t0.email = ? LIMIT 1

[
  "s.goncharov@sovaunion.com"
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.remote_auth AS remote_auth_3,
  t0.is_approved AS is_approved_4,
  t0.pwd AS pwd_5,
  t0.auth_key AS auth_key_6,
  t0.trust_level_id AS trust_level_id_7,
  t0.temp_key AS temp_key_8,
  t0.is_deleted AS is_deleted_9,
  t0.interface AS interface_10,
  t0.company AS company_11,
  t0.traf_cat AS traf_cat_12,
  t0.min_balance AS min_balance_13,
  t0.login_attempts AS login_attempts_14,
  t0.subscribe_active AS subscribe_active_15,
  t0.contact_phone AS contact_phone_16,
  t0.is_invoice_auto_link AS is_invoice_auto_link_17,
  t0.time_zone AS time_zone_18,
  t0.country_id AS country_id_19,
  t0.reg_site_id AS reg_site_id_20,
  t0.mobile_push_token AS mobile_push_token_21,
  t0.fname AS fname_22,
  t0.sname AS sname_23,
  t0.is_active AS is_active_24,
  t0.user_role_id AS user_role_id_25,
  t0.office AS office_26,
  t0.currency_id AS currency_id_27,
  t28.id AS id_29,
  t28.ip AS ip_30,
  t28.created_at AS created_at_31,
  t28.user_id AS user_id_32
FROM
  user t0
  LEFT JOIN user_agreement t28 ON t28.user_id = t0.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.remote_auth AS remote_auth_3, t0.is_approved AS is_approved_4, t0.pwd AS pwd_5, t0.auth_key AS auth_key_6, t0.trust_level_id AS trust_level_id_7, t0.temp_key AS temp_key_8, t0.is_deleted AS is_deleted_9, t0.interface AS interface_10, t0.company AS company_11, t0.traf_cat AS traf_cat_12, t0.min_balance AS min_balance_13, t0.login_attempts AS login_attempts_14, t0.subscribe_active AS subscribe_active_15, t0.contact_phone AS contact_phone_16, t0.is_invoice_auto_link AS is_invoice_auto_link_17, t0.time_zone AS time_zone_18, t0.country_id AS country_id_19, t0.reg_site_id AS reg_site_id_20, t0.mobile_push_token AS mobile_push_token_21, t0.fname AS fname_22, t0.sname AS sname_23, t0.is_active AS is_active_24, t0.user_role_id AS user_role_id_25, t0.office AS office_26, t0.currency_id AS currency_id_27, t28.id AS id_29, t28.ip AS ip_30, t28.created_at AS created_at_31, t28.user_id AS user_id_32 FROM user t0 LEFT JOIN user_agreement t28 ON t28.user_id = t0.id WHERE t0.email = 's.goncharov@sovaunion.com' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2 FROM user_role t0 WHERE t0.id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  user_role t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM user_role t0 WHERE t0.id = 3;

SELECT count(*) AS sclr_0 FROM user u0_

[]

SELECT
  count(*) AS sclr_0
FROM
  user u0_

SELECT count(*) AS sclr_0 FROM user u0_;