GET https://dev.easylistrealty.ca/listings?from=%2Flistings%253Ffrom%253D%25252F

Response
200 OK
IP
216.73.216.151
Profiled on
Token
8d58b9

Query Metrics

26 Database Queries
11 Different statements
36.02 ms Query time
1 Invalid entities
430 Managed entities

Grouped Statements

Show all queries

forsalebyowner connection

Time▼ Count Info
8.30 ms
(23.04%) 		1 
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 (?, ?)
Parameters: 
[
  1
  6
]
View formatted query    View runnable query    Explain query    View query backtrace
7.48 ms
(20.76%) 		1 
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
Parameters: 
[
  1
  6
]
View formatted query    View runnable query    Explain query    View query backtrace
7.39 ms
(20.52%) 		1 
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
Parameters: 
[
  1
  6
]
View formatted query    View runnable query    Explain query    View query backtrace
7.36 ms
(20.42%) 		1 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.61 ms
(7.24%) 		1 
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
Parameters: 
[
  752214
  438432
  943480
  435574
  832368
  850587
  813792
  481705
  298793
  688530
  936164
  902065
]
View formatted query    View runnable query    Explain query    View query backtrace
1.23 ms
(3.41%) 		12 
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: 
[
  439
]
View formatted query    View runnable query    Explain query    View query backtrace
0.75 ms
(2.07%) 		1 
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
Parameters: 
[
  1
  6
  752214
  438432
  943480
  435574
  832368
  850587
  813792
  481705
  298793
  688530
  936164
  902065
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.88%) 		3 
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: 
[
  9
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.85%) 		3 
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: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
0.18 ms
(0.50%) 		1 
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
Parameters: 
[
  "1"
  "5"
  "10"
  "30"
  "8"
  "19"
  "4"
  "17"
  "15"
  "7"
  "18"
  "2"
  "6"
  "20"
  "12"
  "9"
  "52"
  "24"
  "26"
  "16"
  "3"
  "54"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.11 ms
(0.30%) 		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 = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace

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\ListingPhoto 396
App\External\ForSaleByOwner\Entity\Listing 12
App\External\ForSaleByOwner\Entity\City 12
App\External\ForSaleByOwner\Entity\SubCategory 3
App\External\ForSaleByOwner\Entity\Province 3
App\External\ForSaleByOwner\Entity\Stories 3
App\External\ForSaleByOwner\Entity\AdType 1

Entities Mapping

default entity manager

No loaded entities.

forsalebyowner entity manager

Class Mapping errors
App\External\ForSaleByOwner\Entity\Listing
  • The field 'App\External\ForSaleByOwner\Entity\Listing#lat' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\External\ForSaleByOwner\Entity\Listing#lng' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\External\ForSaleByOwner\Entity\City No errors.
App\External\ForSaleByOwner\Entity\Province No errors.
App\External\ForSaleByOwner\Entity\AdType No errors.
App\External\ForSaleByOwner\Entity\SubCategory No errors.
App\External\ForSaleByOwner\Entity\Stories No errors.
App\External\ForSaleByOwner\Entity\ListingPhoto No errors.