Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.active AS active_3
FROM
  centreinteret t0
  INNER JOIN contact_centreinteret ON t0.id = contact_centreinteret.centreinteret_id
WHERE
  contact_centreinteret.contact_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.active AS active_3 FROM centreinteret t0 INNER JOIN contact_centreinteret ON t0.id = contact_centreinteret.centreinteret_id WHERE contact_centreinteret.contact_id = 37202;

SELECT
  a0_.id AS id_0,
  a0_.dateappel AS dateappel_1,
  a0_.numerotelephone AS numerotelephone_2,
  a0_.sourceouverture AS sourceouverture_3,
  a0_.dureeappel AS dureeappel_4,
  c1_.id AS id_5,
  c1_.message AS message_6,
  c1_.date AS date_7,
  a0_.campagneprospect_id AS campagneprospect_id_8,
  a0_.utilisateur_id AS utilisateur_id_9,
  a0_.appelstatut_id AS appelstatut_id_10,
  a0_.commentaire_id AS commentaire_id_11,
  c1_.prospect_id AS prospect_id_12,
  c1_.importation_id AS importation_id_13,
  c1_.utilisateur_id AS utilisateur_id_14,
  c1_.campagne_id AS campagne_id_15
FROM
  appel a0_
  LEFT JOIN commentaire c1_ ON a0_.commentaire_id = c1_.id
  LEFT JOIN campagneprospect c2_ ON (a0_.campagneprospect_id = c2_.id)
  LEFT JOIN utilisateur u3_ ON (a0_.utilisateur_id = u3_.id)
  LEFT JOIN campagne c4_ ON (c2_.campagne_id = c4_.id)
  LEFT JOIN prospect p5_ ON (c2_.prospect_id = p5_.id)
WHERE
  (
    1 = 1
    AND c2_.prospect_id = 22899
  )
ORDER BY
  a0_.id DESC
LIMIT
  100

SELECT a0_.id AS id_0, a0_.dateappel AS dateappel_1, a0_.numerotelephone AS numerotelephone_2, a0_.sourceouverture AS sourceouverture_3, a0_.dureeappel AS dureeappel_4, c1_.id AS id_5, c1_.message AS message_6, c1_.date AS date_7, a0_.campagneprospect_id AS campagneprospect_id_8, a0_.utilisateur_id AS utilisateur_id_9, a0_.appelstatut_id AS appelstatut_id_10, a0_.commentaire_id AS commentaire_id_11, c1_.prospect_id AS prospect_id_12, c1_.importation_id AS importation_id_13, c1_.utilisateur_id AS utilisateur_id_14, c1_.campagne_id AS campagne_id_15 FROM appel a0_ LEFT JOIN commentaire c1_ ON a0_.commentaire_id = c1_.id LEFT JOIN campagneprospect c2_ ON (a0_.campagneprospect_id = c2_.id) LEFT JOIN utilisateur u3_ ON (a0_.utilisateur_id = u3_.id) LEFT JOIN campagne c4_ ON (c2_.campagne_id = c4_.id) LEFT JOIN prospect p5_ ON (c2_.prospect_id = p5_.id) WHERE (1 = 1 AND c2_.prospect_id = 22899) ORDER BY a0_.id DESC LIMIT 100;

SELECT
  a0_.id AS id_0,
  a0_.dateappel AS dateappel_1,
  a0_.numerotelephone AS numerotelephone_2,
  a0_.sourceouverture AS sourceouverture_3,
  a0_.dureeappel AS dureeappel_4,
  c1_.id AS id_5,
  c1_.message AS message_6,
  c1_.date AS date_7,
  a0_.campagneprospect_id AS campagneprospect_id_8,
  a0_.utilisateur_id AS utilisateur_id_9,
  a0_.appelstatut_id AS appelstatut_id_10,
  a0_.commentaire_id AS commentaire_id_11,
  c1_.prospect_id AS prospect_id_12,
  c1_.importation_id AS importation_id_13,
  c1_.utilisateur_id AS utilisateur_id_14,
  c1_.campagne_id AS campagne_id_15
