Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 39
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Emails
• VichUploader
• Mercure
• Configuration

Query Metrics

SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.title AS title_2, a0_.address AS address_3, a0_.address_lat AS address_lat_4, a0_.address_lng AS address_lng_5, a0_.description AS description_6, a0_.information AS information_7, a0_.price AS price_8, a0_.visit_price AS visit_price_9, a0_.currency AS currency_10, a0_.purpose AS purpose_11, a0_.type AS type_12, a0_.new_real_state AS new_real_state_13, a0_.piece AS piece_14, a0_.surface AS surface_15, a0_.virtual_tour_id AS virtual_tour_id_16, a0_.youtube_id AS youtube_id_17, a0_.status AS status_18, a0_.payment_process_type AS payment_process_type_19, a0_.updated_at AS updated_at_20, a0_.land_document_type AS land_document_type_21, a0_.land_document_id AS land_document_id_22, a0_.priority AS priority_23, a0_.owner_id AS owner_id_24, a0_.main_advert_id AS main_advert_id_25 FROM advert a0_ INNER JOIN user u1_ ON a0_.owner_id = u1_.id AND (u1_.enabled = 1) WHERE a0_.status LIKE ? ORDER BY a0_.date DESC LIMIT 6

[
  "PUBLISHED"
]

SELECT
  a0_.id AS id_0,
  a0_.date AS date_1,
  a0_.title AS title_2,
  a0_.address AS address_3,
  a0_.address_lat AS address_lat_4,
  a0_.address_lng AS address_lng_5,
  a0_.description AS description_6,
  a0_.information AS information_7,
  a0_.price AS price_8,
  a0_.visit_price AS visit_price_9,
  a0_.currency AS currency_10,
  a0_.purpose AS purpose_11,
  a0_.type AS type_12,
  a0_.new_real_state AS new_real_state_13,
  a0_.piece AS piece_14,
  a0_.surface AS surface_15,
  a0_.virtual_tour_id AS virtual_tour_id_16,
  a0_.youtube_id AS youtube_id_17,
  a0_.status AS status_18,
  a0_.payment_process_type AS payment_process_type_19,
  a0_.updated_at AS updated_at_20,
  a0_.land_document_type AS land_document_type_21,
  a0_.land_document_id AS land_document_id_22,
  a0_.priority AS priority_23,
  a0_.owner_id AS owner_id_24,
  a0_.main_advert_id AS main_advert_id_25
FROM
  advert a0_
  INNER JOIN user u1_ ON a0_.owner_id = u1_.id
  AND (u1_.enabled = 1)
WHERE
  a0_.status LIKE ?
ORDER BY
  a0_.date DESC
LIMIT
  6

SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.title AS title_2, a0_.address AS address_3, a0_.address_lat AS address_lat_4, a0_.address_lng AS address_lng_5, a0_.description AS description_6, a0_.information AS information_7, a0_.price AS price_8, a0_.visit_price AS visit_price_9, a0_.currency AS currency_10, a0_.purpose AS purpose_11, a0_.type AS type_12, a0_.new_real_state AS new_real_state_13, a0_.piece AS piece_14, a0_.surface AS surface_15, a0_.virtual_tour_id AS virtual_tour_id_16, a0_.youtube_id AS youtube_id_17, a0_.status AS status_18, a0_.payment_process_type AS payment_process_type_19, a0_.updated_at AS updated_at_20, a0_.land_document_type AS land_document_type_21, a0_.land_document_id AS land_document_id_22, a0_.priority AS priority_23, a0_.owner_id AS owner_id_24, a0_.main_advert_id AS main_advert_id_25 FROM advert a0_ INNER JOIN user u1_ ON a0_.owner_id = u1_.id AND (u1_.enabled = 1) WHERE a0_.status LIKE 'PUBLISHED' ORDER BY a0_.date DESC LIMIT 6;

