Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.dolibarr_id AS dolibarr_id_1,
  p0_.ref AS ref_2,
  p0_.label AS label_3,
  p0_.slug AS slug_4,
  p0_.description AS description_5,
  p0_.long_description AS long_description_6,
  p0_.price AS price_7,
  p0_.public_price AS public_price_8,
  p0_.stock AS stock_9,
  p0_.low_stock_threshold AS low_stock_threshold_10,
  p0_.weight AS weight_11,
  p0_.dimensions AS dimensions_12,
  p0_.main_image AS main_image_13,
  p0_.secondary_images AS secondary_images_14,
  p0_.documents AS documents_15,
  p0_.is_active AS is_active_16,
  p0_.is_featured AS is_featured_17,
  p0_.seo_data AS seo_data_18,
  p0_.status AS status_19,
  p0_.created_at AS created_at_20,
  p0_.updated_at AS updated_at_21,
  p0_.last_sync_at AS last_sync_at_22,
  p0_.category_id AS category_id_23,
  p0_.universe_id AS universe_id_24
FROM
  products p0_
  LEFT JOIN universes u1_ ON p0_.universe_id = u1_.id
WHERE
  p0_.is_active = ?
  AND u1_.slug = ?
ORDER BY
  p0_.label ASC
LIMIT
  12

SELECT p0_.id AS id_0, p0_.dolibarr_id AS dolibarr_id_1, p0_.ref AS ref_2, p0_.label AS label_3, p0_.slug AS slug_4, p0_.description AS description_5, p0_.long_description AS long_description_6, p0_.price AS price_7, p0_.public_price AS public_price_8, p0_.stock AS stock_9, p0_.low_stock_threshold AS low_stock_threshold_10, p0_.weight AS weight_11, p0_.dimensions AS dimensions_12, p0_.main_image AS main_image_13, p0_.secondary_images AS secondary_images_14, p0_.documents AS documents_15, p0_.is_active AS is_active_16, p0_.is_featured AS is_featured_17, p0_.seo_data AS seo_data_18, p0_.status AS status_19, p0_.created_at AS created_at_20, p0_.updated_at AS updated_at_21, p0_.last_sync_at AS last_sync_at_22, p0_.category_id AS category_id_23, p0_.universe_id AS universe_id_24 FROM products p0_ LEFT JOIN universes u1_ ON p0_.universe_id = u1_.id WHERE p0_.is_active = 1 AND u1_.slug = 'fraises-bois' ORDER BY p0_.label ASC LIMIT 12;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  products p0_
  LEFT JOIN universes u1_ ON p0_.universe_id = u1_.id
WHERE
  p0_.is_active = ?
  AND u1_.slug = ?

SELECT COUNT(p0_.id) AS sclr_0 FROM products p0_ LEFT JOIN universes u1_ ON p0_.universe_id = u1_.id WHERE p0_.is_active = 1 AND u1_.slug = 'fraises-bois';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.icon AS icon_5,
  t0.seo_data AS seo_data_6,
  t0.is_active AS is_active_7,
  t0.sort_order AS sort_order_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  universes t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.seo_data AS seo_data_6, t0.is_active AS is_active_7, t0.sort_order AS sort_order_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM universes t0;

SELECT
  t0.id AS id_1,
  t0.dolibarr_id AS dolibarr_id_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.description AS description_5,
  t0.is_active AS is_active_6,
  t0.sort_order AS sort_order_7,
  t0.seo_data AS seo_data_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.universe_id AS universe_id_11,
  t0.parent_id AS parent_id_12
FROM
  categories t0

SELECT t0.id AS id_1, t0.dolibarr_id AS dolibarr_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.is_active AS is_active_6, t0.sort_order AS sort_order_7, t0.seo_data AS seo_data_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.universe_id AS universe_id_11, t0.parent_id AS parent_id_12 FROM categories t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.icon AS icon_5,
  t0.seo_data AS seo_data_6,
  t0.is_active AS is_active_7,
  t0.sort_order AS sort_order_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  universes t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.seo_data AS seo_data_6, t0.is_active AS is_active_7, t0.sort_order AS sort_order_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM universes t0 WHERE t0.slug = 'fraises-bois' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.icon AS icon_5,
  t0.seo_data AS seo_data_6,
  t0.is_active AS is_active_7,
  t0.sort_order AS sort_order_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  universes t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.seo_data AS seo_data_6, t0.is_active AS is_active_7, t0.sort_order AS sort_order_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM universes t0 WHERE t0.slug = 'fraises-bois' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.icon AS icon_5,
  t0.seo_data AS seo_data_6,
  t0.is_active AS is_active_7,
  t0.sort_order AS sort_order_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  universes t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.seo_data AS seo_data_6, t0.is_active AS is_active_7, t0.sort_order AS sort_order_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM universes t0 WHERE t0.slug = 'fraises-bois' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.icon AS icon_5,
  t0.seo_data AS seo_data_6,
  t0.is_active AS is_active_7,
  t0.sort_order AS sort_order_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  universes t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.seo_data AS seo_data_6, t0.is_active AS is_active_7, t0.sort_order AS sort_order_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM universes t0 WHERE t0.is_active = 1 ORDER BY t0.sort_order ASC;

