Query Metrics
7
Database Queries
7
Different statements
3.55 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.03 ms (28.96%) |
1 |
SELECT t0.uuid AS uuid_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.external_ids AS external_ids_6, t0.geo_name_id AS geo_name_id_7, t0.population AS population_8, t0.admin_code AS admin_code_9, t0.country_uuid AS country_uuid_10 FROM wt_zone_country_area t0 WHERE t0.uuid = ?
Parameters:
[
"68be7073-d2a7-495e-a05b-7e968e870992"
]
|
0.61 ms (17.18%) |
1 |
SELECT w0_.uuid AS uuid_0, w0_.name AS name_1, w0_.postal_code AS postal_code_2, w0_.slug AS slug_3, w0_.email AS email_4, w0_.longitude AS longitude_5, w0_.latitude AS latitude_6, w0_.population AS population_7, w0_.created_at AS created_at_8, w0_.updated_at AS updated_at_9, w0_.town_uuid AS town_uuid_10, w0_.town_location_uuid AS town_location_uuid_11, w0_.distribution_network_uuid AS distribution_network_uuid_12, w0_.whater_organization_uuid AS whater_organization_uuid_13 FROM wt_zone_ubication w0_ WHERE w0_.slug = ?
Parameters:
[
"la-rinconada"
]
|
0.59 ms (16.61%) |
1 |
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.slug AS slug_3, t0.external_ids AS external_ids_4, t0.geo_name_id AS geo_name_id_5, t0.population AS population_6, t0.longitude AS longitude_7, t0.latitude AS latitude_8, ST_AsBinary(t0.geometry_polygon) AS geometry_polygon_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.sinac_synchonization_at AS sinac_synchonization_at_12, t0.country_area_uuid AS country_area_uuid_13, t0.country_uuid AS country_uuid_14, t0.whater_organization_uuid AS whater_organization_uuid_15 FROM wt_zone_town t0 WHERE t0.uuid = ?
Parameters:
[
"857a351c-caca-43d6-844c-c660ca0a82c9"
]
|
0.47 ms (13.22%) |
1 |
SELECT t0.uuid AS uuid_1, t0.iso_code AS iso_code_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.iso_code3 AS iso_code3_6, t0.iso_numeric AS iso_numeric_7, t0.geo_name_id AS geo_name_id_8, t0.continent AS continent_9, t0.capital AS capital_10, t0.area_in_km2 AS area_in_km2_11, t0.population AS population_12, t0.longitude AS longitude_13, t0.latitude AS latitude_14 FROM wt_zone_country t0 WHERE t0.uuid = ?
Parameters:
[
"216abc6f-594d-49ea-8977-8976ca33e92c"
]
|
0.45 ms (12.80%) |
1 |
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.type AS type_3, t0.slug AS slug_4, t0.sinac_id AS sinac_id_5, t0.whater_status AS whater_status_6, t0.whater_status_by_government AS whater_status_by_government_7, t0.whater_status_by_government_updated_at AS whater_status_by_government_updated_at_8, t0.whater_status_by_operator AS whater_status_by_operator_9, t0.whater_status_by_operator_updated_at AS whater_status_by_operator_updated_at_10, t0.whater_status_by_ubication AS whater_status_by_ubication_11, t0.whater_status_by_ubication_updated_at AS whater_status_by_ubication_updated_at_12, t0.details AS details_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.last_analitycs_update_at AS last_analitycs_update_at_16, t0.center_longitude AS center_longitude_17, t0.center_latitude AS center_latitude_18, ST_AsBinary(t0.geometry_polygon) AS geometry_polygon_19, t0.geometry_area_in_ha AS geometry_area_in_ha_20, t0.sinac_connection_errors AS sinac_connection_errors_21, t0.last_sinac_connection_at AS last_sinac_connection_at_22, t0.notify_whater_status_change AS notify_whater_status_change_23, t0.last_professional_valoration_at AS last_professional_valoration_at_24, t0.last_user_valoration_at AS last_user_valoration_at_25, t0.total_color AS total_color_26, t0.total_taste AS total_taste_27, t0.total_smell AS total_smell_28, t0.total_turbidity AS total_turbidity_29, t0.total_general AS total_general_30, t0.average_professional_general AS average_professional_general_31, t0.average_user_general AS average_user_general_32, t0.count_user_general AS count_user_general_33, t0.count_professional_general AS count_professional_general_34, t0.country_uuid AS country_uuid_35, t0.parent_uuid AS parent_uuid_36, t0.resp_organ_government_uuid AS resp_organ_government_uuid_37, t0.resp_organ_operator_uuid AS resp_organ_operator_uuid_38, t0.resp_organ_corporative_uuid AS resp_organ_corporative_uuid_39, t0.resp_organ_ubication_uuid AS resp_organ_ubication_uuid_40 FROM wt_whater_distr_network t0 WHERE t0.uuid = ?
Parameters:
[
"e2b7f992-cbf1-40b4-9712-4b6d2d680825"
]
|
0.23 ms (6.60%) |
1 |
"COMMIT"
Parameters:
[] |
0.16 ms (4.63%) |
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.