Query Metrics
15
Database Queries
13
Different statements
11.04 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.35 ms |
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_.idname = ? AND (o1_.title IS NOT NULL AND o1_.title <> '') AND o1_.lang = ? AND (o1_.slug IS NOT NULL AND o1_.slug <> '')
Parameters:
[ "page_exhibitions" "pl" ] |
2 | 0.52 ms |
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_.title IS NOT NULL AND o1_.title <> '' AND o1_.lang = ?) GROUP BY o0_.id, o0_.created_at, o0_.updated_at, o0_.stat, o0_.ord, o0_.image_path, o0_.publish_date, o0_.background, o0_.show_header, o0_.header_height, o0_.logo_visible, o0_.header_background ORDER BY o0_.ord DESC LIMIT 12
Parameters:
[
"pl"
]
|
3 | 0.22 ms |
SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM openform_exhibition o0_ LEFT JOIN openform_exhibition_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.stat = 1 AND (o1_.title IS NOT NULL AND o1_.title <> '' AND o1_.lang = ?) ORDER BY o0_.ord DESC
Parameters:
[
"pl"
]
|
4 | 0.71 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.parent_id AS parent_id_4, t0.file_path AS file_path_5, t0.name AS name_6, t0.type AS type_7, t0.width AS width_8, t0.height AS height_9, t0.crop_x AS crop_x_10, t0.crop_y AS crop_y_11, t0.crop_width AS crop_width_12, t0.crop_height AS crop_height_13, t0.parent_id AS parent_id_14 FROM openform_page_thumb t0 WHERE t0.parent_id = ?
Parameters:
[
116
]
|
5 | 0.40 ms |
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"
]
|
6 | 0.26 ms |
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"
]
|
7 | 0.42 ms |
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"
]
|
8 | 0.29 ms |
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"
]
|
9 | 1.05 ms |
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_page_section t0 WHERE t0.parent_id = ? ORDER BY t0.ord DESC
Parameters:
[
116
]
|
10 | 2.71 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.parent_id AS parent_id_4, t0.file_path AS file_path_5, t0.name AS name_6, t0.type AS type_7, t0.width AS width_8, t0.height AS height_9, t0.crop_x AS crop_x_10, t0.crop_y AS crop_y_11, t0.crop_width AS crop_width_12, t0.crop_height AS crop_height_13, t0.parent_id AS parent_id_14 FROM openform_exhibition_thumb t0 WHERE t0.parent_id = ?
Parameters:
[
11
]
|
11 | 2.68 ms |
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.parent_id AS parent_id_10 FROM openform_exhibition_logo t0 WHERE t0.parent_id = ? ORDER BY t0.ord DESC
Parameters:
[
11
]
|
12 | 0.17 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.parent_id AS parent_id_4, t0.file_path AS file_path_5, t0.name AS name_6, t0.type AS type_7, t0.width AS width_8, t0.height AS height_9, t0.crop_x AS crop_x_10, t0.crop_y AS crop_y_11, t0.crop_width AS crop_width_12, t0.crop_height AS crop_height_13, t0.parent_id AS parent_id_14 FROM openform_exhibition_thumb t0 WHERE t0.parent_id = ?
Parameters:
[
9
]
|
13 | 0.16 ms |
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.parent_id AS parent_id_10 FROM openform_exhibition_logo t0 WHERE t0.parent_id = ? ORDER BY t0.ord DESC
Parameters:
[
9
]
|
14 | 0.58 ms |
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_menu = 1 AND o1_.lang = ? AND o1_.title IS NOT NULL AND o1_.slug IS NOT NULL ORDER BY o0_.foot_menu_ord ASC
Parameters:
[
"pl"
]
|
15 | 0.51 ms |
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"
]
|
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\Page | No errors. |
App\Package\Openform\Entity\Exhibition | No errors. |
App\Package\Openform\Entity\ExhibitionDepartment | 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\Search | No errors. |
App\Package\Openform\Entity\PageSection | No errors. |
App\Package\Admin\Main\Entity\AdminModule | No errors. |
App\Package\Openform\Entity\AboutUs | No errors. |
App\Package\Openform\Entity\News | No errors. |
App\Package\Openform\Entity\Proposal | No errors. |
App\Package\Openform\Entity\Mission | 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\ExhibitionTextSection | No errors. |
App\Package\Openform\Entity\MenuPage | 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\Museum | 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\Archive | 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\PrivateCollection | 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\PageSectionTranslation | No errors. |
App\Package\Openform\Entity\PageBlockTranslation | No errors. |
App\Package\Openform\Entity\PageBlockThumb | No errors. |
App\Package\Openform\Entity\Gallery | No errors. |
App\Package\Openform\Entity\Logotypes | No errors. |
App\Package\Openform\Entity\Filesets | No errors. |
App\Package\Openform\Entity\Faq | No errors. |