Query Metrics

60 Database Queries
11 Different statements
151.60 ms Query time
5 Invalid entities

Queries

Group similar statements

# Time Info
1 4.03 ms
SELECT w0_.host AS host_0, w0_.schemes AS schemes_1, w0_.methods AS methods_2, w0_.defaults AS defaults_3, w0_.requirements AS requirements_4, w0_.options AS options_5, w0_.condition_expr AS condition_expr_6, w0_.variable_pattern AS variable_pattern_7, w0_.staticPrefix AS staticPrefix_8, w0_.id AS id_9, w0_.name AS name_10, w0_.position AS position_11, w0_.canonical_name AS canonical_name_12, w0_.tag AS tag_13, w0_.sitemapeable AS sitemapeable_14, w0_.type AS type_15, w0_.seo_meta_data AS seo_meta_data_16, w0_.content_class AS content_class_17, w0_.content_id AS content_id_18, w0_.redirect_target AS redirect_target_19, w0_.autoRoute AS autoRoute_20 FROM wam_routing_route w0_ WHERE (w0_.staticPrefix = ? AND w0_.type = ?) AND w0_.autoRoute IN ('0', '1')
Parameters:
[
  "/"
  "cmf_routing_auto.redirect"
]
2 4.24 ms
SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.condition_expr AS condition_expr_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.id AS id_10, t0.name AS name_11, t0.position AS position_12, t0.canonical_name AS canonical_name_13, t0.tag AS tag_14, t0.sitemapeable AS sitemapeable_15, t0.type AS type_16, t0.seo_meta_data AS seo_meta_data_17, t0.content_class AS content_class_18, t0.content_id AS content_id_19, t0.redirect_target AS redirect_target_20, t0.autoRoute FROM wam_routing_route t0 WHERE t0.staticPrefix IN (?) AND t0.autoRoute IN ('1') ORDER BY t0.position ASC
Parameters:
[
  [
    "/"
  ]
]
3 9.15 ms
SELECT t0.name AS name_1, t0.controller AS controller_2, t0.template AS template_3, t0.id AS id_4, t0.attributes AS attributes_5, t0.host_id AS host_id_6 FROM app_routing_url t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 34.73 ms
SELECT w0_.host AS host_0, w0_.schemes AS schemes_1, w0_.methods AS methods_2, w0_.defaults AS defaults_3, w0_.requirements AS requirements_4, w0_.options AS options_5, w0_.condition_expr AS condition_expr_6, w0_.variable_pattern AS variable_pattern_7, w0_.staticPrefix AS staticPrefix_8, w0_.id AS id_9, w0_.name AS name_10, w0_.position AS position_11, w0_.canonical_name AS canonical_name_12, w0_.tag AS tag_13, w0_.sitemapeable AS sitemapeable_14, w0_.type AS type_15, w0_.seo_meta_data AS seo_meta_data_16, w0_.content_class AS content_class_17, w0_.content_id AS content_id_18, w0_.redirect_target AS redirect_target_19, w0_.autoRoute AS autoRoute_20 FROM wam_routing_route w0_ WHERE (w0_.canonical_name = ? AND w0_.type = ?) AND w0_.autoRoute IN ('0', '1')
Parameters:
[
  "wam_routing_url_1"
  "cmf_routing_auto.primary"
]
5 4.74 ms
SELECT w0_.host AS host_0, w0_.schemes AS schemes_1, w0_.methods AS methods_2, w0_.defaults AS defaults_3, w0_.requirements AS requirements_4, w0_.options AS options_5, w0_.condition_expr AS condition_expr_6, w0_.variable_pattern AS variable_pattern_7, w0_.staticPrefix AS staticPrefix_8, w0_.id AS id_9, w0_.name AS name_10, w0_.position AS position_11, w0_.canonical_name AS canonical_name_12, w0_.tag AS tag_13, w0_.sitemapeable AS sitemapeable_14, w0_.type AS type_15, w0_.seo_meta_data AS seo_meta_data_16, w0_.content_class AS content_class_17, w0_.content_id AS content_id_18, w0_.redirect_target AS redirect_target_19, w0_.autoRoute AS autoRoute_20 FROM wam_routing_route w0_ WHERE (w0_.content_class = 'App\\Entity\\Routing\\Url' AND JSON_LENGTH(w0_.content_id) = JSON_LENGTH('{\"id\":1}') AND REPLACE(JSON_EXTRACT(w0_.content_id, '$'),' ','') LIKE '{\"id\":1}') AND w0_.autoRoute IN ('1') ORDER BY w0_.position ASC
Parameters:
[]
6 10.04 ms
SELECT t0.id AS id_1, t0.city AS city_2, t0.show_advantages AS show_advantages_3, t0.hotel_class AS hotel_class_4, t0.simple_name AS simple_name_5, t0.hotel_header_video AS hotel_header_video_6, t0.rooms_header_video AS rooms_header_video_7, t0.google_url AS google_url_8, t0.review_pro_script1 AS review_pro_script1_9, t0.review_pro_script2 AS review_pro_script2_10, t0.review_pro_script3 AS review_pro_script3_11, t0.review_pro_script4 AS review_pro_script4_12, t0.review_pro_script5 AS review_pro_script5_13, t0.review_pro_script6 AS review_pro_script6_14, t0.enabled AS enabled_15, t0.enabled_picking_up AS enabled_picking_up_16, t0.mirai_hotel_id AS mirai_hotel_id_17, t0.happy_force_hierarchy_id AS happy_force_hierarchy_id_18, t0.left_icons AS left_icons_19, t0.right_icons AS right_icons_20, t0.right_script1 AS right_script1_21, t0.right_script2 AS right_script2_22, t0.right_script3 AS right_script3_23, t0.right_script4 AS right_script4_24, t0.right_script5 AS right_script5_25, t0.right_script6 AS right_script6_26, t0.is_apartment AS is_apartment_27, t0.direction AS direction_28, t0.phone AS phone_29, t0.email AS email_30, t0.address_line1 AS address_line1_31, t0.address_line2 AS address_line2_32, t0.latitude AS latitude_33, t0.longitude AS longitude_34, t0.centered_latitude AS centered_latitude_35, t0.centered_longitude AS centered_longitude_36, t0.location_id AS location_id_37, t0.gallery_certifications_id AS gallery_certifications_id_38, t0.city_gallery_id AS city_gallery_id_39, t0.how_to_get_there_image_id AS how_to_get_there_image_id_40, t0.main_image_id AS main_image_id_41, t0.header_image_id AS header_image_id_42, t0.rooms_header_image_id AS rooms_header_image_id_43, t0.cta_image_id AS cta_image_id_44, t0.gallery1_id AS gallery1_id_45, t0.gallery2_id AS gallery2_id_46, t0.vertical_main_image_id AS vertical_main_image_id_47 FROM app_hotel t0
Parameters:
[]
7 7.56 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  1702
]
8 0.47 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  8145
]
9 0.21 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  8148
]
10 0.33 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  8197
]
11 0.33 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  7948
]
12 0.18 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  7947
]
13 0.52 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  2128
]
14 0.10 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  1704
]
15 0.27 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  1756
]
16 0.34 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  6265
]
17 0.35 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  8308
]
18 0.18 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  7950
]
19 0.29 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  2129
]
20 0.11 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  1706
]
21 0.20 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  8347
]
22 0.18 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  8349
]
23 0.26 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  8348
]
24 0.18 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  1707
]
25 0.44 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  1508
]
26 0.40 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  3858
]
27 0.29 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  6441
]
28 0.27 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  7954
]
29 0.09 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  2131
]
30 0.61 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  3730
]
31 0.70 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  5444
]
32 0.09 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  3694
]
33 0.17 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  7955
]
34 0.18 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  5445
]
35 0.45 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  5833
]
36 6.34 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  5744
]
37 0.10 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  5700
]
38 0.09 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  5832
]
39 11.31 ms
SELECT a0_.locale AS locale_0, a0_.author_name AS author_name_1, a0_.title AS title_2, a0_.body AS body_3, a0_.publication_place AS publication_place_4, a0_.location AS location_5, a0_.stars AS stars_6, a0_.landing AS landing_7, a0_.id AS id_8, a0_.created_at AS created_at_9, a0_.updated_at AS updated_at_10, a0_.position AS position_11, a0_.date_start AS date_start_12, a0_.date_end AS date_end_13, a0_.status AS status_14, a0_.category_id AS category_id_15, a0_.hotel_id AS hotel_id_16, a0_.author_image_id AS author_image_id_17 FROM app_web_content_review a0_ WHERE a0_.status = ? AND a0_.date_start <= ? AND ((a0_.date_end > ? OR a0_.date_end IS NULL)) AND a0_.locale = ? ORDER BY a0_.position ASC
Parameters:
[
  "PUBLISHED"
  "2024-11-15 13:51:05"
  "2024-11-15 13:51:05"
  "es"
]
40 0.69 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  2677
]
41 0.13 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  2673
]
42 0.12 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  2676
]
43 0.99 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  2670
]
44 0.40 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  3497
]
45 0.12 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  3498
]
46 0.11 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  3500
]
47 19.60 ms
SELECT a0_.prominent AS prominent_0, a0_.is_prominent_text_up_on_banner AS is_prominent_text_up_on_banner_1, a0_.is_prominent_text_up_on_cta AS is_prominent_text_up_on_cta_2, a0_.selected_locale AS selected_locale_3, a0_.id AS id_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.date_start AS date_start_7, a0_.date_end AS date_end_8, a0_.status AS status_9, a0_.author_id AS author_id_10, a0_.image_id AS image_id_11, a0_.cta_image_banner_id AS cta_image_banner_id_12, a0_.cta_image_id AS cta_image_id_13, a0_.category_id AS category_id_14 FROM app_news_post a0_ INNER JOIN app_news_post_translation a1_ ON a0_.id = a1_.translatable_id WHERE a0_.status = ? AND a0_.date_start <= ? AND ((a0_.date_end > ? OR a0_.date_end IS NULL)) AND a1_.locale = ? ORDER BY a0_.date_start DESC LIMIT 5
Parameters:
[
  "PUBLISHED"
  "2024-11-15 13:51:05"
  "2024-11-15 13:51:05"
  "es"
]
48 0.43 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  8222
]
49 0.13 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  8163
]
50 0.12 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  8174
]
51 0.12 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  8124
]
52 0.11 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  8111
]
53 7.05 ms
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.position AS position_5, t0.root_node AS root_node_6, t0.icon_class AS icon_class_7, t0.parent_id AS parent_id_8, t0.context AS context_9, t0.media_id AS media_id_10, t0.icon_id AS icon_id_11 FROM app_news_post_category t0
Parameters:
[]
54 16.65 ms
SELECT a0_.sku AS sku_0, a0_.price AS price_1, a0_.base_purchasable AS base_purchasable_2, a0_.id AS id_3, a0_.shipping_cost AS shipping_cost_4, a0_.stock AS stock_5, a0_.stock_enabled AS stock_enabled_6, a0_.date_start AS date_start_7, a0_.date_end AS date_end_8, a0_.status AS status_9, a0_.promoted AS promoted_10, a0_.sales AS sales_11, a0_.contact_email AS contact_email_12, a0_.contact_phone AS contact_phone_13, a0_.title_color AS title_color_14, a0_.short_text_color AS short_text_color_15, a0_.purchasable_type AS purchasable_type_16, a0_.tax_id AS tax_id_17, a0_.image_id AS image_id_18, a0_.hotel_id AS hotel_id_19, a0_.gallery_id AS gallery_id_20 FROM app_ecommerce_purchasable a0_ WHERE (a0_.status = ? AND a0_.date_start <= ? AND ((a0_.date_end > ? OR a0_.date_end IS NULL))) AND a0_.purchasable_type IN ('GIF') ORDER BY a0_.sales DESC LIMIT 5
Parameters:
[
  "PUBLISHED"
  "2024-11-15 13:51:05"
  "2024-11-15 13:51:05"
]
55 0.66 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  1251
]
56 0.53 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  8
]
57 0.12 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  1262
]
58 0.12 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  1271
]
59 0.12 ms
SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = ? AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo')
Parameters:
[
  3870
]
60 2.74 ms
SELECT w0_.host AS host_0, w0_.schemes AS schemes_1, w0_.methods AS methods_2, w0_.defaults AS defaults_3, w0_.requirements AS requirements_4, w0_.options AS options_5, w0_.condition_expr AS condition_expr_6, w0_.variable_pattern AS variable_pattern_7, w0_.staticPrefix AS staticPrefix_8, w0_.id AS id_9, w0_.name AS name_10, w0_.position AS position_11, w0_.canonical_name AS canonical_name_12, w0_.tag AS tag_13, w0_.sitemapeable AS sitemapeable_14, w0_.type AS type_15, w0_.seo_meta_data AS seo_meta_data_16, w0_.content_class AS content_class_17, w0_.content_id AS content_id_18, w0_.redirect_target AS redirect_target_19, w0_.autoRoute AS autoRoute_20 FROM wam_routing_route w0_ WHERE (w0_.canonical_name = ? AND w0_.type = ?) AND w0_.autoRoute IN ('0', '1')
Parameters:
[
  "wam_routing_url_1"
  "cmf_routing_auto.primary"
]

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
Symfony\Component\Routing\Route No errors.
Symfony\Cmf\Bundle\RoutingBundle\Model\Route No errors.
WAM\Bundle\RoutingBundle\Entity\Route No errors.
WAM\Bundle\RoutingBundle\Entity\ManualRoute No errors.
WAM\Bundle\RoutingBundle\Entity\AutoRoute No errors.
App\Entity\Routing\Url No errors.
WAM\Bundle\RoutingBundle\Entity\Host No errors.
WAM\Bundle\BlockBundle\Entity\UrlHasBlocks No errors.
App\Entity\Routing\UrlTranslation No errors.
App\Entity\User\Abstracts\AbstractUser No errors.
App\Entity\User\Admin No errors.
App\Entity\Ecommerce\Cart
  • The field App\Entity\Ecommerce\Cart#cartLines is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Ecommerce\CartLine#cart does not contain the required 'inversedBy="cartLines"' attribute.
