Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms 1
• Exception
• Logs 39
• Events
• Routing
• Cache
• Translation 41
• 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, (6371 * ACOS(COS(RADIANS(14.716677)) * COS(RADIANS(a0_.address_lat)) * COS(RADIANS(a0_.address_lng) - RADIANS(-17.4676861)) + SIN(RADIANS(14.716677)) * SIN(RADIANS(a0_.address_lat)))) AS sclr_24, a0_.owner_id AS owner_id_25, a0_.main_advert_id AS main_advert_id_26 FROM advert a0_ INNER JOIN user u1_ ON a0_.owner_id = u1_.id AND (u1_.enabled = 1) WHERE a0_.status IN (?) HAVING sclr_24 <= ? OR sclr_24 IS NULL ORDER BY a0_.date DESC

[
  "PUBLISHED"
  5
]

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,
  (
    6371 * ACOS(
      COS(
        RADIANS(14.716677)
      ) * COS(
        RADIANS(a0_.address_lat)
      ) * COS(
        RADIANS(a0_.address_lng) - RADIANS(-17.4676861)
      ) + SIN(
        RADIANS(14.716677)
      ) * SIN(
        RADIANS(a0_.address_lat)
      )
    )
  ) AS sclr_24,
  a0_.owner_id AS owner_id_25,
  a0_.main_advert_id AS main_advert_id_26
FROM
  advert a0_
  INNER JOIN user u1_ ON a0_.owner_id = u1_.id
  AND (u1_.enabled = 1)
WHERE
  a0_.status IN (?)
HAVING
  sclr_24 <= ?
  OR sclr_24 IS NULL
ORDER BY
  a0_.date DESC

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, (6371 * ACOS(COS(RADIANS(14.716677)) * COS(RADIANS(a0_.address_lat)) * COS(RADIANS(a0_.address_lng) - RADIANS(-17.4676861)) + SIN(RADIANS(14.716677)) * SIN(RADIANS(a0_.address_lat)))) AS sclr_24, a0_.owner_id AS owner_id_25, a0_.main_advert_id AS main_advert_id_26 FROM advert a0_ INNER JOIN user u1_ ON a0_.owner_id = u1_.id AND (u1_.enabled = 1) WHERE a0_.status IN ('PUBLISHED') HAVING sclr_24 <= 5 OR sclr_24 IS NULL ORDER BY a0_.date DESC;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.entry_date AS entry_date_2, c0_.exit_date AS exit_date_3, c0_.reduction AS reduction_4, c0_.promo_code AS promo_code_5, c0_.agency_id AS agency_id_6, c0_.advert_id AS advert_id_7 FROM campagne c0_ WHERE (c0_.advert_id = ? OR (c0_.agency_id = ? AND c0_.advert_id IS NULL)) AND c0_.entry_date < CURRENT_TIMESTAMP AND c0_.exit_date > CURRENT_TIMESTAMP ORDER BY c0_.entry_date ASC

[
  4
  10036
]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.entry_date AS entry_date_2,
  c0_.exit_date AS exit_date_3,
  c0_.reduction AS reduction_4,
  c0_.promo_code AS promo_code_5,
  c0_.agency_id AS agency_id_6,
  c0_.advert_id AS advert_id_7
FROM
  campagne c0_
WHERE
  (
    c0_.advert_id = ?
    OR (
      c0_.agency_id = ?
      AND c0_.advert_id IS NULL
    )
  )
  AND c0_.entry_date < CURRENT_TIMESTAMP
  AND c0_.exit_date > CURRENT_TIMESTAMP
ORDER BY
  c0_.entry_date ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.entry_date AS entry_date_2, c0_.exit_date AS exit_date_3, c0_.reduction AS reduction_4, c0_.promo_code AS promo_code_5, c0_.agency_id AS agency_id_6, c0_.advert_id AS advert_id_7 FROM campagne c0_ WHERE (c0_.advert_id = 4 OR (c0_.agency_id = 10036 AND c0_.advert_id IS NULL)) AND c0_.entry_date < CURRENT_TIMESTAMP AND c0_.exit_date > CURRENT_TIMESTAMP ORDER BY c0_.entry_date ASC;

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.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 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 a0_.id AS id_0, a0_.date_debut AS date_debut_1, a0_.date_fin AS date_fin_2, a0_.active AS active_3, a0_.type AS type_4, a0_.advert_id AS advert_id_5 FROM ala_une a0_ INNER JOIN advert a1_ ON a0_.advert_id = a1_.id AND (a1_.status LIKE ?) INNER JOIN user u2_ ON a1_.owner_id = u2_.id AND (u2_.enabled = 1) WHERE a0_.active = 1 AND a0_.type = 'search' LIMIT 4

[
  "PUBLISHED"
]

SELECT
  a0_.id AS id_0,
  a0_.date_debut AS date_debut_1,
  a0_.date_fin AS date_fin_2,
  a0_.active AS active_3,
  a0_.type AS type_4,
  a0_.advert_id AS advert_id_5
FROM
  ala_une a0_
  INNER JOIN advert a1_ ON a0_.advert_id = a1_.id
  AND (a1_.status LIKE ?)
  INNER JOIN user u2_ ON a1_.owner_id = u2_.id
  AND (u2_.enabled = 1)
WHERE
  a0_.active = 1
  AND a0_.type = 'search'
LIMIT
  4

SELECT a0_.id AS id_0, a0_.date_debut AS date_debut_1, a0_.date_fin AS date_fin_2, a0_.active AS active_3, a0_.type AS type_4, a0_.advert_id AS advert_id_5 FROM ala_une a0_ INNER JOIN advert a1_ ON a0_.advert_id = a1_.id AND (a1_.status LIKE 'PUBLISHED') INNER JOIN user u2_ ON a1_.owner_id = u2_.id AND (u2_.enabled = 1) WHERE a0_.active = 1 AND a0_.type = 'search' LIMIT 4;