Rechercher dans les petites annonces
(default) 43 queries took 74 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `petite_annonces`12121
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';111
3SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_swedish_ci';111
4SHOW FULL COLUMNS FROM `phpbb_users`76763
5SHOW FULL COLUMNS FROM `phpbb_profile_fields_data`12122
6SHOW FULL COLUMNS FROM `clubs_ffck`15152
7SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
8SHOW FULL COLUMNS FROM `niveau_alertes`552
9SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
10SHOW FULL COLUMNS FROM `topos`10102
11SHOW FULL COLUMNS FROM `topo_types`222
12SHOW FULL COLUMNS FROM `topo_bassins`221
13SHOW FULL COLUMNS FROM `topo_bassin_details`21212
14SHOW FULL COLUMNS FROM `topo_parcours`442
15SHOW FULL COLUMNS FROM `topo_parcours_details`25252
16SHOW FULL COLUMNS FROM `topo_rivieres`222
17SHOW FULL COLUMNS FROM `topo_riviere_details`35352
18SHOW FULL COLUMNS FROM `topo_spots`222
19SHOW FULL COLUMNS FROM `topo_spot_details`20202
20SHOW FULL COLUMNS FROM `niveau_references_de_niveaux`11111
21SHOW FULL COLUMNS FROM `niveau_stations_de_mesures`10102
22SHOW FULL COLUMNS FROM `niveau_source_donnees`662
23SHOW FULL COLUMNS FROM `niveau_donnees_temps_reels`12121
24SHOW FULL COLUMNS FROM `niveau_references_de_niveau_types`222
25SHOW FULL COLUMNS FROM `niveaux`12122
26SHOW FULL COLUMNS FROM `niveau_evaluations`331
27SHOW FULL COLUMNS FROM `coordonnee_administrative_topos`332
28SHOW FULL COLUMNS FROM `coordonnees_administratives`992
29SHOW FULL COLUMNS FROM `coordonnee_administrative_types`221
30SHOW FULL COLUMNS FROM `attachments`19192
31SHOW FULL COLUMNS FROM `attachments_links`661
32SHOW FULL COLUMNS FROM `petite_annonce_types`552
33SHOW FULL COLUMNS FROM `petite_annonce_categories`222
34SHOW FULL COLUMNS FROM `petite_annonce_matos_types`332
35SHOW FULL COLUMNS FROM `petite_annonce_commentaires`662
36SHOW FULL COLUMNS FROM `petite_annonce_disciplines`332
37SHOW FULL COLUMNS FROM `petite_annonces_petite_annonce_disciplines`331
38SELECT COUNT(*) AS `count` 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 `PetiteAnnonceType`.`slug` = 'perdu-vole' 114
39SELECT `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`.`username_clean`, `PetiteAnnonceType`.`id`, `PetiteAnnonceType`.`nom`, `PetiteAnnonceType`.`action`, `PetiteAnnonceType`.`petite_annonce_categorie_id`, `PetiteAnnonceType`.`slug`, `PetiteAnnonceMatosType`.`id`, `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 `PetiteAnnonceType`.`slug` = 'perdu-vole' ORDER BY `PetiteAnnonce`.`created` desc LIMIT 1515157
40SELECT `PetiteAnnonceCategorie`.`nom`, `PetiteAnnonceCategorie`.`id` FROM `petite_annonce_categories` AS `PetiteAnnonceCategorie` WHERE 1 = 1 330
41SELECT `PetiteAnnonceType`.`id`, `PetiteAnnonceType`.`nom`, `PetiteAnnonceType`.`action`, `PetiteAnnonceType`.`petite_annonce_categorie_id`, `PetiteAnnonceType`.`slug` FROM `petite_annonce_types` AS `PetiteAnnonceType` WHERE `PetiteAnnonceType`.`petite_annonce_categorie_id` IN (1, 2, 3) 660
42SELECT `PetiteAnnonceMatosType`.`slug`, `PetiteAnnonceMatosType`.`nom`, `PetiteAnnonceMatosType`.`id` FROM `petite_annonce_matos_types` AS `PetiteAnnonceMatosType` WHERE 1 = 1 880
43SELECT `PetiteAnnonceDiscipline`.`slug`, `PetiteAnnonceDiscipline`.`nom`, `PetiteAnnonceDiscipline`.`id` FROM `petite_annonce_disciplines` AS `PetiteAnnonceDiscipline` WHERE 1 = 1 990