GET https://demolivio.garnockcode.ovh/

Query Metrics

8 Database Queries
8 Different statements
5.40 ms Query time
0 Invalid entities
6 Managed entities

Queries

Group similar statements

# Time Info
1 0.42 ms
SELECT t0.id AS id_1, t0.model AS model_2, t0.version AS version_3, t0.vin AS vin_4, t0.license_plate AS license_plate_5, t0.color AS color_6, t0.km AS km_7, t0.registration AS registration_8, t0.deleted AS deleted_9, t0.buy_price AS buy_price_10, t0.sell_price_b2b AS sell_price_b2b_11, t0.sell_price_b2c AS sell_price_b2c_12, t0.brand_id AS brand_id_13, t0.status_id AS status_id_14, t0.fuel_id AS fuel_id_15 FROM car t0
Parameters:
[]
2 0.95 ms
SELECT c0_.id AS id_0, c0_.model AS model_1, c0_.version AS version_2, c0_.vin AS vin_3, c0_.license_plate AS license_plate_4, c0_.color AS color_5, c0_.km AS km_6, c0_.registration AS registration_7, c0_.deleted AS deleted_8, c0_.buy_price AS buy_price_9, c0_.sell_price_b2b AS sell_price_b2b_10, c0_.sell_price_b2c AS sell_price_b2c_11, c0_.brand_id AS brand_id_12, c0_.status_id AS status_id_13, c0_.fuel_id AS fuel_id_14 FROM car c0_ WHERE c0_.deleted = ? ORDER BY c0_.id DESC
Parameters:
[
  0
]
3 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.company_name AS company_name_4, t0.fiscal_code AS fiscal_code_5, t0.vat AS vat_6, t0.city AS city_7, t0.zip AS zip_8, t0.address AS address_9, t0.province AS province_10, t0.type_id AS type_id_11, t0.nationality_id AS nationality_id_12 FROM customer t0
Parameters:
[]
4 0.61 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.number AS number_3, t0.customer_id AS customer_id_4, t0.vat_rate_id AS vat_rate_id_5, t0.status_id AS status_id_6 FROM contract t0
Parameters:
[]
5 0.71 ms
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.expire_on AS expire_on_2, p0_.customer_id AS customer_id_3 FROM preventive p0_ WHERE p0_.expire_on >= ? ORDER BY p0_.date DESC
Parameters:
[
  "2026-01-11 15:19:27"
]
6 0.66 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.number AS number_3, t0.customer_id AS customer_id_4, t0.vat_rate_id AS vat_rate_id_5, t0.status_id AS status_id_6 FROM contract t0 ORDER BY t0.date DESC LIMIT 5
Parameters:
[]
7 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.company_name AS company_name_4, t0.fiscal_code AS fiscal_code_5, t0.vat AS vat_6, t0.city AS city_7, t0.zip AS zip_8, t0.address AS address_9, t0.province AS province_10, t0.type_id AS type_id_11, t0.nationality_id AS nationality_id_12 FROM customer t0 ORDER BY t0.id DESC LIMIT 5
Parameters:
[]
8 0.66 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM customer_type t0 WHERE t0.id = ?
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Car 1
App\Entity\Brand 1
App\Entity\CarStatus 1
App\Entity\Fuel 1
App\Entity\Customer 1
App\Entity\CustomerType 1

Entities Mapping

Class Mapping errors
App\Entity\Car No errors.
App\Entity\Brand No errors.
App\Entity\CarStatus No errors.
App\Entity\Fuel No errors.
App\Entity\CarPhoto No errors.
App\Entity\ContractCar No errors.
App\Entity\PreventiveCar No errors.
App\Entity\CustomerNegotiation No errors.
App\Entity\Customer No errors.
App\Entity\CustomerType No errors.
App\Entity\Nation No errors.
App\Entity\Contract No errors.
App\Entity\Preventive No errors.
App\Entity\VatRates No errors.
App\Entity\ContractStatus No errors.