Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

2.57 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.07 ms (41.44%)	1	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.id = ? Parameters: [`"1855"`] View formatted query View runnable query Explain query 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.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.id = '1855';
0.76 ms (29.69%)	1	SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.ip_crea AS ip_crea_3, t0.ip_modifica AS ip_modifica_4, t0.user_crea AS user_crea_5, t0.user_modifica AS user_modifica_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.historia_clinica_id AS historia_clinica_id_9, t0.cie10_id AS cie10_id_10 FROM diagnosticos_historia_clinica t0 WHERE t0.historia_clinica_id = ? Parameters: [`1855`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.ip_crea AS ip_crea_3, t0.ip_modifica AS ip_modifica_4, t0.user_crea AS user_crea_5, t0.user_modifica AS user_modifica_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.historia_clinica_id AS historia_clinica_id_9, t0.cie10_id AS cie10_id_10 FROM diagnosticos_historia_clinica t0 WHERE t0.historia_clinica_id = ? SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.ip_crea AS ip_crea_3, t0.ip_modifica AS ip_modifica_4, t0.user_crea AS user_crea_5, t0.user_modifica AS user_modifica_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.historia_clinica_id AS historia_clinica_id_9, t0.cie10_id AS cie10_id_10 FROM diagnosticos_historia_clinica t0 WHERE t0.historia_clinica_id = 1855;
0.74 ms (28.87%)	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 = ? 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;

Time▼

Count

Info

1.07 ms
(41.44%)

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

Parameters:

[
  "1855"
]

View formatted query View runnable query Explain query

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.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.id = '1855';

0.76 ms
(29.69%)

SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.ip_crea AS ip_crea_3, t0.ip_modifica AS ip_modifica_4, t0.user_crea AS user_crea_5, t0.user_modifica AS user_modifica_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.historia_clinica_id AS historia_clinica_id_9, t0.cie10_id AS cie10_id_10 FROM diagnosticos_historia_clinica t0 WHERE t0.historia_clinica_id = ?

Parameters:

[
  1855
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.tipo AS tipo_2,
  t0.ip_crea AS ip_crea_3,
  t0.ip_modifica AS ip_modifica_4,
  t0.user_crea AS user_crea_5,
  t0.user_modifica AS user_modifica_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.historia_clinica_id AS historia_clinica_id_9,
  t0.cie10_id AS cie10_id_10
FROM
  diagnosticos_historia_clinica t0
WHERE
  t0.historia_clinica_id = ?

SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.ip_crea AS ip_crea_3, t0.ip_modifica AS ip_modifica_4, t0.user_crea AS user_crea_5, t0.user_modifica AS user_modifica_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.historia_clinica_id AS historia_clinica_id_9, t0.cie10_id AS cie10_id_10 FROM diagnosticos_historia_clinica t0 WHERE t0.historia_clinica_id = 1855;

0.74 ms
(28.87%)

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;

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\HistoriaClinica	No errors.
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\Paciente	The mappings App\Entity\Paciente#redsocial and App\Entity\RedSocial#agendas are inconsistent with each other.
App\Entity\DiagnosticosHistoriaClinica	No errors.
App\Entity\Receta	No errors.
App\Entity\ExamenOrden	No errors.
App\Entity\Orden012	No errors.
App\Entity\Interconsulta	No errors.
App\Entity\PantallasAs400	No errors.
App\Entity\PlanoCabecera	No errors.
App\Entity\Estudio	No errors.
App\Entity\Epicrisis	No errors.
App\Entity\Cie10	No errors.
App\Entity\User	No errors.
App\Entity\TipoUsuario	No errors.
App\Entity\Especialidad	No errors.
App\Entity\LogAgenda	No errors.
App\Entity\LabProtocolo	No errors.

Symfony Profiler

https://naturmed.sismedsolution.com/index.php/diagnosticos_historia_clinica/index_ajax/1855

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping