POST https://olex.no-ip.net/client/adresse/508/edit

Query Metrics

21 Database Queries
12 Different statements
27.95 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 2.06 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:
[
  2
]
2 0.85 ms
SELECT t0.id AS id_1, t0.adresse AS adresse_2, t0.clientparty_id AS clientparty_id_3, t0.region_calcul_id AS region_calcul_id_4 FROM client_adresse t0 WHERE t0.id = ?
Parameters:
[
  "508"
]
3 0.83 ms
SELECT t0.id AS id_1, t0.code_client_party AS code_client_party_2, t0.name AS name_3 FROM client_party t0 WHERE t0.id = ?
Parameters:
[
  237
]
4 0.49 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.zone AS zone_3, t0.tarif AS tarif_4 FROM region_calcul t0 WHERE t0.id = ?
Parameters:
[
  1
]
5 0.89 ms
SELECT t0.id AS id_1, t0.tarif AS tarif_2, t0.client_adresse_id AS client_adresse_id_3, t0.type_vehicule_id AS type_vehicule_id_4 FROM client_adresse_vehicule_tarif t0 WHERE t0.client_adresse_id = ?
Parameters:
[
  508
]
6 11.20 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM type_vehicule t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 3.80 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM type_vehicule t0 WHERE t0.id = ?
Parameters:
[
  2
]
8 0.40 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM type_vehicule t0 WHERE t0.id = ?
Parameters:
[
  3
]
9 0.38 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM type_vehicule t0 WHERE t0.id = ?
Parameters:
[
  4
]
10 0.37 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM type_vehicule t0 WHERE t0.id = ?
Parameters:
[
  5
]
11 0.57 ms
SELECT c0_.id AS id_0, c0_.code_client_party AS code_client_party_1, c0_.name AS name_2 FROM client_party c0_ WHERE c0_.id IN (?)
Parameters:
[
  "237"
]
12 0.67 ms
SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.zone AS zone_2, r0_.tarif AS tarif_3 FROM region_calcul r0_ WHERE r0_.id IN (?)
Parameters:
[
  "1"
]
13 0.66 ms
SELECT t0_.id AS id_0, t0_.nom AS nom_1 FROM type_vehicule t0_ WHERE t0_.id IN (?)
Parameters:
[
  "1"
]
14 0.56 ms
SELECT t0_.id AS id_0, t0_.nom AS nom_1 FROM type_vehicule t0_ WHERE t0_.id IN (?)
Parameters:
[
  "2"
]
15 0.51 ms
SELECT t0_.id AS id_0, t0_.nom AS nom_1 FROM type_vehicule t0_ WHERE t0_.id IN (?)
Parameters:
[
  "3"
]
16 0.37 ms
SELECT t0_.id AS id_0, t0_.nom AS nom_1 FROM type_vehicule t0_ WHERE t0_.id IN (?)
Parameters:
[
  "4"
]
17 0.37 ms
SELECT t0_.id AS id_0, t0_.nom AS nom_1 FROM type_vehicule t0_ WHERE t0_.id IN (?)
Parameters:
[
  "5"
]
18 0.51 ms
SELECT t0.id AS id_1, t0.tarif AS tarif_2, t0.client_adresse_id AS client_adresse_id_3, t0.type_vehicule_id AS type_vehicule_id_4 FROM client_adresse_vehicule_tarif t0 WHERE t0.client_adresse_id = ?
Parameters:
[
  508
]
19 0.19 ms
"START TRANSACTION"
Parameters:
[]
20 1.08 ms
UPDATE client_adresse SET adresse = ? WHERE id = ?
Parameters:
[
  "Ain chock"
  508
]
21 1.21 ms
"COMMIT"
Parameters:
[]

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.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\ClientAdresse No errors.
App\Entity\ClientParty No errors.
App\Entity\RegionCalcul
  • The field 'App\Entity\RegionCalcul#tarif' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\ClientAdresseVehiculeTarif No errors.
App\Entity\TypeVehicule No errors.
App\Entity\Bonlivraison No errors.