https://back-immoch.mypreprod.xyz/api/immo/v2/check_authorization_for_figuration

Query Metrics

4 Database Queries
4 Different statements
11.33 ms Query time
43 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8.61 ms
(76.02%)
1
SELECT t0.id AS id_1, t0.uid AS uid_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.two_factor_code AS two_factor_code_6, t0.two_factor_code_expires_at AS two_factor_code_expires_at_7, t0.two_factor_temp_token AS two_factor_temp_token_8, t0.name AS name_9, t0.firstname AS firstname_10, t0.telephone AS telephone_11, t0.address AS address_12, t0.status AS status_13, t0.resettoken AS resettoken_14, t0.tradingname AS tradingname_15, t0.sir AS sir_16, t0.tva AS tva_17, t0.dispomon AS dispomon_18, t0.dispotue AS dispotue_19, t0.dispowed AS dispowed_20, t0.dispothu AS dispothu_21, t0.dispofri AS dispofri_22, t0.disposat AS disposat_23, t0.disposun AS disposun_24, t0.stripe_customer_id AS stripe_customer_id_25, t0.mgp_user_id AS mgp_user_id_26, t0.mgp_wallet_id AS mgp_wallet_id_27, t0.mgp_card_id AS mgp_card_id_28, t0.logo AS logo_29, t0.gender AS gender_30, t0.num_national_register AS num_national_register_31, t0.iban AS iban_32, t0.longitude AS longitude_33, t0.latitude AS latitude_34, t0.client_sales_agreement_discussions AS client_sales_agreement_discussions_35, t0.client_deed_of_sale_discussions AS client_deed_of_sale_discussions_36, t0.committee_avatar AS committee_avatar_37, t0.committee_surname AS committee_surname_38, t0.is_admin AS is_admin_39, t0.admin_id AS admin_id_40, t0.house_number AS house_number_41, t0.house_addition AS house_addition_42, t0.last_notification AS last_notification_43, t0.device_token AS device_token_44, t0.region AS region_45, t0.municipality AS municipality_46, t0.country AS country_47, t0.imported AS imported_48, t0.is_moving_company AS is_moving_company_49, t0.mail_id AS mail_id_50, t0.mail_mini AS mail_mini_51, t0.check_sum AS check_sum_52, t0.personnal_abonnement AS personnal_abonnement_53, t0.certification_area AS certification_area_54, t0.inbox_id AS inbox_id_55, t0.inbox_email AS inbox_email_56, t0.supplier_id AS supplier_id_57, t0.code_client AS code_client_58, t0.username AS username_59, t0.pseudonym AS pseudonym_60, t0.referral_token AS referral_token_61, t0.created AS created_62, t0.updated AS updated_63, t64.id AS id_65, t64.created AS created_66, t64.updated AS updated_67, t64.syndic_id AS syndic_id_68, t69.id AS id_70, t69.study AS study_71, t69.associate_name AS associate_name_72, t69.associate_firstname AS associate_firstname_73, t69.associate_email AS associate_email_74, t69.address AS address_75, t69.fax AS fax_76, t69.site AS site_77, t69.telephone AS telephone_78, t69.bce AS bce_79, t69.check_sum AS check_sum_80, t69.name AS name_81, t69.firstname AS firstname_82, t69.email AS email_83, t69.postal_code AS postal_code_84, t69.municipality AS municipality_85, t69.street AS street_86, t69.country AS country_87, t69.latitude AS latitude_88, t69.longitude AS longitude_89, t69.region AS region_90, t69.user_id AS user_id_91 FROM user t0 LEFT JOIN co_ownership t64 ON t64.syndic_id = t0.id LEFT JOIN notary t69 ON t69.user_id = t0.id WHERE t0.username = ? LIMIT 1
Parameters:
[
  "sonnet-claude"
]
1.08 ms
(9.50%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.display_order AS display_order_3, t0.description AS description_4, t0.is_free AS is_free_5, t0.is_premium AS is_premium_6, t0.price AS price_7, t0.billing_interval AS billing_interval_8, t0.stripe_product_id AS stripe_product_id_9, t0.stripe_price_id AS stripe_price_id_10, t0.status AS status_11, t0.created AS created_12, t0.updated AS updated_13 FROM plan t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.87 ms
(7.66%)
1
SELECT t0.id AS id_1, t0.feature_name AS feature_name_2, t0.usage_limit AS usage_limit_3, t0.plan_id AS plan_id_4 FROM plan_feature t0 WHERE t0.plan_id = ?
Parameters:
[
  1
]
0.77 ms
(6.82%)
1
SELECT t0.id AS id_1, t0.stripe_subscription_id AS stripe_subscription_id_2, t0.status AS status_3, t0.current_period_start AS current_period_start_4, t0.current_period_end AS current_period_end_5, t0.cancel_at_period_end AS cancel_at_period_end_6, t0.cancellation_reason AS cancellation_reason_7, t0.canceled_at AS canceled_at_8, t0.plan_id AS plan_id_9, t0.user_id AS user_id_10 FROM plan_subscription t0 WHERE t0.user_id = ?
Parameters:
[
  140
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
import doctrine.orm.import_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Municipality No errors.
App\Entity\BankSimulation No errors.
App\Entity\ProviderSibelga No errors.
App\Entity\ProviderSibelgaWork No errors.
App\Entity\ProviderSociety No errors.
App\Entity\TheProperty
  • The mappings App\Entity\TheProperty#propertyType and App\Entity\PropertyType#theproperties are inconsistent with each other.
  • The association App\Entity\TheProperty#thepropertyWorks refers to the owning side field App\Entity\ThePropertyWork#theProperty which does not exist.
  • The association App\Entity\TheProperty#schools refers to the owning side field App\Entity\Schools#theProperty which does not exist.
  • The mappings App\Entity\TheProperty#tankInstallationConcerns and App\Entity\ProviderTankInstallation#concernedProperties are inconsistent with each other.
  • The association App\Entity\TheProperty#alerts refers to the owning side field App\Entity\Alert#theProperty which does not exist.
App\Entity\ProviderSolar No errors.
App\Entity\ProviderSolarDeclarationCadastre No errors.
App\Entity\User
  • The field App\Entity\User#notaryOffers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Offer#notary does not contain the required 'inversedBy="notaryOffers"' attribute.
  • The field App\Entity\User#syndicChats is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SyndicChat#sender does not contain the required 'inversedBy="syndicChats"' attribute.
App\Entity\Offer
  • The mappings App\Entity\Offer#salesagreement and App\Entity\SalesAgreementFile#offers are inconsistent with each other.
App\Entity\DomiciliationFiles No errors.
App\Entity\Typeofwork
  • The mappings App\Entity\Typeofwork#subsection and App\Entity\Controls#typeOfWork are inconsistent with each other.
  • The association App\Entity\Typeofwork#nextPebControls refers to the owning side field App\Entity\NextPebControls#TypeOfWork which does not exist.
App\Entity\Subsection No errors.
App\Entity\Choicecategory No errors.
App\Entity\Model No errors.
App\Entity\PdfMailLocation No errors.
App\Entity\ThePropertyWork
  • The association App\Entity\ThePropertyWork#theproperty refers to the inverse side field App\Entity\TheProperty#workcost which does not exist.
App\Entity\CoOwnership No errors.
App\Entity\Notary No errors.
App\Entity\Lastvisit No errors.
App\Entity\Alert
  • The mappings App\Entity\Alert#propertyType and App\Entity\PropertyType#alerts are inconsistent with each other.
App\Entity\Save No errors.
App\Entity\Visitproperty No errors.
App\Entity\Announcement
  • The mappings App\Entity\Announcement#cityDeparture and App\Entity\City#announcements_departure are inconsistent with each other.
  • The mappings App\Entity\Announcement#cityArrival and App\Entity\City#announcements_arrival are inconsistent with each other.
App\Entity\Subscription No errors.
App\Entity\Orders No errors.
App\Entity\Theservice No errors.
App\Entity\ServiceOffer
  • The association App\Entity\ServiceOffer#service refers to the inverse side field App\Entity\Theservice#serviceOffers which does not exist.
App\Entity\ThepropertyOfferInterested No errors.
App\Entity\ThepropertyOfferChat
  • The mappings App\Entity\ThepropertyOfferChat#receiver and App\Entity\User#thepropertyOfferChats are inconsistent with each other.
App\Entity\KycDocument No errors.
App\Entity\UboDocument No errors.
App\Entity\SyndicGroup No errors.
App\Entity\SyndicChat No errors.
App\Entity\SyndicDocumentComment
  • The association App\Entity\SyndicDocumentComment#syndicDocument refers to the inverse side field App\Entity\SyndicDocument#syndicDocumentComments which does not exist.
App\Entity\ThePropertyExteriorComment No errors.
App\Entity\Purchase No errors.
App\Entity\ResultEngie No errors.
App\Entity\EnergyBelgique No errors.
App\Entity\ThepropertyOffer No errors.
App\Entity\ClientDeedOfSale No errors.
App\Entity\PurchasePartnerRequest No errors.
App\Entity\CommunityPost No errors.
App\Entity\CommunityPostComment No errors.
App\Entity\CommunityPostLike No errors.
App\Entity\Committee No errors.
App\Entity\CommunityServiceResponse No errors.
App\Entity\CommunityPlpVote No errors.
App\Entity\CommunityPurchase No errors.
App\Entity\CommunityVoteConsultation No errors.
App\Entity\CommunityCoordinate No errors.
App\Entity\AlertNewProjectImmo No errors.
App\Entity\CommunitySolicitationVote No errors.
App\Entity\CommunityWorkVote No errors.
App\Entity\UrbanPermit No errors.
App\Entity\ColectiveGarden No errors.
App\Entity\Society No errors.
App\Entity\SocietyUse No errors.
App\Entity\CounterOffer No errors.
App\Entity\Education
  • The association App\Entity\Education#class refers to the inverse side field App\Entity\Classes#education which does not exist.
App\Entity\OfferLease
  • The association App\Entity\OfferLease#inventories refers to the owning side field App\Entity\Inventory#offerLease which does not exist.
App\Entity\CarpoolAnnouncement No errors.
App\Entity\Bankdetails No errors.
App\Entity\IdentityDocument No errors.
App\Entity\StarRatings No errors.
App\Entity\CoOwnershipAgenda No errors.
App\Entity\ThepropertyLot No errors.
App\Entity\RelookingSave
  • The association App\Entity\RelookingSave#artist refers to the inverse side field App\Entity\User#relookingSavesArtist which does not exist.
App\Entity\CoOwnershipTheProperty No errors.
App\Entity\CoOwnershipProposition No errors.
App\Entity\Portfolio No errors.
App\Entity\GardenProjectActionsLot No errors.
App\Entity\WorkArt No errors.
App\Entity\RentalManagement No errors.
App\Entity\RentalManagementLeave No errors.
App\Entity\UserPurchasePartnerRequest No errors.
App\Entity\PublicityUser No errors.
App\Entity\Plan\PlanSubscription No errors.
App\Entity\ClientSalesAgreement No errors.
App\Entity\AppointmentRequest No errors.
App\Entity\UserRating\UserRating No errors.
App\Entity\TimelineEvent No errors.
App\Entity\MarkofInterest No errors.
App\Entity\Referral No errors.
App\Entity\Plan\Plan No errors.
App\Entity\Plan\Invoice No errors.
App\Entity\Plan\PlanFeature No errors.
App\Entity\Plan\FeatureUsage No errors.
App\Entity\ImagePub No errors.
App\Entity\Engie No errors.
App\Entity\Region
  • The association App\Entity\Region#alerts refers to the owning side field App\Entity\Alert#idregion which does not exist.
  • The association App\Entity\Region#syndics refers to the owning side field App\Entity\Syndic#regiom which does not exist.
  • The association App\Entity\Region#categoryEnvironnements refers to the owning side field App\Entity\CategoryEnvironnement#region which does not exist.
App\Entity\Country No errors.
App\Entity\PropertyType
  • The association App\Entity\PropertyType#theproperties refers to the owning side field App\Entity\TheProperty#propertytype which does not exist.
  • The association App\Entity\PropertyType#alerts refers to the owning side field App\Entity\Alert#property_type which does not exist.
App\Entity\LocationType No errors.
App\Entity\Option
  • The association App\Entity\Option#heatNeededs refers to the owning side field App\Entity\HeatNeeded#opionTypeId which does not exist.
App\Entity\HeatNeeded
  • The mappings App\Entity\HeatNeeded#optionType and App\Entity\Option#heatNeededs are inconsistent with each other.
App\Entity\VentilationLoses No errors.
App\Entity\PebInformation No errors.
App\Entity\VentilationSystem No errors.
App\Entity\WarmWaterPerformance No errors.
App\Entity\Indicator
  • The association App\Entity\Indicator#feature refers to the inverse side field App\Entity\ThepropertyFeature#indicators which does not exist.
App\Entity\ThepropertyFeature
  • The field App\Entity\ThepropertyFeature#features is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\FeatureRelation#thepropertyFeature does not contain the required 'inversedBy="features"' attribute.
App\Entity\FeatureRelation No errors.
App\Entity\Feature
  • The field App\Entity\Feature#features is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\FeatureRelation#feature does not contain the required 'inversedBy="features"' attribute.
App\Entity\BoilerPerformance No errors.
App\Entity\RenewalEnergy No errors.
App\Entity\Syndic
  • The mappings App\Entity\Syndic#region and App\Entity\Region#syndics are inconsistent with each other.
  • The mappings App\Entity\Syndic#theproperties and App\Entity\TheProperty#syndic are inconsistent with each other.
App\Entity\PublicInquiryInProgressCsv No errors.
App\Entity\Provinces No errors.
App\Entity\CategoryEnvironnement No errors.
App\Entity\PermitCiterne No errors.
App\Entity\PermitLocationEnvironment No errors.
App\Entity\Schools No errors.
App\Entity\Levels No errors.
App\Entity\Classes No errors.
App\Entity\ThepropertyDocument
  • The mappings App\Entity\ThepropertyDocument#type and App\Entity\DocumentType#thepropertyDocuments are inconsistent with each other.
App\Entity\DocumentType
  • The association App\Entity\DocumentType#thepropertyDocuments refers to the owning side field App\Entity\ThepropertyDocument#documenttype which does not exist.
App\Entity\ThepropertyDocumentCategory No errors.
App\Entity\TheProperty\ExtensionOrder\ThePropertyExtensionOrder No errors.
App\Entity\TheProperty\ExtensionOrder\ThePropertyExtensionOrderItem No errors.
App\Entity\PropertyImage No errors.
App\Entity\Contactseller No errors.
App\Entity\Photo No errors.
App\Entity\City
  • The association App\Entity\City#announcements_departure refers to the owning side field App\Entity\Announcement#city_departure which does not exist.
  • The association App\Entity\City#announcements_arrival refers to the owning side field App\Entity\Announcement#city_arrival which does not exist.
App\Entity\AnnouncementObject No errors.
App\Entity\Size No errors.
App\Entity\Subject No errors.
App\Entity\ThepropertyOfferImage No errors.
App\Entity\Submodel No errors.
App\Entity\Workcost
  • The association App\Entity\Workcost#constructionwork refers to the owning side field App\Entity\ThePropertyWork#workcost which does not exist.
App\Entity\ThePropertyWorkDocuments No errors.
App\Entity\ThePropertyWorkDocCategory No errors.
App\Entity\DetailedStudyWork No errors.
App\Entity\Controls No errors.
App\Entity\ThePropertyDocuments No errors.
App\Entity\NextControls No errors.
App\Entity\PebControls No errors.
App\Entity\NextPebControls
  • The mappings App\Entity\NextPebControls#typeOfWork and App\Entity\Typeofwork#nextPebControls are inconsistent with each other.
App\Entity\Evacuations No errors.
App\Entity\Authorizations No errors.
App\Entity\Fillings No errors.
App\Entity\Demands No errors.
App\Entity\Responses No errors.
App\Entity\ThePropertyConstructionWorkRules No errors.
App\Entity\Dispense No errors.
App\Entity\Prime
  • The mappings App\Entity\Prime#source and App\Entity\PrimeSource#primes are inconsistent with each other.
  • The field App\Entity\Prime#prime is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Prime#complementary does not contain the required 'inversedBy="prime"' attribute.
App\Entity\PrimeSource
  • The association App\Entity\PrimeSource#primes refers to the owning side field App\Entity\Prime#type which does not exist.
App\Entity\PrimeAmount No errors.
App\Entity\PrimePlafond No errors.
App\Entity\PrimeForm No errors.
App\Entity\PrimeProcedure
  • The mappings App\Entity\PrimeProcedure#fields and App\Entity\PrimeProcedureField#primeProcedure are inconsistent with each other.
App\Entity\PrimeProcedureField
  • The association App\Entity\PrimeProcedureField#primeProcedure refers to the inverse side field App\Entity\PrimeProcedure#primeProcedureFields which does not exist.
App\Entity\PrimeProcess No errors.
App\Entity\NewProjectImmo No errors.
App\Entity\PublicInquiryBruxelles No errors.
App\Entity\PublicInquiryAnvers No errors.
App\Entity\NewProjectImmoFile No errors.
App\Entity\ThepropertOfferBill
  • The mappings App\Entity\ThepropertOfferBill#thepropertyBalance and App\Entity\ThepropertyBalance#thepropertOfferBills are inconsistent with each other.
  • The mappings App\Entity\ThepropertOfferBill#syndicAccounting and App\Entity\SyndicAccounting#thepropertOfferBills are inconsistent with each other.
App\Entity\ThepropertyBalance
  • The association App\Entity\ThepropertyBalance#thepropertOfferBills refers to the owning side field App\Entity\ThepropertOfferBill#ThepropertyBalance which does not exist.
App\Entity\SyndicAccounting
  • The association App\Entity\SyndicAccounting#Theproperty refers to the inverse side field App\Entity\TheProperty#syndicAccountings which does not exist.
  • The association App\Entity\SyndicAccounting#thepropertOfferBills refers to the owning side field App\Entity\ThepropertOfferBill#SyndicAccounting which does not exist.
App\Entity\CoOwnerShipDocument No errors.
App\Entity\OwnershipGeneralMeeting No errors.
App\Entity\CoOwnershipMeetingTranscript No errors.
App\Entity\CoOwnershipMeetingTranscriptFile No errors.
App\Entity\CoOwnershipGMDecision No errors.
App\Entity\CoOwnershipInvoices No errors.
App\Entity\CoOwnershipLotAccount No errors.
App\Entity\CoOwnershipLotTotalAccount No errors.
App\Entity\CoOwnershipTotalAccount No errors.
App\Entity\CoOwnershipBalance No errors.
App\Entity\CoOwnershipLotBalance No errors.
App\Entity\CoOwnershipCouncil No errors.
App\Entity\CoOwnershipFiles No errors.
App\Entity\CoOwnershipAuditor No errors.
App\Entity\CoOwnershipPropositionVote No errors.
App\Entity\OfferCollaborative
  • The association App\Entity\OfferCollaborative#user refers to the inverse side field App\Entity\User#offerCollaboratives which does not exist.
  • The association App\Entity\OfferCollaborative#notary refers to the inverse side field App\Entity\User#notaryOfferCollaboratives which does not exist.
App\Entity\PurchasePartnerRequestObjectif No errors.
App\Entity\OfferDocumentSpeaker
  • The association App\Entity\OfferDocumentSpeaker#deedOfSale refers to the inverse side field App\Entity\ClientDeedOfSale#speakers which does not exist.
App\Entity\OnespanData No errors.
App\Entity\ClientClause No errors.
App\Entity\RequestSellerToNotary No errors.
App\Entity\Vente No errors.
App\Entity\ThepropertyConsumption No errors.
App\Entity\ThepropertyProviderDocumentProof No errors.
App\Entity\ThepropertyProvider
  • The association App\Entity\ThepropertyProvider#thepropertyCounters refers to the owning side field App\Entity\ThepropertyCounter#thepropertyProvider which does not exist.
App\Entity\ThepropertyCounter
  • The mappings App\Entity\ThepropertyCounter#thePropertyProvider and App\Entity\ThepropertyProvider#thepropertyCounters are inconsistent with each other.
  • The association App\Entity\ThepropertyCounter#thepropertyCounterStatements refers to the owning side field App\Entity\ThepropertyCounterStatement#thepropertyCounter which does not exist.
App\Entity\ThepropertyCounterStatement
  • The mappings App\Entity\ThepropertyCounterStatement#thePropertyCounter and App\Entity\ThepropertyCounter#thepropertyCounterStatements are inconsistent with each other.
App\Entity\ThepropertyProviderBill No errors.
App\Entity\CommunityPostFile No errors.
App\Entity\CommunityEvent No errors.
App\Entity\CommunityEventFile No errors.
App\Entity\CommunityServiceRequest No errors.
App\Entity\CommunityPlp No errors.
App\Entity\CommunityLostAnimal No errors.
App\Entity\CommunityParty No errors.
App\Entity\CommunityVoteParty
  • The association App\Entity\CommunityVoteParty#post refers to the inverse side field App\Entity\CommunityPost#votes which does not exist.
App\Entity\CommunityHouseWarming No errors.
App\Entity\CommunityFleatMarket No errors.
App\Entity\CommunitySale No errors.
App\Entity\CommunityProduct No errors.
App\Entity\CommunityTypeProduct No errors.
App\Entity\CommunityConsultation No errors.
App\Entity\DesignNeighborhood
  • The association App\Entity\DesignNeighborhood#committee refers to the inverse side field App\Entity\Committee#designNeighborhood which does not exist.
App\Entity\NeighborhoodImage No errors.
App\Entity\CommunitySolicitation No errors.
App\Entity\CommunityWork No errors.
App\Entity\CommunityPostSignal No errors.
App\Entity\ProviderSolarOrganization No errors.
App\Entity\ProviderSolarBrugel No errors.
App\Entity\ProviderSolarGreenCertificate No errors.
App\Entity\ProviderSolarGreenCertificateFiles No errors.
App\Entity\PermitEnvironmentalForm No errors.
App\Entity\EnvironmentalFormWast No errors.
App\Entity\AnnexPermit No errors.
App\Entity\PermitEnvironmentFile No errors.
App\Entity\EasyPermitForm2 No errors.
App\Entity\DeliveryTimes No errors.
App\Entity\EnvironmentRequest No errors.
App\Entity\SurveillanceCamera No errors.
App\Entity\SurveillanceCameraType No errors.
App\Entity\AlarmSystem No errors.
App\Entity\TypeOfAlarmSystem No errors.
App\Entity\ThePropertyTank No errors.
App\Entity\ThePropertyBoiler No errors.
App\Entity\ChoicedEngie No errors.
App\Entity\Condominium No errors.
App\Entity\View No errors.
App\Entity\PropertyOption
  • The association App\Entity\PropertyOption#optionId refers to the inverse side field App\Entity\Option#propertyOptions which does not exist.
App\Entity\LandPropertyDestination No errors.
App\Entity\Adress No errors.
App\Entity\Solicitation No errors.
App\Entity\UserServicePromo
  • The association App\Entity\UserServicePromo#user refers to the inverse side field App\Entity\User#userServicePromos which does not exist.
App\Entity\LeaseContract No errors.
App\Entity\EditRegisters No errors.
App\Entity\Registers
  • The field App\Entity\Registers#editRegisters is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\EditRegisters#registers does not contain the required 'mappedBy="editRegisters"' attribute.
  • If association App\Entity\Registers#editRegisters is many-to-one, then the inversed side App\Entity\EditRegisters#registers has to be one-to-many.
App\Entity\PermitProperty No errors.
App\Entity\AnnexPermitProperty No errors.

import entity manager

No loaded entities.