business for sale hattch logo mobile

Selected Location

Corowa (2646)
From
To
×

410 Cafe, Food & Beverage businesses for sale in Corowa NSW 2646

Target Icon
Which franchises are thebest match for you?

410 businesses for sale

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

San Churro: Box Hill

Box Hill, VIC 3128 244.9 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

San Churro: Forest Hill

Forest Hill, VIC 3131 245.0 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Liv Eat: Tullamarine

Tullamarine, VIC 3043 245.3 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

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

Jamaica Blue: Essendon DFO

Essendon, VIC 3040 248.0 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

San Churro: Camberwell

Camberwell, VIC 3124 248.6 km away

Indulge in the opportunity to bring San Churro's authentic Spanish chocolate experience to the vibrant heart of Camberwell, VIC. This well-established suburb boasts a thriving reta...(more)

Total Investment: From $300K

Business Type: New Franchise

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

San Churro: Moonee Ponds

Moonee Ponds, VIC 3039 249.2 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Muffin Break: Moonee Ponds

Moonee Ponds, VIC 3039 249.2 km away

Establish your business future with a Muffin Break franchise in the thriving suburb of Moonee Ponds, Victoria. Located in Melbourne's inner northwest, this well-connected hub featu...(more)

Total Investment: From $200K

Business Type: New Franchise

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

San Churro: Waverley

Glen Waverley, VIC 3150 249.2 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

San Churro: Hawthorn

Hawthorn, VIC 3122 250.0 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

San Churro: Richmond

Richmond, VIC 3121 250.7 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Ferguson Plarre: Ascot Vale

Ascot Vale, VIC 3032 250.8 km away

Join Ferguson Plarre's expansion into Ascot Vale, a well-established Melbourne suburb just 5km from the CBD. Located in a thriving retail precinct with excellent foot traffic, Asco...(more)

Total Investment: From $400K

Business Type: New Franchise

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

San Churro: Keilor Downs

Keilor Downs, VIC 3038 251.0 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Muffin Break: Keilor Central

Keilor Downs, VIC 3038 251.0 km away

Join the Muffin Break family in Keilor Downs, where fresh-baked goodness meets community connection in this thriving Melbourne suburb. Situated within a bustling shopping centre wi...(more)

Total Investment: From $200K

Business Type: New Franchise

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

Ferguson Plarre: Tooronga Village

Glen Iris, VIC 3146 251.1 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Jamaica Blue: Highpoint

Maribyrnong, VIC 3032 251.5 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Noodle Box: Ashburton

Ashburton, VIC 3147 251.8 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

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

Milky Lane: Melbourne

Melbourne, VIC 3000 252.7 km away

Establish your presence in Melbourne's thriving food scene with Milky Lane, where prime territories await ambitious entrepreneurs. As Australia's cultural capital and one of the fa...(more)

Total Investment: From $500K

Business Type: New Franchise

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

Liv Eat: Melbourne CBD

Melbourne, VIC 3000 252.7 km away

Lead Liv Eat's expansion into Melbourne's dynamic food scene. As Australia's cultural capital and one of the fastest-growing cities, Melbourne presents an exceptional opportunity t...(more)

Total Investment: From $500K

Business Type: New Franchise

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

Ferguson Plarre: Melbourne CBD

Melbourne, VIC 3000 252.7 km away

Establish your future with Ferguson Plarre in Melbourne's thriving eastern suburbs, where this exclusive territory presents exceptional business potential. As one of Victoria's mos...(more)

Total Investment: From $300K

Business Type: New Franchise

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

San Churro: Malvern

Malvern, VIC 3144 252.8 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Jamaica Blue: Waverley Gardens

Mulgrave, VIC 3170 253.2 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

San Churro: Armadale

Armadale, VIC 3143 253.5 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

San Churro: Malvern East

Malvern East, VIC 3145 253.5 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Acai Brothers: Prahran

Prahran, VIC 3181 253.8 km away

(more)

Total Investment: From $25K

Business Type: Franchise Resale

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

San Churro: South Melbourne

South Melbourne, VIC 3205 254.1 km away

