Petites annonces

Page 1 sur 3, affiche 15 enregistrements sur un total de 40, du 1 au 15

<< prec. | 1 | 2 | 3
(default) 6 queries took 50 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT 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 `PetiteAnnonceMatosType`.`slug` = 'jupe' 1124
2SELECT `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 `PetiteAnnonceMatosType`.`slug` = 'jupe' ORDER BY `PetiteAnnonce`.`created` desc LIMIT 15151526
3SELECT `PetiteAnnonceCategorie`.`nom`, `PetiteAnnonceCategorie`.`id` FROM `petite_annonce_categories` AS `PetiteAnnonceCategorie` WHERE 1 = 1 330
4SELECT `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
5SELECT `PetiteAnnonceMatosType`.`slug`, `PetiteAnnonceMatosType`.`nom`, `PetiteAnnonceMatosType`.`id` FROM `petite_annonce_matos_types` AS `PetiteAnnonceMatosType` WHERE 1 = 1 880
6SELECT `PetiteAnnonceDiscipline`.`slug`, `PetiteAnnonceDiscipline`.`nom`, `PetiteAnnonceDiscipline`.`id` FROM `petite_annonce_disciplines` AS `PetiteAnnonceDiscipline` WHERE 1 = 1 990