Symfony Profiler

SELECT
  e0_.id AS id_0,
  e0_.exchange_rate AS exchange_rate_1,
  e0_.last_automatic_update AS last_automatic_update_2,
  e0_.created_at AS created_at_3,
  e0_.updated_at AS updated_at_4,
  e0_.currency_from_id AS currency_from_id_5,
  e0_.currency_to_id AS currency_to_id_6
FROM
  exchange_rate e0_

SELECT e0_.id AS id_0, e0_.exchange_rate AS exchange_rate_1, e0_.last_automatic_update AS last_automatic_update_2, e0_.created_at AS created_at_3, e0_.updated_at AS updated_at_4, e0_.currency_from_id AS currency_from_id_5, e0_.currency_to_id AS currency_to_id_6 FROM exchange_rate e0_;

SELECT
  c0_.id AS id_0,
  c0_.session_id AS session_id_1,
  c0_.status AS status_2,
  c0_.last_activity_at AS last_activity_at_3,
  c0_.email AS email_4,
  c0_.firstname AS firstname_5,
  c0_.lastname AS lastname_6,
  c0_.telephone AS telephone_7,
  c0_.company_name AS company_name_8,
  c0_.cin AS cin_9,
  c0_.vat_id AS vat_id_10,
  c0_.pickup_point_id AS pickup_point_id_11,
  c0_.pickup_point_name AS pickup_point_name_12,
  c0_.note AS note_13,
  c0_.payment_method AS payment_method_14,
  c0_.created_at AS created_at_15,
  c0_.updated_at AS updated_at_16,
  c0_.address_street AS address_street_17,
  c0_.address_descriptive_number AS address_descriptive_number_18,
  c0_.address_city AS address_city_19,
  c0_.address_country AS address_country_20,
  c0_.address_zip_code AS address_zip_code_21,
  c0_.invoice_street AS invoice_street_22,
  c0_.invoice_descriptive_number AS invoice_descriptive_number_23,
  c0_.invoice_city AS invoice_city_24,
  c0_.invoice_country AS invoice_country_25,
  c0_.invoice_zip_code AS invoice_zip_code_26,
  c1_.id AS id_27,
  c1_.quantity AS quantity_28,
  c1_.created_at AS created_at_29,
  c1_.updated_at AS updated_at_30,
  p2_.id AS id_31,
  p2_.code AS code_32,
  p2_.is_default AS is_default_33,
  p2_.weight_modification AS weight_modification_34,
  p2_.price_modification_amount AS price_modification_amount_35,
  p2_.price_modification_currency AS price_modification_currency_36,
  p2_.stock_stock AS stock_stock_37,
  p2_.stock_reserved AS stock_reserved_38,
  p3_.id AS id_39,
  p3_.public_id AS public_id_40,
  p3_.name AS name_41,
  p3_.description AS description_42,
  p3_.short_description AS short_description_43,
  p3_.code AS code_44,
  p3_.ean AS ean_45,
  p3_.unit AS unit_46,
  p3_.active AS active_47,
  p3_.can_be_bought AS can_be_bought_48,
  p3_.searchable AS searchable_49,
  p3_.show_price AS show_price_50,
  p3_.in_stock_text AS in_stock_text_51,
  p3_.out_of_stock_text AS out_of_stock_text_52,
  p3_.filter_parameter_value_ids AS filter_parameter_value_ids_53,
  p3_.filter_variant_value_ids AS filter_variant_value_ids_54,
  p3_.search_vector_cs AS search_vector_cs_55,
  p3_.search_vector_en AS search_vector_en_56,
  p3_.seo_title AS seo_title_57,
  p3_.seo_description AS seo_description_58,
  p3_.seo_url AS seo_url_59,
  p3_.stock_stock AS stock_stock_60,
  p3_.stock_reserved AS stock_reserved_61,
  p3_.logistic_weight AS logistic_weight_62,
  p3_.logistic_size_width AS logistic_size_width_63,
  p3_.logistic_size_height AS logistic_size_height_64,
  p3_.logistic_size_length AS logistic_size_length_65,
  p3_.price_amount AS price_amount_66,
  p3_.price_currency AS price_currency_67,
  p3_.purchase_price_amount AS purchase_price_amount_68,
  p3_.purchase_price_currency AS purchase_price_currency_69,
  c0_.customer_id AS customer_id_70,
  c0_.shipping_method_id AS shipping_method_id_71,
  c0_.discount_code_id AS discount_code_id_72,
  c1_.cart_id AS cart_id_73,
  c1_.product_variant_id AS product_variant_id_74,
  p2_.product_id AS product_id_75,
  p3_.vat_id AS vat_id_76,
  p3_.main_category_id AS main_category_id_77
