1 | SHOW FULL COLUMNS FROM `petite_annonces` | | 12 | 12 | 1 |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin'; | | 1 | 1 | 1 |
3 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_swedish_ci'; | | 1 | 1 | 1 |
4 | SHOW FULL COLUMNS FROM `phpbb_users` | | 68 | 68 | 2 |
5 | SHOW FULL COLUMNS FROM `phpbb_profile_fields_data` | | 24 | 24 | 1 |
6 | SHOW FULL COLUMNS FROM `clubs_ffck` | | 15 | 15 | 1 |
7 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 1 |
8 | SHOW FULL COLUMNS FROM `niveau_alertes` | | 5 | 5 | 1 |
9 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 1 |
10 | SHOW FULL COLUMNS FROM `topos` | | 10 | 10 | 1 |
11 | SHOW FULL COLUMNS FROM `topo_types` | | 2 | 2 | 1 |
12 | SHOW FULL COLUMNS FROM `topo_bassins` | | 2 | 2 | 1 |
13 | SHOW FULL COLUMNS FROM `topo_bassin_details` | | 21 | 21 | 1 |
14 | SHOW FULL COLUMNS FROM `topo_parcours` | | 4 | 4 | 1 |
15 | SHOW FULL COLUMNS FROM `topo_parcours_details` | | 25 | 25 | 1 |
16 | SHOW FULL COLUMNS FROM `topo_rivieres` | | 2 | 2 | 1 |
17 | SHOW FULL COLUMNS FROM `topo_riviere_details` | | 35 | 35 | 2 |
18 | SHOW FULL COLUMNS FROM `topo_spots` | | 2 | 2 | 1 |
19 | SHOW FULL COLUMNS FROM `topo_spot_details` | | 20 | 20 | 1 |
20 | SHOW FULL COLUMNS FROM `topo_details` | | 8 | 8 | 1 |
21 | SHOW FULL COLUMNS FROM `topo_rubriques` | | 11 | 11 | 1 |
22 | SHOW FULL COLUMNS FROM `niveau_references_de_niveaux` | | 11 | 11 | 1 |
23 | SHOW FULL COLUMNS FROM `niveau_stations_de_mesures` | | 10 | 10 | 1 |
24 | SHOW FULL COLUMNS FROM `niveau_source_donnees` | | 7 | 7 | 1 |
25 | SHOW FULL COLUMNS FROM `niveau_donnees_temps_reels` | | 12 | 12 | 1 |
26 | SHOW FULL COLUMNS FROM `topos_facility` | | 58 | 58 | 2 |
27 | SHOW FULL COLUMNS FROM `coordonnee_administrative_topos` | | 3 | 3 | 1 |
28 | SHOW FULL COLUMNS FROM `coordonnees_administratives` | | 9 | 9 | 1 |
29 | SHOW FULL COLUMNS FROM `coordonnee_administrative_types` | | 2 | 2 | 1 |
30 | SHOW FULL COLUMNS FROM `coordonnees_administratives_facility` | | 18 | 18 | 1 |
31 | SHOW FULL COLUMNS FROM `carto_coordonnees` | | 13 | 13 | 1 |
32 | SHOW FULL COLUMNS FROM `carto_types` | | 2 | 2 | 1 |
33 | SHOW FULL COLUMNS FROM `attachments_links` | | 6 | 6 | 1 |
34 | SHOW FULL COLUMNS FROM `attachments` | | 19 | 19 | 1 |
35 | SHOW FULL COLUMNS FROM `niveau_references_de_niveau_types` | | 2 | 2 | 1 |
36 | SHOW FULL COLUMNS FROM `niveaux` | | 12 | 12 | 1 |
37 | SHOW FULL COLUMNS FROM `niveau_evaluations` | | 3 | 3 | 1 |
38 | SHOW FULL COLUMNS FROM `petite_annonce_types` | | 5 | 5 | 1 |
39 | SHOW FULL COLUMNS FROM `petite_annonce_categories` | | 2 | 2 | 1 |
40 | SHOW FULL COLUMNS FROM `petite_annonce_matos_types` | | 3 | 3 | 1 |
41 | SHOW FULL COLUMNS FROM `petite_annonce_commentaires` | | 6 | 6 | 1 |
42 | SHOW FULL COLUMNS FROM `petite_annonce_disciplines` | | 3 | 3 | 1 |
43 | SHOW FULL COLUMNS FROM `petite_annonces_petite_annonce_disciplines` | | 3 | 3 | 1 |
44 | SELECT `PetiteAnnonce`.`id`, `PetiteAnnonce`.`user_id`, `PetiteAnnonce`.`ip`, `PetiteAnnonce`.`petite_annonce_type_id`, `PetiteAnnonce`.`petite_annonce_matos_type_id`, `PetiteAnnonce`.`contact`, `PetiteAnnonce`.`titre`, `PetiteAnnonce`.`commentaire`, `PetiteAnnonce`.`prix`, `PetiteAnnonce`.`slug`, `PetiteAnnonce`.`created`, `PetiteAnnonce`.`modified`, `Membre`.`user_id`, `Membre`.`username`, `Membre`.`user_email`, `Membre`.`user_avatar`, `Membre`.`username_clean`, `PetiteAnnonceType`.`nom`, `PetiteAnnonceType`.`slug`, `PetiteAnnonceMatosType`.`nom`, `PetiteAnnonceMatosType`.`slug` FROM `petite_annonces` AS `PetiteAnnonce` LEFT JOIN `phpbb_users` AS `Membre` ON (`PetiteAnnonce`.`user_id` = `Membre`.`user_id`) LEFT JOIN `petite_annonce_types` AS `PetiteAnnonceType` ON (`PetiteAnnonce`.`petite_annonce_type_id` = `PetiteAnnonceType`.`id`) LEFT JOIN `petite_annonce_matos_types` AS `PetiteAnnonceMatosType` ON (`PetiteAnnonce`.`petite_annonce_matos_type_id` = `PetiteAnnonceMatosType`.`id`) WHERE `PetiteAnnonce`.`slug` = '16311' LIMIT 1 | | 0 | 0 | 3 |
45 | SELECT `PetiteAnnonce`.`id`, `PetiteAnnonce`.`user_id`, `PetiteAnnonce`.`ip`, `PetiteAnnonce`.`petite_annonce_type_id`, `PetiteAnnonce`.`petite_annonce_matos_type_id`, `PetiteAnnonce`.`contact`, `PetiteAnnonce`.`titre`, `PetiteAnnonce`.`commentaire`, `PetiteAnnonce`.`prix`, `PetiteAnnonce`.`slug`, `PetiteAnnonce`.`created`, `PetiteAnnonce`.`modified`, `Membre`.`user_id`, `Membre`.`username`, `Membre`.`user_email`, `Membre`.`user_avatar`, `Membre`.`username_clean`, `PetiteAnnonceType`.`nom`, `PetiteAnnonceType`.`slug`, `PetiteAnnonceMatosType`.`nom`, `PetiteAnnonceMatosType`.`slug` FROM `petite_annonces` AS `PetiteAnnonce` LEFT JOIN `phpbb_users` AS `Membre` ON (`PetiteAnnonce`.`user_id` = `Membre`.`user_id`) LEFT JOIN `petite_annonce_types` AS `PetiteAnnonceType` ON (`PetiteAnnonce`.`petite_annonce_type_id` = `PetiteAnnonceType`.`id`) LEFT JOIN `petite_annonce_matos_types` AS `PetiteAnnonceMatosType` ON (`PetiteAnnonce`.`petite_annonce_matos_type_id` = `PetiteAnnonceMatosType`.`id`) WHERE `PetiteAnnonce`.`id` = 16311 LIMIT 1 | | 1 | 1 | 1 |
46 | SELECT `Membre`.`user_id`, `Membre`.`username`, `Membre`.`user_email`, `Membre`.`user_avatar`, `Membre`.`username_clean` FROM `phpbb_users` AS `Membre` WHERE `Membre`.`user_id` = 17377 | | 1 | 1 | 0 |
47 | SELECT `PetiteAnnonceType`.`nom`, `PetiteAnnonceType`.`slug` FROM `petite_annonce_types` AS `PetiteAnnonceType` WHERE `PetiteAnnonceType`.`id` = 1 | | 1 | 1 | 0 |
48 | SELECT `PetiteAnnonceMatosType`.`nom`, `PetiteAnnonceMatosType`.`slug` FROM `petite_annonce_matos_types` AS `PetiteAnnonceMatosType` WHERE `PetiteAnnonceMatosType`.`id` = 1 | | 1 | 1 | 0 |
49 | SELECT `Image`.`id`, `Image`.`class`, `Image`.`foreign_id`, `Image`.`filename`, `Image`.`slug`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`height`, `Image`.`width`, `Image`.`thumb`, `Image`.`description`, `Image`.`proprietaire`, `Image`.`proprietaire_url`, `Image`.`proprietaire_email`, `Image`.`user_id`, `Image`.`peut_illustrer`, `Image`.`created`, `Image`.`modified` FROM `attachments` AS `Image` WHERE `Image`.`class` = 'PetiteAnnonce' AND `Image`.`foreign_id` = (16311) | | 1 | 1 | 10 |
50 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 16311 LIMIT 1 | | 1 | 1 | 0 |
51 | SELECT `PetiteAnnonceCommentaire`.`id`, `PetiteAnnonceCommentaire`.`petite_annonce_id`, `PetiteAnnonceCommentaire`.`auteur_id`, `PetiteAnnonceCommentaire`.`commentaire`, `PetiteAnnonceCommentaire`.`created`, `PetiteAnnonceCommentaire`.`modified` FROM `petite_annonce_commentaires` AS `PetiteAnnonceCommentaire` WHERE `PetiteAnnonceCommentaire`.`petite_annonce_id` = (16311) | | 0 | 0 | 0 |
52 | SELECT `PetiteAnnonceDiscipline`.`id`, `PetiteAnnonceDiscipline`.`nom`, `PetiteAnnonceDiscipline`.`slug`, `PetiteAnnoncesPetiteAnnonceDiscipline`.`id`, `PetiteAnnoncesPetiteAnnonceDiscipline`.`petite_annonce_id`, `PetiteAnnoncesPetiteAnnonceDiscipline`.`petite_annonce_discipline_id` FROM `petite_annonce_disciplines` AS `PetiteAnnonceDiscipline` JOIN `petite_annonces_petite_annonce_disciplines` AS `PetiteAnnoncesPetiteAnnonceDiscipline` ON (`PetiteAnnoncesPetiteAnnonceDiscipline`.`petite_annonce_id` = 16311 AND `PetiteAnnoncesPetiteAnnonceDiscipline`.`petite_annonce_discipline_id` = `PetiteAnnonceDiscipline`.`id`) | | 0 | 0 | 1 |
53 | SELECT `PetiteAnnonceType`.`id`, `PetiteAnnonceType`.`nom` FROM `petite_annonce_types` AS `PetiteAnnonceType` WHERE 1 = 1 | | 6 | 6 | 0 |
54 | SELECT `PetiteAnnonceMatosType`.`id`, `PetiteAnnonceMatosType`.`nom` FROM `petite_annonce_matos_types` AS `PetiteAnnonceMatosType` WHERE 1 = 1 | | 8 | 8 | 0 |
55 | SELECT `PetiteAnnonceDiscipline`.`id`, `PetiteAnnonceDiscipline`.`nom` FROM `petite_annonce_disciplines` AS `PetiteAnnonceDiscipline` WHERE 1 = 1 | | 9 | 9 | 0 |