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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
5.19 ms
(79.86%)
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.auto_register AS auto_register_9, t0.logo_url AS logo_url_10, t0.help_text AS help_text_11, t0.terms_url AS terms_url_12, t0.privacy_policy_url AS privacy_policy_url_13, t0.created_at AS created_at_14 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:
[
  "b3a39076-9606-40a6-a5f9-5b719c96bcf8"
]
0.53 ms
(8.13%)
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, u0_.reset_token AS reset_token_13, u0_.reset_token_expires_at AS reset_token_expires_at_14 FROM `user` u0_ WHERE u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY u0_.id DESC, u0_.created_at DESC
Parameters:
[
  "b3a39076-9606-40a6-a5f9-5b719c96bcf8"
  "b2c601a4-109f-59ab-977b-df01d09d6c9b"
  "b1d2753f-0283-54af-b645-d505678657dd"
  "b004d04d-a75b-5ab7-a682-fb09a6fda9f0"
  "afe081d9-7ce9-5127-bcbb-97a662e79a35"
  "ab210ab4-64ab-566e-a2f7-5e06bb738a47"
  "aaf9b1b8-8ff2-57fc-ba65-b043f9274431"
  "aa33e56a-72b3-44c1-a98b-3a68b84ffac8"
  "a872af1d-318c-5487-9996-323c647decae"
  "a7b78323-db38-5174-b8c7-290d6784fcb8"
  "a77b0a59-ab6f-5f41-9845-311c31d1bad3"
  "a705e071-7c95-4839-ae29-cc2f9ebce3f7"
  "a69bbd62-a045-5fab-b587-a5edbd91045e"
  "a64985c1-15ca-44c5-b66d-6c486c3c5c19"
  "a6443d57-91eb-4a7a-b9ab-b986fa483375"
  "a4240dba-08f0-5092-8023-73ca2ee25e98"
  "a1c6bb8b-27fb-4b5d-b2d7-347ab7e9839b"
  "a18c1f61-1254-555b-9c0a-6ed90412e687"
  "9e898906-48b8-5570-b4f2-a5e90cd00223"
  "9dd6abb9-aff5-4ebe-a124-699026311b68"
]
0.52 ms
(8.04%)
1
SELECT DISTINCT u0_.id AS id_0, u0_.id AS id_1, u0_.created_at AS created_at_2 FROM `user` u0_ ORDER BY u0_.id DESC, u0_.created_at DESC LIMIT 20 OFFSET 80
Parameters:
[]
0.26 ms
(3.97%)
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.