Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.nom AS nom_2,
  c0_.type AS type_3,
  c0_.actif AS actif_4,
  c0_.sync_auto AS sync_auto_5,
  c0_.ordre AS ordre_6,
  c0_.base_url AS base_url_7,
  c0_.api_key AS api_key_8,
  c0_.language_id AS language_id_9,
  c0_.shop_id AS shop_id_10,
  c0_.root_category_id AS root_category_id_11,
  c0_.tax_rules_group_id AS tax_rules_group_id_12,
  c0_.zone_id AS zone_id_13
FROM
  canal c0_
  INNER JOIN zone z1_ ON c0_.zone_id = z1_.id
WHERE
  c0_.type = ?
  AND z1_.code = ?
  AND c0_.actif = true
LIMIT
  1

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.nom AS nom_2, c0_.type AS type_3, c0_.actif AS actif_4, c0_.sync_auto AS sync_auto_5, c0_.ordre AS ordre_6, c0_.base_url AS base_url_7, c0_.api_key AS api_key_8, c0_.language_id AS language_id_9, c0_.shop_id AS shop_id_10, c0_.root_category_id AS root_category_id_11, c0_.tax_rules_group_id AS tax_rules_group_id_12, c0_.zone_id AS zone_id_13 FROM canal c0_ INNER JOIN zone z1_ ON c0_.zone_id = z1_.id WHERE c0_.type = 'PARTENAIRES' AND z1_.code = 'METROPOLE' AND c0_.actif = true LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.slug AS slug_2,
  p0_.reference AS reference_3,
  p0_.ean13 AS ean13_4,
  p0_.resume AS resume_5,
  p0_.description AS description_6,
  p0_.poids AS poids_7,
  p0_.stock AS stock_8,
  p0_.actif AS actif_9,
  p0_.afficher_prix AS afficher_prix_10,
  p0_.exclu_synchro AS exclu_synchro_11,
  p0_.cse AS cse_12,
  p0_.en_avant AS en_avant_13,
  p0_.libelle_declinaison AS libelle_declinaison_14,
  p0_.created_at AS created_at_15,
  p0_.updated_at AS updated_at_16,
  p1_.id AS id_17,
  p1_.visible AS visible_18,
  p1_.prix AS prix_19,
  p1_.external_id AS external_id_20,
  p1_.external_combination_id AS external_combination_id_21,
  p1_.external_tax_rules_group_id AS external_tax_rules_group_id_22,
  p1_.sync_statut AS sync_statut_23,
  p1_.sync_erreur AS sync_erreur_24,
  p1_.sync_at AS sync_at_25,
  p1_.sync_hash AS sync_hash_26,
  p2_.id AS id_27,
  p2_.fichier AS fichier_28,
  p2_.taille AS taille_29,
  p2_.mime_type AS mime_type_30,
  p2_.nom_original AS nom_original_31,
  p2_.legende AS legende_32,
  p2_.position AS position_33,
  p2_.verrouillee AS verrouillee_34,
  p2_.hash AS hash_35,
  p2_.external_ids AS external_ids_36,
  p2_.updated_at AS updated_at_37,
  m3_.id AS id_38,
  m3_.nom AS nom_39,
  m3_.actif AS actif_40,
  m3_.external_ids AS external_ids_41,
  c4_.id AS id_42,
  c4_.nom AS nom_43,
  c4_.slug AS slug_44,
  c4_.description AS description_45,
  c4_.actif AS actif_46,
  c4_.accueil AS accueil_47,
  c4_.ordre AS ordre_48,
  c4_.external_ids AS external_ids_49,
  p5_.id AS id_50,
  p5_.nom AS nom_51,
  p5_.slug AS slug_52,
  p5_.reference AS reference_53,
  p5_.ean13 AS ean13_54,
  p5_.resume AS resume_55,
  p5_.description AS description_56,
  p5_.poids AS poids_57,
  p5_.stock AS stock_58,
  p5_.actif AS actif_59,
  p5_.afficher_prix AS afficher_prix_60,
  p5_.exclu_synchro AS exclu_synchro_61,
  p5_.cse AS cse_62,
  p5_.en_avant AS en_avant_63,
  p5_.libelle_declinaison AS libelle_declinaison_64,
  p5_.created_at AS created_at_65,
  p5_.updated_at AS updated_at_66,
  p0_.marque_id AS marque_id_67,
  p0_.parent_id AS parent_id_68,
  p0_.categorie_principale_id AS categorie_principale_id_69,
  p1_.produit_id AS produit_id_70,
  p1_.canal_id AS canal_id_71,
  p2_.produit_id AS produit_id_72,
  c4_.parent_id AS parent_id_73,
  p5_.marque_id AS marque_id_74,
  p5_.parent_id AS parent_id_75,
  p5_.categorie_principale_id AS categorie_principale_id_76
FROM
  produit p0_
  INNER JOIN produit_canal p1_ ON p0_.id = p1_.produit_id
  AND (
    p1_.canal_id = ?
    AND p1_.visible = true
    AND p1_.prix IS NOT NULL
  )
  LEFT JOIN produit_image p2_ ON p0_.id = p2_.produit_id
  LEFT JOIN marque m3_ ON p0_.marque_id = m3_.id
  LEFT JOIN produit_categorie p6_ ON p0_.id = p6_.produit_id
  LEFT JOIN categorie c4_ ON c4_.id = p6_.categorie_id
  LEFT JOIN produit p5_ ON p0_.id = p5_.parent_id
WHERE
  p0_.actif = true
  AND p0_.slug = ?
ORDER BY
  p0_.nom ASC,
  p2_.position ASC,
  p5_.libelle_declinaison ASC

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.slug AS slug_2, p0_.reference AS reference_3, p0_.ean13 AS ean13_4, p0_.resume AS resume_5, p0_.description AS description_6, p0_.poids AS poids_7, p0_.stock AS stock_8, p0_.actif AS actif_9, p0_.afficher_prix AS afficher_prix_10, p0_.exclu_synchro AS exclu_synchro_11, p0_.cse AS cse_12, p0_.en_avant AS en_avant_13, p0_.libelle_declinaison AS libelle_declinaison_14, p0_.created_at AS created_at_15, p0_.updated_at AS updated_at_16, p1_.id AS id_17, p1_.visible AS visible_18, p1_.prix AS prix_19, p1_.external_id AS external_id_20, p1_.external_combination_id AS external_combination_id_21, p1_.external_tax_rules_group_id AS external_tax_rules_group_id_22, p1_.sync_statut AS sync_statut_23, p1_.sync_erreur AS sync_erreur_24, p1_.sync_at AS sync_at_25, p1_.sync_hash AS sync_hash_26, p2_.id AS id_27, p2_.fichier AS fichier_28, p2_.taille AS taille_29, p2_.mime_type AS mime_type_30, p2_.nom_original AS nom_original_31, p2_.legende AS legende_32, p2_.position AS position_33, p2_.verrouillee AS verrouillee_34, p2_.hash AS hash_35, p2_.external_ids AS external_ids_36, p2_.updated_at AS updated_at_37, m3_.id AS id_38, m3_.nom AS nom_39, m3_.actif AS actif_40, m3_.external_ids AS external_ids_41, c4_.id AS id_42, c4_.nom AS nom_43, c4_.slug AS slug_44, c4_.description AS description_45, c4_.actif AS actif_46, c4_.accueil AS accueil_47, c4_.ordre AS ordre_48, c4_.external_ids AS external_ids_49, p5_.id AS id_50, p5_.nom AS nom_51, p5_.slug AS slug_52, p5_.reference AS reference_53, p5_.ean13 AS ean13_54, p5_.resume AS resume_55, p5_.description AS description_56, p5_.poids AS poids_57, p5_.stock AS stock_58, p5_.actif AS actif_59, p5_.afficher_prix AS afficher_prix_60, p5_.exclu_synchro AS exclu_synchro_61, p5_.cse AS cse_62, p5_.en_avant AS en_avant_63, p5_.libelle_declinaison AS libelle_declinaison_64, p5_.created_at AS created_at_65, p5_.updated_at AS updated_at_66, p0_.marque_id AS marque_id_67, p0_.parent_id AS parent_id_68, p0_.categorie_principale_id AS categorie_principale_id_69, p1_.produit_id AS produit_id_70, p1_.canal_id AS canal_id_71, p2_.produit_id AS produit_id_72, c4_.parent_id AS parent_id_73, p5_.marque_id AS marque_id_74, p5_.parent_id AS parent_id_75, p5_.categorie_principale_id AS categorie_principale_id_76 FROM produit p0_ INNER JOIN produit_canal p1_ ON p0_.id = p1_.produit_id AND (p1_.canal_id = 1 AND p1_.visible = true AND p1_.prix IS NOT NULL) LEFT JOIN produit_image p2_ ON p0_.id = p2_.produit_id LEFT JOIN marque m3_ ON p0_.marque_id = m3_.id LEFT JOIN produit_categorie p6_ ON p0_.id = p6_.produit_id LEFT JOIN categorie c4_ ON c4_.id = p6_.categorie_id LEFT JOIN produit p5_ ON p0_.id = p5_.parent_id WHERE p0_.actif = true AND p0_.slug = '4-epices-nature-gourmandise' ORDER BY p0_.nom ASC, p2_.position ASC, p5_.libelle_declinaison ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.type AS type_4,
  t0.actif AS actif_5,
  t0.sync_auto AS sync_auto_6,
  t0.ordre AS ordre_7,
  t0.base_url AS base_url_8,
  t0.api_key AS api_key_9,
  t0.language_id AS language_id_10,
  t0.shop_id AS shop_id_11,
  t0.root_category_id AS root_category_id_12,
  t0.tax_rules_group_id AS tax_rules_group_id_13,
  t0.zone_id AS zone_id_14
FROM
  canal t0
WHERE
  t0.type = ?
  AND t0.actif = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.type AS type_4, t0.actif AS actif_5, t0.sync_auto AS sync_auto_6, t0.ordre AS ordre_7, t0.base_url AS base_url_8, t0.api_key AS api_key_9, t0.language_id AS language_id_10, t0.shop_id AS shop_id_11, t0.root_category_id AS root_category_id_12, t0.tax_rules_group_id AS tax_rules_group_id_13, t0.zone_id AS zone_id_14 FROM canal t0 WHERE t0.type = 'PARTENAIRES' AND t0.actif = 1 ORDER BY t0.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.actif AS actif_4,
  t0.taxe_id AS taxe_id_5
FROM
  zone t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.actif AS actif_4, t0.taxe_id AS taxe_id_5 FROM zone t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.actif AS actif_4,
  t0.taxe_id AS taxe_id_5
FROM
  zone t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.actif AS actif_4, t0.taxe_id AS taxe_id_5 FROM zone t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.taux AS taux_3
FROM
  taxe t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.taux AS taux_3 FROM taxe t0 WHERE t0.id = 1;