Query Metrics

51 Database Queries
21 Different statements
14.07 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.38 ms
(16.88%)
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.76 ms
(12.49%)
7
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.35 ms
(9.62%)
5
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
]
1.31 ms
(9.34%)
4
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:
[
  27
]
0.91 ms
(6.48%)
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.79 ms
(5.61%)
3
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:
[
  28
]
0.77 ms
(5.49%)
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:
[
  4
]
0.54 ms
(3.85%)
2
SELECT t0.id AS id_1, t0.tag_name AS tag_name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM page_tag_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
0.50 ms
(3.54%)
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.42 ms
(2.95%)
1
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.page_id = ? ORDER BY t0.position ASC
Parameters:
[
  27
]
0.38 ms
(2.72%)
1
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.slug = ? LIMIT 1
Parameters:
[
  "massage-practitioner-training-2025-massage-practitioner-training-2025"
]
0.38 ms
(2.71%)
1
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 INNER JOIN event_trainers ON t0.id = event_trainers.admin_user_id WHERE event_trainers.gls_event_id = ?
Parameters:
[
  78
]
0.34 ms
(2.44%)
1
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.active AS active_2, g0_.priority AS priority_3, g0_.begin_date AS begin_date_4, g0_.end_date AS end_date_5, g0_.city AS city_6, g0_.country AS country_7, g0_.event_id AS event_id_8, g0_.spoken_languages AS spoken_languages_9, g0_.module_order AS module_order_10, g0_.slug AS slug_11, g0_.created_at AS created_at_12, g0_.updated_at AS updated_at_13, g0_.related_gls_page_id AS related_gls_page_id_14, g0_.leader_id AS leader_id_15, g0_.company_id AS company_id_16 FROM gls_event g0_ INNER JOIN page p1_ ON g0_.related_gls_page_id = p1_.id WHERE g0_.active = 1 AND p1_.active = 1 AND g0_.begin_date >= ? AND p1_.id = ? ORDER BY g0_.begin_date ASC
Parameters:
[
  "2024-09-28 13:08:57"
  27
]
0.34 ms
(2.39%)
1
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:
[
  6
]
0.33 ms
(2.34%)
1
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.page_banner_id AS page_banner_id_7 FROM gls_page_type t0 WHERE t0.id = ?
Parameters:
[
  6
]
0.31 ms
(2.21%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.slug AS slug_4 FROM page_tag t0 INNER JOIN page_page_tag ON t0.id = page_page_tag.page_tag_id WHERE page_page_tag.page_id = ?
Parameters:
[
  27
]
0.27 ms
(1.92%)
1
SELECT t0.id AS id_1, t0.total_amount AS total_amount_2, t0.qty AS qty_3, t0.qty_remaining AS qty_remaining_4, t0.currency AS currency_5, t0.price_type AS price_type_6, t0.early_bird_available_till AS early_bird_available_till_7, t0.gls_event_id AS gls_event_id_8 FROM price t0 WHERE t0.gls_event_id = ? ORDER BY t0.id DESC
Parameters:
[
  78
]
0.26 ms
(1.88%)
1
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.page_gallery_id = ?
Parameters:
[
  4
]
0.25 ms
(1.77%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_event_location AS short_event_location_3, t0.short_description AS short_description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM gls_event_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  78
]
0.24 ms
(1.72%)
1
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.page_banner_id AS page_banner_id_7 FROM gls_page_type t0 WHERE t0.active = ?
Parameters:
[
  1
]
0.23 ms
(1.65%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM page_gallery t0 WHERE t0.id = ?
Parameters:
[
  4
]

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
HouseOfAgile\NakaCMSBundle\Entity\Page No errors.
App\Entity\Page No errors.
HouseOfAgile\NakaCMSBundle\Entity\PageGallery No errors.
App\Entity\PageGallery No errors.
HouseOfAgile\NakaCMSBundle\Entity\Picture No errors.
Vich\UploaderBundle\Entity\File No errors.
App\Entity\Picture No errors.
App\Entity\GlsPageType No errors.
App\Entity\Training No errors.
HouseOfAgile\NakaCMSBundle\Entity\Category No errors.
App\Entity\Category No errors.
HouseOfAgile\NakaCMSBundle\Entity\MenuItem No errors.
App\Entity\MenuItem No errors.
HouseOfAgile\NakaCMSBundle\Entity\PageBlockElement No errors.
App\Entity\PageBlockElement No errors.
App\Entity\GlsEvent No errors.
App\Entity\PageTag No errors.
HouseOfAgile\NakaCMSBundle\Entity\PageTranslation No errors.
App\Entity\PageTranslation No errors.
App\Entity\GlsPageTypeTranslation No errors.
HouseOfAgile\NakaCMSBundle\Entity\BaseUser No errors.
HouseOfAgile\NakaCMSBundle\Entity\AdminUser No errors.
App\Entity\AdminUser No errors.
App\Entity\Company No errors.
App\Entity\Price No errors.
App\Entity\GlsBooking No errors.
App\Entity\GlsTicket No errors.
HouseOfAgile\NakaCMSBundle\Entity\WebsiteAsset No errors.
App\Entity\WebsiteAsset No errors.
App\Entity\GlsEventTranslation No errors.
HouseOfAgile\NakaCMSBundle\Entity\BlockElement No errors.
App\Entity\BlockElement No errors.
App\Entity\AboutPage No errors.
HouseOfAgile\NakaCMSBundle\Entity\NakaParameter No errors.
App\Entity\NakaParameter No errors.
HouseOfAgile\NakaCMSBundle\Entity\Menu No errors.
App\Entity\Menu No errors.
HouseOfAgile\NakaCMSBundle\Entity\MenuItemTranslation No errors.
App\Entity\MenuItemTranslation No errors.
HouseOfAgile\NakaCMSBundle\Entity\PictureGallery No errors.
App\Entity\PictureGallery No errors.
HouseOfAgile\NakaCMSBundle\Entity\Gallery No errors.
App\Entity\Gallery No errors.
App\Entity\BlogPost No errors.
App\Entity\PageTagTranslation No errors.
App\Entity\GlsMemberSpeciality No errors.
App\Entity\AdminUserTranslation No errors.