https://test-get-to-hikes.online/en/inspiration/fanal-levada-dos-cedros-pr-14

Query Metrics

15 Database Queries
7 Different statements
13.31 ms Query time
5 Invalid entities

Queries

Group similar statements

# Time Info
1 1.35 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.short_desc AS short_desc_4, t0.content AS content_5, t0.position AS position_6, t0.is_visible AS is_visible_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.information_no_follow AS information_no_follow_14, t0.og_title AS og_title_15, t0.og_description AS og_description_16, t0.og_image AS og_image_17, t0.og_image_secure AS og_image_secure_18, t0.domain_id AS domain_id_19, t0.domain_lang_id AS domain_lang_id_20, t0.media_id AS media_id_21 FROM inspiration t0 WHERE t0.slug = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "fanal-levada-dos-cedros-pr-14"
]
2 0.95 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.84 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.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
Parameters:
[]
5 0.73 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 1.14 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.80 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.81 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.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:
[
  347
]
10 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:
[
  348
]
11 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:
[
  407
]
12 1.19 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.meta_keywords AS meta_keywords_7, t0.information_no_follow AS information_no_follow_8, t0.og_title AS og_title_9, t0.og_description AS og_description_10, t0.og_image AS og_image_11, t0.og_image_secure AS og_image_secure_12, t0.domain_id AS domain_id_13, t0.domain_lang_id AS domain_lang_id_14, t0.media_id AS media_id_15, t0.inspiration_id AS inspiration_id_16 FROM inspiration_gallery t0 WHERE t0.inspiration_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  27
]
13 0.80 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:
[
  388
]
14 0.81 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:
[
  389
]
15 0.85 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:
[
  390
]

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\Inspiration
  • The association App\Entity\Inspiration#domain refers to the inverse side field App\Entity\Domain#menus which does not exist.
  • The association App\Entity\Inspiration#domainLang refers to the inverse side field App\Entity\DomainLang#menus which does not exist.
  • The field App\Entity\Inspiration#galleries is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\InspirationGallery#inspiration does not contain the required 'inversedBy="galleries"' 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.
App\Entity\InspirationGallery
  • The association App\Entity\InspirationGallery#domain refers to the inverse side field App\Entity\Domain#menus which does not exist.
  • The association App\Entity\InspirationGallery#domainLang refers to the inverse side field App\Entity\DomainLang#menus which does not exist.
Sonata\MediaBundle\Entity\BaseGalleryItem No errors.
App\Entity\SonataMediaGalleryItem No errors.