Query Metrics
11
Database Queries
7
Different statements
21.92 ms
Query time
11
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
7.33 ms (33.46%) |
1 |
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_.url = ? AND p0_.is_visible = ?) AND (p0_.deleted_at IS NULL)
Parameters:
[ "en" "test-get-to-hikes.online" "inspirations" 1 ] |
5.62 ms (25.65%) |
1 |
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)
Parameters:
[ "en" "test-get-to-hikes.online" 1 ] |
4.30 ms (19.64%) |
5 |
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
]
|
1.92 ms (8.74%) |
1 |
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"
]
|
0.98 ms (4.48%) |
1 |
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:
[] |
0.94 ms (4.31%) |
1 |
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"
]
|
0.81 ms (3.70%) |
1 |
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
]
|
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\Domain | No errors. |
Sonata\MediaBundle\Entity\BaseMedia |
|
App\Entity\SonataMediaMedia |
|
App\Entity\DomainLang | No errors. |
App\Entity\BaseDomain |
|
App\Entity\Page |
|
Sonata\MediaBundle\Entity\BaseGallery | No errors. |
App\Entity\SonataMediaGallery | No errors. |
App\Entity\Menu |
|
App\Entity\PageModule | No errors. |
App\Entity\PageButton | No errors. |
App\Entity\PageIcon |
|
App\Entity\PageProgram |
|
App\Entity\PageSection |
|
App\Entity\PageAccordation |
|
App\Entity\PageFaq |
|
App\Entity\PageNews |
|
App\Entity\PageSlider | No errors. |
Sonata\MediaBundle\Entity\BaseGalleryItem | No errors. |
App\Entity\SonataMediaGalleryItem | No errors. |