Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordre AS ordre_3,
  t0.image AS image_4,
  t0.seo_titre AS seo_titre_5,
  t0.seo_description AS seo_description_6,
  t0.slug AS slug_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9
FROM
  category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordre AS ordre_3, t0.image AS image_4, t0.seo_titre AS seo_titre_5, t0.seo_description AS seo_description_6, t0.slug AS slug_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9 FROM category t0 WHERE t0.slug = 'objectifs' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.code_a_barre AS code_a_barre_3,
  p0_.ordre AS ordre_4,
  p0_.prix_achat AS prix_achat_5,
  p0_.marge_vente AS marge_vente_6,
  p0_.prix_vente AS prix_vente_7,
  p0_.marge_remise AS marge_remise_8,
  p0_.prix_promotion AS prix_promotion_9,
  p0_.remise_gros AS remise_gros_10,
  p0_.prix_gros AS prix_gros_11,
  p0_.stock AS stock_12,
  p0_.is_active AS is_active_13,
  p0_.is_pack AS is_pack_14,
  p0_.image AS image_15,
  p0_.image_publicitaire AS image_publicitaire_16,
  p0_.date_debut AS date_debut_17,
  p0_.date_fin AS date_fin_18,
  p0_.created_at AS created_at_19,
  p0_.image_label AS image_label_20,
  p0_.product_group_id AS product_group_id_21,
  p0_.unit_detail_base_price_id AS unit_detail_base_price_id_22,
  p0_.unit_detail_id AS unit_detail_id_23
FROM
  product p0_
  INNER JOIN product_group p1_ ON p0_.product_group_id = p1_.id
  INNER JOIN product_group_category p3_ ON p1_.id = p3_.product_group_id
  INNER JOIN category c2_ ON c2_.id = p3_.category_id
WHERE
  p0_.is_active = 1
  AND c2_.id = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.code_a_barre AS code_a_barre_3, p0_.ordre AS ordre_4, p0_.prix_achat AS prix_achat_5, p0_.marge_vente AS marge_vente_6, p0_.prix_vente AS prix_vente_7, p0_.marge_remise AS marge_remise_8, p0_.prix_promotion AS prix_promotion_9, p0_.remise_gros AS remise_gros_10, p0_.prix_gros AS prix_gros_11, p0_.stock AS stock_12, p0_.is_active AS is_active_13, p0_.is_pack AS is_pack_14, p0_.image AS image_15, p0_.image_publicitaire AS image_publicitaire_16, p0_.date_debut AS date_debut_17, p0_.date_fin AS date_fin_18, p0_.created_at AS created_at_19, p0_.image_label AS image_label_20, p0_.product_group_id AS product_group_id_21, p0_.unit_detail_base_price_id AS unit_detail_base_price_id_22, p0_.unit_detail_id AS unit_detail_id_23 FROM product p0_ INNER JOIN product_group p1_ ON p0_.product_group_id = p1_.id INNER JOIN product_group_category p3_ ON p1_.id = p3_.product_group_id INNER JOIN category c2_ ON c2_.id = p3_.category_id WHERE p0_.is_active = 1 AND c2_.id = 8;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.code_a_barre AS code_a_barre_3,
  p0_.ordre AS ordre_4,
  p0_.prix_achat AS prix_achat_5,
  p0_.marge_vente AS marge_vente_6,
  p0_.prix_vente AS prix_vente_7,
  p0_.marge_remise AS marge_remise_8,
  p0_.prix_promotion AS prix_promotion_9,
  p0_.remise_gros AS remise_gros_10,
  p0_.prix_gros AS prix_gros_11,
  p0_.stock AS stock_12,
  p0_.is_active AS is_active_13,
  p0_.is_pack AS is_pack_14,
  p0_.image AS image_15,
  p0_.image_publicitaire AS image_publicitaire_16,
  p0_.date_debut AS date_debut_17,
  p0_.date_fin AS date_fin_18,
  p0_.created_at AS created_at_19,
  p0_.image_label AS image_label_20,
  p0_.product_group_id AS product_group_id_21,
  p0_.unit_detail_base_price_id AS unit_detail_base_price_id_22,
  p0_.unit_detail_id AS unit_detail_id_23
