Query Metrics
11
Database Queries
10
Different statements
24.63 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.34 ms |
SELECT j0_.native_title_sort_key AS native_title_sort_key_0, j0_.slug AS slug_1, j0_.import_slug AS import_slug_2, j0_.import_slug_en AS import_slug_en_3, j0_.sort_articles_by_ord AS sort_articles_by_ord_4, j0_.id AS id_5, j0_.uuid AS uuid_6, j0_.stat AS stat_7, j0_.ord AS ord_8, j0_.created_at AS created_at_9, j0_.updated_at AS updated_at_10, j0_.languages AS languages_11, j0_.native_language AS native_language_12, j0_.native_title AS native_title_13, j0_.is_archived AS is_archived_14, j0_.archived_at AS archived_at_15, j0_.import_id AS import_id_16, j0_.created_by_id AS created_by_id_17, j0_.updated_by_id AS updated_by_id_18 FROM journals j0_ WHERE (j0_.slug = ? OR j0_.import_slug = ? OR j0_.import_slug_en = ?) AND j0_.stat = 1 LIMIT 1
Parameters:
[ "aktualnosci" "aktualnosci" "aktualnosci" ] |
| 2 | 8.22 ms |
SELECT p0_.id_name AS id_name_0, p0_.is_statable AS is_statable_1, p0_.is_editable AS is_editable_2, p0_.is_deletable AS is_deletable_3, p0_.is_sub_pageable AS is_sub_pageable_4, p0_.main_menu AS main_menu_5, p0_.id AS id_6, p0_.uuid AS uuid_7, p0_.stat AS stat_8, p0_.ord AS ord_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.languages AS languages_12, p0_.native_language AS native_language_13, p0_.native_title AS native_title_14, p0_.import_id AS import_id_15, p1_.title AS title_16, p1_.description AS description_17, p1_.id AS id_18, p1_.uuid AS uuid_19, p1_.created_at AS created_at_20, p1_.updated_at AS updated_at_21, p1_.lang AS lang_22, p1_.meta_title AS meta_title_23, p1_.meta_description AS meta_description_24, p1_.meta_keywords AS meta_keywords_25, p1_.slug AS slug_26, p2_.url AS url_27, p2_.file_path AS file_path_28, p2_.property AS property_29, p2_.name AS name_30, p2_.type AS type_31, p2_.version AS version_32, p2_.width AS width_33, p2_.height AS height_34, p2_.crop_x AS crop_x_35, p2_.crop_y AS crop_y_36, p2_.crop_width AS crop_width_37, p2_.crop_height AS crop_height_38, p2_.id AS id_39, p2_.uuid AS uuid_40, p2_.created_at AS created_at_41, p2_.updated_at AS updated_at_42, p3_.type AS type_43, p3_.id AS id_44, p3_.uuid AS uuid_45, p3_.stat AS stat_46, p3_.ord AS ord_47, p3_.created_at AS created_at_48, p3_.updated_at AS updated_at_49, p4_.title AS title_50, p4_.text AS text_51, p4_.alt AS alt_52, p4_.media_position AS media_position_53, p4_.id AS id_54, p4_.uuid AS uuid_55, p4_.created_at AS created_at_56, p4_.updated_at AS updated_at_57, p4_.lang AS lang_58, p0_.parent_id AS parent_id_59, p0_.media_id AS media_id_60, p1_.parent_id AS parent_id_61, p2_.parent_id AS parent_id_62, p2_.template_id AS template_id_63, p3_.parent_id AS parent_id_64, p4_.media_id AS media_id_65, p4_.parent_id AS parent_id_66 FROM pages p0_ LEFT JOIN page_translations p1_ ON p0_.id = p1_.parent_id AND (p1_.lang = ?) LEFT JOIN page_thumbs p2_ ON p0_.id = p2_.parent_id LEFT JOIN page_blocks p3_ ON p0_.id = p3_.parent_id AND (p3_.stat = 1) LEFT JOIN page_block_translations p4_ ON p3_.id = p4_.parent_id AND (p1_.lang = ?) WHERE p0_.stat = 1 AND p1_.slug = ? AND (p1_.title IS NOT NULL AND p1_.title <> '') ORDER BY p2_.property ASC, p2_.name ASC, p2_.type ASC, p3_.ord DESC
Parameters:
[ "pl" "pl" "aktualnosci" ] |
| 3 | 9.95 ms |
SELECT n0_.working_title AS working_title_0, n0_.is_uj AS is_uj_1, n0_.published_at AS published_at_2, n0_.id AS id_3, n0_.uuid AS uuid_4, n0_.stat AS stat_5, n0_.ord AS ord_6, n0_.created_at AS created_at_7, n0_.updated_at AS updated_at_8, n0_.languages AS languages_9, n0_.native_language AS native_language_10, n0_.native_title AS native_title_11, n0_.import_id AS import_id_12, n1_.title AS title_13, n1_.subtitle AS subtitle_14, n1_.short_lead AS short_lead_15, n1_.alt AS alt_16, n1_.id AS id_17, n1_.uuid AS uuid_18, n1_.created_at AS created_at_19, n1_.updated_at AS updated_at_20, n1_.lang AS lang_21, n1_.slug AS slug_22, n2_.url AS url_23, n2_.file_path AS file_path_24, n2_.property AS property_25, n2_.name AS name_26, n2_.type AS type_27, n2_.version AS version_28, n2_.width AS width_29, n2_.height AS height_30, n2_.crop_x AS crop_x_31, n2_.crop_y AS crop_y_32, n2_.crop_width AS crop_width_33, n2_.crop_height AS crop_height_34, n2_.id AS id_35, n2_.uuid AS uuid_36, n2_.created_at AS created_at_37, n2_.updated_at AS updated_at_38, n3_.import_id AS import_id_39, n3_.type AS type_40, n3_.id AS id_41, n3_.uuid AS uuid_42, n3_.stat AS stat_43, n3_.ord AS ord_44, n3_.created_at AS created_at_45, n3_.updated_at AS updated_at_46, n4_.title AS title_47, n4_.text AS text_48, n4_.alt AS alt_49, n4_.media_position AS media_position_50, n4_.id AS id_51, n4_.uuid AS uuid_52, n4_.created_at AS created_at_53, n4_.updated_at AS updated_at_54, n4_.lang AS lang_55, n5_.title AS title_56, n5_.description AS description_57, n5_.icon AS icon_58, n5_.id AS id_59, n5_.uuid AS uuid_60, n5_.ord AS ord_61, n5_.created_at AS created_at_62, n5_.updated_at AS updated_at_63, n6_.title AS title_64, n6_.description AS description_65, n6_.alt AS alt_66, n6_.id AS id_67, n6_.uuid AS uuid_68, n6_.ord AS ord_69, n6_.created_at AS created_at_70, n6_.updated_at AS updated_at_71, n7_.url AS url_72, n7_.file_path AS file_path_73, n7_.property AS property_74, n7_.name AS name_75, n7_.type AS type_76, n7_.version AS version_77, n7_.width AS width_78, n7_.height AS height_79, n7_.crop_x AS crop_x_80, n7_.crop_y AS crop_y_81, n7_.crop_width AS crop_width_82, n7_.crop_height AS crop_height_83, n7_.id AS id_84, n7_.uuid AS uuid_85, n7_.created_at AS created_at_86, n7_.updated_at AS updated_at_87, n8_.url AS url_88, n8_.file_path AS file_path_89, n8_.property AS property_90, n8_.name AS name_91, n8_.type AS type_92, n8_.version AS version_93, n8_.width AS width_94, n8_.height AS height_95, n8_.crop_x AS crop_x_96, n8_.crop_y AS crop_y_97, n8_.crop_width AS crop_width_98, n8_.crop_height AS crop_height_99, n8_.id AS id_100, n8_.uuid AS uuid_101, n8_.created_at AS created_at_102, n8_.updated_at AS updated_at_103, n1_.parent_id AS parent_id_104, n1_.media_id AS media_id_105, n2_.parent_id AS parent_id_106, n2_.template_id AS template_id_107, n3_.parent_id AS parent_id_108, n4_.media_id AS media_id_109, n4_.parent_id AS parent_id_110, n5_.parent_id AS parent_id_111, n5_.media_id AS media_id_112, n6_.parent_id AS parent_id_113, n6_.media_id AS media_id_114, n7_.parent_id AS parent_id_115, n7_.template_id AS template_id_116, n8_.parent_id AS parent_id_117, n8_.template_id AS template_id_118 FROM news n0_ LEFT JOIN news_translations n1_ ON n0_.id = n1_.parent_id AND (n1_.lang = ?) LEFT JOIN news_translation_thumbs n2_ ON n1_.id = n2_.parent_id LEFT JOIN news_blocks n3_ ON n0_.id = n3_.parent_id AND (n3_.stat = 1) LEFT JOIN news_block_translations n4_ ON n3_.id = n4_.parent_id AND (n1_.lang = ?) LEFT JOIN news_block_translation_files n5_ ON n4_.id = n5_.parent_id LEFT JOIN news_block_translation_logos n6_ ON n4_.id = n6_.parent_id LEFT JOIN news_block_translation_logo_thumbs n7_ ON n6_.id = n7_.parent_id LEFT JOIN news_block_translation_thumbs n8_ ON n4_.id = n8_.parent_id WHERE n0_.stat = 1 AND n1_.slug = ? ORDER BY n2_.property ASC, n2_.name ASC, n2_.type ASC, n3_.ord DESC, n5_.ord ASC, n6_.ord ASC, n7_.property ASC, n7_.name ASC, n7_.type ASC, n8_.property ASC, n8_.name ASC, n8_.type ASC
Parameters:
[ "pl" "pl" "tyt-1-1" ] |
| 4 | 0.43 ms |
SELECT c0_.is_mourning_version_active AS is_mourning_version_active_0, c0_.home_journals_per_page AS home_journals_per_page_1, c0_.home_is_journals_alphabetical_asc_order AS home_is_journals_alphabetical_asc_order_2, c0_.home_is_unpublished_journals_excluded AS home_is_unpublished_journals_excluded_3, c0_.home_is_closed_journals_excluded AS home_is_closed_journals_excluded_4, c0_.home_is_unscientific_journals_excluded AS home_is_unscientific_journals_excluded_5, c0_.home_is_industry_journals_excluded AS home_is_industry_journals_excluded_6, c0_.alert_a_is_visible AS alert_a_is_visible_7, c0_.alert_a_type AS alert_a_type_8, c0_.alert_a_is_take_off_active AS alert_a_is_take_off_active_9, c0_.alert_a_take_off_date_time AS alert_a_take_off_date_time_10, c0_.alert_b_is_visible AS alert_b_is_visible_11, c0_.alert_b_type AS alert_b_type_12, c0_.alert_b_is_take_off_active AS alert_b_is_take_off_active_13, c0_.alert_b_take_off_date_time AS alert_b_take_off_date_time_14, c0_.alert_c_is_visible AS alert_c_is_visible_15, c0_.alert_c_type AS alert_c_type_16, c0_.alert_c_is_take_off_active AS alert_c_is_take_off_active_17, c0_.alert_c_take_off_date_time AS alert_c_take_off_date_time_18, c0_.contact_map AS contact_map_19, c0_.link_facebook AS link_facebook_20, c0_.link_instagram AS link_instagram_21, c0_.additional_head_code AS additional_head_code_22, c0_.additional_body_code AS additional_body_code_23, c0_.error_report_email AS error_report_email_24, c0_.id AS id_25, c0_.uuid AS uuid_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28 FROM configs c0_ ORDER BY c0_.created_at ASC LIMIT 1
Parameters:
[] |
| 5 | 0.38 ms |
SELECT t0.title AS title_1, t0.alert_a_message AS alert_a_message_2, t0.alert_a_link AS alert_a_link_3, t0.alert_b_message AS alert_b_message_4, t0.alert_b_link AS alert_b_link_5, t0.alert_c_message AS alert_c_message_6, t0.alert_c_link AS alert_c_link_7, t0.contact_address AS contact_address_8, t0.contact_support AS contact_support_9, t0.contact_cooperation AS contact_cooperation_10, t0.home_left_block_title AS home_left_block_title_11, t0.home_left_block_text AS home_left_block_text_12, t0.home_left_block_button_title AS home_left_block_button_title_13, t0.home_left_block_button_link AS home_left_block_button_link_14, t0.home_right_block_title AS home_right_block_title_15, t0.home_right_block_text AS home_right_block_text_16, t0.home_right_block_button_title AS home_right_block_button_title_17, t0.home_right_block_button_link AS home_right_block_button_link_18, t0.home_bottom_block_title AS home_bottom_block_title_19, t0.home_bottom_block_text AS home_bottom_block_text_20, t0.home_bottom_block_button_title AS home_bottom_block_button_title_21, t0.home_bottom_block_button_link AS home_bottom_block_button_link_22, t0.id AS id_23, t0.uuid AS uuid_24, t0.meta_title AS meta_title_25, t0.meta_description AS meta_description_26, t0.meta_keywords AS meta_keywords_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.lang AS lang_30, t0.parent_id AS parent_id_31 FROM config_translations t0 WHERE t0.parent_id = ?
Parameters:
[
1
]
|
| 6 | 0.44 ms |
SELECT p0_.id_name AS id_name_0, p0_.is_statable AS is_statable_1, p0_.is_editable AS is_editable_2, p0_.is_deletable AS is_deletable_3, p0_.is_sub_pageable AS is_sub_pageable_4, p0_.main_menu AS main_menu_5, p0_.id AS id_6, p0_.uuid AS uuid_7, p0_.stat AS stat_8, p0_.ord AS ord_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.languages AS languages_12, p0_.native_language AS native_language_13, p0_.native_title AS native_title_14, p0_.import_id AS import_id_15, p1_.title AS title_16, p1_.description AS description_17, p1_.id AS id_18, p1_.uuid AS uuid_19, p1_.created_at AS created_at_20, p1_.updated_at AS updated_at_21, p1_.lang AS lang_22, p1_.meta_title AS meta_title_23, p1_.meta_description AS meta_description_24, p1_.meta_keywords AS meta_keywords_25, p1_.slug AS slug_26, p2_.type AS type_27, p2_.id AS id_28, p2_.uuid AS uuid_29, p2_.stat AS stat_30, p2_.ord AS ord_31, p2_.created_at AS created_at_32, p2_.updated_at AS updated_at_33, p3_.title AS title_34, p3_.text AS text_35, p3_.alt AS alt_36, p3_.media_position AS media_position_37, p3_.id AS id_38, p3_.uuid AS uuid_39, p3_.created_at AS created_at_40, p3_.updated_at AS updated_at_41, p3_.lang AS lang_42, p0_.parent_id AS parent_id_43, p0_.media_id AS media_id_44, p1_.parent_id AS parent_id_45, p2_.parent_id AS parent_id_46, p3_.media_id AS media_id_47, p3_.parent_id AS parent_id_48 FROM pages p0_ LEFT JOIN page_translations p1_ ON p0_.id = p1_.parent_id AND (p1_.lang = ?) LEFT JOIN page_blocks p2_ ON p0_.id = p2_.parent_id AND (p2_.stat = 1) LEFT JOIN page_block_translations p3_ ON p2_.id = p3_.parent_id AND (p1_.lang = ?) WHERE p0_.id_name = ? ORDER BY p2_.ord DESC
Parameters:
[ "pl" "pl" "page_faq" ] |
| 7 | 0.26 ms |
SELECT p0_.slug AS slug_0 FROM pages p1_ LEFT JOIN page_translations p0_ ON p1_.id = p0_.parent_id AND (p0_.lang = ?) WHERE p1_.id = ? LIMIT 1
Parameters:
[ "en" 70 ] |
| 8 | 0.72 ms |
SELECT n0_.slug AS slug_0 FROM news n1_ LEFT JOIN news_translations n0_ ON n1_.id = n0_.parent_id AND (n0_.lang = ?) WHERE n1_.id = ? LIMIT 1
Parameters:
[ "en" 2 ] |
| 9 | 0.66 ms |
SELECT m0_.working_title AS working_title_0, m0_.is_visible_in_bar AS is_visible_in_bar_1, m0_.is_target_blank AS is_target_blank_2, m0_.is_collapsed AS is_collapsed_3, m0_.is_small AS is_small_4, m0_.id AS id_5, m0_.uuid AS uuid_6, m0_.stat AS stat_7, m0_.ord AS ord_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.languages AS languages_11, m0_.native_language AS native_language_12, m0_.native_title AS native_title_13, m1_.title AS title_14, m1_.link AS link_15, m1_.id AS id_16, m1_.uuid AS uuid_17, m1_.created_at AS created_at_18, m1_.updated_at AS updated_at_19, m1_.lang AS lang_20, m2_.working_title AS working_title_21, m2_.is_target_blank AS is_target_blank_22, m2_.is_small AS is_small_23, m2_.id AS id_24, m2_.uuid AS uuid_25, m2_.stat AS stat_26, m2_.ord AS ord_27, m2_.created_at AS created_at_28, m2_.updated_at AS updated_at_29, m3_.title AS title_30, m3_.link AS link_31, m3_.id AS id_32, m3_.uuid AS uuid_33, m3_.created_at AS created_at_34, m3_.updated_at AS updated_at_35, m3_.lang AS lang_36, m1_.page_id AS page_id_37, m1_.parent_id AS parent_id_38, m2_.parent_id AS parent_id_39, m3_.page_id AS page_id_40, m3_.parent_id AS parent_id_41 FROM menu_groups m0_ LEFT JOIN menu_group_translations m1_ ON m0_.id = m1_.parent_id AND (m1_.lang = ? OR m1_.lang = m0_.native_language) LEFT JOIN menu_group_items m2_ ON m0_.id = m2_.parent_id AND (m2_.stat = 1) LEFT JOIN menu_group_item_translations m3_ ON m2_.id = m3_.parent_id AND (m3_.lang = ? OR m3_.lang = m0_.native_language) WHERE m0_.stat = 1 AND (m1_.title IS NOT NULL AND m1_.title <> '') ORDER BY m0_.ord DESC, m2_.ord DESC
Parameters:
[ "pl" "pl" ] |
| 10 | 0.54 ms |
SELECT p0_.id_name AS id_name_0, p0_.is_statable AS is_statable_1, p0_.is_editable AS is_editable_2, p0_.is_deletable AS is_deletable_3, p0_.is_sub_pageable AS is_sub_pageable_4, p0_.main_menu AS main_menu_5, p0_.id AS id_6, p0_.uuid AS uuid_7, p0_.stat AS stat_8, p0_.ord AS ord_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.languages AS languages_12, p0_.native_language AS native_language_13, p0_.native_title AS native_title_14, p0_.import_id AS import_id_15, p1_.title AS title_16, p1_.description AS description_17, p1_.id AS id_18, p1_.uuid AS uuid_19, p1_.created_at AS created_at_20, p1_.updated_at AS updated_at_21, p1_.lang AS lang_22, p1_.meta_title AS meta_title_23, p1_.meta_description AS meta_description_24, p1_.meta_keywords AS meta_keywords_25, p1_.slug AS slug_26, p2_.type AS type_27, p2_.id AS id_28, p2_.uuid AS uuid_29, p2_.stat AS stat_30, p2_.ord AS ord_31, p2_.created_at AS created_at_32, p2_.updated_at AS updated_at_33, p3_.title AS title_34, p3_.text AS text_35, p3_.alt AS alt_36, p3_.media_position AS media_position_37, p3_.id AS id_38, p3_.uuid AS uuid_39, p3_.created_at AS created_at_40, p3_.updated_at AS updated_at_41, p3_.lang AS lang_42, p0_.parent_id AS parent_id_43, p0_.media_id AS media_id_44, p1_.parent_id AS parent_id_45, p2_.parent_id AS parent_id_46, p3_.media_id AS media_id_47, p3_.parent_id AS parent_id_48 FROM pages p0_ LEFT JOIN page_translations p1_ ON p0_.id = p1_.parent_id AND (p1_.lang = ?) LEFT JOIN page_blocks p2_ ON p0_.id = p2_.parent_id AND (p2_.stat = 1) LEFT JOIN page_block_translations p3_ ON p2_.id = p3_.parent_id AND (p1_.lang = ?) WHERE p0_.id_name = ? ORDER BY p2_.ord DESC
Parameters:
[ "pl" "pl" "search_results" ] |
| 11 | 0.69 ms |
SELECT f0_.working_title AS working_title_0, f0_.is_target_blank AS is_target_blank_1, f0_.id AS id_2, f0_.uuid AS uuid_3, f0_.stat AS stat_4, f0_.ord AS ord_5, f0_.created_at AS created_at_6, f0_.updated_at AS updated_at_7, f0_.languages AS languages_8, f0_.native_language AS native_language_9, f0_.native_title AS native_title_10, f1_.title AS title_11, f1_.link AS link_12, f1_.id AS id_13, f1_.uuid AS uuid_14, f1_.created_at AS created_at_15, f1_.updated_at AS updated_at_16, f1_.lang AS lang_17, f2_.working_title AS working_title_18, f2_.is_target_blank AS is_target_blank_19, f2_.id AS id_20, f2_.uuid AS uuid_21, f2_.stat AS stat_22, f2_.ord AS ord_23, f2_.created_at AS created_at_24, f2_.updated_at AS updated_at_25, f3_.title AS title_26, f3_.link AS link_27, f3_.id AS id_28, f3_.uuid AS uuid_29, f3_.created_at AS created_at_30, f3_.updated_at AS updated_at_31, f3_.lang AS lang_32, f1_.page_id AS page_id_33, f1_.parent_id AS parent_id_34, f2_.parent_id AS parent_id_35, f3_.page_id AS page_id_36, f3_.parent_id AS parent_id_37 FROM footer_menu_groups f0_ LEFT JOIN footer_menu_group_translations f1_ ON f0_.id = f1_.parent_id AND (f1_.lang = ? OR f1_.lang = f0_.native_language) LEFT JOIN footer_menu_group_items f2_ ON f0_.id = f2_.parent_id AND (f2_.stat = 1) LEFT JOIN footer_menu_group_item_translations f3_ ON f2_.id = f3_.parent_id AND (f3_.lang = ? OR f3_.lang = f0_.native_language) WHERE f0_.stat = 1 AND (f1_.title IS NOT NULL AND f1_.title <> '') ORDER BY f0_.ord DESC, f2_.ord DESC
Parameters:
[ "pl" "pl" ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| importfromwuj | doctrine.dbal.importfromwuj_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.