Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.created_at AS created_at_3,
  t0.auth_user_id AS auth_user_id_4
FROM
  auth_tokens t0
WHERE
  t0.value = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.auth_user_id AS auth_user_id_4 FROM auth_tokens t0 WHERE t0.value = 'hipQPW3AgReq64enLog7IYJ9blbMxYmC340LOdpTZquYUboVMlizUP1HMz0ZNkOuHk=' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password_mail AS password_mail_3,
  t0.password AS password_4,
  t0.roles AS roles_5,
  t0.old_login AS old_login_6,
  t0.old_password AS old_password_7,
  t0.actuel AS actuel_8,
  t0.fonction AS fonction_9,
  t0.date_arrive AS date_arrive_10,
  t0.tel_interne AS tel_interne_11,
  t0.adresse_envoi AS adresse_envoi_12,
  t0.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_13,
  t0.u_systeme AS u_systeme_14,
  t0.user_id AS user_id_15,
  t16.id AS id_17,
  t16.prenom AS prenom_18,
  t16.nom AS nom_19,
  t16.email AS email_20,
  t16.resp_conge AS resp_conge_21,
  t16.tel AS tel_22,
  t16.civilite AS civilite_23,
  t16.id_adress AS id_adress_24
FROM
  auth_user t0
  LEFT JOIN user t16 ON t0.user_id = t16.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password_mail AS password_mail_3, t0.password AS password_4, t0.roles AS roles_5, t0.old_login AS old_login_6, t0.old_password AS old_password_7, t0.actuel AS actuel_8, t0.fonction AS fonction_9, t0.date_arrive AS date_arrive_10, t0.tel_interne AS tel_interne_11, t0.adresse_envoi AS adresse_envoi_12, t0.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_13, t0.u_systeme AS u_systeme_14, t0.user_id AS user_id_15, t16.id AS id_17, t16.prenom AS prenom_18, t16.nom AS nom_19, t16.email AS email_20, t16.resp_conge AS resp_conge_21, t16.tel AS tel_22, t16.civilite AS civilite_23, t16.id_adress AS id_adress_24 FROM auth_user t0 LEFT JOIN user t16 ON t0.user_id = t16.id WHERE t0.id = 85;

SELECT
  t0.id AS id_1,
  t0.ancien_id AS ancien_id_2,
  t0.libelle AS libelle_3,
  t0.genre AS genre_4
FROM
  civilite t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.libelle AS libelle_3, t0.genre AS genre_4 FROM civilite t0 WHERE t0.id IN (3);

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.adresse_coupure AS adresse_coupure_3,
  t0.adresse_generique AS adresse_generique_4,
  t0.color AS color_5,
  t0.id_client AS id_client_6,
  t7.id AS id_8,
  t7.nom AS nom_9,
  t7.adresse_generique AS adresse_generique_10,
  t7.adresse_coupure AS adresse_coupure_11,
  t7.actuel AS actuel_12,
  t7.ancien_id AS ancien_id_13,
  t7.dirigeant AS dirigeant_14,
  t7.date_entree AS date_entree_15,
  t7.date_sortie AS date_sortie_16,
  t7.duree AS duree_17,
  t7.score AS score_18,
  t7.logo_id AS logo_id_19,
  t7.pressroom_client AS pressroom_client_20,
  t7.etat_id AS etat_id_21,
  t7.liste_journaliste_interview_article_id AS liste_journaliste_interview_article_id_22,
  t0.id_user AS id_user_23
FROM
  client_role_user t0
  LEFT JOIN client t7 ON t0.id_client = t7.id
WHERE
  t0.id_user IN (?)

SELECT t0.id AS id_1, t0.role AS role_2, t0.adresse_coupure AS adresse_coupure_3, t0.adresse_generique AS adresse_generique_4, t0.color AS color_5, t0.id_client AS id_client_6, t7.id AS id_8, t7.nom AS nom_9, t7.adresse_generique AS adresse_generique_10, t7.adresse_coupure AS adresse_coupure_11, t7.actuel AS actuel_12, t7.ancien_id AS ancien_id_13, t7.dirigeant AS dirigeant_14, t7.date_entree AS date_entree_15, t7.date_sortie AS date_sortie_16, t7.duree AS duree_17, t7.score AS score_18, t7.logo_id AS logo_id_19, t7.pressroom_client AS pressroom_client_20, t7.etat_id AS etat_id_21, t7.liste_journaliste_interview_article_id AS liste_journaliste_interview_article_id_22, t0.id_user AS id_user_23 FROM client_role_user t0 LEFT JOIN client t7 ON t0.id_client = t7.id WHERE t0.id_user IN (85);

