https://test-get-to-hikes.online/en/transfer/sunset-transfer-to-pico-do-arieiro

Query Metrics

12 Database Queries
8 Different statements
10.62 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code_name AS code_name_3, t0.head_title AS head_title_4, t0.slug AS slug_5, t0.seo_body AS seo_body_6, t0.is_visible AS is_visible_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.meta_keywords AS meta_keywords_10, t0.information_no_follow AS information_no_follow_11, t0.og_title AS og_title_12, t0.og_description AS og_description_13, t0.og_image AS og_image_14, t0.og_image_secure AS og_image_secure_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.gallery_id AS gallery_id_18 FROM route t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "sunset-transfer-to-pico-do-arieiro"
]
2 1.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.full_name AS full_name_3, t0.shortcut AS shortcut_4, t0.main AS main_5, t0.main_color AS main_color_6, t0.second_color AS second_color_7, t0.link_social_facebook AS link_social_facebook_8, t0.link_social_instagram AS link_social_instagram_9, t0.link_social_youtube AS link_social_youtube_10, t0.link_social_twitter AS link_social_twitter_11, t0.link_social_linkedin AS link_social_linkedin_12, t0.catalog AS catalog_13, t0.logo_id AS logo_id_14, t0.logo_dark_id AS logo_dark_id_15, t0.favicon_id AS favicon_id_16 FROM domain t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "test-get-to-hikes.online"
]
3 0.81 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.main AS main_4, t0.active AS active_5, t0.media_id AS media_id_6 FROM domain_lang t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "en"
]
4 0.66 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.main AS main_4, t0.active AS active_5, t0.media_id AS media_id_6 FROM domain_lang t0
Parameters:
[]
5 0.71 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.main AS main_4, t0.active AS active_5, t0.media_id AS media_id_6 FROM domain_lang t0 WHERE t0.active = ?
Parameters:
[
  1
]
6 0.95 ms
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:
[
  345
]
7 0.72 ms
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:
[
  354
]
8 0.76 ms
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:
[
  346
]
9 0.76 ms
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:
[
  347
]
10 0.79 ms
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:
[
  348
]
11 0.78 ms
SELECT t0.name AS name_1, t0.context AS context_2, t0.default_format AS default_format_3, t0.enabled AS enabled_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.id AS id_7 FROM media__gallery t0 WHERE t0.id = ?
Parameters:
[
  60
]
12 0.88 ms
SELECT t0.position AS position_1, t0.enabled AS enabled_2, t0.updated_at AS updated_at_3, t0.created_at AS created_at_4, t0.id AS id_5, t0.gallery_id AS gallery_id_6, t0.media_id AS media_id_7 FROM media__gallery_item t0 WHERE t0.gallery_id = ? ORDER BY t0.position ASC
Parameters:
[
  60
]

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\Route No errors.
Sonata\MediaBundle\Entity\BaseGallery No errors.
App\Entity\SonataMediaGallery No errors.
App\Entity\Course No errors.
App\Entity\BusStop No errors.
App\Entity\Domain No errors.
Sonata\MediaBundle\Entity\BaseMedia
  • The field 'Sonata\MediaBundle\Entity\BaseMedia#length' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\SonataMediaMedia
  • The field 'App\Entity\SonataMediaMedia#length' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\DomainLang No errors.
Sonata\MediaBundle\Entity\BaseGalleryItem No errors.
App\Entity\SonataMediaGalleryItem No errors.