Symfony Profiler

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_
ORDER BY
  w0_.name ASC
LIMIT
  500000

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_ ORDER BY w0_.name ASC LIMIT 500000;

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 = '10678518-6844-469a-b629-7a0e297a6138';

SELECT
  t0.uuid AS uuid_1,
  t0.slug AS slug_2,
  t0.title AS title_3,
  t0.locale AS locale_4,
  t0.content AS content_5,
  t0.meta_keywords AS meta_keywords_6,
  t0.meta_description AS meta_description_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.article_uuid AS article_uuid_10
FROM
  wt_blog_article_translation t0
WHERE
  t0.article_uuid = ?

SELECT t0.uuid AS uuid_1, t0.slug AS slug_2, t0.title AS title_3, t0.locale AS locale_4, t0.content AS content_5, t0.meta_keywords AS meta_keywords_6, t0.meta_description AS meta_description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.article_uuid AS article_uuid_10 FROM wt_blog_article_translation t0 WHERE t0.article_uuid = '0bbf99db-6290-4dce-b700-8ad52ada2b8f';

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

SELECT
  DISTINCT w0_.uuid AS uuid_0,
  w0_.status AS status_1,
  w0_.default_locale AS default_locale_2,
  w0_.header_image_url AS header_image_url_3,
  w0_.publish_at AS publish_at_4,
  w0_.show_in_blog AS show_in_blog_5,
  w0_.show_in_whaterpoints AS show_in_whaterpoints_6,
  w0_.show_in_distribution_networks AS show_in_distribution_networks_7,
  w0_.created_at AS created_at_8,
  w0_.updated_at AS updated_at_9
FROM
  wt_blog_article w0_
  LEFT JOIN wt_blog_article_translation w1_ ON w0_.uuid = w1_.article_uuid
WHERE
  (w0_.status = ?)
  AND (w0_.publish_at <= ?)
ORDER BY
  w0_.publish_at DESC
LIMIT
  500

SELECT DISTINCT w0_.uuid AS uuid_0, w0_.status AS status_1, w0_.default_locale AS default_locale_2, w0_.header_image_url AS header_image_url_3, w0_.publish_at AS publish_at_4, w0_.show_in_blog AS show_in_blog_5, w0_.show_in_whaterpoints AS show_in_whaterpoints_6, w0_.show_in_distribution_networks AS show_in_distribution_networks_7, w0_.created_at AS created_at_8, w0_.updated_at AS updated_at_9 FROM wt_blog_article w0_ LEFT JOIN wt_blog_article_translation w1_ ON w0_.uuid = w1_.article_uuid WHERE (w0_.status = 'AS_PUBLIC') AND (w0_.publish_at <= '2025-11-03 10:28:08') ORDER BY w0_.publish_at DESC LIMIT 500;