Symfony Profiler

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

Query Metrics

SELECT DISTINCT l.code AS language, l.name AS name FROM languages l WHERE l.status = ? ORDER BY l.code ASC

[
  "STATUS_ACTIVE"
]

SELECT
  DISTINCT l.code AS language,
  l.name AS name
FROM
  languages l
WHERE
  l.status = ?
ORDER BY
  l.code ASC

SELECT DISTINCT l.code AS language, l.name AS name FROM languages l WHERE l.status = 'STATUS_ACTIVE' ORDER BY l.code ASC;

SELECT t.key, t.value, l.code AS language FROM translates t INNER JOIN languages l ON t.language_id = l.id WHERE (t.status = ?) AND (t.value IS NOT NULL) AND (l.code = ?) ORDER BY t.key ASC

[
  "STATUS_ACTIVE"
  "ru"
]

SELECT
  t.key,
  t.value,
  l.code AS language
FROM
  translates t
  INNER JOIN languages l ON t.language_id = l.id
WHERE
  (t.status = ?)
  AND (t.value IS NOT NULL)
  AND (l.code = ?)
ORDER BY
  t.key ASC

SELECT t.key, t.value, l.code AS language FROM translates t INNER JOIN languages l ON t.language_id = l.id WHERE (t.status = 'STATUS_ACTIVE') AND (t.value IS NOT NULL) AND (l.code = 'ru') ORDER BY t.key ASC;

SELECT t.value FROM settings t WHERE t.key = ? ORDER BY t.id DESC

[
  "ORG_NAME"
]

SELECT
  t.value
FROM
  settings t
WHERE
  t.key = ?
ORDER BY
  t.id DESC

SELECT t.value FROM settings t WHERE t.key = 'ORG_NAME' ORDER BY t.id DESC;