Query Metrics
60
Database Queries
11
Different statements
151.60 ms
Query time
5
Invalid entities
Queries
#▲ | 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 |
|
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 |
|
App\Entity\Ecommerce\Gift |
|
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 |
|
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 |
|
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. |