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 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;

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;