Query Metrics
5
Database Queries
5
Different statements
54.15 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
33.51 ms (61.88%) |
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:
[
"d89313c5-8181-4fa9-b794-ebc7e535d4bf"
]
|
19.62 ms (36.23%) |
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:
[
"badajoz"
]
|
0.54 ms (1.00%) |
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.29 ms (0.53%) |
1 |
"COMMIT"
Parameters:
[] |
0.20 ms (0.37%) |
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.
Entities Mapping
Class | Mapping errors |
---|---|
Whater\Domain\Security\ValueObject\AuthUser | No errors. |
Whater\Domain\User\Model\User | No errors. |
Whater\Domain\Zones\Model\CountryArea | No errors. |
Whater\Domain\Zones\Model\Country | No errors. |
Whater\Domain\Zones\Model\Town | No errors. |
Whater\Domain\Zones\Model\TownLocation | No errors. |
Whater\Domain\User\Model\OrganizationLicense | No errors. |
Whater\Domain\Product\Model\Product | No errors. |
Whater\Domain\Zones\Model\Agrupation | No errors. |
Whater\Domain\Whater\Model\DistributionNetwork | No errors. |
Whater\Domain\Whater\Model\WhaterOrganization | No errors. |
Whater\Domain\Whater\Model\WhaterPoint | No errors. |
Whater\Domain\Zones\Model\District | No errors. |
Whater\Domain\Zones\Model\Ubication | No errors. |
Whater\Domain\Zones\Model\Establishment | No errors. |
Whater\Domain\User\Model\OwnershipRequest | No errors. |