Symfony Profiler

"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
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

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.246', '/catalog/brand/121/300', '2025-07-07 18:56:58', 8, 0, 477, 0.755, 0, 0, 0.955, 121, 300);

"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

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 18:56:58' AND s0_.end_date >= '2025-07-07 18:56:58' 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

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 = 156108 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 18:56:58') 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

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 = 1718062 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 18:56:58') 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

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 = 1764244 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 18:56:58') 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

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 = 1773184 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 18:56:58') 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

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 = 1737583 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 18:56:58') 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

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 = 1738511 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 18:56:58') 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

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

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 18:56:58' AND s0_.end_date >= '2025-07-07 18:56:58' 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

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

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 18:56:58' AND s0_.end_date >= '2025-07-07 18:56:58' AND s0_.is_active = 1;