https://testing-eg.am-root.com/454

Query Metrics

2 Database Queries
2 Different statements
5.52 ms Query time
6 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.03 ms
(54.76%)
1
SELECT COUNT(l0_.id) AS sclr_0 FROM leads l0_ WHERE l0_.user_ip = ? AND l0_.created_at >= ?
Parameters:
[
  "192.168.5.202"
  "2024-09-29 03:06:37"
]
2.50 ms
(45.24%)
1
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.market_property_type AS market_property_type_51, t0.creation_source AS creation_source_52, t0.click_through_rate AS click_through_rate_53, t0.label AS label_54, t0.is_top_picks AS is_top_picks_55, t0.contact_rate AS contact_rate_56, t0.synced AS synced_57, t0.reference_id AS reference_id_58, t0.is_pending_featuring AS is_pending_featuring_59, t0.pending_featuring_type AS pending_featuring_type_60, t0.rate_status AS rate_status_61, t0.is_rate_reviewed AS is_rate_reviewed_62, t0.is_call_request AS is_call_request_63, t0.is_shown_in_homepage AS is_shown_in_homepage_64, t0.is_commercial AS is_commercial_65, t0.is_resale AS is_resale_66, t0.is_rent AS is_rent_67, t0.is_primary AS is_primary_68, t0.is_mortgage_approved AS is_mortgage_approved_69, t0.meta_title AS meta_title_70, t0.meta_description AS meta_description_71, t0.is_mortgage AS is_mortgage_72, t0.eligible_for_mortgage AS eligible_for_mortgage_73, t0.property_registration_status AS property_registration_status_74, t0.advertiser_number AS advertiser_number_75, t0.authorization_number AS authorization_number_76, t0.freezed_at AS freezed_at_77, t0.eligible_for_bumpup AS eligible_for_bumpup_78, t0.waiting_time AS waiting_time_79, t0.reference_number AS reference_number_80, t0.parent_id AS parent_id_81, t0.relist_id AS relist_id_82, t0.section_id AS section_id_83, t0.property_type_id AS property_type_id_84, t0.location_id AS location_id_85, t0.compound_location_id AS compound_location_id_86, t0.user_id AS user_id_87, t0.compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0.id = ?
Parameters:
[
  "454"
]

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\LocationSupplyDemand No errors.
Aqarmap\Bundle\ListingBundle\Entity\CompoundField 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.