Symfony Profiler

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

Query Metrics

SELECT t0_.clave AS clave_0, t0_.persona AS persona_1, t0_.cargo AS cargo_2, t0_.web AS web_3, t1_.texto AS texto_4, c2_.nombre AS nombre_5, c2_.localidad AS localidad_6, p3_.nombre AS nombre_7, p4_.nombreEn AS nombreEn_8, c5_.nombre AS nombre_9 FROM testimonios__datos t0_ INNER JOIN testimonios__texto t1_ ON (t0_.clave = t1_.testimonio AND t1_.idioma = ?) INNER JOIN centros c2_ ON (t0_.centro = c2_.clave) INNER JOIN paises p4_ ON (p4_.clave = c2_.pais) LEFT JOIN testimonios__datos t6_ ON (t0_.centro = t6_.centro AND t0_.clave < t6_.clave) LEFT JOIN provincias p3_ ON (p3_.clave = c2_.provincia) LEFT JOIN comunidades c5_ ON (p3_.comunidad = c5_.clave) WHERE t6_.clave IS NULL AND t0_.verificado = 1 AND t0_.publicado = 1 AND t0_.consentimiento = 1 ORDER BY nombreEn_8 ASC, c5_.nombre ASC, p3_.nombre ASC, c2_.localidad ASC

[
  "en"
]

SELECT
  t0_.clave AS clave_0,
  t0_.persona AS persona_1,
  t0_.cargo AS cargo_2,
  t0_.web AS web_3,
  t1_.texto AS texto_4,
  c2_.nombre AS nombre_5,
  c2_.localidad AS localidad_6,
  p3_.nombre AS nombre_7,
  p4_.nombreEn AS nombreEn_8,
  c5_.nombre AS nombre_9
FROM
  testimonios__datos t0_
  INNER JOIN testimonios__texto t1_ ON (
    t0_.clave = t1_.testimonio
    AND t1_.idioma = ?
  )
  INNER JOIN centros c2_ ON (t0_.centro = c2_.clave)
  INNER JOIN paises p4_ ON (p4_.clave = c2_.pais)
  LEFT JOIN testimonios__datos t6_ ON (
    t0_.centro = t6_.centro
    AND t0_.clave < t6_.clave
  )
  LEFT JOIN provincias p3_ ON (p3_.clave = c2_.provincia)
  LEFT JOIN comunidades c5_ ON (p3_.comunidad = c5_.clave)
WHERE
  t6_.clave IS NULL
  AND t0_.verificado = 1
  AND t0_.publicado = 1
  AND t0_.consentimiento = 1
ORDER BY
  nombreEn_8 ASC,
  c5_.nombre ASC,
  p3_.nombre ASC,
  c2_.localidad ASC

SELECT t0_.clave AS clave_0, t0_.persona AS persona_1, t0_.cargo AS cargo_2, t0_.web AS web_3, t1_.texto AS texto_4, c2_.nombre AS nombre_5, c2_.localidad AS localidad_6, p3_.nombre AS nombre_7, p4_.nombreEn AS nombreEn_8, c5_.nombre AS nombre_9 FROM testimonios__datos t0_ INNER JOIN testimonios__texto t1_ ON (t0_.clave = t1_.testimonio AND t1_.idioma = 'en') INNER JOIN centros c2_ ON (t0_.centro = c2_.clave) INNER JOIN paises p4_ ON (p4_.clave = c2_.pais) LEFT JOIN testimonios__datos t6_ ON (t0_.centro = t6_.centro AND t0_.clave < t6_.clave) LEFT JOIN provincias p3_ ON (p3_.clave = c2_.provincia) LEFT JOIN comunidades c5_ ON (p3_.comunidad = c5_.clave) WHERE t6_.clave IS NULL AND t0_.verificado = 1 AND t0_.publicado = 1 AND t0_.consentimiento = 1 ORDER BY nombreEn_8 ASC, c5_.nombre ASC, p3_.nombre ASC, c2_.localidad ASC;