Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

2 Different statements

1.69 ms Query time

17 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.71 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.name_en AS name_en_4, t0.level AS level_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.author_id AS author_id_8, t0.editor_id AS editor_id_9, t10.id AS id_11, t10.time AS time_12, t10.start_school_time AS start_school_time_13, t10.arrive_school_time AS arrive_school_time_14, t10.first_break_start_at AS first_break_start_at_15, t10.first_break_end_at AS first_break_end_at_16, t10.second_break_start_at AS second_break_start_at_17, t10.second_break_end_at AS second_break_end_at_18, t10.school_id AS school_id_19, t10.year_id AS year_id_20, t10.author_id AS author_id_21 FROM school_year t0 LEFT JOIN agenda_time_convertion t10 ON t10.year_id = t0.id WHERE t0.active = ? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.name_en AS name_en_4, t0.level AS level_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.author_id AS author_id_8, t0.editor_id AS editor_id_9, t10.id AS id_11, t10.time AS time_12, t10.start_school_time AS start_school_time_13, t10.arrive_school_time AS arrive_school_time_14, t10.first_break_start_at AS first_break_start_at_15, t10.first_break_end_at AS first_break_end_at_16, t10.second_break_start_at AS second_break_start_at_17, t10.second_break_end_at AS second_break_end_at_18, t10.school_id AS school_id_19, t10.year_id AS year_id_20, t10.author_id AS author_id_21 FROM school_year t0 LEFT JOIN agenda_time_convertion t10 ON t10.year_id = t0.id WHERE t0.active = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.name_en AS name_en_4, t0.level AS level_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.author_id AS author_id_8, t0.editor_id AS editor_id_9, t10.id AS id_11, t10.time AS time_12, t10.start_school_time AS start_school_time_13, t10.arrive_school_time AS arrive_school_time_14, t10.first_break_start_at AS first_break_start_at_15, t10.first_break_end_at AS first_break_end_at_16, t10.second_break_start_at AS second_break_start_at_17, t10.second_break_end_at AS second_break_end_at_18, t10.school_id AS school_id_19, t10.year_id AS year_id_20, t10.author_id AS author_id_21 FROM school_year t0 LEFT JOIN agenda_time_convertion t10 ON t10.year_id = t0.id WHERE t0.active = 1 LIMIT 1;
2	0.67 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.name_en AS name_en_4, t0.level AS level_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.author_id AS author_id_8, t0.editor_id AS editor_id_9, t10.id AS id_11, t10.time AS time_12, t10.start_school_time AS start_school_time_13, t10.arrive_school_time AS arrive_school_time_14, t10.first_break_start_at AS first_break_start_at_15, t10.first_break_end_at AS first_break_end_at_16, t10.second_break_start_at AS second_break_start_at_17, t10.second_break_end_at AS second_break_end_at_18, t10.school_id AS school_id_19, t10.year_id AS year_id_20, t10.author_id AS author_id_21 FROM school_year t0 LEFT JOIN agenda_time_convertion t10 ON t10.year_id = t0.id WHERE t0.active = ? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.name_en AS name_en_4, t0.level AS level_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.author_id AS author_id_8, t0.editor_id AS editor_id_9, t10.id AS id_11, t10.time AS time_12, t10.start_school_time AS start_school_time_13, t10.arrive_school_time AS arrive_school_time_14, t10.first_break_start_at AS first_break_start_at_15, t10.first_break_end_at AS first_break_end_at_16, t10.second_break_start_at AS second_break_start_at_17, t10.second_break_end_at AS second_break_end_at_18, t10.school_id AS school_id_19, t10.year_id AS year_id_20, t10.author_id AS author_id_21 FROM school_year t0 LEFT JOIN agenda_time_convertion t10 ON t10.year_id = t0.id WHERE t0.active = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.name_en AS name_en_4, t0.level AS level_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.author_id AS author_id_8, t0.editor_id AS editor_id_9, t10.id AS id_11, t10.time AS time_12, t10.start_school_time AS start_school_time_13, t10.arrive_school_time AS arrive_school_time_14, t10.first_break_start_at AS first_break_start_at_15, t10.first_break_end_at AS first_break_end_at_16, t10.second_break_start_at AS second_break_start_at_17, t10.second_break_end_at AS second_break_end_at_18, t10.school_id AS school_id_19, t10.year_id AS year_id_20, t10.author_id AS author_id_21 FROM school_year t0 LEFT JOIN agenda_time_convertion t10 ON t10.year_id = t0.id WHERE t0.active = 1 LIMIT 1;
3	0.31 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.name_en AS name_en_4, t0.level AS level_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.author_id AS author_id_8, t0.editor_id AS editor_id_9, t10.id AS id_11, t10.time AS time_12, t10.start_school_time AS start_school_time_13, t10.arrive_school_time AS arrive_school_time_14, t10.first_break_start_at AS first_break_start_at_15, t10.first_break_end_at AS first_break_end_at_16, t10.second_break_start_at AS second_break_start_at_17, t10.second_break_end_at AS second_break_end_at_18, t10.school_id AS school_id_19, t10.year_id AS year_id_20, t10.author_id AS author_id_21 FROM school_year t0 LEFT JOIN agenda_time_convertion t10 ON t10.year_id = t0.id ORDER BY t0.id DESC Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.name_en AS name_en_4, t0.level AS level_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.author_id AS author_id_8, t0.editor_id AS editor_id_9, t10.id AS id_11, t10.time AS time_12, t10.start_school_time AS start_school_time_13, t10.arrive_school_time AS arrive_school_time_14, t10.first_break_start_at AS first_break_start_at_15, t10.first_break_end_at AS first_break_end_at_16, t10.second_break_start_at AS second_break_start_at_17, t10.second_break_end_at AS second_break_end_at_18, t10.school_id AS school_id_19, t10.year_id AS year_id_20, t10.author_id AS author_id_21 FROM school_year t0 LEFT JOIN agenda_time_convertion t10 ON t10.year_id = t0.id ORDER BY t0.id DESC SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.name_en AS name_en_4, t0.level AS level_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.author_id AS author_id_8, t0.editor_id AS editor_id_9, t10.id AS id_11, t10.time AS time_12, t10.start_school_time AS start_school_time_13, t10.arrive_school_time AS arrive_school_time_14, t10.first_break_start_at AS first_break_start_at_15, t10.first_break_end_at AS first_break_end_at_16, t10.second_break_start_at AS second_break_start_at_17, t10.second_break_end_at AS second_break_end_at_18, t10.school_id AS school_id_19, t10.year_id AS year_id_20, t10.author_id AS author_id_21 FROM school_year t0 LEFT JOIN agenda_time_convertion t10 ON t10.year_id = t0.id ORDER BY t0.id DESC;

