Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• 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

[
  "about"
  "eng"
  "IDENTIFIER_TROUBLESHOOTING"
  "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 = 'about' AND sv_parent.language_code = 'eng' AND sv_sub.value = 'IDENTIFIER_TROUBLESHOOTING' 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';

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM shop_setting t0 WHERE t0.setting_key = ? LIMIT 1

[
  "sanity.projectId"
]

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.setting_value AS setting_value_3
FROM
  shop_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM shop_setting t0 WHERE t0.setting_key = 'sanity.projectId' LIMIT 1;

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM shop_setting t0 WHERE t0.setting_key = ? LIMIT 1

[
  "sanity.dataset"
]

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.setting_value AS setting_value_3
FROM
  shop_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM shop_setting t0 WHERE t0.setting_key = 'sanity.dataset' LIMIT 1;

SELECT t0.id AS id_1, t0.query AS query_2, t0.params AS params_3, t0.response AS response_4, t0.expires AS expires_5 FROM sanity_cache t0 WHERE t0.query = ? AND t0.params = ? LIMIT 1

[
  "ec365a1892b52246f97f745bd272c239e0ce103b3c47626e89e903690eb4fd93"
  "9a86086ef3646c0461f2a75fdfc49e292285b792e4b9f10391ab1c6c11b48015"
]

SELECT
  t0.id AS id_1,
  t0.query AS query_2,
  t0.params AS params_3,
  t0.response AS response_4,
  t0.expires AS expires_5
FROM
  sanity_cache t0
WHERE
  t0.query = ?
  AND t0.params = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.query AS query_2, t0.params AS params_3, t0.response AS response_4, t0.expires AS expires_5 FROM sanity_cache t0 WHERE t0.query = 'ec365a1892b52246f97f745bd272c239e0ce103b3c47626e89e903690eb4fd93' AND t0.params = '9a86086ef3646c0461f2a75fdfc49e292285b792e4b9f10391ab1c6c11b48015' LIMIT 1;