business for sale hattch logo mobile

Selected Location

Newport (3015)
From
To
×

11 Home or Professional Services businesses for sale in Newport VIC 3015

Target Icon
Which franchises are thebest match for you?

11 businesses for sale

business for sale MailPlus logo
A graphic representing a compatibility score out of 100%
?%
match

MailPlus: Port Melbourne

Port Melbourne, VIC 3207 3.9 km away

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

View
business for sale Signwave Australia logo
A graphic representing a compatibility score out of 100%
?%
match

Signwave Australia: Melbourne West

Footscray, VIC 3011 5.4 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

View
business for sale MailPlus logo
A graphic representing a compatibility score out of 100%
?%
match

MailPlus: South Melbourne

South Melbourne, VIC 3205 6.9 km away

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

View
business for sale MailPlus logo
A graphic representing a compatibility score out of 100%
?%
match

MailPlus: Hawthorn

Hawthorn, VIC 3122 13.8 km away

(more)

Total Investment: From $100K

Business Type: Franchise Resale

View
business for sale Signwave Australia logo
A graphic representing a compatibility score out of 100%
?%
match

Signwave Australia: Melbourne East

Hawthorn, VIC 3122 13.8 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

View
business for sale MailPlus logo
A graphic representing a compatibility score out of 100%
?%
match

MailPlus: Airport West

Airport West, VIC 3042 14.5 km away

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

View
business for sale MailPlus logo
A graphic representing a compatibility score out of 100%
?%
match

MailPlus: Hoppers Crossing

Hoppers Crossing, VIC 3029 17.2 km away

(more)

Total Investment: From $50K

Business Type: Franchise Resale

View
business for sale MailPlus logo
A graphic representing a compatibility score out of 100%
?%
match

MailPlus: Campbellfield

Campbellfield, VIC 3061 22.2 km away

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

View
business for sale MailPlus logo
A graphic representing a compatibility score out of 100%
?%
match

MailPlus: Lalor

Lalor, VIC 3075 24.2 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

View
business for sale MailPlus logo
A graphic representing a compatibility score out of 100%
?%
match

MailPlus: Bayswater

Bayswater, VIC 3153 35.3 km away

(more)

Total Investment: From $100K

Business Type: Franchise Resale

View
business for sale MailPlus logo
A graphic representing a compatibility score out of 100%
?%
match

MailPlus: Seaford

Frankston, VIC 3199 43.2 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

View
Want to see more listings?

You've reached the end of listings within 50 km of your location. Expand your search radius to find more businesses (you'll stay on the current page):

