Symfony Profiler

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  city c0_
  LEFT JOIN city_translation c1_ ON c0_.id = c1_.translatable_id
  LEFT JOIN province p2_ ON c0_.province_id = p2_.id
  LEFT JOIN region r3_ ON p2_.region_id = r3_.id

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM city c0_ LEFT JOIN city_translation c1_ ON c0_.id = c1_.translatable_id LEFT JOIN province p2_ ON c0_.province_id = p2_.id LEFT JOIN region r3_ ON p2_.region_id = r3_.id;

SELECT
  DISTINCT c0_.id AS id_0
FROM
  city c0_
  LEFT JOIN city_translation c1_ ON c0_.id = c1_.translatable_id
  LEFT JOIN province p2_ ON c0_.province_id = p2_.id
  LEFT JOIN region r3_ ON p2_.region_id = r3_.id
LIMIT
  9

SELECT DISTINCT c0_.id AS id_0 FROM city c0_ LEFT JOIN city_translation c1_ ON c0_.id = c1_.translatable_id LEFT JOIN province p2_ ON c0_.province_id = p2_.id LEFT JOIN region r3_ ON p2_.region_id = r3_.id LIMIT 9;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.region_id AS region_id_3
FROM
  province t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.region_id AS region_id_3 FROM province t0;

SELECT
  t0.id AS id_1,
  t0.area AS area_2
FROM
  region t0

SELECT t0.id AS id_1, t0.area AS area_2 FROM region t0;

SELECT
  t0.id AS id_1,
  t0.area AS area_2
FROM
  region t0

SELECT t0.id AS id_1, t0.area AS area_2 FROM region t0;