Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

18.39 ms Query time

22 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	18.39 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.user_type AS user_type_8, t0.is_verified AS is_verified_9, t0.matricule AS matricule_10, t0.full_name AS full_name_11, t0.last_request_ts AS last_request_ts_12, t0.theme AS theme_13, t0.picture AS picture_14, t0.sexe AS sexe_15, t0.local_phone_lang AS local_phone_lang_16, t0.user_token AS user_token_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.author_id AS author_id_20, t0.editor_id AS editor_id_21, t0.school_id AS school_id_22 FROM `user` t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.user_type AS user_type_8, t0.is_verified AS is_verified_9, t0.matricule AS matricule_10, t0.full_name AS full_name_11, t0.last_request_ts AS last_request_ts_12, t0.theme AS theme_13, t0.picture AS picture_14, t0.sexe AS sexe_15, t0.local_phone_lang AS local_phone_lang_16, t0.user_token AS user_token_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.author_id AS author_id_20, t0.editor_id AS editor_id_21, t0.school_id AS school_id_22 FROM `user` t0 SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.user_type AS user_type_8, t0.is_verified AS is_verified_9, t0.matricule AS matricule_10, t0.full_name AS full_name_11, t0.last_request_ts AS last_request_ts_12, t0.theme AS theme_13, t0.picture AS picture_14, t0.sexe AS sexe_15, t0.local_phone_lang AS local_phone_lang_16, t0.user_token AS user_token_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.author_id AS author_id_20, t0.editor_id AS editor_id_21, t0.school_id AS school_id_22 FROM `user` t0;

#▲

Time

Info

18.39 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.user_type AS user_type_8, t0.is_verified AS is_verified_9, t0.matricule AS matricule_10, t0.full_name AS full_name_11, t0.last_request_ts AS last_request_ts_12, t0.theme AS theme_13, t0.picture AS picture_14, t0.sexe AS sexe_15, t0.local_phone_lang AS local_phone_lang_16, t0.user_token AS user_token_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.author_id AS author_id_20, t0.editor_id AS editor_id_21, t0.school_id AS school_id_22 FROM `user` t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.phone AS phone_7,
  t0.user_type AS user_type_8,
  t0.is_verified AS is_verified_9,
  t0.matricule AS matricule_10,
  t0.full_name AS full_name_11,
  t0.last_request_ts AS last_request_ts_12,
  t0.theme AS theme_13,
  t0.picture AS picture_14,
  t0.sexe AS sexe_15,
  t0.local_phone_lang AS local_phone_lang_16,
  t0.user_token AS user_token_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.author_id AS author_id_20,
  t0.editor_id AS editor_id_21,
  t0.school_id AS school_id_22
