http://moonshot.testing-eg.svc.cluster.local/api/listing/count?location%5B0%5D=38&propertyType=1&section=2

Query Metrics

0 Database Queries
0 Different statements
0.00 ms Query time
17 Invalid entities

Grouped Statements

Show all queries

No database queries were performed.

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
Aqarmap\Bundle\ListingBundle\Entity\Listing
  • The field Aqarmap\Bundle\ListingBundle\Entity\Listing#compoundAveragePrices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\ListingBundle\Entity\CompoundAveragePrice#parentCompound does not contain the required 'inversedBy="compoundAveragePrices"' attribute.
App\Entity\Lead\Lead No errors.
Aqarmap\Bundle\ListingBundle\Entity\Location
  • The mappings Aqarmap\Bundle\ListingBundle\Entity\Location#childrenSortedById and Aqarmap\Bundle\ListingBundle\Entity\Location#parent are inconsistent with each other.
Aqarmap\Bundle\ListingBundle\Entity\Phone No errors.
Aqarmap\Bundle\ListingBundle\Entity\UserPhone No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingPhone No errors.
Aqarmap\Bundle\UserBundle\Entity\UserServices No errors.
Aqarmap\Bundle\UserBundle\Entity\User
  • The field Aqarmap\Bundle\UserBundle\Entity\User#referrals is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\CRMBundle\Entity\Company#referedBy does not contain the required 'inversedBy="referrals"' attribute.
  • The field Aqarmap\Bundle\UserBundle\Entity\User#recurringTransactions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction#user does not contain the required 'inversedBy="recurringTransactions"' attribute.
  • The field Aqarmap\Bundle\UserBundle\Entity\User#packages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\UserBundle\Entity\UserPackages#user does not contain the required 'inversedBy="packages"' attribute.
Aqarmap\Bundle\ListingBundle\Entity\PropertyType
  • The field Aqarmap\Bundle\ListingBundle\Entity\PropertyType#compoundAveragePrice is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\ListingBundle\Entity\CompoundAveragePrice#propertyType does not contain the required 'inversedBy="compoundAveragePrice"' attribute.
Aqarmap\Bundle\ListingBundle\Entity\CompoundLocation No errors.
Aqarmap\Bundle\ListingBundle\Entity\Rule No errors.
Aqarmap\Bundle\UserBundle\Entity\UserPackages No errors.
Aqarmap\Bundle\CreditBundle\Entity\Credit
  • The association Aqarmap\Bundle\CreditBundle\Entity\Credit#userPackages refers to the inverse side field Aqarmap\Bundle\UserBundle\Entity\UserPackages#credits which does not exist.
Aqarmap\Bundle\PaymentBundle\Entity\Payment
  • The association Aqarmap\Bundle\PaymentBundle\Entity\Payment#recurringTransaction refers to the inverse side field Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction#paymentTransactions which does not exist.
