Symfony Profiler

"START TRANSACTION"

"START TRANSACTION";

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_
WHERE
  w0_.uuid = ?

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_ WHERE w0_.uuid = '5643e25a-eb36-4a57-88f3-66807fe98a6f';

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.free_shippable_code AS free_shippable_code_12,
  t0.product_weight AS product_weight_13,
  t0.product_length AS product_length_14,
  t0.product_width AS product_width_15,
  t0.product_height AS product_height_16,
  t0.accept_whatercoins AS accept_whatercoins_17,
  t0.is_internal_product AS is_internal_product_18,
  t0.average_valorations AS average_valorations_19,
  t0.tags AS tags_20,
  t0.recommend_to_water_status_suitable AS recommend_to_water_status_suitable_21,
  t0.recommend_to_water_status_not_suitable AS recommend_to_water_status_not_suitable_22,
  t0.recommend_to_water_status_with_restrictions AS recommend_to_water_status_with_restrictions_23,
  t0.recommend_to_water_status_unknown AS recommend_to_water_status_unknown_24,
  t0.the_things_network_device_name AS the_things_network_device_name_25,
  t0.whater_supply_miliseconds AS whater_supply_miliseconds_26,
  t0.nfc_reader_online_serial_number AS nfc_reader_online_serial_number_27,
  t0.last_req_register_nfc_at AS last_req_register_nfc_at_28,
  t0.closca_fountain_id AS closca_fountain_id_29,
  t0.max_discount_percentage_allowed AS max_discount_percentage_allowed_30,
  t0.requires_shipping_costs AS requires_shipping_costs_31,
  t0.created_at AS created_at_32,
  t0.updated_at AS updated_at_33,
  t0.whater_point_uuid AS whater_point_uuid_34,
  t0.whater_organization_uuid AS whater_organization_uuid_35,
  t0.product_category_uuid AS product_category_uuid_36,
  t0.last_request_to_register_an_user_nfc_user_id AS last_request_to_register_an_user_nfc_user_id_37
FROM
  wt_product t0
WHERE
  t0.whater_point_uuid = ?

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.free_shippable_code AS free_shippable_code_12, t0.product_weight AS product_weight_13, t0.product_length AS product_length_14, t0.product_width AS product_width_15, t0.product_height AS product_height_16, t0.accept_whatercoins AS accept_whatercoins_17, t0.is_internal_product AS is_internal_product_18, t0.average_valorations AS average_valorations_19, t0.tags AS tags_20, t0.recommend_to_water_status_suitable AS recommend_to_water_status_suitable_21, t0.recommend_to_water_status_not_suitable AS recommend_to_water_status_not_suitable_22, t0.recommend_to_water_status_with_restrictions AS recommend_to_water_status_with_restrictions_23, t0.recommend_to_water_status_unknown AS recommend_to_water_status_unknown_24, t0.the_things_network_device_name AS the_things_network_device_name_25, t0.whater_supply_miliseconds AS whater_supply_miliseconds_26, t0.nfc_reader_online_serial_number AS nfc_reader_online_serial_number_27, t0.last_req_register_nfc_at AS last_req_register_nfc_at_28, t0.closca_fountain_id AS closca_fountain_id_29, t0.max_discount_percentage_allowed AS max_discount_percentage_allowed_30, t0.requires_shipping_costs AS requires_shipping_costs_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.whater_point_uuid AS whater_point_uuid_34, t0.whater_organization_uuid AS whater_organization_uuid_35, t0.product_category_uuid AS product_category_uuid_36, t0.last_request_to_register_an_user_nfc_user_id AS last_request_to_register_an_user_nfc_user_id_37 FROM wt_product t0 WHERE t0.whater_point_uuid = '5643e25a-eb36-4a57-88f3-66807fe98a6f';

SELECT
  w0_.uuid AS uuid_0,
  w0_.nfc_id AS nfc_id_1,
  w0_.nfc_label AS nfc_label_2,
  w0_.nfc_class AS nfc_class_3,
  w0_.created_at AS created_at_4,
  w0_.whater_organization_uuid AS whater_organization_uuid_5,
  w0_.user_uuid AS user_uuid_6
FROM
  wt_user_nfc w0_
WHERE
  w0_.nfc_id = ?

SELECT w0_.uuid AS uuid_0, w0_.nfc_id AS nfc_id_1, w0_.nfc_label AS nfc_label_2, w0_.nfc_class AS nfc_class_3, w0_.created_at AS created_at_4, w0_.whater_organization_uuid AS whater_organization_uuid_5, w0_.user_uuid AS user_uuid_6 FROM wt_user_nfc w0_ WHERE w0_.nfc_id = '04:53:E6:42:6E:1E:90';

INSERT INTO wt_whater_refill (
  uuid, created_at, updated_at, milliliters,
  confirmed, whater_point_uuid, user_uuid,
  cart_order_uuid, user_nfc_uuid
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO wt_whater_refill (uuid, created_at, updated_at, milliliters, confirmed, whater_point_uuid, user_uuid, cart_order_uuid, user_nfc_uuid) VALUES ('4b6087bd-0086-437e-88a4-51a8449b6d6b', '2025-11-10 12:52:27', '2025-11-10 12:52:27', 100, 0, '5643e25a-eb36-4a57-88f3-66807fe98a6f', 'aec6239b-f777-4206-9769-fc49d5a1c9d8', NULL, '86e6be2c-ec27-4365-9b55-d574f1da7ed8');

"COMMIT"

"COMMIT";