FROM
  appel a0_
  LEFT JOIN commentaire c1_ ON a0_.commentaire_id = c1_.id
  LEFT JOIN campagneprospect c2_ ON (a0_.campagneprospect_id = c2_.id)
  LEFT JOIN utilisateur u3_ ON (a0_.utilisateur_id = u3_.id)
  LEFT JOIN campagne c4_ ON (c2_.campagne_id = c4_.id)
  LEFT JOIN prospect p5_ ON (c2_.prospect_id = p5_.id)
WHERE
  (
    1 = 1
    AND c2_.prospect_id = 22899
  )

SELECT a0_.id AS id_0, a0_.dateappel AS dateappel_1, a0_.numerotelephone AS numerotelephone_2, a0_.sourceouverture AS sourceouverture_3, a0_.dureeappel AS dureeappel_4, c1_.id AS id_5, c1_.message AS message_6, c1_.date AS date_7, a0_.campagneprospect_id AS campagneprospect_id_8, a0_.utilisateur_id AS utilisateur_id_9, a0_.appelstatut_id AS appelstatut_id_10, a0_.commentaire_id AS commentaire_id_11, c1_.prospect_id AS prospect_id_12, c1_.importation_id AS importation_id_13, c1_.utilisateur_id AS utilisateur_id_14, c1_.campagne_id AS campagne_id_15 FROM appel a0_ LEFT JOIN commentaire c1_ ON a0_.commentaire_id = c1_.id LEFT JOIN campagneprospect c2_ ON (a0_.campagneprospect_id = c2_.id) LEFT JOIN utilisateur u3_ ON (a0_.utilisateur_id = u3_.id) LEFT JOIN campagne c4_ ON (c2_.campagne_id = c4_.id) LEFT JOIN prospect p5_ ON (c2_.prospect_id = p5_.id) WHERE (1 = 1 AND c2_.prospect_id = 22899);

SELECT
  t0.id AS id_1,
  t0.rappelprive AS rappelprive_2,
  t0.daterappel AS daterappel_3,
  t0.historique AS historique_4,
  t0.commentaire AS commentaire_5,
  t0.traitementdate AS traitementdate_6,
  t0.traitementencore AS traitementencore_7,
  t0.campagne_id AS campagne_id_8,
  t0.prospect_id AS prospect_id_9,
  t0.utilisateur_id AS utilisateur_id_10,
  t0.appelstatut_id AS appelstatut_id_11,
  t0.traitementpar_id AS traitementpar_id_12
FROM
  campagneprospect t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.rappelprive AS rappelprive_2, t0.daterappel AS daterappel_3, t0.historique AS historique_4, t0.commentaire AS commentaire_5, t0.traitementdate AS traitementdate_6, t0.traitementencore AS traitementencore_7, t0.campagne_id AS campagne_id_8, t0.prospect_id AS prospect_id_9, t0.utilisateur_id AS utilisateur_id_10, t0.appelstatut_id AS appelstatut_id_11, t0.traitementpar_id AS traitementpar_id_12 FROM campagneprospect t0 WHERE t0.id = 80413;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.active AS active_6,
  t0.session_active AS session_active_7,
  t0.otp_secret AS otp_secret_8,
  t0.otp_enabled AS otp_enabled_9,
  t0.password_changed_at AS password_changed_at_10,
  t0.parametres AS parametres_11,
  t0.erreur AS erreur_12,
  t0.erreurdate AS erreurdate_13,
  t0.groupe_id AS groupe_id_14,
  t0.photo_id AS photo_id_15,
  t0.client_id AS client_id_16
