Petites annonces

Page 1 sur 1, affiche 2 enregistrements sur un total de 2, du 1 au 2

<< prec. | suiv. >>
(default) 37 queries took 107 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`76762
5SHOW FULL COLUMNS FROM `phpbb_profile_fields_data`12121
6SHOW FULL COLUMNS FROM `clubs_ffck`15151
7SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
8SHOW FULL COLUMNS FROM `topos`10101
9SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
10SHOW FULL COLUMNS FROM `topo_types`221
11SHOW FULL COLUMNS FROM `topo_bassins`221
12SHOW FULL COLUMNS FROM `topo_bassin_details`21211
13SHOW FULL COLUMNS FROM `topo_parcours`441
14SHOW FULL COLUMNS FROM `topo_parcours_details`25251
15SHOW FULL COLUMNS FROM `topo_rivieres`221
16SHOW FULL COLUMNS FROM `topo_riviere_details`35352
17SHOW FULL COLUMNS FROM `topo_spots`221
18SHOW FULL COLUMNS FROM `topo_spot_details`20201
19SHOW FULL COLUMNS FROM `niveau_references_de_niveaux`11111
20SHOW FULL COLUMNS FROM `niveau_stations_de_mesures`10101
21SHOW FULL COLUMNS FROM `niveau_source_donnees`661
22SHOW FULL COLUMNS FROM `niveau_donnees_temps_reels`12121
23SHOW FULL COLUMNS FROM `niveau_references_de_niveau_types`221
24SHOW FULL COLUMNS FROM `niveaux`12121
25SHOW FULL COLUMNS FROM `niveau_evaluations`331
26SHOW FULL COLUMNS FROM `coordonnee_administrative_topos`331
27SHOW FULL COLUMNS FROM `coordonnees_administratives`991
28SHOW FULL COLUMNS FROM `coordonnee_administrative_types`221
29SHOW FULL COLUMNS FROM `attachments`19191
30SHOW FULL COLUMNS FROM `petite_annonce_types`551
31SHOW FULL COLUMNS FROM `petite_annonce_categories`221
32SELECT 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 `Membre`.`username_clean` = 'funfreestyler' 1132
33SELECT `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 `Membre`.`username_clean` = 'funfreestyler' ORDER BY `PetiteAnnonceType`.`nom` asc LIMIT 152242
34SELECT `PetiteAnnonceCategorie`.`nom`, `PetiteAnnonceCategorie`.`id` FROM `petite_annonce_categories` AS `PetiteAnnonceCategorie` WHERE 1 = 1 330
35SELECT `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
36SELECT `PetiteAnnonceMatosType`.`slug`, `PetiteAnnonceMatosType`.`nom`, `PetiteAnnonceMatosType`.`id` FROM `petite_annonce_matos_types` AS `PetiteAnnonceMatosType` WHERE 1 = 1 880
37SELECT `PetiteAnnonceDiscipline`.`slug`, `PetiteAnnonceDiscipline`.`nom`, `PetiteAnnonceDiscipline`.`id` FROM `petite_annonce_disciplines` AS `PetiteAnnonceDiscipline` WHERE 1 = 1 990