FROM
  product p0_
  INNER JOIN product_group p1_ ON p0_.product_group_id = p1_.id
  INNER JOIN product_group_category p3_ ON p1_.id = p3_.product_group_id
  INNER JOIN category c2_ ON c2_.id = p3_.category_id
WHERE
  c2_.id = ?
  AND p0_.is_active = 1
ORDER BY
  p0_.ordre ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.code_a_barre AS code_a_barre_3, p0_.ordre AS ordre_4, p0_.prix_achat AS prix_achat_5, p0_.marge_vente AS marge_vente_6, p0_.prix_vente AS prix_vente_7, p0_.marge_remise AS marge_remise_8, p0_.prix_promotion AS prix_promotion_9, p0_.remise_gros AS remise_gros_10, p0_.prix_gros AS prix_gros_11, p0_.stock AS stock_12, p0_.is_active AS is_active_13, p0_.is_pack AS is_pack_14, p0_.image AS image_15, p0_.image_publicitaire AS image_publicitaire_16, p0_.date_debut AS date_debut_17, p0_.date_fin AS date_fin_18, p0_.created_at AS created_at_19, p0_.image_label AS image_label_20, p0_.product_group_id AS product_group_id_21, p0_.unit_detail_base_price_id AS unit_detail_base_price_id_22, p0_.unit_detail_id AS unit_detail_id_23 FROM product p0_ INNER JOIN product_group p1_ ON p0_.product_group_id = p1_.id INNER JOIN product_group_category p3_ ON p1_.id = p3_.product_group_id INNER JOIN category c2_ ON c2_.id = p3_.category_id WHERE c2_.id = 8 AND p0_.is_active = 1 ORDER BY p0_.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adresse AS adresse_3,
  t0.whatsapp AS whatsapp_4,
  t0.mobile AS mobile_5,
  t0.fixe AS fixe_6,
  t0.facebook AS facebook_7,
  t0.linkedin AS linkedin_8,
  t0.youtube AS youtube_9,
  t0.instagram AS instagram_10,
  t0.email AS email_11,
  t0.image AS image_12,
  t0.created_at AS created_at_13,
  t0.tik_tok AS tik_tok_14,
  t0.email_commande AS email_commande_15,
  t0.gouvernorat_id AS gouvernorat_id_16,
  t0.citie_id AS citie_id_17,
  t0.town_id AS town_id_18
FROM
  entreprise t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.whatsapp AS whatsapp_4, t0.mobile AS mobile_5, t0.fixe AS fixe_6, t0.facebook AS facebook_7, t0.linkedin AS linkedin_8, t0.youtube AS youtube_9, t0.instagram AS instagram_10, t0.email AS email_11, t0.image AS image_12, t0.created_at AS created_at_13, t0.tik_tok AS tik_tok_14, t0.email_commande AS email_commande_15, t0.gouvernorat_id AS gouvernorat_id_16, t0.citie_id AS citie_id_17, t0.town_id AS town_id_18 FROM entreprise t0 WHERE t0.id = 1;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.ordre AS ordre_2,
  s0_.seo_titre AS seo_titre_3,
  s0_.seo_description AS seo_description_4,
  s0_.image AS image_5,
  s0_.slug AS slug_6,
  s0_.is_active AS is_active_7,
  s0_.created_at AS created_at_8
FROM
  sub_category s0_
  INNER JOIN product_group_sub_category p2_ ON s0_.id = p2_.sub_category_id
  INNER JOIN product_group p1_ ON p1_.id = p2_.product_group_id
  INNER JOIN product_group_category p4_ ON p1_.id = p4_.product_group_id
  INNER JOIN category c3_ ON c3_.id = p4_.category_id
  INNER JOIN product p5_ ON p1_.id = p5_.product_group_id
WHERE
  s0_.is_active = 1
  AND p1_.is_active = 1
  AND c3_.id = ?
  AND p5_.is_active = 1
GROUP BY
  s0_.id

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ordre AS ordre_2, s0_.seo_titre AS seo_titre_3, s0_.seo_description AS seo_description_4, s0_.image AS image_5, s0_.slug AS slug_6, s0_.is_active AS is_active_7, s0_.created_at AS created_at_8 FROM sub_category s0_ INNER JOIN product_group_sub_category p2_ ON s0_.id = p2_.sub_category_id INNER JOIN product_group p1_ ON p1_.id = p2_.product_group_id INNER JOIN product_group_category p4_ ON p1_.id = p4_.product_group_id INNER JOIN category c3_ ON c3_.id = p4_.category_id INNER JOIN product p5_ ON p1_.id = p5_.product_group_id WHERE s0_.is_active = 1 AND p1_.is_active = 1 AND c3_.id = 8 AND p5_.is_active = 1 GROUP BY s0_.id;

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.ordre AS ordre_2,
  u0_.created_at AS created_at_3,
  u0_.code_coleur AS code_coleur_4,
  u0_.unite_id AS unite_id_5
