Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception 1
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Doctrine
• Debug
• BM database
• Emails
• Configuration

Query Metrics

SELECT sub.id, sub.parent, sub.controller FROM pages sub INNER JOIN pages parent ON (sub.parent = parent.id) INNER JOIN stringtable str_sub ON (sub.identifier_str = str_sub.code) INNER JOIN stringtable_values sv_sub ON (str_sub.id = sv_sub.string_id) INNER JOIN stringtable str_parent ON (parent.identifier_str = str_parent.code) INNER JOIN stringtable_values sv_parent ON (str_parent.id = sv_parent.string_id) WHERE ISNULL(parent.parent) AND sv_parent.value = ? AND sv_parent.language_code = ? AND sv_sub.value = ? AND sv_sub.language_code = ? ORDER BY id LIMIT 1

[
  "skylight_blinds"
  "eng"
  "fakro"
  "eng"
]

SELECT
  sub.id,
  sub.parent,
  sub.controller
FROM
  pages sub
  INNER JOIN pages parent ON (sub.parent = parent.id)
  INNER JOIN stringtable str_sub ON (
    sub.identifier_str = str_sub.code
  )
  INNER JOIN stringtable_values sv_sub ON (str_sub.id = sv_sub.string_id)
  INNER JOIN stringtable str_parent ON (
    parent.identifier_str = str_parent.code
  )
  INNER JOIN stringtable_values sv_parent ON (
    str_parent.id = sv_parent.string_id
  )
WHERE
  ISNULL(parent.parent)
  AND sv_parent.value = ?
  AND sv_parent.language_code = ?
  AND sv_sub.value = ?
  AND sv_sub.language_code = ?
ORDER BY
  id
LIMIT
  1

SELECT sub.id, sub.parent, sub.controller FROM pages sub INNER JOIN pages parent ON (sub.parent = parent.id) INNER JOIN stringtable str_sub ON (sub.identifier_str = str_sub.code) INNER JOIN stringtable_values sv_sub ON (str_sub.id = sv_sub.string_id) INNER JOIN stringtable str_parent ON (parent.identifier_str = str_parent.code) INNER JOIN stringtable_values sv_parent ON (str_parent.id = sv_parent.string_id) WHERE ISNULL(parent.parent) AND sv_parent.value = 'skylight_blinds' AND sv_parent.language_code = 'eng' AND sv_sub.value = 'fakro' AND sv_sub.language_code = 'eng' ORDER BY id LIMIT 1;

SELECT t0.id AS id_1, t0.name_str AS name_str_2, t0.code AS code_3, t0.iso AS iso_4, t0.promote AS promote_5, t0.vat_percentage AS vat_percentage_6 FROM user_countries t0 WHERE t0.id = ?

[
  "1"
]

SELECT
  t0.id AS id_1,
  t0.name_str AS name_str_2,
  t0.code AS code_3,
  t0.iso AS iso_4,
  t0.promote AS promote_5,
  t0.vat_percentage AS vat_percentage_6
FROM
  user_countries t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_str AS name_str_2, t0.code AS code_3, t0.iso AS iso_4, t0.promote AS promote_5, t0.vat_percentage AS vat_percentage_6 FROM user_countries t0 WHERE t0.id = '1';