Symfony Profiler

• Request / Response
• Performance
• Validator
• Exception
• Logs 12
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 5
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.full_name AS full_name_3 FROM lang t0 WHERE t0.name = ? LIMIT 1

[
  "ru"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.full_name AS full_name_3
FROM
  lang t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.full_name AS full_name_3 FROM lang t0 WHERE t0.name = 'ru' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3, t0.lang_id AS lang_id_4 FROM category_translate t0 WHERE t0.category_id = ? AND t0.lang_id = ? LIMIT 1

[
  7
  2
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.category_id AS category_id_3,
  t0.lang_id AS lang_id_4
FROM
  category_translate t0
WHERE
  t0.category_id = ?
  AND t0.lang_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3, t0.lang_id AS lang_id_4 FROM category_translate t0 WHERE t0.category_id = 7 AND t0.lang_id = 2 LIMIT 1;

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.descr AS descr_2, o0_.img AS img_3, o0_.latitude AS latitude_4, o0_.longitude AS longitude_5, o0_.price AS price_6, o0_.is_contract AS is_contract_7, o0_.type AS type_8, o0_.created_add AS created_add_9, o0_.status AS status_10, o0_.is_deleted AS is_deleted_11, o0_.category_id AS category_id_12, o0_.user_id AS user_id_13, o0_.master_id AS master_id_14 FROM orders o0_ WHERE o0_.category_id = ? ORDER BY o0_.type DESC

[
  7
]

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1,
  o0_.descr AS descr_2,
  o0_.img AS img_3,
  o0_.latitude AS latitude_4,
  o0_.longitude AS longitude_5,
  o0_.price AS price_6,
  o0_.is_contract AS is_contract_7,
  o0_.type AS type_8,
  o0_.created_add AS created_add_9,
  o0_.status AS status_10,
  o0_.is_deleted AS is_deleted_11,
  o0_.category_id AS category_id_12,
  o0_.user_id AS user_id_13,
  o0_.master_id AS master_id_14
FROM
  orders o0_
WHERE
  o0_.category_id = ?
ORDER BY
  o0_.type DESC

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.descr AS descr_2, o0_.img AS img_3, o0_.latitude AS latitude_4, o0_.longitude AS longitude_5, o0_.price AS price_6, o0_.is_contract AS is_contract_7, o0_.type AS type_8, o0_.created_add AS created_add_9, o0_.status AS status_10, o0_.is_deleted AS is_deleted_11, o0_.category_id AS category_id_12, o0_.user_id AS user_id_13, o0_.master_id AS master_id_14 FROM orders o0_ WHERE o0_.category_id = 7 ORDER BY o0_.type DESC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.region AS region_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.lang_id AS lang_id_6 FROM city t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.region AS region_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.lang_id AS lang_id_6
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.region AS region_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.lang_id AS lang_id_6 FROM city t0 WHERE t0.id = 1;

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM orders o0_ WHERE o0_.category_id = ?

[
  7
]

SELECT
  count(DISTINCT o0_.id) AS sclr_0
FROM
  orders o0_
WHERE
  o0_.category_id = ?

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM orders o0_ WHERE o0_.category_id = 7;

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.descr AS descr_2, o0_.img AS img_3, o0_.latitude AS latitude_4, o0_.longitude AS longitude_5, o0_.price AS price_6, o0_.is_contract AS is_contract_7, o0_.type AS type_8, o0_.created_add AS created_add_9, o0_.status AS status_10, o0_.is_deleted AS is_deleted_11, o0_.category_id AS category_id_12, o0_.user_id AS user_id_13, o0_.master_id AS master_id_14 FROM orders o0_ WHERE o0_.category_id = ? AND o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY o0_.type DESC

[
  7
  47
  49
  55
  56
  59
  60
  61
  62
  73
  84
]

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1,
  o0_.descr AS descr_2,
  o0_.img AS img_3,
  o0_.latitude AS latitude_4,
  o0_.longitude AS longitude_5,
  o0_.price AS price_6,
  o0_.is_contract AS is_contract_7,
  o0_.type AS type_8,
  o0_.created_add AS created_add_9,
  o0_.status AS status_10,
  o0_.is_deleted AS is_deleted_11,
  o0_.category_id AS category_id_12,
  o0_.user_id AS user_id_13,
  o0_.master_id AS master_id_14
FROM
  orders o0_
WHERE
  o0_.category_id = ?
  AND o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  o0_.type DESC

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.descr AS descr_2, o0_.img AS img_3, o0_.latitude AS latitude_4, o0_.longitude AS longitude_5, o0_.price AS price_6, o0_.is_contract AS is_contract_7, o0_.type AS type_8, o0_.created_add AS created_add_9, o0_.status AS status_10, o0_.is_deleted AS is_deleted_11, o0_.category_id AS category_id_12, o0_.user_id AS user_id_13, o0_.master_id AS master_id_14 FROM orders o0_ WHERE o0_.category_id = 7 AND o0_.id IN (47, 49, 55, 56, 59, 60, 61, 62, 73, 84) ORDER BY o0_.type DESC;

SELECT DISTINCT o0_.id AS id_0, o0_.type AS type_1 FROM orders o0_ WHERE o0_.category_id = ? ORDER BY o0_.type DESC LIMIT 10

[
  7
]

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.type AS type_1
FROM
  orders o0_
WHERE
  o0_.category_id = ?
ORDER BY
  o0_.type DESC
LIMIT
  10

SELECT DISTINCT o0_.id AS id_0, o0_.type AS type_1 FROM orders o0_ WHERE o0_.category_id = 7 ORDER BY o0_.type DESC LIMIT 10;