Query Metrics
59
Database Queries
19
Different statements
10.41 ms
Query time
0
Invalid entities
113
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.27 ms |
SELECT t0.id AS id_1, t0.opening_hours AS opening_hours_2 FROM website_info t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 2 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_about_page_id AS parent_about_page_id_7, t0.about_page_banner_id AS about_page_banner_id_8 FROM about_page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"minority"
]
|
| 3 | 0.33 ms |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.color AS color_2, a0_.slug AS slug_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a0_.parent_about_page_id AS parent_about_page_id_6, a0_.about_page_banner_id AS about_page_banner_id_7 FROM about_page a0_ WHERE a0_.parent_about_page_id IS NULL ORDER BY a0_.id ASC LIMIT 10
Parameters:
[] |
| 4 | 0.22 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.page_id AS page_id_3, t0.block_element_id AS block_element_id_4, t0.about_page_id AS about_page_id_5 FROM page_block_element t0 WHERE t0.about_page_id = ? ORDER BY t0.position ASC
Parameters:
[
5
]
|
| 5 | 0.24 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM about_page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
5
]
|
| 6 | 0.19 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.catch_phrase AS catch_phrase_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM website_info_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
| 7 | 0.18 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.value AS value_3, t0.extra_info AS extra_info_4 FROM naka_parameter t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
"global.google-tag-manager"
]
|
| 8 | 0.17 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.value AS value_3, t0.extra_info AS extra_info_4 FROM naka_parameter t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
"global.google-analytics"
]
|
| 9 | 0.18 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.value AS value_3, t0.extra_info AS extra_info_4 FROM naka_parameter t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
"global.google-tag-manager"
]
|
| 10 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_fixed AS is_fixed_3 FROM menu t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"glsMainMenu"
]
|
| 11 | 0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.route_parameters AS route_parameters_4, t0.order_id AS order_id_5, t0.type AS type_6, t0.uri AS uri_7, t0.position AS position_8, t0.page_id AS page_id_9 FROM menu_item t0 INNER JOIN menu_menu_item ON t0.id = menu_menu_item.menu_item_id WHERE menu_menu_item.menu_id = ? ORDER BY t0.position ASC
Parameters:
[
3
]
|
| 12 | 0.15 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM menu_item_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
8
]
|
| 13 | 0.15 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM menu_item_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
9
]
|
| 14 | 0.15 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM menu_item_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
13
]
|
| 15 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.active AS active_4, t0.home_page_promoted AS home_page_promoted_5, t0.slug AS slug_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.gls_page_type_banner_id AS gls_page_type_banner_id_9, t0.gls_page_type_slide_id AS gls_page_type_slide_id_10 FROM gls_page_type t0 WHERE t0.active = ?
Parameters:
[
1
]
|
| 16 | 0.19 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.left_content AS left_content_4, t0.right_content AS right_content_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM gls_page_type_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
| 17 | 0.17 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.left_content AS left_content_4, t0.right_content AS right_content_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM gls_page_type_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
2
]
|
| 18 | 0.20 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.left_content AS left_content_4, t0.right_content AS right_content_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM gls_page_type_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
3
]
|
| 19 | 0.20 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.left_content AS left_content_4, t0.right_content AS right_content_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM gls_page_type_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
6
]
|
| 20 | 0.16 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.left_content AS left_content_4, t0.right_content AS right_content_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM gls_page_type_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
7
]
|
| 21 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.active AS active_4, t0.home_page_promoted AS home_page_promoted_5, t0.slug AS slug_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.gls_page_type_banner_id AS gls_page_type_banner_id_9, t0.gls_page_type_slide_id AS gls_page_type_slide_id_10 FROM gls_page_type t0 WHERE t0.active = ?
Parameters:
[
1
]
|
| 22 | 0.20 ms |
SELECT t0.id AS id_1, t0.logo_image_name AS logo_image_name_2, t0.logo_image_original_name AS logo_image_original_name_3, t0.logo_image_mime_type AS logo_image_mime_type_4, t0.logo_image_size AS logo_image_size_5, t0.logo_image_dimensions AS logo_image_dimensions_6, t0.blog_logo_image_name AS blog_logo_image_name_7, t0.blog_logo_image_original_name AS blog_logo_image_original_name_8, t0.blog_logo_image_mime_type AS blog_logo_image_mime_type_9, t0.blog_logo_image_size AS blog_logo_image_size_10, t0.blog_logo_image_dimensions AS blog_logo_image_dimensions_11, t0.default_banner_image_name AS default_banner_image_name_12, t0.default_banner_image_original_name AS default_banner_image_original_name_13, t0.default_banner_image_mime_type AS default_banner_image_mime_type_14, t0.default_banner_image_size AS default_banner_image_size_15, t0.default_banner_image_dimensions AS default_banner_image_dimensions_16, t0.default_slide_image_name AS default_slide_image_name_17, t0.default_slide_image_original_name AS default_slide_image_original_name_18, t0.default_slide_image_mime_type AS default_slide_image_mime_type_19, t0.default_slide_image_size AS default_slide_image_size_20, t0.default_slide_image_dimensions AS default_slide_image_dimensions_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23 FROM naka_site_settings t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 23 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.image_original_name AS image_original_name_4, t0.image_mime_type AS image_mime_type_5, t0.image_size AS image_size_6, t0.image_dimensions AS image_dimensions_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.page_gallery_id AS page_gallery_id_10, t0.picture_gallery_id AS picture_gallery_id_11 FROM picture t0 WHERE t0.id = ?
Parameters:
[
68
]
|
| 24 | 0.20 ms |
SELECT t0.id AS id_1, t0.alt_text AS alt_text_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM picture_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
68
]
|
| 25 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_about_page_id AS parent_about_page_id_7, t0.about_page_banner_id AS about_page_banner_id_8 FROM about_page t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 26 | 0.20 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM about_page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
4
]
|
| 27 | 0.23 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM about_page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
| 28 | 0.20 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM about_page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
2
]
|
| 29 | 0.19 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM about_page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
3
]
|
| 30 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_about_page_id AS parent_about_page_id_7, t0.about_page_banner_id AS about_page_banner_id_8 FROM about_page t0 WHERE t0.parent_about_page_id = ?
Parameters:
[
1
]
|
| 31 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_about_page_id AS parent_about_page_id_7, t0.about_page_banner_id AS about_page_banner_id_8 FROM about_page t0 WHERE t0.parent_about_page_id = ?
Parameters:
[
4
]
|
| 32 | 0.14 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM about_page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
6
]
|
| 33 | 0.14 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM about_page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
7
]
|
| 34 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_about_page_id AS parent_about_page_id_7, t0.about_page_banner_id AS about_page_banner_id_8 FROM about_page t0 WHERE t0.parent_about_page_id = ?
Parameters:
[
7
]
|
| 35 | 0.16 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM about_page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
8
]
|
| 36 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_about_page_id AS parent_about_page_id_7, t0.about_page_banner_id AS about_page_banner_id_8 FROM about_page t0 WHERE t0.parent_about_page_id = ?
Parameters:
[
8
]
|
| 37 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_about_page_id AS parent_about_page_id_7, t0.about_page_banner_id AS about_page_banner_id_8 FROM about_page t0 WHERE t0.parent_about_page_id = ?
Parameters:
[
2
]
|
| 38 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_about_page_id AS parent_about_page_id_7, t0.about_page_banner_id AS about_page_banner_id_8 FROM about_page t0 WHERE t0.parent_about_page_id = ?
Parameters:
[
3
]
|
| 39 | 0.10 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_fixed AS is_fixed_3 FROM menu t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"glsFooterMenu"
]
|
| 40 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.route_parameters AS route_parameters_4, t0.order_id AS order_id_5, t0.type AS type_6, t0.uri AS uri_7, t0.position AS position_8, t0.page_id AS page_id_9 FROM menu_item t0 INNER JOIN menu_menu_item ON t0.id = menu_menu_item.menu_item_id WHERE menu_menu_item.menu_id = ? ORDER BY t0.position ASC
Parameters:
[
2
]
|
| 41 | 0.12 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM menu_item_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
12
]
|
| 42 | 0.10 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM menu_item_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
3
]
|
| 43 | 0.15 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM menu_item_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
2
]
|
| 44 | 0.20 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.page_type AS page_type_4, t0.slug AS slug_5, t0.show_banner AS show_banner_6, t0.color AS color_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.page_gallery_id AS page_gallery_id_10, t0.banner_picture_id AS banner_picture_id_11, t0.slide_picture_id AS slide_picture_id_12, t0.gls_page_type_id AS gls_page_type_id_13, t0.gls_training_id AS gls_training_id_14 FROM page t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 45 | 0.24 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.sensitive_content AS sensitive_content_4, t0.short_description AS short_description_5, t0.invoice_content AS invoice_content_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
4
]
|
| 46 | 0.19 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.page_type AS page_type_4, t0.slug AS slug_5, t0.show_banner AS show_banner_6, t0.color AS color_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.page_gallery_id AS page_gallery_id_10, t0.banner_picture_id AS banner_picture_id_11, t0.slide_picture_id AS slide_picture_id_12, t0.gls_page_type_id AS gls_page_type_id_13, t0.gls_training_id AS gls_training_id_14 FROM page t0 WHERE t0.id = ?
Parameters:
[
10
]
|
| 47 | 0.24 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.sensitive_content AS sensitive_content_4, t0.short_description AS short_description_5, t0.invoice_content AS invoice_content_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
10
]
|
| 48 | 0.16 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.page_type AS page_type_4, t0.slug AS slug_5, t0.show_banner AS show_banner_6, t0.color AS color_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.page_gallery_id AS page_gallery_id_10, t0.banner_picture_id AS banner_picture_id_11, t0.slide_picture_id AS slide_picture_id_12, t0.gls_page_type_id AS gls_page_type_id_13, t0.gls_training_id AS gls_training_id_14 FROM page t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 49 | 0.18 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.sensitive_content AS sensitive_content_4, t0.short_description AS short_description_5, t0.invoice_content AS invoice_content_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
5
]
|
| 50 | 0.18 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.value AS value_3, t0.extra_info AS extra_info_4 FROM naka_parameter t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
"social-page-link.facebook"
]
|
| 51 | 0.14 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.value AS value_3, t0.extra_info AS extra_info_4 FROM naka_parameter t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
"social-page-link.instagram"
]
|
| 52 | 0.14 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.value AS value_3, t0.extra_info AS extra_info_4 FROM naka_parameter t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
"social-page-link.twitter"
]
|
| 53 | 0.17 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.value AS value_3, t0.extra_info AS extra_info_4 FROM naka_parameter t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
"social-page-link.youtube"
]
|
| 54 | 0.16 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.value AS value_3, t0.extra_info AS extra_info_4 FROM naka_parameter t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
"social-page-link.linkedin"
]
|
| 55 | 0.17 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.value AS value_3, t0.extra_info AS extra_info_4 FROM naka_parameter t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
"social-page-link.facebook"
]
|
| 56 | 0.09 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.value AS value_3, t0.extra_info AS extra_info_4 FROM naka_parameter t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
"social-page-link.instagram"
]
|
| 57 | 0.09 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.value AS value_3, t0.extra_info AS extra_info_4 FROM naka_parameter t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
"social-page-link.twitter"
]
|
| 58 | 0.09 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.value AS value_3, t0.extra_info AS extra_info_4 FROM naka_parameter t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
"social-page-link.youtube"
]
|
| 59 | 0.08 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.value AS value_3, t0.extra_info AS extra_info_4 FROM naka_parameter t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
"social-page-link.linkedin"
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\GlsPageTypeTranslation | 25 |
| App\Entity\AboutPageTranslation | 20 |
| App\Entity\Picture | 17 |
| App\Entity\MenuItem | 9 |
| App\Entity\MenuItemTranslation | 9 |
| App\Entity\PageTranslation | 9 |
| App\Entity\AboutPage | 8 |
| App\Entity\GlsPageType | 5 |
| App\Entity\Page | 3 |
| App\Entity\WebsiteInfoTranslation | 2 |
| App\Entity\Menu | 2 |
| App\Entity\WebsiteInfo | 1 |
| App\Entity\NakaParameter | 1 |
| App\Entity\NakaSiteSettings | 1 |
| App\Entity\PictureTranslation | 1 |