Query Metrics
4
Database Queries
4
Different statements
6.02 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.03 ms |
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:
[
"8"
]
|
| 2 | 0.79 ms |
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.structure_id = ? ORDER BY t0.prenom ASC
Parameters:
[
8
]
|
| 3 | 3.42 ms |
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.etat = ?
Parameters:
[
1
]
|
| 4 | 0.78 ms |
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
Parameters:
[] |
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\StructureRecherche | No errors. |
| App\Entity\Chercheur |
|
| App\Entity\Etablissement | No errors. |
| App\Entity\DomaineScientifique | No errors. |
| App\Entity\Projet | No errors. |
| App\Entity\Publication | No errors. |
| App\Entity\OffreRecherche | No errors. |
| App\Entity\Materiel | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Directeur | No errors. |