Symfony Profiler

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

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

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

SELECT
  t0.unique_id AS unique_id_1,
  t0.listing_id AS listing_id_2,
  t0.user_ip AS user_ip_3,
  t0.src AS src_4,
  t0.view_timestamp AS view_timestamp_5,
  t0.listing_id AS listing_id_6
FROM
  listing_views t0
WHERE
  t0.listing_id = ?
  AND t0.user_ip = ?
ORDER BY
  t0.view_timestamp DESC
LIMIT
  1

SELECT t0.unique_id AS unique_id_1, t0.listing_id AS listing_id_2, t0.user_ip AS user_ip_3, t0.src AS src_4, t0.view_timestamp AS view_timestamp_5, t0.listing_id AS listing_id_6 FROM listing_views t0 WHERE t0.listing_id = 481705 AND t0.user_ip = '216.73.216.151' ORDER BY t0.view_timestamp DESC LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO listing_views (
  listing_id, user_ip, src, view_timestamp
)
VALUES
  (?, ?, ?, ?)

INSERT INTO listing_views (listing_id, user_ip, src, view_timestamp) VALUES (481705, '216.73.216.151', 'EasyListRealty.ca', '2026-05-07 10:17:59');

UPDATE
  listings
SET
  lat = ?,
  lng = ?,
  views = ?,
  phone_clicks = ?
WHERE
  listing_id = ?

UPDATE listings SET lat = 55.229221, lng = -118.96209, views = 83, phone_clicks = 0 WHERE listing_id = 481705;

"COMMIT"

"COMMIT";

SELECT
  t0.photo_id AS photo_id_1,
  t0.photo_name AS photo_name_2,
  t0.photo_caption AS photo_caption_3,
  t0.photo_order AS photo_order_4,
  t0.photo_order_mls AS photo_order_mls_5,
  t0.mls_selected AS mls_selected_6,
  t0.listing_id AS listing_id_7,
  t0.last_updated AS last_updated_8
FROM
  listing_photos t0
WHERE
  t0.listing_id = ?
ORDER BY
  t0.photo_order ASC,
  t0.photo_id ASC

SELECT t0.photo_id AS photo_id_1, t0.photo_name AS photo_name_2, t0.photo_caption AS photo_caption_3, t0.photo_order AS photo_order_4, t0.photo_order_mls AS photo_order_mls_5, t0.mls_selected AS mls_selected_6, t0.listing_id AS listing_id_7, t0.last_updated AS last_updated_8 FROM listing_photos t0 WHERE t0.listing_id = 481705 ORDER BY t0.photo_order ASC, t0.photo_id ASC;

SELECT
  t0.listing_id AS listing_id_1,
  t0.open_house_comments AS open_house_comments_2,
  t0.start_date AS start_date_3,
  t0.end_date AS end_date_4,
  t0.mon_start_time AS mon_start_time_5,
  t0.mon_end_time AS mon_end_time_6,
  t0.tue_start_time AS tue_start_time_7,
  t0.tue_end_time AS tue_end_time_8,
  t0.wed_start_time AS wed_start_time_9,
  t0.wed_end_time AS wed_end_time_10,
  t0.thu_start_time AS thu_start_time_11,
  t0.thu_end_time AS thu_end_time_12,
  t0.fri_start_time AS fri_start_time_13,
  t0.fri_end_time AS fri_end_time_14,
  t0.sat_start_time AS sat_start_time_15,
  t0.sat_end_time AS sat_end_time_16,
  t0.sun_start_time AS sun_start_time_17,
  t0.sun_end_time AS sun_end_time_18
FROM
  listing_open_houses t0
WHERE
  t0.listing_id = ?

