Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 25
• Events
• Routing
• Cache
• Translation 28
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.url AS url_7, t0.target AS target_8, t0.is_home AS is_home_9, t0.rank AS rank_10, t0.is_published AS is_published_11, t0.old_id AS old_id_12, t0.menu_id AS menu_id_13 FROM page t0 WHERE t0.menu_id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.body AS body_4,
  t0.keywords AS keywords_5,
  t0.description AS description_6,
  t0.url AS url_7,
  t0.target AS target_8,
  t0.is_home AS is_home_9,
  t0.rank AS rank_10,
  t0.is_published AS is_published_11,
  t0.old_id AS old_id_12,
  t0.menu_id AS menu_id_13
FROM
  page t0
WHERE
  t0.menu_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.url AS url_7, t0.target AS target_8, t0.is_home AS is_home_9, t0.rank AS rank_10, t0.is_published AS is_published_11, t0.old_id AS old_id_12, t0.menu_id AS menu_id_13 FROM page t0 WHERE t0.menu_id = 1;

SELECT t0.guid AS guid_1, t0.id AS id_2, t0.iso2 AS iso2_3, t0.name AS name_4, t0.country_id AS country_id_5 FROM state t0 WHERE t0.country_id = ? ORDER BY t0.name ASC

[
  3
]

SELECT
  t0.guid AS guid_1,
  t0.id AS id_2,
  t0.iso2 AS iso2_3,
  t0.name AS name_4,
  t0.country_id AS country_id_5
FROM
  state t0
WHERE
  t0.country_id = ?
ORDER BY
  t0.name ASC

SELECT t0.guid AS guid_1, t0.id AS id_2, t0.iso2 AS iso2_3, t0.name AS name_4, t0.country_id AS country_id_5 FROM state t0 WHERE t0.country_id = 3 ORDER BY t0.name ASC;

SELECT t0.guid AS guid_1, t0.id AS id_2, t0.name AS name_3, t0.iso AS iso_4, t0.iso2 AS iso2_5, t0.iso_numeric AS iso_numeric_6, t0.phone_code AS phone_code_7, t0.currency_iso AS currency_iso_8, t0.activation_fee AS activation_fee_9, t0.renewal_fee AS renewal_fee_10, t0.minimum_fund_allowed AS minimum_fund_allowed_11, t0.capital_city AS capital_city_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM country t0 WHERE t0.is_active = ? ORDER BY t0.name ASC

[
  1
]

SELECT
  t0.guid AS guid_1,
  t0.id AS id_2,
  t0.name AS name_3,
  t0.iso AS iso_4,
  t0.iso2 AS iso2_5,
  t0.iso_numeric AS iso_numeric_6,
  t0.phone_code AS phone_code_7,
  t0.currency_iso AS currency_iso_8,
  t0.activation_fee AS activation_fee_9,
  t0.renewal_fee AS renewal_fee_10,
  t0.minimum_fund_allowed AS minimum_fund_allowed_11,
  t0.capital_city AS capital_city_12,
  t0.is_active AS is_active_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  country t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.name ASC

SELECT t0.guid AS guid_1, t0.id AS id_2, t0.name AS name_3, t0.iso AS iso_4, t0.iso2 AS iso2_5, t0.iso_numeric AS iso_numeric_6, t0.phone_code AS phone_code_7, t0.currency_iso AS currency_iso_8, t0.activation_fee AS activation_fee_9, t0.renewal_fee AS renewal_fee_10, t0.minimum_fund_allowed AS minimum_fund_allowed_11, t0.capital_city AS capital_city_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM country t0 WHERE t0.is_active = 1 ORDER BY t0.name ASC;

SELECT t0.id AS id_1, t0.opt AS opt_2, t0.data AS data_3, t0.type AS type_4, t0.options AS options_5 FROM setting t0

[]

SELECT
  t0.id AS id_1,
  t0.opt AS opt_2,
  t0.data AS data_3,
  t0.type AS type_4,
  t0.options AS options_5
FROM
  setting t0

SELECT t0.id AS id_1, t0.opt AS opt_2, t0.data AS data_3, t0.type AS type_4, t0.options AS options_5 FROM setting t0;

SELECT c0_.guid AS guid_0, c0_.id AS id_1, c0_.name AS name_2, c0_.iso AS iso_3, c0_.iso2 AS iso2_4, c0_.iso_numeric AS iso_numeric_5, c0_.phone_code AS phone_code_6, c0_.currency_iso AS currency_iso_7, c0_.activation_fee AS activation_fee_8, c0_.renewal_fee AS renewal_fee_9, c0_.minimum_fund_allowed AS minimum_fund_allowed_10, c0_.capital_city AS capital_city_11, c0_.is_active AS is_active_12, c0_.created_at AS created_at_13, c0_.updated_at AS updated_at_14 FROM country c0_ WHERE LOWER(c0_.iso2) = ? OR LOWER(c0_.iso) = ? OR LOWER(c0_.name) = ? LIMIT 1

[
  "ng"
  "ng"
  "ng"
]

SELECT
  c0_.guid AS guid_0,
  c0_.id AS id_1,
  c0_.name AS name_2,
  c0_.iso AS iso_3,
  c0_.iso2 AS iso2_4,
  c0_.iso_numeric AS iso_numeric_5,
  c0_.phone_code AS phone_code_6,
  c0_.currency_iso AS currency_iso_7,
  c0_.activation_fee AS activation_fee_8,
  c0_.renewal_fee AS renewal_fee_9,
  c0_.minimum_fund_allowed AS minimum_fund_allowed_10,
  c0_.capital_city AS capital_city_11,
  c0_.is_active AS is_active_12,
  c0_.created_at AS created_at_13,
  c0_.updated_at AS updated_at_14
FROM
  country c0_
WHERE
  LOWER(c0_.iso2) = ?
  OR LOWER(c0_.iso) = ?
  OR LOWER(c0_.name) = ?
LIMIT
  1

SELECT c0_.guid AS guid_0, c0_.id AS id_1, c0_.name AS name_2, c0_.iso AS iso_3, c0_.iso2 AS iso2_4, c0_.iso_numeric AS iso_numeric_5, c0_.phone_code AS phone_code_6, c0_.currency_iso AS currency_iso_7, c0_.activation_fee AS activation_fee_8, c0_.renewal_fee AS renewal_fee_9, c0_.minimum_fund_allowed AS minimum_fund_allowed_10, c0_.capital_city AS capital_city_11, c0_.is_active AS is_active_12, c0_.created_at AS created_at_13, c0_.updated_at AS updated_at_14 FROM country c0_ WHERE LOWER(c0_.iso2) = 'ng' OR LOWER(c0_.iso) = 'ng' OR LOWER(c0_.name) = 'ng' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.location AS location_3, t0.rank AS rank_4, t0.old_id AS old_id_5 FROM menu t0 WHERE t0.location = ? ORDER BY t0.rank ASC

[
  "top"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.location AS location_3,
  t0.rank AS rank_4,
  t0.old_id AS old_id_5
FROM
  menu t0
WHERE
  t0.location = ?
ORDER BY
  t0.rank ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.location AS location_3, t0.rank AS rank_4, t0.old_id AS old_id_5 FROM menu t0 WHERE t0.location = 'top' ORDER BY t0.rank ASC;