Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.celular AS celular_5,
  t0.fecha_creacion AS fecha_creacion_6,
  t0.fecha_ultimo_acceso AS fecha_ultimo_acceso_7,
  t0.fecha_ultimo_cambio_password AS fecha_ultimo_cambio_password_8,
  t0.modulo_activo AS modulo_activo_9,
  t0.falta_de_pago AS falta_de_pago_10,
  t0.token_password AS token_password_11,
  t0.token_fecha AS token_fecha_12,
  t0.organizacion_activa_id AS organizacion_activa_id_13,
  t0.membresia_activa_id AS membresia_activa_id_14
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.celular AS celular_5, t0.fecha_creacion AS fecha_creacion_6, t0.fecha_ultimo_acceso AS fecha_ultimo_acceso_7, t0.fecha_ultimo_cambio_password AS fecha_ultimo_cambio_password_8, t0.modulo_activo AS modulo_activo_9, t0.falta_de_pago AS falta_de_pago_10, t0.token_password AS token_password_11, t0.token_fecha AS token_fecha_12, t0.organizacion_activa_id AS organizacion_activa_id_13, t0.membresia_activa_id AS membresia_activa_id_14 FROM user t0 WHERE t0.id = 111;

SELECT
  t0_.id AS id_0,
  t0_.dia AS dia_1,
  t0_.duracion AS duracion_2,
  t0_.sobre_turno AS sobre_turno_3,
  t0_.url_meet AS url_meet_4,
  t0_.observaciones AS observaciones_5,
  t0_.estado AS estado_6,
  t0_.origen AS origen_7,
  t0_.orden_de_llegada AS orden_de_llegada_8,
  t0_.recordatorio_enviado AS recordatorio_enviado_9,
  t0_.fecha_actualizacion AS fecha_actualizacion_10,
  t0_.medico_id AS medico_id_11,
  t0_.paciente_id AS paciente_id_12,
  t0_.establecimiento_id AS establecimiento_id_13,
  t0_.motivo_id AS motivo_id_14,
  t0_.modalidad AS modalidad_15,
  t0_.aplicacion_id AS aplicacion_id_16,
  t0_.derivado_por_id AS derivado_por_id_17,
  t0_.usuario_id AS usuario_id_18,
  t0_.organizacion AS organizacion_19,
  t0_.evolucion_paciente_id AS evolucion_paciente_id_20,
  t0_.estacion_id AS estacion_id_21
FROM
  turnos t0_
WHERE
  t0_.organizacion = ?
  AND t0_.estado < ?
  AND DATE_ADD(
    t0_.dia, INTERVAL t0_.duracion MINUTE
  ) <= DATE_SUB(
    CURRENT_TIMESTAMP, INTERVAL ? HOUR
  )

SELECT t0_.id AS id_0, t0_.dia AS dia_1, t0_.duracion AS duracion_2, t0_.sobre_turno AS sobre_turno_3, t0_.url_meet AS url_meet_4, t0_.observaciones AS observaciones_5, t0_.estado AS estado_6, t0_.origen AS origen_7, t0_.orden_de_llegada AS orden_de_llegada_8, t0_.recordatorio_enviado AS recordatorio_enviado_9, t0_.fecha_actualizacion AS fecha_actualizacion_10, t0_.medico_id AS medico_id_11, t0_.paciente_id AS paciente_id_12, t0_.establecimiento_id AS establecimiento_id_13, t0_.motivo_id AS motivo_id_14, t0_.modalidad AS modalidad_15, t0_.aplicacion_id AS aplicacion_id_16, t0_.derivado_por_id AS derivado_por_id_17, t0_.usuario_id AS usuario_id_18, t0_.organizacion AS organizacion_19, t0_.evolucion_paciente_id AS evolucion_paciente_id_20, t0_.estacion_id AS estacion_id_21 FROM turnos t0_ WHERE t0_.organizacion = 1 AND t0_.estado < 7 AND DATE_ADD(t0_.dia, INTERVAL t0_.duracion MINUTE) <= DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 6 HOUR);

SELECT
  count(DISTINCT t0_.id) AS sclr_0
FROM
  turnos t0_
  LEFT JOIN medicos m1_ ON t0_.medico_id = m1_.id
  LEFT JOIN pacientes p2_ ON t0_.paciente_id = p2_.id
