https://api.dahnapp.com/api/countries

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
8.18 ms
(77.63%)
1
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 ORDER BY t0.country_name ASC
Parameters:
[]
1.28 ms
(12.17%)
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:
[
  27882
]
1.08 ms
(10.20%)
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:
[
  "4a0e1ffc42e51ceda98af011aa3fb6987974f0aa363e5f3fa9ce25d6e4ee82a0f53d50a0d56da189f62040b33c7ef06976da48946a890e15f28cff15"
]

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