FROM
  unite_detail u0_
  INNER JOIN product p1_ ON u0_.id = p1_.unit_detail_base_price_id
  INNER JOIN unite u2_ ON u0_.unite_id = u2_.id
  INNER JOIN product_group p3_ ON p1_.product_group_id = p3_.id
  INNER JOIN product_group_category p5_ ON p3_.id = p5_.product_group_id
  INNER JOIN category c4_ ON c4_.id = p5_.category_id
WHERE
  p1_.is_active = 1
  AND c4_.id = ?
ORDER BY
  u2_.name ASC,
  u0_.name ASC

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.ordre AS ordre_2, u0_.created_at AS created_at_3, u0_.code_coleur AS code_coleur_4, u0_.unite_id AS unite_id_5 FROM unite_detail u0_ INNER JOIN product p1_ ON u0_.id = p1_.unit_detail_base_price_id INNER JOIN unite u2_ ON u0_.unite_id = u2_.id INNER JOIN product_group p3_ ON p1_.product_group_id = p3_.id INNER JOIN product_group_category p5_ ON p3_.id = p5_.product_group_id INNER JOIN category c4_ ON c4_.id = p5_.category_id WHERE p1_.is_active = 1 AND c4_.id = 8 ORDER BY u2_.name ASC, u0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.position AS position_4,
  t0.created_at AS created_at_5,
  t0.is_price_unit AS is_price_unit_6
FROM
  unite t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.is_price_unit AS is_price_unit_6 FROM unite t0 WHERE t0.id = 10;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.position AS position_4,
  t0.created_at AS created_at_5,
  t0.is_price_unit AS is_price_unit_6
FROM
  unite t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.is_price_unit AS is_price_unit_6 FROM unite t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.position AS position_4,
  t0.created_at AS created_at_5,
  t0.is_price_unit AS is_price_unit_6
FROM
  unite t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.is_price_unit AS is_price_unit_6 FROM unite t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.position AS position_4,
  t0.created_at AS created_at_5,
  t0.is_price_unit AS is_price_unit_6
FROM
  unite t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.is_price_unit AS is_price_unit_6 FROM unite t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.position AS position_4,
  t0.created_at AS created_at_5,
  t0.is_price_unit AS is_price_unit_6
FROM
  unite t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.is_price_unit AS is_price_unit_6 FROM unite t0 WHERE t0.id = 1;

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.ordre AS ordre_2,
  u0_.created_at AS created_at_3,
  u0_.code_coleur AS code_coleur_4,
  u0_.unite_id AS unite_id_5
FROM
  unite_detail u0_
  INNER JOIN product p1_ ON u0_.id = p1_.unit_detail_id
  INNER JOIN product_group p2_ ON p1_.product_group_id = p2_.id
  INNER JOIN product_group_category p4_ ON p2_.id = p4_.product_group_id
  INNER JOIN category c3_ ON c3_.id = p4_.category_id
WHERE
  p1_.is_active = 1
  AND c3_.id = ?
