Symfony Profiler

SELECT
  DISTINCT (p0_.id) AS sclr_0,
  p0_.nom_produit AS nom_produit_1,
  p1_.info_prix AS info_prix_2,
  p2_.code_genere AS code_genere_3,
  p0_.montanthtAchat AS montanthtAchat_4,
  c3_.id AS id_5,
  p0_.code_genere AS code_genere_6,
  p0_.code_barre AS code_barre_7,
  c3_.type_categorie AS type_categorie_8,
  p0_.si_agricole AS si_agricole_9,
  p0_.si_agricole_parent AS si_agricole_parent_10,
  p0_.en_stock_produit AS en_stock_produit_11,
  p0_.si_semence AS si_semence_12,
  i4_.url_image AS url_image_13,
  d5_.libelle AS libelle_14
FROM
  produit p0_
  INNER JOIN categorieproduit c3_ ON p0_.categorie_id = c3_.id
  INNER JOIN abonne a6_ ON p0_.abonne_id = a6_.id
  INNER JOIN devise d5_ ON a6_.devise_id = d5_.id
  INNER JOIN prix_rigueur p1_ ON p0_.id = p1_.produit_id
  INNER JOIN produit p2_ ON p0_.produit_id = p2_.id
  INNER JOIN image i4_ ON p0_.id = i4_.produit_id
WHERE
  1 = 1
  AND p1_.etat_prix = 1
  AND p0_.etat_produit = 1
  AND p0_.siEcommerce = 1
  AND a6_.id = ?
  AND c3_.id = ?

SELECT DISTINCT (p0_.id) AS sclr_0, p0_.nom_produit AS nom_produit_1, p1_.info_prix AS info_prix_2, p2_.code_genere AS code_genere_3, p0_.montanthtAchat AS montanthtAchat_4, c3_.id AS id_5, p0_.code_genere AS code_genere_6, p0_.code_barre AS code_barre_7, c3_.type_categorie AS type_categorie_8, p0_.si_agricole AS si_agricole_9, p0_.si_agricole_parent AS si_agricole_parent_10, p0_.en_stock_produit AS en_stock_produit_11, p0_.si_semence AS si_semence_12, i4_.url_image AS url_image_13, d5_.libelle AS libelle_14 FROM produit p0_ INNER JOIN categorieproduit c3_ ON p0_.categorie_id = c3_.id INNER JOIN abonne a6_ ON p0_.abonne_id = a6_.id INNER JOIN devise d5_ ON a6_.devise_id = d5_.id INNER JOIN prix_rigueur p1_ ON p0_.id = p1_.produit_id INNER JOIN produit p2_ ON p0_.produit_id = p2_.id INNER JOIN image i4_ ON p0_.id = i4_.produit_id WHERE 1 = 1 AND p1_.etat_prix = 1 AND p0_.etat_produit = 1 AND p0_.siEcommerce = 1 AND a6_.id = 22 AND c3_.id = 3;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code_base_abonne AS code_base_abonne_3,
  t0.email_abonne AS email_abonne_4,
  t0.tel1_abonne AS tel1_abonne_5,
  t0.tel2_abonne AS tel2_abonne_6,
  t0.adresse_abonne AS adresse_abonne_7,
  t0.description_abonne AS description_abonne_8,
  t0.etat_abonne AS etat_abonne_9,
  t0.siExploitation AS siExploitation_10,
  t0.si_principale AS si_principale_11,
  t0.type_action_abonne AS type_action_abonne_12,
  t0.adresse_web AS adresse_web_13,
  t0.date_ajout_abonne AS date_ajout_abonne_14,
  t0.date_edit_abonne AS date_edit_abonne_15,
  t0.titre_image AS titre_image_16,
  t0.url_image AS url_image_17,
  t0.type_presentation AS type_presentation_18,
  t0.langue AS langue_19,
  t0.configuration AS configuration_20,
  t0.type_abonne_id AS type_abonne_id_21,
  t0.template_id AS template_id_22,
  t0.partenaire_id AS partenaire_id_23,
  t0.devise_id AS devise_id_24,
  t0.pays_id AS pays_id_25
FROM
  abonne t0