Indulge in the opportunity to bring San Churro's authentic Spanish chocolate experience to the vibrant heart of South Melbourne. This bustling precinct, with its iconic South Melbo...(more)

Total Investment: From $300K

Business Type: New Franchise

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

San Churro: Oakleigh

Oakleigh, VIC 3166 254.3 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Degani Bakery Cafe: Oakleigh

Oakleigh, VIC 3166 254.3 km away

(more)

Total Investment: From $400K

Business Type: New Franchise

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

Degani Bakery Cafe: Braybrook

Braybrook, VIC 3019 254.5 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Muffin Break: Central West

Braybrook, VIC 3019 254.5 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

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

Ferguson Plarre: Port Melbourne

Port Melbourne, VIC 3207 255.8 km away

Join the iconic Ferguson Plarre bakehouse network with this established Port Melbourne franchise location. Positioned in one of Melbourne's most sought-after bayside suburbs, this...(more)

Total Investment: From $400K

Business Type: Franchise Resale

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

San Churro: Port Melbourne

Port Melbourne, VIC 3207 255.8 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Ferguson Plarre: Sunshine

Sunshine, VIC 3020 256.2 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Degani Bakery Cafe: Sunshine

Sunshine, VIC 3020 256.2 km away

(more)

Total Investment: From $400K

Business Type: New Franchise

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

Jamaica Blue: Sunshine Marketplace

Sunshine, VIC 3020 256.2 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

San Churro: Deer Park

Deer Park, VIC 3023 257.1 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

View
business for sale Banjo's Bakery logo
A graphic representing a compatibility score out of 100%
?%
match

Banjo's Bakery: Warragul

Warragul, VIC 3820 257.3 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

