https://api.dahnapp.com/api/objective/get/31649

Query Metrics

3 Database Queries
3 Different statements
24.30 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
19.58 ms
(80.61%)
1
SELECT o0_.user_id AS user_id_0, o0_.weight AS weight_1, o0_.objective_weight AS objective_weight_2, o0_.last_notification AS last_notification_3, o0_.notification_category AS notification_category_4, o0_.next_notification AS next_notification_5, o0_.next_notification_weight AS next_notification_weight_6, o0_.notifications AS notifications_7, o0_.notifications_sent AS notifications_sent_8, o0_.created_at AS created_at_9 FROM objectives o0_ WHERE o0_.user_id = ? AND o0_.cancelled_at IS NULL LIMIT 1
Parameters:
[
  31649
]
3.87 ms
(15.95%)
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:
[
  31649
]
0.84 ms
(3.45%)
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:
[
  "49a3673335a081a980d611b8f10baab5096ec41cc979a7d85fbc42fd13e966192a863c25576e0f06d5a56d87539614fcb94fe56b05b1f6ce95b205a7"
]

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\Objectives No errors.