Symfony Profiler

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

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

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  agenda a0_
  INNER JOIN paciente p1_ ON a0_.paciente_id = p1_.id
  INNER JOIN user u2_ ON a0_.doctor_id = u2_.id
  INNER JOIN sala s3_ ON a0_.sala_id = s3_.id
  INNER JOIN procedimientos p4_ ON a0_.procedimiento_id = p4_.id
WHERE
  a0_.estado = 1
  AND a0_.estado_agenda = 2
  AND a0_.inicio > ?
  AND a0_.fin < ?
  AND p4_.tipo = ?
  AND s3_.unidad_id = ?

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM agenda a0_ INNER JOIN paciente p1_ ON a0_.paciente_id = p1_.id INNER JOIN user u2_ ON a0_.doctor_id = u2_.id INNER JOIN sala s3_ ON a0_.sala_id = s3_.id INNER JOIN procedimientos p4_ ON a0_.procedimiento_id = p4_.id WHERE a0_.estado = 1 AND a0_.estado_agenda = 2 AND a0_.inicio > '2026-03-05  0:00:00' AND a0_.fin < '2026-03-05 23:59:00' AND p4_.tipo = 'TERAPIA' AND s3_.unidad_id = 1;

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.inicio AS inicio_1
FROM
  agenda a0_
  INNER JOIN paciente p1_ ON a0_.paciente_id = p1_.id
  INNER JOIN user u2_ ON a0_.doctor_id = u2_.id
  INNER JOIN sala s3_ ON a0_.sala_id = s3_.id
  INNER JOIN procedimientos p4_ ON a0_.procedimiento_id = p4_.id
WHERE
  a0_.estado = 1
  AND a0_.estado_agenda = 2
  AND a0_.inicio > ?
  AND a0_.fin < ?
  AND p4_.tipo = ?
  AND s3_.unidad_id = ?
ORDER BY
  a0_.inicio DESC
LIMIT
  100

SELECT DISTINCT a0_.id AS id_0, a0_.inicio AS inicio_1 FROM agenda a0_ INNER JOIN paciente p1_ ON a0_.paciente_id = p1_.id INNER JOIN user u2_ ON a0_.doctor_id = u2_.id INNER JOIN sala s3_ ON a0_.sala_id = s3_.id INNER JOIN procedimientos p4_ ON a0_.procedimiento_id = p4_.id WHERE a0_.estado = 1 AND a0_.estado_agenda = 2 AND a0_.inicio > '2026-03-05  0:00:00' AND a0_.fin < '2026-03-05 23:59:00' AND p4_.tipo = 'TERAPIA' AND s3_.unidad_id = 1 ORDER BY a0_.inicio DESC LIMIT 100;

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_.inicio AS inicio_30,
  CONCAT(
    p1_.apellido1, ?, p1_.apellido2, ?,
    p1_.nombre1, ?, p1_.nombre2
  ) AS sclr_31,
  CONCAT(u2_.apellido1, ?, u2_.nombre1) AS sclr_32,
  s3_.nombre AS nombre_33,
  p4_.nombre AS nombre_34,
  a0_.paciente_id AS paciente_id_35,
  a0_.doctor_id AS doctor_id_36,
  a0_.sala_id AS sala_id_37,
  a0_.seguro_id AS seguro_id_38,
  a0_.especialidad_id AS especialidad_id_39,
  a0_.procedimiento_id AS procedimiento_id_40,
  a0_.doctor_consulta_id AS doctor_consulta_id_41,
  a0_.origen_especialidad_id AS origen_especialidad_id_42,
  a0_.anestesiologo_id AS anestesiologo_id_43,
  a0_.recomendado_id AS recomendado_id_44,
  a0_.redsocial_id AS redsocial_id_45,
  a0_.referencia_id AS referencia_id_46
FROM
  agenda a0_
  INNER JOIN paciente p1_ ON a0_.paciente_id = p1_.id
  INNER JOIN user u2_ ON a0_.doctor_id = u2_.id
  INNER JOIN sala s3_ ON a0_.sala_id = s3_.id
  INNER JOIN procedimientos p4_ ON a0_.procedimiento_id = p4_.id
WHERE
  a0_.estado = 1
  AND a0_.estado_agenda = 2
  AND a0_.inicio > ?
  AND a0_.fin < ?
  AND p4_.tipo = ?
  AND s3_.unidad_id = ?
  AND a0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )
