Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.position_index AS position_index_5
FROM
  region t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.position_index AS position_index_5 FROM region t0;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '1' AND e0_.locale = 'bg' AND e0_.object_class = 'App\\Entity\\Region';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '2' AND e0_.locale = 'bg' AND e0_.object_class = 'App\\Entity\\Region';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '3' AND e0_.locale = 'bg' AND e0_.object_class = 'App\\Entity\\Region';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '4' AND e0_.locale = 'bg' AND e0_.object_class = 'App\\Entity\\Region';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '5' AND e0_.locale = 'bg' AND e0_.object_class = 'App\\Entity\\Region';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '6' AND e0_.locale = 'bg' AND e0_.object_class = 'App\\Entity\\Region';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '7' AND e0_.locale = 'bg' AND e0_.object_class = 'App\\Entity\\Region';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '8' AND e0_.locale = 'bg' AND e0_.object_class = 'App\\Entity\\Region';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '9' AND e0_.locale = 'bg' AND e0_.object_class = 'App\\Entity\\Region';

SELECT
  m0_.id AS id_0,
  m0_.data AS data_1,
  m0_.name AS name_2,
  m0_.slug AS slug_3,
  m0_.description AS description_4,
  m0_.created_at AS created_at_5,
  m0_.updated_at AS updated_at_6,
  m0_.position_index AS position_index_7,
  m0_.page_id AS page_id_8,
  m0_.module_id AS module_id_9
FROM
  module_item m0_
WHERE
  m0_.name IS NOT NULL
  AND (
    m0_.name = ?
    OR m0_.description = ?
  )
ORDER BY
  m0_.name ASC
LIMIT
  1

SELECT m0_.id AS id_0, m0_.data AS data_1, m0_.name AS name_2, m0_.slug AS slug_3, m0_.description AS description_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.position_index AS position_index_7, m0_.page_id AS page_id_8, m0_.module_id AS module_id_9 FROM module_item m0_ WHERE m0_.name IS NOT NULL AND (m0_.name = 'Header' OR m0_.description = 'Header') ORDER BY m0_.name ASC LIMIT 1;

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1,
  o0_.address AS address_2,
  o0_.telephone AS telephone_3,
  o0_.latitude AS latitude_4,
  o0_.longitude AS longitude_5,
  o0_.working_time AS working_time_6,
  o0_.show_on_map AS show_on_map_7,
  o0_.type AS type_8,
  o0_.created_at AS created_at_9,
  o0_.updated_at AS updated_at_10,
  c1_.id AS id_11,
  c1_.name AS name_12,
  c1_.created_at AS created_at_13,
  c1_.updated_at AS updated_at_14,
  o0_.city_id AS city_id_15,
  o0_.region_id AS region_id_16
FROM
  office o0_
  LEFT JOIN city c1_ ON o0_.city_id = c1_.id
WHERE
  o0_.show_on_map = 1
ORDER BY
  o0_.name DESC

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.address AS address_2, o0_.telephone AS telephone_3, o0_.latitude AS latitude_4, o0_.longitude AS longitude_5, o0_.working_time AS working_time_6, o0_.show_on_map AS show_on_map_7, o0_.type AS type_8, o0_.created_at AS created_at_9, o0_.updated_at AS updated_at_10, c1_.id AS id_11, c1_.name AS name_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, o0_.city_id AS city_id_15, o0_.region_id AS region_id_16 FROM office o0_ LEFT JOIN city c1_ ON o0_.city_id = c1_.id WHERE o0_.show_on_map = 1 ORDER BY o0_.name DESC;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '246' AND e0_.locale = 'bg' AND e0_.object_class = 'App\\Entity\\Office';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '124' AND e0_.locale = 'bg' AND e0_.object_class = 'App\\Entity\\City';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '241' AND e0_.locale = 'bg' AND e0_.object_class = 'App\\Entity\\Office';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '121' AND e0_.locale = 'bg' AND e0_.object_class = 'App\\Entity\\City';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '239' AND e0_.locale = 'bg' AND e0_.object_class = 'App\\Entity\\Office';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '120' AND e0_.locale = 'bg' AND e0_.object_class = 'App\\Entity\\City';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '236' AND e0_.locale = 'bg' AND e0_.object_class = 'App\\Entity\\Office';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '119' AND e0_.locale = 'bg' AND e0_.object_class = 'App\\Entity\\City';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '229' AND e0_.locale = 'bg' AND e0_.object_class = 'App\\Entity\\Office';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '118' AND e0_.locale = 'bg' AND e0_.object_class = 'App\\Entity\\City';