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 post p0_ WHERE YEAR(p0_.created) = ? AND MONTH(p0_.created) = ?

[
  "2013"
  "mayo"
]

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  post p0_
WHERE
  YEAR(p0_.created) = ?
  AND MONTH(p0_.created) = ?

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM post p0_ WHERE YEAR(p0_.created) = '2013' AND MONTH(p0_.created) = 'mayo';

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, p0_.created AS created_1 FROM post p0_ WHERE YEAR(p0_.created) = ? AND MONTH(p0_.created) = ? ORDER BY p0_.created DESC LIMIT 10

[
  "2013"
  "mayo"
]

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.created AS created_1
FROM
  post p0_
WHERE
  YEAR(p0_.created) = ?
  AND MONTH(p0_.created) = ?
ORDER BY
  p0_.created DESC
LIMIT
  10

SELECT DISTINCT p0_.id AS id_0, p0_.created AS created_1 FROM post p0_ WHERE YEAR(p0_.created) = '2013' AND MONTH(p0_.created) = 'mayo' ORDER BY p0_.created DESC LIMIT 10;

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 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 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, 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 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;