GET http://api.dev.newretail.avp.tech/users

Query Metrics

154 Database Queries
9 Different statements
279.44 ms Query time
0 Invalid entities
326 Managed entities

Grouped Statements

Show all queries

Time Count Info
62.48 ms
(22.36%)
30
SELECT t0.iso3 AS iso3_1, t0.iso2 AS iso2_2, t0.name AS name_3, t0.capital AS capital_4, t0.currency AS currency_5, t0.phone AS phone_6, t0.sanctioned AS sanctioned_7 FROM country t0 INNER JOIN user_country ON t0.iso3 = user_country.country_iso3 WHERE user_country.user_id = ?
Parameters:
[
  1
]
53.42 ms
(19.12%)
30
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.country_aware AS country_aware_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.brand_id AS brand_id_7 FROM channel t0 INNER JOIN user_channel ON t0.id = user_channel.channel_id WHERE user_channel.user_id = ?
Parameters:
[
  1
]
50.87 ms
(18.20%)
30
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.title AS title_3, t0.brand_id AS brand_id_4, t0.owner_id AS owner_id_5 FROM dealership_group t0 INNER JOIN dealership_group_user ON t0.id = dealership_group_user.dealership_group_id WHERE dealership_group_user.user_id = ?
Parameters:
[
  1
]
50.52 ms
(18.08%)
30
SELECT t0.code AS code_1, t0.name AS name_2, t0.splash_screen AS splash_screen_3 FROM brand t0 INNER JOIN user_brand ON t0.code = user_brand.brand_code WHERE user_brand.user_id = ?
Parameters:
[
  1
]
50.21 ms
(17.97%)
30
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.description AS description_4, t0.editable AS editable_5, t0.last_update AS last_update_6 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = ?
Parameters:
[
  1
]
3.77 ms
(1.35%)
1
SELECT u0_.id AS id_0, u0_.sub AS sub_1, u0_.email AS email_2, u0_.given_name AS given_name_3, u0_.family_name AS family_name_4, u0_.enabled AS enabled_5, u0_.permissions AS permissions_6, u0_.show_tutorial AS show_tutorial_7, u0_.last_login AS last_login_8, u0_.cognito_information_id AS cognito_information_id_9 FROM users u0_ ORDER BY u0_.id ASC LIMIT 30
Parameters:
[]
2.87 ms
(1.03%)
1
SELECT t0.id AS id_1, t0.subject AS subject_2, t0.username AS username_3, t0.email AS email_4, t0.email_verified AS email_verified_5, t0.cognito_groups AS cognito_groups_6, t0.cognito_brands AS cognito_brands_7, t0.cognito_markets AS cognito_markets_8, t0.cognito_old_subs AS cognito_old_subs_9 FROM cognito_information t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  3
  4
  5
  6
  7
  8
  9
  10
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  23
  24
  25
  26
  27
  28
  29
  30
  31
]
2.68 ms
(0.96%)
1
SELECT t0.id AS id_1, t0.flag_key AS flag_key_2, t0.enabled AS enabled_3 FROM feature_flag t0 WHERE t0.flag_key = ? LIMIT 1
Parameters:
[
  "auth_logs_enabled"
]
2.63 ms
(0.94%)
1
SELECT count(*) AS sclr_0 FROM users 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\Country 249
App\Entity\User 30
App\Entity\CognitoInformation 30
App\Entity\Role 5
App\Entity\Channel 4
App\Entity\Brand 4
App\Entity\DealershipGroup 4

Entities Mapping