Symfony Profiler

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

Query Metrics

SELECT DISTINCT titre,
    regexp_replace(regexp_replace(LOWER(unaccent(titre)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS titre_formate
FROM document
ORDER BY titre_formate ASC

[]

SELECT
  DISTINCT titre,
  regexp_replace(
    regexp_replace(
      LOWER(
        unaccent(titre)
      ),
      '[[:punct:]]',
      '',
      'g'
    ),
    '^\s+',
    '',
    'g'
  ) AS titre_formate
FROM
  document
ORDER BY
  titre_formate ASC

SELECT DISTINCT titre,
    regexp_replace(regexp_replace(LOWER(unaccent(titre)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS titre_formate
FROM document
ORDER BY titre_formate ASC;

SELECT
id,
CONCAT(prenom,' ',nom) AS identite,
regexp_replace(regexp_replace(LOWER(unaccent(CONCAT(prenom,' ',nom))), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS identite_formate
FROM personne
ORDER BY nom ASC, prenom ASC

[]

SELECT
  id,
  CONCAT(prenom, ' ', nom) AS identite,
  regexp_replace(
    regexp_replace(
      LOWER(
        unaccent(
          CONCAT(prenom, ' ', nom)
        )
      ),
      '[[:punct:]]',
      '',
      'g'
    ),
    '^\s+',
    '',
    'g'
  ) AS identite_formate
FROM
  personne
ORDER BY
  nom ASC,
  prenom ASC

SELECT
id,
CONCAT(prenom,' ',nom) AS identite,
regexp_replace(regexp_replace(LOWER(unaccent(CONCAT(prenom,' ',nom))), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS identite_formate
FROM personne
ORDER BY nom ASC, prenom ASC;

SELECT 
id,
libelle_fr,
libelle_en,
regexp_replace(regexp_replace(LOWER(unaccent(libelle_fr)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS libelle_fr_formate,
regexp_replace(regexp_replace(LOWER(unaccent(libelle_en)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS libelle_en_formate
FROM mot_cle
ORDER BY libelle_fr_formate

[]

SELECT
  id,
  libelle_fr,
  libelle_en,
  regexp_replace(
    regexp_replace(
      LOWER(
        unaccent(libelle_fr)
      ),
      '[[:punct:]]',
      '',
      'g'
    ),
    '^\s+',
    '',
    'g'
  ) AS libelle_fr_formate,
  regexp_replace(
    regexp_replace(
      LOWER(
        unaccent(libelle_en)
      ),
      '[[:punct:]]',
      '',
      'g'
    ),
    '^\s+',
    '',
    'g'
  ) AS libelle_en_formate
FROM
  mot_cle
ORDER BY
  libelle_fr_formate

SELECT 
id,
libelle_fr,
libelle_en,
regexp_replace(regexp_replace(LOWER(unaccent(libelle_fr)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS libelle_fr_formate,
regexp_replace(regexp_replace(LOWER(unaccent(libelle_en)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS libelle_en_formate
FROM mot_cle
ORDER BY libelle_fr_formate;

SELECT mc.id, mc.libelle_fr, mc.libelle_en, (
    SELECT COUNT(dmc.motcle_id)
    FROM document_mot_cle dmc
    WHERE dmc.motcle_id = mc.id) AS count
FROM mot_cle mc
ORDER BY count DESC
LIMIT 50

[]

SELECT
  mc.id,
  mc.libelle_fr,
  mc.libelle_en,
  (
    SELECT
      COUNT(dmc.motcle_id)
    FROM
      document_mot_cle dmc
    WHERE
      dmc.motcle_id = mc.id
  ) AS count
FROM
  mot_cle mc
ORDER BY
  count DESC
LIMIT
  50

SELECT mc.id, mc.libelle_fr, mc.libelle_en, (
    SELECT COUNT(dmc.motcle_id)
    FROM document_mot_cle dmc
    WHERE dmc.motcle_id = mc.id) AS count
FROM mot_cle mc
ORDER BY count DESC
LIMIT 50;