Symfony Profiler

SELECT
  p0_.product_id AS sclr_0,
  p0_.quantity AS quantity_1,
  p0_.price AS price_2,
  p0_.promo_price AS promo_price_3,
  p0_.promo_start_at AS promo_start_at_4,
  p0_.promo_end_at AS promo_end_at_5
FROM
  product_price p0_
WHERE
  p0_.product_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  p0_.quantity ASC

SELECT p0_.product_id AS sclr_0, p0_.quantity AS quantity_1, p0_.price AS price_2, p0_.promo_price AS promo_price_3, p0_.promo_start_at AS promo_start_at_4, p0_.promo_end_at AS promo_end_at_5 FROM product_price p0_ WHERE p0_.product_id IN (1, 3, 40, 82, 116, 1650, 6276, 7809, 8157, 11521, 12848, 2, 4, 5, 6, 7, 8, 9, 10, 12, 14, 16, 17, 18) ORDER BY p0_.quantity ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.gtin AS gtin_2,
  p0_.ean AS ean_3,
  p0_.cip AS cip_4,
  p0_.external_code AS external_code_5,
  p0_.weight AS weight_6,
  p0_.amm_number AS amm_number_7,
  p0_.legal_thermo AS legal_thermo_8,
  p0_.legal_bio AS legal_bio_9,
  p0_.legal_eco AS legal_eco_10,
  p0_.legal_danger AS legal_danger_11,
  p0_.legal_atb AS legal_atb_12,
  p0_.is_spe_ali AS is_spe_ali_13,
  p0_.is_colisage AS is_colisage_14,
  p0_.vat_rate AS vat_rate_15,
  p0_.deleted_at AS deleted_at_16,
  p0_.replacement_external_code AS replacement_external_code_17,
  p0_.created_at AS created_at_18,
  p0_.updated_at AS updated_at_19,
  p0_.target_species AS target_species_20,
  p1_.id AS id_21,
  p1_.designation_commerciale AS designation_commerciale_22,
  p1_.conditionnement AS conditionnement_23,
  p1_.image_url AS image_url_24,
  p1_.date_commercialisation AS date_commercialisation_25,
  p1_.nature AS nature_26,
  p1_.composition AS composition_27,
  p1_.indications AS indications_28,
  p1_.mode_administration AS mode_administration_29,
  p1_.indications_utilisation AS indications_utilisation_30,
  p1_.objectifs AS objectifs_31,
  p1_.description_commerciale AS description_commerciale_32,
  p1_.contre_indications AS contre_indications_33,
  p1_.especes AS especes_34,
  p0_.laboratory_code AS laboratory_code_35,
  p0_.product_family_id AS product_family_id_36,
  p0_.therapeutic_class_id AS therapeutic_class_id_37,
  p1_.product_id AS product_id_38
FROM
  product p0_
  LEFT JOIN product_mediatheque p1_ ON p0_.id = p1_.product_id
WHERE
  p0_.external_code IN (?, ?)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.gtin AS gtin_2, p0_.ean AS ean_3, p0_.cip AS cip_4, p0_.external_code AS external_code_5, p0_.weight AS weight_6, p0_.amm_number AS amm_number_7, p0_.legal_thermo AS legal_thermo_8, p0_.legal_bio AS legal_bio_9, p0_.legal_eco AS legal_eco_10, p0_.legal_danger AS legal_danger_11, p0_.legal_atb AS legal_atb_12, p0_.is_spe_ali AS is_spe_ali_13, p0_.is_colisage AS is_colisage_14, p0_.vat_rate AS vat_rate_15, p0_.deleted_at AS deleted_at_16, p0_.replacement_external_code AS replacement_external_code_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.target_species AS target_species_20, p1_.id AS id_21, p1_.designation_commerciale AS designation_commerciale_22, p1_.conditionnement AS conditionnement_23, p1_.image_url AS image_url_24, p1_.date_commercialisation AS date_commercialisation_25, p1_.nature AS nature_26, p1_.composition AS composition_27, p1_.indications AS indications_28, p1_.mode_administration AS mode_administration_29, p1_.indications_utilisation AS indications_utilisation_30, p1_.objectifs AS objectifs_31, p1_.description_commerciale AS description_commerciale_32, p1_.contre_indications AS contre_indications_33, p1_.especes AS especes_34, p0_.laboratory_code AS laboratory_code_35, p0_.product_family_id AS product_family_id_36, p0_.therapeutic_class_id AS therapeutic_class_id_37, p1_.product_id AS product_id_38 FROM product p0_ LEFT JOIN product_mediatheque p1_ ON p0_.id = p1_.product_id WHERE p0_.external_code IN ('808661', '809379');

