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 = ?

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;

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;

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.217.145' AND s0_.fecha_hora_aceptacion_politica_datos >= '2026-04-29 00:00:00' AND s0_.fecha_hora_aceptacion_politica_datos < '2026-04-29 23:59:59';

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

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

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-04-29 20:15:09';

SELECT
  t0.id_tramite AS id_tramite_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.activo AS activo_4,
  t0.letra_turnero AS letra_turnero_5,
  t0.peso_en_franjas AS peso_en_franjas_6,
  t0.visible_citas AS visible_citas_7,
  t0.multiple AS multiple_8,
  t0.validación_citas_placa_identificacion AS validacin_citas_placa_identificacion_9,
  t0.turno_preferencial AS turno_preferencial_10,
  t0.ver_botones_fin_efectivo_no_efectivo AS ver_botones_fin_efectivo_no_efectivo_11,
  t0.posicion AS posicion_12,
  t0.ruta_doc_requisitos AS ruta_doc_requisitos_13,
  t0.tiempo_alerta AS tiempo_alerta_14,
  t0.consecutivo_tramite AS consecutivo_tramite_15,
  t0.tipo_documental AS tipo_documental_16,
  t0.codigo_categoria AS codigo_categoria_17,
  t0.id_enterprise AS id_enterprise_18,
  t0.id_tipo_tramite AS id_tipo_tramite_19
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.letra_turnero AS letra_turnero_5, t0.peso_en_franjas AS peso_en_franjas_6, t0.visible_citas AS visible_citas_7, t0.multiple AS multiple_8, t0.validación_citas_placa_identificacion AS validacin_citas_placa_identificacion_9, t0.turno_preferencial AS turno_preferencial_10, t0.ver_botones_fin_efectivo_no_efectivo AS ver_botones_fin_efectivo_no_efectivo_11, t0.posicion AS posicion_12, t0.ruta_doc_requisitos AS ruta_doc_requisitos_13, t0.tiempo_alerta AS tiempo_alerta_14, t0.consecutivo_tramite AS consecutivo_tramite_15, t0.tipo_documental AS tipo_documental_16, t0.codigo_categoria AS codigo_categoria_17, t0.id_enterprise AS id_enterprise_18, t0.id_tipo_tramite AS id_tipo_tramite_19 FROM tramite t0 WHERE t0.id_tramite = '1';

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;