https://api-royal-palace.dix-demo.fr/de

Query Metrics

34 Database Queries
7 Different statements
13.87 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.45 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.is_home = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  1
  "de"
]
2 0.33 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.thumbnail AS thumbnail_5, t0.start AS start_6, t0.end AS end_7, t0.season AS season_8, t0.force_day AS force_day_9, t0.deleted AS deleted_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_full AS is_full_13, t0.concert_id AS concert_id_14, t15.id AS id_16, t15.title AS title_17, t15.description AS description_18, t15.thumbnail AS thumbnail_19, t15.infos AS infos_20, t15.start AS start_21, t15.end AS end_22, t15.published AS published_23, t15.created_at AS created_at_24, t15.updated_at AS updated_at_25, t0.venue_type_id AS venue_type_id_26, t27.id AS id_28, t27.slug AS slug_29, t27.title AS title_30, t27.description AS description_31, t27.thumbnail AS thumbnail_32, t27.season AS season_33, t27.position AS position_34, t27.food AS food_35, t27.created_at AS created_at_36, t27.updated_at AS updated_at_37 FROM framework_venue t0 LEFT JOIN framework_concert t15 ON t0.concert_id = t15.id LEFT JOIN framework_venue_type t27 ON t0.venue_type_id = t27.id WHERE t0.title = ? LIMIT 1
Parameters:
[
  "Mégaconcert"
]
3 0.33 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.is_home = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  1
  "de"
]
4 2.33 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 12:49:15"
]
5 2.94 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
  ]
]
6 0.20 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
  ]
]
7 1.12 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:
[]
8 0.26 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:
[
  "accueil"
  "fr"
]
9 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:
[
  "accueil"
  "en"
]
10 0.18 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"
  "de"
]
11 0.16 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:
[
  "accueil"
  "fr"
]
12 0.14 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:
[
  "accueil"
  "en"
]
13 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:
[
  "reservation"
  "de"
]
14 0.18 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"
  "de"
]
15 0.17 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"
  "de"
]
16 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:
[
  "faq"
  "de"
]
17 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:
[
  "nos-espaces"
  "de"
]
18 0.14 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"
  "de"
]
19 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:
[
  "spectacles-speciaux"
  "de"
]
20 0.26 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"
  "de"
]
21 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:
[
  "spectacles-speciaux"
  "de"
]
22 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:
[
  "spectacles-precedents"
  "de"
]
23 0.36 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"
  "de"
]
24 0.15 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"
  "de"
]
25 0.22 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"
  "de"
]
26 0.14 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"
  "de"
]
27 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:
[
  "actualites"
  "de"
]
28 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:
[
  "contact"
  "de"
]
29 0.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:
[
  "boutique"
  "de"
]
30 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:
[
  "boutique"
  "de"
]
31 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:
[
  "boutique"
  "de"
]
32 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:
[
  "boutique"
  "de"
]
33 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:
[
  "boutique"
  "de"
]
34 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:
[
  "actualites"
  "de"
]

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