Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.visible AS visible_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.position AS position_6,
  t0.depth AS depth_7,
  t0.sort_path AS sort_path_8,
  t0.parent_id AS parent_id_9
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.position AS position_6, t0.depth AS depth_7, t0.sort_path AS sort_path_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.id = '9';

SELECT
  a0_.id AS id_0,
  a0_.code AS code_1,
  a0_.name AS name_2,
  a0_.sort_path AS sort_path_3,
  a1_.id AS id_4,
  a1_.value AS value_5
FROM
  attribute a0_
  INNER JOIN attribute_value a1_ ON a0_.id = a1_.attribute_id
  INNER JOIN product_variant_attribute_value p2_ ON a1_.id = p2_.attribute_value_id
  INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id
  INNER JOIN product p4_ ON p3_.product_id = p4_.id
  INNER JOIN remote_category r5_ ON p4_.remote_category_id = r5_.id
WHERE
  r5_.category_id = ?
  AND p4_.visible = true
  AND p3_.visible = true
  AND a0_.visible = true
GROUP BY
  a0_.id,
  a0_.code,
  a0_.name,
  a0_.sort_path,
  a1_.id,
  a1_.value
ORDER BY
  a0_.sort_path ASC,
  a1_.value ASC

SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.sort_path AS sort_path_3, a1_.id AS id_4, a1_.value AS value_5 FROM attribute a0_ INNER JOIN attribute_value a1_ ON a0_.id = a1_.attribute_id INNER JOIN product_variant_attribute_value p2_ ON a1_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id INNER JOIN remote_category r5_ ON p4_.remote_category_id = r5_.id WHERE r5_.category_id = 9 AND p4_.visible = true AND p3_.visible = true AND a0_.visible = true GROUP BY a0_.id, a0_.code, a0_.name, a0_.sort_path, a1_.id, a1_.value ORDER BY a0_.sort_path ASC, a1_.value ASC;

SELECT
  a0_.id AS id_0,
  a0_.code AS code_1,
  a0_.name AS name_2,
  a0_.sort_path AS sort_path_3,
  a1_.id AS id_4,
  a1_.value AS value_5
FROM
  attribute a0_
  INNER JOIN attribute_value a1_ ON a0_.id = a1_.attribute_id
  INNER JOIN product_attribute_value p2_ ON a1_.id = p2_.attribute_value_id
  INNER JOIN product p3_ ON p2_.product_id = p3_.id
  INNER JOIN remote_category r4_ ON p3_.remote_category_id = r4_.id
WHERE
  r4_.category_id = ?
  AND p3_.visible = true
  AND a0_.visible = true
GROUP BY
  a0_.id,
  a0_.code,
  a0_.name,
  a0_.sort_path,
  a1_.id,
  a1_.value
ORDER BY
  a0_.sort_path ASC,
  a1_.value ASC

SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.sort_path AS sort_path_3, a1_.id AS id_4, a1_.value AS value_5 FROM attribute a0_ INNER JOIN attribute_value a1_ ON a0_.id = a1_.attribute_id INNER JOIN product_attribute_value p2_ ON a1_.id = p2_.attribute_value_id INNER JOIN product p3_ ON p2_.product_id = p3_.id INNER JOIN remote_category r4_ ON p3_.remote_category_id = r4_.id WHERE r4_.category_id = 9 AND p3_.visible = true AND a0_.visible = true GROUP BY a0_.id, a0_.code, a0_.name, a0_.sort_path, a1_.id, a1_.value ORDER BY a0_.sort_path ASC, a1_.value ASC;

SELECT
  p0_.id AS id_0
FROM
  product_variant p0_
WHERE
  p0_.product_id = ?

SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = NULL;

SELECT
  DISTINCT id_0,
  MIN(sclr_7) AS dctrn_minrownum