WHERE
  t0.adresse_web = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_base_abonne AS code_base_abonne_3, t0.email_abonne AS email_abonne_4, t0.tel1_abonne AS tel1_abonne_5, t0.tel2_abonne AS tel2_abonne_6, t0.adresse_abonne AS adresse_abonne_7, t0.description_abonne AS description_abonne_8, t0.etat_abonne AS etat_abonne_9, t0.siExploitation AS siExploitation_10, t0.si_principale AS si_principale_11, t0.type_action_abonne AS type_action_abonne_12, t0.adresse_web AS adresse_web_13, t0.date_ajout_abonne AS date_ajout_abonne_14, t0.date_edit_abonne AS date_edit_abonne_15, t0.titre_image AS titre_image_16, t0.url_image AS url_image_17, t0.type_presentation AS type_presentation_18, t0.langue AS langue_19, t0.configuration AS configuration_20, t0.type_abonne_id AS type_abonne_id_21, t0.template_id AS template_id_22, t0.partenaire_id AS partenaire_id_23, t0.devise_id AS devise_id_24, t0.pays_id AS pays_id_25 FROM abonne t0 WHERE t0.adresse_web = 'uropcm.coo.tg' LIMIT 1;

SELECT
  DISTINCT (p0_.id) AS sclr_0,
  p0_.nom_produit AS nom_produit_1,
  p1_.info_prix AS info_prix_2,
  p2_.code_genere AS code_genere_3,
  p0_.montanthtAchat AS montanthtAchat_4,
  c3_.id AS id_5,
  p0_.code_genere AS code_genere_6,
  p0_.code_barre AS code_barre_7,
  c3_.type_categorie AS type_categorie_8,
  p0_.si_agricole AS si_agricole_9,
  p0_.si_agricole_parent AS si_agricole_parent_10,
  p0_.en_stock_produit AS en_stock_produit_11,
  p0_.si_semence AS si_semence_12,
  i4_.url_image AS url_image_13,
  d5_.libelle AS libelle_14
FROM
  produit p0_
  INNER JOIN categorieproduit c3_ ON p0_.categorie_id = c3_.id
  INNER JOIN abonne a6_ ON p0_.abonne_id = a6_.id
  INNER JOIN devise d5_ ON a6_.devise_id = d5_.id
  INNER JOIN prix_rigueur p1_ ON p0_.id = p1_.produit_id
  INNER JOIN produit p2_ ON p0_.produit_id = p2_.id
  INNER JOIN image i4_ ON p0_.id = i4_.produit_id
WHERE
  1 = 1
  AND p1_.etat_prix = 1
  AND p0_.siEcommerce = 1
  AND a6_.id = ?

SELECT DISTINCT (p0_.id) AS sclr_0, p0_.nom_produit AS nom_produit_1, p1_.info_prix AS info_prix_2, p2_.code_genere AS code_genere_3, p0_.montanthtAchat AS montanthtAchat_4, c3_.id AS id_5, p0_.code_genere AS code_genere_6, p0_.code_barre AS code_barre_7, c3_.type_categorie AS type_categorie_8, p0_.si_agricole AS si_agricole_9, p0_.si_agricole_parent AS si_agricole_parent_10, p0_.en_stock_produit AS en_stock_produit_11, p0_.si_semence AS si_semence_12, i4_.url_image AS url_image_13, d5_.libelle AS libelle_14 FROM produit p0_ INNER JOIN categorieproduit c3_ ON p0_.categorie_id = c3_.id INNER JOIN abonne a6_ ON p0_.abonne_id = a6_.id INNER JOIN devise d5_ ON a6_.devise_id = d5_.id INNER JOIN prix_rigueur p1_ ON p0_.id = p1_.produit_id INNER JOIN produit p2_ ON p0_.produit_id = p2_.id INNER JOIN image i4_ ON p0_.id = i4_.produit_id WHERE 1 = 1 AND p1_.etat_prix = 1 AND p0_.siEcommerce = 1 AND a6_.id = 22;

SELECT
  p0_.id AS id_0,
  p0_.nom_produit AS nom_produit_1,
  0 AS sclr_2,
  p0_.montanthtAchat AS montanthtAchat_3,
  c1_.id AS id_4,
  p0_.code_genere AS code_genere_5,
  p0_.code_barre AS code_barre_6,
  c1_.type_categorie AS type_categorie_7,
  p0_.si_agricole AS si_agricole_8,
  p0_.si_agricole_parent AS si_agricole_parent_9,
  p0_.si_semence AS si_semence_10,
  i2_.url_image AS url_image_11
FROM
  produit p0_
  INNER JOIN categorieproduit c1_ ON p0_.categorie_id = c1_.id
  INNER JOIN abonne a3_ ON p0_.abonne_id = a3_.id
  INNER JOIN image i2_ ON p0_.id = i2_.produit_id
WHERE
  1 = 1
  AND p0_.si_agricole_parent = ?
  AND a3_.id = ?

