Symfony Profiler

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

Query Metrics

SELECT empcod, empcod || ' - ' || empfan AS empfan FROM cad_empresas ORDER BY empcod ASC

[]

SELECT
  empcod,
  empcod || ' - ' || empfan AS empfan
FROM
  cad_empresas
ORDER BY
  empcod ASC

SELECT empcod, empcod || ' - ' || empfan AS empfan FROM cad_empresas ORDER BY empcod ASC;

SELECT entcod, entnom FROM ent_entidades ORDER BY entnom ASC

[]

SELECT
  entcod,
  entnom
FROM
  ent_entidades
ORDER BY
  entnom ASC

SELECT entcod, entnom FROM ent_entidades ORDER BY entnom ASC;

SELECT a.anecod, a.anedes FROM fin_areas_negocio a WHERE a.aneati =  true ORDER BY 2 ASC;

[]

SELECT
  a.anecod,
  a.anedes
FROM
  fin_areas_negocio a
WHERE
  a.aneati = true
ORDER BY
  2 ASC;

SELECT a.anecod, a.anedes FROM fin_areas_negocio a WHERE a.aneati =  true ORDER BY 2 ASC;;

SELECT g.gficod, g.gfides FROM fin_grupos_financeiros g WHERE g.gfiati =  true ORDER BY 2 ASC;

[]

SELECT
  g.gficod,
  g.gfides
FROM
  fin_grupos_financeiros g
WHERE
  g.gfiati = true
ORDER BY
  2 ASC;

SELECT g.gficod, g.gfides FROM fin_grupos_financeiros g WHERE g.gfiati =  true ORDER BY 2 ASC;;

SELECT tf.tficod, CAST(TRIM(CONCAT(s9.tfides, CASE WHEN s9.tfides IS NULL THEN '' ELSE ' => ' END, 			        s8.tfides, CASE WHEN s8.tfides IS NULL THEN '' ELSE ' => ' END, 			        s7.tfides, CASE WHEN s7.tfides IS NULL THEN '' ELSE ' => ' END, 			        s6.tfides, CASE WHEN s6.tfides IS NULL THEN '' ELSE ' => ' END, 			        s5.tfides, CASE WHEN s5.tfides IS NULL THEN '' ELSE ' => ' END, 			        s4.tfides, CASE WHEN s4.tfides IS NULL THEN '' ELSE ' => ' END, 			        s3.tfides, CASE WHEN s3.tfides IS NULL THEN '' ELSE ' => ' END, 			        s2.tfides, CASE WHEN s2.tfides IS NULL THEN '' ELSE ' => ' END, 			        s1.tfides, CASE WHEN s1.tfides IS NULL THEN '' ELSE ' => ' END, 			        s0.tfides, CASE WHEN s0.tfides IS NULL THEN '' ELSE ' => ' END, 			        tf.tfides))AS character(1000)) AS tfides FROM  fin_tipos_financeiros      tf LEFT JOIN fin_grupos_financeiros gf ON gf.gficod = tf.gficod LEFT JOIN fin_tipos_financeiros  s0 ON s0.tficod = tf.tfisub LEFT JOIN fin_tipos_financeiros  s1 ON s1.tficod = s0.tfisub LEFT JOIN fin_tipos_financeiros  s2 ON s2.tficod = s1.tfisub LEFT JOIN fin_tipos_financeiros  s3 ON s3.tficod = s2.tfisub LEFT JOIN fin_tipos_financeiros  s4 ON s4.tficod = s3.tfisub LEFT JOIN fin_tipos_financeiros  s5 ON s5.tficod = s4.tfisub LEFT JOIN fin_tipos_financeiros  s6 ON s6.tficod = s5.tfisub LEFT JOIN fin_tipos_financeiros  s7 ON s7.tficod = s6.tfisub LEFT JOIN fin_tipos_financeiros  s8 ON s8.tficod = s7.tfisub LEFT JOIN fin_tipos_financeiros  s9 ON s9.tficod = s8.tfisub WHERE 0=0   AND tf.tfitip in (0,1)   AND tf.tficom =  false   AND tf.tfiati =  true ORDER BY 2;

[]

