Symfony Profiler

[
  "route" => "app_listings"
  "route_parameters" => [
    "_route" => "app_listings"
    "_controller" => "App\Controller\ListingsController::index"
  ]
  "request_uri" => "https://dev.easylistrealty.ca/listings?from=%2Flistings%253Ffrom%253D%25252F"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 0
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\GeoIpSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerVoy8Q93\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "fsboinc_adminDev"
    "password" => "<redacted>"
    "driverOptions" => [
      "PDO::MYSQL_ATTR_INIT_COMMAND" => "SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci"
    ]
    "defaultTableOptions" => [
      "charset" => "utf8mb4"
      "collate" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "fsboinc_ForSaleByOwner"
    "serverVersion" => "10.3.35-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT COUNT(l0_.listing_id) AS sclr_0 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 LEFT JOIN sub_categories s4_ ON l0_.sub_category_id = s4_.sub_category_id WHERE l0_.listing_status_id IN (?, ?)"
  "params" => [
    1 => 1
    2 => 6
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT DISTINCT sub_category_id FROM listings WHERE mls_listing = 1 AND mls_number != '' AND mls_expiry > NOW() AND listing_status_id IN (1,6) AND sub_category_id IS NOT NULL AND sub_category_id != 0"
]

[
  "sql" => "SELECT s0_.sub_category_id AS sub_category_id_0, s0_.sub_category AS sub_category_1 FROM sub_categories s0_ WHERE s0_.sub_category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.sub_category ASC"
  "params" => [
    1 => "1"
    2 => "5"
    3 => "10"
    4 => "30"
    5 => "8"
    6 => "19"
    7 => "4"
    8 => "17"
    9 => "15"
    10 => "7"
    11 => "18"
    12 => "2"
    13 => "6"
    14 => "20"
    15 => "12"
    16 => "9"
    17 => "52"
    18 => "24"
    19 => "26"
    20 => "16"
    21 => "3"
    22 => "54"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
    22 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT listing_id_0 FROM (SELECT DISTINCT listing_id_0, last_updated_77 FROM (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 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 LEFT JOIN sub_categories s4_ ON l0_.sub_category_id = s4_.sub_category_id WHERE l0_.listing_status_id IN (?, ?)) dctrn_result_inner ORDER BY last_updated_77 DESC) dctrn_result LIMIT 12"
  "params" => [
    1 => 1
    2 => 6
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "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 LEFT JOIN sub_categories s4_ ON l0_.sub_category_id = s4_.sub_category_id WHERE l0_.listing_status_id IN (?, ?) AND l0_.listing_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY l0_.last_updated DESC"
  "params" => [
    1 => 1
    2 => 6
    3 => 752214
    4 => 438432
    5 => 943480
    6 => 435574
    7 => 832368
    8 => 850587
    9 => 813792
    10 => 481705
    11 => 298793
    12 => 688530
    13 => 936164
    14 => 902065
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 752214
    2 => 438432
    3 => 943480
    4 => 435574
    5 => 832368
    6 => 850587
    7 => 813792
    8 => 481705
    9 => 298793
    10 => 688530
    11 => 936164
    12 => 902065
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 439
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 373
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1314
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1679
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1089
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 19
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 255
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 539
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 3274
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 151
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1634
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 587
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1578
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT listing_id_0 FROM (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 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 LEFT JOIN sub_categories s4_ ON l0_.sub_category_id = s4_.sub_category_id WHERE l0_.listing_status_id IN (?, ?) ORDER BY l0_.last_updated DESC) dctrn_result) dctrn_table"
  "params" => [
    1 => 1
    2 => 6
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\PreLoadAssetsEventListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]