Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 18
• Events
• Routing
• Cache
• Translation 3
• Security
• Twig
• HTTP Client
• Doctrine 2
• Debug
• Emails
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.created_at AS created_at_4 FROM company t0 INNER JOIN client_company ON t0.id = client_company.company_id WHERE client_company.client_id = ?

[
  "019e3a1f-5b14-767b-a99f-2b740cb01779"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.created_at AS created_at_4
FROM
  company t0
  INNER JOIN client_company ON t0.id = client_company.company_id
WHERE
  client_company.client_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.created_at AS created_at_4 FROM company t0 INNER JOIN client_company ON t0.id = client_company.company_id WHERE client_company.client_id = '019e3a1f-5b14-767b-a99f-2b740cb01779';

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM client c0_ LEFT JOIN client_company c2_ ON c0_.id = c2_.client_id LEFT JOIN company c1_ ON c1_.id = c2_.company_id

[]

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  client c0_
  LEFT JOIN client_company c2_ ON c0_.id = c2_.client_id
  LEFT JOIN company c1_ ON c1_.id = c2_.company_id

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM client c0_ LEFT JOIN client_company c2_ ON c0_.id = c2_.client_id LEFT JOIN company c1_ ON c1_.id = c2_.company_id;

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.name AS name_4, t0.surnames AS surnames_5, t0.phone AS phone_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.last_login AS last_login_9, t0.status AS status_10, t0.dark_mode AS dark_mode_11, t0.menu_expanded AS menu_expanded_12, t0.locale AS locale_13, t0.address AS address_14, t0.bio AS bio_15, t0.img_profile_id AS img_profile_id_16 FROM user t0 WHERE t0.id = ?

[
  "019df6eb-150c-7d11-94b5-0b82926a9bd1"
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.name AS name_4,
  t0.surnames AS surnames_5,
  t0.phone AS phone_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.last_login AS last_login_9,
  t0.status AS status_10,
  t0.dark_mode AS dark_mode_11,
  t0.menu_expanded AS menu_expanded_12,
  t0.locale AS locale_13,
  t0.address AS address_14,
  t0.bio AS bio_15,
  t0.img_profile_id AS img_profile_id_16
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.name AS name_4, t0.surnames AS surnames_5, t0.phone AS phone_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.last_login AS last_login_9, t0.status AS status_10, t0.dark_mode AS dark_mode_11, t0.menu_expanded AS menu_expanded_12, t0.locale AS locale_13, t0.address AS address_14, t0.bio AS bio_15, t0.img_profile_id AS img_profile_id_16 FROM user t0 WHERE t0.id = '019df6eb-150c-7d11-94b5-0b82926a9bd1';

SELECT DISTINCT c0_.id AS id_0, c0_.name AS name_1 FROM client c0_ LEFT JOIN client_company c2_ ON c0_.id = c2_.client_id LEFT JOIN company c1_ ON c1_.id = c2_.company_id ORDER BY c0_.name ASC LIMIT 10

[]

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.name AS name_1
FROM
  client c0_
  LEFT JOIN client_company c2_ ON c0_.id = c2_.client_id
  LEFT JOIN company c1_ ON c1_.id = c2_.company_id
ORDER BY
  c0_.name ASC
LIMIT
  10

SELECT DISTINCT c0_.id AS id_0, c0_.name AS name_1 FROM client c0_ LEFT JOIN client_company c2_ ON c0_.id = c2_.client_id LEFT JOIN company c1_ ON c1_.id = c2_.company_id ORDER BY c0_.name ASC LIMIT 10;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.email AS email_2, c0_.phone AS phone_3, c0_.created_at AS created_at_4, c0_.created_by_id AS created_by_id_5 FROM client c0_ LEFT JOIN client_company c2_ ON c0_.id = c2_.client_id LEFT JOIN company c1_ ON c1_.id = c2_.company_id WHERE c0_.id IN (?, ?) ORDER BY c0_.name ASC

[
  "019e3a1f-5b14-767b-a99f-2b740cb01779"
  "019e3a1e-c2b2-763c-b63c-55741ac27232"
]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.email AS email_2,
  c0_.phone AS phone_3,
  c0_.created_at AS created_at_4,
  c0_.created_by_id AS created_by_id_5
FROM
  client c0_
  LEFT JOIN client_company c2_ ON c0_.id = c2_.client_id
  LEFT JOIN company c1_ ON c1_.id = c2_.company_id
WHERE
  c0_.id IN (?, ?)
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.email AS email_2, c0_.phone AS phone_3, c0_.created_at AS created_at_4, c0_.created_by_id AS created_by_id_5 FROM client c0_ LEFT JOIN client_company c2_ ON c0_.id = c2_.client_id LEFT JOIN company c1_ ON c1_.id = c2_.company_id WHERE c0_.id IN ('019e3a1f-5b14-767b-a99f-2b740cb01779', '019e3a1e-c2b2-763c-b63c-55741ac27232') ORDER BY c0_.name ASC;

SELECT t0.user_id AS user_id_1, t0.role_id AS role_id_2 FROM user_has_role t0 WHERE t0.user_id = ?

[
  "019df6eb-150c-7d11-94b5-0b82926a9bd1"
]

SELECT
  t0.user_id AS user_id_1,
  t0.role_id AS role_id_2
FROM
  user_has_role t0
WHERE
  t0.user_id = ?

SELECT t0.user_id AS user_id_1, t0.role_id AS role_id_2 FROM user_has_role t0 WHERE t0.user_id = '019df6eb-150c-7d11-94b5-0b82926a9bd1';

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.created_at AS created_at_4 FROM company t0 ORDER BY t0.name ASC

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.created_at AS created_at_4
FROM
  company t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.created_at AS created_at_4 FROM company t0 ORDER BY t0.name ASC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.admin AS admin_4, t0.description AS description_5, t0.company_id AS company_id_6 FROM role t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.admin AS admin_4,
  t0.description AS description_5,
  t0.company_id AS company_id_6
FROM
  role t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.admin AS admin_4, t0.description AS description_5, t0.company_id AS company_id_6 FROM role t0 WHERE t0.id = 1;