App\Entity\Hotel No errors.
App\Entity\WebContent\Review No errors.
App\Entity\News\Post No errors.
App\Entity\News\PostCategory No errors.
App\Entity\Ecommerce\Abstracts\AbstractPurchasable
  • The association App\Entity\Ecommerce\Abstracts\AbstractPurchasable#categories refers to the inverse side field App\Entity\Ecommerce\PurchasableCategory#purchasables which does not exist.
App\Entity\Ecommerce\Gift
  • The association App\Entity\Ecommerce\Gift#categories refers to the inverse side field App\Entity\Ecommerce\PurchasableCategory#purchasables which does not exist.
App\Entity\WebContent\Faq No errors.
App\Entity\WebContent\Popup No errors.
WAM\Bundle\CoreBundle\Entity\Key No errors.
App\Entity\Form No errors.
WAM\Bundle\CoreBundle\Entity\BaseCategory No errors.
WAM\Bundle\CoreBundle\Model\Category No errors.
WAM\Bundle\CoreBundle\Entity\Cookies No errors.
Lexik\Bundle\TranslationBundle\Model\TransUnit No errors.
Lexik\Bundle\TranslationBundle\Entity\TransUnit No errors.
App\Entity\WebContent\MenuItem No errors.
App\Entity\WebContent\Banner No errors.
WAM\Bundle\EcommerceBundle\Entity\Currency No errors.
WAM\Bundle\WebMakerBundle\Entity\BlockMapping No errors.
App\Entity\Location No errors.
App\Entity\Media\Gallery
  • The field App\Entity\Media\Gallery#galleryHasMedias is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Media\GalleryHasMedia#gallery does not contain the required 'inversedBy="galleryHasMedias"' attribute.
