Query Metrics
14
Database Queries
13
Different statements
232.74 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 96.28 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:
[
"hostmaster@whater.es"
]
|
2 | 0.44 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:
[
"4d5518a7-53d7-471e-91ff-be6f7c548a49"
]
|
3 | 0.85 ms |
"START TRANSACTION"
Parameters:
[] |
4 | 4.39 ms |
SELECT w0_.uuid AS uuid_0, w0_.status AS status_1, w0_.invoice_number AS invoice_number_2, w0_.cart_order_type AS cart_order_type_3, w0_.notes AS notes_4, w0_.total_euros AS total_euros_5, w0_.total_whatercoins AS total_whatercoins_6, w0_.total_shipping_cost AS total_shipping_cost_7, w0_.shipping_country AS shipping_country_8, w0_.shipping_address AS shipping_address_9, w0_.shipping_postal_code AS shipping_postal_code_10, w0_.cart_order_number AS cart_order_number_11, w0_.whater_refill_status AS whater_refill_status_12, w0_.number_of_refill_purchased AS number_of_refill_purchased_13, w0_.number_of_refill_pending_use AS number_of_refill_pending_use_14, w0_.dates_of_whater_refill_uses AS dates_of_whater_refill_uses_15, w0_.stripe_payment_intent AS stripe_payment_intent_16, w0_.stripe_subscription AS stripe_subscription_17, w0_.invoice_date AS invoice_date_18, w0_.purchase_date AS purchase_date_19, w0_.created_at AS created_at_20, w0_.updated_at AS updated_at_21, w0_.organization_license_uuid AS organization_license_uuid_22, w0_.user_uuid AS user_uuid_23 FROM wt_product_cart_order w0_ WHERE w0_.uuid = ?
Parameters:
[
"8a41abac-38ef-48cd-8183-3eb489884387"
]
|
5 | 1.02 ms |
SELECT t0.uuid AS uuid_1, t0.price_per_unit AS price_per_unit_2, t0.taxes_percent AS taxes_percent_3, t0.units AS units_4, t0.line_order AS line_order_5, t0.item_description AS item_description_6, t0.meta AS meta_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t10.uuid AS uuid_11, t10.rating AS rating_12, t10.created_at AS created_at_13, t10.cart_order_item_uuid AS cart_order_item_uuid_14, t10.product_uuid AS product_uuid_15, t10.created_by_uuid AS created_by_uuid_16, t0.cart_order_uuid AS cart_order_uuid_17, t0.product_uuid AS product_uuid_18, t0.product_variation_uuid AS product_variation_uuid_19 FROM wt_product_cart_order_item t0 LEFT JOIN wt_product_valoration t10 ON t10.cart_order_item_uuid = t0.uuid WHERE t0.cart_order_uuid = ? ORDER BY t0.line_order ASC, t0.created_at ASC
Parameters:
[
"8a41abac-38ef-48cd-8183-3eb489884387"
]
|
6 | 0.54 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.uuid = ?
Parameters:
[
"830a0e42-edbe-403d-b2be-ab2929443ff6"
]
|
7 | 0.59 ms |
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.slug AS slug_3, t0.url_web AS url_web_4, t0.details AS details_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.public_name AS public_name_8, t0.contact_person AS contact_person_9, t0.contact_email AS contact_email_10, t0.contact_phone AS contact_phone_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.fiscal_name AS fiscal_name_15, t0.fiscal_address AS fiscal_address_16, t0.marketplace_address AS marketplace_address_17, t0.marketplace_postal_code AS marketplace_postal_code_18, t0.marketplace_country AS marketplace_country_19, t0.professional_activity AS professional_activity_20, t0.specialization_in_water AS specialization_in_water_21, t0.region_scope AS region_scope_22, t0.number_of_delegations AS number_of_delegations_23, t0.number_of_customers AS number_of_customers_24, t0.is_public_organization AS is_public_organization_25, t0.is_manufracturer AS is_manufracturer_26, t0.opening_hours AS opening_hours_27, t0.current_balance AS current_balance_28, t0.bank_account_owner_name AS bank_account_owner_name_29, t0.bank_account_iban_number AS bank_account_iban_number_30, t0.bank_account_bic_swift_number AS bank_account_bic_swift_number_31, t0.stripe_express_account_id AS stripe_express_account_id_32, t0.stripe_express_account_status AS stripe_express_account_status_33, t0.referral_code AS referral_code_34, t0.country_uuid AS country_uuid_35 FROM wt_whater_organization t0 WHERE t0.uuid = ?
Parameters:
[
"1d4d6c88-1a63-421a-ab74-eb38b2b4e767"
]
|
8 | 0.82 ms |
UPDATE wt_product_cart_order SET stripe_payment_intent = ? WHERE uuid = ?
Parameters:
[ "{"id":"pi_3QpSh3DcohDs0j2O1JSxmGl3","object":"payment_intent","amount":7994,"amount_capturable":0,"amount_details":{"tip":[]},"amount_received":0,"application":null,"application_fee_amount":799,"automatic_payment_methods":{"enabled":false},"canceled_at":null,"cancellation_reason":null,"capture_method":"automatic","client_secret":"pi_3QpSh3DcohDs0j2O1JSxmGl3_secret_Nogey3kC4SQWUBI0gicGEu7Ni","confirmation_method":"automatic","created":1738839145,"currency":"eur","customer":null,"description":"whater.app - 8a41abac-38ef-48cd-8183-3eb489884387","invoice":null,"last_payment_error":null,"latest_charge":null,"livemode":false,"metadata":{"cart_order_id":"8a41abac-38ef-48cd-8183-3eb489884387","cart_url":"https:\/\/whater-dev.uegmobile.com\/public\/cart-order\/cart-order-checkout\/8a41abac-38ef-48cd-8183-3eb489884387"},"next_action":null,"on_behalf_of":"acct_1Ohbn5RYP3h4d3j9","payment_method":null,"payment_method_configuration_details":null,"payment_method_options":{"card":{"installments":null,"mandate_options":null,"network":null,"request_three_d_secure":"automatic"}},"payment_method_types":["card"],"processing":null,"receipt_email":null,"review":null,"setup_future_usage":null,"shipping":null,"source":null,"statement_descriptor":null,"statement_descriptor_suffix":null,"status":"requires_payment_method","transfer_data":{"destination":"acct_1Ohbn5RYP3h4d3j9"},"transfer_group":null}" "8a41abac-38ef-48cd-8183-3eb489884387" ] |
9 | 122.04 ms |
"COMMIT"
Parameters:
[] |
10 | 0.55 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"
]
|
11 | 0.48 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"
]
|
12 | 3.48 ms |
SELECT t0.uuid AS uuid_1, t0.message AS message_2, t0.title AS title_3, t0.link AS link_4, t0.checksum AS checksum_5, t0.created_at AS created_at_6, t0.read_at AS read_at_7, t0.user_uuid AS user_uuid_8 FROM wt_notification t0 WHERE t0.user_uuid = ? ORDER BY t0.created_at ASC
Parameters:
[
"4d5518a7-53d7-471e-91ff-be6f7c548a49"
]
|
13 | 0.72 ms |
SELECT t0.uuid AS uuid_1, t0.type AS type_2, t0.is_enabled AS is_enabled_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.user AS user_6 FROM wt_user_role t0 WHERE t0.user = ?
Parameters:
[
"4d5518a7-53d7-471e-91ff-be6f7c548a49"
]
|
14 | 0.53 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.uuid = ?
Parameters:
[
"960d5f53-182f-4fc2-a651-1b9d01993323"
]
|
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.