Symfony Profiler

"START TRANSACTION"

"START TRANSACTION";

SELECT
  w0_.uuid AS uuid_0,
  w0_.name AS name_1,
  w0_.slug AS slug_2,
  w0_.external_ids AS external_ids_3,
  w0_.geo_name_id AS geo_name_id_4,
  w0_.population AS population_5,
  w0_.longitude AS longitude_6,
  w0_.latitude AS latitude_7,
  ST_AsBinary(w0_.geometry_polygon) AS geometry_polygon_8,
  w0_.created_at AS created_at_9,
  w0_.updated_at AS updated_at_10,
  w0_.sinac_synchonization_at AS sinac_synchonization_at_11,
  w0_.country_area_uuid AS country_area_uuid_12,
  w0_.country_uuid AS country_uuid_13,
  w0_.whater_organization_uuid AS whater_organization_uuid_14
FROM
  wt_zone_town w0_
WHERE
  w0_.slug = ?

SELECT w0_.uuid AS uuid_0, w0_.name AS name_1, w0_.slug AS slug_2, w0_.external_ids AS external_ids_3, w0_.geo_name_id AS geo_name_id_4, w0_.population AS population_5, w0_.longitude AS longitude_6, w0_.latitude AS latitude_7, ST_AsBinary(w0_.geometry_polygon) AS geometry_polygon_8, w0_.created_at AS created_at_9, w0_.updated_at AS updated_at_10, w0_.sinac_synchonization_at AS sinac_synchonization_at_11, w0_.country_area_uuid AS country_area_uuid_12, w0_.country_uuid AS country_uuid_13, w0_.whater_organization_uuid AS whater_organization_uuid_14 FROM wt_zone_town w0_ WHERE w0_.slug = 'alberite-de-san-juan';

"COMMIT"

"COMMIT";

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 = ?

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 = '216abc6f-594d-49ea-8977-8976ca33e92c';

SELECT
  t0.uuid AS uuid_1,
  t0.slug AS slug_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.name AS name_5,
  t0.external_ids AS external_ids_6,
  t0.geo_name_id AS geo_name_id_7,
  t0.population AS population_8,
  t0.admin_code AS admin_code_9,
  t0.country_uuid AS country_uuid_10
FROM
  wt_zone_country_area t0
WHERE
  t0.uuid = ?

SELECT t0.uuid AS uuid_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.external_ids AS external_ids_6, t0.geo_name_id AS geo_name_id_7, t0.population AS population_8, t0.admin_code AS admin_code_9, t0.country_uuid AS country_uuid_10 FROM wt_zone_country_area t0 WHERE t0.uuid = '097f870f-5a9e-4f61-a7a9-45b92f831200';

SELECT
  t0.uuid AS uuid_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.external_ids AS external_ids_4,
  t0.town_location_type AS town_location_type_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.town_uuid AS town_uuid_15,
  t0.distribution_network_uuid AS distribution_network_uuid_16,
  t0.whater_organization_uuid AS whater_organization_uuid_17
FROM
  wt_zone_town_location t0
WHERE
  t0.town_uuid = ?

SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.slug AS slug_3, t0.external_ids AS external_ids_4, t0.town_location_type AS town_location_type_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.town_uuid AS town_uuid_15, t0.distribution_network_uuid AS distribution_network_uuid_16, t0.whater_organization_uuid AS whater_organization_uuid_17 FROM wt_zone_town_location t0 WHERE t0.town_uuid = 'd32ff10e-2b12-43fc-a16f-74dbc0d5827b';

SELECT
  t0.uuid AS uuid_1,
  t0.name AS name_2,
  t0.postal_code AS postal_code_3,
  t0.slug AS slug_4,
  t0.email AS email_5,
  t0.longitude AS longitude_6,
  t0.latitude AS latitude_7,
  t0.population AS population_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.town_uuid AS town_uuid_11,
  t0.town_location_uuid AS town_location_uuid_12,
  t0.distribution_network_uuid AS distribution_network_uuid_13,
  t0.whater_organization_uuid AS whater_organization_uuid_14
FROM
  wt_zone_ubication t0
WHERE
  t0.town_uuid = ?

SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.postal_code AS postal_code_3, t0.slug AS slug_4, t0.email AS email_5, t0.longitude AS longitude_6, t0.latitude AS latitude_7, t0.population AS population_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.town_uuid AS town_uuid_11, t0.town_location_uuid AS town_location_uuid_12, t0.distribution_network_uuid AS distribution_network_uuid_13, t0.whater_organization_uuid AS whater_organization_uuid_14 FROM wt_zone_ubication t0 WHERE t0.town_uuid = 'd32ff10e-2b12-43fc-a16f-74dbc0d5827b';

