Symfony Profiler

Query Metrics

139 Database Queries

20 Different statements

330.66 ms Query time

20 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

239.28 ms
(72.37%)

SELECT sd.id AS id_sede,
						sd.nombre_sede AS sede,
						f.id_tipo_estado_franja AS estado,
						COUNT(*) AS cantidad
					FROM franja f
					JOIN ventanilla v ON f.id_ventanilla = v.id_ventanilla
					JOIN horario_x_ventanilla hv ON v.id_ventanilla = hv.id_ventanilla
					JOIN datos_horario dh ON hv.id_horario = dh.id_horario
					JOIN sala s ON v.id_sala = s.id_sala
					JOIN sede sd ON s.id_sede = sd.id
					JOIN tramites_x_ventanilla txv ON v.id_ventanilla = txv.ventanilla_id
					WHERE f.fecha_franja = :fechaActual
					AND v.activo = true
					AND dh.activo = true
					AND txv.tramite_id = :idProcedure
					AND sd.id = :idSite
					AND f.id_tipo_estado_franja IN (1, 2, 3, 4, 5)
					
					GROUP BY sd.id, sede, estado

Parameters:

[
  "idSite" => 64
  "idProcedure" => 125
  "fechaActual" => "2026-07-19"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  sd.id AS id_sede,
  sd.nombre_sede AS sede,
  f.id_tipo_estado_franja AS estado,
  COUNT(*) AS cantidad
FROM
  franja f
  JOIN ventanilla v ON f.id_ventanilla = v.id_ventanilla
  JOIN horario_x_ventanilla hv ON v.id_ventanilla = hv.id_ventanilla
  JOIN datos_horario dh ON hv.id_horario = dh.id_horario
  JOIN sala s ON v.id_sala = s.id_sala
  JOIN sede sd ON s.id_sede = sd.id
  JOIN tramites_x_ventanilla txv ON v.id_ventanilla = txv.ventanilla_id
WHERE
  f.fecha_franja = :fechaActual
  AND v.activo = true
  AND dh.activo = true
  AND txv.tramite_id = :idProcedure
  AND sd.id = :idSite
  AND f.id_tipo_estado_franja IN (1, 2, 3, 4, 5)
GROUP BY
  sd.id,
  sede,
  estado

SELECT sd.id AS id_sede,
						sd.nombre_sede AS sede,
						f.id_tipo_estado_franja AS estado,
						COUNT(*) AS cantidad
					FROM franja f
					JOIN ventanilla v ON f.id_ventanilla = v.id_ventanilla
					JOIN horario_x_ventanilla hv ON v.id_ventanilla = hv.id_ventanilla
					JOIN datos_horario dh ON hv.id_horario = dh.id_horario
					JOIN sala s ON v.id_sala = s.id_sala
					JOIN sede sd ON s.id_sede = sd.id
					JOIN tramites_x_ventanilla txv ON v.id_ventanilla = txv.ventanilla_id
					WHERE f.fecha_franja = '2026-07-19'
					AND v.activo = true
					AND dh.activo = true
					AND txv.tramite_id = 125
					AND sd.id = 64
					AND f.id_tipo_estado_franja IN (1, 2, 3, 4, 5)
					
					GROUP BY sd.id, sede, estado
				;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 370)