FROM
  utilisateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.password AS password_5, t0.active AS active_6, t0.session_active AS session_active_7, t0.otp_secret AS otp_secret_8, t0.otp_enabled AS otp_enabled_9, t0.password_changed_at AS password_changed_at_10, t0.parametres AS parametres_11, t0.erreur AS erreur_12, t0.erreurdate AS erreurdate_13, t0.groupe_id AS groupe_id_14, t0.photo_id AS photo_id_15, t0.client_id AS client_id_16 FROM utilisateur t0 WHERE t0.id = 68;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3,
  t0.active AS active_4,
  t0.datecreation AS datecreation_5,
  t0.datedebut AS datedebut_6,
  t0.datefin AS datefin_7,
  t0.objectif AS objectif_8,
  t0.objectifagent AS objectifagent_9,
  t0.type AS type_10,
  t0.campagnecible AS campagnecible_11,
  t0.recuperer_tous_historique AS recuperer_tous_historique_12,
  t0.client_id AS client_id_13,
  t0.reponsable_id AS reponsable_id_14,
  t0.clientmanager_id AS clientmanager_id_15
FROM
  campagne t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.active AS active_4, t0.datecreation AS datecreation_5, t0.datedebut AS datedebut_6, t0.datefin AS datefin_7, t0.objectif AS objectif_8, t0.objectifagent AS objectifagent_9, t0.type AS type_10, t0.campagnecible AS campagnecible_11, t0.recuperer_tous_historique AS recuperer_tous_historique_12, t0.client_id AS client_id_13, t0.reponsable_id AS reponsable_id_14, t0.clientmanager_id AS clientmanager_id_15 FROM campagne t0 WHERE t0.id = 170;

SELECT
  t0.id AS id_1,
  t0.societe AS societe_2,
  t0.siren AS siren_3,
  t0.adresse AS adresse_4,
  t0.adressesuite AS adressesuite_5,
  t0.chiffre_affaire AS chiffre_affaire_6,
  t0.active AS active_7,
  t0.standard AS standard_8,
  t0.email AS email_9,
  t0.datecreation AS datecreation_10,
  t0.datemodification AS datemodification_11,
  t0.siteweb AS siteweb_12,
  t0.effectif AS effectif_13,
  t0.siret AS siret_14,
  t0.description AS description_15,
  t0.linkedin AS linkedin_16,
  t0.type_structure AS type_structure_17,
  t0.qualification_structure AS qualification_structure_18,
  t0.motif_qualification AS motif_qualification_19,
  t0.ville_id AS ville_id_20,
  t0.codenaf_id AS codenaf_id_21,
  t22.id AS id_23,
  t22.consultationderniere AS consultationderniere_24,
  t22.consultationprochaine AS consultationprochaine_25,
  t22.prestataire AS prestataire_26,
  t22.sitedecionnaire AS sitedecionnaire_27,
  t22.societedecisionnaire AS societedecisionnaire_28,
  t22.effectif2 AS effectif2_29,
  t22.description AS description_30,
  t22.segmentmarche_id AS segmentmarche_id_31,
  t22.prospect_id AS prospect_id_32,
  t22.politiquerenouvellement_id AS politiquerenouvellement_id_33,
  t34.id AS id_35,
  t34.siren_interroge AS siren_interroge_36,
  t34.nature_juridique AS nature_juridique_37,
  t34.activite_principale AS activite_principale_38,
  t34.est_administration AS est_administration_39,
  t34.convention_collective_renseignee AS convention_collective_renseignee_40,
  t34.liste_idcc AS liste_idcc_41,
  t34.liste_finess_juridique AS liste_finess_juridique_42,
  t34.egapro_renseignee AS egapro_renseignee_43,
  t34.est_achats_responsables AS est_achats_responsables_44,
  t34.est_alim_confiance AS est_alim_confiance_45,
  t34.est_association AS est_association_46,
  t34.est_avocat AS est_avocat_47,
  t34.est_bio AS est_bio_48,
  t34.est_entrepreneur_individuel AS est_entrepreneur_individuel_49,
  t34.est_entrepreneur_spectacle AS est_entrepreneur_spectacle_50,
  t34.est_ess AS est_ess_51,
  t34.est_finess AS est_finess_52,
  t34.est_organisme_formation AS est_organisme_formation_53,
  t34.est_qualiopi AS est_qualiopi_54,
  t34.liste_id_organisme_formation AS liste_id_organisme_formation_55,
  t34.est_rge AS est_rge_56,
  t34.est_siae AS est_siae_57,
  t34.est_societe_mission AS est_societe_mission_58,
  t34.est_uai AS est_uai_59,
  t34.est_patrimoine_vivant AS est_patrimoine_vivant_60,
  t34.bilan_ges_renseigne AS bilan_ges_renseigne_61,
  t34.identifiant_association AS identifiant_association_62,
  t34.statut_entrepreneur_spectacle AS statut_entrepreneur_spectacle_63,
  t34.type_siae AS type_siae_64,
  t34.date_synchronisation AS date_synchronisation_65,
  t34.date_derniere_tentative AS date_derniere_tentative_66,
  t34.prochaine_tentative AS prochaine_tentative_67,
  t34.statut_synchronisation AS statut_synchronisation_68,
  t34.nombre_tentatives AS nombre_tentatives_69,
  t34.code_erreur AS code_erreur_70,
  t34.message_erreur AS message_erreur_71,
  t34.source AS source_72,
  t34.date_mise_ajour_api AS date_mise_ajour_api_73,
  t34.prospect_id AS prospect_id_74
