Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 18
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.text AS text_3, t0.releaseId AS releaseId_4 FROM release_description t0 WHERE t0.releaseId = ?

[
  449
]

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.text AS text_3,
  t0.releaseId AS releaseId_4
FROM
  release_description t0
WHERE
  t0.releaseId = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.text AS text_3, t0.releaseId AS releaseId_4 FROM release_description t0 WHERE t0.releaseId = 449;

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.path AS path_1, r0_.version AS version_2, r0_.created AS created_3 FROM releases r0_ INNER JOIN release_description r1_ ON (r0_.id = r1_.releaseId AND r1_.locale = ?) WHERE r0_.project = ? AND r0_.id <= ? AND r1_.text IS NOT NULL ORDER BY r0_.id DESC) dctrn_result) dctrn_table

[
  "en"
  3
  451
]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          r0_.id AS id_0,
          r0_.path AS path_1,
          r0_.version AS version_2,
          r0_.created AS created_3
        FROM
          releases r0_
          INNER JOIN release_description r1_ ON (
            r0_.id = r1_.releaseId
            AND r1_.locale = ?
          )
        WHERE
          r0_.project = ?
          AND r0_.id <= ?
          AND r1_.text IS NOT NULL
        ORDER BY
          r0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.path AS path_1, r0_.version AS version_2, r0_.created AS created_3 FROM releases r0_ INNER JOIN release_description r1_ ON (r0_.id = r1_.releaseId AND r1_.locale = 'en') WHERE r0_.project = 3 AND r0_.id <= 451 AND r1_.text IS NOT NULL ORDER BY r0_.id DESC) dctrn_result) dctrn_table;

SELECT r0_.id AS id_0, r0_.path AS path_1, r0_.version AS version_2, r0_.created AS created_3, r0_.project AS project_4 FROM releases r0_ INNER JOIN release_description r1_ ON (r0_.id = r1_.releaseId AND r1_.locale = ?) WHERE r0_.project = ? AND r0_.id <= ? AND r1_.text IS NOT NULL ORDER BY r0_.id DESC LIMIT 20

[
  "en"
  3
  451
]

SELECT
  r0_.id AS id_0,
  r0_.path AS path_1,
  r0_.version AS version_2,
  r0_.created AS created_3,
  r0_.project AS project_4
FROM
  releases r0_
  INNER JOIN release_description r1_ ON (
    r0_.id = r1_.releaseId
    AND r1_.locale = ?
  )
WHERE
  r0_.project = ?
  AND r0_.id <= ?
  AND r1_.text IS NOT NULL
ORDER BY
  r0_.id DESC
LIMIT
  20

SELECT r0_.id AS id_0, r0_.path AS path_1, r0_.version AS version_2, r0_.created AS created_3, r0_.project AS project_4 FROM releases r0_ INNER JOIN release_description r1_ ON (r0_.id = r1_.releaseId AND r1_.locale = 'en') WHERE r0_.project = 3 AND r0_.id <= 451 AND r1_.text IS NOT NULL ORDER BY r0_.id DESC LIMIT 20;

SELECT t0.id AS id_1, t0.active AS active_2, t0.title AS title_3, t0.url AS url_4, t0.platform AS platform_5, t0.token AS token_6, t0.telegram_token AS telegram_token_7, t0.max_token AS max_token_8, t9.id AS id_10, t9.license_date_limit AS license_date_limit_11, t9.license_date_start AS license_date_start_12, t9.users_limit AS users_limit_13, t9.size_limit AS size_limit_14, t9.customer AS customer_15, t0.project AS project_16 FROM customer t0 LEFT JOIN license t9 ON t9.customer = t0.id WHERE t0.token = ? LIMIT 1

[
  "15d06da52a9a9b026dbe525f2c7478ab4ceb895d7635bfb46f620729f615253f389cd6a2ea98375d0ebfa77d2b8bd880318442c7da6d6e08b21ecd2f0cfd3e7b"
]

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.title AS title_3,
  t0.url AS url_4,
  t0.platform AS platform_5,
  t0.token AS token_6,
  t0.telegram_token AS telegram_token_7,
  t0.max_token AS max_token_8,
  t9.id AS id_10,
  t9.license_date_limit AS license_date_limit_11,
  t9.license_date_start AS license_date_start_12,
  t9.users_limit AS users_limit_13,
  t9.size_limit AS size_limit_14,
  t9.customer AS customer_15,
  t0.project AS project_16
FROM
  customer t0
  LEFT JOIN license t9 ON t9.customer = t0.id
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.active AS active_2, t0.title AS title_3, t0.url AS url_4, t0.platform AS platform_5, t0.token AS token_6, t0.telegram_token AS telegram_token_7, t0.max_token AS max_token_8, t9.id AS id_10, t9.license_date_limit AS license_date_limit_11, t9.license_date_start AS license_date_start_12, t9.users_limit AS users_limit_13, t9.size_limit AS size_limit_14, t9.customer AS customer_15, t0.project AS project_16 FROM customer t0 LEFT JOIN license t9 ON t9.customer = t0.id WHERE t0.token = '15d06da52a9a9b026dbe525f2c7478ab4ceb895d7635bfb46f620729f615253f389cd6a2ea98375d0ebfa77d2b8bd880318442c7da6d6e08b21ecd2f0cfd3e7b' LIMIT 1;

SELECT r0_.id AS id_0, r0_.path AS path_1, r0_.version AS version_2, r0_.created AS created_3, r0_.project AS project_4 FROM releases r0_ WHERE r0_.project = ? AND r0_.version = ? ORDER BY r0_.id DESC LIMIT 1

[
  3
  "3.34.47"
]

SELECT
  r0_.id AS id_0,
  r0_.path AS path_1,
  r0_.version AS version_2,
  r0_.created AS created_3,
  r0_.project AS project_4
FROM
  releases r0_
WHERE
  r0_.project = ?
  AND r0_.version = ?
ORDER BY
  r0_.id DESC
LIMIT
  1

SELECT r0_.id AS id_0, r0_.path AS path_1, r0_.version AS version_2, r0_.created AS created_3, r0_.project AS project_4 FROM releases r0_ WHERE r0_.project = 3 AND r0_.version = '3.34.47' ORDER BY r0_.id DESC LIMIT 1;

SELECT r0_.id AS id_0, r0_.path AS path_1, r0_.version AS version_2, r0_.created AS created_3, r0_.project AS project_4 FROM releases r0_ WHERE r0_.project = ? ORDER BY r0_.id DESC LIMIT 1

[
  3
]

SELECT
  r0_.id AS id_0,
  r0_.path AS path_1,
  r0_.version AS version_2,
  r0_.created AS created_3,
  r0_.project AS project_4
FROM
  releases r0_
WHERE
  r0_.project = ?
ORDER BY
  r0_.id DESC
LIMIT
  1

SELECT r0_.id AS id_0, r0_.path AS path_1, r0_.version AS version_2, r0_.created AS created_3, r0_.project AS project_4 FROM releases r0_ WHERE r0_.project = 3 ORDER BY r0_.id DESC LIMIT 1;