Query Metrics
98
Database Queries
98
Different statements
358.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
7.08 ms (1.98%) |
1 |
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:
[] |
|
5.95 ms (1.66%) |
1 |
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:
[] |
|
5.85 ms (1.63%) |
1 |
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:
[] |
|
5.70 ms (1.59%) |
1 |
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.59 ms (1.56%) |
1 |
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:
[] |
|
5.57 ms (1.56%) |
1 |
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:
[] |
|
5.23 ms (1.46%) |
1 |
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:
[] |
|
5.18 ms (1.45%) |
1 |
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:
[] |
|
5.05 ms (1.41%) |
1 |
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:
[] |
|
4.86 ms (1.36%) |
1 |
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:
[] |
|
4.56 ms (1.27%) |
1 |
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:
[] |
|
4.47 ms (1.25%) |
1 |
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:
[] |
|
4.17 ms (1.16%) |
1 |
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:
[] |
|
4.13 ms (1.15%) |
1 |
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:
[] |
|
4.10 ms (1.15%) |
1 |
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:
[] |
|
4.07 ms (1.14%) |
1 |
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:
[] |
|
4.02 ms (1.12%) |
1 |
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:
[] |
|
3.99 ms (1.11%) |
1 |
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:
[] |
|
3.96 ms (1.11%) |
1 |
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:
[] |
|
3.93 ms (1.10%) |
1 |
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:
[] |
|
3.86 ms (1.08%) |
1 |
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:
[] |
|
3.84 ms (1.07%) |
1 |
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:
[] |
|
3.81 ms (1.07%) |
1 |
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:
[] |
|
3.80 ms (1.06%) |
1 |
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:
[] |
|
3.76 ms (1.05%) |
1 |
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:
[] |
|
3.73 ms (1.04%) |
1 |
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:
[] |
|
3.72 ms (1.04%) |
1 |
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:
[] |
|
3.69 ms (1.03%) |
1 |
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:
[] |
|
3.67 ms (1.03%) |
1 |
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:
[] |
|
3.67 ms (1.02%) |
1 |
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:
[] |
|
3.63 ms (1.01%) |
1 |
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:
[] |
|
3.62 ms (1.01%) |
1 |
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:
[] |
|
3.60 ms (1.01%) |
1 |
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:
[] |
|
3.58 ms (1.00%) |
1 |
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:
[] |
|
3.56 ms (1.00%) |
1 |
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:
[] |
|
3.56 ms (0.99%) |
1 |
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:
[] |
|
3.55 ms (0.99%) |
1 |
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:
[] |
|
3.53 ms (0.99%) |
1 |
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:
[] |
|
3.53 ms (0.99%) |
1 |
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:
[] |
|
3.53 ms (0.99%) |
1 |
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:
[] |
|
3.53 ms (0.99%) |
1 |
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:
[] |
|
3.52 ms (0.98%) |
1 |
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:
[] |
|
3.52 ms (0.98%) |
1 |
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:
[] |
|
3.51 ms (0.98%) |
1 |
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:
[] |
|
3.51 ms (0.98%) |
1 |
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:
[] |
|
3.50 ms (0.98%) |
1 |
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:
[] |
|
3.49 ms (0.98%) |
1 |
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:
[] |
|
3.48 ms (0.97%) |
1 |
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:
[] |
|
3.48 ms (0.97%) |
1 |
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:
[] |
|
3.44 ms (0.96%) |
1 |
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:
[] |
|
3.44 ms (0.96%) |
1 |
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:
[] |
|
3.43 ms (0.96%) |
1 |
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:
[] |
|
3.43 ms (0.96%) |
1 |
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:
[] |
|
3.42 ms (0.95%) |
1 |
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:
[] |
|
3.41 ms (0.95%) |
1 |
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:
[] |
|
3.41 ms (0.95%) |
1 |
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:
[] |
|
3.40 ms (0.95%) |
1 |
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:
[] |
|
3.39 ms (0.95%) |
1 |
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:
[] |
|
3.38 ms (0.94%) |
1 |
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:
[] |
|
3.38 ms (0.94%) |
1 |
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:
[] |
|
3.38 ms (0.94%) |
1 |
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:
[] |
|
3.37 ms (0.94%) |
1 |
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:
[] |
|
3.36 ms (0.94%) |
1 |
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:
[] |
|
3.35 ms (0.94%) |
1 |
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:
[] |
|
3.35 ms (0.94%) |
1 |
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:
[] |
|
3.35 ms (0.94%) |
1 |
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:
[] |
|
3.34 ms (0.93%) |
1 |
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:
[] |
|
3.34 ms (0.93%) |
1 |
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:
[] |
|
3.33 ms (0.93%) |
1 |
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:
[] |
|
3.33 ms (0.93%) |
1 |
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:
[] |
|
3.32 ms (0.93%) |
1 |
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:
[] |
|
3.32 ms (0.93%) |
1 |
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:
[] |
|
3.31 ms (0.92%) |
1 |
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:
[] |
|
3.31 ms (0.92%) |
1 |
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:
[] |
|
3.29 ms (0.92%) |
1 |
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:
[] |
|
3.29 ms (0.92%) |
1 |
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:
[] |
|
3.27 ms (0.91%) |
1 |
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:
[] |
|
3.25 ms (0.91%) |
1 |
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:
[] |
|
3.24 ms (0.91%) |
1 |
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:
[] |
|
3.22 ms (0.90%) |
1 |
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:
[] |
|
3.22 ms (0.90%) |
1 |
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:
[] |
|
3.21 ms (0.90%) |
1 |
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:
[] |
|
3.20 ms (0.89%) |
1 |
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:
[] |
|
3.19 ms (0.89%) |
1 |
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:
[] |
|
3.17 ms (0.89%) |
1 |
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:
[] |
|
3.17 ms (0.89%) |
1 |
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:
[] |
|
3.17 ms (0.89%) |
1 |
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:
[] |
|
3.15 ms (0.88%) |
1 |
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:
[] |
|
3.14 ms (0.88%) |
1 |
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:
[] |
|
3.13 ms (0.87%) |
1 |
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:
[] |
|
3.13 ms (0.87%) |
1 |
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:
[] |
|
3.11 ms (0.87%) |
1 |
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:
[] |
|
3.10 ms (0.87%) |
1 |
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:
[] |
|
3.08 ms (0.86%) |
1 |
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:
[] |
|
3.07 ms (0.86%) |
1 |
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:
[] |
|
3.04 ms (0.85%) |
1 |
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:
[] |
|
1.41 ms (0.39%) |
1 |
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:
[] |
|
0.24 ms (0.07%) |
1 |
SELECT * FROM imap_departements
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.