https://whater-dev.uegmobile.com/public/country-area/show/name/partido-de-campana

Query Metrics

5 Database Queries
5 Different statements
29.07 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
16.57 ms
(56.99%)
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.slug = ? LIMIT 1
Parameters:
[
  "partido-de-campana"
]
11.50 ms
(39.57%)
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.country_area_uuid = ?
Parameters:
[
  "f3b0a9d0-7600-47a2-959a-509230da028c"
]
0.50 ms
(1.73%)
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:
[
  "dc3ff466-3142-49d4-9753-1919e9b7454a"
]
0.29 ms
(0.99%)
1
"COMMIT"
Parameters:
[]
0.21 ms
(0.71%)
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.