SELECT p0_.id AS id_0, p0_.nom_produit AS nom_produit_1, 0 AS sclr_2, p0_.montanthtAchat AS montanthtAchat_3, c1_.id AS id_4, p0_.code_genere AS code_genere_5, p0_.code_barre AS code_barre_6, c1_.type_categorie AS type_categorie_7, p0_.si_agricole AS si_agricole_8, p0_.si_agricole_parent AS si_agricole_parent_9, p0_.si_semence AS si_semence_10, i2_.url_image AS url_image_11 FROM produit p0_ INNER JOIN categorieproduit c1_ ON p0_.categorie_id = c1_.id INNER JOIN abonne a3_ ON p0_.abonne_id = a3_.id INNER JOIN image i2_ ON p0_.id = i2_.produit_id WHERE 1 = 1 AND p0_.si_agricole_parent = 1 AND a3_.id = 22;

SELECT
  t0.id AS id_1,
  t0.code_produit AS code_produit_2,
  t0.nom_produit AS nom_produit_3,
  t0.description_produit AS description_produit_4,
  t0.poids_produit AS poids_produit_5,
  t0.frais_affecte_produit AS frais_affecte_produit_6,
  t0.marge_salariale_produit AS marge_salariale_produit_7,
  t0.siSysteme AS siSysteme_8,
  t0.siMelange AS siMelange_9,
  t0.seuil_produit AS seuil_produit_10,
  t0.en_stock_produit AS en_stock_produit_11,
  t0.fabricat_produit AS fabricat_produit_12,
  t0.date_publication AS date_publication_13,
  t0.date_commer AS date_commer_14,
  t0.date_modification AS date_modification_15,
  t0.id_auteur AS id_auteur_16,
  t0.etat_produit AS etat_produit_17,
  t0.quantite_detail AS quantite_detail_18,
  t0.etat_libelle AS etat_libelle_19,
  t0.siEcommerce AS siEcommerce_20,
  t0.montanthtAchat AS montanthtAchat_21,
  t0.montanthtvente AS montanthtvente_22,
  t0.tauxTva AS tauxTva_23,
  t0.couleur_produit AS couleur_produit_24,
  t0.montantttcvente AS montantttcvente_25,
  t0.autretaxe AS autretaxe_26,
  t0.si_conditionnement AS si_conditionnement_27,
  t0.si_transformation AS si_transformation_28,
  t0.si_vendable AS si_vendable_29,
  t0.si_semence AS si_semence_30,
  t0.rendement AS rendement_31,
  t0.si_accueil AS si_accueil_32,
  t0.titre_image AS titre_image_33,
  t0.code_genere AS code_genere_34,
  t0.si_agricole AS si_agricole_35,
  t0.si_agricole_parent AS si_agricole_parent_36,
  t0.type_saison AS type_saison_37,
  t0.type_qualite AS type_qualite_38,
  t0.si_affichage AS si_affichage_39,
  t0.url_image AS url_image_40,
  t0.action_comptable AS action_comptable_41,
  t0.code_barre AS code_barre_42,
  t0.melange_id AS melange_id_43,
  t0.categorie_id AS categorie_id_44,
  t0.produit_id AS produit_id_45,
  t0.compte AS compte_46,
  t0.produitsysteme_id AS produitsysteme_id_47,
  t0.carateristiqueproduit_id AS carateristiqueproduit_id_48,
  t0.unite_id AS unite_id_49,
  t0.abonne_id AS abonne_id_50
FROM
  produit t0
WHERE
  t0.abonne_id = ?

SELECT t0.id AS id_1, t0.code_produit AS code_produit_2, t0.nom_produit AS nom_produit_3, t0.description_produit AS description_produit_4, t0.poids_produit AS poids_produit_5, t0.frais_affecte_produit AS frais_affecte_produit_6, t0.marge_salariale_produit AS marge_salariale_produit_7, t0.siSysteme AS siSysteme_8, t0.siMelange AS siMelange_9, t0.seuil_produit AS seuil_produit_10, t0.en_stock_produit AS en_stock_produit_11, t0.fabricat_produit AS fabricat_produit_12, t0.date_publication AS date_publication_13, t0.date_commer AS date_commer_14, t0.date_modification AS date_modification_15, t0.id_auteur AS id_auteur_16, t0.etat_produit AS etat_produit_17, t0.quantite_detail AS quantite_detail_18, t0.etat_libelle AS etat_libelle_19, t0.siEcommerce AS siEcommerce_20, t0.montanthtAchat AS montanthtAchat_21, t0.montanthtvente AS montanthtvente_22, t0.tauxTva AS tauxTva_23, t0.couleur_produit AS couleur_produit_24, t0.montantttcvente AS montantttcvente_25, t0.autretaxe AS autretaxe_26, t0.si_conditionnement AS si_conditionnement_27, t0.si_transformation AS si_transformation_28, t0.si_vendable AS si_vendable_29, t0.si_semence AS si_semence_30, t0.rendement AS rendement_31, t0.si_accueil AS si_accueil_32, t0.titre_image AS titre_image_33, t0.code_genere AS code_genere_34, t0.si_agricole AS si_agricole_35, t0.si_agricole_parent AS si_agricole_parent_36, t0.type_saison AS type_saison_37, t0.type_qualite AS type_qualite_38, t0.si_affichage AS si_affichage_39, t0.url_image AS url_image_40, t0.action_comptable AS action_comptable_41, t0.code_barre AS code_barre_42, t0.melange_id AS melange_id_43, t0.categorie_id AS categorie_id_44, t0.produit_id AS produit_id_45, t0.compte AS compte_46, t0.produitsysteme_id AS produitsysteme_id_47, t0.carateristiqueproduit_id AS carateristiqueproduit_id_48, t0.unite_id AS unite_id_49, t0.abonne_id AS abonne_id_50 FROM produit t0 WHERE t0.abonne_id = 22;

