Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

99 Database Queries

99 Different statements

1741.89 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
24.83 ms (1.43%)	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';
22.54 ms (1.29%)	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';
22.36 ms (1.28%)	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.01 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='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';
21.90 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='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';
21.14 ms (1.21%)	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';
21.03 ms (1.21%)	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';
21.01 ms (1.21%)	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';
20.48 ms (1.18%)	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';
20.39 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.28 ms (1.16%)	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';
19.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='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';
19.38 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.30 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='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';
19.26 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='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';
19.11 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='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';
19.07 ms (1.09%)	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';
19.03 ms (1.09%)	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';
18.87 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='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';
18.76 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='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';
18.45 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='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.34 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='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.32 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='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.32 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='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.22 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='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';
18.17 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='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';
18.12 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='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.05 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='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';
18.05 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='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.02 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='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';
18.02 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='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.00 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='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.99 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='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.97 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='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';
17.96 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='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.95 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='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.92 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='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.91 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='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.90 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='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';
17.89 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='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.83 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='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.80 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='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.78 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='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.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='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.62 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='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.61 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='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.57 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='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.54 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='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.46 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.46 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='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.45 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='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.43 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='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.37 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='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.37 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';
17.36 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='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 (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='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.32 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='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';
17.30 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='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';
17.29 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='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';
17.27 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='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';
17.21 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';
17.21 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='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.19 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.16 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='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.13 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='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';
17.12 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='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.10 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='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.09 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.09 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='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.05 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='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.04 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='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.02 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='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.02 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='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.99 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';
16.98 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='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';
16.92 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';
16.92 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='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';
16.86 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='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';
16.85 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';
16.82 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='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.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='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.75 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='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';
16.74 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='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.73 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='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';
16.72 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='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';
16.72 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='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';
16.65 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='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.59 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='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';
16.50 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='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.47 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='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';
16.44 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='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.44 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='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.38 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='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.21 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='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.13 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='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';
16.07 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='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.19 ms (0.58%)	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.25 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.33 ms (0.02%)	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