GROUP BY
  u0_.id

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.ordre AS ordre_2, u0_.created_at AS created_at_3, u0_.code_coleur AS code_coleur_4, u0_.unite_id AS unite_id_5 FROM unite_detail u0_ INNER JOIN product p1_ ON u0_.id = p1_.unit_detail_id INNER JOIN product_group p2_ ON p1_.product_group_id = p2_.id INNER JOIN product_group_category p4_ ON p2_.id = p4_.product_group_id INNER JOIN category c3_ ON c3_.id = p4_.category_id WHERE p1_.is_active = 1 AND c3_.id = 8 GROUP BY u0_.id;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.code_a_barre AS code_a_barre_3,
  p0_.ordre AS ordre_4,
  p0_.prix_achat AS prix_achat_5,
  p0_.marge_vente AS marge_vente_6,
  p0_.prix_vente AS prix_vente_7,
  p0_.marge_remise AS marge_remise_8,
  p0_.prix_promotion AS prix_promotion_9,
  p0_.remise_gros AS remise_gros_10,
  p0_.prix_gros AS prix_gros_11,
  p0_.stock AS stock_12,
  p0_.is_active AS is_active_13,
  p0_.is_pack AS is_pack_14,
  p0_.image AS image_15,
  p0_.image_publicitaire AS image_publicitaire_16,
  p0_.date_debut AS date_debut_17,
  p0_.date_fin AS date_fin_18,
  p0_.created_at AS created_at_19,
  p0_.image_label AS image_label_20,
  p0_.product_group_id AS product_group_id_21,
  p0_.unit_detail_base_price_id AS unit_detail_base_price_id_22,
  p0_.unit_detail_id AS unit_detail_id_23
FROM
  product p0_
WHERE
  p0_.is_active = ?
  AND p0_.stock > ?
ORDER BY
  p0_.created_at DESC
LIMIT
  3

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.code_a_barre AS code_a_barre_3, p0_.ordre AS ordre_4, p0_.prix_achat AS prix_achat_5, p0_.marge_vente AS marge_vente_6, p0_.prix_vente AS prix_vente_7, p0_.marge_remise AS marge_remise_8, p0_.prix_promotion AS prix_promotion_9, p0_.remise_gros AS remise_gros_10, p0_.prix_gros AS prix_gros_11, p0_.stock AS stock_12, p0_.is_active AS is_active_13, p0_.is_pack AS is_pack_14, p0_.image AS image_15, p0_.image_publicitaire AS image_publicitaire_16, p0_.date_debut AS date_debut_17, p0_.date_fin AS date_fin_18, p0_.created_at AS created_at_19, p0_.image_label AS image_label_20, p0_.product_group_id AS product_group_id_21, p0_.unit_detail_base_price_id AS unit_detail_base_price_id_22, p0_.unit_detail_id AS unit_detail_id_23 FROM product p0_ WHERE p0_.is_active = 1 AND p0_.stock > 0 ORDER BY p0_.created_at DESC LIMIT 3;

SELECT
  b0_.id AS id_0,
  b0_.titre AS titre_1,
  b0_.sous_titre AS sous_titre_2,
  b0_.image AS image_3,
  b0_.button_text AS button_text_4,
  b0_.button_class AS button_class_5,
  b0_.page AS page_6,
  b0_.custom_url AS custom_url_7,
  b0_.is_active AS is_active_8,
  b0_.ordre AS ordre_9,
  b0_.date_debut AS date_debut_10,
  b0_.date_fin AS date_fin_11,
  b0_.created_at AS created_at_12,
  b0_.updated_at AS updated_at_13,
  b0_.category_id AS category_id_14,
  b0_.sub_category_id AS sub_category_id_15,
  b0_.product_id AS product_id_16
FROM
  banner_product b0_
WHERE
  b0_.page = ?
  AND b0_.is_active = 1
  AND (
    (
      b0_.date_debut IS NULL
      OR b0_.date_debut <= ?
    )
  )
  AND (
    (
      b0_.date_fin IS NULL
      OR b0_.date_fin >= ?
    )
  )
ORDER BY
  b0_.ordre ASC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.titre AS titre_1, b0_.sous_titre AS sous_titre_2, b0_.image AS image_3, b0_.button_text AS button_text_4, b0_.button_class AS button_class_5, b0_.page AS page_6, b0_.custom_url AS custom_url_7, b0_.is_active AS is_active_8, b0_.ordre AS ordre_9, b0_.date_debut AS date_debut_10, b0_.date_fin AS date_fin_11, b0_.created_at AS created_at_12, b0_.updated_at AS updated_at_13, b0_.category_id AS category_id_14, b0_.sub_category_id AS sub_category_id_15, b0_.product_id AS product_id_16 FROM banner_product b0_ WHERE b0_.page = 'category' AND b0_.is_active = 1 AND ((b0_.date_debut IS NULL OR b0_.date_debut <= '2025-12-10 01:22:15')) AND ((b0_.date_fin IS NULL OR b0_.date_fin >= '2025-12-10 01:22:15')) ORDER BY b0_.ordre ASC LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.ordre AS ordre_2,
  c0_.image AS image_3,
  c0_.seo_titre AS seo_titre_4,
  c0_.seo_description AS seo_description_5,
  c0_.slug AS slug_6,
  c0_.is_active AS is_active_7,
  c0_.created_at AS created_at_8