#▲

Time

Info

0.71 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.name_en AS name_en_4, t0.level AS level_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.author_id AS author_id_8, t0.editor_id AS editor_id_9, t10.id AS id_11, t10.time AS time_12, t10.start_school_time AS start_school_time_13, t10.arrive_school_time AS arrive_school_time_14, t10.first_break_start_at AS first_break_start_at_15, t10.first_break_end_at AS first_break_end_at_16, t10.second_break_start_at AS second_break_start_at_17, t10.second_break_end_at AS second_break_end_at_18, t10.school_id AS school_id_19, t10.year_id AS year_id_20, t10.author_id AS author_id_21 FROM school_year t0 LEFT JOIN agenda_time_convertion t10 ON t10.year_id = t0.id WHERE t0.active = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.name_en AS name_en_4,
  t0.level AS level_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.author_id AS author_id_8,
  t0.editor_id AS editor_id_9,
  t10.id AS id_11,
  t10.time AS time_12,
  t10.start_school_time AS start_school_time_13,
  t10.arrive_school_time AS arrive_school_time_14,
  t10.first_break_start_at AS first_break_start_at_15,
  t10.first_break_end_at AS first_break_end_at_16,
  t10.second_break_start_at AS second_break_start_at_17,
  t10.second_break_end_at AS second_break_end_at_18,
  t10.school_id AS school_id_19,
  t10.year_id AS year_id_20,
  t10.author_id AS author_id_21
FROM
  school_year t0
  LEFT JOIN agenda_time_convertion t10 ON t10.year_id = t0.id
WHERE
  t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.name_en AS name_en_4, t0.level AS level_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.author_id AS author_id_8, t0.editor_id AS editor_id_9, t10.id AS id_11, t10.time AS time_12, t10.start_school_time AS start_school_time_13, t10.arrive_school_time AS arrive_school_time_14, t10.first_break_start_at AS first_break_start_at_15, t10.first_break_end_at AS first_break_end_at_16, t10.second_break_start_at AS second_break_start_at_17, t10.second_break_end_at AS second_break_end_at_18, t10.school_id AS school_id_19, t10.year_id AS year_id_20, t10.author_id AS author_id_21 FROM school_year t0 LEFT JOIN agenda_time_convertion t10 ON t10.year_id = t0.id WHERE t0.active = 1 LIMIT 1;

