https://api.escalnet.escalconsulting.com/suivi/intranet/importation/copie/suivi/4073/185,

Query Metrics

9 Database Queries
9 Different statements
5.27 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.65 ms
(31.33%)
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.ape AS ape_19, t14.siren AS siren_20, t14.capital AS capital_21, t14.effectif AS effectif_22, t14.implantation AS implantation_23, t14.creation AS creation_24, t14.modifiation AS modifiation_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.etat_id AS etat_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 FROM client t0 LEFT JOIN organisation t14 ON t14.client_id = t0.id WHERE t0.id IN (?)
Parameters:
[
  [
    20
    312
    241
    279
    362
    350
    262
    359
    363
    268
    335
    150
    376
    378
    337
    381
    214
    366
    253
    375
    216
    361
    386
    387
    379
    133
  ]
]
0.78 ms
(14.80%)
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:
[
  129
]
0.53 ms
(10.13%)
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:
[
  "rZJSKrNnINrO3kmcnMqWgAAjqCuvfyBYfcZgN8KdMOPavzmjEht8qCg0UYhgF7F95w="
]
0.48 ms
(9.05%)
1
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.suivi_par_id AS suivi_par_id_13, t0.mutualisation_id AS mutualisation_id_14, t0.contact_id AS contact_id_15, t0.type_relation_id AS type_relation_id_16, t0.vecteur_id AS vecteur_id_17, t0.statut_id AS statut_id_18, t0.auteur_id AS auteur_id_19 FROM suivi t0 WHERE t0.id = ?
Parameters:
[
  "4073"
]
0.47 ms
(8.97%)
1
SELECT t0.id AS id_1, t0.axe AS axe_2, t0.interesse AS interesse_3, t0.sujet AS sujet_4, t0.theme_itw AS theme_itw_5, t0.interlocuteur AS interlocuteur_6, t0.raison AS raison_7, t0.commentaire AS commentaire_8, t0.date_itw AS date_itw_9, t0.suivi_id AS suivi_id_10, t0.nature_id AS nature_id_11, t0.opportunites_client_id AS opportunites_client_id_12 FROM suivi_nature t0 WHERE t0.suivi_id = ?
Parameters:
[
  4073
]
0.46 ms
(8.82%)
1
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.auteur_id AS auteur_id_13, t0.civilite_id AS civilite_id_14, t0.fonction_id AS fonction_id_15, t0.coordonnees_id AS coordonnees_id_16, t0.genre_id AS genre_id_17 FROM contact t0 WHERE t0.id = ?
Parameters:
[
  885
]
0.33 ms
(6.28%)
1
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:
[
  [
    3
  ]
]
0.28 ms
(5.37%)
1
SELECT t0.id AS id_1, t0.article AS article_2, t0.client_id AS client_id_3, t0.mailing_id AS mailing_id_4, t0.calendrier_redactionnel_id AS calendrier_redactionnel_id_5, t0.suivi_id AS suivi_id_6 FROM client_mailing_calendrier_redactionnel t0 WHERE t0.suivi_id = ?
Parameters:
[
  4073
]
0.28 ms
(5.25%)
1
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:
[
  [
    99
  ]
]

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\Auth\AuthToken No errors.
App\Entity\Auth\AuthUser No errors.
App\Entity\User No errors.
App\Entity\Civilite 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\Contact No errors.
App\Entity\Logo No errors.
App\Entity\Pressroom No errors.
App\Entity\Organisation No errors.
App\Entity\FormeJuridique No errors.
App\Entity\Etat No errors.
App\Entity\CategoriesGenerales No errors.
App\Entity\Coordonnees No errors.
App\Entity\Mailling
  • The mappings App\Entity\Mailling#partiesCp and App\Entity\PartieCp#mailling are inconsistent with each other.
App\Entity\ClientPersonne No errors.
App\Entity\MotsCles No errors.
App\Entity\Documents No errors.
App\Entity\CalendrierRedactionnel No errors.
App\Entity\TypeRelationSuivi No errors.
App\Entity\VecteurSuivi No errors.
App\Entity\StatutSuivi No errors.
App\Entity\Support No errors.
App\Entity\SuiviNature No errors.
App\Entity\ClientMailingCalendrierRedactionnel No errors.
App\Entity\Fonction No errors.
App\Entity\Genre No errors.
App\Entity\SousCategoriesGenerales No errors.
App\Entity\Langues No errors.
App\Entity\Pays No errors.
App\Entity\ContactOrganisation No errors.
App\Entity\ContactSupport No errors.
App\Entity\NatureSuivi No errors.