Query Metrics
8
Database Queries
8
Different statements
5.15 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.70 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.is_deleted AS is_deleted_3 FROM titles_members t0 WHERE t0.is_deleted = ? ORDER BY t0.id ASC
Parameters:
[
0
]
|
2 | 0.83 ms |
SELECT t0.id AS id_1, t0.presentation AS presentation_2, t0.objectifs AS objectifs_3, t0.valeurs AS valeurs_4, t0.is_deleted AS is_deleted_5 FROM presentation_labo t0 WHERE t0.is_deleted = ? ORDER BY t0.id DESC
Parameters:
[
0
]
|
3 | 1.38 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.cin AS cin_4, t0.genre AS genre_5, t0.date_naiss AS date_naiss_6, t0.last_synced_google_scholar_date AS last_synced_google_scholar_date_7, t0.tel AS tel_8, t0.email AS email_9, t0.adresse AS adresse_10, t0.statut AS statut_11, t0.universite AS universite_12, t0.etablissement AS etablissement_13, t0.equipe AS equipe_14, t0.is_deleted AS is_deleted_15, t0.dernier_diplome AS dernier_diplome_16, t0.date_diplome AS date_diplome_17, t0.etablissement_formation AS etablissement_formation_18, t0.titre_these_master AS titre_these_master_19, t0.encadreur AS encadreur_20, t0.poucentage_avancement AS poucentage_avancement_21, t0.cv_fr AS cv_fr_22, t0.cv_en AS cv_en_23, t0.scopus_id AS scopus_id_24, t0.dblplink AS dblplink_25, t0.orc_id AS orc_id_26, t0.scholar_id AS scholar_id_27, t0.res_keywords AS res_keywords_28, t0.sh_biography AS sh_biography_29, t0.photo_profil AS photo_profil_30, t0.etat AS etat_31, t0.web_page AS web_page_32, t0.linkedin AS linkedin_33, t0.creation_date AS creation_date_34, t0.modification_date AS modification_date_35, t0.validated_by_id AS validated_by_id_36, t0.headoflab AS headoflab_37, t0.doctoraldelegate AS doctoraldelegate_38, t0.titles_members_id AS titles_members_id_39, t0.user_id AS user_id_40 FROM membre t0 WHERE t0.is_deleted = ? ORDER BY t0.id DESC
Parameters:
[
0
]
|
4 | 0.55 ms |
SELECT COUNT(m0_.id) AS sclr_0 FROM membre m0_ INNER JOIN titles_members t1_ ON m0_.titles_members_id = t1_.id WHERE t1_.id = 2 AND m0_.is_deleted = 0
Parameters:
[] |
5 | 0.38 ms |
SELECT COUNT(m0_.id) AS sclr_0 FROM membre m0_ INNER JOIN titles_members t1_ ON m0_.titles_members_id = t1_.id WHERE t1_.id = 3 AND m0_.is_deleted = 0
Parameters:
[] |
6 | 0.52 ms |
SELECT COUNT(m0_.id) AS sclr_0 FROM membre m0_ INNER JOIN titles_members t1_ ON m0_.titles_members_id = t1_.id WHERE t1_.id = 6 AND m0_.is_deleted = 0
Parameters:
[] |
7 | 0.38 ms |
SELECT COUNT(m0_.id) AS sclr_0 FROM membre m0_ INNER JOIN titles_members t1_ ON m0_.titles_members_id = t1_.id WHERE t1_.id = 4 AND m0_.is_deleted = 0
Parameters:
[] |
8 | 0.40 ms |
SELECT COUNT(m0_.id) AS sclr_0 FROM membre m0_ INNER JOIN titles_members t1_ ON m0_.titles_members_id = t1_.id WHERE t1_.id = 7 AND m0_.is_deleted <> 0
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\TitlesMembers | No errors. |
App\Entity\PresentationLabo | No errors. |
App\Entity\Membre |
|
App\Entity\User | No errors. |
App\Entity\Projet | No errors. |
App\Entity\Publications |
|
App\Entity\Event | No errors. |