| 1 | 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` = '16307' LIMIT 1 | | 0 | 0 | 3 |
| 2 | 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` = 16307 LIMIT 1 | | 1 | 1 | 1 |
| 3 | SELECT `Membre`.`user_id`, `Membre`.`username`, `Membre`.`user_email`, `Membre`.`user_avatar`, `Membre`.`username_clean` FROM `phpbb_users` AS `Membre` WHERE `Membre`.`user_id` = 3801 | | 1 | 1 | 0 |
| 4 | SELECT `PetiteAnnonceType`.`nom`, `PetiteAnnonceType`.`slug` FROM `petite_annonce_types` AS `PetiteAnnonceType` WHERE `PetiteAnnonceType`.`id` = 3 | | 1 | 1 | 0 |
| 5 | SELECT `PetiteAnnonceMatosType`.`nom`, `PetiteAnnonceMatosType`.`slug` FROM `petite_annonce_matos_types` AS `PetiteAnnonceMatosType` WHERE `PetiteAnnonceMatosType`.`id` = 8 | | 1 | 1 | 0 |
| 6 | 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` = (16307) | | 0 | 0 | 10 |
| 7 | 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` = (16307) | | 0 | 0 | 0 |
| 8 | SELECT `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` = 16307 AND `PetiteAnnoncesPetiteAnnonceDiscipline`.`petite_annonce_discipline_id` = `PetiteAnnonceDiscipline`.`id`) | | 1 | 1 | 1 |
| 9 | SELECT `PetiteAnnonceType`.`id`, `PetiteAnnonceType`.`nom` FROM `petite_annonce_types` AS `PetiteAnnonceType` WHERE 1 = 1 | | 6 | 6 | 0 |
| 10 | SELECT `PetiteAnnonceMatosType`.`id`, `PetiteAnnonceMatosType`.`nom` FROM `petite_annonce_matos_types` AS `PetiteAnnonceMatosType` WHERE 1 = 1 | | 8 | 8 | 0 |
| 11 | SELECT `PetiteAnnonceDiscipline`.`id`, `PetiteAnnonceDiscipline`.`nom` FROM `petite_annonce_disciplines` AS `PetiteAnnonceDiscipline` WHERE 1 = 1 | | 9 | 9 | 0 |
