Query Metrics
1
Database Queries
1
Different statements
3.23 ms
Query time
19
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.23 ms |
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, l0_.address AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.amenities AS amenities_41, l0_.source AS source_42, l0_.impressions AS impressions_43, l0_.impressions_monthly_count AS impressions_monthly_count_44, l0_.impressions_weekly_count AS impressions_weekly_count_45, l0_.impression_updated_at AS impression_updated_at_46, l0_.price_level AS price_level_47, l0_.compound_status AS compound_status_48, l0_.price_per_meter AS price_per_meter_49, l0_.is_bumped AS is_bumped_50, l0_.is_send_email AS is_send_email_51, l0_.is_availability_email_sent AS is_availability_email_sent_52, l0_.market_property_type AS market_property_type_53, l0_.creation_source AS creation_source_54, l0_.click_through_rate AS click_through_rate_55, l0_.label AS label_56, l0_.is_top_picks AS is_top_picks_57, l0_.contact_rate AS contact_rate_58, l0_.synced AS synced_59, l0_.reference_id AS reference_id_60, l0_.is_pending_featuring AS is_pending_featuring_61, l0_.pending_featuring_type AS pending_featuring_type_62, l0_.rate_status AS rate_status_63, l0_.is_rate_reviewed AS is_rate_reviewed_64, l0_.is_call_request AS is_call_request_65, l0_.is_shown_in_homepage AS is_shown_in_homepage_66, l0_.is_commercial AS is_commercial_67, l0_.is_resale AS is_resale_68, l0_.is_rent AS is_rent_69, l0_.is_primary AS is_primary_70, l0_.is_mortgage_approved AS is_mortgage_approved_71, l0_.meta_title AS meta_title_72, l0_.meta_description AS meta_description_73, l0_.is_mortgage AS is_mortgage_74, l0_.eligible_for_mortgage AS eligible_for_mortgage_75, l0_.property_registration_status AS property_registration_status_76, l0_.advertiser_number AS advertiser_number_77, l0_.authorization_number AS authorization_number_78, l0_.freezed_at AS freezed_at_79, l0_.eligible_for_bumpup AS eligible_for_bumpup_80, l0_.waiting_time AS waiting_time_81, l0_.reference_number AS reference_number_82, l0_.is_hold AS is_hold_83, l0_.is_ai_content AS is_ai_content_84, l0_.ai_review AS ai_review_85, l0_.rating_review_status AS rating_review_status_86, l0_.parent_id AS parent_id_87, l0_.relist_id AS relist_id_88, l0_.section_id AS section_id_89, l0_.property_type_id AS property_type_id_90, l0_.location_id AS location_id_91, l0_.compound_location_id AS compound_location_id_92, l0_.user_id AS user_id_93, l0_.compound_field_id AS compound_field_id_94, l0_.brochure_id AS brochure_id_95, l0_.valuation_id AS valuation_id_96 FROM listings l0_ WHERE (l0_.id IN (NULL)) AND (l0_.deleted_at IS NULL) ORDER BY FIELD(l0_.id, NULL) ASC
Parameters:
[] |
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| Aqarmap\Bundle\ListingBundle\Entity\Location |
|
| Aqarmap\Bundle\FeatureToggleBundle\Entity\FeatureToggle | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\PropertyType | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\Rule | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\Listing |
|
| Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationStatistics | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\TopCustomer | No errors. |
| Aqarmap\Bundle\MainBundle\Entity\Setting | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\CompoundLocation | No errors. |
| Aqarmap\Bundle\AnnouncementBundle\Entity\Announcement | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\Section | No errors. |
| Aqarmap\Bundle\SearchBundle\Entity\SearchResultCombinations | 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\UserBundle\Entity\UserInterest | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\LocationPhoto | 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\FeatureToggleBundle\Entity\FeatureToggleRule | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\PropertyTypeTranslation | No errors. |
| Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationCompoundSize | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\CustomField | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\CompoundAveragePrice | No errors. |
| Aqarmap\Bundle\UserBundle\Entity\User |
|
| Aqarmap\Bundle\ListingBundle\Entity\ListingAttribute | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\ListingPhone | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\ListingPhoto | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\ListingTranslation | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\ListingLead | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\ListingFeature | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\ListingNotification | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\Rejection | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\Interaction | No errors. |
| App\Entity\ListingLabel | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\ListingRate | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\Favourite | 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\File | No errors. |
| App\Entity\Listing\ListingValuation | No errors. |
| Aqarmap\Bundle\NeighborhoodBundle\Entity\StatisticsHistory | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\CompoundLocationTranslation | 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\Lead\Lead | No errors. |
| App\Entity\LeadsBank\Proposal |
|
| App\Entity\LeadsBank\UserSegment | No errors. |
| App\Entity\ListingReviewPrompt | No errors. |
| App\Entity\Banners\Banners | No errors. |
| App\Entity\UserLabel | No errors. |
| App\Entity\WaitingList\UserWaitingList | No errors. |
| App\Entity\Subscriptions\UserSubscription |
|
| App\Entity\Subscriptions\SubscriptionCancellationSurveyReason | No errors. |
| App\Entity\Subscriptions\SubscriptionPlan |
|
| App\Entity\Subscriptions\SubscriptionPlanPackage |
|
| App\Entity\Subscriptions\SubscriptionCancellationSurvey | No errors. |
| App\Entity\Subscriptions\SubscriptionPlanTranslation | No errors. |
| App\Entity\Subscriptions\SubscriptionPlanService | No errors. |
| App\Entity\Subscriptions\SubscriptionTransaction | No errors. |
| App\Entity\Valuation\Valuation | No errors. |
| App\Entity\Valuation\ValuationHistory | No errors. |
| App\Entity\Label | No errors. |
| App\Entity\User\UserGeoLocation | No errors. |
| App\Entity\User\UserCard | No errors. |
| App\Entity\User\UserSubAccount |
|
| App\Entity\User\UserAuth | No errors. |
| Aqarmap\Bundle\UserBundle\Entity\BaseUserInterest | No errors. |
| Aqarmap\Bundle\UserBundle\Entity\UserDomain | No errors. |
| Aqarmap\Bundle\UserBundle\Entity\TeamHistory | No errors. |
| Aqarmap\Bundle\UserBundle\Entity\UserCheckin | No errors. |
| Aqarmap\Bundle\UserBundle\Entity\SavedSearch | No errors. |
| Aqarmap\Bundle\UserBundle\Entity\UserDevice | No errors. |
| Aqarmap\Bundle\UserBundle\Entity\Group | No errors. |
| Aqarmap\Bundle\UserBundle\Entity\PersonalInfo | No errors. |
| Aqarmap\Bundle\UserBundle\Entity\UserDeviceCategory | No errors. |
| Aqarmap\Bundle\UserBundle\Entity\Team | No errors. |
| Aqarmap\Bundle\UserBundle\Entity\ZohoUsersLogs | No errors. |
| Aqarmap\Bundle\UserBundle\Entity\UserPackages |
|
| Aqarmap\Bundle\UserBundle\Entity\Device | No errors. |
| Aqarmap\Bundle\UserBundle\Entity\UserServices | No errors. |
| Aqarmap\Bundle\UserBundle\Entity\UserNote | No errors. |
| Aqarmap\Bundle\UserBundle\Entity\DeveloperField | 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 |
|
| Aqarmap\Bundle\ListingBundle\Entity\Lead | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\TargetUserPhoneLead | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\TargetUserLead | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\RejectionTranslation |
|
| Aqarmap\Bundle\ListingBundle\Entity\FreeListing | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\WhatsAppLead | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\UserDomainLead | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\UserDomainMessageLead | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\TopSellerLead | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\Phone | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\TargetUserCallRequestLead | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\UserDomainPhoneLead | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\MessageLead | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\ListingRateReasons | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\CallRequestLead | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\CRMLead | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\ProjectSetting | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\FeaturedCompany | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\Search | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\FeaturedCompanyLead | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\ListingSearchScoreSetting | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\PhoneLead | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\CompoundFieldTranslation | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\CallRequest | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\Photo | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\UserPhone | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\TargetUserMessageLead | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\SimilarListingsLead | No errors. |
| Aqarmap\Bundle\ListingBundle\Entity\LeadsExpectations | No errors. |
| Aqarmap\Bundle\MessageBundle\Entity\Conversation | No errors. |
| Aqarmap\Bundle\MessageBundle\Entity\Recipient | No errors. |
| Aqarmap\Bundle\MessageBundle\Entity\Message | No errors. |
| Aqarmap\Bundle\MessageBundle\Entity\ConversationRecipient | No errors. |
| Aqarmap\Bundle\CreditBundle\Entity\Credit |
|
| Aqarmap\Bundle\CreditBundle\Entity\PackageTranslation | No errors. |
| Aqarmap\Bundle\CreditBundle\Entity\CreditAnalysis | No errors. |
| Aqarmap\Bundle\CreditBundle\Entity\Service | No errors. |
| Aqarmap\Bundle\CreditBundle\Entity\Package |
|
| 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 |
|
| Aqarmap\Bundle\NotifierBundle\Entity\NotifierStatistic | No errors. |
| Aqarmap\Bundle\BuyerAlertsBundle\Entity\RecentSearches |
|
| Aqarmap\Bundle\BuyerAlertsBundle\Entity\BuyerAlerts |
|
| Aqarmap\Bundle\MortgageBundle\Entity\MortgageRequest | No errors. |
| Aqarmap\Bundle\BrokerSalesBundle\Entity\Broker | No errors. |
| Aqarmap\Bundle\BrokerSalesBundle\Entity\Seller | No errors. |
| Aqarmap\Bundle\DiscussionBundle\Entity\Category | No errors. |
| Aqarmap\Bundle\DiscussionBundle\Entity\CommentLike | No errors. |
| Aqarmap\Bundle\DiscussionBundle\Entity\CategoryTranslation | No errors. |
| Aqarmap\Bundle\DiscussionBundle\Entity\Comment | No errors. |
| Aqarmap\Bundle\CRMBundle\Entity\StaffCheckIn | No errors. |
| Aqarmap\Bundle\CRMBundle\Entity\Staff | No errors. |
| Aqarmap\Bundle\CRMBundle\Entity\StaffHistory | No errors. |
| Aqarmap\Bundle\CRMBundle\Entity\CompanyStaff | No errors. |
| Aqarmap\Bundle\CustomerProfilingBundle\Entity\QuestionSetAnswer | No errors. |
| Aqarmap\Bundle\CustomerProfilingBundle\Entity\CustomerProfilingQuestionQueue | 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\ExchangeBundle\Entity\ExchangeRequestUnlock | No errors. |
| Aqarmap\Bundle\PaymentBundle\Entity\SalesAnalysis | No errors. |
| Aqarmap\Bundle\PaymentBundle\Entity\PaymentTransactionServiceTranslation | No errors. |
| Aqarmap\Bundle\PaymentBundle\Entity\Payment |
|
| Aqarmap\Bundle\PaymentBundle\Entity\PaymentTransactionService | No errors. |
| Aqarmap\Bundle\AnnouncementBundle\Entity\AnnouncementTranslation |
|
| Aqarmap\Bundle\SearchBundle\Entity\SearchResultCombinationFilter | No errors. |
| Aqarmap\Bundle\NotificationBundle\Entity\Notification | No errors. |
| Aqarmap\Bundle\NotificationBundle\Entity\NotificationBag | No errors. |
| Aqarmap\Bundle\OTPBundle\Entity\OTP | No errors. |
| Aqarmap\Bundle\FinancialAidsBundle\Entity\FinancialAid | No errors. |
| Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransactionState | No errors. |
| Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction |
|
| Vich\UploaderBundle\Entity\File | No errors. |
| FOS\UserBundle\Model\User | No errors. |