Symfony Profiler

"COMMIT"

"COMMIT";

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

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 WHERE t0.uuid = 'f0179988-dbf7-4e6b-84af-1677a8c5d2e6';

SELECT
  t0.uuid AS uuid_1,
  t0.parameter_value AS parameter_value_2,
  t0.analyzed_at AS analyzed_at_3,
  t0.laboratory_name AS laboratory_name_4,
  t0.created_at AS created_at_5,
  t0.sample_point_name AS sample_point_name_6,
  t0.sample_hash AS sample_hash_7,
  t0.analytical_uuid AS analytical_uuid_8,
  t0.analytical_parameter_uuid AS analytical_parameter_uuid_9
FROM
  wt_whater_analytical_samples t0
WHERE
  t0.analytical_uuid = ?

SELECT t0.uuid AS uuid_1, t0.parameter_value AS parameter_value_2, t0.analyzed_at AS analyzed_at_3, t0.laboratory_name AS laboratory_name_4, t0.created_at AS created_at_5, t0.sample_point_name AS sample_point_name_6, t0.sample_hash AS sample_hash_7, t0.analytical_uuid AS analytical_uuid_8, t0.analytical_parameter_uuid AS analytical_parameter_uuid_9 FROM wt_whater_analytical_samples t0 WHERE t0.analytical_uuid = 'd8e1991d-c1c4-4eae-a6fe-b9a4795f437f';

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

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 = '2c1abae3-8d0a-4243-a960-1dddfc174e56';

SELECT
  w0_.uuid AS uuid_0,
  w0_.source AS source_1,
  w0_.created_from AS created_from_2,
  w0_.result AS result_3,
  w0_.comments AS comments_4,
  w0_.sinac_bulletin_number AS sinac_bulletin_number_5,
  w0_.analytical_type AS analytical_type_6,
  w0_.created_at AS created_at_7,
  w0_.analyzed_at AS analyzed_at_8,
  w0_.distribution_network_uuid AS distribution_network_uuid_9,
  w0_.whater_point_uuid AS whater_point_uuid_10,
  w0_.responsable_uuid AS responsable_uuid_11
FROM
  wt_whater_analytical w0_
WHERE
  w0_.uuid = ?

SELECT w0_.uuid AS uuid_0, w0_.source AS source_1, w0_.created_from AS created_from_2, w0_.result AS result_3, w0_.comments AS comments_4, w0_.sinac_bulletin_number AS sinac_bulletin_number_5, w0_.analytical_type AS analytical_type_6, w0_.created_at AS created_at_7, w0_.analyzed_at AS analyzed_at_8, w0_.distribution_network_uuid AS distribution_network_uuid_9, w0_.whater_point_uuid AS whater_point_uuid_10, w0_.responsable_uuid AS responsable_uuid_11 FROM wt_whater_analytical w0_ WHERE w0_.uuid = 'd8e1991d-c1c4-4eae-a6fe-b9a4795f437f';

"START TRANSACTION"

"START TRANSACTION";

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.parameter_code AS parameter_code_2,
  t0.parameter_name AS parameter_name_3,
  t0.parameter_metric AS parameter_metric_4,
  t0.reference_min_value AS reference_min_value_5,
  t0.reference_max_value AS reference_max_value_6,
  t0.limit_min_value AS limit_min_value_7,
  t0.limit_max_value AS limit_max_value_8,
  t0.created_at AS created_at_9
FROM
  wt_whater_analytical_parameter t0
WHERE
  t0.uuid = ?

SELECT t0.uuid AS uuid_1, t0.parameter_code AS parameter_code_2, t0.parameter_name AS parameter_name_3, t0.parameter_metric AS parameter_metric_4, t0.reference_min_value AS reference_min_value_5, t0.reference_max_value AS reference_max_value_6, t0.limit_min_value AS limit_min_value_7, t0.limit_max_value AS limit_max_value_8, t0.created_at AS created_at_9 FROM wt_whater_analytical_parameter t0 WHERE t0.uuid = 'b46841d9-e8a6-4d15-b8b4-1a863e028410';

SELECT
  t0.uuid AS uuid_1,
  t0.source AS source_2,
  t0.created_from AS created_from_3,
  t0.result AS result_4,
  t0.comments AS comments_5,
  t0.sinac_bulletin_number AS sinac_bulletin_number_6,
  t0.analytical_type AS analytical_type_7,
  t0.created_at AS created_at_8,
  t0.analyzed_at AS analyzed_at_9,
  t0.distribution_network_uuid AS distribution_network_uuid_10,
  t0.whater_point_uuid AS whater_point_uuid_11,
  t0.responsable_uuid AS responsable_uuid_12
FROM
  wt_whater_analytical t0
WHERE
  t0.distribution_network_uuid = ?
ORDER BY
  t0.analyzed_at DESC

SELECT t0.uuid AS uuid_1, t0.source AS source_2, t0.created_from AS created_from_3, t0.result AS result_4, t0.comments AS comments_5, t0.sinac_bulletin_number AS sinac_bulletin_number_6, t0.analytical_type AS analytical_type_7, t0.created_at AS created_at_8, t0.analyzed_at AS analyzed_at_9, t0.distribution_network_uuid AS distribution_network_uuid_10, t0.whater_point_uuid AS whater_point_uuid_11, t0.responsable_uuid AS responsable_uuid_12 FROM wt_whater_analytical t0 WHERE t0.distribution_network_uuid = 'f0179988-dbf7-4e6b-84af-1677a8c5d2e6' ORDER BY t0.analyzed_at DESC;

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
  INNER JOIN wt_whater_distr_netw_x_towns ON t0.uuid = wt_whater_distr_netw_x_towns.town_uuid
WHERE
  wt_whater_distr_netw_x_towns.distr_network_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.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 INNER JOIN wt_whater_distr_netw_x_towns ON t0.uuid = wt_whater_distr_netw_x_towns.town_uuid WHERE wt_whater_distr_netw_x_towns.distr_network_uuid = 'f0179988-dbf7-4e6b-84af-1677a8c5d2e6';

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.analytical_uuid AS analytical_uuid_9,
  t0.created_by_uuid AS created_by_uuid_10
FROM
  wt_whater_analytical_media t0
WHERE
  t0.analytical_uuid = ?

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.analytical_uuid AS analytical_uuid_9, t0.created_by_uuid AS created_by_uuid_10 FROM wt_whater_analytical_media t0 WHERE t0.analytical_uuid = 'd8e1991d-c1c4-4eae-a6fe-b9a4795f437f';