https://api.dahnapp.com/api/profiles/history

Query Metrics

5 Database Queries
5 Different statements
269.19 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
124.68 ms
(46.32%)
1
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.country_id AS country_id_3, t0.gender AS gender_4, t0.age AS age_5, t0.weight AS weight_6, t0.height AS height_7, t0.physical_activity_level AS physical_activity_level_8, t0.smoker AS smoker_9, t0.systolic_blood_pressure AS systolic_blood_pressure_10, t0.hypertension_treatment AS hypertension_treatment_11, t0.total_cholesterol AS total_cholesterol_12, t0.hdl_cholesterol AS hdl_cholesterol_13, t0.non_hdl_cholesterol AS non_hdl_cholesterol_14, t0.myocardial_infarction AS myocardial_infarction_15, t0.angina_pectoris AS angina_pectoris_16, t0.coronary_artery_bypass AS coronary_artery_bypass_17, t0.arthritis AS arthritis_18, t0.stroke AS stroke_19, t0.angioplasty AS angioplasty_20, t0.diabetes AS diabetes_21, t0.water AS water_22, t0.imc AS imc_23, t0.calories AS calories_24, t0.hba1c AS hba1c_25, t0.unit_measure_hba1c AS unit_measure_hba1c_26, t0.fasting_blood_sugar AS fasting_blood_sugar_27, t0.creatinine AS creatinine_28, t0.urea AS urea_29, t0.egfr AS egfr_30, t0.unit_measure_concentration AS unit_measure_concentration_31, t0.cvd_score_id AS cvd_score_id_32, t0.master_profile AS master_profile_33, t0.created_at AS created_at_34, t0.favourite_menus AS favourite_menus_35, t0.diabetes_status AS diabetes_status_36, t0.diabetes_diagnosis_year AS diabetes_diagnosis_year_37 FROM cardiometabolic_profiles t0 WHERE t0.user_id = ? AND t0.master_profile = ? ORDER BY t0.id DESC
Parameters:
[
  37346
  1
]
59.57 ms
(22.13%)
1
SELECT t0.id AS id_1, t0.gender AS gender_2, t0.smoking AS smoking_3, t0.systolic_blood_presure_id AS systolic_blood_presure_id_4, t0.age_category_id AS age_category_id_5, t0.non_hdl_cholesterol_id AS non_hdl_cholesterol_id_6, t0.cvd_risk_id AS cvd_risk_id_7, t0.score AS score_8, t0.score_risk_id AS score_risk_id_9, t0.removed AS removed_10 FROM cardiovascular_score t0 WHERE t0.id = ?
Parameters:
[
  2254
]
39.66 ms
(14.73%)
1
SELECT t0.id AS id_1, t0.score_risk AS score_risk_2, t0.color AS color_3 FROM score_risk t0 WHERE t0.id = ?
Parameters:
[
  2
]
39.58 ms
(14.70%)
1
SELECT t0.id AS id_1, t0.email_address AS email_address_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.fullname AS fullname_5, t0.username AS username_6, t0.password AS password_7, t0.mobile_phone AS mobile_phone_8, t0.profile_image AS profile_image_9, t0.register_source AS register_source_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.tos_consent_at AS tos_consent_at_13, t0.gdpr_consent_at AS gdpr_consent_at_14, t0.lang AS lang_15, t0.active AS active_16, t0.email_verified AS email_verified_17, t0.update_email_sent AS update_email_sent_18, t0.do_not_email AS do_not_email_19, t0.removed AS removed_20, t0.last_notification AS last_notification_21, t0.unit_measure AS unit_measure_22, t0.user_points AS user_points_23, t0.healthy_minutes AS healthy_minutes_24, t0.latest_subscription_id AS latest_subscription_id_25 FROM users t0 WHERE t0.id = ?
Parameters:
[
  37346
]
5.71 ms
(2.12%)
1
SELECT t0.id AS id_1, t0.token AS token_2, t0.expires_at AS expires_at_3, t0.user_id AS user_id_4 FROM api_token t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
  "78d8acd495b5b662a0bd28d91332e8f3722b564715a493b5129a581b8c4adf0b303034879fce20d4ed3e19ee17042002482dfe1adcd6dd04a180fb64"
]

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