Query Metrics
5
Database Queries
3
Different statements
3.08 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.99 ms |
SELECT UPPER(v0_.country) AS sclr_0, v0_.value AS value_1 FROM vat v0_ WHERE ? >= v0_.valid_from AND (v0_.valid_until IS NULL OR ? <= v0_.valid_until)
Parameters:
[ "2025-06-07" "2025-06-07" ] |
2 | 0.76 ms |
SELECT p0_.id AS id_0, p0_.min_nr_of_licenses AS min_nr_of_licenses_1, p0_.value AS value_2, p0_.valid_from AS valid_from_3, p0_.valid_until AS valid_until_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.currency AS currency_7 FROM price p0_ WHERE p0_.currency = ? AND CURRENT_DATE >= p0_.valid_from AND (p0_.valid_until IS NULL OR CURRENT_DATE <= p0_.valid_until) ORDER BY p0_.min_nr_of_licenses ASC
Parameters:
[
"CHF"
]
|
3 | 0.43 ms |
SELECT p0_.id AS id_0, p0_.min_nr_of_licenses AS min_nr_of_licenses_1, p0_.value AS value_2, p0_.valid_from AS valid_from_3, p0_.valid_until AS valid_until_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.currency AS currency_7 FROM price p0_ WHERE p0_.currency = ? AND CURRENT_DATE >= p0_.valid_from AND (p0_.valid_until IS NULL OR CURRENT_DATE <= p0_.valid_until) ORDER BY p0_.min_nr_of_licenses ASC
Parameters:
[
"USD"
]
|
4 | 0.53 ms |
SELECT UPPER(CountryId) FROM countries
Parameters:
[] |
5 | 0.38 ms |
SELECT UPPER(v0_.country) AS sclr_0, v0_.value AS value_1 FROM vat v0_ WHERE ? >= v0_.valid_from AND (v0_.valid_until IS NULL OR ? <= v0_.valid_until)
Parameters:
[ "2025-06-07" "2025-06-07" ] |
Database Connections
Name | Service |
---|---|
main | doctrine.dbal.main_connection |
Entity Managers
Name | Service |
---|---|
main | doctrine.orm.main_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Main\Vat | No errors. |
App\Entity\Main\Price | No errors. |
App\Entity\Main\Currency | No errors. |