Aqarmap\Bundle\FeatureToggleBundle\Entity\FeatureToggle No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\TopSellerLead No errors.
Aqarmap\Bundle\MessageBundle\Entity\Message No errors.
Aqarmap\Bundle\MessageBundle\Entity\Conversation No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingPhoto No errors.
Aqarmap\Bundle\ListingBundle\Entity\Interaction No errors.
Aqarmap\Bundle\ListingBundle\Entity\Favourite No errors.
Aqarmap\Bundle\ListingBundle\Entity\CallRequestLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\PhoneLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\MessageLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\FreeListing No errors.
Aqarmap\Bundle\ListingBundle\Entity\TargetUserPhoneLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\TargetUserMessageLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\TargetUserLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\SimilarListingsLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\UserDomainPhoneLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\UserDomainMessageLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\WhatsAppLead No errors.
Aqarmap\Bundle\UserBundle\Entity\UserInterest No errors.
Aqarmap\Bundle\ListingBundle\Entity\Section No errors.
Aqarmap\Bundle\MainBundle\Entity\Setting No errors.
Aqarmap\Bundle\ListingBundle\Entity\Lead No errors.
Aqarmap\Bundle\MessageBundle\Entity\Recipient No errors.
Aqarmap\Bundle\ListingBundle\Entity\CallRequest No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingFeature No errors.
Aqarmap\Bundle\ListingBundle\Entity\CustomField No errors.
Aqarmap\Bundle\SearchBundle\Entity\SearchResultCombinations No errors.
Aqarmap\Bundle\UserBundle\Entity\Group No errors.
Aqarmap\Bundle\ListingBundle\Entity\Rejection No errors.
Aqarmap\Bundle\AnnouncementBundle\Entity\Announcement No errors.
Aqarmap\Bundle\ListingBundle\Entity\CompoundAveragePrice No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingAttribute No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingTranslation No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingNotification No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingRate No errors.
Aqarmap\Bundle\ValueEngineBundle\Entity\ValueEngineListingsLocations No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingNote No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingsRatesNote No errors.
Aqarmap\Bundle\ListingBundle\Entity\CompoundField No errors.
Aqarmap\Bundle\ListingBundle\Entity\FeaturedCompany No errors.
Aqarmap\Bundle\ListingBundle\Entity\LocationTranslation No errors.
Aqarmap\Bundle\CRMBundle\Entity\Company No errors.
Aqarmap\Bundle\ListingBundle\Entity\LocationSupplyDemand No errors.
Aqarmap\Bundle\NotifierBundle\Entity\Notifier No errors.
Aqarmap\Bundle\ListingBundle\Entity\LocationPhoto No errors.
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationStatistics No errors.
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationCompound No errors.
Aqarmap\Bundle\DiscussionBundle\Entity\Discussion No errors.
Aqarmap\Bundle\ExchangeBundle\Entity\ExchangeRequest No errors.
Aqarmap\Bundle\ListingBundle\Entity\LocationRating No errors.
Aqarmap\Bundle\ListingBundle\Entity\SearchTerm No errors.
Aqarmap\Bundle\ValueEngineBundle\Entity\ListingInsight No errors.
Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction
  • The field Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction#recurringTransactionStates is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransactionState#recurringTransaction does not contain the required 'inversedBy="recurringTransactionStates"' attribute.
  • The mappings Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction#payment and Aqarmap\Bundle\PaymentBundle\Entity\Payment#recurringTransaction are inconsistent with each other.
Aqarmap\Bundle\ListingBundle\Entity\Photo No errors.
Aqarmap\Bundle\BrokerSalesBundle\Entity\Seller No errors.
Aqarmap\Bundle\BrokerSalesBundle\Entity\Broker No errors.
Aqarmap\Bundle\CreditBundle\Entity\CreditAnalysis No errors.
Aqarmap\Bundle\PaymentBundle\Entity\SalesAnalysis No errors.
Aqarmap\Bundle\UserBundle\Entity\TeamHistory No errors.
Aqarmap\Bundle\UserBundle\Entity\UserDevice No errors.
Aqarmap\Bundle\CRMBundle\Entity\Staff No errors.
Aqarmap\Bundle\UserBundle\Entity\Team No errors.
Aqarmap\Bundle\ExchangeBundle\Entity\ExchangeRequestUnlock No errors.
Aqarmap\Bundle\UserBundle\Entity\UserCheckin No errors.
Aqarmap\Bundle\UserBundle\Entity\UserDomain No errors.
Aqarmap\Bundle\DiscussionBundle\Entity\Comment No errors.
Aqarmap\Bundle\UserBundle\Entity\PersonalInfo No errors.
Aqarmap\Bundle\CustomerProfilingBundle\Entity\CustomerProfilingQuestionQueue No errors.
Aqarmap\Bundle\MessageBundle\Entity\ConversationRecipient No errors.
Aqarmap\Bundle\DiscussionBundle\Entity\CommentLike No errors.
Aqarmap\Bundle\PaymentBundle\Entity\PaymentTransactionService No errors.
Aqarmap\Bundle\CRMBundle\Entity\StaffHistory No errors.
Aqarmap\Bundle\UserBundle\Entity\DeveloperField No errors.
Aqarmap\Bundle\ListingBundle\Entity\PropertyTypeTranslation No errors.
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationCompoundSize No errors.
Aqarmap\Bundle\ListingBundle\Entity\CompoundLocationTranslation No errors.
Aqarmap\Bundle\CreditBundle\Entity\Package
  • The association Aqarmap\Bundle\CreditBundle\Entity\Package#locations refers to the inverse side field Aqarmap\Bundle\ListingBundle\Entity\Location#packages which does not exist.
