https://app-preprod.lesbonsprofs.com/nos-cours/terminale/mathematiques/inegalite-de-concentration-91

Query Metrics

8 Database Queries
8 Different statements
92.84 ms Query time
6 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 11.11 ms
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.slug AS slug_2, f0_.link AS link_3, f0_.content AS content_4, f0_.`online` AS online_5, f0_.position AS position_6, f0_.metadescription AS metadescription_7, f0_.created AS created_8, f0_.updated AS updated_9, f0_.video_id AS video_id_10, f0_.notion_id AS notion_id_11 FROM free_activity_notion f0_ INNER JOIN free_notion f1_ ON f0_.notion_id = f1_.id INNER JOIN library l2_ ON f1_.library_id = l2_.id INNER JOIN Course c3_ ON l2_.course_id = c3_.id INNER JOIN admin_discipline a4_ ON l2_.disciplines_id = a4_.id WHERE f0_.slug = ? AND c3_.slug = ? AND a4_.slug = ?
Parameters:
[
  "inegalite-de-concentration-91"
  "terminale"
  "mathematiques"
]
2 10.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.front AS front_4, t0.order AS order_5, t0.description AS description_6, t0.metadescription AS metadescription_7 FROM Course t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "terminale"
]
3 10.14 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.title AS title_2 FROM Course c0_ WHERE c0_.front = 1 ORDER BY c0_.order ASC
Parameters:
[]
4 20.32 ms
SELECT CASE WHEN a0_.lesson_title IS NOT NULL THEN a0_.lesson_title ELSE a0_.title END AS sclr_0, a0_.id AS id_1, a0_.slug AS slug_2, c1_.title AS title_3, c1_.id AS id_4, l2_.id AS id_5, l2_.`online` AS online_6, l2_.metadescription AS metadescription_7, l2_.content AS content_8, l2_.title AS title_9 FROM library l2_ INNER JOIN Course c1_ ON l2_.course_id = c1_.id INNER JOIN admin_discipline a0_ ON l2_.disciplines_id = a0_.id WHERE c1_.slug = ? AND l2_.`online` = 1 ORDER BY c1_.order ASC, l2_.position ASC
Parameters:
[
  "terminale"
]
5 10.13 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.vimeo_file AS vimeo_file_3, t0.video_id AS video_id_4, t0.vimeo_id AS vimeo_id_5, t0.picture AS picture_6, t0.title AS title_7, t0.description AS description_8, t0.position AS position_9, t0.duration AS duration_10, t0.poster AS poster_11, t0.picture_mobile_id AS picture_mobile_id_12, t0.visible_for_all AS visible_for_all_13, t0.answers_question AS answers_question_14, t0.resume AS resume_15, t0.title_youtube AS title_youtube_16, t0.published AS published_17, t0.weight AS weight_18, t0.caption AS caption_19, t0.slug AS slug_20, t0.duration_youtube AS duration_youtube_21, t0.publish_date_youtube AS publish_date_youtube_22, t0.meta_description AS meta_description_23, t0.transcript AS transcript_24, t0.transcript_auto AS transcript_auto_25, t0.link_kumulus AS link_kumulus_26, t0.created AS created_27, t0.updated AS updated_28 FROM Video t0 WHERE t0.id = ?
Parameters:
[
  3201
]
6 10.19 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.`online` AS online_4, t0.position AS position_5, t0.metadescription AS metadescription_6, t0.created AS created_7, t0.updated AS updated_8, t0.library_id AS library_id_9 FROM free_notion t0 WHERE t0.id = ?
Parameters:
[
  17
]
7 10.44 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.`online` AS online_4, t0.position AS position_5, t0.metadescription AS metadescription_6, t0.created AS created_7, t0.updated AS updated_8, t0.course_id AS course_id_9, t0.disciplines_id AS disciplines_id_10 FROM library t0 WHERE t0.id = ?
Parameters:
[
  13
]
8 10.23 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.lesson_title AS lesson_title_3, t0.slug AS slug_4, t0.slug_lesson AS slug_lesson_5, t0.front AS front_6, t0.order AS order_7, t0.speciality AS speciality_8, t0.exam AS exam_9, t0.main_color AS main_color_10, t0.gradient_color AS gradient_color_11, t0.published AS published_12, t0.color AS color_13, t0.style AS style_14 FROM admin_discipline t0 WHERE t0.id = ?
Parameters:
[
  3
]

Database Connections

Name Service
default doctrine.dbal.default_connection
wp doctrine.dbal.wp_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\Users\User No errors.
App\Entity\Management\Subscription\Subscription
  • The association App\Entity\Management\Subscription\Subscription#student refers to the inverse side field App\Entity\Users\Child#offers which does not exist.
App\Entity\Educational\Activity No errors.
App\Entity\Educational\Notion No errors.
App\Entity\Educational\Library No errors.
App\Entity\Educational\Course
  • The mappings App\Entity\Educational\Course#students and App\Entity\Users\Child#course are inconsistent with each other.
App\Entity\Educational\Discipline
  • The mappings App\Entity\Educational\Discipline#domains and App\Entity\Educational\Domain#discipline are inconsistent with each other.
App\Entity\Media\Video No errors.
App\Entity\Educational\Domain
  • The association App\Entity\Educational\Domain#discipline refers to the inverse side field App\Entity\Educational\Discipline#domain which does not exist.
App\Entity\Users\Child
  • The association App\Entity\Users\Child#course refers to the inverse side field App\Entity\Educational\Course#users which does not exist.
App\Entity\Educational\SubChapterDomainVideo No errors.
App\Entity\Users\Teacher
  • The association App\Entity\Users\Teacher#students refers to the owning side field App\Entity\Users\Child#teacher which does not exist.