Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.esta_habilitado AS esta_habilitado_5, t0.plain_password AS plain_password_6, t0.nombre AS nombre_7, t0.apellidos AS apellidos_8, t0.email AS email_9, t0.ultimo_acceso AS ultimo_acceso_10, t0.eliminado_el AS eliminado_el_11, t0.avatar AS avatar_12, t0.avatar_actualizado_el AS avatar_actualizado_el_13, t0.perfil_id AS perfil_id_14, t0.entidad_id AS entidad_id_15 FROM usuario t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.esta_habilitado AS esta_habilitado_5,
  t0.plain_password AS plain_password_6,
  t0.nombre AS nombre_7,
  t0.apellidos AS apellidos_8,
  t0.email AS email_9,
  t0.ultimo_acceso AS ultimo_acceso_10,
  t0.eliminado_el AS eliminado_el_11,
  t0.avatar AS avatar_12,
  t0.avatar_actualizado_el AS avatar_actualizado_el_13,
  t0.perfil_id AS perfil_id_14,
  t0.entidad_id AS entidad_id_15
FROM
  usuario t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.esta_habilitado AS esta_habilitado_5, t0.plain_password AS plain_password_6, t0.nombre AS nombre_7, t0.apellidos AS apellidos_8, t0.email AS email_9, t0.ultimo_acceso AS ultimo_acceso_10, t0.eliminado_el AS eliminado_el_11, t0.avatar AS avatar_12, t0.avatar_actualizado_el AS avatar_actualizado_el_13, t0.perfil_id AS perfil_id_14, t0.entidad_id AS entidad_id_15 FROM usuario t0 WHERE t0.id = 1;

SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM perfil t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2
FROM
  perfil t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM perfil t0 WHERE t0.id = 1;

SELECT t0.id AS id_1, t0.recurso AS recurso_2, t0.accion AS accion_3, t0.recurso_orden AS recurso_orden_4, t0.accion_orden AS accion_orden_5, t0.role AS role_6 FROM permiso t0 INNER JOIN perfil_permiso ON t0.id = perfil_permiso.permiso_id WHERE perfil_permiso.perfil_id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.recurso AS recurso_2,
  t0.accion AS accion_3,
  t0.recurso_orden AS recurso_orden_4,
  t0.accion_orden AS accion_orden_5,
  t0.role AS role_6
FROM
  permiso t0
  INNER JOIN perfil_permiso ON t0.id = perfil_permiso.permiso_id
WHERE
  perfil_permiso.perfil_id = ?

SELECT t0.id AS id_1, t0.recurso AS recurso_2, t0.accion AS accion_3, t0.recurso_orden AS recurso_orden_4, t0.accion_orden AS accion_orden_5, t0.role AS role_6 FROM permiso t0 INNER JOIN perfil_permiso ON t0.id = perfil_permiso.permiso_id WHERE perfil_permiso.perfil_id = 1;

SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.provincia_id AS provincia_id_2 FROM municipio m0_ WHERE m0_.id IN (?) ORDER BY m0_.nombre ASC

[
  "5016"
]

SELECT
  m0_.id AS id_0,
  m0_.nombre AS nombre_1,
  m0_.provincia_id AS provincia_id_2
FROM
  municipio m0_
WHERE
  m0_.id IN (?)
ORDER BY
  m0_.nombre ASC

SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.provincia_id AS provincia_id_2 FROM municipio m0_ WHERE m0_.id IN ('5016') ORDER BY m0_.nombre ASC;

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.municipio_id AS municipio_id_2 FROM parroquia p0_ ORDER BY p0_.nombre ASC

[]

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.municipio_id AS municipio_id_2
FROM
  parroquia p0_
ORDER BY
  p0_.nombre ASC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.municipio_id AS municipio_id_2 FROM parroquia p0_ ORDER BY p0_.nombre ASC;

SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.provincia_id AS provincia_id_2 FROM municipio m0_ ORDER BY m0_.nombre ASC

[]

SELECT
  m0_.id AS id_0,
  m0_.nombre AS nombre_1,
  m0_.provincia_id AS provincia_id_2
FROM
  municipio m0_
ORDER BY
  m0_.nombre ASC

SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.provincia_id AS provincia_id_2 FROM municipio m0_ ORDER BY m0_.nombre ASC;

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.comunidad_autonoma_id AS comunidad_autonoma_id_2 FROM provincia p0_ ORDER BY p0_.nombre ASC

[]

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.comunidad_autonoma_id AS comunidad_autonoma_id_2
FROM
  provincia p0_
ORDER BY
  p0_.nombre ASC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.comunidad_autonoma_id AS comunidad_autonoma_id_2 FROM provincia p0_ ORDER BY p0_.nombre ASC;

SELECT c0_.id AS id_0, c0_.nombre AS nombre_1 FROM comunidad_autonoma c0_ ORDER BY c0_.nombre ASC

[]

SELECT
  c0_.id AS id_0,
  c0_.nombre AS nombre_1
FROM
  comunidad_autonoma c0_
ORDER BY
  c0_.nombre ASC

SELECT c0_.id AS id_0, c0_.nombre AS nombre_1 FROM comunidad_autonoma c0_ ORDER BY c0_.nombre ASC;

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, nombre_1 FROM (SELECT a0_.id AS id_0, a0_.nombre AS nombre_1, p1_.id AS id_2, p1_.nombre AS nombre_3 FROM aldea a0_ LEFT JOIN parroquia p1_ ON a0_.parroquia_id = p1_.id LEFT JOIN municipio m2_ ON p1_.municipio_id = m2_.id LEFT JOIN provincia p3_ ON m2_.provincia_id = p3_.id LEFT JOIN comunidad_autonoma c4_ ON p3_.comunidad_autonoma_id = c4_.id WHERE p1_.municipio_id = ?) dctrn_result_inner ORDER BY nombre_1 ASC) dctrn_result LIMIT 20