SELECT
  t0.id AS id_1,
  t0.adresse AS adresse_2,
  t0.ville AS ville_3,
  t0.code_postal AS code_postal_4,
  t0.pays AS pays_5,
  t0.complement AS complement_6
FROM
  adresse t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.adresse AS adresse_2, t0.ville AS ville_3, t0.code_postal AS code_postal_4, t0.pays AS pays_5, t0.complement AS complement_6 FROM adresse t0 WHERE t0.id IN (60);

SELECT
  t0.id AS id_1,
  t0.ancien_id AS ancien_id_2,
  t0.nom AS nom_3,
  t0.prenom AS prenom_4,
  t0.mode_envoi_pref AS mode_envoi_pref_5,
  t0.pieces_jointes AS pieces_jointes_6,
  t0.contact_perso AS contact_perso_7,
  t0.commentaires AS commentaires_8,
  t0.objet AS objet_9,
  t0.date_conclusion AS date_conclusion_10,
  t0.creation AS creation_11,
  t0.modification AS modification_12,
  t0.dernier_import AS dernier_import_13,
  t0.auteur_id AS auteur_id_14,
  t0.civilite_id AS civilite_id_15,
  t0.fonction_id AS fonction_id_16,
  t0.coordonnees_id AS coordonnees_id_17,
  t0.genre_id AS genre_id_18,
  t0.reseaux_sociaux_id AS reseaux_sociaux_id_19
FROM
  contact t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.mode_envoi_pref AS mode_envoi_pref_5, t0.pieces_jointes AS pieces_jointes_6, t0.contact_perso AS contact_perso_7, t0.commentaires AS commentaires_8, t0.objet AS objet_9, t0.date_conclusion AS date_conclusion_10, t0.creation AS creation_11, t0.modification AS modification_12, t0.dernier_import AS dernier_import_13, t0.auteur_id AS auteur_id_14, t0.civilite_id AS civilite_id_15, t0.fonction_id AS fonction_id_16, t0.coordonnees_id AS coordonnees_id_17, t0.genre_id AS genre_id_18, t0.reseaux_sociaux_id AS reseaux_sociaux_id_19 FROM contact t0 WHERE t0.id = '15592';

