Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 2
• 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, t0_.fecharegistro AS fecharegistro_4, t1_.texto AS texto_5, c2_.nombre AS nombre_6, c2_.localidad AS localidad_7, p3_.clave AS clave_8, p4_.nombre AS nombre_9, p3_.nombreEn AS nombreEn_10, c5_.nombre AS nombre_11 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 p3_ ON (p3_.clave = c2_.pais) LEFT JOIN testimonios__datos t6_ ON (t0_.centro = t6_.centro AND t0_.clave < t6_.clave) LEFT JOIN provincias p4_ ON (p4_.clave = c2_.provincia) LEFT JOIN comunidades c5_ ON (p4_.comunidad = c5_.clave) WHERE t6_.clave IS NULL AND t0_.verificado = 1 AND t0_.publicado = 1 AND t0_.consentimiento = 1 ORDER BY nombreEn_10 ASC, c5_.nombre ASC, t0_.fecharegistro DESC, p4_.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,
  t0_.fecharegistro AS fecharegistro_4,
  t1_.texto AS texto_5,
  c2_.nombre AS nombre_6,
  c2_.localidad AS localidad_7,
  p3_.clave AS clave_8,
  p4_.nombre AS nombre_9,
  p3_.nombreEn AS nombreEn_10,
  c5_.nombre AS nombre_11
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 p3_ ON (p3_.clave = c2_.pais)
  LEFT JOIN testimonios__datos t6_ ON (
    t0_.centro = t6_.centro
    AND t0_.clave < t6_.clave
  )
  LEFT JOIN provincias p4_ ON (p4_.clave = c2_.provincia)
  LEFT JOIN comunidades c5_ ON (p4_.comunidad = c5_.clave)
WHERE
  t6_.clave IS NULL
  AND t0_.verificado = 1
  AND t0_.publicado = 1
  AND t0_.consentimiento = 1
ORDER BY
  nombreEn_10 ASC,
  c5_.nombre ASC,
  t0_.fecharegistro DESC,
  p4_.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, t0_.fecharegistro AS fecharegistro_4, t1_.texto AS texto_5, c2_.nombre AS nombre_6, c2_.localidad AS localidad_7, p3_.clave AS clave_8, p4_.nombre AS nombre_9, p3_.nombreEn AS nombreEn_10, c5_.nombre AS nombre_11 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 p3_ ON (p3_.clave = c2_.pais) LEFT JOIN testimonios__datos t6_ ON (t0_.centro = t6_.centro AND t0_.clave < t6_.clave) LEFT JOIN provincias p4_ ON (p4_.clave = c2_.provincia) LEFT JOIN comunidades c5_ ON (p4_.comunidad = c5_.clave) WHERE t6_.clave IS NULL AND t0_.verificado = 1 AND t0_.publicado = 1 AND t0_.consentimiento = 1 ORDER BY nombreEn_10 ASC, c5_.nombre ASC, t0_.fecharegistro DESC, p4_.nombre ASC, c2_.localidad ASC;