Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.titre_url AS titre_url_3,
  t0.titre_select AS titre_select_4,
  t0.titre_page AS titre_page_5,
  t0.mots_cles AS mots_cles_6,
  t0.description AS description_7,
  t0.texte_court AS texte_court_8,
  t0.texte AS texte_9,
  t0.langue AS langue_10,
  t0.ordre AS ordre_11,
  t0.type AS type_12,
  t0.deroulant AS deroulant_13,
  t0.lien_page AS lien_page_14,
  t0.page AS page_15,
  t0.filtre AS filtre_16,
  t0.actif AS actif_17,
  t0.cle AS cle_18,
  t0.parent_page_id AS parent_page_id_19,
  t0.ecole_id AS ecole_id_20
FROM
  www_contenu t0
WHERE
  t0.cle = ?
  AND t0.langue = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.url AS url_2, t0.titre_url AS titre_url_3, t0.titre_select AS titre_select_4, t0.titre_page AS titre_page_5, t0.mots_cles AS mots_cles_6, t0.description AS description_7, t0.texte_court AS texte_court_8, t0.texte AS texte_9, t0.langue AS langue_10, t0.ordre AS ordre_11, t0.type AS type_12, t0.deroulant AS deroulant_13, t0.lien_page AS lien_page_14, t0.page AS page_15, t0.filtre AS filtre_16, t0.actif AS actif_17, t0.cle AS cle_18, t0.parent_page_id AS parent_page_id_19, t0.ecole_id AS ecole_id_20 FROM www_contenu t0 WHERE t0.cle = 'home' AND t0.langue = 'fr' LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.titre_url AS titre_url_1,
  a0_.titre AS titre_2,
  a0_.texte_court AS texte_court_3,
  a0_.texte AS texte_4,
  a0_.mots_cles AS mots_cles_5,
  a0_.auteur AS auteur_6,
  a0_.auteur_lien AS auteur_lien_7,
  a0_.date AS date_8,
  a0_.date_debut AS date_debut_9,
  a0_.date_fin AS date_fin_10,
  a0_.ordre AS ordre_11,
  a0_.actif AS actif_12,
  a0_.lectures AS lectures_13,
  a0_.langue AS langue_14,
  a0_.une AS une_15,
  a0_.photo AS photo_16,
  a0_.actualites_associees AS actualites_associees_17,
  a0_.id_cat1 AS id_cat1_18,
  a0_.id_cat2 AS id_cat2_19,
  a0_.ecole_id AS ecole_id_20
FROM
  actualites a0_
WHERE
  a0_.actif = '1'
  AND a0_.id_cat1 = '1'
  AND a0_.langue = 'fr'
ORDER BY
  a0_.date DESC
LIMIT
  4

SELECT a0_.id AS id_0, a0_.titre_url AS titre_url_1, a0_.titre AS titre_2, a0_.texte_court AS texte_court_3, a0_.texte AS texte_4, a0_.mots_cles AS mots_cles_5, a0_.auteur AS auteur_6, a0_.auteur_lien AS auteur_lien_7, a0_.date AS date_8, a0_.date_debut AS date_debut_9, a0_.date_fin AS date_fin_10, a0_.ordre AS ordre_11, a0_.actif AS actif_12, a0_.lectures AS lectures_13, a0_.langue AS langue_14, a0_.une AS une_15, a0_.photo AS photo_16, a0_.actualites_associees AS actualites_associees_17, a0_.id_cat1 AS id_cat1_18, a0_.id_cat2 AS id_cat2_19, a0_.ecole_id AS ecole_id_20 FROM actualites a0_ WHERE a0_.actif = '1' AND a0_.id_cat1 = '1' AND a0_.langue = 'fr' ORDER BY a0_.date DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.fichier AS fichier_3,
  t0.ordre AS ordre_4,
  t0.note AS note_5,
  t0.id_fournisseur AS id_fournisseur_6
FROM
  fournisseurs_medias t0
WHERE
  t0.id_fournisseur = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.fichier AS fichier_3, t0.ordre AS ordre_4, t0.note AS note_5, t0.id_fournisseur AS id_fournisseur_6 FROM fournisseurs_medias t0 WHERE t0.id_fournisseur = 1;

SELECT
  DISTINCT e0_.id AS id_0,
  e0_.date_debut AS date_debut_1,
  e0_.date_fin AS date_fin_2,
  e0_.id_actualite AS id_actualite_3,
  e0_.titre AS titre_4,
  e0_.texte AS texte_5,
  e0_.image AS image_6,
  e0_.lien AS lien_7,
  e0_.ordre AS ordre_8,
  e0_.actif AS actif_9,
  e0_.langue AS langue_10,
  e0_.ecole_id AS ecole_id_11
FROM
  encarts e0_
WHERE
  e0_.actif = '1'
  AND e0_.ecole_id IS NULL
