Symfony Profiler

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

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

SELECT
  c0_.id AS id_0,
  c0_.user_id AS user_id_1,
  c0_.country_id AS country_id_2,
  c0_.gender AS gender_3,
  c0_.age AS age_4,
  c0_.weight AS weight_5,
  c0_.height AS height_6,
  c0_.physical_activity_level AS physical_activity_level_7,
  c0_.smoker AS smoker_8,
  c0_.systolic_blood_pressure AS systolic_blood_pressure_9,
  c0_.hypertension_treatment AS hypertension_treatment_10,
  c0_.total_cholesterol AS total_cholesterol_11,
  c0_.hdl_cholesterol AS hdl_cholesterol_12,
  c0_.non_hdl_cholesterol AS non_hdl_cholesterol_13,
  c0_.myocardial_infarction AS myocardial_infarction_14,
  c0_.angina_pectoris AS angina_pectoris_15,
  c0_.coronary_artery_bypass AS coronary_artery_bypass_16,
  c0_.arthritis AS arthritis_17,
  c0_.stroke AS stroke_18,
  c0_.angioplasty AS angioplasty_19,
  c0_.diabetes AS diabetes_20,
  c0_.water AS water_21,
  c0_.imc AS imc_22,
  c0_.calories AS calories_23,
  c0_.hba1c AS hba1c_24,
  c0_.unit_measure_hba1c AS unit_measure_hba1c_25,
  c0_.fasting_blood_sugar AS fasting_blood_sugar_26,
  c0_.creatinine AS creatinine_27,
  c0_.urea AS urea_28,
  c0_.egfr AS egfr_29,
  c0_.unit_measure_concentration AS unit_measure_concentration_30,
  c0_.cvd_score_id AS cvd_score_id_31,
  c0_.master_profile AS master_profile_32,
  c0_.created_at AS created_at_33,
  c0_.favourite_menus AS favourite_menus_34,
  c0_.diabetes_status AS diabetes_status_35,
  c0_.diabetes_diagnosis_year AS diabetes_diagnosis_year_36
FROM
  cardiometabolic_profiles c0_
WHERE
  c0_.user_id = ?
ORDER BY
  c0_.id DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.user_id AS user_id_1, c0_.country_id AS country_id_2, c0_.gender AS gender_3, c0_.age AS age_4, c0_.weight AS weight_5, c0_.height AS height_6, c0_.physical_activity_level AS physical_activity_level_7, c0_.smoker AS smoker_8, c0_.systolic_blood_pressure AS systolic_blood_pressure_9, c0_.hypertension_treatment AS hypertension_treatment_10, c0_.total_cholesterol AS total_cholesterol_11, c0_.hdl_cholesterol AS hdl_cholesterol_12, c0_.non_hdl_cholesterol AS non_hdl_cholesterol_13, c0_.myocardial_infarction AS myocardial_infarction_14, c0_.angina_pectoris AS angina_pectoris_15, c0_.coronary_artery_bypass AS coronary_artery_bypass_16, c0_.arthritis AS arthritis_17, c0_.stroke AS stroke_18, c0_.angioplasty AS angioplasty_19, c0_.diabetes AS diabetes_20, c0_.water AS water_21, c0_.imc AS imc_22, c0_.calories AS calories_23, c0_.hba1c AS hba1c_24, c0_.unit_measure_hba1c AS unit_measure_hba1c_25, c0_.fasting_blood_sugar AS fasting_blood_sugar_26, c0_.creatinine AS creatinine_27, c0_.urea AS urea_28, c0_.egfr AS egfr_29, c0_.unit_measure_concentration AS unit_measure_concentration_30, c0_.cvd_score_id AS cvd_score_id_31, c0_.master_profile AS master_profile_32, c0_.created_at AS created_at_33, c0_.favourite_menus AS favourite_menus_34, c0_.diabetes_status AS diabetes_status_35, c0_.diabetes_diagnosis_year AS diabetes_diagnosis_year_36 FROM cardiometabolic_profiles c0_ WHERE c0_.user_id = 27882 ORDER BY c0_.id DESC LIMIT 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

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 = '4a0e1ffc42e51ceda98af011aa3fb6987974f0aa363e5f3fa9ce25d6e4ee82a0f53d50a0d56da189f62040b33c7ef06976da48946a890e15f28cff15' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.language_id AS language_id_1,
  c0_.advice AS advice_2,
  c0_.smoker AS smoker_3,
  c0_.non_smoker AS non_smoker_4,
  c0_.imc_exceeded AS imc_exceeded_5,
  c0_.is_default AS is_default_6,
  c0_.country_id AS country_id_7,
  c0_.title AS title_8,
  c0_.pro_version AS pro_version_9,
  c0_.image AS image_10,
  c0_.diabetes_status AS diabetes_status_11
FROM
  cvd_advices c0_
WHERE
  (
    c0_.non_smoker = ?
    OR c0_.diabetes_status = ?
    OR c0_.is_default = ?
  )
  AND c0_.country_id IS NULL
  AND c0_.language_id = ?
  AND c0_.pro_version = ?

SELECT c0_.id AS id_0, c0_.language_id AS language_id_1, c0_.advice AS advice_2, c0_.smoker AS smoker_3, c0_.non_smoker AS non_smoker_4, c0_.imc_exceeded AS imc_exceeded_5, c0_.is_default AS is_default_6, c0_.country_id AS country_id_7, c0_.title AS title_8, c0_.pro_version AS pro_version_9, c0_.image AS image_10, c0_.diabetes_status AS diabetes_status_11 FROM cvd_advices c0_ WHERE (c0_.non_smoker = 1 OR c0_.diabetes_status = 3 OR c0_.is_default = 1) AND c0_.country_id IS NULL AND c0_.language_id = 2 AND c0_.pro_version = 0;

