Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 11
• Events
• Routing
• Cache
• Translation 1
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• E-mails
• Serializer
• VichUploader
• Configuration

Query Metrics

Queries

Group similar statements

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.chapo AS chapo_3, p0_.content AS content_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.published_at AS published_at_7, p0_.deleted AS deleted_8, p0_.published AS published_9, p0_.language AS language_10, p0_.comments_allowed AS comments_allowed_11 FROM post p0_ WHERE p0_.language = ? AND p0_.deleted = ? AND p0_.published = ? ORDER BY p0_.published_at DESC) dctrn_result) dctrn_table

[
  "en"
  0
  1
]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.title AS title_1,
          p0_.slug AS slug_2,
          p0_.chapo AS chapo_3,
          p0_.content AS content_4,
          p0_.created_at AS created_at_5,
          p0_.updated_at AS updated_at_6,
          p0_.published_at AS published_at_7,
          p0_.deleted AS deleted_8,
          p0_.published AS published_9,
          p0_.language AS language_10,
          p0_.comments_allowed AS comments_allowed_11
        FROM
          post p0_
        WHERE
          p0_.language = ?
          AND p0_.deleted = ?
          AND p0_.published = ?
        ORDER BY
          p0_.published_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.chapo AS chapo_3, p0_.content AS content_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.published_at AS published_at_7, p0_.deleted AS deleted_8, p0_.published AS published_9, p0_.language AS language_10, p0_.comments_allowed AS comments_allowed_11 FROM post p0_ WHERE p0_.language = 'en' AND p0_.deleted = 0 AND p0_.published = 1 ORDER BY p0_.published_at DESC) dctrn_result) dctrn_table;

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_7 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.chapo AS chapo_3, p0_.content AS content_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.published_at AS published_at_7, p0_.deleted AS deleted_8, p0_.published AS published_9, p0_.language AS language_10, p0_.comments_allowed AS comments_allowed_11 FROM post p0_ WHERE p0_.language = ? AND p0_.deleted = ? AND p0_.published = ?) dctrn_result_inner ORDER BY published_at_7 DESC) dctrn_result LIMIT 5

[
  "en"
  0
  1
]

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      published_at_7
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.title AS title_1,
          p0_.slug AS slug_2,
          p0_.chapo AS chapo_3,
          p0_.content AS content_4,
          p0_.created_at AS created_at_5,
          p0_.updated_at AS updated_at_6,
          p0_.published_at AS published_at_7,
          p0_.deleted AS deleted_8,
          p0_.published AS published_9,
          p0_.language AS language_10,
          p0_.comments_allowed AS comments_allowed_11
        FROM
          post p0_
        WHERE
          p0_.language = ?
          AND p0_.deleted = ?
          AND p0_.published = ?
      ) dctrn_result_inner
    ORDER BY
      published_at_7 DESC
  ) dctrn_result
LIMIT
  5

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_7 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.chapo AS chapo_3, p0_.content AS content_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.published_at AS published_at_7, p0_.deleted AS deleted_8, p0_.published AS published_9, p0_.language AS language_10, p0_.comments_allowed AS comments_allowed_11 FROM post p0_ WHERE p0_.language = 'en' AND p0_.deleted = 0 AND p0_.published = 1) dctrn_result_inner ORDER BY published_at_7 DESC) dctrn_result LIMIT 5;

Database Connections

Entity Managers

Second Level Cache

Entities Mapping