GET https://mantrainternational.eu/Registre?licenses=11&modules=fv%2Crp%2Ctr

Query Metrics

5 Database Queries
3 Different statements
2.14 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.54 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.50 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.44 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.30 ms
SELECT UPPER(CountryId) FROM countries
Parameters:
[]
5 0.36 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.