Symfony Profiler

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

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 = 1 AND s0_.price >= 100000 AND s0_.date_sold >= '2020-10-01 00:00:00' AND l2_.hide_on_recently_sold = 0 GROUP BY s0_.listing_id ORDER BY l2_.last_updated DESC, s0_.price DESC LIMIT 1000;

SELECT
  s0_.unique_id AS unique_id_0,
  s0_.listing_id AS listing_id_1,
  s0_.sub_category_id AS sub_category_id_2,
  s0_.ad_type_id AS ad_type_id_3,
  s0_.city_id AS city_id_4,
  s0_.province_id AS province_id_5,
  s0_.country_id AS country_id_6,
  s0_.price AS price_7,
  s0_.actual_savings AS actual_savings_8,
  s0_.date_sold AS date_sold_9,
  s0_.sold_by_realtor AS sold_by_realtor_10,
  s0_.addon_id AS addon_id_11,
  s0_.mls_number AS mls_number_12,
  s0_.user_id AS user_id_13,
  s0_.user_first_name AS user_first_name_14,
  s0_.user_last_name AS user_last_name_15,
  s0_.user_email AS user_email_16,
  s0_.DOM_total AS DOM_total_17,
  s0_.DOM_with_relists AS DOM_with_relists_18,
  s0_.last_updated AS last_updated_19,
  c1_.city_id AS city_id_20,
  c1_.province_id AS province_id_21,
  c1_.city AS city_22,
  c1_.country_id AS country_id_23,
  c1_.board_id AS board_id_24,
  c1_.major_city AS major_city_25,
  p2_.province_id AS province_id_26,
  p2_.province AS province_27,
  p2_.province_abbr AS province_abbr_28,
  p2_.timezone AS timezone_29,
  p2_.timezone_shortname AS timezone_shortname_30,
  p2_.country_id AS country_id_31,
  s0_.city_id AS city_id_32,
  s0_.province_id AS province_id_33
FROM
  sold_listings s0_
  LEFT JOIN cities c1_ ON s0_.city_id = c1_.city_id
  LEFT JOIN provinces p2_ ON s0_.province_id = p2_.province_id
WHERE
  s0_.DOM_with_relists IS NOT NULL
  AND s0_.DOM_with_relists < ?
  AND s0_.ad_type_id = 1
  AND s0_.price > 100000
ORDER BY
  s0_.date_sold DESC
LIMIT
  24

SELECT s0_.unique_id AS unique_id_0, s0_.listing_id AS listing_id_1, s0_.sub_category_id AS sub_category_id_2, s0_.ad_type_id AS ad_type_id_3, s0_.city_id AS city_id_4, s0_.province_id AS province_id_5, s0_.country_id AS country_id_6, s0_.price AS price_7, s0_.actual_savings AS actual_savings_8, s0_.date_sold AS date_sold_9, s0_.sold_by_realtor AS sold_by_realtor_10, s0_.addon_id AS addon_id_11, s0_.mls_number AS mls_number_12, s0_.user_id AS user_id_13, s0_.user_first_name AS user_first_name_14, s0_.user_last_name AS user_last_name_15, s0_.user_email AS user_email_16, s0_.DOM_total AS DOM_total_17, s0_.DOM_with_relists AS DOM_with_relists_18, s0_.last_updated AS last_updated_19, c1_.city_id AS city_id_20, c1_.province_id AS province_id_21, c1_.city AS city_22, c1_.country_id AS country_id_23, c1_.board_id AS board_id_24, c1_.major_city AS major_city_25, p2_.province_id AS province_id_26, p2_.province AS province_27, p2_.province_abbr AS province_abbr_28, p2_.timezone AS timezone_29, p2_.timezone_shortname AS timezone_shortname_30, p2_.country_id AS country_id_31, s0_.city_id AS city_id_32, s0_.province_id AS province_id_33 FROM sold_listings s0_ LEFT JOIN cities c1_ ON s0_.city_id = c1_.city_id LEFT JOIN provinces p2_ ON s0_.province_id = p2_.province_id WHERE s0_.DOM_with_relists IS NOT NULL AND s0_.DOM_with_relists < 130 AND s0_.ad_type_id = 1 AND s0_.price > 100000 ORDER BY s0_.date_sold DESC LIMIT 24;

SELECT
  l0_.photo_id AS photo_id_0,
  l0_.photo_name AS photo_name_1,
  l0_.photo_caption AS photo_caption_2,
  l0_.photo_order AS photo_order_3,
  l0_.photo_order_mls AS photo_order_mls_4,
  l0_.mls_selected AS mls_selected_5,
  l0_.listing_id AS listing_id_6,
  l0_.last_updated AS last_updated_7
FROM
  listing_photos l0_
WHERE
  l0_.listing_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  l0_.listing_id ASC,
  l0_.photo_order ASC

SELECT l0_.photo_id AS photo_id_0, l0_.photo_name AS photo_name_1, l0_.photo_caption AS photo_caption_2, l0_.photo_order AS photo_order_3, l0_.photo_order_mls AS photo_order_mls_4, l0_.mls_selected AS mls_selected_5, l0_.listing_id AS listing_id_6, l0_.last_updated AS last_updated_7 FROM listing_photos l0_ WHERE l0_.listing_id IN (213431, 100726, 271873, 930755, 415796, 973699, 290694, 586583, 174033, 666460, 158615, 438432, 883133, 680164, 727729, 511950, 821630, 832211, 487515, 244594, 527843, 396812, 735417, 841188) ORDER BY l0_.listing_id ASC, l0_.photo_order ASC;

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_
  LEFT JOIN cities c1_ ON l0_.city_id = c1_.city_id
  LEFT JOIN provinces p2_ ON l0_.province_id = p2_.province_id
  LEFT JOIN ad_types a3_ ON l0_.ad_type_id = a3_.ad_type_id
WHERE
  l0_.listing_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

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_ LEFT JOIN cities c1_ ON l0_.city_id = c1_.city_id LEFT JOIN provinces p2_ ON l0_.province_id = p2_.province_id LEFT JOIN ad_types a3_ ON l0_.ad_type_id = a3_.ad_type_id WHERE l0_.listing_id IN (213431, 100726, 271873, 930755, 415796, 973699, 290694, 586583, 174033, 666460, 158615, 438432, 883133, 680164, 727729, 511950, 821630, 832211, 487515, 244594, 527843, 396812, 735417, 841188);