Query Metrics
5
Database Queries
3
Different statements
1.86 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.90 ms (48.40%) |
2 |
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"
]
|
0.67 ms (35.90%) |
2 |
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-06" "2025-06-06" ] |
0.29 ms (15.71%) |
1 |
SELECT UPPER(CountryId) FROM countries
Parameters:
[] |
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. |