SELECT
  t0.id AS id_1,
  t0.premier_tel AS premier_tel_2,
  t0.deuxieme_tel AS deuxieme_tel_3,
  t0.email AS email_4,
  t0.rue AS rue_5,
  t0.complements AS complements_6,
  t0.boite_postale AS boite_postale_7,
  t0.code_postal AS code_postal_8,
  t0.ville AS ville_9,
  t0.premier_url AS premier_url_10,
  t0.deuxieme_url AS deuxieme_url_11,
  t0.creation AS creation_12,
  t0.modification AS modification_13,
  t0.ancien_id AS ancien_id_14,
  t0.pays_id AS pays_id_15,
  t0.auteur_id AS auteur_id_16,
  t17.id AS id_18,
  t17.ancien_id AS ancien_id_19,
  t17.nom AS nom_20,
  t17.date_creation AS date_creation_21,
  t17.siren AS siren_22,
  t17.capital AS capital_23,
  t17.effectif AS effectif_24,
  t17.implantation AS implantation_25,
  t17.commentaires AS commentaires_26,
  t17.creation AS creation_27,
  t17.modification AS modification_28,
  t17.auteur_id AS auteur_id_29,
  t17.appartenir_a_id AS appartenir_a_id_30,
  t17.client_id AS client_id_31,
  t17.forme_juridique_id AS forme_juridique_id_32,
  t17.genre_id AS genre_id_33,
  t17.categorie_generale_id AS categorie_generale_id_34,
  t17.coordonnees_id AS coordonnees_id_35,
  t17.dirigeant_id AS dirigeant_id_36,
  t17.ape_id AS ape_id_37,
  t38.id AS id_39,
  t38.nom AS nom_40,
  t38.date_parution AS date_parution_41,
  t38.date_bouclage AS date_bouclage_42,
  t38.audience AS audience_43,
  t38.mediametrie AS mediametrie_44,
  t38.ojd AS ojd_45,
  t38.equiv_pub AS equiv_pub_46,
  t38.precisions AS precisions_47,
  t38.positionnement AS positionnement_48,
  t38.cible AS cible_49,
  t38.commentaires AS commentaires_50,
  t38.disponibilite AS disponibilite_51,
  t38.exemp_dispo AS exemp_dispo_52,
  t38.ancien_id AS ancien_id_53,
  t38.creation AS creation_54,
  t38.modification AS modification_55,
  t38.tel_standard AS tel_standard_56,
  t38.tel_publicite AS tel_publicite_57,
  t38.casier_id AS casier_id_58,
  t38.type_media_id AS type_media_id_59,
  t38.etat_id AS etat_id_60,
  t38.organisation_id AS organisation_id_61,
  t38.famille_id AS famille_id_62,
  t38.periodicite_id AS periodicite_id_63,
  t38.type_ojd_id AS type_ojd_id_64,
  t38.zone_diffusion_id AS zone_diffusion_id_65,
  t38.coordonnees_id AS coordonnees_id_66,
  t38.auteur_id AS auteur_id_67,
  t38.logo_support_id AS logo_support_id_68,
  t69.id AS id_70,
  t69.ancien_id AS ancien_id_71,
  t69.nom AS nom_72,
  t69.prenom AS prenom_73,
  t69.mode_envoi_pref AS mode_envoi_pref_74,
  t69.pieces_jointes AS pieces_jointes_75,
  t69.contact_perso AS contact_perso_76,
  t69.commentaires AS commentaires_77,
  t69.objet AS objet_78,
  t69.date_conclusion AS date_conclusion_79,
  t69.creation AS creation_80,
  t69.modification AS modification_81,
  t69.dernier_import AS dernier_import_82,
  t69.auteur_id AS auteur_id_83,
  t69.civilite_id AS civilite_id_84,
  t69.fonction_id AS fonction_id_85,
  t69.coordonnees_id AS coordonnees_id_86,
  t69.genre_id AS genre_id_87,
  t69.reseaux_sociaux_id AS reseaux_sociaux_id_88
FROM
  coordonnees t0
  LEFT JOIN organisation t17 ON t17.coordonnees_id = t0.id
  LEFT JOIN support t38 ON t38.coordonnees_id = t0.id
  LEFT JOIN contact t69 ON t69.coordonnees_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.premier_tel AS premier_tel_2, t0.deuxieme_tel AS deuxieme_tel_3, t0.email AS email_4, t0.rue AS rue_5, t0.complements AS complements_6, t0.boite_postale AS boite_postale_7, t0.code_postal AS code_postal_8, t0.ville AS ville_9, t0.premier_url AS premier_url_10, t0.deuxieme_url AS deuxieme_url_11, t0.creation AS creation_12, t0.modification AS modification_13, t0.ancien_id AS ancien_id_14, t0.pays_id AS pays_id_15, t0.auteur_id AS auteur_id_16, t17.id AS id_18, t17.ancien_id AS ancien_id_19, t17.nom AS nom_20, t17.date_creation AS date_creation_21, t17.siren AS siren_22, t17.capital AS capital_23, t17.effectif AS effectif_24, t17.implantation AS implantation_25, t17.commentaires AS commentaires_26, t17.creation AS creation_27, t17.modification AS modification_28, t17.auteur_id AS auteur_id_29, t17.appartenir_a_id AS appartenir_a_id_30, t17.client_id AS client_id_31, t17.forme_juridique_id AS forme_juridique_id_32, t17.genre_id AS genre_id_33, t17.categorie_generale_id AS categorie_generale_id_34, t17.coordonnees_id AS coordonnees_id_35, t17.dirigeant_id AS dirigeant_id_36, t17.ape_id AS ape_id_37, t38.id AS id_39, t38.nom AS nom_40, t38.date_parution AS date_parution_41, t38.date_bouclage AS date_bouclage_42, t38.audience AS audience_43, t38.mediametrie AS mediametrie_44, t38.ojd AS ojd_45, t38.equiv_pub AS equiv_pub_46, t38.precisions AS precisions_47, t38.positionnement AS positionnement_48, t38.cible AS cible_49, t38.commentaires AS commentaires_50, t38.disponibilite AS disponibilite_51, t38.exemp_dispo AS exemp_dispo_52, t38.ancien_id AS ancien_id_53, t38.creation AS creation_54, t38.modification AS modification_55, t38.tel_standard AS tel_standard_56, t38.tel_publicite AS tel_publicite_57, t38.casier_id AS casier_id_58, t38.type_media_id AS type_media_id_59, t38.etat_id AS etat_id_60, t38.organisation_id AS organisation_id_61, t38.famille_id AS famille_id_62, t38.periodicite_id AS periodicite_id_63, t38.type_ojd_id AS type_ojd_id_64, t38.zone_diffusion_id AS zone_diffusion_id_65, t38.coordonnees_id AS coordonnees_id_66, t38.auteur_id AS auteur_id_67, t38.logo_support_id AS logo_support_id_68, t69.id AS id_70, t69.ancien_id AS ancien_id_71, t69.nom AS nom_72, t69.prenom AS prenom_73, t69.mode_envoi_pref AS mode_envoi_pref_74, t69.pieces_jointes AS pieces_jointes_75, t69.contact_perso AS contact_perso_76, t69.commentaires AS commentaires_77, t69.objet AS objet_78, t69.date_conclusion AS date_conclusion_79, t69.creation AS creation_80, t69.modification AS modification_81, t69.dernier_import AS dernier_import_82, t69.auteur_id AS auteur_id_83, t69.civilite_id AS civilite_id_84, t69.fonction_id AS fonction_id_85, t69.coordonnees_id AS coordonnees_id_86, t69.genre_id AS genre_id_87, t69.reseaux_sociaux_id AS reseaux_sociaux_id_88 FROM coordonnees t0 LEFT JOIN organisation t17 ON t17.coordonnees_id = t0.id LEFT JOIN support t38 ON t38.coordonnees_id = t0.id LEFT JOIN contact t69 ON t69.coordonnees_id = t0.id WHERE t0.id = 21988;