SELECT
  t0.uuid AS uuid_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.longitude AS longitude_4,
  t0.latitude AS latitude_5,
  t0.tipology AS tipology_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.town_uuid AS town_uuid_9,
  t0.town_location_uuid AS town_location_uuid_10,
  t0.ubication_uuid AS ubication_uuid_11,
  t0.distribution_network_uuid AS distribution_network_uuid_12
FROM
  wt_zone_establishment t0
WHERE
  t0.town_uuid = ?

SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.slug AS slug_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.tipology AS tipology_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.town_uuid AS town_uuid_9, t0.town_location_uuid AS town_location_uuid_10, t0.ubication_uuid AS ubication_uuid_11, t0.distribution_network_uuid AS distribution_network_uuid_12 FROM wt_zone_establishment t0 WHERE t0.town_uuid = 'd32ff10e-2b12-43fc-a16f-74dbc0d5827b';

SELECT
  t0.uuid AS uuid_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.certification AS certification_4,
  t0.longitude AS longitude_5,
  t0.latitude AS latitude_6,
  t0.slug AS slug_7,
  ST_AsBinary(t0.geo_point) AS geo_point_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.whater_status AS whater_status_11,
  t0.whater_status_at AS whater_status_at_12,
  t0.last_professional_valoration_at AS last_professional_valoration_at_13,
  t0.last_user_valoration_at AS last_user_valoration_at_14,
  t0.total_color AS total_color_15,
  t0.total_taste AS total_taste_16,
  t0.total_smell AS total_smell_17,
  t0.total_turbidity AS total_turbidity_18,
  t0.total_general AS total_general_19,
  t0.average_professional_general AS average_professional_general_20,
  t0.average_user_general AS average_user_general_21,
  t0.count_user_general AS count_user_general_22,
  t0.count_professional_general AS count_professional_general_23,
  t0.sinac_id AS sinac_id_24,
  t0.sinac_slug AS sinac_slug_25,
  t0.dispersed AS dispersed_26,
  t0.confirmed_geoposition AS confirmed_geoposition_27,
  t0.osm_id AS osm_id_28,
  t0.osm_data AS osm_data_29,
  t0.import_notes AS import_notes_30,
  t0.validated_by_admin AS validated_by_admin_31,
  t0.notify_whater_status_change AS notify_whater_status_change_32,
  t33.uuid AS uuid_34,
  t33.product_label AS product_label_35,
  t33.product_slug AS product_slug_36,
  t33.product_type AS product_type_37,
  t33.product_short_description AS product_short_description_38,
  t33.product_description AS product_description_39,
  t33.product_price AS product_price_40,
  t33.product_vat_percent AS product_vat_percent_41,
  t33.whater_commision_percent AS whater_commision_percent_42,
  t33.is_enable AS is_enable_43,
  t33.is_shippable AS is_shippable_44,
  t33.product_weight AS product_weight_45,
  t33.product_length AS product_length_46,
  t33.product_width AS product_width_47,
  t33.product_height AS product_height_48,
  t33.accept_whatercoins AS accept_whatercoins_49,
  t33.is_internal_product AS is_internal_product_50,
  t33.average_valorations AS average_valorations_51,
  t33.tags AS tags_52,
  t33.recommend_to_water_status_suitable AS recommend_to_water_status_suitable_53,
  t33.recommend_to_water_status_not_suitable AS recommend_to_water_status_not_suitable_54,
  t33.recommend_to_water_status_with_restrictions AS recommend_to_water_status_with_restrictions_55,
  t33.recommend_to_water_status_unknown AS recommend_to_water_status_unknown_56,
  t33.the_things_network_device_name AS the_things_network_device_name_57,
  t33.whater_supply_miliseconds AS whater_supply_miliseconds_58,
  t33.max_discount_percentage_allowed AS max_discount_percentage_allowed_59,
  t33.requires_shipping_costs AS requires_shipping_costs_60,
  t33.created_at AS created_at_61,
  t33.updated_at AS updated_at_62,
  t33.whater_point_uuid AS whater_point_uuid_63,
  t33.whater_organization_uuid AS whater_organization_uuid_64,
  t33.product_category_uuid AS product_category_uuid_65,
  t0.distribution_network_uuid AS distribution_network_uuid_66,
  t0.town_uuid AS town_uuid_67,
  t0.town_location_uuid AS town_location_uuid_68,
  t0.district_uuid AS district_uuid_69,
  t0.ubication_uuid AS ubication_uuid_70,
  t0.establishment_uuid AS establishment_uuid_71,
  t0.created_by_uuid AS created_by_uuid_72,
  t0.whater_device_uuid AS whater_device_uuid_73,
  t0.resp_organ_corporative_uuid AS resp_organ_corporative_uuid_74,
  t0.resp_organ_ubication_uuid AS resp_organ_ubication_uuid_75