WHERE
  t0_.estado < ?
  AND t0_.organizacion = ?
  AND t0_.dia > DATE_SUB(
    CURRENT_TIMESTAMP, INTERVAL 666 HOUR
  )
  AND m1_.id IN (?, ?, ?)

SELECT count(DISTINCT t0_.id) AS sclr_0 FROM turnos t0_ LEFT JOIN medicos m1_ ON t0_.medico_id = m1_.id LEFT JOIN pacientes p2_ ON t0_.paciente_id = p2_.id WHERE t0_.estado < 7 AND t0_.organizacion = 1 AND t0_.dia > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 666 HOUR) AND m1_.id IN (130, 131, 129);

SELECT
  t0_.id AS id_0,
  t0_.dia AS dia_1,
  t0_.duracion AS duracion_2,
  t0_.sobre_turno AS sobre_turno_3,
  t0_.url_meet AS url_meet_4,
  t0_.observaciones AS observaciones_5,
  t0_.estado AS estado_6,
  t0_.origen AS origen_7,
  t0_.orden_de_llegada AS orden_de_llegada_8,
  t0_.recordatorio_enviado AS recordatorio_enviado_9,
  t0_.fecha_actualizacion AS fecha_actualizacion_10,
  m1_.id AS id_11,
  m1_.apellido AS apellido_12,
  m1_.nombre AS nombre_13,
  m1_.matricula AS matricula_14,
  m1_.tratamiento AS tratamiento_15,
  m1_.duracion_turno AS duracion_turno_16,
  m1_.activo AS activo_17,
  m1_.visible AS visible_18,
  m1_.url_meet_predefinida AS url_meet_predefinida_19,
  m1_.fecha_actualizacion_url_meet AS fecha_actualizacion_url_meet_20,
  m1_.obras_sociales_config AS obras_sociales_config_21,
  p2_.id AS id_22,
  p2_.apellido AS apellido_23,
  p2_.nombre AS nombre_24,
  p2_.nro_doc AS nro_doc_25,
  p2_.fecha_nacimiento AS fecha_nacimiento_26,
  p2_.hijos AS hijos_27,
  p2_.calle AS calle_28,
  p2_.domicilio_nro AS domicilio_nro_29,
  p2_.piso AS piso_30,
  p2_.dpto AS dpto_31,
  p2_.plan_obra_social AS plan_obra_social_32,
  p2_.nro_afiliado AS nro_afiliado_33,
  p2_.celular AS celular_34,
  p2_.email AS email_35,
  p2_.fecha_primera_consulta AS fecha_primera_consulta_36,
  p2_.foto AS foto_37,
  p2_.observacion_personal AS observacion_personal_38,
  p2_.antecedentes_de_jerarquia AS antecedentes_de_jerarquia_39,
  p2_.medicacion_habitual AS medicacion_habitual_40,
  p2_.factores_riesgo AS factores_riesgo_41,
  p2_.estudios AS estudios_42,
  p2_.hta AS hta_43,
  p2_.dbt AS dbt_44,
  p2_.dlp AS dlp_45,
  p2_.tbq AS tbq_46,
  p2_.consentimiento_email AS consentimiento_email_47,
  t0_.medico_id AS medico_id_48,
  t0_.paciente_id AS paciente_id_49,
  t0_.establecimiento_id AS establecimiento_id_50,
  t0_.motivo_id AS motivo_id_51,
  t0_.modalidad AS modalidad_52,
  t0_.aplicacion_id AS aplicacion_id_53,
  t0_.derivado_por_id AS derivado_por_id_54,
  t0_.usuario_id AS usuario_id_55,
  t0_.organizacion AS organizacion_56,
  t0_.evolucion_paciente_id AS evolucion_paciente_id_57,
  t0_.estacion_id AS estacion_id_58,
  m1_.profesion_id AS profesion_id_59,
  m1_.horario_id AS horario_id_60,
  m1_.organizacion AS organizacion_61,
  p2_.genero_id AS genero_id_62,
  p2_.estado_civil_id AS estado_civil_id_63,
  p2_.localidad_id AS localidad_id_64,
  p2_.obra_social_id AS obra_social_id_65,
  p2_.organizacion AS organizacion_66