FROM
  category c0_
WHERE
  c0_.is_active = 1
ORDER BY
  c0_.ordre ASC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.ordre AS ordre_2, c0_.image AS image_3, c0_.seo_titre AS seo_titre_4, c0_.seo_description AS seo_description_5, c0_.slug AS slug_6, c0_.is_active AS is_active_7, c0_.created_at AS created_at_8 FROM category c0_ WHERE c0_.is_active = 1 ORDER BY c0_.ordre ASC LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.ordre AS ordre_2,
  s0_.seo_titre AS seo_titre_3,
  s0_.seo_description AS seo_description_4,
  s0_.image AS image_5,
  s0_.slug AS slug_6,
  s0_.is_active AS is_active_7,
  s0_.created_at AS created_at_8
FROM
  sub_category s0_
WHERE
  s0_.is_active = 1
ORDER BY
  s0_.ordre ASC
LIMIT
  2

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ordre AS ordre_2, s0_.seo_titre AS seo_titre_3, s0_.seo_description AS seo_description_4, s0_.image AS image_5, s0_.slug AS slug_6, s0_.is_active AS is_active_7, s0_.created_at AS created_at_8 FROM sub_category s0_ WHERE s0_.is_active = 1 ORDER BY s0_.ordre ASC LIMIT 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordre AS ordre_3,
  t0.image AS image_4,
  t0.seo_titre AS seo_titre_5,
  t0.seo_description AS seo_description_6,
  t0.slug AS slug_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9
FROM
  category t0
  INNER JOIN sub_category_category ON t0.id = sub_category_category.category_id
WHERE
  sub_category_category.sub_category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordre AS ordre_3, t0.image AS image_4, t0.seo_titre AS seo_titre_5, t0.seo_description AS seo_description_6, t0.slug AS slug_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9 FROM category t0 INNER JOIN sub_category_category ON t0.id = sub_category_category.category_id WHERE sub_category_category.sub_category_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordre AS ordre_3,
  t0.image AS image_4,
  t0.seo_titre AS seo_titre_5,
  t0.seo_description AS seo_description_6,
  t0.slug AS slug_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9
FROM
  category t0
  INNER JOIN sub_category_category ON t0.id = sub_category_category.category_id
WHERE
  sub_category_category.sub_category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordre AS ordre_3, t0.image AS image_4, t0.seo_titre AS seo_titre_5, t0.seo_description AS seo_description_6, t0.slug AS slug_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9 FROM category t0 INNER JOIN sub_category_category ON t0.id = sub_category_category.category_id WHERE sub_category_category.sub_category_id = 10;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.code_a_barre AS code_a_barre_3,
  p0_.ordre AS ordre_4,
  p0_.prix_achat AS prix_achat_5,
  p0_.marge_vente AS marge_vente_6,
  p0_.prix_vente AS prix_vente_7,
  p0_.marge_remise AS marge_remise_8,
  p0_.prix_promotion AS prix_promotion_9,
  p0_.remise_gros AS remise_gros_10,
  p0_.prix_gros AS prix_gros_11,
  p0_.stock AS stock_12,
  p0_.is_active AS is_active_13,
  p0_.is_pack AS is_pack_14,
  p0_.image AS image_15,
  p0_.image_publicitaire AS image_publicitaire_16,
  p0_.date_debut AS date_debut_17,
  p0_.date_fin AS date_fin_18,
  p0_.created_at AS created_at_19,
  p0_.image_label AS image_label_20,
  p0_.product_group_id AS product_group_id_21,
  p0_.unit_detail_base_price_id AS unit_detail_base_price_id_22,
  p0_.unit_detail_id AS unit_detail_id_23
FROM
  product p0_
WHERE
  p0_.is_active = 1
ORDER BY
  p0_.ordre ASC
