Query Metrics
6
Database Queries
6
Different statements
4.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.35 ms (29.19%) |
1 |
SELECT l0_.id AS id_0, l0_.client AS client_1, l0_.numero AS numero_2, l0_.adresse AS adresse_3, l0_.type AS type_4, l0_.nbr AS nbr_5, l0_.encour AS encour_6, l0_.nbrposi AS nbrposi_7, l0_.vilcode AS vilcode_8, l0_.ville AS ville_9, l0_.lon AS lon_10, l0_.lat AS lat_11, l0_.fact AS fact_12, l0_.rucher AS rucher_13, l0_.comment AS comment_14 FROM lieu l0_
Parameters:
[] |
|
0.90 ms (19.43%) |
1 |
SELECT i0_.id AS id_0, i0_.lieu AS lieu_1, i0_.inter AS inter_2, i0_.posi AS posi_3, i0_.reste AS reste_4, i0_.grign AS grign_5, i0_.remit AS remit_6, i0_.conso AS conso_7, i0_.chan AS chan_8, i0_.produit AS produit_9, i0_.observation AS observation_10, i0_.iduser AS iduser_11, i0_.clientfait AS clientfait_12, i0_.prodavan AS prodavan_13, i0_.piege AS piege_14, i0_.piegeancien AS piegeancien_15, i0_.fact AS fact_16, i0_.frelon AS frelon_17, i0_.renouvel AS renouvel_18 FROM interfait i0_ WHERE i0_.inter = '1'
Parameters:
[] |
|
0.68 ms (14.67%) |
1 |
SELECT i0_.id AS id_0, i0_.lieu AS lieu_1, i0_.inter AS inter_2, i0_.posi AS posi_3, i0_.reste AS reste_4, i0_.grign AS grign_5, i0_.remit AS remit_6, i0_.conso AS conso_7, i0_.chan AS chan_8, i0_.produit AS produit_9, i0_.observation AS observation_10, i0_.iduser AS iduser_11, i0_.clientfait AS clientfait_12, i0_.prodavan AS prodavan_13, i0_.piege AS piege_14, i0_.piegeancien AS piegeancien_15, i0_.fact AS fact_16, i0_.frelon AS frelon_17, i0_.renouvel AS renouvel_18 FROM interfait i0_ WHERE i0_.inter = '2'
Parameters:
[] |
|
0.62 ms (13.42%) |
1 |
SELECT i0_.id AS id_0, i0_.lieu AS lieu_1, i0_.inter AS inter_2, i0_.posi AS posi_3, i0_.reste AS reste_4, i0_.grign AS grign_5, i0_.remit AS remit_6, i0_.conso AS conso_7, i0_.chan AS chan_8, i0_.produit AS produit_9, i0_.observation AS observation_10, i0_.iduser AS iduser_11, i0_.clientfait AS clientfait_12, i0_.prodavan AS prodavan_13, i0_.piege AS piege_14, i0_.piegeancien AS piegeancien_15, i0_.fact AS fact_16, i0_.frelon AS frelon_17, i0_.renouvel AS renouvel_18 FROM interfait i0_ WHERE i0_.inter = '3'
Parameters:
[] |
|
0.59 ms (12.75%) |
1 |
SELECT i0_.id AS id_0, i0_.client AS client_1, i0_.contrat AS contrat_2, i0_.archive AS archive_3, i0_.encour AS encour_4, i0_.user AS user_5, i0_.clientfait AS clientfait_6, i0_.date AS date_7, i0_.type AS type_8, i0_.fact AS fact_9 FROM intervention i0_
Parameters:
[] |
|
0.49 ms (10.54%) |
1 |
SELECT i0_.id AS id_0, i0_.lieu AS lieu_1, i0_.inter AS inter_2, i0_.posi AS posi_3, i0_.reste AS reste_4, i0_.grign AS grign_5, i0_.remit AS remit_6, i0_.conso AS conso_7, i0_.chan AS chan_8, i0_.produit AS produit_9, i0_.observation AS observation_10, i0_.iduser AS iduser_11, i0_.clientfait AS clientfait_12, i0_.prodavan AS prodavan_13, i0_.piege AS piege_14, i0_.piegeancien AS piegeancien_15, i0_.fact AS fact_16, i0_.frelon AS frelon_17, i0_.renouvel AS renouvel_18 FROM interfait i0_ WHERE i0_.inter = '4'
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\Lieu | No errors. |
| App\Entity\Intervention | No errors. |
| App\Entity\Interfait | No errors. |