SELECT t0.listing_id AS listing_id_1, t0.open_house_comments AS open_house_comments_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.mon_start_time AS mon_start_time_5, t0.mon_end_time AS mon_end_time_6, t0.tue_start_time AS tue_start_time_7, t0.tue_end_time AS tue_end_time_8, t0.wed_start_time AS wed_start_time_9, t0.wed_end_time AS wed_end_time_10, t0.thu_start_time AS thu_start_time_11, t0.thu_end_time AS thu_end_time_12, t0.fri_start_time AS fri_start_time_13, t0.fri_end_time AS fri_end_time_14, t0.sat_start_time AS sat_start_time_15, t0.sat_end_time AS sat_end_time_16, t0.sun_start_time AS sun_start_time_17, t0.sun_end_time AS sun_end_time_18 FROM listing_open_houses t0 WHERE t0.listing_id = 481705;

SELECT
  t0.user_id AS user_id_1,
  t0.account_manager AS account_manager_2,
  t0.user_first_name AS user_first_name_3,
  t0.user_last_name AS user_last_name_4,
  t0.builder_name AS builder_name_5,
  t0.title_name1 AS title_name1_6,
  t0.title_name2 AS title_name2_7,
  t0.title_name3 AS title_name3_8,
  t0.title_name4 AS title_name4_9,
  t0.user_email AS user_email_10,
  t0.user_email_secondary AS user_email_secondary_11,
  t0.user_phone AS user_phone_12,
  t0.user_phone_alt AS user_phone_alt_13,
  t0.user_realtor AS user_realtor_14,
  t0.user_builder AS user_builder_15,
  t0.builder_id AS builder_id_16,
  t0.user_avatar_id AS user_avatar_id_17,
  t0.user_avatar_upload AS user_avatar_upload_18,
  t0.user_tagline AS user_tagline_19,
  t0.user_ip AS user_ip_20,
  t0.user_ip_city AS user_ip_city_21,
  t0.user_ip_prov AS user_ip_prov_22,
  t0.user_ip_country AS user_ip_country_23,
  t0.user_agent_info AS user_agent_info_24,
  t0.user_os AS user_os_25,
  t0.user_browser AS user_browser_26,
  t0.user_device AS user_device_27,
  t0.service_option_id AS service_option_id_28,
  t0.realtor_website AS realtor_website_29,
  t0.realtor_tagline AS realtor_tagline_30,
  t0.realtor_office_phone AS realtor_office_phone_31,
  t0.realtor_cell_phone AS realtor_cell_phone_32,
  t0.realty_company_id AS realty_company_id_33,
  t0.realty_company_division AS realty_company_division_34,
  t0.city_id AS city_id_35,
  t0.province_id AS province_id_36,
  t0.country_id AS country_id_37,
  t0.video_url AS video_url_38,
  t0.video_clicks AS video_clicks_39,
  t0.audio_enabled AS audio_enabled_40,
  t0.audio_bg_music AS audio_bg_music_41,
  t0.audio_clicks AS audio_clicks_42,
  t0.realtor_paid AS realtor_paid_43,
  t0.ad_clicks AS ad_clicks_44,
  t0.user_password AS user_password_45,
  t0.newsletter AS newsletter_46,
  t0.register_date AS register_date_47,
  t0.last_login_date AS last_login_date_48,
  t0.last_updated AS last_updated_49,
  t0.confirmed AS confirmed_50,
  t0.banned AS banned_51,
  t0.inactive_notice AS inactive_notice_52,
  t0.no_phone_reminder AS no_phone_reminder_53,
  t0.mls_upgrade_offer_hide AS mls_upgrade_offer_hide_54,
  t0.system_account AS system_account_55,
  t0.captcha_score AS captcha_score_56
FROM
  users t0
WHERE
  t0.user_id = ?

