Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.primernombre AS primernombre_2,
  t0.segundonombre AS segundonombre_3,
  t0.primerapellido AS primerapellido_4,
  t0.segundoapellido AS segundoapellido_5,
  t0.documento AS documento_6,
  t0.estado AS estado_7,
  t0.fechanacimiento AS fechanacimiento_8,
  t0.direccion AS direccion_9,
  t0.telefono AS telefono_10,
  t0.email AS email_11,
  t0.idintegracion AS idintegracion_12,
  t0.documentfile AS documentfile_13,
  t0.tipodocumento_id AS tipodocumento_id_14,
  t0.municipio_id AS municipio_id_15,
  t0.empresa_id AS empresa_id_16,
  t0.tipopago_id AS tipopago_id_17,
  t0.catalogoprecio_id AS catalogoprecio_id_18,
  t0.tipocliente_id AS tipocliente_id_19,
  t0.resptributaria_id AS resptributaria_id_20,
  t0.posicionfiscal_id AS posicionfiscal_id_21
FROM
  persona t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.primernombre AS primernombre_2, t0.segundonombre AS segundonombre_3, t0.primerapellido AS primerapellido_4, t0.segundoapellido AS segundoapellido_5, t0.documento AS documento_6, t0.estado AS estado_7, t0.fechanacimiento AS fechanacimiento_8, t0.direccion AS direccion_9, t0.telefono AS telefono_10, t0.email AS email_11, t0.idintegracion AS idintegracion_12, t0.documentfile AS documentfile_13, t0.tipodocumento_id AS tipodocumento_id_14, t0.municipio_id AS municipio_id_15, t0.empresa_id AS empresa_id_16, t0.tipopago_id AS tipopago_id_17, t0.catalogoprecio_id AS catalogoprecio_id_18, t0.tipocliente_id AS tipocliente_id_19, t0.resptributaria_id AS resptributaria_id_20, t0.posicionfiscal_id AS posicionfiscal_id_21 FROM persona t0 WHERE t0.id = 3454;

SELECT
  t0.id AS id_1,
  t0.precio AS precio_2,
  t0.valorasegurado AS valorasegurado_3,
  t0.duracion AS duracion_4,
  t0.observacion AS observacion_5,
  t0.fechaprocedimiento AS fechaprocedimiento_6,
  t0.fechacreacion AS fechacreacion_7,
  t0.fechaenviada AS fechaenviada_8,
  t0.urldocidentificacion AS urldocidentificacion_9,
  t0.urlcobertura AS urlcobertura_10,
  t0.urlcomprobantepago AS urlcomprobantepago_11,
  t0.tipopersonafacturacion AS tipopersonafacturacion_12,
  t0.sincronizado AS sincronizado_13,
  t0.pedidoodoo AS pedidoodoo_14,
  t0.edad AS edad_15,
  t0.estatura AS estatura_16,
  t0.peso AS peso_17,
  t0.asa AS asa_18,
  t0.hemoglobina AS hemoglobina_19,
  t0.anexos AS anexos_20,
  t0.certificado AS certificado_21,
  t0.fechamodificacion AS fechamodificacion_22,
  t0.nombreodoo AS nombreodoo_23,
  t0.consumidorfinal AS consumidorfinal_24,
  t0.usuario_id AS usuario_id_25,
  t0.profesional_id AS profesional_id_26,
  t0.asistente_id AS asistente_id_27,
  t0.paciente_id AS paciente_id_28,
  t0.entidad_id AS entidad_id_29,
  t0.paquetecobertura_id AS paquetecobertura_id_30,
  t0.estado_id AS estado_id_31,
  t0.especialidad_id AS especialidad_id_32,
  t0.municipio_id AS municipio_id_33,
  t0.poliza_id AS poliza_id_34,
  t0.personafacturacion_id AS personafacturacion_id_35,
  t0.empresafacturacion_id AS empresafacturacion_id_36,
  t0.usuariocancela_id AS usuariocancela_id_37,
  t0.usuariomodifica_id AS usuariomodifica_id_38,
  t0.tipopago_id AS tipopago_id_39
FROM
  solicitudcobertura t0
