64 Home or Professional Services businesses for sale in Norwood SA 5067

64 businesses for sale

DeckSeal: Adelaide

(more)

Total Investment: From $50K

Business Type: New Franchise

DeckSeal: Adelaide b

(more)

Total Investment: From $50K

Business Type: New Franchise

DeckSeal: Port Adelaide c

Kilburn, SA 5084 8.5 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

DeckSeal: Port Adelaide d

(more)

Total Investment: From $50K

Business Type: New Franchise

MailPlus: Regency

(more)

Total Investment: From $50K

Business Type: Franchise Resale

DeckSeal: Port Adelaide b

(more)

Total Investment: From $50K

Business Type: New Franchise

DeckSeal: Adelaide a

Glenelg, SA 5045 13.3 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

DeckSeal: Salisbury a

(more)

Total Investment: From $50K

Business Type: New Franchise

DeckSeal: Port Adelaide

(more)

Total Investment: From $50K

Business Type: New Franchise

DeckSeal: Flagstaff Hill

(more)

Total Investment: From $50K

Business Type: New Franchise

DeckSeal: Salisbury

(more)

Total Investment: From $50K

Business Type: New Franchise

DeckSeal: Port Adelaide a

DeckSeal presents a rare opportunity to establish a premium deck restoration service in the thriving coastal suburb of North Haven, SA. Positioned in Adelaide's northern beaches ar...(more)

Total Investment: From $50K

Business Type: New Franchise

DeckSeal: Flagstaff Hill a

Reynella, SA 5161 23.2 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

DeckSeal: Port Adelaide e

DeckSeal presents a rare opportunity to establish a thriving deck restoration business in Williamstown, SA, where the blend of historic charm and modern development creates an idea...(more)

Total Investment: From $50K

Business Type: New Franchise

DeckSeal: Port Adelaide d

(more)

Total Investment: From $50K

Business Type: New Franchise

MailPlus: Geelong

Geelong, VIC 3220 662.3 km away

(more)

Total Investment: From $200K

Business Type: Franchise Resale

Mobile Skips: Geelong

Geelong, VIC 3220 662.3 km away

(more)

Total Investment: From $50K

Business Type: Franchise Resale

MailPlus: Hoppers Crossing

(more)

Total Investment: From $50K

Business Type: Franchise Resale

MailPlus: Airport West

Take over an operational MailPlus courier franchise in the strategic Airport West business district. This established Melbourne territory benefits from its prime position near Esse...(more)

Total Investment: From $200K

Business Type: Franchise Resale

MailPlus: Campbellfield

Secure your future with this established MailPlus franchise in Campbellfield, a thriving industrial hub in Melbourne's northern suburbs with excellent transport links and a robust...(more)

Total Investment: From $50K

Business Type: Franchise Resale

Signwave Australia: Melbourne West

Footscray, VIC 3011 684.3 km away

Signwave Australia offers a rare opportunity to join a leading signage and visual communications network in the vibrant suburb of Footscray, Victoria. This diverse, rapidly develop...(more)

Total Investment: From $300K

Business Type: New Franchise

MailPlus: Lalor

Lalor, VIC 3075 686.7 km away

Secure your future with this established MailPlus franchise in Lalor, a thriving northern suburb of Melbourne with strong industrial and commercial presence. We offer a proven busi...(more)

Total Investment: From $100K

Business Type: Franchise Resale

MailPlus: Port Melbourne

Secure your future with this established MailPlus franchise in Port Melbourne, offering a proven business model in one of Melbourne's most dynamic commercial hubs. Port Melbourne's...(more)

Total Investment: From $200K

Business Type: Franchise Resale

MailPlus: South Melbourne

Secure your future with this established MailPlus franchise territory in South Melbourne, offering a proven business model in one of Melbourne's most dynamic commercial hubs. South...(more)

Total Investment: From $100K

Business Type: Franchise Resale

MailPlus: Hawthorn

Hawthorn, VIC 3122 696.7 km away

(more)

Total Investment: From $100K

Business Type: Franchise Resale

Signwave Australia: Melbourne East

Hawthorn, VIC 3122 696.7 km away

Establish your business legacy with a Signwave Australia franchise in the prestigious suburb of Hawthorn, Victoria. Located just 6km east of Melbourne's CBD, this well-positioned t...(more)

Total Investment: From $400K

Business Type: Franchise Resale

MailPlus: Bayswater

Bayswater, VIC 3153 716.9 km away

(more)

Total Investment: From $100K

Business Type: Franchise Resale

MailPlus: Seaford

Frankston, VIC 3199 724.0 km away

Discover an established MailPlus courier franchise in Frankston, one of Melbourne's thriving bayside business hubs. Located in this major commercial centre with excellent transport...(more)

Total Investment: From $50K

Business Type: Franchise Resale

Mobile Skips: Canberra

Belconnen, ACT 2617 1,006.5 km away

Discover the innovative waste management solution that's revolutionising the skip bin industry with a Mobile Skips franchise opportunity in Belconnen, ACT. Positioned in one of Can...(more)

Total Investment: From $50K

Business Type: New Franchise

MailPlus: Canberra

Deakin, ACT 2600 1,009.9 km away

(more)

Total Investment: From $50K

