GET https://ist-mamou.org/

Query Metrics

8 Database Queries
8 Different statements
4.66 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 1.41 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.date_of_birth AS date_of_birth_4, t0.roll_number AS roll_number_5, t0.phone AS phone_6, t0.gender AS gender_7, t0.father AS father_8, t0.mother AS mother_9, t0.parent_number AS parent_number_10, t0.place_of_birth AS place_of_birth_11, t0.nationality AS nationality_12, t0.picture AS picture_13, t0.created_at AS created_at_14, t0.created_by AS created_by_15, t0.updated_at AS updated_at_16, t0.updated_by AS updated_by_17, t0.flag AS flag_18, t0.email AS email_19, t0.exam_table_number AS exam_table_number_20, t0.baccalaureate_option AS baccalaureate_option_21, t0.baccalaureate_session AS baccalaureate_session_22, t0.exam_center AS exam_center_23, t0.high_school AS high_school_24, t0.baccalaureate_average AS baccalaureate_average_25, t0.orientation_session AS orientation_session_26, t0.prefecture AS prefecture_27, t0.orientation_program AS orientation_program_28 FROM student t0
Parameters:
[]
2 0.49 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.specialization AS specialization_4, t0.gender AS gender_5, t0.phone AS phone_6, t0.joining_date AS joining_date_7, t0.created_at AS created_at_8, t0.created_by AS created_by_9, t0.updated_at AS updated_at_10, t0.updated_by AS updated_by_11, t0.date_of_birth AS date_of_birth_12, t0.address AS address_13, t0.picture AS picture_14, t0.education AS education_15, t0.designation AS designation_16, t0.country AS country_17, t0.flag AS flag_18, t0.email AS email_19, t0.security_social_number AS security_social_number_20, t0.roll_number AS roll_number_21 FROM teacher t0
Parameters:
[]
3 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.phone AS phone_4, t0.starting_year AS starting_year_5, t0.created_at AS created_at_6, t0.created_by AS created_by_7, t0.updated_at AS updated_at_8, t0.updated_by AS updated_by_9, t0.flag AS flag_10 FROM faculty t0
Parameters:
[]
4 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.duration AS duration_4, t0.ects AS ects_5, t0.created_at AS created_at_6, t0.created_by AS created_by_7, t0.updated_at AS updated_at_8, t0.updated_by AS updated_by_9, t0.department_id AS department_id_10 FROM formation t0
Parameters:
[]
5 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.phone AS phone_4, t0.starting_year AS starting_year_5, t0.student_capacity AS student_capacity_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.slug AS slug_11, t0.flag AS flag_12, t0.faculty_id AS faculty_id_13 FROM department t0
Parameters:
[]
6 0.76 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.type AS type_3, a0_.image AS image_4, a0_.content AS content_5, a0_.created_at AS created_at_6, a0_.created_by AS created_by_7, a0_.updated_at AS updated_at_8, a0_.updated_by AS updated_by_9 FROM article a0_ ORDER BY a0_.created_at DESC LIMIT 3
Parameters:
[]
7 0.41 ms
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.image AS image_3, e0_.start_date AS start_date_4, e0_.end_date AS end_date_5, e0_.created_at AS created_at_6, e0_.created_by AS created_by_7, e0_.updated_at AS updated_at_8, e0_.updated_by AS updated_by_9, e0_.content AS content_10 FROM event e0_ ORDER BY e0_.created_at DESC LIMIT 4
Parameters:
[]
8 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code_course AS code_course_4, t0.duration AS duration_5, t0.picture AS picture_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.flag AS flag_11, t0.teacher_id AS teacher_id_12, t0.department_id AS department_id_13, t0.promotion_id AS promotion_id_14, t0.subject_id AS subject_id_15 FROM course t0
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\Student
  • The mappings App\Entity\Student#formation and App\Entity\Enrollment#student are inconsistent with each other.
App\Entity\Teacher No errors.
App\Entity\Faculty No errors.
App\Entity\Formation
  • The association App\Entity\Formation#onlineCourses refers to the owning side field App\Entity\OnlineCourse#Formation which does not exist.
App\Entity\Department
  • The mappings App\Entity\Department#formation and App\Entity\Timetable#formation are inconsistent with each other.
App\Entity\Article No errors.
App\Entity\Event No errors.
App\Entity\Course No errors.
App\Entity\Promotion
  • The association App\Entity\Promotion#publishes refers to the owning side field App\Entity\Publish#Promotion which does not exist.
  • The association App\Entity\Promotion#onlineCourses refers to the owning side field App\Entity\OnlineCourse#Promotion which does not exist.
App\Entity\Subject No errors.