Query Metrics
67
Database Queries
15
Different statements
19.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.07 ms (20.74%) |
5 |
SELECT p0_.is_editable AS is_editable_0, p0_.is_main_page AS is_main_page_1, p0_.is_blog_page AS is_blog_page_2, p0_.template_path AS template_path_3, p0_.is_published AS is_published_4, p0_.should_be_followed AS should_be_followed_5, p0_.type AS type_6, p0_.id AS id_7, p0_.internal_name AS internal_name_8, p0_.migration_id AS migration_id_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p1_.url AS url_12, p1_.displayed_title AS displayed_title_13, p1_.meta_tags AS meta_tags_14, p1_.id AS id_15, p1_.locale AS locale_16 FROM page p0_ INNER JOIN page_translation p1_ ON p0_.id = p1_.translatable_id WHERE p1_.locale = ?
Parameters:
[
"pl"
]
|
|
3.05 ms (15.54%) |
18 |
SELECT t0.image_type AS image_type_1, t0.id AS id_2, t0.name AS name_3, t0.file_name AS file_name_4, t0.preview_file_name AS preview_file_name_5, t0.extension AS extension_6, t0.mime_type AS mime_type_7, t0.uuid AS uuid_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM image t0 WHERE t0.id = ?
Parameters:
[
24
]
|
|
2.61 ms (13.28%) |
14 |
SELECT t0.name AS name_1, t0.short_description AS short_description_2, t0.details AS details_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM diet_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
|
1.95 ms (9.93%) |
7 |
SELECT t0.name AS name_1, t0.template_path AS template_path_2, t0.params AS params_3, t0.is_editable AS is_editable_4, t0.type AS type_5, t0.layout AS layout_6, t0.form_type AS form_type_7, t0.layout_settings AS layout_settings_8, t0.is_unique AS is_unique_9, t0.anchor_color AS anchor_color_10, t0.id AS id_11, t0.migration_id AS migration_id_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.section_image_id AS section_image_id_15, t0.section_media_id AS section_media_id_16, t0.background_image_id AS background_image_id_17, t0.uploaded_file_id AS uploaded_file_id_18, t0.uploaded_image_id AS uploaded_image_id_19 FROM section t0 WHERE t0.id = ?
Parameters:
[
186
]
|
|
1.73 ms (8.83%) |
7 |
SELECT t0.html_contents AS html_contents_1, t0.title AS title_2, t0.sub_title AS sub_title_3, t0.anchor_text AS anchor_text_4, t0.anchor_url AS anchor_url_5, t0.id AS id_6, t0.locale AS locale_7, t0.image_id AS image_id_8, t0.section_media_id AS section_media_id_9, t0.translatable_id AS translatable_id_10 FROM section_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
186
]
|
|
0.98 ms (4.98%) |
4 |
SELECT t0.id AS id_1 FROM main_menu t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
|
0.97 ms (4.94%) |
1 |
SELECT t0.is_editable AS is_editable_1, t0.is_main_page AS is_main_page_2, t0.is_blog_page AS is_blog_page_3, t0.template_path AS template_path_4, t0.is_published AS is_published_5, t0.should_be_followed AS should_be_followed_6, t0.type AS type_7, t0.id AS id_8, t0.internal_name AS internal_name_9, t0.migration_id AS migration_id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t13.is_news AS is_news_14, t13.sort_order AS sort_order_15, t13.reading_time AS reading_time_16, t13.previous_post AS previous_post_17, t13.next_post AS next_post_18, t13.id AS id_19, t13.page_id AS page_id_20, t13.post_preview_id AS post_preview_id_21, t13.category_id AS category_id_22, t23.name AS name_24, t23.street AS street_25, t23.apartment_number AS apartment_number_26, t23.postal_code AS postal_code_27, t23.city AS city_28, t23.lat AS lat_29, t23.lng AS lng_30, t23.email AS email_31, t23.phone_number AS phone_number_32, t23.sort_order AS sort_order_33, t23.population AS population_34, t23.opening_date AS opening_date_35, t23.parking_spaces_number AS parking_spaces_number_36, t23.store_usable_floor_area AS store_usable_floor_area_37, t23.commercial_space AS commercial_space_38, t23.has_petrol_station AS has_petrol_station_39, t23.has_car_wash AS has_car_wash_40, t23.has_shopping_delivery AS has_shopping_delivery_41, t23.region AS region_42, t23.id AS id_43, t23.created_at AS created_at_44, t23.updated_at AS updated_at_45, t23.page_id AS page_id_46, t47.sort_order AS sort_order_48, t47.id AS id_49, t47.page_id AS page_id_50, t47.category_preview_id AS category_preview_id_51 FROM page t0 LEFT JOIN post t13 ON t13.page_id = t0.id LEFT JOIN shop t23 ON t23.page_id = t0.id LEFT JOIN category t47 ON t47.page_id = t0.id WHERE t0.id = ?
Parameters:
[
74
]
|
|
0.87 ms (4.44%) |
3 |
SELECT t0.items AS items_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM main_menu_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
|
0.61 ms (3.09%) |
1 |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.page_id AS page_id_3, t0.section_id AS section_id_4 FROM page_section t0 WHERE t0.page_id = ?
Parameters:
[
74
]
|
|
0.60 ms (3.06%) |
1 |
SELECT t0.old_url AS old_url_1, t0.new_url AS new_url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.is_create_by_user AS is_create_by_user_5, t0.id AS id_6 FROM redirects t0 WHERE t0.old_url = ? LIMIT 1
Parameters:
[
"/catering-dietetyczny-zielona-gora"
]
|
|
0.49 ms (2.48%) |
2 |
SELECT t0.url AS url_1, t0.displayed_title AS displayed_title_2, t0.meta_tags AS meta_tags_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
74
]
|
|
0.48 ms (2.44%) |
1 |
SELECT t0.url AS url_1, t0.displayed_title AS displayed_title_2, t0.meta_tags AS meta_tags_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"catering-dietetyczny-zielona-gora"
]
|
|
0.42 ms (2.16%) |
1 |
SELECT t0.ordering AS ordering_1, t0.view AS view_2, t0.choose_menu AS choose_menu_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.thumbnail_id AS thumbnail_id_7, t0.page_id AS page_id_8 FROM diet t0 ORDER BY t0.ordering ASC
Parameters:
[] |
|
0.42 ms (2.14%) |
1 |
SELECT t0.is_editable AS is_editable_1, t0.is_main_page AS is_main_page_2, t0.is_blog_page AS is_blog_page_3, t0.template_path AS template_path_4, t0.is_published AS is_published_5, t0.should_be_followed AS should_be_followed_6, t0.type AS type_7, t0.id AS id_8, t0.internal_name AS internal_name_9, t0.migration_id AS migration_id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t13.is_news AS is_news_14, t13.sort_order AS sort_order_15, t13.reading_time AS reading_time_16, t13.previous_post AS previous_post_17, t13.next_post AS next_post_18, t13.id AS id_19, t13.page_id AS page_id_20, t13.post_preview_id AS post_preview_id_21, t13.category_id AS category_id_22, t23.name AS name_24, t23.street AS street_25, t23.apartment_number AS apartment_number_26, t23.postal_code AS postal_code_27, t23.city AS city_28, t23.lat AS lat_29, t23.lng AS lng_30, t23.email AS email_31, t23.phone_number AS phone_number_32, t23.sort_order AS sort_order_33, t23.population AS population_34, t23.opening_date AS opening_date_35, t23.parking_spaces_number AS parking_spaces_number_36, t23.store_usable_floor_area AS store_usable_floor_area_37, t23.commercial_space AS commercial_space_38, t23.has_petrol_station AS has_petrol_station_39, t23.has_car_wash AS has_car_wash_40, t23.has_shopping_delivery AS has_shopping_delivery_41, t23.region AS region_42, t23.id AS id_43, t23.created_at AS created_at_44, t23.updated_at AS updated_at_45, t23.page_id AS page_id_46, t47.sort_order AS sort_order_48, t47.id AS id_49, t47.page_id AS page_id_50, t47.category_preview_id AS category_preview_id_51 FROM page t0 LEFT JOIN post t13 ON t13.page_id = t0.id LEFT JOIN shop t23 ON t23.page_id = t0.id LEFT JOIN category t47 ON t47.page_id = t0.id WHERE t0.is_blog_page = ? LIMIT 1
Parameters:
[
1
]
|
|
0.39 ms (1.96%) |
1 |
SELECT t0.facebook AS facebook_1, t0.instagram AS instagram_2, t0.linkedin AS linkedin_3, t0.you_tube AS you_tube_4, t0.pinterest AS pinterest_5, t0.twitter AS twitter_6, t0.tiktok AS tiktok_7, t0.app_store AS app_store_8, t0.google_play AS google_play_9, t0.phone AS phone_10, t0.email AS email_11, t0.pn_pt AS pn_pt_12, t0.nd AS nd_13, t0.address_first_line AS address_first_line_14, t0.address_second_line AS address_second_line_15, t0.app_icon AS app_icon_16, t0.log_in_icon AS log_in_icon_17, t0.order_icon AS order_icon_18, t0.text AS text_19, t0.anchors AS anchors_20, t0.id AS id_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23 FROM settings t0 WHERE t0.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\Entity\Page\Page | No errors. |
| App\Entity\Page\PageTranslation | No errors. |
| App\Entity\Page\Redirects | No errors. |
| App\Entity\Post\Post | No errors. |
| App\Entity\Section\Image | No errors. |
| App\Entity\Post\Category | No errors. |
| App\Entity\Shop\Shop | No errors. |
| App\Entity\Page\PageSection | No errors. |
| App\Entity\Diet\Diet | No errors. |
| App\Entity\Settings\Settings | No errors. |
| App\Entity\MainMenu\MainMenu | No errors. |
| App\Entity\Section\Section | No errors. |
| App\Entity\File\File | No errors. |
| App\Entity\Slide\Slide | No errors. |
| App\Entity\PostsIntro\PostsIntro | No errors. |
| App\Entity\Section\ImageToSection | No errors. |
| App\Entity\Form\Form | No errors. |
| App\Entity\Section\SectionTranslation | No errors. |
| App\Entity\MainMenu\MainMenuTranslation | No errors. |
| App\Entity\Section\ImageTranslation | No errors. |
| App\Entity\Diet\DietTranslation | No errors. |