Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.cedula AS cedula_2,
  t0.apellido1 AS apellido1_3,
  t0.apellido2 AS apellido2_4,
  t0.nombre1 AS nombre1_5,
  t0.nombre2 AS nombre2_6,
  t0.fecha_nacimiento AS fecha_nacimiento_7,
  t0.telefono AS telefono_8,
  t0.direccion AS direccion_9,
  t0.sexo AS sexo_10,
  t0.estado_civil AS estado_civil_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.email AS email_14,
  t0.celular AS celular_15,
  t0.copia_cedula AS copia_cedula_16,
  t0.ciudad AS ciudad_17,
  t0.lugar_nacimiento AS lugar_nacimiento_18,
  t0.referido AS referido_19,
  t0.cedula_familiar AS cedula_familiar_20,
  t0.parentesco AS parentesco_21,
  t0.nombres_familiar AS nombres_familiar_22,
  t0.telefono_familiar AS telefono_familiar_23,
  t0.alcohol AS alcohol_24,
  t0.tabaco AS tabaco_25,
  t0.drogas AS drogas_26,
  t0.habitos_fisiologicos AS habitos_fisiologicos_27,
  t0.enfermedad_de_la_infancia AS enfermedad_de_la_infancia_28,
  t0.mas_antecedentes_personales AS mas_antecedentes_personales_29,
  t0.antecedentes_quirurgicos AS antecedentes_quirurgicos_30,
  t0.antecedentes_familiares AS antecedentes_familiares_31,
  t0.grupo_sanguineo AS grupo_sanguineo_32,
  t0.enfermedad AS enfermedad_33,
  t0.alergias AS alergias_34,
  t0.medicacion AS medicacion_35,
  t0.ago AS ago_36,
  t0.fum AS fum_37,
  t0.gesta AS gesta_38,
  t0.abo AS abo_39,
  t0.para AS para_40,
  t0.cesa AS cesa_41,
  t0.provincia_residencia AS provincia_residencia_42,
  t0.parroquia_residencia AS parroquia_residencia_43,
  t0.pais AS pais_44,
  t0.cedula_jpg AS cedula_jpg_45,
  t0.tipo_firma AS tipo_firma_46,
  t0.barrio AS barrio_47,
  t0.canton AS canton_48,
  t0.zona AS zona_49,
  t0.grupo_cultural AS grupo_cultural_50,
  t0.instruccion AS instruccion_51,
  t0.ocupacion AS ocupacion_52,
  t0.empresa AS empresa_53,
  t0.apf_alergico AS apf_alergico_54,
  t0.apf_clinico AS apf_clinico_55,
  t0.apf_ginecolo AS apf_ginecolo_56,
  t0.apf_trauma AS apf_trauma_57,
  t0.apf_quirur AS apf_quirur_58,
  t0.apf_farma AS apf_farma_59,
  t0.apf_psiquia AS apf_psiquia_60,
  t0.apf_otro AS apf_otro_61,
  t0.direccion_familiar AS direccion_familiar_62,
  t0.cedula_mama AS cedula_mama_63,
  t0.cedula_papa AS cedula_papa_64,
  t0.recomendacion AS recomendacion_65,
  t0.vacuna_covid AS vacuna_covid_66,
  t0.alias AS alias_67,
  t0.hijos AS hijos_68,
  t0.region AS region_69,
  t0.contrato AS contrato_70,
  t0.salud_producto AS salud_producto_71,
  t0.salud_nropersona AS salud_nropersona_72,
  t0.salud_nivel AS salud_nivel_73,
  t0.observacion AS observacion_74,
  t0.paciente_endoscopias AS paciente_endoscopias_75,
  t0.paciente_bariatrico AS paciente_bariatrico_76,
  t0.user_id AS user_id_77,
  t0.seguro_id AS seguro_id_78,
  t0.recomendado_id AS recomendado_id_79,
  t0.redsocial_id AS redsocial_id_80