ORDER BY
  a0_.inicio DESC

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_.inicio AS inicio_30, CONCAT(p1_.apellido1, ' ', p1_.apellido2, ' ', p1_.nombre1, ' ', p1_.nombre2) AS sclr_31, CONCAT(u2_.apellido1, ' ', u2_.nombre1) AS sclr_32, s3_.nombre AS nombre_33, p4_.nombre AS nombre_34, a0_.paciente_id AS paciente_id_35, a0_.doctor_id AS doctor_id_36, a0_.sala_id AS sala_id_37, a0_.seguro_id AS seguro_id_38, a0_.especialidad_id AS especialidad_id_39, a0_.procedimiento_id AS procedimiento_id_40, a0_.doctor_consulta_id AS doctor_consulta_id_41, a0_.origen_especialidad_id AS origen_especialidad_id_42, a0_.anestesiologo_id AS anestesiologo_id_43, a0_.recomendado_id AS recomendado_id_44, a0_.redsocial_id AS redsocial_id_45, a0_.referencia_id AS referencia_id_46 FROM agenda a0_ INNER JOIN paciente p1_ ON a0_.paciente_id = p1_.id INNER JOIN user u2_ ON a0_.doctor_id = u2_.id INNER JOIN sala s3_ ON a0_.sala_id = s3_.id INNER JOIN procedimientos p4_ ON a0_.procedimiento_id = p4_.id WHERE a0_.estado = 1 AND a0_.estado_agenda = 2 AND a0_.inicio > '2026-03-05  0:00:00' AND a0_.fin < '2026-03-05 23:59:00' AND p4_.tipo = 'TERAPIA' AND s3_.unidad_id = 1 AND a0_.id IN (2645, 2647, 1757, 1759, 2496, 2646, 1754, 1758, 2494, 2495, 2643, 1728, 1731, 1755, 1756, 2493, 2497, 1729, 2562, 1725, 2641, 1726, 1727, 2586, 2587, 2606, 2573, 2558, 1665, 2605, 1686, 2572, 2554, 2556, 2559, 2604, 1685, 2571, 1687, 2581, 2601, 2549, 2582, 2550, 2555, 2603, 2570, 2580, 2600, 2537, 2551, 2557, 2602, 1611, 2531, 2546, 2599, 2523, 2524, 1610, 2527, 1612, 2529, 2532, 2519, 2521, 2525, 2528, 2547, 2548, 2614, 2520, 2530, 2514, 2613, 1600, 2522, 1604, 1601, 1602, 2516) ORDER BY a0_.inicio DESC;

SELECT
  u0_.id AS id_0,
  u0_.nombre AS nombre_1,
  u0_.estado AS estado_2,
  u0_.ip_crea AS ip_crea_3,
  u0_.ip_modifica AS ip_modifica_4,
  u0_.user_crea AS user_crea_5,
  u0_.user_modifica AS user_modifica_6,
  u0_.created_at AS created_at_7,
  u0_.updated_at AS updated_at_8
FROM
  unidad u0_
WHERE
  u0_.estado = 1
  AND u0_.id IN (?)
ORDER BY
  u0_.nombre ASC

SELECT u0_.id AS id_0, u0_.nombre AS nombre_1, u0_.estado AS estado_2, u0_.ip_crea AS ip_crea_3, u0_.ip_modifica AS ip_modifica_4, u0_.user_crea AS user_crea_5, u0_.user_modifica AS user_modifica_6, u0_.created_at AS created_at_7, u0_.updated_at AS updated_at_8 FROM unidad u0_ WHERE u0_.estado = 1 AND u0_.id IN ('1') ORDER BY u0_.nombre ASC;

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

SELECT
  u0_.id AS id_0,
  u0_.nombre AS nombre_1,
  u0_.estado AS estado_2,
  u0_.ip_crea AS ip_crea_3,
  u0_.ip_modifica AS ip_modifica_4,
  u0_.user_crea AS user_crea_5,
  u0_.user_modifica AS user_modifica_6,
  u0_.created_at AS created_at_7,
  u0_.updated_at AS updated_at_8
FROM
  unidad u0_
WHERE
  u0_.estado = 1
ORDER BY
  u0_.nombre ASC

SELECT u0_.id AS id_0, u0_.nombre AS nombre_1, u0_.estado AS estado_2, u0_.ip_crea AS ip_crea_3, u0_.ip_modifica AS ip_modifica_4, u0_.user_crea AS user_crea_5, u0_.user_modifica AS user_modifica_6, u0_.created_at AS created_at_7, u0_.updated_at AS updated_at_8 FROM unidad u0_ WHERE u0_.estado = 1 ORDER BY u0_.nombre ASC;