Symfony Profiler

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

Query Metrics

SELECT count(DISTINCT m0_.id) AS sclr_0 FROM maison m0_ WHERE m0_.sold = ? AND m0_.is_visible = ?

[
  0
  1
]

SELECT
  count(DISTINCT m0_.id) AS sclr_0
FROM
  maison m0_
WHERE
  m0_.sold = ?
  AND m0_.is_visible = ?

SELECT count(DISTINCT m0_.id) AS sclr_0 FROM maison m0_ WHERE m0_.sold = 0 AND m0_.is_visible = 1;

SELECT DISTINCT m0_.id AS id_0 FROM maison m0_ WHERE m0_.sold = ? AND m0_.is_visible = ? LIMIT 12

[
  0
  1
]

SELECT
  DISTINCT m0_.id AS id_0
FROM
  maison m0_
WHERE
  m0_.sold = ?
  AND m0_.is_visible = ?
LIMIT
  12

SELECT DISTINCT m0_.id AS id_0 FROM maison m0_ WHERE m0_.sold = 0 AND m0_.is_visible = 1 LIMIT 12;

SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.adresse AS adresse_2, m0_.dimension AS dimension_3, m0_.loyer AS loyer_4, m0_.typelectrification AS typelectrification_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7, m0_.description AS description_8, m0_.piece AS piece_9, m0_.bedrooms AS bedrooms_10, m0_.sold AS sold_11, m0_.garage AS garage_12, m0_.devise AS devise_13, m0_.is_visible AS is_visible_14, m0_.utilisateur_id AS utilisateur_id_15, m0_.type_id AS type_id_16 FROM maison m0_ WHERE m0_.sold = ? AND m0_.is_visible = ? AND m0_.id IN (?)

[
  0
  1
  1
]

SELECT
  m0_.id AS id_0,
  m0_.titre AS titre_1,
  m0_.adresse AS adresse_2,
  m0_.dimension AS dimension_3,
  m0_.loyer AS loyer_4,
  m0_.typelectrification AS typelectrification_5,
  m0_.created_at AS created_at_6,
  m0_.updated_at AS updated_at_7,
  m0_.description AS description_8,
  m0_.piece AS piece_9,
  m0_.bedrooms AS bedrooms_10,
  m0_.sold AS sold_11,
  m0_.garage AS garage_12,
  m0_.devise AS devise_13,
  m0_.is_visible AS is_visible_14,
  m0_.utilisateur_id AS utilisateur_id_15,
  m0_.type_id AS type_id_16
FROM
  maison m0_
WHERE
  m0_.sold = ?
  AND m0_.is_visible = ?
  AND m0_.id IN (?)

SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.adresse AS adresse_2, m0_.dimension AS dimension_3, m0_.loyer AS loyer_4, m0_.typelectrification AS typelectrification_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7, m0_.description AS description_8, m0_.piece AS piece_9, m0_.bedrooms AS bedrooms_10, m0_.sold AS sold_11, m0_.garage AS garage_12, m0_.devise AS devise_13, m0_.is_visible AS is_visible_14, m0_.utilisateur_id AS utilisateur_id_15, m0_.type_id AS type_id_16 FROM maison m0_ WHERE m0_.sold = 0 AND m0_.is_visible = 1 AND m0_.id IN (1);

SELECT t0_.id AS id_0, t0_.nom AS nom_1 FROM type t0_

[]

SELECT
  t0_.id AS id_0,
  t0_.nom AS nom_1
FROM
  type t0_

SELECT t0_.id AS id_0, t0_.nom AS nom_1 FROM type t0_;

SELECT o0_.id AS id_0, o0_.name AS name_1 FROM `option` o0_

[]

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1
FROM
  `option` o0_

SELECT o0_.id AS id_0, o0_.name AS name_1 FROM `option` o0_;

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM type t0

[]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  type t0

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM type t0;

SELECT t0.id AS id_1, t0.image AS image_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.maison_id AS maison_id_5 FROM images_maison t0 WHERE t0.maison_id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.maison_id AS maison_id_5
FROM
  images_maison t0
WHERE
  t0.maison_id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.maison_id AS maison_id_5 FROM images_maison t0 WHERE t0.maison_id = 1;