Symfony Profiler

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

Query Metrics

SELECT l0_.idlocalidad AS idlocalidad_0, l0_.nombre AS nombre_1, p1_.idprovincia AS idprovincia_2, p1_.nombre AS nombre_3, a2_.idagencia AS idagencia_4, a3_.apellido AS apellido_5, o4_.domicilio AS domicilio_6, o4_.telefono AS telefono_7, o4_.email AS email_8, o4_.horario_atencion AS horario_atencion_9, o4_.referencia_domicilio AS referencia_domicilio_10, o4_.facebook AS facebook_11, o4_.instagram AS instagram_12, o4_.facebook_descrip AS facebook_descrip_13, o4_.instagram_descrip AS instagram_descrip_14, o4_.whatsapp AS whatsapp_15, o4_.googlemap AS googlemap_16 FROM localidades l0_ INNER JOIN provincias p1_ ON (l0_.idprovincia = p1_.idprovincia) INNER JOIN oficinas o4_ ON (o4_.idlocalidad = l0_.idlocalidad) INNER JOIN agentes a3_ ON (a3_.idagente = o4_.idagente) INNER JOIN agencias a2_ ON (a2_.idagencia = a3_.idagencia) WHERE p1_.idprovincia <> 0 AND o4_.vigente = 1 AND a3_.vigente = 1 AND a2_.vigente = 1 ORDER BY p1_.nombre ASC, l0_.nombre ASC, a2_.idagencia ASC

[]

SELECT
  l0_.idlocalidad AS idlocalidad_0,
  l0_.nombre AS nombre_1,
  p1_.idprovincia AS idprovincia_2,
  p1_.nombre AS nombre_3,
  a2_.idagencia AS idagencia_4,
  a3_.apellido AS apellido_5,
  o4_.domicilio AS domicilio_6,
  o4_.telefono AS telefono_7,
  o4_.email AS email_8,
  o4_.horario_atencion AS horario_atencion_9,
  o4_.referencia_domicilio AS referencia_domicilio_10,
  o4_.facebook AS facebook_11,
  o4_.instagram AS instagram_12,
  o4_.facebook_descrip AS facebook_descrip_13,
  o4_.instagram_descrip AS instagram_descrip_14,
  o4_.whatsapp AS whatsapp_15,
  o4_.googlemap AS googlemap_16
FROM
  localidades l0_
  INNER JOIN provincias p1_ ON (
    l0_.idprovincia = p1_.idprovincia
  )
  INNER JOIN oficinas o4_ ON (
    o4_.idlocalidad = l0_.idlocalidad
  )
  INNER JOIN agentes a3_ ON (a3_.idagente = o4_.idagente)
  INNER JOIN agencias a2_ ON (a2_.idagencia = a3_.idagencia)
WHERE
  p1_.idprovincia <> 0
  AND o4_.vigente = 1
  AND a3_.vigente = 1
  AND a2_.vigente = 1
ORDER BY
  p1_.nombre ASC,
  l0_.nombre ASC,
  a2_.idagencia ASC

SELECT l0_.idlocalidad AS idlocalidad_0, l0_.nombre AS nombre_1, p1_.idprovincia AS idprovincia_2, p1_.nombre AS nombre_3, a2_.idagencia AS idagencia_4, a3_.apellido AS apellido_5, o4_.domicilio AS domicilio_6, o4_.telefono AS telefono_7, o4_.email AS email_8, o4_.horario_atencion AS horario_atencion_9, o4_.referencia_domicilio AS referencia_domicilio_10, o4_.facebook AS facebook_11, o4_.instagram AS instagram_12, o4_.facebook_descrip AS facebook_descrip_13, o4_.instagram_descrip AS instagram_descrip_14, o4_.whatsapp AS whatsapp_15, o4_.googlemap AS googlemap_16 FROM localidades l0_ INNER JOIN provincias p1_ ON (l0_.idprovincia = p1_.idprovincia) INNER JOIN oficinas o4_ ON (o4_.idlocalidad = l0_.idlocalidad) INNER JOIN agentes a3_ ON (a3_.idagente = o4_.idagente) INNER JOIN agencias a2_ ON (a2_.idagencia = a3_.idagencia) WHERE p1_.idprovincia <> 0 AND o4_.vigente = 1 AND a3_.vigente = 1 AND a2_.vigente = 1 ORDER BY p1_.nombre ASC, l0_.nombre ASC, a2_.idagencia ASC;