100 km 200 km All of Australia
Messages50RequestTimelineExceptionsViews22Queries59Models298Livewire0MailsGate
SettingsRequest history359msRequest Duration6MBMemory 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-newport...
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:50:48] LOG.info: ValidateBusinessListingUrl processing request { "path": "businesses-for-sal...
  • infolog[18:50:48] LOG.info: Route has location parameter, passing through { "location": "newport-vic-30...
  • infolog[18:50:48] LOG.info: Processing single location parameter { "location": "newport-vic-3015", ...
  • infolog[18:50:48] LOG.info: Successfully parsed location parameter { "location": "newport-vic-3015", ...
  • infolog[18:50:48] LOG.info: Cookie debugging in FranchiseDirectoryController { "path": "businesses-for-...
  • infolog[18:50:48] LOG.info: Parameters received: { "industry": "home-professional-services", "franc...
  • infolog[18:50:48] LOG.info: User is not authenticated on filtered listings page { "host": "directory.te...
  • infolog[18:50:48] LOG.info: Populated filter arrays from parsed location { "suburb": "newport", "st...
  • infolog[18:50:48] LOG.info: Starting getFilteredListings with filters: { "locations": [], "business...
  • infolog[18:50:48] LOG.info: Applying industry filter: { "industry": "home-professional-services" }
  • infolog[18:50:48] LOG.info: Using single known industry: { "industry": "home-professional-services" }
  • infolog[18:50:48] LOG.info: Applying location filters: { "suburb": [ "newport" ], "stat...
  • infolog[18:50:48] LOG.info: Using postcodes for filtering: { "postcodes": [ "3015" ] }
  • infolog[18:50:48] LOG.info: Including nearby postcodes: { "count": 38, "postcodes": [ 3015,...
  • infolog[18:50:48] LOG.info: Adding distance_km to select for sorting by distance
  • debuglog[18:50:48] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.*, `brands`.`id` as ...
  • infolog[18:50:48] LOG.info: Successfully retrieved listings { "total": 3, "per_page": 36, "curr...
  • infolog[18:50:48] LOG.info: Listings retrieved: { "count": 3, "total": 3 }
  • infolog[18:50:48] LOG.info: Caching filter options for 30 minutes
  • errorlog[18:50:48] LOG.error: Error getting filter options: file_put_contents(/var/app/current/storage/frame...
  • infolog[18:50:48] LOG.info: Brand IDs found: { "ids": [ 7017978, 7017944 ] }
  • infolog[18:50:48] LOG.info: Retrieved postcode record for brand filters: { "postcode": "3015", "has...
  • infolog[18:50:48] LOG.info: Adding coordinates to brand filters for distance search: { "lat": "-37.8454...
  • infolog[18:50:48] LOG.info: Setting distance parameter for brands: { "max_distance": 50 }
  • infolog[18:50:48] LOG.info: Local brand count check (exact postcode): { "postcode": "3015", "localB...
  • infolog[18:50:48] LOG.info: Starting getFilteredBrands with filters: { "locations": [], "businessTy...
  • infolog[18:50:48] LOG.info: Applying industry filter: { "industry": "home-professional-services" }
  • infolog[18:50:48] LOG.info: Using single known industry: { "industry": "home-professional-services" }
  • infolog[18:50:48] LOG.info: Using coordinates for distance-based search: { "lat": -37.84549, "lng":...
  • debuglog[18:50:48] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:50:48] LOG.info: Successfully retrieved brands { "total": 2, "per_page": 36, "curren...
  • infolog[18:50:48] LOG.info: Postcode found: { "id": 5862, "suburb": "Newport" }
  • infolog[18:50:48] LOG.info: Final postcodeArray before passing to view: { "postcodeArray": [ { ...
  • infolog[18:50:48] LOG.info: Starting getDefaultListings without filters
  • debuglog[18:50:48] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.* from `listings` in...
  • infolog[18:50:48] LOG.info: Successfully retrieved listings { "total": 2552, "per_page": 36, "c...
  • infolog[18:50:48] LOG.info: Starting getDefaultBrands without filters
  • debuglog[18:50:48] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:50:48] LOG.info: Successfully retrieved listings { "total": 42, "per_page": 36, "cur...
  • infolog[18:50:48] LOG.info: Exact location listing count { "suburb": "newport", "state": "VIC", ...
  • infolog[18:50:48] LOG.info: Starting getNearbyListings with filters: { "locations": [], "businessTy...
  • infolog[18:50:48] LOG.info: Applying industry filter: { "industry": "home-professional-services" }
  • infolog[18:50:48] LOG.info: Using where for single industry { "industry": "home-professional-services" ...
  • debuglog[18:50:48] LOG.debug: Final SQL query for nearby listings: { "sql": "select distinct `listings`....
  • infolog[18:50:48] LOG.info: Successfully retrieved nearby listings { "total": 11, "per_page": 36, ...
  • infolog[18:50:48] LOG.info: Display flags: { "hasExactLocationSearch": true, "originalBrandCount": ...
  • infolog[18:50:48] LOG.info: Getting industry IDs from slug { "slug": "home-professional-services" }
  • infolog[18:50:48] LOG.info: Found industry from direct lookup { "slug": "home-professional-services", ...
  • infolog[18:50:48] LOG.info: Final industry IDs from slug { "slug": "home-professional-services", "i...
  • infolog[18:50:48] LOG.info: View data prepared successfully
infodebugerror
status
200 OK
full_url
http://directory.testing.hattch.net/businesses-for-sale/within-home-professional-services/in-newport...
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
362ms
peak_memory
8MB
response
text/html; charset=UTF-8
request_format
html
request_query
  0 of 0   
array:1 [▼
  "distance" => "50"
]
request_request
[]
request_headers
  0 of 0   
array:13 [▼
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "via" => array:1 [▶
    0 => "1.1 squid-proxy-5b5d847c96-kml6h (squid/6.10)"
  ]
  "cookie" => array:1 [▶
    0 => "_clck=lwhbtr%7C2%7Cfxa%7C0%7C2010"
  ]
  "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-68664468-33f651f14db7beb222ff80af"
  ]
  "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
  0 of 0   
array:1 [▼
  "_clck" => "lwhbtr|2|fxa|0|2010"
]
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:50:48 GMT"
  ]
]
session_attributes
  0 of 0   
array:1 [▼
  "_token" => "XVJChzhcIjEuQQy3hxsAoDf7SesjqZFnUxKWXwPJ"
]
  • Booting (23.47ms)time
  • Application (336ms)time
  • Routing (2.02ms)
  • View: pages.home.brandviews
  • View: pages.home.breadcrumbviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.dir_empty_resultsviews
  • 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 (93.46%)
    336ms
    1 x Booting (6.54%)
    23.47ms
    1 x Routing (0.56%)
    2.02ms
    22 x View (0%)
    0μs
    22 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.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
    59 statements were executed (20 duplicates)Show only duplicates262ms
    • 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#328hattch2022prod12.28msselect 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.41msselect `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#34hattch2022prod2.92msselect `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#267hattch2022prod3.91msselect `to_postcode` from `distances` where `from_postcode` in ('3015') order by `distance_km` asc
      Bindings
      • 0: 3015
      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.85msselect 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 ('3015') 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 (3015, 3015, 3013, 3016, 3207, 3011, 3003, 3008, 3031, 3025, 3019, 3018, 3012, 3006, 3206, 3205, 3051, 3053, 3034, 3039, 3052, 3032, 3000, 3065, 3055, 3182, 3002, 3054, 3026, 3020, 3040, 3056, 3030, 3066, 3141, 3028, 3022, '3015')
      Bindings
      • 0: 3015
      • 1: open
      • 2: 1
      • 3: 8
      • 4: 8
      • 5: 3015
      • 6: 3015
      • 7: 3013
      • 8: 3016
      • 9: 3207
      • 10: 3011
      • 11: 3003
      • 12: 3008
      • 13: 3031
      • 14: 3025
      • 15: 3019
      • 16: 3018
      • 17: 3012
      • 18: 3006
      • 19: 3206
      • 20: 3205
      • 21: 3051
      • 22: 3053
      • 23: 3034
      • 24: 3039
      • 25: 3052
      • 26: 3032
      • 27: 3000
      • 28: 3065
      • 29: 3055
      • 30: 3182
      • 31: 3002
      • 32: 3054
      • 33: 3026
      • 34: 3020
      • 35: 3040
      • 36: 3056
      • 37: 3030
      • 38: 3066
      • 39: 3141
      • 40: 3028
      • 41: 3022
      • 42: 3015
      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.11msselect 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 ('3015') 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 (3015, 3015, 3013, 3016, 3207, 3011, 3003, 3008, 3031, 3025, 3019, 3018, 3012, 3006, 3206, 3205, 3051, 3053, 3034, 3039, 3052, 3032, 3000, 3065, 3055, 3182, 3002, 3054, 3026, 3020, 3040, 3056, 3030, 3066, 3141, 3028, 3022, '3015') order by CASE WHEN post_codes.postcode IN ('3015') THEN 0 ELSE 1 END, `distances`.`distance_km` asc, `post_codes`.`postcode` asc limit 36 offset 0
      Bindings
      • 0: 3015
      • 1: open
      • 2: 1
      • 3: 8
      • 4: 8
      • 5: 3015
      • 6: 3015
      • 7: 3013
      • 8: 3016
      • 9: 3207
      • 10: 3011
      • 11: 3003
      • 12: 3008
      • 13: 3031
      • 14: 3025
      • 15: 3019
      • 16: 3018
      • 17: 3012
      • 18: 3006
      • 19: 3206
      • 20: 3205
      • 21: 3051
      • 22: 3053
      • 23: 3034
      • 24: 3039
      • 25: 3052
      • 26: 3032
      • 27: 3000
      • 28: 3065
      • 29: 3055
      • 30: 3182
      • 31: 3002
      • 32: 3054
      • 33: 3026
      • 34: 3020
      • 35: 3040
      • 36: 3056
      • 37: 3030
      • 38: 3066
      • 39: 3141
      • 40: 3028
      • 41: 3022
      • 42: 3015
      • 43: 3015
      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.5msselect * from `brands` where `brands`.`id` in (7017944, 7017978)
      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.28msselect * from `homepages` where `homepages`.`brand_id` in (7017944, 7017978)
      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.37msselect * 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.55msselect * from `post_codes` where `post_codes`.`id` in (6172, 6204, 6706)
      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#1094hattch2022prod2.31msselect * from `industries` where `industries`.`deleted_at` is null order by `industry` asc
      Backtrace
      • app/Services/BusinessListingService.php:1094
      • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • app/Services/BusinessListingService.php:1090
      • app/Http/Controllers/FranchiseDirectoryController.php:597
    • BusinessListingService.php#1095hattch2022prod2.35msselect * from `franchise_types` order by `type` asc
      Backtrace
      • app/Services/BusinessListingService.php:1095
      • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • app/Services/BusinessListingService.php:1090
      • app/Http/Controllers/FranchiseDirectoryController.php:597
    • BusinessListingService.php#1096hattch2022prod2.38msselect * from `categories` where `categories`.`deleted_at` is null order by `category` asc
      Backtrace
      • app/Services/BusinessListingService.php:1096
      • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • app/Services/BusinessListingService.php:1090
      • app/Http/Controllers/FranchiseDirectoryController.php:597
    • FranchiseDirectoryController.php#624hattch2022prod2.42msselect * from `post_codes` where `postcode` = '3015' limit 1
      Bindings
      • 0: 3015
      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.39msselect `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#730hattch2022prod2.92msselect 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` = '3015' and (`brands`.`industry_id` = 8 or `brands`.`secondary_industry_id` = 8)
      Bindings
      • 0: open
      • 1: 1
      • 2: 3015
      • 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#34hattch2022prod2.39msselect `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#1053hattch2022prod4.56msselect 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(-37.84549)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.88329)) + sin(radians(-37.84549)) * 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` having MIN((6751 * acos(cos(radians(-37.84549)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.88329)) + sin(radians(-37.84549)) * sin(radians(post_codes.lat))))) <= 50) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 8
      • 3: 8
      • 4: 50
      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.5msselect 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(-37.84549)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.88329)) + sin(radians(-37.84549)) * 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` having MIN((6751 * acos(cos(radians(-37.84549)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.88329)) + sin(radians(-37.84549)) * sin(radians(post_codes.lat))))) <= 50 order by MIN((6751 * acos(cos(radians(-37.84549)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.88329)) + sin(radians(-37.84549)) * sin(radians(post_codes.lat))))) asc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      • 2: 8
      • 3: 8
      • 4: 50
      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.03msselect * from `homepages` where `homepages`.`brand_id` in (7017944, 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.33msselect * 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.12msselect * from `listings` where `listings`.`brand_id` in (7017944, 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.65msselect * from `post_codes` where `post_codes`.`id` in (110, 124, 376, 689, 813, 1964, 1986, 2634, 3054, 3073, 3444, 3989, 4100, 4264, 4868, 5416, 5691, 5899, 5971, 6172, 6204, 6369, 6706, 7222, 7235, 7812, 7820, 7898, 7914, 10177, 11838, 13588, 14920, 15160, 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.5msselect * from `post_codes` where `suburb` in ('Newport') and `state` = 'VIC' and `postcode` = '3015' limit 1
      Bindings
      • 0: Newport
      • 1: VIC
      • 2: 3015
      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#498hattch2022prod11.3msselect 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#498hattch2022prod38.53msselect 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#615hattch2022prod22.68msselect 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#615hattch2022prod20.53msselect 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.13msselect * 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#615hattch2022prod9.54msselect * 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.63msselect * 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.32msselect * 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.73msselect 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` = '3015' and `post_codes`.`state` = 'VIC' and `post_codes`.`suburb` in ('Newport') and `listings`.`status` = 'open' and (`brands`.`industry_id` = 8 or `brands`.`secondary_industry_id` = 8)
      Bindings
      • 0: 3015
      • 1: VIC
      • 2: Newport
      • 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.32msselect `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.94msselect count(*) as aggregate from (select 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(-37.84549)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.88329)) + sin(radians(-37.84549)) * 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)) having distance_km <= 50) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 8
      • 3: 8
      • 4: 50
      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.67msselect 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(-37.84549)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.88329)) + sin(radians(-37.84549)) * 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)) having distance_km <= 50 order by `distance_km` asc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      • 2: 8
      • 3: 8
      • 4: 50
      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.66msselect * from `brands` where `brands`.`id` in (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.83msselect * from `homepages` where `homepages`.`brand_id` in (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.44msselect * 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.84msselect * from `post_codes` where `post_codes`.`id` in (4868, 5416, 5899, 5971, 6172, 6204, 6369, 6706, 7222, 7235)
      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.64msselect * from `brands` where `id` in (7017944, 7017978)
      Bindings
      • 0: 7017944
      • 1: 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.5msselect * from `post_codes` where `id` in (6204, 6172, 6706, 4868, 6369, 7235, 5899, 7222, 5971, 5416)
      Bindings
      • 0: 6204
      • 1: 6172
      • 2: 6706
      • 3: 4868
      • 4: 6369
      • 5: 7235
      • 6: 5899
      • 7: 7222
      • 8: 5971
      • 9: 5416
      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.34msselect * 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.35msselect * 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.59msselect * from `survey_questions` where `brand_id` in (7017944, 7017978) and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017944
      • 1: 7017978
      • 2: 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#1301hattch2022prod2.82msselect * from `homepages` where `brand_id` in (7017944, 7017978)
      Bindings
      • 0: 7017944
      • 1: 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.49msselect `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.9msselect `postcode` from `post_codes` where `postcode` = '3015' limit 10
      Bindings
      • 0: 3015
      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.44msselect * from `post_codes` where `postcode` in ('3015', 3015, 3015, 3015)
      Bindings
      • 0: 3015
      • 1: 3015
      • 2: 3015
      • 3: 3015
      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.54msselect * from `post_codes` where `id` = 5862 limit 1
      Bindings
      • 0: 5862
      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.38msselect * 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.33msselect * 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.48msselect * from `post_codes` where `id` = 5862 limit 1
      Bindings
      • 0: 5862
      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.31msselect * 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` = 5862 limit 1
      Bindings
      • 0: 5862
      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.37msSELECT 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.59msSELECT 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.4msselect * 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
    124Listing.php#?
    App\Models\PostCode
    51PostCode.php#?
    App\Models\Brand
    42Brand.php#?
    App\Models\Homepage
    42Homepage.php#?
    App\Models\Industry
    32Industry.php#?
    App\Models\FranchiseType
    4FranchiseType.php#?
    App\Models\Category
    3Category.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-07-03 18:50:48GET/businesses-for-sale/within-home-professional-services/in-newport-vic-3015?distance=50502259298