Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.rang AS rang_4,
  t0.boutiquemobile AS boutiquemobile_5,
  t0.src AS src_6,
  t0.alt AS alt_7
FROM
  typeprojet t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.rang AS rang_4, t0.boutiquemobile AS boutiquemobile_5, t0.src AS src_6, t0.alt AS alt_7 FROM typeprojet t0 WHERE t0.id = 0;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.valeur AS valeur_3,
  t0.link AS link_4,
  t0.description AS description_5,
  t0.date AS date_6,
  t0.rang AS rang_7,
  t0.src AS src_8,
  t0.alt AS alt_9,
  t0.user_id AS user_id_10
FROM
  parametreadmin t0
WHERE
  t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = 'templatewebsite' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.siteweb AS siteweb_2,
  p0_.citoyen AS citoyen_3,
  p0_.citoyenne AS citoyenne_4,
  p0_.code AS code_5,
  p0_.domaine AS domaine_6,
  p0_.src AS src_7,
  p0_.alt AS alt_8,
  p0_.drapeau_id AS drapeau_id_9,
  p0_.continent_id AS continent_id_10
FROM
  pays p0_
ORDER BY
  p0_.nom ASC

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.siteweb AS siteweb_2, p0_.citoyen AS citoyen_3, p0_.citoyenne AS citoyenne_4, p0_.code AS code_5, p0_.domaine AS domaine_6, p0_.src AS src_7, p0_.alt AS alt_8, p0_.drapeau_id AS drapeau_id_9, p0_.continent_id AS continent_id_10 FROM pays p0_ ORDER BY p0_.nom ASC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.nom AS nom_1,
          p0_.slogan AS slogan_2,
          p0_.date AS date_3,
          p0_.nbvisit AS nbvisit_4,
          p0_.siteweb AS siteweb_5,
          p0_.email AS email_6,
          p0_.tel AS tel_7,
          p0_.telpublic AS telpublic_8,
          p0_.villetext AS villetext_9,
          p0_.boutiquemobile AS boutiquemobile_10,
          p0_.twitter AS twitter_11,
          p0_.google AS google_12,
          p0_.linkedin AS linkedin_13,
          p0_.facebook AS facebook_14,
          p0_.clicklink AS clicklink_15,
          p0_.nbpoint AS nbpoint_16,
          p0_.tcode AS tcode_17,
          p0_.valide AS valide_18,
          p0_.inscriptionacheve AS inscriptionacheve_19,
          p0_.pageprojet AS pageprojet_20,
          p0_.montantrecu AS montantrecu_21,
          p0_.binplace AS binplace_22,
          p0_.nblike AS nblike_23,
          p0_.nbabonne AS nbabonne_24,
          p0_.nbconsultation AS nbconsultation_25,
          p0_.note AS note_26,
          p0_.nbdon AS nbdon_27,
          p0_.nbproduit AS nbproduit_28,
          p0_.profilupload AS profilupload_29,
          i1_.id AS id_30,
          i1_.src AS src_31,
          i1_.alt AS alt_32,
          p2_.id AS id_33,
          p2_.nom AS nom_34,
          p2_.siteweb AS siteweb_35,
          p2_.citoyen AS citoyen_36,
          p2_.citoyenne AS citoyenne_37,
          p2_.code AS code_38,
          p2_.domaine AS domaine_39,
          p2_.src AS src_40,
          p2_.alt AS alt_41,
          v3_.id AS id_42,
          v3_.nom AS nom_43,
          v3_.date AS date_44,
          v3_.nbpoint AS nbpoint_45,
          v3_.src AS src_46,
          v3_.alt AS alt_47,
          t4_.id AS id_48,
          t4_.nom AS nom_49,
          t4_.description AS description_50,
          t4_.rang AS rang_51,
          t4_.boutiquemobile AS boutiquemobile_52,
          t4_.src AS src_53,
          t4_.alt AS alt_54
        FROM
          projet p0_
          LEFT JOIN imgprofilprojet i1_ ON p0_.id = i1_.projet_id
          LEFT JOIN pays p2_ ON p0_.pays_id = p2_.id
          LEFT JOIN ville v3_ ON p0_.ville_id = v3_.id
          LEFT JOIN typeprojet t4_ ON p0_.typeprojet_id = t4_.id
        WHERE
          p0_.valide = 1
        ORDER BY
          p0_.nbpoint DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.slogan AS slogan_2, p0_.date AS date_3, p0_.nbvisit AS nbvisit_4, p0_.siteweb AS siteweb_5, p0_.email AS email_6, p0_.tel AS tel_7, p0_.telpublic AS telpublic_8, p0_.villetext AS villetext_9, p0_.boutiquemobile AS boutiquemobile_10, p0_.twitter AS twitter_11, p0_.google AS google_12, p0_.linkedin AS linkedin_13, p0_.facebook AS facebook_14, p0_.clicklink AS clicklink_15, p0_.nbpoint AS nbpoint_16, p0_.tcode AS tcode_17, p0_.valide AS valide_18, p0_.inscriptionacheve AS inscriptionacheve_19, p0_.pageprojet AS pageprojet_20, p0_.montantrecu AS montantrecu_21, p0_.binplace AS binplace_22, p0_.nblike AS nblike_23, p0_.nbabonne AS nbabonne_24, p0_.nbconsultation AS nbconsultation_25, p0_.note AS note_26, p0_.nbdon AS nbdon_27, p0_.nbproduit AS nbproduit_28, p0_.profilupload AS profilupload_29, i1_.id AS id_30, i1_.src AS src_31, i1_.alt AS alt_32, p2_.id AS id_33, p2_.nom AS nom_34, p2_.siteweb AS siteweb_35, p2_.citoyen AS citoyen_36, p2_.citoyenne AS citoyenne_37, p2_.code AS code_38, p2_.domaine AS domaine_39, p2_.src AS src_40, p2_.alt AS alt_41, v3_.id AS id_42, v3_.nom AS nom_43, v3_.date AS date_44, v3_.nbpoint AS nbpoint_45, v3_.src AS src_46, v3_.alt AS alt_47, t4_.id AS id_48, t4_.nom AS nom_49, t4_.description AS description_50, t4_.rang AS rang_51, t4_.boutiquemobile AS boutiquemobile_52, t4_.src AS src_53, t4_.alt AS alt_54 FROM projet p0_ LEFT JOIN imgprofilprojet i1_ ON p0_.id = i1_.projet_id LEFT JOIN pays p2_ ON p0_.pays_id = p2_.id LEFT JOIN ville v3_ ON p0_.ville_id = v3_.id LEFT JOIN typeprojet t4_ ON p0_.typeprojet_id = t4_.id WHERE p0_.valide = 1 ORDER BY p0_.nbpoint DESC) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.salt AS salt_4,
  t0.roles AS roles_5,
  t0.nom AS nom_6,
  t0.poste AS poste_7,
  t0.villetext AS villetext_8,
  t0.statut AS statut_9,
  t0.prenom AS prenom_10,
  t0.tel AS tel_11,
  t0.tcode AS tcode_12,
  t0.email AS email_13,
  t0.datenaiss AS datenaiss_14,
  t0.publieridentite AS publieridentite_15,
  t0.complet AS complet_16,
  t0.typeaccount AS typeaccount_17,
  t0.adresse AS adresse_18,
  t0.sexe AS sexe_19,
  t0.nbprojetvue AS nbprojetvue_20,
  t0.nbabonne AS nbabonne_21,
  t0.nbpubconsulter AS nbpubconsulter_22,
  t0.nbabonnement AS nbabonnement_23,
  t0.nbabonnementprojet AS nbabonnementprojet_24,
  t0.nbvisiteur AS nbvisiteur_25,
  t0.projetconnecter AS projetconnecter_26,
  t0.nbprojet AS nbprojet_27,
  t0.dernierevisite AS dernierevisite_28,
  t0.heurearrive AS heurearrive_29,
  t0.datebeg AS datebeg_30,
  t0.dateinscription AS dateinscription_31,
  t0.cni AS cni_32,
  t0.puui AS puui_33,
  t0.publication AS publication_34,
  t35.id AS id_36,
  t35.src AS src_37,
  t35.alt AS alt_38,
  t35.user_id AS user_id_39,
  t40.id AS id_41,
  t40.src AS src_42,
  t40.alt AS alt_43,
  t40.user_id AS user_id_44,
  t0.pays_id AS pays_id_45