SELECT t0.id AS id_1, t0.name AS name_2, t0.updated_at AS updated_at_3, t0.priority AS priority_4, t0.advert_id AS advert_id_5 FROM photo t0 WHERE t0.advert_id = ?

[
  4
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.updated_at AS updated_at_3,
  t0.priority AS priority_4,
  t0.advert_id AS advert_id_5
FROM
  photo t0
WHERE
  t0.advert_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.updated_at AS updated_at_3, t0.priority AS priority_4, t0.advert_id AS advert_id_5 FROM photo t0 WHERE t0.advert_id = 4;

SELECT c0_.id AS id_0, c0_.entry_date AS entry_date_1, c0_.exit_date AS exit_date_2, c0_.excluded_date AS excluded_date_3, c0_.value AS value_4, c0_.is_flat AS is_flat_5, c0_.is_modifier AS is_modifier_6, c0_.status AS status_7, c0_.type AS type_8, c0_.description AS description_9, c0_.owner_id AS owner_id_10, c0_.advert_id AS advert_id_11 FROM calendar c0_ WHERE c0_.advert_id = ? AND CURRENT_DATE >= c0_.entry_date AND c0_.exit_date > CURRENT_DATE AND c0_.type = ? AND c0_.status IN (?) LIMIT 1

[
  4
  "CALENDAR_SEASONAL_PRICE"
  "ENABLED"
]

SELECT
  c0_.id AS id_0,
  c0_.entry_date AS entry_date_1,
  c0_.exit_date AS exit_date_2,
  c0_.excluded_date AS excluded_date_3,
  c0_.value AS value_4,
  c0_.is_flat AS is_flat_5,
  c0_.is_modifier AS is_modifier_6,
  c0_.status AS status_7,
  c0_.type AS type_8,
  c0_.description AS description_9,
  c0_.owner_id AS owner_id_10,
  c0_.advert_id AS advert_id_11
FROM
  calendar c0_
WHERE
  c0_.advert_id = ?
  AND CURRENT_DATE >= c0_.entry_date
  AND c0_.exit_date > CURRENT_DATE
  AND c0_.type = ?
  AND c0_.status IN (?)
LIMIT
  1

SELECT c0_.id AS id_0, c0_.entry_date AS entry_date_1, c0_.exit_date AS exit_date_2, c0_.excluded_date AS excluded_date_3, c0_.value AS value_4, c0_.is_flat AS is_flat_5, c0_.is_modifier AS is_modifier_6, c0_.status AS status_7, c0_.type AS type_8, c0_.description AS description_9, c0_.owner_id AS owner_id_10, c0_.advert_id AS advert_id_11 FROM calendar c0_ WHERE c0_.advert_id = 4 AND CURRENT_DATE >= c0_.entry_date AND c0_.exit_date > CURRENT_DATE AND c0_.type = 'CALENDAR_SEASONAL_PRICE' AND c0_.status IN ('ENABLED') LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.num_value AS num_value_3, t0.bool_value AS bool_value_4, t0.string_value AS string_value_5 FROM parameter t0

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.num_value AS num_value_3,
  t0.bool_value AS bool_value_4,
  t0.string_value AS string_value_5
FROM
  parameter t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.num_value AS num_value_3, t0.bool_value AS bool_value_4, t0.string_value AS string_value_5 FROM parameter t0;

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.comment AS comment_3, t0.advert_option_item_id AS advert_option_item_id_4, t0.advert_id AS advert_id_5 FROM advert_option t0 WHERE t0.advert_id = ?

[
  4
]

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.comment AS comment_3,
  t0.advert_option_item_id AS advert_option_item_id_4,
  t0.advert_id AS advert_id_5
FROM
  advert_option t0
WHERE
  t0.advert_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.comment AS comment_3, t0.advert_option_item_id AS advert_option_item_id_4, t0.advert_id AS advert_id_5 FROM advert_option t0 WHERE t0.advert_id = 4;