Symfony Profiler

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

Query Metrics

SELECT COUNT(DISTINCT v0_.centro) AS sclr_0 FROM ventas v0_ WHERE v0_.diaslicencia IS NOT NULL AND DATE_ADD(v0_.fechapedido, INTERVAL v0_.diaslicencia DAY) >= CURRENT_DATE

[]

SELECT
  COUNT(DISTINCT v0_.centro) AS sclr_0
FROM
  ventas v0_
WHERE
  v0_.diaslicencia IS NOT NULL
  AND DATE_ADD(
    v0_.fechapedido, INTERVAL v0_.diaslicencia DAY
  ) >= CURRENT_DATE

SELECT COUNT(DISTINCT v0_.centro) AS sclr_0 FROM ventas v0_ WHERE v0_.diaslicencia IS NOT NULL AND DATE_ADD(v0_.fechapedido, INTERVAL v0_.diaslicencia DAY) >= CURRENT_DATE;

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_.nombre AS nombre_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 c2_.pais <> ? AND t0_.verificado = 1 AND t0_.publicado = 1 AND t0_.consentimiento = 1

[
  "en"
  "US"
]

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_.nombre AS nombre_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 c2_.pais <> ?
  AND t0_.verificado = 1
  AND t0_.publicado = 1
  AND t0_.consentimiento = 1

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_.nombre AS nombre_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 c2_.pais <> 'US' AND t0_.verificado = 1 AND t0_.publicado = 1 AND t0_.consentimiento = 1;

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_.nombre AS nombre_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 c2_.pais = ? AND t0_.verificado = 1 AND t0_.publicado = 1 AND t0_.consentimiento = 1

[
  "en"
  "US"
]

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_.nombre AS nombre_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 c2_.pais = ?
  AND t0_.verificado = 1
  AND t0_.publicado = 1
  AND t0_.consentimiento = 1

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_.nombre AS nombre_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 c2_.pais = 'US' AND t0_.verificado = 1 AND t0_.publicado = 1 AND t0_.consentimiento = 1;