https://senacs.symfyp.fr/index.php/fiche-action/recherche-geographique-mot-cle

Query Metrics

99 Database Queries
99 Different statements
1771.86 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 10.98 ms
SELECT k0_.id AS id_0, k0_.name AS name_1, count(k0_.id) AS sclr_2 FROM Keyword k0_ INNER JOIN ficheAction_keyword f2_ ON k0_.id = f2_.keyword_id INNER JOIN FicheAction f1_ ON f1_.id = f2_.fiche_action_id GROUP BY k0_.id ORDER BY k0_.name ASC
Parameters:
[]
2 4.31 ms
SELECT sub.id, sub.name, count(sub.id) as counter FROM (
                SELECT pa.id as id, pa .intitule AS name
                FROM PartnerAction pa
                INNER JOIN ficheAction_actionPartners fa_ap ON pa.id = fa_ap.partner_action_id
                UNION ALL
                SELECT pa.id as id, pa .intitule AS name
                FROM PartnerAction pa
                INNER JOIN ficheAction_financialPartners fa_fp ON pa.id = fa_fp.partner_action_id
                ) as sub
                GROUP BY id
                ORDER BY name
Parameters:
[]
3 0.17 ms
SELECT * FROM imap_departements
Parameters:
[]
4 17.56 ms
SELECT * FROM FicheAction 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:
[]
5 17.51 ms
SELECT * FROM FicheAction 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:
[]
6 17.72 ms
SELECT * FROM FicheAction 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:
[]
7 17.22 ms
SELECT * FROM FicheAction 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:
[]
8 17.33 ms
SELECT * FROM FicheAction 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:
[]
9 17.34 ms
SELECT * FROM FicheAction 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:
[]
10 17.36 ms
SELECT * FROM FicheAction 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:
[]
11 17.71 ms
SELECT * FROM FicheAction 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:
[]
12 17.39 ms
SELECT * FROM FicheAction 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:
[]
13 16.57 ms
SELECT * FROM FicheAction 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:
[]
14 17.54 ms
SELECT * FROM FicheAction 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:
[]
15 17.26 ms
SELECT * FROM FicheAction 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:
[]
16 18.15 ms
SELECT * FROM FicheAction 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:
[]
17 17.10 ms
SELECT * FROM FicheAction 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:
[]
18 16.83 ms
SELECT * FROM FicheAction 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:
[]
19 17.50 ms
SELECT * FROM FicheAction 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:
[]
20 18.71 ms
SELECT * FROM FicheAction 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:
[]
21 17.26 ms
SELECT * FROM FicheAction 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:
[]
22 17.54 ms
SELECT * FROM FicheAction 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:
[]
23 17.74 ms
SELECT * FROM FicheAction 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:
[]
24 17.50 ms
SELECT * FROM FicheAction 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:
[]
25 18.37 ms
SELECT * FROM FicheAction 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:
[]
26 17.62 ms
SELECT * FROM FicheAction 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:
[]
27 17.47 ms
SELECT * FROM FicheAction 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:
[]
28 17.54 ms
SELECT * FROM FicheAction 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:
[]
29 24.18 ms
SELECT * FROM FicheAction 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:
[]
30 18.16 ms
SELECT * FROM FicheAction 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:
[]
31 17.35 ms
SELECT * FROM FicheAction 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:
[]
32 16.61 ms
SELECT * FROM FicheAction 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:
[]
33 17.73 ms
SELECT * FROM FicheAction 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:
[]
34 17.65 ms
SELECT * FROM FicheAction 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:
[]
35 21.13 ms
SELECT * FROM FicheAction 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:
[]
36 18.68 ms
SELECT * FROM FicheAction 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:
[]
37 18.14 ms
SELECT * FROM FicheAction 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:
[]
38 17.76 ms
SELECT * FROM FicheAction 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:
[]
39 17.59 ms
SELECT * FROM FicheAction 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:
[]
40 17.52 ms
SELECT * FROM FicheAction 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:
[]
41 17.35 ms
SELECT * FROM FicheAction 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:
[]
42 18.91 ms
SELECT * FROM FicheAction 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:
[]
43 16.99 ms
SELECT * FROM FicheAction 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:
[]
44 16.75 ms
SELECT * FROM FicheAction 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:
[]
45 16.87 ms
SELECT * FROM FicheAction 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:
[]
46 19.16 ms
SELECT * FROM FicheAction 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:
[]
47 17.23 ms
SELECT * FROM FicheAction 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:
[]
48 19.62 ms
SELECT * FROM FicheAction 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:
[]
49 18.39 ms
SELECT * FROM FicheAction 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:
[]
50 18.77 ms
SELECT * FROM FicheAction 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:
[]
51 17.62 ms
SELECT * FROM FicheAction 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:
[]
52 17.32 ms
SELECT * FROM FicheAction 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:
[]
53 20.74 ms
SELECT * FROM FicheAction 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:
[]
54 17.43 ms
SELECT * FROM FicheAction 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:
[]
55 22.32 ms
SELECT * FROM FicheAction 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:
[]
56 16.76 ms
SELECT * FROM FicheAction 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:
[]
57 18.82 ms
SELECT * FROM FicheAction 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:
[]
58 17.48 ms
SELECT * FROM FicheAction 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:
[]
59 16.79 ms
SELECT * FROM FicheAction 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:
[]
60 17.01 ms
SELECT * FROM FicheAction 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:
[]
61 17.52 ms
SELECT * FROM FicheAction 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:
[]
62 17.30 ms
SELECT * FROM FicheAction 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:
[]
63 17.64 ms
SELECT * FROM FicheAction 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:
[]
64 16.74 ms
SELECT * FROM FicheAction 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:
[]
65 16.95 ms
SELECT * FROM FicheAction 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:
[]
66 18.02 ms
SELECT * FROM FicheAction 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:
[]
67 17.54 ms
SELECT * FROM FicheAction 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:
[]
68 17.47 ms
SELECT * FROM FicheAction 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:
[]
69 18.53 ms
SELECT * FROM FicheAction 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:
[]
70 17.46 ms
SELECT * FROM FicheAction 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:
[]
71 18.19 ms
SELECT * FROM FicheAction 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:
[]
72 20.00 ms
SELECT * FROM FicheAction 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:
[]
73 18.37 ms
SELECT * FROM FicheAction 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:
[]
74 17.94 ms
SELECT * FROM FicheAction 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:
[]
75 17.71 ms
SELECT * FROM FicheAction 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:
[]
76 17.87 ms
SELECT * FROM FicheAction 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:
[]
77 17.61 ms
SELECT * FROM FicheAction 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:
[]
78 18.32 ms
SELECT * FROM FicheAction 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:
[]
79 24.57 ms
SELECT * FROM FicheAction 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:
[]
80 31.19 ms
SELECT * FROM FicheAction 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:
[]
81 29.45 ms
SELECT * FROM FicheAction 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:
[]
82 22.22 ms
SELECT * FROM FicheAction 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:
[]
83 18.01 ms
SELECT * FROM FicheAction 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:
[]
84 18.02 ms
SELECT * FROM FicheAction 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:
[]
85 18.01 ms
SELECT * FROM FicheAction 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:
[]
86 17.35 ms
SELECT * FROM FicheAction 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:
[]
87 18.05 ms
SELECT * FROM FicheAction 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:
[]
88 17.73 ms
SELECT * FROM FicheAction 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:
[]
89 17.76 ms
SELECT * FROM FicheAction 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:
[]
90 17.33 ms
SELECT * FROM FicheAction 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:
[]
91 16.88 ms
SELECT * FROM FicheAction 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:
[]
92 17.21 ms
SELECT * FROM FicheAction 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:
[]
93 18.13 ms
SELECT * FROM FicheAction 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:
[]
94 18.66 ms
SELECT * FROM FicheAction 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:
[]
95 18.46 ms
SELECT * FROM FicheAction 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:
[]
96 17.47 ms
SELECT * FROM FicheAction 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:
[]
97 17.67 ms
SELECT * FROM FicheAction 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:
[]
98 20.44 ms
SELECT * FROM FicheAction 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:
[]
99 17.88 ms
SELECT * FROM FicheAction 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

Class Mapping errors
App\Entity\Keyword No errors.
App\Entity\PartnerAction No errors.