Query Metrics

11 Database Queries
11 Different statements
6.46 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.22 ms
(18.95%)
1
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_ LEFT JOIN wt_zone_town w1_ ON w0_.town_uuid = w1_.uuid LEFT JOIN wt_whater_distr_network w2_ ON w0_.distribution_network_uuid = w2_.uuid LEFT JOIN wt_zone_country_area w3_ ON w1_.country_area_uuid = w3_.uuid LEFT JOIN wt_zone_country w4_ ON w1_.country_uuid = w4_.uuid LEFT JOIN wt_user w5_ ON w0_.created_by_uuid = w5_.uuid WHERE w5_.uuid = ? ORDER BY w0_.updated_at DESC LIMIT 10
Parameters:
[
  "cc4f74ca-70cf-4a58-8d47-84d39cd4d91f"
]
0.86 ms
(13.28%)
1
SELECT count(DISTINCT w0_.uuid) AS sclr_0 FROM wt_whater_point w0_ LEFT JOIN wt_zone_town w1_ ON w0_.town_uuid = w1_.uuid LEFT JOIN wt_whater_distr_network w2_ ON w0_.distribution_network_uuid = w2_.uuid LEFT JOIN wt_zone_country_area w3_ ON w1_.country_area_uuid = w3_.uuid LEFT JOIN wt_zone_country w4_ ON w1_.country_uuid = w4_.uuid LEFT JOIN wt_user w5_ ON w0_.created_by_uuid = w5_.uuid WHERE w5_.uuid = ?
Parameters:
[
  "cc4f74ca-70cf-4a58-8d47-84d39cd4d91f"
]
0.71 ms
(10.94%)
1
SELECT DISTINCT w0_.uuid AS uuid_0, w0_.email AS email_1, w0_.created_at AS created_at_2, w0_.updated_at AS updated_at_3, w0_.is_enabled AS is_enabled_4, w0_.first_name AS first_name_5, w0_.last_name AS last_name_6, w0_.phone AS phone_7, w0_.public_comments AS public_comments_8, w0_.private_comments AS private_comments_9, w0_.is_deleted AS is_deleted_10, w0_.reset_token_hash AS reset_token_hash_11, w0_.reset_token_expire_at AS reset_token_expire_at_12, w0_.current_balance AS current_balance_13, w0_.stripe_customer_id AS stripe_customer_id_14, w0_.referral_code_used AS referral_code_used_15, w0_.auth_username AS auth_username_16, w0_.auth_password_hash AS auth_password_hash_17, w1_.uuid AS uuid_18, w1_.type AS type_19, w1_.is_enabled AS is_enabled_20, w1_.created_at AS created_at_21, w1_.updated_at AS updated_at_22, w2_.uuid AS uuid_23, w2_.type AS type_24, w2_.is_enabled AS is_enabled_25, w2_.created_at AS created_at_26, w2_.updated_at AS updated_at_27, w0_.default_role_uuid AS default_role_uuid_28, w0_.active_role_uuid AS active_role_uuid_29, w0_.town_uuid AS town_uuid_30, w0_.whater_organization_uuid AS whater_organization_uuid_31, w0_.referral_whater_organization_uuid AS referral_whater_organization_uuid_32, w1_.user AS user_33, w2_.user AS user_34 FROM wt_user w0_ LEFT JOIN wt_user_role w1_ ON w0_.default_role_uuid = w1_.uuid LEFT JOIN wt_user_role w2_ ON w0_.active_role_uuid = w2_.uuid WHERE w0_.email = ? AND w0_.is_deleted = 0
Parameters:
[
  "clienteweb@whater.app"
]
0.65 ms
(10.06%)
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:
[
  "718b2da7-a6ed-409c-b8b6-7131ad11569a"
]
0.59 ms
(9.08%)
1
SELECT t0.uuid AS uuid_1, t0.product_label AS product_label_2, t0.product_slug AS product_slug_3, t0.product_type AS product_type_4, t0.product_short_description AS product_short_description_5, t0.product_description AS product_description_6, t0.product_price AS product_price_7, t0.product_vat_percent AS product_vat_percent_8, t0.whater_commision_percent AS whater_commision_percent_9, t0.is_enable AS is_enable_10, t0.is_shippable AS is_shippable_11, t0.product_weight AS product_weight_12, t0.product_length AS product_length_13, t0.product_width AS product_width_14, t0.product_height AS product_height_15, t0.accept_whatercoins AS accept_whatercoins_16, t0.is_internal_product AS is_internal_product_17, t0.average_valorations AS average_valorations_18, t0.tags AS tags_19, t0.recommend_to_water_status_suitable AS recommend_to_water_status_suitable_20, t0.recommend_to_water_status_not_suitable AS recommend_to_water_status_not_suitable_21, t0.recommend_to_water_status_with_restrictions AS recommend_to_water_status_with_restrictions_22, t0.recommend_to_water_status_unknown AS recommend_to_water_status_unknown_23, t0.the_things_network_device_name AS the_things_network_device_name_24, t0.whater_supply_miliseconds AS whater_supply_miliseconds_25, t0.max_discount_percentage_allowed AS max_discount_percentage_allowed_26, t0.requires_shipping_costs AS requires_shipping_costs_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.whater_point_uuid AS whater_point_uuid_30, t0.whater_organization_uuid AS whater_organization_uuid_31, t0.product_category_uuid AS product_category_uuid_32 FROM wt_product t0 WHERE t0.whater_point_uuid = ?
Parameters:
[
  "5643e25a-eb36-4a57-88f3-66807fe98a6f"
]
0.57 ms
(8.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.uuid = ?
Parameters:
[
  "726ca49d-3b53-49a2-8e31-46b7cba3979a"
]
0.50 ms
(7.68%)
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.49 ms
(7.61%)
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.41 ms
(6.34%)
1
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.uuid AS uuid_22, t0.position AS position_23, t0.avatar_user_uuid AS avatar_user_uuid_24 FROM wt_media t0 WHERE t0.avatar_user_uuid = ?
Parameters:
[
  "cc4f74ca-70cf-4a58-8d47-84d39cd4d91f"
]
0.24 ms
(3.67%)
1
"COMMIT"
Parameters:
[]
0.23 ms
(3.51%)
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\User\Model\Role No errors.
Whater\Domain\Zones\Model\Town No errors.
Whater\Domain\Whater\Model\WhaterOrganization No errors.
Sonata\MediaBundle\Entity\BaseMedia
  • The field 'Sonata\MediaBundle\Entity\BaseMedia#length' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
Whater\Domain\Media\Model\Media
  • The field 'Whater\Domain\Media\Model\Media#length' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
Whater\Domain\Whater\Model\WhaterValoration No errors.
Whater\Domain\Whater\Model\DistributionNetworkValoration No errors.
Whater\Domain\Product\Model\ProductValoration No errors.
Whater\Domain\Product\Model\WalletOperation No errors.
Whater\Domain\Whater\Model\WhaterPoint No errors.
Whater\Domain\Whater\Model\ImportDataFile No errors.
Whater\Domain\Notification\Model\Notification No errors.
Whater\Domain\Product\Model\CartOrder No errors.
Whater\Domain\User\Model\OwnershipRequest No errors.
Whater\Domain\Product\Model\WhatercoinCoupon No errors.
Whater\Domain\Whater\Model\DistributionNetwork No errors.
Whater\Domain\Zones\Model\CountryArea No errors.
Whater\Domain\Zones\Model\Country No errors.
Whater\Domain\Zones\Model\TownLocation 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\Whater\Model\WhaterDevice No errors.
Whater\Domain\Product\Model\Product No errors.
Whater\Domain\Product\Model\ProductCategory No errors.
Whater\Domain\Media\Model\ProductImage No errors.
Whater\Domain\Product\Model\ProductVariation No errors.
Whater\Domain\Product\Model\ProductAttribute No errors.
Whater\Domain\Whater\Model\Analytical No errors.
Whater\Domain\Media\Model\WhaterPointImage No errors.
Whater\Domain\User\Model\OrganizationLicense No errors.
Whater\Domain\Blog\Model\Article No errors.
Whater\Domain\Zones\Model\Agrupation No errors.