https://api.dahnapp.com/api/recipes/18?lang=ro

Query Metrics

4 Database Queries
4 Different statements
4.88 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.21 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:
[
  "e7d50eab261d70723afdaf23c26225c59066cf9cc595611d3e9e7a6fbae357bbcab02f6e888e2176e4d72b7e0c0696fa708c1604b2161e31350c9604"
]
2 1.07 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:
[
  37343
]
3 1.07 ms
SELECT r0_.id AS id_0, r0_.recipe_name AS recipe_name_1, r0_.recipe_description AS recipe_description_2, r0_.calories AS calories_3, r0_.proteins AS proteins_4, r0_.fats AS fats_5, r0_.sugar AS sugar_6, r0_.active AS active_7, r0_.removed AS removed_8 FROM recipes r0_ WHERE r0_.id = ? AND r0_.active = 1 AND r0_.removed = 0 LIMIT 1
Parameters:
[
  "18"
]
4 1.52 ms
SELECT r0_.ingredient_id AS ingredient_id_0, r0_.quantity AS quantity_1, i1_.ingredient_name AS ingredient_name_2, i1_.unit_measure_id AS unit_measure_id_3, u2_.unit_measure_name AS unit_measure_name_4, u2_.abbreviation AS abbreviation_5, i1_.category_id AS category_id_6, i3_.category_name AS category_name_7, i3_.image AS image_8 FROM recipe_ingredients r0_ INNER JOIN ingredients i1_ ON (i1_.id = r0_.ingredient_id) INNER JOIN unit_measures u2_ ON (u2_.id = i1_.unit_measure_id) LEFT JOIN ingredient_categories i3_ ON (i3_.id = i1_.category_id) WHERE r0_.recipe_id = ? AND r0_.removed = 0
Parameters:
[
  "18"
]

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