rendered paste body+----+-------------+-----------------------------+--------+----------------------------------------------------------+---------------+---------+---------------------------------------------------------------------------------+------+----------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-----------------------------+--------+----------------------------------------------------------+---------------+---------+---------------------------------------------------------------------------------+------+----------------------------------------------+
| 1 | SIMPLE | grilles_services | ref | cle,ref_grille,ref_service | ref_service | 3 | const | 2 | Using index; Using temporary; Using filesort |
| 1 | SIMPLE | grilles | eq_ref | PRIMARY,ref_grille_bo,ref_monnaie | PRIMARY | 3 | trouvea.grilles_services.ref_grille | 1 | |
| 1 | SIMPLE | structures_agences_zones | ALL | ref_agence,ref_pays,ref_region,ref_sous_region,ref_ville | NULL | NULL | NULL | 7 | Using where |
| 1 | SIMPLE | grilles_agences | eq_ref | cle,ref_grille,ref_agence | cle | 6 | trouvea.grilles_services.ref_grille,trouvea.structures_agences_zones.ref_agence | 1 | Using index |
| 1 | SIMPLE | structures_agences_data | eq_ref | PRIMARY,ref_structure | PRIMARY | 3 | trouvea.structures_agences_zones.ref_agence | 1 | Using where |
| 1 | SIMPLE | structures_agences_services | eq_ref | cle,ref_agence,ref_service | cle | 6 | trouvea.grilles_agences.ref_agence,const | 1 | Using where |
| 1 | SIMPLE | structures | eq_ref | PRIMARY | PRIMARY | 3 | trouvea.structures_agences_data.ref_structure | 1 | |
| 1 | SIMPLE | grilles_produits | ref | cle,ref_grille | cle | 3 | trouvea.grilles_agences.ref_grille | 1 | Using index |
| 1 | SIMPLE | grilles_criteres | ref | cle,ref_grille | cle | 3 | trouvea.grilles_services.ref_grille | 1 | Using index |
| 1 | SIMPLE | grilles_modes_paiement | ref | cle,ref_grille | ref_grille | 3 | trouvea.grilles_agences.ref_grille | 5 | Using index |
| 1 | SIMPLE | structures | eq_ref | PRIMARY,ref_type_structure | PRIMARY | 3 | trouvea.structures.id | 1 | Using where |
| 1 | SIMPLE | structures_data | ref | ref_structure | ref_structure | 3 | trouvea.structures.id | 4 | |
| 1 | SIMPLE | d1 | eq_ref | PRIMARY | PRIMARY | 3 | trouvea.structures_data.ref_data | 1 | |
| 1 | SIMPLE | utilisateurs_avis | ref | ref_agence | ref_agence | 3 | trouvea.structures_agences_zones.ref_agence | 1 | |
| 1 | SIMPLE | grilles_bo | eq_ref | PRIMARY | PRIMARY | 1 | trouvea.grilles.ref_grille_bo | 1 | |
| 1 | SIMPLE | monnaies | eq_ref | PRIMARY | PRIMARY | 1 | trouvea.grilles.ref_monnaie | 1 | |
| 1 | SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 3 | trouvea.structures.ref_type_structure | 1 | |
+----+-------------+-----------------------------+--------+----------------------------------------------------------+---------------+---------+---------------------------------------------------------------------------------+------+----------------------------------------------+