App\Entity\Media\Media No errors.
App\Entity\KeySellingPoint No errors.
App\Entity\Experience No errors.
App\Entity\Room No errors.
App\Entity\Advantage No errors.
App\Entity\PurchasableExperience No errors.
App\Entity\Media\Category
  • The field App\Entity\Media\Category#medias is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Media\Media#category does not contain the required 'inversedBy="medias"' attribute.
App\Entity\Media\File No errors.
App\Entity\Media\VimeoVideo No errors.
App\Entity\Media\YoutubeVideo No errors.
App\Entity\Media\MediaTranslation No errors.
App\Entity\HotelTranslation No errors.
WAM\Bundle\CoreBundle\Model\Tag No errors.
App\Entity\News\PostTranslation No errors.
App\Entity\News\Author No errors.
WAM\Bundle\CoreBundle\Entity\Context No errors.
App\Entity\News\PostCategoryTranslation No errors.
WAM\Bundle\EcommerceBundle\Entity\Tax No errors.
App\Entity\Ecommerce\PurchasableCategory No errors.
App\Entity\Ecommerce\GiftHasExtra No errors.
App\Entity\Ecommerce\GiftCategory No errors.
App\Entity\Ecommerce\Abstracts\AbstractPurchasableTranslation No errors.
App\Entity\Ecommerce\GiftTranslation No errors.