FROM
  paciente t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cedula AS cedula_2, t0.apellido1 AS apellido1_3, t0.apellido2 AS apellido2_4, t0.nombre1 AS nombre1_5, t0.nombre2 AS nombre2_6, t0.fecha_nacimiento AS fecha_nacimiento_7, t0.telefono AS telefono_8, t0.direccion AS direccion_9, t0.sexo AS sexo_10, t0.estado_civil AS estado_civil_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.email AS email_14, t0.celular AS celular_15, t0.copia_cedula AS copia_cedula_16, t0.ciudad AS ciudad_17, t0.lugar_nacimiento AS lugar_nacimiento_18, t0.referido AS referido_19, t0.cedula_familiar AS cedula_familiar_20, t0.parentesco AS parentesco_21, t0.nombres_familiar AS nombres_familiar_22, t0.telefono_familiar AS telefono_familiar_23, t0.alcohol AS alcohol_24, t0.tabaco AS tabaco_25, t0.drogas AS drogas_26, t0.habitos_fisiologicos AS habitos_fisiologicos_27, t0.enfermedad_de_la_infancia AS enfermedad_de_la_infancia_28, t0.mas_antecedentes_personales AS mas_antecedentes_personales_29, t0.antecedentes_quirurgicos AS antecedentes_quirurgicos_30, t0.antecedentes_familiares AS antecedentes_familiares_31, t0.grupo_sanguineo AS grupo_sanguineo_32, t0.enfermedad AS enfermedad_33, t0.alergias AS alergias_34, t0.medicacion AS medicacion_35, t0.ago AS ago_36, t0.fum AS fum_37, t0.gesta AS gesta_38, t0.abo AS abo_39, t0.para AS para_40, t0.cesa AS cesa_41, t0.provincia_residencia AS provincia_residencia_42, t0.parroquia_residencia AS parroquia_residencia_43, t0.pais AS pais_44, t0.cedula_jpg AS cedula_jpg_45, t0.tipo_firma AS tipo_firma_46, t0.barrio AS barrio_47, t0.canton AS canton_48, t0.zona AS zona_49, t0.grupo_cultural AS grupo_cultural_50, t0.instruccion AS instruccion_51, t0.ocupacion AS ocupacion_52, t0.empresa AS empresa_53, t0.apf_alergico AS apf_alergico_54, t0.apf_clinico AS apf_clinico_55, t0.apf_ginecolo AS apf_ginecolo_56, t0.apf_trauma AS apf_trauma_57, t0.apf_quirur AS apf_quirur_58, t0.apf_farma AS apf_farma_59, t0.apf_psiquia AS apf_psiquia_60, t0.apf_otro AS apf_otro_61, t0.direccion_familiar AS direccion_familiar_62, t0.cedula_mama AS cedula_mama_63, t0.cedula_papa AS cedula_papa_64, t0.recomendacion AS recomendacion_65, t0.vacuna_covid AS vacuna_covid_66, t0.alias AS alias_67, t0.hijos AS hijos_68, t0.region AS region_69, t0.contrato AS contrato_70, t0.salud_producto AS salud_producto_71, t0.salud_nropersona AS salud_nropersona_72, t0.salud_nivel AS salud_nivel_73, t0.observacion AS observacion_74, t0.paciente_endoscopias AS paciente_endoscopias_75, t0.paciente_bariatrico AS paciente_bariatrico_76, t0.user_id AS user_id_77, t0.seguro_id AS seguro_id_78, t0.recomendado_id AS recomendado_id_79, t0.redsocial_id AS redsocial_id_80 FROM paciente t0 WHERE t0.id = 209;

