Symfony Profiler

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

Query Metrics

SELECT COUNT(l0_.id) AS sclr_0 FROM listini l0_

[]

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  listini l0_

SELECT COUNT(l0_.id) AS sclr_0 FROM listini l0_;

SELECT t0.id AS id_1, t0.type AS type_2, t0.old_url AS old_url_3, t0.new_url AS new_url_4 FROM redirects t0 WHERE t0.old_url = ? LIMIT 1

[
  "/en-ot/capsule/view-all-capsule/diamond"
]

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.old_url AS old_url_3,
  t0.new_url AS new_url_4
FROM
  redirects t0
WHERE
  t0.old_url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.old_url AS old_url_3, t0.new_url AS new_url_4 FROM redirects t0 WHERE t0.old_url = '/en-ot/capsule/view-all-capsule/diamond' LIMIT 1;

SELECT c0_.id AS id_0, c0_.custom_category AS custom_category_1, c0_.ordine AS ordine_2, c0_.is_online AS is_online_3, c0_.show_in_menu AS show_in_menu_4, c1_.category_name AS category_name_5, c1_.category_url AS category_url_6, c1_.meta_title AS meta_title_7, c1_.meta_description AS meta_description_8, c1_.frontend_description AS frontend_description_9, c1_.meta_h1 AS meta_h1_10, c1_.meta_h2 AS meta_h2_11, c0_.parent_id AS parent_id_12 FROM custom_categories c0_ INNER JOIN custom_categories_lang c1_ ON (c1_.custom_category_id = c0_.id) WHERE c1_.category_url = ? AND c1_.lang_id = ? AND c0_.parent_id IS NULL

[
  "capsule"
  2
]

SELECT
  c0_.id AS id_0,
  c0_.custom_category AS custom_category_1,
  c0_.ordine AS ordine_2,
  c0_.is_online AS is_online_3,
  c0_.show_in_menu AS show_in_menu_4,
  c1_.category_name AS category_name_5,
  c1_.category_url AS category_url_6,
  c1_.meta_title AS meta_title_7,
  c1_.meta_description AS meta_description_8,
  c1_.frontend_description AS frontend_description_9,
  c1_.meta_h1 AS meta_h1_10,
  c1_.meta_h2 AS meta_h2_11,
  c0_.parent_id AS parent_id_12
FROM
  custom_categories c0_
  INNER JOIN custom_categories_lang c1_ ON (c1_.custom_category_id = c0_.id)
WHERE
  c1_.category_url = ?
  AND c1_.lang_id = ?
  AND c0_.parent_id IS NULL

SELECT c0_.id AS id_0, c0_.custom_category AS custom_category_1, c0_.ordine AS ordine_2, c0_.is_online AS is_online_3, c0_.show_in_menu AS show_in_menu_4, c1_.category_name AS category_name_5, c1_.category_url AS category_url_6, c1_.meta_title AS meta_title_7, c1_.meta_description AS meta_description_8, c1_.frontend_description AS frontend_description_9, c1_.meta_h1 AS meta_h1_10, c1_.meta_h2 AS meta_h2_11, c0_.parent_id AS parent_id_12 FROM custom_categories c0_ INNER JOIN custom_categories_lang c1_ ON (c1_.custom_category_id = c0_.id) WHERE c1_.category_url = 'capsule' AND c1_.lang_id = 2 AND c0_.parent_id IS NULL;

SELECT c0_.id AS id_0, c0_.custom_category AS custom_category_1, c0_.ordine AS ordine_2, c0_.is_online AS is_online_3, c0_.show_in_menu AS show_in_menu_4, c1_.category_name AS category_name_5, c1_.category_url AS category_url_6, c1_.meta_title AS meta_title_7, c1_.meta_description AS meta_description_8, c1_.frontend_description AS frontend_description_9, c1_.meta_h1 AS meta_h1_10, c1_.meta_h2 AS meta_h2_11, c0_.parent_id AS parent_id_12 FROM custom_categories c0_ INNER JOIN custom_categories_lang c1_ ON (c1_.custom_category_id = c0_.id) WHERE c1_.category_url = ? AND c1_.lang_id = ? AND c0_.parent_id = ?

[
  "view-all-capsule"
  2
  81
]

SELECT
  c0_.id AS id_0,
  c0_.custom_category AS custom_category_1,
  c0_.ordine AS ordine_2,
  c0_.is_online AS is_online_3,
  c0_.show_in_menu AS show_in_menu_4,
  c1_.category_name AS category_name_5,
  c1_.category_url AS category_url_6,
  c1_.meta_title AS meta_title_7,
  c1_.meta_description AS meta_description_8,
  c1_.frontend_description AS frontend_description_9,
  c1_.meta_h1 AS meta_h1_10,
  c1_.meta_h2 AS meta_h2_11,
  c0_.parent_id AS parent_id_12
FROM
  custom_categories c0_
  INNER JOIN custom_categories_lang c1_ ON (c1_.custom_category_id = c0_.id)
WHERE
  c1_.category_url = ?
  AND c1_.lang_id = ?
  AND c0_.parent_id = ?

SELECT c0_.id AS id_0, c0_.custom_category AS custom_category_1, c0_.ordine AS ordine_2, c0_.is_online AS is_online_3, c0_.show_in_menu AS show_in_menu_4, c1_.category_name AS category_name_5, c1_.category_url AS category_url_6, c1_.meta_title AS meta_title_7, c1_.meta_description AS meta_description_8, c1_.frontend_description AS frontend_description_9, c1_.meta_h1 AS meta_h1_10, c1_.meta_h2 AS meta_h2_11, c0_.parent_id AS parent_id_12 FROM custom_categories c0_ INNER JOIN custom_categories_lang c1_ ON (c1_.custom_category_id = c0_.id) WHERE c1_.category_url = 'view-all-capsule' AND c1_.lang_id = 2 AND c0_.parent_id = 81;

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.label AS label_3 FROM langs t0 WHERE t0.lang = ? LIMIT 1

[
  "en"
]

SELECT
  t0.id AS id_1,
  t0.lang AS lang_2,
  t0.label AS label_3
FROM
  langs t0
WHERE
  t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.label AS label_3 FROM langs t0 WHERE t0.lang = 'en' LIMIT 1;

SELECT t0.id AS id_1, t0.listino AS listino_2, t0.currency_id AS currency_id_3 FROM listini t0 WHERE t0.listino = ? LIMIT 1

[
  "ot"
]

SELECT
  t0.id AS id_1,
  t0.listino AS listino_2,
  t0.currency_id AS currency_id_3
FROM
  listini t0
WHERE
  t0.listino = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.listino AS listino_2, t0.currency_id AS currency_id_3 FROM listini t0 WHERE t0.listino = 'ot' LIMIT 1;