Symfony Profiler

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

Query Metrics

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 t0.id AS id_1, t0.title AS title_2 FROM menu t0

[]

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  menu t0

SELECT t0.id AS id_1, t0.title AS title_2 FROM menu t0;

SELECT t0.id AS id_1, t0.title AS title_2, t0.teaser AS teaser_3, t0.description AS description_4, t0.period AS period_5, t0.seo AS seo_6, t0.slug AS slug_7, t0.price AS price_8, t0.frontpage AS frontpage_9, t0.link AS link_10, t0.created AS created_11, t0.updated AS updated_12, t0.webform AS webform_13, t0.priority AS priority_14, t0.image_id AS image_id_15, t0.header_image_id AS header_image_id_16, t0.tag_id AS tag_id_17, t0.page_id AS page_id_18, t0.menu_id AS menu_id_19 FROM offer t0 WHERE t0.menu_id = ?

[
  33
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.teaser AS teaser_3,
  t0.description AS description_4,
  t0.period AS period_5,
  t0.seo AS seo_6,
  t0.slug AS slug_7,
  t0.price AS price_8,
  t0.frontpage AS frontpage_9,
  t0.link AS link_10,
  t0.created AS created_11,
  t0.updated AS updated_12,
  t0.webform AS webform_13,
  t0.priority AS priority_14,
  t0.image_id AS image_id_15,
  t0.header_image_id AS header_image_id_16,
  t0.tag_id AS tag_id_17,
  t0.page_id AS page_id_18,
  t0.menu_id AS menu_id_19
FROM
  offer t0
WHERE
  t0.menu_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.teaser AS teaser_3, t0.description AS description_4, t0.period AS period_5, t0.seo AS seo_6, t0.slug AS slug_7, t0.price AS price_8, t0.frontpage AS frontpage_9, t0.link AS link_10, t0.created AS created_11, t0.updated AS updated_12, t0.webform AS webform_13, t0.priority AS priority_14, t0.image_id AS image_id_15, t0.header_image_id AS header_image_id_16, t0.tag_id AS tag_id_17, t0.page_id AS page_id_18, t0.menu_id AS menu_id_19 FROM offer t0 WHERE t0.menu_id = 33;

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

[
  "escapadas-andorra"
]

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 = 'escapadas-andorra' LIMIT 1;

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')

[
  2515
  2578
]

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 (2515, 2578)) AND p0_.product_type IN ('product', 'ski', 'activity', 'pack');

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 = ?

[
  1935
]

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 = 1935;

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;

SELECT count(p.post_id) AS count, t.id, t.name, t.slug
                      FROM category t
                      JOIN post_tags p on (p.tag_id = t.id)
                      GROUP BY (p.post_id)

[]

SELECT
  count(p.post_id) AS count,
  t.id,
  t.name,
  t.slug
FROM
  category t
  JOIN post_tags p on (p.tag_id = t.id)
GROUP BY
  (p.post_id)

SELECT count(p.post_id) AS count, t.id, t.name, t.slug
                      FROM category t
                      JOIN post_tags p on (p.tag_id = t.id)
                      GROUP BY (p.post_id);

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.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 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

[
  2515
  2578
]

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 (2515, 2578)) AND p0_.product_type IN ('product', 'ski', 'activity', 'pack') LIMIT 10;