Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

4.18 ms Query time

0 Invalid entities

Queries


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_
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_
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.41 ms	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: [] View formatted query View runnable query Explain query 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_ 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_;
2	0.52 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_ 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_ 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_;
3	0.83 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.51 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.36 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.56 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\Lieu	No errors.
App\Entity\Intervention	No errors.
App\Entity\Interfait	No errors.

Symfony Profiler

GET https://frelon.carte-des-cueilleur-essaim.fr/public/piege/relever/4

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping