https://mmwec-api.dev.knectar.com/api/dabids?date%5Bafter%5D=2025-09-23&date%5Bbefore%5D=2025-09-23&member.id=14

Query Metrics

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

Queries

Group similar statements

custom connection

# Time Info
1 0.49 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.21 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 37.86 ms
SELECT d0_.id AS id_0, d0_.date AS date_1, d0_.hour AS hour_2, d0_.mwh AS mwh_3, d0_.price AS price_4, d0_.lmp AS lmp_5, d0_.member_id AS member_id_6 FROM dabids d0_ INNER JOIN members m1_ ON d0_.member_id = m1_.id WHERE d0_.id IN (SELECT d2_.id FROM dabids d2_ INNER JOIN members m3_ ON d2_.member_id = m3_.id WHERE d2_.date <= ? AND d2_.date >= ? AND m3_.id = ?) ORDER BY d0_.id ASC LIMIT 50
Parameters:
[
  "2025-09-23"
  "2025-09-23"
  "14"
]
2 37.08 ms
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM dabids d0_ INNER JOIN members m1_ ON d0_.member_id = m1_.id WHERE d0_.id IN (SELECT d2_.id FROM dabids d2_ INNER JOIN members m3_ ON d2_.member_id = m3_.id WHERE d2_.date <= ? AND d2_.date >= ? AND m3_.id = ?)
Parameters:
[
  "2025-09-23"
  "2025-09-23"
  "14"
]

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\Dabids No 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.