SELECT
  c0_.id AS id_0,
  c0_.session_id AS session_id_1,
  c0_.created_at AS created_at_2,
  c0_.updated_at AS updated_at_3,
  c0_.expires_at AS expires_at_4,
  c0_.user_id AS user_id_5
FROM
  carts c0_
WHERE
  c0_.session_id = ?
  AND c0_.user_id IS NULL

SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.expires_at AS expires_at_4, c0_.user_id AS user_id_5 FROM carts c0_ WHERE c0_.session_id = '80r2aj6riimoe6k5jeeb0qkrc8' AND c0_.user_id IS NULL;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO carts (
  session_id, created_at, updated_at,
  expires_at, user_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO carts (session_id, created_at, updated_at, expires_at, user_id) VALUES ('80r2aj6riimoe6k5jeeb0qkrc8', '2025-12-06 23:29:13', '2025-12-06 23:29:13', '2026-01-05 23:29:13', NULL);

"COMMIT"

"COMMIT";

SELECT
  c0_.id AS id_0,
  c0_.session_id AS session_id_1,
  c0_.created_at AS created_at_2,
  c0_.updated_at AS updated_at_3,
  c0_.expires_at AS expires_at_4,
  c0_.user_id AS user_id_5
FROM
  carts c0_
WHERE
  c0_.session_id = ?
  AND c0_.user_id IS NULL

SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.expires_at AS expires_at_4, c0_.user_id AS user_id_5 FROM carts c0_ WHERE c0_.session_id = '80r2aj6riimoe6k5jeeb0qkrc8' AND c0_.user_id IS NULL;

SELECT
  c0_.id AS id_0,
  c0_.quantity AS quantity_1,
  c0_.unit_price AS unit_price_2,
  c0_.created_at AS created_at_3,
  c0_.updated_at AS updated_at_4,
  p1_.id AS id_5,
  p1_.dolibarr_id AS dolibarr_id_6,
  p1_.ref AS ref_7,
  p1_.label AS label_8,
  p1_.slug AS slug_9,
  p1_.description AS description_10,
  p1_.long_description AS long_description_11,
  p1_.price AS price_12,
  p1_.public_price AS public_price_13,
  p1_.stock AS stock_14,
  p1_.low_stock_threshold AS low_stock_threshold_15,
  p1_.weight AS weight_16,
  p1_.dimensions AS dimensions_17,
  p1_.main_image AS main_image_18,
  p1_.secondary_images AS secondary_images_19,
  p1_.documents AS documents_20,
  p1_.is_active AS is_active_21,
  p1_.is_featured AS is_featured_22,
  p1_.seo_data AS seo_data_23,
  p1_.status AS status_24,
  p1_.created_at AS created_at_25,
  p1_.updated_at AS updated_at_26,
  p1_.last_sync_at AS last_sync_at_27,
  c0_.cart_id AS cart_id_28,
  c0_.product_id AS product_id_29,
  p1_.category_id AS category_id_30,
  p1_.universe_id AS universe_id_31
FROM
  cart_items c0_
  LEFT JOIN products p1_ ON c0_.product_id = p1_.id
WHERE
  c0_.cart_id = ?
ORDER BY
  c0_.created_at ASC

SELECT c0_.id AS id_0, c0_.quantity AS quantity_1, c0_.unit_price AS unit_price_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, p1_.id AS id_5, p1_.dolibarr_id AS dolibarr_id_6, p1_.ref AS ref_7, p1_.label AS label_8, p1_.slug AS slug_9, p1_.description AS description_10, p1_.long_description AS long_description_11, p1_.price AS price_12, p1_.public_price AS public_price_13, p1_.stock AS stock_14, p1_.low_stock_threshold AS low_stock_threshold_15, p1_.weight AS weight_16, p1_.dimensions AS dimensions_17, p1_.main_image AS main_image_18, p1_.secondary_images AS secondary_images_19, p1_.documents AS documents_20, p1_.is_active AS is_active_21, p1_.is_featured AS is_featured_22, p1_.seo_data AS seo_data_23, p1_.status AS status_24, p1_.created_at AS created_at_25, p1_.updated_at AS updated_at_26, p1_.last_sync_at AS last_sync_at_27, c0_.cart_id AS cart_id_28, c0_.product_id AS product_id_29, p1_.category_id AS category_id_30, p1_.universe_id AS universe_id_31 FROM cart_items c0_ LEFT JOIN products p1_ ON c0_.product_id = p1_.id WHERE c0_.cart_id = 823 ORDER BY c0_.created_at ASC;

SELECT
  c0_.id AS id_0,
  c0_.session_id AS session_id_1,
  c0_.created_at AS created_at_2,
  c0_.updated_at AS updated_at_3,
  c0_.expires_at AS expires_at_4,
  c0_.user_id AS user_id_5
FROM
  carts c0_
WHERE
  c0_.session_id = ?
  AND c0_.user_id IS NULL

SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.expires_at AS expires_at_4, c0_.user_id AS user_id_5 FROM carts c0_ WHERE c0_.session_id = '80r2aj6riimoe6k5jeeb0qkrc8' AND c0_.user_id IS NULL;

SELECT
  c0_.id AS id_0,
  c0_.quantity AS quantity_1,
  c0_.unit_price AS unit_price_2,
  c0_.created_at AS created_at_3,
  c0_.updated_at AS updated_at_4,
  p1_.id AS id_5,
  p1_.dolibarr_id AS dolibarr_id_6,
  p1_.ref AS ref_7,
  p1_.label AS label_8,
  p1_.slug AS slug_9,
  p1_.description AS description_10,
  p1_.long_description AS long_description_11,
  p1_.price AS price_12,
  p1_.public_price AS public_price_13,
  p1_.stock AS stock_14,
  p1_.low_stock_threshold AS low_stock_threshold_15,
  p1_.weight AS weight_16,
  p1_.dimensions AS dimensions_17,
  p1_.main_image AS main_image_18,
  p1_.secondary_images AS secondary_images_19,
  p1_.documents AS documents_20,
  p1_.is_active AS is_active_21,
  p1_.is_featured AS is_featured_22,
  p1_.seo_data AS seo_data_23,
  p1_.status AS status_24,
  p1_.created_at AS created_at_25,
  p1_.updated_at AS updated_at_26,
  p1_.last_sync_at AS last_sync_at_27,
  c0_.cart_id AS cart_id_28,
  c0_.product_id AS product_id_29,
  p1_.category_id AS category_id_30,
  p1_.universe_id AS universe_id_31
FROM
  cart_items c0_
  LEFT JOIN products p1_ ON c0_.product_id = p1_.id
WHERE
  c0_.cart_id = ?
  AND c0_.unit_price <> p1_.price

SELECT c0_.id AS id_0, c0_.quantity AS quantity_1, c0_.unit_price AS unit_price_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, p1_.id AS id_5, p1_.dolibarr_id AS dolibarr_id_6, p1_.ref AS ref_7, p1_.label AS label_8, p1_.slug AS slug_9, p1_.description AS description_10, p1_.long_description AS long_description_11, p1_.price AS price_12, p1_.public_price AS public_price_13, p1_.stock AS stock_14, p1_.low_stock_threshold AS low_stock_threshold_15, p1_.weight AS weight_16, p1_.dimensions AS dimensions_17, p1_.main_image AS main_image_18, p1_.secondary_images AS secondary_images_19, p1_.documents AS documents_20, p1_.is_active AS is_active_21, p1_.is_featured AS is_featured_22, p1_.seo_data AS seo_data_23, p1_.status AS status_24, p1_.created_at AS created_at_25, p1_.updated_at AS updated_at_26, p1_.last_sync_at AS last_sync_at_27, c0_.cart_id AS cart_id_28, c0_.product_id AS product_id_29, p1_.category_id AS category_id_30, p1_.universe_id AS universe_id_31 FROM cart_items c0_ LEFT JOIN products p1_ ON c0_.product_id = p1_.id WHERE c0_.cart_id = 823 AND c0_.unit_price <> p1_.price;