Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.property_id AS property_id_3 FROM picture t0 WHERE t0.property_id = ?

[
  15
]

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.property_id AS property_id_3
FROM
  picture t0
WHERE
  t0.property_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.property_id AS property_id_3 FROM picture t0 WHERE t0.property_id = 15;

SELECT t0_.id AS id_0, t0_.name AS name_1 FROM type t0_

[]

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1
FROM
  type t0_

SELECT t0_.id AS id_0, t0_.name AS name_1 FROM type t0_;

SELECT p0_.id AS id_0, p0_.updated_at AS updated_at_1, p0_.title AS title_2, p0_.description AS description_3, p0_.surface AS surface_4, p0_.rooms AS rooms_5, p0_.bedrooms AS bedrooms_6, p0_.floor AS floor_7, p0_.price AS price_8, p0_.heating AS heating_9, p0_.city AS city_10, p0_.address AS address_11, p0_.postal_code AS postal_code_12, p0_.sold AS sold_13, p0_.created_at AS created_at_14, p0_.lat AS lat_15, p0_.lng AS lng_16, p0_.bathrooms AS bathrooms_17, p0_.terrace_garden AS terrace_garden_18, p0_.terrace_surface AS terrace_surface_19, p0_.garden_surface AS garden_surface_20, p0_.energy_label AS energy_label_21, p0_.parcel_score AS parcel_score_22, p0_.building_score AS building_score_23, p0_.zone AS zone_24, p0_.pdf_filename AS pdf_filename_25, p0_.pdf_size AS pdf_size_26 FROM property p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.title ASC

[
  15
  16
  17
  19
  20
  21
  22
  23
]

SELECT
  p0_.id AS id_0,
  p0_.updated_at AS updated_at_1,
  p0_.title AS title_2,
  p0_.description AS description_3,
  p0_.surface AS surface_4,
  p0_.rooms AS rooms_5,
  p0_.bedrooms AS bedrooms_6,
  p0_.floor AS floor_7,
  p0_.price AS price_8,
  p0_.heating AS heating_9,
  p0_.city AS city_10,
  p0_.address AS address_11,
  p0_.postal_code AS postal_code_12,
  p0_.sold AS sold_13,
  p0_.created_at AS created_at_14,
  p0_.lat AS lat_15,
  p0_.lng AS lng_16,
  p0_.bathrooms AS bathrooms_17,
  p0_.terrace_garden AS terrace_garden_18,
  p0_.terrace_surface AS terrace_surface_19,
  p0_.garden_surface AS garden_surface_20,
  p0_.energy_label AS energy_label_21,
  p0_.parcel_score AS parcel_score_22,
  p0_.building_score AS building_score_23,
  p0_.zone AS zone_24,
  p0_.pdf_filename AS pdf_filename_25,
  p0_.pdf_size AS pdf_size_26
FROM
  property p0_
WHERE
  p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.title ASC

SELECT p0_.id AS id_0, p0_.updated_at AS updated_at_1, p0_.title AS title_2, p0_.description AS description_3, p0_.surface AS surface_4, p0_.rooms AS rooms_5, p0_.bedrooms AS bedrooms_6, p0_.floor AS floor_7, p0_.price AS price_8, p0_.heating AS heating_9, p0_.city AS city_10, p0_.address AS address_11, p0_.postal_code AS postal_code_12, p0_.sold AS sold_13, p0_.created_at AS created_at_14, p0_.lat AS lat_15, p0_.lng AS lng_16, p0_.bathrooms AS bathrooms_17, p0_.terrace_garden AS terrace_garden_18, p0_.terrace_surface AS terrace_surface_19, p0_.garden_surface AS garden_surface_20, p0_.energy_label AS energy_label_21, p0_.parcel_score AS parcel_score_22, p0_.building_score AS building_score_23, p0_.zone AS zone_24, p0_.pdf_filename AS pdf_filename_25, p0_.pdf_size AS pdf_size_26 FROM property p0_ WHERE p0_.id IN (15, 16, 17, 19, 20, 21, 22, 23) ORDER BY p0_.title ASC;

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM property p0_

[]

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  property p0_

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM property p0_;

SELECT DISTINCT p0_.id AS id_0, p0_.title AS title_1 FROM property p0_ ORDER BY p0_.title ASC LIMIT 8 OFFSET 16

[]

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.title AS title_1
FROM
  property p0_
ORDER BY
  p0_.title ASC
LIMIT
  8 OFFSET 16

SELECT DISTINCT p0_.id AS id_0, p0_.title AS title_1 FROM property p0_ ORDER BY p0_.title ASC LIMIT 8 OFFSET 16;