https://whater-dev.uegmobile.com/public/whater/show/whaterpoint/id/85016985-3676-4923-ac40-0136bc3253a4

Query Metrics

4 Database Queries
4 Different statements
1.61 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.76 ms
(47.23%)
1
SELECT w0_.uuid AS uuid_0, w0_.name AS name_1, w0_.type AS type_2, w0_.certification AS certification_3, w0_.longitude AS longitude_4, w0_.latitude AS latitude_5, w0_.slug AS slug_6, ST_AsBinary(w0_.geo_point) AS geo_point_7, w0_.created_at AS created_at_8, w0_.updated_at AS updated_at_9, w0_.whater_status AS whater_status_10, w0_.whater_status_at AS whater_status_at_11, w0_.last_professional_valoration_at AS last_professional_valoration_at_12, w0_.last_user_valoration_at AS last_user_valoration_at_13, w0_.total_color AS total_color_14, w0_.total_taste AS total_taste_15, w0_.total_smell AS total_smell_16, w0_.total_turbidity AS total_turbidity_17, w0_.total_general AS total_general_18, w0_.average_professional_general AS average_professional_general_19, w0_.average_user_general AS average_user_general_20, w0_.count_user_general AS count_user_general_21, w0_.count_professional_general AS count_professional_general_22, w0_.sinac_id AS sinac_id_23, w0_.sinac_slug AS sinac_slug_24, w0_.dispersed AS dispersed_25, w0_.confirmed_geoposition AS confirmed_geoposition_26, w0_.osm_id AS osm_id_27, w0_.osm_data AS osm_data_28, w0_.import_notes AS import_notes_29, w0_.validated_by_admin AS validated_by_admin_30, w0_.notify_whater_status_change AS notify_whater_status_change_31, w0_.distribution_network_uuid AS distribution_network_uuid_32, w0_.town_uuid AS town_uuid_33, w0_.town_location_uuid AS town_location_uuid_34, w0_.district_uuid AS district_uuid_35, w0_.ubication_uuid AS ubication_uuid_36, w0_.establishment_uuid AS establishment_uuid_37, w0_.created_by_uuid AS created_by_uuid_38, w0_.whater_device_uuid AS whater_device_uuid_39, w0_.resp_organ_corporative_uuid AS resp_organ_corporative_uuid_40, w0_.resp_organ_ubication_uuid AS resp_organ_ubication_uuid_41 FROM wt_whater_point w0_ WHERE w0_.uuid = ?
Parameters:
[
  "85016985-3676-4923-ac40-0136bc3253a4"
]
0.42 ms
(26.17%)
1
SELECT t0.uuid AS uuid_1, t0.product_label AS product_label_2, t0.product_slug AS product_slug_3, t0.product_type AS product_type_4, t0.product_short_description AS product_short_description_5, t0.product_description AS product_description_6, t0.product_price AS product_price_7, t0.product_vat_percent AS product_vat_percent_8, t0.whater_commision_percent AS whater_commision_percent_9, t0.is_enable AS is_enable_10, t0.is_shippable AS is_shippable_11, t0.product_weight AS product_weight_12, t0.product_length AS product_length_13, t0.product_width AS product_width_14, t0.product_height AS product_height_15, t0.accept_whatercoins AS accept_whatercoins_16, t0.is_internal_product AS is_internal_product_17, t0.average_valorations AS average_valorations_18, t0.tags AS tags_19, t0.recommend_to_water_status_suitable AS recommend_to_water_status_suitable_20, t0.recommend_to_water_status_not_suitable AS recommend_to_water_status_not_suitable_21, t0.recommend_to_water_status_with_restrictions AS recommend_to_water_status_with_restrictions_22, t0.recommend_to_water_status_unknown AS recommend_to_water_status_unknown_23, t0.the_things_network_device_name AS the_things_network_device_name_24, t0.whater_supply_miliseconds AS whater_supply_miliseconds_25, t0.max_discount_percentage_allowed AS max_discount_percentage_allowed_26, t0.requires_shipping_costs AS requires_shipping_costs_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.whater_point_uuid AS whater_point_uuid_30, t0.whater_organization_uuid AS whater_organization_uuid_31, t0.product_category_uuid AS product_category_uuid_32 FROM wt_product t0 WHERE t0.whater_point_uuid = ?
Parameters:
[
  "85016985-3676-4923-ac40-0136bc3253a4"
]
0.28 ms
(17.28%)
1
"COMMIT"
Parameters:
[]
0.15 ms
(9.32%)
1
"START TRANSACTION"
Parameters:
[]

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.