Petites annonces

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

<< prec. | suiv. >>
(default) 10 queries took 97 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `phpbb_users`76762
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';111
3SHOW FULL COLUMNS FROM `topos`10101
4SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
5SELECT 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' 1134
6SELECT `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 `PetiteAnnonce`.`titre` asc LIMIT 152258
7SELECT `PetiteAnnonceCategorie`.`nom`, `PetiteAnnonceCategorie`.`id` FROM `petite_annonce_categories` AS `PetiteAnnonceCategorie` WHERE 1 = 1 330
8SELECT `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
9SELECT `PetiteAnnonceMatosType`.`slug`, `PetiteAnnonceMatosType`.`nom`, `PetiteAnnonceMatosType`.`id` FROM `petite_annonce_matos_types` AS `PetiteAnnonceMatosType` WHERE 1 = 1 880
10SELECT `PetiteAnnonceDiscipline`.`slug`, `PetiteAnnonceDiscipline`.`nom`, `PetiteAnnonceDiscipline`.`id` FROM `petite_annonce_disciplines` AS `PetiteAnnonceDiscipline` WHERE 1 = 1 990