business for sale hattch logo mobile

Selected Location

Cabramatta (2166)
From
To
×

11 Home or Professional Services businesses for sale in Cabramatta NSW 2166

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: Milperra

Milperra, NSW 2214 6.9 km away

(more)

Total Investment: From $50K

Business Type: Franchise Resale

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

Signwave Australia: Sydney

Greenacre, NSW 2190 11.9 km away

(more)

Total Investment: From $300K

Business Type: Franchise Resale

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

MailPlus: Parramatta

Parramatta, NSW 2150 12.1 km away

(more)

Total Investment: From $200K

Business Type: Franchise Resale

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

Mobile Skips: Sydney West

Blacktown, NSW 2148 14.7 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

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

MailPlus: Epping

Epping, NSW 2121 20.1 km away

Take over an established MailPlus courier franchise in the thriving business hub of Epping, NSW. Located in Sydney's growing northern district, Epping offers a strategic mix of com...(more)

Total Investment: From $25K

Business Type: Franchise Resale

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

MailPlus: St Marys

St Marys, NSW 2760 23.0 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: Taren Point

Taren Point, NSW 2229 23.2 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: Sydney North

Artarmon, NSW 2064 26.4 km away

Signwave Australia offers a rare opportunity to acquire an established visual communications business in the thriving commercial hub of Artarmon, NSW. Positioned strategically on S...(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: Penrith

Penrith, NSW 2750 30.1 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: Northern Beaches

Brookvale, NSW 2100 36.3 km away

(more)

Total Investment: From $100K

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
Messages50RequestTimelineExceptionsViews22Queries59Models316Livewire0MailsGate
SettingsRequest history367msRequest 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-cabrama...
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": "cabramatta-nsw...
  • infolog[18:50:48] LOG.info: Processing single location parameter { "location": "cabramatta-nsw-2166", ...
  • infolog[18:50:48] LOG.info: Successfully parsed location parameter { "location": "cabramatta-nsw-2166",...
  • 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": "cabramatta", ...
  • 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": [ "cabramatta" ], "s...
  • infolog[18:50:48] LOG.info: Using postcodes for filtering: { "postcodes": [ "2166" ] }
  • infolog[18:50:48] LOG.info: Including nearby postcodes: { "count": 30, "postcodes": [ 2166,...
  • 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": { "0": 7017944, "2": 7017978 ...
  • infolog[18:50:48] LOG.info: Retrieved postcode record for brand filters: { "postcode": "2166", "has...
  • infolog[18:50:48] LOG.info: Adding coordinates to brand filters for distance search: { "lat": "-33.8819...
  • 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": "2166", "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": -33.88198, "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": 3, "per_page": 36, "curren...
  • infolog[18:50:48] LOG.info: Postcode found: { "id": 1286, "suburb": "Cabramatta" }
  • 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": "cabramatta", "state": "NSW", ...
  • 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-cabrama...
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
369ms
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-07bb6a6f78c701582f873fe6"
  ]
  "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" => "TvvBujGGM1SRnZ3QV9q20ZKNx5zX8qZxi3F3k37X"
]
  • Booting (15.37ms)time
  • Application (351ms)time
  • Routing (1.75ms)
  • 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 (95.8%)
    351ms
    1 x Booting (4.19%)
    15.37ms
    1 x Routing (0.48%)
    1.75ms
    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 (17 duplicates)Show only duplicates279ms
    • 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.48msselect 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.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: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.51msselect `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#267hattch2022prod2.56msselect `to_postcode` from `distances` where `from_postcode` in ('2166') order by `distance_km` asc
      Bindings
      • 0: 2166
      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.43msselect 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 ('2166') 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 (2166, 2166, 2163, 2165, 2170, 2198, 2197, 2161, 2162, 2164, 2176, 2160, 2168, 2214, 2199, 2177, 2144, 2143, 2200, 2173, 2150, 2190, 2171, 2172, 2142, 2141, 2212, 2213, 2128, '2166')
      Bindings
      • 0: 2166
      • 1: open
      • 2: 1
      • 3: 8
      • 4: 8
      • 5: 2166
      • 6: 2166
      • 7: 2163
      • 8: 2165
      • 9: 2170
      • 10: 2198
      • 11: 2197
      • 12: 2161
      • 13: 2162
      • 14: 2164
      • 15: 2176
      • 16: 2160
      • 17: 2168
      • 18: 2214
      • 19: 2199
      • 20: 2177
      • 21: 2144
      • 22: 2143
      • 23: 2200
      • 24: 2173
      • 25: 2150
      • 26: 2190
      • 27: 2171
      • 28: 2172
      • 29: 2142
      • 30: 2141
      • 31: 2212
      • 32: 2213
      • 33: 2128
      • 34: 2166
      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.32msselect 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 ('2166') 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 (2166, 2166, 2163, 2165, 2170, 2198, 2197, 2161, 2162, 2164, 2176, 2160, 2168, 2214, 2199, 2177, 2144, 2143, 2200, 2173, 2150, 2190, 2171, 2172, 2142, 2141, 2212, 2213, 2128, '2166') order by CASE WHEN post_codes.postcode IN ('2166') THEN 0 ELSE 1 END, `distances`.`distance_km` asc, `post_codes`.`postcode` asc limit 36 offset 0
      Bindings
      • 0: 2166
      • 1: open
      • 2: 1
      • 3: 8
      • 4: 8
      • 5: 2166
      • 6: 2166
      • 7: 2163
      • 8: 2165
      • 9: 2170
      • 10: 2198
      • 11: 2197
      • 12: 2161
      • 13: 2162
      • 14: 2164
      • 15: 2176
      • 16: 2160
      • 17: 2168
      • 18: 2214
      • 19: 2199
      • 20: 2177
      • 21: 2144
      • 22: 2143
      • 23: 2200
      • 24: 2173
      • 25: 2150
      • 26: 2190
      • 27: 2171
      • 28: 2172
      • 29: 2142
      • 30: 2141
      • 31: 2212
      • 32: 2213
      • 33: 2128
      • 34: 2166
      • 35: 2166
      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.6msselect * 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#446hattch2022prod5.78msselect * 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.39msselect * 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.59msselect * from `post_codes` where `post_codes`.`id` in (110, 124, 1964)
      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.57msselect * 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.45msselect * 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.49msselect * 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.4msselect * from `post_codes` where `postcode` = '2166' limit 1
      Bindings
      • 0: 2166
      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.45msselect `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.85msselect 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` = '2166' and (`brands`.`industry_id` = 8 or `brands`.`secondary_industry_id` = 8)
      Bindings
      • 0: open
      • 1: 1
      • 2: 2166
      • 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.47msselect `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.26msselect 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(-33.88198)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(150.9227)) + sin(radians(-33.88198)) * 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(-33.88198)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(150.9227)) + sin(radians(-33.88198)) * 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#1053hattch2022prod6.03msselect 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(-33.88198)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(150.9227)) + sin(radians(-33.88198)) * 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(-33.88198)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(150.9227)) + sin(radians(-33.88198)) * sin(radians(post_codes.lat))))) <= 50 order by MIN((6751 * acos(cos(radians(-33.88198)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(150.9227)) + sin(radians(-33.88198)) * 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#1053hattch2022prod5.69msselect * from `homepages` where `homepages`.`brand_id` in (7017926, 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.42msselect * 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#1053hattch2022prod2.96msselect * from `listings` where `listings`.`brand_id` in (7017926, 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.81msselect * from `post_codes` where `post_codes`.`id` in (110, 124, 376, 385, 689, 813, 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, 8820, 9507, 10177, 10718, 11838, 13588, 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.48msselect * from `post_codes` where `suburb` in ('Cabramatta') and `state` = 'NSW' and `postcode` = '2166' limit 1
      Bindings
      • 0: Cabramatta
      • 1: NSW
      • 2: 2166
      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#498hattch2022prod17.79msselect 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#498hattch2022prod40.67msselect 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.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 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.56msselect 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.41msselect * 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.62msselect * 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.43msselect * 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.23msselect * 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.49msselect `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.7msselect 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` = '2166' and `post_codes`.`state` = 'NSW' and `post_codes`.`suburb` in ('Cabramatta') and `listings`.`status` = 'open' and (`brands`.`industry_id` = 8 or `brands`.`secondary_industry_id` = 8)
      Bindings
      • 0: 2166
      • 1: NSW
      • 2: Cabramatta
      • 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.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/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.88msselect 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(-33.89828)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(150.93609)) + sin(radians(-33.89828)) * 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.93msselect 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(-33.89828)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(150.93609)) + sin(radians(-33.89828)) * 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.62msselect * from `brands` where `brands`.`id` in (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 (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.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.43msselect * from `post_codes` where `post_codes`.`id` in (110, 124, 385, 689, 1964, 1986, 3054, 3073, 3444, 3989, 4100)
      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.6msselect * from `brands` where `id` in (7017944, 7017978, 7017926)
      Bindings
      • 0: 7017944
      • 1: 7017978
      • 2: 7017926
      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 (124, 110, 1964, 385, 1986, 3054, 689, 3444, 4100, 3073, 3989)
      Bindings
      • 0: 124
      • 1: 110
      • 2: 1964
      • 3: 385
      • 4: 1986
      • 5: 3054
      • 6: 689
      • 7: 3444
      • 8: 4100
      • 9: 3073
      • 10: 3989
      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.42msselect * 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.41msselect * 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#1295hattch2022prod3.54msselect * from `survey_questions` where `brand_id` in (7017944, 7017978, 7017926) and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017944
      • 1: 7017978
      • 2: 7017926
      • 3: 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.92msselect * from `homepages` where `brand_id` in (7017944, 7017978, 7017926)
      Bindings
      • 0: 7017944
      • 1: 7017978
      • 2: 7017926
      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.37msselect `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#1136hattch2022prod3.84msselect `postcode` from `post_codes` where `postcode` = '2166' limit 10
      Bindings
      • 0: 2166
      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.49msselect * from `post_codes` where `postcode` in ('2166', 2166, 2166, 2166, 2166, 2166)
      Bindings
      • 0: 2166
      • 1: 2166
      • 2: 2166
      • 3: 2166
      • 4: 2166
      • 5: 2166
      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.46msselect * from `post_codes` where `id` = 1286 limit 1
      Bindings
      • 0: 1286
      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.33msselect * 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.28msselect * 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.35msselect * from `post_codes` where `id` = 1286 limit 1
      Bindings
      • 0: 1286
      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.43msselect * 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` = 1286 limit 1
      Bindings
      • 0: 1286
      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#99hattch2022prod7.71msSELECT 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.52msSELECT 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.38msselect * 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
    131Listing.php#?
    App\Models\PostCode
    58PostCode.php#?
    App\Models\Brand
    44Brand.php#?
    App\Models\Homepage
    44Homepage.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-cabramatta-nsw-2166?distance=50502259316