Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 7
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Doctrine 1
• Debug
• E-mails
• Serializer
• Blocks 0
• Configuration

Query Metrics

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.name_hy AS name_hy_2, l0_.name_ru AS name_ru_3, l0_.slug AS slug_4, l0_.address AS address_5, l0_.latitude AS latitude_6, l0_.longitude AS longitude_7, l0_.category AS category_8, l0_.is_active AS is_active_9, l0_.created_at AS created_at_10, l0_.updated_at AS updated_at_11, l1_.id AS id_12, l1_.type AS type_13, l1_.title AS title_14, l1_.content AS content_15, l1_.file_path AS file_path_16, l1_.language AS language_17, l1_.sort_order AS sort_order_18, l1_.is_active AS is_active_19, l1_.created_at AS created_at_20, l1_.updated_at AS updated_at_21, c2_.id AS id_22, c2_.name AS name_23, c2_.slug AS slug_24, c2_.is_active AS is_active_25, c2_.created_at AS created_at_26, c3_.id AS id_27, c3_.name AS name_28, c3_.code AS code_29, c3_.slug AS slug_30, c3_.is_active AS is_active_31, c3_.created_at AS created_at_32, l0_.city_id AS city_id_33, l1_.location_id AS location_id_34, c2_.country_id AS country_id_35 FROM location l0_ LEFT JOIN location_detail l1_ ON l0_.id = l1_.location_id INNER JOIN city c2_ ON l0_.city_id = c2_.id INNER JOIN country c3_ ON c2_.country_id = c3_.id WHERE l0_.is_active = ? AND l0_.latitude IS NOT NULL AND l0_.longitude IS NOT NULL ORDER BY l0_.name ASC, l1_.sort_order ASC

[
  1
]

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.name_hy AS name_hy_2,
  l0_.name_ru AS name_ru_3,
  l0_.slug AS slug_4,
  l0_.address AS address_5,
  l0_.latitude AS latitude_6,
  l0_.longitude AS longitude_7,
  l0_.category AS category_8,
  l0_.is_active AS is_active_9,
  l0_.created_at AS created_at_10,
  l0_.updated_at AS updated_at_11,
  l1_.id AS id_12,
  l1_.type AS type_13,
  l1_.title AS title_14,
  l1_.content AS content_15,
  l1_.file_path AS file_path_16,
  l1_.language AS language_17,
  l1_.sort_order AS sort_order_18,
  l1_.is_active AS is_active_19,
  l1_.created_at AS created_at_20,
  l1_.updated_at AS updated_at_21,
  c2_.id AS id_22,
  c2_.name AS name_23,
  c2_.slug AS slug_24,
  c2_.is_active AS is_active_25,
  c2_.created_at AS created_at_26,
  c3_.id AS id_27,
  c3_.name AS name_28,
  c3_.code AS code_29,
  c3_.slug AS slug_30,
  c3_.is_active AS is_active_31,
  c3_.created_at AS created_at_32,
  l0_.city_id AS city_id_33,
  l1_.location_id AS location_id_34,
  c2_.country_id AS country_id_35
FROM
  location l0_
  LEFT JOIN location_detail l1_ ON l0_.id = l1_.location_id
  INNER JOIN city c2_ ON l0_.city_id = c2_.id
  INNER JOIN country c3_ ON c2_.country_id = c3_.id
WHERE
  l0_.is_active = ?
  AND l0_.latitude IS NOT NULL
  AND l0_.longitude IS NOT NULL
ORDER BY
  l0_.name ASC,
  l1_.sort_order ASC

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.name_hy AS name_hy_2, l0_.name_ru AS name_ru_3, l0_.slug AS slug_4, l0_.address AS address_5, l0_.latitude AS latitude_6, l0_.longitude AS longitude_7, l0_.category AS category_8, l0_.is_active AS is_active_9, l0_.created_at AS created_at_10, l0_.updated_at AS updated_at_11, l1_.id AS id_12, l1_.type AS type_13, l1_.title AS title_14, l1_.content AS content_15, l1_.file_path AS file_path_16, l1_.language AS language_17, l1_.sort_order AS sort_order_18, l1_.is_active AS is_active_19, l1_.created_at AS created_at_20, l1_.updated_at AS updated_at_21, c2_.id AS id_22, c2_.name AS name_23, c2_.slug AS slug_24, c2_.is_active AS is_active_25, c2_.created_at AS created_at_26, c3_.id AS id_27, c3_.name AS name_28, c3_.code AS code_29, c3_.slug AS slug_30, c3_.is_active AS is_active_31, c3_.created_at AS created_at_32, l0_.city_id AS city_id_33, l1_.location_id AS location_id_34, c2_.country_id AS country_id_35 FROM location l0_ LEFT JOIN location_detail l1_ ON l0_.id = l1_.location_id INNER JOIN city c2_ ON l0_.city_id = c2_.id INNER JOIN country c3_ ON c2_.country_id = c3_.id WHERE l0_.is_active = 1 AND l0_.latitude IS NOT NULL AND l0_.longitude IS NOT NULL ORDER BY l0_.name ASC, l1_.sort_order ASC;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.is_active AS is_active_3, c0_.created_at AS created_at_4, c0_.country_id AS country_id_5 FROM city c0_ WHERE c0_.is_active = ? ORDER BY c0_.name ASC

[
  1
]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.is_active AS is_active_3,
  c0_.created_at AS created_at_4,
  c0_.country_id AS country_id_5
FROM
  city c0_
WHERE
  c0_.is_active = ?
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.is_active AS is_active_3, c0_.created_at AS created_at_4, c0_.country_id AS country_id_5 FROM city c0_ WHERE c0_.is_active = 1 ORDER BY c0_.name ASC;