Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.idCountry AS idCountry_2,
  t0.code AS code_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.region_id AS region_id_6,
  t0.small_region_id AS small_region_id_7
FROM
  department t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.idCountry AS idCountry_2, t0.code AS code_3, t0.name AS name_4, t0.slug AS slug_5, t0.region_id AS region_id_6, t0.small_region_id AS small_region_id_7 FROM department t0 WHERE t0.code = '94' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.slug AS slug_4,
  t0.location AS location_5,
  t0.position AS position_6,
  t0.department_id AS department_id_7,
  t0.parent_city_id AS parent_city_id_8
FROM
  city t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.slug AS slug_4, t0.location AS location_5, t0.position AS position_6, t0.department_id AS department_id_7, t0.parent_city_id AS parent_city_id_8 FROM city t0 WHERE t0.name = 'CHOISY-LE-ROI' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.idCountry AS idCountry_2,
  t0.code AS code_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.region_id AS region_id_6,
  t0.small_region_id AS small_region_id_7
FROM
  department t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.idCountry AS idCountry_2, t0.code AS code_3, t0.name AS name_4, t0.slug AS slug_5, t0.region_id AS region_id_6, t0.small_region_id AS small_region_id_7 FROM department t0 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.idCountry AS idCountry_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.type AS type_5,
  t0.parent_region_id AS parent_region_id_6
FROM
  region t0
WHERE
  t0.type = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.idCountry AS idCountry_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.parent_region_id AS parent_region_id_6 FROM region t0 WHERE t0.type = 'main' ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.idCountry AS idCountry_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.type AS type_5,
  t0.parent_region_id AS parent_region_id_6
FROM
  region t0
WHERE
  t0.type = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.idCountry AS idCountry_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.parent_region_id AS parent_region_id_6 FROM region t0 WHERE t0.type = 'small' ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.slug AS slug_4,
  t0.location AS location_5,
  t0.position AS position_6,
  t0.department_id AS department_id_7,
  t0.parent_city_id AS parent_city_id_8
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.slug AS slug_4, t0.location AS location_5, t0.position AS position_6, t0.department_id AS department_id_7, t0.parent_city_id AS parent_city_id_8 FROM city t0 WHERE t0.id = 901;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.slug AS slug_4,
  t0.location AS location_5,
  t0.position AS position_6,
  t0.department_id AS department_id_7,
  t0.parent_city_id AS parent_city_id_8
FROM
  city t0
WHERE
  t0.parent_city_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.slug AS slug_4, t0.location AS location_5, t0.position AS position_6, t0.department_id AS department_id_7, t0.parent_city_id AS parent_city_id_8 FROM city t0 WHERE t0.parent_city_id = 901;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.slug AS slug_4,
  t0.location AS location_5,
  t0.position AS position_6,
  t0.department_id AS department_id_7,
  t0.parent_city_id AS parent_city_id_8
FROM
  city t0
WHERE
  t0.department_id = ?
ORDER BY
  t0.position ASC,
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.slug AS slug_4, t0.location AS location_5, t0.position AS position_6, t0.department_id AS department_id_7, t0.parent_city_id AS parent_city_id_8 FROM city t0 WHERE t0.department_id = 7 ORDER BY t0.position ASC, t0.name ASC;