459 Health, Beauty & Fitness businesses for sale in Quinns Rocks WA 6030

S30 Studio: East Vic Park

(more)

Total Investment: From $200K

Business Type: New Franchise

REVL: Como

Como, WA 6152 43.3 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

Listen To Your Body: Applecross

(more)

Total Investment: From $200K

Business Type: New Franchise

REVL: Applecross

Discover a premium fitness opportunity in the affluent riverside suburb of Applecross, where discerning residents value health and wellness as part of their lifestyle. Nestled amon...(more)

Total Investment: From $200K

Business Type: New Franchise

REVL: Kewdale

Kewdale, WA 6105 45.0 km away

Secure your position in Kewdale's dynamic business landscape with this REVL franchise opportunity. Located in Perth's industrial hub, Kewdale offers strategic advantages with its p...(more)

Total Investment: From $200K

Business Type: New Franchise

S30 Studio: Fremantle

(more)

Total Investment: From $200K

Business Type: New Franchise

REVL: Fremantle

(more)

Total Investment: From $200K

Business Type: New Franchise

S30 Studio: Booragoon

(more)

Total Investment: From $200K

Business Type: New Franchise

REVL: Queens Park

(more)

Total Investment: From $200K

Business Type: New Franchise

REVL: Riverton

Riverton, WA 6148 47.8 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

REVL: Murdoch

Murdoch, WA 6150 49.6 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

REVL: Spearwood

(more)

Total Investment: From $200K

Business Type: New Franchise

REVL: Thornlie

Thornlie, WA 6108 53.3 km away

Join the revolution in fitness and wellness with REVL in Thornlie, WA, a vibrant suburb positioned perfectly between Perth's CBD and the growing southeastern corridor. This strateg...(more)

Total Investment: From $200K

Business Type: New Franchise

REVL: Gosnells

Gosnells, WA 6110 58.0 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

REVL: Success

Success, WA 6164 58.2 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

REVL: Armadale

Armadale, WA 6112 65.3 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

REVL: Kwinana

(more)

Total Investment: From $200K

Business Type: New Franchise

REVL: Rockingham

Discover a premium fitness opportunity with REVL in Rockingham, WA, where the growing coastal community offers an ideal market for our innovative fitness concept. Nestled between p...(more)

Total Investment: From $200K

Business Type: New Franchise

REVL: Menora Bay

(more)

Total Investment: From $200K

Business Type: New Franchise

REVL: Mandurah

Mandurah, WA 6210 101.3 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

BurnTheory: Aldinga Beach

Aldinga Beach, SA 5173 2,272.0 km away

(more)

Total Investment: From $100K

Business Type: New Franchise

Listen To Your Body: Henley Beach

Henley Beach, SA 5022 2,272.9 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

BurnTheory: Henley Beach

Henley Beach, SA 5022 2,272.9 km away

(more)

Total Investment: From $100K

Business Type: New Franchise

BurnTheory: Port Adelaide

Port Adelaide, SA 5015 2,273.7 km away

(more)

Total Investment: From $100K

Business Type: New Franchise

REVL: Port Adelaide

Port Adelaide, SA 5015 2,273.7 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

REVL: Noarlunga

(more)

Total Investment: From $200K

Business Type: New Franchise

REVL: Glenelg

Glenelg, SA 5045 2,275.0 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

BurnTheory: Glenelg

Glenelg, SA 5045 2,275.0 km away

(more)

Total Investment: From $100K

Business Type: New Franchise

REVL: Hallett Cove

Hallett Cove, SA 5158 2,275.2 km away

Discover a premium fitness opportunity with REVL in the picturesque coastal suburb of Hallett Cove, where the growing community and stunning beachside location create an ideal envi...(more)

Total Investment: From $200K

Business Type: New Franchise

BurnTheory: Somerton Park

Somerton Park, SA 5044 2,275.6 km away

(more)

Total Investment: From $100K

