Symfony Profiler

SELECT
  p.*,
  u.name as universe_name,
  u.slug as universe_slug,
  m.name as manufacturer_name,
  m.code as manufacturer_code
FROM
  product p
  LEFT JOIN universe u ON p.universe_id = u.id
  LEFT JOIN manufacturer m ON p.manufacturer_id = m.id
WHERE
  p.is_active = true
ORDER BY
  p.label ASC
LIMIT
  12
OFFSET
  24

SELECT p.*,
           u.name as universe_name,
           u.slug as universe_slug,
           m.name as manufacturer_name,
           m.code as manufacturer_code
    FROM product p
    LEFT JOIN universe u ON p.universe_id = u.id
    LEFT JOIN manufacturer m ON p.manufacturer_id = m.id
    WHERE p.is_active = true
    ORDER BY p.label ASC LIMIT 12 OFFSET 24;

SELECT
  *
FROM
  product_image
WHERE
  product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  is_primary DESC,
  sort_order ASC

SELECT * FROM product_image WHERE product_id IN (19,20,17,18,63,64,36,35,26,55,53,54) ORDER BY is_primary DESC, sort_order ASC;

SELECT
  c.*,
  u.name as universe_name,
  u.slug as universe_slug,
  p.name as parent_name
FROM
  category c
  LEFT JOIN universe u ON c.universe_id = u.id
  LEFT JOIN category p ON c.parent_id = p.id
WHERE
  c.is_active = true
ORDER BY
  c.sort_order ASC,
  c.name ASC

SELECT c.*,
           u.name as universe_name,
           u.slug as universe_slug,
           p.name as parent_name
    FROM category c
    LEFT JOIN universe u ON c.universe_id = u.id
    LEFT JOIN category p ON c.parent_id = p.id
    WHERE c.is_active = true
    ORDER BY c.sort_order ASC, c.name ASC;

SELECT
  u.*
FROM
  universe u
WHERE
  u.is_active = true
ORDER BY
  u.sort_order ASC,
  u.name ASC

SELECT u.*
    FROM universe u
    WHERE u.is_active = true
    ORDER BY u.sort_order ASC, u.name ASC;

SELECT
  COUNT(*)
FROM
  product p
  LEFT JOIN universe u ON p.universe_id = u.id
WHERE
  p.is_active = true

SELECT COUNT(*) FROM product p LEFT JOIN universe u ON p.universe_id = u.id WHERE p.is_active = true;

"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 = 'rspl7l45p26p1kocidsjjs9qc1' 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 = 1240 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 = ?
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 = 1240 ORDER BY c0_.created_at ASC;

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 ('rspl7l45p26p1kocidsjjs9qc1', '2026-02-05 09:36:04', '2026-02-05 09:36:04', '2026-03-07 09:36:04', NULL);

"START TRANSACTION"

"START TRANSACTION";