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

Query Metrics

23 Database Queries
4 Different statements
4.31 ms Query time
0 Invalid entities
25 Managed entities

Queries

Group similar statements

# Time Info
1 0.36 ms
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 ASC, u0_.created_at DESC LIMIT 20 OFFSET 40
Parameters:
[]
2 0.31 ms
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_.id ASC, u0_.created_at DESC
Parameters:
[
  "479a2dd9-039e-542e-be9e-0c97e496eab5"
  "4ad09fa7-d59e-545e-a3a4-2addacf66619"
  "4d21495c-6c2d-529b-9f9c-e0227f9286ee"
  "4dd89055-627d-5fce-a730-4faec6c8c24f"
  "50044f83-9a21-5b9e-9d75-aab4ed7d0cb3"
  "5429093b-1531-51af-ad01-73a5b25a259c"
  "59471302-d987-4516-981c-40df4539100b"
  "59a52448-d578-40eb-bf40-d3a1b18db8d5"
  "5ad5cc22-3d5c-511b-a7ab-644f3095da3b"
  "5eeadd1e-00a4-5926-8e0e-398b300fd65f"
  "65c5c65e-67d5-5959-8d1b-2e286d83d024"
  "69aa0dba-8268-557c-8a42-2ac9c8528ecb"
  "6aa3b009-330c-5a95-939f-09343e798303"
  "6b19acaf-8922-5873-837f-31ffba513499"
  "6c8c459b-8607-5588-8950-0875da4cea6e"
  "6d672b20-f982-59f7-8594-914a7cde0fe0"
  "6eba9df8-f791-5143-a608-c5809d6275be"
  "6f2f543b-1ce2-571b-9143-499423387ec2"
  "73881920-956a-5249-b8c7-99f7257c0c55"
  "73d1d021-8543-5816-8e4a-bd2a85e5bdfb"
]
3 0.13 ms
SELECT count(*) AS sclr_0 FROM `user` u0_
Parameters:
[]
4 0.23 ms
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:
[
  "479a2dd9-039e-542e-be9e-0c97e496eab5"
]
5 0.18 ms
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:
[
  "4ad09fa7-d59e-545e-a3a4-2addacf66619"
]
6 0.17 ms
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:
[
  "4d21495c-6c2d-529b-9f9c-e0227f9286ee"
]
7 0.17 ms
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:
[
  "4dd89055-627d-5fce-a730-4faec6c8c24f"
]
8 0.18 ms
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:
[
  "50044f83-9a21-5b9e-9d75-aab4ed7d0cb3"
]
9 0.18 ms
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:
[
  "5429093b-1531-51af-ad01-73a5b25a259c"
]
10 0.18 ms
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:
[
  "59471302-d987-4516-981c-40df4539100b"
]
11 0.17 ms
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:
[
  "59a52448-d578-40eb-bf40-d3a1b18db8d5"
]
12 0.17 ms
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:
[
  "5ad5cc22-3d5c-511b-a7ab-644f3095da3b"
]
13 0.16 ms
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:
[
  "5eeadd1e-00a4-5926-8e0e-398b300fd65f"
]
14 0.17 ms
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:
[
  "65c5c65e-67d5-5959-8d1b-2e286d83d024"
]
15 0.17 ms
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:
[
  "69aa0dba-8268-557c-8a42-2ac9c8528ecb"
]
16 0.16 ms
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:
[
  "6aa3b009-330c-5a95-939f-09343e798303"
]
17 0.19 ms
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:
[
  "6b19acaf-8922-5873-837f-31ffba513499"
]
18 0.16 ms
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:
[
  "6c8c459b-8607-5588-8950-0875da4cea6e"
]
19 0.17 ms
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:
[
  "6d672b20-f982-59f7-8594-914a7cde0fe0"
]
20 0.19 ms
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:
[
  "6eba9df8-f791-5143-a608-c5809d6275be"
]
21 0.17 ms
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:
[
  "6f2f543b-1ce2-571b-9143-499423387ec2"
]
22 0.16 ms
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:
[
  "73881920-956a-5249-b8c7-99f7257c0c55"
]
23 0.17 ms
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:
[
  "73d1d021-8543-5816-8e4a-bd2a85e5bdfb"
]

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 5

Entities Mapping

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