Query Metrics
45
Database Queries
4
Different statements
31.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
11.14 ms (35.26%) |
15 |
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:
[
7
]
|
|
9.44 ms (29.86%) |
14 |
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:
[
3
]
|
|
7.81 ms (24.70%) |
15 |
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:
[
7
]
|
|
3.22 ms (10.18%) |
1 |
SELECT t0.id AS id_1, t0.display_order AS display_order_2, t0.published AS published_3, t0.template AS template_4, t0.disposition AS disposition_5, t0.is_virtual_visit AS is_virtual_visit_6, t0.in_primary_menu AS in_primary_menu_7, t0.in_secondary_menu AS in_secondary_menu_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.miniature_id AS miniature_id_11, t0.miniaturebis_id AS miniaturebis_id_12, t0.badge_id AS badge_id_13, t0.obstacle_id AS obstacle_id_14, t0.gallery_id AS gallery_id_15, t0.old_quizz_id AS old_quizz_id_16, t0.young_quizz_id AS young_quizz_id_17, t0.flip_card_collection_id AS flip_card_collection_id_18 FROM page t0 WHERE t0.published = ? AND t0.is_virtual_visit = ? ORDER BY t0.display_order ASC
Parameters:
[ 1 1 ] |
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. |
| 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. |
| App\Entity\PageTranslation | No errors. |
| Sonata\MediaBundle\Entity\BaseGalleryItem | No errors. |
| App\Entity\SonataMediaGalleryItem | No errors. |
| App\Entity\SonataMediaMediaTranslation | No errors. |