Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 3
• Events
• Routing
• Cache
• Security
• Twig
• Doctrine
• Configuration

Query Metrics

SELECT v.immatriculation, t.badge_id, v.modele, t.recorded_at AS dateEntree, COALESCE(a.nom, 'Inconnue') AS provenance, b_prev.serial AS provenance_box_serial FROM ( SELECT j.*, ROW_NUMBER() OVER (PARTITION BY j.badge_id ORDER BY j.recorded_at DESC, j.id DESC) AS rn, LAG(j.box_serial) OVER (PARTITION BY j.badge_id ORDER BY j.recorded_at, j.id) AS prev_box_serial FROM journal j ) t JOIN vehicule v ON v.badge_id = t.badge_id LEFT JOIN boite b_prev ON b_prev.serial = t.prev_box_serial LEFT JOIN agence a ON a.id = b_prev.agence_id WHERE t.rn = 1 AND t.box_serial = ? AND t.type = ? ORDER BY dateEntree DESC

[
  "5&D0F69D0&0&1"
  "entrée"
]

SELECT
  v.immatriculation,
  t.badge_id,
  v.modele,
  t.recorded_at AS dateEntree,
  COALESCE(a.nom, 'Inconnue') AS provenance,
  b_prev.serial AS provenance_box_serial
FROM
  (
    SELECT
      j.*,
      ROW_NUMBER() OVER (
        PARTITION BY
          j.badge_id
        ORDER BY
          j.recorded_at DESC,
          j.id DESC
      ) AS rn,
      LAG(j.box_serial) OVER (
        PARTITION BY
          j.badge_id
        ORDER BY
          j.recorded_at,
          j.id
      ) AS prev_box_serial
    FROM
      journal j
  ) t
  JOIN vehicule v ON v.badge_id = t.badge_id
  LEFT JOIN boite b_prev ON b_prev.serial = t.prev_box_serial
  LEFT JOIN agence a ON a.id = b_prev.agence_id
WHERE
  t.rn = 1
  AND t.box_serial = ?
  AND t.type = ?
ORDER BY
  dateEntree DESC

SELECT v.immatriculation, t.badge_id, v.modele, t.recorded_at AS dateEntree, COALESCE(a.nom, 'Inconnue') AS provenance, b_prev.serial AS provenance_box_serial FROM ( SELECT j.*, ROW_NUMBER() OVER (PARTITION BY j.badge_id ORDER BY j.recorded_at DESC, j.id DESC) AS rn, LAG(j.box_serial) OVER (PARTITION BY j.badge_id ORDER BY j.recorded_at, j.id) AS prev_box_serial FROM journal j ) t JOIN vehicule v ON v.badge_id = t.badge_id LEFT JOIN boite b_prev ON b_prev.serial = t.prev_box_serial LEFT JOIN agence a ON a.id = b_prev.agence_id WHERE t.rn = 1 AND t.box_serial = '5&D0F69D0&0&1' AND t.type = 'entrée' ORDER BY dateEntree DESC;

SELECT v.immatriculation, t.badge_id, v.modele, t.recorded_at AS dateMouvement, t.type AS mouvement_type, COALESCE(a.nom, 'Inconnue') AS provenance, t.prev_box_serial AS provenance_box_serial FROM ( SELECT j.*, LAG(j.box_serial) OVER (PARTITION BY j.badge_id ORDER BY j.recorded_at, j.id) AS prev_box_serial FROM journal j ) t JOIN vehicule v ON v.badge_id = t.badge_id LEFT JOIN boite b_prev ON b_prev.serial = t.prev_box_serial LEFT JOIN agence a ON a.id = b_prev.agence_id WHERE t.box_serial = ? ORDER BY dateMouvement DESC

[
  "5&D0F69D0&0&1"
]

SELECT
  v.immatriculation,
  t.badge_id,
  v.modele,
  t.recorded_at AS dateMouvement,
  t.type AS mouvement_type,
  COALESCE(a.nom, 'Inconnue') AS provenance,
  t.prev_box_serial AS provenance_box_serial
FROM
  (
    SELECT
      j.*,
      LAG(j.box_serial) OVER (
        PARTITION BY
          j.badge_id
        ORDER BY
          j.recorded_at,
          j.id
      ) AS prev_box_serial
    FROM
      journal j
  ) t
  JOIN vehicule v ON v.badge_id = t.badge_id
  LEFT JOIN boite b_prev ON b_prev.serial = t.prev_box_serial
  LEFT JOIN agence a ON a.id = b_prev.agence_id
WHERE
  t.box_serial = ?
ORDER BY
  dateMouvement DESC

SELECT v.immatriculation, t.badge_id, v.modele, t.recorded_at AS dateMouvement, t.type AS mouvement_type, COALESCE(a.nom, 'Inconnue') AS provenance, t.prev_box_serial AS provenance_box_serial FROM ( SELECT j.*, LAG(j.box_serial) OVER (PARTITION BY j.badge_id ORDER BY j.recorded_at, j.id) AS prev_box_serial FROM journal j ) t JOIN vehicule v ON v.badge_id = t.badge_id LEFT JOIN boite b_prev ON b_prev.serial = t.prev_box_serial LEFT JOIN agence a ON a.id = b_prev.agence_id WHERE t.box_serial = '5&D0F69D0&0&1' ORDER BY dateMouvement DESC;

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.prenom AS prenom_4, t0.nom AS nom_5, t0.is_verified AS is_verified_6, t0.agence_id AS agence_id_7 FROM user t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.prenom AS prenom_4,
  t0.nom AS nom_5,
  t0.is_verified AS is_verified_6,
  t0.agence_id AS agence_id_7
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.prenom AS prenom_4, t0.nom AS nom_5, t0.is_verified AS is_verified_6, t0.agence_id AS agence_id_7 FROM user t0 WHERE t0.id = 1;

SELECT t0.id AS id_1, t0.serial AS serial_2, t0.nom AS nom_3, t0.emplacement_physique AS emplacement_physique_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.agence_id AS agence_id_8 FROM boite t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.serial AS serial_2,
  t0.nom AS nom_3,
  t0.emplacement_physique AS emplacement_physique_4,
  t0.statut AS statut_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.agence_id AS agence_id_8
FROM
  boite t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.serial AS serial_2, t0.nom AS nom_3, t0.emplacement_physique AS emplacement_physique_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.agence_id AS agence_id_8 FROM boite t0 WHERE t0.id = 2;