SELECT
  m0_.destinataire AS destinataire_0
FROM
  mailling_en_cour m0_
WHERE
  m0_.user_id = ?
ORDER BY
  m0_.date_envoie DESC,
  m0_.id DESC
LIMIT
  1

SELECT m0_.destinataire AS destinataire_0 FROM mailling_en_cour m0_ WHERE m0_.user_id = '281517' ORDER BY m0_.date_envoie DESC, m0_.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.premier_tel AS premier_tel_2,
  t0.deuxieme_tel AS deuxieme_tel_3,
  t0.email AS email_4,
  t0.contact_id AS contact_id_5,
  t0.organisation_id AS organisation_id_6
FROM
  contact_organisation t0
WHERE
  t0.contact_id = ?

SELECT t0.id AS id_1, t0.premier_tel AS premier_tel_2, t0.deuxieme_tel AS deuxieme_tel_3, t0.email AS email_4, t0.contact_id AS contact_id_5, t0.organisation_id AS organisation_id_6 FROM contact_organisation t0 WHERE t0.contact_id = 15592;

SELECT
  t0.id AS id_1,
  t0.premier_tel AS premier_tel_2,
  t0.deuxieme_tel AS deuxieme_tel_3,
  t0.email AS email_4,
  t0.participe AS participe_5,
  t0.date_depart AS date_depart_6,
  t0.commentaires AS commentaires_7,
  t0.dernier_email_verif AS dernier_email_verif_8,
  t0.contact_id AS contact_id_9,
  t0.support_id AS support_id_10,
  t0.fonction_id AS fonction_id_11
FROM
  contact_support t0
WHERE
  t0.contact_id = ?