SELECT
  t0.id AS id_1,
  t0.country_name AS country_name_2,
  t0.iso_code_2 AS iso_code_2_3,
  t0.iso_code_3 AS iso_code_3_4,
  t0.address_format AS address_format_5,
  t0.postcode_required AS postcode_required_6,
  t0.status AS status_7,
  t0.is_ue AS is_ue_8,
  t0.risk_id AS risk_id_9,
  t0.mmol_unit AS mmol_unit_10,
  t0.unit_measure AS unit_measure_11
FROM
  countries t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.country_name AS country_name_2, t0.iso_code_2 AS iso_code_2_3, t0.iso_code_3 AS iso_code_3_4, t0.address_format AS address_format_5, t0.postcode_required AS postcode_required_6, t0.status AS status_7, t0.is_ue AS is_ue_8, t0.risk_id AS risk_id_9, t0.mmol_unit AS mmol_unit_10, t0.unit_measure AS unit_measure_11 FROM countries t0 WHERE t0.id = 175;

SELECT
  c0_.id AS id_0,
  c0_.language_id AS language_id_1,
  c0_.advice AS advice_2,
  c0_.smoker AS smoker_3,
  c0_.non_smoker AS non_smoker_4,
  c0_.imc_exceeded AS imc_exceeded_5,
  c0_.is_default AS is_default_6,
  c0_.country_id AS country_id_7,
  c0_.title AS title_8,
  c0_.pro_version AS pro_version_9,
  c0_.image AS image_10,
  c0_.diabetes_status AS diabetes_status_11
FROM
  cvd_advices c0_
WHERE
  (
    c0_.non_smoker = ?
    OR c0_.diabetes_status = ?
    OR c0_.is_default = ?
  )
  AND c0_.country_id = ?
  AND c0_.language_id = ?
  AND c0_.pro_version = ?

SELECT c0_.id AS id_0, c0_.language_id AS language_id_1, c0_.advice AS advice_2, c0_.smoker AS smoker_3, c0_.non_smoker AS non_smoker_4, c0_.imc_exceeded AS imc_exceeded_5, c0_.is_default AS is_default_6, c0_.country_id AS country_id_7, c0_.title AS title_8, c0_.pro_version AS pro_version_9, c0_.image AS image_10, c0_.diabetes_status AS diabetes_status_11 FROM cvd_advices c0_ WHERE (c0_.non_smoker = 1 OR c0_.diabetes_status = 3 OR c0_.is_default = 1) AND c0_.country_id = 175 AND c0_.language_id = 2 AND c0_.pro_version = 0;

SELECT
  a0_.id AS id_0,
  a0_.age_category AS age_category_1,
  a0_.from_val AS from_val_2,
  a0_.to_val AS to_val_3
FROM
  age_categories a0_
WHERE
  (
    ? BETWEEN a0_.from_val
    AND a0_.to_val
  )
  OR (
    ? >= a0_.from_val
    AND a0_.to_val IS NULL
  )
LIMIT
  1

SELECT a0_.id AS id_0, a0_.age_category AS age_category_1, a0_.from_val AS from_val_2, a0_.to_val AS to_val_3 FROM age_categories a0_ WHERE (30 BETWEEN a0_.from_val AND a0_.to_val) OR (30 >= a0_.from_val AND a0_.to_val IS NULL) LIMIT 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.gender = ?
  AND t0.smoking = ?
  AND t0.systolic_blood_presure_id = ?
  AND t0.age_category_id = ?
  AND t0.non_hdl_cholesterol_id = ?
  AND t0.cvd_risk_id = ?
  AND t0.removed = ?
LIMIT
  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.gender = 2 AND t0.smoking = 0 AND t0.systolic_blood_presure_id = 2 AND t0.age_category_id = 1 AND t0.non_hdl_cholesterol_id = 1 AND t0.cvd_risk_id = 4 AND t0.removed = 0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cvd_risk AS cvd_risk_2
FROM
  cvd_risks t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cvd_risk AS cvd_risk_2 FROM cvd_risks t0 WHERE t0.id = 4;

SELECT
  s0_.id AS id_0,
  s0_.systolic_blood_presure AS systolic_blood_presure_1,
  s0_.from_val AS from_val_2,
  s0_.to_val AS to_val_3
FROM
  systolic_blood_presure s0_
WHERE
  (
    ? BETWEEN s0_.from_val
    AND s0_.to_val
  )
LIMIT
  1

SELECT s0_.id AS id_0, s0_.systolic_blood_presure AS systolic_blood_presure_1, s0_.from_val AS from_val_2, s0_.to_val AS to_val_3 FROM systolic_blood_presure s0_ WHERE (135 BETWEEN s0_.from_val AND s0_.to_val) LIMIT 1;

SELECT
  n0_.id AS id_0,
  n0_.non_hdl_cholesterol AS non_hdl_cholesterol_1,
  n0_.from_val AS from_val_2,
  n0_.to_val AS to_val_3
FROM
  non_hdl_cholesterol n0_
WHERE
  (
    ? BETWEEN n0_.from_val
    AND n0_.to_val
  )
  OR (
    ? >= n0_.from_val
    AND n0_.to_val IS NULL
  )
LIMIT
  1

SELECT n0_.id AS id_0, n0_.non_hdl_cholesterol AS non_hdl_cholesterol_1, n0_.from_val AS from_val_2, n0_.to_val AS to_val_3 FROM non_hdl_cholesterol n0_ WHERE (107 BETWEEN n0_.from_val AND n0_.to_val) OR (107 >= n0_.from_val AND n0_.to_val IS NULL) LIMIT 1;