Query Metrics
15
Database Queries
8
Different statements
35.06 ms
Query time
1
Invalid entities
90
Managed entities
Queries
forsalebyowner connection
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 19.67 ms |
SELECT l0_.feedback_id AS feedback_id_0, l0_.listing_id AS listing_id_1, l0_.sub_category_id AS sub_category_id_2, l0_.ad_type_id AS ad_type_id_3, l0_.city_id AS city_id_4, l0_.province_id AS province_id_5, l0_.country_id AS country_id_6, l0_.price AS price_7, l0_.actual_savings AS actual_savings_8, l0_.date_sold AS date_sold_9, l0_.sold_by_realtor AS sold_by_realtor_10, l0_.rented AS rented_11, l0_.user_id AS user_id_12, l0_.user_first_name AS user_first_name_13, l0_.user_last_name AS user_last_name_14, l0_.user_email AS user_email_15, l0_.listing_status_id AS listing_status_id_16, l0_.feedback_message AS feedback_message_17, l0_.feedback_message_edit AS feedback_message_edit_18, l0_.testimonial AS testimonial_19, l0_.testimonial_no_photo AS testimonial_no_photo_20, l0_.testimonial_featured AS testimonial_featured_21, l0_.testimonial_featured_edit AS testimonial_featured_edit_22, l0_.feedback_timestamp AS feedback_timestamp_23 FROM listing_feedback l0_ INNER JOIN listings l1_ ON (l1_.listing_id = l0_.listing_id) INNER JOIN sold_listings s2_ ON (s2_.listing_id = l0_.listing_id) WHERE l0_.testimonial = 1 AND l0_.price IS NOT NULL AND l1_.price > 0 AND s2_.DOM_with_relists < 120 AND l0_.date_sold IS NOT NULL AND l1_.date_posted_original IS NOT NULL AND s2_.DOM_with_relists IS NOT NULL
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 2 | 0.25 ms |
SELECT t0.listing_id AS listing_id_1, t0.user_id AS user_id_2, t0.addon_id AS addon_id_3, t0.category_id AS category_id_4, t0.sub_category_id AS sub_category_id_5, t0.ad_type_id AS ad_type_id_6, t0.ownership_type AS ownership_type_7, t0.rural_property AS rural_property_8, t0.commercial_property AS commercial_property_9, t0.tagline AS tagline_10, t0.mls_number AS mls_number_11, t0.mls_number_additional AS mls_number_additional_12, t0.mls_url AS mls_url_13, t0.mls_stats_url AS mls_stats_url_14, t0.mls_stats_url_additional AS mls_stats_url_additional_15, t0.mls_relist AS mls_relist_16, t0.price AS price_17, t0.taxes AS taxes_18, t0.address_unit AS address_unit_19, t0.address AS address_20, t0.city_id AS city_id_21, t0.province_id AS province_id_22, t0.country_id AS country_id_23, t0.postal_code AS postal_code_24, t0.lat AS lat_25, t0.lng AS lng_26, t0.map_setting_id AS map_setting_id_27, t0.year AS year_28, t0.square_footage AS square_footage_29, t0.lot_size AS lot_size_30, t0.lot_size_unit_id AS lot_size_unit_id_31, t0.stories_id AS stories_id_32, t0.bedrooms AS bedrooms_33, t0.bedrooms_plus AS bedrooms_plus_34, t0.bathrooms AS bathrooms_35, t0.description AS description_36, t0.description_mls AS description_mls_37, t0.condo_fees AS condo_fees_38, t0.featured AS featured_39, t0.featured_expiry AS featured_expiry_40, t0.urgent AS urgent_41, t0.urgent_expiry AS urgent_expiry_42, t0.mls_listing AS mls_listing_43, t0.mls_listing_form AS mls_listing_form_44, t0.mls_agent_friendly AS mls_agent_friendly_45, t0.mls_date_posted AS mls_date_posted_46, t0.mls_date_posted_relist AS mls_date_posted_relist_47, t0.mls_expiry AS mls_expiry_48, t0.mls_expiry_notice1 AS mls_expiry_notice1_49, t0.mls_expiry_notice2 AS mls_expiry_notice2_50, t0.mls_cancelled AS mls_cancelled_51, t0.mls_suspended AS mls_suspended_52, t0.mls_suspended_until AS mls_suspended_until_53, t0.package_expiry AS package_expiry_54, t0.max_photos AS max_photos_55, t0.agent_friendly_comments AS agent_friendly_comments_56, t0.fireplace AS fireplace_57, t0.air_conditioning AS air_conditioning_58, t0.pool AS pool_59, t0.hot_tub AS hot_tub_60, t0.jacuzzi AS jacuzzi_61, t0.wood_stove AS wood_stove_62, t0.guest_suite AS guest_suite_63, t0.games_room AS games_room_64, t0.home_theatre AS home_theatre_65, t0.walkout AS walkout_66, t0.legal_suite AS legal_suite_67, t0.private_entrance AS private_entrance_68, t0.wheelchair_accessible AS wheelchair_accessible_69, t0.website_url AS website_url_70, t0.video_url AS video_url_71, t0.virtual_tour_url AS virtual_tour_url_72, t0.audio_enabled AS audio_enabled_73, t0.audio_bg_music AS audio_bg_music_74, t0.seller_verified AS seller_verified_75, t0.date_posted AS date_posted_76, t0.date_posted_original AS date_posted_original_77, t0.last_updated AS last_updated_78, t0.date_sold AS date_sold_79, t0.sold_by_realtor AS sold_by_realtor_80, t0.offer_acceptance_date AS offer_acceptance_date_81, t0.condition_removal_date AS condition_removal_date_82, t0.closing_date AS closing_date_83, t0.sold_price AS sold_price_84, t0.hide_on_recently_sold AS hide_on_recently_sold_85, t0.views AS views_86, t0.phone_clicks AS phone_clicks_87, t0.mls_audit_period AS mls_audit_period_88, t0.hide_from_user AS hide_from_user_89, t0.required_fields_complete AS required_fields_complete_90, t0.listing_status_id AS listing_status_id_91, t0.incomplete_reminder AS incomplete_reminder_92, t0.no_photo_notice AS no_photo_notice_93, t0.mls_renewal_notice AS mls_renewal_notice_94, t0.package_renewal_notice AS package_renewal_notice_95, t0.ad_type_id AS ad_type_id_96, t0.sub_category_id AS sub_category_id_97, t0.city_id AS city_id_98, t0.province_id AS province_id_99, t0.stories_id AS stories_id_100 FROM listings t0 WHERE t0.listing_id = ?
Parameters:
[
371726
]
|
||||||||||||||||||||||||||||||
| 3 | 0.85 ms |
SELECT t0.unique_id AS unique_id_1, t0.listing_id AS listing_id_2, t0.sub_category_id AS sub_category_id_3, t0.ad_type_id AS ad_type_id_4, t0.city_id AS city_id_5, t0.province_id AS province_id_6, t0.country_id AS country_id_7, t0.price AS price_8, t0.actual_savings AS actual_savings_9, t0.date_sold AS date_sold_10, t0.sold_by_realtor AS sold_by_realtor_11, t0.addon_id AS addon_id_12, t0.mls_number AS mls_number_13, t0.user_id AS user_id_14, t0.user_first_name AS user_first_name_15, t0.user_last_name AS user_last_name_16, t0.user_email AS user_email_17, t0.DOM_total AS DOM_total_18, t0.DOM_with_relists AS DOM_with_relists_19, t0.last_updated AS last_updated_20, t0.city_id AS city_id_21, t0.province_id AS province_id_22 FROM sold_listings t0 WHERE t0.listing_id = ? LIMIT 1
Parameters:
[
371726
]
|
||||||||||||||||||||||||||||||
| 4 | 0.09 ms |
SELECT t0.province_id AS province_id_1, t0.province AS province_2, t0.province_abbr AS province_abbr_3, t0.timezone AS timezone_4, t0.timezone_shortname AS timezone_shortname_5, t0.country_id AS country_id_6 FROM provinces t0 WHERE t0.province_id = ?
Parameters:
[
4
]
|
||||||||||||||||||||||||||||||
| 5 | 0.09 ms |
SELECT t0.city_id AS city_id_1, t0.province_id AS province_id_2, t0.city AS city_3, t0.country_id AS country_id_4, t0.board_id AS board_id_5, t0.major_city AS major_city_6 FROM cities t0 WHERE t0.city_id = ?
Parameters:
[
1010
]
|
||||||||||||||||||||||||||||||
| 6 | 0.07 ms |
SELECT t0.sub_category_id AS sub_category_id_1, t0.sub_category AS sub_category_2, t0.sub_category_plural AS sub_category_plural_3, t0.category_id AS category_id_4, t0.tier AS tier_5, t0.land_only AS land_only_6, t0.restriction_level AS restriction_level_7, t0.sub_category_order AS sub_category_order_8 FROM sub_categories t0 WHERE t0.sub_category_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
| 7 | 0.19 ms |
SELECT t0.listing_id AS listing_id_1, t0.user_id AS user_id_2, t0.addon_id AS addon_id_3, t0.category_id AS category_id_4, t0.sub_category_id AS sub_category_id_5, t0.ad_type_id AS ad_type_id_6, t0.ownership_type AS ownership_type_7, t0.rural_property AS rural_property_8, t0.commercial_property AS commercial_property_9, t0.tagline AS tagline_10, t0.mls_number AS mls_number_11, t0.mls_number_additional AS mls_number_additional_12, t0.mls_url AS mls_url_13, t0.mls_stats_url AS mls_stats_url_14, t0.mls_stats_url_additional AS mls_stats_url_additional_15, t0.mls_relist AS mls_relist_16, t0.price AS price_17, t0.taxes AS taxes_18, t0.address_unit AS address_unit_19, t0.address AS address_20, t0.city_id AS city_id_21, t0.province_id AS province_id_22, t0.country_id AS country_id_23, t0.postal_code AS postal_code_24, t0.lat AS lat_25, t0.lng AS lng_26, t0.map_setting_id AS map_setting_id_27, t0.year AS year_28, t0.square_footage AS square_footage_29, t0.lot_size AS lot_size_30, t0.lot_size_unit_id AS lot_size_unit_id_31, t0.stories_id AS stories_id_32, t0.bedrooms AS bedrooms_33, t0.bedrooms_plus AS bedrooms_plus_34, t0.bathrooms AS bathrooms_35, t0.description AS description_36, t0.description_mls AS description_mls_37, t0.condo_fees AS condo_fees_38, t0.featured AS featured_39, t0.featured_expiry AS featured_expiry_40, t0.urgent AS urgent_41, t0.urgent_expiry AS urgent_expiry_42, t0.mls_listing AS mls_listing_43, t0.mls_listing_form AS mls_listing_form_44, t0.mls_agent_friendly AS mls_agent_friendly_45, t0.mls_date_posted AS mls_date_posted_46, t0.mls_date_posted_relist AS mls_date_posted_relist_47, t0.mls_expiry AS mls_expiry_48, t0.mls_expiry_notice1 AS mls_expiry_notice1_49, t0.mls_expiry_notice2 AS mls_expiry_notice2_50, t0.mls_cancelled AS mls_cancelled_51, t0.mls_suspended AS mls_suspended_52, t0.mls_suspended_until AS mls_suspended_until_53, t0.package_expiry AS package_expiry_54, t0.max_photos AS max_photos_55, t0.agent_friendly_comments AS agent_friendly_comments_56, t0.fireplace AS fireplace_57, t0.air_conditioning AS air_conditioning_58, t0.pool AS pool_59, t0.hot_tub AS hot_tub_60, t0.jacuzzi AS jacuzzi_61, t0.wood_stove AS wood_stove_62, t0.guest_suite AS guest_suite_63, t0.games_room AS games_room_64, t0.home_theatre AS home_theatre_65, t0.walkout AS walkout_66, t0.legal_suite AS legal_suite_67, t0.private_entrance AS private_entrance_68, t0.wheelchair_accessible AS wheelchair_accessible_69, t0.website_url AS website_url_70, t0.video_url AS video_url_71, t0.virtual_tour_url AS virtual_tour_url_72, t0.audio_enabled AS audio_enabled_73, t0.audio_bg_music AS audio_bg_music_74, t0.seller_verified AS seller_verified_75, t0.date_posted AS date_posted_76, t0.date_posted_original AS date_posted_original_77, t0.last_updated AS last_updated_78, t0.date_sold AS date_sold_79, t0.sold_by_realtor AS sold_by_realtor_80, t0.offer_acceptance_date AS offer_acceptance_date_81, t0.condition_removal_date AS condition_removal_date_82, t0.closing_date AS closing_date_83, t0.sold_price AS sold_price_84, t0.hide_on_recently_sold AS hide_on_recently_sold_85, t0.views AS views_86, t0.phone_clicks AS phone_clicks_87, t0.mls_audit_period AS mls_audit_period_88, t0.hide_from_user AS hide_from_user_89, t0.required_fields_complete AS required_fields_complete_90, t0.listing_status_id AS listing_status_id_91, t0.incomplete_reminder AS incomplete_reminder_92, t0.no_photo_notice AS no_photo_notice_93, t0.mls_renewal_notice AS mls_renewal_notice_94, t0.package_renewal_notice AS package_renewal_notice_95, t0.ad_type_id AS ad_type_id_96, t0.sub_category_id AS sub_category_id_97, t0.city_id AS city_id_98, t0.province_id AS province_id_99, t0.stories_id AS stories_id_100 FROM listings t0 WHERE t0.listing_id = ?
Parameters:
[
989896
]
|
||||||||||||||||||||||||||||||
| 8 | 0.63 ms |
SELECT t0.unique_id AS unique_id_1, t0.listing_id AS listing_id_2, t0.sub_category_id AS sub_category_id_3, t0.ad_type_id AS ad_type_id_4, t0.city_id AS city_id_5, t0.province_id AS province_id_6, t0.country_id AS country_id_7, t0.price AS price_8, t0.actual_savings AS actual_savings_9, t0.date_sold AS date_sold_10, t0.sold_by_realtor AS sold_by_realtor_11, t0.addon_id AS addon_id_12, t0.mls_number AS mls_number_13, t0.user_id AS user_id_14, t0.user_first_name AS user_first_name_15, t0.user_last_name AS user_last_name_16, t0.user_email AS user_email_17, t0.DOM_total AS DOM_total_18, t0.DOM_with_relists AS DOM_with_relists_19, t0.last_updated AS last_updated_20, t0.city_id AS city_id_21, t0.province_id AS province_id_22 FROM sold_listings t0 WHERE t0.listing_id = ? LIMIT 1
Parameters:
[
989896
]
|
||||||||||||||||||||||||||||||
| 9 | 0.06 ms |
SELECT t0.province_id AS province_id_1, t0.province AS province_2, t0.province_abbr AS province_abbr_3, t0.timezone AS timezone_4, t0.timezone_shortname AS timezone_shortname_5, t0.country_id AS country_id_6 FROM provinces t0 WHERE t0.province_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
| 10 | 0.06 ms |
SELECT t0.city_id AS city_id_1, t0.province_id AS province_id_2, t0.city AS city_3, t0.country_id AS country_id_4, t0.board_id AS board_id_5, t0.major_city AS major_city_6 FROM cities t0 WHERE t0.city_id = ?
Parameters:
[
431
]
|
||||||||||||||||||||||||||||||
| 11 | 0.19 ms |
SELECT t0.listing_id AS listing_id_1, t0.user_id AS user_id_2, t0.addon_id AS addon_id_3, t0.category_id AS category_id_4, t0.sub_category_id AS sub_category_id_5, t0.ad_type_id AS ad_type_id_6, t0.ownership_type AS ownership_type_7, t0.rural_property AS rural_property_8, t0.commercial_property AS commercial_property_9, t0.tagline AS tagline_10, t0.mls_number AS mls_number_11, t0.mls_number_additional AS mls_number_additional_12, t0.mls_url AS mls_url_13, t0.mls_stats_url AS mls_stats_url_14, t0.mls_stats_url_additional AS mls_stats_url_additional_15, t0.mls_relist AS mls_relist_16, t0.price AS price_17, t0.taxes AS taxes_18, t0.address_unit AS address_unit_19, t0.address AS address_20, t0.city_id AS city_id_21, t0.province_id AS province_id_22, t0.country_id AS country_id_23, t0.postal_code AS postal_code_24, t0.lat AS lat_25, t0.lng AS lng_26, t0.map_setting_id AS map_setting_id_27, t0.year AS year_28, t0.square_footage AS square_footage_29, t0.lot_size AS lot_size_30, t0.lot_size_unit_id AS lot_size_unit_id_31, t0.stories_id AS stories_id_32, t0.bedrooms AS bedrooms_33, t0.bedrooms_plus AS bedrooms_plus_34, t0.bathrooms AS bathrooms_35, t0.description AS description_36, t0.description_mls AS description_mls_37, t0.condo_fees AS condo_fees_38, t0.featured AS featured_39, t0.featured_expiry AS featured_expiry_40, t0.urgent AS urgent_41, t0.urgent_expiry AS urgent_expiry_42, t0.mls_listing AS mls_listing_43, t0.mls_listing_form AS mls_listing_form_44, t0.mls_agent_friendly AS mls_agent_friendly_45, t0.mls_date_posted AS mls_date_posted_46, t0.mls_date_posted_relist AS mls_date_posted_relist_47, t0.mls_expiry AS mls_expiry_48, t0.mls_expiry_notice1 AS mls_expiry_notice1_49, t0.mls_expiry_notice2 AS mls_expiry_notice2_50, t0.mls_cancelled AS mls_cancelled_51, t0.mls_suspended AS mls_suspended_52, t0.mls_suspended_until AS mls_suspended_until_53, t0.package_expiry AS package_expiry_54, t0.max_photos AS max_photos_55, t0.agent_friendly_comments AS agent_friendly_comments_56, t0.fireplace AS fireplace_57, t0.air_conditioning AS air_conditioning_58, t0.pool AS pool_59, t0.hot_tub AS hot_tub_60, t0.jacuzzi AS jacuzzi_61, t0.wood_stove AS wood_stove_62, t0.guest_suite AS guest_suite_63, t0.games_room AS games_room_64, t0.home_theatre AS home_theatre_65, t0.walkout AS walkout_66, t0.legal_suite AS legal_suite_67, t0.private_entrance AS private_entrance_68, t0.wheelchair_accessible AS wheelchair_accessible_69, t0.website_url AS website_url_70, t0.video_url AS video_url_71, t0.virtual_tour_url AS virtual_tour_url_72, t0.audio_enabled AS audio_enabled_73, t0.audio_bg_music AS audio_bg_music_74, t0.seller_verified AS seller_verified_75, t0.date_posted AS date_posted_76, t0.date_posted_original AS date_posted_original_77, t0.last_updated AS last_updated_78, t0.date_sold AS date_sold_79, t0.sold_by_realtor AS sold_by_realtor_80, t0.offer_acceptance_date AS offer_acceptance_date_81, t0.condition_removal_date AS condition_removal_date_82, t0.closing_date AS closing_date_83, t0.sold_price AS sold_price_84, t0.hide_on_recently_sold AS hide_on_recently_sold_85, t0.views AS views_86, t0.phone_clicks AS phone_clicks_87, t0.mls_audit_period AS mls_audit_period_88, t0.hide_from_user AS hide_from_user_89, t0.required_fields_complete AS required_fields_complete_90, t0.listing_status_id AS listing_status_id_91, t0.incomplete_reminder AS incomplete_reminder_92, t0.no_photo_notice AS no_photo_notice_93, t0.mls_renewal_notice AS mls_renewal_notice_94, t0.package_renewal_notice AS package_renewal_notice_95, t0.ad_type_id AS ad_type_id_96, t0.sub_category_id AS sub_category_id_97, t0.city_id AS city_id_98, t0.province_id AS province_id_99, t0.stories_id AS stories_id_100 FROM listings t0 WHERE t0.listing_id = ?
Parameters:
[
577881
]
|
||||||||||||||||||||||||||||||
| 12 | 0.69 ms |
SELECT t0.unique_id AS unique_id_1, t0.listing_id AS listing_id_2, t0.sub_category_id AS sub_category_id_3, t0.ad_type_id AS ad_type_id_4, t0.city_id AS city_id_5, t0.province_id AS province_id_6, t0.country_id AS country_id_7, t0.price AS price_8, t0.actual_savings AS actual_savings_9, t0.date_sold AS date_sold_10, t0.sold_by_realtor AS sold_by_realtor_11, t0.addon_id AS addon_id_12, t0.mls_number AS mls_number_13, t0.user_id AS user_id_14, t0.user_first_name AS user_first_name_15, t0.user_last_name AS user_last_name_16, t0.user_email AS user_email_17, t0.DOM_total AS DOM_total_18, t0.DOM_with_relists AS DOM_with_relists_19, t0.last_updated AS last_updated_20, t0.city_id AS city_id_21, t0.province_id AS province_id_22 FROM sold_listings t0 WHERE t0.listing_id = ? LIMIT 1
Parameters:
[
577881
]
|
||||||||||||||||||||||||||||||
| 13 | 0.06 ms |
SELECT t0.city_id AS city_id_1, t0.province_id AS province_id_2, t0.city AS city_3, t0.country_id AS country_id_4, t0.board_id AS board_id_5, t0.major_city AS major_city_6 FROM cities t0 WHERE t0.city_id = ?
Parameters:
[
72
]
|
||||||||||||||||||||||||||||||
| 14 | 8.35 ms |
SELECT s0_.price AS price_0, s0_.sold_by_realtor AS sold_by_realtor_1, p1_.province_abbr AS province_abbr_2, l2_.last_updated AS last_updated_3 FROM sold_listings s0_ LEFT JOIN provinces p1_ ON (p1_.province_id = s0_.province_id) LEFT JOIN listings l2_ ON (l2_.listing_id = s0_.listing_id) WHERE s0_.ad_type_id = ? AND s0_.price >= ? AND s0_.date_sold >= ? AND l2_.hide_on_recently_sold = ? GROUP BY s0_.listing_id ORDER BY l2_.last_updated DESC, s0_.price DESC LIMIT 1000
Parameters:
[ 1 100000 "2020-10-01 00:00:00" 0 ]
|
||||||||||||||||||||||||||||||
| 15 | 3.83 ms |
SELECT l0_.listing_id AS listing_id_0, l0_.user_id AS user_id_1, l0_.addon_id AS addon_id_2, l0_.category_id AS category_id_3, l0_.sub_category_id AS sub_category_id_4, l0_.ad_type_id AS ad_type_id_5, l0_.ownership_type AS ownership_type_6, l0_.rural_property AS rural_property_7, l0_.commercial_property AS commercial_property_8, l0_.tagline AS tagline_9, l0_.mls_number AS mls_number_10, l0_.mls_number_additional AS mls_number_additional_11, l0_.mls_url AS mls_url_12, l0_.mls_stats_url AS mls_stats_url_13, l0_.mls_stats_url_additional AS mls_stats_url_additional_14, l0_.mls_relist AS mls_relist_15, l0_.price AS price_16, l0_.taxes AS taxes_17, l0_.address_unit AS address_unit_18, l0_.address AS address_19, l0_.city_id AS city_id_20, l0_.province_id AS province_id_21, l0_.country_id AS country_id_22, l0_.postal_code AS postal_code_23, l0_.lat AS lat_24, l0_.lng AS lng_25, l0_.map_setting_id AS map_setting_id_26, l0_.year AS year_27, l0_.square_footage AS square_footage_28, l0_.lot_size AS lot_size_29, l0_.lot_size_unit_id AS lot_size_unit_id_30, l0_.stories_id AS stories_id_31, l0_.bedrooms AS bedrooms_32, l0_.bedrooms_plus AS bedrooms_plus_33, l0_.bathrooms AS bathrooms_34, l0_.description AS description_35, l0_.description_mls AS description_mls_36, l0_.condo_fees AS condo_fees_37, l0_.featured AS featured_38, l0_.featured_expiry AS featured_expiry_39, l0_.urgent AS urgent_40, l0_.urgent_expiry AS urgent_expiry_41, l0_.mls_listing AS mls_listing_42, l0_.mls_listing_form AS mls_listing_form_43, l0_.mls_agent_friendly AS mls_agent_friendly_44, l0_.mls_date_posted AS mls_date_posted_45, l0_.mls_date_posted_relist AS mls_date_posted_relist_46, l0_.mls_expiry AS mls_expiry_47, l0_.mls_expiry_notice1 AS mls_expiry_notice1_48, l0_.mls_expiry_notice2 AS mls_expiry_notice2_49, l0_.mls_cancelled AS mls_cancelled_50, l0_.mls_suspended AS mls_suspended_51, l0_.mls_suspended_until AS mls_suspended_until_52, l0_.package_expiry AS package_expiry_53, l0_.max_photos AS max_photos_54, l0_.agent_friendly_comments AS agent_friendly_comments_55, l0_.fireplace AS fireplace_56, l0_.air_conditioning AS air_conditioning_57, l0_.pool AS pool_58, l0_.hot_tub AS hot_tub_59, l0_.jacuzzi AS jacuzzi_60, l0_.wood_stove AS wood_stove_61, l0_.guest_suite AS guest_suite_62, l0_.games_room AS games_room_63, l0_.home_theatre AS home_theatre_64, l0_.walkout AS walkout_65, l0_.legal_suite AS legal_suite_66, l0_.private_entrance AS private_entrance_67, l0_.wheelchair_accessible AS wheelchair_accessible_68, l0_.website_url AS website_url_69, l0_.video_url AS video_url_70, l0_.virtual_tour_url AS virtual_tour_url_71, l0_.audio_enabled AS audio_enabled_72, l0_.audio_bg_music AS audio_bg_music_73, l0_.seller_verified AS seller_verified_74, l0_.date_posted AS date_posted_75, l0_.date_posted_original AS date_posted_original_76, l0_.last_updated AS last_updated_77, l0_.date_sold AS date_sold_78, l0_.sold_by_realtor AS sold_by_realtor_79, l0_.offer_acceptance_date AS offer_acceptance_date_80, l0_.condition_removal_date AS condition_removal_date_81, l0_.closing_date AS closing_date_82, l0_.sold_price AS sold_price_83, l0_.hide_on_recently_sold AS hide_on_recently_sold_84, l0_.views AS views_85, l0_.phone_clicks AS phone_clicks_86, l0_.mls_audit_period AS mls_audit_period_87, l0_.hide_from_user AS hide_from_user_88, l0_.required_fields_complete AS required_fields_complete_89, l0_.listing_status_id AS listing_status_id_90, l0_.incomplete_reminder AS incomplete_reminder_91, l0_.no_photo_notice AS no_photo_notice_92, l0_.mls_renewal_notice AS mls_renewal_notice_93, l0_.package_renewal_notice AS package_renewal_notice_94, l0_.ad_type_id AS ad_type_id_95, l0_.sub_category_id AS sub_category_id_96, l0_.city_id AS city_id_97, l0_.province_id AS province_id_98, l0_.stories_id AS stories_id_99 FROM listings l0_ WHERE l0_.addon_id = 34 AND l0_.listing_status_id = 1 AND l0_.price >= 900000 AND l0_.mls_url <> ? ORDER BY l0_.date_posted DESC LIMIT 1
Parameters:
[ "" ]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| forsalebyowner | doctrine.dbal.forsalebyowner_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| forsalebyowner | doctrine.orm.forsalebyowner_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
forsalebyowner entity manager
| Class | Amount of managed objects |
|---|---|
| App\External\ForSaleByOwner\Entity\ListingFeedback | 71 |
| App\External\ForSaleByOwner\Entity\Listing | 4 |
| App\External\ForSaleByOwner\Entity\City | 4 |
| App\External\ForSaleByOwner\Entity\Province | 3 |
| App\External\ForSaleByOwner\Entity\SoldListing | 3 |
| App\External\ForSaleByOwner\Entity\SubCategory | 2 |
| App\External\ForSaleByOwner\Entity\Stories | 2 |
| App\External\ForSaleByOwner\Entity\AdType | 1 |
Entities Mapping
default entity manager
No loaded entities.
forsalebyowner entity manager
| Class | Mapping errors |
|---|---|
| App\External\ForSaleByOwner\Entity\ListingFeedback | No errors. |
| App\External\ForSaleByOwner\Entity\Listing |
|
| App\External\ForSaleByOwner\Entity\SoldListing | No errors. |
| App\External\ForSaleByOwner\Entity\AdType | No errors. |
| App\External\ForSaleByOwner\Entity\SubCategory | No errors. |
| App\External\ForSaleByOwner\Entity\City | No errors. |
| App\External\ForSaleByOwner\Entity\Province | No errors. |
| App\External\ForSaleByOwner\Entity\Stories | No errors. |