Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.user_id AS user_id_2,
  t0.display AS display_3,
  t0.search AS search_4,
  t0.basket AS basket_5,
  t0.button AS button_6
FROM
  extracharge t0
WHERE
  t0.user_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.display AS display_3, t0.search AS search_4, t0.basket AS basket_5, t0.button AS button_6 FROM extracharge t0 WHERE t0.user_id IS NULL LIMIT 1;

"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 ('group', '216.73.216.245', '/catalog/chemistry/184', '2025-07-07 00:51:12', 8, 0, 55, 0.244, 0, 0, 0.29, NULL, NULL);

"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 00:51:12' AND s0_.end_date >= '2025-07-07 00:51:12' 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 = 1825129 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 00:51:12') 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 = 1825132 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 00:51:12') 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 = 186835 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 00:51:12') 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 = 186851 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 00:51:12') 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 = 186853 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 00:51:12') 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 = 1825130 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 00:51:12') 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 = 160991 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 00:51:12') 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 = 160992 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 00:51:12') 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 = 1849366 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 00:51:12') 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 = 1849370 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 00:51:12') 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 00:51:12' AND s0_.end_date >= '2025-07-07 00:51:12' 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 00:51:12' AND s0_.end_date >= '2025-07-07 00:51:12' AND s0_.is_active = 1;