Symfony Profiler

• Request / Response
• Performance
• Validator
• Exception
• Logs 3
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine
• Messages
• Emails
• Serializer
• GraphQL 1
• Redis
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.bundle_id AS bundle_id_2, t0.platform AS platform_3, t0.name AS name_4, t0.project_id AS project_id_5 FROM administration_application t0 WHERE t0.project_id = ?

[
  "21d78a45-2d76-45a2-a958-1ba510fe598d"
]

SELECT
  t0.id AS id_1,
  t0.bundle_id AS bundle_id_2,
  t0.platform AS platform_3,
  t0.name AS name_4,
  t0.project_id AS project_id_5
FROM
  administration_application t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.bundle_id AS bundle_id_2, t0.platform AS platform_3, t0.name AS name_4, t0.project_id AS project_id_5 FROM administration_application t0 WHERE t0.project_id = '21d78a45-2d76-45a2-a958-1ba510fe598d';

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.avatar AS avatar_4, t0.full_path_avatar AS full_path_avatar_5, t0.email AS email_6, t0.name AS name_7 FROM administration_user t0 WHERE t0.email = ? LIMIT 1

[
  "[email protected]"
]

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.avatar AS avatar_4,
  t0.full_path_avatar AS full_path_avatar_5,
  t0.email AS email_6,
  t0.name AS name_7
FROM
  administration_user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.avatar AS avatar_4, t0.full_path_avatar AS full_path_avatar_5, t0.email AS email_6, t0.name AS name_7 FROM administration_user t0 WHERE t0.email = '[email protected]' LIMIT 1;

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM administration_project a0_ WHERE a0_.organization_id = ?

[
  "5b409a88-390b-47f4-b2df-7afe3cb8285a"
]

SELECT
  COUNT(DISTINCT a0_.id) AS sclr_0
FROM
  administration_project a0_
WHERE
  a0_.organization_id = ?

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM administration_project a0_ WHERE a0_.organization_id = '5b409a88-390b-47f4-b2df-7afe3cb8285a';

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.full_path_logo AS full_path_logo_3, t0.name AS name_4 FROM administration_organization t0 INNER JOIN administration_user_organization ON t0.id = administration_user_organization.organization_id WHERE administration_user_organization.amply_user_id = ?

[
  "413049a2-edcd-430f-b955-a0dfdae60678"
]

SELECT
  t0.id AS id_1,
  t0.logo AS logo_2,
  t0.full_path_logo AS full_path_logo_3,
  t0.name AS name_4
FROM
  administration_organization t0
  INNER JOIN administration_user_organization ON t0.id = administration_user_organization.organization_id
WHERE
  administration_user_organization.amply_user_id = ?

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.full_path_logo AS full_path_logo_3, t0.name AS name_4 FROM administration_organization t0 INNER JOIN administration_user_organization ON t0.id = administration_user_organization.organization_id WHERE administration_user_organization.amply_user_id = '413049a2-edcd-430f-b955-a0dfdae60678';

SELECT DISTINCT id_0, MIN(sclr_2) AS dctrn_minrownum FROM (SELECT a0_.id AS id_0, a0_.name AS name_1, ROW_NUMBER() OVER(ORDER BY a0_.id ASC) AS sclr_2 FROM administration_project a0_ WHERE a0_.organization_id = ?) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 11

[
  "5b409a88-390b-47f4-b2df-7afe3cb8285a"
]

SELECT
  DISTINCT id_0,
  MIN(sclr_2) AS dctrn_minrownum
FROM
  (
    SELECT
      a0_.id AS id_0,
      a0_.name AS name_1,
      ROW_NUMBER() OVER(
        ORDER BY
          a0_.id ASC
      ) AS sclr_2
    FROM
      administration_project a0_
    WHERE
      a0_.organization_id = ?
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  11

SELECT DISTINCT id_0, MIN(sclr_2) AS dctrn_minrownum FROM (SELECT a0_.id AS id_0, a0_.name AS name_1, ROW_NUMBER() OVER(ORDER BY a0_.id ASC) AS sclr_2 FROM administration_project a0_ WHERE a0_.organization_id = '5b409a88-390b-47f4-b2df-7afe3cb8285a') dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 11;

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.organization_id AS organization_id_2 FROM administration_project a0_ WHERE a0_.organization_id = ? AND a0_.id IN (?, ?, ?, ?, ?) ORDER BY a0_.id ASC

[
  "5b409a88-390b-47f4-b2df-7afe3cb8285a"
  "21d78a45-2d76-45a2-a958-1ba510fe598d"
  "64cdc9b2-1c6f-481d-bce4-210e9ff2777a"
  "68488f00-69d2-454c-bef6-a70ad37bb87e"
  "88946d55-6c7c-48e5-aca7-c3f093521bce"
  "cce0d658-3d37-4eb3-936c-cc6cad514074"
]

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.organization_id AS organization_id_2
FROM
  administration_project a0_
WHERE
  a0_.organization_id = ?
  AND a0_.id IN (?, ?, ?, ?, ?)
ORDER BY
  a0_.id ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.organization_id AS organization_id_2 FROM administration_project a0_ WHERE a0_.organization_id = '5b409a88-390b-47f4-b2df-7afe3cb8285a' AND a0_.id IN ('21d78a45-2d76-45a2-a958-1ba510fe598d', '64cdc9b2-1c6f-481d-bce4-210e9ff2777a', '68488f00-69d2-454c-bef6-a70ad37bb87e', '88946d55-6c7c-48e5-aca7-c3f093521bce', 'cce0d658-3d37-4eb3-936c-cc6cad514074') ORDER BY a0_.id ASC;