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

Grouped Statements

Show all queries

Time Count Info
16.16 ms
(57.81%)
5
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM type_vehicule t0 WHERE t0.id = ?
Parameters:
[
  1
]
2.45 ms
(8.77%)
5
SELECT t0_.id AS id_0, t0_.nom AS nom_1 FROM type_vehicule t0_ WHERE t0_.id IN (?)
Parameters:
[
  "1"
]
2.06 ms
(7.35%)
1
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
]
1.40 ms
(5.00%)
2
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
]
1.21 ms
(4.35%)
1
"COMMIT"
Parameters:
[]
1.08 ms
(3.86%)
1
UPDATE client_adresse SET adresse = ? WHERE id = ?
Parameters:
[
  "Ain chock"
  508
]
0.85 ms
(3.03%)
1
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"
]
0.83 ms
(2.98%)
1
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
]
0.67 ms
(2.39%)
1
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"
]
0.57 ms
(2.03%)
1
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"
]
0.49 ms
(1.75%)
1
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
]
0.19 ms
(0.67%)
1
"START TRANSACTION"
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.