https://testing-eg.am-root.com/ar/listing/155

Query Metrics

1 Database Queries
1 Different statements
4.85 ms Query time
5 Invalid entities

Queries

Group similar statements

# Time Info
1 4.85 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.category AS category_4, t0.pending_photos_status AS pending_photos_status_5, t0.pending_payment_status AS pending_payment_status_6, t0.relist_status AS relist_status_7, t0.seller_role AS seller_role_8, t0.area AS area_9, t0.price AS price_10, t0.address AS address_11, t0.center_lat AS center_lat_12, t0.center_lng AS center_lng_13, t0.status AS status_14, t0.property_view AS property_view_15, t0.payment_method AS payment_method_16, t0.featured AS featured_17, t0.views AS views_18, t0.phone_counter AS phone_counter_19, t0.messages_counter AS messages_counter_20, t0.leads_counter AS leads_counter_21, t0.sent_notifiers AS sent_notifiers_22, t0.relist_counter AS relist_counter_23, t0.ip AS ip_24, t0.video_url AS video_url_25, t0.slug AS slug_26, t0.custom_slug AS custom_slug_27, t0.score AS score_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.pending_status_created_at AS pending_status_created_at_31, t0.published_at AS published_at_32, t0.expires_at AS expires_at_33, t0.deleted_at AS deleted_at_34, t0.rejected_at AS rejected_at_35, t0.campaign AS campaign_36, t0.final_price AS final_price_37, t0.source_of_sale AS source_of_sale_38, t0.delete_reason AS delete_reason_39, t0.delete_reason_details AS delete_reason_details_40, t0.source AS source_41, t0.impressions AS impressions_42, t0.impressions_monthly_count AS impressions_monthly_count_43, t0.impressions_weekly_count AS impressions_weekly_count_44, t0.impression_updated_at AS impression_updated_at_45, t0.price_level AS price_level_46, t0.compound_status AS compound_status_47, t0.price_per_meter AS price_per_meter_48, t0.is_bumped AS is_bumped_49, t0.is_send_email AS is_send_email_50, t0.is_availability_email_sent AS is_availability_email_sent_51, t0.market_property_type AS market_property_type_52, t0.creation_source AS creation_source_53, t0.click_through_rate AS click_through_rate_54, t0.label AS label_55, t0.is_top_picks AS is_top_picks_56, t0.contact_rate AS contact_rate_57, t0.synced AS synced_58, t0.reference_id AS reference_id_59, t0.is_pending_featuring AS is_pending_featuring_60, t0.pending_featuring_type AS pending_featuring_type_61, t0.rate_status AS rate_status_62, t0.is_rate_reviewed AS is_rate_reviewed_63, t0.is_call_request AS is_call_request_64, t0.is_shown_in_homepage AS is_shown_in_homepage_65, t0.is_commercial AS is_commercial_66, t0.is_resale AS is_resale_67, t0.is_rent AS is_rent_68, t0.is_primary AS is_primary_69, t0.is_mortgage_approved AS is_mortgage_approved_70, t0.meta_title AS meta_title_71, t0.meta_description AS meta_description_72, t0.is_mortgage AS is_mortgage_73, t0.eligible_for_mortgage AS eligible_for_mortgage_74, t0.property_registration_status AS property_registration_status_75, t0.advertiser_number AS advertiser_number_76, t0.authorization_number AS authorization_number_77, t0.freezed_at AS freezed_at_78, t0.eligible_for_bumpup AS eligible_for_bumpup_79, t0.waiting_time AS waiting_time_80, t0.reference_number AS reference_number_81, t0.parent_id AS parent_id_82, t0.relist_id AS relist_id_83, t0.section_id AS section_id_84, t0.property_type_id AS property_type_id_85, t0.location_id AS location_id_86, t0.compound_location_id AS compound_location_id_87, t0.user_id AS user_id_88, t0.compound_field_id AS compound_field_id_89, t0.brochure_id AS brochure_id_90 FROM listings t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "155"
]

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 No errors.
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\NeighborhoodBundle\Entity\LocationStatistics No errors.
Aqarmap\Bundle\ListingBundle\Entity\TopCustomer 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\MainBundle\Entity\CustomParagraph 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\LocationSupplyDemand No errors.
Aqarmap\Bundle\ListingBundle\Entity\CompoundField No errors.
Aqarmap\Bundle\ListingBundle\Entity\File 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.