FROM
  wt_whater_point t0
  LEFT JOIN wt_product t33 ON t33.whater_point_uuid = t0.uuid
WHERE
  t0.town_uuid = ?

SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.type AS type_3, t0.certification AS certification_4, t0.longitude AS longitude_5, t0.latitude AS latitude_6, t0.slug AS slug_7, ST_AsBinary(t0.geo_point) AS geo_point_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.whater_status AS whater_status_11, t0.whater_status_at AS whater_status_at_12, t0.last_professional_valoration_at AS last_professional_valoration_at_13, t0.last_user_valoration_at AS last_user_valoration_at_14, t0.total_color AS total_color_15, t0.total_taste AS total_taste_16, t0.total_smell AS total_smell_17, t0.total_turbidity AS total_turbidity_18, t0.total_general AS total_general_19, t0.average_professional_general AS average_professional_general_20, t0.average_user_general AS average_user_general_21, t0.count_user_general AS count_user_general_22, t0.count_professional_general AS count_professional_general_23, t0.sinac_id AS sinac_id_24, t0.sinac_slug AS sinac_slug_25, t0.dispersed AS dispersed_26, t0.confirmed_geoposition AS confirmed_geoposition_27, t0.osm_id AS osm_id_28, t0.osm_data AS osm_data_29, t0.import_notes AS import_notes_30, t0.validated_by_admin AS validated_by_admin_31, t0.notify_whater_status_change AS notify_whater_status_change_32, t33.uuid AS uuid_34, t33.product_label AS product_label_35, t33.product_slug AS product_slug_36, t33.product_type AS product_type_37, t33.product_short_description AS product_short_description_38, t33.product_description AS product_description_39, t33.product_price AS product_price_40, t33.product_vat_percent AS product_vat_percent_41, t33.whater_commision_percent AS whater_commision_percent_42, t33.is_enable AS is_enable_43, t33.is_shippable AS is_shippable_44, t33.product_weight AS product_weight_45, t33.product_length AS product_length_46, t33.product_width AS product_width_47, t33.product_height AS product_height_48, t33.accept_whatercoins AS accept_whatercoins_49, t33.is_internal_product AS is_internal_product_50, t33.average_valorations AS average_valorations_51, t33.tags AS tags_52, t33.recommend_to_water_status_suitable AS recommend_to_water_status_suitable_53, t33.recommend_to_water_status_not_suitable AS recommend_to_water_status_not_suitable_54, t33.recommend_to_water_status_with_restrictions AS recommend_to_water_status_with_restrictions_55, t33.recommend_to_water_status_unknown AS recommend_to_water_status_unknown_56, t33.the_things_network_device_name AS the_things_network_device_name_57, t33.whater_supply_miliseconds AS whater_supply_miliseconds_58, t33.max_discount_percentage_allowed AS max_discount_percentage_allowed_59, t33.requires_shipping_costs AS requires_shipping_costs_60, t33.created_at AS created_at_61, t33.updated_at AS updated_at_62, t33.whater_point_uuid AS whater_point_uuid_63, t33.whater_organization_uuid AS whater_organization_uuid_64, t33.product_category_uuid AS product_category_uuid_65, t0.distribution_network_uuid AS distribution_network_uuid_66, t0.town_uuid AS town_uuid_67, t0.town_location_uuid AS town_location_uuid_68, t0.district_uuid AS district_uuid_69, t0.ubication_uuid AS ubication_uuid_70, t0.establishment_uuid AS establishment_uuid_71, t0.created_by_uuid AS created_by_uuid_72, t0.whater_device_uuid AS whater_device_uuid_73, t0.resp_organ_corporative_uuid AS resp_organ_corporative_uuid_74, t0.resp_organ_ubication_uuid AS resp_organ_ubication_uuid_75 FROM wt_whater_point t0 LEFT JOIN wt_product t33 ON t33.whater_point_uuid = t0.uuid WHERE t0.town_uuid = 'd32ff10e-2b12-43fc-a16f-74dbc0d5827b';

