Query Metrics
21
Database Queries
10
Different statements
5.49 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.54 ms (28.12%) |
6 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.short_content AS short_content_3, t0.content AS content_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM blog_post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
16
]
|
0.79 ms (14.41%) |
3 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.plain_password AS plain_password_7, t0.preferred_locale AS preferred_locale_8, t0.birth_date AS birth_date_9, t0.is_verified AS is_verified_10, t0.last_verification_email_sent_at AS last_verification_email_sent_at_11, t0.street AS street_12, t0.zip_code AS zip_code_13, t0.city AS city_14, t0.country AS country_15, t0.in_who_is_who AS in_who_is_who_16, t0.display_name AS display_name_17, t0.spoken_languages AS spoken_languages_18, t0.location AS location_19, t0.show_email AS show_email_20, t0.show_in_blog_team AS show_in_blog_team_21, t0.phone_number AS phone_number_22, t0.whatsapp_phone_number AS whatsapp_phone_number_23, t0.telegram_phone_number AS telegram_phone_number_24, t0.telegram_pseudo AS telegram_pseudo_25, t0.signal_phone_number AS signal_phone_number_26, t0.admin_user_main_picture_id AS admin_user_main_picture_id_27 FROM admin_user t0 WHERE t0.id = ?
Parameters:
[
3
]
|
0.65 ms (11.91%) |
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:
[
26
]
|
0.63 ms (11.50%) |
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.gls_page_type_id AS gls_page_type_id_12, t0.slide_picture_id AS slide_picture_id_13, t0.training_id AS training_id_14 FROM page t0 WHERE t0.id = ?
Parameters:
[
26
]
|
0.43 ms (7.82%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.active AS active_2, b0_.day_of_week AS day_of_week_3, b0_.blog_post_type AS blog_post_type_4, b0_.blog_post_news_category AS blog_post_news_category_5, b0_.blog_post_brain_food_category AS blog_post_brain_food_category_6, b0_.meta_title AS meta_title_7, b0_.meta_description AS meta_description_8, b0_.meta_keywords AS meta_keywords_9, b0_.slug AS slug_10, b0_.created_at AS created_at_11, b0_.updated_at AS updated_at_12 FROM blog_post b0_ WHERE b0_.blog_post_type = ?) dctrn_result) dctrn_table
Parameters:
[
"BrainFood"
]
|
0.36 ms (6.62%) |
1 |
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:
[
4
]
|
0.32 ms (5.88%) |
1 |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.active AS active_2, b0_.day_of_week AS day_of_week_3, b0_.blog_post_type AS blog_post_type_4, b0_.blog_post_news_category AS blog_post_news_category_5, b0_.blog_post_brain_food_category AS blog_post_brain_food_category_6, b0_.meta_title AS meta_title_7, b0_.meta_description AS meta_description_8, b0_.meta_keywords AS meta_keywords_9, b0_.slug AS slug_10, b0_.created_at AS created_at_11, b0_.updated_at AS updated_at_12, b0_.admin_user_id AS admin_user_id_13, b0_.blog_post_main_picture_id AS blog_post_main_picture_id_14, b0_.blog_post_second_picture_id AS blog_post_second_picture_id_15, b0_.blog_post_third_picture_id AS blog_post_third_picture_id_16 FROM blog_post b0_ WHERE b0_.blog_post_type = ? AND b0_.id IN (?, ?, ?, ?, ?, ?)
Parameters:
[ "BrainFood" 16 17 18 19 20 21 ] |
0.29 ms (5.27%) |
1 |
SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.active AS active_2, b0_.day_of_week AS day_of_week_3, b0_.blog_post_type AS blog_post_type_4, b0_.blog_post_news_category AS blog_post_news_category_5, b0_.blog_post_brain_food_category AS blog_post_brain_food_category_6, b0_.meta_title AS meta_title_7, b0_.meta_description AS meta_description_8, b0_.meta_keywords AS meta_keywords_9, b0_.slug AS slug_10, b0_.created_at AS created_at_11, b0_.updated_at AS updated_at_12 FROM blog_post b0_ WHERE b0_.blog_post_type = ?) dctrn_result LIMIT 6 OFFSET 12
Parameters:
[
"BrainFood"
]
|
0.26 ms (4.65%) |
1 |
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"
]
|
0.21 ms (3.82%) |
1 |
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:
[
"blogFooterMenu"
]
|
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.