Symfony Profiler

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
  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 = ?
  AND t0.id = ?
LIMIT
  1

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 AND t0.id = '2401' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.nom_produit AS nom_produit_1,
  p1_.info_prix AS info_prix_2,
  p0_.code_genere AS code_genere_3,
  p0_.montanthtAchat AS montanthtAchat_4,
  p0_.description_produit AS description_produit_5,
  c2_.id AS id_6,
  p0_.code_genere AS code_genere_7,
  p0_.code_barre AS code_barre_8,
  c2_.type_categorie AS type_categorie_9,
  p0_.si_agricole AS si_agricole_10,
  p0_.si_agricole_parent AS si_agricole_parent_11,
  p0_.en_stock_produit AS en_stock_produit_12,
  p0_.si_semence AS si_semence_13,
  i3_.url_image AS url_image_14,
  d4_.libelle AS libelle_15
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_.siEcommerce = 1
  AND a5_.id = ?
  AND p0_.code_genere = ?

SELECT p0_.id AS id_0, p0_.nom_produit AS nom_produit_1, p1_.info_prix AS info_prix_2, p0_.code_genere AS code_genere_3, p0_.montanthtAchat AS montanthtAchat_4, p0_.description_produit AS description_produit_5, c2_.id AS id_6, p0_.code_genere AS code_genere_7, p0_.code_barre AS code_barre_8, c2_.type_categorie AS type_categorie_9, p0_.si_agricole AS si_agricole_10, p0_.si_agricole_parent AS si_agricole_parent_11, p0_.en_stock_produit AS en_stock_produit_12, p0_.si_semence AS si_semence_13, i3_.url_image AS url_image_14, d4_.libelle AS libelle_15 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_.siEcommerce = 1 AND a5_.id = 22 AND p0_.code_genere = 'PR1011301252';

SELECT
  p0_.id AS id_0,
  p1_.id AS id_1,
  p0_.nom_produit AS nom_produit_2,
  p1_.nom_produit AS nom_produit_3
FROM
  produit p0_
  INNER JOIN carateristique_produit c2_ ON p0_.id = c2_.produit_id
  INNER JOIN produit p1_ ON c2_.produitparent_id = p1_.id
  INNER JOIN abonne a3_ ON p0_.abonne_id = a3_.id
  INNER JOIN categorieproduit c4_ ON p1_.categorie_id = c4_.id
WHERE
  1 = 1
  AND p0_.etat_produit <> 2
  AND p0_.id = ?
  AND a3_.id = ?
ORDER BY
  p0_.nom_produit ASC

SELECT p0_.id AS id_0, p1_.id AS id_1, p0_.nom_produit AS nom_produit_2, p1_.nom_produit AS nom_produit_3 FROM produit p0_ INNER JOIN carateristique_produit c2_ ON p0_.id = c2_.produit_id INNER JOIN produit p1_ ON c2_.produitparent_id = p1_.id INNER JOIN abonne a3_ ON p0_.abonne_id = a3_.id INNER JOIN categorieproduit c4_ ON p1_.categorie_id = c4_.id WHERE 1 = 1 AND p0_.etat_produit <> 2 AND p0_.id = 2401 AND a3_.id = 22 ORDER BY p0_.nom_produit 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 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
  t0.id AS id_1,
  t0.titre_image AS titre_image_2,
  t0.titre_template AS titre_template_3,
  t0.nom_dossier_template AS nom_dossier_template_4,
  t0.description_template AS description_template_5,
  t0.etat_template AS etat_template_6,
  t0.date_ajout_template AS date_ajout_template_7,
  t0.abonne_id AS abonne_id_8
FROM
  template t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre_image AS titre_image_2, t0.titre_template AS titre_template_3, t0.nom_dossier_template AS nom_dossier_template_4, t0.description_template AS description_template_5, t0.etat_template AS etat_template_6, t0.date_ajout_template AS date_ajout_template_7, t0.abonne_id AS abonne_id_8 FROM template t0 WHERE t0.id = 2;

SELECT
  DISTINCT c0_.id AS id_0,
  p1_.id AS id_1,
  p1_.info_prix AS info_prix_2,
  c0_.libelle AS libelle_3,
  p2_.id AS id_4
FROM
  prix_rigueur p1_
  LEFT JOIN caracteristique_prix c0_ ON p1_.caracteristique_prix_id = c0_.id
  INNER JOIN produit p2_ ON p1_.produit_id = p2_.id
  INNER JOIN abonne a3_ ON p1_.abonne_id = a3_.id
WHERE
  a3_.id = ?
  AND p1_.etat_prix <> ?
  AND p2_.id = ?

SELECT DISTINCT c0_.id AS id_0, p1_.id AS id_1, p1_.info_prix AS info_prix_2, c0_.libelle AS libelle_3, p2_.id AS id_4 FROM prix_rigueur p1_ LEFT JOIN caracteristique_prix c0_ ON p1_.caracteristique_prix_id = c0_.id INNER JOIN produit p2_ ON p1_.produit_id = p2_.id INNER JOIN abonne a3_ ON p1_.abonne_id = a3_.id WHERE a3_.id = 22 AND p1_.etat_prix <> 2 AND p2_.id = 2401;