https://saco-preprod.kwantic.fr/faq-footer

Query Metrics

6 Database Queries
6 Different statements
10.53 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.99 ms
(37.91%)
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"
]
2.65 ms
(25.18%)
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_ INNER JOIN post_category p1_ ON e0_.category_id = p1_.id WHERE p1_.slug = ? LIMIT 9
Parameters:
[
  "elearning-mode"
]
1.30 ms
(12.38%)
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
]
1.17 ms
(11.16%)
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 6
Parameters:
[
  "2024-10-29 00:00:00"
]
0.86 ms
(8.13%)
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.post_type = ?
Parameters:
[
  "elearning"
]
0.55 ms
(5.25%)
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\Post No errors.
App\Entity\User No errors.
App\Entity\PostCategory No errors.
App\Entity\PostMeta No errors.
App\Entity\PageBloc No errors.
App\Entity\Elearning No errors.
App\Entity\ProductVideo No errors.
App\Entity\LiveSession No errors.
App\Entity\Faq No errors.