FROM
  turnos t0_
  LEFT JOIN medicos m1_ ON t0_.medico_id = m1_.id
  LEFT JOIN pacientes p2_ ON t0_.paciente_id = p2_.id
WHERE
  t0_.estado < ?
  AND t0_.organizacion = ?
  AND t0_.dia > DATE_SUB(
    CURRENT_TIMESTAMP, INTERVAL 666 HOUR
  )
  AND m1_.id IN (?, ?, ?)
  AND t0_.id IN (?, ?, ?, ?, ?)
ORDER BY
  t0_.dia ASC

SELECT t0_.id AS id_0, t0_.dia AS dia_1, t0_.duracion AS duracion_2, t0_.sobre_turno AS sobre_turno_3, t0_.url_meet AS url_meet_4, t0_.observaciones AS observaciones_5, t0_.estado AS estado_6, t0_.origen AS origen_7, t0_.orden_de_llegada AS orden_de_llegada_8, t0_.recordatorio_enviado AS recordatorio_enviado_9, t0_.fecha_actualizacion AS fecha_actualizacion_10, m1_.id AS id_11, m1_.apellido AS apellido_12, m1_.nombre AS nombre_13, m1_.matricula AS matricula_14, m1_.tratamiento AS tratamiento_15, m1_.duracion_turno AS duracion_turno_16, m1_.activo AS activo_17, m1_.visible AS visible_18, m1_.url_meet_predefinida AS url_meet_predefinida_19, m1_.fecha_actualizacion_url_meet AS fecha_actualizacion_url_meet_20, m1_.obras_sociales_config AS obras_sociales_config_21, p2_.id AS id_22, p2_.apellido AS apellido_23, p2_.nombre AS nombre_24, p2_.nro_doc AS nro_doc_25, p2_.fecha_nacimiento AS fecha_nacimiento_26, p2_.hijos AS hijos_27, p2_.calle AS calle_28, p2_.domicilio_nro AS domicilio_nro_29, p2_.piso AS piso_30, p2_.dpto AS dpto_31, p2_.plan_obra_social AS plan_obra_social_32, p2_.nro_afiliado AS nro_afiliado_33, p2_.celular AS celular_34, p2_.email AS email_35, p2_.fecha_primera_consulta AS fecha_primera_consulta_36, p2_.foto AS foto_37, p2_.observacion_personal AS observacion_personal_38, p2_.antecedentes_de_jerarquia AS antecedentes_de_jerarquia_39, p2_.medicacion_habitual AS medicacion_habitual_40, p2_.factores_riesgo AS factores_riesgo_41, p2_.estudios AS estudios_42, p2_.hta AS hta_43, p2_.dbt AS dbt_44, p2_.dlp AS dlp_45, p2_.tbq AS tbq_46, p2_.consentimiento_email AS consentimiento_email_47, t0_.medico_id AS medico_id_48, t0_.paciente_id AS paciente_id_49, t0_.establecimiento_id AS establecimiento_id_50, t0_.motivo_id AS motivo_id_51, t0_.modalidad AS modalidad_52, t0_.aplicacion_id AS aplicacion_id_53, t0_.derivado_por_id AS derivado_por_id_54, t0_.usuario_id AS usuario_id_55, t0_.organizacion AS organizacion_56, t0_.evolucion_paciente_id AS evolucion_paciente_id_57, t0_.estacion_id AS estacion_id_58, m1_.profesion_id AS profesion_id_59, m1_.horario_id AS horario_id_60, m1_.organizacion AS organizacion_61, p2_.genero_id AS genero_id_62, p2_.estado_civil_id AS estado_civil_id_63, p2_.localidad_id AS localidad_id_64, p2_.obra_social_id AS obra_social_id_65, p2_.organizacion AS organizacion_66 FROM turnos t0_ LEFT JOIN medicos m1_ ON t0_.medico_id = m1_.id LEFT JOIN pacientes p2_ ON t0_.paciente_id = p2_.id WHERE t0_.estado < 7 AND t0_.organizacion = 1 AND t0_.dia > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 666 HOUR) AND m1_.id IN (130, 131, 129) AND t0_.id IN (100950, 100951, 100947, 100948, 100949) ORDER BY t0_.dia ASC;

SELECT
  DISTINCT t0_.id AS id_0,
  t0_.dia AS dia_1
