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('CTC_', u.num_util)                      as idExterne,
                       'M'                                             as civilite,
                       concat('CLT_', c.num_client)                    as contratIdExterne,
                       u.nom                                           as nom,
                       IFNULL(u.prenom, '-')                           as prenom,
                       replace(replace(u.telephone, ' ', ''), '.', '') as telephone,
                       IFNULL(u.mail, 'no-mail@mail.com')              as email,
                       IFNULL(u.fonction, 'Gestionnaire')              as fonction,
                       1                                               as isActive
                FROM utilisateur u
                         INNER JOIN client c
                WHERE u.num_client = c.num_client
                    AND TIMESTAMPDIFF(MINUTE, u.last_update, now()) <= :value
                    ORDER BY u.num_util DESC

[
  "value" => 2
]

SELECT
  concat('CTC_', u.num_util) as idExterne,
  'M' as civilite,
  concat('CLT_', c.num_client) as contratIdExterne,
  u.nom as nom,
  IFNULL(u.prenom, '-') as prenom,
  replace(
    replace(u.telephone, ' ', ''),
    '.',
    ''
  ) as telephone,
  IFNULL(u.mail, 'no-mail@mail.com') as email,
  IFNULL(u.fonction, 'Gestionnaire') as fonction,
  1 as isActive
FROM
  utilisateur u
  INNER JOIN client c
WHERE
  u.num_client = c.num_client
  AND TIMESTAMPDIFF(
    MINUTE,
    u.last_update,
    now()
  ) <= :value
ORDER BY
  u.num_util DESC

SELECT concat('CTC_', u.num_util)                      as idExterne,
                       'M'                                             as civilite,
                       concat('CLT_', c.num_client)                    as contratIdExterne,
                       u.nom                                           as nom,
                       IFNULL(u.prenom, '-')                           as prenom,
                       replace(replace(u.telephone, ' ', ''), '.', '') as telephone,
                       IFNULL(u.mail, 'no-mail@mail.com')              as email,
                       IFNULL(u.fonction, 'Gestionnaire')              as fonction,
                       1                                               as isActive
                FROM utilisateur u
                         INNER JOIN client c
                WHERE u.num_client = c.num_client
                    AND TIMESTAMPDIFF(MINUTE, u.last_update, now()) <= 2
                    ORDER BY u.num_util DESC;