FROM
  (
    SELECT
      p0_.id AS id_0,
      p0_.remote_id AS remote_id_1,
      p0_.name AS name_2,
      p0_.title AS title_3,
      p0_.specification AS specification_4,
      p0_.description AS description_5,
      p0_.visible AS visible_6,
      ROW_NUMBER() OVER(
        ORDER BY
          p0_.id DESC
      ) AS sclr_7
    FROM
      product p0_
      INNER JOIN remote_category r1_ ON p0_.remote_category_id = r1_.id
      INNER JOIN product_variant p2_ ON p0_.id = p2_.product_id
    WHERE
      r1_.category_id = ?
      AND p0_.visible = true
      AND p2_.visible = true
    GROUP BY
      p0_.id
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  9

SELECT DISTINCT id_0, MIN(sclr_7) AS dctrn_minrownum FROM (SELECT p0_.id AS id_0, p0_.remote_id AS remote_id_1, p0_.name AS name_2, p0_.title AS title_3, p0_.specification AS specification_4, p0_.description AS description_5, p0_.visible AS visible_6, ROW_NUMBER() OVER(ORDER BY p0_.id DESC) AS sclr_7 FROM product p0_ INNER JOIN remote_category r1_ ON p0_.remote_category_id = r1_.id INNER JOIN product_variant p2_ ON p0_.id = p2_.product_id WHERE r1_.category_id = 9 AND p0_.visible = true AND p2_.visible = true GROUP BY p0_.id) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 9;

SELECT
  p0_.id AS id_0,
  p0_.remote_id AS remote_id_1,
  p0_.name AS name_2,
  p0_.title AS title_3,
  p0_.specification AS specification_4,
  p0_.description AS description_5,
  p0_.visible AS visible_6,
  p0_.source_id AS source_id_7,
  p0_.manufacturer_id AS manufacturer_id_8,
  p0_.remote_category_id AS remote_category_id_9
FROM
  product p0_
  INNER JOIN remote_category r1_ ON p0_.remote_category_id = r1_.id
  INNER JOIN product_variant p2_ ON p0_.id = p2_.product_id
WHERE
  r1_.category_id = ?
  AND p0_.visible = true
  AND p2_.visible = true
  AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  p0_.id
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.remote_id AS remote_id_1, p0_.name AS name_2, p0_.title AS title_3, p0_.specification AS specification_4, p0_.description AS description_5, p0_.visible AS visible_6, p0_.source_id AS source_id_7, p0_.manufacturer_id AS manufacturer_id_8, p0_.remote_category_id AS remote_category_id_9 FROM product p0_ INNER JOIN remote_category r1_ ON p0_.remote_category_id = r1_.id INNER JOIN product_variant p2_ ON p0_.id = p2_.product_id WHERE r1_.category_id = 9 AND p0_.visible = true AND p2_.visible = true AND p0_.id IN (421, 415, 414, 413, 393, 389, 388, 386, 384) GROUP BY p0_.id ORDER BY p0_.id DESC;

SELECT
  p0_.product_id AS sclr_0,
  MIN(p0_.id) AS sclr_1
FROM
  product_variant p0_
WHERE
  p0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
  AND p0_.visible = true
GROUP BY
  p0_.product_id

SELECT p0_.product_id AS sclr_0, MIN(p0_.id) AS sclr_1 FROM product_variant p0_ WHERE p0_.product_id IN (421, 415, 414, 413, 393, 389, 388, 386, 384) AND p0_.visible = true GROUP BY p0_.product_id;

SELECT
  p0_.id AS id_0,
  p0_.ean AS ean_1,
  p0_.price AS price_2,
  p0_.stock AS stock_3,
  p0_.visible AS visible_4,
  p1_.id AS id_5,
  a2_.id AS id_6,
  a2_.value AS value_7,
  a2_.value_float AS value_float_8,
  a3_.id AS id_9,
  a3_.code AS code_10,
  a3_.name AS name_11,
  a3_.visible AS visible_12,
  a3_.position AS position_13,
  a3_.depth AS depth_14,
  a3_.sort_path AS sort_path_15,
  p0_.product_id AS product_id_16,
  p1_.variant_id AS variant_id_17,
  p1_.attribute_value_id AS attribute_value_id_18,
  a2_.attribute_id AS attribute_id_19,
  a3_.parent_id AS parent_id_20
FROM
  product_variant p0_
  LEFT JOIN product_variant_attribute_value p1_ ON p0_.id = p1_.variant_id
  LEFT JOIN attribute_value a2_ ON p1_.attribute_value_id = a2_.id
  LEFT JOIN attribute a3_ ON a2_.attribute_id = a3_.id
WHERE
  p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT p0_.id AS id_0, p0_.ean AS ean_1, p0_.price AS price_2, p0_.stock AS stock_3, p0_.visible AS visible_4, p1_.id AS id_5, a2_.id AS id_6, a2_.value AS value_7, a2_.value_float AS value_float_8, a3_.id AS id_9, a3_.code AS code_10, a3_.name AS name_11, a3_.visible AS visible_12, a3_.position AS position_13, a3_.depth AS depth_14, a3_.sort_path AS sort_path_15, p0_.product_id AS product_id_16, p1_.variant_id AS variant_id_17, p1_.attribute_value_id AS attribute_value_id_18, a2_.attribute_id AS attribute_id_19, a3_.parent_id AS parent_id_20 FROM product_variant p0_ LEFT JOIN product_variant_attribute_value p1_ ON p0_.id = p1_.variant_id LEFT JOIN attribute_value a2_ ON p1_.attribute_value_id = a2_.id LEFT JOIN attribute a3_ ON a2_.attribute_id = a3_.id WHERE p0_.id IN (14093, 14302, 14330, 16660, 16653, 16646, 16750, 14128, 13945);

SELECT
  p0_.variant_id AS sclr_0,
  MIN(i1_.path) AS sclr_1
FROM
  image i1_
  INNER JOIN product_variant_image p0_ ON i1_.id = p0_.image_id
  INNER JOIN product_variant p2_ ON p0_.variant_id = p2_.id
WHERE
  p2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
  AND p2_.visible = true
GROUP BY
  p0_.variant_id

SELECT p0_.variant_id AS sclr_0, MIN(i1_.path) AS sclr_1 FROM image i1_ INNER JOIN product_variant_image p0_ ON i1_.id = p0_.image_id INNER JOIN product_variant p2_ ON p0_.variant_id = p2_.id WHERE p2_.id IN (14093, 14302, 14330, 16660, 16653, 16646, 16750, 14128, 13945) AND p2_.visible = true GROUP BY p0_.variant_id;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.visible AS visible_2,
  c0_.created_at AS created_at_3,
  c0_.updated_at AS updated_at_4,
  c0_.position AS position_5,
  c0_.depth AS depth_6,
  c0_.sort_path AS sort_path_7,
  c0_.parent_id AS parent_id_8
FROM
  category c0_
WHERE
  c0_.parent_id IS NULL
  AND c0_.visible = true
ORDER BY
  c0_.sort_path ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.visible AS visible_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.position AS position_5, c0_.depth AS depth_6, c0_.sort_path AS sort_path_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE c0_.parent_id IS NULL AND c0_.visible = true ORDER BY c0_.sort_path ASC;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO cart (
  created_at, updated_at, owner_id,
  shipping_method_id, payment_method_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO cart (created_at, updated_at, owner_id, shipping_method_id, payment_method_id) VALUES ('2026-03-17 18:49:08', '2026-03-17 18:49:08', NULL, NULL, NULL);

"COMMIT"

"COMMIT";

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c1_.id AS id_3,
  c1_.quantity AS quantity_4,
  c1_.created_at AS created_at_5,
  c1_.updated_at AS updated_at_6,
  p2_.id AS id_7,
  p2_.ean AS ean_8,
  p2_.price AS price_9,
  p2_.stock AS stock_10,
  p2_.visible AS visible_11,
  p3_.id AS id_12,
  p3_.remote_id AS remote_id_13,
  p3_.name AS name_14,
  p3_.title AS title_15,
  p3_.specification AS specification_16,
  p3_.description AS description_17,
  p3_.visible AS visible_18,
  p4_.id AS id_19,
  a5_.id AS id_20,
  a5_.value AS value_21,
  a5_.value_float AS value_float_22,
  a6_.id AS id_23,
  a6_.code AS code_24,
  a6_.name AS name_25,
  a6_.visible AS visible_26,
  a6_.position AS position_27,
  a6_.depth AS depth_28,
  a6_.sort_path AS sort_path_29,
  p7_.id AS id_30,
  p7_.original_filename AS original_filename_31,
  p7_.filename AS filename_32,
  p7_.mime_type AS mime_type_33,
  p7_.size AS size_34,
  p7_.path AS path_35,
  p7_.created_at AS created_at_36,
  p7_.updated_at AS updated_at_37,
  c0_.owner_id AS owner_id_38,
  c0_.shipping_method_id AS shipping_method_id_39,
  c0_.payment_method_id AS payment_method_id_40,
  c1_.cart_id AS cart_id_41,
  c1_.product_variant_id AS product_variant_id_42,
  c1_.project_file_id AS project_file_id_43,
  p2_.product_id AS product_id_44,
  p3_.source_id AS source_id_45,
  p3_.manufacturer_id AS manufacturer_id_46,
  p3_.remote_category_id AS remote_category_id_47,
  p4_.variant_id AS variant_id_48,
  p4_.attribute_value_id AS attribute_value_id_49,
  a5_.attribute_id AS attribute_id_50,
  a6_.parent_id AS parent_id_51,
  p7_.user_id AS user_id_52
FROM
  cart c0_
  LEFT JOIN cart_product_variant c1_ ON c0_.id = c1_.cart_id
  LEFT JOIN product_variant p2_ ON c1_.product_variant_id = p2_.id
  LEFT JOIN product p3_ ON p2_.product_id = p3_.id
  LEFT JOIN product_variant_attribute_value p4_ ON p2_.id = p4_.variant_id
  LEFT JOIN attribute_value a5_ ON p4_.attribute_value_id = a5_.id
  LEFT JOIN attribute a6_ ON a5_.attribute_id = a6_.id
  LEFT JOIN project_file p7_ ON c1_.project_file_id = p7_.id
WHERE
  c0_.id = ?

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c1_.id AS id_3, c1_.quantity AS quantity_4, c1_.created_at AS created_at_5, c1_.updated_at AS updated_at_6, p2_.id AS id_7, p2_.ean AS ean_8, p2_.price AS price_9, p2_.stock AS stock_10, p2_.visible AS visible_11, p3_.id AS id_12, p3_.remote_id AS remote_id_13, p3_.name AS name_14, p3_.title AS title_15, p3_.specification AS specification_16, p3_.description AS description_17, p3_.visible AS visible_18, p4_.id AS id_19, a5_.id AS id_20, a5_.value AS value_21, a5_.value_float AS value_float_22, a6_.id AS id_23, a6_.code AS code_24, a6_.name AS name_25, a6_.visible AS visible_26, a6_.position AS position_27, a6_.depth AS depth_28, a6_.sort_path AS sort_path_29, p7_.id AS id_30, p7_.original_filename AS original_filename_31, p7_.filename AS filename_32, p7_.mime_type AS mime_type_33, p7_.size AS size_34, p7_.path AS path_35, p7_.created_at AS created_at_36, p7_.updated_at AS updated_at_37, c0_.owner_id AS owner_id_38, c0_.shipping_method_id AS shipping_method_id_39, c0_.payment_method_id AS payment_method_id_40, c1_.cart_id AS cart_id_41, c1_.product_variant_id AS product_variant_id_42, c1_.project_file_id AS project_file_id_43, p2_.product_id AS product_id_44, p3_.source_id AS source_id_45, p3_.manufacturer_id AS manufacturer_id_46, p3_.remote_category_id AS remote_category_id_47, p4_.variant_id AS variant_id_48, p4_.attribute_value_id AS attribute_value_id_49, a5_.attribute_id AS attribute_id_50, a6_.parent_id AS parent_id_51, p7_.user_id AS user_id_52 FROM cart c0_ LEFT JOIN cart_product_variant c1_ ON c0_.id = c1_.cart_id LEFT JOIN product_variant p2_ ON c1_.product_variant_id = p2_.id LEFT JOIN product p3_ ON p2_.product_id = p3_.id LEFT JOIN product_variant_attribute_value p4_ ON p2_.id = p4_.variant_id LEFT JOIN attribute_value a5_ ON p4_.attribute_value_id = a5_.id LEFT JOIN attribute a6_ ON a5_.attribute_id = a6_.id LEFT JOIN project_file p7_ ON c1_.project_file_id = p7_.id WHERE c0_.id = 77;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.visible AS visible_2,
  c0_.created_at AS created_at_3,
  c0_.updated_at AS updated_at_4,
  c0_.position AS position_5,
  c0_.depth AS depth_6,
  c0_.sort_path AS sort_path_7,
  c0_.parent_id AS parent_id_8
FROM
  category c0_
WHERE
  c0_.parent_id IS NULL
  AND c0_.visible = true
ORDER BY
  c0_.sort_path ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.visible AS visible_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.position AS position_5, c0_.depth AS depth_6, c0_.sort_path AS sort_path_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE c0_.parent_id IS NULL AND c0_.visible = true ORDER BY c0_.sort_path ASC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      p0_.id AS id_0,
      p0_.remote_id AS remote_id_1,
      p0_.name AS name_2,
      p0_.title AS title_3,
      p0_.specification AS specification_4,
      p0_.description AS description_5,
      p0_.visible AS visible_6
    FROM
      product p0_
      INNER JOIN remote_category r1_ ON p0_.remote_category_id = r1_.id
      INNER JOIN product_variant p2_ ON p0_.id = p2_.product_id
    WHERE
      r1_.category_id = ?
      AND p0_.visible = true
      AND p2_.visible = true
    GROUP BY
      p0_.id
    ORDER BY
      p0_.id DESC
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT p0_.id AS id_0, p0_.remote_id AS remote_id_1, p0_.name AS name_2, p0_.title AS title_3, p0_.specification AS specification_4, p0_.description AS description_5, p0_.visible AS visible_6 FROM product p0_ INNER JOIN remote_category r1_ ON p0_.remote_category_id = r1_.id INNER JOIN product_variant p2_ ON p0_.id = p2_.product_id WHERE r1_.category_id = 9 AND p0_.visible = true AND p2_.visible = true GROUP BY p0_.id ORDER BY p0_.id DESC) dctrn_table;