SELECT t0.id AS id_1, t0.premier_tel AS premier_tel_2, t0.deuxieme_tel AS deuxieme_tel_3, t0.email AS email_4, t0.participe AS participe_5, t0.date_depart AS date_depart_6, t0.commentaires AS commentaires_7, t0.dernier_email_verif AS dernier_email_verif_8, t0.contact_id AS contact_id_9, t0.support_id AS support_id_10, t0.fonction_id AS fonction_id_11 FROM contact_support t0 WHERE t0.contact_id = 15592;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.date_parution AS date_parution_3,
  t0.date_bouclage AS date_bouclage_4,
  t0.audience AS audience_5,
  t0.mediametrie AS mediametrie_6,
  t0.ojd AS ojd_7,
  t0.equiv_pub AS equiv_pub_8,
  t0.precisions AS precisions_9,
  t0.positionnement AS positionnement_10,
  t0.cible AS cible_11,
  t0.commentaires AS commentaires_12,
  t0.disponibilite AS disponibilite_13,
  t0.exemp_dispo AS exemp_dispo_14,
  t0.ancien_id AS ancien_id_15,
  t0.creation AS creation_16,
  t0.modification AS modification_17,
  t0.tel_standard AS tel_standard_18,
  t0.tel_publicite AS tel_publicite_19,
  t0.casier_id AS casier_id_20,
  t0.type_media_id AS type_media_id_21,
  t0.etat_id AS etat_id_22,
  t0.organisation_id AS organisation_id_23,
  t0.famille_id AS famille_id_24,
  t0.periodicite_id AS periodicite_id_25,
  t0.type_ojd_id AS type_ojd_id_26,
  t0.zone_diffusion_id AS zone_diffusion_id_27,
  t0.coordonnees_id AS coordonnees_id_28,
  t0.auteur_id AS auteur_id_29,
  t0.logo_support_id AS logo_support_id_30
FROM
  support t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.date_parution AS date_parution_3, t0.date_bouclage AS date_bouclage_4, t0.audience AS audience_5, t0.mediametrie AS mediametrie_6, t0.ojd AS ojd_7, t0.equiv_pub AS equiv_pub_8, t0.precisions AS precisions_9, t0.positionnement AS positionnement_10, t0.cible AS cible_11, t0.commentaires AS commentaires_12, t0.disponibilite AS disponibilite_13, t0.exemp_dispo AS exemp_dispo_14, t0.ancien_id AS ancien_id_15, t0.creation AS creation_16, t0.modification AS modification_17, t0.tel_standard AS tel_standard_18, t0.tel_publicite AS tel_publicite_19, t0.casier_id AS casier_id_20, t0.type_media_id AS type_media_id_21, t0.etat_id AS etat_id_22, t0.organisation_id AS organisation_id_23, t0.famille_id AS famille_id_24, t0.periodicite_id AS periodicite_id_25, t0.type_ojd_id AS type_ojd_id_26, t0.zone_diffusion_id AS zone_diffusion_id_27, t0.coordonnees_id AS coordonnees_id_28, t0.auteur_id AS auteur_id_29, t0.logo_support_id AS logo_support_id_30 FROM support t0 WHERE t0.id = 90;