View
Messages62RequestTimelineExceptionsViews25Queries54Models176Livewire0MailsGate
SettingsRequest history527msRequest Duration6MBMemory Usage9.x
Laravel Version
9.52.20
PHP Version
8.2.15
Environment
test
Debug Mode
Enabled
URL
testing.hattch.net
Timezone
Australia/Melbourne
Locale
en
GET {viewType}/within-{industry}/in-{location}
status
200 OK
full_url
http://directory.testing.hattch.net/businesses-for-sale/within-cafe-food-beverage/in-corowa-nsw-2646...
action_name
directory.industry-location-search.single
controller_action
App\Http\Controllers\FranchiseDirectoryController@showFilteredListings
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
  • infolog[18:50:41] LOG.info: ValidateBusinessListingUrl processing request { "path": "businesses-for-sal...
  • infolog[18:50:41] LOG.info: Route has location parameter, passing through { "location": "corowa-nsw-264...
  • infolog[18:50:41] LOG.info: Processing single location parameter { "location": "corowa-nsw-2646", "...
  • infolog[18:50:41] LOG.info: Successfully parsed location parameter { "location": "corowa-nsw-2646", ...
  • infolog[18:50:41] LOG.info: Cookie debugging in FranchiseDirectoryController { "path": "businesses-for-...
  • infolog[18:50:41] LOG.info: Parameters received: { "industry": "cafe-food-beverage", "franchiseType...
  • infolog[18:50:41] LOG.info: User is not authenticated on filtered listings page { "host": "directory.te...
  • infolog[18:50:41] LOG.info: Populated filter arrays from parsed location { "suburb": "corowa", "sta...
  • infolog[18:50:41] LOG.info: Starting getFilteredListings with filters: { "locations": [], "business...
  • infolog[18:50:41] LOG.info: Applying industry filter: { "industry": "cafe-food-beverage" }
  • infolog[18:50:41] LOG.info: Using single known industry: { "industry": "cafe-food-beverage" }
  • infolog[18:50:41] LOG.info: Applying location filters: { "suburb": [ "corowa" ], "state...
  • infolog[18:50:41] LOG.info: Using postcodes for filtering: { "postcodes": [ "2646" ] }
  • infolog[18:50:41] LOG.info: Including nearby postcodes: { "count": 3, "postcodes": [ 2646, ...
  • infolog[18:50:41] LOG.info: Adding distance_km to select for sorting by distance
  • debuglog[18:50:41] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.*, `brands`.`id` as ...
  • infolog[18:50:41] LOG.info: Successfully retrieved listings { "total": 0, "per_page": 36, "curr...
  • infolog[18:50:41] LOG.info: Listings retrieved: { "count": 0, "total": 0 }
  • infolog[18:50:41] LOG.info: Caching filter options for 30 minutes
  • errorlog[18:50:41] LOG.error: Error getting filter options: file_put_contents(/var/app/current/storage/frame...
  • infolog[18:50:41] LOG.info: Brand IDs found: { "ids": [] }
  • infolog[18:50:41] LOG.info: Retrieved postcode record for brand filters: { "postcode": "2646", "has...
  • infolog[18:50:41] LOG.info: Adding coordinates to brand filters for distance search: { "lat": "-35.7355...
  • infolog[18:50:41] LOG.info: Local brand count check (exact postcode): { "postcode": "2646", "localB...
  • infolog[18:50:41] LOG.info: Starting getFilteredBrands with filters: { "locations": [], "businessTy...
  • infolog[18:50:41] LOG.info: Applying industry filter: { "industry": "cafe-food-beverage" }
  • infolog[18:50:41] LOG.info: Using single known industry: { "industry": "cafe-food-beverage" }
  • infolog[18:50:41] LOG.info: Using coordinates for distance-based search: { "lat": -35.73554, "lng":...
  • debuglog[18:50:41] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:50:41] LOG.info: Successfully retrieved brands { "total": 0, "per_page": 36, "curren...
  • infolog[18:50:41] LOG.info: Starting getFilteredBrands with filters: { "locations": [], "businessTy...
  • infolog[18:50:41] LOG.info: Applying industry filter: { "industry": "cafe-food-beverage" }
  • infolog[18:50:41] LOG.info: Using single known industry: { "industry": "cafe-food-beverage" }
  • infolog[18:50:41] LOG.info: Using coordinates for distance-based search: { "lat": -35.73554, "lng":...
  • debuglog[18:50:41] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:50:41] LOG.info: Successfully retrieved brands { "total": 11, "per_page": 36, "curre...
  • infolog[18:50:41] LOG.info: Automatically expanding brands search to All of Australia due to zero results {...
  • infolog[18:50:41] LOG.info: Postcode found: { "id": 1144, "suburb": "Corowa" }
  • infolog[18:50:41] LOG.info: Final postcodeArray before passing to view: { "postcodeArray": [ { ...
  • infolog[18:50:41] LOG.info: Starting getDefaultListings without filters
  • debuglog[18:50:41] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.* from `listings` in...
  • infolog[18:50:41] LOG.info: Successfully retrieved listings { "total": 2552, "per_page": 36, "c...
  • infolog[18:50:41] LOG.info: Starting getDefaultBrands without filters
  • debuglog[18:50:41] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:50:41] LOG.info: Successfully retrieved listings { "total": 42, "per_page": 36, "cur...
  • infolog[18:50:41] LOG.info: Exact location listing count { "suburb": "corowa", "state": "NSW", ...
  • infolog[18:50:41] LOG.info: Starting getNearbyListings with filters: { "locations": [], "businessTy...
  • infolog[18:50:41] LOG.info: Applying industry filter: { "industry": "cafe-food-beverage" }
  • infolog[18:50:41] LOG.info: Using where for single industry { "industry": "cafe-food-beverage" }
  • debuglog[18:50:41] LOG.debug: Final SQL query for nearby listings: { "sql": "select distinct `listings`....
  • infolog[18:50:41] LOG.info: Successfully retrieved nearby listings { "total": 0, "per_page": 36, ...
  • infolog[18:50:41] LOG.info: Starting getNearbyListings with filters: { "locations": [], "businessTy...
  • infolog[18:50:41] LOG.info: Applying industry filter: { "industry": "cafe-food-beverage" }
  • infolog[18:50:41] LOG.info: Using where for single industry { "industry": "cafe-food-beverage" }
  • debuglog[18:50:41] LOG.debug: Final SQL query for nearby listings: { "sql": "select distinct `listings`....
  • infolog[18:50:41] LOG.info: Successfully retrieved nearby listings { "total": 410, "per_page": 36, ...
  • infolog[18:50:41] LOG.info: Automatically expanding to All of Australia due to zero results { "original...
  • infolog[18:50:41] LOG.info: Display flags: { "hasExactLocationSearch": true, "originalBrandCount": ...
  • infolog[18:50:41] LOG.info: Getting industry IDs from slug { "slug": "cafe-food-beverage" }
  • infolog[18:50:41] LOG.info: Found industry from direct lookup { "slug": "cafe-food-beverage", "id":...
  • infolog[18:50:41] LOG.info: Final industry IDs from slug { "slug": "cafe-food-beverage", "ids": [ ...
  • infolog[18:50:41] LOG.info: View data prepared successfully
infodebugerror
status
200 OK
full_url
http://directory.testing.hattch.net/businesses-for-sale/within-cafe-food-beverage/in-corowa-nsw-2646...
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
529ms
peak_memory
10MB
response
text/html; charset=UTF-8
request_format
html
request_query
  0 of 0   
array:1 [▼
  "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-68664461-18beb8255e6a1a9b026b7ae8"
  ]
  "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:50:41 GMT"
  ]
]
session_attributes
  0 of 0   
array:1 [▼
  "_token" => "rVGke3UZSN0Q4g9708lCadfa6iaFdb3lU3wohHSj"
]
  • Booting (38.65ms)time
  • Application (488ms)time
  • Routing (1.81ms)
  • 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 (92.67%)
    488ms
    1 x Booting (7.33%)
    38.65ms
    1 x Routing (0.34%)
    1.81ms
    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
    54 statements were executed (15 duplicates)Show only duplicates378ms
    • 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.09msselect exists(select * from `industries` where `industry_slug` = 'cafe-food-beverage' and `industries`.`deleted_at` is null) as `exists`
      Bindings
      • 0: cafe-food-beverage
      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#333hattch2022prod3.65msselect `id` from `industries` where `industry_slug` = 'cafe-food-beverage' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: cafe-food-beverage
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:333
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • BusinessListingService.php#34hattch2022prod4.97msselect `id` from `industries` where `industry_slug` = 'cafe-food-beverage' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: cafe-food-beverage
      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.95msselect `to_postcode` from `distances` where `from_postcode` in ('2646') order by `distance_km` asc
      Bindings
      • 0: 2646
      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#446hattch2022prod4.93msselect 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 ('2646') where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and (`brands`.`industry_id` in (1) or `brands`.`secondary_industry_id` in (1)) and `post_codes`.`postcode` in (2646, 2646, '2646')
      Bindings
      • 0: 2646
      • 1: open
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 2646
      • 6: 2646
      • 7: 2646
      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#1094hattch2022prod6.58msselect * from `industries` where `industries`.`deleted_at` is null order by `industry` asc
      Backtrace
      • app/Services/BusinessListingService.php:1094
      • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • app/Services/BusinessListingService.php:1090
      • app/Http/Controllers/FranchiseDirectoryController.php:597
    • BusinessListingService.php#1095hattch2022prod4.94msselect * from `franchise_types` order by `type` asc
      Backtrace
      • app/Services/BusinessListingService.php:1095
      • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • app/Services/BusinessListingService.php:1090
      • app/Http/Controllers/FranchiseDirectoryController.php:597
    • BusinessListingService.php#1096hattch2022prod2.53msselect * from `categories` where `categories`.`deleted_at` is null order by `category` asc
      Backtrace
      • app/Services/BusinessListingService.php:1096
      • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • app/Services/BusinessListingService.php:1090
      • app/Http/Controllers/FranchiseDirectoryController.php:597
    • FranchiseDirectoryController.php#624hattch2022prod4.06msselect * from `post_codes` where `postcode` = '2646' limit 1
      Bindings
      • 0: 2646
      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.1msselect `id` from `industries` where `industry_slug` = 'cafe-food-beverage' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: cafe-food-beverage
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:721
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FranchiseDirectoryController.php#730hattch2022prod6.68msselect 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` = '2646' and (`brands`.`industry_id` = 1 or `brands`.`secondary_industry_id` = 1)
      Bindings
      • 0: open
      • 1: 1
      • 2: 2646
      • 3: 1
      • 4: 1
      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.66msselect `id` from `industries` where `industry_slug` = 'cafe-food-beverage' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: cafe-food-beverage
      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.26msselect count(*) as aggregate from (select distinct `brands`.`id`, `brands`.`id` as `brand_id`, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `brands`.`minimum_investment`, `brands`.`maximum_investment`, `brands`.`country_code`, `industries`.`industry`, `industries`.`industry_slug`, MIN(post_codes.suburb) as suburb, MIN(post_codes.state) as state, MIN(post_codes.postcode) as postcode, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_brand_logo")) as mobile_brand_logo, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_listing_image")) as mobile_listing_image, JSON_UNQUOTE(JSON_EXTRACT(homepages.section2, "$.business_intro_subtext")) as business_intro_subtext, MIN((6751 * acos(cos(radians(-35.73554)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(146.02409)) + sin(radians(-35.73554)) * 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 (1) or `brands`.`secondary_industry_id` in (1)) group by `brands`.`id` having MIN((6751 * acos(cos(radians(-35.73554)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(146.02409)) + sin(radians(-35.73554)) * sin(radians(post_codes.lat))))) <= 10) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 10
      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#34hattch2022prod4msselect `id` from `industries` where `industry_slug` = 'cafe-food-beverage' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: cafe-food-beverage
      Backtrace
      • app/Services/BusinessListingService.php:34
      • app/Services/BusinessListingService.php:724
      • app/Http/Controllers/FranchiseDirectoryController.php:756
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • BusinessListingService.php#1053hattch2022prod9.73msselect 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(-35.73554)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(146.02409)) + sin(radians(-35.73554)) * 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 (1) or `brands`.`secondary_industry_id` in (1)) group by `brands`.`id`) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 1
      • 3: 1
      Backtrace
      • app/Services/BusinessListingService.php:1053
      • app/Http/Controllers/FranchiseDirectoryController.php:756
      • 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(-35.73554)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(146.02409)) + sin(radians(-35.73554)) * 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 (1) or `brands`.`secondary_industry_id` in (1)) group by `brands`.`id` order by MIN((6751 * acos(cos(radians(-35.73554)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(146.02409)) + sin(radians(-35.73554)) * sin(radians(post_codes.lat))))) asc limit 36 offset 36
      Bindings
      • 0: open
      • 1: 1
      • 2: 1
      • 3: 1
      Backtrace
      • app/Services/BusinessListingService.php:1053
      • app/Http/Controllers/FranchiseDirectoryController.php:756
      • 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#783hattch2022prod8.48msselect * from `post_codes` where `suburb` in ('Corowa') and `state` = 'NSW' and `postcode` = '2646' limit 1
      Bindings
      • 0: Corowa
      • 1: NSW
      • 2: 2646
      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#498hattch2022prod13.3msselect count(*) as aggregate from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null)
      Bindings
      • 0: open
      • 1: 1
      Backtrace
      • app/Services/BusinessListingService.php:498
      • app/Http/Controllers/FranchiseDirectoryController.php:810
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#498hattch2022prod31.51msselect 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#615hattch2022prod35.8msselect 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#615hattch2022prod35.72msselect 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#615hattch2022prod5.7msselect * 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#615hattch2022prod7.19msselect * 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#615hattch2022prod16.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#615hattch2022prod9.11msselect * 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#856hattch2022prod3.55msselect `id` from `industries` where `industry_slug` = 'cafe-food-beverage' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: cafe-food-beverage
      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#870hattch2022prod3.1msselect 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` = '2646' and `post_codes`.`state` = 'NSW' and `post_codes`.`suburb` in ('Corowa') and `listings`.`status` = 'open' and (`brands`.`industry_id` = 1 or `brands`.`secondary_industry_id` = 1)
      Bindings
      • 0: 2646
      • 1: NSW
      • 2: Corowa
      • 3: open
      • 4: 1
      • 5: 1
      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#34hattch2022prod3.98msselect `id` from `industries` where `industry_slug` = 'cafe-food-beverage' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: cafe-food-beverage
      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#1488hattch2022prod6.64msselect count(*) as aggregate from (select distinct `listings`.`id`, `listings`.`name`, `listings`.`overview`, `listings`.`min_investment`, `listings`.`max_investment`, `listings`.`new`, `listings`.`status`, `listings`.`post_code_id`, `listings`.`brand_id`, `listings`.`created_at`, `listings`.`updated_at`, `listings`.`category_id`, `brands`.`id` as `brand_id_relation`, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `industries`.`industry`, `industries`.`industry_slug`, `post_codes`.`suburb`, `post_codes`.`state`, `post_codes`.`postcode`, (6751 * acos(cos(radians(-35.99338)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(146.36285)) + sin(radians(-35.99338)) * 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 (1) or `brands`.`secondary_industry_id` in (1)) having distance_km <= 10) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 10
      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#34hattch2022prod5.36msselect `id` from `industries` where `industry_slug` = 'cafe-food-beverage' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: cafe-food-beverage
      Backtrace
      • app/Services/BusinessListingService.php:34
      • app/Services/BusinessListingService.php:1276
      • app/Http/Controllers/FranchiseDirectoryController.php:914
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • BusinessListingService.php#1488hattch2022prod7.11msselect count(*) as aggregate from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and (`brands`.`industry_id` in (1) or `brands`.`secondary_industry_id` in (1))
      Bindings
      • 0: open
      • 1: 1
      • 2: 1
      • 3: 1
      Backtrace
      • app/Services/BusinessListingService.php:1488
      • app/Http/Controllers/FranchiseDirectoryController.php:914
      • 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(-35.99338)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(146.36285)) + sin(radians(-35.99338)) * 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 (1) or `brands`.`secondary_industry_id` in (1)) order by `distance_km` asc limit 36 offset 36
      Bindings
      • 0: open
      • 1: 1
      • 2: 1
      • 3: 1
      Backtrace
      • app/Services/BusinessListingService.php:1488
      • app/Http/Controllers/FranchiseDirectoryController.php:914
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1488hattch2022prod3.09msselect * from `brands` where `brands`.`id` in (7017912, 7017930, 7017934, 7017941, 7017945, 7017948, 7017949, 7017951, 7017960, 7017973)
      Backtrace
      • app/Services/BusinessListingService.php:1488
      • app/Http/Controllers/FranchiseDirectoryController.php:914
      • 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#1488hattch2022prod7.73msselect * from `homepages` where `homepages`.`brand_id` in (7017912, 7017930, 7017934, 7017941, 7017945, 7017948, 7017949, 7017951, 7017960, 7017973)
      Backtrace
      • app/Services/BusinessListingService.php:1488
      • app/Http/Controllers/FranchiseDirectoryController.php:914
      • 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.68msselect * from `industries` where `industries`.`id` in (1) and `industries`.`deleted_at` is null
      Backtrace
      • app/Services/BusinessListingService.php:1488
      • app/Http/Controllers/FranchiseDirectoryController.php:914
      • 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.8msselect * from `post_codes` where `post_codes`.`id` in (4773, 4864, 4866, 4867, 4868, 4875, 4882, 4887, 4891, 6178, 6179, 6193, 6204, 6353, 6354, 6356, 6362, 6363, 6364, 6706, 6849, 6851, 6852, 6854, 7200, 7204, 7267)
      Backtrace
      • app/Services/BusinessListingService.php:1488
      • app/Http/Controllers/FranchiseDirectoryController.php:914
      • 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#1264hattch2022prod3.9msselect * from `brands` where `id` in (7017941, 7017960, 7017949, 7017948, 7017951, 7017973, 7017934, 7017930, 7017945, 7017912)
      Bindings
      • 0: 7017941
      • 1: 7017960
      • 2: 7017949
      • 3: 7017948
      • 4: 7017951
      • 5: 7017973
      • 6: 7017934
      • 7: 7017930
      • 8: 7017945
      • 9: 7017912
      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#1270hattch2022prod3.85msselect * from `post_codes` where `id` in (7200, 7204, 4882, 6364, 4864, 6363, 6356, 4868, 7267, 6362, 4875, 4866, 6179, 4867, 6193, 6852, 6354, 6851, 6854, 6849, 6706, 6353, 6178, 6204, 4887, 4891, 4773)
      Bindings
      • 0: 7200
      • 1: 7204
      • 2: 4882
      • 3: 6364
      • 4: 4864
      • 5: 6363
      • 6: 6356
      • 7: 4868
      • 8: 7267
      • 9: 6362
      • 10: 4875
      • 11: 4866
      • 12: 6179
      • 13: 4867
      • 14: 6193
      • 15: 6852
      • 16: 6354
      • 17: 6851
      • 18: 6854
      • 19: 6849
      • 20: 6706
      • 21: 6353
      • 22: 6178
      • 23: 6204
      • 24: 4887
      • 25: 4891
      • 26: 4773
      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#1277hattch2022prod5.2msselect * 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#1287hattch2022prod2.91msselect * from `industries` where `id` in (1)
      Bindings
      • 0: 1
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:1287
      • app/Http/Controllers/FranchiseDirectoryController.php:1097
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#1295hattch2022prod3.99msselect * from `survey_questions` where `brand_id` in (7017941, 7017960, 7017949, 7017948, 7017951, 7017973, 7017934, 7017930, 7017945, 7017912) and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017941
      • 1: 7017960
      • 2: 7017949
      • 3: 7017948
      • 4: 7017951
      • 5: 7017973
      • 6: 7017934
      • 7: 7017930
      • 8: 7017945
      • 9: 7017912
      • 10: 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.99msselect * from `homepages` where `brand_id` in (7017941, 7017960, 7017949, 7017948, 7017951, 7017973, 7017934, 7017930, 7017945, 7017912)
      Bindings
      • 0: 7017941
      • 1: 7017960
      • 2: 7017949
      • 3: 7017948
      • 4: 7017951
      • 5: 7017973
      • 6: 7017934
      • 7: 7017930
      • 8: 7017945
      • 9: 7017912
      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.88msselect `industry_slug`, `industry` from `industries`
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:1123
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FranchiseDirectoryController.php#1136hattch2022prod3.95msselect `postcode` from `post_codes` where `postcode` = '2646' limit 10
      Bindings
      • 0: 2646
      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.7msselect * from `post_codes` where `postcode` in ('2646', 2646, 2646, 2646, 2646, 2646, 2646, 2646, 2646, 2646, 2646)
      Bindings
      • 0: 2646
      • 1: 2646
      • 2: 2646
      • 3: 2646
      • 4: 2646
      • 5: 2646
      • 6: 2646
      • 7: 2646
      • 8: 2646
      • 9: 2646
      • 10: 2646
      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#60hattch2022prod3.43msselect * from `post_codes` where `id` = 1144 limit 1
      Bindings
      • 0: 1144
      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#257hattch2022prod6.26msselect * from `industries` where `industry_slug` = 'cafe-food-beverage' limit 1
      Bindings
      • 0: cafe-food-beverage
      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.39msselect * from `industries` where `id` = 1 limit 1
      Bindings
      • 0: 1
      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#383hattch2022prod6.86msselect * from `post_codes` where `id` = 1144 limit 1
      Bindings
      • 0: 1144
      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.39msselect * from `industries` where `industry_slug` = 'cafe-food-beverage' limit 1
      Bindings
      • 0: cafe-food-beverage
      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.56msselect * from `post_codes` where `id` = 1144 limit 1
      Bindings
      • 0: 1144
      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#99hattch2022prod3.67msSELECT 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.55msSELECT 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#172hattch2022prod4.14msselect * 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\Industry
    30Industry.php#?
    App\Models\PostCode
    29PostCode.php#?
    App\Models\Brand
    16Brand.php#?
    App\Models\Homepage
    16Homepage.php#?
    App\Models\FranchiseType
    4FranchiseType.php#?
    App\Models\Category
    3Category.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-07-03 18:50:41GET/businesses-for-sale/within-cafe-food-beverage/in-corowa-nsw-2646?page=2+622554176