Query Metrics
99
Database Queries
99
Different statements
1741.89 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 10.19 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.25 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.33 ms |
SELECT * FROM imap_departements
Parameters:
[] |
| 4 | 18.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='01'
Parameters:
[] |
| 5 | 17.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='02'
Parameters:
[] |
| 6 | 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='03'
Parameters:
[] |
| 7 | 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='04'
Parameters:
[] |
| 8 | 17.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='05'
Parameters:
[] |
| 9 | 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='06'
Parameters:
[] |
| 10 | 19.11 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 | 16.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='08'
Parameters:
[] |
| 12 | 16.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='09'
Parameters:
[] |
| 13 | 16.07 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 | 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='11'
Parameters:
[] |
| 15 | 16.85 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 | 17.97 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 | 19.07 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.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='15'
Parameters:
[] |
| 19 | 16.98 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 | 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='17'
Parameters:
[] |
| 21 | 16.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='18'
Parameters:
[] |
| 22 | 16.92 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 | 16.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='2A'
Parameters:
[] |
| 24 | 16.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='2B'
Parameters:
[] |
| 25 | 17.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='21'
Parameters:
[] |
| 26 | 16.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='22'
Parameters:
[] |
| 27 | 16.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='23'
Parameters:
[] |
| 28 | 16.38 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 | 22.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='25'
Parameters:
[] |
| 30 | 16.81 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.09 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 | 17.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='28'
Parameters:
[] |
| 33 | 17.04 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.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='30'
Parameters:
[] |
| 35 | 21.03 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.12 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 | 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='33'
Parameters:
[] |
| 38 | 17.78 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.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='35'
Parameters:
[] |
| 40 | 16.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='36'
Parameters:
[] |
| 41 | 16.86 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.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='38'
Parameters:
[] |
| 43 | 19.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='39'
Parameters:
[] |
| 44 | 22.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='40'
Parameters:
[] |
| 45 | 17.27 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 | 18.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='42'
Parameters:
[] |
| 47 | 18.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='43'
Parameters:
[] |
| 48 | 19.38 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 | 20.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='45'
Parameters:
[] |
| 50 | 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='46'
Parameters:
[] |
| 51 | 18.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='47'
Parameters:
[] |
| 52 | 20.28 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.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='49'
Parameters:
[] |
| 54 | 19.03 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 | 21.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='51'
Parameters:
[] |
| 56 | 24.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='52'
Parameters:
[] |
| 57 | 21.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='53'
Parameters:
[] |
| 58 | 22.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='54'
Parameters:
[] |
| 59 | 17.29 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 | 16.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='56'
Parameters:
[] |
| 61 | 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='57'
Parameters:
[] |
| 62 | 17.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='58'
Parameters:
[] |
| 63 | 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='59'
Parameters:
[] |
| 64 | 17.96 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 | 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='61'
Parameters:
[] |
| 66 | 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='62'
Parameters:
[] |
| 67 | 16.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='63'
Parameters:
[] |
| 68 | 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='64'
Parameters:
[] |
| 69 | 17.90 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 | 16.92 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 | 17.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='67'
Parameters:
[] |
| 72 | 21.90 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.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='69'
Parameters:
[] |
| 74 | 16.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='70'
Parameters:
[] |
| 75 | 17.09 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.92 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.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='73'
Parameters:
[] |
| 78 | 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='74'
Parameters:
[] |
| 79 | 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='75'
Parameters:
[] |
| 80 | 18.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='76'
Parameters:
[] |
| 81 | 17.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='77'
Parameters:
[] |
| 82 | 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='78'
Parameters:
[] |
| 83 | 17.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='79'
Parameters:
[] |
| 84 | 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='80'
Parameters:
[] |
| 85 | 17.12 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.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='82'
Parameters:
[] |
| 87 | 19.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='83'
Parameters:
[] |
| 88 | 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='84'
Parameters:
[] |
| 89 | 17.80 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 | 18.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='86'
Parameters:
[] |
| 91 | 18.17 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.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='88'
Parameters:
[] |
| 93 | 17.89 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 | 17.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='90'
Parameters:
[] |
| 95 | 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='91'
Parameters:
[] |
| 96 | 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='92'
Parameters:
[] |
| 97 | 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='93'
Parameters:
[] |
| 98 | 19.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='94'
Parameters:
[] |
| 99 | 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='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. |