SELECT
  m0_.id AS id_0,
  m0_.titre AS titre_1,
  m0_.datePublication AS datePublication_2,
  m0_.contenuMenu AS contenuMenu_3,
  m0_.type_menu AS type_menu_4,
  m0_.etat_menu AS etat_menu_5,
  m0_.classHtmlMenu AS classHtmlMenu_6,
  m0_.ordre AS ordre_7,
  m0_.abonne_id AS abonne_id_8,
  m0_.menu_id AS menu_id_9
FROM
  menu m0_
  INNER JOIN abonne a1_ ON m0_.abonne_id = a1_.id
WHERE
  m0_.etat_menu = 1
  AND a1_.id = 22
ORDER BY
  m0_.ordre ASC

SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.datePublication AS datePublication_2, m0_.contenuMenu AS contenuMenu_3, m0_.type_menu AS type_menu_4, m0_.etat_menu AS etat_menu_5, m0_.classHtmlMenu AS classHtmlMenu_6, m0_.ordre AS ordre_7, m0_.abonne_id AS abonne_id_8, m0_.menu_id AS menu_id_9 FROM menu m0_ INNER JOIN abonne a1_ ON m0_.abonne_id = a1_.id WHERE m0_.etat_menu = 1 AND a1_.id = 22 ORDER BY m0_.ordre ASC;

SELECT
  DISTINCT (p0_.id) AS sclr_0,
  p0_.nom_produit AS nom_produit_1,
  p1_.info_prix AS info_prix_2,
  c2_.code AS code_3,
  p0_.montanthtAchat AS montanthtAchat_4,
  c2_.id AS id_5,
  p0_.code_genere AS code_genere_6,
  p0_.code_barre AS code_barre_7,
  c2_.type_categorie AS type_categorie_8,
  p0_.si_agricole AS si_agricole_9,
  p0_.si_agricole_parent AS si_agricole_parent_10,
  p0_.en_stock_produit AS en_stock_produit_11,
  p0_.si_semence AS si_semence_12,
  i3_.url_image AS url_image_13,
  d4_.libelle AS libelle_14
FROM
  produit p0_
  INNER JOIN categorieproduit c2_ ON p0_.categorie_id = c2_.id
  INNER JOIN abonne a5_ ON p0_.abonne_id = a5_.id
  INNER JOIN devise d4_ ON a5_.devise_id = d4_.id
  INNER JOIN prix_rigueur p1_ ON p0_.id = p1_.produit_id
  INNER JOIN image i3_ ON p0_.id = i3_.produit_id
WHERE
  1 = 1
  AND p1_.etat_prix = 1
  AND p0_.etat_produit = 1
  AND p0_.siEcommerce = 1
  AND c2_.id <> 3
  AND a5_.id = ?

SELECT DISTINCT (p0_.id) AS sclr_0, p0_.nom_produit AS nom_produit_1, p1_.info_prix AS info_prix_2, c2_.code AS code_3, p0_.montanthtAchat AS montanthtAchat_4, c2_.id AS id_5, p0_.code_genere AS code_genere_6, p0_.code_barre AS code_barre_7, c2_.type_categorie AS type_categorie_8, p0_.si_agricole AS si_agricole_9, p0_.si_agricole_parent AS si_agricole_parent_10, p0_.en_stock_produit AS en_stock_produit_11, p0_.si_semence AS si_semence_12, i3_.url_image AS url_image_13, d4_.libelle AS libelle_14 FROM produit p0_ INNER JOIN categorieproduit c2_ ON p0_.categorie_id = c2_.id INNER JOIN abonne a5_ ON p0_.abonne_id = a5_.id INNER JOIN devise d4_ ON a5_.devise_id = d4_.id INNER JOIN prix_rigueur p1_ ON p0_.id = p1_.produit_id INNER JOIN image i3_ ON p0_.id = i3_.produit_id WHERE 1 = 1 AND p1_.etat_prix = 1 AND p0_.etat_produit = 1 AND p0_.siEcommerce = 1 AND c2_.id <> 3 AND a5_.id = 22;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.etat AS etat_3,
  t0.abonne_id AS abonne_id_4
