Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

8.12 ms Query time

5 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
4.23 ms (52.13%)	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 = ? AND ((t0.deleted_at IS NULL)) Parameters: [`"21"`] View formatted query View runnable query Explain query 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 = ? AND ( (t0.deleted_at IS NULL) ) 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 = '21' AND ((t0.deleted_at IS NULL));
3.89 ms (47.87%)	1	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_.expires_at AS expires_at_32, l0_.deleted_at AS deleted_at_33, l0_.rejected_at AS rejected_at_34, l0_.campaign AS campaign_35, l0_.final_price AS final_price_36, l0_.source_of_sale AS source_of_sale_37, l0_.delete_reason AS delete_reason_38, l0_.delete_reason_details AS delete_reason_details_39, l0_.source AS source_40, l0_.impressions AS impressions_41, l0_.impressions_monthly_count AS impressions_monthly_count_42, l0_.impressions_weekly_count AS impressions_weekly_count_43, l0_.impression_updated_at AS impression_updated_at_44, l0_.price_level AS price_level_45, l0_.compound_status AS compound_status_46, l0_.price_per_meter AS price_per_meter_47, l0_.is_bumped AS is_bumped_48, l0_.is_send_email AS is_send_email_49, l0_.market_property_type AS market_property_type_50, l0_.creation_source AS creation_source_51, l0_.click_through_rate AS click_through_rate_52, l0_.label AS label_53, l0_.is_top_picks AS is_top_picks_54, l0_.contact_rate AS contact_rate_55, l0_.synced AS synced_56, l0_.reference_id AS reference_id_57, l0_.is_pending_featuring AS is_pending_featuring_58, l0_.pending_featuring_type AS pending_featuring_type_59, l0_.rate_status AS rate_status_60, l0_.is_rate_reviewed AS is_rate_reviewed_61, l0_.is_call_request AS is_call_request_62, l0_.is_shown_in_homepage AS is_shown_in_homepage_63, l0_.is_commercial AS is_commercial_64, l0_.is_resale AS is_resale_65, l0_.is_rent AS is_rent_66, l0_.is_primary AS is_primary_67, l0_.is_mortgage_approved AS is_mortgage_approved_68, l0_.meta_title AS meta_title_69, l0_.meta_description AS meta_description_70, l0_.is_mortgage AS is_mortgage_71, l0_.eligible_for_mortgage AS eligible_for_mortgage_72, l0_.property_registration_status AS property_registration_status_73, l0_.advertiser_number AS advertiser_number_74, l0_.authorization_number AS authorization_number_75, l0_.freezed_at AS freezed_at_76, l0_.eligible_for_bumpup AS eligible_for_bumpup_77, l0_.waiting_time AS waiting_time_78, l0_.reference_number AS reference_number_79, l0_.parent_id AS parent_id_80, l0_.relist_id AS relist_id_81, l0_.section_id AS section_id_82, l0_.property_type_id AS property_type_id_83, l0_.location_id AS location_id_84, l0_.compound_location_id AS compound_location_id_85, l0_.user_id AS user_id_86, l0_.compound_field_id AS compound_field_id_87 FROM listings l0_ WHERE (l0_.id IN (?)) AND (l0_.deleted_at IS NULL) ORDER BY FIELD(l0_.id, ?) ASC Parameters: [`[] []`] View formatted query View runnable query Explain query 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_.expires_at AS expires_at_32, l0_.deleted_at AS deleted_at_33, l0_.rejected_at AS rejected_at_34, l0_.campaign AS campaign_35, l0_.final_price AS final_price_36, l0_.source_of_sale AS source_of_sale_37, l0_.delete_reason AS delete_reason_38, l0_.delete_reason_details AS delete_reason_details_39, l0_.source AS source_40, l0_.impressions AS impressions_41, l0_.impressions_monthly_count AS impressions_monthly_count_42, l0_.impressions_weekly_count AS impressions_weekly_count_43, l0_.impression_updated_at AS impression_updated_at_44, l0_.price_level AS price_level_45, l0_.compound_status AS compound_status_46, l0_.price_per_meter AS price_per_meter_47, l0_.is_bumped AS is_bumped_48, l0_.is_send_email AS is_send_email_49, l0_.market_property_type AS market_property_type_50, l0_.creation_source AS creation_source_51, l0_.click_through_rate AS click_through_rate_52, l0_.label AS label_53, l0_.is_top_picks AS is_top_picks_54, l0_.contact_rate AS contact_rate_55, l0_.synced AS synced_56, l0_.reference_id AS reference_id_57, l0_.is_pending_featuring AS is_pending_featuring_58, l0_.pending_featuring_type AS pending_featuring_type_59, l0_.rate_status AS rate_status_60, l0_.is_rate_reviewed AS is_rate_reviewed_61, l0_.is_call_request AS is_call_request_62, l0_.is_shown_in_homepage AS is_shown_in_homepage_63, l0_.is_commercial AS is_commercial_64, l0_.is_resale AS is_resale_65, l0_.is_rent AS is_rent_66, l0_.is_primary AS is_primary_67, l0_.is_mortgage_approved AS is_mortgage_approved_68, l0_.meta_title AS meta_title_69, l0_.meta_description AS meta_description_70, l0_.is_mortgage AS is_mortgage_71, l0_.eligible_for_mortgage AS eligible_for_mortgage_72, l0_.property_registration_status AS property_registration_status_73, l0_.advertiser_number AS advertiser_number_74, l0_.authorization_number AS authorization_number_75, l0_.freezed_at AS freezed_at_76, l0_.eligible_for_bumpup AS eligible_for_bumpup_77, l0_.waiting_time AS waiting_time_78, l0_.reference_number AS reference_number_79, l0_.parent_id AS parent_id_80, l0_.relist_id AS relist_id_81, l0_.section_id AS section_id_82, l0_.property_type_id AS property_type_id_83, l0_.location_id AS location_id_84, l0_.compound_location_id AS compound_location_id_85, l0_.user_id AS user_id_86, l0_.compound_field_id AS compound_field_id_87 FROM listings l0_ WHERE ( l0_.id IN (?) ) AND (l0_.deleted_at IS NULL) ORDER BY FIELD(l0_.id, ?) ASC 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_.expires_at AS expires_at_32, l0_.deleted_at AS deleted_at_33, l0_.rejected_at AS rejected_at_34, l0_.campaign AS campaign_35, l0_.final_price AS final_price_36, l0_.source_of_sale AS source_of_sale_37, l0_.delete_reason AS delete_reason_38, l0_.delete_reason_details AS delete_reason_details_39, l0_.source AS source_40, l0_.impressions AS impressions_41, l0_.impressions_monthly_count AS impressions_monthly_count_42, l0_.impressions_weekly_count AS impressions_weekly_count_43, l0_.impression_updated_at AS impression_updated_at_44, l0_.price_level AS price_level_45, l0_.compound_status AS compound_status_46, l0_.price_per_meter AS price_per_meter_47, l0_.is_bumped AS is_bumped_48, l0_.is_send_email AS is_send_email_49, l0_.market_property_type AS market_property_type_50, l0_.creation_source AS creation_source_51, l0_.click_through_rate AS click_through_rate_52, l0_.label AS label_53, l0_.is_top_picks AS is_top_picks_54, l0_.contact_rate AS contact_rate_55, l0_.synced AS synced_56, l0_.reference_id AS reference_id_57, l0_.is_pending_featuring AS is_pending_featuring_58, l0_.pending_featuring_type AS pending_featuring_type_59, l0_.rate_status AS rate_status_60, l0_.is_rate_reviewed AS is_rate_reviewed_61, l0_.is_call_request AS is_call_request_62, l0_.is_shown_in_homepage AS is_shown_in_homepage_63, l0_.is_commercial AS is_commercial_64, l0_.is_resale AS is_resale_65, l0_.is_rent AS is_rent_66, l0_.is_primary AS is_primary_67, l0_.is_mortgage_approved AS is_mortgage_approved_68, l0_.meta_title AS meta_title_69, l0_.meta_description AS meta_description_70, l0_.is_mortgage AS is_mortgage_71, l0_.eligible_for_mortgage AS eligible_for_mortgage_72, l0_.property_registration_status AS property_registration_status_73, l0_.advertiser_number AS advertiser_number_74, l0_.authorization_number AS authorization_number_75, l0_.freezed_at AS freezed_at_76, l0_.eligible_for_bumpup AS eligible_for_bumpup_77, l0_.waiting_time AS waiting_time_78, l0_.reference_number AS reference_number_79, l0_.parent_id AS parent_id_80, l0_.relist_id AS relist_id_81, l0_.section_id AS section_id_82, l0_.property_type_id AS property_type_id_83, l0_.location_id AS location_id_84, l0_.compound_location_id AS compound_location_id_85, l0_.user_id AS user_id_86, l0_.compound_field_id AS compound_field_id_87 FROM listings l0_ WHERE (l0_.id IN (NULL)) AND (l0_.deleted_at IS NULL) ORDER BY FIELD(l0_.id, NULL) ASC;

Time▼

Count

Info

4.23 ms
(52.13%)

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 = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  "21"
]

View formatted query View runnable query Explain query

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 = ?
  AND (
    (t0.deleted_at IS NULL)
  )

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 = '21' AND ((t0.deleted_at IS NULL));

3.89 ms
(47.87%)

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_.expires_at AS expires_at_32, l0_.deleted_at AS deleted_at_33, l0_.rejected_at AS rejected_at_34, l0_.campaign AS campaign_35, l0_.final_price AS final_price_36, l0_.source_of_sale AS source_of_sale_37, l0_.delete_reason AS delete_reason_38, l0_.delete_reason_details AS delete_reason_details_39, l0_.source AS source_40, l0_.impressions AS impressions_41, l0_.impressions_monthly_count AS impressions_monthly_count_42, l0_.impressions_weekly_count AS impressions_weekly_count_43, l0_.impression_updated_at AS impression_updated_at_44, l0_.price_level AS price_level_45, l0_.compound_status AS compound_status_46, l0_.price_per_meter AS price_per_meter_47, l0_.is_bumped AS is_bumped_48, l0_.is_send_email AS is_send_email_49, l0_.market_property_type AS market_property_type_50, l0_.creation_source AS creation_source_51, l0_.click_through_rate AS click_through_rate_52, l0_.label AS label_53, l0_.is_top_picks AS is_top_picks_54, l0_.contact_rate AS contact_rate_55, l0_.synced AS synced_56, l0_.reference_id AS reference_id_57, l0_.is_pending_featuring AS is_pending_featuring_58, l0_.pending_featuring_type AS pending_featuring_type_59, l0_.rate_status AS rate_status_60, l0_.is_rate_reviewed AS is_rate_reviewed_61, l0_.is_call_request AS is_call_request_62, l0_.is_shown_in_homepage AS is_shown_in_homepage_63, l0_.is_commercial AS is_commercial_64, l0_.is_resale AS is_resale_65, l0_.is_rent AS is_rent_66, l0_.is_primary AS is_primary_67, l0_.is_mortgage_approved AS is_mortgage_approved_68, l0_.meta_title AS meta_title_69, l0_.meta_description AS meta_description_70, l0_.is_mortgage AS is_mortgage_71, l0_.eligible_for_mortgage AS eligible_for_mortgage_72, l0_.property_registration_status AS property_registration_status_73, l0_.advertiser_number AS advertiser_number_74, l0_.authorization_number AS authorization_number_75, l0_.freezed_at AS freezed_at_76, l0_.eligible_for_bumpup AS eligible_for_bumpup_77, l0_.waiting_time AS waiting_time_78, l0_.reference_number AS reference_number_79, l0_.parent_id AS parent_id_80, l0_.relist_id AS relist_id_81, l0_.section_id AS section_id_82, l0_.property_type_id AS property_type_id_83, l0_.location_id AS location_id_84, l0_.compound_location_id AS compound_location_id_85, l0_.user_id AS user_id_86, l0_.compound_field_id AS compound_field_id_87 FROM listings l0_ WHERE (l0_.id IN (?)) AND (l0_.deleted_at IS NULL) ORDER BY FIELD(l0_.id, ?) ASC

