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/301', '2025-07-07 18:57:00', 8, 0, 241, 0.348, 0, 0, 0.497, 121, 301);

"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:57:00' AND s0_.end_date >= '2025-07-07 18:57:00' 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 = 1776781 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 18:57:00') 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 = 156189 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 18:57:01') 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 = 156190 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 18:57:01') 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 = 156119 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 18:57:01') 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 = 156123 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 18:57:01') 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 = 1776801 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 18:57:01') 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:57:01' AND s0_.end_date >= '2025-07-07 18:57:01' 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:57:01' AND s0_.end_date >= '2025-07-07 18:57:01' AND s0_.is_active = 1;