Query Metrics
85
Database Queries
13
Different statements
15.53 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.10 ms (20.00%) |
16 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.short_presentation AS short_presentation_3, t0.presentation AS presentation_4, t0.blog_title AS blog_title_5, t0.blog_short_presentation AS blog_short_presentation_6, t0.blog_presentation AS blog_presentation_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM admin_user_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
3
]
|
2.58 ms (16.64%) |
18 |
SELECT t0.id AS id_1, t0.description AS description_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM admin_user_occupation_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
7
]
|
2.30 ms (14.80%) |
16 |
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:
[
58
]
|
1.48 ms (9.51%) |
11 |
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"
]
|
1.24 ms (7.97%) |
6 |
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
]
|
1.01 ms (6.54%) |
1 |
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.background_color AS background_color_2, g0_.priority AS priority_3, a1_.id AS id_4, a2_.id AS id_5, a2_.email AS email_6, a2_.roles AS roles_7, a2_.password AS password_8, a2_.first_name AS first_name_9, a2_.last_name AS last_name_10, a2_.plain_password AS plain_password_11, a2_.preferred_locale AS preferred_locale_12, a2_.birth_date AS birth_date_13, a2_.is_verified AS is_verified_14, a2_.last_verification_email_sent_at AS last_verification_email_sent_at_15, a2_.street AS street_16, a2_.zip_code AS zip_code_17, a2_.city AS city_18, a2_.country AS country_19, a2_.in_who_is_who AS in_who_is_who_20, a2_.display_name AS display_name_21, a2_.spoken_languages AS spoken_languages_22, a2_.location AS location_23, a2_.show_email AS show_email_24, a2_.show_in_blog_team AS show_in_blog_team_25, a2_.provide_individual_session AS provide_individual_session_26, a2_.phone_number AS phone_number_27, a2_.whatsapp_phone_number AS whatsapp_phone_number_28, a2_.telegram_phone_number AS telegram_phone_number_29, a2_.telegram_pseudo AS telegram_pseudo_30, a2_.signal_phone_number AS signal_phone_number_31, a1_.admin_user_id AS admin_user_id_32, a1_.occupation_id AS occupation_id_33, a2_.admin_user_main_picture_id AS admin_user_main_picture_id_34 FROM gls_occupation g0_ LEFT JOIN admin_user_occupation a1_ ON g0_.id = a1_.occupation_id LEFT JOIN admin_user a2_ ON a1_.admin_user_id = a2_.id WHERE a2_.in_who_is_who = ? ORDER BY g0_.priority ASC
Parameters:
[
1
]
|
0.90 ms (5.82%) |
4 |
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
]
|
0.76 ms (4.88%) |
2 |
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
]
|
0.65 ms (4.19%) |
3 |
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.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
4
]
|
0.55 ms (3.52%) |
3 |
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
]
|
0.37 ms (2.38%) |
2 |
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"
]
|
0.35 ms (2.27%) |
2 |
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.gls_page_type_banner_id AS gls_page_type_banner_id_7, t0.gls_page_type_slide_id AS gls_page_type_slide_id_8 FROM gls_page_type t0 WHERE t0.active = ?
Parameters:
[
1
]
|
0.23 ms (1.49%) |
1 |
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
]
|
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.