SELECT
  tf.tficod,
  CAST(
    TRIM(
      CONCAT(
        s9.tfides, CASE WHEN s9.tfides IS NULL THEN
          ''
        ELSE
          ' => '
        END,
        s8.tfides, CASE WHEN s8.tfides IS NULL THEN
          ''
        ELSE
          ' => '
        END,
        s7.tfides, CASE WHEN s7.tfides IS NULL THEN
          ''
        ELSE
          ' => '
        END,
        s6.tfides, CASE WHEN s6.tfides IS NULL THEN
          ''
        ELSE
          ' => '
        END,
        s5.tfides, CASE WHEN s5.tfides IS NULL THEN
          ''
        ELSE
          ' => '
        END,
        s4.tfides, CASE WHEN s4.tfides IS NULL THEN
          ''
        ELSE
          ' => '
        END,
        s3.tfides, CASE WHEN s3.tfides IS NULL THEN
          ''
        ELSE
          ' => '
        END,
        s2.tfides, CASE WHEN s2.tfides IS NULL THEN
          ''
        ELSE
          ' => '
        END,
        s1.tfides, CASE WHEN s1.tfides IS NULL THEN
          ''
        ELSE
          ' => '
        END,
        s0.tfides, CASE WHEN s0.tfides IS NULL THEN
          ''
        ELSE
          ' => '
        END,
        tf.tfides
      )
    ) AS character(1000)
  ) AS tfides
FROM
  fin_tipos_financeiros tf
  LEFT JOIN fin_grupos_financeiros gf ON gf.gficod = tf.gficod
  LEFT JOIN fin_tipos_financeiros s0 ON s0.tficod = tf.tfisub
  LEFT JOIN fin_tipos_financeiros s1 ON s1.tficod = s0.tfisub
  LEFT JOIN fin_tipos_financeiros s2 ON s2.tficod = s1.tfisub
  LEFT JOIN fin_tipos_financeiros s3 ON s3.tficod = s2.tfisub
  LEFT JOIN fin_tipos_financeiros s4 ON s4.tficod = s3.tfisub
  LEFT JOIN fin_tipos_financeiros s5 ON s5.tficod = s4.tfisub
  LEFT JOIN fin_tipos_financeiros s6 ON s6.tficod = s5.tfisub
  LEFT JOIN fin_tipos_financeiros s7 ON s7.tficod = s6.tfisub
  LEFT JOIN fin_tipos_financeiros s8 ON s8.tficod = s7.tfisub
  LEFT JOIN fin_tipos_financeiros s9 ON s9.tficod = s8.tfisub
WHERE
  0 = 0
  AND tf.tfitip in (0, 1)
  AND tf.tficom = false
  AND tf.tfiati = true
ORDER BY
  2;

SELECT tf.tficod, CAST(TRIM(CONCAT(s9.tfides, CASE WHEN s9.tfides IS NULL THEN '' ELSE ' => ' END, 			        s8.tfides, CASE WHEN s8.tfides IS NULL THEN '' ELSE ' => ' END, 			        s7.tfides, CASE WHEN s7.tfides IS NULL THEN '' ELSE ' => ' END, 			        s6.tfides, CASE WHEN s6.tfides IS NULL THEN '' ELSE ' => ' END, 			        s5.tfides, CASE WHEN s5.tfides IS NULL THEN '' ELSE ' => ' END, 			        s4.tfides, CASE WHEN s4.tfides IS NULL THEN '' ELSE ' => ' END, 			        s3.tfides, CASE WHEN s3.tfides IS NULL THEN '' ELSE ' => ' END, 			        s2.tfides, CASE WHEN s2.tfides IS NULL THEN '' ELSE ' => ' END, 			        s1.tfides, CASE WHEN s1.tfides IS NULL THEN '' ELSE ' => ' END, 			        s0.tfides, CASE WHEN s0.tfides IS NULL THEN '' ELSE ' => ' END, 			        tf.tfides))AS character(1000)) AS tfides FROM  fin_tipos_financeiros      tf LEFT JOIN fin_grupos_financeiros gf ON gf.gficod = tf.gficod LEFT JOIN fin_tipos_financeiros  s0 ON s0.tficod = tf.tfisub LEFT JOIN fin_tipos_financeiros  s1 ON s1.tficod = s0.tfisub LEFT JOIN fin_tipos_financeiros  s2 ON s2.tficod = s1.tfisub LEFT JOIN fin_tipos_financeiros  s3 ON s3.tficod = s2.tfisub LEFT JOIN fin_tipos_financeiros  s4 ON s4.tficod = s3.tfisub LEFT JOIN fin_tipos_financeiros  s5 ON s5.tficod = s4.tfisub LEFT JOIN fin_tipos_financeiros  s6 ON s6.tficod = s5.tfisub LEFT JOIN fin_tipos_financeiros  s7 ON s7.tficod = s6.tfisub LEFT JOIN fin_tipos_financeiros  s8 ON s8.tficod = s7.tfisub LEFT JOIN fin_tipos_financeiros  s9 ON s9.tficod = s8.tfisub WHERE 0=0   AND tf.tfitip in (0,1)   AND tf.tficom =  false   AND tf.tfiati =  true ORDER BY 2;;