FROM
  prospect t0
  LEFT JOIN prospectdetail t22 ON t22.prospect_id = t0.id
  LEFT JOIN prospectcomplement t34 ON t34.prospect_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.societe AS societe_2, t0.siren AS siren_3, t0.adresse AS adresse_4, t0.adressesuite AS adressesuite_5, t0.chiffre_affaire AS chiffre_affaire_6, t0.active AS active_7, t0.standard AS standard_8, t0.email AS email_9, t0.datecreation AS datecreation_10, t0.datemodification AS datemodification_11, t0.siteweb AS siteweb_12, t0.effectif AS effectif_13, t0.siret AS siret_14, t0.description AS description_15, t0.linkedin AS linkedin_16, t0.type_structure AS type_structure_17, t0.qualification_structure AS qualification_structure_18, t0.motif_qualification AS motif_qualification_19, t0.ville_id AS ville_id_20, t0.codenaf_id AS codenaf_id_21, t22.id AS id_23, t22.consultationderniere AS consultationderniere_24, t22.consultationprochaine AS consultationprochaine_25, t22.prestataire AS prestataire_26, t22.sitedecionnaire AS sitedecionnaire_27, t22.societedecisionnaire AS societedecisionnaire_28, t22.effectif2 AS effectif2_29, t22.description AS description_30, t22.segmentmarche_id AS segmentmarche_id_31, t22.prospect_id AS prospect_id_32, t22.politiquerenouvellement_id AS politiquerenouvellement_id_33, t34.id AS id_35, t34.siren_interroge AS siren_interroge_36, t34.nature_juridique AS nature_juridique_37, t34.activite_principale AS activite_principale_38, t34.est_administration AS est_administration_39, t34.convention_collective_renseignee AS convention_collective_renseignee_40, t34.liste_idcc AS liste_idcc_41, t34.liste_finess_juridique AS liste_finess_juridique_42, t34.egapro_renseignee AS egapro_renseignee_43, t34.est_achats_responsables AS est_achats_responsables_44, t34.est_alim_confiance AS est_alim_confiance_45, t34.est_association AS est_association_46, t34.est_avocat AS est_avocat_47, t34.est_bio AS est_bio_48, t34.est_entrepreneur_individuel AS est_entrepreneur_individuel_49, t34.est_entrepreneur_spectacle AS est_entrepreneur_spectacle_50, t34.est_ess AS est_ess_51, t34.est_finess AS est_finess_52, t34.est_organisme_formation AS est_organisme_formation_53, t34.est_qualiopi AS est_qualiopi_54, t34.liste_id_organisme_formation AS liste_id_organisme_formation_55, t34.est_rge AS est_rge_56, t34.est_siae AS est_siae_57, t34.est_societe_mission AS est_societe_mission_58, t34.est_uai AS est_uai_59, t34.est_patrimoine_vivant AS est_patrimoine_vivant_60, t34.bilan_ges_renseigne AS bilan_ges_renseigne_61, t34.identifiant_association AS identifiant_association_62, t34.statut_entrepreneur_spectacle AS statut_entrepreneur_spectacle_63, t34.type_siae AS type_siae_64, t34.date_synchronisation AS date_synchronisation_65, t34.date_derniere_tentative AS date_derniere_tentative_66, t34.prochaine_tentative AS prochaine_tentative_67, t34.statut_synchronisation AS statut_synchronisation_68, t34.nombre_tentatives AS nombre_tentatives_69, t34.code_erreur AS code_erreur_70, t34.message_erreur AS message_erreur_71, t34.source AS source_72, t34.date_mise_ajour_api AS date_mise_ajour_api_73, t34.prospect_id AS prospect_id_74 FROM prospect t0 LEFT JOIN prospectdetail t22 ON t22.prospect_id = t0.id LEFT JOIN prospectcomplement t34 ON t34.prospect_id = t0.id WHERE t0.id = 22899;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.active AS active_3,
  t0.horscible AS horscible_4,
  t0.nrp AS nrp_5,
  t0.rdv AS rdv_6,
  t0.rappel AS rappel_7,
  t0.couleur AS couleur_8,
  t0.objectif AS objectif_9,
  t0.fichequalifie AS fichequalifie_10,
  t0.fichearequalifie AS fichearequalifie_11,
  t0.ordre_affichage AS ordre_affichage_12
