Symfony Profiler

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_.mls_listing = 1
  AND l0_.mls_number <> ?
  AND l0_.mls_expiry > ?
  AND l0_.listing_status_id IN (?, ?)
ORDER BY
  l0_.last_updated DESC
LIMIT
  20

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_.mls_listing = 1 AND l0_.mls_number <> '' AND l0_.mls_expiry > '2026-05-07 00:00:00' AND l0_.listing_status_id IN (1, 6) ORDER BY l0_.last_updated DESC LIMIT 20;

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 (435574, 832368, 850587, 813792, 481705, 298793, 936164, 902065, 271546, 609119, 893560, 630786, 814247, 824175, 180145, 680732, 433820, 769170, 259510, 629566) ORDER BY l0_.listing_id ASC, l0_.photo_order ASC;

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 = ?

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 = 1679;

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 = ?

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 = 9;

SELECT
  t0.ad_type_id AS ad_type_id_1,
  t0.ad_type AS ad_type_2,
  t0.real_estate_only AS real_estate_only_3,
  t0.classifieds_only AS classifieds_only_4
FROM
  ad_types t0
WHERE
  t0.ad_type_id = ?

SELECT t0.ad_type_id AS ad_type_id_1, t0.ad_type AS ad_type_2, t0.real_estate_only AS real_estate_only_3, t0.classifieds_only AS classifieds_only_4 FROM ad_types t0 WHERE t0.ad_type_id = 1;

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 = ?

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 = 1;

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 = ?

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 = 1089;

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 = ?

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 = 19;

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 = ?

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 = 255;

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 = ?

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 = 2;

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 = ?

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 = 539;

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 = ?

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 = 3274;

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 = ?

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 = 1;

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 = ?

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 = 151;

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 = ?

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 = 587;

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 = ?

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 = 1578;

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 = ?

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 = 516;

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 = ?

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 = 4;

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 = ?

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 = 1188;

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 = ?

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 = 1394;

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 = ?

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 = 1010;

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 = ?

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 = 4;