Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

2.43 ms Query time

3 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.69 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	1.13 ms	SELECT t0.id AS id_1, t0.inicio AS inicio_2, t0.fin AS fin_3, t0.estado AS estado_4, t0.ip_crea AS ip_crea_5, t0.ip_modifica AS ip_modifica_6, t0.user_crea AS user_crea_7, t0.user_modifica AS user_modifica_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.observacion AS observacion_11, t0.estado_agenda AS estado_agenda_12, t0.archivo053 AS archivo053_13, t0.tipo_consulta AS tipo_consulta_14, t0.origen AS origen_15, t0.fecha_consulta AS fecha_consulta_16, t0.cie10_recep AS cie10_recep_17, t0.validacion AS validacion_18, t0.cobrado AS cobrado_19, t0.factura AS factura_20, t0.fecha_factura AS fecha_factura_21, t0.fecha_pago AS fecha_pago_22, t0.verificado AS verificado_23, t0.confirma AS confirma_24, t0.corte_seguro AS corte_seguro_25, t0.salud_producto AS salud_producto_26, t0.salud_nropersona AS salud_nropersona_27, t0.salud_nivel AS salud_nivel_28, t0.documentos AS documentos_29, t0.wid AS wid_30, t0.paciente_id AS paciente_id_31, t0.doctor_id AS doctor_id_32, t0.sala_id AS sala_id_33, t0.seguro_id AS seguro_id_34, t0.especialidad_id AS especialidad_id_35, t36.id AS id_37, t36.grupo_sanquineo AS grupo_sanquineo_38, t36.presion AS presion_39, t36.pulso AS pulso_40, t36.temperatura AS temperatura_41, t36.estatura AS estatura_42, t36.peso AS peso_43, t36.estado AS estado_44, t36.ip_crea AS ip_crea_45, t36.ip_modifica AS ip_modifica_46, t36.user_crea AS user_crea_47, t36.user_modifica AS user_modifica_48, t36.created_at AS created_at_49, t36.updated_at AS updated_at_50, t36.observacion AS observacion_51, t36.frecuencia_respiratoria AS frecuencia_respiratoria_52, t36.saturacion_de_oxigeno AS saturacion_de_oxigeno_53, t36.perimetro_cefalico AS perimetro_cefalico_54, t36.perimetro_toraxico AS perimetro_toraxico_55, t36.cambio_de_peso AS cambio_de_peso_56, t36.agenda_id AS agenda_id_57, t58.id AS id_59, t58.motivo AS motivo_60, t58.evolucion AS evolucion_61, t58.examen_fisico AS examen_fisico_62, t58.indicaciones AS indicaciones_63, t58.estado AS estado_64, t58.ip_crea AS ip_crea_65, t58.ip_modifica AS ip_modifica_66, t58.user_crea AS user_crea_67, t58.user_modifica AS user_modifica_68, t58.created_at AS created_at_69, t58.updated_at AS updated_at_70, t58.enfermedad_actual AS enfermedad_actual_71, t58.revision_actual_organos_y_sistemas AS revision_actual_organos_y_sistemas_72, t58.descripcion_certificado AS descripcion_certificado_73, t58.hora_espera AS hora_espera_74, t58.dias_reposo AS dias_reposo_75, t58.reposo_desde AS reposo_desde_76, t58.reposo_hasta AS reposo_hasta_77, t58.ritmo AS ritmo_78, t58.frecuencia AS frecuencia_79, t58.intervalos AS intervalos_80, t58.segmento_st AS segmento_st_81, t58.eje_electrico AS eje_electrico_82, t58.imp_diagnostica_ekg AS imp_diagnostica_ekg_83, t58.conclusion AS conclusion_84, t58.riesgo AS riesgo_85, t58.recomendaciones AS recomendaciones_86, t58.diagnostico_clinico_cardiologico AS diagnostico_clinico_cardiologico_87, t58.trabaja_en AS trabaja_en_88, t58.puesto_trabajo AS puesto_trabajo_89, t58.presenta_sintomas AS presenta_sintomas_90, t58.aislamiento AS aislamiento_91, t58.ciudad_trabajo AS ciudad_trabajo_92, t58.tipo_contingencia AS tipo_contingencia_93, t58.certificado_evolucion AS certificado_evolucion_94, t58.certificado_diagnostico AS certificado_diagnostico_95, t58.certificado_cie10 AS certificado_cie10_96, t58.gota_fresca_disbiosis AS gota_fresca_disbiosis_97, t58.gota_fresca_cristales AS gota_fresca_cristales_98, t58.gota_fresca_hiperglicemia AS gota_fresca_hiperglicemia_99, t58.gota_fresca_hipoxia AS gota_fresca_hipoxia_100, t58.gota_fresca_acidez AS gota_fresca_acidez_101, t58.gota_fresca_inflamacion AS gota_fresca_inflamacion_102, t58.hlb_grado AS hlb_grado_103, t58.hlb_intolerancia_alimenticia AS hlb_intolerancia_alimenticia_104, t58.hlb_terreno_degenerativo_digestivo AS hlb_terreno_degenerativo_digestivo_105, t58.hlb_terreno_artrosico AS hlb_terreno_artrosico_106, t58.hlb_cnr AS hlb_cnr_107, t58.hlb_irritabilidad_nerviosa AS hlb_irritabilidad_nerviosa_108, t58.hlb_colesterol AS hlb_colesterol_109, t58.hlb_proceso_hepatico AS hlb_proceso_hepatico_110, t58.hlb_alergia AS hlb_alergia_111, t58.hlb_estres AS hlb_estres_112, t58.hlb_inflamacion AS hlb_inflamacion_113, t58.hlb_anemia AS hlb_anemia_114, t58.hlb_afectacion_muscular AS hlb_afectacion_muscular_115, t58.hlb_sol_toxico AS hlb_sol_toxico_116, t58.hlb_congestion_linfatica AS hlb_congestion_linfatica_117, t58.agenda_id AS agenda_id_118, t58.paciente_id AS paciente_id_119, t0.procedimiento_id AS procedimiento_id_120, t0.doctor_consulta_id AS doctor_consulta_id_121, t0.origen_especialidad_id AS origen_especialidad_id_122, t0.anestesiologo_id AS anestesiologo_id_123, t0.recomendado_id AS recomendado_id_124, t0.redsocial_id AS redsocial_id_125, t0.referencia_id AS referencia_id_126 FROM agenda t0 LEFT JOIN preparacion t36 ON t36.agenda_id = t0.id LEFT JOIN historia_clinica t58 ON t58.agenda_id = t0.id WHERE t0.id = ? Parameters: [`"2537"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.inicio AS inicio_2, t0.fin AS fin_3, t0.estado AS estado_4, t0.ip_crea AS ip_crea_5, t0.ip_modifica AS ip_modifica_6, t0.user_crea AS user_crea_7, t0.user_modifica AS user_modifica_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.observacion AS observacion_11, t0.estado_agenda AS estado_agenda_12, t0.archivo053 AS archivo053_13, t0.tipo_consulta AS tipo_consulta_14, t0.origen AS origen_15, t0.fecha_consulta AS fecha_consulta_16, t0.cie10_recep AS cie10_recep_17, t0.validacion AS validacion_18, t0.cobrado AS cobrado_19, t0.factura AS factura_20, t0.fecha_factura AS fecha_factura_21, t0.fecha_pago AS fecha_pago_22, t0.verificado AS verificado_23, t0.confirma AS confirma_24, t0.corte_seguro AS corte_seguro_25, t0.salud_producto AS salud_producto_26, t0.salud_nropersona AS salud_nropersona_27, t0.salud_nivel AS salud_nivel_28, t0.documentos AS documentos_29, t0.wid AS wid_30, t0.paciente_id AS paciente_id_31, t0.doctor_id AS doctor_id_32, t0.sala_id AS sala_id_33, t0.seguro_id AS seguro_id_34, t0.especialidad_id AS especialidad_id_35, t36.id AS id_37, t36.grupo_sanquineo AS grupo_sanquineo_38, t36.presion AS presion_39, t36.pulso AS pulso_40, t36.temperatura AS temperatura_41, t36.estatura AS estatura_42, t36.peso AS peso_43, t36.estado AS estado_44, t36.ip_crea AS ip_crea_45, t36.ip_modifica AS ip_modifica_46, t36.user_crea AS user_crea_47, t36.user_modifica AS user_modifica_48, t36.created_at AS created_at_49, t36.updated_at AS updated_at_50, t36.observacion AS observacion_51, t36.frecuencia_respiratoria AS frecuencia_respiratoria_52, t36.saturacion_de_oxigeno AS saturacion_de_oxigeno_53, t36.perimetro_cefalico AS perimetro_cefalico_54, t36.perimetro_toraxico AS perimetro_toraxico_55, t36.cambio_de_peso AS cambio_de_peso_56, t36.agenda_id AS agenda_id_57, t58.id AS id_59, t58.motivo AS motivo_60, t58.evolucion AS evolucion_61, t58.examen_fisico AS examen_fisico_62, t58.indicaciones AS indicaciones_63, t58.estado AS estado_64, t58.ip_crea AS ip_crea_65, t58.ip_modifica AS ip_modifica_66, t58.user_crea AS user_crea_67, t58.user_modifica AS user_modifica_68, t58.created_at AS created_at_69, t58.updated_at AS updated_at_70, t58.enfermedad_actual AS enfermedad_actual_71, t58.revision_actual_organos_y_sistemas AS revision_actual_organos_y_sistemas_72, t58.descripcion_certificado AS descripcion_certificado_73, t58.hora_espera AS hora_espera_74, t58.dias_reposo AS dias_reposo_75, t58.reposo_desde AS reposo_desde_76, t58.reposo_hasta AS reposo_hasta_77, t58.ritmo AS ritmo_78, t58.frecuencia AS frecuencia_79, t58.intervalos AS intervalos_80, t58.segmento_st AS segmento_st_81, t58.eje_electrico AS eje_electrico_82, t58.imp_diagnostica_ekg AS imp_diagnostica_ekg_83, t58.conclusion AS conclusion_84, t58.riesgo AS riesgo_85, t58.recomendaciones AS recomendaciones_86, t58.diagnostico_clinico_cardiologico AS diagnostico_clinico_cardiologico_87, t58.trabaja_en AS trabaja_en_88, t58.puesto_trabajo AS puesto_trabajo_89, t58.presenta_sintomas AS presenta_sintomas_90, t58.aislamiento AS aislamiento_91, t58.ciudad_trabajo AS ciudad_trabajo_92, t58.tipo_contingencia AS tipo_contingencia_93, t58.certificado_evolucion AS certificado_evolucion_94, t58.certificado_diagnostico AS certificado_diagnostico_95, t58.certificado_cie10 AS certificado_cie10_96, t58.gota_fresca_disbiosis AS gota_fresca_disbiosis_97, t58.gota_fresca_cristales AS gota_fresca_cristales_98, t58.gota_fresca_hiperglicemia AS gota_fresca_hiperglicemia_99, t58.gota_fresca_hipoxia AS gota_fresca_hipoxia_100, t58.gota_fresca_acidez AS gota_fresca_acidez_101, t58.gota_fresca_inflamacion AS gota_fresca_inflamacion_102, t58.hlb_grado AS hlb_grado_103, t58.hlb_intolerancia_alimenticia AS hlb_intolerancia_alimenticia_104, t58.hlb_terreno_degenerativo_digestivo AS hlb_terreno_degenerativo_digestivo_105, t58.hlb_terreno_artrosico AS hlb_terreno_artrosico_106, t58.hlb_cnr AS hlb_cnr_107, t58.hlb_irritabilidad_nerviosa AS hlb_irritabilidad_nerviosa_108, t58.hlb_colesterol AS hlb_colesterol_109, t58.hlb_proceso_hepatico AS hlb_proceso_hepatico_110, t58.hlb_alergia AS hlb_alergia_111, t58.hlb_estres AS hlb_estres_112, t58.hlb_inflamacion AS hlb_inflamacion_113, t58.hlb_anemia AS hlb_anemia_114, t58.hlb_afectacion_muscular AS hlb_afectacion_muscular_115, t58.hlb_sol_toxico AS hlb_sol_toxico_116, t58.hlb_congestion_linfatica AS hlb_congestion_linfatica_117, t58.agenda_id AS agenda_id_118, t58.paciente_id AS paciente_id_119, t0.procedimiento_id AS procedimiento_id_120, t0.doctor_consulta_id AS doctor_consulta_id_121, t0.origen_especialidad_id AS origen_especialidad_id_122, t0.anestesiologo_id AS anestesiologo_id_123, t0.recomendado_id AS recomendado_id_124, t0.redsocial_id AS redsocial_id_125, t0.referencia_id AS referencia_id_126 FROM agenda t0 LEFT JOIN preparacion t36 ON t36.agenda_id = t0.id LEFT JOIN historia_clinica t58 ON t58.agenda_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.inicio AS inicio_2, t0.fin AS fin_3, t0.estado AS estado_4, t0.ip_crea AS ip_crea_5, t0.ip_modifica AS ip_modifica_6, t0.user_crea AS user_crea_7, t0.user_modifica AS user_modifica_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.observacion AS observacion_11, t0.estado_agenda AS estado_agenda_12, t0.archivo053 AS archivo053_13, t0.tipo_consulta AS tipo_consulta_14, t0.origen AS origen_15, t0.fecha_consulta AS fecha_consulta_16, t0.cie10_recep AS cie10_recep_17, t0.validacion AS validacion_18, t0.cobrado AS cobrado_19, t0.factura AS factura_20, t0.fecha_factura AS fecha_factura_21, t0.fecha_pago AS fecha_pago_22, t0.verificado AS verificado_23, t0.confirma AS confirma_24, t0.corte_seguro AS corte_seguro_25, t0.salud_producto AS salud_producto_26, t0.salud_nropersona AS salud_nropersona_27, t0.salud_nivel AS salud_nivel_28, t0.documentos AS documentos_29, t0.wid AS wid_30, t0.paciente_id AS paciente_id_31, t0.doctor_id AS doctor_id_32, t0.sala_id AS sala_id_33, t0.seguro_id AS seguro_id_34, t0.especialidad_id AS especialidad_id_35, t36.id AS id_37, t36.grupo_sanquineo AS grupo_sanquineo_38, t36.presion AS presion_39, t36.pulso AS pulso_40, t36.temperatura AS temperatura_41, t36.estatura AS estatura_42, t36.peso AS peso_43, t36.estado AS estado_44, t36.ip_crea AS ip_crea_45, t36.ip_modifica AS ip_modifica_46, t36.user_crea AS user_crea_47, t36.user_modifica AS user_modifica_48, t36.created_at AS created_at_49, t36.updated_at AS updated_at_50, t36.observacion AS observacion_51, t36.frecuencia_respiratoria AS frecuencia_respiratoria_52, t36.saturacion_de_oxigeno AS saturacion_de_oxigeno_53, t36.perimetro_cefalico AS perimetro_cefalico_54, t36.perimetro_toraxico AS perimetro_toraxico_55, t36.cambio_de_peso AS cambio_de_peso_56, t36.agenda_id AS agenda_id_57, t58.id AS id_59, t58.motivo AS motivo_60, t58.evolucion AS evolucion_61, t58.examen_fisico AS examen_fisico_62, t58.indicaciones AS indicaciones_63, t58.estado AS estado_64, t58.ip_crea AS ip_crea_65, t58.ip_modifica AS ip_modifica_66, t58.user_crea AS user_crea_67, t58.user_modifica AS user_modifica_68, t58.created_at AS created_at_69, t58.updated_at AS updated_at_70, t58.enfermedad_actual AS enfermedad_actual_71, t58.revision_actual_organos_y_sistemas AS revision_actual_organos_y_sistemas_72, t58.descripcion_certificado AS descripcion_certificado_73, t58.hora_espera AS hora_espera_74, t58.dias_reposo AS dias_reposo_75, t58.reposo_desde AS reposo_desde_76, t58.reposo_hasta AS reposo_hasta_77, t58.ritmo AS ritmo_78, t58.frecuencia AS frecuencia_79, t58.intervalos AS intervalos_80, t58.segmento_st AS segmento_st_81, t58.eje_electrico AS eje_electrico_82, t58.imp_diagnostica_ekg AS imp_diagnostica_ekg_83, t58.conclusion AS conclusion_84, t58.riesgo AS riesgo_85, t58.recomendaciones AS recomendaciones_86, t58.diagnostico_clinico_cardiologico AS diagnostico_clinico_cardiologico_87, t58.trabaja_en AS trabaja_en_88, t58.puesto_trabajo AS puesto_trabajo_89, t58.presenta_sintomas AS presenta_sintomas_90, t58.aislamiento AS aislamiento_91, t58.ciudad_trabajo AS ciudad_trabajo_92, t58.tipo_contingencia AS tipo_contingencia_93, t58.certificado_evolucion AS certificado_evolucion_94, t58.certificado_diagnostico AS certificado_diagnostico_95, t58.certificado_cie10 AS certificado_cie10_96, t58.gota_fresca_disbiosis AS gota_fresca_disbiosis_97, t58.gota_fresca_cristales AS gota_fresca_cristales_98, t58.gota_fresca_hiperglicemia AS gota_fresca_hiperglicemia_99, t58.gota_fresca_hipoxia AS gota_fresca_hipoxia_100, t58.gota_fresca_acidez AS gota_fresca_acidez_101, t58.gota_fresca_inflamacion AS gota_fresca_inflamacion_102, t58.hlb_grado AS hlb_grado_103, t58.hlb_intolerancia_alimenticia AS hlb_intolerancia_alimenticia_104, t58.hlb_terreno_degenerativo_digestivo AS hlb_terreno_degenerativo_digestivo_105, t58.hlb_terreno_artrosico AS hlb_terreno_artrosico_106, t58.hlb_cnr AS hlb_cnr_107, t58.hlb_irritabilidad_nerviosa AS hlb_irritabilidad_nerviosa_108, t58.hlb_colesterol AS hlb_colesterol_109, t58.hlb_proceso_hepatico AS hlb_proceso_hepatico_110, t58.hlb_alergia AS hlb_alergia_111, t58.hlb_estres AS hlb_estres_112, t58.hlb_inflamacion AS hlb_inflamacion_113, t58.hlb_anemia AS hlb_anemia_114, t58.hlb_afectacion_muscular AS hlb_afectacion_muscular_115, t58.hlb_sol_toxico AS hlb_sol_toxico_116, t58.hlb_congestion_linfatica AS hlb_congestion_linfatica_117, t58.agenda_id AS agenda_id_118, t58.paciente_id AS paciente_id_119, t0.procedimiento_id AS procedimiento_id_120, t0.doctor_consulta_id AS doctor_consulta_id_121, t0.origen_especialidad_id AS origen_especialidad_id_122, t0.anestesiologo_id AS anestesiologo_id_123, t0.recomendado_id AS recomendado_id_124, t0.redsocial_id AS redsocial_id_125, t0.referencia_id AS referencia_id_126 FROM agenda t0 LEFT JOIN preparacion t36 ON t36.agenda_id = t0.id LEFT JOIN historia_clinica t58 ON t58.agenda_id = t0.id WHERE t0.id = '2537';
3	0.61 ms	SELECT t0.id AS id_1, t0.ip_crea AS ip_crea_2, t0.ip_modifica AS ip_modifica_3, t0.user_crea AS user_crea_4, t0.user_modifica AS user_modifica_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.agenda_id AS agenda_id_8, t0.procedimiento_id AS procedimiento_id_9 FROM agenda_procedimiento t0 WHERE t0.agenda_id = ? Parameters: [`2537`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.ip_crea AS ip_crea_2, t0.ip_modifica AS ip_modifica_3, t0.user_crea AS user_crea_4, t0.user_modifica AS user_modifica_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.agenda_id AS agenda_id_8, t0.procedimiento_id AS procedimiento_id_9 FROM agenda_procedimiento t0 WHERE t0.agenda_id = ? SELECT t0.id AS id_1, t0.ip_crea AS ip_crea_2, t0.ip_modifica AS ip_modifica_3, t0.user_crea AS user_crea_4, t0.user_modifica AS user_modifica_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.agenda_id AS agenda_id_8, t0.procedimiento_id AS procedimiento_id_9 FROM agenda_procedimiento t0 WHERE t0.agenda_id = 2537;

#▲

Time

Info

0.69 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;

1.13 ms

SELECT t0.id AS id_1, t0.inicio AS inicio_2, t0.fin AS fin_3, t0.estado AS estado_4, t0.ip_crea AS ip_crea_5, t0.ip_modifica AS ip_modifica_6, t0.user_crea AS user_crea_7, t0.user_modifica AS user_modifica_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.observacion AS observacion_11, t0.estado_agenda AS estado_agenda_12, t0.archivo053 AS archivo053_13, t0.tipo_consulta AS tipo_consulta_14, t0.origen AS origen_15, t0.fecha_consulta AS fecha_consulta_16, t0.cie10_recep AS cie10_recep_17, t0.validacion AS validacion_18, t0.cobrado AS cobrado_19, t0.factura AS factura_20, t0.fecha_factura AS fecha_factura_21, t0.fecha_pago AS fecha_pago_22, t0.verificado AS verificado_23, t0.confirma AS confirma_24, t0.corte_seguro AS corte_seguro_25, t0.salud_producto AS salud_producto_26, t0.salud_nropersona AS salud_nropersona_27, t0.salud_nivel AS salud_nivel_28, t0.documentos AS documentos_29, t0.wid AS wid_30, t0.paciente_id AS paciente_id_31, t0.doctor_id AS doctor_id_32, t0.sala_id AS sala_id_33, t0.seguro_id AS seguro_id_34, t0.especialidad_id AS especialidad_id_35, t36.id AS id_37, t36.grupo_sanquineo AS grupo_sanquineo_38, t36.presion AS presion_39, t36.pulso AS pulso_40, t36.temperatura AS temperatura_41, t36.estatura AS estatura_42, t36.peso AS peso_43, t36.estado AS estado_44, t36.ip_crea AS ip_crea_45, t36.ip_modifica AS ip_modifica_46, t36.user_crea AS user_crea_47, t36.user_modifica AS user_modifica_48, t36.created_at AS created_at_49, t36.updated_at AS updated_at_50, t36.observacion AS observacion_51, t36.frecuencia_respiratoria AS frecuencia_respiratoria_52, t36.saturacion_de_oxigeno AS saturacion_de_oxigeno_53, t36.perimetro_cefalico AS perimetro_cefalico_54, t36.perimetro_toraxico AS perimetro_toraxico_55, t36.cambio_de_peso AS cambio_de_peso_56, t36.agenda_id AS agenda_id_57, t58.id AS id_59, t58.motivo AS motivo_60, t58.evolucion AS evolucion_61, t58.examen_fisico AS examen_fisico_62, t58.indicaciones AS indicaciones_63, t58.estado AS estado_64, t58.ip_crea AS ip_crea_65, t58.ip_modifica AS ip_modifica_66, t58.user_crea AS user_crea_67, t58.user_modifica AS user_modifica_68, t58.created_at AS created_at_69, t58.updated_at AS updated_at_70, t58.enfermedad_actual AS enfermedad_actual_71, t58.revision_actual_organos_y_sistemas AS revision_actual_organos_y_sistemas_72, t58.descripcion_certificado AS descripcion_certificado_73, t58.hora_espera AS hora_espera_74, t58.dias_reposo AS dias_reposo_75, t58.reposo_desde AS reposo_desde_76, t58.reposo_hasta AS reposo_hasta_77, t58.ritmo AS ritmo_78, t58.frecuencia AS frecuencia_79, t58.intervalos AS intervalos_80, t58.segmento_st AS segmento_st_81, t58.eje_electrico AS eje_electrico_82, t58.imp_diagnostica_ekg AS imp_diagnostica_ekg_83, t58.conclusion AS conclusion_84, t58.riesgo AS riesgo_85, t58.recomendaciones AS recomendaciones_86, t58.diagnostico_clinico_cardiologico AS diagnostico_clinico_cardiologico_87, t58.trabaja_en AS trabaja_en_88, t58.puesto_trabajo AS puesto_trabajo_89, t58.presenta_sintomas AS presenta_sintomas_90, t58.aislamiento AS aislamiento_91, t58.ciudad_trabajo AS ciudad_trabajo_92, t58.tipo_contingencia AS tipo_contingencia_93, t58.certificado_evolucion AS certificado_evolucion_94, t58.certificado_diagnostico AS certificado_diagnostico_95, t58.certificado_cie10 AS certificado_cie10_96, t58.gota_fresca_disbiosis AS gota_fresca_disbiosis_97, t58.gota_fresca_cristales AS gota_fresca_cristales_98, t58.gota_fresca_hiperglicemia AS gota_fresca_hiperglicemia_99, t58.gota_fresca_hipoxia AS gota_fresca_hipoxia_100, t58.gota_fresca_acidez AS gota_fresca_acidez_101, t58.gota_fresca_inflamacion AS gota_fresca_inflamacion_102, t58.hlb_grado AS hlb_grado_103, t58.hlb_intolerancia_alimenticia AS hlb_intolerancia_alimenticia_104, t58.hlb_terreno_degenerativo_digestivo AS hlb_terreno_degenerativo_digestivo_105, t58.hlb_terreno_artrosico AS hlb_terreno_artrosico_106, t58.hlb_cnr AS hlb_cnr_107, t58.hlb_irritabilidad_nerviosa AS hlb_irritabilidad_nerviosa_108, t58.hlb_colesterol AS hlb_colesterol_109, t58.hlb_proceso_hepatico AS hlb_proceso_hepatico_110, t58.hlb_alergia AS hlb_alergia_111, t58.hlb_estres AS hlb_estres_112, t58.hlb_inflamacion AS hlb_inflamacion_113, t58.hlb_anemia AS hlb_anemia_114, t58.hlb_afectacion_muscular AS hlb_afectacion_muscular_115, t58.hlb_sol_toxico AS hlb_sol_toxico_116, t58.hlb_congestion_linfatica AS hlb_congestion_linfatica_117, t58.agenda_id AS agenda_id_118, t58.paciente_id AS paciente_id_119, t0.procedimiento_id AS procedimiento_id_120, t0.doctor_consulta_id AS doctor_consulta_id_121, t0.origen_especialidad_id AS origen_especialidad_id_122, t0.anestesiologo_id AS anestesiologo_id_123, t0.recomendado_id AS recomendado_id_124, t0.redsocial_id AS redsocial_id_125, t0.referencia_id AS referencia_id_126 FROM agenda t0 LEFT JOIN preparacion t36 ON t36.agenda_id = t0.id LEFT JOIN historia_clinica t58 ON t58.agenda_id = t0.id WHERE t0.id = ?

Parameters:

[
  "2537"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.inicio AS inicio_2,
  t0.fin AS fin_3,
  t0.estado AS estado_4,
  t0.ip_crea AS ip_crea_5,
  t0.ip_modifica AS ip_modifica_6,
  t0.user_crea AS user_crea_7,
  t0.user_modifica AS user_modifica_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.observacion AS observacion_11,
  t0.estado_agenda AS estado_agenda_12,
  t0.archivo053 AS archivo053_13,
  t0.tipo_consulta AS tipo_consulta_14,
  t0.origen AS origen_15,
  t0.fecha_consulta AS fecha_consulta_16,
  t0.cie10_recep AS cie10_recep_17,
  t0.validacion AS validacion_18,
  t0.cobrado AS cobrado_19,
  t0.factura AS factura_20,
  t0.fecha_factura AS fecha_factura_21,
  t0.fecha_pago AS fecha_pago_22,
  t0.verificado AS verificado_23,
  t0.confirma AS confirma_24,
  t0.corte_seguro AS corte_seguro_25,
  t0.salud_producto AS salud_producto_26,
  t0.salud_nropersona AS salud_nropersona_27,
  t0.salud_nivel AS salud_nivel_28,
  t0.documentos AS documentos_29,
  t0.wid AS wid_30,
  t0.paciente_id AS paciente_id_31,
  t0.doctor_id AS doctor_id_32,
  t0.sala_id AS sala_id_33,
  t0.seguro_id AS seguro_id_34,
  t0.especialidad_id AS especialidad_id_35,
  t36.id AS id_37,
  t36.grupo_sanquineo AS grupo_sanquineo_38,
  t36.presion AS presion_39,
  t36.pulso AS pulso_40,
  t36.temperatura AS temperatura_41,
  t36.estatura AS estatura_42,
  t36.peso AS peso_43,
  t36.estado AS estado_44,
  t36.ip_crea AS ip_crea_45,
  t36.ip_modifica AS ip_modifica_46,
  t36.user_crea AS user_crea_47,
  t36.user_modifica AS user_modifica_48,
  t36.created_at AS created_at_49,
  t36.updated_at AS updated_at_50,
  t36.observacion AS observacion_51,
  t36.frecuencia_respiratoria AS frecuencia_respiratoria_52,
  t36.saturacion_de_oxigeno AS saturacion_de_oxigeno_53,
  t36.perimetro_cefalico AS perimetro_cefalico_54,
  t36.perimetro_toraxico AS perimetro_toraxico_55,
  t36.cambio_de_peso AS cambio_de_peso_56,
  t36.agenda_id AS agenda_id_57,
  t58.id AS id_59,
  t58.motivo AS motivo_60,
  t58.evolucion AS evolucion_61,
  t58.examen_fisico AS examen_fisico_62,
  t58.indicaciones AS indicaciones_63,
  t58.estado AS estado_64,
  t58.ip_crea AS ip_crea_65,
  t58.ip_modifica AS ip_modifica_66,
  t58.user_crea AS user_crea_67,
  t58.user_modifica AS user_modifica_68,
  t58.created_at AS created_at_69,
  t58.updated_at AS updated_at_70,
  t58.enfermedad_actual AS enfermedad_actual_71,
  t58.revision_actual_organos_y_sistemas AS revision_actual_organos_y_sistemas_72,
  t58.descripcion_certificado AS descripcion_certificado_73,
  t58.hora_espera AS hora_espera_74,
  t58.dias_reposo AS dias_reposo_75,
  t58.reposo_desde AS reposo_desde_76,
  t58.reposo_hasta AS reposo_hasta_77,
  t58.ritmo AS ritmo_78,
  t58.frecuencia AS frecuencia_79,
  t58.intervalos AS intervalos_80,
  t58.segmento_st AS segmento_st_81,
  t58.eje_electrico AS eje_electrico_82,
  t58.imp_diagnostica_ekg AS imp_diagnostica_ekg_83,
  t58.conclusion AS conclusion_84,
  t58.riesgo AS riesgo_85,
  t58.recomendaciones AS recomendaciones_86,
  t58.diagnostico_clinico_cardiologico AS diagnostico_clinico_cardiologico_87,
  t58.trabaja_en AS trabaja_en_88,
  t58.puesto_trabajo AS puesto_trabajo_89,
  t58.presenta_sintomas AS presenta_sintomas_90,
  t58.aislamiento AS aislamiento_91,
  t58.ciudad_trabajo AS ciudad_trabajo_92,
  t58.tipo_contingencia AS tipo_contingencia_93,
  t58.certificado_evolucion AS certificado_evolucion_94,
  t58.certificado_diagnostico AS certificado_diagnostico_95,
  t58.certificado_cie10 AS certificado_cie10_96,
  t58.gota_fresca_disbiosis AS gota_fresca_disbiosis_97,
  t58.gota_fresca_cristales AS gota_fresca_cristales_98,
  t58.gota_fresca_hiperglicemia AS gota_fresca_hiperglicemia_99,
  t58.gota_fresca_hipoxia AS gota_fresca_hipoxia_100,
  t58.gota_fresca_acidez AS gota_fresca_acidez_101,
  t58.gota_fresca_inflamacion AS gota_fresca_inflamacion_102,
  t58.hlb_grado AS hlb_grado_103,
  t58.hlb_intolerancia_alimenticia AS hlb_intolerancia_alimenticia_104,
  t58.hlb_terreno_degenerativo_digestivo AS hlb_terreno_degenerativo_digestivo_105,
  t58.hlb_terreno_artrosico AS hlb_terreno_artrosico_106,
  t58.hlb_cnr AS hlb_cnr_107,
  t58.hlb_irritabilidad_nerviosa AS hlb_irritabilidad_nerviosa_108,
  t58.hlb_colesterol AS hlb_colesterol_109,
  t58.hlb_proceso_hepatico AS hlb_proceso_hepatico_110,
  t58.hlb_alergia AS hlb_alergia_111,
  t58.hlb_estres AS hlb_estres_112,
  t58.hlb_inflamacion AS hlb_inflamacion_113,
  t58.hlb_anemia AS hlb_anemia_114,
  t58.hlb_afectacion_muscular AS hlb_afectacion_muscular_115,
  t58.hlb_sol_toxico AS hlb_sol_toxico_116,
  t58.hlb_congestion_linfatica AS hlb_congestion_linfatica_117,
  t58.agenda_id AS agenda_id_118,
  t58.paciente_id AS paciente_id_119,
  t0.procedimiento_id AS procedimiento_id_120,
  t0.doctor_consulta_id AS doctor_consulta_id_121,
  t0.origen_especialidad_id AS origen_especialidad_id_122,
  t0.anestesiologo_id AS anestesiologo_id_123,
  t0.recomendado_id AS recomendado_id_124,
  t0.redsocial_id AS redsocial_id_125,
  t0.referencia_id AS referencia_id_126
FROM
  agenda t0
  LEFT JOIN preparacion t36 ON t36.agenda_id = t0.id
  LEFT JOIN historia_clinica t58 ON t58.agenda_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.inicio AS inicio_2, t0.fin AS fin_3, t0.estado AS estado_4, t0.ip_crea AS ip_crea_5, t0.ip_modifica AS ip_modifica_6, t0.user_crea AS user_crea_7, t0.user_modifica AS user_modifica_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.observacion AS observacion_11, t0.estado_agenda AS estado_agenda_12, t0.archivo053 AS archivo053_13, t0.tipo_consulta AS tipo_consulta_14, t0.origen AS origen_15, t0.fecha_consulta AS fecha_consulta_16, t0.cie10_recep AS cie10_recep_17, t0.validacion AS validacion_18, t0.cobrado AS cobrado_19, t0.factura AS factura_20, t0.fecha_factura AS fecha_factura_21, t0.fecha_pago AS fecha_pago_22, t0.verificado AS verificado_23, t0.confirma AS confirma_24, t0.corte_seguro AS corte_seguro_25, t0.salud_producto AS salud_producto_26, t0.salud_nropersona AS salud_nropersona_27, t0.salud_nivel AS salud_nivel_28, t0.documentos AS documentos_29, t0.wid AS wid_30, t0.paciente_id AS paciente_id_31, t0.doctor_id AS doctor_id_32, t0.sala_id AS sala_id_33, t0.seguro_id AS seguro_id_34, t0.especialidad_id AS especialidad_id_35, t36.id AS id_37, t36.grupo_sanquineo AS grupo_sanquineo_38, t36.presion AS presion_39, t36.pulso AS pulso_40, t36.temperatura AS temperatura_41, t36.estatura AS estatura_42, t36.peso AS peso_43, t36.estado AS estado_44, t36.ip_crea AS ip_crea_45, t36.ip_modifica AS ip_modifica_46, t36.user_crea AS user_crea_47, t36.user_modifica AS user_modifica_48, t36.created_at AS created_at_49, t36.updated_at AS updated_at_50, t36.observacion AS observacion_51, t36.frecuencia_respiratoria AS frecuencia_respiratoria_52, t36.saturacion_de_oxigeno AS saturacion_de_oxigeno_53, t36.perimetro_cefalico AS perimetro_cefalico_54, t36.perimetro_toraxico AS perimetro_toraxico_55, t36.cambio_de_peso AS cambio_de_peso_56, t36.agenda_id AS agenda_id_57, t58.id AS id_59, t58.motivo AS motivo_60, t58.evolucion AS evolucion_61, t58.examen_fisico AS examen_fisico_62, t58.indicaciones AS indicaciones_63, t58.estado AS estado_64, t58.ip_crea AS ip_crea_65, t58.ip_modifica AS ip_modifica_66, t58.user_crea AS user_crea_67, t58.user_modifica AS user_modifica_68, t58.created_at AS created_at_69, t58.updated_at AS updated_at_70, t58.enfermedad_actual AS enfermedad_actual_71, t58.revision_actual_organos_y_sistemas AS revision_actual_organos_y_sistemas_72, t58.descripcion_certificado AS descripcion_certificado_73, t58.hora_espera AS hora_espera_74, t58.dias_reposo AS dias_reposo_75, t58.reposo_desde AS reposo_desde_76, t58.reposo_hasta AS reposo_hasta_77, t58.ritmo AS ritmo_78, t58.frecuencia AS frecuencia_79, t58.intervalos AS intervalos_80, t58.segmento_st AS segmento_st_81, t58.eje_electrico AS eje_electrico_82, t58.imp_diagnostica_ekg AS imp_diagnostica_ekg_83, t58.conclusion AS conclusion_84, t58.riesgo AS riesgo_85, t58.recomendaciones AS recomendaciones_86, t58.diagnostico_clinico_cardiologico AS diagnostico_clinico_cardiologico_87, t58.trabaja_en AS trabaja_en_88, t58.puesto_trabajo AS puesto_trabajo_89, t58.presenta_sintomas AS presenta_sintomas_90, t58.aislamiento AS aislamiento_91, t58.ciudad_trabajo AS ciudad_trabajo_92, t58.tipo_contingencia AS tipo_contingencia_93, t58.certificado_evolucion AS certificado_evolucion_94, t58.certificado_diagnostico AS certificado_diagnostico_95, t58.certificado_cie10 AS certificado_cie10_96, t58.gota_fresca_disbiosis AS gota_fresca_disbiosis_97, t58.gota_fresca_cristales AS gota_fresca_cristales_98, t58.gota_fresca_hiperglicemia AS gota_fresca_hiperglicemia_99, t58.gota_fresca_hipoxia AS gota_fresca_hipoxia_100, t58.gota_fresca_acidez AS gota_fresca_acidez_101, t58.gota_fresca_inflamacion AS gota_fresca_inflamacion_102, t58.hlb_grado AS hlb_grado_103, t58.hlb_intolerancia_alimenticia AS hlb_intolerancia_alimenticia_104, t58.hlb_terreno_degenerativo_digestivo AS hlb_terreno_degenerativo_digestivo_105, t58.hlb_terreno_artrosico AS hlb_terreno_artrosico_106, t58.hlb_cnr AS hlb_cnr_107, t58.hlb_irritabilidad_nerviosa AS hlb_irritabilidad_nerviosa_108, t58.hlb_colesterol AS hlb_colesterol_109, t58.hlb_proceso_hepatico AS hlb_proceso_hepatico_110, t58.hlb_alergia AS hlb_alergia_111, t58.hlb_estres AS hlb_estres_112, t58.hlb_inflamacion AS hlb_inflamacion_113, t58.hlb_anemia AS hlb_anemia_114, t58.hlb_afectacion_muscular AS hlb_afectacion_muscular_115, t58.hlb_sol_toxico AS hlb_sol_toxico_116, t58.hlb_congestion_linfatica AS hlb_congestion_linfatica_117, t58.agenda_id AS agenda_id_118, t58.paciente_id AS paciente_id_119, t0.procedimiento_id AS procedimiento_id_120, t0.doctor_consulta_id AS doctor_consulta_id_121, t0.origen_especialidad_id AS origen_especialidad_id_122, t0.anestesiologo_id AS anestesiologo_id_123, t0.recomendado_id AS recomendado_id_124, t0.redsocial_id AS redsocial_id_125, t0.referencia_id AS referencia_id_126 FROM agenda t0 LEFT JOIN preparacion t36 ON t36.agenda_id = t0.id LEFT JOIN historia_clinica t58 ON t58.agenda_id = t0.id WHERE t0.id = '2537';

0.61 ms

SELECT t0.id AS id_1, t0.ip_crea AS ip_crea_2, t0.ip_modifica AS ip_modifica_3, t0.user_crea AS user_crea_4, t0.user_modifica AS user_modifica_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.agenda_id AS agenda_id_8, t0.procedimiento_id AS procedimiento_id_9 FROM agenda_procedimiento t0 WHERE t0.agenda_id = ?

Parameters:

[
  2537
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.ip_crea AS ip_crea_2,
  t0.ip_modifica AS ip_modifica_3,
  t0.user_crea AS user_crea_4,
  t0.user_modifica AS user_modifica_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.agenda_id AS agenda_id_8,
  t0.procedimiento_id AS procedimiento_id_9
FROM
  agenda_procedimiento t0
WHERE
  t0.agenda_id = ?

SELECT t0.id AS id_1, t0.ip_crea AS ip_crea_2, t0.ip_modifica AS ip_modifica_3, t0.user_crea AS user_crea_4, t0.user_modifica AS user_modifica_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.agenda_id AS agenda_id_8, t0.procedimiento_id AS procedimiento_id_9 FROM agenda_procedimiento t0 WHERE t0.agenda_id = 2537;

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\Sala	No errors.
App\Entity\SeguroPrivado	No errors.
App\Entity\Preparacion	No errors.
App\Entity\HistoriaClinica	No errors.
App\Entity\Procedimientos	No errors.
App\Entity\RedSocial	No errors.
App\Entity\HdSolicitud	No errors.
App\Entity\HdPaso	No errors.
App\Entity\HdOrdenes	No errors.
App\Entity\OdontogramaProcedimiento	No errors.
App\Entity\DatosCirugia	No errors.
App\Entity\AgendaProcedimiento	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/agenda_procedimiento/2537

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping