Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

1.86 ms Query time

3 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.90 ms	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 = ? Parameters: [`31`] View formatted query View runnable query Explain query 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;
2	0.96 ms	SELECT p0_.id AS id_0, p0_.cedula AS cedula_1, p0_.apellido1 AS apellido1_2, p0_.apellido2 AS apellido2_3, p0_.nombre1 AS nombre1_4, p0_.nombre2 AS nombre2_5, p0_.fecha_nacimiento AS fecha_nacimiento_6, p0_.telefono AS telefono_7, p0_.direccion AS direccion_8, p0_.sexo AS sexo_9, p0_.estado_civil AS estado_civil_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.email AS email_13, p0_.celular AS celular_14, p0_.copia_cedula AS copia_cedula_15, p0_.ciudad AS ciudad_16, p0_.lugar_nacimiento AS lugar_nacimiento_17, p0_.referido AS referido_18, p0_.cedula_familiar AS cedula_familiar_19, p0_.parentesco AS parentesco_20, p0_.nombres_familiar AS nombres_familiar_21, p0_.telefono_familiar AS telefono_familiar_22, p0_.alcohol AS alcohol_23, p0_.tabaco AS tabaco_24, p0_.drogas AS drogas_25, p0_.habitos_fisiologicos AS habitos_fisiologicos_26, p0_.enfermedad_de_la_infancia AS enfermedad_de_la_infancia_27, p0_.mas_antecedentes_personales AS mas_antecedentes_personales_28, p0_.antecedentes_quirurgicos AS antecedentes_quirurgicos_29, p0_.antecedentes_familiares AS antecedentes_familiares_30, p0_.grupo_sanguineo AS grupo_sanguineo_31, p0_.enfermedad AS enfermedad_32, p0_.alergias AS alergias_33, p0_.medicacion AS medicacion_34, p0_.ago AS ago_35, p0_.fum AS fum_36, p0_.gesta AS gesta_37, p0_.abo AS abo_38, p0_.para AS para_39, p0_.cesa AS cesa_40, p0_.provincia_residencia AS provincia_residencia_41, p0_.parroquia_residencia AS parroquia_residencia_42, p0_.pais AS pais_43, p0_.cedula_jpg AS cedula_jpg_44, p0_.tipo_firma AS tipo_firma_45, p0_.barrio AS barrio_46, p0_.canton AS canton_47, p0_.zona AS zona_48, p0_.grupo_cultural AS grupo_cultural_49, p0_.instruccion AS instruccion_50, p0_.ocupacion AS ocupacion_51, p0_.empresa AS empresa_52, p0_.apf_alergico AS apf_alergico_53, p0_.apf_clinico AS apf_clinico_54, p0_.apf_ginecolo AS apf_ginecolo_55, p0_.apf_trauma AS apf_trauma_56, p0_.apf_quirur AS apf_quirur_57, p0_.apf_farma AS apf_farma_58, p0_.apf_psiquia AS apf_psiquia_59, p0_.apf_otro AS apf_otro_60, p0_.direccion_familiar AS direccion_familiar_61, p0_.cedula_mama AS cedula_mama_62, p0_.cedula_papa AS cedula_papa_63, p0_.recomendacion AS recomendacion_64, p0_.vacuna_covid AS vacuna_covid_65, p0_.alias AS alias_66, p0_.hijos AS hijos_67, p0_.region AS region_68, p0_.contrato AS contrato_69, p0_.salud_producto AS salud_producto_70, p0_.salud_nropersona AS salud_nropersona_71, p0_.salud_nivel AS salud_nivel_72, p0_.observacion AS observacion_73, p0_.paciente_endoscopias AS paciente_endoscopias_74, p0_.paciente_bariatrico AS paciente_bariatrico_75, p0_.user_id AS user_id_76, p0_.seguro_id AS seguro_id_77, p0_.recomendado_id AS recomendado_id_78, p0_.redsocial_id AS redsocial_id_79 FROM paciente p0_ WHERE p0_.cedula = ? LIMIT 1 Parameters: [`"0200410454"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.cedula AS cedula_1, p0_.apellido1 AS apellido1_2, p0_.apellido2 AS apellido2_3, p0_.nombre1 AS nombre1_4, p0_.nombre2 AS nombre2_5, p0_.fecha_nacimiento AS fecha_nacimiento_6, p0_.telefono AS telefono_7, p0_.direccion AS direccion_8, p0_.sexo AS sexo_9, p0_.estado_civil AS estado_civil_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.email AS email_13, p0_.celular AS celular_14, p0_.copia_cedula AS copia_cedula_15, p0_.ciudad AS ciudad_16, p0_.lugar_nacimiento AS lugar_nacimiento_17, p0_.referido AS referido_18, p0_.cedula_familiar AS cedula_familiar_19, p0_.parentesco AS parentesco_20, p0_.nombres_familiar AS nombres_familiar_21, p0_.telefono_familiar AS telefono_familiar_22, p0_.alcohol AS alcohol_23, p0_.tabaco AS tabaco_24, p0_.drogas AS drogas_25, p0_.habitos_fisiologicos AS habitos_fisiologicos_26, p0_.enfermedad_de_la_infancia AS enfermedad_de_la_infancia_27, p0_.mas_antecedentes_personales AS mas_antecedentes_personales_28, p0_.antecedentes_quirurgicos AS antecedentes_quirurgicos_29, p0_.antecedentes_familiares AS antecedentes_familiares_30, p0_.grupo_sanguineo AS grupo_sanguineo_31, p0_.enfermedad AS enfermedad_32, p0_.alergias AS alergias_33, p0_.medicacion AS medicacion_34, p0_.ago AS ago_35, p0_.fum AS fum_36, p0_.gesta AS gesta_37, p0_.abo AS abo_38, p0_.para AS para_39, p0_.cesa AS cesa_40, p0_.provincia_residencia AS provincia_residencia_41, p0_.parroquia_residencia AS parroquia_residencia_42, p0_.pais AS pais_43, p0_.cedula_jpg AS cedula_jpg_44, p0_.tipo_firma AS tipo_firma_45, p0_.barrio AS barrio_46, p0_.canton AS canton_47, p0_.zona AS zona_48, p0_.grupo_cultural AS grupo_cultural_49, p0_.instruccion AS instruccion_50, p0_.ocupacion AS ocupacion_51, p0_.empresa AS empresa_52, p0_.apf_alergico AS apf_alergico_53, p0_.apf_clinico AS apf_clinico_54, p0_.apf_ginecolo AS apf_ginecolo_55, p0_.apf_trauma AS apf_trauma_56, p0_.apf_quirur AS apf_quirur_57, p0_.apf_farma AS apf_farma_58, p0_.apf_psiquia AS apf_psiquia_59, p0_.apf_otro AS apf_otro_60, p0_.direccion_familiar AS direccion_familiar_61, p0_.cedula_mama AS cedula_mama_62, p0_.cedula_papa AS cedula_papa_63, p0_.recomendacion AS recomendacion_64, p0_.vacuna_covid AS vacuna_covid_65, p0_.alias AS alias_66, p0_.hijos AS hijos_67, p0_.region AS region_68, p0_.contrato AS contrato_69, p0_.salud_producto AS salud_producto_70, p0_.salud_nropersona AS salud_nropersona_71, p0_.salud_nivel AS salud_nivel_72, p0_.observacion AS observacion_73, p0_.paciente_endoscopias AS paciente_endoscopias_74, p0_.paciente_bariatrico AS paciente_bariatrico_75, p0_.user_id AS user_id_76, p0_.seguro_id AS seguro_id_77, p0_.recomendado_id AS recomendado_id_78, p0_.redsocial_id AS redsocial_id_79 FROM paciente p0_ WHERE p0_.cedula = ? LIMIT 1 SELECT p0_.id AS id_0, p0_.cedula AS cedula_1, p0_.apellido1 AS apellido1_2, p0_.apellido2 AS apellido2_3, p0_.nombre1 AS nombre1_4, p0_.nombre2 AS nombre2_5, p0_.fecha_nacimiento AS fecha_nacimiento_6, p0_.telefono AS telefono_7, p0_.direccion AS direccion_8, p0_.sexo AS sexo_9, p0_.estado_civil AS estado_civil_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.email AS email_13, p0_.celular AS celular_14, p0_.copia_cedula AS copia_cedula_15, p0_.ciudad AS ciudad_16, p0_.lugar_nacimiento AS lugar_nacimiento_17, p0_.referido AS referido_18, p0_.cedula_familiar AS cedula_familiar_19, p0_.parentesco AS parentesco_20, p0_.nombres_familiar AS nombres_familiar_21, p0_.telefono_familiar AS telefono_familiar_22, p0_.alcohol AS alcohol_23, p0_.tabaco AS tabaco_24, p0_.drogas AS drogas_25, p0_.habitos_fisiologicos AS habitos_fisiologicos_26, p0_.enfermedad_de_la_infancia AS enfermedad_de_la_infancia_27, p0_.mas_antecedentes_personales AS mas_antecedentes_personales_28, p0_.antecedentes_quirurgicos AS antecedentes_quirurgicos_29, p0_.antecedentes_familiares AS antecedentes_familiares_30, p0_.grupo_sanguineo AS grupo_sanguineo_31, p0_.enfermedad AS enfermedad_32, p0_.alergias AS alergias_33, p0_.medicacion AS medicacion_34, p0_.ago AS ago_35, p0_.fum AS fum_36, p0_.gesta AS gesta_37, p0_.abo AS abo_38, p0_.para AS para_39, p0_.cesa AS cesa_40, p0_.provincia_residencia AS provincia_residencia_41, p0_.parroquia_residencia AS parroquia_residencia_42, p0_.pais AS pais_43, p0_.cedula_jpg AS cedula_jpg_44, p0_.tipo_firma AS tipo_firma_45, p0_.barrio AS barrio_46, p0_.canton AS canton_47, p0_.zona AS zona_48, p0_.grupo_cultural AS grupo_cultural_49, p0_.instruccion AS instruccion_50, p0_.ocupacion AS ocupacion_51, p0_.empresa AS empresa_52, p0_.apf_alergico AS apf_alergico_53, p0_.apf_clinico AS apf_clinico_54, p0_.apf_ginecolo AS apf_ginecolo_55, p0_.apf_trauma AS apf_trauma_56, p0_.apf_quirur AS apf_quirur_57, p0_.apf_farma AS apf_farma_58, p0_.apf_psiquia AS apf_psiquia_59, p0_.apf_otro AS apf_otro_60, p0_.direccion_familiar AS direccion_familiar_61, p0_.cedula_mama AS cedula_mama_62, p0_.cedula_papa AS cedula_papa_63, p0_.recomendacion AS recomendacion_64, p0_.vacuna_covid AS vacuna_covid_65, p0_.alias AS alias_66, p0_.hijos AS hijos_67, p0_.region AS region_68, p0_.contrato AS contrato_69, p0_.salud_producto AS salud_producto_70, p0_.salud_nropersona AS salud_nropersona_71, p0_.salud_nivel AS salud_nivel_72, p0_.observacion AS observacion_73, p0_.paciente_endoscopias AS paciente_endoscopias_74, p0_.paciente_bariatrico AS paciente_bariatrico_75, p0_.user_id AS user_id_76, p0_.seguro_id AS seguro_id_77, p0_.recomendado_id AS recomendado_id_78, p0_.redsocial_id AS redsocial_id_79 FROM paciente p0_ WHERE p0_.cedula = '0200410454' LIMIT 1;

#▲

Time

Info

0.90 ms

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 = ?

Parameters:

[
  31
]

View formatted query View runnable query Explain query

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;

0.96 ms

SELECT p0_.id AS id_0, p0_.cedula AS cedula_1, p0_.apellido1 AS apellido1_2, p0_.apellido2 AS apellido2_3, p0_.nombre1 AS nombre1_4, p0_.nombre2 AS nombre2_5, p0_.fecha_nacimiento AS fecha_nacimiento_6, p0_.telefono AS telefono_7, p0_.direccion AS direccion_8, p0_.sexo AS sexo_9, p0_.estado_civil AS estado_civil_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.email AS email_13, p0_.celular AS celular_14, p0_.copia_cedula AS copia_cedula_15, p0_.ciudad AS ciudad_16, p0_.lugar_nacimiento AS lugar_nacimiento_17, p0_.referido AS referido_18, p0_.cedula_familiar AS cedula_familiar_19, p0_.parentesco AS parentesco_20, p0_.nombres_familiar AS nombres_familiar_21, p0_.telefono_familiar AS telefono_familiar_22, p0_.alcohol AS alcohol_23, p0_.tabaco AS tabaco_24, p0_.drogas AS drogas_25, p0_.habitos_fisiologicos AS habitos_fisiologicos_26, p0_.enfermedad_de_la_infancia AS enfermedad_de_la_infancia_27, p0_.mas_antecedentes_personales AS mas_antecedentes_personales_28, p0_.antecedentes_quirurgicos AS antecedentes_quirurgicos_29, p0_.antecedentes_familiares AS antecedentes_familiares_30, p0_.grupo_sanguineo AS grupo_sanguineo_31, p0_.enfermedad AS enfermedad_32, p0_.alergias AS alergias_33, p0_.medicacion AS medicacion_34, p0_.ago AS ago_35, p0_.fum AS fum_36, p0_.gesta AS gesta_37, p0_.abo AS abo_38, p0_.para AS para_39, p0_.cesa AS cesa_40, p0_.provincia_residencia AS provincia_residencia_41, p0_.parroquia_residencia AS parroquia_residencia_42, p0_.pais AS pais_43, p0_.cedula_jpg AS cedula_jpg_44, p0_.tipo_firma AS tipo_firma_45, p0_.barrio AS barrio_46, p0_.canton AS canton_47, p0_.zona AS zona_48, p0_.grupo_cultural AS grupo_cultural_49, p0_.instruccion AS instruccion_50, p0_.ocupacion AS ocupacion_51, p0_.empresa AS empresa_52, p0_.apf_alergico AS apf_alergico_53, p0_.apf_clinico AS apf_clinico_54, p0_.apf_ginecolo AS apf_ginecolo_55, p0_.apf_trauma AS apf_trauma_56, p0_.apf_quirur AS apf_quirur_57, p0_.apf_farma AS apf_farma_58, p0_.apf_psiquia AS apf_psiquia_59, p0_.apf_otro AS apf_otro_60, p0_.direccion_familiar AS direccion_familiar_61, p0_.cedula_mama AS cedula_mama_62, p0_.cedula_papa AS cedula_papa_63, p0_.recomendacion AS recomendacion_64, p0_.vacuna_covid AS vacuna_covid_65, p0_.alias AS alias_66, p0_.hijos AS hijos_67, p0_.region AS region_68, p0_.contrato AS contrato_69, p0_.salud_producto AS salud_producto_70, p0_.salud_nropersona AS salud_nropersona_71, p0_.salud_nivel AS salud_nivel_72, p0_.observacion AS observacion_73, p0_.paciente_endoscopias AS paciente_endoscopias_74, p0_.paciente_bariatrico AS paciente_bariatrico_75, p0_.user_id AS user_id_76, p0_.seguro_id AS seguro_id_77, p0_.recomendado_id AS recomendado_id_78, p0_.redsocial_id AS redsocial_id_79 FROM paciente p0_ WHERE p0_.cedula = ? LIMIT 1

Parameters:

[
  "0200410454"
]

View formatted query View runnable query Explain query

SELECT
  p0_.id AS id_0,
  p0_.cedula AS cedula_1,
  p0_.apellido1 AS apellido1_2,
  p0_.apellido2 AS apellido2_3,
  p0_.nombre1 AS nombre1_4,
  p0_.nombre2 AS nombre2_5,
  p0_.fecha_nacimiento AS fecha_nacimiento_6,
  p0_.telefono AS telefono_7,
  p0_.direccion AS direccion_8,
  p0_.sexo AS sexo_9,
  p0_.estado_civil AS estado_civil_10,
  p0_.created_at AS created_at_11,
  p0_.updated_at AS updated_at_12,
  p0_.email AS email_13,
  p0_.celular AS celular_14,
  p0_.copia_cedula AS copia_cedula_15,
  p0_.ciudad AS ciudad_16,
  p0_.lugar_nacimiento AS lugar_nacimiento_17,
  p0_.referido AS referido_18,
  p0_.cedula_familiar AS cedula_familiar_19,
  p0_.parentesco AS parentesco_20,
  p0_.nombres_familiar AS nombres_familiar_21,
  p0_.telefono_familiar AS telefono_familiar_22,
  p0_.alcohol AS alcohol_23,
  p0_.tabaco AS tabaco_24,
  p0_.drogas AS drogas_25,
  p0_.habitos_fisiologicos AS habitos_fisiologicos_26,
  p0_.enfermedad_de_la_infancia AS enfermedad_de_la_infancia_27,
  p0_.mas_antecedentes_personales AS mas_antecedentes_personales_28,
  p0_.antecedentes_quirurgicos AS antecedentes_quirurgicos_29,
  p0_.antecedentes_familiares AS antecedentes_familiares_30,
  p0_.grupo_sanguineo AS grupo_sanguineo_31,
  p0_.enfermedad AS enfermedad_32,
  p0_.alergias AS alergias_33,
  p0_.medicacion AS medicacion_34,
  p0_.ago AS ago_35,
  p0_.fum AS fum_36,
  p0_.gesta AS gesta_37,
  p0_.abo AS abo_38,
  p0_.para AS para_39,
  p0_.cesa AS cesa_40,
  p0_.provincia_residencia AS provincia_residencia_41,
  p0_.parroquia_residencia AS parroquia_residencia_42,
  p0_.pais AS pais_43,
  p0_.cedula_jpg AS cedula_jpg_44,
  p0_.tipo_firma AS tipo_firma_45,
  p0_.barrio AS barrio_46,
  p0_.canton AS canton_47,
  p0_.zona AS zona_48,
  p0_.grupo_cultural AS grupo_cultural_49,
  p0_.instruccion AS instruccion_50,
  p0_.ocupacion AS ocupacion_51,
  p0_.empresa AS empresa_52,
  p0_.apf_alergico AS apf_alergico_53,
  p0_.apf_clinico AS apf_clinico_54,
  p0_.apf_ginecolo AS apf_ginecolo_55,
  p0_.apf_trauma AS apf_trauma_56,
  p0_.apf_quirur AS apf_quirur_57,
  p0_.apf_farma AS apf_farma_58,
  p0_.apf_psiquia AS apf_psiquia_59,
  p0_.apf_otro AS apf_otro_60,
  p0_.direccion_familiar AS direccion_familiar_61,
  p0_.cedula_mama AS cedula_mama_62,
  p0_.cedula_papa AS cedula_papa_63,
  p0_.recomendacion AS recomendacion_64,
  p0_.vacuna_covid AS vacuna_covid_65,
  p0_.alias AS alias_66,
  p0_.hijos AS hijos_67,
  p0_.region AS region_68,
  p0_.contrato AS contrato_69,
  p0_.salud_producto AS salud_producto_70,
  p0_.salud_nropersona AS salud_nropersona_71,
  p0_.salud_nivel AS salud_nivel_72,
  p0_.observacion AS observacion_73,
  p0_.paciente_endoscopias AS paciente_endoscopias_74,
  p0_.paciente_bariatrico AS paciente_bariatrico_75,
  p0_.user_id AS user_id_76,
  p0_.seguro_id AS seguro_id_77,
  p0_.recomendado_id AS recomendado_id_78,
  p0_.redsocial_id AS redsocial_id_79
FROM
  paciente p0_
WHERE
  p0_.cedula = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.cedula AS cedula_1, p0_.apellido1 AS apellido1_2, p0_.apellido2 AS apellido2_3, p0_.nombre1 AS nombre1_4, p0_.nombre2 AS nombre2_5, p0_.fecha_nacimiento AS fecha_nacimiento_6, p0_.telefono AS telefono_7, p0_.direccion AS direccion_8, p0_.sexo AS sexo_9, p0_.estado_civil AS estado_civil_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.email AS email_13, p0_.celular AS celular_14, p0_.copia_cedula AS copia_cedula_15, p0_.ciudad AS ciudad_16, p0_.lugar_nacimiento AS lugar_nacimiento_17, p0_.referido AS referido_18, p0_.cedula_familiar AS cedula_familiar_19, p0_.parentesco AS parentesco_20, p0_.nombres_familiar AS nombres_familiar_21, p0_.telefono_familiar AS telefono_familiar_22, p0_.alcohol AS alcohol_23, p0_.tabaco AS tabaco_24, p0_.drogas AS drogas_25, p0_.habitos_fisiologicos AS habitos_fisiologicos_26, p0_.enfermedad_de_la_infancia AS enfermedad_de_la_infancia_27, p0_.mas_antecedentes_personales AS mas_antecedentes_personales_28, p0_.antecedentes_quirurgicos AS antecedentes_quirurgicos_29, p0_.antecedentes_familiares AS antecedentes_familiares_30, p0_.grupo_sanguineo AS grupo_sanguineo_31, p0_.enfermedad AS enfermedad_32, p0_.alergias AS alergias_33, p0_.medicacion AS medicacion_34, p0_.ago AS ago_35, p0_.fum AS fum_36, p0_.gesta AS gesta_37, p0_.abo AS abo_38, p0_.para AS para_39, p0_.cesa AS cesa_40, p0_.provincia_residencia AS provincia_residencia_41, p0_.parroquia_residencia AS parroquia_residencia_42, p0_.pais AS pais_43, p0_.cedula_jpg AS cedula_jpg_44, p0_.tipo_firma AS tipo_firma_45, p0_.barrio AS barrio_46, p0_.canton AS canton_47, p0_.zona AS zona_48, p0_.grupo_cultural AS grupo_cultural_49, p0_.instruccion AS instruccion_50, p0_.ocupacion AS ocupacion_51, p0_.empresa AS empresa_52, p0_.apf_alergico AS apf_alergico_53, p0_.apf_clinico AS apf_clinico_54, p0_.apf_ginecolo AS apf_ginecolo_55, p0_.apf_trauma AS apf_trauma_56, p0_.apf_quirur AS apf_quirur_57, p0_.apf_farma AS apf_farma_58, p0_.apf_psiquia AS apf_psiquia_59, p0_.apf_otro AS apf_otro_60, p0_.direccion_familiar AS direccion_familiar_61, p0_.cedula_mama AS cedula_mama_62, p0_.cedula_papa AS cedula_papa_63, p0_.recomendacion AS recomendacion_64, p0_.vacuna_covid AS vacuna_covid_65, p0_.alias AS alias_66, p0_.hijos AS hijos_67, p0_.region AS region_68, p0_.contrato AS contrato_69, p0_.salud_producto AS salud_producto_70, p0_.salud_nropersona AS salud_nropersona_71, p0_.salud_nivel AS salud_nivel_72, p0_.observacion AS observacion_73, p0_.paciente_endoscopias AS paciente_endoscopias_74, p0_.paciente_bariatrico AS paciente_bariatrico_75, p0_.user_id AS user_id_76, p0_.seguro_id AS seguro_id_77, p0_.recomendado_id AS recomendado_id_78, p0_.redsocial_id AS redsocial_id_79 FROM paciente p0_ WHERE p0_.cedula = '0200410454' LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\TipoUsuario	No errors.
App\Entity\Especialidad	No errors.
App\Entity\Paciente	The mappings App\Entity\Paciente#redsocial and App\Entity\RedSocial#agendas are inconsistent with each other.
App\Entity\Agenda	The field App\Entity\Agenda#agenda_procedimientos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AgendaProcedimiento#agenda does not contain the required 'inversedBy="agenda_procedimientos"' attribute. The mappings App\Entity\Agenda#redsocial and App\Entity\RedSocial#agendas are inconsistent with each other. The field App\Entity\Agenda#agendasReferenciadas is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Agenda#referencia does not contain the required 'inversedBy="agendasReferenciadas"' attribute.
App\Entity\LogAgenda	No errors.
App\Entity\Receta	No errors.
App\Entity\ExamenOrden	No errors.
App\Entity\Orden012	No errors.
App\Entity\PlanoCabecera	No errors.
App\Entity\Epicrisis	No errors.
App\Entity\LabProtocolo	No errors.
App\Entity\SeguroPrivado	No errors.
App\Entity\RedSocial	No errors.
App\Entity\HistoriaClinica	No errors.
App\Entity\Interconsulta	No errors.
App\Entity\HdSolicitud	No errors.
App\Entity\OrdenProcedimiento	The mappings App\Entity\OrdenProcedimiento#agendado and App\Entity\Agenda#ordenProcedimientos are inconsistent with each other.

Symfony Profiler

https://naturmed.sismedsolution.com/index.php/paciente/0200410454/buscar/cedula

Configuration Settings

Theme