SELECT
  t0.id AS id_1,
  t0.motivo AS motivo_2,
  t0.evolucion AS evolucion_3,
  t0.examen_fisico AS examen_fisico_4,
  t0.indicaciones AS indicaciones_5,
  t0.estado AS estado_6,
  t0.ip_crea AS ip_crea_7,
  t0.ip_modifica AS ip_modifica_8,
  t0.user_crea AS user_crea_9,
  t0.user_modifica AS user_modifica_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.enfermedad_actual AS enfermedad_actual_13,
  t0.revision_actual_organos_y_sistemas AS revision_actual_organos_y_sistemas_14,
  t0.descripcion_certificado AS descripcion_certificado_15,
  t0.hora_espera AS hora_espera_16,
  t0.dias_reposo AS dias_reposo_17,
  t0.reposo_desde AS reposo_desde_18,
  t0.reposo_hasta AS reposo_hasta_19,
  t0.ritmo AS ritmo_20,
  t0.frecuencia AS frecuencia_21,
  t0.intervalos AS intervalos_22,
  t0.segmento_st AS segmento_st_23,
  t0.eje_electrico AS eje_electrico_24,
  t0.imp_diagnostica_ekg AS imp_diagnostica_ekg_25,
  t0.conclusion AS conclusion_26,
  t0.riesgo AS riesgo_27,
  t0.recomendaciones AS recomendaciones_28,
  t0.diagnostico_clinico_cardiologico AS diagnostico_clinico_cardiologico_29,
  t0.trabaja_en AS trabaja_en_30,
  t0.puesto_trabajo AS puesto_trabajo_31,
  t0.presenta_sintomas AS presenta_sintomas_32,
  t0.aislamiento AS aislamiento_33,
  t0.ciudad_trabajo AS ciudad_trabajo_34,
  t0.tipo_contingencia AS tipo_contingencia_35,
  t0.certificado_evolucion AS certificado_evolucion_36,
  t0.certificado_diagnostico AS certificado_diagnostico_37,
  t0.certificado_cie10 AS certificado_cie10_38,
  t0.gota_fresca_disbiosis AS gota_fresca_disbiosis_39,
  t0.gota_fresca_cristales AS gota_fresca_cristales_40,
  t0.gota_fresca_hiperglicemia AS gota_fresca_hiperglicemia_41,
  t0.gota_fresca_hipoxia AS gota_fresca_hipoxia_42,
  t0.gota_fresca_acidez AS gota_fresca_acidez_43,
  t0.gota_fresca_inflamacion AS gota_fresca_inflamacion_44,
  t0.hlb_grado AS hlb_grado_45,
  t0.hlb_intolerancia_alimenticia AS hlb_intolerancia_alimenticia_46,
  t0.hlb_terreno_degenerativo_digestivo AS hlb_terreno_degenerativo_digestivo_47,
  t0.hlb_terreno_artrosico AS hlb_terreno_artrosico_48,
  t0.hlb_cnr AS hlb_cnr_49,
  t0.hlb_irritabilidad_nerviosa AS hlb_irritabilidad_nerviosa_50,
  t0.hlb_colesterol AS hlb_colesterol_51,
  t0.hlb_proceso_hepatico AS hlb_proceso_hepatico_52,
  t0.hlb_alergia AS hlb_alergia_53,
  t0.hlb_estres AS hlb_estres_54,
  t0.hlb_inflamacion AS hlb_inflamacion_55,
  t0.hlb_anemia AS hlb_anemia_56,
  t0.hlb_afectacion_muscular AS hlb_afectacion_muscular_57,
  t0.hlb_sol_toxico AS hlb_sol_toxico_58,
  t0.hlb_congestion_linfatica AS hlb_congestion_linfatica_59,
  t0.agenda_id AS agenda_id_60,
  t0.paciente_id AS paciente_id_61
FROM
  historia_clinica t0
WHERE
  t0.agenda_id = ?

