Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 56
• Events
• Routing
• Cache
• Translation 4
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Migrations 2
• Debug
• Messages
• Emails
• Notifications
• Configuration

Query Metrics

SELECT count(DISTINCT b0_.id) AS sclr_0 FROM blog b0_ LEFT JOIN blog_translation b1_ ON b0_.id = b1_.translatable_id WHERE b1_.locale = ?

[
  "cs"
]

SELECT
  count(DISTINCT b0_.id) AS sclr_0
FROM
  blog b0_
  LEFT JOIN blog_translation b1_ ON b0_.id = b1_.translatable_id
WHERE
  b1_.locale = ?

SELECT count(DISTINCT b0_.id) AS sclr_0 FROM blog b0_ LEFT JOIN blog_translation b1_ ON b0_.id = b1_.translatable_id WHERE b1_.locale = 'cs';

SELECT DISTINCT b0_.id AS id_0, b0_.posted_at AS posted_at_1 FROM blog b0_ LEFT JOIN blog_translation b1_ ON b0_.id = b1_.translatable_id WHERE b1_.locale = ? ORDER BY b0_.posted_at DESC LIMIT 6

[
  "cs"
]

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.posted_at AS posted_at_1
FROM
  blog b0_
  LEFT JOIN blog_translation b1_ ON b0_.id = b1_.translatable_id
WHERE
  b1_.locale = ?
ORDER BY
  b0_.posted_at DESC
LIMIT
  6

SELECT DISTINCT b0_.id AS id_0, b0_.posted_at AS posted_at_1 FROM blog b0_ LEFT JOIN blog_translation b1_ ON b0_.id = b1_.translatable_id WHERE b1_.locale = 'cs' ORDER BY b0_.posted_at DESC LIMIT 6;

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.link AS link_2, n0_.link_type AS link_type_3, n0_.position AS position_4, n0_.section AS section_5, n0_.created AS created_6, n0_.updated AS updated_7, n0_.page_id AS page_id_8, n0_.language_id AS language_id_9 FROM navigation n0_ LEFT JOIN language l1_ ON n0_.language_id = l1_.id WHERE (n0_.section = ? OR n0_.section = ?) AND l1_.shortcut = ? ORDER BY n0_.id ASC

[
  "top"
  "both"
  "cs"
]

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.link AS link_2,
  n0_.link_type AS link_type_3,
  n0_.position AS position_4,
  n0_.section AS section_5,
  n0_.created AS created_6,
  n0_.updated AS updated_7,
  n0_.page_id AS page_id_8,
  n0_.language_id AS language_id_9
FROM
  navigation n0_
  LEFT JOIN language l1_ ON n0_.language_id = l1_.id
WHERE
  (
    n0_.section = ?
    OR n0_.section = ?
  )
  AND l1_.shortcut = ?
ORDER BY
  n0_.id ASC

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.link AS link_2, n0_.link_type AS link_type_3, n0_.position AS position_4, n0_.section AS section_5, n0_.created AS created_6, n0_.updated AS updated_7, n0_.page_id AS page_id_8, n0_.language_id AS language_id_9 FROM navigation n0_ LEFT JOIN language l1_ ON n0_.language_id = l1_.id WHERE (n0_.section = 'top' OR n0_.section = 'both') AND l1_.shortcut = 'cs' ORDER BY n0_.id ASC;