https://mmwec-api.dev.knectar.com/api/members

Query Metrics

4 Database Queries
4 Different statements
17.55 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

custom connection

Time Count Info
2.88 ms
(16.39%)
1
SELECT t0.id AS id_1, t0.token AS token_2, t0.user_id AS user_id_3 FROM api_token t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
  "917ee1c4e21a9a1455e6ebb4bee14cb67cb41dbb7e0518c57f1b2bbc99ad8f4a"
]
0.40 ms
(2.26%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?
Parameters:
[
  1
]

default connection

Time Count Info
7.17 ms
(40.87%)
1
SELECT m0_.id AS id_0, m0_.iso AS iso_1, m0_.jde AS jde_2, m0_.name AS name_3, m0_.code AS code_4 FROM members m0_ ORDER BY m0_.id ASC LIMIT 250
Parameters:
[]
7.11 ms
(40.49%)
1
SELECT count(DISTINCT m0_.id) AS sclr_0 FROM members m0_
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
custom doctrine.dbal.custom_connection

Entity Managers

Name Service
auto_generate_proxy_classes doctrine.orm.auto_generate_proxy_classes_entity_manager
auto_mapping doctrine.orm.auto_mapping_entity_manager
default doctrine.orm.default_entity_manager
custom doctrine.orm.custom_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

auto_generate_proxy_classes entity manager

No loaded entities.

auto_mapping entity manager

No loaded entities.

default entity manager

Class Mapping errors
App\Entity\Main\Members No errors.

custom entity manager

Class Mapping errors
App\Entity\Custom\ApiToken No errors.
App\Entity\Custom\User No errors.