GET http://app-ac82aa68-a16d-42fb-a997-8ae828c79ace.cleverapps.io/actualite

Query Metrics

15 Database Queries
10 Different statements
21.55 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.93 ms
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.content AS content_2, b0_.created_at AS created_at_3, b0_.end_date_at AS end_date_at_4, b0_.picture_header AS picture_header_5, b0_.alt_picture_header AS alt_picture_header_6, b0_.slug AS slug_7, b0_.visible_start_date AS visible_start_date_8, b0_.visible_expired_date AS visible_expired_date_9 FROM bandeau b0_ WHERE b0_.end_date_at >= ? AND b0_.created_at <= ? ORDER BY b0_.id DESC
Parameters:
[
  "2025-07-05 00:00:00"
  "2025-07-05 00:00:00"
]
2 1.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.visible_start_date AS visible_start_date_3, t0.visible_expired_date AS visible_expired_date_4 FROM actuality t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Actualités"
]
3 1.73 ms
SELECT DISTINCT YEAR(a0_.created_at) AS sclr_0 FROM article a0_ WHERE YEAR(a0_.created_at) >= ? ORDER BY sclr_0 DESC LIMIT 3
Parameters:
[
  2023
]
4 1.35 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.created_at AS created_at_3, a0_.end_date_at AS end_date_at_4, a0_.picture_header AS picture_header_5, a0_.alt_picture_header AS alt_picture_header_6, a0_.slug AS slug_7, a0_.id_video AS id_video_8 FROM article a0_ WHERE a0_.created_at >= ? AND a0_.created_at <= ? ORDER BY a0_.created_at DESC
Parameters:
[
  "2023-01-01 00:00:00"
  "2026-12-31 23:59:59"
]
5 1.79 ms
SELECT h0_.id AS id_0 FROM header h0_ ORDER BY h0_.id DESC LIMIT 1
Parameters:
[]
6 1.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.url_type AS url_type_4, t0.url AS url_5, t0.route AS route_6, t0.header_id AS header_id_7 FROM header_category t0 WHERE t0.header_id = ?
Parameters:
[
  1
]
7 1.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url_type AS url_type_3, t0.url AS url_4, t0.route AS route_5, t0.header_category_id AS header_category_id_6 FROM header_item t0 WHERE t0.header_category_id = ?
Parameters:
[
  1
]
8 1.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url_type AS url_type_3, t0.url AS url_4, t0.route AS route_5, t0.header_category_id AS header_category_id_6 FROM header_item t0 WHERE t0.header_category_id = ?
Parameters:
[
  2
]
9 1.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url_type AS url_type_3, t0.url AS url_4, t0.route AS route_5, t0.header_category_id AS header_category_id_6 FROM header_item t0 WHERE t0.header_category_id = ?
Parameters:
[
  3
]
10 1.30 ms
SELECT f0_.id AS id_0 FROM footer f0_ ORDER BY f0_.id DESC LIMIT 1
Parameters:
[]
11 1.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.column_index AS column_index_3, t0.footer_id AS footer_id_4 FROM footer_category t0 WHERE t0.footer_id = ?
Parameters:
[
  1
]
12 1.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.url_type AS url_type_4, t0.url AS url_5, t0.route AS route_6, t0.is_button AS is_button_7, t0.footer_category_id AS footer_category_id_8 FROM footer_item t0 WHERE t0.footer_category_id = ?
Parameters:
[
  1
]
13 1.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.url_type AS url_type_4, t0.url AS url_5, t0.route AS route_6, t0.is_button AS is_button_7, t0.footer_category_id AS footer_category_id_8 FROM footer_item t0 WHERE t0.footer_category_id = ?
Parameters:
[
  2
]
14 1.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.url_type AS url_type_4, t0.url AS url_5, t0.route AS route_6, t0.is_button AS is_button_7, t0.footer_category_id AS footer_category_id_8 FROM footer_item t0 WHERE t0.footer_category_id = ?
Parameters:
[
  3
]
15 1.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.url_type AS url_type_4, t0.url AS url_5, t0.route AS route_6, t0.is_button AS is_button_7, t0.footer_category_id AS footer_category_id_8 FROM footer_item t0 WHERE t0.footer_category_id = ?
Parameters:
[
  4
]

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\Bandeau No errors.
App\Entity\Actuality No errors.
App\Entity\Article No errors.
App\Entity\Comment No errors.
App\Entity\Header No errors.
App\Entity\HeaderCategory No errors.
App\Entity\HeaderItem No errors.
App\Entity\Footer No errors.
App\Entity\FooterCategory No errors.
App\Entity\FooterItem No errors.