Query Metrics
59
Database Queries
25
Different statements
25.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.52 ms (13.89%) |
7 |
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:
[
9
]
|
|
2.74 ms (10.81%) |
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"
]
|
|
1.78 ms (7.05%) |
7 |
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:
[
9
]
|
|
1.67 ms (6.61%) |
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:
[
10
]
|
|
1.67 ms (6.59%) |
7 |
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:
[
231
]
|
|
1.36 ms (5.36%) |
5 |
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
]
|
|
1.12 ms (4.42%) |
2 |
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:
[
43
]
|
|
1.09 ms (4.30%) |
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:
[
"/blog?page=7"
]
|
|
0.99 ms (3.92%) |
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.97 ms (3.83%) |
1 |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM post p0_ INNER JOIN page p1_ ON p0_.page_id = p1_.id INNER JOIN post_category p2_ ON p0_.id = p2_.post_id WHERE p1_.is_published = ? ORDER BY p0_.sort_order DESC, p0_.id DESC
Parameters:
[
1
]
|
|
0.91 ms (3.60%) |
1 |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM post p0_ INNER JOIN page p1_ ON p0_.page_id = p1_.id INNER JOIN post_category p2_ ON p0_.id = p2_.post_id WHERE p1_.is_published = ? AND 1 = p2_.category_id ORDER BY p0_.sort_order DESC, p0_.id DESC
Parameters:
[
1
]
|
|
0.91 ms (3.59%) |
3 |
SELECT t0.id AS id_1 FROM main_menu t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
|
0.83 ms (3.30%) |
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 OFFSET 36
Parameters:
[ "pl" 1 ] |
|
0.79 ms (3.10%) |
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 ] |
|
0.78 ms (3.09%) |
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:
[
43
]
|
|
0.55 ms (2.18%) |
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:
[
"blog"
]
|
|
0.52 ms (2.05%) |
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.49 ms (1.94%) |
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:
[
9
]
|
|
0.49 ms (1.92%) |
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
]
|
|
0.40 ms (1.57%) |
1 |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM post p0_ INNER JOIN page p1_ ON p0_.page_id = p1_.id INNER JOIN post_category p2_ ON p0_.id = p2_.post_id WHERE p1_.is_published = ? AND 2 = p2_.category_id ORDER BY p0_.sort_order DESC, p0_.id DESC
Parameters:
[
1
]
|
|
0.40 ms (1.57%) |
1 |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM post p0_ INNER JOIN page p1_ ON p0_.page_id = p1_.id INNER JOIN post_category p2_ ON p0_.id = p2_.post_id WHERE p1_.is_published = ? AND 4 = p2_.category_id ORDER BY p0_.sort_order DESC, p0_.id DESC
Parameters:
[
1
]
|
|
0.38 ms (1.51%) |
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:
[ 10 9 8 7 6 5 ] |
|
0.38 ms (1.50%) |
1 |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM post p0_ INNER JOIN page p1_ ON p0_.page_id = p1_.id INNER JOIN post_category p2_ ON p0_.id = p2_.post_id WHERE p1_.is_published = ? AND 5 = p2_.category_id ORDER BY p0_.sort_order DESC, p0_.id DESC
Parameters:
[
1
]
|
|
0.32 ms (1.27%) |
1 |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM post p0_ INNER JOIN page p1_ ON p0_.page_id = p1_.id INNER JOIN post_category p2_ ON p0_.id = p2_.post_id WHERE p1_.is_published = ? AND 3 = p2_.category_id ORDER BY p0_.sort_order DESC, p0_.id DESC
Parameters:
[
1
]
|
|
0.26 ms (1.02%) |
1 |
SELECT t0.sort_order AS sort_order_1, t0.id AS id_2, t0.page_id AS page_id_3, t0.category_preview_id AS category_preview_id_4 FROM category t0
Parameters:
[] |
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\Post\PostCategory | No errors. |
| App\Entity\Post\CategoryTranslation | No errors. |
| App\Entity\Post\PostTranslation | No errors. |