https://saco-preprod.kwantic.fr/elearning/coupe-graduee

Query Metrics

8 Database Queries
8 Different statements
8.23 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.56 ms
(31.10%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.video AS video_6, t0.coach AS coach_7, t0.category_id AS category_id_8 FROM elearning t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "coupe-graduee"
]
1.06 ms
(12.87%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.video_pro_id AS video_pro_id_4, t0.elearning_id AS elearning_id_5 FROM product_video t0 WHERE t0.elearning_id = ?
Parameters:
[
  12
]
0.95 ms
(11.49%)
1
SELECT t0.id AS id_1, t0.question AS question_2, t0.response AS response_3, t0.show_in_footer AS show_in_footer_4, t0.ordre AS ordre_5 FROM faq t0 WHERE t0.show_in_footer = ? ORDER BY t0.ordre ASC
Parameters:
[
  1
]
0.87 ms
(10.62%)
1
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.description AS description_3, e0_.image AS image_4, e0_.video AS video_5, e0_.coach AS coach_6, e0_.category_id AS category_id_7 FROM elearning e0_ WHERE e0_.slug <> ? AND e0_.category_id = ? LIMIT 3
Parameters:
[
  "coupe-graduee"
  108
]
0.86 ms
(10.49%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.excerpt AS excerpt_5, t0.status AS status_6, t0.publish_at AS publish_at_7, t0.type AS type_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image AS image_11, t0.video AS video_12, t0.author_id AS author_id_13, t0.category_id AS category_id_14 FROM post t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "banner-elearning"
]
0.75 ms
(9.06%)
1
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.slug AS slug_2, l0_.date AS date_3, l0_.description AS description_4, l0_.image AS image_5, l0_.url AS url_6, l0_.coach AS coach_7, l0_.video AS video_8, l0_.category_id AS category_id_9 FROM live_session l0_ WHERE l0_.date >= ? LIMIT 3
Parameters:
[
  "2024-10-29 00:00:00"
]
0.61 ms
(7.44%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.slug AS slug_4, t0.post_type AS post_type_5, t0.parent_id AS parent_id_6 FROM post_category t0 WHERE t0.id = ?
Parameters:
[
  108
]
0.57 ms
(6.93%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.slug AS slug_4, t0.image AS image_5, t0.post_id AS post_id_6 FROM page_bloc t0 WHERE t0.post_id = ?
Parameters:
[
  78
]

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\Elearning No errors.
App\Entity\PostCategory No errors.
App\Entity\ProductVideo No errors.
App\Entity\LiveSession No errors.
App\Entity\Post No errors.
App\Entity\User No errors.
App\Entity\PostMeta No errors.
App\Entity\PageBloc No errors.
App\Entity\VideoPro No errors.
App\Entity\Faq No errors.
App\Entity\Coach No errors.
App\Entity\Subscription No errors.
App\Entity\Reservation No errors.