ORDER BY
  e0_.ordre ASC
LIMIT
  4

SELECT DISTINCT e0_.id AS id_0, e0_.date_debut AS date_debut_1, e0_.date_fin AS date_fin_2, e0_.id_actualite AS id_actualite_3, e0_.titre AS titre_4, e0_.texte AS texte_5, e0_.image AS image_6, e0_.lien AS lien_7, e0_.ordre AS ordre_8, e0_.actif AS actif_9, e0_.langue AS langue_10, e0_.ecole_id AS ecole_id_11 FROM encarts e0_ WHERE e0_.actif = '1' AND e0_.ecole_id IS NULL ORDER BY e0_.ordre ASC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.societe AS societe_2,
  t0.nom_url AS nom_url_3,
  t0.tva_intracomm AS tva_intracomm_4,
  t0.siret AS siret_5,
  t0.num_compta AS num_compta_6,
  t0.nom AS nom_7,
  t0.prenom AS prenom_8,
  t0.civilite AS civilite_9,
  t0.fonction AS fonction_10,
  t0.adresse AS adresse_11,
  t0.adresse2 AS adresse2_12,
  t0.code_postal AS code_postal_13,
  t0.ville AS ville_14,
  t0.pays AS pays_15,
  t0.telephone AS telephone_16,
  t0.mobile AS mobile_17,
  t0.fax AS fax_18,
  t0.email AS email_19,
  t0.pass AS pass_20,
  t0.newsletter AS newsletter_21,
  t0.groupe_newsletter AS groupe_newsletter_22,
  t0.date AS date_23,
  t0.connecte AS connecte_24,
  t0.hors_taxes AS hors_taxes_25,
  t0.site_web AS site_web_26,
  t0.actif AS actif_27,
  t0.note AS note_28,
  t0.cle AS cle_29,
  t0.paiement AS paiement_30,
  t0.old_id AS old_id_31
FROM
  fournisseurs t0
WHERE
  t0.actif = ?

SELECT t0.id AS id_1, t0.societe AS societe_2, t0.nom_url AS nom_url_3, t0.tva_intracomm AS tva_intracomm_4, t0.siret AS siret_5, t0.num_compta AS num_compta_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.civilite AS civilite_9, t0.fonction AS fonction_10, t0.adresse AS adresse_11, t0.adresse2 AS adresse2_12, t0.code_postal AS code_postal_13, t0.ville AS ville_14, t0.pays AS pays_15, t0.telephone AS telephone_16, t0.mobile AS mobile_17, t0.fax AS fax_18, t0.email AS email_19, t0.pass AS pass_20, t0.newsletter AS newsletter_21, t0.groupe_newsletter AS groupe_newsletter_22, t0.date AS date_23, t0.connecte AS connecte_24, t0.hors_taxes AS hors_taxes_25, t0.site_web AS site_web_26, t0.actif AS actif_27, t0.note AS note_28, t0.cle AS cle_29, t0.paiement AS paiement_30, t0.old_id AS old_id_31 FROM fournisseurs t0 WHERE t0.actif = 1;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.titre_url AS titre_url_3,
  t0.titre_select AS titre_select_4,
  t0.titre_page AS titre_page_5,
  t0.mots_cles AS mots_cles_6,
  t0.description AS description_7,
  t0.texte_court AS texte_court_8,
  t0.texte AS texte_9,
  t0.langue AS langue_10,
  t0.ordre AS ordre_11,
  t0.type AS type_12,
  t0.deroulant AS deroulant_13,
  t0.lien_page AS lien_page_14,
  t0.page AS page_15,
  t0.filtre AS filtre_16,
  t0.actif AS actif_17,
  t0.cle AS cle_18,
  t0.parent_page_id AS parent_page_id_19,
  t0.ecole_id AS ecole_id_20
FROM
  www_contenu t0