SELECT
  t0.id AS id_1,
  t0.premier_tel AS premier_tel_2,
  t0.deuxieme_tel AS deuxieme_tel_3,
  t0.email AS email_4,
  t0.rue AS rue_5,
  t0.complements AS complements_6,
  t0.boite_postale AS boite_postale_7,
  t0.code_postal AS code_postal_8,
  t0.ville AS ville_9,
  t0.premier_url AS premier_url_10,
  t0.deuxieme_url AS deuxieme_url_11,
  t0.creation AS creation_12,
  t0.modification AS modification_13,
  t0.ancien_id AS ancien_id_14,
  t0.pays_id AS pays_id_15,
  t0.auteur_id AS auteur_id_16,
  t17.id AS id_18,
  t17.ancien_id AS ancien_id_19,
  t17.nom AS nom_20,
  t17.date_creation AS date_creation_21,
  t17.siren AS siren_22,
  t17.capital AS capital_23,
  t17.effectif AS effectif_24,
  t17.implantation AS implantation_25,
  t17.commentaires AS commentaires_26,
  t17.creation AS creation_27,
  t17.modification AS modification_28,
  t17.auteur_id AS auteur_id_29,
  t17.appartenir_a_id AS appartenir_a_id_30,
  t17.client_id AS client_id_31,
  t17.forme_juridique_id AS forme_juridique_id_32,
  t17.genre_id AS genre_id_33,
  t17.categorie_generale_id AS categorie_generale_id_34,
  t17.coordonnees_id AS coordonnees_id_35,
  t17.dirigeant_id AS dirigeant_id_36,
  t17.ape_id AS ape_id_37,
  t38.id AS id_39,
  t38.nom AS nom_40,
  t38.date_parution AS date_parution_41,
  t38.date_bouclage AS date_bouclage_42,
  t38.audience AS audience_43,
  t38.mediametrie AS mediametrie_44,
  t38.ojd AS ojd_45,
  t38.equiv_pub AS equiv_pub_46,
  t38.precisions AS precisions_47,
  t38.positionnement AS positionnement_48,
  t38.cible AS cible_49,
  t38.commentaires AS commentaires_50,
  t38.disponibilite AS disponibilite_51,
  t38.exemp_dispo AS exemp_dispo_52,
  t38.ancien_id AS ancien_id_53,
  t38.creation AS creation_54,
  t38.modification AS modification_55,
  t38.tel_standard AS tel_standard_56,
  t38.tel_publicite AS tel_publicite_57,
  t38.casier_id AS casier_id_58,
  t38.type_media_id AS type_media_id_59,
  t38.etat_id AS etat_id_60,
  t38.organisation_id AS organisation_id_61,
  t38.famille_id AS famille_id_62,
  t38.periodicite_id AS periodicite_id_63,
  t38.type_ojd_id AS type_ojd_id_64,
  t38.zone_diffusion_id AS zone_diffusion_id_65,
  t38.coordonnees_id AS coordonnees_id_66,
  t38.auteur_id AS auteur_id_67,
  t38.logo_support_id AS logo_support_id_68,
  t69.id AS id_70,
  t69.ancien_id AS ancien_id_71,
  t69.nom AS nom_72,
  t69.prenom AS prenom_73,
  t69.mode_envoi_pref AS mode_envoi_pref_74,
  t69.pieces_jointes AS pieces_jointes_75,
  t69.contact_perso AS contact_perso_76,
  t69.commentaires AS commentaires_77,
  t69.objet AS objet_78,
  t69.date_conclusion AS date_conclusion_79,
  t69.creation AS creation_80,
  t69.modification AS modification_81,
  t69.dernier_import AS dernier_import_82,
  t69.auteur_id AS auteur_id_83,
  t69.civilite_id AS civilite_id_84,
  t69.fonction_id AS fonction_id_85,
  t69.coordonnees_id AS coordonnees_id_86,
  t69.genre_id AS genre_id_87,
  t69.reseaux_sociaux_id AS reseaux_sociaux_id_88
