https://regimlab.org/public/

Query Metrics

7 Database Queries
7 Different statements
10.66 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 1.08 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.is_deleted AS is_deleted_6, t0.piece_joindre AS piece_joindre_7, t0.created_by AS created_by_8 FROM article t0 WHERE t0.is_deleted = ? ORDER BY t0.created_at DESC
Parameters:
[
  0
]
2 0.67 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.lien AS lien_3, t0.is_deleted AS is_deleted_4 FROM lien_utils t0 WHERE t0.is_deleted = ? ORDER BY t0.id DESC
Parameters:
[
  0
]
3 0.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.link AS link_4, t0.type AS type_5, t0.is_deleted AS is_deleted_6, t0.priority AS priority_7 FROM partner t0 WHERE t0.is_deleted = ? ORDER BY t0.id DESC
Parameters:
[
  0
]
4 2.32 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 = ?
Parameters:
[
  0
]
5 4.86 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.link AS link_3, t0.authors AS authors_4, t0.venue AS venue_5, t0.citations AS citations_6, t0.year AS year_7 FROM publications t0
Parameters:
[]
6 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.link AS link_4, t0.type AS type_5, t0.is_deleted AS is_deleted_6, t0.priority AS priority_7 FROM partner t0 WHERE t0.is_deleted = ?
Parameters:
[
  0
]
7 0.63 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.type AS type_3, t0.is_deleted AS is_deleted_4, t0.date AS date_5, t0.time AS time_6 FROM manifestation t0 WHERE t0.is_deleted = ?
Parameters:
[
  0
]

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