SELECT
  t0.uuid AS uuid_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.slug AS slug_4,
  t0.sinac_id AS sinac_id_5,
  t0.whater_status AS whater_status_6,
  t0.whater_status_by_government AS whater_status_by_government_7,
  t0.whater_status_by_government_updated_at AS whater_status_by_government_updated_at_8,
  t0.whater_status_by_operator AS whater_status_by_operator_9,
  t0.whater_status_by_operator_updated_at AS whater_status_by_operator_updated_at_10,
  t0.whater_status_by_ubication AS whater_status_by_ubication_11,
  t0.whater_status_by_ubication_updated_at AS whater_status_by_ubication_updated_at_12,
  t0.details AS details_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.last_analitycs_update_at AS last_analitycs_update_at_16,
  t0.center_longitude AS center_longitude_17,
  t0.center_latitude AS center_latitude_18,
  ST_AsBinary(t0.geometry_polygon) AS geometry_polygon_19,
  t0.geometry_area_in_ha AS geometry_area_in_ha_20,
  t0.sinac_connection_errors AS sinac_connection_errors_21,
  t0.last_sinac_connection_at AS last_sinac_connection_at_22,
  t0.notify_whater_status_change AS notify_whater_status_change_23,
  t0.last_professional_valoration_at AS last_professional_valoration_at_24,
  t0.last_user_valoration_at AS last_user_valoration_at_25,
  t0.total_color AS total_color_26,
  t0.total_taste AS total_taste_27,
  t0.total_smell AS total_smell_28,
  t0.total_turbidity AS total_turbidity_29,
  t0.total_general AS total_general_30,
  t0.average_professional_general AS average_professional_general_31,
  t0.average_user_general AS average_user_general_32,
  t0.count_user_general AS count_user_general_33,
  t0.count_professional_general AS count_professional_general_34,
  t0.country_uuid AS country_uuid_35,
  t0.parent_uuid AS parent_uuid_36,
  t0.resp_organ_government_uuid AS resp_organ_government_uuid_37,
  t0.resp_organ_operator_uuid AS resp_organ_operator_uuid_38,
  t0.resp_organ_corporative_uuid AS resp_organ_corporative_uuid_39,
  t0.resp_organ_ubication_uuid AS resp_organ_ubication_uuid_40
FROM
  wt_whater_distr_network t0
  INNER JOIN wt_whater_distr_netw_x_towns ON t0.uuid = wt_whater_distr_netw_x_towns.distr_network_uuid
WHERE
  wt_whater_distr_netw_x_towns.town_uuid = ?
ORDER BY
  t0.type ASC

SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.type AS type_3, t0.slug AS slug_4, t0.sinac_id AS sinac_id_5, t0.whater_status AS whater_status_6, t0.whater_status_by_government AS whater_status_by_government_7, t0.whater_status_by_government_updated_at AS whater_status_by_government_updated_at_8, t0.whater_status_by_operator AS whater_status_by_operator_9, t0.whater_status_by_operator_updated_at AS whater_status_by_operator_updated_at_10, t0.whater_status_by_ubication AS whater_status_by_ubication_11, t0.whater_status_by_ubication_updated_at AS whater_status_by_ubication_updated_at_12, t0.details AS details_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.last_analitycs_update_at AS last_analitycs_update_at_16, t0.center_longitude AS center_longitude_17, t0.center_latitude AS center_latitude_18, ST_AsBinary(t0.geometry_polygon) AS geometry_polygon_19, t0.geometry_area_in_ha AS geometry_area_in_ha_20, t0.sinac_connection_errors AS sinac_connection_errors_21, t0.last_sinac_connection_at AS last_sinac_connection_at_22, t0.notify_whater_status_change AS notify_whater_status_change_23, t0.last_professional_valoration_at AS last_professional_valoration_at_24, t0.last_user_valoration_at AS last_user_valoration_at_25, t0.total_color AS total_color_26, t0.total_taste AS total_taste_27, t0.total_smell AS total_smell_28, t0.total_turbidity AS total_turbidity_29, t0.total_general AS total_general_30, t0.average_professional_general AS average_professional_general_31, t0.average_user_general AS average_user_general_32, t0.count_user_general AS count_user_general_33, t0.count_professional_general AS count_professional_general_34, t0.country_uuid AS country_uuid_35, t0.parent_uuid AS parent_uuid_36, t0.resp_organ_government_uuid AS resp_organ_government_uuid_37, t0.resp_organ_operator_uuid AS resp_organ_operator_uuid_38, t0.resp_organ_corporative_uuid AS resp_organ_corporative_uuid_39, t0.resp_organ_ubication_uuid AS resp_organ_ubication_uuid_40 FROM wt_whater_distr_network t0 INNER JOIN wt_whater_distr_netw_x_towns ON t0.uuid = wt_whater_distr_netw_x_towns.distr_network_uuid WHERE wt_whater_distr_netw_x_towns.town_uuid = 'd32ff10e-2b12-43fc-a16f-74dbc0d5827b' ORDER BY t0.type ASC;