SELECT t0.id AS id_1, t0.motivo AS motivo_2, t0.evolucion AS evolucion_3, t0.examen_fisico AS examen_fisico_4, t0.indicaciones AS indicaciones_5, t0.estado AS estado_6, t0.ip_crea AS ip_crea_7, t0.ip_modifica AS ip_modifica_8, t0.user_crea AS user_crea_9, t0.user_modifica AS user_modifica_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.enfermedad_actual AS enfermedad_actual_13, t0.revision_actual_organos_y_sistemas AS revision_actual_organos_y_sistemas_14, t0.descripcion_certificado AS descripcion_certificado_15, t0.hora_espera AS hora_espera_16, t0.dias_reposo AS dias_reposo_17, t0.reposo_desde AS reposo_desde_18, t0.reposo_hasta AS reposo_hasta_19, t0.ritmo AS ritmo_20, t0.frecuencia AS frecuencia_21, t0.intervalos AS intervalos_22, t0.segmento_st AS segmento_st_23, t0.eje_electrico AS eje_electrico_24, t0.imp_diagnostica_ekg AS imp_diagnostica_ekg_25, t0.conclusion AS conclusion_26, t0.riesgo AS riesgo_27, t0.recomendaciones AS recomendaciones_28, t0.diagnostico_clinico_cardiologico AS diagnostico_clinico_cardiologico_29, t0.trabaja_en AS trabaja_en_30, t0.puesto_trabajo AS puesto_trabajo_31, t0.presenta_sintomas AS presenta_sintomas_32, t0.aislamiento AS aislamiento_33, t0.ciudad_trabajo AS ciudad_trabajo_34, t0.tipo_contingencia AS tipo_contingencia_35, t0.certificado_evolucion AS certificado_evolucion_36, t0.certificado_diagnostico AS certificado_diagnostico_37, t0.certificado_cie10 AS certificado_cie10_38, t0.gota_fresca_disbiosis AS gota_fresca_disbiosis_39, t0.gota_fresca_cristales AS gota_fresca_cristales_40, t0.gota_fresca_hiperglicemia AS gota_fresca_hiperglicemia_41, t0.gota_fresca_hipoxia AS gota_fresca_hipoxia_42, t0.gota_fresca_acidez AS gota_fresca_acidez_43, t0.gota_fresca_inflamacion AS gota_fresca_inflamacion_44, t0.hlb_grado AS hlb_grado_45, t0.hlb_intolerancia_alimenticia AS hlb_intolerancia_alimenticia_46, t0.hlb_terreno_degenerativo_digestivo AS hlb_terreno_degenerativo_digestivo_47, t0.hlb_terreno_artrosico AS hlb_terreno_artrosico_48, t0.hlb_cnr AS hlb_cnr_49, t0.hlb_irritabilidad_nerviosa AS hlb_irritabilidad_nerviosa_50, t0.hlb_colesterol AS hlb_colesterol_51, t0.hlb_proceso_hepatico AS hlb_proceso_hepatico_52, t0.hlb_alergia AS hlb_alergia_53, t0.hlb_estres AS hlb_estres_54, t0.hlb_inflamacion AS hlb_inflamacion_55, t0.hlb_anemia AS hlb_anemia_56, t0.hlb_afectacion_muscular AS hlb_afectacion_muscular_57, t0.hlb_sol_toxico AS hlb_sol_toxico_58, t0.hlb_congestion_linfatica AS hlb_congestion_linfatica_59, t0.agenda_id AS agenda_id_60, t0.paciente_id AS paciente_id_61 FROM historia_clinica t0 WHERE t0.agenda_id = 1260;

