Query Metrics
28
Database Queries
7
Different statements
13.58 ms
Query time
5
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
5.23 ms (0.00%) |
2 |
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:
[ "app_routing_url_34" "cmf_routing_auto.primary" ] |
3.32 ms (0.00%) |
1 |
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\":34}') AND REPLACE(JSON_EXTRACT(w0_.content_id, '$'),' ','') LIKE '{\"id\":34}') AND w0_.autoRoute IN ('1') ORDER BY w0_.position ASC
Parameters:
[] |
2.53 ms (0.00%) |
21 |
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
]
|
0.97 ms (0.00%) |
1 |
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:
[ [ "/en/menorca/what-to-see-in-4-days" "/en/menorca" "/en" "/" ] ] |
0.80 ms (0.00%) |
1 |
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:
[ "/en/menorca/what-to-see-in-4-days" "cmf_routing_auto.redirect" ] |
0.41 ms (0.00%) |
1 |
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:
[
34
]
|
0.33 ms (0.00%) |
1 |
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 WHERE t0.city = ?
Parameters:
[
"menorca"
]
|
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\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\Review | 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. |