https://mmwec-api.dev.knectar.com/api/dabids/select/towns

Query Metrics

3 Database Queries
3 Different statements
10.04 ms Query time
0 Invalid entities

Queries

Group similar statements

custom connection

# Time Info
1 0.36 ms
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"
]
2 0.58 ms
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 Info
1 9.10 ms
SELECT t.* FROM
  (
    SELECT d.member_id
      FROM dabids d
      WHERE d.date = CURDATE()
      GROUP BY d.member_id
  ) b
  LEFT JOIN members t ON t.id = b.member_id
  ORDER BY t.name ASC
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

No loaded entities.

custom entity manager

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