SELECT
  t0.id AS id_1,
  t0.grupo_sanquineo AS grupo_sanquineo_2,
  t0.presion AS presion_3,
  t0.pulso AS pulso_4,
  t0.temperatura AS temperatura_5,
  t0.estatura AS estatura_6,
  t0.peso AS peso_7,
  t0.estado AS estado_8,
  t0.ip_crea AS ip_crea_9,
  t0.ip_modifica AS ip_modifica_10,
  t0.user_crea AS user_crea_11,
  t0.user_modifica AS user_modifica_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.observacion AS observacion_15,
  t0.frecuencia_respiratoria AS frecuencia_respiratoria_16,
  t0.saturacion_de_oxigeno AS saturacion_de_oxigeno_17,
  t0.perimetro_cefalico AS perimetro_cefalico_18,
  t0.perimetro_toraxico AS perimetro_toraxico_19,
  t0.cambio_de_peso AS cambio_de_peso_20,
  t0.agenda_id AS agenda_id_21
FROM
  preparacion t0
WHERE
  t0.agenda_id = ?

SELECT t0.id AS id_1, t0.grupo_sanquineo AS grupo_sanquineo_2, t0.presion AS presion_3, t0.pulso AS pulso_4, t0.temperatura AS temperatura_5, t0.estatura AS estatura_6, t0.peso AS peso_7, t0.estado AS estado_8, t0.ip_crea AS ip_crea_9, t0.ip_modifica AS ip_modifica_10, t0.user_crea AS user_crea_11, t0.user_modifica AS user_modifica_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.observacion AS observacion_15, t0.frecuencia_respiratoria AS frecuencia_respiratoria_16, t0.saturacion_de_oxigeno AS saturacion_de_oxigeno_17, t0.perimetro_cefalico AS perimetro_cefalico_18, t0.perimetro_toraxico AS perimetro_toraxico_19, t0.cambio_de_peso AS cambio_de_peso_20, t0.agenda_id AS agenda_id_21 FROM preparacion t0 WHERE t0.agenda_id = 1260;

SELECT
  t0.id AS id_1,
  t0.ip_crea AS ip_crea_2,
  t0.ip_modifica AS ip_modifica_3,
  t0.user_crea AS user_crea_4,
  t0.user_modifica AS user_modifica_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.agenda_id AS agenda_id_8,
  t0.procedimiento_id AS procedimiento_id_9
FROM
  agenda_procedimiento t0
WHERE
  t0.agenda_id = ?

SELECT t0.id AS id_1, t0.ip_crea AS ip_crea_2, t0.ip_modifica AS ip_modifica_3, t0.user_crea AS user_crea_4, t0.user_modifica AS user_modifica_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.agenda_id AS agenda_id_8, t0.procedimiento_id AS procedimiento_id_9 FROM agenda_procedimiento t0 WHERE t0.agenda_id = 1260;

SELECT
  a0_.id AS id_0,
  a0_.inicio AS inicio_1,
  a0_.fin AS fin_2,
  a0_.estado AS estado_3,
  a0_.ip_crea AS ip_crea_4,
  a0_.ip_modifica AS ip_modifica_5,
  a0_.user_crea AS user_crea_6,
  a0_.user_modifica AS user_modifica_7,
  a0_.created_at AS created_at_8,
  a0_.updated_at AS updated_at_9,
  a0_.observacion AS observacion_10,
  a0_.estado_agenda AS estado_agenda_11,
  a0_.archivo053 AS archivo053_12,
  a0_.tipo_consulta AS tipo_consulta_13,
  a0_.origen AS origen_14,
  a0_.fecha_consulta AS fecha_consulta_15,
  a0_.cie10_recep AS cie10_recep_16,
  a0_.validacion AS validacion_17,
  a0_.cobrado AS cobrado_18,
  a0_.factura AS factura_19,
  a0_.fecha_factura AS fecha_factura_20,
  a0_.fecha_pago AS fecha_pago_21,
  a0_.verificado AS verificado_22,
  a0_.confirma AS confirma_23,
  a0_.corte_seguro AS corte_seguro_24,
  a0_.salud_producto AS salud_producto_25,
  a0_.salud_nropersona AS salud_nropersona_26,
  a0_.salud_nivel AS salud_nivel_27,
  a0_.documentos AS documentos_28,
  a0_.wid AS wid_29,
  a0_.paciente_id AS paciente_id_30,
  a0_.doctor_id AS doctor_id_31,
  a0_.sala_id AS sala_id_32,
  a0_.seguro_id AS seguro_id_33,
  a0_.especialidad_id AS especialidad_id_34,
  a0_.procedimiento_id AS procedimiento_id_35,
  a0_.doctor_consulta_id AS doctor_consulta_id_36,
  a0_.origen_especialidad_id AS origen_especialidad_id_37,
  a0_.anestesiologo_id AS anestesiologo_id_38,
  a0_.recomendado_id AS recomendado_id_39,
  a0_.redsocial_id AS redsocial_id_40,
  a0_.referencia_id AS referencia_id_41
