## Format de la requête (possible que les parenthèses ne soient pas au bon endroit) :

select T1.ID_ACTUALITE, T1.CODE, T1.LANGUE from ACTUALITE T1 
LEFT JOIN RUBRIQUEPUBLICATION RUB_PUB ON T1.CODE = RUB_PUB.CODE_FICHE_ORIG AND T1.LANGUE = RUB_PUB.LANGUE_FICHE_ORIG AND RUB_PUB.TYPE_FICHE_ORIG = '0008' 
LEFT JOIN METATAG META ON T1.ID_ACTUALITE = META.META_ID_FICHE 
WHERE T1.ETAT_OBJET = '0003' AND  ( RUB_PUB.ID_RUBRIQUEPUBLICATION IS NULL OR RUB_PUB.TYPE_FICHE_ORIG = '0008' )  
AND  ( T1.CODE_RUBRIQUE IN  ( 'XXX' ) OR RUB_PUB.RUBRIQUE_DEST IN  ( 'XXX' )  )  
AND  ( DATE_FORMAT(META.META_DATE_MISE_EN_LIGNE, '%Y-%m-%d %H:%i:%s') < '2014-02-26 10:54:03' AND META.META_CODE_OBJET = '0008' ) 
AND  (  ( T1.DIFFUSION_MODE_RESTRICTION = '0' OR  ( T1.DIFFUSION_MODE_RESTRICTION = '2' 
AND  ( T1.DIFFUSION_PUBLIC_VISE LIKE '%[/cn=ETP,ou=groups,dc=univ-tlse2,dc=fr]%' OR T1.DIFFUSION_PUBLIC_VISE LIKE '%[/cn=ETP,ou=groups,dc=fr]%' ... ))  )  
OR  ( T1.DIFFUSION_MODE_RESTRICTION = '3' 
AND  ( T1.DIFFUSION_PUBLIC_VISE_RESTRICTION LIKE '%[/cn=ETP,ou=groups,dc=fr]%' ...  )  )  )
OR T1.DIFFUSION_PUBLIC_VISE_RESTRICTION LIKE '%[/etudiants]%' )  )  )  
AND  ( T1.DIFFUSION_PUBLIC_VISE LIKE '%[/cn=ETP,ou=groups,dc=fr]%' 
OR T1.DIFFUSION_PUBLIC_VISE LIKE '%[/cn=ETP,ou=groups,dc=fr]%' 
OR T1.DIFFUSION_PUBLIC_VISE LIKE '%[/etudiants]%' ))
ORDER BY META.META_DATE_MISE_EN_LIGNE  DESC

## Temps passé sur requête complete avec clauses en doublons :
+--------------------------------+----------+
| Status                         | Duration |
+--------------------------------+----------+
| starting                       | 0.000025 |
| checking query cache for query | 0.001136 |
| checking permissions           | 0.000005 |
| checking permissions           | 0.000003 |
| checking permissions           | 0.000004 |
| Opening tables                 | 0.000019 |
| System lock                    | 0.000005 |
| Table lock                     | 0.000566 |
| init                           | 0.001002 |
| optimizing                     | 0.000153 |
| statistics                     | 0.000518 |
| preparing                      | 0.000208 |
| Creating tmp table             | 0.000040 |
| executing                      | 0.000005 |
| Copying to tmp table           | 0.156260 |
| Sorting result                 | 0.000031 |
| Sending data                   | 0.000106 |
| end                            | 0.000004 |
| removing tmp table             | 0.000014 |
| end                            | 0.000004 |
| end                            | 0.000003 |
| query end                      | 0.000005 |
| storing result in query cache  | 0.000039 |
| freeing items                  | 0.000076 |
| closing tables                 | 0.000009 |
| logging slow query             | 0.000003 |
| cleaning up                    | 0.000012 |
+--------------------------------+----------+

## Temps passé avec requête light sans clauses en doublon :
+--------------------------------+----------+
| Status                         | Duration |
+--------------------------------+----------+
| starting                       | 0.000029 |
| checking query cache for query | 0.000416 |
| checking permissions           | 0.000004 |
| checking permissions           | 0.000004 |
| checking permissions           | 0.000004 |
| Opening tables                 | 0.000018 |
| System lock                    | 0.000006 |
| Table lock                     | 0.000175 |
| init                           | 0.000301 |
| optimizing                     | 0.000057 |
| statistics                     | 0.000327 |
| preparing                      | 0.000085 |
| Creating tmp table             | 0.000036 |
| executing                      | 0.000004 |
| Copying to tmp table           | 0.090239 |
| Sorting result                 | 0.000034 |
| Sending data                   | 0.000111 |
| end                            | 0.000003 |
| removing tmp table             | 0.000011 |
| end                            | 0.000004 |
| end                            | 0.000003 |
| query end                      | 0.000004 |
| storing result in query cache  | 0.000003 |
| freeing items                  | 0.000036 |
| closing tables                 | 0.000007 |
| logging slow query             | 0.000003 |
| cleaning up                    | 0.000007 |