3	App\Repository\SiteRepository->getQuotaIdSiteFest (line 1060)
4	App\Controller\HomeController->agendarAction (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

31.38 ms
(9.49%)

SELECT ct.id_sede,
                   ct.sede,
                   ct.fecha,
                   ct.cantidad AS cupos_totales,
                   cd.cantidad AS cupos_disponibles
            FROM (
                SELECT sd.id AS id_sede,
                       sd.nombre_sede AS sede,
                       f.fecha_franja AS fecha,
                       COUNT(*) AS cantidad
                FROM franja f
                JOIN ventanilla v ON f.id_ventanilla = v.id_ventanilla
                JOIN horario_x_ventanilla hv ON v.id_ventanilla = hv.id_ventanilla
                JOIN datos_horario dh ON hv.id_horario = dh.id_horario
                JOIN sala s ON v.id_sala = s.id_sala
                JOIN sede sd ON s.id_sede = sd.id
                JOIN tramites_x_ventanilla txv ON v.id_ventanilla = txv.ventanilla_id
                WHERE f.fecha_franja >= :fecha
                  AND f.fecha_franja < CAST(:fecha AS date) + INTERVAL '1 day'
                  AND v.activo = true
                  AND dh.activo = true
                  AND f.id_tipo_estado_franja IN (1, 2, 3, 5)
                  AND txv.tramite_id = :tramiteId
                GROUP BY sd.id, sede, fecha
            ) ct
            JOIN (
                SELECT sd.nombre_sede AS sede,
                       f.fecha_franja AS fecha,
                       COUNT(*) AS cantidad
                FROM franja f
                JOIN ventanilla v ON f.id_ventanilla = v.id_ventanilla
                JOIN horario_x_ventanilla hv ON v.id_ventanilla = hv.id_ventanilla
                JOIN datos_horario dh ON hv.id_horario = dh.id_horario
                JOIN sala s ON v.id_sala = s.id_sala
                JOIN sede sd ON s.id_sede = sd.id
                JOIN tramites_x_ventanilla txv ON v.id_ventanilla = txv.ventanilla_id
                WHERE f.fecha_franja >= :fecha
                  AND f.fecha_franja < CAST(:fecha AS date) + INTERVAL '1 day'
                  AND v.activo = true
                  AND dh.activo = true
                  AND f.id_tipo_estado_franja = 1
                  AND txv.tramite_id = :tramiteId
                GROUP BY sede, fecha
            ) cd ON ct.sede = cd.sede AND ct.fecha = cd.fecha

Parameters:

[
  "fecha" => "2026-07-19"
  "tramiteId" => 125
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  ct.id_sede,
  ct.sede,
  ct.fecha,
  ct.cantidad AS cupos_totales,
  cd.cantidad AS cupos_disponibles
FROM
  (
    SELECT
      sd.id AS id_sede,
      sd.nombre_sede AS sede,
      f.fecha_franja AS fecha,
      COUNT(*) AS cantidad
    FROM
      franja f
      JOIN ventanilla v ON f.id_ventanilla = v.id_ventanilla
      JOIN horario_x_ventanilla hv ON v.id_ventanilla = hv.id_ventanilla
      JOIN datos_horario dh ON hv.id_horario = dh.id_horario
      JOIN sala s ON v.id_sala = s.id_sala
      JOIN sede sd ON s.id_sede = sd.id
      JOIN tramites_x_ventanilla txv ON v.id_ventanilla = txv.ventanilla_id
    WHERE
      f.fecha_franja >= :fecha
      AND f.fecha_franja < CAST(:fecha AS date) + INTERVAL '1 day'
      AND v.activo = true
      AND dh.activo = true
      AND f.id_tipo_estado_franja IN (1, 2, 3, 5)
      AND txv.tramite_id = :tramiteId
    GROUP BY
      sd.id,
      sede,
      fecha
  ) ct
  JOIN (
    SELECT
      sd.nombre_sede AS sede,
      f.fecha_franja AS fecha,
      COUNT(*) AS cantidad
    FROM
      franja f
      JOIN ventanilla v ON f.id_ventanilla = v.id_ventanilla
      JOIN horario_x_ventanilla hv ON v.id_ventanilla = hv.id_ventanilla
      JOIN datos_horario dh ON hv.id_horario = dh.id_horario
      JOIN sala s ON v.id_sala = s.id_sala
      JOIN sede sd ON s.id_sede = sd.id
      JOIN tramites_x_ventanilla txv ON v.id_ventanilla = txv.ventanilla_id
    WHERE
      f.fecha_franja >= :fecha
      AND f.fecha_franja < CAST(:fecha AS date) + INTERVAL '1 day'
      AND v.activo = true
      AND dh.activo = true
      AND f.id_tipo_estado_franja = 1
      AND txv.tramite_id = :tramiteId
    GROUP BY
      sede,
      fecha
  ) cd ON ct.sede = cd.sede
  AND ct.fecha = cd.fecha

SELECT ct.id_sede,
                   ct.sede,
                   ct.fecha,
                   ct.cantidad AS cupos_totales,
                   cd.cantidad AS cupos_disponibles
            FROM (
                SELECT sd.id AS id_sede,
                       sd.nombre_sede AS sede,
                       f.fecha_franja AS fecha,
                       COUNT(*) AS cantidad
                FROM franja f
                JOIN ventanilla v ON f.id_ventanilla = v.id_ventanilla
                JOIN horario_x_ventanilla hv ON v.id_ventanilla = hv.id_ventanilla
                JOIN datos_horario dh ON hv.id_horario = dh.id_horario
                JOIN sala s ON v.id_sala = s.id_sala
                JOIN sede sd ON s.id_sede = sd.id
                JOIN tramites_x_ventanilla txv ON v.id_ventanilla = txv.ventanilla_id
                WHERE f.fecha_franja >= '2026-07-19'
                  AND f.fecha_franja < CAST('2026-07-19' AS date) + INTERVAL '1 day'
                  AND v.activo = true
                  AND dh.activo = true
                  AND f.id_tipo_estado_franja IN (1, 2, 3, 5)
                  AND txv.tramite_id = 125
                GROUP BY sd.id, sede, fecha
            ) ct
            JOIN (
                SELECT sd.nombre_sede AS sede,
                       f.fecha_franja AS fecha,
                       COUNT(*) AS cantidad
                FROM franja f
                JOIN ventanilla v ON f.id_ventanilla = v.id_ventanilla
                JOIN horario_x_ventanilla hv ON v.id_ventanilla = hv.id_ventanilla
                JOIN datos_horario dh ON hv.id_horario = dh.id_horario
                JOIN sala s ON v.id_sala = s.id_sala
                JOIN sede sd ON s.id_sede = sd.id
                JOIN tramites_x_ventanilla txv ON v.id_ventanilla = txv.ventanilla_id
                WHERE f.fecha_franja >= '2026-07-19'
                  AND f.fecha_franja < CAST('2026-07-19' AS date) + INTERVAL '1 day'
                  AND v.activo = true
                  AND dh.activo = true
                  AND f.id_tipo_estado_franja = 1
                  AND txv.tramite_id = 125
                GROUP BY sede, fecha
            ) cd ON ct.sede = cd.sede AND ct.fecha = cd.fecha;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 220)
3	App\Repository\SiteRepository->getQuotaSite (line 1035)
4	App\Controller\HomeController->agendarAction (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

17.95 ms
(5.43%)

SELECT dh.*
                FROM sede s, sala sl, ventanilla v, tramites_x_ventanilla txv,
                    datos_horario dh, horario_x_ventanilla hv
                WHERE s.id = sl.id_sede
                AND sl.id_sala = v.id_sala
                AND v.id_ventanilla = txv.ventanilla_id
                AND v.id_ventanilla = hv.id_ventanilla
                AND hv.id_horario = dh.id_horario
                AND s.id = :idSite
                AND txv.tramite_id = :idProcedure
                AND dh.activo = true

Parameters:

[
  "idSite" => 64
  "idProcedure" => 125
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  dh.*
FROM
  sede s,
  sala sl,
  ventanilla v,
  tramites_x_ventanilla txv,
  datos_horario dh,
  horario_x_ventanilla hv
WHERE
  s.id = sl.id_sede
  AND sl.id_sala = v.id_sala
  AND v.id_ventanilla = txv.ventanilla_id
  AND v.id_ventanilla = hv.id_ventanilla
  AND hv.id_horario = dh.id_horario
  AND s.id = :idSite
  AND txv.tramite_id = :idProcedure
  AND dh.activo = true

SELECT dh.*
                FROM sede s, sala sl, ventanilla v, tramites_x_ventanilla txv,
                    datos_horario dh, horario_x_ventanilla hv
                WHERE s.id = sl.id_sede
                AND sl.id_sala = v.id_sala
                AND v.id_ventanilla = txv.ventanilla_id
                AND v.id_ventanilla = hv.id_ventanilla
                AND hv.id_horario = dh.id_horario
                AND s.id = 64
                AND txv.tramite_id = 125
                AND dh.activo = true;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 103)
3	App\Repository\ScheduleDataRepository->getDataSchedulesByProcedureSite (line 1054)
4	App\Controller\HomeController->agendarAction (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

8.07 ms
(2.44%)

SELECT t0.id_parametro AS id_parametro_1, t0.descripcion_parametro AS descripcion_parametro_2, t0.valor AS valor_3, t0.tipo_dato AS tipo_dato_4, t0.cliente AS cliente_5 FROM parametros t0 WHERE t0.id_parametro = ?

Parameters:

[
  89
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_parametro AS id_parametro_1,
  t0.descripcion_parametro AS descripcion_parametro_2,
  t0.valor AS valor_3,
  t0.tipo_dato AS tipo_dato_4,
  t0.cliente AS cliente_5
FROM
  parametros t0
WHERE
  t0.id_parametro = ?

SELECT t0.id_parametro AS id_parametro_1, t0.descripcion_parametro AS descripcion_parametro_2, t0.valor AS valor_3, t0.tipo_dato AS tipo_dato_4, t0.cliente AS cliente_5 FROM parametros t0 WHERE t0.id_parametro = 89;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 861)
6	App\Controller\HomeController->agendarAction (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

4.85 ms
(1.47%)

SELECT t0.id_categoria AS id_categoria_1, t0.nombre_categoria AS nombre_categoria_2, t0.activo AS activo_3, t0.id_empresa AS id_empresa_4 FROM categorias t0 INNER JOIN tramites_x_categorias ON t0.id_categoria = tramites_x_categorias.id_categoria WHERE tramites_x_categorias.id_tramite = ?

Parameters:

[
  125
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_categoria AS id_categoria_1,
  t0.nombre_categoria AS nombre_categoria_2,
  t0.activo AS activo_3,
  t0.id_empresa AS id_empresa_4
FROM
  categorias t0
  INNER JOIN tramites_x_categorias ON t0.id_categoria = tramites_x_categorias.id_categoria
WHERE
  tramites_x_categorias.id_tramite = ?

SELECT t0.id_categoria AS id_categoria_1, t0.nombre_categoria AS nombre_categoria_2, t0.activo AS activo_3, t0.id_empresa AS id_empresa_4 FROM categorias t0 INNER JOIN tramites_x_categorias ON t0.id_categoria = tramites_x_categorias.id_categoria WHERE tramites_x_categorias.id_tramite = 125;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1143)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1065)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3322)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 315)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 995)
8	App\Controller\HomeController->agendarAction (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

4.58 ms
(1.38%)

SELECT count(s0_.ip) AS sclr_0 FROM solicitud_agendamiento_pasaporte s0_ WHERE s0_.ip = ? AND s0_.fecha_hora_aceptacion_politica_datos >= ? AND s0_.fecha_hora_aceptacion_politica_datos < ?

Parameters:

[
  "216.73.216.194"
  "2026-07-19 00:00:00"
  "2026-07-19 23:59:59"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(s0_.ip) AS sclr_0
FROM
  solicitud_agendamiento_pasaporte s0_
WHERE
  s0_.ip = ?
  AND s0_.fecha_hora_aceptacion_politica_datos >= ?
  AND s0_.fecha_hora_aceptacion_politica_datos < ?

SELECT count(s0_.ip) AS sclr_0 FROM solicitud_agendamiento_pasaporte s0_ WHERE s0_.ip = '216.73.216.194' AND s0_.fecha_hora_aceptacion_politica_datos >= '2026-07-19 00:00:00' AND s0_.fecha_hora_aceptacion_politica_datos < '2026-07-19 23:59:59';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1213)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1167)
5	Doctrine\ORM\AbstractQuery->execute (line 906)
6	Doctrine\ORM\AbstractQuery->getResult (line 119)
7	App\Repository\PassportSchedulingRequestRepository->getCountAppointmentByIpToday (line 948)
8	App\Controller\HomeController->agendarAction (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

3.73 ms
(1.13%)

SELECT t0.id_parametro AS id_parametro_1, t0.descripcion_parametro AS descripcion_parametro_2, t0.valor AS valor_3, t0.tipo_dato AS tipo_dato_4, t0.cliente AS cliente_5 FROM parametros t0 WHERE t0.id_parametro = ? LIMIT 1

Parameters:

[
  104
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_parametro AS id_parametro_1,
  t0.descripcion_parametro AS descripcion_parametro_2,
  t0.valor AS valor_3,
  t0.tipo_dato AS tipo_dato_4,
  t0.cliente AS cliente_5
FROM
  parametros t0
WHERE
  t0.id_parametro = ?
LIMIT
  1

SELECT t0.id_parametro AS id_parametro_1, t0.descripcion_parametro AS descripcion_parametro_2, t0.valor AS valor_3, t0.tipo_dato AS tipo_dato_4, t0.cliente AS cliente_5 FROM parametros t0 WHERE t0.id_parametro = 104 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 17)
4	App\Repository\ParameterRepository->findParameterForId (line 863)
5	App\Controller\HomeController->agendarAction (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

3.18 ms
(0.96%)

SELECT t0.id_ventanilla AS id_ventanilla_1, t0.nombre_ventanilla AS nombre_ventanilla_2, t0.mac_pc AS mac_pc_3, t0.direccion_ip AS direccion_ip_4, t0.activo AS activo_5, t0.ventanilla_virtual AS ventanilla_virtual_6, t0.tipo_agendamiento AS tipo_agendamiento_7, t0.cantidad_tramites_x_cita AS cantidad_tramites_x_cita_8, t0.ventanilla_masiva AS ventanilla_masiva_9, t0.cantidad_cupos AS cantidad_cupos_10, t0.com AS com_11, t0.cantidad_cupos_extra AS cantidad_cupos_extra_12, t0.ventanilla_preferencial AS ventanilla_preferencial_13, t0.id_tramite_transferencia AS id_tramite_transferencia_14, t0.id_sala AS id_sala_15 FROM ventanilla t0 INNER JOIN tramites_x_ventanilla ON t0.id_ventanilla = tramites_x_ventanilla.ventanilla_id WHERE tramites_x_ventanilla.tramite_id = ?

Parameters:

[
  125
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_ventanilla AS id_ventanilla_1,
  t0.nombre_ventanilla AS nombre_ventanilla_2,
  t0.mac_pc AS mac_pc_3,
  t0.direccion_ip AS direccion_ip_4,
  t0.activo AS activo_5,
  t0.ventanilla_virtual AS ventanilla_virtual_6,
  t0.tipo_agendamiento AS tipo_agendamiento_7,
  t0.cantidad_tramites_x_cita AS cantidad_tramites_x_cita_8,
  t0.ventanilla_masiva AS ventanilla_masiva_9,
  t0.cantidad_cupos AS cantidad_cupos_10,
  t0.com AS com_11,
  t0.cantidad_cupos_extra AS cantidad_cupos_extra_12,
  t0.ventanilla_preferencial AS ventanilla_preferencial_13,
  t0.id_tramite_transferencia AS id_tramite_transferencia_14,
  t0.id_sala AS id_sala_15
FROM
  ventanilla t0
  INNER JOIN tramites_x_ventanilla ON t0.id_ventanilla = tramites_x_ventanilla.ventanilla_id
WHERE
  tramites_x_ventanilla.tramite_id = ?

SELECT t0.id_ventanilla AS id_ventanilla_1, t0.nombre_ventanilla AS nombre_ventanilla_2, t0.mac_pc AS mac_pc_3, t0.direccion_ip AS direccion_ip_4, t0.activo AS activo_5, t0.ventanilla_virtual AS ventanilla_virtual_6, t0.tipo_agendamiento AS tipo_agendamiento_7, t0.cantidad_tramites_x_cita AS cantidad_tramites_x_cita_8, t0.ventanilla_masiva AS ventanilla_masiva_9, t0.cantidad_cupos AS cantidad_cupos_10, t0.com AS com_11, t0.cantidad_cupos_extra AS cantidad_cupos_extra_12, t0.ventanilla_preferencial AS ventanilla_preferencial_13, t0.id_tramite_transferencia AS id_tramite_transferencia_14, t0.id_sala AS id_sala_15 FROM ventanilla t0 INNER JOIN tramites_x_ventanilla ON t0.id_ventanilla = tramites_x_ventanilla.ventanilla_id WHERE tramites_x_ventanilla.tramite_id = 125;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1143)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1065)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3322)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 315)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 1009)
8	App\Controller\HomeController->agendarAction (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

3.03 ms
(0.92%)

SELECT v0_.id_ventanilla AS id_ventanilla_0, v0_.nombre_ventanilla AS nombre_ventanilla_1, v0_.mac_pc AS mac_pc_2, v0_.direccion_ip AS direccion_ip_3, v0_.activo AS activo_4, v0_.ventanilla_virtual AS ventanilla_virtual_5, v0_.tipo_agendamiento AS tipo_agendamiento_6, v0_.cantidad_tramites_x_cita AS cantidad_tramites_x_cita_7, v0_.ventanilla_masiva AS ventanilla_masiva_8, v0_.cantidad_cupos AS cantidad_cupos_9, v0_.com AS com_10, v0_.cantidad_cupos_extra AS cantidad_cupos_extra_11, v0_.ventanilla_preferencial AS ventanilla_preferencial_12, v0_.id_tramite_transferencia AS id_tramite_transferencia_13, v0_.id_sala AS id_sala_14 FROM ventanilla v0_ INNER JOIN sala s1_ ON v0_.id_sala = s1_.id_sala INNER JOIN sede s2_ ON s1_.id_sede = s2_.id INNER JOIN empresa e3_ ON s2_.id_enterprise = e3_.id_empresa WHERE v0_.activo = true AND s1_.activo = true AND s2_.activo = true AND e3_.activo = true ORDER BY v0_.nombre_ventanilla ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id_ventanilla AS id_ventanilla_0,
  v0_.nombre_ventanilla AS nombre_ventanilla_1,
  v0_.mac_pc AS mac_pc_2,
  v0_.direccion_ip AS direccion_ip_3,
  v0_.activo AS activo_4,
  v0_.ventanilla_virtual AS ventanilla_virtual_5,
  v0_.tipo_agendamiento AS tipo_agendamiento_6,
  v0_.cantidad_tramites_x_cita AS cantidad_tramites_x_cita_7,
  v0_.ventanilla_masiva AS ventanilla_masiva_8,
  v0_.cantidad_cupos AS cantidad_cupos_9,
  v0_.com AS com_10,
  v0_.cantidad_cupos_extra AS cantidad_cupos_extra_11,
  v0_.ventanilla_preferencial AS ventanilla_preferencial_12,
  v0_.id_tramite_transferencia AS id_tramite_transferencia_13,
  v0_.id_sala AS id_sala_14
FROM
  ventanilla v0_
  INNER JOIN sala s1_ ON v0_.id_sala = s1_.id_sala
  INNER JOIN sede s2_ ON s1_.id_sede = s2_.id
  INNER JOIN empresa e3_ ON s2_.id_enterprise = e3_.id_empresa
WHERE
  v0_.activo = true
  AND s1_.activo = true
  AND s2_.activo = true
  AND e3_.activo = true
ORDER BY
  v0_.nombre_ventanilla ASC

SELECT v0_.id_ventanilla AS id_ventanilla_0, v0_.nombre_ventanilla AS nombre_ventanilla_1, v0_.mac_pc AS mac_pc_2, v0_.direccion_ip AS direccion_ip_3, v0_.activo AS activo_4, v0_.ventanilla_virtual AS ventanilla_virtual_5, v0_.tipo_agendamiento AS tipo_agendamiento_6, v0_.cantidad_tramites_x_cita AS cantidad_tramites_x_cita_7, v0_.ventanilla_masiva AS ventanilla_masiva_8, v0_.cantidad_cupos AS cantidad_cupos_9, v0_.com AS com_10, v0_.cantidad_cupos_extra AS cantidad_cupos_extra_11, v0_.ventanilla_preferencial AS ventanilla_preferencial_12, v0_.id_tramite_transferencia AS id_tramite_transferencia_13, v0_.id_sala AS id_sala_14 FROM ventanilla v0_ INNER JOIN sala s1_ ON v0_.id_sala = s1_.id_sala INNER JOIN sede s2_ ON s1_.id_sede = s2_.id INNER JOIN empresa e3_ ON s2_.id_enterprise = e3_.id_empresa WHERE v0_.activo = true AND s1_.activo = true AND s2_.activo = true AND e3_.activo = true ORDER BY v0_.nombre_ventanilla ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1213)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1167)
5	Doctrine\ORM\AbstractQuery->execute (line 906)
6	Doctrine\ORM\AbstractQuery->getResult (line 670)
7	App\Repository\ProcedureWindowRepository->getProcedureWindowsAvailable (line 964)
8	App\Controller\HomeController->agendarAction (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

2.43 ms
(0.74%)

SELECT t0_.id_tramite AS id_tramite_0, t0_.nombre AS nombre_1, t0_.descripcion AS descripcion_2, t0_.activo AS activo_3, t0_.letra_turnero AS letra_turnero_4, t0_.peso_en_franjas AS peso_en_franjas_5, t0_.visible_citas AS visible_citas_6, t0_.multiple AS multiple_7, t0_.validación_citas_placa_identificacion AS validacin_citas_placa_identificacion_8, t0_.turno_preferencial AS turno_preferencial_9, t0_.ver_botones_fin_efectivo_no_efectivo AS ver_botones_fin_efectivo_no_efectivo_10, t0_.posicion AS posicion_11, t0_.ruta_doc_requisitos AS ruta_doc_requisitos_12, t0_.tiempo_alerta AS tiempo_alerta_13, t0_.consecutivo_tramite AS consecutivo_tramite_14, t0_.tipo_documental AS tipo_documental_15, t0_.codigo_categoria AS codigo_categoria_16, t0_.id_enterprise AS id_enterprise_17, t0_.id_tipo_tramite AS id_tipo_tramite_18 FROM tramite t0_ INNER JOIN tramites_x_ventanilla t2_ ON t0_.id_tramite = t2_.tramite_id INNER JOIN ventanilla v1_ ON v1_.id_ventanilla = t2_.ventanilla_id WHERE t0_.activo = true AND t0_.visible_citas = true AND v1_.id_ventanilla IN (?, ?, ?, ?) ORDER BY t0_.posicion ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id_tramite AS id_tramite_0,
  t0_.nombre AS nombre_1,
  t0_.descripcion AS descripcion_2,
  t0_.activo AS activo_3,
  t0_.letra_turnero AS letra_turnero_4,
  t0_.peso_en_franjas AS peso_en_franjas_5,
  t0_.visible_citas AS visible_citas_6,
  t0_.multiple AS multiple_7,
  t0_.validación_citas_placa_identificacion AS validacin_citas_placa_identificacion_8,
  t0_.turno_preferencial AS turno_preferencial_9,
  t0_.ver_botones_fin_efectivo_no_efectivo AS ver_botones_fin_efectivo_no_efectivo_10,
  t0_.posicion AS posicion_11,
  t0_.ruta_doc_requisitos AS ruta_doc_requisitos_12,
  t0_.tiempo_alerta AS tiempo_alerta_13,
  t0_.consecutivo_tramite AS consecutivo_tramite_14,
  t0_.tipo_documental AS tipo_documental_15,
  t0_.codigo_categoria AS codigo_categoria_16,
  t0_.id_enterprise AS id_enterprise_17,
  t0_.id_tipo_tramite AS id_tipo_tramite_18
FROM
  tramite t0_
  INNER JOIN tramites_x_ventanilla t2_ ON t0_.id_tramite = t2_.tramite_id
  INNER JOIN ventanilla v1_ ON v1_.id_ventanilla = t2_.ventanilla_id
WHERE
  t0_.activo = true
  AND t0_.visible_citas = true
  AND v1_.id_ventanilla IN (?, ?, ?, ?)
ORDER BY
  t0_.posicion ASC

SELECT t0_.id_tramite AS id_tramite_0, t0_.nombre AS nombre_1, t0_.descripcion AS descripcion_2, t0_.activo AS activo_3, t0_.letra_turnero AS letra_turnero_4, t0_.peso_en_franjas AS peso_en_franjas_5, t0_.visible_citas AS visible_citas_6, t0_.multiple AS multiple_7, t0_.validación_citas_placa_identificacion AS validacin_citas_placa_identificacion_8, t0_.turno_preferencial AS turno_preferencial_9, t0_.ver_botones_fin_efectivo_no_efectivo AS ver_botones_fin_efectivo_no_efectivo_10, t0_.posicion AS posicion_11, t0_.ruta_doc_requisitos AS ruta_doc_requisitos_12, t0_.tiempo_alerta AS tiempo_alerta_13, t0_.consecutivo_tramite AS consecutivo_tramite_14, t0_.tipo_documental AS tipo_documental_15, t0_.codigo_categoria AS codigo_categoria_16, t0_.id_enterprise AS id_enterprise_17, t0_.id_tipo_tramite AS id_tipo_tramite_18 FROM tramite t0_ INNER JOIN tramites_x_ventanilla t2_ ON t0_.id_tramite = t2_.tramite_id INNER JOIN ventanilla v1_ ON v1_.id_ventanilla = t2_.ventanilla_id WHERE t0_.activo = true AND t0_.visible_citas = true AND v1_.id_ventanilla IN (810, 811, 812, 604) ORDER BY t0_.posicion ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1213)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1167)
5	Doctrine\ORM\AbstractQuery->execute (line 906)
6	Doctrine\ORM\AbstractQuery->getResult (line 249)
7	App\Repository\ProcedureRepository->getProceduresAvailables (line 977)
8	App\Controller\HomeController->agendarAction (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

2.24 ms
(0.68%)

SELECT t0.id AS id_1, t0.Nombre_sede AS nombre_sede_2, t0.Direccion_sede AS direccion_sede_3, t0.Telefono_sede AS telefono_sede_4, t0.activo AS activo_5, t0.visible_bot AS visible_bot_6, t0.descentralizada AS descentralizada_7, t0.fechainicio AS fechainicio_8, t0.fechafin AS fechafin_9, t0.id_ciudad AS id_ciudad_10, t0.id_enterprise AS id_enterprise_11 FROM sede t0 WHERE t0.id = ?

Parameters:

[
  76
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.Nombre_sede AS nombre_sede_2,
  t0.Direccion_sede AS direccion_sede_3,
  t0.Telefono_sede AS telefono_sede_4,
  t0.activo AS activo_5,
  t0.visible_bot AS visible_bot_6,
  t0.descentralizada AS descentralizada_7,
  t0.fechainicio AS fechainicio_8,
  t0.fechafin AS fechafin_9,
  t0.id_ciudad AS id_ciudad_10,
  t0.id_enterprise AS id_enterprise_11
FROM
  sede t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.Nombre_sede AS nombre_sede_2, t0.Direccion_sede AS direccion_sede_3, t0.Telefono_sede AS telefono_sede_4, t0.activo AS activo_5, t0.visible_bot AS visible_bot_6, t0.descentralizada AS descentralizada_7, t0.fechainicio AS fechainicio_8, t0.fechafin AS fechafin_9, t0.id_ciudad AS id_ciudad_10, t0.id_enterprise AS id_enterprise_11 FROM sede t0 WHERE t0.id = 76;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 369)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 479)