FROM
  agenda a0_
  INNER JOIN sala s1_ ON a0_.sala_id = s1_.id
WHERE
  (
    (
      a0_.inicio BETWEEN ?
      AND ?
    )
    OR (
      a0_.fin BETWEEN ?
      AND ?
    )
  )
  AND a0_.sala_id = ?
  AND a0_.estado = ?

SELECT a0_.id AS id_0, a0_.inicio AS inicio_1, a0_.fin AS fin_2, a0_.estado AS estado_3, a0_.ip_crea AS ip_crea_4, a0_.ip_modifica AS ip_modifica_5, a0_.user_crea AS user_crea_6, a0_.user_modifica AS user_modifica_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.observacion AS observacion_10, a0_.estado_agenda AS estado_agenda_11, a0_.archivo053 AS archivo053_12, a0_.tipo_consulta AS tipo_consulta_13, a0_.origen AS origen_14, a0_.fecha_consulta AS fecha_consulta_15, a0_.cie10_recep AS cie10_recep_16, a0_.validacion AS validacion_17, a0_.cobrado AS cobrado_18, a0_.factura AS factura_19, a0_.fecha_factura AS fecha_factura_20, a0_.fecha_pago AS fecha_pago_21, a0_.verificado AS verificado_22, a0_.confirma AS confirma_23, a0_.corte_seguro AS corte_seguro_24, a0_.salud_producto AS salud_producto_25, a0_.salud_nropersona AS salud_nropersona_26, a0_.salud_nivel AS salud_nivel_27, a0_.documentos AS documentos_28, a0_.wid AS wid_29, a0_.paciente_id AS paciente_id_30, a0_.doctor_id AS doctor_id_31, a0_.sala_id AS sala_id_32, a0_.seguro_id AS seguro_id_33, a0_.especialidad_id AS especialidad_id_34, a0_.procedimiento_id AS procedimiento_id_35, a0_.doctor_consulta_id AS doctor_consulta_id_36, a0_.origen_especialidad_id AS origen_especialidad_id_37, a0_.anestesiologo_id AS anestesiologo_id_38, a0_.recomendado_id AS recomendado_id_39, a0_.redsocial_id AS redsocial_id_40, a0_.referencia_id AS referencia_id_41 FROM agenda a0_ INNER JOIN sala s1_ ON a0_.sala_id = s1_.id WHERE ((a0_.inicio BETWEEN '2026-03-02' AND '2026-03-09') OR (a0_.fin BETWEEN '2026-03-02' AND '2026-03-09')) AND a0_.sala_id = 1 AND a0_.estado = 1;

