Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 330
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• PHPCR
• Debug
• Messages
• Emails
• Serializer
• JMS Serializer 0 + 0
• Sulu
• Configuration

Query Metrics

SELECT b0_.id AS id_0, b0_.reference AS reference_1, b0_.enabled AS enabled_2, b0_.approved AS approved_3, b0_.approval_pending AS approval_pending_4, b0_.latitude AS latitude_5, b0_.longitude AS longitude_6, b0_.price AS price_7, b0_.currency AS currency_8, b0_.zip AS zip_9, b0_.surface AS surface_10, b0_.divisible_surface AS divisible_surface_11, b0_.high AS high_12, b0_.availability AS availability_13, b0_.created_at AS created_at_14, b0_.updated_at AS updated_at_15, b0_.brochure AS brochure_16, b0_.visit_link AS visit_link_17, b0_.unemployment AS unemployment_18, b0_.area AS area_19, b0_.population AS population_20, b0_.geometry AS geometry_21, b0_.construction_year AS construction_year_22, b0_.offices_surface AS offices_surface_23, b0_.etat AS etat_24, b0_.transaction AS transaction_25, b0_.rent_price AS rent_price_26, b0_.price_on_demand AS price_on_demand_27, b0_.charge AS charge_28, b0_.tax AS tax_29, b0_.divisible AS divisible_30, b0_.created_by AS created_by_31, b0_.rent_price_on_demand AS rent_price_on_demand_32, b0_.contact_person_uuid AS contact_person_uuid_33, b0_.created_from AS created_from_34, b0_.included_charges AS included_charges_35, b0_.owner_id AS owner_id_36, b0_.owner_contact_id AS owner_contact_id_37, b0_.member_contact_id AS member_contact_id_38 FROM bien b0_ INNER JOIN bien_translation b1_ ON b0_.id = b1_.bien_id LEFT JOIN category c2_ ON b0_.id = c2_.bien_id LEFT JOIN icpe i3_ ON c2_.icpe_id = i3_.id WHERE b1_.locale = ? AND b0_.enabled = ? AND b0_.transaction LIKE ? AND ((b0_.visit_link IS NOT NULL AND CHAR_LENGTH(TRIM(b0_.visit_link)) > 0)) ORDER BY CASE WHEN b0_.availability = 'Available' THEN 0 ELSE 1 END ASC, RAND() ASC

[
  "fr"
  1
  "%"buy"%"
]

SELECT
  b0_.id AS id_0,
  b0_.reference AS reference_1,
  b0_.enabled AS enabled_2,
  b0_.approved AS approved_3,
  b0_.approval_pending AS approval_pending_4,
  b0_.latitude AS latitude_5,
  b0_.longitude AS longitude_6,
  b0_.price AS price_7,
  b0_.currency AS currency_8,
  b0_.zip AS zip_9,
  b0_.surface AS surface_10,
  b0_.divisible_surface AS divisible_surface_11,
  b0_.high AS high_12,
  b0_.availability AS availability_13,
  b0_.created_at AS created_at_14,
  b0_.updated_at AS updated_at_15,
  b0_.brochure AS brochure_16,
  b0_.visit_link AS visit_link_17,
  b0_.unemployment AS unemployment_18,
  b0_.area AS area_19,
  b0_.population AS population_20,
  b0_.geometry AS geometry_21,
  b0_.construction_year AS construction_year_22,
  b0_.offices_surface AS offices_surface_23,
  b0_.etat AS etat_24,
  b0_.transaction AS transaction_25,
  b0_.rent_price AS rent_price_26,
  b0_.price_on_demand AS price_on_demand_27,
  b0_.charge AS charge_28,
  b0_.tax AS tax_29,
  b0_.divisible AS divisible_30,
  b0_.created_by AS created_by_31,
  b0_.rent_price_on_demand AS rent_price_on_demand_32,
  b0_.contact_person_uuid AS contact_person_uuid_33,
  b0_.created_from AS created_from_34,
  b0_.included_charges AS included_charges_35,
  b0_.owner_id AS owner_id_36,
  b0_.owner_contact_id AS owner_contact_id_37,
  b0_.member_contact_id AS member_contact_id_38
FROM
  bien b0_
  INNER JOIN bien_translation b1_ ON b0_.id = b1_.bien_id
  LEFT JOIN category c2_ ON b0_.id = c2_.bien_id
  LEFT JOIN icpe i3_ ON c2_.icpe_id = i3_.id
WHERE
  b1_.locale = ?
  AND b0_.enabled = ?
  AND b0_.transaction LIKE ?
  AND (
    (
      b0_.visit_link IS NOT NULL
      AND CHAR_LENGTH(
        TRIM(b0_.visit_link)
      ) > 0
    )
  )
ORDER BY
  CASE WHEN b0_.availability = 'Available' THEN
    0
  ELSE
    1
  END ASC,
  RAND() ASC

SELECT b0_.id AS id_0, b0_.reference AS reference_1, b0_.enabled AS enabled_2, b0_.approved AS approved_3, b0_.approval_pending AS approval_pending_4, b0_.latitude AS latitude_5, b0_.longitude AS longitude_6, b0_.price AS price_7, b0_.currency AS currency_8, b0_.zip AS zip_9, b0_.surface AS surface_10, b0_.divisible_surface AS divisible_surface_11, b0_.high AS high_12, b0_.availability AS availability_13, b0_.created_at AS created_at_14, b0_.updated_at AS updated_at_15, b0_.brochure AS brochure_16, b0_.visit_link AS visit_link_17, b0_.unemployment AS unemployment_18, b0_.area AS area_19, b0_.population AS population_20, b0_.geometry AS geometry_21, b0_.construction_year AS construction_year_22, b0_.offices_surface AS offices_surface_23, b0_.etat AS etat_24, b0_.transaction AS transaction_25, b0_.rent_price AS rent_price_26, b0_.price_on_demand AS price_on_demand_27, b0_.charge AS charge_28, b0_.tax AS tax_29, b0_.divisible AS divisible_30, b0_.created_by AS created_by_31, b0_.rent_price_on_demand AS rent_price_on_demand_32, b0_.contact_person_uuid AS contact_person_uuid_33, b0_.created_from AS created_from_34, b0_.included_charges AS included_charges_35, b0_.owner_id AS owner_id_36, b0_.owner_contact_id AS owner_contact_id_37, b0_.member_contact_id AS member_contact_id_38 FROM bien b0_ INNER JOIN bien_translation b1_ ON b0_.id = b1_.bien_id LEFT JOIN category c2_ ON b0_.id = c2_.bien_id LEFT JOIN icpe i3_ ON c2_.icpe_id = i3_.id WHERE b1_.locale = 'fr' AND b0_.enabled = 1 AND b0_.transaction LIKE '%\"buy\"%' AND ((b0_.visit_link IS NOT NULL AND CHAR_LENGTH(TRIM(b0_.visit_link)) > 0)) ORDER BY CASE WHEN b0_.availability = 'Available' THEN 0 ELSE 1 END ASC, RAND() ASC;