5	Proxies\__CG__\App\Entity\Site::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
7	Proxies\__CG__\App\Entity\Site->__get (line 129)
8	App\Entity\Site->getIsActive (line 970)
9	App\Controller\HomeController->agendarAction (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

2.17 ms
(0.66%)

SELECT t0.id_sala AS id_sala_1, t0.nombre_sala AS nombre_sala_2, t0.activo AS activo_3, t0.id_sede AS id_sede_4 FROM sala t0 WHERE t0.id_sala = ?

Parameters:

[
  80
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_sala AS id_sala_1,
  t0.nombre_sala AS nombre_sala_2,
  t0.activo AS activo_3,
  t0.id_sede AS id_sede_4
FROM
  sala t0
WHERE
  t0.id_sala = ?

SELECT t0.id_sala AS id_sala_1, t0.nombre_sala AS nombre_sala_2, t0.activo AS activo_3, t0.id_sede AS id_sede_4 FROM sala t0 WHERE t0.id_sala = 80;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 369)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 479)
5	Proxies\__CG__\App\Entity\WaitingRoom::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
7	Proxies\__CG__\App\Entity\WaitingRoom->__get (line 77)
8	App\Entity\WaitingRoom->getIsActive (line 969)
9	App\Controller\HomeController->agendarAction (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

2.03 ms
(0.61%)

UPDATE franja 
                        SET id_tipo_estado_franja = 1, fecha_asignacion = null
                        WHERE id_tipo_estado_franja = 3 OR id_tipo_estado_franja = 2
                        AND id_cita is null
                        AND fecha_asignacion <= :lastInterval

Parameters:

[
  "lastInterval" => "2026-07-19 03:24:42"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  franja
SET
  id_tipo_estado_franja = 1,
  fecha_asignacion = null
WHERE
  id_tipo_estado_franja = 3
  OR id_tipo_estado_franja = 2
  AND id_cita is null
  AND fecha_asignacion <= :lastInterval

UPDATE franja 
                        SET id_tipo_estado_franja = 1, fecha_asignacion = null
                        WHERE id_tipo_estado_franja = 3 OR id_tipo_estado_franja = 2
                        AND id_cita is null
                        AND fecha_asignacion <= '2026-07-19 03:24:42';

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 903)
3	App\Controller\HomeController->agendarAction (line 181)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 5)

