Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

105 Database Queries

7 Different statements

41.03 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT t0.id AS id_1, t0.date AS date_2, t0.heure_ouverture AS heure_ouverture_3, t0.heure_fermeture AS heure_fermeture_4, t0.lieux_id AS lieux_id_5, t0.avocats_id AS avocats_id_6 FROM jours_fermetures t0 WHERE t0.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.date AS date_2, t0.ouvert AS ouvert_3, t0.occupe AS occupe_4, t0.jours_fermetures_id AS jours_fermetures_id_5 FROM tranches t0 WHERE t0.jours_fermetures_id = ?
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM tranches WHERE id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM jours_fermetures WHERE id = ?
"COMMIT"
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.avocats_id AS avocats_id_5 FROM users t0 WHERE t0.id = ?

#▲	Time	Info
1	1.04 ms	SELECT t0.id AS id_1, t0.date AS date_2, t0.heure_ouverture AS heure_ouverture_3, t0.heure_fermeture AS heure_fermeture_4, t0.lieux_id AS lieux_id_5, t0.avocats_id AS avocats_id_6 FROM jours_fermetures t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"1013"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.date AS date_2, t0.heure_ouverture AS heure_ouverture_3, t0.heure_fermeture AS heure_fermeture_4, t0.lieux_id AS lieux_id_5, t0.avocats_id AS avocats_id_6 FROM jours_fermetures t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.date AS date_2, t0.heure_ouverture AS heure_ouverture_3, t0.heure_fermeture AS heure_fermeture_4, t0.lieux_id AS lieux_id_5, t0.avocats_id AS avocats_id_6 FROM jours_fermetures t0 WHERE t0.id = '1013' LIMIT 1;
2	0.85 ms	SELECT t0.id AS id_1, t0.date AS date_2, t0.ouvert AS ouvert_3, t0.occupe AS occupe_4, t0.jours_fermetures_id AS jours_fermetures_id_5 FROM tranches t0 WHERE t0.jours_fermetures_id = ? Parameters: [`1013`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.date AS date_2, t0.ouvert AS ouvert_3, t0.occupe AS occupe_4, t0.jours_fermetures_id AS jours_fermetures_id_5 FROM tranches t0 WHERE t0.jours_fermetures_id = ? SELECT t0.id AS id_1, t0.date AS date_2, t0.ouvert AS ouvert_3, t0.occupe AS occupe_4, t0.jours_fermetures_id AS jours_fermetures_id_5 FROM tranches t0 WHERE t0.jours_fermetures_id = 1013;
3	0.29 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
4	0.49 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32342`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32342;
5	0.50 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
6	0.27 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
7	0.43 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32343`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32343;
8	0.52 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
9	0.27 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
10	0.41 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32344`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32344;
11	0.42 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
12	0.25 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
13	0.46 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32345`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32345;
14	0.41 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
15	0.25 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
16	0.47 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32346`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32346;
17	0.42 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
18	0.24 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
19	0.37 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32347`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32347;
20	0.46 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
21	0.25 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
22	0.37 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32348`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32348;
23	0.40 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
24	0.25 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
25	0.54 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32349`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32349;
26	0.35 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
27	0.24 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
28	0.34 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32350`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32350;
29	1.96 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
30	0.45 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
31	0.43 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32351`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32351;
32	0.69 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
33	0.26 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
34	0.39 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32352`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32352;
35	0.45 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
36	0.23 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
37	0.31 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32353`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32353;
38	0.56 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
39	0.22 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
40	0.34 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32354`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32354;
41	0.32 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
42	0.25 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
43	0.30 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32355`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32355;
44	0.83 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
45	0.21 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
46	0.29 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32356`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32356;
47	0.34 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
48	0.23 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
49	0.28 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32357`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32357;
50	0.27 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
51	0.19 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
52	0.28 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32358`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32358;
53	0.40 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
54	0.24 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
55	0.42 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32359`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32359;
56	0.37 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
57	0.22 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
58	0.34 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32360`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32360;
59	0.98 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
60	0.24 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
61	0.33 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32361`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32361;
62	0.51 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
63	0.19 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
64	0.25 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32362`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32362;
65	0.31 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
66	0.20 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
67	0.25 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32363`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32363;
68	0.29 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
69	0.20 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
70	0.24 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32364`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32364;
71	0.27 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
72	0.25 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
73	0.30 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32365`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32365;
74	0.30 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
75	0.20 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
76	0.28 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32366`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32366;
77	0.32 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
78	0.23 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
79	0.32 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32367`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32367;
80	0.28 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
81	0.20 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
82	0.27 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32368`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32368;
83	0.28 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
84	0.21 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
85	0.27 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32369`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32369;
86	0.31 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
87	0.24 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
88	0.30 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32370`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32370;
89	1.81 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
90	0.27 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
91	0.36 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32371`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32371;
92	0.50 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
93	0.24 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
94	0.40 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32372`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32372;
95	0.42 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
96	0.26 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
97	0.39 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32373`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32373;
98	0.40 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
99	0.26 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
100	0.38 ms	DELETE FROM tranches WHERE id = ? Parameters: [`32374`] View formatted query View runnable query Explain query DELETE FROM tranches WHERE id = ? DELETE FROM tranches WHERE id = 32374;
101	0.46 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
102	0.25 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
103	1.07 ms	DELETE FROM jours_fermetures WHERE id = ? Parameters: [`1013`] View formatted query View runnable query Explain query DELETE FROM jours_fermetures WHERE id = ? DELETE FROM jours_fermetures WHERE id = 1013;
104	0.42 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
105	0.68 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.avocats_id AS avocats_id_5 FROM users t0 WHERE t0.id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.avocats_id AS avocats_id_5 FROM users t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.avocats_id AS avocats_id_5 FROM users t0 WHERE t0.id = 3;

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\JoursFermetures	No errors.
App\Entity\Tranches	No errors.
App\Entity\Lieux	No errors.
App\Entity\Avocats	No errors.
App\Entity\Users	No errors.

Symfony Profiler

https://llvd-avocats.be/deleteJours/1013?p=deleteJours%2F1013

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping