https://api-royal-palace.dix-demo.fr/fr/menus-tarifs/le-versailles

Query Metrics

44 Database Queries
5 Different statements
7.90 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.25 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "menus-tarifs-page"
  "fr"
]
2 0.53 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM framework_translation t0
Parameters:
[]
3 1.78 ms
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.slug AS slug_2, f0_.description AS description_3, f0_.thumbnail AS thumbnail_4, f0_.start AS start_5, f0_.end AS end_6, f0_.season AS season_7, f0_.force_day AS force_day_8, f0_.deleted AS deleted_9, f0_.created_at AS created_at_10, f0_.updated_at AS updated_at_11, f0_.is_full AS is_full_12, f0_.concert_id AS concert_id_13, f0_.venue_type_id AS venue_type_id_14 FROM framework_venue f0_ LEFT JOIN framework_venue_type f1_ ON f0_.venue_type_id = f1_.id WHERE f0_.start > ? AND f0_.deleted IS NULL ORDER BY f0_.start ASC
Parameters:
[
  "2025-04-29 19:12:35"
]
4 1.06 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.description AS description_4, t0.thumbnail AS thumbnail_5, t0.season AS season_6, t0.position AS position_7, t0.food AS food_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM framework_venue_type t0 WHERE t0.id IN (?)
Parameters:
[
  [
    20
    24
    21
    32
    40
    34
    35
    36
    38
    37
  ]
]
5 0.12 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.thumbnail AS thumbnail_4, t0.infos AS infos_5, t0.start AS start_6, t0.end AS end_7, t0.published AS published_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM framework_concert t0 WHERE t0.id IN (?)
Parameters:
[
  [
    16
    10
    18
    24
    19
    20
    21
    22
    23
  ]
]
6 0.31 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM framework_translation t0
Parameters:
[]
7 0.13 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "reservation"
  "fr"
]
8 0.08 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "menus-tarifs"
  "fr"
]
9 0.08 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "menus-tarifs"
  "fr"
]
10 0.07 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "menus-tarifs"
  "fr"
]
11 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "reservation"
  "fr"
]
12 0.08 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "menus-tarifs"
  "fr"
]
13 0.09 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "informations-pratiques"
  "fr"
]
14 0.09 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "faq"
  "fr"
]
15 0.07 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "nos-espaces"
  "fr"
]
16 0.07 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "notre-histoire"
  "fr"
]
17 0.07 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "spectacles-speciaux"
  "fr"
]
18 0.07 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "spectacles-speciaux"
  "fr"
]
19 0.06 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "spectacles-speciaux"
  "fr"
]
20 0.06 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "spectacles-precedents"
  "fr"
]
21 0.06 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "boutique"
  "fr"
]
22 0.06 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "espace-entreprises"
  "fr"
]
23 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "reservation"
  "fr"
]
24 0.06 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "offres-emploi"
  "fr"
]
25 0.06 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "actualites"
  "fr"
]
26 0.06 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "contact"
  "fr"
]
27 0.12 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "menus-tarifs"
  "fr"
]
28 0.08 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "menus-tarifs"
  "fr"
]
29 0.07 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "menus-tarifs"
  "fr"
]
30 0.07 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "menus-tarifs"
  "fr"
]
31 0.07 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "menus-tarifs"
  "fr"
]
32 0.08 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "reservation"
  "fr"
]
33 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "notre-histoire"
  "fr"
]
34 0.08 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "nos-espaces"
  "fr"
]
35 0.07 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "informations-pratiques"
  "fr"
]
36 0.07 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "menus-tarifs"
  "fr"
]
37 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "spectacles-precedents"
  "fr"
]
38 0.07 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "reservation"
  "fr"
]
39 0.06 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "actualites"
  "fr"
]
40 0.06 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "espace-entreprises"
  "fr"
]
41 0.06 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "boutique"
  "fr"
]
42 0.06 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "faq"
  "fr"
]
43 0.06 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "politique-de-confidentialite"
  "fr"
]
44 0.07 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "actualites"
  "fr"
]

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\Framework\AppBundle\Entity\Page No errors.
App\Framework\AppBundle\Entity\Translation No errors.
App\Framework\AppBundle\Entity\Venue No errors.
App\Framework\AppBundle\Entity\VenueType No errors.
App\Framework\AppBundle\Entity\Concert No errors.
App\Framework\AppBundle\Entity\Places No errors.