1.22 ms
(0.37%)

SELECT t0_.id_tipo_documento AS id_tipo_documento_0, t0_.descripcion_tipo_documento AS descripcion_tipo_documento_1, t0_.codigo_tipo_documento AS codigo_tipo_documento_2, t0_.activo AS activo_3 FROM tipo_documento t0_ ORDER BY t0_.descripcion_tipo_documento ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id_tipo_documento AS id_tipo_documento_0,
  t0_.descripcion_tipo_documento AS descripcion_tipo_documento_1,
  t0_.codigo_tipo_documento AS codigo_tipo_documento_2,
  t0_.activo AS activo_3
FROM
  tipo_documento t0_
ORDER BY
  t0_.descripcion_tipo_documento ASC

SELECT t0_.id_tipo_documento AS id_tipo_documento_0, t0_.descripcion_tipo_documento AS descripcion_tipo_documento_1, t0_.codigo_tipo_documento AS codigo_tipo_documento_2, t0_.activo AS activo_3 FROM tipo_documento t0_ ORDER BY t0_.descripcion_tipo_documento ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1213)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1167)
5	Doctrine\ORM\AbstractQuery->execute (line 44)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 56)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 189)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 461)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 236)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 1112)
21	App\Controller\HomeController->agendarAction (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

1.04 ms
(0.32%)

SELECT t0_.id_tipo_solicitud_pasaporte AS id_tipo_solicitud_pasaporte_0, t0_.descripcion_tipo_solicitud AS descripcion_tipo_solicitud_1, t0_.activo AS activo_2 FROM tipo_solicitud_pasaporte t0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id_tipo_solicitud_pasaporte AS id_tipo_solicitud_pasaporte_0,
  t0_.descripcion_tipo_solicitud AS descripcion_tipo_solicitud_1,
  t0_.activo AS activo_2
FROM
  tipo_solicitud_pasaporte t0_

SELECT t0_.id_tipo_solicitud_pasaporte AS id_tipo_solicitud_pasaporte_0, t0_.descripcion_tipo_solicitud AS descripcion_tipo_solicitud_1, t0_.activo AS activo_2 FROM tipo_solicitud_pasaporte t0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1213)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1167)
5	Doctrine\ORM\AbstractQuery->execute (line 44)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 56)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 189)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 461)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 236)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 1112)
21	App\Controller\HomeController->agendarAction (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.91 ms
(0.27%)

SELECT t0_.id_tipo_acompanante AS id_tipo_acompanante_0, t0_.descripcion_tipo_acompanante AS descripcion_tipo_acompanante_1, t0_.activo AS activo_2 FROM tipo_acompanante t0_ ORDER BY t0_.descripcion_tipo_acompanante ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id_tipo_acompanante AS id_tipo_acompanante_0,
  t0_.descripcion_tipo_acompanante AS descripcion_tipo_acompanante_1,
  t0_.activo AS activo_2
FROM
  tipo_acompanante t0_
ORDER BY
  t0_.descripcion_tipo_acompanante ASC

SELECT t0_.id_tipo_acompanante AS id_tipo_acompanante_0, t0_.descripcion_tipo_acompanante AS descripcion_tipo_acompanante_1, t0_.activo AS activo_2 FROM tipo_acompanante t0_ ORDER BY t0_.descripcion_tipo_acompanante ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1213)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1167)
5	Doctrine\ORM\AbstractQuery->execute (line 44)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 56)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 189)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 461)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 236)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 1112)
21	App\Controller\HomeController->agendarAction (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.76 ms
(0.23%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.boton_principal AS boton_principal_3, t0.boton_tabla AS boton_tabla_4, t0.columna_tabla AS columna_tabla_5, t0.titulo_tabla AS titulo_tabla_6 FROM tema t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.boton_principal AS boton_principal_3,
  t0.boton_tabla AS boton_tabla_4,
  t0.columna_tabla AS columna_tabla_5,
  t0.titulo_tabla AS titulo_tabla_6
FROM
  tema t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.boton_principal AS boton_principal_3, t0.boton_tabla AS boton_tabla_4, t0.columna_tabla AS columna_tabla_5, t0.titulo_tabla AS titulo_tabla_6 FROM tema t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 36)
6	App\Twig\AppExtension->getGlobals (line 365)
7	Twig\ExtensionSet->getGlobals (line 908)
8	Twig\Environment->getGlobals (line 398)
9	Twig\Template->yield (line 358)
10	Twig\Template->display (line 373)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 333)
13	Twig\Environment->render (line 243)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 1109)
16	App\Controller\HomeController->agendarAction (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.70 ms
(0.21%)

SELECT t0.id_empresa AS id_empresa_1, t0.nombre_empresa AS nombre_empresa_2, t0.nit_empresa AS nit_empresa_3, t0.activo AS activo_4, t0.url_empresa AS url_empresa_5, t0.ruta_banner_login AS ruta_banner_login_6, t0.ruta_doc_protocolo_bioseguridad AS ruta_doc_protocolo_bioseguridad_7, t0.ruta_doc_autenticacion_digital AS ruta_doc_autenticacion_digital_8 FROM empresa t0 WHERE t0.id_empresa = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_empresa AS id_empresa_1,
  t0.nombre_empresa AS nombre_empresa_2,
  t0.nit_empresa AS nit_empresa_3,
  t0.activo AS activo_4,
  t0.url_empresa AS url_empresa_5,
  t0.ruta_banner_login AS ruta_banner_login_6,
  t0.ruta_doc_protocolo_bioseguridad AS ruta_doc_protocolo_bioseguridad_7,
  t0.ruta_doc_autenticacion_digital AS ruta_doc_autenticacion_digital_8
FROM
  empresa t0
WHERE
  t0.id_empresa = ?

SELECT t0.id_empresa AS id_empresa_1, t0.nombre_empresa AS nombre_empresa_2, t0.nit_empresa AS nit_empresa_3, t0.activo AS activo_4, t0.url_empresa AS url_empresa_5, t0.ruta_banner_login AS ruta_banner_login_6, t0.ruta_doc_protocolo_bioseguridad AS ruta_doc_protocolo_bioseguridad_7, t0.ruta_doc_autenticacion_digital AS ruta_doc_autenticacion_digital_8 FROM empresa t0 WHERE t0.id_empresa = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 369)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 479)
5	Proxies\__CG__\App\Entity\Enterprise::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
7	Proxies\__CG__\App\Entity\Enterprise->__get (line 168)
8	App\Entity\Enterprise->getIsActive (line 971)
9	App\Controller\HomeController->agendarAction (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.58 ms
(0.18%)

SELECT c0_.id_categoria AS id_categoria_0, c0_.nombre_categoria AS nombre_categoria_1, c0_.activo AS activo_2, c0_.id_empresa AS id_empresa_3 FROM categorias c0_ WHERE c0_.activo = 'S'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id_categoria AS id_categoria_0,
  c0_.nombre_categoria AS nombre_categoria_1,
  c0_.activo AS activo_2,
  c0_.id_empresa AS id_empresa_3
FROM
  categorias c0_
WHERE
  c0_.activo = 'S'

SELECT c0_.id_categoria AS id_categoria_0, c0_.nombre_categoria AS nombre_categoria_1, c0_.activo AS activo_2, c0_.id_empresa AS id_empresa_3 FROM categorias c0_ WHERE c0_.activo = 'S';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1213)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1167)
5	Doctrine\ORM\AbstractQuery->execute (line 906)
6	Doctrine\ORM\AbstractQuery->getResult (line 53)
7	App\Repository\CategoryRepository->findByCategoriesActives (line 1077)
8	App\Controller\HomeController->agendarAction (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.51 ms
(0.15%)

UPDATE franja 
                        SET id_tipo_estado_franja = 2
                        WHERE id_tipo_estado_franja = 3
                        AND id_cita is not null

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  franja
SET
  id_tipo_estado_franja = 2
WHERE
  id_tipo_estado_franja = 3
  AND id_cita is not null

UPDATE franja 
                        SET id_tipo_estado_franja = 2
                        WHERE id_tipo_estado_franja = 3
                        AND id_cita is not null;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 913)