FROM
  coordonnees t0
  LEFT JOIN organisation t17 ON t17.coordonnees_id = t0.id
  LEFT JOIN support t38 ON t38.coordonnees_id = t0.id
  LEFT JOIN contact t69 ON t69.coordonnees_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.premier_tel AS premier_tel_2, t0.deuxieme_tel AS deuxieme_tel_3, t0.email AS email_4, t0.rue AS rue_5, t0.complements AS complements_6, t0.boite_postale AS boite_postale_7, t0.code_postal AS code_postal_8, t0.ville AS ville_9, t0.premier_url AS premier_url_10, t0.deuxieme_url AS deuxieme_url_11, t0.creation AS creation_12, t0.modification AS modification_13, t0.ancien_id AS ancien_id_14, t0.pays_id AS pays_id_15, t0.auteur_id AS auteur_id_16, t17.id AS id_18, t17.ancien_id AS ancien_id_19, t17.nom AS nom_20, t17.date_creation AS date_creation_21, t17.siren AS siren_22, t17.capital AS capital_23, t17.effectif AS effectif_24, t17.implantation AS implantation_25, t17.commentaires AS commentaires_26, t17.creation AS creation_27, t17.modification AS modification_28, t17.auteur_id AS auteur_id_29, t17.appartenir_a_id AS appartenir_a_id_30, t17.client_id AS client_id_31, t17.forme_juridique_id AS forme_juridique_id_32, t17.genre_id AS genre_id_33, t17.categorie_generale_id AS categorie_generale_id_34, t17.coordonnees_id AS coordonnees_id_35, t17.dirigeant_id AS dirigeant_id_36, t17.ape_id AS ape_id_37, t38.id AS id_39, t38.nom AS nom_40, t38.date_parution AS date_parution_41, t38.date_bouclage AS date_bouclage_42, t38.audience AS audience_43, t38.mediametrie AS mediametrie_44, t38.ojd AS ojd_45, t38.equiv_pub AS equiv_pub_46, t38.precisions AS precisions_47, t38.positionnement AS positionnement_48, t38.cible AS cible_49, t38.commentaires AS commentaires_50, t38.disponibilite AS disponibilite_51, t38.exemp_dispo AS exemp_dispo_52, t38.ancien_id AS ancien_id_53, t38.creation AS creation_54, t38.modification AS modification_55, t38.tel_standard AS tel_standard_56, t38.tel_publicite AS tel_publicite_57, t38.casier_id AS casier_id_58, t38.type_media_id AS type_media_id_59, t38.etat_id AS etat_id_60, t38.organisation_id AS organisation_id_61, t38.famille_id AS famille_id_62, t38.periodicite_id AS periodicite_id_63, t38.type_ojd_id AS type_ojd_id_64, t38.zone_diffusion_id AS zone_diffusion_id_65, t38.coordonnees_id AS coordonnees_id_66, t38.auteur_id AS auteur_id_67, t38.logo_support_id AS logo_support_id_68, t69.id AS id_70, t69.ancien_id AS ancien_id_71, t69.nom AS nom_72, t69.prenom AS prenom_73, t69.mode_envoi_pref AS mode_envoi_pref_74, t69.pieces_jointes AS pieces_jointes_75, t69.contact_perso AS contact_perso_76, t69.commentaires AS commentaires_77, t69.objet AS objet_78, t69.date_conclusion AS date_conclusion_79, t69.creation AS creation_80, t69.modification AS modification_81, t69.dernier_import AS dernier_import_82, t69.auteur_id AS auteur_id_83, t69.civilite_id AS civilite_id_84, t69.fonction_id AS fonction_id_85, t69.coordonnees_id AS coordonnees_id_86, t69.genre_id AS genre_id_87, t69.reseaux_sociaux_id AS reseaux_sociaux_id_88 FROM coordonnees t0 LEFT JOIN organisation t17 ON t17.coordonnees_id = t0.id LEFT JOIN support t38 ON t38.coordonnees_id = t0.id LEFT JOIN contact t69 ON t69.coordonnees_id = t0.id WHERE t0.id = 175;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.date_parution AS date_parution_3,
  t0.date_bouclage AS date_bouclage_4,
  t0.audience AS audience_5,
  t0.mediametrie AS mediametrie_6,
  t0.ojd AS ojd_7,
  t0.equiv_pub AS equiv_pub_8,
  t0.precisions AS precisions_9,
  t0.positionnement AS positionnement_10,
  t0.cible AS cible_11,
  t0.commentaires AS commentaires_12,
  t0.disponibilite AS disponibilite_13,
  t0.exemp_dispo AS exemp_dispo_14,
  t0.ancien_id AS ancien_id_15,
  t0.creation AS creation_16,
  t0.modification AS modification_17,
  t0.tel_standard AS tel_standard_18,
  t0.tel_publicite AS tel_publicite_19,
  t0.casier_id AS casier_id_20,
  t0.type_media_id AS type_media_id_21,
  t0.etat_id AS etat_id_22,
  t0.organisation_id AS organisation_id_23,
  t0.famille_id AS famille_id_24,
  t0.periodicite_id AS periodicite_id_25,
  t0.type_ojd_id AS type_ojd_id_26,
  t0.zone_diffusion_id AS zone_diffusion_id_27,
  t0.coordonnees_id AS coordonnees_id_28,
  t0.auteur_id AS auteur_id_29,
  t0.logo_support_id AS logo_support_id_30
FROM
  support t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.date_parution AS date_parution_3, t0.date_bouclage AS date_bouclage_4, t0.audience AS audience_5, t0.mediametrie AS mediametrie_6, t0.ojd AS ojd_7, t0.equiv_pub AS equiv_pub_8, t0.precisions AS precisions_9, t0.positionnement AS positionnement_10, t0.cible AS cible_11, t0.commentaires AS commentaires_12, t0.disponibilite AS disponibilite_13, t0.exemp_dispo AS exemp_dispo_14, t0.ancien_id AS ancien_id_15, t0.creation AS creation_16, t0.modification AS modification_17, t0.tel_standard AS tel_standard_18, t0.tel_publicite AS tel_publicite_19, t0.casier_id AS casier_id_20, t0.type_media_id AS type_media_id_21, t0.etat_id AS etat_id_22, t0.organisation_id AS organisation_id_23, t0.famille_id AS famille_id_24, t0.periodicite_id AS periodicite_id_25, t0.type_ojd_id AS type_ojd_id_26, t0.zone_diffusion_id AS zone_diffusion_id_27, t0.coordonnees_id AS coordonnees_id_28, t0.auteur_id AS auteur_id_29, t0.logo_support_id AS logo_support_id_30 FROM support t0 WHERE t0.id = 157;