WHERE
  t0.profesional_id = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.precio AS precio_2, t0.valorasegurado AS valorasegurado_3, t0.duracion AS duracion_4, t0.observacion AS observacion_5, t0.fechaprocedimiento AS fechaprocedimiento_6, t0.fechacreacion AS fechacreacion_7, t0.fechaenviada AS fechaenviada_8, t0.urldocidentificacion AS urldocidentificacion_9, t0.urlcobertura AS urlcobertura_10, t0.urlcomprobantepago AS urlcomprobantepago_11, t0.tipopersonafacturacion AS tipopersonafacturacion_12, t0.sincronizado AS sincronizado_13, t0.pedidoodoo AS pedidoodoo_14, t0.edad AS edad_15, t0.estatura AS estatura_16, t0.peso AS peso_17, t0.asa AS asa_18, t0.hemoglobina AS hemoglobina_19, t0.anexos AS anexos_20, t0.certificado AS certificado_21, t0.fechamodificacion AS fechamodificacion_22, t0.nombreodoo AS nombreodoo_23, t0.consumidorfinal AS consumidorfinal_24, t0.usuario_id AS usuario_id_25, t0.profesional_id AS profesional_id_26, t0.asistente_id AS asistente_id_27, t0.paciente_id AS paciente_id_28, t0.entidad_id AS entidad_id_29, t0.paquetecobertura_id AS paquetecobertura_id_30, t0.estado_id AS estado_id_31, t0.especialidad_id AS especialidad_id_32, t0.municipio_id AS municipio_id_33, t0.poliza_id AS poliza_id_34, t0.personafacturacion_id AS personafacturacion_id_35, t0.empresafacturacion_id AS empresafacturacion_id_36, t0.usuariocancela_id AS usuariocancela_id_37, t0.usuariomodifica_id AS usuariomodifica_id_38, t0.tipopago_id AS tipopago_id_39 FROM solicitudcobertura t0 WHERE t0.profesional_id = 147 ORDER BY t0.id DESC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.terminosycondiciones AS terminosycondiciones_5,
  t0.suscripcion AS suscripcion_6,
  t0.persona_id AS persona_id_7,
  t0.rol_id AS rol_id_8
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.terminosycondiciones AS terminosycondiciones_5, t0.suscripcion AS suscripcion_6, t0.persona_id AS persona_id_7, t0.rol_id AS rol_id_8 FROM `user` t0 WHERE t0.id = 72;

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  solicitudcobertura s0_
WHERE
  s0_.fechaprocedimiento <= ?
  AND s0_.estado_id = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM solicitudcobertura s0_ WHERE s0_.fechaprocedimiento <= '2025-08-04 11:10:12' AND s0_.estado_id = 5;

SELECT
  t0.id AS id_1,
  t0.precio AS precio_2,
  t0.valorasegurado AS valorasegurado_3,
  t0.duracion AS duracion_4,
  t0.observacion AS observacion_5,
  t0.fechaprocedimiento AS fechaprocedimiento_6,
  t0.fechacreacion AS fechacreacion_7,
  t0.fechaenviada AS fechaenviada_8,
  t0.urldocidentificacion AS urldocidentificacion_9,
  t0.urlcobertura AS urlcobertura_10,
  t0.urlcomprobantepago AS urlcomprobantepago_11,
  t0.tipopersonafacturacion AS tipopersonafacturacion_12,
  t0.sincronizado AS sincronizado_13,
  t0.pedidoodoo AS pedidoodoo_14,
  t0.edad AS edad_15,
  t0.estatura AS estatura_16,
  t0.peso AS peso_17,
  t0.asa AS asa_18,
  t0.hemoglobina AS hemoglobina_19,
  t0.anexos AS anexos_20,
  t0.certificado AS certificado_21,
  t0.fechamodificacion AS fechamodificacion_22,
  t0.nombreodoo AS nombreodoo_23,
  t0.consumidorfinal AS consumidorfinal_24,
  t0.usuario_id AS usuario_id_25,
  t0.profesional_id AS profesional_id_26,
  t0.asistente_id AS asistente_id_27,
  t0.paciente_id AS paciente_id_28,
  t0.entidad_id AS entidad_id_29,
  t0.paquetecobertura_id AS paquetecobertura_id_30,
  t0.estado_id AS estado_id_31,
  t0.especialidad_id AS especialidad_id_32,
  t0.municipio_id AS municipio_id_33,
  t0.poliza_id AS poliza_id_34,
  t0.personafacturacion_id AS personafacturacion_id_35,
  t0.empresafacturacion_id AS empresafacturacion_id_36,
  t0.usuariocancela_id AS usuariocancela_id_37,
  t0.usuariomodifica_id AS usuariomodifica_id_38,
  t0.tipopago_id AS tipopago_id_39
FROM
  solicitudcobertura t0
