Query Metrics
13
Database Queries
9
Different statements
6.74 ms
Query time
1
Invalid entities
Grouped Statements
| 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 |
|
| App\Entity\Quote | No errors. |