http://fpd.in.openform.pl/wyszukiwarka?year=1700

Query Metrics

44 Database Queries
24 Different statements
52.78 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
21.67 ms
(41.05%)
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"
  "%year|1700%"
]
8.78 ms
(16.64%)
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"
  "%year|1700%"
]
2.62 ms
(4.96%)
5
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:
[
  64
]
2.55 ms
(4.84%)
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
]
1.90 ms
(3.60%)
5
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:
[
  64
]
1.64 ms
(3.11%)
5
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:
[
  64
]
1.40 ms
(2.66%)
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"
  "%year|1700%"
]
1.35 ms
(2.57%)
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
  ]
  "%year|1700%"
]
1.25 ms
(2.37%)
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
  ]
  "%year|1700%"
]
1.15 ms
(2.18%)
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"
  "%year|1700%"
]
0.92 ms
(1.74%)
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_antique_suit_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  31
]
0.87 ms
(1.65%)
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.83 ms
(1.57%)
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
  ]
  "%year|1700%"
]
0.77 ms
(1.46%)
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.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.72 ms
(1.36%)
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.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:
[
  31
]
0.69 ms
(1.31%)
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.59 ms
(1.12%)
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"
]
0.51 ms
(0.96%)
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.49 ms
(0.93%)
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.49 ms
(0.92%)
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"
  "%year|1700%"
]
0.41 ms
(0.78%)
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
  ]
  "%year|1700%"
]
0.40 ms
(0.76%)
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.38 ms
(0.72%)
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"
  "%year|1700%"
]
0.38 ms
(0.72%)
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"
]

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.