SELECT t0.user_id AS user_id_1, t0.account_manager AS account_manager_2, t0.user_first_name AS user_first_name_3, t0.user_last_name AS user_last_name_4, t0.builder_name AS builder_name_5, t0.title_name1 AS title_name1_6, t0.title_name2 AS title_name2_7, t0.title_name3 AS title_name3_8, t0.title_name4 AS title_name4_9, t0.user_email AS user_email_10, t0.user_email_secondary AS user_email_secondary_11, t0.user_phone AS user_phone_12, t0.user_phone_alt AS user_phone_alt_13, t0.user_realtor AS user_realtor_14, t0.user_builder AS user_builder_15, t0.builder_id AS builder_id_16, t0.user_avatar_id AS user_avatar_id_17, t0.user_avatar_upload AS user_avatar_upload_18, t0.user_tagline AS user_tagline_19, t0.user_ip AS user_ip_20, t0.user_ip_city AS user_ip_city_21, t0.user_ip_prov AS user_ip_prov_22, t0.user_ip_country AS user_ip_country_23, t0.user_agent_info AS user_agent_info_24, t0.user_os AS user_os_25, t0.user_browser AS user_browser_26, t0.user_device AS user_device_27, t0.service_option_id AS service_option_id_28, t0.realtor_website AS realtor_website_29, t0.realtor_tagline AS realtor_tagline_30, t0.realtor_office_phone AS realtor_office_phone_31, t0.realtor_cell_phone AS realtor_cell_phone_32, t0.realty_company_id AS realty_company_id_33, t0.realty_company_division AS realty_company_division_34, t0.city_id AS city_id_35, t0.province_id AS province_id_36, t0.country_id AS country_id_37, t0.video_url AS video_url_38, t0.video_clicks AS video_clicks_39, t0.audio_enabled AS audio_enabled_40, t0.audio_bg_music AS audio_bg_music_41, t0.audio_clicks AS audio_clicks_42, t0.realtor_paid AS realtor_paid_43, t0.ad_clicks AS ad_clicks_44, t0.user_password AS user_password_45, t0.newsletter AS newsletter_46, t0.register_date AS register_date_47, t0.last_login_date AS last_login_date_48, t0.last_updated AS last_updated_49, t0.confirmed AS confirmed_50, t0.banned AS banned_51, t0.inactive_notice AS inactive_notice_52, t0.no_phone_reminder AS no_phone_reminder_53, t0.mls_upgrade_offer_hide AS mls_upgrade_offer_hide_54, t0.system_account AS system_account_55, t0.captcha_score AS captcha_score_56 FROM users t0 WHERE t0.user_id = 33302;

SELECT
  t0.listing_id AS listing_id_1,
  t0.seller_name_override AS seller_name_override_2,
  t0.seller_email_override AS seller_email_override_3,
  t0.seller_phone_override AS seller_phone_override_4,
  t0.seller_phone_alt_override AS seller_phone_alt_override_5,
  t0.seller_tagline_override AS seller_tagline_override_6,
  t0.seller_avatar_id_override AS seller_avatar_id_override_7,
  t0.seller_avatar_upload_override AS seller_avatar_upload_override_8,
  t0.title_name1_override AS title_name1_override_9,
  t0.title_name2_override AS title_name2_override_10,
  t0.title_name3_override AS title_name3_override_11,
  t0.title_name4_override AS title_name4_override_12,
  t0.last_updated AS last_updated_13
FROM
  listing_contact_overrides t0
WHERE
  t0.listing_id = ?
LIMIT
  1

SELECT t0.listing_id AS listing_id_1, t0.seller_name_override AS seller_name_override_2, t0.seller_email_override AS seller_email_override_3, t0.seller_phone_override AS seller_phone_override_4, t0.seller_phone_alt_override AS seller_phone_alt_override_5, t0.seller_tagline_override AS seller_tagline_override_6, t0.seller_avatar_id_override AS seller_avatar_id_override_7, t0.seller_avatar_upload_override AS seller_avatar_upload_override_8, t0.title_name1_override AS title_name1_override_9, t0.title_name2_override AS title_name2_override_10, t0.title_name3_override AS title_name3_override_11, t0.title_name4_override AS title_name4_override_12, t0.last_updated AS last_updated_13 FROM listing_contact_overrides t0 WHERE t0.listing_id = 481705 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2
FROM
  measurement_unit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2 FROM measurement_unit t0 WHERE t0.id = 3;

SELECT
  t0.stories_id AS stories_id_1,
  t0.stories AS stories_2
FROM
  stories t0
WHERE
  t0.stories_id = ?

SELECT t0.stories_id AS stories_id_1, t0.stories AS stories_2 FROM stories t0 WHERE t0.stories_id = 0;