Query Metrics
3
Database Queries
3
Different statements
47.28 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.85 ms |
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:
[
"50203ffce2a443ac5e72f671b280220a95b3bc9f07c82eb213b630e29878887b8d765ee0796af46885e12a15934ba6aa79404bd96d2291f9a055e497"
]
|
| 2 | 10.93 ms |
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:
[
37099
]
|
| 3 | 32.50 ms |
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:
[ 37099 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\ApiToken | No errors. |
| App\Entity\Users | No errors. |
| App\Entity\UserSubscriptions | No errors. |
| App\Entity\UserVouchers | No errors. |
| App\Entity\UserPointsHistory | No errors. |
| App\Entity\Feedbacks | No errors. |
| App\Entity\CardiometabolicProfiles | No errors. |