Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 104
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Emails
• Serializer
• JMS Serializer 0 + 0
• Configuration

Query Metrics

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO sf_stat_catalog (type, ip, ref, date, fid, uid, found, time_local, time_cross, time_logic, microtime, brand_id, category_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  "brand"
  "216.73.216.245"
  "/catalog/brand/11/213/51"
  "2025-07-07 06:34:43"
  8
  0
  621
  0.984
  0.0
  1
  2.555
  11
  null
]

INSERT INTO sf_stat_catalog (
  type, ip, ref, date, fid, uid, found,
  time_local, time_cross, time_logic,
  microtime, brand_id, category_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO sf_stat_catalog (type, ip, ref, date, fid, uid, found, time_local, time_cross, time_logic, microtime, brand_id, category_id) VALUES ('brand', '216.73.216.245', '/catalog/brand/11/213/51', '2025-07-07 06:34:43', 8, 0, 621, 0.984, 0, 1, 2.555, 11, NULL);

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.is_active AS is_active_3, s0_.start_date AS start_date_4, s0_.end_date AS end_date_5, s0_.color AS color_6, s0_.icon AS icon_7 FROM sale_types s0_ WHERE s0_.start_date <= ? AND s0_.end_date >= ? AND s0_.is_active = 1

[
  "2025-07-07 06:34:43"
  "2025-07-07 06:34:43"
]

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.description AS description_2,
  s0_.is_active AS is_active_3,
  s0_.start_date AS start_date_4,
  s0_.end_date AS end_date_5,
  s0_.color AS color_6,
  s0_.icon AS icon_7
FROM
  sale_types s0_
WHERE
  s0_.start_date <= ?
  AND s0_.end_date >= ?
  AND s0_.is_active = 1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.is_active AS is_active_3, s0_.start_date AS start_date_4, s0_.end_date AS end_date_5, s0_.color AS color_6, s0_.icon AS icon_7 FROM sale_types s0_ WHERE s0_.start_date <= '2025-07-07 06:34:43' AND s0_.end_date >= '2025-07-07 06:34:43' AND s0_.is_active = 1;

SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1

[
  162496
  "2025-07-07 06:34:43"
]

SELECT
  p0_.id AS id_0
FROM
  product_kit_items p0_
  INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id)
  INNER JOIN promo_kit p2_ ON (
    p2_.product_kit_id = p1_.id
    OR p2_.product_kit_id = p1_.parent_id
  )
WHERE
  p0_.product_id = ?
  AND (
    p2_.date_finish IS NULL
    OR p2_.date_finish >= ?
  )
  AND p2_.public = 1

SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = 162496 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 06:34:43') AND p2_.public = 1;

SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1

[
  162498
  "2025-07-07 06:34:43"
]

SELECT
  p0_.id AS id_0
FROM
  product_kit_items p0_
  INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id)
  INNER JOIN promo_kit p2_ ON (
    p2_.product_kit_id = p1_.id
    OR p2_.product_kit_id = p1_.parent_id
  )
WHERE
  p0_.product_id = ?
  AND (
    p2_.date_finish IS NULL
    OR p2_.date_finish >= ?
  )
  AND p2_.public = 1

SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = 162498 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 06:34:43') AND p2_.public = 1;

SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1

[
  162499
  "2025-07-07 06:34:43"
]

SELECT
  p0_.id AS id_0
FROM
  product_kit_items p0_
  INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id)
  INNER JOIN promo_kit p2_ ON (
    p2_.product_kit_id = p1_.id
    OR p2_.product_kit_id = p1_.parent_id
  )
WHERE
  p0_.product_id = ?
  AND (
    p2_.date_finish IS NULL
    OR p2_.date_finish >= ?
  )
  AND p2_.public = 1

SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = 162499 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 06:34:43') AND p2_.public = 1;

SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1

[
  162506
  "2025-07-07 06:34:43"
]

SELECT
  p0_.id AS id_0
FROM
  product_kit_items p0_
  INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id)
  INNER JOIN promo_kit p2_ ON (
    p2_.product_kit_id = p1_.id
    OR p2_.product_kit_id = p1_.parent_id
  )
WHERE
  p0_.product_id = ?
  AND (
    p2_.date_finish IS NULL
    OR p2_.date_finish >= ?
  )
  AND p2_.public = 1

SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = 162506 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 06:34:43') AND p2_.public = 1;

SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.type AS type_4, t0.sort AS sort_5 FROM selection_type t0 WHERE t0.enabled = ? ORDER BY t0.sort DESC

[
  1
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.enabled AS enabled_3,
  t0.type AS type_4,
  t0.sort AS sort_5
FROM
  selection_type t0
WHERE
  t0.enabled = ?
ORDER BY
  t0.sort DESC

SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.type AS type_4, t0.sort AS sort_5 FROM selection_type t0 WHERE t0.enabled = 1 ORDER BY t0.sort DESC;

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.is_active AS is_active_3, s0_.start_date AS start_date_4, s0_.end_date AS end_date_5, s0_.color AS color_6, s0_.icon AS icon_7 FROM sale_types s0_ WHERE s0_.start_date <= ? AND s0_.end_date >= ? AND s0_.is_active = 1

[
  "2025-07-07 06:34:43"
  "2025-07-07 06:34:43"
]

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.description AS description_2,
  s0_.is_active AS is_active_3,
  s0_.start_date AS start_date_4,
  s0_.end_date AS end_date_5,
  s0_.color AS color_6,
  s0_.icon AS icon_7
FROM
  sale_types s0_
WHERE
  s0_.start_date <= ?
  AND s0_.end_date >= ?
  AND s0_.is_active = 1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.is_active AS is_active_3, s0_.start_date AS start_date_4, s0_.end_date AS end_date_5, s0_.color AS color_6, s0_.icon AS icon_7 FROM sale_types s0_ WHERE s0_.start_date <= '2025-07-07 06:34:43' AND s0_.end_date >= '2025-07-07 06:34:43' AND s0_.is_active = 1;

SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.type AS type_4, t0.sort AS sort_5 FROM selection_type t0 WHERE t0.enabled = ? ORDER BY t0.sort DESC

[
  1
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.enabled AS enabled_3,
  t0.type AS type_4,
  t0.sort AS sort_5
FROM
  selection_type t0
WHERE
  t0.enabled = ?
ORDER BY
  t0.sort DESC

SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.type AS type_4, t0.sort AS sort_5 FROM selection_type t0 WHERE t0.enabled = 1 ORDER BY t0.sort DESC;

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.is_active AS is_active_3, s0_.start_date AS start_date_4, s0_.end_date AS end_date_5, s0_.color AS color_6, s0_.icon AS icon_7 FROM sale_types s0_ WHERE s0_.start_date <= ? AND s0_.end_date >= ? AND s0_.is_active = 1

[
  "2025-07-07 06:34:43"
  "2025-07-07 06:34:43"
]

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.description AS description_2,
  s0_.is_active AS is_active_3,
  s0_.start_date AS start_date_4,
  s0_.end_date AS end_date_5,
  s0_.color AS color_6,
  s0_.icon AS icon_7
FROM
  sale_types s0_
WHERE
  s0_.start_date <= ?
  AND s0_.end_date >= ?
  AND s0_.is_active = 1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.is_active AS is_active_3, s0_.start_date AS start_date_4, s0_.end_date AS end_date_5, s0_.color AS color_6, s0_.icon AS icon_7 FROM sale_types s0_ WHERE s0_.start_date <= '2025-07-07 06:34:43' AND s0_.end_date >= '2025-07-07 06:34:43' AND s0_.is_active = 1;