business for sale hattch logo mobile

Selected Location

Clifton Hill (3068)
From
To
×

410 Cafe, Food & Beverage businesses for sale in Clifton Hill VIC 3068

Target Icon
Which franchises are thebest match for you?

410 businesses for sale

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

Ferguson Plarre: Sunshine

Sunshine, VIC 3020 15.4 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: Sunshine Marketplace

Sunshine, VIC 3020 15.4 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 15.4 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: Oakleigh

Oakleigh, VIC 3166 15.9 km away

(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: Oakleigh

Oakleigh, VIC 3166 15.9 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 16.1 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

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

Liv Eat: Altona North

Altona North, VIC 3025 16.7 km away

Launch your business journey with Liv Eat's newest franchise opportunity in Altona North, Victoria. This thriving western Melbourne suburb, known for its strong industrial presence...(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: Example

Altona North, VIC 3025 16.7 km away

Become the pioneering Milky Lane franchisee in Altona North, a rapidly expanding suburb in Melbourne's western growth corridor. Located just 10km from Melbourne's CBD, Altona North...(more)

Total Investment: From $100K

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 17.3 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: Pacific Epping

Epping, VIC 3076 17.3 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: Hampton

Hampton, VIC 3188 17.5 km away

Established in 1901, Ferguson Plarre Bakehouses offers a rare opportunity to join a heritage brand that has perfected the art of traditional baking while embracing innovation in Ha...(more)

Total Investment: From $400K

Business Type: New Franchise

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

Noodle Box: Mitcham

Mitcham, VIC 3132 19.1 km away

(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 19.6 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 19.7 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 San Churro logo
A graphic representing a compatibility score out of 100%
?%
match

San Churro: Keilor Downs

Keilor Downs, VIC 3038 19.7 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 20.9 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: Diamond Creek

Diamond Creek, VIC 3089 21.0 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: Westfield Southland

Cheltenham, VIC 3192 21.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: Knox Private Hospital

Wantirna, VIC 3152 22.4 km away

Join Jamaica Blue's strategic expansion in Wantirna, a thriving suburb in Melbourne's eastern growth corridor. Located within Knox City Shopping Centre, one of Victoria's major ret...(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 22.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: Ringwood

Ringwood, VIC 3134 22.7 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: Mernda

Mernda, VIC 3754 24.6 km away

(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: Craigieburn

Craigieburn, VIC 3064 25.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: Craigieburn

Craigieburn, VIC 3064 25.5 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: Craigieburn Central

Craigieburn, VIC 3064 25.5 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: Mountain High

Bayswater, VIC 3153 25.6 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: Bayswater

Bayswater, VIC 3153 25.6 km away

Established in 1901, Ferguson Plarre Bakehouses offers a rare opportunity to join a heritage brand that has perfected the art of traditional baking while embracing innovation. Bays...(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: Croydon

Croydon, VIC 3136 26.5 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: Croydon Central

Croydon, VIC 3136 26.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: Point Cook

Point Cook, VIC 3030 27.3 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: Keysborough

Keysborough, VIC 3173 30.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: Parkmore

Keysborough, VIC 3173 30.0 km away

(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: Chirnside Park

Chirnside Park, VIC 3116 30.1 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: Dandenong

Dandenong, VIC 3175 30.6 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: Rockbank

Rockbank, VIC 3335 31.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: Thornhill Park

Rockbank, VIC 3335 31.2 km away

(more)

Total Investment: From $400K

Business Type: New Franchise

View
Messages50RequestTimelineExceptionsViews25Queries51Models168Livewire0MailsGate
SettingsRequest history457msRequest 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-clifton-hill-vi...
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:45] LOG.info: ValidateBusinessListingUrl processing request { "path": "businesses-for-sal...
  • infolog[18:50:45] LOG.info: Route has location parameter, passing through { "location": "clifton-hill-v...
  • infolog[18:50:45] LOG.info: Processing single location parameter { "location": "clifton-hill-vic-3068",...
  • infolog[18:50:45] LOG.info: Successfully parsed location parameter { "location": "clifton-hill-vic-3068...
  • infolog[18:50:45] LOG.info: Cookie debugging in FranchiseDirectoryController { "path": "businesses-for-...
  • infolog[18:50:45] LOG.info: Parameters received: { "industry": "cafe-food-beverage", "franchiseType...
  • infolog[18:50:45] LOG.info: User is not authenticated on filtered listings page { "host": "directory.te...
  • infolog[18:50:45] LOG.info: Populated filter arrays from parsed location { "suburb": "clifton-hill", ...
  • infolog[18:50:45] LOG.info: Starting getFilteredListings with filters: { "locations": [], "business...
  • infolog[18:50:45] LOG.info: Applying industry filter: { "industry": "cafe-food-beverage" }
  • infolog[18:50:45] LOG.info: Using single known industry: { "industry": "cafe-food-beverage" }
  • infolog[18:50:45] LOG.info: Applying location filters: { "suburb": [ "clifton-hill" ], ...
  • infolog[18:50:45] LOG.info: Using postcodes for filtering: { "postcodes": [ "3068" ] }
  • infolog[18:50:45] LOG.info: Including nearby postcodes: { "count": 56, "postcodes": [ 3068,...
  • infolog[18:50:45] LOG.info: Adding distance_km to select for sorting by distance
  • debuglog[18:50:45] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.*, `brands`.`id` as ...
  • infolog[18:50:45] LOG.info: Successfully retrieved listings { "total": 22, "per_page": 36, "cur...
  • infolog[18:50:45] LOG.info: Listings retrieved: { "count": 0, "total": 22 }
  • infolog[18:50:45] LOG.info: Caching filter options for 30 minutes
  • errorlog[18:50:45] LOG.error: Error getting filter options: file_put_contents(/var/app/current/storage/frame...
  • infolog[18:50:45] LOG.info: Brand IDs found: { "ids": [] }
  • infolog[18:50:45] LOG.info: Retrieved postcode record for brand filters: { "postcode": "3068", "has...
  • infolog[18:50:45] LOG.info: Adding coordinates to brand filters for distance search: { "lat": "-37.7835...
  • infolog[18:50:45] LOG.info: Setting distance parameter for brands: { "max_distance": 99999 }
  • infolog[18:50:45] LOG.info: Local brand count check (exact postcode): { "postcode": "3068", "localB...
  • infolog[18:50:45] LOG.info: Starting getFilteredBrands with filters: { "locations": [], "businessTy...
  • infolog[18:50:45] LOG.info: Applying industry filter: { "industry": "cafe-food-beverage" }
  • infolog[18:50:45] LOG.info: Using single known industry: { "industry": "cafe-food-beverage" }
  • infolog[18:50:46] LOG.info: Using coordinates for distance-based search: { "lat": -37.78356, "lng":...
  • debuglog[18:50:46] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:50:46] LOG.info: Successfully retrieved brands { "total": 11, "per_page": 36, "curre...
  • infolog[18:50:46] LOG.info: Postcode found: { "id": 7306, "suburb": "Clifton Hill" }
  • infolog[18:50:46] LOG.info: Final postcodeArray before passing to view: { "postcodeArray": [ { ...
  • infolog[18:50:46] LOG.info: Starting getDefaultListings without filters
  • debuglog[18:50:46] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.* from `listings` in...
  • infolog[18:50:46] LOG.info: Successfully retrieved listings { "total": 2552, "per_page": 36, "c...
  • infolog[18:50:46] LOG.info: Starting getDefaultBrands without filters
  • debuglog[18:50:46] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:50:46] LOG.info: Successfully retrieved listings { "total": 42, "per_page": 36, "cur...
  • infolog[18:50:46] LOG.info: Exact location listing count { "suburb": "clifton-hill", "state": "VIC"...
  • infolog[18:50:46] LOG.info: Starting getNearbyListings with filters: { "locations": [], "businessTy...
  • infolog[18:50:46] LOG.info: Applying industry filter: { "industry": "cafe-food-beverage" }
  • infolog[18:50:46] LOG.info: Using where for single industry { "industry": "cafe-food-beverage" }
  • debuglog[18:50:46] LOG.debug: Final SQL query for nearby listings: { "sql": "select distinct `listings`....
  • infolog[18:50:46] LOG.info: Successfully retrieved nearby listings { "total": 410, "per_page": 36, ...
  • infolog[18:50:46] LOG.info: Display flags: { "hasExactLocationSearch": true, "originalBrandCount": ...
  • infolog[18:50:46] LOG.info: Getting industry IDs from slug { "slug": "cafe-food-beverage" }
  • infolog[18:50:46] LOG.info: Found industry from direct lookup { "slug": "cafe-food-beverage", "id":...
  • infolog[18:50:46] LOG.info: Final industry IDs from slug { "slug": "cafe-food-beverage", "ids": [ ...
  • infolog[18:50:46] 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-clifton-hill-vi...
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
459ms
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:13 [▼
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "via" => array:1 [▶
    0 => "1.1 squid-proxy-5b5d847c96-kml6h (squid/6.10)"
  ]
  "cookie" => array:1 [▶
    0 => "_clck=lwhbtr%7C2%7Cfxa%7C0%7C2010"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "x-amzn-trace-id" => array:1 [▶
    0 => "Root=1-68664465-09bb8512147e59e516722f17"
  ]
  "host" => array:1 [▶
    0 => "directory.testing.hattch.net"
  ]
  "x-forwarded-port" => array:1 [▶
    0 => "80"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "http"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "10.1.3.136, 216.73.216.89"
  ]
]
request_cookies
  0 of 0   
array:1 [▼
  "_clck" => "lwhbtr|2|fxa|0|2010"
]
response_headers
  0 of 0   
array:3 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Thu, 03 Jul 2025 08:50:46 GMT"
  ]
]
session_attributes
  0 of 0   
array:1 [▼
  "_token" => "iIGUP41aWshiDyTUzH6Q9OoCoXmkpA8jRe3TETdZ"
]
  • Booting (16.18ms)time
  • Application (440ms)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 (96.45%)
    440ms
    1 x Booting (3.54%)
    16.18ms
    1 x Routing (0.38%)
    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
    51 statements were executed (13 duplicates)Show only duplicates367ms
    • 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#328hattch2022prod26.88msselect 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#333hattch2022prod2.5msselect `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#34hattch2022prod2.59msselect `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.74msselect `to_postcode` from `distances` where `from_postcode` in ('3068') order by `distance_km` asc
      Bindings
      • 0: 3068
      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#446hattch2022prod5.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` left join `distances` on `post_codes`.`postcode` = `distances`.`to_postcode` and `distances`.`from_postcode` in ('3068') 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 (3068, 3068, 3070, 3071, 3067, 3066, 3065, 3057, 3054, 3002, 3101, 3078, 3056, 3053, 3051, 3121, 3102, 3052, 3072, 3000, 3122, 3006, 3032, 3055, 3031, 3141, 3142, 3058, 3079, 3003, 3205, 3008, 3073, 3081, 3206, 3181, 3144, 3104, 3039, 3123, 3182, 3143, 3207, 3126, 3105, 3103, 3044, 3040, 3011, 3124, 3046, 3161, 3084, 3183, 3060, '3068')
      Bindings
      • 0: 3068
      • 1: open
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 3068
      • 6: 3068
      • 7: 3070
      • 8: 3071
      • 9: 3067
      • 10: 3066
      • 11: 3065
      • 12: 3057
      • 13: 3054
      • 14: 3002
      • 15: 3101
      • 16: 3078
      • 17: 3056
      • 18: 3053
      • 19: 3051
      • 20: 3121
      • 21: 3102
      • 22: 3052
      • 23: 3072
      • 24: 3000
      • 25: 3122
      • 26: 3006
      • 27: 3032
      • 28: 3055
      • 29: 3031
      • 30: 3141
      • 31: 3142
      • 32: 3058
      • 33: 3079
      • 34: 3003
      • 35: 3205
      • 36: 3008
      • 37: 3073
      • 38: 3081
      • 39: 3206
      • 40: 3181
      • 41: 3144
      • 42: 3104
      • 43: 3039
      • 44: 3123
      • 45: 3182
      • 46: 3143
      • 47: 3207
      • 48: 3126
      • 49: 3105
      • 50: 3103
      • 51: 3044
      • 52: 3040
      • 53: 3011
      • 54: 3124
      • 55: 3046
      • 56: 3161
      • 57: 3084
      • 58: 3183
      • 59: 3060
      • 60: 3068
      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#446hattch2022prod6.46msselect 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 ('3068') 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 (3068, 3068, 3070, 3071, 3067, 3066, 3065, 3057, 3054, 3002, 3101, 3078, 3056, 3053, 3051, 3121, 3102, 3052, 3072, 3000, 3122, 3006, 3032, 3055, 3031, 3141, 3142, 3058, 3079, 3003, 3205, 3008, 3073, 3081, 3206, 3181, 3144, 3104, 3039, 3123, 3182, 3143, 3207, 3126, 3105, 3103, 3044, 3040, 3011, 3124, 3046, 3161, 3084, 3183, 3060, '3068') order by CASE WHEN post_codes.postcode IN ('3068') THEN 0 ELSE 1 END, `distances`.`distance_km` asc, `post_codes`.`postcode` asc limit 36 offset 36
      Bindings
      • 0: 3068
      • 1: open
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 3068
      • 6: 3068
      • 7: 3070
      • 8: 3071
      • 9: 3067
      • 10: 3066
      • 11: 3065
      • 12: 3057
      • 13: 3054
      • 14: 3002
      • 15: 3101
      • 16: 3078
      • 17: 3056
      • 18: 3053
      • 19: 3051
      • 20: 3121
      • 21: 3102
      • 22: 3052
      • 23: 3072
      • 24: 3000
      • 25: 3122
      • 26: 3006
      • 27: 3032
      • 28: 3055
      • 29: 3031
      • 30: 3141
      • 31: 3142
      • 32: 3058
      • 33: 3079
      • 34: 3003
      • 35: 3205
      • 36: 3008
      • 37: 3073
      • 38: 3081
      • 39: 3206
      • 40: 3181
      • 41: 3144
      • 42: 3104
      • 43: 3039
      • 44: 3123
      • 45: 3182
      • 46: 3143
      • 47: 3207
      • 48: 3126
      • 49: 3105
      • 50: 3103
      • 51: 3044
      • 52: 3040
      • 53: 3011
      • 54: 3124
      • 55: 3046
      • 56: 3161
      • 57: 3084
      • 58: 3183
      • 59: 3060
      • 60: 3068
      • 61: 3068
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1094hattch2022prod2.51msselect * from `industries` where `industries`.`deleted_at` is null order by `industry` asc
      Backtrace
      • app/Services/BusinessListingService.php:1094
      • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • app/Services/BusinessListingService.php:1090
      • app/Http/Controllers/FranchiseDirectoryController.php:597
    • BusinessListingService.php#1095hattch2022prod2.38msselect * 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.33msselect * from `categories` where `categories`.`deleted_at` is null order by `category` asc
      Backtrace
      • app/Services/BusinessListingService.php:1096
      • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • app/Services/BusinessListingService.php:1090
      • app/Http/Controllers/FranchiseDirectoryController.php:597
    • FranchiseDirectoryController.php#624hattch2022prod2.66msselect * from `post_codes` where `postcode` = '3068' limit 1
      Bindings
      • 0: 3068
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:624
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FranchiseDirectoryController.php#721hattch2022prod2.87msselect `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#730hattch2022prod3.1msselect 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` = '3068' and (`brands`.`industry_id` = 1 or `brands`.`secondary_industry_id` = 1)
      Bindings
      • 0: open
      • 1: 1
      • 2: 3068
      • 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.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/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#1053hattch2022prod13.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(-37.78356)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.98573)) + sin(radians(-37.78356)) * 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: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#1053hattch2022prod7.56msselect distinct `brands`.`id`, `brands`.`id` as `brand_id`, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `brands`.`minimum_investment`, `brands`.`maximum_investment`, `brands`.`country_code`, `industries`.`industry`, `industries`.`industry_slug`, MIN(post_codes.suburb) as suburb, MIN(post_codes.state) as state, MIN(post_codes.postcode) as postcode, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_brand_logo")) as mobile_brand_logo, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_listing_image")) as mobile_listing_image, JSON_UNQUOTE(JSON_EXTRACT(homepages.section2, "$.business_intro_subtext")) as business_intro_subtext, MIN((6751 * acos(cos(radians(-37.78356)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.98573)) + sin(radians(-37.78356)) * 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(-37.78356)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.98573)) + sin(radians(-37.78356)) * 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: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#783hattch2022prod6msselect * from `post_codes` where `suburb` in ('Clifton Hill', 'Clifton-hill') and `state` = 'VIC' and `postcode` = '3068' limit 1
      Bindings
      • 0: Clifton Hill
      • 1: Clifton-hill
      • 2: VIC
      • 3: 3068
      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#498hattch2022prod24.37msselect 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#498hattch2022prod45.18msselect 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#615hattch2022prod42.39msselect 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#615hattch2022prod31.22msselect 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.66msselect * 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#615hattch2022prod10.87msselect * 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.47msselect * 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.27msselect * from `post_codes` where 0 = 1
      Backtrace
      • app/Services/BusinessListingService.php:615
      • app/Http/Controllers/FranchiseDirectoryController.php:811
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#856hattch2022prod2.32msselect `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#870hattch2022prod2.74msselect 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` = '3068' and `post_codes`.`state` = 'VIC' and `post_codes`.`suburb` in ('Clifton Hill', 'Clifton-hill') and `listings`.`status` = 'open' and (`brands`.`industry_id` = 1 or `brands`.`secondary_industry_id` = 1)
      Bindings
      • 0: 3068
      • 1: VIC
      • 2: Clifton Hill
      • 3: Clifton-hill
      • 4: open
      • 5: 1
      • 6: 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#34hattch2022prod10.27msselect `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#1488hattch2022prod13.4msselect 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: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#1488hattch2022prod10.39msselect distinct `listings`.`id`, `listings`.`name`, `listings`.`overview`, `listings`.`min_investment`, `listings`.`max_investment`, `listings`.`new`, `listings`.`status`, `listings`.`post_code_id`, `listings`.`brand_id`, `listings`.`created_at`, `listings`.`updated_at`, `listings`.`category_id`, `brands`.`id` as `brand_id_relation`, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `industries`.`industry`, `industries`.`industry_slug`, `post_codes`.`suburb`, `post_codes`.`state`, `post_codes`.`postcode`, (6751 * acos(cos(radians(-37.78971)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.99682)) + sin(radians(-37.78971)) * 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: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.72msselect * from `brands` where `brands`.`id` in (7017934, 7017941, 7017945, 7017948, 7017949, 7017951, 7017960, 7017973)
      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#1488hattch2022prod12.73msselect * from `homepages` where `homepages`.`brand_id` in (7017934, 7017941, 7017945, 7017948, 7017949, 7017951, 7017960, 7017973)
      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.39msselect * from `industries` where `industries`.`id` in (1) and `industries`.`deleted_at` is null
      Backtrace
      • app/Services/BusinessListingService.php:1488
      • app/Http/Controllers/FranchiseDirectoryController.php:905
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1488hattch2022prod2.49msselect * from `post_codes` where `post_codes`.`id` in (4816, 4819, 4875, 4882, 4887, 4891, 5665, 5669, 5856, 5913, 5971, 5978, 6181, 6191, 6211, 6353, 6354, 6356, 6616, 7202, 7204, 7211, 7212, 7242, 7249)
      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.75msselect * from `brands` where `id` in (7017951, 7017949, 7017945, 7017941, 7017960, 7017934, 7017973, 7017948)
      Bindings
      • 0: 7017951
      • 1: 7017949
      • 2: 7017945
      • 3: 7017941
      • 4: 7017960
      • 5: 7017934
      • 6: 7017973
      • 7: 7017948
      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.62msselect * from `post_codes` where `id` in (4887, 6353, 4882, 5856, 7204, 7211, 4816, 7202, 6356, 4875, 4891, 6616, 4819, 5978, 6354, 6191, 7212, 5913, 5971, 6181, 7249, 5669, 7242, 5665, 6211)
      Bindings
      • 0: 4887
      • 1: 6353
      • 2: 4882
      • 3: 5856
      • 4: 7204
      • 5: 7211
      • 6: 4816
      • 7: 7202
      • 8: 6356
      • 9: 4875
      • 10: 4891
      • 11: 6616
      • 12: 4819
      • 13: 5978
      • 14: 6354
      • 15: 6191
      • 16: 7212
      • 17: 5913
      • 18: 5971
      • 19: 6181
      • 20: 7249
      • 21: 5669
      • 22: 7242
      • 23: 5665
      • 24: 6211
      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.7msselect * 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.85msselect * 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#1295hattch2022prod2.54msselect * from `survey_questions` where `brand_id` in (7017951, 7017949, 7017945, 7017941, 7017960, 7017934, 7017973, 7017948) and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017951
      • 1: 7017949
      • 2: 7017945
      • 3: 7017941
      • 4: 7017960
      • 5: 7017934
      • 6: 7017973
      • 7: 7017948
      • 8: 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#1301hattch2022prod4.52msselect * from `homepages` where `brand_id` in (7017951, 7017949, 7017945, 7017941, 7017960, 7017934, 7017973, 7017948)
      Bindings
      • 0: 7017951
      • 1: 7017949
      • 2: 7017945
      • 3: 7017941
      • 4: 7017960
      • 5: 7017934
      • 6: 7017973
      • 7: 7017948
      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.36msselect `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.33msselect `postcode` from `post_codes` where `postcode` = '3068' limit 10
      Bindings
      • 0: 3068
      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.46msselect * from `post_codes` where `postcode` in ('3068', 3068, 3068)
      Bindings
      • 0: 3068
      • 1: 3068
      • 2: 3068
      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.55msselect * from `post_codes` where `id` = 7306 limit 1
      Bindings
      • 0: 7306
      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.34msselect * 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.29msselect * 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#383hattch2022prod2.29msselect * from `post_codes` where `id` = 7306 limit 1
      Bindings
      • 0: 7306
      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#416hattch2022prod8.91msselect * 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#50hattch2022prod3.78msselect * from `post_codes` where `id` = 7306 limit 1
      Bindings
      • 0: 7306
      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.44msSELECT 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.6msSELECT maximum_investment from `brands` GROUP BY maximum_investment ORDER BY maximum_investment ASC;
      Backtrace
      • view::pages.home.partials.header-filters:118
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • header-filters.blade.php#172hattch2022prod2.39msselect * 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
    28Industry.php#?
    App\Models\PostCode
    27PostCode.php#?
    App\Models\Brand
    14Brand.php#?
    App\Models\Homepage
    14Homepage.php#?
    App\Models\FranchiseType
    4FranchiseType.php#?
    App\Models\Category
    3Category.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-07-03 18:50:46GET/businesses-for-sale/within-cafe-food-beverage/in-clifton-hill-vic-3068?distance=99999&page=2502551168