Query Metrics
6
Database Queries
6
Different statements
3.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.39 ms (38.55%) |
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_ LIMIT 10
Parameters:
[] |
|
0.54 ms (14.94%) |
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.52 ms (14.31%) |
1 |
SELECT t0.id AS id_1, t0.ref AS ref_2, t0.client AS client_3, t0.lieu AS lieu_4, t0.type AS type_5, t0.datedebut AS datedebut_6, t0.datefin AS datefin_7, t0.act AS act_8 FROM factu t0 WHERE t0.id = ?
Parameters:
[
0
]
|
|
0.42 ms (11.57%) |
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.37 ms (10.33%) |
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:
[] |
|
0.37 ms (10.29%) |
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:
[] |
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\Intervention | No errors. |
| App\Entity\Factu | No errors. |
| App\Entity\Interfait | No errors. |