https://senacs.symfyp.fr/action/geographical-and-tag-search

Query Metrics

98 Database Queries
98 Different statements
337.50 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.56 ms
SELECT at.action_tag_id, t.nom, count(at.action_tag_id) as count
                                    FROM actions_tag at
                                    LEFT JOIN ActionTag t ON at.action_tag_id = t.id
                                    GROUP BY at.action_tag_id
                                    ORDER BY t.nom ASC
Parameters:
[]
2 0.18 ms
SELECT * FROM imap_departements
Parameters:
[]
3 3.44 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='01'
Parameters:
[]
4 3.34 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='02'
Parameters:
[]
5 3.25 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='03'
Parameters:
[]
6 3.17 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='04'
Parameters:
[]
7 3.23 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='05'
Parameters:
[]
8 3.20 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='06'
Parameters:
[]
9 3.12 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='07'
Parameters:
[]
10 3.17 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='08'
Parameters:
[]
11 3.23 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='09'
Parameters:
[]
12 3.16 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='10'
Parameters:
[]
13 3.16 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='11'
Parameters:
[]
14 3.30 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='12'
Parameters:
[]
15 3.74 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='13'
Parameters:
[]
16 3.27 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='14'
Parameters:
[]
17 3.32 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='15'
Parameters:
[]
18 3.29 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='16'
Parameters:
[]
19 3.71 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='17'
Parameters:
[]
20 4.12 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='18'
Parameters:
[]
21 3.21 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='19'
Parameters:
[]
22 3.07 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='2A'
Parameters:
[]
23 3.02 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='2B'
Parameters:
[]
24 2.89 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='21'
Parameters:
[]
25 3.24 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='22'
Parameters:
[]
26 2.97 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='23'
Parameters:
[]
27 3.15 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='24'
Parameters:
[]
28 2.86 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='25'
Parameters:
[]
29 2.91 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='26'
Parameters:
[]
30 3.92 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='27'
Parameters:
[]
31 4.94 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='28'
Parameters:
[]
32 5.82 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='29'
Parameters:
[]
33 4.93 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='30'
Parameters:
[]
34 4.42 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='31'
Parameters:
[]
35 3.04 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='32'
Parameters:
[]
36 3.72 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='33'
Parameters:
[]
37 2.89 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='34'
Parameters:
[]
38 3.06 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='35'
Parameters:
[]
39 2.95 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='36'
Parameters:
[]
40 3.23 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='37'
Parameters:
[]
41 3.14 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='38'
Parameters:
[]
42 2.88 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='39'
Parameters:
[]
43 2.83 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='40'
Parameters:
[]
44 2.85 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='41'
Parameters:
[]
45 5.63 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='42'
Parameters:
[]
46 5.11 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='43'
Parameters:
[]
47 5.09 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='44'
Parameters:
[]
48 4.36 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='45'
Parameters:
[]
49 3.06 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='46'
Parameters:
[]
50 3.03 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='47'
Parameters:
[]
51 2.91 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='48'
Parameters:
[]
52 3.23 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='49'
Parameters:
[]
53 3.10 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='50'
Parameters:
[]
54 2.91 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='51'
Parameters:
[]
55 2.90 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='52'
Parameters:
[]
56 3.01 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='53'
Parameters:
[]
57 3.79 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='54'
Parameters:
[]
58 2.96 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='55'
Parameters:
[]
59 3.23 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='56'
Parameters:
[]
60 3.27 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='57'
Parameters:
[]
61 3.03 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='58'
Parameters:
[]
62 4.16 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='59'
Parameters:
[]
63 2.90 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='60'
Parameters:
[]
64 3.11 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='61'
Parameters:
[]
65 3.64 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='62'
Parameters:
[]
66 3.27 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='63'
Parameters:
[]
67 3.17 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='64'
Parameters:
[]
68 3.05 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='65'
Parameters:
[]
69 3.05 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='66'
Parameters:
[]
70 3.00 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='67'
Parameters:
[]
71 3.13 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='68'
Parameters:
[]
72 3.23 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='69'
Parameters:
[]
73 2.85 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='70'
Parameters:
[]
74 2.99 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='71'
Parameters:
[]
75 3.16 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='72'
Parameters:
[]
76 3.08 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='73'
Parameters:
[]
77 3.34 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='74'
Parameters:
[]
78 5.56 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='75'
Parameters:
[]
79 4.29 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='76'
Parameters:
[]
80 3.35 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='77'
Parameters:
[]
81 3.41 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='78'
Parameters:
[]
82 3.16 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='79'
Parameters:
[]
83 3.15 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='80'
Parameters:
[]
84 3.54 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='81'
Parameters:
[]
85 3.45 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='82'
Parameters:
[]
86 3.31 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='83'
Parameters:
[]
87 3.41 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='84'
Parameters:
[]
88 3.53 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='85'
Parameters:
[]
89 3.74 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='86'
Parameters:
[]
90 3.43 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='87'
Parameters:
[]
91 3.37 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='88'
Parameters:
[]
92 5.74 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='89'
Parameters:
[]
93 5.37 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='90'
Parameters:
[]
94 3.85 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='91'
Parameters:
[]
95 3.35 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='92'
Parameters:
[]
96 3.99 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='93'
Parameters:
[]
97 4.18 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='94'
Parameters:
[]
98 4.67 ms
SELECT * FROM Action a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='95'
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

No loaded entities.