Symfony Profiler

"START TRANSACTION"

"START TRANSACTION";

SELECT
  w0_.uuid AS uuid_0,
  w0_.name AS name_1,
  w0_.type AS type_2,
  w0_.slug AS slug_3,
  w0_.sinac_id AS sinac_id_4,
  w0_.whater_status AS whater_status_5,
  w0_.whater_status_by_government AS whater_status_by_government_6,
  w0_.whater_status_by_government_updated_at AS whater_status_by_government_updated_at_7,
  w0_.whater_status_by_operator AS whater_status_by_operator_8,
  w0_.whater_status_by_operator_updated_at AS whater_status_by_operator_updated_at_9,
  w0_.whater_status_by_ubication AS whater_status_by_ubication_10,
  w0_.whater_status_by_ubication_updated_at AS whater_status_by_ubication_updated_at_11,
  w0_.details AS details_12,
  w0_.created_at AS created_at_13,
  w0_.updated_at AS updated_at_14,
  w0_.last_analitycs_update_at AS last_analitycs_update_at_15,
  w0_.center_longitude AS center_longitude_16,
  w0_.center_latitude AS center_latitude_17,
  ST_AsBinary(w0_.geometry_polygon) AS geometry_polygon_18,
  w0_.geometry_area_in_ha AS geometry_area_in_ha_19,
  w0_.sinac_connection_errors AS sinac_connection_errors_20,
  w0_.last_sinac_connection_at AS last_sinac_connection_at_21,
  w0_.notify_whater_status_change AS notify_whater_status_change_22,
  w0_.last_professional_valoration_at AS last_professional_valoration_at_23,
  w0_.last_user_valoration_at AS last_user_valoration_at_24,
  w0_.total_color AS total_color_25,
  w0_.total_taste AS total_taste_26,
  w0_.total_smell AS total_smell_27,
  w0_.total_turbidity AS total_turbidity_28,
  w0_.total_general AS total_general_29,
  w0_.average_professional_general AS average_professional_general_30,
  w0_.average_user_general AS average_user_general_31,
  w0_.count_user_general AS count_user_general_32,
  w0_.count_professional_general AS count_professional_general_33,
  w0_.country_uuid AS country_uuid_34,
  w0_.parent_uuid AS parent_uuid_35,
  w0_.resp_organ_government_uuid AS resp_organ_government_uuid_36,
  w0_.resp_organ_operator_uuid AS resp_organ_operator_uuid_37,
  w0_.resp_organ_corporative_uuid AS resp_organ_corporative_uuid_38,
  w0_.resp_organ_ubication_uuid AS resp_organ_ubication_uuid_39
FROM
  wt_whater_distr_network w0_
WHERE
  w0_.slug = ?

SELECT w0_.uuid AS uuid_0, w0_.name AS name_1, w0_.type AS type_2, w0_.slug AS slug_3, w0_.sinac_id AS sinac_id_4, w0_.whater_status AS whater_status_5, w0_.whater_status_by_government AS whater_status_by_government_6, w0_.whater_status_by_government_updated_at AS whater_status_by_government_updated_at_7, w0_.whater_status_by_operator AS whater_status_by_operator_8, w0_.whater_status_by_operator_updated_at AS whater_status_by_operator_updated_at_9, w0_.whater_status_by_ubication AS whater_status_by_ubication_10, w0_.whater_status_by_ubication_updated_at AS whater_status_by_ubication_updated_at_11, w0_.details AS details_12, w0_.created_at AS created_at_13, w0_.updated_at AS updated_at_14, w0_.last_analitycs_update_at AS last_analitycs_update_at_15, w0_.center_longitude AS center_longitude_16, w0_.center_latitude AS center_latitude_17, ST_AsBinary(w0_.geometry_polygon) AS geometry_polygon_18, w0_.geometry_area_in_ha AS geometry_area_in_ha_19, w0_.sinac_connection_errors AS sinac_connection_errors_20, w0_.last_sinac_connection_at AS last_sinac_connection_at_21, w0_.notify_whater_status_change AS notify_whater_status_change_22, w0_.last_professional_valoration_at AS last_professional_valoration_at_23, w0_.last_user_valoration_at AS last_user_valoration_at_24, w0_.total_color AS total_color_25, w0_.total_taste AS total_taste_26, w0_.total_smell AS total_smell_27, w0_.total_turbidity AS total_turbidity_28, w0_.total_general AS total_general_29, w0_.average_professional_general AS average_professional_general_30, w0_.average_user_general AS average_user_general_31, w0_.count_user_general AS count_user_general_32, w0_.count_professional_general AS count_professional_general_33, w0_.country_uuid AS country_uuid_34, w0_.parent_uuid AS parent_uuid_35, w0_.resp_organ_government_uuid AS resp_organ_government_uuid_36, w0_.resp_organ_operator_uuid AS resp_organ_operator_uuid_37, w0_.resp_organ_corporative_uuid AS resp_organ_corporative_uuid_38, w0_.resp_organ_ubication_uuid AS resp_organ_ubication_uuid_39 FROM wt_whater_distr_network w0_ WHERE w0_.slug = 'redint-bar-el-pela';

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

"COMMIT"

"COMMIT";

SELECT
  t0.uuid AS uuid_1,
  t0.status AS status_2,
  t0.default_locale AS default_locale_3,
  t0.header_image_url AS header_image_url_4,
  t0.publish_at AS publish_at_5,
  t0.show_in_blog AS show_in_blog_6,
  t0.show_in_whaterpoints AS show_in_whaterpoints_7,
  t0.show_in_distribution_networks AS show_in_distribution_networks_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  wt_blog_article t0
  INNER JOIN wt_blog_articles_distr_networks ON t0.uuid = wt_blog_articles_distr_networks.article_id
WHERE
  wt_blog_articles_distr_networks.distribution_network_id = ?

SELECT t0.uuid AS uuid_1, t0.status AS status_2, t0.default_locale AS default_locale_3, t0.header_image_url AS header_image_url_4, t0.publish_at AS publish_at_5, t0.show_in_blog AS show_in_blog_6, t0.show_in_whaterpoints AS show_in_whaterpoints_7, t0.show_in_distribution_networks AS show_in_distribution_networks_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM wt_blog_article t0 INNER JOIN wt_blog_articles_distr_networks ON t0.uuid = wt_blog_articles_distr_networks.article_id WHERE wt_blog_articles_distr_networks.distribution_network_id = '298b64a6-6571-4ff4-884a-70b8a440a218';

"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.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 = '298b64a6-6571-4ff4-884a-70b8a440a218';

"ROLLBACK"

"ROLLBACK";