Query Metrics
9
Database Queries
9
Different statements
2.26 ms
Query time
3
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.39 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 745 ] |
2 | 0.30 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 = 745) 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:
[
745
]
|
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.21 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.21 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:
[
745
]
|
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:
[
745
]
|
8 | 0.24 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:
[
24
]
|
9 | 0.21 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:
[
745
]
|
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 |
|
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 |
|
App\Entity\CoursesNiveaux | No errors. |
App\Entity\Eleves | No errors. |
App\Entity\Niveaux | No errors. |
App\Entity\Matieres |
|
App\Entity\Annonces | No errors. |
App\Entity\AnnoncesPropositions | No errors. |