Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 160
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Doctrine
• Emails
• Configuration

Query Metrics

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

[
  "app.host"
]

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

SELECT t0.id AS id_1, t0.name AS name_2 FROM settings t0 WHERE t0.id = 'app.host';

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM user_company u0_ INNER JOIN user u1_ ON u0_.id_user = u1_.id WHERE u1_.is_active = 1

[]

SELECT
  count(DISTINCT u0_.id) AS sclr_0
FROM
  user_company u0_
  INNER JOIN user u1_ ON u0_.id_user = u1_.id
WHERE
  u1_.is_active = 1

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM user_company u0_ INNER JOIN user u1_ ON u0_.id_user = u1_.id WHERE u1_.is_active = 1;

SELECT DISTINCT u0_.id AS id_0, u0_.name AS name_1 FROM user_company u0_ INNER JOIN user u1_ ON u0_.id_user = u1_.id WHERE u1_.is_active = 1 ORDER BY u0_.name ASC LIMIT 12

[]

SELECT
  DISTINCT u0_.id AS id_0,
  u0_.name AS name_1
FROM
  user_company u0_
  INNER JOIN user u1_ ON u0_.id_user = u1_.id
WHERE
  u1_.is_active = 1
ORDER BY
  u0_.name ASC
LIMIT
  12

SELECT DISTINCT u0_.id AS id_0, u0_.name AS name_1 FROM user_company u0_ INNER JOIN user u1_ ON u0_.id_user = u1_.id WHERE u1_.is_active = 1 ORDER BY u0_.name ASC LIMIT 12;

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.description AS description_3, u0_.logo AS logo_4, u0_.image AS image_5, u0_.tin AS tin_6, u0_.street AS street_7, u0_.postal_code AS postal_code_8, u0_.city AS city_9, u0_.company_data_visible AS company_data_visible_10, u0_.bank_account_number AS bank_account_number_11, u0_.is_custom_subdomain AS is_custom_subdomain_12, u0_.custom_domain_name AS custom_domain_name_13, u0_.id_user AS id_user_14 FROM user_company u0_ INNER JOIN user u1_ ON u0_.id_user = u1_.id WHERE u1_.is_active = 1 AND u0_.id IN (?) ORDER BY u0_.name ASC

[
  "1"
]

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.slug AS slug_2,
  u0_.description AS description_3,
  u0_.logo AS logo_4,
  u0_.image AS image_5,
  u0_.tin AS tin_6,
  u0_.street AS street_7,
  u0_.postal_code AS postal_code_8,
  u0_.city AS city_9,
  u0_.company_data_visible AS company_data_visible_10,
  u0_.bank_account_number AS bank_account_number_11,
  u0_.is_custom_subdomain AS is_custom_subdomain_12,
  u0_.custom_domain_name AS custom_domain_name_13,
  u0_.id_user AS id_user_14
FROM
  user_company u0_
  INNER JOIN user u1_ ON u0_.id_user = u1_.id
WHERE
  u1_.is_active = 1
  AND u0_.id IN (?)
ORDER BY
  u0_.name ASC

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.description AS description_3, u0_.logo AS logo_4, u0_.image AS image_5, u0_.tin AS tin_6, u0_.street AS street_7, u0_.postal_code AS postal_code_8, u0_.city AS city_9, u0_.company_data_visible AS company_data_visible_10, u0_.bank_account_number AS bank_account_number_11, u0_.is_custom_subdomain AS is_custom_subdomain_12, u0_.custom_domain_name AS custom_domain_name_13, u0_.id_user AS id_user_14 FROM user_company u0_ INNER JOIN user u1_ ON u0_.id_user = u1_.id WHERE u1_.is_active = 1 AND u0_.id IN ('1') ORDER BY u0_.name ASC;

SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ INNER JOIN user u1_ ON p0_.id_added_by_user = u1_.id WHERE p0_.is_active = 1 AND u1_.is_active = 1 AND p0_.id_added_by_user = ?

[
  "3"
]

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  product p0_
  INNER JOIN user u1_ ON p0_.id_added_by_user = u1_.id
WHERE
  p0_.is_active = 1
  AND u1_.is_active = 1
  AND p0_.id_added_by_user = ?

SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ INNER JOIN user u1_ ON p0_.id_added_by_user = u1_.id WHERE p0_.is_active = 1 AND u1_.is_active = 1 AND p0_.id_added_by_user = '3';