SELECT
  a0_.id AS id_0,
  a0_.inicio AS inicio_1,
  a0_.fin AS fin_2,
  a0_.estado AS estado_3,
  a0_.ip_crea AS ip_crea_4,
  a0_.ip_modifica AS ip_modifica_5,
  a0_.user_crea AS user_crea_6,
  a0_.user_modifica AS user_modifica_7,
  a0_.created_at AS created_at_8,
  a0_.updated_at AS updated_at_9,
  a0_.observacion AS observacion_10,
  a0_.estado_agenda AS estado_agenda_11,
  a0_.archivo053 AS archivo053_12,
  a0_.tipo_consulta AS tipo_consulta_13,
  a0_.origen AS origen_14,
  a0_.fecha_consulta AS fecha_consulta_15,
  a0_.cie10_recep AS cie10_recep_16,
  a0_.validacion AS validacion_17,
  a0_.cobrado AS cobrado_18,
  a0_.factura AS factura_19,
  a0_.fecha_factura AS fecha_factura_20,
  a0_.fecha_pago AS fecha_pago_21,
  a0_.verificado AS verificado_22,
  a0_.confirma AS confirma_23,
  a0_.corte_seguro AS corte_seguro_24,
  a0_.salud_producto AS salud_producto_25,
  a0_.salud_nropersona AS salud_nropersona_26,
  a0_.salud_nivel AS salud_nivel_27,
  a0_.documentos AS documentos_28,
  a0_.wid AS wid_29,
  a0_.paciente_id AS paciente_id_30,
  a0_.doctor_id AS doctor_id_31,
  a0_.sala_id AS sala_id_32,
  a0_.seguro_id AS seguro_id_33,
  a0_.especialidad_id AS especialidad_id_34,
  a0_.procedimiento_id AS procedimiento_id_35,
  a0_.doctor_consulta_id AS doctor_consulta_id_36,
  a0_.origen_especialidad_id AS origen_especialidad_id_37,
  a0_.anestesiologo_id AS anestesiologo_id_38,
  a0_.recomendado_id AS recomendado_id_39,
  a0_.redsocial_id AS redsocial_id_40,
  a0_.referencia_id AS referencia_id_41
FROM
  agenda a0_
WHERE
  (
    a0_.inicio BETWEEN ?
    AND ?
    OR a0_.fin BETWEEN ?
    AND ?
  )
  AND a0_.sala_id = ?
  AND a0_.estado = ?