FROM
  cart c0_
  LEFT JOIN cart_item 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
WHERE
  c0_.session_id = ?
  AND c0_.status = ?
ORDER BY
  c1_.id ASC

SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.status AS status_2, c0_.last_activity_at AS last_activity_at_3, c0_.email AS email_4, c0_.firstname AS firstname_5, c0_.lastname AS lastname_6, c0_.telephone AS telephone_7, c0_.company_name AS company_name_8, c0_.cin AS cin_9, c0_.vat_id AS vat_id_10, c0_.pickup_point_id AS pickup_point_id_11, c0_.pickup_point_name AS pickup_point_name_12, c0_.note AS note_13, c0_.payment_method AS payment_method_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.address_street AS address_street_17, c0_.address_descriptive_number AS address_descriptive_number_18, c0_.address_city AS address_city_19, c0_.address_country AS address_country_20, c0_.address_zip_code AS address_zip_code_21, c0_.invoice_street AS invoice_street_22, c0_.invoice_descriptive_number AS invoice_descriptive_number_23, c0_.invoice_city AS invoice_city_24, c0_.invoice_country AS invoice_country_25, c0_.invoice_zip_code AS invoice_zip_code_26, c1_.id AS id_27, c1_.quantity AS quantity_28, c1_.created_at AS created_at_29, c1_.updated_at AS updated_at_30, p2_.id AS id_31, p2_.code AS code_32, p2_.is_default AS is_default_33, p2_.weight_modification AS weight_modification_34, p2_.price_modification_amount AS price_modification_amount_35, p2_.price_modification_currency AS price_modification_currency_36, p2_.stock_stock AS stock_stock_37, p2_.stock_reserved AS stock_reserved_38, p3_.id AS id_39, p3_.public_id AS public_id_40, p3_.name AS name_41, p3_.description AS description_42, p3_.short_description AS short_description_43, p3_.code AS code_44, p3_.ean AS ean_45, p3_.unit AS unit_46, p3_.active AS active_47, p3_.can_be_bought AS can_be_bought_48, p3_.searchable AS searchable_49, p3_.show_price AS show_price_50, p3_.in_stock_text AS in_stock_text_51, p3_.out_of_stock_text AS out_of_stock_text_52, p3_.filter_parameter_value_ids AS filter_parameter_value_ids_53, p3_.filter_variant_value_ids AS filter_variant_value_ids_54, p3_.search_vector_cs AS search_vector_cs_55, p3_.search_vector_en AS search_vector_en_56, p3_.seo_title AS seo_title_57, p3_.seo_description AS seo_description_58, p3_.seo_url AS seo_url_59, p3_.stock_stock AS stock_stock_60, p3_.stock_reserved AS stock_reserved_61, p3_.logistic_weight AS logistic_weight_62, p3_.logistic_size_width AS logistic_size_width_63, p3_.logistic_size_height AS logistic_size_height_64, p3_.logistic_size_length AS logistic_size_length_65, p3_.price_amount AS price_amount_66, p3_.price_currency AS price_currency_67, p3_.purchase_price_amount AS purchase_price_amount_68, p3_.purchase_price_currency AS purchase_price_currency_69, c0_.customer_id AS customer_id_70, c0_.shipping_method_id AS shipping_method_id_71, c0_.discount_code_id AS discount_code_id_72, c1_.cart_id AS cart_id_73, c1_.product_variant_id AS product_variant_id_74, p2_.product_id AS product_id_75, p3_.vat_id AS vat_id_76, p3_.main_category_id AS main_category_id_77 FROM cart c0_ LEFT JOIN cart_item 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 WHERE c0_.session_id = '6c17e3ecd0ffd001cd3aa2eb21950667' AND c0_.status = 'active' ORDER BY c1_.id ASC;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO cart (
  id, session_id, status, last_activity_at,
  email, firstname, lastname, telephone,
  company_name, cin, vat_id, pickup_point_id,
  pickup_point_name, note, payment_method,
  created_at, updated_at, address_street,
  address_descriptive_number, address_city,
  address_country, address_zip_code,
  invoice_street, invoice_descriptive_number,
  invoice_city, invoice_country, invoice_zip_code,
  customer_id, shipping_method_id,
  discount_code_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO cart (id, session_id, status, last_activity_at, email, firstname, lastname, telephone, company_name, cin, vat_id, pickup_point_id, pickup_point_name, note, payment_method, created_at, updated_at, address_street, address_descriptive_number, address_city, address_country, address_zip_code, invoice_street, invoice_descriptive_number, invoice_city, invoice_country, invoice_zip_code, customer_id, shipping_method_id, discount_code_id) VALUES ('b02b380e-1ef3-489b-82c5-c59999091948', '6c17e3ecd0ffd001cd3aa2eb21950667', 'active', '2026-06-07 16:24:11', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-07 16:24:11', '2026-06-07 16:24:11', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

"COMMIT"

"COMMIT";

SELECT
  h0_.id AS id_0,
  h0_.text_content AS text_content_1,
  h0_.text_content_secondary AS text_content_secondary_2,
  h0_.section_order AS section_order_3,
  h0_.benefits_enabled AS benefits_enabled_4,
  h0_.text_enabled AS text_enabled_5,
  h0_.text_secondary_enabled AS text_secondary_enabled_6,
  h0_.slider_enabled AS slider_enabled_7,
  h0_.slider_interval AS slider_interval_8,
  h0_.slider_effect AS slider_effect_9,
  h0_.products_enabled AS products_enabled_10
FROM
  homepage h0_

SELECT h0_.id AS id_0, h0_.text_content AS text_content_1, h0_.text_content_secondary AS text_content_secondary_2, h0_.section_order AS section_order_3, h0_.benefits_enabled AS benefits_enabled_4, h0_.text_enabled AS text_enabled_5, h0_.text_secondary_enabled AS text_secondary_enabled_6, h0_.slider_enabled AS slider_enabled_7, h0_.slider_interval AS slider_interval_8, h0_.slider_effect AS slider_effect_9, h0_.products_enabled AS products_enabled_10 FROM homepage h0_;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.homepage_id AS homepage_id_3,
  t0.product_id AS product_id_4
FROM
  homepage_selected_product t0
WHERE
  t0.homepage_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.homepage_id AS homepage_id_3, t0.product_id AS product_id_4 FROM homepage_selected_product t0 WHERE t0.homepage_id = '838099bc-3c98-459d-9083-f949c36ba34b' ORDER BY t0.position ASC;

SELECT
  c0_.id AS id_0,
  c0_.public_id AS public_id_1,
  c0_.name AS name_2,
  c0_.slug AS slug_3,
  c0_.description AS description_4,
  c0_.lft AS lft_5,
  c0_.lvl AS lvl_6,
  c0_.rgt AS rgt_7,
  c0_.position AS position_8
FROM
  category c0_
ORDER BY
  c0_.tree_root ASC,
  c0_.lft ASC

SELECT c0_.id AS id_0, c0_.public_id AS public_id_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.lft AS lft_5, c0_.lvl AS lvl_6, c0_.rgt AS rgt_7, c0_.position AS position_8 FROM category c0_ ORDER BY c0_.tree_root ASC, c0_.lft ASC;

SELECT
  s0_.id AS id_0,
  s0_.public_id AS public_id_1,
  s0_.title AS title_2,
  s0_.slug AS slug_3,
  s0_.content AS content_4,
  s0_.show_contact_form AS show_contact_form_5,
  s0_.active AS active_6,
  s0_.created_at AS created_at_7,
  s0_.updated_at AS updated_at_8,
  s0_.seo_title AS seo_title_9,
  s0_.seo_description AS seo_description_10,
  s0_.seo_url AS seo_url_11
FROM
  static_page s0_
WHERE
  s0_.active = true
ORDER BY
  s0_.created_at ASC

SELECT s0_.id AS id_0, s0_.public_id AS public_id_1, s0_.title AS title_2, s0_.slug AS slug_3, s0_.content AS content_4, s0_.show_contact_form AS show_contact_form_5, s0_.active AS active_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.seo_title AS seo_title_9, s0_.seo_description AS seo_description_10, s0_.seo_url AS seo_url_11 FROM static_page s0_ WHERE s0_.active = true ORDER BY s0_.created_at ASC;

SELECT
  s0_.id AS id_0,
  s0_.public_id AS public_id_1,
  s0_.title AS title_2,
  s0_.slug AS slug_3,
  s0_.content AS content_4,
  s0_.show_contact_form AS show_contact_form_5,
  s0_.active AS active_6,
  s0_.created_at AS created_at_7,
  s0_.updated_at AS updated_at_8,
  s0_.seo_title AS seo_title_9,
  s0_.seo_description AS seo_description_10,
  s0_.seo_url AS seo_url_11
FROM
  static_page s0_
WHERE
  s0_.active = true
ORDER BY
  s0_.created_at ASC

SELECT s0_.id AS id_0, s0_.public_id AS public_id_1, s0_.title AS title_2, s0_.slug AS slug_3, s0_.content AS content_4, s0_.show_contact_form AS show_contact_form_5, s0_.active AS active_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.seo_title AS seo_title_9, s0_.seo_description AS seo_description_10, s0_.seo_url AS seo_url_11 FROM static_page s0_ WHERE s0_.active = true ORDER BY s0_.created_at ASC;

SELECT
  c0_.id AS id_0,
  c0_.public_id AS public_id_1,
  c0_.name AS name_2,
  c0_.slug AS slug_3,
  c0_.description AS description_4,
  c0_.lft AS lft_5,
  c0_.lvl AS lvl_6,
  c0_.rgt AS rgt_7,
  c0_.position AS position_8
FROM
  category c0_
ORDER BY
  c0_.tree_root ASC,
  c0_.lft ASC

SELECT c0_.id AS id_0, c0_.public_id AS public_id_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.lft AS lft_5, c0_.lvl AS lvl_6, c0_.rgt AS rgt_7, c0_.position AS position_8 FROM category c0_ ORDER BY c0_.tree_root ASC, c0_.lft ASC;

SELECT
  s0_.id AS id_0,
  s0_.position AS position_1,
  s0_.title AS title_2,
  s0_.content AS content_3,
  s0_.link_url AS link_url_4,
  s0_.link_label AS link_label_5,
  s0_.is_active AS is_active_6,
  f1_.id AS id_7,
  f1_.size AS size_8,
  f1_.mime_type AS mime_type_9,
  s0_.image_id AS image_id_10
FROM
  sidebar_block s0_
  LEFT JOIN file f1_ ON s0_.image_id = f1_.id
WHERE
  s0_.is_active = true
ORDER BY
  s0_.position ASC,
  s0_.id ASC

SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.title AS title_2, s0_.content AS content_3, s0_.link_url AS link_url_4, s0_.link_label AS link_label_5, s0_.is_active AS is_active_6, f1_.id AS id_7, f1_.size AS size_8, f1_.mime_type AS mime_type_9, s0_.image_id AS image_id_10 FROM sidebar_block s0_ LEFT JOIN file f1_ ON s0_.image_id = f1_.id WHERE s0_.is_active = true ORDER BY s0_.position ASC, s0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.icon AS icon_3,
  t0.label AS label_4,
  t0.description AS description_5,
  t0.url AS url_6,
  t0.icon_color AS icon_color_7,
  t0.label_color AS label_color_8,
  t0.description_color AS description_color_9,
  t0.homepage_id AS homepage_id_10
FROM
  homepage_benefit t0
WHERE
  t0.homepage_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.icon AS icon_3, t0.label AS label_4, t0.description AS description_5, t0.url AS url_6, t0.icon_color AS icon_color_7, t0.label_color AS label_color_8, t0.description_color AS description_color_9, t0.homepage_id AS homepage_id_10 FROM homepage_benefit t0 WHERE t0.homepage_id = '838099bc-3c98-459d-9083-f949c36ba34b' ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.label AS label_3,
  t0.link_label AS link_label_4,
  t0.url AS url_5,
  t0.homepage_id AS homepage_id_6,
  t0.image_id AS image_id_7
FROM
  homepage_slide t0
WHERE
  t0.homepage_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.label AS label_3, t0.link_label AS link_label_4, t0.url AS url_5, t0.homepage_id AS homepage_id_6, t0.image_id AS image_id_7 FROM homepage_slide t0 WHERE t0.homepage_id = '838099bc-3c98-459d-9083-f949c36ba34b' ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.size AS size_2,
  t0.mime_type AS mime_type_3
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.size AS size_2, t0.mime_type AS mime_type_3 FROM file t0 WHERE t0.id = '4ae4005e-427a-4df7-8284-7337f00c2b01';

SELECT
  t0.id AS id_1,
  t0.size AS size_2,
  t0.mime_type AS mime_type_3
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.size AS size_2, t0.mime_type AS mime_type_3 FROM file t0 WHERE t0.id = 'd6580c74-f418-46de-9482-f09f0e92f7de';

SELECT
  t0.id AS id_1,
  t0.size AS size_2,
  t0.mime_type AS mime_type_3
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.size AS size_2, t0.mime_type AS mime_type_3 FROM file t0 WHERE t0.id = '9e555e9d-7380-4b72-a498-d629c1ebd1a8';