Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.code_a_barre AS code_a_barre_4,
  t0.ordre AS ordre_5,
  t0.prix_achat AS prix_achat_6,
  t0.marge_vente AS marge_vente_7,
  t0.prix_vente AS prix_vente_8,
  t0.marge_remise AS marge_remise_9,
  t0.prix_promotion AS prix_promotion_10,
  t0.remise_gros AS remise_gros_11,
  t0.prix_gros AS prix_gros_12,
  t0.stock AS stock_13,
  t0.is_active AS is_active_14,
  t0.is_pack AS is_pack_15,
  t0.image AS image_16,
  t0.image_publicitaire AS image_publicitaire_17,
  t0.date_debut AS date_debut_18,
  t0.date_fin AS date_fin_19,
  t0.created_at AS created_at_20,
  t0.image_label AS image_label_21,
  t0.product_group_id AS product_group_id_22,
  t0.unit_detail_base_price_id AS unit_detail_base_price_id_23,
  t0.unit_detail_id AS unit_detail_id_24
FROM
  product t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.code_a_barre AS code_a_barre_4, t0.ordre AS ordre_5, t0.prix_achat AS prix_achat_6, t0.marge_vente AS marge_vente_7, t0.prix_vente AS prix_vente_8, t0.marge_remise AS marge_remise_9, t0.prix_promotion AS prix_promotion_10, t0.remise_gros AS remise_gros_11, t0.prix_gros AS prix_gros_12, t0.stock AS stock_13, t0.is_active AS is_active_14, t0.is_pack AS is_pack_15, t0.image AS image_16, t0.image_publicitaire AS image_publicitaire_17, t0.date_debut AS date_debut_18, t0.date_fin AS date_fin_19, t0.created_at AS created_at_20, t0.image_label AS image_label_21, t0.product_group_id AS product_group_id_22, t0.unit_detail_base_price_id AS unit_detail_base_price_id_23, t0.unit_detail_id AS unit_detail_id_24 FROM product t0 WHERE t0.slug = 'abe-pre-workout-cans-12-canette-s-abe-pre-workout-2' 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 = ?
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 = 'pack-fitness-diet' LIMIT 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
WHERE
  t0.slug = ?
LIMIT
  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 WHERE t0.slug = 'booster-force-energie' 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_
WHERE
  p0_.product_group_id = ?
ORDER BY
  p0_.id 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_ WHERE p0_.product_group_id = 177 ORDER BY p0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.is_active AS is_active_4,
  t0.seo_titre AS seo_titre_5,
  t0.seo_description AS seo_description_6,
  t0.created_at AS created_at_7,
  t0.brand_id AS brand_id_8,
  t0.unit_price_id AS unit_price_id_9
FROM
  product_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.seo_titre AS seo_titre_5, t0.seo_description AS seo_description_6, t0.created_at AS created_at_7, t0.brand_id AS brand_id_8, t0.unit_price_id AS unit_price_id_9 FROM product_group t0 WHERE t0.id = 177;

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 product_group_category ON t0.id = product_group_category.category_id
WHERE
  product_group_category.product_group_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 product_group_category ON t0.id = product_group_category.category_id WHERE product_group_category.product_group_id = 177;

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 product_group_sub_category ON t0.id = product_group_sub_category.sub_category_id
WHERE
  product_group_sub_category.product_group_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 product_group_sub_category ON t0.id = product_group_sub_category.sub_category_id WHERE product_group_sub_category.product_group_id = 177;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordre AS ordre_3,
  t0.slug AS slug_4,
  t0.image AS image_5,
  t0.seo_titre AS seo_titre_6,
  t0.seo_description AS seo_description_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9
FROM
  brand t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordre AS ordre_3, t0.slug AS slug_4, t0.image AS image_5, t0.seo_titre AS seo_titre_6, t0.seo_description AS seo_description_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9 FROM brand t0 WHERE t0.id = 15;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordre AS ordre_3,
  t0.created_at AS created_at_4,
  t0.code_coleur AS code_coleur_5,
  t0.unite_id AS unite_id_6
FROM
  unite_detail t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordre AS ordre_3, t0.created_at AS created_at_4, t0.code_coleur AS code_coleur_5, t0.unite_id AS unite_id_6 FROM unite_detail t0 WHERE t0.id = 144;

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.ordre AS ordre_3,
  t0.created_at AS created_at_4,
  t0.code_coleur AS code_coleur_5,
  t0.unite_id AS unite_id_6
FROM
  unite_detail t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordre AS ordre_3, t0.created_at AS created_at_4, t0.code_coleur AS code_coleur_5, t0.unite_id AS unite_id_6 FROM unite_detail t0 WHERE t0.id = 138;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordre AS ordre_3,
  t0.created_at AS created_at_4,
  t0.code_coleur AS code_coleur_5,
  t0.unite_id AS unite_id_6
FROM
  unite_detail t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordre AS ordre_3, t0.created_at AS created_at_4, t0.code_coleur AS code_coleur_5, t0.unite_id AS unite_id_6 FROM unite_detail t0 WHERE t0.id = 145;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordre AS ordre_3,
  t0.created_at AS created_at_4,
  t0.code_coleur AS code_coleur_5,
  t0.unite_id AS unite_id_6
FROM
  unite_detail t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordre AS ordre_3, t0.created_at AS created_at_4, t0.code_coleur AS code_coleur_5, t0.unite_id AS unite_id_6 FROM unite_detail t0 WHERE t0.id = 151;

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
  t0.id AS id_1,
  t0.facteur_gain AS facteur_gain_2,
  t0.facteur_conversion AS facteur_conversion_3,
  t0.created_at AS created_at_4,
  t0.is_active AS is_active_5,
  t0.seuil_utilisation AS seuil_utilisation_6
FROM
  parametre_fidelite t0
WHERE
  t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.facteur_gain AS facteur_gain_2, t0.facteur_conversion AS facteur_conversion_3, t0.created_at AS created_at_4, t0.is_active AS is_active_5, t0.seuil_utilisation AS seuil_utilisation_6 FROM parametre_fidelite t0 WHERE t0.is_active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.free_shipping_from AS free_shipping_from_2,
  t0.tva_value AS tva_value_3,
  t0.timbre_fiscal AS timbre_fiscal_4,
  t0.card_payement_discount AS card_payement_discount_5
FROM
  setting t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.free_shipping_from AS free_shipping_from_2, t0.tva_value AS tva_value_3, t0.timbre_fiscal AS timbre_fiscal_4, t0.card_payement_discount AS card_payement_discount_5 FROM setting t0 WHERE t0.id = 1;

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
  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.description AS description_3,
  t0.is_active AS is_active_4,
  t0.seo_titre AS seo_titre_5,
  t0.seo_description AS seo_description_6,
  t0.created_at AS created_at_7,
  t0.brand_id AS brand_id_8,
  t0.unit_price_id AS unit_price_id_9
FROM
  product_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.seo_titre AS seo_titre_5, t0.seo_description AS seo_description_6, t0.created_at AS created_at_7, t0.brand_id AS brand_id_8, t0.unit_price_id AS unit_price_id_9 FROM product_group t0 WHERE t0.id = 178;

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 product_group_category ON t0.id = product_group_category.category_id
WHERE
  product_group_category.product_group_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 product_group_category ON t0.id = product_group_category.category_id WHERE product_group_category.product_group_id = 178;