Symfony Profiler

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 = 'red-de-abastecimiento-rincon-de-olivedo';

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_
  LEFT JOIN wt_whater_point w1_ ON w0_.whater_point_uuid = w1_.uuid
  LEFT JOIN wt_whater_distr_network w2_ ON w0_.distribution_network_uuid = w2_.uuid
WHERE
  w2_.uuid = ?
  AND w0_.responsable_uuid = ?
ORDER BY
  w0_.analyzed_at DESC
LIMIT
  1

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_ LEFT JOIN wt_whater_point w1_ ON w0_.whater_point_uuid = w1_.uuid LEFT JOIN wt_whater_distr_network w2_ ON w0_.distribution_network_uuid = w2_.uuid WHERE w2_.uuid = 'd38df5b8-4719-4867-96cc-f750148d75ff' AND w0_.responsable_uuid = '642b6497-510d-4907-b439-bfce8fb63b7c' ORDER BY w0_.analyzed_at DESC LIMIT 1;

"COMMIT"

"COMMIT";

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 = '642b6497-510d-4907-b439-bfce8fb63b7c';

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

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 = '6c8b0dc4-bcb9-46d7-ba27-3b30ba2f0d89' ORDER BY t0.created_at DESC;

"START TRANSACTION"

"START TRANSACTION";

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 = '17668ebf-2554-4086-acc8-f00b252bb1d3';

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.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.parent_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.parent_uuid = 'd38df5b8-4719-4867-96cc-f750148d75ff';

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 = 'd38df5b8-4719-4867-96cc-f750148d75ff';

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_
  LEFT JOIN wt_whater_organization w1_ ON w0_.whater_organization_uuid = w1_.uuid
  LEFT JOIN wt_zone_country w2_ ON w1_.country_uuid = w2_.uuid
WHERE
  (
    EXISTS (
      SELECT
        1
      FROM
        wt_product_x_country w3_
      WHERE
        w3_.product_uuid = w0_.uuid
        AND w3_.country_uuid IN (?)
    )
    OR EXISTS (
      SELECT
        1
      FROM
        wt_product_x_country_area w4_
      WHERE
        w4_.product_uuid = w0_.uuid
        AND w4_.country_area_uuid IN (?)
    )
    OR w0_.recommend_to_water_status_suitable = 1
  )
  AND w0_.is_enable = 1
  AND w2_.uuid = ?
  AND w0_.product_type = ?
ORDER BY
  w0_.created_at ASC
LIMIT
  5

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_ LEFT JOIN wt_whater_organization w1_ ON w0_.whater_organization_uuid = w1_.uuid LEFT JOIN wt_zone_country w2_ ON w1_.country_uuid = w2_.uuid WHERE (EXISTS (SELECT 1 FROM wt_product_x_country w3_ WHERE w3_.product_uuid = w0_.uuid AND w3_.country_uuid IN ('216abc6f-594d-49ea-8977-8976ca33e92c')) OR EXISTS (SELECT 1 FROM wt_product_x_country_area w4_ WHERE w4_.product_uuid = w0_.uuid AND w4_.country_area_uuid IN ('17668ebf-2554-4086-acc8-f00b252bb1d3')) OR w0_.recommend_to_water_status_suitable = 1) AND w0_.is_enable = 1 AND w2_.uuid = '216abc6f-594d-49ea-8977-8976ca33e92c' AND w0_.product_type = 'PT_CATALOG' ORDER BY w0_.created_at ASC LIMIT 5;

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 = 'd38df5b8-4719-4867-96cc-f750148d75ff';

SELECT
  t0.uuid AS uuid_1,
  t0.color_valoration AS color_valoration_2,
  t0.taste_valoration AS taste_valoration_3,
  t0.smell_valoration AS smell_valoration_4,
  t0.turbidity_valoration AS turbidity_valoration_5,
  t0.general_valoration AS general_valoration_6,
  t0.user_comment_text AS user_comment_text_7,
  t0.response_comment_text AS response_comment_text_8,
  t0.hide_user_comment AS hide_user_comment_9,
  t0.created_at AS created_at_10,
  t0.response_comment_at AS response_comment_at_11,
  t0.is_professional_valoration AS is_professional_valoration_12,
  t13.uuid AS uuid_14,
  t13.file_name AS file_name_15,
  t13.file_size AS file_size_16,
  t13.file_mime_type AS file_mime_type_17,
  t13.file_originalname AS file_originalname_18,
  t13.file_dimensions AS file_dimensions_19,
  t13.created_at AS created_at_20,
  t13.updated_at AS updated_at_21,
  t13.whater_distr_net_valor_uuid AS whater_distr_net_valor_uuid_22,
  t13.created_by_uuid AS created_by_uuid_23,
  t0.distribution_network_uuid AS distribution_network_uuid_24,
  t0.created_by_uuid AS created_by_uuid_25
FROM
  wt_whater_distr_netw_valoration t0
  LEFT JOIN wt_whater_distr_netw_valor_image t13 ON t13.whater_distr_net_valor_uuid = t0.uuid
WHERE
  t0.distribution_network_uuid = ?
ORDER BY
  t0.created_at DESC

SELECT t0.uuid AS uuid_1, t0.color_valoration AS color_valoration_2, t0.taste_valoration AS taste_valoration_3, t0.smell_valoration AS smell_valoration_4, t0.turbidity_valoration AS turbidity_valoration_5, t0.general_valoration AS general_valoration_6, t0.user_comment_text AS user_comment_text_7, t0.response_comment_text AS response_comment_text_8, t0.hide_user_comment AS hide_user_comment_9, t0.created_at AS created_at_10, t0.response_comment_at AS response_comment_at_11, t0.is_professional_valoration AS is_professional_valoration_12, t13.uuid AS uuid_14, t13.file_name AS file_name_15, t13.file_size AS file_size_16, t13.file_mime_type AS file_mime_type_17, t13.file_originalname AS file_originalname_18, t13.file_dimensions AS file_dimensions_19, t13.created_at AS created_at_20, t13.updated_at AS updated_at_21, t13.whater_distr_net_valor_uuid AS whater_distr_net_valor_uuid_22, t13.created_by_uuid AS created_by_uuid_23, t0.distribution_network_uuid AS distribution_network_uuid_24, t0.created_by_uuid AS created_by_uuid_25 FROM wt_whater_distr_netw_valoration t0 LEFT JOIN wt_whater_distr_netw_valor_image t13 ON t13.whater_distr_net_valor_uuid = t0.uuid WHERE t0.distribution_network_uuid = 'd38df5b8-4719-4867-96cc-f750148d75ff' ORDER BY t0.created_at DESC;