Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation 4
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT MIN(b0_.price) AS sclr_0, MAX(b0_.price) AS sclr_1 FROM building b0_

[]

SELECT
  MIN(b0_.price) AS sclr_0,
  MAX(b0_.price) AS sclr_1
FROM
  building b0_

SELECT MIN(b0_.price) AS sclr_0, MAX(b0_.price) AS sclr_1 FROM building b0_;

SELECT DISTINCT (b0_.city) AS sclr_0 FROM building b0_ WHERE b0_.city IS NOT NULL

[]

SELECT
  DISTINCT (b0_.city) AS sclr_0
FROM
  building b0_
WHERE
  b0_.city IS NOT NULL

SELECT DISTINCT (b0_.city) AS sclr_0 FROM building b0_ WHERE b0_.city IS NOT NULL;

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.street AS street_2, b0_.zip AS zip_3, b0_.city AS city_4, b0_.description AS description_5, b0_.livable_area AS livable_area_6, b0_.land_area AS land_area_7, b0_.number_of_floors AS number_of_floors_8, b0_.number_of_garages AS number_of_garages_9, b0_.living_room_area AS living_room_area_10, b0_.price AS price_11, b0_.type_of_heating AS type_of_heating_12, b0_.gas_connection AS gas_connection_13, b0_.water_connection AS water_connection_14, b0_.equipped_kitchen AS equipped_kitchen_15, b0_.type_of_glazing AS type_of_glazing_16, b0_.active AS active_17, b0_.public_slider_title AS public_slider_title_18, b0_.public_slider_description AS public_slider_description_19, b0_.public_slider_active AS public_slider_active_20, b0_.number_of_bedroom AS number_of_bedroom_21, b0_.country_id AS country_id_22, b0_.peb_id AS peb_id_23, b0_.locality_id AS locality_id_24, b0_.building_type_id AS building_type_id_25, b0_.banner_id AS banner_id_26 FROM building b0_

[]

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.street AS street_2,
  b0_.zip AS zip_3,
  b0_.city AS city_4,
  b0_.description AS description_5,
  b0_.livable_area AS livable_area_6,
  b0_.land_area AS land_area_7,
  b0_.number_of_floors AS number_of_floors_8,
  b0_.number_of_garages AS number_of_garages_9,
  b0_.living_room_area AS living_room_area_10,
  b0_.price AS price_11,
  b0_.type_of_heating AS type_of_heating_12,
  b0_.gas_connection AS gas_connection_13,
  b0_.water_connection AS water_connection_14,
  b0_.equipped_kitchen AS equipped_kitchen_15,
  b0_.type_of_glazing AS type_of_glazing_16,
  b0_.active AS active_17,
  b0_.public_slider_title AS public_slider_title_18,
  b0_.public_slider_description AS public_slider_description_19,
  b0_.public_slider_active AS public_slider_active_20,
  b0_.number_of_bedroom AS number_of_bedroom_21,
  b0_.country_id AS country_id_22,
  b0_.peb_id AS peb_id_23,
  b0_.locality_id AS locality_id_24,
  b0_.building_type_id AS building_type_id_25,
  b0_.banner_id AS banner_id_26
FROM
  building b0_

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.street AS street_2, b0_.zip AS zip_3, b0_.city AS city_4, b0_.description AS description_5, b0_.livable_area AS livable_area_6, b0_.land_area AS land_area_7, b0_.number_of_floors AS number_of_floors_8, b0_.number_of_garages AS number_of_garages_9, b0_.living_room_area AS living_room_area_10, b0_.price AS price_11, b0_.type_of_heating AS type_of_heating_12, b0_.gas_connection AS gas_connection_13, b0_.water_connection AS water_connection_14, b0_.equipped_kitchen AS equipped_kitchen_15, b0_.type_of_glazing AS type_of_glazing_16, b0_.active AS active_17, b0_.public_slider_title AS public_slider_title_18, b0_.public_slider_description AS public_slider_description_19, b0_.public_slider_active AS public_slider_active_20, b0_.number_of_bedroom AS number_of_bedroom_21, b0_.country_id AS country_id_22, b0_.peb_id AS peb_id_23, b0_.locality_id AS locality_id_24, b0_.building_type_id AS building_type_id_25, b0_.banner_id AS banner_id_26 FROM building b0_;

SELECT l0_.id AS id_0, l0_.name AS name_1 FROM locality l0_

[]

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1
FROM
  locality l0_

SELECT l0_.id AS id_0, l0_.name AS name_1 FROM locality l0_;

SELECT b0_.id AS id_0, b0_.name AS name_1 FROM building_type b0_

[]

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1
FROM
  building_type b0_

SELECT b0_.id AS id_0, b0_.name AS name_1 FROM building_type b0_;

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.position AS position_5, t0.building_id AS building_id_6 FROM building_picture t0 WHERE t0.building_id = ? ORDER BY t0.position ASC

[
  1
]

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_filename AS original_filename_3,
  t0.mime_type AS mime_type_4,
  t0.position AS position_5,
  t0.building_id AS building_id_6
FROM
  building_picture t0
WHERE
  t0.building_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.position AS position_5, t0.building_id AS building_id_6 FROM building_picture t0 WHERE t0.building_id = 1 ORDER BY t0.position ASC;

SELECT t0.id AS id_1, t0.name AS name_2 FROM peb t0 WHERE t0.id = ?

[
  8
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  peb t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM peb t0 WHERE t0.id = 8;

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.position AS position_5, t0.building_id AS building_id_6 FROM building_picture t0 WHERE t0.building_id = ? ORDER BY t0.position ASC

[
  2
]

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_filename AS original_filename_3,
  t0.mime_type AS mime_type_4,
  t0.position AS position_5,
  t0.building_id AS building_id_6
FROM
  building_picture t0
WHERE
  t0.building_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.position AS position_5, t0.building_id AS building_id_6 FROM building_picture t0 WHERE t0.building_id = 2 ORDER BY t0.position ASC;

SELECT t0.id AS id_1, t0.name AS name_2 FROM peb t0 WHERE t0.id = ?

[
  9
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  peb t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM peb t0 WHERE t0.id = 9;

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.position AS position_5, t0.building_id AS building_id_6 FROM building_picture t0 WHERE t0.building_id = ? ORDER BY t0.position ASC

[
  3
]

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_filename AS original_filename_3,
  t0.mime_type AS mime_type_4,
  t0.position AS position_5,
  t0.building_id AS building_id_6
FROM
  building_picture t0
WHERE
  t0.building_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.position AS position_5, t0.building_id AS building_id_6 FROM building_picture t0 WHERE t0.building_id = 3 ORDER BY t0.position ASC;

SELECT t0.id AS id_1, t0.name AS name_2 FROM peb t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  peb t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM peb t0 WHERE t0.id = 1;

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.position AS position_5, t0.building_id AS building_id_6 FROM building_picture t0 WHERE t0.building_id = ? ORDER BY t0.position ASC

[
  4
]

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_filename AS original_filename_3,
  t0.mime_type AS mime_type_4,
  t0.position AS position_5,
  t0.building_id AS building_id_6
FROM
  building_picture t0
WHERE
  t0.building_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.position AS position_5, t0.building_id AS building_id_6 FROM building_picture t0 WHERE t0.building_id = 4 ORDER BY t0.position ASC;