Symfony Profiler

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.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 = 278;

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.id_doctor AS id_doctor_10,
  t0.unidad_id AS unidad_id_11
FROM
  sala 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.id_doctor AS id_doctor_10, t0.unidad_id AS unidad_id_11 FROM sala t0 WHERE t0.id = '5';

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
FROM
  unidad 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 FROM unidad t0 WHERE t0.id = 1;

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

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;

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
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.apellido1 AS apellido1_2,
  u0_.apellido2 AS apellido2_3,
  u0_.nombre1 AS nombre1_4,
  u0_.nombre2 AS nombre2_5,
  u0_.roles AS roles_6,
  u0_.password AS password_7,
  u0_.cedula AS cedula_8,
  u0_.estado AS estado_9,
  u0_.firma AS firma_10,
  u0_.cod_senescyt AS cod_senescyt_11,
  u0_.titulo AS titulo_12,
  u0_.titulo_abrev AS titulo_abrev_13,
  u0_.color AS color_14,
  u0_.dr AS dr_15,
  u0_.tipousuario_id AS tipousuario_id_16,
  u0_.especialidad_id AS especialidad_id_17
FROM
  user u0_
WHERE
  u0_.tipousuario_id IN (?, ?)
  AND u0_.estado = 1
ORDER BY
  u0_.tipousuario_id ASC,
  u0_.apellido1 ASC

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.apellido1 AS apellido1_2, u0_.apellido2 AS apellido2_3, u0_.nombre1 AS nombre1_4, u0_.nombre2 AS nombre2_5, u0_.roles AS roles_6, u0_.password AS password_7, u0_.cedula AS cedula_8, u0_.estado AS estado_9, u0_.firma AS firma_10, u0_.cod_senescyt AS cod_senescyt_11, u0_.titulo AS titulo_12, u0_.titulo_abrev AS titulo_abrev_13, u0_.color AS color_14, u0_.dr AS dr_15, u0_.tipousuario_id AS tipousuario_id_16, u0_.especialidad_id AS especialidad_id_17 FROM user u0_ WHERE u0_.tipousuario_id IN (3, 4) AND u0_.estado = 1 ORDER BY u0_.tipousuario_id ASC, u0_.apellido1 ASC;

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.observacion AS observacion_2,
  p0_.estado AS estado_3,
  p0_.ip_crea AS ip_crea_4,
  p0_.ip_modifica AS ip_modifica_5,
  p0_.user_crea AS user_crea_6,
  p0_.user_modifica AS user_modifica_7,
  p0_.created_at AS created_at_8,
  p0_.updated_at AS updated_at_9,
  p0_.tipo AS tipo_10,
  p0_.imagen AS imagen_11,
  p0_.color_activo AS color_activo_12,
  p0_.color_inactivo AS color_inactivo_13,
  p0_.producto_id AS producto_id_14,
  p0_.especialidad_id AS especialidad_id_15
FROM
  procedimientos p0_
WHERE
  p0_.estado = 1
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.observacion AS observacion_2, p0_.estado AS estado_3, p0_.ip_crea AS ip_crea_4, p0_.ip_modifica AS ip_modifica_5, p0_.user_crea AS user_crea_6, p0_.user_modifica AS user_modifica_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.tipo AS tipo_10, p0_.imagen AS imagen_11, p0_.color_activo AS color_activo_12, p0_.color_inactivo AS color_inactivo_13, p0_.producto_id AS producto_id_14, p0_.especialidad_id AS especialidad_id_15 FROM procedimientos p0_ WHERE p0_.estado = 1 ORDER BY p0_.id ASC;

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

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

SELECT
  s0_.id AS id_0,
  s0_.nombre AS nombre_1,
  s0_.estado AS estado_2,
  s0_.created_at AS created_at_3,
  s0_.updated_at AS updated_at_4,
  s0_.tipo AS tipo_5,
  s0_.user_crea AS user_crea_6,
  s0_.user_modifica AS user_modifica_7,
  s0_.ip_crea AS ip_crea_8,
  s0_.ip_modifica AS ip_modifica_9,
  s0_.color AS color_10
FROM
  seguro_privado s0_
WHERE
  s0_.estado = 1
ORDER BY
  s0_.nombre ASC

SELECT s0_.id AS id_0, s0_.nombre AS nombre_1, s0_.estado AS estado_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.tipo AS tipo_5, s0_.user_crea AS user_crea_6, s0_.user_modifica AS user_modifica_7, s0_.ip_crea AS ip_crea_8, s0_.ip_modifica AS ip_modifica_9, s0_.color AS color_10 FROM seguro_privado s0_ WHERE s0_.estado = 1 ORDER BY s0_.nombre ASC;