Aqarmap\Bundle\FeatureToggleBundle\Entity\FeatureToggleRule No errors.
Aqarmap\Bundle\ListingBundle\Entity\SectionTranslation No errors.
Aqarmap\Bundle\ListingBundle\Entity\PriceFilter No errors.
Gedmo\Tree\Entity\MappedSuperclass\AbstractClosure No errors.
App\Entity\WaitingList\UserWaitingList No errors.
App\Entity\User\UserSubAccount
  • The association App\Entity\User\UserSubAccount#user refers to the inverse side field Aqarmap\Bundle\UserBundle\Entity\User#subAccountInventions which does not exist.
  • The association App\Entity\User\UserSubAccount#subAccount refers to the inverse side field Aqarmap\Bundle\UserBundle\Entity\User#subAccountInventions which does not exist.
App\Entity\User\UserAuth No errors.
Aqarmap\Bundle\UserBundle\Entity\BaseUserInterest No errors.
Aqarmap\Bundle\UserBundle\Entity\SavedSearch No errors.
Aqarmap\Bundle\UserBundle\Entity\UserDeviceCategory No errors.
Aqarmap\Bundle\UserBundle\Entity\ZohoUsersLogs No errors.
Aqarmap\Bundle\UserBundle\Entity\TargetAudienceHistory No errors.
Aqarmap\Bundle\UserBundle\Entity\Device No errors.
Aqarmap\Bundle\UserBundle\Entity\UserNote No errors.
Aqarmap\Bundle\MainBundle\Entity\MobileSectionsToggles No errors.
Aqarmap\Bundle\MainBundle\Entity\Menu No errors.
Aqarmap\Bundle\MainBundle\Entity\MenuTranslation No errors.
Aqarmap\Bundle\MainBundle\Entity\JoinUs No errors.
Aqarmap\Bundle\MainBundle\Entity\Feedback No errors.
Aqarmap\Bundle\MainBundle\Entity\Link No errors.
Aqarmap\Bundle\MainBundle\Entity\CustomParagraph No errors.
Aqarmap\Bundle\MainBundle\Entity\LinkTranslation No errors.
Aqarmap\Bundle\MainBundle\Entity\Page No errors.
Aqarmap\Bundle\MainBundle\Entity\CustomParagraphTranslation No errors.
Aqarmap\Bundle\MainBundle\Entity\DefaultTopCustomers No errors.
Aqarmap\Bundle\MainBundle\Entity\PageTranslation
  • The association Aqarmap\Bundle\MainBundle\Entity\PageTranslation#object refers to the inverse side field Aqarmap\Bundle\MainBundle\Entity\Page#translations which does not exist.
Aqarmap\Bundle\ListingBundle\Entity\UserDomainLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\TargetUserCallRequestLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\FeaturedCompanyLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\RejectionTranslation
  • The association Aqarmap\Bundle\ListingBundle\Entity\RejectionTranslation#object refers to the inverse side field Aqarmap\Bundle\ListingBundle\Entity\Rejection#translations which does not exist.
Aqarmap\Bundle\ListingBundle\Entity\ListingRateReasons No errors.
Aqarmap\Bundle\ListingBundle\Entity\CRMLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\ProjectSetting No errors.
Aqarmap\Bundle\ListingBundle\Entity\Search No errors.
Aqarmap\Bundle\ListingBundle\Entity\TopCustomer No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingSearchScoreSetting No errors.
Aqarmap\Bundle\ListingBundle\Entity\CompoundFieldTranslation No errors.
Aqarmap\Bundle\ListingBundle\Entity\LeadsExpectations No errors.
Aqarmap\Bundle\CreditBundle\Entity\PackageTranslation No errors.
Aqarmap\Bundle\CreditBundle\Entity\Service No errors.
Aqarmap\Bundle\CreditBundle\Entity\ChurnsAndExpiry No errors.
Aqarmap\Bundle\CreditBundle\Entity\PackageService No errors.
Aqarmap\Bundle\CreditBundle\Entity\ServiceTranslation No errors.
Aqarmap\Bundle\NotifierBundle\Entity\NotifierSettingValue No errors.
Aqarmap\Bundle\NotifierBundle\Entity\NotifierSetting
  • The field Aqarmap\Bundle\NotifierBundle\Entity\NotifierSetting#values is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\NotifierBundle\Entity\NotifierSettingValue#setting does not contain the required 'inversedBy="values"' attribute.
Aqarmap\Bundle\NotifierBundle\Entity\NotifierStatistic No errors.
Aqarmap\Bundle\BuyerAlertsBundle\Entity\RecentSearches
  • The association Aqarmap\Bundle\BuyerAlertsBundle\Entity\RecentSearches#user refers to the inverse side field Aqarmap\Bundle\UserBundle\Entity\User#recentSearches which does not exist.
  • The association Aqarmap\Bundle\BuyerAlertsBundle\Entity\RecentSearches#location refers to the inverse side field Aqarmap\Bundle\ListingBundle\Entity\Location#recentSearches which does not exist.
  • The association Aqarmap\Bundle\BuyerAlertsBundle\Entity\RecentSearches#propertyType refers to the inverse side field Aqarmap\Bundle\ListingBundle\Entity\PropertyType#recentSearches which does not exist.
