Query Metrics
27
Database Queries
12
Different statements
11.19 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.96 ms (26.46%) |
1 |
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.stat AS stat_3, o0_.ord AS ord_4, o0_.image_path AS image_path_5, o0_.video_path AS video_path_6, o0_.yt_code AS yt_code_7, o0_.parent_id AS parent_id_8, o0_.publish_date AS publish_date_9, o0_.target_blank AS target_blank_10, o0_.show_in_main_menu AS show_in_main_menu_11, o0_.show_in_footer_menu AS show_in_footer_menu_12, o0_.foot_menu_ord AS foot_menu_ord_13, o0_.background AS background_14, o0_.main_content_padding_top AS main_content_padding_top_15, o0_.main_content_padding_bottom AS main_content_padding_bottom_16, o1_.id AS id_17, o1_.created_at AS created_at_18, o1_.updated_at AS updated_at_19, o1_.translatable_id AS translatable_id_20, o1_.lang AS lang_21, o1_.meta_title AS meta_title_22, o1_.meta_description AS meta_description_23, o1_.meta_keywords AS meta_keywords_24, o1_.title AS title_25, o1_.slug AS slug_26, o1_.title_html AS title_html_27, o1_.sub_title AS sub_title_28, o1_.text AS text_29, o1_.short_lead AS short_lead_30, o1_.link AS link_31, o1_.alt AS alt_32, o0_.museum_id AS museum_id_33, o0_.archive_id AS archive_id_34, o0_.private_collection_id AS private_collection_id_35, o0_.exhibition_id AS exhibition_id_36, o0_.proposal_id AS proposal_id_37, o0_.mission_id AS mission_id_38, o0_.about_us_id AS about_us_id_39, o0_.parent_id AS parent_id_40, o1_.translatable_id AS translatable_id_41 FROM openform_menu_page o2_, openform_menu_page o0_ LEFT JOIN openform_menu_page_translation o1_ ON o0_.id = o1_.translatable_id LEFT JOIN openform_menu_page o3_ ON o0_.parent_id = o3_.id LEFT JOIN openform_menu_page o4_ ON o3_.parent_id = o4_.id WHERE o0_.stat = 1 AND o0_.show_in_footer_menu = 1 AND o1_.lang = ? AND o1_.title IS NOT NULL AND o1_.slug IS NOT NULL AND (o0_.museum_id = ? OR o3_.museum_id = ? OR o4_.museum_id = ?) ORDER BY o0_.foot_menu_ord ASC
Parameters:
[ "pl" 2 2 2 ] |
1.96 ms (17.54%) |
10 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.stat AS stat_4, t0.ord AS ord_5, t0.image_path AS image_path_6, t0.video_path AS video_path_7, t0.yt_code AS yt_code_8, t0.parent_id AS parent_id_9, t0.publish_date AS publish_date_10, t0.target_blank AS target_blank_11, t0.show_in_main_menu AS show_in_main_menu_12, t0.show_in_footer_menu AS show_in_footer_menu_13, t0.foot_menu_ord AS foot_menu_ord_14, t0.background AS background_15, t0.main_content_padding_top AS main_content_padding_top_16, t0.main_content_padding_bottom AS main_content_padding_bottom_17, t0.museum_id AS museum_id_18, t0.archive_id AS archive_id_19, t0.private_collection_id AS private_collection_id_20, t0.exhibition_id AS exhibition_id_21, t0.proposal_id AS proposal_id_22, t0.mission_id AS mission_id_23, t0.about_us_id AS about_us_id_24, t0.parent_id AS parent_id_25 FROM openform_menu_page t0 WHERE t0.parent_id = ? ORDER BY t0.ord DESC
Parameters:
[
33
]
|
1.29 ms (11.51%) |
1 |
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.stat AS stat_3, o0_.ord AS ord_4, o0_.image_path AS image_path_5, o0_.video_path AS video_path_6, o0_.yt_code AS yt_code_7, o0_.parent_id AS parent_id_8, o0_.publish_date AS publish_date_9, o0_.target_blank AS target_blank_10, o0_.show_in_main_menu AS show_in_main_menu_11, o0_.show_in_footer_menu AS show_in_footer_menu_12, o0_.foot_menu_ord AS foot_menu_ord_13, o0_.background AS background_14, o0_.main_content_padding_top AS main_content_padding_top_15, o0_.main_content_padding_bottom AS main_content_padding_bottom_16, o1_.id AS id_17, o1_.created_at AS created_at_18, o1_.updated_at AS updated_at_19, o1_.translatable_id AS translatable_id_20, o1_.lang AS lang_21, o1_.meta_title AS meta_title_22, o1_.meta_description AS meta_description_23, o1_.meta_keywords AS meta_keywords_24, o1_.title AS title_25, o1_.slug AS slug_26, o1_.title_html AS title_html_27, o1_.sub_title AS sub_title_28, o1_.text AS text_29, o1_.short_lead AS short_lead_30, o1_.link AS link_31, o1_.alt AS alt_32, o0_.museum_id AS museum_id_33, o0_.archive_id AS archive_id_34, o0_.private_collection_id AS private_collection_id_35, o0_.exhibition_id AS exhibition_id_36, o0_.proposal_id AS proposal_id_37, o0_.mission_id AS mission_id_38, o0_.about_us_id AS about_us_id_39, o0_.parent_id AS parent_id_40, o1_.translatable_id AS translatable_id_41 FROM openform_menu_page o2_, openform_menu_page o0_ LEFT JOIN openform_menu_page_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND o0_.show_in_main_menu = 1 AND o0_.parent_id IS NULL AND o1_.lang = ? AND o1_.title IS NOT NULL AND o1_.slug IS NOT NULL AND o0_.museum_id = ? ORDER BY o0_.ord DESC
Parameters:
[ "pl" 2 ] |
1.01 ms (8.99%) |
7 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.translatable_id AS translatable_id_4, t0.lang AS lang_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.meta_keywords AS meta_keywords_8, t0.title AS title_9, t0.slug AS slug_10, t0.title_html AS title_html_11, t0.sub_title AS sub_title_12, t0.text AS text_13, t0.short_lead AS short_lead_14, t0.link AS link_15, t0.alt AS alt_16, t0.translatable_id AS translatable_id_17 FROM openform_menu_page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
47
]
|
0.69 ms (6.13%) |
1 |
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.stat AS stat_3, o0_.ord AS ord_4, o0_.image_path AS image_path_5, o0_.parent_id AS parent_id_6, o0_.admin_module_id AS admin_module_id_7, o0_.idname AS idname_8, o0_.is_not_searchable AS is_not_searchable_9, o0_.statable AS statable_10, o0_.editable AS editable_11, o0_.deletable AS deletable_12, o0_.subpageable AS subpageable_13, o0_.main_menu AS main_menu_14, o0_.main_menu_column AS main_menu_column_15, o0_.blank AS blank_16, o0_.foot_menu AS foot_menu_17, o0_.foot_menu_ord AS foot_menu_ord_18, o0_.foot_menu2 AS foot_menu2_19, o0_.foot_menu2ord AS foot_menu2ord_20, o0_.background AS background_21, o0_.show_children AS show_children_22, o0_.template_id AS template_id_23, o0_.main_content_padding_top AS main_content_padding_top_24, o0_.main_content_padding_bottom AS main_content_padding_bottom_25, o1_.id AS id_26, o1_.created_at AS created_at_27, o1_.updated_at AS updated_at_28, o1_.translatable_id AS translatable_id_29, o1_.lang AS lang_30, o1_.meta_title AS meta_title_31, o1_.meta_description AS meta_description_32, o1_.meta_keywords AS meta_keywords_33, o1_.title AS title_34, o1_.slug AS slug_35, o1_.title_html AS title_html_36, o1_.text AS text_37, o1_.sub_title AS sub_title_38, o1_.short_lead AS short_lead_39, o1_.link AS link_40, o1_.alt AS alt_41, o0_.parent_id AS parent_id_42, o0_.admin_module_id AS admin_module_id_43, o1_.translatable_id AS translatable_id_44 FROM openform_page o0_ LEFT JOIN openform_page_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND o0_.foot_menu2 = 1 AND o1_.lang = ? AND o1_.title IS NOT NULL AND o1_.slug IS NOT NULL ORDER BY o0_.foot_menu2ord ASC
Parameters:
[
"pl"
]
|
0.57 ms (5.12%) |
1 |
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.stat AS stat_3, o0_.ord AS ord_4, o0_.image_path AS image_path_5, o0_.publish_date AS publish_date_6, o0_.menu_variant AS menu_variant_7, o0_.logo_visible AS logo_visible_8, o0_.background AS background_9, o0_.header_background AS header_background_10, o0_.show_header AS show_header_11, o0_.header_height AS header_height_12, o1_.id AS id_13, o1_.created_at AS created_at_14, o1_.updated_at AS updated_at_15, o1_.translatable_id AS translatable_id_16, o1_.lang AS lang_17, o1_.meta_title AS meta_title_18, o1_.meta_description AS meta_description_19, o1_.meta_keywords AS meta_keywords_20, o1_.title AS title_21, o1_.slug AS slug_22, o1_.title_html AS title_html_23, o1_.text AS text_24, o1_.short_lead AS short_lead_25, o1_.alt AS alt_26, o1_.translatable_id AS translatable_id_27 FROM openform_museum o0_ LEFT JOIN openform_museum_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND (o1_.lang = ? AND o1_.title IS NOT NULL AND o1_.slug IS NOT NULL) ORDER BY o1_.title ASC
Parameters:
[
"pl"
]
|
0.53 ms (4.75%) |
1 |
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.stat AS stat_3, o0_.ord AS ord_4, o0_.image_path AS image_path_5, o0_.publish_date AS publish_date_6, o0_.menu_variant AS menu_variant_7, o0_.logo_visible AS logo_visible_8, o0_.background AS background_9, o0_.header_background AS header_background_10, o0_.show_header AS show_header_11, o0_.header_height AS header_height_12, o1_.id AS id_13, o1_.created_at AS created_at_14, o1_.updated_at AS updated_at_15, o1_.translatable_id AS translatable_id_16, o1_.lang AS lang_17, o1_.meta_title AS meta_title_18, o1_.meta_description AS meta_description_19, o1_.meta_keywords AS meta_keywords_20, o1_.title AS title_21, o1_.slug AS slug_22, o1_.title_html AS title_html_23, o1_.text AS text_24, o1_.short_lead AS short_lead_25, o1_.alt AS alt_26, o1_.translatable_id AS translatable_id_27 FROM openform_archive o0_ LEFT JOIN openform_archive_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND (o1_.lang = ? AND o1_.title IS NOT NULL AND o1_.slug IS NOT NULL) ORDER BY o1_.title ASC
Parameters:
[
"pl"
]
|
0.52 ms (4.67%) |
1 |
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.stat AS stat_3, o0_.ord AS ord_4, o0_.image_path AS image_path_5, o0_.video_path AS video_path_6, o0_.yt_code AS yt_code_7, o0_.parent_id AS parent_id_8, o0_.publish_date AS publish_date_9, o0_.target_blank AS target_blank_10, o0_.show_in_main_menu AS show_in_main_menu_11, o0_.show_in_footer_menu AS show_in_footer_menu_12, o0_.foot_menu_ord AS foot_menu_ord_13, o0_.background AS background_14, o0_.main_content_padding_top AS main_content_padding_top_15, o0_.main_content_padding_bottom AS main_content_padding_bottom_16, o1_.id AS id_17, o1_.created_at AS created_at_18, o1_.updated_at AS updated_at_19, o1_.translatable_id AS translatable_id_20, o1_.lang AS lang_21, o1_.meta_title AS meta_title_22, o1_.meta_description AS meta_description_23, o1_.meta_keywords AS meta_keywords_24, o1_.title AS title_25, o1_.slug AS slug_26, o1_.title_html AS title_html_27, o1_.sub_title AS sub_title_28, o1_.text AS text_29, o1_.short_lead AS short_lead_30, o1_.link AS link_31, o1_.alt AS alt_32, o0_.museum_id AS museum_id_33, o0_.archive_id AS archive_id_34, o0_.private_collection_id AS private_collection_id_35, o0_.exhibition_id AS exhibition_id_36, o0_.proposal_id AS proposal_id_37, o0_.mission_id AS mission_id_38, o0_.about_us_id AS about_us_id_39, o0_.parent_id AS parent_id_40, o1_.translatable_id AS translatable_id_41 FROM openform_menu_page o0_ LEFT JOIN openform_menu_page_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND (o1_.title IS NOT NULL AND o1_.title <> '' AND o1_.lang = ?) AND o1_.slug = ?
Parameters:
[ "pl" "strona-glowna-portalu" ] |
0.47 ms (4.22%) |
1 |
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.stat AS stat_3, o0_.ord AS ord_4, o0_.image_path AS image_path_5, o0_.publish_date AS publish_date_6, o0_.menu_variant AS menu_variant_7, o0_.logo_visible AS logo_visible_8, o0_.background AS background_9, o0_.header_background AS header_background_10, o0_.show_header AS show_header_11, o0_.header_height AS header_height_12, o1_.id AS id_13, o1_.created_at AS created_at_14, o1_.updated_at AS updated_at_15, o1_.translatable_id AS translatable_id_16, o1_.lang AS lang_17, o1_.meta_title AS meta_title_18, o1_.meta_description AS meta_description_19, o1_.meta_keywords AS meta_keywords_20, o1_.title AS title_21, o1_.slug AS slug_22, o1_.title_html AS title_html_23, o1_.text AS text_24, o1_.short_lead AS short_lead_25, o1_.alt AS alt_26, o1_.translatable_id AS translatable_id_27 FROM openform_private_collection o0_ LEFT JOIN openform_private_collection_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND (o1_.lang = ? AND o1_.title IS NOT NULL AND o1_.slug IS NOT NULL) ORDER BY o1_.title ASC
Parameters:
[
"pl"
]
|
0.45 ms (4.00%) |
1 |
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.stat AS stat_3, o0_.ord AS ord_4, o0_.image_path AS image_path_5, o0_.publish_date AS publish_date_6, o0_.background AS background_7, o0_.show_header AS show_header_8, o0_.header_height AS header_height_9, o0_.logo_visible AS logo_visible_10, o0_.header_background AS header_background_11, o1_.id AS id_12, o1_.created_at AS created_at_13, o1_.updated_at AS updated_at_14, o1_.translatable_id AS translatable_id_15, o1_.lang AS lang_16, o1_.meta_title AS meta_title_17, o1_.meta_description AS meta_description_18, o1_.meta_keywords AS meta_keywords_19, o1_.title AS title_20, o1_.slug AS slug_21, o1_.title_html AS title_html_22, o1_.text AS text_23, o1_.short_lead AS short_lead_24, o1_.alt AS alt_25, o1_.translatable_id AS translatable_id_26 FROM openform_exhibition o0_ LEFT JOIN openform_exhibition_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND (o1_.lang = ? AND o1_.title IS NOT NULL AND o1_.slug IS NOT NULL) ORDER BY o1_.title ASC
Parameters:
[
"pl"
]
|
0.40 ms (3.55%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.stat AS stat_4, t0.ord AS ord_5, t0.type AS type_6, t0.hr_weight AS hr_weight_7, t0.section_link AS section_link_8, t0.hr_background AS hr_background_9, t0.section_background AS section_background_10, t0.slider_kind AS slider_kind_11, t0.slider_position AS slider_position_12, t0.slider_background AS slider_background_13, t0.slider_top_background AS slider_top_background_14, t0.slider_bottom_background AS slider_bottom_background_15, t0.precent_collumn AS precent_collumn_16, t0.slider_height AS slider_height_17, t0.num_collumn AS num_collumn_18, t0.slider_switcher_id AS slider_switcher_id_19, t0.content_padding_left AS content_padding_left_20, t0.content_padding_right AS content_padding_right_21, t0.content_padding_top AS content_padding_top_22, t0.content_padding_bottom AS content_padding_bottom_23, t0.parent_id AS parent_id_24 FROM openform_menu_page_section t0 WHERE t0.parent_id = ? ORDER BY t0.ord DESC
Parameters:
[
33
]
|
0.34 ms (3.06%) |
1 |
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.stat AS stat_3, o0_.ord AS ord_4, o0_.image_path AS image_path_5, o0_.publish_date AS publish_date_6, o0_.menu_variant AS menu_variant_7, o0_.logo_visible AS logo_visible_8, o0_.background AS background_9, o0_.header_background AS header_background_10, o0_.show_header AS show_header_11, o0_.header_height AS header_height_12, o1_.id AS id_13, o1_.created_at AS created_at_14, o1_.updated_at AS updated_at_15, o1_.translatable_id AS translatable_id_16, o1_.lang AS lang_17, o1_.meta_title AS meta_title_18, o1_.meta_description AS meta_description_19, o1_.meta_keywords AS meta_keywords_20, o1_.title AS title_21, o1_.slug AS slug_22, o1_.title_html AS title_html_23, o1_.text AS text_24, o1_.short_lead AS short_lead_25, o1_.alt AS alt_26, o1_.translatable_id AS translatable_id_27 FROM openform_museum o0_ LEFT JOIN openform_museum_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND (o1_.title IS NOT NULL AND o1_.title <> '' AND o1_.lang = ?) AND o1_.slug = ?
Parameters:
[ "pl" "wirtualne-muzeum-ikon" ] |
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\Package\Openform\Entity\MenuPage | No errors. |
App\Package\Openform\Entity\MenuPageTranslation | No errors. |
App\Package\Openform\Entity\MenuPageThumb | No errors. |
App\Package\Openform\Entity\MenuPageBlock | No errors. |
App\Package\Openform\Entity\Search | No errors. |
App\Package\Openform\Entity\MenuPageSection | No errors. |
App\Package\Openform\Entity\Museum | No errors. |
App\Package\Openform\Entity\Archive | No errors. |
App\Package\Openform\Entity\PrivateCollection | No errors. |
App\Package\Openform\Entity\Exhibition | No errors. |
App\Package\Openform\Entity\Proposal | No errors. |
App\Package\Openform\Entity\Mission | No errors. |
App\Package\Openform\Entity\AboutUs | No errors. |
App\Package\Openform\Entity\MuseumTranslation | No errors. |
App\Package\Openform\Entity\MuseumThumb | No errors. |
App\Package\Openform\Entity\MuseumBlock | No errors. |
App\Package\Openform\Entity\MuseumLogo | No errors. |
App\Package\Openform\Entity\MuseumSponsor | No errors. |
App\Package\Openform\Entity\MuseumSection | No errors. |
App\Package\Openform\Entity\MuseumDepartment | No errors. |
App\Package\Openform\Entity\Config | No errors. |
App\Package\Openform\Entity\ConfigTranslation | No errors. |
App\Package\Openform\Entity\ConfigThumb | No errors. |
App\Package\Openform\Entity\ExhibitionTranslation | No errors. |
App\Package\Openform\Entity\ExhibitionThumb | No errors. |
App\Package\Openform\Entity\ExhibitionBlock | No errors. |
App\Package\Openform\Entity\ExhibitionLogo | No errors. |
App\Package\Openform\Entity\ExhibitionDepartment | No errors. |
App\Package\Openform\Entity\ExhibitionTextSection | No errors. |
App\Package\Openform\Entity\News | No errors. |
App\Package\Openform\Entity\Page | No errors. |
App\Package\Openform\Entity\ArchiveTranslation | No errors. |
App\Package\Openform\Entity\ArchiveThumb | No errors. |
App\Package\Openform\Entity\ArchiveBlock | No errors. |
App\Package\Openform\Entity\ArchiveLogo | No errors. |
App\Package\Openform\Entity\ArchiveSponsor | No errors. |
App\Package\Openform\Entity\ArchiveSection | No errors. |
App\Package\Openform\Entity\ArchiveDepartment | No errors. |
App\Package\Openform\Entity\PrivateCollectionTranslation | No errors. |
App\Package\Openform\Entity\PrivateCollectionThumb | No errors. |
App\Package\Openform\Entity\PrivateCollectionSponsor | No errors. |
App\Package\Openform\Entity\PrivateCollectionBlock | No errors. |
App\Package\Openform\Entity\PrivateCollectionSection | No errors. |
App\Package\Openform\Entity\PrivateCollectionDepartment | No errors. |
App\Package\Openform\Entity\PageTranslation | No errors. |
App\Package\Openform\Entity\PageThumb | No errors. |
App\Package\Openform\Entity\PageBlock | No errors. |
App\Package\Openform\Entity\PageSideBlock | No errors. |
App\Package\Openform\Entity\PageCategory | No errors. |
App\Package\Openform\Entity\PageImage | No errors. |
App\Package\Openform\Entity\PageSection | No errors. |
App\Package\Admin\Main\Entity\AdminModule | No errors. |