[
  5016
]

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      nombre_1
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.nombre AS nombre_1,
          p1_.id AS id_2,
          p1_.nombre AS nombre_3
        FROM
          aldea a0_
          LEFT JOIN parroquia p1_ ON a0_.parroquia_id = p1_.id
          LEFT JOIN municipio m2_ ON p1_.municipio_id = m2_.id
          LEFT JOIN provincia p3_ ON m2_.provincia_id = p3_.id
          LEFT JOIN comunidad_autonoma c4_ ON p3_.comunidad_autonoma_id = c4_.id
        WHERE
          p1_.municipio_id = ?
      ) dctrn_result_inner
    ORDER BY
      nombre_1 ASC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, nombre_1 FROM (SELECT a0_.id AS id_0, a0_.nombre AS nombre_1, p1_.id AS id_2, p1_.nombre AS nombre_3 FROM aldea a0_ LEFT JOIN parroquia p1_ ON a0_.parroquia_id = p1_.id LEFT JOIN municipio m2_ ON p1_.municipio_id = m2_.id LEFT JOIN provincia p3_ ON m2_.provincia_id = p3_.id LEFT JOIN comunidad_autonoma c4_ ON p3_.comunidad_autonoma_id = c4_.id WHERE p1_.municipio_id = 5016) dctrn_result_inner ORDER BY nombre_1 ASC) dctrn_result LIMIT 20;

SELECT a0_.id AS id_0, a0_.nombre AS nombre_1, a0_.parroquia_id AS parroquia_id_2 FROM aldea a0_ LEFT JOIN parroquia p1_ ON a0_.parroquia_id = p1_.id LEFT JOIN municipio m2_ ON p1_.municipio_id = m2_.id LEFT JOIN provincia p3_ ON m2_.provincia_id = p3_.id LEFT JOIN comunidad_autonoma c4_ ON p3_.comunidad_autonoma_id = c4_.id WHERE p1_.municipio_id = ? AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.nombre ASC

[
  5016
  74
  84
  46
  47
  100
  94
  86
  103
  87
  88
  110
  48
  60
  64
  89
  85
  54
  70
  75
  79
]

SELECT
  a0_.id AS id_0,
  a0_.nombre AS nombre_1,
  a0_.parroquia_id AS parroquia_id_2
FROM
  aldea a0_
  LEFT JOIN parroquia p1_ ON a0_.parroquia_id = p1_.id
  LEFT JOIN municipio m2_ ON p1_.municipio_id = m2_.id
  LEFT JOIN provincia p3_ ON m2_.provincia_id = p3_.id
  LEFT JOIN comunidad_autonoma c4_ ON p3_.comunidad_autonoma_id = c4_.id
WHERE
  p1_.municipio_id = ?
  AND a0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  a0_.nombre ASC

SELECT a0_.id AS id_0, a0_.nombre AS nombre_1, a0_.parroquia_id AS parroquia_id_2 FROM aldea a0_ LEFT JOIN parroquia p1_ ON a0_.parroquia_id = p1_.id LEFT JOIN municipio m2_ ON p1_.municipio_id = m2_.id LEFT JOIN provincia p3_ ON m2_.provincia_id = p3_.id LEFT JOIN comunidad_autonoma c4_ ON p3_.comunidad_autonoma_id = c4_.id WHERE p1_.municipio_id = 5016 AND a0_.id IN (74, 84, 46, 47, 100, 94, 86, 103, 87, 88, 110, 48, 60, 64, 89, 85, 54, 70, 75, 79) ORDER BY a0_.nombre ASC;

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.nombre AS nombre_1 FROM aldea a0_ LEFT JOIN parroquia p1_ ON a0_.parroquia_id = p1_.id LEFT JOIN municipio m2_ ON p1_.municipio_id = m2_.id LEFT JOIN provincia p3_ ON m2_.provincia_id = p3_.id LEFT JOIN comunidad_autonoma c4_ ON p3_.comunidad_autonoma_id = c4_.id WHERE p1_.municipio_id = ? ORDER BY a0_.nombre ASC) dctrn_result) dctrn_table

[
  5016
]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.nombre AS nombre_1
        FROM
          aldea a0_
          LEFT JOIN parroquia p1_ ON a0_.parroquia_id = p1_.id
          LEFT JOIN municipio m2_ ON p1_.municipio_id = m2_.id
          LEFT JOIN provincia p3_ ON m2_.provincia_id = p3_.id
          LEFT JOIN comunidad_autonoma c4_ ON p3_.comunidad_autonoma_id = c4_.id
        WHERE
          p1_.municipio_id = ?
        ORDER BY
          a0_.nombre ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.nombre AS nombre_1 FROM aldea a0_ LEFT JOIN parroquia p1_ ON a0_.parroquia_id = p1_.id LEFT JOIN municipio m2_ ON p1_.municipio_id = m2_.id LEFT JOIN provincia p3_ ON m2_.provincia_id = p3_.id LEFT JOIN comunidad_autonoma c4_ ON p3_.comunidad_autonoma_id = c4_.id WHERE p1_.municipio_id = 5016 ORDER BY a0_.nombre ASC) dctrn_result) dctrn_table;