SELECT a0_.id AS id_0, a0_.inicio AS inicio_1, a0_.fin AS fin_2, a0_.estado AS estado_3, a0_.ip_crea AS ip_crea_4, a0_.ip_modifica AS ip_modifica_5, a0_.user_crea AS user_crea_6, a0_.user_modifica AS user_modifica_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.observacion AS observacion_10, a0_.estado_agenda AS estado_agenda_11, a0_.archivo053 AS archivo053_12, a0_.tipo_consulta AS tipo_consulta_13, a0_.origen AS origen_14, a0_.fecha_consulta AS fecha_consulta_15, a0_.cie10_recep AS cie10_recep_16, a0_.validacion AS validacion_17, a0_.cobrado AS cobrado_18, a0_.factura AS factura_19, a0_.fecha_factura AS fecha_factura_20, a0_.fecha_pago AS fecha_pago_21, a0_.verificado AS verificado_22, a0_.confirma AS confirma_23, a0_.corte_seguro AS corte_seguro_24, a0_.salud_producto AS salud_producto_25, a0_.salud_nropersona AS salud_nropersona_26, a0_.salud_nivel AS salud_nivel_27, a0_.documentos AS documentos_28, a0_.wid AS wid_29, a0_.paciente_id AS paciente_id_30, a0_.doctor_id AS doctor_id_31, a0_.sala_id AS sala_id_32, a0_.seguro_id AS seguro_id_33, a0_.especialidad_id AS especialidad_id_34, a0_.procedimiento_id AS procedimiento_id_35, a0_.doctor_consulta_id AS doctor_consulta_id_36, a0_.origen_especialidad_id AS origen_especialidad_id_37, a0_.anestesiologo_id AS anestesiologo_id_38, a0_.recomendado_id AS recomendado_id_39, a0_.redsocial_id AS redsocial_id_40, a0_.referencia_id AS referencia_id_41 FROM agenda a0_ WHERE (a0_.inicio BETWEEN '2026-03-02' AND '2026-03-09' OR a0_.fin BETWEEN '2026-03-02' AND '2026-03-09') AND a0_.sala_id = 1 AND a0_.estado = 2;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.apellido1 AS apellido1_3,
  t0.apellido2 AS apellido2_4,
  t0.nombre1 AS nombre1_5,
  t0.nombre2 AS nombre2_6,
  t0.roles AS roles_7,
  t0.password AS password_8,
  t0.cedula AS cedula_9,
  t0.estado AS estado_10,
  t0.firma AS firma_11,
  t0.cod_senescyt AS cod_senescyt_12,
  t0.titulo AS titulo_13,
  t0.titulo_abrev AS titulo_abrev_14,
  t0.color AS color_15,
  t0.dr AS dr_16,
  t0.tipousuario_id AS tipousuario_id_17,
  t0.especialidad_id AS especialidad_id_18
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.apellido1 AS apellido1_3, t0.apellido2 AS apellido2_4, t0.nombre1 AS nombre1_5, t0.nombre2 AS nombre2_6, t0.roles AS roles_7, t0.password AS password_8, t0.cedula AS cedula_9, t0.estado AS estado_10, t0.firma AS firma_11, t0.cod_senescyt AS cod_senescyt_12, t0.titulo AS titulo_13, t0.titulo_abrev AS titulo_abrev_14, t0.color AS color_15, t0.dr AS dr_16, t0.tipousuario_id AS tipousuario_id_17, t0.especialidad_id AS especialidad_id_18 FROM user t0 WHERE t0.id = 31;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.observacion AS observacion_3,
  t0.estado AS estado_4,
  t0.ip_crea AS ip_crea_5,
  t0.ip_modifica AS ip_modifica_6,
  t0.user_crea AS user_crea_7,
  t0.user_modifica AS user_modifica_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.tipo AS tipo_11,
  t0.imagen AS imagen_12,
  t0.color_activo AS color_activo_13,
  t0.color_inactivo AS color_inactivo_14,
  t0.producto_id AS producto_id_15,
  t0.especialidad_id AS especialidad_id_16
FROM
  procedimientos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.observacion AS observacion_3, t0.estado AS estado_4, t0.ip_crea AS ip_crea_5, t0.ip_modifica AS ip_modifica_6, t0.user_crea AS user_crea_7, t0.user_modifica AS user_modifica_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.tipo AS tipo_11, t0.imagen AS imagen_12, t0.color_activo AS color_activo_13, t0.color_inactivo AS color_inactivo_14, t0.producto_id AS producto_id_15, t0.especialidad_id AS especialidad_id_16 FROM procedimientos t0 WHERE t0.id = 45;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.estado AS estado_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.tipo AS tipo_6,
  t0.user_crea AS user_crea_7,
  t0.user_modifica AS user_modifica_8,
  t0.ip_crea AS ip_crea_9,
  t0.ip_modifica AS ip_modifica_10,
  t0.color AS color_11
FROM
  seguro_privado t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.estado AS estado_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.tipo AS tipo_6, t0.user_crea AS user_crea_7, t0.user_modifica AS user_modifica_8, t0.ip_crea AS ip_crea_9, t0.ip_modifica AS ip_modifica_10, t0.color AS color_11 FROM seguro_privado t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.estado AS estado_3,
  t0.ip_crea AS ip_crea_4,
  t0.ip_modifica AS ip_modifica_5,
  t0.user_crea AS user_crea_6,
  t0.user_modifica AS user_modifica_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.dependencia_id AS dependencia_id_10
FROM
  especialidad t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.estado AS estado_3, t0.ip_crea AS ip_crea_4, t0.ip_modifica AS ip_modifica_5, t0.user_crea AS user_crea_6, t0.user_modifica AS user_modifica_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.dependencia_id AS dependencia_id_10 FROM especialidad t0 WHERE t0.id = 1;