Query Metrics
28
Database Queries
10
Different statements
23.32 ms
Query time
3
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
7.91 ms (33.91%) |
1 |
SELECT s0_.id AS id_0, s0_.ancien_id AS ancien_id_1, s0_.date AS date_2, s0_.titre AS titre_3, s0_.commentaires AS commentaires_4, s0_.niveau AS niveau_5, s0_.a_paraitre AS a_paraitre_6, s0_.inclure_ra AS inclure_ra_7, s0_.email AS email_8, s0_.telephone AS telephone_9, s0_.creation AS creation_10, s0_.modification AS modification_11, s0_.niveau_mutualisation AS niveau_mutualisation_12, a1_.id AS id_13, a1_.username AS username_14, a1_.password_mail AS password_mail_15, a1_.password AS password_16, a1_.roles AS roles_17, a1_.old_login AS old_login_18, a1_.old_password AS old_password_19, a1_.actuel AS actuel_20, a1_.fonction AS fonction_21, a1_.date_arrive AS date_arrive_22, a1_.tel_interne AS tel_interne_23, a1_.adresse_envoi AS adresse_envoi_24, a1_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_25, a1_.u_systeme AS u_systeme_26, u2_.id AS id_27, u2_.prenom AS prenom_28, u2_.nom AS nom_29, u2_.email AS email_30, u2_.resp_conge AS resp_conge_31, u2_.tel AS tel_32, a3_.id AS id_33, a3_.username AS username_34, a3_.password_mail AS password_mail_35, a3_.password AS password_36, a3_.roles AS roles_37, a3_.old_login AS old_login_38, a3_.old_password AS old_password_39, a3_.actuel AS actuel_40, a3_.fonction AS fonction_41, a3_.date_arrive AS date_arrive_42, a3_.tel_interne AS tel_interne_43, a3_.adresse_envoi AS adresse_envoi_44, a3_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_45, a3_.u_systeme AS u_systeme_46, u4_.id AS id_47, u4_.prenom AS prenom_48, u4_.nom AS nom_49, u4_.email AS email_50, u4_.resp_conge AS resp_conge_51, u4_.tel AS tel_52, c5_.id AS id_53, c5_.ancien_id AS ancien_id_54, c5_.nom AS nom_55, c5_.prenom AS prenom_56, c5_.mode_envoi_pref AS mode_envoi_pref_57, c5_.pieces_jointes AS pieces_jointes_58, c5_.contact_perso AS contact_perso_59, c5_.commentaires AS commentaires_60, c5_.objet AS objet_61, c5_.date_conclusion AS date_conclusion_62, c5_.creation AS creation_63, c5_.modification AS modification_64, t6_.id AS id_65, t6_.libelle AS libelle_66, v7_.id AS id_67, v7_.libelle AS libelle_68, s8_.id AS id_69, s8_.libelle AS libelle_70, s9_.id AS id_71, s9_.nom AS nom_72, s9_.date_parution AS date_parution_73, s9_.date_bouclage AS date_bouclage_74, s9_.audience AS audience_75, s9_.mediametrie AS mediametrie_76, s9_.ojd AS ojd_77, s9_.equiv_pub AS equiv_pub_78, s9_.precisions AS precisions_79, s9_.positionnement AS positionnement_80, s9_.cible AS cible_81, s9_.commentaires AS commentaires_82, s9_.disponibilite AS disponibilite_83, s9_.exemp_dispo AS exemp_dispo_84, s9_.ancien_id AS ancien_id_85, s9_.creation AS creation_86, s9_.modification AS modification_87, s9_.tel_standard AS tel_standard_88, s9_.tel_publicite AS tel_publicite_89, s10_.id AS id_90, s10_.axe AS axe_91, s10_.interesse AS interesse_92, s10_.sujet AS sujet_93, s10_.theme_itw AS theme_itw_94, s10_.interlocuteur AS interlocuteur_95, s10_.raison AS raison_96, s10_.commentaire AS commentaire_97, s10_.date_itw AS date_itw_98, n11_.id AS id_99, n11_.libelle AS libelle_100, c12_.id AS id_101, c12_.nom AS nom_102, c12_.adresse_generique AS adresse_generique_103, c12_.adresse_coupure AS adresse_coupure_104, c12_.actuel AS actuel_105, c12_.ancien_id AS ancien_id_106, c12_.dirigeant AS dirigeant_107, c12_.date_entree AS date_entree_108, c12_.date_sortie AS date_sortie_109, c12_.duree AS duree_110, c12_.score AS score_111, c13_.id AS id_112, c13_.article AS article_113, c14_.id AS id_114, c14_.nom AS nom_115, c14_.adresse_generique AS adresse_generique_116, c14_.adresse_coupure AS adresse_coupure_117, c14_.actuel AS actuel_118, c14_.ancien_id AS ancien_id_119, c14_.dirigeant AS dirigeant_120, c14_.date_entree AS date_entree_121, c14_.date_sortie AS date_sortie_122, c14_.duree AS duree_123, c14_.score AS score_124, m15_.id AS id_125, m15_.ancien_id AS ancien_id_126, m15_.nom AS nom_127, m15_.valider_envoi AS valider_envoi_128, m15_.envoyer AS envoyer_129, m15_.resumer AS resumer_130, m15_.type_mail AS type_mail_131, m15_.en_cour AS en_cour_132, m15_.objet AS objet_133, m15_.nb_mail_envoye AS nb_mail_envoye_134, m15_.nb_mail AS nb_mail_135, m15_.modification_old AS modification_old_136, m15_.objet_cour AS objet_cour_137, m15_.resumer_cour AS resumer_cour_138, m15_.color AS color_139, m15_.titre AS titre_140, m15_.content AS content_141, m15_.date_envoi AS date_envoi_142, m15_.langue AS langue_143, m15_.debut_mail_coupure AS debut_mail_coupure_144, m15_.fin_mail_coupure AS fin_mail_coupure_145, m15_.hyperlien AS hyperlien_146, m15_.signature AS signature_147, m15_.signature_contenu AS signature_contenu_148, c16_.id AS id_149, c16_.ancien_id AS ancien_id_150, c16_.dossier AS dossier_151, c16_.date_bouclage AS date_bouclage_152, c16_.date_parution AS date_parution_153, c16_.portrait AS portrait_154, c16_.notes AS notes_155, c16_.creation AS creation_156, c16_.modification AS modification_157, a17_.id AS id_158, a17_.username AS username_159, a17_.password_mail AS password_mail_160, a17_.password AS password_161, a17_.roles AS roles_162, a17_.old_login AS old_login_163, a17_.old_password AS old_password_164, a17_.actuel AS actuel_165, a17_.fonction AS fonction_166, a17_.date_arrive AS date_arrive_167, a17_.tel_interne AS tel_interne_168, a17_.adresse_envoi AS adresse_envoi_169, a17_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_170, a17_.u_systeme AS u_systeme_171, u18_.id AS id_172, u18_.prenom AS prenom_173, u18_.nom AS nom_174, u18_.email AS email_175, u18_.resp_conge AS resp_conge_176, u18_.tel AS tel_177, e19_.id AS id_178, e19_.nom AS nom_179, e19_.ancien_id AS ancien_id_180, s0_.suivi_par_id AS suivi_par_id_181, s0_.mutualisation_id AS mutualisation_id_182, s0_.contact_id AS contact_id_183, s0_.type_relation_id AS type_relation_id_184, s0_.vecteur_id AS vecteur_id_185, s0_.statut_id AS statut_id_186, s0_.auteur_id AS auteur_id_187, s0_.evenement_id AS evenement_id_188, a1_.user_id AS user_id_189, u2_.civilite AS civilite_190, u2_.id_adress AS id_adress_191, a3_.user_id AS user_id_192, u4_.civilite AS civilite_193, u4_.id_adress AS id_adress_194, c5_.auteur_id AS auteur_id_195, c5_.civilite_id AS civilite_id_196, c5_.fonction_id AS fonction_id_197, c5_.coordonnees_id AS coordonnees_id_198, c5_.genre_id AS genre_id_199, c5_.reseaux_sociaux_id AS reseaux_sociaux_id_200, s9_.casier_id AS casier_id_201, s9_.type_media_id AS type_media_id_202, s9_.etat_id AS etat_id_203, s9_.organisation_id AS organisation_id_204, s9_.famille_id AS famille_id_205, s9_.periodicite_id AS periodicite_id_206, s9_.type_ojd_id AS type_ojd_id_207, s9_.zone_diffusion_id AS zone_diffusion_id_208, s9_.coordonnees_id AS coordonnees_id_209, s9_.auteur_id AS auteur_id_210, s9_.logo_support_id AS logo_support_id_211, s10_.suivi_id AS suivi_id_212, s10_.nature_id AS nature_id_213, s10_.opportunites_client_id AS opportunites_client_id_214, c12_.logo_id AS logo_id_215, c12_.pressroom_client AS pressroom_client_216, c12_.etat_id AS etat_id_217, c13_.client_id AS client_id_218, c13_.mailing_id AS mailing_id_219, c13_.calendrier_redactionnel_id AS calendrier_redactionnel_id_220, c13_.suivi_id AS suivi_id_221, c14_.logo_id AS logo_id_222, c14_.pressroom_client AS pressroom_client_223, c14_.etat_id AS etat_id_224, m15_.client_id AS client_id_225, m15_.envoye_par AS envoye_par_226, m15_.reply_to AS reply_to_227, m15_.pdf_id AS pdf_id_228, m15_.photo_id AS photo_id_229, m15_.logo_id AS logo_id_230, c16_.auteur_id AS auteur_id_231, c16_.support_id AS support_id_232, c16_.emission_id AS emission_id_233, a17_.user_id AS user_id_234, u18_.civilite AS civilite_235, u18_.id_adress AS id_adress_236 FROM suivi s0_ LEFT JOIN auth_user a1_ ON s0_.suivi_par_id = a1_.id LEFT JOIN user u2_ ON a1_.user_id = u2_.id LEFT JOIN auth_user a3_ ON s0_.mutualisation_id = a3_.id LEFT JOIN user u4_ ON a3_.user_id = u4_.id LEFT JOIN contact c5_ ON s0_.contact_id = c5_.id LEFT JOIN type_relation_suivi t6_ ON s0_.type_relation_id = t6_.id LEFT JOIN vecteur_suivi v7_ ON s0_.vecteur_id = v7_.id LEFT JOIN statut_suivi s8_ ON s0_.statut_id = s8_.id LEFT JOIN suivi_support s20_ ON s0_.id = s20_.suivi_id LEFT JOIN support s9_ ON s9_.id = s20_.support_id LEFT JOIN suivi_nature s10_ ON s0_.id = s10_.suivi_id LEFT JOIN nature_suivi n11_ ON s10_.nature_id = n11_.id LEFT JOIN client c12_ ON s10_.opportunites_client_id = c12_.id LEFT JOIN client_mailing_calendrier_redactionnel c13_ ON s0_.id = c13_.suivi_id LEFT JOIN client c14_ ON c13_.client_id = c14_.id LEFT JOIN mailling m15_ ON c13_.mailing_id = m15_.id LEFT JOIN calendrier_redactionnel c16_ ON c13_.calendrier_redactionnel_id = c16_.id LEFT JOIN auth_user a17_ ON s0_.auteur_id = a17_.id LEFT JOIN user u18_ ON a17_.user_id = u18_.id LEFT JOIN evenement_metier e19_ ON s0_.evenement_id = e19_.id WHERE s0_.id IN (SELECT s21_.id FROM suivi s21_ LEFT JOIN auth_user a22_ ON s21_.suivi_par_id = a22_.id LEFT JOIN user u23_ ON a22_.user_id = u23_.id LEFT JOIN auth_user a24_ ON s21_.mutualisation_id = a24_.id LEFT JOIN user u25_ ON a24_.user_id = u25_.id LEFT JOIN contact c26_ ON s21_.contact_id = c26_.id LEFT JOIN type_relation_suivi t27_ ON s21_.type_relation_id = t27_.id LEFT JOIN vecteur_suivi v28_ ON s21_.vecteur_id = v28_.id LEFT JOIN statut_suivi s29_ ON s21_.statut_id = s29_.id LEFT JOIN suivi_support s31_ ON s21_.id = s31_.suivi_id LEFT JOIN support s30_ ON s30_.id = s31_.support_id LEFT JOIN suivi_nature s32_ ON s21_.id = s32_.suivi_id LEFT JOIN nature_suivi n33_ ON s32_.nature_id = n33_.id LEFT JOIN client c34_ ON s32_.opportunites_client_id = c34_.id LEFT JOIN client_mailing_calendrier_redactionnel c35_ ON s21_.id = c35_.suivi_id LEFT JOIN client c36_ ON c35_.client_id = c36_.id LEFT JOIN mailling m37_ ON c35_.mailing_id = m37_.id LEFT JOIN calendrier_redactionnel c38_ ON c35_.calendrier_redactionnel_id = c38_.id LEFT JOIN auth_user a39_ ON s21_.auteur_id = a39_.id LEFT JOIN user u40_ ON a39_.user_id = u40_.id LEFT JOIN evenement_metier e41_ ON s21_.evenement_id = e41_.id WHERE c26_.id = ?) AND s0_.id IN (?) ORDER BY s0_.date DESC, s0_.id ASC
Parameters:
[ "2971" [ 98079 96850 96801 94997 94991 91193 9097 9084 11433 11434 ] ] |
|
3.90 ms (16.74%) |
13 |
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.client_id = ?
Parameters:
[
375
]
|
|
3.52 ms (15.11%) |
1 |
SELECT DISTINCT s0_.id AS id_0, s0_.date AS date_1, s0_.id AS id_2 FROM suivi s0_ LEFT JOIN auth_user a1_ ON s0_.suivi_par_id = a1_.id LEFT JOIN user u2_ ON a1_.user_id = u2_.id LEFT JOIN auth_user a3_ ON s0_.mutualisation_id = a3_.id LEFT JOIN user u4_ ON a3_.user_id = u4_.id LEFT JOIN contact c5_ ON s0_.contact_id = c5_.id LEFT JOIN type_relation_suivi t6_ ON s0_.type_relation_id = t6_.id LEFT JOIN vecteur_suivi v7_ ON s0_.vecteur_id = v7_.id LEFT JOIN statut_suivi s8_ ON s0_.statut_id = s8_.id LEFT JOIN suivi_support s10_ ON s0_.id = s10_.suivi_id LEFT JOIN support s9_ ON s9_.id = s10_.support_id LEFT JOIN suivi_nature s11_ ON s0_.id = s11_.suivi_id LEFT JOIN nature_suivi n12_ ON s11_.nature_id = n12_.id LEFT JOIN client c13_ ON s11_.opportunites_client_id = c13_.id LEFT JOIN client_mailing_calendrier_redactionnel c14_ ON s0_.id = c14_.suivi_id LEFT JOIN client c15_ ON c14_.client_id = c15_.id LEFT JOIN mailling m16_ ON c14_.mailing_id = m16_.id LEFT JOIN calendrier_redactionnel c17_ ON c14_.calendrier_redactionnel_id = c17_.id LEFT JOIN auth_user a18_ ON s0_.auteur_id = a18_.id LEFT JOIN user u19_ ON a18_.user_id = u19_.id LEFT JOIN evenement_metier e20_ ON s0_.evenement_id = e20_.id WHERE s0_.id IN (SELECT s21_.id FROM suivi s21_ LEFT JOIN auth_user a22_ ON s21_.suivi_par_id = a22_.id LEFT JOIN user u23_ ON a22_.user_id = u23_.id LEFT JOIN auth_user a24_ ON s21_.mutualisation_id = a24_.id LEFT JOIN user u25_ ON a24_.user_id = u25_.id LEFT JOIN contact c26_ ON s21_.contact_id = c26_.id LEFT JOIN type_relation_suivi t27_ ON s21_.type_relation_id = t27_.id LEFT JOIN vecteur_suivi v28_ ON s21_.vecteur_id = v28_.id LEFT JOIN statut_suivi s29_ ON s21_.statut_id = s29_.id LEFT JOIN suivi_support s31_ ON s21_.id = s31_.suivi_id LEFT JOIN support s30_ ON s30_.id = s31_.support_id LEFT JOIN suivi_nature s32_ ON s21_.id = s32_.suivi_id LEFT JOIN nature_suivi n33_ ON s32_.nature_id = n33_.id LEFT JOIN client c34_ ON s32_.opportunites_client_id = c34_.id LEFT JOIN client_mailing_calendrier_redactionnel c35_ ON s21_.id = c35_.suivi_id LEFT JOIN client c36_ ON c35_.client_id = c36_.id LEFT JOIN mailling m37_ ON c35_.mailing_id = m37_.id LEFT JOIN calendrier_redactionnel c38_ ON c35_.calendrier_redactionnel_id = c38_.id LEFT JOIN auth_user a39_ ON s21_.auteur_id = a39_.id LEFT JOIN user u40_ ON a39_.user_id = u40_.id LEFT JOIN evenement_metier e41_ ON s21_.evenement_id = e41_.id WHERE c26_.id = ?) ORDER BY s0_.date DESC, s0_.id ASC LIMIT 10
Parameters:
[
"2971"
]
|
|
3.40 ms (14.60%) |
1 |
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM suivi s0_ LEFT JOIN auth_user a1_ ON s0_.suivi_par_id = a1_.id LEFT JOIN user u2_ ON a1_.user_id = u2_.id LEFT JOIN auth_user a3_ ON s0_.mutualisation_id = a3_.id LEFT JOIN user u4_ ON a3_.user_id = u4_.id LEFT JOIN contact c5_ ON s0_.contact_id = c5_.id LEFT JOIN type_relation_suivi t6_ ON s0_.type_relation_id = t6_.id LEFT JOIN vecteur_suivi v7_ ON s0_.vecteur_id = v7_.id LEFT JOIN statut_suivi s8_ ON s0_.statut_id = s8_.id LEFT JOIN suivi_support s10_ ON s0_.id = s10_.suivi_id LEFT JOIN support s9_ ON s9_.id = s10_.support_id LEFT JOIN suivi_nature s11_ ON s0_.id = s11_.suivi_id LEFT JOIN nature_suivi n12_ ON s11_.nature_id = n12_.id LEFT JOIN client c13_ ON s11_.opportunites_client_id = c13_.id LEFT JOIN client_mailing_calendrier_redactionnel c14_ ON s0_.id = c14_.suivi_id LEFT JOIN client c15_ ON c14_.client_id = c15_.id LEFT JOIN mailling m16_ ON c14_.mailing_id = m16_.id LEFT JOIN calendrier_redactionnel c17_ ON c14_.calendrier_redactionnel_id = c17_.id LEFT JOIN auth_user a18_ ON s0_.auteur_id = a18_.id LEFT JOIN user u19_ ON a18_.user_id = u19_.id LEFT JOIN evenement_metier e20_ ON s0_.evenement_id = e20_.id WHERE s0_.id IN (SELECT s21_.id FROM suivi s21_ LEFT JOIN auth_user a22_ ON s21_.suivi_par_id = a22_.id LEFT JOIN user u23_ ON a22_.user_id = u23_.id LEFT JOIN auth_user a24_ ON s21_.mutualisation_id = a24_.id LEFT JOIN user u25_ ON a24_.user_id = u25_.id LEFT JOIN contact c26_ ON s21_.contact_id = c26_.id LEFT JOIN type_relation_suivi t27_ ON s21_.type_relation_id = t27_.id LEFT JOIN vecteur_suivi v28_ ON s21_.vecteur_id = v28_.id LEFT JOIN statut_suivi s29_ ON s21_.statut_id = s29_.id LEFT JOIN suivi_support s31_ ON s21_.id = s31_.suivi_id LEFT JOIN support s30_ ON s30_.id = s31_.support_id LEFT JOIN suivi_nature s32_ ON s21_.id = s32_.suivi_id LEFT JOIN nature_suivi n33_ ON s32_.nature_id = n33_.id LEFT JOIN client c34_ ON s32_.opportunites_client_id = c34_.id LEFT JOIN client_mailing_calendrier_redactionnel c35_ ON s21_.id = c35_.suivi_id LEFT JOIN client c36_ ON c35_.client_id = c36_.id LEFT JOIN mailling m37_ ON c35_.mailing_id = m37_.id LEFT JOIN calendrier_redactionnel c38_ ON c35_.calendrier_redactionnel_id = c38_.id LEFT JOIN auth_user a39_ ON s21_.auteur_id = a39_.id LEFT JOIN user u40_ ON a39_.user_id = u40_.id LEFT JOIN evenement_metier e41_ ON s21_.evenement_id = e41_.id WHERE c26_.id = ?)
Parameters:
[
"2971"
]
|
|
1.37 ms (5.90%) |
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, t0.id_user AS id_user_22 FROM client_role_user t0 LEFT JOIN client t7 ON t0.id_client = t7.id WHERE t0.id_user = ?
Parameters:
[
158
]
|
|
1.05 ms (4.50%) |
4 |
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:
[
[
138
]
]
|
|
0.60 ms (2.56%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse_generique AS adresse_generique_3, t0.adresse_coupure AS adresse_coupure_4, t0.actuel AS actuel_5, t0.ancien_id AS ancien_id_6, t0.dirigeant AS dirigeant_7, t0.date_entree AS date_entree_8, t0.date_sortie AS date_sortie_9, t0.duree AS duree_10, t0.score AS score_11, t0.logo_id AS logo_id_12, t0.pressroom_client AS pressroom_client_13, t14.id AS id_15, t14.ancien_id AS ancien_id_16, t14.nom AS nom_17, t14.date_creation AS date_creation_18, t14.siren AS siren_19, t14.capital AS capital_20, t14.effectif AS effectif_21, t14.implantation AS implantation_22, t14.commentaires AS commentaires_23, t14.creation AS creation_24, t14.modification AS modification_25, t14.auteur_id AS auteur_id_26, t14.appartenir_a_id AS appartenir_a_id_27, t14.client_id AS client_id_28, t14.forme_juridique_id AS forme_juridique_id_29, t14.genre_id AS genre_id_30, t14.categorie_generale_id AS categorie_generale_id_31, t14.coordonnees_id AS coordonnees_id_32, t14.dirigeant_id AS dirigeant_id_33, t14.ape_id AS ape_id_34, t0.etat_id AS etat_id_35 FROM client t0 LEFT JOIN organisation t14 ON t14.client_id = t0.id WHERE t0.id IN (?)
Parameters:
[
[
411
399
168
321
396
420
]
]
|
|
0.59 ms (2.51%) |
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, 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:
[
169
]
|
|
0.58 ms (2.47%) |
2 |
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:
[
[
1
]
]
|
|
0.40 ms (1.70%) |
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 = ? LIMIT 1
Parameters:
[
"Zs07tFK8ie3Ml6Sbz7zjVAEobXh3ZQVU0BH3msQxmLhg4ayznutfNvDF6kjIdP4Qc="
]
|
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\Suivi | No errors. |
| App\Entity\TypeRelationSuivi | No errors. |
| App\Entity\SuiviNature | No errors. |
| App\Entity\NatureSuivi | No errors. |
| App\Entity\VecteurSuivi | No errors. |
| App\Entity\StatutSuivi | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\Auth\AuthUser | No errors. |
| App\Entity\ClientMailingCalendrierRedactionnel | No errors. |
| App\Entity\Client |
|
| App\Entity\ContactOrganisation | No errors. |
| App\Entity\Organisation | No errors. |
| App\Entity\ContactSupport | No errors. |
| App\Entity\Support | No errors. |
| App\Entity\Auth\AuthToken | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Civilite | No errors. |
| App\Entity\Adresse | No errors. |
| App\Entity\ClientRoleUser | No errors. |
| App\Entity\AuthUserGroupeUser | No errors. |
| App\Entity\Evenement | No errors. |
| App\Entity\Logo | No errors. |
| App\Entity\Pressroom | No errors. |
| App\Entity\FormeJuridique | No errors. |
| App\Entity\Genre | No errors. |
| App\Entity\CategoriesGenerales | No errors. |
| App\Entity\Coordonnees | No errors. |
| App\Entity\CodeApe | No errors. |
| App\Entity\Etat |
|
| App\Entity\Mailling |
|
| App\Entity\ClientPersonne | No errors. |
| App\Entity\MotsCles | No errors. |
| App\Entity\Documents | No errors. |
| App\Entity\CalendrierRedactionnel | No errors. |
| App\Entity\Membre | No errors. |
| App\Entity\Emission | No errors. |
| App\Entity\ListeOrganisationOrganisation | No errors. |
| App\Entity\EvenementMetier | No errors. |
| App\Entity\Fonction | No errors. |
| App\Entity\ReseauxSociaux | No errors. |
| App\Entity\Casier | No errors. |
| App\Entity\TypeMedia | No errors. |
| 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\Pdf | No errors. |
| App\Entity\PhotoMailling | No errors. |
| App\Entity\LogoMailling | No errors. |
| App\Entity\SousCategoriesGenerales | No errors. |
| App\Entity\Langues | No errors. |
| App\Entity\Pays | No errors. |
| App\Entity\ListeContactContact | No errors. |
| App\Entity\NatureTypeRelationSuivi | No errors. |
| App\Entity\NatureVecteurSuivi | No errors. |
| App\Entity\Secteur | No errors. |