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
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.actif_article AS actif_article_2,
  a0_.titre_image AS titre_image_3,
  a0_.type_article AS type_article_4,
  a0_.datePublication AS datePublication_5,
  a0_.contenuArticle AS contenuArticle_6,
  a0_.resumeArticle AS resumeArticle_7,
  a0_.classHtmlArticle AS classHtmlArticle_8,
  a0_.rubrique_id AS rubrique_id_9,
  a0_.utilisateur_id AS utilisateur_id_10,
  a0_.abonne_id AS abonne_id_11,
  a0_.producteur_id AS producteur_id_12,
  a0_.groupement_id AS groupement_id_13
FROM
  article a0_
  INNER JOIN rubrique r1_ ON a0_.rubrique_id = r1_.id
WHERE
  a0_.actif_article = ?
  AND r1_.actifRubrique = ?
  AND r1_.id = ?

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.actif_article AS actif_article_2, a0_.titre_image AS titre_image_3, a0_.type_article AS type_article_4, a0_.datePublication AS datePublication_5, a0_.contenuArticle AS contenuArticle_6, a0_.resumeArticle AS resumeArticle_7, a0_.classHtmlArticle AS classHtmlArticle_8, a0_.rubrique_id AS rubrique_id_9, a0_.utilisateur_id AS utilisateur_id_10, a0_.abonne_id AS abonne_id_11, a0_.producteur_id AS producteur_id_12, a0_.groupement_id AS groupement_id_13 FROM article a0_ INNER JOIN rubrique r1_ ON a0_.rubrique_id = r1_.id WHERE a0_.actif_article = 1 AND r1_.actifRubrique = 1 AND r1_.id = 32;

SELECT
  r0_.id AS id_0,
  r0_.designationRubrique AS designationRubrique_1,
  r0_.dateCreationRubrique AS dateCreationRubrique_2,
  r0_.actifRubrique AS actifRubrique_3,
  r0_.typeRubrique AS typeRubrique_4,
  r0_.classHtmlRubrique AS classHtmlRubrique_5,
  r0_.iconeRubrique AS iconeRubrique_6,
  r0_.descriptionRubrique AS descriptionRubrique_7,
  r0_.code_genere_parent AS code_genere_parent_8,
  r0_.utilisateur_id AS utilisateur_id_9,
  r0_.rubrique_id AS rubrique_id_10,
  r0_.abonne_id AS abonne_id_11,
  r0_.produit_id AS produit_id_12,
  r0_.produitetapecroissance_id AS produitetapecroissance_id_13
FROM
  rubrique r0_
WHERE
  r0_.actifRubrique <> 2
  AND r0_.id = ?

SELECT r0_.id AS id_0, r0_.designationRubrique AS designationRubrique_1, r0_.dateCreationRubrique AS dateCreationRubrique_2, r0_.actifRubrique AS actifRubrique_3, r0_.typeRubrique AS typeRubrique_4, r0_.classHtmlRubrique AS classHtmlRubrique_5, r0_.iconeRubrique AS iconeRubrique_6, r0_.descriptionRubrique AS descriptionRubrique_7, r0_.code_genere_parent AS code_genere_parent_8, r0_.utilisateur_id AS utilisateur_id_9, r0_.rubrique_id AS rubrique_id_10, r0_.abonne_id AS abonne_id_11, r0_.produit_id AS produit_id_12, r0_.produitetapecroissance_id AS produitetapecroissance_id_13 FROM rubrique r0_ WHERE r0_.actifRubrique <> 2 AND r0_.id = 32;

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.titre_image AS titre_image_2,
  t0.titre_page AS titre_page_3,
  t0.twig_page AS twig_page_4,
  t0.description_page AS description_page_5,
  t0.etat_page AS etat_page_6,
  t0.type_page AS type_page_7,
  t0.si_page_accueil AS si_page_accueil_8,
  t0.date_ajout_page AS date_ajout_page_9,
  t0.template_id AS template_id_10,
  t0.abonne_id AS abonne_id_11,
  t0.groupement_id AS groupement_id_12
FROM
  page t0
