GET https://jonathan-easyschoolnet.websrc.fr/course/details/760

Query Metrics

9 Database Queries
9 Different statements
2.38 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.42 ms
SELECT t0.type AS type_1, t0.description AS description_2, t0.places AS places_3, t0.nb_hours AS nb_hours_4, t0.price AS price_5, t0.date_max AS date_max_6, t0.name AS name_7, t0.file AS file_8, t0.libre AS libre_9, t0.room_type AS room_type_10, t0.room_uuid AS room_uuid_11, t0.id AS id_12, t0.active AS active_13, t0.date_created AS date_created_14, t0.date_updated AS date_updated_15, t0.professeur_id AS professeur_id_16, t17.lundi AS lundi_18, t17.mardi AS mardi_19, t17.mercredi AS mercredi_20, t17.jeudi AS jeudi_21, t17.vendredi AS vendredi_22, t17.samedi AS samedi_23, t17.dimanche AS dimanche_24, t17.id AS id_25, t17.active AS active_26, t17.course_id AS course_id_27 FROM courses t0 LEFT JOIN courses_recurring t17 ON t17.course_id = t0.id WHERE t0.active = ? AND t0.id = ? LIMIT 1
Parameters:
[
  1
  760
]
2 0.32 ms
SELECT e0_.firstname AS firstname_0, e0_.birthdate AS birthdate_1, e0_.gender AS gender_2, e0_.image AS image_3, e0_.lastname AS lastname_4, e0_.mail AS mail_5, e0_.id AS id_6, e0_.date_created AS date_created_7, e0_.date_updated AS date_updated_8, e0_.user_id AS user_id_9, e0_.niveau_id AS niveau_id_10 FROM eleves e0_ LEFT JOIN courses_participants c1_ ON e0_.id = c1_.eleve_id AND (c1_.eleve_id = e0_.id AND c1_.course_id = 760) WHERE e0_.user_id = ? AND ((c1_.id IS NULL AND c1_.active IS NULL) OR (c1_.id IS NOT NULL AND c1_.active = 0))
Parameters:
[
  null
]
3 0.25 ms
SELECT t0.uuid AS uuid_1, t0.duration AS duration_2, t0.description AS description_3, t0.file AS file_4, t0.id AS id_5, t0.active AS active_6, t0.date_created AS date_created_7, t0.date_updated AS date_updated_8, t0.course_id AS course_id_9, t0.user_id AS user_id_10, t0.eleve_id AS eleve_id_11 FROM courses_participants t0 WHERE t0.course_id = ?
Parameters:
[
  760
]
4 0.26 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.image AS image_3, t0.id AS id_4, t0.active AS active_5 FROM matieres t0 WHERE t0.active = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
5 0.26 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.id AS id_4 FROM niveaux t0 ORDER BY t0.position ASC
Parameters:
[]
6 0.24 ms
SELECT t0.id AS id_1, t0.course_id AS course_id_2, t0.matiere_id AS matiere_id_3 FROM courses_matieres t0 WHERE t0.course_id = ?
Parameters:
[
  760
]
7 0.20 ms
SELECT t0.file AS file_1, t0.name AS name_2, t0.id AS id_3, t0.user_id AS user_id_4, t0.course_id AS course_id_5 FROM courses_files t0 WHERE t0.course_id = ?
Parameters:
[
  760
]
8 0.23 ms
SELECT t0.username AS username_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.lastname AS lastname_5, t0.firstname AS firstname_6, t0.last_login AS last_login_7, t0.password_request_at AS password_request_at_8, t0.token AS token_9, t0.last_activity AS last_activity_10, t0.newsletter AS newsletter_11, t0.cni AS cni_12, t0.iban AS iban_13, t0.cni_valid AS cni_valid_14, t0.iban_valid AS iban_valid_15, t0.stripe_account AS stripe_account_16, t0.type AS type_17, t0.description AS description_18, t0.image AS image_19, t0.id AS id_20, t0.date_created AS date_created_21, t0.date_updated AS date_updated_22, t0.active AS active_23 FROM user t0 WHERE t0.id = ?
Parameters:
[
  16
]
9 0.19 ms
SELECT t0.id AS id_1, t0.course_id AS course_id_2, t0.niveau_id AS niveau_id_3 FROM courses_niveaux t0 WHERE t0.course_id = ?
Parameters:
[
  760
]

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\Courses
  • The field 'App\Entity\Courses#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\User No errors.
App\Entity\CoursesRecurring No errors.
App\Entity\CoursesParticipants No errors.
App\Entity\CoursesFiles No errors.
App\Entity\CoursesMatieres No errors.
App\Entity\Payments
  • The association App\Entity\Payments#courseParticipant refers to the inverse side field App\Entity\CoursesParticipants#payments which does not exist.
  • The association App\Entity\Payments#annonce refers to the inverse side field App\Entity\Annonces#payments which does not exist.
  • The association App\Entity\Payments#annonceProposition refers to the inverse side field App\Entity\AnnoncesPropositions#payments which does not exist.
App\Entity\CoursesNiveaux No errors.
App\Entity\Eleves No errors.
App\Entity\Niveaux No errors.
App\Entity\Matieres
  • The association App\Entity\Matieres#courses refers to the owning side field App\Entity\Courses#matiere which does not exist.
App\Entity\Annonces No errors.
App\Entity\AnnoncesPropositions No errors.