GET https://api.whitefrog.ru/api/v1/asset

Query Metrics

2 Database Queries
2 Different statements
5.11 ms Query time
0 Invalid entities
2 Managed entities

Queries

Group similar statements

#▲ Time Info
1 3.48 ms
SELECT t0.login AS login_1, t0.email AS email_2, t0.password_hash AS password_hash_3, t0.status AS status_4, t0.roles AS roles_5, t0.id AS id_6, t0.public_id AS public_id_7, t0.created_at AS created_at_8, t0.name AS name_9, t0.surname AS surname_10, t0.patronymic AS patronymic_11, t0.avatar_id AS avatar_id_12, t13.chat_id AS chat_id_14, t13.username AS username_15, t13.first_name AS first_name_16, t13.last_name AS last_name_17, t13.language_code AS language_code_18, t13.auth_token AS auth_token_19, t13.auth_token_expires AS auth_token_expires_20, t13.id AS id_21, t13.created_at AS created_at_22, t13.status AS status_23, t13.user_id AS user_id_24, t25.token AS token_26, t25.status AS status_27, t25.id AS id_28, t25.public_id AS public_id_29, t25.created_at AS created_at_30, t25.period_from AS period_from_31, t25.period_to AS period_to_32, t25.user_id AS user_id_33 FROM users t0 LEFT JOIN telegram_users t13 ON t13.user_id = t0.id LEFT JOIN confirm_tokens t25 ON t25.user_id = t0.id WHERE t0.login = ? LIMIT 1
Parameters:
[
  "admin"
]
2 1.63 ms
SELECT a.*, f.public_id file_public_id FROM assets a LEFT JOIN files f ON a.icon_id = f.id ORDER BY a.active DESC, a.payment DESC, a.symbol ASC
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Domain\User\Entity\User 1
App\Domain\File\Entity\File 1