tests/routes/pro/get_collective_offer_test.py:207: in test_performance
    with testing.assert_num_queries(expected_num_queries):
/usr/local/lib/python3.11/contextlib.py:144: in __exit__
    next(self.gen)
src/pcapi/core/testing.py:82: in assert_num_queries
    pytest.fail(
E   Failed: 9 queries executed, 8 expected
E   Captured queries were:
E   1. SELECT user_session.id AS user_session_id, user_session."userId" AS "user_session_userId", user_session.uuid AS user_session_uuid 
E      FROM user_session 
E      WHERE user_session."userId" = 834 AND user_session.uuid = a11ea1eb-9841-4d7c-b110-563335ab8ffb
E   2. SELECT "user"."phoneNumber" AS "user_phoneNumber", "user"."isActive" AS "user_isActive", "user".id AS user_id, "user".activity AS user_activity, "user".address AS user_address, "user".city AS user_city, "user".civility AS user_civility, "user".comment AS user_comment, "user"."culturalSurveyFilledDate" AS "user_culturalSurveyFilledDate", "user"."culturalSurveyId" AS "user_culturalSurveyId", "user"."dateCreated" AS "user_dateCreated", "user"."dateOfBirth" AS "user_dateOfBirth", "user"."departementCode" AS "user_departementCode", "user".email AS user_email, "user"."externalIds" AS "user_externalIds", "user"."extraData" AS "user_extraData", "user"."firstName" AS "user_firstName", "user"."hasSeenProTutorials" AS "user_hasSeenProTutorials", "user"."hasSeenProRgs" AS "user_hasSeenProRgs", "user"."idPieceNumber" AS "user_idPieceNumber", "user"."ineHash" AS "user_ineHash", "user"."irisFranceId" AS "user_irisFranceId", "user"."isEmailValidated" AS "user_isEmailValidated", "user"."lastConnectionDate" AS "user_lastConnectionDate", "user"."lastName" AS "user_lastName", "user".married_name AS user_married_name, "user"."needsToFillCulturalSurvey" AS "user_needsToFillCulturalSurvey", "user"."notificationSubscriptions" AS "user_notificationSubscriptions", "user".password AS user_password, "user"."phoneValidationStatus" AS "user_phoneValidationStatus", "user"."postalCode" AS "user_postalCode", "user"."recreditAmountToShow" AS "user_recreditAmountToShow", "user".roles AS user_roles, "user"."schoolType" AS "user_schoolType", "user"."validatedBirthDate" AS "user_validatedBirthDate" 
E      FROM "user" 
E      WHERE "user".id = 834
E   3. SELECT offerer.address AS offerer_address, offerer.street AS offerer_street, offerer."isActive" AS "offerer_isActive", offerer.id AS offerer_id, offerer."postalCode" AS "offerer_postalCode", offerer.city AS offerer_city, offerer."validationStatus" AS "offerer_validationStatus", offerer."dateCreated" AS "offerer_dateCreated", offerer.name AS offerer_name, offerer.siren AS offerer_siren, offerer."dateValidated" AS "offerer_dateValidated", offerer."allowedOnAdage" AS "offerer_allowedOnAdage" 
E      FROM offerer JOIN venue ON offerer.id = venue."managingOffererId" JOIN collective_offer ON venue.id = collective_offer."venueId" 
E      WHERE collective_offer.id = 197
E   4. SELECT EXISTS (SELECT 1 
E      FROM user_offerer 
E      WHERE user_offerer."offererId" = 665 AND user_offerer."userId" = 834 AND user_offerer."validationStatus" = VALIDATED) AS anon_1
E   5. SELECT collective_stock.id AS collective_stock_id, collective_stock."stockId" AS "collective_stock_stockId", collective_stock."dateCreated" AS "collective_stock_dateCreated", collective_stock."dateModified" AS "collective_stock_dateModified", collective_stock."beginningDatetime" AS "collective_stock_beginningDatetime", collective_stock."startDatetime" AS "collective_stock_startDatetime", collective_stock."endDatetime" AS "collective_stock_endDatetime", collective_stock."collectiveOfferId" AS "collective_stock_collectiveOfferId", collective_stock.price AS collective_stock_price, collective_stock."bookingLimitDatetime" AS "collective_stock_bookingLimitDatetime", collective_stock."numberOfTickets" AS "collective_stock_numberOfTickets", collective_stock."priceDetail" AS "collective_stock_priceDetail", collective_offer.id AS collective_offer_id, collective_offer."lastValidationDate" AS "collective_offer_lastValidationDate", collective_offer."lastValidationType" AS "collective_offer_lastValidationType", collective_offer.validation AS collective_offer_validation, collective_offer."audioDisabilityCompliant" AS "collective_offer_audioDisabilityCompliant", collective_offer."mentalDisabilityCompliant" AS "collective_offer_mentalDisabilityCompliant", collective_offer."motorDisabilityCompliant" AS "collective_offer_motorDisabilityCompliant", collective_offer."visualDisabilityCompliant" AS "collective_offer_visualDisabilityCompliant", collective_offer."imageId" AS "collective_offer_imageId", collective_offer."imageCrop" AS "collective_offer_imageCrop", collective_offer."imageCredit" AS "collective_offer_imageCredit", collective_offer."imageHasOriginal" AS "collective_offer_imageHasOriginal", collective_offer."offerId" AS "collective_offer_offerId", collective_offer."isActive" AS "collective_offer_isActive", collective_offer."authorId" AS "collective_offer_authorId", collective_offer."venueId" AS "collective_offer_venueId", collective_offer.name AS collective_offer_name, collective_offer."bookingEmails" AS "collective_offer_bookingEmails", collective_offer.description AS collective_offer_description, collective_offer."durationMinutes" AS "collective_offer_durationMinutes", collective_offer."dateCreated" AS "collective_offer_dateCreated", collective_offer."dateArchived" AS "collective_offer_dateArchived", collective_offer."subcategoryId" AS "collective_offer_subcategoryId", collective_offer."dateUpdated" AS "collective_offer_dateUpdated", collective_offer.students AS collective_offer_students, collective_offer."contactEmail" AS "collective_offer_contactEmail", collective_offer."contactPhone" AS "collective_offer_contactPhone", collective_offer."offerVenue" AS "collective_offer_offerVenue", collective_offer."interventionArea" AS "collective_offer_interventionArea", collective_offer."institutionId" AS "collective_offer_institutionId", collective_offer."templateId" AS "collective_offer_templateId", collective_offer."teacherId" AS "collective_offer_teacherId", collective_offer."providerId" AS "collective_offer_providerId", collective_offer.formats AS collective_offer_formats, collective_offer."offererAddressId" AS "collective_offer_offererAddressId", collective_offer."nationalProgramId" AS "collective_offer_nationalProgramId", collective_offer."lastValidationAuthorUserId" AS "collective_offer_lastValidationAuthorUserId", offerer_1.address AS offerer_1_address, offerer_1.street AS offerer_1_street, offerer_1."isActive" AS "offerer_1_isActive", offerer_1.id AS offerer_1_id, offerer_1."postalCode" AS "offerer_1_postalCode", offerer_1.city AS offerer_1_city, offerer_1."validationStatus" AS "offerer_1_validationStatus", offerer_1."dateCreated" AS "offerer_1_dateCreated", offerer_1.name AS offerer_1_name, offerer_1.siren AS offerer_1_siren, offerer_1."dateValidated" AS "offerer_1_dateValidated", offerer_1."allowedOnAdage" AS "offerer_1_allowedOnAdage", venue_1.address AS venue_1_address, venue_1.street AS venue_1_street, venue_1."bannerUrl" AS "venue_1_bannerUrl", venue_1."bannerMeta" AS "venue_1_bannerMeta", venue_1.id AS venue_1_id, venue_1."audioDisabilityCompliant" AS "venue_1_audioDisabilityCompliant", venue_1."mentalDisabilityCompliant" AS "venue_1_mentalDisabilityCompliant", venue_1."motorDisabilityCompliant" AS "venue_1_motorDisabilityCompliant", venue_1."visualDisabilityCompliant" AS "venue_1_visualDisabilityCompliant", venue_1."thumbCount" AS "venue_1_thumbCount", venue_1.name AS venue_1_name, venue_1.siret AS venue_1_siret, venue_1."departementCode" AS "venue_1_departementCode", venue_1.latitude AS venue_1_latitude, venue_1.longitude AS venue_1_longitude, venue_1."managingOffererId" AS "venue_1_managingOffererId", venue_1."bookingEmail" AS "venue_1_bookingEmail", venue_1."postalCode" AS "venue_1_postalCode", venue_1.city AS venue_1_city, venue_1."banId" AS "venue_1_banId", venue_1.timezone AS venue_1_timezone, venue_1."publicName" AS "venue_1_publicName", venue_1."isVisibleInApp" AS "venue_1_isVisibleInApp", venue_1."isVirtual" AS "venue_1_isVirtual", venue_1."isPermanent" AS "venue_1_isPermanent", venue_1.comment AS venue_1_comment, venue_1."venueTypeCode" AS "venue_1_venueTypeCode", venue_1."venueLabelId" AS "venue_1_venueLabelId", venue_1."dateCreated" AS "venue_1_dateCreated", venue_1."withdrawalDetails" AS "venue_1_withdrawalDetails", venue_1.description AS venue_1_description, venue_1."adageId" AS "venue_1_adageId", venue_1."adageInscriptionDate" AS "venue_1_adageInscriptionDate", venue_1."dmsToken" AS "venue_1_dmsToken", venue_1."venueEducationalStatusId" AS "venue_1_venueEducationalStatusId", venue_1."collectiveDescription" AS "venue_1_collectiveDescription", venue_1."collectiveStudents" AS "venue_1_collectiveStudents", venue_1."collectiveWebsite" AS "venue_1_collectiveWebsite", venue_1."collectiveInterventionArea" AS "venue_1_collectiveInterventionArea", venue_1."collectiveNetwork" AS "venue_1_collectiveNetwork", venue_1."collectiveAccessInformation" AS "venue_1_collectiveAccessInformation", venue_1."collectivePhone" AS "venue_1_collectivePhone", venue_1."collectiveEmail" AS "venue_1_collectiveEmail", venue_1."collectiveSubCategoryId" AS "venue_1_collectiveSubCategoryId", venue_1."offererAddressId" AS "venue_1_offererAddressId", collective_booking_1.id AS collective_booking_1_id, collective_booking_1."dateCreated" AS "collective_booking_1_dateCreated", collective_booking_1."dateUsed" AS "collective_booking_1_dateUsed", collective_booking_1."collectiveStockId" AS "collective_booking_1_collectiveStockId", collective_booking_1."venueId" AS "collective_booking_1_venueId", collective_booking_1."offererId" AS "collective_booking_1_offererId", collective_booking_1."cancellationDate" AS "collective_booking_1_cancellationDate", collective_booking_1."cancellationUserId" AS "collective_booking_1_cancellationUserId", collective_booking_1."cancellationLimitDate" AS "collective_booking_1_cancellationLimitDate", collective_booking_1."cancellationReason" AS "collective_booking_1_cancellationReason", collective_booking_1.status AS collective_booking_1_status, collective_booking_1."reimbursementDate" AS "collective_booking_1_reimbursementDate", collective_booking_1."educationalInstitutionId" AS "collective_booking_1_educationalInstitutionId", collective_booking_1."educationalYearId" AS "collective_booking_1_educationalYearId", collective_booking_1."confirmationDate" AS "collective_booking_1_confirmationDate", collective_booking_1."confirmationLimitDate" AS "collective_booking_1_confirmationLimitDate", collective_booking_1."educationalRedactorId" AS "collective_booking_1_educationalRedactorId", educational_domain_1.id AS educational_domain_1_id, educational_domain_1.name AS educational_domain_1_name 
E      FROM collective_offer LEFT OUTER JOIN collective_stock ON collective_stock."collectiveOfferId" = 197 JOIN venue AS venue_1 ON venue_1.id = collective_offer."venueId" JOIN offerer AS offerer_1 ON offerer_1.id = venue_1."managingOffererId" LEFT OUTER JOIN collective_booking AS collective_booking_1 ON collective_stock.id = collective_booking_1."collectiveStockId" LEFT OUTER JOIN (collective_offer_domain AS collective_offer_domain_1 JOIN educational_domain AS educational_domain_1 ON educational_domain_1.id = collective_offer_domain_1."educationalDomainId") ON collective_offer.id = collective_offer_domain_1."collectiveOfferId" 
E      WHERE collective_offer.id = 197
E   6. SELECT google_places_info.id AS google_places_info_id, google_places_info."venueId" AS "google_places_info_venueId", google_places_info."placeId" AS "google_places_info_placeId", google_places_info."bannerUrl" AS "google_places_info_bannerUrl", google_places_info."bannerMeta" AS "google_places_info_bannerMeta", google_places_info."updateDate" AS "google_places_info_updateDate" 
E      FROM google_places_info 
E      WHERE 659 = google_places_info."venueId"
E   7. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" 
E      FROM feature
E   8. SELECT collective_booking.status AS collective_booking_status 
E      FROM collective_booking JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" 
E      WHERE collective_stock."collectiveOfferId" = 197 AND collective_booking.id IN (SELECT max(collective_booking.id) AS max_1 
E      FROM collective_booking JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" 
E      WHERE collective_stock."collectiveOfferId" = 197)
E   9. SELECT max(collective_booking.id) AS max_1 
E      FROM collective_booking JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" 
E      WHERE collective_stock."collectiveOfferId" = 197