Query Metrics
46
Database Queries
26
Different statements
28.98 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
4.55 ms (15.70%) |
2 |
SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM openform_search o0_ LEFT JOIN openform_search_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_.properties_fields LIKE ? ORDER BY o0_.ord DESC
Parameters:
[ "pl" "%antiquePhisicalAttributeMain|xxx%" ] |
3.39 ms (11.68%) |
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_.entity_name AS entity_name_5, o0_.range_path AS range_path_6, o0_.root_parent AS root_parent_7, o0_.root_parent_id AS root_parent_id_8, o1_.id AS id_9, o1_.created_at AS created_at_10, o1_.updated_at AS updated_at_11, o1_.translatable_id AS translatable_id_12, o1_.lang AS lang_13, o1_.title AS title_14, o1_.text AS text_15, o1_.properties_fields AS properties_fields_16, o0_.page_id AS page_id_17, o0_.menu_page_id AS menu_page_id_18, o0_.news_id AS news_id_19, o0_.museum_id AS museum_id_20, o0_.museum_department_id AS museum_department_id_21, o0_.archive_id AS archive_id_22, o0_.archive_department_id AS archive_department_id_23, o0_.private_collection_id AS private_collection_id_24, o0_.private_collection_department_id AS private_collection_department_id_25, o0_.proposal_id AS proposal_id_26, o0_.antique_id AS antique_id_27, o0_.antique_suit_id AS antique_suit_id_28, o0_.relict_id AS relict_id_29, o0_.relict_pack_id AS relict_pack_id_30, o0_.about_us_id AS about_us_id_31, o0_.mission_id AS mission_id_32, o0_.exhibition_id AS exhibition_id_33, o0_.exhibition_department_id AS exhibition_department_id_34, o1_.translatable_id AS translatable_id_35 FROM openform_search o0_ LEFT JOIN openform_search_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_.properties_fields LIKE ? GROUP BY o0_.id, o0_.created_at, o0_.updated_at, o0_.stat, o0_.ord, o0_.entity_name, o0_.range_path, o0_.root_parent, o0_.root_parent_id, o0_.page_id, o0_.menu_page_id, o0_.news_id, o0_.museum_id, o0_.museum_department_id, o0_.archive_id, o0_.archive_department_id, o0_.private_collection_id, o0_.private_collection_department_id, o0_.proposal_id, o0_.antique_id, o0_.antique_suit_id, o0_.relict_id, o0_.relict_pack_id, o0_.about_us_id, o0_.mission_id, o0_.exhibition_id, o0_.exhibition_department_id ORDER BY o0_.ord DESC LIMIT 10
Parameters:
[ "pl" "%antiquePhisicalAttributeMain|xxx%" ] |
1.84 ms (6.37%) |
4 |
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.image2path AS image2path_7, t0.publish_date AS publish_date_8, t0.template_id AS template_id_9, t0.is_inverted_template AS is_inverted_template_10, t0.thumbs_height AS thumbs_height_11, t0.thumbs_background_color AS thumbs_background_color_12, t0.slider_thumbs_background_color AS slider_thumbs_background_color_13, t0.navi_background_color AS navi_background_color_14, t0.image_background_color AS image_background_color_15, t0.text_area_width AS text_area_width_16, t0.year AS year_17, t0.month AS month_18, t0.day AS day_19, t0.age AS age_20, t0.year_to AS year_to_21, t0.month_to AS month_to_22, t0.day_to AS day_to_23, t0.age_to AS age_to_24, t0.document_year AS document_year_25, t0.document_month AS document_month_26, t0.document_day AS document_day_27, t0.document_age AS document_age_28, t0.object_year AS object_year_29, t0.object_age AS object_age_30, t0.photo_creation_year AS photo_creation_year_31, t0.photo_creation_month AS photo_creation_month_32, t0.photo_creation_day AS photo_creation_day_33, t0.photo_creation_age AS photo_creation_age_34, t0.purchase_year AS purchase_year_35, t0.purchase_month AS purchase_month_36, t0.purchase_day AS purchase_day_37, t0.purchase_age AS purchase_age_38, t0.shown_object_year AS shown_object_year_39, t0.shown_object_age AS shown_object_age_40, t0.dimensions AS dimensions_41, t0.background AS background_42, t0.background2 AS background2_43, t0.inventory_number AS inventory_number_44, t0.url AS url_45, t0.image_width_percent AS image_width_percent_46, t0.image_height AS image_height_47, t0.cols_design AS cols_design_48, t0.antique_suit_id AS antique_suit_id_49, t0.antique_owner_id AS antique_owner_id_50, t0.antique_storage_institution_id AS antique_storage_institution_id_51, t0.antique_place_id AS antique_place_id_52, t0.antique_scene_id AS antique_scene_id_53, t0.antique_scene_additional_1_id AS antique_scene_additional_1_id_54, t0.antique_scene_additional_2_id AS antique_scene_additional_2_id_55, t0.antique_scene_additional_3_id AS antique_scene_additional_3_id_56, t0.country_id AS country_id_57, t0.region_id AS region_id_58, t0.geographical_name_id AS geographical_name_id_59, t0.antique_storage_place_id AS antique_storage_place_id_60, t0.antique_creation_institution_id AS antique_creation_institution_id_61, t0.antique_creation_place_id AS antique_creation_place_id_62 FROM openform_antique t0 WHERE t0.id = ?
Parameters:
[
17
]
|
1.75 ms (6.04%) |
4 |
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.text AS text_12, t0.text2 AS text2_13, t0.desc_place_additional AS desc_place_additional_14, t0.desc_place AS desc_place_15, t0.place_name_detailed AS place_name_detailed_16, t0.description AS description_17, t0.artistic_description AS artistic_description_18, t0.artistic_description_additional AS artistic_description_additional_19, t0.background AS background_20, t0.inscription AS inscription_21, t0.antique_phisical_attribute_additional4 AS antique_phisical_attribute_additional4_22, t0.antique_phisical_attribute_additional5 AS antique_phisical_attribute_additional5_23, t0.additional_informations AS additional_informations_24, t0.owners_additional_informations AS owners_additional_informations_25, t0.alt AS alt_26, t0.folk_context AS folk_context_27, t0.folk_people_context AS folk_people_context_28, t0.origin_history AS origin_history_29, t0.document_history AS document_history_30, t0.document_description_additional AS document_description_additional_31, t0.object_history AS object_history_32, t0.place_exactly AS place_exactly_33, t0.shown_object_owner AS shown_object_owner_34, t0.shown_object_owner_description AS shown_object_owner_description_35, t0.shown_object_description AS shown_object_description_36, t0.owner_copyrights AS owner_copyrights_37, t0.translatable_id AS translatable_id_38 FROM openform_antique_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
17
]
|
1.62 ms (5.58%) |
2 |
SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM openform_search o0_ LEFT JOIN openform_search_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 (((o0_.root_parent = 'Museum' AND o0_.root_parent_id IN (?)))) AND o1_.properties_fields LIKE ? ORDER BY o0_.ord DESC
Parameters:
[ "pl" [ 3 ] "%antiquePhisicalAttributeMain|xxx%" ] |
1.50 ms (5.19%) |
1 |
SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM openform_search o0_ LEFT JOIN openform_search_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 (o0_.root_parent = 'Museum') AND o1_.properties_fields LIKE ? ORDER BY o0_.ord DESC
Parameters:
[ "pl" "%antiquePhisicalAttributeMain|xxx%" ] |
1.29 ms (4.44%) |
2 |
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"
]
|
1.28 ms (4.41%) |
4 |
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_antique_thumb t0 WHERE t0.parent_id = ?
Parameters:
[
17
]
|
1.18 ms (4.08%) |
1 |
SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM openform_search o0_ LEFT JOIN openform_search_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 (o0_.root_parent = 'Exhibition') AND o1_.properties_fields LIKE ? ORDER BY o0_.ord DESC
Parameters:
[ "pl" "%antiquePhisicalAttributeMain|xxx%" ] |
1.16 ms (4.00%) |
2 |
SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM openform_search o0_ LEFT JOIN openform_search_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 (((o0_.root_parent = 'Exhibition' AND o0_.root_parent_id IN (?)))) AND o1_.properties_fields LIKE ? ORDER BY o0_.ord DESC
Parameters:
[ "pl" [ 11 ] "%antiquePhisicalAttributeMain|xxx%" ] |
1.00 ms (3.45%) |
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_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"
]
|
0.95 ms (3.28%) |
2 |
SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM openform_search o0_ LEFT JOIN openform_search_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 (((o0_.root_parent = 'Archive' AND o0_.root_parent_id IN (?)))) AND o1_.properties_fields LIKE ? ORDER BY o0_.ord DESC
Parameters:
[ "pl" [ 1 ] "%antiquePhisicalAttributeMain|xxx%" ] |
0.89 ms (3.06%) |
2 |
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.87 ms (2.99%) |
2 |
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.83 ms (2.88%) |
2 |
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.74 ms (2.56%) |
1 |
SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM openform_search o0_ LEFT JOIN openform_search_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 (((o0_.root_parent = 'PrivateCollection' AND o0_.root_parent_id IN (?)))) AND o1_.properties_fields LIKE ? ORDER BY o0_.ord DESC
Parameters:
[ "pl" [ 2 ] "%antiquePhisicalAttributeMain|xxx%" ] |
0.70 ms (2.41%) |
2 |
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.text AS text_12, t0.short_lead AS short_lead_13, t0.alt AS alt_14, t0.translatable_id AS translatable_id_15 FROM openform_antique_suit_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
11
]
|
0.51 ms (1.75%) |
2 |
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.publish_date AS publish_date_7, t0.antique_form_design AS antique_form_design_8, t0.background AS background_9, t0.museum_department_id AS museum_department_id_10, t0.archive_department_id AS archive_department_id_11, t0.private_collection_department_id AS private_collection_department_id_12 FROM openform_antique_suit t0 WHERE t0.id = ?
Parameters:
[
11
]
|
0.50 ms (1.73%) |
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.50 ms (1.73%) |
1 |
SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM openform_search o0_ LEFT JOIN openform_search_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 (o0_.root_parent = 'Archive') AND o1_.properties_fields LIKE ? ORDER BY o0_.ord DESC
Parameters:
[ "pl" "%antiquePhisicalAttributeMain|xxx%" ] |
0.45 ms (1.55%) |
2 |
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.publish_date AS publish_date_7, t0.is_skipped AS is_skipped_8, t0.background AS background_9, t0.museum_id AS museum_id_10, t0.parent_id AS parent_id_11 FROM openform_museum_department t0 WHERE t0.id = ?
Parameters:
[
2
]
|
0.44 ms (1.51%) |
1 |
SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM openform_search o0_ LEFT JOIN openform_search_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 (o0_.root_parent = 'PrivateCollection') AND o1_.properties_fields LIKE ? ORDER BY o0_.ord DESC
Parameters:
[ "pl" "%antiquePhisicalAttributeMain|xxx%" ] |
0.33 ms (1.14%) |
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_.idname = ? AND (o1_.title IS NOT NULL AND o1_.title <> '') AND o1_.lang = ? AND (o1_.slug IS NOT NULL AND o1_.slug <> '')
Parameters:
[ "page_search" "pl" ] |
0.33 ms (1.14%) |
1 |
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.text AS text_12, t0.short_lead AS short_lead_13, t0.alt AS alt_14, t0.translatable_id AS translatable_id_15 FROM openform_museum_department_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
2
]
|
0.20 ms (0.69%) |
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.image_path AS image_path_6, t0.publish_date AS publish_date_7, t0.menu_variant AS menu_variant_8, t0.logo_visible AS logo_visible_9, t0.background AS background_10, t0.header_background AS header_background_11, t0.show_header AS show_header_12, t0.header_height AS header_height_13 FROM openform_museum t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.19 ms (0.66%) |
1 |
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.text AS text_12, t0.short_lead AS short_lead_13, t0.alt AS alt_14, t0.translatable_id AS translatable_id_15 FROM openform_museum_translation t0 WHERE t0.translatable_id = ?
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\Package\Openform\Entity\Search | No errors. |
App\Package\Openform\Entity\Page | No errors. |
App\Package\Openform\Entity\SearchTranslation | No errors. |
App\Package\Openform\Entity\MenuPage | No errors. |
App\Package\Openform\Entity\News | No errors. |
App\Package\Openform\Entity\Museum | No errors. |
App\Package\Openform\Entity\MuseumDepartment | No errors. |
App\Package\Openform\Entity\Archive | No errors. |
App\Package\Openform\Entity\ArchiveDepartment | No errors. |
App\Package\Openform\Entity\PrivateCollection | No errors. |
App\Package\Openform\Entity\PrivateCollectionDepartment | No errors. |
App\Package\Openform\Entity\Proposal | No errors. |
App\Package\Openform\Entity\Antique | No errors. |
App\Package\Openform\Entity\AntiqueSuit | No errors. |
App\Package\Openform\Entity\Relict | No errors. |
App\Package\Openform\Entity\RelictPack | No errors. |
App\Package\Openform\Entity\AboutUs | No errors. |
App\Package\Openform\Entity\Mission | 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\PageSection | No errors. |
App\Package\Admin\Main\Entity\AdminModule | 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\ExhibitionTextSection | 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\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\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\AntiqueOwner | No errors. |
App\Package\Openform\Entity\AntiqueStorageInstitution | No errors. |
App\Package\Openform\Entity\AntiquePlace | No errors. |
App\Package\Openform\Entity\AntiqueScene | No errors. |
App\Package\Openform\Entity\Country | No errors. |
App\Package\Openform\Entity\Region | No errors. |
App\Package\Openform\Entity\GeographicalName | No errors. |
App\Package\Openform\Entity\AntiqueStoragePlace | No errors. |
App\Package\Openform\Entity\AntiqueCreationInstitution | No errors. |
App\Package\Openform\Entity\AntiqueCreationPlace | No errors. |
App\Package\Openform\Entity\AntiqueTranslation | No errors. |
App\Package\Openform\Entity\AntiqueThumb | No errors. |
App\Package\Openform\Entity\AntiqueImage | No errors. |
App\Package\Openform\Entity\AntiqueBlock | No errors. |
App\Package\Openform\Entity\AntiqueSection | No errors. |
App\Package\Openform\Entity\Artist | No errors. |
App\Package\Openform\Entity\AntiqueType | No errors. |
App\Package\Openform\Entity\AntiqueSceneKind | No errors. |
App\Package\Openform\Entity\AntiqueCopyrights | No errors. |
App\Package\Openform\Entity\AntiquePhisicalAttribute | No errors. |
App\Package\Openform\Entity\AntiqueMaterial | No errors. |
App\Package\Openform\Entity\AntiqueTechnique | No errors. |
App\Package\Openform\Entity\AntiqueTheme | No errors. |
App\Package\Openform\Entity\AntiqueCharacterKind | No errors. |
App\Package\Openform\Entity\AntiqueArtifact | No errors. |
App\Package\Openform\Entity\AntiqueSuitTranslation | No errors. |
App\Package\Openform\Entity\AntiqueSuitThumb | No errors. |
App\Package\Openform\Entity\AntiqueSuitBlock | No errors. |
App\Package\Openform\Entity\MuseumDepartmentTranslation | No errors. |
App\Package\Openform\Entity\MuseumDepartmentThumb | No errors. |
App\Package\Openform\Entity\MuseumDepartmentBlock | No errors. |
App\Package\Openform\Entity\MuseumDepartmentSection | No errors. |