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 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 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.7434582)) * COS(RADIANS(a0_.address_lat)) * COS(RADIANS(a0_.address_lng) - RADIANS(-17.5116542)) + SIN(RADIANS(14.7434582)) * 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.7434582)
      ) * COS(
        RADIANS(a0_.address_lat)
      ) * COS(
        RADIANS(a0_.address_lng) - RADIANS(-17.5116542)
      ) + SIN(
        RADIANS(14.7434582)
      ) * 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.7434582)) * COS(RADIANS(a0_.address_lat)) * COS(RADIANS(a0_.address_lng) - RADIANS(-17.5116542)) + SIN(RADIANS(14.7434582)) * 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 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;