FROM
  turnos t0_
  LEFT JOIN medicos m1_ ON t0_.medico_id = m1_.id
  LEFT JOIN pacientes p2_ ON t0_.paciente_id = p2_.id
WHERE
  t0_.estado < ?
  AND t0_.organizacion = ?
  AND t0_.dia > DATE_SUB(
    CURRENT_TIMESTAMP, INTERVAL 666 HOUR
  )
  AND m1_.id IN (?, ?, ?)
ORDER BY
  t0_.dia ASC
LIMIT
  20

SELECT DISTINCT t0_.id AS id_0, t0_.dia AS dia_1 FROM turnos t0_ LEFT JOIN medicos m1_ ON t0_.medico_id = m1_.id LEFT JOIN pacientes p2_ ON t0_.paciente_id = p2_.id WHERE t0_.estado < 7 AND t0_.organizacion = 1 AND t0_.dia > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 666 HOUR) AND m1_.id IN (130, 131, 129) ORDER BY t0_.dia ASC LIMIT 20;

SELECT
  m0_.id AS id_0,
  m0_.apellido AS apellido_1,
  m0_.nombre AS nombre_2,
  m0_.matricula AS matricula_3,
  m0_.tratamiento AS tratamiento_4,
  m0_.duracion_turno AS duracion_turno_5,
  m0_.activo AS activo_6,
  m0_.visible AS visible_7,
  m0_.url_meet_predefinida AS url_meet_predefinida_8,
  m0_.fecha_actualizacion_url_meet AS fecha_actualizacion_url_meet_9,
  m0_.obras_sociales_config AS obras_sociales_config_10,
  m0_.profesion_id AS profesion_id_11,
  m0_.horario_id AS horario_id_12,
  m0_.organizacion AS organizacion_13
FROM
  medicos m0_
WHERE
  m0_.activo = 1
  AND m0_.organizacion = ?
ORDER BY
  m0_.apellido ASC,
  m0_.nombre ASC

SELECT m0_.id AS id_0, m0_.apellido AS apellido_1, m0_.nombre AS nombre_2, m0_.matricula AS matricula_3, m0_.tratamiento AS tratamiento_4, m0_.duracion_turno AS duracion_turno_5, m0_.activo AS activo_6, m0_.visible AS visible_7, m0_.url_meet_predefinida AS url_meet_predefinida_8, m0_.fecha_actualizacion_url_meet AS fecha_actualizacion_url_meet_9, m0_.obras_sociales_config AS obras_sociales_config_10, m0_.profesion_id AS profesion_id_11, m0_.horario_id AS horario_id_12, m0_.organizacion AS organizacion_13 FROM medicos m0_ WHERE m0_.activo = 1 AND m0_.organizacion = 1 ORDER BY m0_.apellido ASC, m0_.nombre ASC;

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.ultima_actividad AS ultima_actividad_3,
  t0.activo AS activo_4,
  t0.fecha_expiracion AS fecha_expiracion_5,
  t0.usuario_id AS usuario_id_6,
  t0.organizacion_id AS organizacion_id_7,
  t0.medico_id AS medico_id_8
FROM
  membresia t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.ultima_actividad AS ultima_actividad_3, t0.activo AS activo_4, t0.fecha_expiracion AS fecha_expiracion_5, t0.usuario_id AS usuario_id_6, t0.organizacion_id AS organizacion_id_7, t0.medico_id AS medico_id_8 FROM membresia t0 WHERE t0.id = 66;

SELECT
  t0.id AS id_1,
  t0.apellido AS apellido_2,
  t0.nombre AS nombre_3,
  t0.nro_doc AS nro_doc_4,
  t0.fecha_nacimiento AS fecha_nacimiento_5,
  t0.hijos AS hijos_6,
  t0.calle AS calle_7,
  t0.domicilio_nro AS domicilio_nro_8,
  t0.piso AS piso_9,
  t0.dpto AS dpto_10,
  t0.plan_obra_social AS plan_obra_social_11,
  t0.nro_afiliado AS nro_afiliado_12,
  t0.celular AS celular_13,
  t0.email AS email_14,
  t0.fecha_primera_consulta AS fecha_primera_consulta_15,
  t0.foto AS foto_16,
  t0.observacion_personal AS observacion_personal_17,
  t0.antecedentes_de_jerarquia AS antecedentes_de_jerarquia_18,
  t0.medicacion_habitual AS medicacion_habitual_19,
  t0.factores_riesgo AS factores_riesgo_20,
  t0.estudios AS estudios_21,
  t0.hta AS hta_22,
  t0.dbt AS dbt_23,
  t0.dlp AS dlp_24,
  t0.tbq AS tbq_25,
  t0.consentimiento_email AS consentimiento_email_26,
  t0.genero_id AS genero_id_27,
  t0.estado_civil_id AS estado_civil_id_28,
  t0.localidad_id AS localidad_id_29,
  t0.obra_social_id AS obra_social_id_30,
  t0.organizacion AS organizacion_31