FROM
  user t0
  LEFT JOIN imgprofil t35 ON t35.user_id = t0.id
  LEFT JOIN imgcouverture t40 ON t40.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.salt AS salt_4, t0.roles AS roles_5, t0.nom AS nom_6, t0.poste AS poste_7, t0.villetext AS villetext_8, t0.statut AS statut_9, t0.prenom AS prenom_10, t0.tel AS tel_11, t0.tcode AS tcode_12, t0.email AS email_13, t0.datenaiss AS datenaiss_14, t0.publieridentite AS publieridentite_15, t0.complet AS complet_16, t0.typeaccount AS typeaccount_17, t0.adresse AS adresse_18, t0.sexe AS sexe_19, t0.nbprojetvue AS nbprojetvue_20, t0.nbabonne AS nbabonne_21, t0.nbpubconsulter AS nbpubconsulter_22, t0.nbabonnement AS nbabonnement_23, t0.nbabonnementprojet AS nbabonnementprojet_24, t0.nbvisiteur AS nbvisiteur_25, t0.projetconnecter AS projetconnecter_26, t0.nbprojet AS nbprojet_27, t0.dernierevisite AS dernierevisite_28, t0.heurearrive AS heurearrive_29, t0.datebeg AS datebeg_30, t0.dateinscription AS dateinscription_31, t0.cni AS cni_32, t0.puui AS puui_33, t0.publication AS publication_34, t35.id AS id_36, t35.src AS src_37, t35.alt AS alt_38, t35.user_id AS user_id_39, t40.id AS id_41, t40.src AS src_42, t40.alt AS alt_43, t40.user_id AS user_id_44, t0.pays_id AS pays_id_45 FROM user t0 LEFT JOIN imgprofil t35 ON t35.user_id = t0.id LEFT JOIN imgcouverture t40 ON t40.user_id = t0.id WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.date AS date_3,
  t0.nbpoint AS nbpoint_4,
  t0.src AS src_5,
  t0.alt AS alt_6,
  t0.pays_id AS pays_id_7,
  t0.user_id AS user_id_8