Business Type: Franchise Resale

MailPlus: Barton

Barton, ACT 2600 1,013.4 km away

(more)

Total Investment: From $50K

Business Type: Franchise Resale

MailPlus: Canberra Airport

(more)

Total Investment: From $25K

Business Type: Franchise Resale

DeckSeal: North Tasmania

Devonport, TAS 7310 1,026.3 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

DeckSeal: North Tasmania a

Wilmot, TAS 7310 1,034.0 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

DeckSeal: North Tasmania b

Launceston, TAS 7250 1,099.1 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

MailPlus: Penrith

Penrith, NSW 2750 1,180.6 km away

(more)

Total Investment: From $50K

Business Type: Franchise Resale

SettingsRequest history359msRequest Duration7MBMemory Usage9.x
Laravel Version
9.52.20
PHP Version
8.2.15
Environment
test
Debug Mode
Enabled
URL
testing.hattch.net
Timezone
Australia/Melbourne
Locale
en
GET {viewType}/within-{industry}/in-{location}
status
200 OK
full_url
http://directory.testing.hattch.net/businesses-for-sale/within-home-professional-services/in-norwood...
action_name
directory.industry-location-search.single
controller_action
App\Http\Controllers\FranchiseDirectoryController@showFilteredListings
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
  • infolog[18:37:57] LOG.info: ValidateBusinessListingUrl processing request { "path": "businesses-for-sal...
  • infolog[18:37:57] LOG.info: Route has location parameter, passing through { "location": "norwood-sa-506...
  • infolog[18:37:57] LOG.info: Processing single location parameter { "location": "norwood-sa-5067", "...
  • infolog[18:37:57] LOG.info: Successfully parsed location parameter { "location": "norwood-sa-5067", ...
  • infolog[18:37:57] LOG.info: Cookie debugging in FranchiseDirectoryController { "path": "businesses-for-...
  • infolog[18:37:57] LOG.info: Parameters received: { "industry": "home-professional-services", "franc...
  • infolog[18:37:57] LOG.info: User is not authenticated on filtered listings page { "host": "directory.te...
  • infolog[18:37:57] LOG.info: Populated filter arrays from parsed location { "suburb": "norwood", "st...
  • infolog[18:37:57] LOG.info: Starting getFilteredListings with filters: { "locations": [], "business...
  • infolog[18:37:57] LOG.info: Applying industry filter: { "industry": "home-professional-services" }
  • infolog[18:37:57] LOG.info: Using single known industry: { "industry": "home-professional-services" }
  • infolog[18:37:57] LOG.info: Applying location filters: { "suburb": [ "norwood" ], "stat...
  • infolog[18:37:57] LOG.info: Using postcodes for filtering: { "postcodes": [ "5067" ] }
  • infolog[18:37:57] LOG.info: Including nearby postcodes: { "count": 48, "postcodes": [ 5067,...
  • infolog[18:37:57] LOG.info: Adding distance_km to select for sorting by distance
  • debuglog[18:37:57] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.*, `brands`.`id` as ...
  • infolog[18:37:57] LOG.info: Successfully retrieved listings { "total": 5, "per_page": 36, "curr...
  • infolog[18:37:57] LOG.info: Listings retrieved: { "count": 5, "total": 5 }
  • infolog[18:37:57] LOG.info: Brand IDs found: { "ids": { "0": 7017925, "4": 7017944 ...
  • infolog[18:37:57] LOG.info: Retrieved postcode record for brand filters: { "postcode": "5067", "has...
  • infolog[18:37:57] LOG.info: Adding coordinates to brand filters for distance search: { "lat": "-34.9176...
  • infolog[18:37:57] LOG.info: Setting distance parameter for brands: { "max_distance": 99999 }
  • infolog[18:37:57] LOG.info: Local brand count check (exact postcode): { "postcode": "5067", "localB...
  • infolog[18:37:57] LOG.info: Starting getFilteredBrands with filters: { "locations": [], "businessTy...
  • infolog[18:37:57] LOG.info: Applying industry filter: { "industry": "home-professional-services" }
  • infolog[18:37:57] LOG.info: Using single known industry: { "industry": "home-professional-services" }
  • infolog[18:37:57] LOG.info: Using coordinates for distance-based search: { "lat": -34.91768, "lng":...
  • debuglog[18:37:57] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:37:57] LOG.info: Successfully retrieved brands { "total": 5, "per_page": 36, "curren...
  • infolog[18:37:57] LOG.info: Postcode found: { "id": 11697, "suburb": "Norwood" }
  • infolog[18:37:57] LOG.info: Final postcodeArray before passing to view: { "postcodeArray": [ { ...
  • infolog[18:37:57] LOG.info: Starting getDefaultListings without filters
  • debuglog[18:37:57] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.* from `listings` in...
  • infolog[18:37:57] LOG.info: Successfully retrieved listings { "total": 2552, "per_page": 36, "c...
  • infolog[18:37:57] LOG.info: Starting getDefaultBrands without filters
  • debuglog[18:37:57] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:37:57] LOG.info: Successfully retrieved listings { "total": 42, "per_page": 36, "cur...
  • infolog[18:37:57] LOG.info: Exact location listing count { "suburb": "norwood", "state": "SA", ...
  • infolog[18:37:57] LOG.info: Starting getNearbyListings with filters: { "locations": [], "businessTy...
  • infolog[18:37:57] LOG.info: Applying industry filter: { "industry": "home-professional-services" }
  • infolog[18:37:57] LOG.info: Using where for single industry { "industry": "home-professional-services" ...
  • debuglog[18:37:57] LOG.debug: Final SQL query for nearby listings: { "sql": "select distinct `listings`....
  • infolog[18:37:57] LOG.info: Successfully retrieved nearby listings { "total": 64, "per_page": 36, ...
  • infolog[18:37:57] LOG.info: Display flags: { "hasExactLocationSearch": true, "originalBrandCount": ...
  • infolog[18:37:57] LOG.info: Getting industry IDs from slug { "slug": "home-professional-services" }
  • infolog[18:37:57] LOG.info: Found industry from direct lookup { "slug": "home-professional-services", ...
  • infolog[18:37:57] LOG.info: Final industry IDs from slug { "slug": "home-professional-services", "i...
  • infolog[18:37:57] LOG.info: View data prepared successfully
status
200 OK
full_url
http://directory.testing.hattch.net/businesses-for-sale/within-home-professional-services/in-norwood...
action_name
directory.industry-location-search.single
controller_action
App\Http\Controllers\FranchiseDirectoryController@showFilteredListings
uri
GET {viewType}/within-{industry}/in-{location}
domain
directory.testing.hattch.net
controller
App\Http\Controllers\FranchiseDirectoryController@showFilteredListings
file
app/Http/Controllers/FranchiseDirectoryController.php:91-1230
middleware
web, lowercase.state, validate.business.url
duration
361ms
peak_memory
10MB
response
text/html; charset=UTF-8
request_format
html
request_query
0 of 0
array:1 [ "distance" => "99999" ]
request_request
[]
request_headers
0 of 0
array:12 [ "cache-control" => array:1 [ 0 => "no-cache" ] "via" => array:1 [ 0 => "1.1 squid-proxy-5b5d847c96-kml6h (squid/6.10)" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "pragma" => array:1 [ 0 => "no-cache" ] "x-amzn-trace-id" => array:1 [ 0 => "Root=1-68664165-380c0c882a4608b10ee25b35" ] "host" => array:1 [ 0 => "directory.testing.hattch.net" ] "x-forwarded-port" => array:1 [ 0 => "80" ] "x-forwarded-proto" => array:1 [ 0 => "http" ] "x-forwarded-for" => array:1 [ 0 => "10.1.3.136, 216.73.216.89" ] ]
request_cookies
[]
response_headers
0 of 0
array:3 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Thu, 03 Jul 2025 08:37:57 GMT" ] ]
session_attributes
0 of 0
array:1 [ "_token" => "e5QzsBKnP5m33GJNCuUnPemRHabi3oerDiYLxORP" ]
  • Booting (15.5ms)time
  • Application (344ms)time
  • Routing (1.76ms)
  • View: pages.home.brandviews
  • View: pages.home.breadcrumbviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.dir_empty_resultsviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.summaryviews
  • View: pages.home.partials.lazy-load-scriptviews
  • View: brand.common.frontpage-layoutviews
  • View: brand.common.tracking-codesviews
  • View: pages.home.universal-headerviews
  • View: pages.home.partials.header-filtersviews
  • View: pages.home.skeleton-loadersviews
  • View: pages.home.profile_slider_menuviews
  • View: pages.home.partials._main_optionsviews
  • View: pages.home.partials._account_detailsviews
  • View: pages.home.partials._franchise_compatibilityviews
  • View: pages.home.partials._enquiries_invitationsviews
  • View: pages.home.partials._investment_calculatorviews
  • View: pages.home.partials._notification_settingsviews
  • View: pages.home.partials._securityviews
  • View: pages.widget.summaryviews
  • View: layouts.common.footerviews
  • View: partials.welcome-collection-modalviews
  • 1 x Application (95.68%)
    344ms
    1 x Booting (4.32%)
    15.50ms
    1 x Routing (0.49%)
    1.76ms
    25 x View (0%)
    0μs
    25 templates were rendered
    • pages.home.brandbrand.blade.php#?blade
    • pages.home.breadcrumbbreadcrumb.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.dir_empty_resultsdir_empty_results.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.summarysummary.blade.php#?blade
    • pages.home.partials.lazy-load-scriptlazy-load-script.blade.php#?blade
    • brand.common.frontpage-layoutfrontpage-layout.blade.php#?blade
    • brand.common.tracking-codestracking-codes.blade.php#?blade
    • pages.home.universal-headeruniversal-header.blade.php#?blade
    • pages.home.partials.header-filtersheader-filters.blade.php#?blade
    • pages.home.skeleton-loadersskeleton-loaders.blade.php#?blade
    • pages.home.profile_slider_menuprofile_slider_menu.blade.php#?blade
    • pages.home.partials._main_options_main_options.blade.php#?blade
    • pages.home.partials._account_details_account_details.blade.php#?blade
    • pages.home.partials._franchise_compatibility_franchise_compatibility.blade.php#?blade
    • pages.home.partials._enquiries_invitations_enquiries_invitations.blade.php#?blade
    • pages.home.partials._investment_calculator_investment_calculator.blade.php#?blade
    • pages.home.partials._notification_settings_notification_settings.blade.php#?blade
    • pages.home.partials._security_security.blade.php#?blade
    • pages.widget.summarysummary.blade.php#?blade
    • layouts.common.footerfooter.blade.php#?blade
    • partials.welcome-collection-modalwelcome-collection-modal.blade.php#?blade
    56 statements were executed (13 duplicates)Show only duplicates264ms
    • FranchiseDirectoryController.php#328hattch2022prodConnection Established
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:328
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FranchiseDirectoryController.php#328hattch2022prod13.37msselect exists(select * from `industries` where `industry_slug` = 'home-professional-services' and `industries`.`deleted_at` is null) as `exists`
      Bindings
      • 0: home-professional-services
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:328
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FranchiseDirectoryController.php#333hattch2022prod2.37msselect `id` from `industries` where `industry_slug` = 'home-professional-services' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: home-professional-services
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:333
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • BusinessListingService.php#34hattch2022prod4.42msselect `id` from `industries` where `industry_slug` = 'home-professional-services' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: home-professional-services
      Backtrace
      • app/Services/BusinessListingService.php:34
      • app/Services/BusinessListingService.php:153
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • BusinessListingService.php#267hattch2022prod9.38msselect `to_postcode` from `distances` where `from_postcode` in ('5067') order by `distance_km` asc
      Bindings
      • 0: 5067
      Backtrace
      • app/Services/BusinessListingService.php:267
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#446hattch2022prod3.6msselect count(*) as aggregate from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` left join `distances` on `post_codes`.`postcode` = `distances`.`to_postcode` and `distances`.`from_postcode` in ('5067') where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and (`brands`.`industry_id` in (8) or `brands`.`secondary_industry_id` in (8)) and `post_codes`.`postcode` in (5067, 5067, 5069, 5068, 5065, 5081, 5070, 5066, 5064, 5063, 5006, 5061, 5000, 5087, 5074, 5073, 5072, 5062, 5034, 5082, 5083, 5140, 5031, 5075, 5007, 5035, 5150, 5037, 5084, 5085, 5086, 5088, 5008, 5141, 5033, 5041, 5136, 5032, 5039, 5152, 5090, 5089, 5009, 5010, 5025, 5052, 5038, '5067')
      Bindings
      • 0: 5067
      • 1: open
      • 2: 1
      • 3: 8
      • 4: 8
      • 5: 5067
      • 6: 5067
      • 7: 5069
      • 8: 5068
      • 9: 5065
      • 10: 5081
      • 11: 5070
      • 12: 5066
      • 13: 5064
      • 14: 5063
      • 15: 5006
      • 16: 5061
      • 17: 5000
      • 18: 5087
      • 19: 5074
      • 20: 5073
      • 21: 5072
      • 22: 5062
      • 23: 5034
      • 24: 5082
      • 25: 5083
      • 26: 5140
      • 27: 5031
      • 28: 5075
      • 29: 5007
      • 30: 5035
      • 31: 5150
      • 32: 5037
      • 33: 5084
      • 34: 5085
      • 35: 5086
      • 36: 5088
      • 37: 5008
      • 38: 5141
      • 39: 5033
      • 40: 5041
      • 41: 5136
      • 42: 5032
      • 43: 5039
      • 44: 5152
      • 45: 5090
      • 46: 5089
      • 47: 5009
      • 48: 5010
      • 49: 5025
      • 50: 5052
      • 51: 5038
      • 52: 5067
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#446hattch2022prod4.12msselect distinct `listings`.*, `brands`.`id` as `brand_id`, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `industries`.`industry`, `industries`.`industry_slug`, `post_codes`.`suburb`, `post_codes`.`state`, `post_codes`.`postcode`, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_listing_image")) as mobile_listing_image, `distances`.`distance_km` from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` left join `distances` on `post_codes`.`postcode` = `distances`.`to_postcode` and `distances`.`from_postcode` in ('5067') where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and (`brands`.`industry_id` in (8) or `brands`.`secondary_industry_id` in (8)) and `post_codes`.`postcode` in (5067, 5067, 5069, 5068, 5065, 5081, 5070, 5066, 5064, 5063, 5006, 5061, 5000, 5087, 5074, 5073, 5072, 5062, 5034, 5082, 5083, 5140, 5031, 5075, 5007, 5035, 5150, 5037, 5084, 5085, 5086, 5088, 5008, 5141, 5033, 5041, 5136, 5032, 5039, 5152, 5090, 5089, 5009, 5010, 5025, 5052, 5038, '5067') order by CASE WHEN post_codes.postcode IN ('5067') THEN 0 ELSE 1 END, `distances`.`distance_km` asc, `post_codes`.`postcode` asc limit 36 offset 0
      Bindings
      • 0: 5067
      • 1: open
      • 2: 1
      • 3: 8
      • 4: 8
      • 5: 5067
      • 6: 5067
      • 7: 5069
      • 8: 5068
      • 9: 5065
      • 10: 5081
      • 11: 5070
      • 12: 5066
      • 13: 5064
      • 14: 5063
      • 15: 5006
      • 16: 5061
      • 17: 5000
      • 18: 5087
      • 19: 5074
      • 20: 5073
      • 21: 5072
      • 22: 5062
      • 23: 5034
      • 24: 5082
      • 25: 5083
      • 26: 5140
      • 27: 5031
      • 28: 5075
      • 29: 5007
      • 30: 5035
      • 31: 5150
      • 32: 5037
      • 33: 5084
      • 34: 5085
      • 35: 5086
      • 36: 5088
      • 37: 5008
      • 38: 5141
      • 39: 5033
      • 40: 5041
      • 41: 5136
      • 42: 5032
      • 43: 5039
      • 44: 5152
      • 45: 5090
      • 46: 5089
      • 47: 5009
      • 48: 5010
      • 49: 5025
      • 50: 5052
      • 51: 5038
      • 52: 5067
      • 53: 5067
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#446hattch2022prod3.19msselect * from `brands` where `brands`.`id` in (7017925, 7017944)
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#446hattch2022prod4.87msselect * from `homepages` where `homepages`.`brand_id` in (7017925, 7017944)
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#446hattch2022prod2.51msselect * from `industries` where `industries`.`id` in (8) and `industries`.`deleted_at` is null
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#446hattch2022prod2.53msselect * from `post_codes` where `post_codes`.`id` in (10717, 10742, 11806, 11814, 11838)
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#624hattch2022prod2.44msselect * from `post_codes` where `postcode` = '5067' limit 1
      Bindings
      • 0: 5067
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:624
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FranchiseDirectoryController.php#721hattch2022prod2.81msselect `id` from `industries` where `industry_slug` = 'home-professional-services' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: home-professional-services
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:721
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FranchiseDirectoryController.php#730hattch2022prod6.55msselect count(distinct `brands`.`id`) as aggregate from `brands` inner join `listings` on `brands`.`id` = `listings`.`brand_id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` or `brands`.`secondary_industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and `post_codes`.`postcode` = '5067' and (`brands`.`industry_id` = 8 or `brands`.`secondary_industry_id` = 8)
      Bindings
      • 0: open
      • 1: 1
      • 2: 5067
      • 3: 8
      • 4: 8
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:730
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • BusinessListingService.php#34hattch2022prod3.08msselect `id` from `industries` where `industry_slug` = 'home-professional-services' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: home-professional-services
      Backtrace
      • app/Services/BusinessListingService.php:34
      • app/Services/BusinessListingService.php:724
      • app/Http/Controllers/FranchiseDirectoryController.php:744
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • BusinessListingService.php#1053hattch2022prod5.61msselect count(*) as aggregate from (select distinct `brands`.`id`, `brands`.`id` as `brand_id`, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `brands`.`minimum_investment`, `brands`.`maximum_investment`, `brands`.`country_code`, `industries`.`industry`, `industries`.`industry_slug`, MIN(post_codes.suburb) as suburb, MIN(post_codes.state) as state, MIN(post_codes.postcode) as postcode, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_brand_logo")) as mobile_brand_logo, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_listing_image")) as mobile_listing_image, JSON_UNQUOTE(JSON_EXTRACT(homepages.section2, "$.business_intro_subtext")) as business_intro_subtext, MIN((6751 * acos(cos(radians(-34.91768)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(138.64521)) + sin(radians(-34.91768)) * sin(radians(post_codes.lat))))) AS distance_km, MIN(post_codes.postcode) AS nearest_postcode from `brands` inner join `listings` on `brands`.`id` = `listings`.`brand_id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and (`brands`.`industry_id` in (8) or `brands`.`secondary_industry_id` in (8)) group by `brands`.`id`) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 8
      • 3: 8
      Backtrace
      • app/Services/BusinessListingService.php:1053
      • app/Http/Controllers/FranchiseDirectoryController.php:744
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1053hattch2022prod4msselect distinct `brands`.`id`, `brands`.`id` as `brand_id`, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `brands`.`minimum_investment`, `brands`.`maximum_investment`, `brands`.`country_code`, `industries`.`industry`, `industries`.`industry_slug`, MIN(post_codes.suburb) as suburb, MIN(post_codes.state) as state, MIN(post_codes.postcode) as postcode, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_brand_logo")) as mobile_brand_logo, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_listing_image")) as mobile_listing_image, JSON_UNQUOTE(JSON_EXTRACT(homepages.section2, "$.business_intro_subtext")) as business_intro_subtext, MIN((6751 * acos(cos(radians(-34.91768)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(138.64521)) + sin(radians(-34.91768)) * sin(radians(post_codes.lat))))) AS distance_km, MIN(post_codes.postcode) AS nearest_postcode from `brands` inner join `listings` on `brands`.`id` = `listings`.`brand_id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and (`brands`.`industry_id` in (8) or `brands`.`secondary_industry_id` in (8)) group by `brands`.`id` order by MIN((6751 * acos(cos(radians(-34.91768)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(138.64521)) + sin(radians(-34.91768)) * sin(radians(post_codes.lat))))) asc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      • 2: 8
      • 3: 8
      Backtrace
      • app/Services/BusinessListingService.php:1053
      • app/Http/Controllers/FranchiseDirectoryController.php:744
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1053hattch2022prod4.12msselect * from `homepages` where `homepages`.`brand_id` in (7017925, 7017926, 7017944, 7017967, 7017978)
      Backtrace
      • app/Services/BusinessListingService.php:1053
      • app/Http/Controllers/FranchiseDirectoryController.php:744
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1053hattch2022prod3.56msselect * from `industries` where 0 = 1 and `industries`.`deleted_at` is null
      Backtrace
      • app/Services/BusinessListingService.php:1053
      • app/Http/Controllers/FranchiseDirectoryController.php:744
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1053hattch2022prod3.01msselect * from `listings` where `listings`.`brand_id` in (7017925, 7017926, 7017944, 7017967, 7017978)
      Backtrace
      • app/Services/BusinessListingService.php:1053
      • app/Http/Controllers/FranchiseDirectoryController.php:744
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1053hattch2022prod2.8msselect * from `post_codes` where `post_codes`.`id` in (110, 124, 376, 385, 689, 813, 1020, 1964, 1986, 2634, 2889, 3054, 3073, 3444, 3989, 4100, 4264, 4868, 5416, 5691, 5899, 5971, 6172, 6204, 6369, 6706, 7222, 7235, 7812, 7820, 7898, 7914, 8784, 8820, 8869, 9507, 9802, 10177, 10717, 10718, 10742, 10845, 10947, 11104, 11191, 11734, 11744, 11806, 11814, 11821, 11838, 11843, 11908, 12001, 13588, 14343, 14465, 14543, 14630, 14920, 15160, 15161, 15176, 15224)
      Backtrace
      • app/Services/BusinessListingService.php:1053
      • app/Http/Controllers/FranchiseDirectoryController.php:744
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#783hattch2022prod2.4msselect * from `post_codes` where `suburb` in ('Norwood') and `state` = 'SA' and `postcode` = '5067' limit 1
      Bindings
      • 0: Norwood
      • 1: SA
      • 2: 5067
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:783
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • BusinessListingService.php#498hattch2022prod14.08msselect count(*) as aggregate from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null)
      Bindings
      • 0: open
      • 1: 1
      Backtrace
      • app/Services/BusinessListingService.php:498
      • app/Http/Controllers/FranchiseDirectoryController.php:810
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#498hattch2022prod31.95msselect distinct `listings`.* from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) order by `post_codes`.`postcode` asc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      Backtrace
      • app/Services/BusinessListingService.php:498
      • app/Http/Controllers/FranchiseDirectoryController.php:810
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#615hattch2022prod19.34msselect count(*) as aggregate from (select distinct `brands`.`id`, `brands`.`id` as `brand_id`, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `brands`.`minimum_investment`, `brands`.`maximum_investment`, `brands`.`country_code`, `industries`.`industry`, `industries`.`industry_slug`, MIN(post_codes.suburb) as suburb, MIN(post_codes.state) as state, MIN(post_codes.postcode) as postcode, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_brand_logo")) as mobile_brand_logo, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_listing_image")) as mobile_listing_image, JSON_UNQUOTE(JSON_EXTRACT(homepages.section2, "$.business_intro_subtext")) as business_intro_subtext from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) group by `brands`.`id`) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      Backtrace
      • app/Services/BusinessListingService.php:615
      • app/Http/Controllers/FranchiseDirectoryController.php:811
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#615hattch2022prod21.12msselect distinct `brands`.`id`, `brands`.`id` as `brand_id`, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `brands`.`minimum_investment`, `brands`.`maximum_investment`, `brands`.`country_code`, `industries`.`industry`, `industries`.`industry_slug`, MIN(post_codes.suburb) as suburb, MIN(post_codes.state) as state, MIN(post_codes.postcode) as postcode, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_brand_logo")) as mobile_brand_logo, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_listing_image")) as mobile_listing_image, JSON_UNQUOTE(JSON_EXTRACT(homepages.section2, "$.business_intro_subtext")) as business_intro_subtext from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) group by `brands`.`id` order by `listings`.`created_at` desc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      Backtrace
      • app/Services/BusinessListingService.php:615
      • app/Http/Controllers/FranchiseDirectoryController.php:811
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#615hattch2022prod3.24msselect * from `brands` where `brands`.`id` in (7017918, 7017929, 7017930, 7017931, 7017932, 7017934, 7017937, 7017940, 7017941, 7017943, 7017944, 7017945, 7017946, 7017947, 7017948, 7017949, 7017950, 7017951, 7017953, 7017956, 7017959, 7017960, 7017962, 7017963, 7017964, 7017965, 7017967, 7017968, 7017969, 7017970, 7017971, 7017972, 7017973, 7017978, 7017981, 7017984)
      Backtrace
      • app/Services/BusinessListingService.php:615
      • app/Http/Controllers/FranchiseDirectoryController.php:811
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#615hattch2022prod7.32msselect * from `homepages` where `homepages`.`brand_id` in (7017918, 7017929, 7017930, 7017931, 7017932, 7017934, 7017937, 7017940, 7017941, 7017943, 7017944, 7017945, 7017946, 7017947, 7017948, 7017949, 7017950, 7017951, 7017953, 7017956, 7017959, 7017960, 7017962, 7017963, 7017964, 7017965, 7017967, 7017968, 7017969, 7017970, 7017971, 7017972, 7017973, 7017978, 7017981, 7017984)
      Backtrace
      • app/Services/BusinessListingService.php:615
      • app/Http/Controllers/FranchiseDirectoryController.php:811
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#615hattch2022prod2.41msselect * from `industries` where `industries`.`id` in (1, 2, 3, 4, 5, 6, 7, 8) and `industries`.`deleted_at` is null
      Backtrace
      • app/Services/BusinessListingService.php:615
      • app/Http/Controllers/FranchiseDirectoryController.php:811
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#615hattch2022prod2.53msselect * from `post_codes` where 0 = 1
      Backtrace
      • app/Services/BusinessListingService.php:615
      • app/Http/Controllers/FranchiseDirectoryController.php:811
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#856hattch2022prod2.44msselect `id` from `industries` where `industry_slug` = 'home-professional-services' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: home-professional-services
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:856
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FranchiseDirectoryController.php#870hattch2022prod2.78msselect count(*) as aggregate from `listings` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `brands` on `listings`.`brand_id` = `brands`.`id` where `post_codes`.`postcode` = '5067' and `post_codes`.`state` = 'SA' and `post_codes`.`suburb` in ('Norwood') and `listings`.`status` = 'open' and (`brands`.`industry_id` = 8 or `brands`.`secondary_industry_id` = 8)
      Bindings
      • 0: 5067
      • 1: SA
      • 2: Norwood
      • 3: open
      • 4: 8
      • 5: 8
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:870
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • BusinessListingService.php#34hattch2022prod2.36msselect `id` from `industries` where `industry_slug` = 'home-professional-services' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: home-professional-services
      Backtrace
      • app/Services/BusinessListingService.php:34
      • app/Services/BusinessListingService.php:1276
      • app/Http/Controllers/FranchiseDirectoryController.php:905
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • BusinessListingService.php#1488hattch2022prod3.11msselect count(*) as aggregate from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and (`brands`.`industry_id` in (8) or `brands`.`secondary_industry_id` in (8))
      Bindings
      • 0: open
      • 1: 1
      • 2: 8
      • 3: 8
      Backtrace
      • app/Services/BusinessListingService.php:1488
      • app/Http/Controllers/FranchiseDirectoryController.php:905
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1488hattch2022prod4.56msselect distinct `listings`.`id`, `listings`.`name`, `listings`.`overview`, `listings`.`min_investment`, `listings`.`max_investment`, `listings`.`new`, `listings`.`status`, `listings`.`post_code_id`, `listings`.`brand_id`, `listings`.`created_at`, `listings`.`updated_at`, `listings`.`category_id`, `brands`.`id` as `brand_id_relation`, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `industries`.`industry`, `industries`.`industry_slug`, `post_codes`.`suburb`, `post_codes`.`state`, `post_codes`.`postcode`, (6751 * acos(cos(radians(-34.92135)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(138.63206)) + sin(radians(-34.92135)) * sin(radians(post_codes.lat)))) AS distance_km, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_listing_image")) as mobile_listing_image from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and (`brands`.`industry_id` in (8) or `brands`.`secondary_industry_id` in (8)) order by `distance_km` asc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      • 2: 8
      • 3: 8
      Backtrace
      • app/Services/BusinessListingService.php:1488
      • app/Http/Controllers/FranchiseDirectoryController.php:905
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1488hattch2022prod2.61msselect * from `brands` where `brands`.`id` in (7017925, 7017926, 7017944, 7017978)
      Backtrace
      • app/Services/BusinessListingService.php:1488
      • app/Http/Controllers/FranchiseDirectoryController.php:905
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1488hattch2022prod3.09msselect * from `homepages` where `homepages`.`brand_id` in (7017925, 7017926, 7017944, 7017978)
      Backtrace
      • app/Services/BusinessListingService.php:1488
      • app/Http/Controllers/FranchiseDirectoryController.php:905
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1488hattch2022prod2.42msselect * from `industries` where `industries`.`id` in (8) and `industries`.`deleted_at` is null
      Backtrace
      • app/Services/BusinessListingService.php:1488
      • app/Http/Controllers/FranchiseDirectoryController.php:905
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1488hattch2022prod2.71msselect * from `post_codes` where `post_codes`.`id` in (3073, 4868, 5416, 5691, 5899, 5971, 6172, 6204, 6369, 6706, 7222, 7235, 10717, 10742, 10845, 10947, 11104, 11191, 11734, 11744, 11806, 11814, 11821, 11838, 11843, 11908, 12001, 14343, 14543, 14630, 15160, 15161, 15176, 15224)
      Backtrace
      • app/Services/BusinessListingService.php:1488
      • app/Http/Controllers/FranchiseDirectoryController.php:905
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#1264hattch2022prod2.59msselect * from `brands` where `id` in (7017925, 7017944, 7017926, 7017978)
      Bindings
      • 0: 7017925
      • 1: 7017944
      • 2: 7017926
      • 3: 7017978
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:1264
      • app/Http/Controllers/FranchiseDirectoryController.php:1097
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#1270hattch2022prod2.94msselect * from `post_codes` where `id` in (10717, 10742, 11814, 11806, 11838, 10947, 11191, 12001, 11843, 11734, 11908, 11821, 11744, 10845, 11104, 5691, 7235, 6369, 5899, 6172, 7222, 6204, 6706, 4868, 5971, 5416, 15161, 15176, 15160, 15224, 14343, 14543, 14630, 3073)
      Bindings
      • 0: 10717
      • 1: 10742
      • 2: 11814
      • 3: 11806
      • 4: 11838
      • 5: 10947
      • 6: 11191
      • 7: 12001
      • 8: 11843
      • 9: 11734
      • 10: 11908
      • 11: 11821
      • 12: 11744
      • 13: 10845
      • 14: 11104
      • 15: 5691
      • 16: 7235
      • 17: 6369
      • 18: 5899
      • 19: 6172
      • 20: 7222
      • 21: 6204
      • 22: 6706
      • 23: 4868
      • 24: 5971
      • 25: 5416
      • 26: 15161
      • 27: 15176
      • 28: 15160
      • 29: 15224
      • 30: 14343
      • 31: 14543
      • 32: 14630
      • 33: 3073
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:1270
      • app/Http/Controllers/FranchiseDirectoryController.php:1097
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#1277hattch2022prod2.4msselect * from `categories` where `id` in (3, 1)
      Bindings
      • 0: 3
      • 1: 1
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:1277
      • app/Http/Controllers/FranchiseDirectoryController.php:1097
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#1287hattch2022prod2.36msselect * from `industries` where `id` in (8)
      Bindings
      • 0: 8
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:1287
      • app/Http/Controllers/FranchiseDirectoryController.php:1097
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#1295hattch2022prod2.58msselect * from `survey_questions` where `brand_id` in (7017925, 7017944, 7017926, 7017978) and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017925
      • 1: 7017944
      • 2: 7017926
      • 3: 7017978
      • 4: 1
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:1295
      • app/Http/Controllers/FranchiseDirectoryController.php:1097
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#1301hattch2022prod3.14msselect * from `homepages` where `brand_id` in (7017925, 7017944, 7017926, 7017978)
      Bindings
      • 0: 7017925
      • 1: 7017944
      • 2: 7017926
      • 3: 7017978
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:1301
      • app/Http/Controllers/FranchiseDirectoryController.php:1097
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#1123hattch2022prod2.44msselect `industry_slug`, `industry` from `industries`
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:1123
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FranchiseDirectoryController.php#1136hattch2022prod2.42msselect `postcode` from `post_codes` where `postcode` = '5067' limit 10
      Bindings
      • 0: 5067
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:1136
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FranchiseDirectoryController.php#1139hattch2022prod2.54msselect * from `post_codes` where `postcode` in ('5067', 5067, 5067, 5067, 5067)
      Bindings
      • 0: 5067
      • 1: 5067
      • 2: 5067
      • 3: 5067
      • 4: 5067
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:1139
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • breadcrumb.blade.php#60hattch2022prod2.62msselect * from `post_codes` where `id` = 11697 limit 1
      Bindings
      • 0: 11697
      Backtrace
      • view::pages.home.breadcrumb:60
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • frontpage-layout.blade.php#257hattch2022prod2.43msselect * from `industries` where `industry_slug` = 'home-professional-services' limit 1
      Bindings
      • 0: home-professional-services
      Backtrace
      • view::brand.common.frontpage-layout:257
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • frontpage-layout.blade.php#320hattch2022prod2.44msselect * from `industries` where `id` = 8 limit 1
      Bindings
      • 0: 8
      Backtrace
      • view::brand.common.frontpage-layout:320
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • frontpage-layout.blade.php#383hattch2022prod2.46msselect * from `post_codes` where `id` = 11697 limit 1
      Bindings
      • 0: 11697
      Backtrace
      • view::brand.common.frontpage-layout:383
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • frontpage-layout.blade.php#416hattch2022prod2.47msselect * from `industries` where `industry_slug` = 'home-professional-services' limit 1
      Bindings
      • 0: home-professional-services
      Backtrace
      • view::brand.common.frontpage-layout:416
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • header-filters.blade.php#50hattch2022prod2.38msselect * from `post_codes` where `id` = 11697 limit 1
      Bindings
      • 0: 11697
      Backtrace
      • view::pages.home.partials.header-filters:50
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • header-filters.blade.php#99hattch2022prod2.47msSELECT minimum_investment from `brands` GROUP BY minimum_investment ORDER BY minimum_investment ASC;
      Backtrace
      • view::pages.home.partials.header-filters:99
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • header-filters.blade.php#118hattch2022prod2.44msSELECT maximum_investment from `brands` GROUP BY maximum_investment ORDER BY maximum_investment ASC;
      Backtrace
      • view::pages.home.partials.header-filters:118
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • header-filters.blade.php#172hattch2022prod2.37msselect * from `industries` where `industries`.`deleted_at` is null order by `industry` asc
      Backtrace
      • view::pages.home.partials.header-filters:172
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    App\Models\Listing
    180Listing.php#?
    App\Models\PostCode
    105PostCode.php#?
    App\Models\Brand
    47Brand.php#?
    App\Models\Homepage
    47Homepage.php#?
    App\Models\Industry
    24Industry.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-07-03 18:37:57GET/businesses-for-sale/within-home-professional-services/in-norwood-sa-5067?distance=99999482556403