FROM
  pacientes t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.apellido AS apellido_2, t0.nombre AS nombre_3, t0.nro_doc AS nro_doc_4, t0.fecha_nacimiento AS fecha_nacimiento_5, t0.hijos AS hijos_6, t0.calle AS calle_7, t0.domicilio_nro AS domicilio_nro_8, t0.piso AS piso_9, t0.dpto AS dpto_10, t0.plan_obra_social AS plan_obra_social_11, t0.nro_afiliado AS nro_afiliado_12, t0.celular AS celular_13, t0.email AS email_14, t0.fecha_primera_consulta AS fecha_primera_consulta_15, t0.foto AS foto_16, t0.observacion_personal AS observacion_personal_17, t0.antecedentes_de_jerarquia AS antecedentes_de_jerarquia_18, t0.medicacion_habitual AS medicacion_habitual_19, t0.factores_riesgo AS factores_riesgo_20, t0.estudios AS estudios_21, t0.hta AS hta_22, t0.dbt AS dbt_23, t0.dlp AS dlp_24, t0.tbq AS tbq_25, t0.consentimiento_email AS consentimiento_email_26, t0.genero_id AS genero_id_27, t0.estado_civil_id AS estado_civil_id_28, t0.localidad_id AS localidad_id_29, t0.obra_social_id AS obra_social_id_30, t0.organizacion AS organizacion_31 FROM pacientes t0 WHERE t0.id = 27673;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.activo AS activo_3,
  t0.visible AS visible_4,
  t0.estado_al_finalizar AS estado_al_finalizar_5,
  t0.periodicidad AS periodicidad_6,
  t0.organizacion AS organizacion_7
FROM
  motivos_consulta t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3, t0.visible AS visible_4, t0.estado_al_finalizar AS estado_al_finalizar_5, t0.periodicidad AS periodicidad_6, t0.organizacion AS organizacion_7 FROM motivos_consulta t0 WHERE t0.id = 80;

SELECT
  t0.id AS id_1,
  t0.apellido AS apellido_2,
  t0.nombre AS nombre_3,
  t0.matricula AS matricula_4,
  t0.tratamiento AS tratamiento_5,
  t0.duracion_turno AS duracion_turno_6,
  t0.activo AS activo_7,
  t0.visible AS visible_8,
  t0.url_meet_predefinida AS url_meet_predefinida_9,
  t0.fecha_actualizacion_url_meet AS fecha_actualizacion_url_meet_10,
  t0.obras_sociales_config AS obras_sociales_config_11,
  t0.profesion_id AS profesion_id_12,
  t0.horario_id AS horario_id_13,
  t0.organizacion AS organizacion_14
FROM
  medicos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.apellido AS apellido_2, t0.nombre AS nombre_3, t0.matricula AS matricula_4, t0.tratamiento AS tratamiento_5, t0.duracion_turno AS duracion_turno_6, t0.activo AS activo_7, t0.visible AS visible_8, t0.url_meet_predefinida AS url_meet_predefinida_9, t0.fecha_actualizacion_url_meet AS fecha_actualizacion_url_meet_10, t0.obras_sociales_config AS obras_sociales_config_11, t0.profesion_id AS profesion_id_12, t0.horario_id AS horario_id_13, t0.organizacion AS organizacion_14 FROM medicos t0 WHERE t0.id = 130;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.activo AS activo_3,
  t0.visible AS visible_4,
  t0.fn_practicas AS fn_practicas_5,
  t0.fn_ia AS fn_ia_6,
  t0.organizacion_id AS organizacion_id_7,
  t0.cuestionario_id AS cuestionario_id_8