0.67 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.name_en AS name_en_4, t0.level AS level_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.author_id AS author_id_8, t0.editor_id AS editor_id_9, t10.id AS id_11, t10.time AS time_12, t10.start_school_time AS start_school_time_13, t10.arrive_school_time AS arrive_school_time_14, t10.first_break_start_at AS first_break_start_at_15, t10.first_break_end_at AS first_break_end_at_16, t10.second_break_start_at AS second_break_start_at_17, t10.second_break_end_at AS second_break_end_at_18, t10.school_id AS school_id_19, t10.year_id AS year_id_20, t10.author_id AS author_id_21 FROM school_year t0 LEFT JOIN agenda_time_convertion t10 ON t10.year_id = t0.id WHERE t0.active = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.name_en AS name_en_4,
  t0.level AS level_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.author_id AS author_id_8,
  t0.editor_id AS editor_id_9,
  t10.id AS id_11,
  t10.time AS time_12,
  t10.start_school_time AS start_school_time_13,
  t10.arrive_school_time AS arrive_school_time_14,
  t10.first_break_start_at AS first_break_start_at_15,
  t10.first_break_end_at AS first_break_end_at_16,
  t10.second_break_start_at AS second_break_start_at_17,
  t10.second_break_end_at AS second_break_end_at_18,
  t10.school_id AS school_id_19,
  t10.year_id AS year_id_20,
  t10.author_id AS author_id_21
FROM
  school_year t0
  LEFT JOIN agenda_time_convertion t10 ON t10.year_id = t0.id
WHERE
  t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.name_en AS name_en_4, t0.level AS level_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.author_id AS author_id_8, t0.editor_id AS editor_id_9, t10.id AS id_11, t10.time AS time_12, t10.start_school_time AS start_school_time_13, t10.arrive_school_time AS arrive_school_time_14, t10.first_break_start_at AS first_break_start_at_15, t10.first_break_end_at AS first_break_end_at_16, t10.second_break_start_at AS second_break_start_at_17, t10.second_break_end_at AS second_break_end_at_18, t10.school_id AS school_id_19, t10.year_id AS year_id_20, t10.author_id AS author_id_21 FROM school_year t0 LEFT JOIN agenda_time_convertion t10 ON t10.year_id = t0.id WHERE t0.active = 1 LIMIT 1;

0.31 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.name_en AS name_en_4, t0.level AS level_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.author_id AS author_id_8, t0.editor_id AS editor_id_9, t10.id AS id_11, t10.time AS time_12, t10.start_school_time AS start_school_time_13, t10.arrive_school_time AS arrive_school_time_14, t10.first_break_start_at AS first_break_start_at_15, t10.first_break_end_at AS first_break_end_at_16, t10.second_break_start_at AS second_break_start_at_17, t10.second_break_end_at AS second_break_end_at_18, t10.school_id AS school_id_19, t10.year_id AS year_id_20, t10.author_id AS author_id_21 FROM school_year t0 LEFT JOIN agenda_time_convertion t10 ON t10.year_id = t0.id ORDER BY t0.id DESC

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.name_en AS name_en_4,
  t0.level AS level_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.author_id AS author_id_8,
  t0.editor_id AS editor_id_9,
  t10.id AS id_11,
  t10.time AS time_12,
  t10.start_school_time AS start_school_time_13,
  t10.arrive_school_time AS arrive_school_time_14,
  t10.first_break_start_at AS first_break_start_at_15,
  t10.first_break_end_at AS first_break_end_at_16,
  t10.second_break_start_at AS second_break_start_at_17,
  t10.second_break_end_at AS second_break_end_at_18,
  t10.school_id AS school_id_19,
  t10.year_id AS year_id_20,
  t10.author_id AS author_id_21
