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

Query Metrics

14 Database Queries
9 Different statements
19.27 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.08 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.61 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.content AS content_4, t0.sub_content AS sub_content_5, t0.slug AS slug_6, t0.redirect_url AS redirect_url_7, t0.meta_keywords AS meta_keywords_8 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "parrainer"
]
3 1.63 ms
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.picture AS picture_2, a0_.id_crm_animal AS id_crm_animal_3, a0_.description AS description_4, a0_.alt_picture AS alt_picture_5, a0_.institution_id AS institution_id_6 FROM animals a0_ ORDER BY a0_.name ASC
Parameters:
[]
4 1.43 ms
SELECT h0_.id AS id_0 FROM header h0_ ORDER BY h0_.id DESC LIMIT 1
Parameters:
[]
5 1.21 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
]
6 1.10 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
]
7 1.19 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
]
8 1.04 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
]
9 1.49 ms
SELECT f0_.id AS id_0 FROM footer f0_ ORDER BY f0_.id DESC LIMIT 1
Parameters:
[]
10 1.28 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
]
11 1.36 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
]
12 1.30 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
]
13 1.29 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
]
14 1.26 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\Page No errors.
App\Entity\Animals No errors.
App\Entity\Institution No errors.
App\Entity\AnimalEvents 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.