SELECT
  p0_.product_id AS sclr_0,
  p0_.id AS id_1,
  p1_.id AS id_2,
  p0_.linked_external_code AS linked_external_code_3,
  p1_.name AS name_4,
  p2_.designation_commerciale AS designation_commerciale_5,
  p2_.image_url AS image_url_6,
  p0_.master_quantity AS master_quantity_7,
  p0_.linked_quantity AS linked_quantity_8,
  p0_.is_free AS is_free_9,
  p0_.start_at AS start_at_10,
  p0_.end_at AS end_at_11
FROM
  product_linked p0_
  INNER JOIN product p1_ ON p0_.linked_product_id = p1_.id
  LEFT JOIN product_mediatheque p2_ ON p1_.id = p2_.product_id
WHERE
  p0_.product_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND (
    p0_.start_at IS NULL
    OR p0_.start_at <= ?
  )
  AND (
    p0_.end_at IS NULL
    OR p0_.end_at >= ?
  )
ORDER BY
  p0_.is_free DESC,
  p0_.master_quantity ASC

SELECT p0_.product_id AS sclr_0, p0_.id AS id_1, p1_.id AS id_2, p0_.linked_external_code AS linked_external_code_3, p1_.name AS name_4, p2_.designation_commerciale AS designation_commerciale_5, p2_.image_url AS image_url_6, p0_.master_quantity AS master_quantity_7, p0_.linked_quantity AS linked_quantity_8, p0_.is_free AS is_free_9, p0_.start_at AS start_at_10, p0_.end_at AS end_at_11 FROM product_linked p0_ INNER JOIN product p1_ ON p0_.linked_product_id = p1_.id LEFT JOIN product_mediatheque p2_ ON p1_.id = p2_.product_id WHERE p0_.product_id IN (1, 3, 40, 82, 116, 1650, 6276, 7809, 8157, 11521, 12848, 2, 4, 5, 6, 7, 8, 9, 10, 12, 14, 16, 17, 18) AND (p0_.start_at IS NULL OR p0_.start_at <= '2026-10-05') AND (p0_.end_at IS NULL OR p0_.end_at >= '2026-10-05') ORDER BY p0_.is_free DESC, p0_.master_quantity ASC;

SELECT
  p0_.id AS id_0,
  p0_.depot_id AS depot_id_1,
  p0_.is_visible AS is_visible_2,
  p0_.stock_status AS stock_status_3,
  p0_.product_status AS product_status_4,
  p0_.identity_status AS identity_status_5,
  p0_.available_quantity AS available_quantity_6,
  p0_.future_quantity AS future_quantity_7,
  p0_.rupture_origin AS rupture_origin_8,
  p0_.expiry_date AS expiry_date_9,
  p0_.lot_number AS lot_number_10,
  p0_.updated_at AS updated_at_11,
  p0_.product_id AS product_id_12
FROM
  product_stock p0_
WHERE
  p0_.product_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND p0_.depot_id = ?

SELECT p0_.id AS id_0, p0_.depot_id AS depot_id_1, p0_.is_visible AS is_visible_2, p0_.stock_status AS stock_status_3, p0_.product_status AS product_status_4, p0_.identity_status AS identity_status_5, p0_.available_quantity AS available_quantity_6, p0_.future_quantity AS future_quantity_7, p0_.rupture_origin AS rupture_origin_8, p0_.expiry_date AS expiry_date_9, p0_.lot_number AS lot_number_10, p0_.updated_at AS updated_at_11, p0_.product_id AS product_id_12 FROM product_stock p0_ WHERE p0_.product_id IN (1, 3, 40, 82, 116, 1650, 6276, 7809, 8157, 11521, 12848, 2, 4, 5, 6, 7, 8, 9, 10, 12, 14, 16, 17, 18) AND p0_.depot_id = 1;