FROM
  school_year t0
  LEFT JOIN agenda_time_convertion t10 ON t10.year_id = t0.id
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.name_en AS name_en_4, t0.level AS level_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.author_id AS author_id_8, t0.editor_id AS editor_id_9, t10.id AS id_11, t10.time AS time_12, t10.start_school_time AS start_school_time_13, t10.arrive_school_time AS arrive_school_time_14, t10.first_break_start_at AS first_break_start_at_15, t10.first_break_end_at AS first_break_end_at_16, t10.second_break_start_at AS second_break_start_at_17, t10.second_break_end_at AS second_break_end_at_18, t10.school_id AS school_id_19, t10.year_id AS year_id_20, t10.author_id AS author_id_21 FROM school_year t0 LEFT JOIN agenda_time_convertion t10 ON t10.year_id = t0.id ORDER BY t0.id DESC;

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\SchoolYear	The mappings App\Entity\SchoolYear#agendaTimeConvertion and App\Entity\AgendaTimeConvertion#year are inconsistent with each other.
App\Entity\User	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\School	The association App\Entity\School#appreciations refers to the owning side field App\Entity\Appreciation#school which does not exist. The mappings App\Entity\School#agendaTimeConvertion and App\Entity\AgendaTimeConvertion#school are inconsistent with each other.
App\Entity\UserYear	No errors.
App\Entity\StudentYear	The association App\Entity\StudentYear#classe refers to the inverse side field App\Entity\TheClass#studentYears which does not exist.
App\Entity\HomeWork	No errors.
App\Entity\HomeWorkYear	The association App\Entity\HomeWorkYear#homeWork refers to the inverse side field App\Entity\HomeWork#homeWorkYears which does not exist. The association App\Entity\HomeWorkYear#classe refers to the inverse side field App\Entity\TheClass#homeWorkYears which does not exist.
App\Entity\Late	No errors.
App\Entity\Chat	The mappings App\Entity\Chat#recipient and App\Entity\User#chats are inconsistent with each other.
App\Entity\Absence	No errors.
App\Entity\Note	No errors.
App\Entity\Exams	No errors.
App\Entity\DocInfo	No errors.
App\Entity\Punish	The association App\Entity\Punish#student refers to the inverse side field App\Entity\Student#punishDetails which does not exist. The join columns of the association 'category' have to match to ALL identifier columns of the target entity 'App\Entity\PunishCategory', however 'id' are missing.
App\Entity\Discussion	The mappings App\Entity\Discussion#userB and App\Entity\User#discussions are inconsistent with each other.
App\Entity\DiscussionClass	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\Quarter	No errors.
App\Entity\GlobalQuarter	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\DisciplineWarning	No errors.
App\Entity\DisciplineBlame	No errors.
App\Entity\DisciplineExclusion	No errors.
App\Entity\ParentNote	No errors.
App\Entity\JustifyAbsence	The join columns of the association 'absence' have to match to ALL identifier columns of the target entity 'App\Entity\Absence', however 'id' are missing.
App\Entity\Subject	No errors.
App\Entity\SubjectReference	No errors.
App\Entity\AbsenceRetainedConfig	No errors.
App\Entity\AbsenceWarningConfig	No errors.
App\Entity\AbsenceExclusionConfig	No errors.
App\Entity\AbsenceBlameConfig	No errors.
App\Entity\DisciplineRetained	No errors.
App\Entity\DefinitiveExclusion	No errors.
App\Entity\DisciplineConcile	The mappings App\Entity\DisciplineConcile#editor and App\Entity\User#disciplineConciles 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\WarningBlameConfig	The association App\Entity\WarningBlameConfig#school refers to the inverse side field App\Entity\School#warningBlameConfig which does not exist.
App\Entity\WarningDefinitiveExlusionConfig	The association App\Entity\WarningDefinitiveExlusionConfig#school refers to the inverse side field App\Entity\School#warningDefinitiveExlusionConfig which does not exist.
App\Entity\PrimaryParentNote	No errors.
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\GlobalDisciplineConfig	No errors.
App\Entity\DisciplinePunish	No errors.
App\Entity\GlobalDisciplineEnabledConfig	No errors.
App\Entity\BlamePunishConfig	No errors.
App\Entity\AbsencePunishConfig	No errors.
App\Entity\WarningPunishConfig	No errors.
App\Entity\PunishRetainedConfig	No errors.
App\Entity\PunishWarningConfig	No errors.
App\Entity\PunishBlameConfig	No errors.
App\Entity\PunishExclusionConfig	No errors.
App\Entity\SchoolYearInfos	No errors.
App\Entity\Blame	No errors.
App\Entity\Warning	No errors.
App\Entity\Retained	No errors.
App\Entity\HonnorTableLimitMoy	No errors.
App\Entity\News	No errors.
App\Entity\Event	No errors.
App\Entity\AdmissionLimit	No errors.
App\Entity\ExamWeek	No errors.
App\Entity\Competence	No errors.
App\Entity\WeekSubjectGoal	No errors.
App\Entity\ProfSchoolPlanner	No errors.
App\Entity\ProfTime	No errors.
App\Entity\SchoolPlannerType	No errors.
App\Entity\AgendaElement	No errors.
App\Entity\GlobalSchoolBreak	No errors.
App\Entity\TeacherAbsence	No errors.
App\Entity\AttendanceMissed	No errors.
App\Entity\GeneralBreak	No errors.

Symfony Profiler

https://college-prive-bilingue-shekinah.com/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping