Query Metrics
4
Database Queries
4
Different statements
59.28 ms
Query time
0
Invalid entities
Queries
custom connection
#▲ | Time | Info |
---|---|---|
1 | 0.40 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 | 1.16 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 | 28.91 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" "1" ] |
2 | 28.81 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" "1" ] |
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. |