Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

1.67 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	1.67 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.id = ? Parameters: [`"144"`] View formatted query View runnable query Explain query 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.id = ? 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.id = '144';

#▲

Time

Info

1.67 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.id = ?

Parameters:

[
  "144"
]

View formatted query View runnable query Explain query

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.id = ?

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.id = '144';

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\Membre	The association App\Entity\Membre#publications refers to the inverse side field App\Entity\Publications#Membre which does not exist. The association App\Entity\Membre#events refers to the owning side field App\Entity\Event#membres which does not exist.
App\Entity\TitlesMembers	No errors.
App\Entity\User	No errors.
App\Entity\Projet	No errors.
App\Entity\Publications	The mappings App\Entity\Publications#membre and App\Entity\Membre#publications are inconsistent with each other.
App\Entity\Event	No errors.

Symfony Profiler

https://regimlab.org/public/members/profile/144/SamarBouazizi

Configuration Settings

Theme