Symfony Profiler

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 = 91 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 = ?
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 = 37 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 = ?
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 = 79 LIMIT 1;

SELECT
  t0.id_tramite AS id_tramite_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.activo AS activo_4,
  t0.publico AS publico_5,
  t0.letra_turnero AS letra_turnero_6,
  t0.peso_en_franjas AS peso_en_franjas_7,
  t0.visible_citas AS visible_citas_8,
  t0.multiple AS multiple_9,
  t0.validación_citas_placa_identificacion AS validacin_citas_placa_identificacion_10,
  t0.turno_preferencial AS turno_preferencial_11,
  t0.ver_botones_fin_efectivo_no_efectivo AS ver_botones_fin_efectivo_no_efectivo_12,
  t0.posicion AS posicion_13,
  t0.ruta_doc_requisitos AS ruta_doc_requisitos_14,
  t0.tiempo_alerta AS tiempo_alerta_15,
  t0.consecutivo_tramite AS consecutivo_tramite_16,
  t0.tipo_documental AS tipo_documental_17,
  t0.codigo_categoria AS codigo_categoria_18,
  t0.id_enterprise AS id_enterprise_19,
  t0.id_tipo_tramite AS id_tipo_tramite_20
FROM
  tramite t0
WHERE
  t0.id_tramite = ?

SELECT t0.id_tramite AS id_tramite_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.activo AS activo_4, t0.publico AS publico_5, t0.letra_turnero AS letra_turnero_6, t0.peso_en_franjas AS peso_en_franjas_7, t0.visible_citas AS visible_citas_8, t0.multiple AS multiple_9, t0.validación_citas_placa_identificacion AS validacin_citas_placa_identificacion_10, t0.turno_preferencial AS turno_preferencial_11, t0.ver_botones_fin_efectivo_no_efectivo AS ver_botones_fin_efectivo_no_efectivo_12, t0.posicion AS posicion_13, t0.ruta_doc_requisitos AS ruta_doc_requisitos_14, t0.tiempo_alerta AS tiempo_alerta_15, t0.consecutivo_tramite AS consecutivo_tramite_16, t0.tipo_documental AS tipo_documental_17, t0.codigo_categoria AS codigo_categoria_18, t0.id_enterprise AS id_enterprise_19, t0.id_tipo_tramite AS id_tipo_tramite_20 FROM tramite t0 WHERE t0.id_tramite = '15';

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 = 15;

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 = 3;

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 = 3;

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 = 84;

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 = 85;

SELECT
  sd.id AS id_sede,
  sd.nombre_sede AS sede,
  f.fecha_franja AS fecha,
  COUNT(*) FILTER (
    WHERE
      f.id_tipo_estado_franja IN (1, 2, 3, 5)
  ) AS cupos_totales,
  COUNT(*) FILTER (
    WHERE
      f.id_tipo_estado_franja = 1
  ) AS cupos_disponibles
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,
  sd.nombre_sede,
  f.fecha_franja
HAVING
  COUNT(*) FILTER (
    WHERE
      f.id_tipo_estado_franja = 1
  ) > 0

SELECT sd.id AS id_sede,
                   sd.nombre_sede AS sede,
                   f.fecha_franja AS fecha,
                   COUNT(*) FILTER (WHERE f.id_tipo_estado_franja IN (1, 2, 3, 5)) AS cupos_totales,
                   COUNT(*) FILTER (WHERE f.id_tipo_estado_franja = 1) AS cupos_disponibles
            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-09-29'
              AND f.fecha_franja < CAST('2026-09-29' 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 = 15
            GROUP BY sd.id, sd.nombre_sede, f.fecha_franja
            HAVING COUNT(*) FILTER (WHERE f.id_tipo_estado_franja = 1) > 0;

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 = 3
                AND txv.tramite_id = '15'
                AND dh.activo = true;

SELECT
  f.fecha_franja AS fecha,
  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 BETWEEN :fechaIni
  AND :fechaFin
  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
  f.fecha_franja,
  f.id_tipo_estado_franja
ORDER BY
  f.fecha_franja ASC

SELECT f.fecha_franja AS fecha,
					   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 BETWEEN '2026-09-29' AND '2026-11-13'
				  AND v.activo = true
				  AND dh.activo = true
				  AND txv.tramite_id = '15'
				  AND sd.id = 3
				  AND f.id_tipo_estado_franja IN (1, 2, 3, 4, 5)
				  
				GROUP BY f.fecha_franja, f.id_tipo_estado_franja
				ORDER BY f.fecha_franja ASC
			;

SELECT
  c0_.id_categoria AS id_categoria_0,
  c0_.nombre_categoria AS nombre_categoria_1,
  c0_.activo AS activo_2,
  c0_.publico AS publico_3,
  c0_.id_empresa AS id_empresa_4
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_.publico AS publico_3, c0_.id_empresa AS id_empresa_4 FROM categorias c0_ WHERE c0_.activo = 'S';

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 = 116 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 = ?
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 = 117 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 = ?
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 = 118 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 = ?
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 = 119 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 = ?
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 = 114 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 = ?
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 = 91 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 = ?
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 = 27 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 = ?
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 = 43 LIMIT 1;

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 = 2;