SELECT
  t0.id AS id_1,
  t0.premier_tel AS premier_tel_2,
  t0.deuxieme_tel AS deuxieme_tel_3,
  t0.email AS email_4,
  t0.rue AS rue_5,
  t0.complements AS complements_6,
  t0.boite_postale AS boite_postale_7,
  t0.code_postal AS code_postal_8,
  t0.ville AS ville_9,
  t0.premier_url AS premier_url_10,
  t0.deuxieme_url AS deuxieme_url_11,
  t0.creation AS creation_12,
  t0.modification AS modification_13,
  t0.ancien_id AS ancien_id_14,
  t0.pays_id AS pays_id_15,
  t0.auteur_id AS auteur_id_16,
  t17.id AS id_18,
  t17.ancien_id AS ancien_id_19,
  t17.nom AS nom_20,
  t17.date_creation AS date_creation_21,
  t17.siren AS siren_22,
  t17.capital AS capital_23,
  t17.effectif AS effectif_24,
  t17.implantation AS implantation_25,
  t17.commentaires AS commentaires_26,
  t17.creation AS creation_27,
  t17.modification AS modification_28,
  t17.auteur_id AS auteur_id_29,
  t17.appartenir_a_id AS appartenir_a_id_30,
  t17.client_id AS client_id_31,
  t17.forme_juridique_id AS forme_juridique_id_32,
  t17.genre_id AS genre_id_33,
  t17.categorie_generale_id AS categorie_generale_id_34,
  t17.coordonnees_id AS coordonnees_id_35,
  t17.dirigeant_id AS dirigeant_id_36,
  t17.ape_id AS ape_id_37,
  t38.id AS id_39,
  t38.nom AS nom_40,
  t38.date_parution AS date_parution_41,
  t38.date_bouclage AS date_bouclage_42,
  t38.audience AS audience_43,
  t38.mediametrie AS mediametrie_44,
  t38.ojd AS ojd_45,
  t38.equiv_pub AS equiv_pub_46,
  t38.precisions AS precisions_47,
  t38.positionnement AS positionnement_48,
  t38.cible AS cible_49,
  t38.commentaires AS commentaires_50,
  t38.disponibilite AS disponibilite_51,
  t38.exemp_dispo AS exemp_dispo_52,
  t38.ancien_id AS ancien_id_53,
  t38.creation AS creation_54,
  t38.modification AS modification_55,
  t38.tel_standard AS tel_standard_56,
  t38.tel_publicite AS tel_publicite_57,
  t38.casier_id AS casier_id_58,
  t38.type_media_id AS type_media_id_59,
  t38.etat_id AS etat_id_60,
  t38.organisation_id AS organisation_id_61,
  t38.famille_id AS famille_id_62,
  t38.periodicite_id AS periodicite_id_63,
  t38.type_ojd_id AS type_ojd_id_64,
  t38.zone_diffusion_id AS zone_diffusion_id_65,
  t38.coordonnees_id AS coordonnees_id_66,
  t38.auteur_id AS auteur_id_67,
  t38.logo_support_id AS logo_support_id_68,
  t69.id AS id_70,
  t69.ancien_id AS ancien_id_71,
  t69.nom AS nom_72,
  t69.prenom AS prenom_73,
  t69.mode_envoi_pref AS mode_envoi_pref_74,
  t69.pieces_jointes AS pieces_jointes_75,
  t69.contact_perso AS contact_perso_76,
  t69.commentaires AS commentaires_77,
  t69.objet AS objet_78,
  t69.date_conclusion AS date_conclusion_79,
  t69.creation AS creation_80,
  t69.modification AS modification_81,
  t69.dernier_import AS dernier_import_82,
  t69.auteur_id AS auteur_id_83,
  t69.civilite_id AS civilite_id_84,
  t69.fonction_id AS fonction_id_85,
  t69.coordonnees_id AS coordonnees_id_86,
  t69.genre_id AS genre_id_87,
  t69.reseaux_sociaux_id AS reseaux_sociaux_id_88
FROM
  coordonnees t0
  LEFT JOIN organisation t17 ON t17.coordonnees_id = t0.id
  LEFT JOIN support t38 ON t38.coordonnees_id = t0.id
  LEFT JOIN contact t69 ON t69.coordonnees_id = t0.id
WHERE
  t0.id = ?