SELECT
  t0.id AS id_1,
  t0.external_code AS external_code_2,
  t0.name AS name_3,
  t0.delivery_code AS delivery_code_4,
  t0.email AS email_5,
  t0.phone AS phone_6,
  t0.state AS state_7,
  t0.postal_code AS postal_code_8,
  t0.address AS address_9,
  t0.adrline1 AS adrline1_10,
  t0.adrline2 AS adrline2_11,
  t0.adrline3 AS adrline3_12,
  t0.city AS city_13,
  t0.is_spe_ali AS is_spe_ali_14,
  t0.depot_id AS depot_id_15,
  t0.is_packaging_prohibited AS is_packaging_prohibited_16,
  t0.updated_at AS updated_at_17
FROM
  customer_coveto t0
  INNER JOIN auth_user_customer_coveto ON t0.id = auth_user_customer_coveto.customer_coveto_id
WHERE
  auth_user_customer_coveto.auth_user_id = ?

SELECT t0.id AS id_1, t0.external_code AS external_code_2, t0.name AS name_3, t0.delivery_code AS delivery_code_4, t0.email AS email_5, t0.phone AS phone_6, t0.state AS state_7, t0.postal_code AS postal_code_8, t0.address AS address_9, t0.adrline1 AS adrline1_10, t0.adrline2 AS adrline2_11, t0.adrline3 AS adrline3_12, t0.city AS city_13, t0.is_spe_ali AS is_spe_ali_14, t0.depot_id AS depot_id_15, t0.is_packaging_prohibited AS is_packaging_prohibited_16, t0.updated_at AS updated_at_17 FROM customer_coveto t0 INNER JOIN auth_user_customer_coveto ON t0.id = auth_user_customer_coveto.customer_coveto_id WHERE auth_user_customer_coveto.auth_user_id = 5;

SELECT
  t0.id AS id_1,
  t0.login AS login_2,
  t0.email AS email_3,
  t0.password AS password_4,
  t0.roles AS roles_5,
  t0.api_token AS api_token_6,
  t0.created_at AS created_at_7
FROM
  auth_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.login AS login_2, t0.email AS email_3, t0.password AS password_4, t0.roles AS roles_5, t0.api_token AS api_token_6, t0.created_at AS created_at_7 FROM auth_user t0 WHERE t0.id = 5;

SELECT
  p0_.id AS id_0,
  p0_.created_at AS created_at_1,
  p0_.deleted_at AS deleted_at_2
FROM
  product p0_
WHERE
  p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.deleted_at AS deleted_at_2 FROM product p0_ WHERE p0_.id IN (1, 3, 40, 82, 116, 1650, 6276, 7809, 8157, 11521, 12848, 2, 4, 5, 6, 7, 8, 9, 10, 12, 14, 16, 17, 18);

SELECT
  u0_.product_id AS product_id_0,
  u0_.is_favorite AS is_favorite_1,
  u0_.is_red_list AS is_red_list_2
FROM
  user_product_preference u0_
WHERE
  u0_.user_id = ?
  AND u0_.product_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT u0_.product_id AS product_id_0, u0_.is_favorite AS is_favorite_1, u0_.is_red_list AS is_red_list_2 FROM user_product_preference u0_ WHERE u0_.user_id = 5 AND u0_.product_id IN (1, 3, 40, 82, 116, 1650, 6276, 7809, 8157, 11521, 12848, 2, 4, 5, 6, 7, 8, 9, 10, 12, 14, 16, 17, 18);

SELECT
  u0_.product_id AS product_id_0
FROM
  user_product_preference u0_
WHERE
  u0_.user_id = ?
  AND u0_.is_favorite = 1

SELECT u0_.product_id AS product_id_0 FROM user_product_preference u0_ WHERE u0_.user_id = 5 AND u0_.is_favorite = 1;