WHERE
  t0.filtre = ?
  AND t0.ecole_id IS NULL
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.url AS url_2, t0.titre_url AS titre_url_3, t0.titre_select AS titre_select_4, t0.titre_page AS titre_page_5, t0.mots_cles AS mots_cles_6, t0.description AS description_7, t0.texte_court AS texte_court_8, t0.texte AS texte_9, t0.langue AS langue_10, t0.ordre AS ordre_11, t0.type AS type_12, t0.deroulant AS deroulant_13, t0.lien_page AS lien_page_14, t0.page AS page_15, t0.filtre AS filtre_16, t0.actif AS actif_17, t0.cle AS cle_18, t0.parent_page_id AS parent_page_id_19, t0.ecole_id AS ecole_id_20 FROM www_contenu t0 WHERE t0.filtre = 'menu' AND t0.ecole_id IS NULL ORDER BY t0.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.nom_url AS nom_url_3,
  t0.nom_de AS nom_de_4,
  t0.nom_de_url AS nom_de_url_5,
  t0.texte AS texte_6,
  t0.texte_de AS texte_de_7,
  t0.photo AS photo_8,
  t0.ordre AS ordre_9,
  t0.actif AS actif_10,
  t0.latitude AS latitude_11,
  t0.longitude AS longitude_12,
  t0.couleur AS couleur_13,
  t0.adresse AS adresse_14,
  t0.code_postal AS code_postal_15,
  t0.ville AS ville_16,
  t0.pays AS pays_17,
  t0.email AS email_18,
  t0.tel1 AS tel1_19,
  t0.tel2 AS tel2_20,
  t0.facebook AS facebook_21,
  t0.asso_nom AS asso_nom_22,
  t0.asso_adresse AS asso_adresse_23,
  t0.asso_code_postal AS asso_code_postal_24,
  t0.asso_ville AS asso_ville_25,
  t0.asso_email AS asso_email_26,
  t0.asso_tel1 AS asso_tel1_27,
  t0.asso_tel2 AS asso_tel2_28,
  t0.site_url AS site_url_29,
  t0.site_titre AS site_titre_30,
  t0.texte_asso AS texte_asso_31
FROM
  ecoles t0
WHERE
  t0.actif = ?
ORDER BY
  t0.ordre ASC,
  t0.nom ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_url AS nom_url_3, t0.nom_de AS nom_de_4, t0.nom_de_url AS nom_de_url_5, t0.texte AS texte_6, t0.texte_de AS texte_de_7, t0.photo AS photo_8, t0.ordre AS ordre_9, t0.actif AS actif_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.couleur AS couleur_13, t0.adresse AS adresse_14, t0.code_postal AS code_postal_15, t0.ville AS ville_16, t0.pays AS pays_17, t0.email AS email_18, t0.tel1 AS tel1_19, t0.tel2 AS tel2_20, t0.facebook AS facebook_21, t0.asso_nom AS asso_nom_22, t0.asso_adresse AS asso_adresse_23, t0.asso_code_postal AS asso_code_postal_24, t0.asso_ville AS asso_ville_25, t0.asso_email AS asso_email_26, t0.asso_tel1 AS asso_tel1_27, t0.asso_tel2 AS asso_tel2_28, t0.site_url AS site_url_29, t0.site_titre AS site_titre_30, t0.texte_asso AS texte_asso_31 FROM ecoles t0 WHERE t0.actif = 1 ORDER BY t0.ordre ASC, t0.nom ASC;

SELECT
  a0_.id AS id_0,
  a0_.titre_url AS titre_url_1,
  a0_.titre AS titre_2,
  a0_.texte_court AS texte_court_3,
  a0_.texte AS texte_4,
  a0_.mots_cles AS mots_cles_5,
  a0_.auteur AS auteur_6,
  a0_.auteur_lien AS auteur_lien_7,
  a0_.date AS date_8,
  a0_.date_debut AS date_debut_9,
  a0_.date_fin AS date_fin_10,
  a0_.ordre AS ordre_11,
  a0_.actif AS actif_12,
  a0_.lectures AS lectures_13,
  a0_.langue AS langue_14,
  a0_.une AS une_15,
  a0_.photo AS photo_16,
  a0_.actualites_associees AS actualites_associees_17,
  a0_.id_cat1 AS id_cat1_18,
  a0_.id_cat2 AS id_cat2_19,
  a0_.ecole_id AS ecole_id_20
FROM
  actualites a0_
  INNER JOIN ecoles e1_ ON a0_.ecole_id = e1_.id
WHERE
  a0_.actif = '1'
  AND a0_.id_cat1 = '1'
  AND e1_.ville LIKE ?
  AND a0_.langue = 'fr'
ORDER BY
  a0_.date DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.titre_url AS titre_url_1, a0_.titre AS titre_2, a0_.texte_court AS texte_court_3, a0_.texte AS texte_4, a0_.mots_cles AS mots_cles_5, a0_.auteur AS auteur_6, a0_.auteur_lien AS auteur_lien_7, a0_.date AS date_8, a0_.date_debut AS date_debut_9, a0_.date_fin AS date_fin_10, a0_.ordre AS ordre_11, a0_.actif AS actif_12, a0_.lectures AS lectures_13, a0_.langue AS langue_14, a0_.une AS une_15, a0_.photo AS photo_16, a0_.actualites_associees AS actualites_associees_17, a0_.id_cat1 AS id_cat1_18, a0_.id_cat2 AS id_cat2_19, a0_.ecole_id AS ecole_id_20 FROM actualites a0_ INNER JOIN ecoles e1_ ON a0_.ecole_id = e1_.id WHERE a0_.actif = '1' AND a0_.id_cat1 = '1' AND e1_.ville LIKE NULL AND a0_.langue = 'fr' ORDER BY a0_.date DESC LIMIT 1;