Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.display_on_shop AS display_on_shop_2,
  t0.sort AS sort_3,
  t0.reference AS reference_4,
  t0.price_euros AS price_euros_5,
  t0.promotion_price_euros AS promotion_price_euros_6,
  t0.price_dollars AS price_dollars_7,
  t0.promotion_price_dollars AS promotion_price_dollars_8,
  t0.price_pounds AS price_pounds_9,
  t0.promotion_price_pounds AS promotion_price_pounds_10,
  t0.promotion_start_date AS promotion_start_date_11,
  t0.promotion_end_date AS promotion_end_date_12,
  t0.deleted_at AS deleted_at_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.category_id AS category_id_16
FROM
  catalog_product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.display_on_shop AS display_on_shop_2, t0.sort AS sort_3, t0.reference AS reference_4, t0.price_euros AS price_euros_5, t0.promotion_price_euros AS promotion_price_euros_6, t0.price_dollars AS price_dollars_7, t0.promotion_price_dollars AS promotion_price_dollars_8, t0.price_pounds AS price_pounds_9, t0.promotion_price_pounds AS promotion_price_pounds_10, t0.promotion_start_date AS promotion_start_date_11, t0.promotion_end_date AS promotion_end_date_12, t0.deleted_at AS deleted_at_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category_id AS category_id_16 FROM catalog_product t0 WHERE t0.id = '10';

SELECT
  t0.id AS id_1,
  t0.session AS session_2,
  t0.recipient AS recipient_3,
  t0.currency AS currency_4,
  t0.ordered AS ordered_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.user_id AS user_id_8
FROM
  ecommerce_cart t0
WHERE
  t0.session = ?
  AND t0.ordered = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.session AS session_2, t0.recipient AS recipient_3, t0.currency AS currency_4, t0.ordered AS ordered_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_id AS user_id_8 FROM ecommerce_cart t0 WHERE t0.session = 'dva3n31r7a1mp3ftahkvdt84hk' AND t0.ordered = 0 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO ecommerce_cart (
  SESSION, recipient, currency, ordered,
  created_at, updated_at, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO ecommerce_cart (SESSION, recipient, currency, ordered, created_at, updated_at, user_id) VALUES ('dva3n31r7a1mp3ftahkvdt84hk', NULL, 'dollars', 0, '2025-12-06 06:26:09', '2025-12-06 06:26:09', NULL);

INSERT INTO ecommerce_cart_product (
  quantity, reference, price_euros,
  promotion_price_euros, price_dollars,
  promotion_price_dollars, price_pounds,
  promotion_price_pounds, promotion_start_date,
  promotion_end_date, created_at,
  updated_at, product_id, cart_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO ecommerce_cart_product (quantity, reference, price_euros, promotion_price_euros, price_dollars, promotion_price_dollars, price_pounds, promotion_price_pounds, promotion_start_date, promotion_end_date, created_at, updated_at, product_id, cart_id) VALUES (1, 'LORE-STANDARD', 34.99, 29.99, 40.99, 40.99, 30.99, 30.99, '2025-05-01 00:00:00', '2025-06-30 23:59:00', '2025-12-06 06:26:09', '2025-12-06 06:26:09', 10, 334);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.session AS session_2,
  t0.recipient AS recipient_3,
  t0.currency AS currency_4,
  t0.ordered AS ordered_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.user_id AS user_id_8
FROM
  ecommerce_cart t0
WHERE
  t0.session = ?
  AND t0.ordered = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.session AS session_2, t0.recipient AS recipient_3, t0.currency AS currency_4, t0.ordered AS ordered_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_id AS user_id_8 FROM ecommerce_cart t0 WHERE t0.session = 'dva3n31r7a1mp3ftahkvdt84hk' AND t0.ordered = 0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.seo_title AS seo_title_2,
  t0.seo_h1 AS seo_h1_3,
  t0.title AS title_4,
  t0.short_content AS short_content_5,
  t0.content AS content_6,
  t0.slug AS slug_7,
  t0.locale AS locale_8,
  t0.translatable_id AS translatable_id_9
FROM
  catalog_product_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.seo_title AS seo_title_2, t0.seo_h1 AS seo_h1_3, t0.title AS title_4, t0.short_content AS short_content_5, t0.content AS content_6, t0.slug AS slug_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM catalog_product_translation t0 WHERE t0.translatable_id = 10;