Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.date_debut_promo AS date_debut_promo_2,
  t0.date_fin_promo AS date_fin_promo_3,
  t0.produit_id AS produit_id_4,
  t0.promotion_id AS promotion_id_5
FROM
  produit_promotion t0
WHERE
  t0.produit_id = ?

SELECT t0.id AS id_1, t0.date_debut_promo AS date_debut_promo_2, t0.date_fin_promo AS date_fin_promo_3, t0.produit_id AS produit_id_4, t0.promotion_id AS promotion_id_5 FROM produit_promotion t0 WHERE t0.produit_id = 68;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.image_url AS image_url_3,
  t0.produit_id AS produit_id_4,
  t0.produit_variant_id AS produit_variant_id_5
FROM
  image t0
WHERE
  t0.produit_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = 68;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.tax AS tax_3
FROM
  category t0
ORDER BY
  t0.nom ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.tax AS tax_3 FROM category t0 ORDER BY t0.nom ASC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.product_name AS product_name_1,
          p0_.qtt AS qtt_2,
          p0_.prix AS prix_3,
          p0_.publish_item AS publish_item_4,
          p0_.promo AS promo_5,
          p0_.description AS description_6,
          p0_.publish_date AS publish_date_7,
          p0_.sale_price AS sale_price_8,
          p0_.cost_price AS cost_price_9,
          p0_.date_production AS date_production_10,
          p0_.date_expiration AS date_expiration_11,
          p0_.variant_type AS variant_type_12,
          p0_.variant_type2 AS variant_type2_13,
          p0_.variant_type3 AS variant_type3_14,
          c1_.id AS id_15,
          c1_.nom AS nom_16,
          c1_.tax AS tax_17
        FROM
          produit p0_
          INNER JOIN category c1_ ON p0_.category_id = c1_.id
          LEFT JOIN magasin m2_ ON p0_.magasin_id = m2_.id
        WHERE
          (
            p0_.publish_item = 1
            OR ? = 1
          )
          AND (
            (
              m2_.active = 1
              AND (
                m2_.subscription_paid_until IS NULL
                OR m2_.subscription_paid_until >= ?
              )
            )
            OR ? = 1
          )
        ORDER BY
          p0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.product_name AS product_name_1, p0_.qtt AS qtt_2, p0_.prix AS prix_3, p0_.publish_item AS publish_item_4, p0_.promo AS promo_5, p0_.description AS description_6, p0_.publish_date AS publish_date_7, p0_.sale_price AS sale_price_8, p0_.cost_price AS cost_price_9, p0_.date_production AS date_production_10, p0_.date_expiration AS date_expiration_11, p0_.variant_type AS variant_type_12, p0_.variant_type2 AS variant_type2_13, p0_.variant_type3 AS variant_type3_14, c1_.id AS id_15, c1_.nom AS nom_16, c1_.tax AS tax_17 FROM produit p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id LEFT JOIN magasin m2_ ON p0_.magasin_id = m2_.id WHERE (p0_.publish_item = 1 OR 0 = 1) AND ((m2_.active = 1 AND (m2_.subscription_paid_until IS NULL OR m2_.subscription_paid_until >= '2026-06-16 00:00:00')) OR 0 = 1) ORDER BY p0_.id DESC) dctrn_result) dctrn_table;

SELECT
  m0_.id AS id_0,
  m0_.start_time AS start_time_1,
  m0_.end_time AS end_time_2,
  m0_.description AS description_3,
  m0_.is_active AS is_active_4
FROM
  maintenance_schedule m0_
WHERE
  m0_.is_active = ?
  AND m0_.start_time <= ?
  AND m0_.end_time >= ?
ORDER BY
  m0_.end_time DESC
LIMIT
  1

SELECT m0_.id AS id_0, m0_.start_time AS start_time_1, m0_.end_time AS end_time_2, m0_.description AS description_3, m0_.is_active AS is_active_4 FROM maintenance_schedule m0_ WHERE m0_.is_active = 1 AND m0_.start_time <= '2026-06-16 19:07:53' AND m0_.end_time >= '2026-06-16 19:07:53' ORDER BY m0_.end_time DESC LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.product_name AS product_name_1,
  p0_.qtt AS qtt_2,
  p0_.prix AS prix_3,
  p0_.publish_item AS publish_item_4,
  p0_.promo AS promo_5,
  p0_.description AS description_6,
  p0_.publish_date AS publish_date_7,
  p0_.sale_price AS sale_price_8,
  p0_.cost_price AS cost_price_9,
  p0_.date_production AS date_production_10,
  p0_.date_expiration AS date_expiration_11,
  p0_.variant_type AS variant_type_12,
  p0_.variant_type2 AS variant_type2_13,
  p0_.variant_type3 AS variant_type3_14,
  c1_.id AS id_15,
  c1_.nom AS nom_16,
  c1_.tax AS tax_17,
  p0_.category_id AS category_id_18,
  p0_.user_id AS user_id_19,
  p0_.magasin_id AS magasin_id_20
