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.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.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
  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
  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
  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
  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.frais_livraison AS frais_livraison_3
FROM
  gouvernorat t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.frais_livraison AS frais_livraison_3 FROM gouvernorat t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.gouvernorat_id AS gouvernorat_id_3
FROM
  citie t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.gouvernorat_id AS gouvernorat_id_3 FROM citie t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.zip_code AS zip_code_3,
  t0.citie_id AS citie_id_4,
  t0.gouvernorat_id AS gouvernorat_id_5
FROM
  town t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.zip_code AS zip_code_3, t0.citie_id AS citie_id_4, t0.gouvernorat_id AS gouvernorat_id_5 FROM town t0 WHERE t0.id = 105;