Query Metrics
13
Database Queries
11
Different statements
5.91 ms
Query time
2
Invalid entities
Queries
#▲ | 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.