FROM
  ville t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.date AS date_3, t0.nbpoint AS nbpoint_4, t0.src AS src_5, t0.alt AS alt_6, t0.pays_id AS pays_id_7, t0.user_id AS user_id_8 FROM ville t0 WHERE t0.id = 0;

SELECT
  t0_.id AS id_0,
  t0_.nom AS nom_1,
  t0_.description AS description_2,
  t0_.rang AS rang_3,
  t0_.boutiquemobile AS boutiquemobile_4,
  t0_.src AS src_5,
  t0_.alt AS alt_6
FROM
  typeprojet t0_
WHERE
  t0_.boutiquemobile = 0
ORDER BY
  t0_.rang ASC

SELECT t0_.id AS id_0, t0_.nom AS nom_1, t0_.description AS description_2, t0_.rang AS rang_3, t0_.boutiquemobile AS boutiquemobile_4, t0_.src AS src_5, t0_.alt AS alt_6 FROM typeprojet t0_ WHERE t0_.boutiquemobile = 0 ORDER BY t0_.rang ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.siteweb AS siteweb_3,
  t0.citoyen AS citoyen_4,
  t0.citoyenne AS citoyenne_5,
  t0.code AS code_6,
  t0.domaine AS domaine_7,
  t0.src AS src_8,
  t0.alt AS alt_9,
  t0.drapeau_id AS drapeau_id_10,
  t0.continent_id AS continent_id_11
FROM
  pays t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.siteweb AS siteweb_3, t0.citoyen AS citoyen_4, t0.citoyenne AS citoyenne_5, t0.code AS code_6, t0.domaine AS domaine_7, t0.src AS src_8, t0.alt AS alt_9, t0.drapeau_id AS drapeau_id_10, t0.continent_id AS continent_id_11 FROM pays t0 WHERE t0.id = 0;