FROM
  `user` t0

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.user_type AS user_type_8, t0.is_verified AS is_verified_9, t0.matricule AS matricule_10, t0.full_name AS full_name_11, t0.last_request_ts AS last_request_ts_12, t0.theme AS theme_13, t0.picture AS picture_14, t0.sexe AS sexe_15, t0.local_phone_lang AS local_phone_lang_16, t0.user_token AS user_token_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.author_id AS author_id_20, t0.editor_id AS editor_id_21, t0.school_id AS school_id_22 FROM `user` t0;

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\User	No errors.
App\Entity\School	The mappings App\Entity\School#agendaTimeConvertion and App\Entity\AgendaTimeConvertion#school are inconsistent with each other.
App\Entity\News	No errors.
App\Entity\Event	No errors.
App\Entity\UserYear	No errors.
App\Entity\Subject	No errors.
App\Entity\Student	The mappings App\Entity\Student#punishes and App\Entity\Punish#student are inconsistent with each other.
App\Entity\HomeWork	No errors.
App\Entity\Chat	The mappings App\Entity\Chat#recipient and App\Entity\User#chats are inconsistent with each other.
App\Entity\Message	The association App\Entity\Message#author refers to the inverse side field App\Entity\UserYear#messages which does not exist.
App\Entity\DocInfo	No errors.
App\Entity\Discussion	The mappings App\Entity\Discussion#userB and App\Entity\User#discussions are inconsistent with each other.
App\Entity\DiscussionMessage	The mappings App\Entity\DiscussionMessage#messageFor and App\Entity\User#discussionMessages are inconsistent with each other.
App\Entity\Notifications	The association App\Entity\Notifications#year refers to the inverse side field App\Entity\SchoolYear#notifications which does not exist.
App\Entity\Absence	No errors.
App\Entity\CategoryEvent	No errors.
App\Entity\ClassYear	The association App\Entity\ClassYear#class refers to the inverse side field App\Entity\TheClass#classYears which does not exist. The field App\Entity\ClassYear#chats is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Chat#classes does not contain the required 'inversedBy="chats"' attribute.
App\Entity\Exams	No errors.
App\Entity\Late	No errors.
App\Entity\NewsCategory	No errors.
App\Entity\Note	No errors.
App\Entity\SchoolSection	No errors.
App\Entity\SchoolYear	The mappings App\Entity\SchoolYear#agendaTimeConvertion and App\Entity\AgendaTimeConvertion#year are inconsistent with each other.
App\Entity\SubjectGroup	No errors.
App\Entity\TheClass	The mappings App\Entity\TheClass#studentsYears and App\Entity\StudentYear#classe are inconsistent with each other. The association App\Entity\TheClass#userYears refers to the owning side field App\Entity\UserYear#classes which does not exist. The association App\Entity\TheClass#quarters refers to the owning side field App\Entity\Quarter#classe which does not exist.
App\Entity\Punish	The association App\Entity\Punish#student refers to the inverse side field App\Entity\Student#punishDetails which does not exist.
App\Entity\PunishCategory	No errors.
App\Entity\DiscussionClassMessage	No errors.
App\Entity\Agenda	The association App\Entity\Agenda#classe refers to the inverse side field App\Entity\TheClass#agendas which does not exist. The association App\Entity\Agenda#agendaDays refers to the owning side field App\Entity\AgendaDay#agenda which does not exist.
App\Entity\ExamAgenda	No errors.
App\Entity\SubSequence	No errors.
App\Entity\Quarter	No errors.
App\Entity\SubNote	No errors.
App\Entity\AgendaDay	No errors.
App\Entity\AgendaElement	No errors.
App\Entity\ExamAgendaDay	No errors.
App\Entity\ExamAgendaElement	No errors.
App\Entity\Appreciation	No errors.
App\Entity\LocalAccount	The mappings App\Entity\LocalAccount#account and App\Entity\User#localAccounts are inconsistent with each other.
App\Entity\NewsBookmark	The association App\Entity\NewsBookmark#year refers to the inverse side field App\Entity\SchoolYear#newsBookmarks which does not exist.
App\Entity\HomeworkBookmark	The association App\Entity\HomeworkBookmark#year refers to the inverse side field App\Entity\SchoolYear#homeworkBookmarks which does not exist.
App\Entity\ScolarityHistory	The mappings App\Entity\ScolarityHistory#editor and App\Entity\User#scolarityHistories are inconsistent with each other.
App\Entity\ScolarityHistoryEdition	No errors.
App\Entity\JustifyAbsence	No errors.
App\Entity\VerbalProcess	The mappings App\Entity\VerbalProcess#editor and App\Entity\User#verbalProcesses are inconsistent with each other.
App\Entity\AbsenceDisciplineConcileConfig	The mappings App\Entity\AbsenceDisciplineConcileConfig#editor and App\Entity\User#absenceDisciplineConcileConfigs are inconsistent with each other.
App\Entity\PrimaryNote	The mappings App\Entity\PrimaryNote#editor and App\Entity\User#primaryNotes are inconsistent with each other.
App\Entity\VerbalProcessCategory	The association App\Entity\VerbalProcessCategory#verbalProcess refers to the owning side field App\Entity\VerbalProcess#verbalProcessCategory which does not exist.
App\Entity\UserAndroidToken	No errors.
App\Entity\UserIphoneToken	No errors.
App\Entity\AbsenceBlameConfig	No errors.
App\Entity\AbsenceWarningConfig	No errors.
App\Entity\AbsencePunishConfig	No errors.
App\Entity\AbsenceExclusionConfig	No errors.
App\Entity\GlobalDisciplineEnabledConfig	No errors.
App\Entity\AbsenceRetainedConfig	No errors.
App\Entity\DisciplineConcile	The mappings App\Entity\DisciplineConcile#editor and App\Entity\User#disciplineConciles are inconsistent with each other.
App\Entity\RefreshToken	No errors.
App\Entity\UserNotification	No errors.
App\Entity\AgendaTimeConvertion	The association App\Entity\AgendaTimeConvertion#school refers to the inverse side field App\Entity\School#agendaTimeConvertions which does not exist. The association App\Entity\AgendaTimeConvertion#year refers to the inverse side field App\Entity\SchoolYear#agendaTimeConvertions which does not exist.
App\Entity\Competence	No errors.
App\Entity\ProfTime	No errors.

Symfony Profiler

https://college-prive-bilingue-shekinah.com/prof/parent/note/new/133/15/2

Configuration Settings

Theme