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

Query Metrics

12 Database Queries
8 Different statements
11.32 ms Query time
2 Invalid entities
  • Queries
  • Database Connections
  • Entity Managers
  • Second Level Cache
  • Entities Mapping

Group similar statements

# Time Info
1 1.77 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:
0 of 0
[ "sunset-transfer-to-pico-do-arieiro" ]
2 0.99 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:
0 of 0
[ "test-get-to-hikes.online" ]
3 0.87 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:
0 of 0
[ "en" ]
4 0.77 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 1.29 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:
0 of 0
[ 1 ]
6 0.86 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:
0 of 0
[ 345 ]
7 0.78 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:
0 of 0
[ 354 ]
8 0.73 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:
0 of 0
[ 346 ]
9 0.71 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:
0 of 0
[ 347 ]
10 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:
0 of 0
[ 348 ]
11 0.93 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:
0 of 0
[ 60 ]
12 0.85 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:
0 of 0
[ 60 ]