Parameters:

[
  []
  []
]

View formatted query View runnable query Explain query

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_.expires_at AS expires_at_32,
  l0_.deleted_at AS deleted_at_33,
  l0_.rejected_at AS rejected_at_34,
  l0_.campaign AS campaign_35,
  l0_.final_price AS final_price_36,
  l0_.source_of_sale AS source_of_sale_37,
  l0_.delete_reason AS delete_reason_38,
  l0_.delete_reason_details AS delete_reason_details_39,
  l0_.source AS source_40,
  l0_.impressions AS impressions_41,
  l0_.impressions_monthly_count AS impressions_monthly_count_42,
  l0_.impressions_weekly_count AS impressions_weekly_count_43,
  l0_.impression_updated_at AS impression_updated_at_44,
  l0_.price_level AS price_level_45,
  l0_.compound_status AS compound_status_46,
  l0_.price_per_meter AS price_per_meter_47,
  l0_.is_bumped AS is_bumped_48,
  l0_.is_send_email AS is_send_email_49,
  l0_.market_property_type AS market_property_type_50,
  l0_.creation_source AS creation_source_51,
  l0_.click_through_rate AS click_through_rate_52,
  l0_.label AS label_53,
  l0_.is_top_picks AS is_top_picks_54,
  l0_.contact_rate AS contact_rate_55,
  l0_.synced AS synced_56,
  l0_.reference_id AS reference_id_57,
  l0_.is_pending_featuring AS is_pending_featuring_58,
  l0_.pending_featuring_type AS pending_featuring_type_59,
  l0_.rate_status AS rate_status_60,
  l0_.is_rate_reviewed AS is_rate_reviewed_61,
  l0_.is_call_request AS is_call_request_62,
  l0_.is_shown_in_homepage AS is_shown_in_homepage_63,
  l0_.is_commercial AS is_commercial_64,
  l0_.is_resale AS is_resale_65,
  l0_.is_rent AS is_rent_66,
  l0_.is_primary AS is_primary_67,
  l0_.is_mortgage_approved AS is_mortgage_approved_68,
  l0_.meta_title AS meta_title_69,
  l0_.meta_description AS meta_description_70,
  l0_.is_mortgage AS is_mortgage_71,
  l0_.eligible_for_mortgage AS eligible_for_mortgage_72,
  l0_.property_registration_status AS property_registration_status_73,
  l0_.advertiser_number AS advertiser_number_74,
  l0_.authorization_number AS authorization_number_75,
  l0_.freezed_at AS freezed_at_76,
  l0_.eligible_for_bumpup AS eligible_for_bumpup_77,
  l0_.waiting_time AS waiting_time_78,
  l0_.reference_number AS reference_number_79,
  l0_.parent_id AS parent_id_80,
  l0_.relist_id AS relist_id_81,
  l0_.section_id AS section_id_82,
  l0_.property_type_id AS property_type_id_83,
  l0_.location_id AS location_id_84,
  l0_.compound_location_id AS compound_location_id_85,
  l0_.user_id AS user_id_86,
  l0_.compound_field_id AS compound_field_id_87
