https://whater-dev.uegmobile.com/public/cart-order/cart-order-checkout/8a41abac-38ef-48cd-8183-3eb489884387

Query Metrics

14 Database Queries
13 Different statements
232.74 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
122.04 ms
(52.44%)
1
"COMMIT"
Parameters:
[]
96.28 ms
(41.37%)
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:
[
  "hostmaster@whater.es"
]
4.39 ms
(1.89%)
1
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"
]
3.48 ms
(1.50%)
1
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"
]
1.08 ms
(0.46%)
2
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"
]
1.02 ms
(0.44%)
1
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"
]
0.85 ms
(0.37%)
1
"START TRANSACTION"
Parameters:
[]
0.82 ms
(0.35%)
1
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"
]
0.72 ms
(0.31%)
1
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"
]
0.59 ms
(0.25%)
1
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"
]
0.55 ms
(0.24%)
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.48 ms
(0.20%)
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.44 ms
(0.19%)
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:
[
  "4d5518a7-53d7-471e-91ff-be6f7c548a49"
]

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\User\Model\OrganizationLicense No errors.
Whater\Domain\Product\Model\CartOrderItem No errors.
Whater\Domain\Product\Model\Product No errors.
Whater\Domain\Product\Model\ProductVariation No errors.
Whater\Domain\Product\Model\ProductCategory No errors.
Whater\Domain\Media\Model\ProductImage No errors.
Whater\Domain\Zones\Model\Country No errors.
Whater\Domain\Zones\Model\CountryArea No errors.
Whater\Domain\Product\Model\ProductAttribute No errors.
Whater\Domain\Whater\Model\DistributionNetwork No errors.
Whater\Domain\Whater\Model\Analytical No errors.
Whater\Domain\Product\Model\WalletLiquidationRequest No errors.
Whater\Domain\Zones\Model\Ubication No errors.
Whater\Domain\Zones\Model\TownLocation No errors.
Whater\Domain\Whater\Model\WhaterOrganizationCode No errors.
Whater\Domain\Zones\Model\District No errors.
Whater\Domain\Zones\Model\Establishment No errors.
Whater\Domain\Zones\Model\Agrupation No errors.