FROM
  appelstatut t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.active AS active_3, t0.horscible AS horscible_4, t0.nrp AS nrp_5, t0.rdv AS rdv_6, t0.rappel AS rappel_7, t0.couleur AS couleur_8, t0.objectif AS objectif_9, t0.fichequalifie AS fichequalifie_10, t0.fichearequalifie AS fichearequalifie_11, t0.ordre_affichage AS ordre_affichage_12 FROM appelstatut t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.permissions AS permissions_3,
  t0.active AS active_4,
  t0.est_globale AS est_globale_5
FROM
  groupe t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.permissions AS permissions_3, t0.active AS active_4, t0.est_globale AS est_globale_5 FROM groupe t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.societe AS societe_2,
  t0.adresse AS adresse_3,
  t0.fixe AS fixe_4,
  t0.mobile AS mobile_5,
  t0.email AS email_6,
  t0.siteweb AS siteweb_7,
  t0.active AS active_8,
  t0.siren AS siren_9,
  t0.ville_id AS ville_id_10,
  t0.manager_id AS manager_id_11
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.societe AS societe_2, t0.adresse AS adresse_3, t0.fixe AS fixe_4, t0.mobile AS mobile_5, t0.email AS email_6, t0.siteweb AS siteweb_7, t0.active AS active_8, t0.siren AS siren_9, t0.ville_id AS ville_id_10, t0.manager_id AS manager_id_11 FROM client t0 WHERE t0.id = 12;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.active AS active_6,
  t0.session_active AS session_active_7,
  t0.otp_secret AS otp_secret_8,
  t0.otp_enabled AS otp_enabled_9,
  t0.password_changed_at AS password_changed_at_10,
  t0.parametres AS parametres_11,
  t0.erreur AS erreur_12,
  t0.erreurdate AS erreurdate_13,
  t0.groupe_id AS groupe_id_14,
  t0.photo_id AS photo_id_15,
  t0.client_id AS client_id_16