Aqarmap\Bundle\BuyerAlertsBundle\Entity\BuyerAlerts
  • The association Aqarmap\Bundle\BuyerAlertsBundle\Entity\BuyerAlerts#user refers to the inverse side field Aqarmap\Bundle\UserBundle\Entity\User#buyerAlerts which does not exist.
  • The association Aqarmap\Bundle\BuyerAlertsBundle\Entity\BuyerAlerts#location refers to the inverse side field Aqarmap\Bundle\ListingBundle\Entity\Location#buyerAlerts which does not exist.
  • The association Aqarmap\Bundle\BuyerAlertsBundle\Entity\BuyerAlerts#propertyType refers to the inverse side field Aqarmap\Bundle\ListingBundle\Entity\PropertyType#buyerAlerts which does not exist.
Aqarmap\Bundle\MortgageBundle\Entity\MortgageRequest No errors.
Aqarmap\Bundle\NeighborhoodBundle\Entity\StatisticsHistory No errors.
Aqarmap\Bundle\DiscussionBundle\Entity\Category No errors.
Aqarmap\Bundle\DiscussionBundle\Entity\CategoryTranslation No errors.
Aqarmap\Bundle\CRMBundle\Entity\StaffCheckIn No errors.
Aqarmap\Bundle\CRMBundle\Entity\CompanyStaff No errors.
Aqarmap\Bundle\CustomerProfilingBundle\Entity\QuestionSetAnswer No errors.
Aqarmap\Bundle\CustomerProfilingBundle\Entity\AnnualSurvey No errors.
Aqarmap\Bundle\CustomerProfilingBundle\Entity\DynamicQuestionChoice No errors.
Aqarmap\Bundle\CustomerProfilingBundle\Entity\DynamicQuestion No errors.
Aqarmap\Bundle\CustomerProfilingBundle\Entity\DynamicQuestionChoiceTranslation No errors.
Aqarmap\Bundle\CustomerProfilingBundle\Entity\DynamicQuestionTranslation No errors.
Aqarmap\Bundle\CustomerProfilingBundle\Entity\QuestionSet No errors.
Aqarmap\Bundle\NotificationBundle\Entity\Notification No errors.
Aqarmap\Bundle\NotificationBundle\Entity\NotificationBag No errors.
Aqarmap\Bundle\PaymentBundle\Entity\PaymentTransactionServiceTranslation No errors.
Aqarmap\Bundle\AnnouncementBundle\Entity\AnnouncementTranslation
  • The association Aqarmap\Bundle\AnnouncementBundle\Entity\AnnouncementTranslation#object refers to the inverse side field Aqarmap\Bundle\AnnouncementBundle\Entity\Announcement#translations which does not exist.
Aqarmap\Bundle\SearchBundle\Entity\SearchResultCombinationFilter No errors.
Aqarmap\Bundle\ValueEngineBundle\Entity\ValueEngineSetting No errors.
Aqarmap\Bundle\ValueEngineBundle\Entity\LocationInsight No errors.
Aqarmap\Bundle\ValueEngineBundle\Entity\DepthProductInsight No errors.
Aqarmap\Bundle\SurveyBundle\Entity\SurveyReason No errors.
Aqarmap\Bundle\SurveyBundle\Entity\SurveyReasonTranslation
  • The association Aqarmap\Bundle\SurveyBundle\Entity\SurveyReasonTranslation#object refers to the inverse side field Aqarmap\Bundle\SurveyBundle\Entity\SurveyReason#translations which does not exist.
Aqarmap\Bundle\SurveyBundle\Entity\Survey
  • The association Aqarmap\Bundle\SurveyBundle\Entity\Survey#user refers to the inverse side field Aqarmap\Bundle\UserBundle\Entity\User#surveys which does not exist.
Aqarmap\Bundle\OTPBundle\Entity\OTP No errors.
Aqarmap\Bundle\FinancialAidsBundle\Entity\FinancialAid No errors.
Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransactionState No errors.
Vich\UploaderBundle\Entity\File No errors.
FOS\UserBundle\Model\User No errors.