https://api.viesmajuscules.lu/api/page/get/politique-de-confidentialite/fr

Query Metrics

13 Database Queries
9 Different statements
6.74 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.26 ms
(33.60%)
5
SELECT t0.id AS id_1, t0.content AS content_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM paragraph_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  11
]
1.32 ms
(19.55%)
1
SELECT p0_.id AS id_0, p0_.display_order AS display_order_1, p0_.published AS published_2, p0_.template AS template_3, p0_.disposition AS disposition_4, p0_.is_virtual_visit AS is_virtual_visit_5, p0_.in_primary_menu AS in_primary_menu_6, p0_.in_secondary_menu AS in_secondary_menu_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.miniature_id AS miniature_id_10, p0_.miniaturebis_id AS miniaturebis_id_11, p0_.badge_id AS badge_id_12, p0_.obstacle_id AS obstacle_id_13, p0_.gallery_id AS gallery_id_14, p0_.old_quizz_id AS old_quizz_id_15, p0_.young_quizz_id AS young_quizz_id_16, p0_.flip_card_collection_id AS flip_card_collection_id_17 FROM page p0_ LEFT JOIN page_translation p1_ ON (p0_.id = p1_.translatable_id) WHERE p1_.locale = ? AND p1_.slug = ? AND p0_.published = ? LIMIT 1
Parameters:
[
  "fr"
  "politique-de-confidentialite"
  1
]
0.59 ms
(8.73%)
1
SELECT t0.id AS id_1, t0.disposition AS disposition_2, t0.youtube_url AS youtube_url_3, t0.picture_id AS picture_id_4, t0.page_id AS page_id_5 FROM paragraph t0 WHERE t0.page_id = ?
Parameters:
[
  18
]
0.58 ms
(8.63%)
1
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  39
]
0.45 ms
(6.73%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.theme AS theme_3, t0.slug AS slug_4, t0.lead_text AS lead_text_5, t0.seo_title AS seo_title_6, t0.seo_resume AS seo_resume_7, t0.canonical_url AS canonical_url_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  18
]
0.42 ms
(6.18%)
1
SELECT t0.id AS id_1, t0.alt AS alt_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM media__media_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  39
]
0.40 ms
(5.97%)
1
SELECT t0.id AS id_1, t0.picture_id AS picture_id_2 FROM review t0 INNER JOIN page_review ON t0.id = page_review.review_id WHERE page_review.page_id = ?
Parameters:
[
  18
]
0.36 ms
(5.40%)
1
SELECT t0.id AS id_1, t0.testimonial_id AS testimonial_id_2, t0.page_id AS page_id_3 FROM testimonial_item t0 WHERE t0.page_id = ?
Parameters:
[
  18
]
0.35 ms
(5.22%)
1
SELECT t0.id AS id_1, t0.page_id AS page_id_2, t0.quote_id AS quote_id_3 FROM quote_item t0 WHERE t0.page_id = ?
Parameters:
[
  18
]

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\Page No errors.
App\Entity\PageTranslation No errors.
Sonata\MediaBundle\Entity\BaseMedia No errors.
App\Entity\SonataMediaMedia No errors.
App\Entity\ObstacleCollection No errors.
Sonata\MediaBundle\Entity\BaseGallery No errors.
App\Entity\SonataMediaGallery No errors.
App\Entity\Quizz No errors.
App\Entity\FlipCardCollection No errors.
App\Entity\Paragraph No errors.
App\Entity\QuoteItem No errors.
App\Entity\TestimonialItem No errors.
App\Entity\Review No errors.
Sonata\MediaBundle\Entity\BaseGalleryItem No errors.
App\Entity\SonataMediaGalleryItem No errors.
App\Entity\SonataMediaMediaTranslation No errors.
App\Entity\ParagraphTranslation No errors.
App\Entity\Testimonial
  • The mappings App\Entity\Testimonial#domains and App\Entity\Domain#testimonial are inconsistent with each other.
App\Entity\Quote No errors.