Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

3.56 ms Query time

0 Invalid entities

Queries


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
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 = ?
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'
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'
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'
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'

#▲	Time	Info
1	1.20 ms	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: [] View formatted query View runnable query Explain query 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 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;
2	0.57 ms	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`] View formatted query View runnable query Explain query 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 = ? 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 = 0;
3	0.66 ms	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: [] View formatted query View runnable query Explain query 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' 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';
4	0.42 ms	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: [] View formatted query View runnable query Explain query 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' 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';
5	0.37 ms	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: [] View formatted query View runnable query Explain query 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' 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';
6	0.35 ms	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: [] View formatted query View runnable query Explain query 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' 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';

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.

Symfony Profiler

GET https://frelon.carte-des-cueilleur-essaim.fr/public/graph/facpro/non/0/4

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping