Query Metrics
53
Database Queries
23
Different statements
46.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
7.65 ms (16.30%) |
8 |
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:
[
72
]
|
|
4.55 ms (9.70%) |
3 |
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"
]
|
|
4.43 ms (9.45%) |
8 |
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:
[
72
]
|
|
3.80 ms (8.09%) |
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:
[
"/problemy-trawienne-co-jesc"
]
|
|
3.03 ms (6.46%) |
6 |
SELECT t0.head AS head_1, t0.intro AS intro_2, t0.id AS id_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
45
]
|
|
2.89 ms (6.16%) |
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
]
|
|
2.83 ms (6.04%) |
1 |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.post_id AS post_id_3, t0.category_id AS category_id_4, t5.sort_order AS sort_order_6, t5.id AS id_7, t5.page_id AS page_id_8, t5.category_preview_id AS category_preview_id_9 FROM post_category t0 LEFT JOIN category t5 ON t0.category_id = t5.id WHERE t0.post_id = ?
Parameters:
[
46
]
|
|
1.72 ms (3.67%) |
3 |
SELECT t0.id AS id_1 FROM main_menu t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
|
1.63 ms (3.47%) |
2 |
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
]
|
|
1.61 ms (3.43%) |
1 |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM post p0_ LEFT JOIN page p1_ ON p0_.page_id = p1_.id LEFT JOIN page_translation p2_ ON p1_.id = p2_.translatable_id WHERE p2_.locale LIKE ? AND p1_.is_published = ? ORDER BY p0_.sort_order DESC
Parameters:
[ "pl" 1 ] |
|
1.59 ms (3.39%) |
1 |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM post p0_ LEFT JOIN page p1_ ON p0_.page_id = p1_.id LEFT JOIN page_translation p2_ ON p1_.id = p2_.translatable_id LEFT JOIN post_category p3_ ON p0_.id = p3_.post_id WHERE p2_.locale LIKE ? AND 1 = p3_.category_id AND p1_.is_published = ? ORDER BY p0_.sort_order DESC
Parameters:
[ "pl" 1 ] |
|
1.59 ms (3.38%) |
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
]
|
|
1.50 ms (3.20%) |
4 |
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:
[
178
]
|
|
1.49 ms (3.18%) |
1 |
SELECT p0_.id AS id_0 FROM post p0_ LEFT JOIN page p1_ ON p0_.page_id = p1_.id LEFT JOIN page_translation p2_ ON p1_.id = p2_.translatable_id LEFT JOIN post_category p3_ ON p0_.id = p3_.post_id WHERE p2_.locale LIKE ? AND 1 = p3_.category_id AND p1_.is_published = ? ORDER BY p0_.sort_order DESC LIMIT 4
Parameters:
[ "pl" 1 ] |
|
1.27 ms (2.71%) |
1 |
SELECT p0_.id AS id_0 FROM post p0_ LEFT JOIN page p1_ ON p0_.page_id = p1_.id LEFT JOIN page_translation p2_ ON p1_.id = p2_.translatable_id WHERE p2_.locale LIKE ? AND p1_.is_published = ? ORDER BY p0_.sort_order DESC LIMIT 6
Parameters:
[ "pl" 1 ] |
|
1.11 ms (2.37%) |
2 |
SELECT t0.is_news AS is_news_1, t0.sort_order AS sort_order_2, t0.reading_time AS reading_time_3, t0.previous_post AS previous_post_4, t0.next_post AS next_post_5, t0.id AS id_6, t0.page_id AS page_id_7, t0.post_preview_id AS post_preview_id_8, t0.category_id AS category_id_9 FROM post t0 WHERE t0.sort_order = ? LIMIT 1
Parameters:
[
47
]
|
|
0.71 ms (1.51%) |
1 |
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:
[
184
]
|
|
0.70 ms (1.50%) |
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:
[
"problemy-trawienne-co-jesc"
]
|
|
0.68 ms (1.44%) |
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:
[
72
]
|
|
0.60 ms (1.29%) |
1 |
SELECT t0.is_news AS is_news_1, t0.sort_order AS sort_order_2, t0.reading_time AS reading_time_3, t0.previous_post AS previous_post_4, t0.next_post AS next_post_5, t0.id AS id_6, t0.page_id AS page_id_7, t0.post_preview_id AS post_preview_id_8, t0.category_id AS category_id_9 FROM post t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?) ORDER BY t0.sort_order DESC
Parameters:
[ 46 45 44 43 42 41 ] |
|
0.59 ms (1.26%) |
1 |
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:
[
184
]
|
|
0.53 ms (1.12%) |
1 |
SELECT t0.description AS description_1, t0.category_name AS category_name_2, t0.id AS id_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
|
0.41 ms (0.88%) |
1 |
SELECT t0.is_news AS is_news_1, t0.sort_order AS sort_order_2, t0.reading_time AS reading_time_3, t0.previous_post AS previous_post_4, t0.next_post AS next_post_5, t0.id AS id_6, t0.page_id AS page_id_7, t0.post_preview_id AS post_preview_id_8, t0.category_id AS category_id_9 FROM post t0 WHERE t0.id IN (?, ?, ?, ?) ORDER BY t0.sort_order DESC
Parameters:
[ 46 45 44 43 ] |
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\Post\PostCategory | No errors. |
| App\Entity\Post\PostTranslation | 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\Post\CategoryTranslation | No errors. |
| App\Entity\Section\ImageTranslation | No errors. |