https://api.dahnapp.com/api/menus/119/healthy_minutes

Query Metrics

6 Database Queries
6 Different statements
7.16 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.87 ms
(40.13%)
1
"COMMIT"
Parameters:
[]
1.19 ms
(16.56%)
1
UPDATE users SET healthy_minutes = ? WHERE id = ?
Parameters:
[
  233
  33851
]
1.17 ms
(16.36%)
1
SELECT m0_.id AS id_0, m0_.menu_name AS menu_name_1, m0_.calories AS calories_2, m0_.proteins AS proteins_3, m0_.fats AS fats_4, m0_.sugar AS sugar_5, c1_.category_name AS category_name_6, m0_.category_id AS category_id_7, c1_.image AS image_8, m0_.healthy_minutes AS healthy_minutes_9, m0_.energy AS energy_10, m0_.protein AS protein_11, m0_.sugars_total AS sugars_total_12, m0_.carbohydrate AS carbohydrate_13, m0_.fiber_total_dietary AS fiber_total_dietary_14, m0_.total_fat AS total_fat_15, m0_.fatty_acids_total_saturated AS fatty_acids_total_saturated_16, m0_.fatty_acids_total_monosaturated AS fatty_acids_total_monosaturated_17, m0_.fatty_acids_total_polyunsaturated AS fatty_acids_total_polyunsaturated_18, m0_.cholesterol AS cholesterol_19, m0_.retinol AS retinol_20, m0_.vitamin_a AS vitamin_a_21, m0_.carotene_alpha AS carotene_alpha_22, m0_.carotene_beta AS carotene_beta_23, m0_.cryptoxanthin_beta AS cryptoxanthin_beta_24, m0_.lycopene AS lycopene_25, m0_.lutein_zeaxanthin AS lutein_zeaxanthin_26, m0_.thiamin AS thiamin_27, m0_.riboflavin AS riboflavin_28, m0_.niacin AS niacin_29, m0_.vitamin_b6 AS vitamin_b6_30, m0_.folic_acid AS folic_acid_31, m0_.folate_food AS folate_food_32, m0_.folate_dfe AS folate_dfe_33, m0_.folate_total AS folate_total_34, m0_.choline_total AS choline_total_35, m0_.vitamin_b12 AS vitamin_b12_36, m0_.vitamin_b12_added AS vitamin_b12_added_37, m0_.vitamin_c AS vitamin_c_38, m0_.vitamin_d_d2_d3 AS vitamin_d_d2_d3_39, m0_.vitamin_e_alpha_tocopherol AS vitamin_e_alpha_tocopherol_40, m0_.vitamin_e_added AS vitamin_e_added_41, m0_.vitamin_k_phylloquinone AS vitamin_k_phylloquinone_42, m0_.calcium AS calcium_43, m0_.phosphorus AS phosphorus_44, m0_.magnesium AS magnesium_45, m0_.iron AS iron_46, m0_.zinc AS zinc_47, m0_.copper AS copper_48, m0_.selenium AS selenium_49, m0_.potassium AS potassium_50, m0_.sodium AS sodium_51, m0_.caffeine AS caffeine_52, m0_.theobromine AS theobromine_53, m0_.alcohol AS alcohol_54, m0_.water AS water_55, m0_.healthy_minutes AS healthy_minutes_56 FROM menus m0_ INNER JOIN categories c1_ ON (c1_.id = m0_.category_id) WHERE m0_.id = ? AND m0_.active = 1 AND m0_.removed = 0 LIMIT 1
Parameters:
[
  "119"
]
0.85 ms
(11.92%)
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:
[
  33851
]
0.70 ms
(9.81%)
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:
[
  "4a00395ede6e8358bea352e7042c79009d698bf261b6e83cbf48f0ca87bd0a8f46eb99b487ea3bd4cea268c017cb7f8beaa6beda1a3ff9a254ad3328"
]
0.37 ms
(5.21%)
1
"START TRANSACTION"
Parameters:
[]

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\Menus No errors.
App\Entity\Categories No errors.