FROM
  produit p0_
  INNER JOIN category c1_ ON p0_.category_id = c1_.id
  LEFT JOIN magasin m2_ ON p0_.magasin_id = m2_.id
WHERE
  (
    p0_.publish_item = 1
    OR ? = 1
  )
  AND (
    (
      m2_.active = 1
      AND (
        m2_.subscription_paid_until IS NULL
        OR m2_.subscription_paid_until >= ?
      )
    )
    OR ? = 1
  )
  AND p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.product_name AS product_name_1, p0_.qtt AS qtt_2, p0_.prix AS prix_3, p0_.publish_item AS publish_item_4, p0_.promo AS promo_5, p0_.description AS description_6, p0_.publish_date AS publish_date_7, p0_.sale_price AS sale_price_8, p0_.cost_price AS cost_price_9, p0_.date_production AS date_production_10, p0_.date_expiration AS date_expiration_11, p0_.variant_type AS variant_type_12, p0_.variant_type2 AS variant_type2_13, p0_.variant_type3 AS variant_type3_14, c1_.id AS id_15, c1_.nom AS nom_16, c1_.tax AS tax_17, p0_.category_id AS category_id_18, p0_.user_id AS user_id_19, p0_.magasin_id AS magasin_id_20 FROM produit p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id LEFT JOIN magasin m2_ ON p0_.magasin_id = m2_.id WHERE (p0_.publish_item = 1 OR 0 = 1) AND ((m2_.active = 1 AND (m2_.subscription_paid_until IS NULL OR m2_.subscription_paid_until >= '2026-06-16 00:00:00')) OR 0 = 1) AND p0_.id IN (68, 66, 65, 61, 60, 59, 58, 57, 56, 55, 53, 45, 43, 42, 41, 40, 39, 38, 36, 35, 32, 30, 29, 28) ORDER BY p0_.id DESC;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.product_name AS product_name_1,
          p0_.qtt AS qtt_2,
          p0_.prix AS prix_3,
          p0_.publish_item AS publish_item_4,
          p0_.promo AS promo_5,
          p0_.description AS description_6,
          p0_.publish_date AS publish_date_7,
          p0_.sale_price AS sale_price_8,
          p0_.cost_price AS cost_price_9,
          p0_.date_production AS date_production_10,
          p0_.date_expiration AS date_expiration_11,
          p0_.variant_type AS variant_type_12,
          p0_.variant_type2 AS variant_type2_13,
          p0_.variant_type3 AS variant_type3_14,
          c1_.id AS id_15,
          c1_.nom AS nom_16,
          c1_.tax AS tax_17,
          m2_.id AS id_18,
          m2_.nom AS nom_19,
          m2_.logo_path AS logo_path_20,
          m2_.active AS active_21,
          m2_.subscription_paid_until AS subscription_paid_until_22,
          m2_.adresse AS adresse_23,
          m2_.telephone AS telephone_24,
          m2_.numero_cr AS numero_cr_25,
          m2_.numero_tva AS numero_tva_26
        FROM
          produit p0_
          INNER JOIN category c1_ ON p0_.category_id = c1_.id
          LEFT JOIN magasin m2_ ON p0_.magasin_id = m2_.id
        WHERE
          (
            p0_.publish_item = 1
            OR ? = 1
          )
          AND (
            (
              m2_.active = 1
              AND (
                m2_.subscription_paid_until IS NULL
                OR m2_.subscription_paid_until >= ?
              )
            )
            OR ? = 1
          )
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  24

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.product_name AS product_name_1, p0_.qtt AS qtt_2, p0_.prix AS prix_3, p0_.publish_item AS publish_item_4, p0_.promo AS promo_5, p0_.description AS description_6, p0_.publish_date AS publish_date_7, p0_.sale_price AS sale_price_8, p0_.cost_price AS cost_price_9, p0_.date_production AS date_production_10, p0_.date_expiration AS date_expiration_11, p0_.variant_type AS variant_type_12, p0_.variant_type2 AS variant_type2_13, p0_.variant_type3 AS variant_type3_14, c1_.id AS id_15, c1_.nom AS nom_16, c1_.tax AS tax_17, m2_.id AS id_18, m2_.nom AS nom_19, m2_.logo_path AS logo_path_20, m2_.active AS active_21, m2_.subscription_paid_until AS subscription_paid_until_22, m2_.adresse AS adresse_23, m2_.telephone AS telephone_24, m2_.numero_cr AS numero_cr_25, m2_.numero_tva AS numero_tva_26 FROM produit p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id LEFT JOIN magasin m2_ ON p0_.magasin_id = m2_.id WHERE (p0_.publish_item = 1 OR 0 = 1) AND ((m2_.active = 1 AND (m2_.subscription_paid_until IS NULL OR m2_.subscription_paid_until >= '2026-06-16 00:00:00')) OR 0 = 1)) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 24;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.product_name AS product_name_1,
          p0_.qtt AS qtt_2,
          p0_.prix AS prix_3,
          p0_.publish_item AS publish_item_4,
          p0_.promo AS promo_5,
          p0_.description AS description_6,
          p0_.publish_date AS publish_date_7,
          p0_.sale_price AS sale_price_8,
          p0_.cost_price AS cost_price_9,
          p0_.date_production AS date_production_10,
          p0_.date_expiration AS date_expiration_11,
          p0_.variant_type AS variant_type_12,
          p0_.variant_type2 AS variant_type2_13,
          p0_.variant_type3 AS variant_type3_14
        FROM
          produit p0_
          LEFT JOIN magasin m1_ ON p0_.magasin_id = m1_.id
        WHERE
          p0_.publish_date <= ?
          AND p0_.publish_date >= ?
          AND (
            p0_.publish_item = 1
            OR ? = 1
          )
          AND (
            (
              m1_.active = 1
              AND (
                m1_.subscription_paid_until IS NULL
                OR m1_.subscription_paid_until >= ?
              )
            )
            OR ? = 1
          )
        ORDER BY
          p0_.publish_date DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.product_name AS product_name_1, p0_.qtt AS qtt_2, p0_.prix AS prix_3, p0_.publish_item AS publish_item_4, p0_.promo AS promo_5, p0_.description AS description_6, p0_.publish_date AS publish_date_7, p0_.sale_price AS sale_price_8, p0_.cost_price AS cost_price_9, p0_.date_production AS date_production_10, p0_.date_expiration AS date_expiration_11, p0_.variant_type AS variant_type_12, p0_.variant_type2 AS variant_type2_13, p0_.variant_type3 AS variant_type3_14 FROM produit p0_ LEFT JOIN magasin m1_ ON p0_.magasin_id = m1_.id WHERE p0_.publish_date <= '2026-06-16 19:07:53' AND p0_.publish_date >= '2026-05-17 19:07:53' AND (p0_.publish_item = 1 OR 0 = 1) AND ((m1_.active = 1 AND (m1_.subscription_paid_until IS NULL OR m1_.subscription_paid_until >= '2026-06-16 00:00:00')) OR 0 = 1) ORDER BY p0_.publish_date DESC) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.logo_path AS logo_path_3,
  t0.active AS active_4,
  t0.subscription_paid_until AS subscription_paid_until_5,
  t0.adresse AS adresse_6,
  t0.telephone AS telephone_7,
  t0.numero_cr AS numero_cr_8,
  t0.numero_tva AS numero_tva_9,
  t0.country_id AS country_id_10,
  t0.region_id AS region_id_11,
  t0.city_id AS city_id_12
FROM
  magasin t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.logo_path AS logo_path_3, t0.active AS active_4, t0.subscription_paid_until AS subscription_paid_until_5, t0.adresse AS adresse_6, t0.telephone AS telephone_7, t0.numero_cr AS numero_cr_8, t0.numero_tva AS numero_tva_9, t0.country_id AS country_id_10, t0.region_id AS region_id_11, t0.city_id AS city_id_12 FROM magasin t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.iso_code AS iso_code_3,
  t0.phone_code AS phone_code_4
FROM
  country t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.phone_code AS phone_code_4 FROM country t0 ORDER BY t0.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.tax AS tax_2
FROM
  category c0_

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.tax AS tax_2 FROM category c0_;