WHERE
  t0.template_id = ?
  AND t0.abonne_id = ?
  AND t0.si_page_accueil = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.titre_image AS titre_image_2, t0.titre_page AS titre_page_3, t0.twig_page AS twig_page_4, t0.description_page AS description_page_5, t0.etat_page AS etat_page_6, t0.type_page AS type_page_7, t0.si_page_accueil AS si_page_accueil_8, t0.date_ajout_page AS date_ajout_page_9, t0.template_id AS template_id_10, t0.abonne_id AS abonne_id_11, t0.groupement_id AS groupement_id_12 FROM page t0 WHERE t0.template_id = 2 AND t0.abonne_id = 22 AND t0.si_page_accueil = 1 LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.actif_article AS actif_article_2,
  a0_.titre_image AS titre_image_3,
  a0_.type_article AS type_article_4,
  a0_.datePublication AS datePublication_5,
  a0_.contenuArticle AS contenuArticle_6,
  a0_.resumeArticle AS resumeArticle_7,
  a0_.classHtmlArticle AS classHtmlArticle_8,
  a0_.rubrique_id AS rubrique_id_9,
  a0_.utilisateur_id AS utilisateur_id_10,
  a0_.abonne_id AS abonne_id_11,
  a0_.producteur_id AS producteur_id_12,
  a0_.groupement_id AS groupement_id_13
FROM
  article a0_
WHERE
  a0_.actif_article <> 2
  AND a0_.id = ?

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.actif_article AS actif_article_2, a0_.titre_image AS titre_image_3, a0_.type_article AS type_article_4, a0_.datePublication AS datePublication_5, a0_.contenuArticle AS contenuArticle_6, a0_.resumeArticle AS resumeArticle_7, a0_.classHtmlArticle AS classHtmlArticle_8, a0_.rubrique_id AS rubrique_id_9, a0_.utilisateur_id AS utilisateur_id_10, a0_.abonne_id AS abonne_id_11, a0_.producteur_id AS producteur_id_12, a0_.groupement_id AS groupement_id_13 FROM article a0_ WHERE a0_.actif_article <> 2 AND a0_.id = 49;

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 z0_.id AS id_0,
  z0_.titre_zone AS titre_zone_1,
  z0_.type_element AS type_element_2,
  z0_.point_vers AS point_vers_3,
  z0_.etat_zone AS etat_zone_4,
  z0_.type_affichage AS type_affichage_5,
  z0_.style AS style_6,
  z0_.ordre AS ordre_7
FROM
  zone z0_
  INNER JOIN page p1_ ON z0_.page_id = p1_.id
WHERE
  1 = 1
  AND z0_.etat_zone = ?
  AND p1_.id = ?
ORDER BY
  z0_.ordre ASC

SELECT DISTINCT z0_.id AS id_0, z0_.titre_zone AS titre_zone_1, z0_.type_element AS type_element_2, z0_.point_vers AS point_vers_3, z0_.etat_zone AS etat_zone_4, z0_.type_affichage AS type_affichage_5, z0_.style AS style_6, z0_.ordre AS ordre_7 FROM zone z0_ INNER JOIN page p1_ ON z0_.page_id = p1_.id WHERE 1 = 1 AND z0_.etat_zone = 1 AND p1_.id = 16 ORDER BY z0_.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
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.code AS code_2,
  c0_.description AS description_3,
  c0_.etat AS etat_4,
  c0_.type_categorie AS type_categorie_5,
  c0_.si_affichage AS si_affichage_6,
  c0_.abonne_id AS abonne_id_7,
  c0_.categorieproduit_id AS categorieproduit_id_8,
  c0_.type_abonne_id AS type_abonne_id_9
FROM
  categorieproduit c0_
  INNER JOIN abonne a1_ ON c0_.abonne_id = a1_.id
WHERE
  (
    c0_.etat <> 2
    AND c0_.id = ?
  )
  OR a1_.id = ?

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.code AS code_2, c0_.description AS description_3, c0_.etat AS etat_4, c0_.type_categorie AS type_categorie_5, c0_.si_affichage AS si_affichage_6, c0_.abonne_id AS abonne_id_7, c0_.categorieproduit_id AS categorieproduit_id_8, c0_.type_abonne_id AS type_abonne_id_9 FROM categorieproduit c0_ INNER JOIN abonne a1_ ON c0_.abonne_id = a1_.id WHERE (c0_.etat <> 2 AND c0_.id = 1) OR a1_.id = 1;

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
  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
  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;

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;