FROM
  caracteristique_prix t0
WHERE
  t0.abonne_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.etat AS etat_3, t0.abonne_id AS abonne_id_4 FROM caracteristique_prix t0 WHERE t0.abonne_id = 22;

SELECT
  p0_.id AS id_0,
  p0_.nom_produit AS nom_produit_1,
  0 AS sclr_2,
  p0_.code_genere AS code_genere_3
FROM
  produit p0_
  INNER JOIN categorieproduit c1_ ON p0_.categorie_id = c1_.id
  INNER JOIN abonne a2_ ON p0_.abonne_id = a2_.id
  INNER JOIN image i3_ ON p0_.id = i3_.produit_id
  INNER JOIN produit p4_ ON p0_.id = p4_.produit_id
WHERE
  1 = 1
  AND p4_.siEcommerce = 1
  AND p0_.si_agricole_parent = ?
  AND a2_.id = ?

SELECT p0_.id AS id_0, p0_.nom_produit AS nom_produit_1, 0 AS sclr_2, p0_.code_genere AS code_genere_3 FROM produit p0_ INNER JOIN categorieproduit c1_ ON p0_.categorie_id = c1_.id INNER JOIN abonne a2_ ON p0_.abonne_id = a2_.id INNER JOIN image i3_ ON p0_.id = i3_.produit_id INNER JOIN produit p4_ ON p0_.id = p4_.produit_id WHERE 1 = 1 AND p4_.siEcommerce = 1 AND p0_.si_agricole_parent = 1 AND a2_.id = 22;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.etat AS etat_3,
  t0.abonne_id AS abonne_id_4
FROM
  cible t0
WHERE
  t0.abonne_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.etat AS etat_3, t0.abonne_id AS abonne_id_4 FROM cible t0 WHERE t0.abonne_id = 22;

SELECT
  p0_.id AS id_0,
  p0_.nom_produit AS nom_produit_1,
  0 AS sclr_2
FROM
  produit p0_
  INNER JOIN categorieproduit c1_ ON p0_.categorie_id = c1_.id
  INNER JOIN abonne a2_ ON p0_.abonne_id = a2_.id
  INNER JOIN image i3_ ON p0_.id = i3_.produit_id
  INNER JOIN produit p4_ ON p0_.id = p4_.produit_id
WHERE
  1 = 1
  AND p4_.siEcommerce = 1
  AND a2_.id = ?

SELECT p0_.id AS id_0, p0_.nom_produit AS nom_produit_1, 0 AS sclr_2 FROM produit p0_ INNER JOIN categorieproduit c1_ ON p0_.categorie_id = c1_.id INNER JOIN abonne a2_ ON p0_.abonne_id = a2_.id INNER JOIN image i3_ ON p0_.id = i3_.produit_id INNER JOIN produit p4_ ON p0_.id = p4_.produit_id WHERE 1 = 1 AND p4_.siEcommerce = 1 AND a2_.id = 22;

SELECT
  DISTINCT (c0_.id) AS sclr_0,
  c0_.nom AS nom_1,
  0 AS sclr_2,
  c0_.code AS code_3
FROM
  categorieproduit c0_
  INNER JOIN produit p1_ ON c0_.id = p1_.categorie_id
  INNER JOIN abonne a2_ ON p1_.abonne_id = a2_.id
  INNER JOIN image i3_ ON p1_.id = i3_.produit_id
WHERE
  1 = 1
  AND p1_.siEcommerce = 1
  AND a2_.id = ?

SELECT DISTINCT (c0_.id) AS sclr_0, c0_.nom AS nom_1, 0 AS sclr_2, c0_.code AS code_3 FROM categorieproduit c0_ INNER JOIN produit p1_ ON c0_.id = p1_.categorie_id INNER JOIN abonne a2_ ON p1_.abonne_id = a2_.id INNER JOIN image i3_ ON p1_.id = i3_.produit_id WHERE 1 = 1 AND p1_.siEcommerce = 1 AND a2_.id = 22;