FROM
  listings l0_
WHERE
  (
    l0_.id IN (?)
  )
  AND (l0_.deleted_at IS NULL)
ORDER BY
  FIELD(l0_.id, ?) ASC

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_.expires_at AS expires_at_32, l0_.deleted_at AS deleted_at_33, l0_.rejected_at AS rejected_at_34, l0_.campaign AS campaign_35, l0_.final_price AS final_price_36, l0_.source_of_sale AS source_of_sale_37, l0_.delete_reason AS delete_reason_38, l0_.delete_reason_details AS delete_reason_details_39, l0_.source AS source_40, l0_.impressions AS impressions_41, l0_.impressions_monthly_count AS impressions_monthly_count_42, l0_.impressions_weekly_count AS impressions_weekly_count_43, l0_.impression_updated_at AS impression_updated_at_44, l0_.price_level AS price_level_45, l0_.compound_status AS compound_status_46, l0_.price_per_meter AS price_per_meter_47, l0_.is_bumped AS is_bumped_48, l0_.is_send_email AS is_send_email_49, l0_.market_property_type AS market_property_type_50, l0_.creation_source AS creation_source_51, l0_.click_through_rate AS click_through_rate_52, l0_.label AS label_53, l0_.is_top_picks AS is_top_picks_54, l0_.contact_rate AS contact_rate_55, l0_.synced AS synced_56, l0_.reference_id AS reference_id_57, l0_.is_pending_featuring AS is_pending_featuring_58, l0_.pending_featuring_type AS pending_featuring_type_59, l0_.rate_status AS rate_status_60, l0_.is_rate_reviewed AS is_rate_reviewed_61, l0_.is_call_request AS is_call_request_62, l0_.is_shown_in_homepage AS is_shown_in_homepage_63, l0_.is_commercial AS is_commercial_64, l0_.is_resale AS is_resale_65, l0_.is_rent AS is_rent_66, l0_.is_primary AS is_primary_67, l0_.is_mortgage_approved AS is_mortgage_approved_68, l0_.meta_title AS meta_title_69, l0_.meta_description AS meta_description_70, l0_.is_mortgage AS is_mortgage_71, l0_.eligible_for_mortgage AS eligible_for_mortgage_72, l0_.property_registration_status AS property_registration_status_73, l0_.advertiser_number AS advertiser_number_74, l0_.authorization_number AS authorization_number_75, l0_.freezed_at AS freezed_at_76, l0_.eligible_for_bumpup AS eligible_for_bumpup_77, l0_.waiting_time AS waiting_time_78, l0_.reference_number AS reference_number_79, l0_.parent_id AS parent_id_80, l0_.relist_id AS relist_id_81, l0_.section_id AS section_id_82, l0_.property_type_id AS property_type_id_83, l0_.location_id AS location_id_84, l0_.compound_location_id AS compound_location_id_85, l0_.user_id AS user_id_86, l0_.compound_field_id AS compound_field_id_87 FROM listings l0_ WHERE (l0_.id IN (NULL)) AND (l0_.deleted_at IS NULL) ORDER BY FIELD(l0_.id, NULL) ASC;

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\ListingNote	No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingRate	No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingRateReasons	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\ValueEngineBundle\Entity\ValueEngineListingsLocations	No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingsRatesNote	No errors.

Symfony Profiler

http://moonshot.testing-eg.svc.cluster.local/api/v2/listing/21/related-listings

Configuration Settings

Theme