https://whater-dev.uegmobile.com/public/whater/show/whaterpoint/id/93fbf11f-5a28-4e5a-b2bb-9185c1f1b801

Query Metrics

3 Database Queries
3 Different statements
4.97 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.20 ms
"START TRANSACTION"
Parameters:
[]
2 4.51 ms
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:
[
  "93fbf11f-5a28-4e5a-b2bb-9185c1f1b801"
]
3 0.26 ms
"COMMIT"
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.