Redirect 301 redirect from GET @search (9e72d8)

GET https://testing-eg.am-root.com/en/listing/112-projects-north-coast

Query Metrics

2 Database Queries
2 Different statements
6.46 ms Query time
3 Invalid entities
8 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.03 ms
(62.47%)
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.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.is_hold AS is_hold_82, t0.is_ai_content AS is_ai_content_83, t0.ai_review AS ai_review_84, t0.parent_id AS parent_id_85, t0.relist_id AS relist_id_86, t0.section_id AS section_id_87, t0.property_type_id AS property_type_id_88, t0.location_id AS location_id_89, t0.compound_location_id AS compound_location_id_90, t0.user_id AS user_id_91, t0.compound_field_id AS compound_field_id_92, t0.brochure_id AS brochure_id_93 FROM listings t0 WHERE t0.id = ?
Parameters:
[
  "112"
]
2.42 ms
(37.53%)
1
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  112
]

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
Aqarmap\Bundle\ListingBundle\Entity\ListingTranslation 3
Aqarmap\Bundle\ListingBundle\Entity\Listing 1
Aqarmap\Bundle\ListingBundle\Entity\Section 1
Aqarmap\Bundle\ListingBundle\Entity\PropertyType 1
Aqarmap\Bundle\ListingBundle\Entity\Location 1
Aqarmap\Bundle\UserBundle\Entity\User 1

Entities Mapping

Class Mapping 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\FeatureToggleBundle\Entity\FeatureToggle No errors.
Aqarmap\Bundle\ListingBundle\Entity\PropertyType No errors.
Aqarmap\Bundle\ListingBundle\Entity\Rule No 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.
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\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#geoLocations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User\UserGeoLocation#user does not contain the required 'inversedBy="geoLocations"' 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\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\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\Label No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingRate No errors.
Aqarmap\Bundle\ListingBundle\Entity\Favourite No errors.
Aqarmap\Bundle\ValueEngineBundle\Entity\ValueEngineListingsLocations No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingNote No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingsRatesNote No errors.