LIMIT
  3

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.code_a_barre AS code_a_barre_3, p0_.ordre AS ordre_4, p0_.prix_achat AS prix_achat_5, p0_.marge_vente AS marge_vente_6, p0_.prix_vente AS prix_vente_7, p0_.marge_remise AS marge_remise_8, p0_.prix_promotion AS prix_promotion_9, p0_.remise_gros AS remise_gros_10, p0_.prix_gros AS prix_gros_11, p0_.stock AS stock_12, p0_.is_active AS is_active_13, p0_.is_pack AS is_pack_14, p0_.image AS image_15, p0_.image_publicitaire AS image_publicitaire_16, p0_.date_debut AS date_debut_17, p0_.date_fin AS date_fin_18, p0_.created_at AS created_at_19, p0_.image_label AS image_label_20, p0_.product_group_id AS product_group_id_21, p0_.unit_detail_base_price_id AS unit_detail_base_price_id_22, p0_.unit_detail_id AS unit_detail_id_23 FROM product p0_ WHERE p0_.is_active = 1 ORDER BY p0_.ordre ASC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordre AS ordre_3,
  t0.image AS image_4,
  t0.seo_titre AS seo_titre_5,
  t0.seo_description AS seo_description_6,
  t0.slug AS slug_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9
FROM
  category t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordre AS ordre_3, t0.image AS image_4, t0.seo_titre AS seo_titre_5, t0.seo_description AS seo_description_6, t0.slug AS slug_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9 FROM category t0 WHERE t0.is_active = 1 ORDER BY t0.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordre AS ordre_3,
  t0.image AS image_4,
  t0.seo_titre AS seo_titre_5,
  t0.seo_description AS seo_description_6,
  t0.slug AS slug_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9
FROM
  category t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordre AS ordre_3, t0.image AS image_4, t0.seo_titre AS seo_titre_5, t0.seo_description AS seo_description_6, t0.slug AS slug_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9 FROM category t0 WHERE t0.is_active = 1 ORDER BY t0.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordre AS ordre_3,
  t0.seo_titre AS seo_titre_4,
  t0.seo_description AS seo_description_5,
  t0.image AS image_6,
  t0.slug AS slug_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9
FROM
  sub_category t0
  INNER JOIN sub_category_category ON t0.id = sub_category_category.sub_category_id
WHERE
  sub_category_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordre AS ordre_3, t0.seo_titre AS seo_titre_4, t0.seo_description AS seo_description_5, t0.image AS image_6, t0.slug AS slug_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9 FROM sub_category t0 INNER JOIN sub_category_category ON t0.id = sub_category_category.sub_category_id WHERE sub_category_category.category_id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordre AS ordre_3,
  t0.seo_titre AS seo_titre_4,
  t0.seo_description AS seo_description_5,
  t0.image AS image_6,
  t0.slug AS slug_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9
FROM
  sub_category t0
  INNER JOIN sub_category_category ON t0.id = sub_category_category.sub_category_id
WHERE
  sub_category_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordre AS ordre_3, t0.seo_titre AS seo_titre_4, t0.seo_description AS seo_description_5, t0.image AS image_6, t0.slug AS slug_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9 FROM sub_category t0 INNER JOIN sub_category_category ON t0.id = sub_category_category.sub_category_id WHERE sub_category_category.category_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordre AS ordre_3,
  t0.seo_titre AS seo_titre_4,
  t0.seo_description AS seo_description_5,
  t0.image AS image_6,
  t0.slug AS slug_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9
FROM
  sub_category t0
  INNER JOIN sub_category_category ON t0.id = sub_category_category.sub_category_id
WHERE
  sub_category_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordre AS ordre_3, t0.seo_titre AS seo_titre_4, t0.seo_description AS seo_description_5, t0.image AS image_6, t0.slug AS slug_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9 FROM sub_category t0 INNER JOIN sub_category_category ON t0.id = sub_category_category.sub_category_id WHERE sub_category_category.category_id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordre AS ordre_3,
  t0.image AS image_4,
  t0.seo_titre AS seo_titre_5,
  t0.seo_description AS seo_description_6,
  t0.slug AS slug_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9
FROM
  category t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordre AS ordre_3, t0.image AS image_4, t0.seo_titre AS seo_titre_5, t0.seo_description AS seo_description_6, t0.slug AS slug_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9 FROM category t0 WHERE t0.is_active = 1 ORDER BY t0.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.position AS position_4,
  t0.created_at AS created_at_5,
  t0.is_price_unit AS is_price_unit_6
FROM
  unite t0
WHERE
  t0.id = ?