WHERE
  t0.profesional_id = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.precio AS precio_2, t0.valorasegurado AS valorasegurado_3, t0.duracion AS duracion_4, t0.observacion AS observacion_5, t0.fechaprocedimiento AS fechaprocedimiento_6, t0.fechacreacion AS fechacreacion_7, t0.fechaenviada AS fechaenviada_8, t0.urldocidentificacion AS urldocidentificacion_9, t0.urlcobertura AS urlcobertura_10, t0.urlcomprobantepago AS urlcomprobantepago_11, t0.tipopersonafacturacion AS tipopersonafacturacion_12, t0.sincronizado AS sincronizado_13, t0.pedidoodoo AS pedidoodoo_14, t0.edad AS edad_15, t0.estatura AS estatura_16, t0.peso AS peso_17, t0.asa AS asa_18, t0.hemoglobina AS hemoglobina_19, t0.anexos AS anexos_20, t0.certificado AS certificado_21, t0.fechamodificacion AS fechamodificacion_22, t0.nombreodoo AS nombreodoo_23, t0.consumidorfinal AS consumidorfinal_24, t0.usuario_id AS usuario_id_25, t0.profesional_id AS profesional_id_26, t0.asistente_id AS asistente_id_27, t0.paciente_id AS paciente_id_28, t0.entidad_id AS entidad_id_29, t0.paquetecobertura_id AS paquetecobertura_id_30, t0.estado_id AS estado_id_31, t0.especialidad_id AS especialidad_id_32, t0.municipio_id AS municipio_id_33, t0.poliza_id AS poliza_id_34, t0.personafacturacion_id AS personafacturacion_id_35, t0.empresafacturacion_id AS empresafacturacion_id_36, t0.usuariocancela_id AS usuariocancela_id_37, t0.usuariomodifica_id AS usuariomodifica_id_38, t0.tipopago_id AS tipopago_id_39 FROM solicitudcobertura t0 WHERE t0.profesional_id = 147 ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.descripcion AS descripcion_2,
  t0.estado AS estado_3,
  t0.direccion AS direccion_4,
  t0.empresa_id AS empresa_id_5,
  t0.tipoentidad_id AS tipoentidad_id_6,
  t0.municipio_id AS municipio_id_7
FROM
  entidad t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.estado AS estado_3, t0.direccion AS direccion_4, t0.empresa_id AS empresa_id_5, t0.tipoentidad_id AS tipoentidad_id_6, t0.municipio_id AS municipio_id_7 FROM entidad t0 WHERE t0.id = 49;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3
FROM
  estadocobertura t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM estadocobertura t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.idfactura AS idfactura_2,
  t0.factura AS factura_3,
  t0.idcliente AS idcliente_4,
  t0.cliente AS cliente_5,
  t0.fechavencimiento AS fechavencimiento_6,
  t0.total AS total_7,
  t0.estadopago AS estadopago_8,
  t0.user_id AS user_id_9
FROM
  bloqueofactura t0
WHERE
  t0.idcliente = ?

SELECT t0.id AS id_1, t0.idfactura AS idfactura_2, t0.factura AS factura_3, t0.idcliente AS idcliente_4, t0.cliente AS cliente_5, t0.fechavencimiento AS fechavencimiento_6, t0.total AS total_7, t0.estadopago AS estadopago_8, t0.user_id AS user_id_9 FROM bloqueofactura t0 WHERE t0.idcliente = 4390;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.codigo AS codigo_3,
  t0.departamento_id AS departamento_id_4
FROM
  municipio t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.departamento_id AS departamento_id_4 FROM municipio t0 WHERE t0.id = 722;

UPDATE
  solicitudcobertura
SET
  estado_id = 12
WHERE
  fechaprocedimiento <= ?
  AND estado_id = ?

UPDATE solicitudcobertura SET estado_id = 12 WHERE fechaprocedimiento <= '2025-08-04 11:10:12' AND estado_id = 5;

SELECT
  t0.id AS id_1,
  t0.numerocuenta AS numerocuenta_2,
  t0.anioexperiencia AS anioexperiencia_3,
  t0.tarjetaprofesional AS tarjetaprofesional_4,
  t0.validacion AS validacion_5,
  t0.persona_id AS persona_id_6,
  t0.profesion_id AS profesion_id_7,
  t0.banco_id AS banco_id_8,
  t0.tipocuenta_id AS tipocuenta_id_9,
  t0.comercial_id AS comercial_id_10,
  t0.poliza_id AS poliza_id_11,
  t0.estado_id AS estado_id_12,
  t0.tipofacturacion_id AS tipofacturacion_id_13,
  t0.razonsocialfacturacion_id AS razonsocialfacturacion_id_14,
  t0.catalogoventa_id AS catalogoventa_id_15
FROM
  profesionales t0
WHERE
  t0.persona_id = ?

SELECT t0.id AS id_1, t0.numerocuenta AS numerocuenta_2, t0.anioexperiencia AS anioexperiencia_3, t0.tarjetaprofesional AS tarjetaprofesional_4, t0.validacion AS validacion_5, t0.persona_id AS persona_id_6, t0.profesion_id AS profesion_id_7, t0.banco_id AS banco_id_8, t0.tipocuenta_id AS tipocuenta_id_9, t0.comercial_id AS comercial_id_10, t0.poliza_id AS poliza_id_11, t0.estado_id AS estado_id_12, t0.tipofacturacion_id AS tipofacturacion_id_13, t0.razonsocialfacturacion_id AS razonsocialfacturacion_id_14, t0.catalogoventa_id AS catalogoventa_id_15 FROM profesionales t0 WHERE t0.persona_id = 230;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3
FROM
  rol t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM rol t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.descripcion AS descripcion_2,
  t0.abreviatura AS abreviatura_3,
  t0.tipodocumentodian AS tipodocumentodian_4,
  t0.idodoo AS idodoo_5
FROM
  tipodocumento t0

SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.abreviatura AS abreviatura_3, t0.tipodocumentodian AS tipodocumentodian_4, t0.idodoo AS idodoo_5 FROM tipodocumento t0;