https://whater-dev.uegmobile.com/public/product/product/show/eclorite-desinfectante

Query Metrics

13 Database Queries
11 Different statements
5.91 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.73 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.43 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.23 ms
"START TRANSACTION"
Parameters:
[]
4 0.57 ms
SELECT w0_.uuid AS uuid_0, w0_.product_label AS product_label_1, w0_.product_slug AS product_slug_2, w0_.product_type AS product_type_3, w0_.product_short_description AS product_short_description_4, w0_.product_description AS product_description_5, w0_.product_price AS product_price_6, w0_.product_vat_percent AS product_vat_percent_7, w0_.whater_commision_percent AS whater_commision_percent_8, w0_.is_enable AS is_enable_9, w0_.is_shippable AS is_shippable_10, w0_.product_weight AS product_weight_11, w0_.product_length AS product_length_12, w0_.product_width AS product_width_13, w0_.product_height AS product_height_14, w0_.accept_whatercoins AS accept_whatercoins_15, w0_.is_internal_product AS is_internal_product_16, w0_.average_valorations AS average_valorations_17, w0_.tags AS tags_18, w0_.recommend_to_water_status_suitable AS recommend_to_water_status_suitable_19, w0_.recommend_to_water_status_not_suitable AS recommend_to_water_status_not_suitable_20, w0_.recommend_to_water_status_with_restrictions AS recommend_to_water_status_with_restrictions_21, w0_.recommend_to_water_status_unknown AS recommend_to_water_status_unknown_22, w0_.the_things_network_device_name AS the_things_network_device_name_23, w0_.whater_supply_miliseconds AS whater_supply_miliseconds_24, w0_.max_discount_percentage_allowed AS max_discount_percentage_allowed_25, w0_.requires_shipping_costs AS requires_shipping_costs_26, w0_.created_at AS created_at_27, w0_.updated_at AS updated_at_28, w0_.whater_point_uuid AS whater_point_uuid_29, w0_.whater_organization_uuid AS whater_organization_uuid_30, w0_.product_category_uuid AS product_category_uuid_31 FROM wt_product w0_ WHERE w0_.product_slug = ?
Parameters:
[
  "eclorite-desinfectante"
]
5 0.29 ms
"COMMIT"
Parameters:
[]
6 0.16 ms
"START TRANSACTION"
Parameters:
[]
7 0.17 ms
"COMMIT"
Parameters:
[]
8 0.53 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"
]
9 0.67 ms
SELECT t0.uuid AS uuid_1, t0.product_variation_short_description AS product_variation_short_description_2, t0.product_variation_description AS product_variation_description_3, t0.product_variation_price AS product_variation_price_4, t0.product_variation_attributes AS product_variation_attributes_5, t0.checksum AS checksum_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.product_uuid AS product_uuid_9 FROM wt_product_variation t0 WHERE t0.product_uuid = ? ORDER BY t0.created_at DESC
Parameters:
[
  "6c8b0dc4-bcb9-46d7-ba27-3b30ba2f0d89"
]
10 0.87 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"
]
11 0.41 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"
]
12 0.42 ms
SELECT t0.uuid AS uuid_1, t0.file_name AS file_name_2, t0.file_size AS file_size_3, t0.file_mime_type AS file_mime_type_4, t0.file_originalname AS file_originalname_5, t0.file_dimensions AS file_dimensions_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.product_uuid AS product_uuid_9, t0.created_by_uuid AS created_by_uuid_10 FROM wt_product_image t0 WHERE t0.product_uuid = ? ORDER BY t0.created_at DESC
Parameters:
[
  "6c8b0dc4-bcb9-46d7-ba27-3b30ba2f0d89"
]
13 0.44 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"
]

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\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\Zones\Model\Country No errors.
Whater\Domain\Zones\Model\CountryArea No errors.
Whater\Domain\Product\Model\ProductAttribute No errors.
Whater\Domain\User\Model\OrganizationLicense 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.