Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.nom AS nom_3, t0.description AS description_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.type_terrain AS type_terrain_7, t0.taille AS taille_8, t0.tarif_heure AS tarif_heure_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.enable AS enable_12, t0.complexe_id AS complexe_id_13 FROM terrains t0 WHERE t0.slug = ? LIMIT 1

[
  "indoor-1"
]

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.nom AS nom_3,
  t0.description AS description_4,
  t0.image_name AS image_name_5,
  t0.image_size AS image_size_6,
  t0.type_terrain AS type_terrain_7,
  t0.taille AS taille_8,
  t0.tarif_heure AS tarif_heure_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.enable AS enable_12,
  t0.complexe_id AS complexe_id_13
FROM
  terrains t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.nom AS nom_3, t0.description AS description_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.type_terrain AS type_terrain_7, t0.taille AS taille_8, t0.tarif_heure AS tarif_heure_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.enable AS enable_12, t0.complexe_id AS complexe_id_13 FROM terrains t0 WHERE t0.slug = 'indoor-1' LIMIT 1;

SELECT a0_.id AS id_0, a0_.note AS note_1, a0_.commentaire AS commentaire_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, a0_.enable AS enable_5, a0_.user_id AS user_id_6, a0_.terrain_id AS terrain_id_7 FROM avis a0_ WHERE a0_.terrain_id = ? AND a0_.enable = ? ORDER BY a0_.created_at DESC

[
  5
  1
]

SELECT
  a0_.id AS id_0,
  a0_.note AS note_1,
  a0_.commentaire AS commentaire_2,
  a0_.created_at AS created_at_3,
  a0_.updated_at AS updated_at_4,
  a0_.enable AS enable_5,
  a0_.user_id AS user_id_6,
  a0_.terrain_id AS terrain_id_7
FROM
  avis a0_
WHERE
  a0_.terrain_id = ?
  AND a0_.enable = ?
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.note AS note_1, a0_.commentaire AS commentaire_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, a0_.enable AS enable_5, a0_.user_id AS user_id_6, a0_.terrain_id AS terrain_id_7 FROM avis a0_ WHERE a0_.terrain_id = 5 AND a0_.enable = 1 ORDER BY a0_.created_at DESC;

SELECT concat(debut , " - " , fin)  as creneau
    FROM creneaux c
    CROSS JOIN complexes co
    WHERE c.debut BETWEEN co.heure_ouverture AND co.heure_fermeture - 1
    AND co.id = ?;

[
  4
]

SELECT
  concat(debut, " - ", fin) as creneau
FROM
  creneaux c CROSS
  JOIN complexes co
WHERE
  c.debut BETWEEN co.heure_ouverture
  AND co.heure_fermeture - 1
  AND co.id = ?;

SELECT concat(debut , " - " , fin)  as creneau
    FROM creneaux c
    CROSS JOIN complexes co
    WHERE c.debut BETWEEN co.heure_ouverture AND co.heure_fermeture - 1
    AND co.id = 4;
    ;

SELECT COUNT(a0_.note) AS sclr_0 FROM avis a0_ WHERE a0_.terrain_id = ?

[
  5
]

SELECT
  COUNT(a0_.note) AS sclr_0
FROM
  avis a0_
WHERE
  a0_.terrain_id = ?

SELECT COUNT(a0_.note) AS sclr_0 FROM avis a0_ WHERE a0_.terrain_id = 5;

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.description AS description_4, t0.telephone AS telephone_5, t0.ville AS ville_6, t0.heure_ouverture AS heure_ouverture_7, t0.heure_fermeture AS heure_fermeture_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.enable AS enable_11, t0.proprietaire_id AS proprietaire_id_12 FROM complexes t0 WHERE t0.id = ?

[
  4
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adresse AS adresse_3,
  t0.description AS description_4,
  t0.telephone AS telephone_5,
  t0.ville AS ville_6,
  t0.heure_ouverture AS heure_ouverture_7,
  t0.heure_fermeture AS heure_fermeture_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.enable AS enable_11,
  t0.proprietaire_id AS proprietaire_id_12
FROM
  complexes t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.description AS description_4, t0.telephone AS telephone_5, t0.ville AS ville_6, t0.heure_ouverture AS heure_ouverture_7, t0.heure_fermeture AS heure_fermeture_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.enable AS enable_11, t0.proprietaire_id AS proprietaire_id_12 FROM complexes t0 WHERE t0.id = 4;