FROM
  estacion t0
WHERE
  t0.organizacion_id = ?
  AND t0.activo = ?
ORDER BY
  t0.nombre ASC

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3, t0.visible AS visible_4, t0.fn_practicas AS fn_practicas_5, t0.fn_ia AS fn_ia_6, t0.organizacion_id AS organizacion_id_7, t0.cuestionario_id AS cuestionario_id_8 FROM estacion t0 WHERE t0.organizacion_id = 1 AND t0.activo = 1 ORDER BY t0.nombre ASC;

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.ultima_actividad AS ultima_actividad_3,
  t0.activo AS activo_4,
  t0.fecha_expiracion AS fecha_expiracion_5,
  t0.usuario_id AS usuario_id_6,
  t0.organizacion_id AS organizacion_id_7,
  t0.medico_id AS medico_id_8
FROM
  membresia t0
WHERE
  t0.usuario_id = ?

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.ultima_actividad AS ultima_actividad_3, t0.activo AS activo_4, t0.fecha_expiracion AS fecha_expiracion_5, t0.usuario_id AS usuario_id_6, t0.organizacion_id AS organizacion_id_7, t0.medico_id AS medico_id_8 FROM membresia t0 WHERE t0.usuario_id = 111;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.fecha_creacion AS fecha_creacion_3,
  t0.fecha_actualizacion AS fecha_actualizacion_4,
  t0.fecha_expiracion AS fecha_expiracion_5,
  t0.modulo_ambulatorio AS modulo_ambulatorio_6,
  t0.modulo_internacion AS modulo_internacion_7,
  t0.modulo_circuito AS modulo_circuito_8,
  t0.modulo_caja AS modulo_caja_9,
  t0.modulo_portal AS modulo_portal_10,
  t0.modulo_llamador AS modulo_llamador_11,
  t0.max_usuarios AS max_usuarios_12,
  t0.max_establecimientos AS max_establecimientos_13,
  t0.configuracion AS configuracion_14,
  t0.activo AS activo_15,
  t0.portal_slug AS portal_slug_16,
  t0.configuracion_obras_sociales AS configuracion_obras_sociales_17,
  t0.configuracion_profesiones AS configuracion_profesiones_18,
  t0.configuracion_especialidades AS configuracion_especialidades_19,
  t0.configuracion_practicas_medicas AS configuracion_practicas_medicas_20
FROM
  organizacion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.fecha_creacion AS fecha_creacion_3, t0.fecha_actualizacion AS fecha_actualizacion_4, t0.fecha_expiracion AS fecha_expiracion_5, t0.modulo_ambulatorio AS modulo_ambulatorio_6, t0.modulo_internacion AS modulo_internacion_7, t0.modulo_circuito AS modulo_circuito_8, t0.modulo_caja AS modulo_caja_9, t0.modulo_portal AS modulo_portal_10, t0.modulo_llamador AS modulo_llamador_11, t0.max_usuarios AS max_usuarios_12, t0.max_establecimientos AS max_establecimientos_13, t0.configuracion AS configuracion_14, t0.activo AS activo_15, t0.portal_slug AS portal_slug_16, t0.configuracion_obras_sociales AS configuracion_obras_sociales_17, t0.configuracion_profesiones AS configuracion_profesiones_18, t0.configuracion_especialidades AS configuracion_especialidades_19, t0.configuracion_practicas_medicas AS configuracion_practicas_medicas_20 FROM organizacion t0 WHERE t0.id = 1;

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  membresia m0_
WHERE
  m0_.ultima_actividad >= ?

SELECT COUNT(m0_.id) AS sclr_0 FROM membresia m0_ WHERE m0_.ultima_actividad >= '2026-01-17 16:56:08';

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.cuit AS cuit_3,
  t0.organizacion AS organizacion_4
FROM
  obra_social t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.cuit AS cuit_3, t0.organizacion AS organizacion_4 FROM obra_social t0 WHERE t0.id = 1387;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.organizacion AS organizacion_3
FROM
  profesion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.organizacion AS organizacion_3 FROM profesion t0 WHERE t0.id = 67;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.activo AS activo_3,
  t0.organizacion AS organizacion_4
FROM
  establecimientos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3, t0.organizacion AS organizacion_4 FROM establecimientos t0 WHERE t0.id = 19;