Redirect 301 redirect from GET @booking_room_nl (353f8c)

GET https://www.boa.hb-preprod.com/nl/reserveren/boa-karaoke-elsene

Response
200 OK
Browse referrer URL
IP
216.73.217.167
Profiled on
Token
4b93c2

Query Metrics

18 Database Queries
16 Different statements
4.02 ms Query time
0 Invalid entities
349 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
0.76 ms
(18.94%) 		1 
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.field AS field_2, c0_.controller AS controller_3, c0_.action AS action_4, c0_.is_sitemap AS is_sitemap_5, c0_.is_contain_default_content_generator AS is_contain_default_content_generator_6, c0_.sort AS sort_7, c1_.id AS id_8, c1_.path AS path_9, c1_.seo_title AS seo_title_10, c1_.seo_description AS seo_description_11, c1_.seo_image AS seo_image_12, c1_.locale AS locale_13, c2_.id AS id_14, c2_.is_deletable AS is_deletable_15, c2_.sort AS sort_16, c3_.id AS id_17, c3_.name AS name_18, c3_.field AS field_19, c3_.type AS type_20, c4_.id AS id_21, c4_.name AS name_22, c4_.field AS field_23, c4_.type AS type_24, c4_.description AS description_25, c4_.options AS options_26, c4_.is_translation AS is_translation_27, c4_.is_required AS is_required_28, c4_.sort AS sort_29, c5_.id AS id_30, c5_.value AS value_31, c6_.id AS id_32, c6_.translation AS translation_33, c6_.locale AS locale_34, c7_.id AS id_35, c7_.name AS name_36, c7_.field AS field_37, c7_.type AS type_38, c7_.description AS description_39, c7_.options AS options_40, c7_.is_translation AS is_translation_41, c7_.is_required AS is_required_42, c7_.sort AS sort_43, c1_.translatable_id AS translatable_id_44, c2_.cms_generator_id AS cms_generator_id_45, c2_.cms_page_id AS cms_page_id_46, c4_.cms_generator_id AS cms_generator_id_47, c5_.cms_generator_page_id AS cms_generator_page_id_48, c5_.cms_generator_content_id AS cms_generator_content_id_49, c6_.translatable_id AS translatable_id_50, c7_.cms_generator_id AS cms_generator_id_51 FROM cms_page c0_ LEFT JOIN cms_page_translation c1_ ON c0_.id = c1_.translatable_id AND (c1_.locale = ?) LEFT JOIN cms_generator_page c2_ ON c0_.id = c2_.cms_page_id LEFT JOIN cms_generator c3_ ON c2_.cms_generator_id = c3_.id LEFT JOIN cms_generator_content c4_ ON c3_.id = c4_.cms_generator_id LEFT JOIN cms_page_content c5_ ON c2_.id = c5_.cms_generator_page_id LEFT JOIN cms_page_content_translation c6_ ON c5_.id = c6_.translatable_id AND (c6_.locale = ?) LEFT JOIN cms_generator_content c7_ ON c5_.cms_generator_content_id = c7_.id WHERE c0_.field = ? ORDER BY c2_.sort ASC, c4_.sort ASC
Parameters: 
[
  "nl"
  "nl"
  "booking_room"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.58 ms
(14.41%) 		1 
SELECT e0_.id AS id_0, e0_.post_code AS post_code_1, e0_.facebook_link AS facebook_link_2, e0_.instagram_link AS instagram_link_3, e0_.pinterest_link AS pinterest_link_4, e0_.linkedin_link AS linkedin_link_5, e0_.tiktok_link AS tiktok_link_6, e0_.youtube_link AS youtube_link_7, e0_.vimeo_link AS vimeo_link_8, e0_.email_link AS email_link_9, e0_.phone_link AS phone_link_10, e0_.email_order AS email_order_11, e0_.mollie_api_key AS mollie_api_key_12, e0_.image AS image_13, e0_.is_active AS is_active_14, e0_.sort AS sort_15, e1_.id AS id_16, e1_.title AS title_17, e1_.slug AS slug_18, e1_.short_title AS short_title_19, e1_.sub_title AS sub_title_20, e1_.address AS address_21, e1_.city AS city_22, e1_.country AS country_23, e1_.schedule AS schedule_24, e1_.additional_information AS additional_information_25, e1_.seo_title AS seo_title_26, e1_.seo_description AS seo_description_27, e1_.seo_image AS seo_image_28, e1_.locale AS locale_29, r2_.id AS id_30, r2_.minimum_number_of_people AS minimum_number_of_people_31, r2_.maximum_number_of_people AS maximum_number_of_people_32, r2_.percentage_of_deposit AS percentage_of_deposit_33, r2_.minimum_price_with_tax AS minimum_price_with_tax_34, r2_.sort AS sort_35, r2_.background_color_checkout AS background_color_checkout_36, r3_.id AS id_37, r3_.title AS title_38, r3_.slug AS slug_39, r3_.seo_title AS seo_title_40, r3_.seo_description AS seo_description_41, r3_.seo_image AS seo_image_42, r3_.locale AS locale_43, r4_.id AS id_44, r4_.day_of_week AS day_of_week_45, r4_.hour_begin AS hour_begin_46, r4_.hour_end AS hour_end_47, r4_.date_begin AS date_begin_48, r4_.date_end AS date_end_49, r4_.price_with_tax AS price_with_tax_50, r4_.sort AS sort_51, r5_.id AS id_52, r5_.image AS image_53, r5_.sort AS sort_54, a6_.id AS id_55, a6_.duration AS duration_56, a6_.days_of_week AS days_of_week_57, a6_.is_price_depend_number_of_people AS is_price_depend_number_of_people_58, a6_.price_per_person AS price_per_person_59, a6_.is_price_supplement AS is_price_supplement_60, a6_.price_supplement_type AS price_supplement_type_61, a6_.price_supplement_value AS price_supplement_value_62, a6_.duration_between_booking AS duration_between_booking_63, a6_.sort AS sort_64, a7_.id AS id_65, a7_.title AS title_66, a7_.description AS description_67, a7_.message_error AS message_error_68, a7_.locale AS locale_69, e1_.translatable_id AS translatable_id_70, r2_.establishment_id AS establishment_id_71, r3_.translatable_id AS translatable_id_72, r4_.room_id AS room_id_73, r5_.room_id AS room_id_74, a7_.translatable_id AS translatable_id_75 FROM establishment e0_ LEFT JOIN establishment_translation e1_ ON e0_.id = e1_.translatable_id AND (e1_.locale = ?) LEFT JOIN room r2_ ON e0_.id = r2_.establishment_id LEFT JOIN room_translation r3_ ON r2_.id = r3_.translatable_id AND (r3_.locale = ?) LEFT JOIN room_price r4_ ON r2_.id = r4_.room_id LEFT JOIN room_image r5_ ON r2_.id = r5_.room_id LEFT JOIN activity_room a8_ ON r2_.id = a8_.room_id LEFT JOIN activity a6_ ON a6_.id = a8_.activity_id LEFT JOIN activity_translation a7_ ON a6_.id = a7_.translatable_id AND (a7_.locale = ?) WHERE e0_.is_active = ? AND e1_.slug = ? ORDER BY e0_.sort ASC, r2_.sort ASC, r4_.sort ASC, r5_.sort ASC
Parameters: 
[
  "nl"
  "nl"
  "nl"
  1
  "boa-karaoke-elsene"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(7.70%) 		2 
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.short_title AS short_title_4, t0.sub_title AS sub_title_5, t0.address AS address_6, t0.city AS city_7, t0.country AS country_8, t0.schedule AS schedule_9, t0.additional_information AS additional_information_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_image AS seo_image_13, t0.locale AS locale_14, t0.translatable_id AS translatable_id_15 FROM establishment_translation t0 WHERE t0.slug = ? LIMIT 1
Parameters: 
[
  "boa-karaoke-elsene"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(7.60%) 		1 
SELECT t0.id AS id_1, t0.is_deletable AS is_deletable_2, t0.sort AS sort_3, t0.cms_generator_id AS cms_generator_id_4, t5.id AS id_6, t5.name AS name_7, t5.field AS field_8, t5.type AS type_9, t0.cms_page_id AS cms_page_id_10, t11.id AS id_12, t11.name AS name_13, t11.field AS field_14, t11.controller AS controller_15, t11.action AS action_16, t11.is_sitemap AS is_sitemap_17, t11.is_contain_default_content_generator AS is_contain_default_content_generator_18, t11.sort AS sort_19 FROM cms_generator_page t0 INNER JOIN cms_generator t5 ON t0.cms_generator_id = t5.id INNER JOIN cms_page t11 ON t0.cms_page_id = t11.id WHERE t0.cms_generator_id IN (?, ?) ORDER BY t0.sort ASC
Parameters: 
[
  20
  24
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(7.19%) 		1 
SELECT e0_.id AS id_0, e0_.post_code AS post_code_1, e0_.facebook_link AS facebook_link_2, e0_.instagram_link AS instagram_link_3, e0_.pinterest_link AS pinterest_link_4, e0_.linkedin_link AS linkedin_link_5, e0_.tiktok_link AS tiktok_link_6, e0_.youtube_link AS youtube_link_7, e0_.vimeo_link AS vimeo_link_8, e0_.email_link AS email_link_9, e0_.phone_link AS phone_link_10, e0_.email_order AS email_order_11, e0_.mollie_api_key AS mollie_api_key_12, e0_.image AS image_13, e0_.is_active AS is_active_14, e0_.sort AS sort_15, e1_.id AS id_16, e1_.title AS title_17, e1_.slug AS slug_18, e1_.short_title AS short_title_19, e1_.sub_title AS sub_title_20, e1_.address AS address_21, e1_.city AS city_22, e1_.country AS country_23, e1_.schedule AS schedule_24, e1_.additional_information AS additional_information_25, e1_.seo_title AS seo_title_26, e1_.seo_description AS seo_description_27, e1_.seo_image AS seo_image_28, e1_.locale AS locale_29, e1_.translatable_id AS translatable_id_30 FROM establishment e0_ LEFT JOIN establishment_translation e1_ ON e0_.id = e1_.translatable_id AND (e1_.locale = ?) ORDER BY e0_.sort ASC
Parameters: 
[
  "nl"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(6.52%) 		2 
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.short_title AS short_title_4, t0.sub_title AS sub_title_5, t0.address AS address_6, t0.city AS city_7, t0.country AS country_8, t0.schedule AS schedule_9, t0.additional_information AS additional_information_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_image AS seo_image_13, t0.locale AS locale_14, t0.translatable_id AS translatable_id_15 FROM establishment_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  1
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(5.64%) 		1 
SELECT t0.id AS id_1, t0.is_deletable AS is_deletable_2, t0.sort AS sort_3, t0.cms_generator_id AS cms_generator_id_4, t5.id AS id_6, t5.name AS name_7, t5.field AS field_8, t5.type AS type_9, t0.cms_page_id AS cms_page_id_10, t11.id AS id_12, t11.name AS name_13, t11.field AS field_14, t11.controller AS controller_15, t11.action AS action_16, t11.is_sitemap AS is_sitemap_17, t11.is_contain_default_content_generator AS is_contain_default_content_generator_18, t11.sort AS sort_19 FROM cms_generator_page t0 INNER JOIN cms_generator t5 ON t0.cms_generator_id = t5.id INNER JOIN cms_page t11 ON t0.cms_page_id = t11.id WHERE t0.cms_page_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0.sort ASC
Parameters: 
[
  10
  17
  16
  15
  14
  12
  7
  2
  9
  6
  18
  19
]
View formatted query    View runnable query    Explain query    View query backtrace
0.21 ms
(5.12%) 		1 
SELECT t0.id AS id_1, t0.is_deletable AS is_deletable_2, t0.sort AS sort_3, t0.cms_generator_id AS cms_generator_id_4, t5.id AS id_6, t5.name AS name_7, t5.field AS field_8, t5.type AS type_9, t0.cms_page_id AS cms_page_id_10, t11.id AS id_12, t11.name AS name_13, t11.field AS field_14, t11.controller AS controller_15, t11.action AS action_16, t11.is_sitemap AS is_sitemap_17, t11.is_contain_default_content_generator AS is_contain_default_content_generator_18, t11.sort AS sort_19 FROM cms_generator_page t0 INNER JOIN cms_generator t5 ON t0.cms_generator_id = t5.id INNER JOIN cms_page t11 ON t0.cms_page_id = t11.id WHERE t0.cms_generator_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0.sort ASC
Parameters: 
[
  25
  22
  2
  9
  19
  11
  6
  23
  21
  17
  4
  26
]
View formatted query    View runnable query    Explain query    View query backtrace
0.18 ms
(4.40%) 		1 
SELECT t0.id AS id_1, t0.value AS value_2, t0.cms_generator_page_id AS cms_generator_page_id_3, t0.cms_generator_content_id AS cms_generator_content_id_4 FROM cms_page_content t0 WHERE t0.cms_generator_page_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  51
  36
  63
  56
  27
  64
  57
  28
  60
  37
  65
  58
  29
  59
  30
  61
  62
  55
  53
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(4.28%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.field AS field_3, t0.type AS type_4, t0.description AS description_5, t0.options AS options_6, t0.is_translation AS is_translation_7, t0.is_required AS is_required_8, t0.sort AS sort_9, t0.cms_generator_id AS cms_generator_id_10 FROM cms_generator_content t0 WHERE t0.cms_generator_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0.sort ASC
Parameters: 
[
  25
  22
  2
  9
  19
  11
  6
  23
  21
  17
  4
  26
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(4.18%) 		1 
SELECT t0.id AS id_1, t0.value AS value_2, t0.cms_generator_page_id AS cms_generator_page_id_3, t0.cms_generator_content_id AS cms_generator_content_id_4 FROM cms_page_content t0 WHERE t0.cms_generator_page_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  33
  44
  43
  42
  41
  39
  34
  31
  26
  46
  38
  48
  49
  52
  54
  45
]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(3.21%) 		1 
SELECT t0.id AS id_1, t0.is_deletable AS is_deletable_2, t0.sort AS sort_3, t0.cms_generator_id AS cms_generator_id_4, t5.id AS id_6, t5.name AS name_7, t5.field AS field_8, t5.type AS type_9, t0.cms_page_id AS cms_page_id_10, t11.id AS id_12, t11.name AS name_13, t11.field AS field_14, t11.controller AS controller_15, t11.action AS action_16, t11.is_sitemap AS is_sitemap_17, t11.is_contain_default_content_generator AS is_contain_default_content_generator_18, t11.sort AS sort_19 FROM cms_generator_page t0 INNER JOIN cms_generator t5 ON t0.cms_generator_id = t5.id INNER JOIN cms_page t11 ON t0.cms_page_id = t11.id WHERE t0.cms_generator_id IN (?, ?, ?) ORDER BY t0.sort ASC
Parameters: 
[
  3
  7
  15
]
View formatted query    View runnable query    Explain query    View query backtrace
0.12 ms
(3.08%) 		1 
SELECT t0.id AS id_1, t0.is_deletable AS is_deletable_2, t0.sort AS sort_3, t0.cms_generator_id AS cms_generator_id_4, t5.id AS id_6, t5.name AS name_7, t5.field AS field_8, t5.type AS type_9, t0.cms_page_id AS cms_page_id_10, t11.id AS id_12, t11.name AS name_13, t11.field AS field_14, t11.controller AS controller_15, t11.action AS action_16, t11.is_sitemap AS is_sitemap_17, t11.is_contain_default_content_generator AS is_contain_default_content_generator_18, t11.sort AS sort_19 FROM cms_generator_page t0 INNER JOIN cms_generator t5 ON t0.cms_generator_id = t5.id INNER JOIN cms_page t11 ON t0.cms_page_id = t11.id WHERE t0.cms_page_id IN (?) ORDER BY t0.sort ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.12 ms
(2.96%) 		1 
SELECT t0.id AS id_1, t0.value AS value_2, t0.cms_generator_page_id AS cms_generator_page_id_3, t0.cms_generator_content_id AS cms_generator_content_id_4 FROM cms_page_content t0 WHERE t0.cms_generator_page_id IN (?, ?, ?, ?, ?, ?)
Parameters: 
[
  13
  14
  15
  16
  17
  19
]
View formatted query    View runnable query    Explain query    View query backtrace
0.10 ms
(2.54%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.field AS field_3, t0.type AS type_4, t0.description AS description_5, t0.options AS options_6, t0.is_translation AS is_translation_7, t0.is_required AS is_required_8, t0.sort AS sort_9, t0.cms_generator_id AS cms_generator_id_10 FROM cms_generator_content t0 WHERE t0.cms_generator_id IN (?, ?, ?) ORDER BY t0.sort ASC
Parameters: 
[
  3
  7
  15
]
View formatted query    View runnable query    Explain query    View query backtrace
0.09 ms
(2.23%) 		1 
SELECT t0.id AS id_1, t0.value AS value_2, t0.cms_generator_page_id AS cms_generator_page_id_3, t0.cms_generator_content_id AS cms_generator_content_id_4 FROM cms_page_content t0 WHERE t0.cms_generator_page_id IN (?, ?, ?)
Parameters: 
[
  1
  18
  25
]
View formatted query    View runnable query    Explain query    View query backtrace

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\Core\Entity\CmsPageContent 188
App\Core\Entity\CmsGeneratorContent 75
App\Core\Entity\CmsGeneratorPage 46
App\Core\Entity\CmsGenerator 17
App\Core\Entity\CmsPage 14
App\Entity\Establishment\EstablishmentTranslation 4
App\Entity\Establishment\Establishment 2
App\Core\Entity\CmsPageContentTranslation 2
App\Core\Entity\CmsPageTranslation 1

Entities Mapping

Class Mapping errors
App\Entity\Establishment\Establishment No errors.
App\Entity\Establishment\EstablishmentTranslation No errors.
App\Entity\Establishment\Room No errors.
App\Entity\Establishment\Option No errors.
App\Entity\Content\Content No errors.
App\Core\Entity\CmsPage No errors.
App\Core\Entity\CmsPageTranslation No errors.
App\Core\Entity\CmsGeneratorPage No errors.
App\Core\Entity\CmsGenerator No errors.
App\Core\Entity\CmsGeneratorContent No errors.
App\Core\Entity\CmsPageContent No errors.
App\Core\Entity\CmsPageContentTranslation No errors.
App\Core\Entity\CmsGeneratorFlexiblePage No errors.
App\Core\Entity\CmsGeneratorEmail No errors.
App\Core\Entity\CmsEmailContent No errors.
App\Entity\Establishment\RoomTranslation No errors.
App\Entity\Establishment\RoomPrice No errors.
App\Entity\Establishment\RoomImage No errors.
App\Entity\Activity\Activity No errors.
App\Entity\Activity\ActivityTranslation No errors.