Query Metrics
11
Database Queries
11
Different statements
6.46 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.71 ms |
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"
]
|
2 | 0.41 ms |
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"
]
|
3 | 0.23 ms |
"START TRANSACTION"
Parameters:
[] |
4 | 0.24 ms |
"COMMIT"
Parameters:
[] |
5 | 1.22 ms |
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"
]
|
6 | 0.59 ms |
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"
]
|
7 | 0.86 ms |
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"
]
|
8 | 0.65 ms |
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"
]
|
9 | 0.57 ms |
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"
]
|
10 | 0.50 ms |
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"
]
|
11 | 0.49 ms |
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"
]
|
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.