https://whater-dev.uegmobile.com/public/distribution-network/show/id/5640f5f0-1224-46f3-bd34-2eb065775937

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.21 ms
"START TRANSACTION"
Parameters:
[]
2 0.76 ms
SELECT w0_.uuid AS uuid_0, w0_.name AS name_1, w0_.type AS type_2, w0_.slug AS slug_3, w0_.sinac_id AS sinac_id_4, w0_.whater_status AS whater_status_5, w0_.whater_status_by_government AS whater_status_by_government_6, w0_.whater_status_by_government_updated_at AS whater_status_by_government_updated_at_7, w0_.whater_status_by_operator AS whater_status_by_operator_8, w0_.whater_status_by_operator_updated_at AS whater_status_by_operator_updated_at_9, w0_.whater_status_by_ubication AS whater_status_by_ubication_10, w0_.whater_status_by_ubication_updated_at AS whater_status_by_ubication_updated_at_11, w0_.details AS details_12, w0_.created_at AS created_at_13, w0_.updated_at AS updated_at_14, w0_.last_analitycs_update_at AS last_analitycs_update_at_15, w0_.center_longitude AS center_longitude_16, w0_.center_latitude AS center_latitude_17, ST_AsBinary(w0_.geometry_polygon) AS geometry_polygon_18, w0_.geometry_area_in_ha AS geometry_area_in_ha_19, w0_.sinac_connection_errors AS sinac_connection_errors_20, w0_.last_sinac_connection_at AS last_sinac_connection_at_21, w0_.notify_whater_status_change AS notify_whater_status_change_22, w0_.last_professional_valoration_at AS last_professional_valoration_at_23, w0_.last_user_valoration_at AS last_user_valoration_at_24, w0_.total_color AS total_color_25, w0_.total_taste AS total_taste_26, w0_.total_smell AS total_smell_27, w0_.total_turbidity AS total_turbidity_28, w0_.total_general AS total_general_29, w0_.average_professional_general AS average_professional_general_30, w0_.average_user_general AS average_user_general_31, w0_.count_user_general AS count_user_general_32, w0_.count_professional_general AS count_professional_general_33, w0_.country_uuid AS country_uuid_34, w0_.parent_uuid AS parent_uuid_35, w0_.resp_organ_government_uuid AS resp_organ_government_uuid_36, w0_.resp_organ_operator_uuid AS resp_organ_operator_uuid_37, w0_.resp_organ_corporative_uuid AS resp_organ_corporative_uuid_38, w0_.resp_organ_ubication_uuid AS resp_organ_ubication_uuid_39 FROM wt_whater_distr_network w0_ WHERE w0_.uuid = ?
Parameters:
[
  "5640f5f0-1224-46f3-bd34-2eb065775937"
]
3 0.29 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.