Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

99 Database Queries

99 Different statements

1771.86 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
31.19 ms (1.76%)	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';
29.45 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='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';
24.57 ms (1.39%)	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';
24.18 ms (1.36%)	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.32 ms (1.26%)	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';
22.22 ms (1.25%)	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';
21.13 ms (1.19%)	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.74 ms (1.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='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.44 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='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.00 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='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.62 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='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';
19.16 ms (1.08%)	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';
18.91 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='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';
18.82 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='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';
18.77 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='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';
18.71 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='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';
18.68 ms (1.05%)	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.66 ms (1.05%)	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';
18.53 ms (1.05%)	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.46 ms (1.04%)	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';
18.39 ms (1.04%)	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';
18.37 ms (1.04%)	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';
18.37 ms (1.04%)	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';
18.32 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='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';
18.19 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='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.16 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='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';
18.15 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='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';
18.14 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='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';
18.13 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='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';
18.05 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='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';
18.02 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='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';
18.02 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='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.01 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='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';
18.01 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='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.94 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='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';
17.88 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='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';
17.87 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='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.76 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='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.76 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='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';
17.74 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='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.73 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='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';
17.73 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='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';
17.72 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='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.71 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='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';
17.71 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='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.67 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='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';
17.65 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='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.64 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='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.62 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='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';
17.62 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='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';
17.61 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='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.59 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='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';
17.56 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='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.54 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='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';
17.54 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='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.54 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='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.54 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='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.52 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='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.52 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='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';
17.51 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='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.50 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='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.50 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='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';
17.48 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='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.47 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';
17.47 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='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.47 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='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';
17.46 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='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.43 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='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';
17.39 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='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';
17.36 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='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.35 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='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';
17.35 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='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.35 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='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.34 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='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.33 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='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';
17.33 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='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.32 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='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.30 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='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';
17.26 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='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';
17.26 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='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';
17.23 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='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';
17.22 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='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.21 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='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.10 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='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.01 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='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';
16.99 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='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';
16.95 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='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';
16.88 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='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.87 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='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';
16.83 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='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';
16.79 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='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';
16.76 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='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';
16.75 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='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';
16.74 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='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';
16.61 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='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.57 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='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';
10.98 ms (0.62%)	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.31 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/index.php/fiche-action/recherche-geographique-mot-cle

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping