99 Retail or Convenience businesses for sale in Cleveland QLD 4163

99 businesses for sale

Celebrity Ink: Townsville

Aitkenvale, QLD 4814 1,196.9 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Willows

Celebrity Ink presents a rare opportunity to join a globally recognised tattoo franchise in the thriving community of Thuringowa Central, QLD, where the growing population and stra...(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Shepparton

Shepparton, VIC 3630 1,304.9 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Carpet Court: Mildura Carpet Court

Mildura, VIC 3500 1,372.4 km away

(more)

Total Investment: From $100K

Business Type: New Franchise

Celebrity Ink: Bendigo

Bendigo, VIC 3550 1,407.6 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Carpet Court: Innisfail Carpet Court

Innisfail, QLD 4860 1,417.3 km away

(more)

Total Investment: From $100K

Business Type: New Franchise

Celebrity Ink: Chirnside Park

(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Plenty Valley

Mill Park, VIC 3082 1,443.8 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Craigieburn

Craigieburn, VIC 3064 1,444.0 km away

Celebrity Ink presents a rare opportunity to establish a premium tattoo studio in the rapidly expanding suburb of Craigieburn, one of Melbourne's fastest-growing northern communiti...(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Epping

Epping, VIC 3076 1,444.9 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: The Pines

(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Warringal

Heidelberg, VIC 3084 1,451.8 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Broadmeadows

Broadmeadows, VIC 3047 1,452.8 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Northland

Preston, VIC 3072 1,454.3 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: The Glen

(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Barkly Square

Brunswick, VIC 3056 1,459.2 km away

Pioneer the first Celebrity Ink studio in Brunswick, a dynamic inner-Melbourne suburb known for its thriving arts and cultural scene. As Melbourne's tattoo industry continues to ex...(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Airport West

Airport West, VIC 3042 1,459.8 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Pakenham

Pakenham, VIC 3810 1,460.2 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Victoria Gardens

Richmond, VIC 3121 1,462.2 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Waverly Gardens

Mulgrave, VIC 3170 1,462.3 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Watergardens

Join Celebrity Ink's expansion into Taylors Lakes, one of Melbourne's thriving north-western suburbs. Located within a rapidly growing residential corridor and anchored by the bust...(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Chadstone

Chadstone, VIC 3148 1,462.7 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Malvern Central

Armadale, VIC 3143 1,464.7 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: DFO South Wharf

South Wharf, VIC 3006 1,465.4 km away

Celebrity Ink presents a rare opportunity to establish a premium tattoo studio in South Wharf, VIC, where the vibrant waterfront precinct attracts a steady flow of fashion-forward...(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Dandenong

Dandenong, VIC 3175 1,466.4 km away

Drive business success with Celebrity Ink's newest franchise opportunity in Dandenong, Victoria. Located in one of Melbourne's fastest-growing multicultural hubs, Dandenong present...(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Clarinda

Clarinda, VIC 3169 1,468.0 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Brimbank

Deer Park, VIC 3023 1,469.8 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Woodgrove

Melton West, VIC 3337 1,473.3 km away

Begin your business ownership journey with Celebrity Ink in Melbourne's rapidly expanding western suburb of Melton West. This growing community, characterised by its young demograp...(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Altona

Altona North, VIC 3025 1,473.5 km away

Secure your position in Melbourne's west with Celebrity Ink's latest franchise territory in Altona North, Victoria. This rapidly developing suburb, located just 10km from Melbourne...(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Cranbourne

Cranbourne, VIC 3977 1,475.6 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Carpet Court: Atherton Carpet Court

Atherton, QLD 4883 1,475.6 km away

(more)

Total Investment: From $100K

Business Type: New Franchise

Celebrity Ink: Werribee

(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Point Cook

Point Cook, VIC 3030 1,484.6 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Celebrity Ink: Bayside

Frankston, VIC 3199 1,486.2 km away

Celebrity Ink presents a rare opportunity to join a globally recognised tattoo brand in the thriving coastal suburb of Frankston, Victoria. Positioned in a high-growth area with st...(more)

Total Investment: From $300K

Business Type: New Franchise

Carpet Court: Club Interiors (Frankston Carpet Court)

Frankston, VIC 3199 1,486.2 km away

Carpet Court stands as Australia's largest flooring retailer, offering a rare opportunity to acquire an established franchise in the thriving coastal hub of Frankston, Victoria. Po...(more)

Total Investment: From $100K

Business Type: Franchise Resale

Celebrity Ink: Cairns

Cairns City, QLD 4870 1,492.2 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

SettingsRequest history415msRequest 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-retail-convenience/in-cleveland-qld-4...
action_name
directory.industry-location-search.single
controller_action
App\Http\Controllers\FranchiseDirectoryController@showFilteredListings
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
  • infolog[18:37:56] LOG.info: ValidateBusinessListingUrl processing request { "path": "businesses-for-sal...
  • infolog[18:37:56] LOG.info: Route has location parameter, passing through { "location": "cleveland-qld-...
  • infolog[18:37:56] LOG.info: Processing single location parameter { "location": "cleveland-qld-4163", ...
  • infolog[18:37:56] LOG.info: Successfully parsed location parameter { "location": "cleveland-qld-4163", ...
  • infolog[18:37:56] LOG.info: Cookie debugging in FranchiseDirectoryController { "path": "businesses-for-...
  • infolog[18:37:56] LOG.info: Parameters received: { "industry": "retail-convenience", "franchiseType...
  • infolog[18:37:56] LOG.info: User is not authenticated on filtered listings page { "host": "directory.te...
  • infolog[18:37:57] LOG.info: Populated filter arrays from parsed location { "suburb": "cleveland", "...
  • infolog[18:37:57] LOG.info: Starting getFilteredListings with filters: { "locations": [], "business...
  • infolog[18:37:57] LOG.info: Applying industry filter: { "industry": "retail-convenience" }
  • infolog[18:37:57] LOG.info: Using single known industry: { "industry": "retail-convenience" }
  • infolog[18:37:57] LOG.info: Applying location filters: { "suburb": [ "cleveland" ], "st...
  • infolog[18:37:57] LOG.info: Using postcodes for filtering: { "postcodes": [ "4163" ] }
  • infolog[18:37:57] LOG.info: Including nearby postcodes: { "count": 12, "postcodes": [ 4163,...
  • infolog[18:37:57] LOG.info: Adding distance_km to select for sorting by distance
  • debuglog[18:37:57] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.*, `brands`.`id` as ...
  • infolog[18:37:57] LOG.info: Successfully retrieved listings { "total": 1, "per_page": 36, "curr...
  • infolog[18:37:57] LOG.info: Listings retrieved: { "count": 0, "total": 1 }
  • infolog[18:37:57] LOG.info: Brand IDs found: { "ids": [] }
  • infolog[18:37:57] LOG.info: Retrieved postcode record for brand filters: { "postcode": "4163", "has...
  • infolog[18:37:57] LOG.info: Adding coordinates to brand filters for distance search: { "lat": "-27.5292...
  • infolog[18:37:57] LOG.info: Setting distance parameter for brands: { "max_distance": 99999 }
  • infolog[18:37:57] LOG.info: Local brand count check (exact postcode): { "postcode": "4163", "localB...
  • infolog[18:37:57] LOG.info: Starting getFilteredBrands with filters: { "locations": [], "businessTy...
  • infolog[18:37:57] LOG.info: Applying industry filter: { "industry": "retail-convenience" }
  • infolog[18:37:57] LOG.info: Using single known industry: { "industry": "retail-convenience" }
  • infolog[18:37:57] LOG.info: Using coordinates for distance-based search: { "lat": -27.52929, "lng":...
  • debuglog[18:37:57] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:37:57] LOG.info: Successfully retrieved brands { "total": 3, "per_page": 36, "curren...
  • infolog[18:37:57] LOG.info: Postcode found: { "id": 9932, "suburb": "Cleveland" }
  • infolog[18:37:57] LOG.info: Final postcodeArray before passing to view: { "postcodeArray": [ { ...
  • infolog[18:37:57] LOG.info: Starting getDefaultListings without filters
  • debuglog[18:37:57] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.* from `listings` in...
  • infolog[18:37:57] LOG.info: Successfully retrieved listings { "total": 2552, "per_page": 36, "c...
  • infolog[18:37:57] LOG.info: Starting getDefaultBrands without filters
  • debuglog[18:37:57] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:37:57] LOG.info: Successfully retrieved listings { "total": 42, "per_page": 36, "cur...
  • infolog[18:37:57] LOG.info: Exact location listing count { "suburb": "cleveland", "state": "QLD", ...
  • infolog[18:37:57] LOG.info: Starting getNearbyListings with filters: { "locations": [], "businessTy...
  • infolog[18:37:57] LOG.info: Applying industry filter: { "industry": "retail-convenience" }
  • infolog[18:37:57] LOG.info: Using where for single industry { "industry": "retail-convenience" }
  • debuglog[18:37:57] LOG.debug: Final SQL query for nearby listings: { "sql": "select distinct `listings`....
  • infolog[18:37:57] LOG.info: Successfully retrieved nearby listings { "total": 99, "per_page": 36, ...
  • infolog[18:37:57] LOG.info: Display flags: { "hasExactLocationSearch": true, "originalBrandCount": ...
  • infolog[18:37:57] LOG.info: Getting industry IDs from slug { "slug": "retail-convenience" }
  • infolog[18:37:57] LOG.info: Found industry from direct lookup { "slug": "retail-convenience", "id":...
  • infolog[18:37:57] LOG.info: Final industry IDs from slug { "slug": "retail-convenience", "ids": [ ...
  • infolog[18:37:57] LOG.info: View data prepared successfully
status
200 OK
full_url
http://directory.testing.hattch.net/businesses-for-sale/within-retail-convenience/in-cleveland-qld-4...
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
423ms
peak_memory
8MB
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:12 [ "cache-control" => array:1 [ 0 => "no-cache" ] "via" => array:1 [ 0 => "1.1 squid-proxy-5b5d847c96-kml6h (squid/6.10)" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "pragma" => array:1 [ 0 => "no-cache" ] "x-amzn-trace-id" => array:1 [ 0 => "Root=1-68664164-28c4f9c54fcad6da20af36fe" ] "host" => array:1 [ 0 => "directory.testing.hattch.net" ] "x-forwarded-port" => array:1 [ 0 => "80" ] "x-forwarded-proto" => array:1 [ 0 => "http" ] "x-forwarded-for" => array:1 [ 0 => "10.1.3.136, 216.73.216.89" ] ]
request_cookies
[]
response_headers
0 of 0
array:3 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Thu, 03 Jul 2025 08:37:57 GMT" ] ]
session_attributes
0 of 0
array:1 [ "_token" => "khLsQKNZsSxKEg1T0Ea73K8I4nA66XZMYpqcc92m" ]
  • Booting (47.59ms)time
  • Application (368ms)time
  • Routing (1.74ms)
  • View: pages.home.brandviews
  • View: pages.home.breadcrumbviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.dir_empty_resultsviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.summaryviews
  • View: pages.home.partials.lazy-load-scriptviews
  • View: brand.common.frontpage-layoutviews
  • View: brand.common.tracking-codesviews
  • View: pages.home.universal-headerviews
  • View: pages.home.partials.header-filtersviews
  • View: pages.home.skeleton-loadersviews
  • View: pages.home.profile_slider_menuviews
  • View: pages.home.partials._main_optionsviews
  • View: pages.home.partials._account_detailsviews
  • View: pages.home.partials._franchise_compatibilityviews
  • View: pages.home.partials._enquiries_invitationsviews
  • View: pages.home.partials._investment_calculatorviews
  • View: pages.home.partials._notification_settingsviews
  • View: pages.home.partials._securityviews
  • View: pages.widget.summaryviews
  • View: layouts.common.footerviews
  • View: partials.welcome-collection-modalviews
  • 1 x Application (88.54%)
    368ms
    1 x Booting (11.46%)
    47.59ms
    1 x Routing (0.42%)
    1.74ms
    25 x View (0%)
    0μs
    25 templates were rendered
    • pages.home.brandbrand.blade.php#?blade
    • pages.home.breadcrumbbreadcrumb.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.dir_empty_resultsdir_empty_results.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.summarysummary.blade.php#?blade
    • pages.home.partials.lazy-load-scriptlazy-load-script.blade.php#?blade
    • brand.common.frontpage-layoutfrontpage-layout.blade.php#?blade
    • brand.common.tracking-codestracking-codes.blade.php#?blade
    • pages.home.universal-headeruniversal-header.blade.php#?blade
    • pages.home.partials.header-filtersheader-filters.blade.php#?blade
    • pages.home.skeleton-loadersskeleton-loaders.blade.php#?blade
    • pages.home.profile_slider_menuprofile_slider_menu.blade.php#?blade
    • pages.home.partials._main_options_main_options.blade.php#?blade
    • pages.home.partials._account_details_account_details.blade.php#?blade
    • pages.home.partials._franchise_compatibility_franchise_compatibility.blade.php#?blade
    • pages.home.partials._enquiries_invitations_enquiries_invitations.blade.php#?blade
    • pages.home.partials._investment_calculator_investment_calculator.blade.php#?blade
    • pages.home.partials._notification_settings_notification_settings.blade.php#?blade
    • pages.home.partials._security_security.blade.php#?blade
    • pages.widget.summarysummary.blade.php#?blade
    • layouts.common.footerfooter.blade.php#?blade
    • partials.welcome-collection-modalwelcome-collection-modal.blade.php#?blade
    48 statements were executed (11 duplicates)Show only duplicates292ms
    • 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#328hattch2022prod14.44msselect exists(select * from `industries` where `industry_slug` = 'retail-convenience' and `industries`.`deleted_at` is null) as `exists`
      Bindings
      • 0: retail-convenience
      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.33msselect `id` from `industries` where `industry_slug` = 'retail-convenience' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: retail-convenience
      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.53msselect `id` from `industries` where `industry_slug` = 'retail-convenience' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: retail-convenience
      Backtrace
      • app/Services/BusinessListingService.php:34
      • app/Services/BusinessListingService.php:153
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • BusinessListingService.php#267hattch2022prod3.28msselect `to_postcode` from `distances` where `from_postcode` in ('4163') order by `distance_km` asc
      Bindings
      • 0: 4163
      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.44msselect 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 ('4163') where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and (`brands`.`industry_id` in (2) or `brands`.`secondary_industry_id` in (2)) and `post_codes`.`postcode` in (4163, 4163, 4161, 4160, 4164, 4157, 4159, 4165, 4158, 4154, 4155, '4163')
      Bindings
      • 0: 4163
      • 1: open
      • 2: 1
      • 3: 2
      • 4: 2
      • 5: 4163
      • 6: 4163
      • 7: 4161
      • 8: 4160
      • 9: 4164
      • 10: 4157
      • 11: 4159
      • 12: 4165
      • 13: 4158
      • 14: 4154
      • 15: 4155
      • 16: 4163
      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.16msselect 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 ('4163') where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and (`brands`.`industry_id` in (2) or `brands`.`secondary_industry_id` in (2)) and `post_codes`.`postcode` in (4163, 4163, 4161, 4160, 4164, 4157, 4159, 4165, 4158, 4154, 4155, '4163') order by CASE WHEN post_codes.postcode IN ('4163') THEN 0 ELSE 1 END, `distances`.`distance_km` asc, `post_codes`.`postcode` asc limit 36 offset 36
      Bindings
      • 0: 4163
      • 1: open
      • 2: 1
      • 3: 2
      • 4: 2
      • 5: 4163
      • 6: 4163
      • 7: 4161
      • 8: 4160
      • 9: 4164
      • 10: 4157
      • 11: 4159
      • 12: 4165
      • 13: 4158
      • 14: 4154
      • 15: 4155
      • 16: 4163
      • 17: 4163
      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#624hattch2022prod3.73msselect * from `post_codes` where `postcode` = '4163' limit 1
      Bindings
      • 0: 4163
      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#721hattch2022prod3.59msselect `id` from `industries` where `industry_slug` = 'retail-convenience' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: retail-convenience
      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.06msselect 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` = '4163' and (`brands`.`industry_id` = 2 or `brands`.`secondary_industry_id` = 2)
      Bindings
      • 0: open
      • 1: 1
      • 2: 4163
      • 3: 2
      • 4: 2
      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.45msselect `id` from `industries` where `industry_slug` = 'retail-convenience' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: retail-convenience
      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#1053hattch2022prod6.23msselect 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(-27.52929)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(153.26646)) + sin(radians(-27.52929)) * 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 (2) or `brands`.`secondary_industry_id` in (2)) group by `brands`.`id`) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 2
      • 3: 2
      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.08msselect 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(-27.52929)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(153.26646)) + sin(radians(-27.52929)) * 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 (2) or `brands`.`secondary_industry_id` in (2)) group by `brands`.`id` order by MIN((6751 * acos(cos(radians(-27.52929)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(153.26646)) + sin(radians(-27.52929)) * sin(radians(post_codes.lat))))) asc limit 36 offset 36
      Bindings
      • 0: open
      • 1: 1
      • 2: 2
      • 3: 2
      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.57msselect * from `post_codes` where `suburb` in ('Cleveland') and `state` = 'QLD' and `postcode` = '4163' limit 1
      Bindings
      • 0: Cleveland
      • 1: QLD
      • 2: 4163
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:783
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • BusinessListingService.php#498hattch2022prod11.07msselect 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#498hattch2022prod68.46msselect 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#615hattch2022prod30.89msselect 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.06msselect 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#615hattch2022prod2.63msselect * 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#615hattch2022prod4.98msselect * 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.36msselect * 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.34msselect * 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#856hattch2022prod4.52msselect `id` from `industries` where `industry_slug` = 'retail-convenience' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: retail-convenience
      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` = '4163' and `post_codes`.`state` = 'QLD' and `post_codes`.`suburb` in ('Cleveland') and `listings`.`status` = 'open' and (`brands`.`industry_id` = 2 or `brands`.`secondary_industry_id` = 2)
      Bindings
      • 0: 4163
      • 1: QLD
      • 2: Cleveland
      • 3: open
      • 4: 2
      • 5: 2
      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.81msselect `id` from `industries` where `industry_slug` = 'retail-convenience' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: retail-convenience
      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.17msselect 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 (2) or `brands`.`secondary_industry_id` in (2))
      Bindings
      • 0: open
      • 1: 1
      • 2: 2
      • 3: 2
      Backtrace
      • app/Services/BusinessListingService.php:1488
      • app/Http/Controllers/FranchiseDirectoryController.php:905
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1488hattch2022prod4.98msselect 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(-27.52929)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(153.26646)) + sin(radians(-27.52929)) * 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 (2) or `brands`.`secondary_industry_id` in (2)) order by `distance_km` asc limit 36 offset 36
      Bindings
      • 0: open
      • 1: 1
      • 2: 2
      • 3: 2
      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.49msselect * from `brands` where `brands`.`id` in (7017911, 7017956)
      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.92msselect * from `homepages` where `homepages`.`brand_id` in (7017911, 7017956)
      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.31msselect * from `industries` where `industries`.`id` in (2) 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#1488hattch2022prod8.4msselect * from `post_codes` where `post_codes`.`id` in (4680, 4876, 4891, 5056, 5084, 5293, 5416, 5591, 5665, 5732, 5856, 5900, 5913, 5954, 6136, 6196, 6215, 6224, 6348, 6354, 6356, 6369, 6422, 6851, 7211, 7220, 7235, 7242, 7249, 7267, 7466, 8109, 9080, 10101, 10176)
      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.67msselect * from `brands` where `id` in (7017911, 7017956)
      Bindings
      • 0: 7017911
      • 1: 7017956
      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.77msselect * from `post_codes` where `id` in (10176, 10101, 5732, 6224, 5591, 9080, 7242, 7220, 5913, 7211, 6136, 4680, 5900, 5293, 6356, 6422, 6369, 5056, 7267, 6354, 4876, 6348, 6851, 6196, 5665, 5954, 4891, 6215, 5856, 5084, 7466, 7235, 7249, 5416, 8109)
      Bindings
      • 0: 10176
      • 1: 10101
      • 2: 5732
      • 3: 6224
      • 4: 5591
      • 5: 9080
      • 6: 7242
      • 7: 7220
      • 8: 5913
      • 9: 7211
      • 10: 6136
      • 11: 4680
      • 12: 5900
      • 13: 5293
      • 14: 6356
      • 15: 6422
      • 16: 6369
      • 17: 5056
      • 18: 7267
      • 19: 6354
      • 20: 4876
      • 21: 6348
      • 22: 6851
      • 23: 6196
      • 24: 5665
      • 25: 5954
      • 26: 4891
      • 27: 6215
      • 28: 5856
      • 29: 5084
      • 30: 7466
      • 31: 7235
      • 32: 7249
      • 33: 5416
      • 34: 8109
      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.81msselect * from `categories` where `id` in (1)
      Bindings
      • 0: 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#1287hattch2022prod4.33msselect * from `industries` where `id` in (2)
      Bindings
      • 0: 2
      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.45msselect * from `survey_questions` where `brand_id` in (7017911, 7017956) and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017911
      • 1: 7017956
      • 2: 1
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:1295
      • app/Http/Controllers/FranchiseDirectoryController.php:1097
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#1301hattch2022prod2.82msselect * from `homepages` where `brand_id` in (7017911, 7017956)
      Bindings
      • 0: 7017911
      • 1: 7017956
      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.29msselect `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.35msselect `postcode` from `post_codes` where `postcode` = '4163' limit 10
      Bindings
      • 0: 4163
      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#1139hattch2022prod5.14msselect * from `post_codes` where `postcode` in ('4163', 4163)
      Bindings
      • 0: 4163
      • 1: 4163
      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.45msselect * from `post_codes` where `id` = 9932 limit 1
      Bindings
      • 0: 9932
      Backtrace
      • view::pages.home.breadcrumb:60
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • frontpage-layout.blade.php#257hattch2022prod2.43msselect * from `industries` where `industry_slug` = 'retail-convenience' limit 1
      Bindings
      • 0: retail-convenience
      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#320hattch2022prod5.3msselect * from `industries` where `id` = 2 limit 1
      Bindings
      • 0: 2
      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#383hattch2022prod3.52msselect * from `post_codes` where `id` = 9932 limit 1
      Bindings
      • 0: 9932
      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.58msselect * from `industries` where `industry_slug` = 'retail-convenience' limit 1
      Bindings
      • 0: retail-convenience
      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.35msselect * from `post_codes` where `id` = 9932 limit 1
      Bindings
      • 0: 9932
      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.51msSELECT 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#118hattch2022prod3.88msSELECT 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#172hattch2022prod3.1msselect * 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
    37PostCode.php#?
    App\Models\Industry
    20Industry.php#?
    App\Models\Brand
    8Brand.php#?
    App\Models\Homepage
    8Homepage.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-07-03 18:37:57GET/businesses-for-sale/within-retail-convenience/in-cleveland-qld-4163?distance=99999&page=2+482548151