Query Metrics
68
Database Queries
22
Different statements
155.08 ms
Query time
6
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 3.73 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.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:
[
485
]
|
2 | 3.27 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.listing_id AS listing_id_3, t0.custome_field_id AS custome_field_id_4 FROM listings_attributes t0 WHERE t0.listing_id = ?
Parameters:
[
485
]
|
3 | 2.02 ms |
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
Parameters:
[
485
]
|
4 | 1.76 ms |
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
Parameters:
[
485
]
|
5 | 2.08 ms |
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
Parameters:
[
485
]
|
6 | 2.44 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.leads_counter AS leads_counter_22, t0.listings_counter AS listings_counter_23, t0.keyword AS keyword_24, t0.full_path AS full_path_25, t0.reference_id AS reference_id_26, t0.type AS type_27, t0.eligible_for_mortgage AS eligible_for_mortgage_28, t0.is_compound_location AS is_compound_location_29, t0.parent_id AS parent_id_30, t0.location_compound_id AS location_compound_id_31, t0.rating_id AS rating_id_32, t0.listing_id AS listing_id_33 FROM locations t0 WHERE t0.id = ?
Parameters:
[
36
]
|
7 | 2.77 ms |
SELECT l0_.id AS id_0, SUM(((u1_.credit_price * ABS(c2_.amount)) / DATEDIFF(l3_.expires_at, l3_.created_at)) * LEAST(DATEDIFF(?, l3_.created_at), DATEDIFF(l3_.expires_at, l3_.created_at))) AS sclr_1, SUM(l0_.leads_counter) AS sclr_2 FROM listings l0_ LEFT JOIN listings_features l3_ ON l0_.id = l3_.listing_id LEFT JOIN credit_transactions c2_ ON l3_.credit_id = c2_.id LEFT JOIN user_packages u1_ ON c2_.user_package_id = u1_.id WHERE (l0_.id IN (?) AND l0_.leads_counter > ?) AND (l0_.deleted_at IS NULL) GROUP BY l0_.id
Parameters:
[ "2025-01-18 10:58:48" [ 485 ] 0 ] |
8 | 2.88 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.boost_level AS boost_level_44, t0.boost AS boost_45, t0.is_phone_verified AS is_phone_verified_46, t0.auth_identifier AS auth_identifier_47, t0.auth_access_token AS auth_access_token_48, t0.auth_refresh_token AS auth_refresh_token_49, t0.auth_updated_at AS auth_updated_at_50, t0.parent_id AS parent_id_51, t0.logo AS logo_52, t0.personal_photo AS personal_photo_53, t0.company_id AS company_id_54, t0.staff_id AS staff_id_55, t0.team_id AS team_id_56, t0.developerField_id AS developerField_id_57, t0.phone_id AS phone_id_58 FROM users t0 WHERE t0.id = ?
Parameters:
[
3
]
|
9 | 2.33 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
3
]
|
10 | 2.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ?
Parameters:
[
3
]
|
11 | 2.03 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.id DESC
Parameters:
[
3
]
|
12 | 1.91 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.id DESC
Parameters:
[
3
]
|
13 | 1.92 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.main_number DESC, t0.id DESC
Parameters:
[
3
]
|
14 | 2.00 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ?
Parameters:
[
3
]
|
15 | 2.00 ms |
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
Parameters:
[
485
]
|
16 | 1.82 ms |
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
Parameters:
[
485
]
|
17 | 3.43 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.created_at AS created_at_3, t0.expires_at AS expires_at_4, t0.approved_at AS approved_at_5, t0.bump_up_duration AS bump_up_duration_6, t0.bump_up_occurrences AS bump_up_occurrences_7, t0.bumps_count AS bumps_count_8, t0.last_bumped_at AS last_bumped_at_9, t0.paused_at AS paused_at_10, t0.processed AS processed_11, t0.leads_count_snapshot AS leads_count_snapshot_12, t0.next_bump_date AS next_bump_date_13, t0.featuring_status AS featuring_status_14, t0.listing_id AS listing_id_15, t16.id AS id_17, t16.title AS title_18, t16.description AS description_19, t16.category AS category_20, t16.pending_photos_status AS pending_photos_status_21, t16.pending_payment_status AS pending_payment_status_22, t16.relist_status AS relist_status_23, t16.seller_role AS seller_role_24, t16.area AS area_25, t16.price AS price_26, t16.address AS address_27, t16.center_lat AS center_lat_28, t16.center_lng AS center_lng_29, t16.status AS status_30, t16.property_view AS property_view_31, t16.payment_method AS payment_method_32, t16.featured AS featured_33, t16.views AS views_34, t16.phone_counter AS phone_counter_35, t16.messages_counter AS messages_counter_36, t16.leads_counter AS leads_counter_37, t16.sent_notifiers AS sent_notifiers_38, t16.relist_counter AS relist_counter_39, t16.ip AS ip_40, t16.video_url AS video_url_41, t16.slug AS slug_42, t16.custom_slug AS custom_slug_43, t16.score AS score_44, t16.created_at AS created_at_45, t16.updated_at AS updated_at_46, t16.pending_status_created_at AS pending_status_created_at_47, t16.published_at AS published_at_48, t16.expires_at AS expires_at_49, t16.deleted_at AS deleted_at_50, t16.rejected_at AS rejected_at_51, t16.campaign AS campaign_52, t16.final_price AS final_price_53, t16.source_of_sale AS source_of_sale_54, t16.delete_reason AS delete_reason_55, t16.delete_reason_details AS delete_reason_details_56, t16.source AS source_57, t16.impressions AS impressions_58, t16.impressions_monthly_count AS impressions_monthly_count_59, t16.impressions_weekly_count AS impressions_weekly_count_60, t16.impression_updated_at AS impression_updated_at_61, t16.price_level AS price_level_62, t16.compound_status AS compound_status_63, t16.price_per_meter AS price_per_meter_64, t16.is_bumped AS is_bumped_65, t16.is_send_email AS is_send_email_66, t16.market_property_type AS market_property_type_67, t16.creation_source AS creation_source_68, t16.click_through_rate AS click_through_rate_69, t16.label AS label_70, t16.is_top_picks AS is_top_picks_71, t16.contact_rate AS contact_rate_72, t16.synced AS synced_73, t16.reference_id AS reference_id_74, t16.is_pending_featuring AS is_pending_featuring_75, t16.pending_featuring_type AS pending_featuring_type_76, t16.rate_status AS rate_status_77, t16.is_rate_reviewed AS is_rate_reviewed_78, t16.is_call_request AS is_call_request_79, t16.is_shown_in_homepage AS is_shown_in_homepage_80, t16.is_commercial AS is_commercial_81, t16.is_resale AS is_resale_82, t16.is_rent AS is_rent_83, t16.is_primary AS is_primary_84, t16.is_mortgage_approved AS is_mortgage_approved_85, t16.meta_title AS meta_title_86, t16.meta_description AS meta_description_87, t16.is_mortgage AS is_mortgage_88, t16.eligible_for_mortgage AS eligible_for_mortgage_89, t16.property_registration_status AS property_registration_status_90, t16.advertiser_number AS advertiser_number_91, t16.authorization_number AS authorization_number_92, t16.freezed_at AS freezed_at_93, t16.eligible_for_bumpup AS eligible_for_bumpup_94, t16.waiting_time AS waiting_time_95, t16.reference_number AS reference_number_96, t16.parent_id AS parent_id_97, t16.relist_id AS relist_id_98, t16.section_id AS section_id_99, t16.property_type_id AS property_type_id_100, t16.location_id AS location_id_101, t16.compound_location_id AS compound_location_id_102, t16.user_id AS user_id_103, t16.compound_field_id AS compound_field_id_104, t0.credit_id AS credit_id_105, t0.bump_up_owner_id AS bump_up_owner_id_106 FROM listings_features t0 INNER JOIN listings t16 ON t0.listing_id = t16.id AND ((t16.deleted_at IS NULL)) WHERE (((t0.expires_at >= ? AND t0.type != ?) AND t0.type != ?) AND t0.listing_id = ?) ORDER BY t0.id DESC LIMIT 1
Parameters:
[ "2025-01-18 10:58:48" 1 3 485 ] |
18 | 3.23 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.created_at AS created_at_3, t0.expires_at AS expires_at_4, t0.approved_at AS approved_at_5, t0.bump_up_duration AS bump_up_duration_6, t0.bump_up_occurrences AS bump_up_occurrences_7, t0.bumps_count AS bumps_count_8, t0.last_bumped_at AS last_bumped_at_9, t0.paused_at AS paused_at_10, t0.processed AS processed_11, t0.leads_count_snapshot AS leads_count_snapshot_12, t0.next_bump_date AS next_bump_date_13, t0.featuring_status AS featuring_status_14, t0.listing_id AS listing_id_15, t16.id AS id_17, t16.title AS title_18, t16.description AS description_19, t16.category AS category_20, t16.pending_photos_status AS pending_photos_status_21, t16.pending_payment_status AS pending_payment_status_22, t16.relist_status AS relist_status_23, t16.seller_role AS seller_role_24, t16.area AS area_25, t16.price AS price_26, t16.address AS address_27, t16.center_lat AS center_lat_28, t16.center_lng AS center_lng_29, t16.status AS status_30, t16.property_view AS property_view_31, t16.payment_method AS payment_method_32, t16.featured AS featured_33, t16.views AS views_34, t16.phone_counter AS phone_counter_35, t16.messages_counter AS messages_counter_36, t16.leads_counter AS leads_counter_37, t16.sent_notifiers AS sent_notifiers_38, t16.relist_counter AS relist_counter_39, t16.ip AS ip_40, t16.video_url AS video_url_41, t16.slug AS slug_42, t16.custom_slug AS custom_slug_43, t16.score AS score_44, t16.created_at AS created_at_45, t16.updated_at AS updated_at_46, t16.pending_status_created_at AS pending_status_created_at_47, t16.published_at AS published_at_48, t16.expires_at AS expires_at_49, t16.deleted_at AS deleted_at_50, t16.rejected_at AS rejected_at_51, t16.campaign AS campaign_52, t16.final_price AS final_price_53, t16.source_of_sale AS source_of_sale_54, t16.delete_reason AS delete_reason_55, t16.delete_reason_details AS delete_reason_details_56, t16.source AS source_57, t16.impressions AS impressions_58, t16.impressions_monthly_count AS impressions_monthly_count_59, t16.impressions_weekly_count AS impressions_weekly_count_60, t16.impression_updated_at AS impression_updated_at_61, t16.price_level AS price_level_62, t16.compound_status AS compound_status_63, t16.price_per_meter AS price_per_meter_64, t16.is_bumped AS is_bumped_65, t16.is_send_email AS is_send_email_66, t16.market_property_type AS market_property_type_67, t16.creation_source AS creation_source_68, t16.click_through_rate AS click_through_rate_69, t16.label AS label_70, t16.is_top_picks AS is_top_picks_71, t16.contact_rate AS contact_rate_72, t16.synced AS synced_73, t16.reference_id AS reference_id_74, t16.is_pending_featuring AS is_pending_featuring_75, t16.pending_featuring_type AS pending_featuring_type_76, t16.rate_status AS rate_status_77, t16.is_rate_reviewed AS is_rate_reviewed_78, t16.is_call_request AS is_call_request_79, t16.is_shown_in_homepage AS is_shown_in_homepage_80, t16.is_commercial AS is_commercial_81, t16.is_resale AS is_resale_82, t16.is_rent AS is_rent_83, t16.is_primary AS is_primary_84, t16.is_mortgage_approved AS is_mortgage_approved_85, t16.meta_title AS meta_title_86, t16.meta_description AS meta_description_87, t16.is_mortgage AS is_mortgage_88, t16.eligible_for_mortgage AS eligible_for_mortgage_89, t16.property_registration_status AS property_registration_status_90, t16.advertiser_number AS advertiser_number_91, t16.authorization_number AS authorization_number_92, t16.freezed_at AS freezed_at_93, t16.eligible_for_bumpup AS eligible_for_bumpup_94, t16.waiting_time AS waiting_time_95, t16.reference_number AS reference_number_96, t16.parent_id AS parent_id_97, t16.relist_id AS relist_id_98, t16.section_id AS section_id_99, t16.property_type_id AS property_type_id_100, t16.location_id AS location_id_101, t16.compound_location_id AS compound_location_id_102, t16.user_id AS user_id_103, t16.compound_field_id AS compound_field_id_104, t0.credit_id AS credit_id_105, t0.bump_up_owner_id AS bump_up_owner_id_106 FROM listings_features t0 INNER JOIN listings t16 ON t0.listing_id = t16.id AND ((t16.deleted_at IS NULL)) WHERE ((t0.type != ? AND t0.type != ?) AND t0.listing_id = ?) ORDER BY t0.id DESC LIMIT 1
Parameters:
[ 1 3 485 ] |
19 | 1.93 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.main AS main_6, t0.searchable AS searchable_7, t0.slug AS slug_8, t0.synced AS synced_9, t0.reference_id AS reference_id_10, t0.meta_search_description AS meta_search_description_11 FROM sections t0 WHERE t0.id = ?
Parameters:
[
2
]
|
20 | 2.05 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.private AS private_4, t0.level AS level_5, t0._left AS _left_6, t0._right AS _right_7, t0.root AS root_8, t0.compound_related AS compound_related_9, t0.reference_id AS reference_id_10, t0.exchangeable AS exchangeable_11, t0.is_evaluable AS is_evaluable_12, t0.synced AS synced_13, t0.searchable AS searchable_14, t0.deleted_at AS deleted_at_15, t0.custom_order AS custom_order_16, t0.parent_id AS parent_id_17 FROM property_types t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
3
]
|
21 | 2.99 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.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:
[
4
]
|
22 | 2.15 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.listing_id AS listing_id_3, t0.custome_field_id AS custome_field_id_4 FROM listings_attributes t0 WHERE t0.listing_id = ?
Parameters:
[
4
]
|
23 | 1.89 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.type AS type_4, t0.options AS options_5, t0.similar_identifier AS similar_identifier_6, t0.required AS required_7 FROM custom_fields t0 WHERE t0.id = ?
Parameters:
[
1
]
|
24 | 1.77 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.type AS type_4, t0.options AS options_5, t0.similar_identifier AS similar_identifier_6, t0.required AS required_7 FROM custom_fields t0 WHERE t0.id = ?
Parameters:
[
2
]
|
25 | 1.88 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.type AS type_4, t0.options AS options_5, t0.similar_identifier AS similar_identifier_6, t0.required AS required_7 FROM custom_fields t0 WHERE t0.id = ?
Parameters:
[
3
]
|
26 | 1.91 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.type AS type_4, t0.options AS options_5, t0.similar_identifier AS similar_identifier_6, t0.required AS required_7 FROM custom_fields t0 WHERE t0.id = ?
Parameters:
[
4
]
|
27 | 1.88 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.type AS type_4, t0.options AS options_5, t0.similar_identifier AS similar_identifier_6, t0.required AS required_7 FROM custom_fields t0 WHERE t0.id = ?
Parameters:
[
5
]
|
28 | 2.05 ms |
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
Parameters:
[
4
]
|
29 | 1.91 ms |
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ?
Parameters:
[
4
]
|
30 | 1.97 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.hash AS hash_4 FROM photos t0 WHERE t0.id = ?
Parameters:
[
224
]
|
31 | 2.35 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.leads_counter AS leads_counter_22, t0.listings_counter AS listings_counter_23, t0.keyword AS keyword_24, t0.full_path AS full_path_25, t0.reference_id AS reference_id_26, t0.type AS type_27, t0.eligible_for_mortgage AS eligible_for_mortgage_28, t0.is_compound_location AS is_compound_location_29, t0.parent_id AS parent_id_30, t0.location_compound_id AS location_compound_id_31, t0.rating_id AS rating_id_32, t0.listing_id AS listing_id_33 FROM locations t0 WHERE t0.id = ?
Parameters:
[
38
]
|
32 | 2.52 ms |
SELECT l0_.id AS id_0, SUM(((u1_.credit_price * ABS(c2_.amount)) / DATEDIFF(l3_.expires_at, l3_.created_at)) * LEAST(DATEDIFF(?, l3_.created_at), DATEDIFF(l3_.expires_at, l3_.created_at))) AS sclr_1, SUM(l0_.leads_counter) AS sclr_2 FROM listings l0_ LEFT JOIN listings_features l3_ ON l0_.id = l3_.listing_id LEFT JOIN credit_transactions c2_ ON l3_.credit_id = c2_.id LEFT JOIN user_packages u1_ ON c2_.user_package_id = u1_.id WHERE (l0_.id IN (?) AND l0_.leads_counter > ?) AND (l0_.deleted_at IS NULL) GROUP BY l0_.id
Parameters:
[ "2025-01-18 10:58:48" [ 4 ] 0 ] |
33 | 3.00 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.boost_level AS boost_level_44, t0.boost AS boost_45, t0.is_phone_verified AS is_phone_verified_46, t0.auth_identifier AS auth_identifier_47, t0.auth_access_token AS auth_access_token_48, t0.auth_refresh_token AS auth_refresh_token_49, t0.auth_updated_at AS auth_updated_at_50, t0.parent_id AS parent_id_51, t0.logo AS logo_52, t0.personal_photo AS personal_photo_53, t0.company_id AS company_id_54, t0.staff_id AS staff_id_55, t0.team_id AS team_id_56, t0.developerField_id AS developerField_id_57, t0.phone_id AS phone_id_58 FROM users t0 WHERE t0.id = ?
Parameters:
[
1
]
|
34 | 2.52 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1
]
|
35 | 2.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ?
Parameters:
[
1
]
|
36 | 2.20 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.id DESC
Parameters:
[
1
]
|
37 | 2.04 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.id DESC
Parameters:
[
1
]
|
38 | 1.87 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.main_number DESC, t0.id DESC
Parameters:
[
1
]
|
39 | 1.86 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.main_number DESC, t0.id DESC
Parameters:
[
1
]
|
40 | 2.04 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.id DESC LIMIT 2
Parameters:
[
1
]
|
41 | 1.85 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.original_phone_number AS original_phone_number_3, t0.country_code AS country_code_4, t0.ip AS ip_5, t0.country AS country_6, t0.created_at AS created_at_7 FROM phones t0 WHERE t0.id = ?
Parameters:
[
1142
]
|
42 | 1.94 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.main_number DESC, t0.id DESC
Parameters:
[
1
]
|
43 | 1.85 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.main_number DESC, t0.id DESC
Parameters:
[
1
]
|
44 | 1.85 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.id DESC LIMIT 2
Parameters:
[
1
]
|
45 | 1.63 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.original_phone_number AS original_phone_number_3, t0.country_code AS country_code_4, t0.ip AS ip_5, t0.country AS country_6, t0.created_at AS created_at_7 FROM phones t0 WHERE t0.id = ?
Parameters:
[
628
]
|
46 | 1.94 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.hash AS hash_4 FROM photos t0 WHERE t0.id = ?
Parameters:
[
398
]
|
47 | 3.36 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.created_at AS created_at_3, t0.expires_at AS expires_at_4, t0.approved_at AS approved_at_5, t0.bump_up_duration AS bump_up_duration_6, t0.bump_up_occurrences AS bump_up_occurrences_7, t0.bumps_count AS bumps_count_8, t0.last_bumped_at AS last_bumped_at_9, t0.paused_at AS paused_at_10, t0.processed AS processed_11, t0.leads_count_snapshot AS leads_count_snapshot_12, t0.next_bump_date AS next_bump_date_13, t0.featuring_status AS featuring_status_14, t0.listing_id AS listing_id_15, t16.id AS id_17, t16.title AS title_18, t16.description AS description_19, t16.category AS category_20, t16.pending_photos_status AS pending_photos_status_21, t16.pending_payment_status AS pending_payment_status_22, t16.relist_status AS relist_status_23, t16.seller_role AS seller_role_24, t16.area AS area_25, t16.price AS price_26, t16.address AS address_27, t16.center_lat AS center_lat_28, t16.center_lng AS center_lng_29, t16.status AS status_30, t16.property_view AS property_view_31, t16.payment_method AS payment_method_32, t16.featured AS featured_33, t16.views AS views_34, t16.phone_counter AS phone_counter_35, t16.messages_counter AS messages_counter_36, t16.leads_counter AS leads_counter_37, t16.sent_notifiers AS sent_notifiers_38, t16.relist_counter AS relist_counter_39, t16.ip AS ip_40, t16.video_url AS video_url_41, t16.slug AS slug_42, t16.custom_slug AS custom_slug_43, t16.score AS score_44, t16.created_at AS created_at_45, t16.updated_at AS updated_at_46, t16.pending_status_created_at AS pending_status_created_at_47, t16.published_at AS published_at_48, t16.expires_at AS expires_at_49, t16.deleted_at AS deleted_at_50, t16.rejected_at AS rejected_at_51, t16.campaign AS campaign_52, t16.final_price AS final_price_53, t16.source_of_sale AS source_of_sale_54, t16.delete_reason AS delete_reason_55, t16.delete_reason_details AS delete_reason_details_56, t16.source AS source_57, t16.impressions AS impressions_58, t16.impressions_monthly_count AS impressions_monthly_count_59, t16.impressions_weekly_count AS impressions_weekly_count_60, t16.impression_updated_at AS impression_updated_at_61, t16.price_level AS price_level_62, t16.compound_status AS compound_status_63, t16.price_per_meter AS price_per_meter_64, t16.is_bumped AS is_bumped_65, t16.is_send_email AS is_send_email_66, t16.market_property_type AS market_property_type_67, t16.creation_source AS creation_source_68, t16.click_through_rate AS click_through_rate_69, t16.label AS label_70, t16.is_top_picks AS is_top_picks_71, t16.contact_rate AS contact_rate_72, t16.synced AS synced_73, t16.reference_id AS reference_id_74, t16.is_pending_featuring AS is_pending_featuring_75, t16.pending_featuring_type AS pending_featuring_type_76, t16.rate_status AS rate_status_77, t16.is_rate_reviewed AS is_rate_reviewed_78, t16.is_call_request AS is_call_request_79, t16.is_shown_in_homepage AS is_shown_in_homepage_80, t16.is_commercial AS is_commercial_81, t16.is_resale AS is_resale_82, t16.is_rent AS is_rent_83, t16.is_primary AS is_primary_84, t16.is_mortgage_approved AS is_mortgage_approved_85, t16.meta_title AS meta_title_86, t16.meta_description AS meta_description_87, t16.is_mortgage AS is_mortgage_88, t16.eligible_for_mortgage AS eligible_for_mortgage_89, t16.property_registration_status AS property_registration_status_90, t16.advertiser_number AS advertiser_number_91, t16.authorization_number AS authorization_number_92, t16.freezed_at AS freezed_at_93, t16.eligible_for_bumpup AS eligible_for_bumpup_94, t16.waiting_time AS waiting_time_95, t16.reference_number AS reference_number_96, t16.parent_id AS parent_id_97, t16.relist_id AS relist_id_98, t16.section_id AS section_id_99, t16.property_type_id AS property_type_id_100, t16.location_id AS location_id_101, t16.compound_location_id AS compound_location_id_102, t16.user_id AS user_id_103, t16.compound_field_id AS compound_field_id_104, t0.credit_id AS credit_id_105, t0.bump_up_owner_id AS bump_up_owner_id_106 FROM listings_features t0 INNER JOIN listings t16 ON t0.listing_id = t16.id AND ((t16.deleted_at IS NULL)) WHERE (((t0.expires_at >= ? AND t0.type != ?) AND t0.type != ?) AND t0.listing_id = ?) ORDER BY t0.id DESC LIMIT 1
Parameters:
[ "2025-01-18 10:58:48" 1 3 4 ] |
48 | 3.47 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.created_at AS created_at_3, t0.expires_at AS expires_at_4, t0.approved_at AS approved_at_5, t0.bump_up_duration AS bump_up_duration_6, t0.bump_up_occurrences AS bump_up_occurrences_7, t0.bumps_count AS bumps_count_8, t0.last_bumped_at AS last_bumped_at_9, t0.paused_at AS paused_at_10, t0.processed AS processed_11, t0.leads_count_snapshot AS leads_count_snapshot_12, t0.next_bump_date AS next_bump_date_13, t0.featuring_status AS featuring_status_14, t0.listing_id AS listing_id_15, t16.id AS id_17, t16.title AS title_18, t16.description AS description_19, t16.category AS category_20, t16.pending_photos_status AS pending_photos_status_21, t16.pending_payment_status AS pending_payment_status_22, t16.relist_status AS relist_status_23, t16.seller_role AS seller_role_24, t16.area AS area_25, t16.price AS price_26, t16.address AS address_27, t16.center_lat AS center_lat_28, t16.center_lng AS center_lng_29, t16.status AS status_30, t16.property_view AS property_view_31, t16.payment_method AS payment_method_32, t16.featured AS featured_33, t16.views AS views_34, t16.phone_counter AS phone_counter_35, t16.messages_counter AS messages_counter_36, t16.leads_counter AS leads_counter_37, t16.sent_notifiers AS sent_notifiers_38, t16.relist_counter AS relist_counter_39, t16.ip AS ip_40, t16.video_url AS video_url_41, t16.slug AS slug_42, t16.custom_slug AS custom_slug_43, t16.score AS score_44, t16.created_at AS created_at_45, t16.updated_at AS updated_at_46, t16.pending_status_created_at AS pending_status_created_at_47, t16.published_at AS published_at_48, t16.expires_at AS expires_at_49, t16.deleted_at AS deleted_at_50, t16.rejected_at AS rejected_at_51, t16.campaign AS campaign_52, t16.final_price AS final_price_53, t16.source_of_sale AS source_of_sale_54, t16.delete_reason AS delete_reason_55, t16.delete_reason_details AS delete_reason_details_56, t16.source AS source_57, t16.impressions AS impressions_58, t16.impressions_monthly_count AS impressions_monthly_count_59, t16.impressions_weekly_count AS impressions_weekly_count_60, t16.impression_updated_at AS impression_updated_at_61, t16.price_level AS price_level_62, t16.compound_status AS compound_status_63, t16.price_per_meter AS price_per_meter_64, t16.is_bumped AS is_bumped_65, t16.is_send_email AS is_send_email_66, t16.market_property_type AS market_property_type_67, t16.creation_source AS creation_source_68, t16.click_through_rate AS click_through_rate_69, t16.label AS label_70, t16.is_top_picks AS is_top_picks_71, t16.contact_rate AS contact_rate_72, t16.synced AS synced_73, t16.reference_id AS reference_id_74, t16.is_pending_featuring AS is_pending_featuring_75, t16.pending_featuring_type AS pending_featuring_type_76, t16.rate_status AS rate_status_77, t16.is_rate_reviewed AS is_rate_reviewed_78, t16.is_call_request AS is_call_request_79, t16.is_shown_in_homepage AS is_shown_in_homepage_80, t16.is_commercial AS is_commercial_81, t16.is_resale AS is_resale_82, t16.is_rent AS is_rent_83, t16.is_primary AS is_primary_84, t16.is_mortgage_approved AS is_mortgage_approved_85, t16.meta_title AS meta_title_86, t16.meta_description AS meta_description_87, t16.is_mortgage AS is_mortgage_88, t16.eligible_for_mortgage AS eligible_for_mortgage_89, t16.property_registration_status AS property_registration_status_90, t16.advertiser_number AS advertiser_number_91, t16.authorization_number AS authorization_number_92, t16.freezed_at AS freezed_at_93, t16.eligible_for_bumpup AS eligible_for_bumpup_94, t16.waiting_time AS waiting_time_95, t16.reference_number AS reference_number_96, t16.parent_id AS parent_id_97, t16.relist_id AS relist_id_98, t16.section_id AS section_id_99, t16.property_type_id AS property_type_id_100, t16.location_id AS location_id_101, t16.compound_location_id AS compound_location_id_102, t16.user_id AS user_id_103, t16.compound_field_id AS compound_field_id_104, t0.credit_id AS credit_id_105, t0.bump_up_owner_id AS bump_up_owner_id_106 FROM listings_features t0 INNER JOIN listings t16 ON t0.listing_id = t16.id AND ((t16.deleted_at IS NULL)) WHERE ((t0.type != ? AND t0.type != ?) AND t0.listing_id = ?) ORDER BY t0.id DESC LIMIT 1
Parameters:
[ 1 3 4 ] |
49 | 2.11 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE (t0.has_whatsApp = ? AND t0.user_id = ?) ORDER BY t0.id DESC
Parameters:
[ 1 1 ] |
50 | 2.16 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE (t0.has_whatsApp = ? AND t0.user_id = ?) ORDER BY t0.id DESC
Parameters:
[ 1 1 ] |
51 | 1.99 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.main AS main_6, t0.searchable AS searchable_7, t0.slug AS slug_8, t0.synced AS synced_9, t0.reference_id AS reference_id_10, t0.meta_search_description AS meta_search_description_11 FROM sections t0 WHERE t0.id = ?
Parameters:
[
3
]
|
52 | 2.14 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.private AS private_4, t0.level AS level_5, t0._left AS _left_6, t0._right AS _right_7, t0.root AS root_8, t0.compound_related AS compound_related_9, t0.reference_id AS reference_id_10, t0.exchangeable AS exchangeable_11, t0.is_evaluable AS is_evaluable_12, t0.synced AS synced_13, t0.searchable AS searchable_14, t0.deleted_at AS deleted_at_15, t0.custom_order AS custom_order_16, t0.parent_id AS parent_id_17 FROM property_types t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
2
]
|
53 | 2.63 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.leads_counter AS leads_counter_22, t0.listings_counter AS listings_counter_23, t0.keyword AS keyword_24, t0.full_path AS full_path_25, t0.reference_id AS reference_id_26, t0.type AS type_27, t0.eligible_for_mortgage AS eligible_for_mortgage_28, t0.is_compound_location AS is_compound_location_29, t0.parent_id AS parent_id_30, t0.location_compound_id AS location_compound_id_31, t0.rating_id AS rating_id_32, t0.listing_id AS listing_id_33 FROM locations t0 WHERE t0.id = ?
Parameters:
[
37
]
|
54 | 2.53 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.leads_counter AS leads_counter_22, t0.listings_counter AS listings_counter_23, t0.keyword AS keyword_24, t0.full_path AS full_path_25, t0.reference_id AS reference_id_26, t0.type AS type_27, t0.eligible_for_mortgage AS eligible_for_mortgage_28, t0.is_compound_location AS is_compound_location_29, t0.parent_id AS parent_id_30, t0.location_compound_id AS location_compound_id_31, t0.rating_id AS rating_id_32, t0.listing_id AS listing_id_33 FROM locations t0 WHERE t0.id = ?
Parameters:
[
31
]
|
55 | 2.18 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.main_number DESC, t0.id DESC
Parameters:
[
1
]
|
56 | 2.14 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.main_number DESC, t0.id DESC
Parameters:
[
1
]
|
57 | 2.15 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE (t0.has_whatsApp = ? AND t0.user_id = ?) ORDER BY t0.id DESC
Parameters:
[ 1 1 ] |
58 | 2.74 ms |
SELECT COUNT(*) FROM listings t0 WHERE (t0.status = ? AND t0.user_id = ?) AND ((t0.deleted_at IS NULL))
Parameters:
[ 2 1 ] |
59 | 2.47 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.leads_counter AS leads_counter_22, t0.listings_counter AS listings_counter_23, t0.keyword AS keyword_24, t0.full_path AS full_path_25, t0.reference_id AS reference_id_26, t0.type AS type_27, t0.eligible_for_mortgage AS eligible_for_mortgage_28, t0.is_compound_location AS is_compound_location_29, t0.parent_id AS parent_id_30, t0.location_compound_id AS location_compound_id_31, t0.rating_id AS rating_id_32, t0.listing_id AS listing_id_33 FROM locations t0 WHERE t0.id = ?
Parameters:
[
32
]
|
60 | 3.01 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.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:
[
430
]
|
61 | 2.10 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.listing_id AS listing_id_3, t0.custome_field_id AS custome_field_id_4 FROM listings_attributes t0 WHERE t0.listing_id = ?
Parameters:
[
430
]
|
62 | 2.05 ms |
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
Parameters:
[
430
]
|
63 | 2.08 ms |
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
Parameters:
[
430
]
|
64 | 2.27 ms |
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
Parameters:
[
430
]
|
65 | 2.48 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.leads_counter AS leads_counter_22, t0.listings_counter AS listings_counter_23, t0.keyword AS keyword_24, t0.full_path AS full_path_25, t0.reference_id AS reference_id_26, t0.type AS type_27, t0.eligible_for_mortgage AS eligible_for_mortgage_28, t0.is_compound_location AS is_compound_location_29, t0.parent_id AS parent_id_30, t0.location_compound_id AS location_compound_id_31, t0.rating_id AS rating_id_32, t0.listing_id AS listing_id_33 FROM locations t0 WHERE t0.id = ?
Parameters:
[
44
]
|
66 | 2.50 ms |
SELECT l0_.id AS id_0, SUM(((u1_.credit_price * ABS(c2_.amount)) / DATEDIFF(l3_.expires_at, l3_.created_at)) * LEAST(DATEDIFF(?, l3_.created_at), DATEDIFF(l3_.expires_at, l3_.created_at))) AS sclr_1, SUM(l0_.leads_counter) AS sclr_2 FROM listings l0_ LEFT JOIN listings_features l3_ ON l0_.id = l3_.listing_id LEFT JOIN credit_transactions c2_ ON l3_.credit_id = c2_.id LEFT JOIN user_packages u1_ ON c2_.user_package_id = u1_.id WHERE (l0_.id IN (?) AND l0_.leads_counter > ?) AND (l0_.deleted_at IS NULL) GROUP BY l0_.id
Parameters:
[ "2025-01-18 10:58:49" [ 430 ] 0 ] |
67 | 2.55 ms |
SELECT COUNT(*) FROM listings t0 WHERE (t0.status = ? AND t0.user_id = ?) AND ((t0.deleted_at IS NULL))
Parameters:
[ 2 3 ] |
68 | 2.02 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.hash AS hash_4 FROM photos t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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 |
|
App\Entity\Lead\Lead | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\Location |
|
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 |
|
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 |
|
Aqarmap\Bundle\PaymentBundle\Entity\Payment |
|
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. |
Aqarmap\Bundle\ListingBundle\Entity\Photo | No errors. |
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationCompound | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\LocationRating | 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\ListingBundle\Entity\LocationPhoto | No errors. |
Aqarmap\Bundle\DiscussionBundle\Entity\Discussion | No errors. |
Aqarmap\Bundle\ExchangeBundle\Entity\ExchangeRequest | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\SearchTerm | No errors. |
Aqarmap\Bundle\ValueEngineBundle\Entity\ListingInsight | No errors. |
Aqarmap\Bundle\CRMBundle\Entity\Staff | No errors. |
Aqarmap\Bundle\UserBundle\Entity\Team | No errors. |
Aqarmap\Bundle\UserBundle\Entity\DeveloperField | No errors. |
Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction |
|
Aqarmap\Bundle\BrokerSalesBundle\Entity\Seller | No errors. |
Aqarmap\Bundle\BrokerSalesBundle\Entity\Broker | No errors. |
Aqarmap\Bundle\CreditBundle\Entity\CreditAnalysis | No errors. |
Aqarmap\Bundle\PaymentBundle\Entity\SalesAnalysis | No errors. |
Aqarmap\Bundle\UserBundle\Entity\TeamHistory | No errors. |
Aqarmap\Bundle\UserBundle\Entity\UserDevice | No errors. |
Aqarmap\Bundle\ExchangeBundle\Entity\ExchangeRequestUnlock | No errors. |
Aqarmap\Bundle\UserBundle\Entity\UserCheckin | No errors. |
Aqarmap\Bundle\UserBundle\Entity\UserDomain | No errors. |
Aqarmap\Bundle\DiscussionBundle\Entity\Comment | No errors. |
Aqarmap\Bundle\UserBundle\Entity\PersonalInfo | No errors. |
Aqarmap\Bundle\CustomerProfilingBundle\Entity\CustomerProfilingQuestionQueue | No errors. |
Aqarmap\Bundle\MessageBundle\Entity\ConversationRecipient | No errors. |
Aqarmap\Bundle\DiscussionBundle\Entity\CommentLike | No errors. |
Aqarmap\Bundle\PaymentBundle\Entity\PaymentTransactionService | No errors. |
Aqarmap\Bundle\CRMBundle\Entity\StaffHistory | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\SectionTranslation | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\PriceFilter | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\PropertyTypeTranslation | No errors. |
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationCompoundSize | No errors. |