Business Type: New Franchise

Kelly Sports: Greater Brighton

Brighton, SA 5048 2,276.0 km away

(more)

Total Investment: From $25K

Business Type: New Franchise

REVL: Woodville

Woodville, SA 5011 2,276.6 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

Kelly Sports: Greater South

Hackham, SA 5163 2,277.0 km away

(more)

Total Investment: From $25K

Business Type: New Franchise

BurnTheory: Morphett Vale

Morphett Vale, SA 5162 2,277.2 km away

(more)

Total Investment: From $100K

Business Type: New Franchise

BurnTheory: Edwardstown

Edwardstown, SA 5039 2,280.2 km away

(more)

Total Investment: From $100K

Business Type: New Franchise

BurnTheory: Woodcroft

Woodcroft, SA 5162 2,280.9 km away

(more)

Total Investment: From $100K

Business Type: New Franchise

SettingsRequest history316msRequest Duration5MBMemory 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-health-beauty-fitness/in-quinns-rocks...
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:38:02] LOG.info: ValidateBusinessListingUrl processing request { "path": "businesses-for-sal...
  • infolog[18:38:02] LOG.info: Route has location parameter, passing through { "location": "quinns-rocks-w...
  • infolog[18:38:02] LOG.info: Processing single location parameter { "location": "quinns-rocks-wa-6030", ...
  • infolog[18:38:02] LOG.info: Successfully parsed location parameter { "location": "quinns-rocks-wa-6030"...
  • infolog[18:38:02] LOG.info: Cookie debugging in FranchiseDirectoryController { "path": "businesses-for-...
  • infolog[18:38:02] LOG.info: Parameters received: { "industry": "health-beauty-fitness", "franchiseT...
  • infolog[18:38:02] LOG.info: User is not authenticated on filtered listings page { "host": "directory.te...
  • infolog[18:38:02] LOG.info: Populated filter arrays from parsed location { "suburb": "quinns-rocks", ...
  • infolog[18:38:02] LOG.info: Starting getFilteredListings with filters: { "locations": [], "business...
  • infolog[18:38:02] LOG.info: Applying industry filter: { "industry": "health-beauty-fitness" }
  • infolog[18:38:02] LOG.info: Using single known industry: { "industry": "health-beauty-fitness" }
  • infolog[18:38:02] LOG.info: Applying location filters: { "suburb": [ "quinns-rocks" ], ...
  • infolog[18:38:02] LOG.info: Using postcodes for filtering: { "postcodes": [ "6030" ] }
  • infolog[18:38:02] LOG.info: Including nearby postcodes: { "count": 8, "postcodes": [ 6030, ...
  • infolog[18:38:02] LOG.info: Adding distance_km to select for sorting by distance
  • debuglog[18:38:02] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.*, `brands`.`id` as ...
  • infolog[18:38:02] LOG.info: Successfully retrieved listings { "total": 1, "per_page": 36, "curr...
  • infolog[18:38:02] LOG.info: Listings retrieved: { "count": 0, "total": 1 }
  • infolog[18:38:02] LOG.info: Brand IDs found: { "ids": [] }
  • infolog[18:38:02] LOG.info: Retrieved postcode record for brand filters: { "postcode": "6030", "has...
  • infolog[18:38:02] LOG.info: Adding coordinates to brand filters for distance search: { "lat": "-31.6652...
  • infolog[18:38:02] LOG.info: Setting distance parameter for brands: { "max_distance": 99999 }
  • infolog[18:38:02] LOG.info: Local brand count check (exact postcode): { "postcode": "6030", "localB...
  • infolog[18:38:02] LOG.info: Starting getFilteredBrands with filters: { "locations": [], "businessTy...
  • infolog[18:38:02] LOG.info: Applying industry filter: { "industry": "health-beauty-fitness" }
  • infolog[18:38:02] LOG.info: Using single known industry: { "industry": "health-beauty-fitness" }
  • infolog[18:38:02] LOG.info: Using coordinates for distance-based search: { "lat": -31.66527, "lng":...
  • debuglog[18:38:02] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:38:02] LOG.info: Successfully retrieved brands { "total": 7, "per_page": 36, "curren...
  • infolog[18:38:02] LOG.info: Postcode found: { "id": 13879, "suburb": "Quinns Rocks" }
  • infolog[18:38:02] LOG.info: Final postcodeArray before passing to view: { "postcodeArray": [ { ...
  • infolog[18:38:02] LOG.info: Starting getDefaultListings without filters
  • debuglog[18:38:02] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.* from `listings` in...
  • infolog[18:38:02] LOG.info: Successfully retrieved listings { "total": 2552, "per_page": 36, "c...
  • infolog[18:38:02] LOG.info: Starting getDefaultBrands without filters
  • debuglog[18:38:02] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:38:02] LOG.info: Successfully retrieved listings { "total": 42, "per_page": 36, "cur...
  • infolog[18:38:02] LOG.info: Exact location listing count { "suburb": "quinns-rocks", "state": "WA",...
  • infolog[18:38:02] LOG.info: Starting getNearbyListings with filters: { "locations": [], "businessTy...
  • infolog[18:38:02] LOG.info: Applying industry filter: { "industry": "health-beauty-fitness" }
  • infolog[18:38:02] LOG.info: Using where for single industry { "industry": "health-beauty-fitness" }
  • debuglog[18:38:02] LOG.debug: Final SQL query for nearby listings: { "sql": "select distinct `listings`....
  • infolog[18:38:02] LOG.info: Successfully retrieved nearby listings { "total": 459, "per_page": 36, ...
  • infolog[18:38:02] LOG.info: Display flags: { "hasExactLocationSearch": true, "originalBrandCount": ...
  • infolog[18:38:02] LOG.info: Getting industry IDs from slug { "slug": "health-beauty-fitness" }
  • infolog[18:38:02] LOG.info: Found industry from direct lookup { "slug": "health-beauty-fitness", "i...
  • infolog[18:38:02] LOG.info: Final industry IDs from slug { "slug": "health-beauty-fitness", "ids": ...
  • infolog[18:38:02] LOG.info: View data prepared successfully
status
200 OK
full_url
http://directory.testing.hattch.net/businesses-for-sale/within-health-beauty-fitness/in-quinns-rocks...
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
318ms
peak_memory
6MB
response
text/html; charset=UTF-8
request_format
html
request_query
0 of 0
array:2 [ "distance" => "99999" "page" => "2" ]
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=azaeul%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-6866416a-13aa71853b551caf0e6b811b" ] "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" => "azaeul|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:38:02 GMT" ] ]
session_attributes
0 of 0
array:1 [ "_token" => "I104Bs1upTPUnToXT5y7Qyw146FExhasonwHEIqV" ]
  • Booting (16.23ms)time
  • Application (300ms)time
  • Routing (1.73ms)
  • View: pages.home.brandviews
  • View: pages.home.breadcrumbviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.summaryviews
  • View: pages.home.partials.lazy-load-scriptviews
  • View: brand.common.frontpage-layoutviews
  • View: brand.common.tracking-codesviews
  • View: pages.home.universal-headerviews
  • View: pages.home.partials.header-filtersviews
  • View: pages.home.skeleton-loadersviews
  • View: pages.home.profile_slider_menuviews
  • View: pages.home.partials._main_optionsviews
  • View: pages.home.partials._account_detailsviews
  • View: pages.home.partials._franchise_compatibilityviews
  • View: pages.home.partials._enquiries_invitationsviews
  • View: pages.home.partials._investment_calculatorviews
  • View: pages.home.partials._notification_settingsviews
  • View: pages.home.partials._securityviews
  • View: pages.widget.summaryviews
  • View: layouts.common.footerviews
  • View: partials.welcome-collection-modalviews
  • 1 x Application (94.86%)
    300ms
    1 x Booting (5.13%)
    16.23ms
    1 x Routing (0.55%)
    1.73ms
    24 x View (0%)
    0μs
    24 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.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.summarysummary.blade.php#?blade
    • pages.home.partials.lazy-load-scriptlazy-load-script.blade.php#?blade
    • brand.common.frontpage-layoutfrontpage-layout.blade.php#?blade
    • brand.common.tracking-codestracking-codes.blade.php#?blade
    • pages.home.universal-headeruniversal-header.blade.php#?blade
    • pages.home.partials.header-filtersheader-filters.blade.php#?blade
    • pages.home.skeleton-loadersskeleton-loaders.blade.php#?blade
    • pages.home.profile_slider_menuprofile_slider_menu.blade.php#?blade
    • pages.home.partials._main_options_main_options.blade.php#?blade
    • pages.home.partials._account_details_account_details.blade.php#?blade
    • pages.home.partials._franchise_compatibility_franchise_compatibility.blade.php#?blade
    • pages.home.partials._enquiries_invitations_enquiries_invitations.blade.php#?blade
    • pages.home.partials._investment_calculator_investment_calculator.blade.php#?blade
    • pages.home.partials._notification_settings_notification_settings.blade.php#?blade
    • pages.home.partials._security_security.blade.php#?blade
    • pages.widget.summarysummary.blade.php#?blade
    • layouts.common.footerfooter.blade.php#?blade
    • partials.welcome-collection-modalwelcome-collection-modal.blade.php#?blade
    48 statements were executed (11 duplicates)Show only duplicates230ms
    • 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.61msselect exists(select * from `industries` where `industry_slug` = 'health-beauty-fitness' and `industries`.`deleted_at` is null) as `exists`
      Bindings
      • 0: health-beauty-fitness
      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.46msselect `id` from `industries` where `industry_slug` = 'health-beauty-fitness' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: health-beauty-fitness
      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` = 'health-beauty-fitness' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: health-beauty-fitness
      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.49msselect `to_postcode` from `distances` where `from_postcode` in ('6030') order by `distance_km` asc
      Bindings
      • 0: 6030
      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.31msselect 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 ('6030') where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and (`brands`.`industry_id` in (3) or `brands`.`secondary_industry_id` in (3)) and `post_codes`.`postcode` in (6030, 6036, 6032, 6028, 6038, 6033, 6031, '6030')
      Bindings
      • 0: 6030
      • 1: open
      • 2: 1
      • 3: 3
      • 4: 3
      • 5: 6030
      • 6: 6036
      • 7: 6032
      • 8: 6028
      • 9: 6038
      • 10: 6033
      • 11: 6031
      • 12: 6030
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#446hattch2022prod3.67msselect 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 ('6030') where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and (`brands`.`industry_id` in (3) or `brands`.`secondary_industry_id` in (3)) and `post_codes`.`postcode` in (6030, 6036, 6032, 6028, 6038, 6033, 6031, '6030') order by CASE WHEN post_codes.postcode IN ('6030') THEN 0 ELSE 1 END, `distances`.`distance_km` asc, `post_codes`.`postcode` asc limit 36 offset 36
      Bindings
      • 0: 6030
      • 1: open
      • 2: 1
      • 3: 3
      • 4: 3
      • 5: 6030
      • 6: 6036
      • 7: 6032
      • 8: 6028
      • 9: 6038
      • 10: 6033
      • 11: 6031
      • 12: 6030
      • 13: 6030
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#624hattch2022prod2.61msselect * from `post_codes` where `postcode` = '6030' limit 1
      Bindings
      • 0: 6030
      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.54msselect `id` from `industries` where `industry_slug` = 'health-beauty-fitness' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: health-beauty-fitness
      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#730hattch2022prod3.16msselect 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` = '6030' and (`brands`.`industry_id` = 3 or `brands`.`secondary_industry_id` = 3)
      Bindings
      • 0: open
      • 1: 1
      • 2: 6030
      • 3: 3
      • 4: 3
      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.54msselect `id` from `industries` where `industry_slug` = 'health-beauty-fitness' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: health-beauty-fitness
      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#1053hattch2022prod7.09msselect 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(-31.66527)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(115.69795)) + sin(radians(-31.66527)) * 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 (3) or `brands`.`secondary_industry_id` in (3)) group by `brands`.`id`) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 3
      • 3: 3
      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.58msselect 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(-31.66527)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(115.69795)) + sin(radians(-31.66527)) * 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 (3) or `brands`.`secondary_industry_id` in (3)) group by `brands`.`id` order by MIN((6751 * acos(cos(radians(-31.66527)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(115.69795)) + sin(radians(-31.66527)) * sin(radians(post_codes.lat))))) asc limit 36 offset 36
      Bindings
      • 0: open
      • 1: 1
      • 2: 3
      • 3: 3
      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.58msselect * from `post_codes` where `suburb` in ('Quinns Rocks', 'Quinns-rocks') and `state` = 'WA' and `postcode` = '6030' limit 1
      Bindings
      • 0: Quinns Rocks
      • 1: Quinns-rocks
      • 2: WA
      • 3: 6030
      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#498hattch2022prod10.72msselect 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#498hattch2022prod29.92msselect 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 36
      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#615hattch2022prod18.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 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#615hattch2022prod19.94msselect 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 36
      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.07msselect * from `brands` where `brands`.`id` in (7017911, 7017912, 7017916, 7017924, 7017925, 7017926)
      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#615hattch2022prod5.43msselect * from `homepages` where `homepages`.`brand_id` in (7017911, 7017912, 7017916, 7017924, 7017925, 7017926)
      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.5msselect * from `industries` where `industries`.`id` in (1, 2, 3, 5, 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.37msselect * 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.51msselect `id` from `industries` where `industry_slug` = 'health-beauty-fitness' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: health-beauty-fitness
      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.84msselect 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` = '6030' and `post_codes`.`state` = 'WA' and `post_codes`.`suburb` in ('Quinns Rocks', 'Quinns-rocks') and `listings`.`status` = 'open' and (`brands`.`industry_id` = 3 or `brands`.`secondary_industry_id` = 3)
      Bindings
      • 0: 6030
      • 1: WA
      • 2: Quinns Rocks
      • 3: Quinns-rocks
      • 4: open
      • 5: 3
      • 6: 3
      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.46msselect `id` from `industries` where `industry_slug` = 'health-beauty-fitness' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: health-beauty-fitness
      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#1488hattch2022prod5.01msselect count(*) as aggregate from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and (`brands`.`industry_id` in (3) or `brands`.`secondary_industry_id` in (3))
      Bindings
      • 0: open
      • 1: 1
      • 2: 3
      • 3: 3
      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#1488hattch2022prod11.2msselect 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(-31.66527)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(115.69795)) + sin(radians(-31.66527)) * 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 (3) or `brands`.`secondary_industry_id` in (3)) order by `distance_km` asc limit 36 offset 36
      Bindings
      • 0: open
      • 1: 1
      • 2: 3
      • 3: 3
      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.9msselect * from `brands` where `brands`.`id` in (7017916, 7017918, 7017937, 7017947, 7017950)
      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.48msselect * from `homepages` where `homepages`.`brand_id` in (7017916, 7017918, 7017937, 7017947, 7017950)
      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.48msselect * from `industries` where `industries`.`id` in (3) 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.7msselect * from `post_codes` where `post_codes`.`id` in (10947, 10967, 11190, 11191, 11195, 11453, 11458, 11707, 11725, 11731, 11736, 11745, 11843, 12459, 12535, 12670, 12679, 12746, 12756, 12992, 13070, 13072, 13278, 13317, 13324, 13380, 13381, 13387, 13639, 13710, 13827)
      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.9msselect * from `brands` where `id` in (7017916, 7017918, 7017937, 7017947, 7017950)
      Bindings
      • 0: 7017916
      • 1: 7017918
      • 2: 7017937
      • 3: 7017947
      • 4: 7017950
      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.9msselect * from `post_codes` where `id` in (13827, 13710, 13381, 12535, 12992, 13380, 12679, 12670, 13387, 12746, 13072, 13070, 12756, 12459, 13278, 13639, 13324, 13317, 11736, 10947, 11843, 11731, 11191, 11458, 11190, 11195, 10967, 11707, 11725, 11453, 11745)
      Bindings
      • 0: 13827
      • 1: 13710
      • 2: 13381
      • 3: 12535
      • 4: 12992
      • 5: 13380
      • 6: 12679
      • 7: 12670
      • 8: 13387
      • 9: 12746
      • 10: 13072
      • 11: 13070
      • 12: 12756
      • 13: 12459
      • 14: 13278
      • 15: 13639
      • 16: 13324
      • 17: 13317
      • 18: 11736
      • 19: 10947
      • 20: 11843
      • 21: 11731
      • 22: 11191
      • 23: 11458
      • 24: 11190
      • 25: 11195
      • 26: 10967
      • 27: 11707
      • 28: 11725
      • 29: 11453
      • 30: 11745
      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.49msselect * from `categories` where `id` in (1, 3)
      Bindings
      • 0: 1
      • 1: 3
      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.28msselect * from `industries` where `id` in (3)
      Bindings
      • 0: 3
      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.79msselect * from `survey_questions` where `brand_id` in (7017916, 7017918, 7017937, 7017947, 7017950) and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017916
      • 1: 7017918
      • 2: 7017937
      • 3: 7017947
      • 4: 7017950
      • 5: 1
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:1295
      • app/Http/Controllers/FranchiseDirectoryController.php:1097
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#1301hattch2022prod3.41msselect * from `homepages` where `brand_id` in (7017916, 7017918, 7017937, 7017947, 7017950)
      Bindings
      • 0: 7017916
      • 1: 7017918
      • 2: 7017937
      • 3: 7017947
      • 4: 7017950
      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.38msselect `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.34msselect `postcode` from `post_codes` where `postcode` = '6030' limit 10
      Bindings
      • 0: 6030
      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.56msselect * from `post_codes` where `postcode` in ('6030', 6030, 6030, 6030, 6030, 6030, 6030)
      Bindings
      • 0: 6030
      • 1: 6030
      • 2: 6030
      • 3: 6030
      • 4: 6030
      • 5: 6030
      • 6: 6030
      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.43msselect * from `post_codes` where `id` = 13879 limit 1
      Bindings
      • 0: 13879
      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.56msselect * from `industries` where `industry_slug` = 'health-beauty-fitness' limit 1
      Bindings
      • 0: health-beauty-fitness
      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.38msselect * from `industries` where `id` = 3 limit 1
      Bindings
      • 0: 3
      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.41msselect * from `post_codes` where `id` = 13879 limit 1
      Bindings
      • 0: 13879
      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.55msselect * from `industries` where `industry_slug` = 'health-beauty-fitness' limit 1
      Bindings
      • 0: health-beauty-fitness
      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.53msselect * from `post_codes` where `id` = 13879 limit 1
      Bindings
      • 0: 13879
      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.49msSELECT 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.76msSELECT 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.47msselect * 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
    78Listing.php#?
    App\Models\PostCode
    33PostCode.php#?
    App\Models\Industry
    20Industry.php#?
    App\Models\Brand
    11Brand.php#?
    App\Models\Homepage
    11Homepage.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-07-03 18:38:02GET/businesses-for-sale/within-health-beauty-fitness/in-quinns-rocks-wa-6030?distance=99999&page=2482448153