3	App\Controller\HomeController->agendarAction (line 181)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Parameter	No errors.
App\Entity\DocumentType	The association App\Entity\DocumentType#schedulingRequest refers to the owning side field App\Entity\SchedulingRequest#documentType which does not exist. The association App\Entity\DocumentType#passportSchedulingRequest refers to the owning side field App\Entity\PassportSchedulingRequest#documentType which does not exist.
App\Entity\PassportSchedulingRequest	The association App\Entity\PassportSchedulingRequest#appointment refers to the inverse side field App\Entity\Appointment#passportSchedulingRequest which does not exist. The association App\Entity\PassportSchedulingRequest#passportRequestType refers to the inverse side field App\Entity\PassportRequestType#passportSchedulingRequest which does not exist. The mappings App\Entity\PassportSchedulingRequest#documentTypeSolicitante and App\Entity\DocumentType#passportSchedulingRequest are inconsistent with each other. The mappings App\Entity\PassportSchedulingRequest#documentTypeAcompanante and App\Entity\DocumentType#passportSchedulingRequest are inconsistent with each other. The association App\Entity\PassportSchedulingRequest#companionTypeId refers to the inverse side field App\Entity\CompanionType#passportSchedulingRequest which does not exist.
App\Entity\PassportRequestType	The mappings App\Entity\PassportRequestType#passportSchedulingRequests and App\Entity\PassportSchedulingRequest#passportRequestType are inconsistent with each other.
App\Entity\CompanionType	No errors.
App\Entity\ProcedureWindow	The mappings App\Entity\ProcedureWindow#schedule and App\Entity\Schedule#procedureWindow are inconsistent with each other.
App\Entity\Interval	The association App\Entity\Interval#templateInterval refers to the inverse side field App\Entity\TemplateInterval#interval which does not exist.
App\Entity\Schedule	The mappings App\Entity\Schedule#specialDate and App\Entity\SpecialDate#schedule are inconsistent with each other. The association App\Entity\Schedule#procedureWindow refers to the inverse side field App\Entity\ProcedureWindow#schedules which does not exist.
App\Entity\WaitingRoom	No errors.
App\Entity\StateAppointmentWindow	No errors.
App\Entity\Procedure	The mappings App\Entity\Procedure#enterprise and App\Entity\Enterprise#procedures are inconsistent with each other. The association App\Entity\Procedure#typeProcess refers to the inverse side field App\Entity\TypeProcess#procedures which does not exist. The field App\Entity\Procedure#sites is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Site#procedures does not contain the required 'inversedBy="sites"' attribute. The field App\Entity\Procedure#appointments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Appointment#procedures does not contain the required 'inversedBy="appointments"' attribute. The field App\Entity\Procedure#procedureWindows is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProcedureWindow#procedures does not contain the required 'inversedBy="procedureWindows"' attribute. The field App\Entity\Procedure#ticketDispensers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TicketDispenser#enabledProcedures does not contain the required 'inversedBy="ticketDispensers"' attribute.
App\Entity\Intern	No errors.
App\Entity\Turn	The mappings App\Entity\Turn#citizenTurn and App\Entity\CitizenTurn#turns are inconsistent with each other. The mappings App\Entity\Turn#remember_turns and App\Entity\RememberTurn#turn are inconsistent with each other.
App\Entity\Category	The mappings App\Entity\Category#formTemplate and App\Entity\FormTemplate#categories are inconsistent with each other. The field App\Entity\Category#sites is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Site#categories does not contain the required 'inversedBy="sites"' attribute.
App\Entity\Site	The mappings App\Entity\Site#city and App\Entity\City#sites are inconsistent with each other. The mappings App\Entity\Site#enterprise and App\Entity\Enterprise#sites are inconsistent with each other. The association App\Entity\Site#waitingRooms refers to the owning side field App\Entity\WaitingRoom#sites which does not exist. The association App\Entity\Site#ticketDispensers refers to the owning side field App\Entity\TicketDispenser#sites which does not exist.
App\Entity\Display	No errors.
App\Entity\City	The association App\Entity\City#sites refers to the owning side field App\Entity\Site#City which does not exist. The association App\Entity\City#id_Department refers to the inverse side field App\Entity\Department#Cities which does not exist.
App\Entity\Enterprise	The association App\Entity\Enterprise#sites refers to the owning side field App\Entity\Site#Enterprise which does not exist. The field App\Entity\Enterprise#videos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Video#enterprises does not contain the required 'inversedBy="videos"' attribute. The association App\Entity\Enterprise#procedures refers to the owning side field App\Entity\Procedure#Enterprise which does not exist. The field App\Entity\Enterprise#formTemplates is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\FormTemplate#enterprises does not contain the required 'inversedBy="formTemplates"' attribute. The field App\Entity\Enterprise#interns is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Intern#enterprises does not contain the required 'inversedBy="interns"' attribute. The field App\Entity\Enterprise#messages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Message#enterprises does not contain the required 'inversedBy="messages"' attribute. The field App\Entity\Enterprise#schedule is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Schedule#enterprises does not contain the required 'inversedBy="schedule"' attribute.
App\Entity\TicketDispenser	The mappings App\Entity\TicketDispenser#site and App\Entity\Site#ticketDispensers are inconsistent with each other. If association App\Entity\TicketDispenser#site is many-to-one, then the inversed side App\Entity\Site#ticketDispensers has to be one-to-many. If association App\Entity\TicketDispenser#intern is many-to-one, then the inversed side App\Entity\Intern#ticketDispensers has to be one-to-many.
App\Entity\Video	The field App\Entity\Video#displays is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Display#videos does not contain the required 'inversedBy="displays"' attribute.
App\Entity\FormTemplate	The field App\Entity\FormTemplate#tramite is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Procedure#form does not contain the required 'inversedBy="tramite"' attribute. The field App\Entity\FormTemplate#turnProcedure is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Procedure#turnForm does not contain the required 'inversedBy="turnProcedure"' attribute. The association App\Entity\FormTemplate#categories refers to the owning side field App\Entity\Category#formTemplates which does not exist.
App\Entity\Message	The field App\Entity\Message#displays is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Display#messages does not contain the required 'inversedBy="displays"' attribute.
App\Entity\TypeProcess	No errors.
App\Entity\ProceduresOrder	No errors.
App\Entity\Appointment	The mappings App\Entity\Appointment#passportschedulingRequest and App\Entity\PassportSchedulingRequest#appointment are inconsistent with each other.
App\Entity\ScheduleData	The mappings App\Entity\ScheduleData#templateInterval and App\Entity\TemplateInterval#scheduleData are inconsistent with each other.
App\Entity\SchedulingRequest	The association App\Entity\SchedulingRequest#responsibleType refers to the inverse side field App\Entity\ResponsibleType#schedulingRequest which does not exist. The mappings App\Entity\SchedulingRequest#documentTypeApoderado and App\Entity\DocumentType#schedulingRequest are inconsistent with each other. The mappings App\Entity\SchedulingRequest#documentTypeInfractor and App\Entity\DocumentType#schedulingRequest are inconsistent with each other. The mappings App\Entity\SchedulingRequest#documentTypePropietario and App\Entity\DocumentType#schedulingRequest are inconsistent with each other.
App\Entity\Citizen	The association App\Entity\Citizen#enterprises refers to the owning side field App\Entity\Enterprise#citizens which does not exist.
App\Entity\Theme	No errors.

Symfony Profiler

GET https://demo.appoloatiende.com/home/agendar

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping