Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 61
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Migrations 3
• Debug
• Messages
• Emails
• Configuration

Query Metrics

SELECT concat('CLT_', c.num_client)                 as idExterne,
                           'STRUCTURE'                                  as uo,
                           concat('PART_', p.num_part)                  as uoClient,
                           c.nom                                        as libelle,
                           concat(c.adresse, ', ', c.cp, ', ', c.ville) as adresse,
                           null                                         as lat,
                           null                                         as lng,
                           '2024-01-01'                                 as debut,
                           '2099-12-31'                                 as fin
                    FROM client c
                             LEFT JOIN partenaire_client pc ON pc.num_client = c.num_client
                             INNER JOIN partenaire p ON p.num_part = pc.num_part
                    WHERE TIMESTAMPDIFF(MINUTE, c.last_update, now()) <= :value
                                        ORDER BY c.num_client DESC

[
  "value" => 2
]

SELECT
  concat('CLT_', c.num_client) as idExterne,
  'STRUCTURE' as uo,
  concat('PART_', p.num_part) as uoClient,
  c.nom as libelle,
  concat(
    c.adresse, ', ', c.cp, ', ', c.ville
  ) as adresse,
  null as lat,
  null as lng,
  '2024-01-01' as debut,
  '2099-12-31' as fin
FROM
  client c
  LEFT JOIN partenaire_client pc ON pc.num_client = c.num_client
  INNER JOIN partenaire p ON p.num_part = pc.num_part
WHERE
  TIMESTAMPDIFF(
    MINUTE,
    c.last_update,
    now()
  ) <= :value
ORDER BY
  c.num_client DESC

SELECT concat('CLT_', c.num_client)                 as idExterne,
                           'STRUCTURE'                                  as uo,
                           concat('PART_', p.num_part)                  as uoClient,
                           c.nom                                        as libelle,
                           concat(c.adresse, ', ', c.cp, ', ', c.ville) as adresse,
                           null                                         as lat,
                           null                                         as lng,
                           '2024-01-01'                                 as debut,
                           '2099-12-31'                                 as fin
                    FROM client c
                             LEFT JOIN partenaire_client pc ON pc.num_client = c.num_client
                             INNER JOIN partenaire p ON p.num_part = pc.num_part
                    WHERE TIMESTAMPDIFF(MINUTE, c.last_update, now()) <= 2
                                        ORDER BY c.num_client DESC;