Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 13
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Doctrine
• Debug
• Emails
• Serializer
• JMS Serializer 0 + 0
• Configuration

Query Metrics

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_tags p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.tag_id WHERE (c1_.id IN (?, ?)) AND p0_.product_type IN ('product', 'ski', 'activity', 'pack')

[
  2556
  2560
]

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  INNER JOIN product_tags p2_ ON p0_.id = p2_.product_id
  INNER JOIN category c1_ ON c1_.id = p2_.tag_id
WHERE
  (
    c1_.id IN (?, ?)
  )
  AND p0_.product_type IN (
    'product', 'ski', 'activity', 'pack'
  )

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_tags p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.tag_id WHERE (c1_.id IN (2556, 2560)) AND p0_.product_type IN ('product', 'ski', 'activity', 'pack');

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.path AS path_4, t0.file_type AS file_type_5 FROM image t0 WHERE t0.id = ?

[
  8176
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.path AS path_4,
  t0.file_type AS file_type_5
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.path AS path_4, t0.file_type AS file_type_5 FROM image t0 WHERE t0.id = 8176;

SELECT DISTINCT p0_.id AS id_0 FROM product p0_ INNER JOIN product_tags p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.tag_id WHERE (c1_.id IN (?, ?)) AND p0_.product_type IN ('product', 'ski', 'activity', 'pack') LIMIT 10

[
  2556
  2560
]

SELECT
  DISTINCT p0_.id AS id_0
FROM
  product p0_
  INNER JOIN product_tags p2_ ON p0_.id = p2_.product_id
  INNER JOIN category c1_ ON c1_.id = p2_.tag_id
WHERE
  (
    c1_.id IN (?, ?)
  )
  AND p0_.product_type IN (
    'product', 'ski', 'activity', 'pack'
  )
LIMIT
  10

SELECT DISTINCT p0_.id AS id_0 FROM product p0_ INNER JOIN product_tags p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.tag_id WHERE (c1_.id IN (2556, 2560)) AND p0_.product_type IN ('product', 'ski', 'activity', 'pack') LIMIT 10;

SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.slug AS slug_4, t0.seo AS seo_5, t0.stick AS stick_6, t0.created AS created_7, t0.updated AS updated_8, t0.image_id AS image_id_9 FROM post t0 ORDER BY t0.created DESC LIMIT 5

[]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.body AS body_3,
  t0.slug AS slug_4,
  t0.seo AS seo_5,
  t0.stick AS stick_6,
  t0.created AS created_7,
  t0.updated AS updated_8,
  t0.image_id AS image_id_9
FROM
  post t0
ORDER BY
  t0.created DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.slug AS slug_4, t0.seo AS seo_5, t0.stick AS stick_6, t0.created AS created_7, t0.updated AS updated_8, t0.image_id AS image_id_9 FROM post t0 ORDER BY t0.created DESC LIMIT 5;

SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.slug AS slug_4, t0.seo AS seo_5, t0.stick AS stick_6, t0.created AS created_7, t0.updated AS updated_8, t0.image_id AS image_id_9 FROM post t0 WHERE t0.slug = ? LIMIT 1

[
  "fechas-de-apertura-actualizadas-de-las-estaciones-de-esqui-espanolas-para-la-temporada-2020-2021"
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.body AS body_3,
  t0.slug AS slug_4,
  t0.seo AS seo_5,
  t0.stick AS stick_6,
  t0.created AS created_7,
  t0.updated AS updated_8,
  t0.image_id AS image_id_9
FROM
  post t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.slug AS slug_4, t0.seo AS seo_5, t0.stick AS stick_6, t0.created AS created_7, t0.updated AS updated_8, t0.image_id AS image_id_9 FROM post t0 WHERE t0.slug = 'fechas-de-apertura-actualizadas-de-las-estaciones-de-esqui-espanolas-para-la-temporada-2020-2021' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.weight AS weight_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM category t0 INNER JOIN post_tags ON t0.id = post_tags.tag_id WHERE post_tags.post_id = ?

[
  1941
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.weight AS weight_3,
  t0.slug AS slug_4,
  t0.parent_id AS parent_id_5
FROM
  category t0
  INNER JOIN post_tags ON t0.id = post_tags.tag_id
WHERE
  post_tags.post_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.weight AS weight_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM category t0 INNER JOIN post_tags ON t0.id = post_tags.tag_id WHERE post_tags.post_id = 1941;

SELECT t0.id AS id_1, t0.name AS name_2, t0.config_key AS config_key_3, t0.settings AS settings_4 FROM configuration t0 WHERE t0.config_key = ? LIMIT 1

[
  "homepage"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.config_key AS config_key_3,
  t0.settings AS settings_4
FROM
  configuration t0
WHERE
  t0.config_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.config_key AS config_key_3, t0.settings AS settings_4 FROM configuration t0 WHERE t0.config_key = 'homepage' LIMIT 1;

SELECT count(id) AS count, created
                      FROM post
                      GROUP BY YEAR(created), MONTH(created)
                      ORDER BY YEAR(created) DESC, MONTH(created) DESC

[]

SELECT
  count(id) AS count,
  created
FROM
  post
GROUP BY
  YEAR(created),
  MONTH(created)
ORDER BY
  YEAR(created) DESC,
  MONTH(created) DESC

SELECT count(id) AS count, created
                      FROM post
                      GROUP BY YEAR(created), MONTH(created)
                      ORDER BY YEAR(created) DESC, MONTH(created) DESC;