GET https://www.ujrecherche.progresstn.com/178/chercheur/details

Query Metrics

3 Database Queries
3 Different statements
6.27 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.59 ms
(57.32%)
1
SELECT t0.id AS id_1, t0.nom_long AS nom_long_2, t0.nom_court AS nom_court_3, t0.nom_arabe AS nom_arabe_4, t0.type AS type_5, t0.etat AS etat_6, t0.adresse AS adresse_7, t0.email AS email_8, t0.site_web AS site_web_9, t0.logo AS logo_10, t0.description AS description_11, t0.code AS code_12, t0.image1 AS image1_13, t0.image2 AS image2_14, t0.image3 AS image3_15, t0.doc_pdf AS doc_pdf_16, t0.nom_doc_pdf AS nom_doc_pdf_17, t0.responsable_id AS responsable_id_18, t0.etablissement_id AS etablissement_id_19, t0.domaine_id AS domaine_id_20 FROM structure_recherche t0 WHERE t0.id = ?
Parameters:
[
  5
]
1.73 ms
(27.53%)
1
SELECT t0.id AS id_1, t0.cin AS cin_2, t0.date_naissance AS date_naissance_3, t0.grade AS grade_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.email AS email_7, t0.photo AS photo_8, t0.specialite AS specialite_9, t0.biography AS biography_10, t0.linkedin AS linkedin_11, t0.orcid AS orcid_12, t0.p_google AS p_google_13, t0.p_scopus AS p_scopus_14, t0.fonction AS fonction_15, t0.p_web_science AS p_web_science_16, t0.resarchgate AS resarchgate_17, t0.masteres_recherches AS masteres_recherches_18, t0.theses_doctorat AS theses_doctorat_19, t0.date_debut AS date_debut_20, t0.date_fin AS date_fin_21, t0.projet_nationaux_iternationaux AS projet_nationaux_iternationaux_22, t0.brevet_nationaux_internationaux AS brevet_nationaux_internationaux_23, t0.autre_activites AS autre_activites_24, t0.etablissement_enseignement AS etablissement_enseignement_25, t0.etat_cin AS etat_cin_26, t0.etat_naissance AS etat_naissance_27, t0.etat_phone AS etat_phone_28, t0.etablissement_id AS etablissement_id_29, t0.user_id AS user_id_30, t0.structure_id AS structure_id_31 FROM chercheur t0 WHERE t0.id = ?
Parameters:
[
  "178"
]
0.95 ms
(15.14%)
1
SELECT t0.id AS id_1, t0.nom_court AS nom_court_2, t0.nom_long AS nom_long_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.site_web AS site_web_6, t0.telephone AS telephone_7, t0.fax AS fax_8, t0.description AS description_9, t0.nom_arabe AS nom_arabe_10, t0.logo AS logo_11, t0.image1 AS image1_12, t0.image2 AS image2_13, t0.image3 AS image3_14 FROM etablissement t0 WHERE t0.id = ?
Parameters:
[
  3
]

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\Chercheur
  • The association App\Entity\Chercheur#membreProjet refers to the owning side field App\Entity\Projet#membres which does not exist.
App\Entity\Etablissement No errors.
App\Entity\User No errors.
App\Entity\StructureRecherche No errors.
App\Entity\Projet No errors.
App\Entity\Membre No errors.
App\Entity\Auteur No errors.
App\Entity\Directeur No errors.
App\Entity\DomaineScientifique No errors.
App\Entity\Publication No errors.
App\Entity\OffreRecherche No errors.
App\Entity\Materiel No errors.