FROM
  utilisateur t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.password AS password_5, t0.active AS active_6, t0.session_active AS session_active_7, t0.otp_secret AS otp_secret_8, t0.otp_enabled AS otp_enabled_9, t0.password_changed_at AS password_changed_at_10, t0.parametres AS parametres_11, t0.erreur AS erreur_12, t0.erreurdate AS erreurdate_13, t0.groupe_id AS groupe_id_14, t0.photo_id AS photo_id_15, t0.client_id AS client_id_16 FROM utilisateur t0 WHERE t0.client_id = 12;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.active AS active_6,
  t0.session_active AS session_active_7,
  t0.otp_secret AS otp_secret_8,
  t0.otp_enabled AS otp_enabled_9,
  t0.password_changed_at AS password_changed_at_10,
  t0.parametres AS parametres_11,
  t0.erreur AS erreur_12,
  t0.erreurdate AS erreurdate_13,
  t0.groupe_id AS groupe_id_14,
  t0.photo_id AS photo_id_15,
  t0.client_id AS client_id_16
FROM
  utilisateur t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.password AS password_5, t0.active AS active_6, t0.session_active AS session_active_7, t0.otp_secret AS otp_secret_8, t0.otp_enabled AS otp_enabled_9, t0.password_changed_at AS password_changed_at_10, t0.parametres AS parametres_11, t0.erreur AS erreur_12, t0.erreurdate AS erreurdate_13, t0.groupe_id AS groupe_id_14, t0.photo_id AS photo_id_15, t0.client_id AS client_id_16 FROM utilisateur t0 WHERE t0.email = 'souad.mouzouni@gmail.com' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nbre AS nbre_2,
  t0.description AS description_3,
  t0.type_id AS type_id_4,
  t0.marque_id AS marque_id_5,
  t0.prospect_id AS prospect_id_6
FROM
  appareil t0
WHERE
  t0.prospect_id = ?

SELECT t0.id AS id_1, t0.nbre AS nbre_2, t0.description AS description_3, t0.type_id AS type_id_4, t0.marque_id AS marque_id_5, t0.prospect_id AS prospect_id_6 FROM appareil t0 WHERE t0.prospect_id = 22899;

SELECT
  t0.id AS id_1,
  t0.civilite AS civilite_2,
  t0.nom AS nom_3,
  t0.prenom AS prenom_4,
  t0.fonction AS fonction_5,
  t0.email AS email_6,
  t0.fixe AS fixe_7,
  t0.mobile AS mobile_8,
  t0.active AS active_9,
  t0.datecreation AS datecreation_10,
  t0.datemodification AS datemodification_11,
  t0.rgpd AS rgpd_12,
  t0.linkedin AS linkedin_13,
  t0.prospect_id AS prospect_id_14,
  t0.collaborateur_id AS collaborateur_id_15
FROM
  contact t0
WHERE
  t0.prospect_id = ?

SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.fonction AS fonction_5, t0.email AS email_6, t0.fixe AS fixe_7, t0.mobile AS mobile_8, t0.active AS active_9, t0.datecreation AS datecreation_10, t0.datemodification AS datemodification_11, t0.rgpd AS rgpd_12, t0.linkedin AS linkedin_13, t0.prospect_id AS prospect_id_14, t0.collaborateur_id AS collaborateur_id_15 FROM contact t0 WHERE t0.prospect_id = 22899;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3,
  t0.active AS active_4
FROM
  appareilmarque t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.active AS active_4 FROM appareilmarque t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3,
  t0.active AS active_4
FROM
  appareiltype t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.active AS active_4 FROM appareiltype t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.active AS active_4,
  t0.classification_structure AS classification_structure_5
FROM
  codenaf t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.active AS active_4, t0.classification_structure AS classification_structure_5 FROM codenaf t0 WHERE t0.id = 83;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.codepostal AS codepostal_3,
  t0.active AS active_4,
  t0.pays AS pays_5
FROM
  ville t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.codepostal AS codepostal_3, t0.active AS active_4, t0.pays AS pays_5 FROM ville t0 WHERE t0.id = 398;