Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.dolibarr_id AS dolibarr_id_2,
  t0.ref AS ref_3,
  t0.label AS label_4,
  t0.slug AS slug_5,
  t0.description AS description_6,
  t0.long_description AS long_description_7,
  t0.price AS price_8,
  t0.public_price AS public_price_9,
  t0.stock AS stock_10,
  t0.low_stock_threshold AS low_stock_threshold_11,
  t0.weight AS weight_12,
  t0.dimensions AS dimensions_13,
  t0.main_image AS main_image_14,
  t0.secondary_images AS secondary_images_15,
  t0.documents AS documents_16,
  t0.is_active AS is_active_17,
  t0.is_featured AS is_featured_18,
  t0.seo_data AS seo_data_19,
  t0.status AS status_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.last_sync_at AS last_sync_at_23,
  t0.category_id AS category_id_24,
  t0.universe_id AS universe_id_25
FROM
  products t0
WHERE
  t0.is_featured = ?
  AND t0.is_active = ?
ORDER BY
  t0.created_at DESC
LIMIT
  8

SELECT t0.id AS id_1, t0.dolibarr_id AS dolibarr_id_2, t0.ref AS ref_3, t0.label AS label_4, t0.slug AS slug_5, t0.description AS description_6, t0.long_description AS long_description_7, t0.price AS price_8, t0.public_price AS public_price_9, t0.stock AS stock_10, t0.low_stock_threshold AS low_stock_threshold_11, t0.weight AS weight_12, t0.dimensions AS dimensions_13, t0.main_image AS main_image_14, t0.secondary_images AS secondary_images_15, t0.documents AS documents_16, t0.is_active AS is_active_17, t0.is_featured AS is_featured_18, t0.seo_data AS seo_data_19, t0.status AS status_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.last_sync_at AS last_sync_at_23, t0.category_id AS category_id_24, t0.universe_id AS universe_id_25 FROM products t0 WHERE t0.is_featured = 1 AND t0.is_active = 1 ORDER BY t0.created_at DESC LIMIT 8;

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
  COUNT(*)
FROM
  products t0
WHERE
  t0.universe_id = ?
  AND t0.is_active = ?

SELECT COUNT(*) FROM products t0 WHERE t0.universe_id = 1 AND t0.is_active = 1;

SELECT
  COUNT(*)
FROM
  products t0
WHERE
  t0.universe_id = ?
  AND t0.is_active = ?

SELECT COUNT(*) FROM products t0 WHERE t0.universe_id = 2 AND t0.is_active = 1;

SELECT
  COUNT(*)
FROM
  products t0
WHERE
  t0.universe_id = ?
  AND t0.is_active = ?

SELECT COUNT(*) FROM products t0 WHERE t0.universe_id = 3 AND t0.is_active = 1;

SELECT
  COUNT(*)
FROM
  products t0
WHERE
  t0.universe_id = ?
  AND t0.is_active = ?

SELECT COUNT(*) FROM products t0 WHERE t0.universe_id = 4 AND t0.is_active = 1;

SELECT
  COUNT(*)
FROM
  products t0
WHERE
  t0.universe_id = ?
  AND t0.is_active = ?

SELECT COUNT(*) FROM products t0 WHERE t0.universe_id = 5 AND t0.is_active = 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 = 'udkb14peg7pcta162jemkotjmu' 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 ('udkb14peg7pcta162jemkotjmu', '2025-12-06 23:41:47', '2025-12-06 23:41:47', '2026-01-05 23:41:47', 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 = 'udkb14peg7pcta162jemkotjmu' 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 = 824 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 = 'udkb14peg7pcta162jemkotjmu' 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 = 824 AND c0_.unit_price <> p1_.price;