https://test-get-to-hikes.online/en/madeira-gardens-a-journey-through-funchals-natural-beauty

Query Metrics

13 Database Queries
9 Different statements
18.65 ms Query time
11 Invalid entities

Queries

Group similar statements

# Time Info
1 4.41 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.identificator AS identificator_3, t0.template AS template_4, t0.slug AS slug_5, t0.url AS url_6, t0.description AS description_7, t0.short_desc AS short_desc_8, t0.seo_desc AS seo_desc_9, t0.main_page AS main_page_10, t0.hike_trail AS hike_trail_11, t0.is_visible AS is_visible_12, t0.sub_title_movie AS sub_title_movie_13, t0.main_page_section_bus_stop AS main_page_section_bus_stop_14, t0.main_page_section_recommendations_title AS main_page_section_recommendations_title_15, t0.main_page_section_slider_title AS main_page_section_slider_title_16, t0.main_page_section_aveiro_title AS main_page_section_aveiro_title_17, t0.main_page_section_aveiro_description AS main_page_section_aveiro_description_18, t0.main_page_section_rabacal_title AS main_page_section_rabacal_title_19, t0.main_page_section_rabacal_description AS main_page_section_rabacal_description_20, t0.main_page_section_fanal_title AS main_page_section_fanal_title_21, t0.main_page_section_fanal_description AS main_page_section_fanal_description_22, t0.main_page_section_fanal_link AS main_page_section_fanal_link_23, t0.main_page_section_levada_title AS main_page_section_levada_title_24, t0.main_page_section_levada_description AS main_page_section_levada_description_25, t0.main_page_section_levada_link AS main_page_section_levada_link_26, t0.main_page_section_outdoo_title AS main_page_section_outdoo_title_27, t0.main_page_section_outdoor_description AS main_page_section_outdoor_description_28, t0.about_us_first_section_title AS about_us_first_section_title_29, t0.about_us_first_section_description AS about_us_first_section_description_30, t0.show_on_list AS show_on_list_31, t0.about_us_second_section_title AS about_us_second_section_title_32, t0.about_us_second_section_description AS about_us_second_section_description_33, t0.about_us_third_section_title AS about_us_third_section_title_34, t0.about_us_third_section_description AS about_us_third_section_description_35, t0.desc_movie AS desc_movie_36, t0.main_page_content AS main_page_content_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.deleted_at AS deleted_at_40, t0.meta_title AS meta_title_41, t0.meta_description AS meta_description_42, t0.meta_keywords AS meta_keywords_43, t0.information_no_follow AS information_no_follow_44, t0.og_title AS og_title_45, t0.og_description AS og_description_46, t0.og_image AS og_image_47, t0.og_image_secure AS og_image_secure_48, t0.domain_id AS domain_id_49, t0.domain_lang_id AS domain_lang_id_50, t0.movie_id AS movie_id_51, t0.gallery_id AS gallery_id_52 FROM page t0 WHERE t0.slug = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "madeira-gardens-a-journey-through-funchals-natural-beauty"
]
2 0.88 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.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 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "en"
]
4 6.12 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.identificator AS identificator_2, p0_.template AS template_3, p0_.slug AS slug_4, p0_.url AS url_5, p0_.description AS description_6, p0_.short_desc AS short_desc_7, p0_.seo_desc AS seo_desc_8, p0_.main_page AS main_page_9, p0_.hike_trail AS hike_trail_10, p0_.is_visible AS is_visible_11, p0_.sub_title_movie AS sub_title_movie_12, p0_.main_page_section_bus_stop AS main_page_section_bus_stop_13, p0_.main_page_section_recommendations_title AS main_page_section_recommendations_title_14, p0_.main_page_section_slider_title AS main_page_section_slider_title_15, p0_.main_page_section_aveiro_title AS main_page_section_aveiro_title_16, p0_.main_page_section_aveiro_description AS main_page_section_aveiro_description_17, p0_.main_page_section_rabacal_title AS main_page_section_rabacal_title_18, p0_.main_page_section_rabacal_description AS main_page_section_rabacal_description_19, p0_.main_page_section_fanal_title AS main_page_section_fanal_title_20, p0_.main_page_section_fanal_description AS main_page_section_fanal_description_21, p0_.main_page_section_fanal_link AS main_page_section_fanal_link_22, p0_.main_page_section_levada_title AS main_page_section_levada_title_23, p0_.main_page_section_levada_description AS main_page_section_levada_description_24, p0_.main_page_section_levada_link AS main_page_section_levada_link_25, p0_.main_page_section_outdoo_title AS main_page_section_outdoo_title_26, p0_.main_page_section_outdoor_description AS main_page_section_outdoor_description_27, p0_.about_us_first_section_title AS about_us_first_section_title_28, p0_.about_us_first_section_description AS about_us_first_section_description_29, p0_.show_on_list AS show_on_list_30, p0_.about_us_second_section_title AS about_us_second_section_title_31, p0_.about_us_second_section_description AS about_us_second_section_description_32, p0_.about_us_third_section_title AS about_us_third_section_title_33, p0_.about_us_third_section_description AS about_us_third_section_description_34, p0_.desc_movie AS desc_movie_35, p0_.main_page_content AS main_page_content_36, p0_.created_at AS created_at_37, p0_.updated_at AS updated_at_38, p0_.deleted_at AS deleted_at_39, p0_.meta_title AS meta_title_40, p0_.meta_description AS meta_description_41, p0_.meta_keywords AS meta_keywords_42, p0_.information_no_follow AS information_no_follow_43, p0_.og_title AS og_title_44, p0_.og_description AS og_description_45, p0_.og_image AS og_image_46, p0_.og_image_secure AS og_image_secure_47, p0_.domain_id AS domain_id_48, p0_.domain_lang_id AS domain_lang_id_49, p0_.movie_id AS movie_id_50, p0_.gallery_id AS gallery_id_51 FROM page p0_ INNER JOIN domain d1_ ON p0_.domain_id = d1_.id INNER JOIN domain_lang d2_ ON p0_.domain_lang_id = d2_.id WHERE (d2_.slug = ? AND d1_.name = ? AND p0_.show_on_list = 1 AND p0_.is_visible = ?) AND (p0_.deleted_at IS NULL) ORDER BY p0_.id DESC LIMIT 10
Parameters:
[
  "en"
  "test-get-to-hikes.online"
  1
]
5 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:
[]
6 0.64 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
]
7 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:
[
  345
]
8 0.75 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
]
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:
[
  346
]
10 0.75 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
]
11 0.68 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
]
12 0.71 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:
[
  103
]
13 0.84 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:
[
  103
]

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\BaseDomain
  • The association App\Entity\BaseDomain#domain refers to the inverse side field App\Entity\Domain#menus which does not exist.
  • The association App\Entity\BaseDomain#domainLang refers to the inverse side field App\Entity\DomainLang#menus which does not exist.
