https://api.escalnet.escalconsulting.com/api/contacts?ancienId=234858

Method
GET
HTTP Status
200
IP
185.126.230.125
Profiled on
Token
960c9a

Query Metrics

11 Database Queries
11 Different statements
418.27 ms Query time
2 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.68 ms 
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
Parameters: 
[
  "LgJJFro3Kso+GXMMsc37InFuaJw9DnfAnuUVwu4kGshx4Fg8IFaeB12yeyYtzkfolE="
]
View formatted query    View runnable query    Explain query
2 1.04 ms 
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, t25.id AS id_26, t25.role AS role_27, t25.adresse_coupure AS adresse_coupure_28, t25.adresse_generique AS adresse_generique_29, t25.color AS color_30, t25.id_client AS id_client_31, t25.id_user AS id_user_32 FROM auth_user t0 LEFT JOIN user t16 ON t0.user_id = t16.id LEFT JOIN client_role_user t25 ON t25.id_user = t0.id WHERE t0.id = ?
Parameters: 
[
  104
]
View formatted query    View runnable query    Explain query
3 0.41 ms 
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 (?)
Parameters: 
[
  [
    2
  ]
]
View formatted query    View runnable query    Explain query
4 0.23 ms 
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 (?)
Parameters: 
[
  [
    79
  ]
]
View formatted query    View runnable query    Explain query
5 205.47 ms 
SELECT DISTINCT c0_.id AS id_0, c0_.id AS id_1 FROM contact c0_ LEFT JOIN auth_user a1_ ON c0_.auteur_id = a1_.id LEFT JOIN user u2_ ON a1_.user_id = u2_.id LEFT JOIN civilite c3_ ON c0_.civilite_id = c3_.id LEFT JOIN fonction f4_ ON c0_.fonction_id = f4_.id LEFT JOIN coordonnees c5_ ON c0_.coordonnees_id = c5_.id LEFT JOIN pays p6_ ON c5_.pays_id = p6_.id LEFT JOIN auth_user a7_ ON c5_.auteur_id = a7_.id LEFT JOIN user u8_ ON a7_.user_id = u8_.id LEFT JOIN genre g9_ ON c0_.genre_id = g9_.id LEFT JOIN contact_categories_generales c11_ ON c0_.id = c11_.contact_id LEFT JOIN categories_generales c10_ ON c10_.id = c11_.categories_generales_id LEFT JOIN contact_sous_categories_generales c13_ ON c0_.id = c13_.contact_id LEFT JOIN sous_categories_generales s12_ ON s12_.id = c13_.sous_categories_generales_id LEFT JOIN contact_langues c15_ ON c0_.id = c15_.contact_id LEFT JOIN langues l14_ ON l14_.id = c15_.langues_id LEFT JOIN contact_pays c17_ ON c0_.id = c17_.contact_id LEFT JOIN pays p16_ ON p16_.id = c17_.pays_id LEFT JOIN organisation o18_ ON c0_.id = o18_.dirigeant_id LEFT JOIN contact_organisation c19_ ON c0_.id = c19_.contact_id LEFT JOIN organisation o20_ ON c19_.organisation_id = o20_.id LEFT JOIN contact_support c21_ ON c0_.id = c21_.contact_id LEFT JOIN support s22_ ON c21_.support_id = s22_.id LEFT JOIN fonction f23_ ON c21_.fonction_id = f23_.id LEFT JOIN reseaux_sociaux r24_ ON c0_.reseaux_sociaux_id = r24_.id WHERE c0_.id IN (SELECT c25_.id FROM contact c25_ LEFT JOIN auth_user a26_ ON c25_.auteur_id = a26_.id LEFT JOIN user u27_ ON a26_.user_id = u27_.id LEFT JOIN civilite c28_ ON c25_.civilite_id = c28_.id LEFT JOIN fonction f29_ ON c25_.fonction_id = f29_.id LEFT JOIN coordonnees c30_ ON c25_.coordonnees_id = c30_.id LEFT JOIN pays p31_ ON c30_.pays_id = p31_.id LEFT JOIN auth_user a32_ ON c30_.auteur_id = a32_.id LEFT JOIN user u33_ ON a32_.user_id = u33_.id LEFT JOIN genre g34_ ON c25_.genre_id = g34_.id LEFT JOIN contact_categories_generales c36_ ON c25_.id = c36_.contact_id LEFT JOIN categories_generales c35_ ON c35_.id = c36_.categories_generales_id LEFT JOIN contact_sous_categories_generales c38_ ON c25_.id = c38_.contact_id LEFT JOIN sous_categories_generales s37_ ON s37_.id = c38_.sous_categories_generales_id LEFT JOIN contact_langues c40_ ON c25_.id = c40_.contact_id LEFT JOIN langues l39_ ON l39_.id = c40_.langues_id LEFT JOIN contact_pays c42_ ON c25_.id = c42_.contact_id LEFT JOIN pays p41_ ON p41_.id = c42_.pays_id LEFT JOIN organisation o43_ ON c25_.id = o43_.dirigeant_id LEFT JOIN contact_organisation c44_ ON c25_.id = c44_.contact_id LEFT JOIN organisation o45_ ON c44_.organisation_id = o45_.id LEFT JOIN contact_support c46_ ON c25_.id = c46_.contact_id LEFT JOIN support s47_ ON c46_.support_id = s47_.id LEFT JOIN fonction f48_ ON c46_.fonction_id = f48_.id LEFT JOIN reseaux_sociaux r49_ ON c25_.reseaux_sociaux_id = r49_.id WHERE c25_.ancien_id = ?) ORDER BY c0_.id ASC LIMIT 10
Parameters: 
[
  "234858"
]
View formatted query    View runnable query    Explain query
6 3.72 ms 
SELECT c0_.id AS id_0, c0_.ancien_id AS ancien_id_1, c0_.nom AS nom_2, c0_.prenom AS prenom_3, c0_.mode_envoi_pref AS mode_envoi_pref_4, c0_.pieces_jointes AS pieces_jointes_5, c0_.contact_perso AS contact_perso_6, c0_.commentaires AS commentaires_7, c0_.objet AS objet_8, c0_.date_conclusion AS date_conclusion_9, c0_.creation AS creation_10, c0_.modification AS modification_11, a1_.id AS id_12, a1_.username AS username_13, a1_.password_mail AS password_mail_14, a1_.password AS password_15, a1_.roles AS roles_16, a1_.old_login AS old_login_17, a1_.old_password AS old_password_18, a1_.actuel AS actuel_19, a1_.fonction AS fonction_20, a1_.date_arrive AS date_arrive_21, a1_.tel_interne AS tel_interne_22, a1_.adresse_envoi AS adresse_envoi_23, a1_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_24, a1_.u_systeme AS u_systeme_25, u2_.id AS id_26, u2_.prenom AS prenom_27, u2_.nom AS nom_28, u2_.email AS email_29, u2_.resp_conge AS resp_conge_30, u2_.tel AS tel_31, c3_.id AS id_32, c3_.ancien_id AS ancien_id_33, c3_.libelle AS libelle_34, c3_.genre AS genre_35, f4_.id AS id_36, f4_.libelle AS libelle_37, f4_.ancien_id AS ancien_id_38, c5_.id AS id_39, c5_.premier_tel AS premier_tel_40, c5_.deuxieme_tel AS deuxieme_tel_41, c5_.email AS email_42, c5_.rue AS rue_43, c5_.complements AS complements_44, c5_.boite_postale AS boite_postale_45, c5_.code_postal AS code_postal_46, c5_.ville AS ville_47, c5_.premier_url AS premier_url_48, c5_.deuxieme_url AS deuxieme_url_49, c5_.creation AS creation_50, c5_.modification AS modification_51, c5_.ancien_id AS ancien_id_52, p6_.id AS id_53, p6_.libelle_fr AS libelle_fr_54, p6_.libelle_en AS libelle_en_55, p6_.iso AS iso_56, a7_.id AS id_57, a7_.username AS username_58, a7_.password_mail AS password_mail_59, a7_.password AS password_60, a7_.roles AS roles_61, a7_.old_login AS old_login_62, a7_.old_password AS old_password_63, a7_.actuel AS actuel_64, a7_.fonction AS fonction_65, a7_.date_arrive AS date_arrive_66, a7_.tel_interne AS tel_interne_67, a7_.adresse_envoi AS adresse_envoi_68, a7_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_69, a7_.u_systeme AS u_systeme_70, u8_.id AS id_71, u8_.prenom AS prenom_72, u8_.nom AS nom_73, u8_.email AS email_74, u8_.resp_conge AS resp_conge_75, u8_.tel AS tel_76, g9_.id AS id_77, g9_.libelle AS libelle_78, c10_.id AS id_79, c10_.libelle AS libelle_80, c10_.ancien_id AS ancien_id_81, s11_.id AS id_82, s11_.libelle AS libelle_83, s11_.ancien_id AS ancien_id_84, l12_.id AS id_85, l12_.libelle AS libelle_86, l12_.iso AS iso_87, p13_.id AS id_88, p13_.libelle_fr AS libelle_fr_89, p13_.libelle_en AS libelle_en_90, p13_.iso AS iso_91, o14_.id AS id_92, o14_.ancien_id AS ancien_id_93, o14_.nom AS nom_94, o14_.date_creation AS date_creation_95, o14_.siren AS siren_96, o14_.capital AS capital_97, o14_.effectif AS effectif_98, o14_.implantation AS implantation_99, o14_.commentaires AS commentaires_100, o14_.creation AS creation_101, o14_.modification AS modification_102, c15_.id AS id_103, c15_.premier_tel AS premier_tel_104, c15_.deuxieme_tel AS deuxieme_tel_105, c15_.email AS email_106, o16_.id AS id_107, o16_.ancien_id AS ancien_id_108, o16_.nom AS nom_109, o16_.date_creation AS date_creation_110, o16_.siren AS siren_111, o16_.capital AS capital_112, o16_.effectif AS effectif_113, o16_.implantation AS implantation_114, o16_.commentaires AS commentaires_115, o16_.creation AS creation_116, o16_.modification AS modification_117, c17_.id AS id_118, c17_.premier_tel AS premier_tel_119, c17_.deuxieme_tel AS deuxieme_tel_120, c17_.email AS email_121, c17_.participe AS participe_122, c17_.date_depart AS date_depart_123, c17_.commentaires AS commentaires_124, c17_.dernier_email_verif AS dernier_email_verif_125, s18_.id AS id_126, s18_.nom AS nom_127, s18_.date_parution AS date_parution_128, s18_.date_bouclage AS date_bouclage_129, s18_.audience AS audience_130, s18_.mediametrie AS mediametrie_131, s18_.ojd AS ojd_132, s18_.equiv_pub AS equiv_pub_133, s18_.precisions AS precisions_134, s18_.positionnement AS positionnement_135, s18_.cible AS cible_136, s18_.commentaires AS commentaires_137, s18_.disponibilite AS disponibilite_138, s18_.exemp_dispo AS exemp_dispo_139, s18_.ancien_id AS ancien_id_140, s18_.creation AS creation_141, s18_.modification AS modification_142, s18_.tel_standard AS tel_standard_143, s18_.tel_publicite AS tel_publicite_144, f19_.id AS id_145, f19_.libelle AS libelle_146, f19_.ancien_id AS ancien_id_147, r20_.id AS id_148, r20_.linkedin_url AS linkedin_url_149, r20_.twitter_url AS twitter_url_150, r20_.facebook_url AS facebook_url_151, c0_.auteur_id AS auteur_id_152, c0_.civilite_id AS civilite_id_153, c0_.fonction_id AS fonction_id_154, c0_.coordonnees_id AS coordonnees_id_155, c0_.genre_id AS genre_id_156, c0_.reseaux_sociaux_id AS reseaux_sociaux_id_157, a1_.user_id AS user_id_158, u2_.civilite AS civilite_159, u2_.id_adress AS id_adress_160, c5_.pays_id AS pays_id_161, c5_.auteur_id AS auteur_id_162, a7_.user_id AS user_id_163, u8_.civilite AS civilite_164, u8_.id_adress AS id_adress_165, o14_.auteur_id AS auteur_id_166, o14_.appartenir_a_id AS appartenir_a_id_167, o14_.client_id AS client_id_168, o14_.forme_juridique_id AS forme_juridique_id_169, o14_.genre_id AS genre_id_170, o14_.categorie_generale_id AS categorie_generale_id_171, o14_.coordonnees_id AS coordonnees_id_172, o14_.dirigeant_id AS dirigeant_id_173, o14_.ape_id AS ape_id_174, c15_.contact_id AS contact_id_175, c15_.organisation_id AS organisation_id_176, o16_.auteur_id AS auteur_id_177, o16_.appartenir_a_id AS appartenir_a_id_178, o16_.client_id AS client_id_179, o16_.forme_juridique_id AS forme_juridique_id_180, o16_.genre_id AS genre_id_181, o16_.categorie_generale_id AS categorie_generale_id_182, o16_.coordonnees_id AS coordonnees_id_183, o16_.dirigeant_id AS dirigeant_id_184, o16_.ape_id AS ape_id_185, c17_.contact_id AS contact_id_186, c17_.support_id AS support_id_187, c17_.fonction_id AS fonction_id_188, s18_.casier_id AS casier_id_189, s18_.type_media_id AS type_media_id_190, s18_.etat_id AS etat_id_191, s18_.organisation_id AS organisation_id_192, s18_.famille_id AS famille_id_193, s18_.periodicite_id AS periodicite_id_194, s18_.type_ojd_id AS type_ojd_id_195, s18_.zone_diffusion_id AS zone_diffusion_id_196, s18_.coordonnees_id AS coordonnees_id_197, s18_.auteur_id AS auteur_id_198, s18_.logo_support_id AS logo_support_id_199 FROM contact c0_ LEFT JOIN auth_user a1_ ON c0_.auteur_id = a1_.id LEFT JOIN user u2_ ON a1_.user_id = u2_.id LEFT JOIN civilite c3_ ON c0_.civilite_id = c3_.id LEFT JOIN fonction f4_ ON c0_.fonction_id = f4_.id LEFT JOIN coordonnees c5_ ON c0_.coordonnees_id = c5_.id LEFT JOIN pays p6_ ON c5_.pays_id = p6_.id LEFT JOIN auth_user a7_ ON c5_.auteur_id = a7_.id LEFT JOIN user u8_ ON a7_.user_id = u8_.id LEFT JOIN genre g9_ ON c0_.genre_id = g9_.id LEFT JOIN contact_categories_generales c21_ ON c0_.id = c21_.contact_id LEFT JOIN categories_generales c10_ ON c10_.id = c21_.categories_generales_id LEFT JOIN contact_sous_categories_generales c22_ ON c0_.id = c22_.contact_id LEFT JOIN sous_categories_generales s11_ ON s11_.id = c22_.sous_categories_generales_id LEFT JOIN contact_langues c23_ ON c0_.id = c23_.contact_id LEFT JOIN langues l12_ ON l12_.id = c23_.langues_id LEFT JOIN contact_pays c24_ ON c0_.id = c24_.contact_id LEFT JOIN pays p13_ ON p13_.id = c24_.pays_id LEFT JOIN organisation o14_ ON c0_.id = o14_.dirigeant_id LEFT JOIN contact_organisation c15_ ON c0_.id = c15_.contact_id LEFT JOIN organisation o16_ ON c15_.organisation_id = o16_.id LEFT JOIN contact_support c17_ ON c0_.id = c17_.contact_id LEFT JOIN support s18_ ON c17_.support_id = s18_.id LEFT JOIN fonction f19_ ON c17_.fonction_id = f19_.id LEFT JOIN reseaux_sociaux r20_ ON c0_.reseaux_sociaux_id = r20_.id WHERE c0_.id IN (SELECT c25_.id FROM contact c25_ LEFT JOIN auth_user a26_ ON c25_.auteur_id = a26_.id LEFT JOIN user u27_ ON a26_.user_id = u27_.id LEFT JOIN civilite c28_ ON c25_.civilite_id = c28_.id LEFT JOIN fonction f29_ ON c25_.fonction_id = f29_.id LEFT JOIN coordonnees c30_ ON c25_.coordonnees_id = c30_.id LEFT JOIN pays p31_ ON c30_.pays_id = p31_.id LEFT JOIN auth_user a32_ ON c30_.auteur_id = a32_.id LEFT JOIN user u33_ ON a32_.user_id = u33_.id LEFT JOIN genre g34_ ON c25_.genre_id = g34_.id LEFT JOIN contact_categories_generales c36_ ON c25_.id = c36_.contact_id LEFT JOIN categories_generales c35_ ON c35_.id = c36_.categories_generales_id LEFT JOIN contact_sous_categories_generales c38_ ON c25_.id = c38_.contact_id LEFT JOIN sous_categories_generales s37_ ON s37_.id = c38_.sous_categories_generales_id LEFT JOIN contact_langues c40_ ON c25_.id = c40_.contact_id LEFT JOIN langues l39_ ON l39_.id = c40_.langues_id LEFT JOIN contact_pays c42_ ON c25_.id = c42_.contact_id LEFT JOIN pays p41_ ON p41_.id = c42_.pays_id LEFT JOIN organisation o43_ ON c25_.id = o43_.dirigeant_id LEFT JOIN contact_organisation c44_ ON c25_.id = c44_.contact_id LEFT JOIN organisation o45_ ON c44_.organisation_id = o45_.id LEFT JOIN contact_support c46_ ON c25_.id = c46_.contact_id LEFT JOIN support s47_ ON c46_.support_id = s47_.id LEFT JOIN fonction f48_ ON c46_.fonction_id = f48_.id LEFT JOIN reseaux_sociaux r49_ ON c25_.reseaux_sociaux_id = r49_.id WHERE c25_.ancien_id = ?) AND c0_.id IN (?) ORDER BY c0_.id ASC
Parameters: 
[
  "234858"
  [
    13799
  ]
]
View formatted query    View runnable query    Explain query
7 0.38 ms 
SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.date_creation AS date_creation_4, t0.siren AS siren_5, t0.capital AS capital_6, t0.effectif AS effectif_7, t0.implantation AS implantation_8, t0.commentaires AS commentaires_9, t0.creation AS creation_10, t0.modification AS modification_11, t0.auteur_id AS auteur_id_12, t0.appartenir_a_id AS appartenir_a_id_13, t0.client_id AS client_id_14, t0.forme_juridique_id AS forme_juridique_id_15, t0.genre_id AS genre_id_16, t0.categorie_generale_id AS categorie_generale_id_17, t0.coordonnees_id AS coordonnees_id_18, t0.dirigeant_id AS dirigeant_id_19, t0.ape_id AS ape_id_20 FROM organisation t0 WHERE t0.coordonnees_id = ?
Parameters: 
[
  15401
]
View formatted query    View runnable query    Explain query
8 0.32 ms 
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.coordonnees_id = ?
Parameters: 
[
  15401
]
View formatted query    View runnable query    Explain query
9 0.68 ms 
SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.dossier AS dossier_3, t0.date_bouclage AS date_bouclage_4, t0.date_parution AS date_parution_5, t0.portrait AS portrait_6, t0.notes AS notes_7, t0.creation AS creation_8, t0.modification AS modification_9, t0.auteur_id AS auteur_id_10, t0.support_id AS support_id_11, t0.emission_id AS emission_id_12 FROM calendrier_redactionnel t0 INNER JOIN calendrier_redactionnel_contact ON t0.id = calendrier_redactionnel_contact.calendrier_redactionnel_id WHERE calendrier_redactionnel_contact.contact_id = ?
Parameters: 
[
  13799
]
View formatted query    View runnable query    Explain query
10 0.64 ms 
SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.date AS date_3, t0.titre AS titre_4, t0.commentaires AS commentaires_5, t0.niveau AS niveau_6, t0.a_paraitre AS a_paraitre_7, t0.inclure_ra AS inclure_ra_8, t0.email AS email_9, t0.telephone AS telephone_10, t0.creation AS creation_11, t0.modification AS modification_12, t0.niveau_mutualisation AS niveau_mutualisation_13, t0.suivi_par_id AS suivi_par_id_14, t0.mutualisation_id AS mutualisation_id_15, t0.contact_id AS contact_id_16, t0.type_relation_id AS type_relation_id_17, t0.vecteur_id AS vecteur_id_18, t0.statut_id AS statut_id_19, t0.auteur_id AS auteur_id_20, t0.evenement_id AS evenement_id_21 FROM suivi t0 WHERE t0.contact_id = ?
Parameters: 
[
  13799
]
View formatted query    View runnable query    Explain query
11 204.70 ms 
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM contact c0_ LEFT JOIN auth_user a1_ ON c0_.auteur_id = a1_.id LEFT JOIN user u2_ ON a1_.user_id = u2_.id LEFT JOIN civilite c3_ ON c0_.civilite_id = c3_.id LEFT JOIN fonction f4_ ON c0_.fonction_id = f4_.id LEFT JOIN coordonnees c5_ ON c0_.coordonnees_id = c5_.id LEFT JOIN pays p6_ ON c5_.pays_id = p6_.id LEFT JOIN auth_user a7_ ON c5_.auteur_id = a7_.id LEFT JOIN user u8_ ON a7_.user_id = u8_.id LEFT JOIN genre g9_ ON c0_.genre_id = g9_.id LEFT JOIN contact_categories_generales c11_ ON c0_.id = c11_.contact_id LEFT JOIN categories_generales c10_ ON c10_.id = c11_.categories_generales_id LEFT JOIN contact_sous_categories_generales c13_ ON c0_.id = c13_.contact_id LEFT JOIN sous_categories_generales s12_ ON s12_.id = c13_.sous_categories_generales_id LEFT JOIN contact_langues c15_ ON c0_.id = c15_.contact_id LEFT JOIN langues l14_ ON l14_.id = c15_.langues_id LEFT JOIN contact_pays c17_ ON c0_.id = c17_.contact_id LEFT JOIN pays p16_ ON p16_.id = c17_.pays_id LEFT JOIN organisation o18_ ON c0_.id = o18_.dirigeant_id LEFT JOIN contact_organisation c19_ ON c0_.id = c19_.contact_id LEFT JOIN organisation o20_ ON c19_.organisation_id = o20_.id LEFT JOIN contact_support c21_ ON c0_.id = c21_.contact_id LEFT JOIN support s22_ ON c21_.support_id = s22_.id LEFT JOIN fonction f23_ ON c21_.fonction_id = f23_.id LEFT JOIN reseaux_sociaux r24_ ON c0_.reseaux_sociaux_id = r24_.id WHERE c0_.id IN (SELECT c25_.id FROM contact c25_ LEFT JOIN auth_user a26_ ON c25_.auteur_id = a26_.id LEFT JOIN user u27_ ON a26_.user_id = u27_.id LEFT JOIN civilite c28_ ON c25_.civilite_id = c28_.id LEFT JOIN fonction f29_ ON c25_.fonction_id = f29_.id LEFT JOIN coordonnees c30_ ON c25_.coordonnees_id = c30_.id LEFT JOIN pays p31_ ON c30_.pays_id = p31_.id LEFT JOIN auth_user a32_ ON c30_.auteur_id = a32_.id LEFT JOIN user u33_ ON a32_.user_id = u33_.id LEFT JOIN genre g34_ ON c25_.genre_id = g34_.id LEFT JOIN contact_categories_generales c36_ ON c25_.id = c36_.contact_id LEFT JOIN categories_generales c35_ ON c35_.id = c36_.categories_generales_id LEFT JOIN contact_sous_categories_generales c38_ ON c25_.id = c38_.contact_id LEFT JOIN sous_categories_generales s37_ ON s37_.id = c38_.sous_categories_generales_id LEFT JOIN contact_langues c40_ ON c25_.id = c40_.contact_id LEFT JOIN langues l39_ ON l39_.id = c40_.langues_id LEFT JOIN contact_pays c42_ ON c25_.id = c42_.contact_id LEFT JOIN pays p41_ ON p41_.id = c42_.pays_id LEFT JOIN organisation o43_ ON c25_.id = o43_.dirigeant_id LEFT JOIN contact_organisation c44_ ON c25_.id = c44_.contact_id LEFT JOIN organisation o45_ ON c44_.organisation_id = o45_.id LEFT JOIN contact_support c46_ ON c25_.id = c46_.contact_id LEFT JOIN support s47_ ON c46_.support_id = s47_.id LEFT JOIN fonction f48_ ON c46_.fonction_id = f48_.id LEFT JOIN reseaux_sociaux r49_ ON c25_.reseaux_sociaux_id = r49_.id WHERE c25_.ancien_id = ?)
Parameters: 
[
  "234858"
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Contact No errors.
App\Entity\Civilite No errors.
App\Entity\Genre No errors.
App\Entity\Auth\AuthUser No errors.
App\Entity\Fonction No errors.
App\Entity\Coordonnees No errors.
App\Entity\Pays No errors.
App\Entity\ListeContactContact No errors.
App\Entity\ListeContact No errors.
App\Entity\CategoriesGenerales No errors.
App\Entity\SousCategoriesGenerales No errors.
App\Entity\Auth\AuthToken No errors.
App\Entity\User No errors.
App\Entity\Adresse No errors.
App\Entity\ClientRoleUser No errors.
App\Entity\Client
  • The field App\Entity\Client#evenements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Evenement#client does not contain the required 'inversedBy="evenements"' attribute.
App\Entity\AuthUserGroupeUser No errors.
App\Entity\Evenement No errors.
App\Entity\Suivi No errors.
App\Entity\Langues No errors.
App\Entity\Organisation No errors.
App\Entity\ContactOrganisation No errors.
App\Entity\ContactSupport No errors.
App\Entity\Support No errors.
App\Entity\ReseauxSociaux No errors.
App\Entity\FormeJuridique No errors.
App\Entity\CodeApe No errors.
App\Entity\Casier No errors.
App\Entity\TypeMedia No errors.
App\Entity\Etat
  • The association App\Entity\Etat#organisations refers to the owning side field App\Entity\Organisation#etat which does not exist.
App\Entity\Famille No errors.
App\Entity\Periodicite No errors.
App\Entity\TypeOJD No errors.
App\Entity\ZoneDiffusion No errors.
App\Entity\LogoSupport No errors.
App\Entity\CalendrierRedactionnel No errors.
App\Entity\Secteur No errors.
App\Entity\Emission No errors.
App\Entity\TypeRelationSuivi No errors.
App\Entity\VecteurSuivi No errors.
App\Entity\StatutSuivi No errors.
App\Entity\EvenementMetier No errors.
App\Entity\SuiviNature No errors.
App\Entity\ClientMailingCalendrierRedactionnel No errors.