GET http://www.la-fonderie.mon-lms.com/

Query Metrics

12 Database Queries
3 Different statements
10.77 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 1.74 ms
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.picture AS picture_3, c0_.duration AS duration_4, c0_.difficulty AS difficulty_5, c0_.progress AS progress_6, c0_.available AS available_7, c0_.category_id AS category_id_8 FROM course c0_ ORDER BY c0_.id DESC LIMIT 8
Parameters:
[]
2 1.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.picture AS picture_4 FROM category t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 0.82 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.video AS video_4, t0.duration AS duration_5, t0.chapter_part AS chapter_part_6, t0.course_id AS course_id_7 FROM chapter t0 WHERE t0.course_id = ?
Parameters:
[
  68
]
4 0.72 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.video AS video_4, t0.duration AS duration_5, t0.chapter_part AS chapter_part_6, t0.course_id AS course_id_7 FROM chapter t0 WHERE t0.course_id = ?
Parameters:
[
  67
]
5 0.84 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.video AS video_4, t0.duration AS duration_5, t0.chapter_part AS chapter_part_6, t0.course_id AS course_id_7 FROM chapter t0 WHERE t0.course_id = ?
Parameters:
[
  66
]
6 0.91 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.video AS video_4, t0.duration AS duration_5, t0.chapter_part AS chapter_part_6, t0.course_id AS course_id_7 FROM chapter t0 WHERE t0.course_id = ?
Parameters:
[
  65
]
7 0.77 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.picture AS picture_4 FROM category t0 WHERE t0.id = ?
Parameters:
[
  2
]
8 0.66 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.video AS video_4, t0.duration AS duration_5, t0.chapter_part AS chapter_part_6, t0.course_id AS course_id_7 FROM chapter t0 WHERE t0.course_id = ?
Parameters:
[
  64
]
9 0.79 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.video AS video_4, t0.duration AS duration_5, t0.chapter_part AS chapter_part_6, t0.course_id AS course_id_7 FROM chapter t0 WHERE t0.course_id = ?
Parameters:
[
  63
]
10 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.picture AS picture_4 FROM category t0 WHERE t0.id = ?
Parameters:
[
  10
]
11 0.81 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.video AS video_4, t0.duration AS duration_5, t0.chapter_part AS chapter_part_6, t0.course_id AS course_id_7 FROM chapter t0 WHERE t0.course_id = ?
Parameters:
[
  62
]
12 0.69 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.video AS video_4, t0.duration AS duration_5, t0.chapter_part AS chapter_part_6, t0.course_id AS course_id_7 FROM chapter t0 WHERE t0.course_id = ?
Parameters:
[
  61
]

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\Course
  • The field App\Entity\Course#evaluations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Evaluation#course does not contain the required 'inversedBy="evaluations"' attribute.
App\Entity\Category No errors.
App\Entity\User
  • The field App\Entity\User#evaluations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Evaluation#user does not contain the required 'inversedBy="evaluations"' attribute.
App\Entity\Theme No errors.
App\Entity\Chapter No errors.
App\Entity\ChapterProgression No errors.
App\Entity\Evaluation No errors.
App\Entity\Question No errors.
App\Entity\Quiz No errors.
App\Entity\Exercice
  • The mappings App\Entity\Exercice#studentExercices and App\Entity\StudentExercice#exercice are inconsistent with each other.
App\Entity\Material No errors.
App\Entity\Satisfaction No errors.
App\Entity\UserDetails No errors.