App\Entity\Page
  • The association App\Entity\Page#domain refers to the inverse side field App\Entity\Domain#menus which does not exist.
  • The association App\Entity\Page#domainLang refers to the inverse side field App\Entity\DomainLang#menus which does not exist.
  • The field App\Entity\Page#modules is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PageModule#page does not contain the required 'inversedBy="modules"' attribute.
  • The field App\Entity\Page#buttons is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PageButton#page does not contain the required 'inversedBy="buttons"' attribute.
  • The mappings App\Entity\Page#programs and App\Entity\PageProgram#page are inconsistent with each other.
  • The mappings App\Entity\Page#sections and App\Entity\PageSection#page are inconsistent with each other.
  • The field App\Entity\Page#accordations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PageAccordation#page does not contain the required 'inversedBy="accordations"' attribute.
  • The field App\Entity\Page#faqs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PageFaq#page does not contain the required 'inversedBy="faqs"' attribute.
  • The mappings App\Entity\Page#news and App\Entity\PageNews#page are inconsistent with each other.
  • The field App\Entity\Page#sliders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PageSlider#page does not contain the required 'inversedBy="sliders"' attribute.
App\Entity\Domain No errors.
App\Entity\DomainLang 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.
Sonata\MediaBundle\Entity\BaseGallery No errors.
App\Entity\SonataMediaGallery No errors.
App\Entity\Menu
  • The association App\Entity\Menu#domain refers to the inverse side field App\Entity\Domain#menus which does not exist.
  • The association App\Entity\Menu#domainLang refers to the inverse side field App\Entity\DomainLang#menus which does not exist.
App\Entity\PageModule No errors.
App\Entity\PageButton No errors.
App\Entity\PageIcon
  • The association App\Entity\PageIcon#domain refers to the inverse side field App\Entity\Domain#menus which does not exist.
  • The association App\Entity\PageIcon#domainLang refers to the inverse side field App\Entity\DomainLang#menus which does not exist.
App\Entity\PageProgram
  • The association App\Entity\PageProgram#domain refers to the inverse side field App\Entity\Domain#menus which does not exist.
  • The association App\Entity\PageProgram#domainLang refers to the inverse side field App\Entity\DomainLang#menus which does not exist.
App\Entity\PageSection
  • The association App\Entity\PageSection#domain refers to the inverse side field App\Entity\Domain#menus which does not exist.
  • The association App\Entity\PageSection#domainLang refers to the inverse side field App\Entity\DomainLang#menus which does not exist.
App\Entity\PageAccordation
  • The association App\Entity\PageAccordation#domain refers to the inverse side field App\Entity\Domain#menus which does not exist.
  • The association App\Entity\PageAccordation#domainLang refers to the inverse side field App\Entity\DomainLang#menus which does not exist.
App\Entity\PageFaq
  • The association App\Entity\PageFaq#domain refers to the inverse side field App\Entity\Domain#menus which does not exist.
  • The association App\Entity\PageFaq#domainLang refers to the inverse side field App\Entity\DomainLang#menus which does not exist.
App\Entity\PageNews
  • The association App\Entity\PageNews#domain refers to the inverse side field App\Entity\Domain#menus which does not exist.
  • The association App\Entity\PageNews#domainLang refers to the inverse side field App\Entity\DomainLang#menus which does not exist.
  • The association App\Entity\PageNews#news refers to the inverse side field App\Entity\News#news which does not exist.
App\Entity\PageSlider No errors.
Sonata\MediaBundle\Entity\BaseGalleryItem No errors.
App\Entity\SonataMediaGalleryItem No errors.