GET https://panel.smartescrow.eu/user?page=2&sort%5Bemail%5D=DESC

Query Metrics

23 Database Queries
4 Different statements
7.98 ms Query time
0 Invalid entities
24 Managed entities

Grouped Statements

Show all queries

Time Count Info
6.27 ms
(78.64%)
20
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.secret AS secret_3, t0.name AS name_4, t0.redirect_uris AS redirect_uris_5, t0.grant_types AS grant_types_6, t0.scopes AS scopes_7, t0.is_confidential AS is_confidential_8, t0.logo_url AS logo_url_9, t0.help_text AS help_text_10, t0.terms_url AS terms_url_11, t0.privacy_policy_url AS privacy_policy_url_12, t0.created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0.id = user_oauth_client_access.oauth_client_id WHERE user_oauth_client_access.user_id = ?
Parameters:
[
  "30d2d380-3ec5-5e8c-bc73-cef91d8ade3d"
]
0.77 ms
(9.64%)
1
SELECT DISTINCT u0_.id AS id_0, u0_.email AS email_1, u0_.created_at AS created_at_2 FROM `user` u0_ ORDER BY u0_.email DESC, u0_.created_at DESC LIMIT 20 OFFSET 20
Parameters:
[]
0.63 ms
(7.93%)
1
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.first_name AS first_name_4, u0_.last_name AS last_name_5, u0_.is_active AS is_active_6, u0_.created_at AS created_at_7, u0_.type_person AS type_person_8, u0_.nif AS nif_9, u0_.company_name AS company_name_10, u0_.alias AS alias_11, u0_.logo AS logo_12 FROM `user` u0_ WHERE u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY u0_.email DESC, u0_.created_at DESC
Parameters:
[
  "30d2d380-3ec5-5e8c-bc73-cef91d8ade3d"
  "383c0f88-d0e7-5f2a-be5e-2b2e0170dca6"
  "ca78574a-8d29-51ed-87b6-8fd1161be6a3"
  "149a2021-26ad-5ae5-84c2-199e7163fc91"
  "96fa030e-85be-5210-8929-9ee7cb7fd043"
  "88b7aab9-8126-5cf2-9cd8-3113f4540242"
  "e5610dfd-8d33-5446-9d32-a606cf9b141e"
  "a1c6bb8b-27fb-4b5d-b2d7-347ab7e9839b"
  "7810f419-28d0-5ef5-8633-837d6f43bbff"
  "8b171a7b-10d0-5541-a4b3-c481755e9301"
  "da8ca43b-3a94-5403-9235-6ac2ed18f8e4"
  "ab210ab4-64ab-566e-a2f7-5e06bb738a47"
  "18760d99-9700-5202-989a-5be18e52e3d4"
  "295d0247-1a23-532b-8a41-6a4f704075dd"
  "9e898906-48b8-5570-b4f2-a5e90cd00223"
  "b88c2da3-b8ec-11f0-a10c-a0ad9f24310d"
  "b88e30e5-b8ec-11f0-a10c-a0ad9f24310d"
  "792b67cd-5e60-532f-bd75-5e02522f8393"
  "b88b23e6-b8ec-11f0-a10c-a0ad9f24310d"
  "20bd20a1-61ed-5cf3-8d82-0d073709c0a5"
]
0.30 ms
(3.78%)
1
SELECT count(*) AS sclr_0 FROM `user` u0_
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\Entity\User 20
App\Entity\OAuthClient 4

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\OAuthClient No errors.