Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

99 Database Queries

99 Different statements

1827.90 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
39.75 ms (2.17%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
30.26 ms (1.66%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
29.61 ms (1.62%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
28.16 ms (1.54%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
27.68 ms (1.51%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
25.91 ms (1.42%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
25.88 ms (1.42%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
23.69 ms (1.30%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
22.74 ms (1.24%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
22.72 ms (1.24%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
22.49 ms (1.23%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
22.47 ms (1.23%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
22.34 ms (1.22%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
20.98 ms (1.15%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
20.74 ms (1.13%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
20.48 ms (1.12%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
20.27 ms (1.11%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
20.17 ms (1.10%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
19.61 ms (1.07%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
19.60 ms (1.07%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
19.47 ms (1.07%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
19.35 ms (1.06%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
18.76 ms (1.03%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
18.71 ms (1.02%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
18.55 ms (1.01%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
18.34 ms (1.00%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
18.31 ms (1.00%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
18.10 ms (0.99%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
18.08 ms (0.99%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
18.07 ms (0.99%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
18.07 ms (0.99%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
18.03 ms (0.99%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
18.01 ms (0.99%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.95 ms (0.98%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.89 ms (0.98%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.87 ms (0.98%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.81 ms (0.97%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.80 ms (0.97%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.78 ms (0.97%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.76 ms (0.97%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.72 ms (0.97%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.71 ms (0.97%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.71 ms (0.97%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.70 ms (0.97%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.70 ms (0.97%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.70 ms (0.97%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.62 ms (0.96%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.60 ms (0.96%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.60 ms (0.96%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.59 ms (0.96%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.58 ms (0.96%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.51 ms (0.96%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.49 ms (0.96%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.48 ms (0.96%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.47 ms (0.96%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.45 ms (0.95%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.45 ms (0.95%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.45 ms (0.95%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.42 ms (0.95%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.42 ms (0.95%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.39 ms (0.95%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.35 ms (0.95%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.34 ms (0.95%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.33 ms (0.95%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.32 ms (0.95%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.29 ms (0.95%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.23 ms (0.94%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.23 ms (0.94%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.18 ms (0.94%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.18 ms (0.94%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.15 ms (0.94%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.10 ms (0.94%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.06 ms (0.93%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.05 ms (0.93%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.05 ms (0.93%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.04 ms (0.93%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.03 ms (0.93%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
17.00 ms (0.93%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
16.99 ms (0.93%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
16.98 ms (0.93%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
16.95 ms (0.93%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
16.94 ms (0.93%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
16.94 ms (0.93%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
16.89 ms (0.92%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
16.87 ms (0.92%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
16.84 ms (0.92%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
16.84 ms (0.92%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
16.82 ms (0.92%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
16.76 ms (0.92%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
16.74 ms (0.92%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
16.73 ms (0.92%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
16.65 ms (0.91%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
16.64 ms (0.91%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
16.60 ms (0.91%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
16.53 ms (0.90%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
16.51 ms (0.90%)	1	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: [] View formatted query View runnable query Explain query 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' 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';
10.15 ms (0.56%)	1	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: [] View formatted query View runnable query Explain query 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 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;
4.41 ms (0.24%)	1	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: [] View formatted query View runnable query Explain query 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 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;
0.17 ms (0.01%)	1	SELECT * FROM imap_departements Parameters: [] View formatted query View runnable query Explain query SELECT * FROM imap_departements SELECT * FROM imap_departements;

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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping