114 Cafe, Food & Beverage businesses for sale in Rosebud VIC 3939

Jamaica Blue: Rosebud Plaza

(more)

Total Investment: From $300K

Business Type: New Franchise

Ferguson Plarre: Mornington Peninsula

(more)

Total Investment: From $400K

Business Type: New Franchise

Ferguson Plarre: Mornington

(more)

Total Investment: From $300K

Business Type: New Franchise

Degani Bakery Cafe: Mornington

(more)

Total Investment: From $400K

Business Type: New Franchise

Muffin Break: Mornington Central

(more)

Total Investment: From $200K

Business Type: New Franchise

San Churro: Mornington

(more)

Total Investment: From $300K

Business Type: New Franchise

San Churro: Frankston

Secure a prime San Churro franchise opportunity in Frankston, one of Melbourne's fastest-growing bayside communities. Located in the heart of this major retail and entertainment pr...(more)

Total Investment: From $300K

Business Type: New Franchise

Muffin Break: Bayside

(more)

Total Investment: From $200K

Business Type: New Franchise

Ferguson Plarre: Ocean Grove

(more)

Total Investment: From $300K

Business Type: New Franchise

Ferguson Plarre: Surf Coast

Ferguson Plarre Bakehouses presents a rare opportunity to join a heritage brand with over 120 years of baking excellence in the thriving coastal community of Ocean Grove, Victoria....(more)

Total Investment: From $300K

Business Type: New Franchise

Ferguson Plarre: Drysdale

Join Ferguson Plarre Bakehouses in establishing their newest location in the growing community of Drysdale, Victoria. Situated on the Bellarine Peninsula, Drysdale serves as a key...(more)

Total Investment: From $300K

Business Type: New Franchise

Noodle Box: Patterson Lakes

Noodle Box offers a fresh opportunity to join Australia's premier Asian-inspired fast food franchise in the thriving waterside suburb of Patterson Lakes. This established location...(more)

Total Investment: From $200K

Business Type: New Franchise

Noodle Box: Cranbourne

(more)

Total Investment: From $200K

Business Type: New Franchise

San Churro: Cranbourne

(more)

Total Investment: From $300K

Business Type: New Franchise

Ferguson Plarre: Leopold

Leopold, VIC 3224 46.5 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Degani Bakery Cafe: Gateway Plaza

Leopold, VIC 3224 46.5 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

San Churro: Keysborough

(more)

Total Investment: From $300K

Business Type: New Franchise

Muffin Break: Parkmore

(more)

Total Investment: From $200K

Business Type: New Franchise

Jamaica Blue: Westfield Southland

(more)

Total Investment: From $300K

Business Type: New Franchise

Ferguson Plarre: Hampton

Hampton, VIC 3188 51.8 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

Ferguson Plarre: Clyde North

(more)

Total Investment: From $300K

Business Type: New Franchise

Jamaica Blue: Casey Central

(more)

Total Investment: From $300K

Business Type: New Franchise

Liv Eat: Narre Warren

(more)

Total Investment: From $200K

Business Type: New Franchise

Muffin Break: Fountain Gate

(more)

Total Investment: From $50K

Business Type: Franchise Resale

Liv Eat: Dandenong

(more)

Total Investment: From $200K

Business Type: New Franchise

Noodle Box: Berwick

Berwick, VIC 3806 55.9 km away

Establish your future in quick-service dining with a Noodle Box franchise opportunity in Berwick, one of Melbourne's fastest-growing southeastern suburbs. Located in the heart of t...(more)

Total Investment: From $200K

Business Type: New Franchise

San Churro: Point Cook

(more)

Total Investment: From $300K

Business Type: New Franchise

San Churro: Geelong

Geelong, VIC 3220 57.3 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Jamaica Blue: Westfield Geelong

Geelong, VIC 3220 57.3 km away

(more)

Total Investment: From $100K

Business Type: Franchise Resale

Ferguson Plarre: Geelong City

Geelong, VIC 3220 57.3 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Degani Bakery Cafe: Oakleigh

(more)

Total Investment: From $400K

Business Type: New Franchise

San Churro: Oakleigh

(more)

Total Investment: From $300K

Business Type: New Franchise

Jamaica Blue: Waverley Gardens

(more)

Total Investment: From $300K

Business Type: New Franchise

San Churro: Malvern East

(more)

Total Investment: From $300K

Business Type: New Franchise

Noodle Box: Werribee

(more)

Total Investment: From $200K

Business Type: New Franchise

Jamaica Blue: Pacific Werribee

Jamaica Blue offers a premium café experience that combines exceptional coffee with fresh, inspired food in a relaxed atmosphere. Werribee presents an exciting business opportunity...(more)

Total Investment: From $300K

Business Type: New Franchise

SettingsRequest history371msRequest Duration9MBMemory 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-rosebud-vic-393...
action_name
directory.industry-location-search.single
controller_action
App\Http\Controllers\FranchiseDirectoryController@showFilteredListings
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
  • infolog[18:38:02] LOG.info: ValidateBusinessListingUrl processing request { "path": "businesses-for-sal...
  • infolog[18:38:02] LOG.info: Route has location parameter, passing through { "location": "rosebud-vic-39...
  • infolog[18:38:02] LOG.info: Processing single location parameter { "location": "rosebud-vic-3939", ...
  • infolog[18:38:02] LOG.info: Successfully parsed location parameter { "location": "rosebud-vic-3939", ...
  • infolog[18:38:02] LOG.info: Cookie debugging in FranchiseDirectoryController { "path": "businesses-for-...
  • infolog[18:38:02] LOG.info: Parameters received: { "industry": "cafe-food-beverage", "franchiseType...
  • infolog[18:38:02] LOG.info: User is not authenticated on filtered listings page { "host": "directory.te...
  • infolog[18:38:02] LOG.info: Populated filter arrays from parsed location { "suburb": "rosebud", "st...
  • infolog[18:38:02] LOG.info: Starting getFilteredListings with filters: { "locations": [], "business...
  • infolog[18:38:02] LOG.info: Applying industry filter: { "industry": "cafe-food-beverage" }
  • infolog[18:38:02] LOG.info: Using single known industry: { "industry": "cafe-food-beverage" }
  • infolog[18:38:02] LOG.info: Applying location filters: { "suburb": [ "rosebud" ], "stat...
  • infolog[18:38:02] LOG.info: Using postcodes for filtering: { "postcodes": [ "3939" ] }
  • infolog[18:38:02] LOG.info: Including nearby postcodes: { "count": 8, "postcodes": [ 3939, ...
  • infolog[18:38:02] LOG.info: Adding distance_km to select for sorting by distance
  • debuglog[18:38:02] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.*, `brands`.`id` as ...
  • infolog[18:38:02] LOG.info: Successfully retrieved listings { "total": 3, "per_page": 36, "curr...
  • infolog[18:38:02] LOG.info: Listings retrieved: { "count": 2, "total": 3 }
  • infolog[18:38:02] LOG.info: Brand IDs found: { "ids": [ 7017949, 7017951 ] }
  • infolog[18:38:02] LOG.info: Retrieved postcode record for brand filters: { "postcode": "3939", "has...
  • infolog[18:38:02] LOG.info: Adding coordinates to brand filters for distance search: { "lat": "-38.3709...
  • infolog[18:38:02] LOG.info: Setting distance parameter for brands: { "max_distance": 100 }
  • infolog[18:38:02] LOG.info: Local brand count check (exact postcode): { "postcode": "3939", "localB...
  • infolog[18:38:02] LOG.info: Starting getFilteredBrands with filters: { "locations": [], "businessTy...
  • infolog[18:38:02] LOG.info: Applying industry filter: { "industry": "cafe-food-beverage" }
  • infolog[18:38:02] LOG.info: Using single known industry: { "industry": "cafe-food-beverage" }
  • infolog[18:38:02] LOG.info: Using coordinates for distance-based search: { "lat": -38.37094, "lng":...
  • debuglog[18:38:02] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:38:02] LOG.info: Successfully retrieved brands { "total": 10, "per_page": 36, "curre...
  • infolog[18:38:02] LOG.info: Postcode found: { "id": 6456, "suburb": "Rosebud" }
  • infolog[18:38:02] LOG.info: Final postcodeArray before passing to view: { "postcodeArray": [ { ...
  • infolog[18:38:02] LOG.info: Starting getDefaultListings without filters
  • debuglog[18:38:02] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.* from `listings` in...
  • infolog[18:38:02] LOG.info: Successfully retrieved listings { "total": 2552, "per_page": 36, "c...
  • infolog[18:38:02] LOG.info: Starting getDefaultBrands without filters
  • debuglog[18:38:02] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:38:02] LOG.info: Successfully retrieved listings { "total": 42, "per_page": 36, "cur...
  • infolog[18:38:02] LOG.info: Exact location listing count { "suburb": "rosebud", "state": "VIC", ...
  • infolog[18:38:02] LOG.info: Starting getNearbyListings with filters: { "locations": [], "businessTy...
  • infolog[18:38:02] LOG.info: Applying industry filter: { "industry": "cafe-food-beverage" }
  • infolog[18:38:02] LOG.info: Using where for single industry { "industry": "cafe-food-beverage" }
  • debuglog[18:38:02] LOG.debug: Final SQL query for nearby listings: { "sql": "select distinct `listings`....
  • infolog[18:38:02] LOG.info: Successfully retrieved nearby listings { "total": 114, "per_page": 36, ...
  • infolog[18:38:02] LOG.info: Display flags: { "hasExactLocationSearch": true, "originalBrandCount": ...
  • infolog[18:38:02] LOG.info: Getting industry IDs from slug { "slug": "cafe-food-beverage" }
  • infolog[18:38:02] LOG.info: Found industry from direct lookup { "slug": "cafe-food-beverage", "id":...
  • infolog[18:38:02] LOG.info: Final industry IDs from slug { "slug": "cafe-food-beverage", "ids": [ ...
  • infolog[18:38:02] LOG.info: View data prepared successfully
status
200 OK
full_url
http://directory.testing.hattch.net/businesses-for-sale/within-cafe-food-beverage/in-rosebud-vic-393...
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
373ms
peak_memory
10MB
response
text/html; charset=UTF-8
request_format
html
request_query
0 of 0
array:1 [ "distance" => "100" ]
request_request
[]
request_headers
0 of 0
array:13 [ "cache-control" => array:1 [ 0 => "no-cache" ] "via" => array:1 [ 0 => "1.1 squid-proxy-5b5d847c96-kml6h (squid/6.10)" ] "cookie" => array:1 [ 0 => "_clck=azaeul%7C2%7Cfxa%7C0%7C2010" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "pragma" => array:1 [ 0 => "no-cache" ] "x-amzn-trace-id" => array:1 [ 0 => "Root=1-6866416a-33e0c1f72df943895cdd4119" ] "host" => array:1 [ 0 => "directory.testing.hattch.net" ] "x-forwarded-port" => array:1 [ 0 => "80" ] "x-forwarded-proto" => array:1 [ 0 => "http" ] "x-forwarded-for" => array:1 [ 0 => "10.1.3.136, 216.73.216.89" ] ]
request_cookies
0 of 0
array:1 [ "_clck" => "azaeul|2|fxa|0|2010" ]
response_headers
0 of 0
array:3 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Thu, 03 Jul 2025 08:38:02 GMT" ] ]
session_attributes
0 of 0
array:1 [ "_token" => "xx7w32KFL2MdLtDZqsiTtTi2HRVaVlUe5X0E5kay" ]
  • Booting (16.29ms)time
  • Application (355ms)time
  • Routing (1.71ms)
  • View: pages.home.brandviews
  • View: pages.home.breadcrumbviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.summaryviews
  • View: pages.home.partials.lazy-load-scriptviews
  • View: brand.common.frontpage-layoutviews
  • View: brand.common.tracking-codesviews
  • View: pages.home.universal-headerviews
  • View: pages.home.partials.header-filtersviews
  • View: pages.home.skeleton-loadersviews
  • View: pages.home.profile_slider_menuviews
  • View: pages.home.partials._main_optionsviews
  • View: pages.home.partials._account_detailsviews
  • View: pages.home.partials._franchise_compatibilityviews
  • View: pages.home.partials._enquiries_invitationsviews
  • View: pages.home.partials._investment_calculatorviews
  • View: pages.home.partials._notification_settingsviews
  • View: pages.home.partials._securityviews
  • View: pages.widget.summaryviews
  • View: layouts.common.footerviews
  • View: partials.welcome-collection-modalviews
  • 1 x Application (95.61%)
    355ms
    1 x Booting (4.39%)
    16.29ms
    1 x Routing (0.46%)
    1.71ms
    24 x View (0%)
    0μs
    24 templates were rendered
    • pages.home.brandbrand.blade.php#?blade
    • pages.home.breadcrumbbreadcrumb.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.summarysummary.blade.php#?blade
    • pages.home.partials.lazy-load-scriptlazy-load-script.blade.php#?blade
    • brand.common.frontpage-layoutfrontpage-layout.blade.php#?blade
    • brand.common.tracking-codestracking-codes.blade.php#?blade
    • pages.home.universal-headeruniversal-header.blade.php#?blade
    • pages.home.partials.header-filtersheader-filters.blade.php#?blade
    • pages.home.skeleton-loadersskeleton-loaders.blade.php#?blade
    • pages.home.profile_slider_menuprofile_slider_menu.blade.php#?blade
    • pages.home.partials._main_options_main_options.blade.php#?blade
    • pages.home.partials._account_details_account_details.blade.php#?blade
    • pages.home.partials._franchise_compatibility_franchise_compatibility.blade.php#?blade
    • pages.home.partials._enquiries_invitations_enquiries_invitations.blade.php#?blade
    • pages.home.partials._investment_calculator_investment_calculator.blade.php#?blade
    • pages.home.partials._notification_settings_notification_settings.blade.php#?blade
    • pages.home.partials._security_security.blade.php#?blade
    • pages.widget.summarysummary.blade.php#?blade
    • layouts.common.footerfooter.blade.php#?blade
    • partials.welcome-collection-modalwelcome-collection-modal.blade.php#?blade
    56 statements were executed (13 duplicates)Show only duplicates269ms
    • 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#328hattch2022prod11.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.54msselect `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.43msselect `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.68msselect `to_postcode` from `distances` where `from_postcode` in ('3939') order by `distance_km` asc
      Bindings
      • 0: 3939
      Backtrace
      • app/Services/BusinessListingService.php:267
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#446hattch2022prod3.44msselect count(*) as aggregate from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` left join `distances` on `post_codes`.`postcode` = `distances`.`to_postcode` and `distances`.`from_postcode` in ('3939') 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 (3939, 3939, 3938, 3940, 3941, 3928, 3936, '3939')
      Bindings
      • 0: 3939
      • 1: open
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 3939
      • 6: 3939
      • 7: 3938
      • 8: 3940
      • 9: 3941
      • 10: 3928
      • 11: 3936
      • 12: 3939
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#446hattch2022prod4.22msselect 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 ('3939') 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 (3939, 3939, 3938, 3940, 3941, 3928, 3936, '3939') order by CASE WHEN post_codes.postcode IN ('3939') THEN 0 ELSE 1 END, `distances`.`distance_km` asc, `post_codes`.`postcode` asc limit 36 offset 0
      Bindings
      • 0: 3939
      • 1: open
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 3939
      • 6: 3939
      • 7: 3938
      • 8: 3940
      • 9: 3941
      • 10: 3928
      • 11: 3936
      • 12: 3939
      • 13: 3939
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#446hattch2022prod2.74msselect * from `brands` where `brands`.`id` in (7017949, 7017951)
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#446hattch2022prod5.06msselect * from `homepages` where `homepages`.`brand_id` in (7017949, 7017951)
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#446hattch2022prod2.47msselect * from `industries` where `industries`.`id` in (1) and `industries`.`deleted_at` is null
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#446hattch2022prod2.53msselect * from `post_codes` where `post_codes`.`id` in (6452, 6456)
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#624hattch2022prod2.48msselect * from `post_codes` where `postcode` = '3939' limit 1
      Bindings
      • 0: 3939
      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.49msselect `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.03msselect 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` = '3939' and (`brands`.`industry_id` = 1 or `brands`.`secondary_industry_id` = 1)
      Bindings
      • 0: open
      • 1: 1
      • 2: 3939
      • 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.54msselect `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.71msselect 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(-38.37094)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.91382)) + sin(radians(-38.37094)) * 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(-38.37094)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.91382)) + sin(radians(-38.37094)) * sin(radians(post_codes.lat))))) <= 100) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 100
      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.05msselect 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(-38.37094)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.91382)) + sin(radians(-38.37094)) * 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(-38.37094)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.91382)) + sin(radians(-38.37094)) * sin(radians(post_codes.lat))))) <= 100 order by MIN((6751 * acos(cos(radians(-38.37094)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.91382)) + sin(radians(-38.37094)) * sin(radians(post_codes.lat))))) asc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 100
      Backtrace
      • app/Services/BusinessListingService.php:1053
      • app/Http/Controllers/FranchiseDirectoryController.php:744
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1053hattch2022prod6.44msselect * from `homepages` where `homepages`.`brand_id` in (7017912, 7017930, 7017934, 7017941, 7017945, 7017948, 7017949, 7017951, 7017960, 7017973)
      Backtrace
      • app/Services/BusinessListingService.php:1053
      • app/Http/Controllers/FranchiseDirectoryController.php:744
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1053hattch2022prod2.29msselect * from `industries` where 0 = 1 and `industries`.`deleted_at` is null
      Backtrace
      • app/Services/BusinessListingService.php:1053
      • app/Http/Controllers/FranchiseDirectoryController.php:744
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1053hattch2022prod6.06msselect * from `listings` where `listings`.`brand_id` in (7017912, 7017930, 7017934, 7017941, 7017945, 7017948, 7017949, 7017951, 7017960, 7017973)
      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#1053hattch2022prod4.98msselect * from `post_codes` where `post_codes`.`id` in (41, 70, 101, 108, 206, 208, 213, 254, 368, 376, 385, 397, 451, 543, 559, 561, 563, 657, 689, 710, 923, 1163, 1246, 1288, 1301, 1304, 1417, 1428, 1447, 1690, 1804, 1953, 1956, 1964, 2009, 2278, 2295, 2387, 2517, 2530, 2596, 2598, 2626, 2631, 2634, 2637, 2650, 2886, 2927, 3068, 3073, 3075, 3078, 3141, 3148, 3157, 3180, 3187, 3202, 3209, 3443, 3452, 3484, 3494, 3495, 3505, 3989, 3991, 4038, 4039, 4201, 4286, 4381, 4618, 4680, 4685, 4687, 4773, 4816, 4819, 4864, 4866, 4867, 4868, 4875, 4882, 4887, 4891, 5056, 5075, 5079, 5084, 5101, 5102, 5147, 5289, 5290, 5293, 5416, 5474, 5591, 5608, 5665, 5669, 5673, 5681, 5691, 5704, 5715, 5716, 5856, 5863, 5900, 5909, 5913, 5919, 5970, 5971, 5977, 5978, 6138, 6178, 6179, 6181, 6191, 6193, 6204, 6211, 6214, 6215, 6224, 6348, 6353, 6354, 6356, 6357, 6362, 6363, 6364, 6376, 6427, 6430, 6452, 6456, 6470, 6556, 6616, 6706, 6849, 6851, 6852, 6854, 7105, 7150, 7200, 7202, 7204, 7207, 7211, 7212, 7223, 7236, 7237, 7242, 7249, 7253, 7267, 7300, 7306, 7347, 7466, 7733, 7755, 7781, 7786, 7789, 7791, 7804, 7816, 7820, 7828, 7830, 7854, 7856, 7858, 7878, 7913, 7915, 8056, 8076, 8095, 8109, 8181, 8186, 8434, 8589, 8773, 8811, 8812, 8818, 8821, 8840, 8846, 8855, 8874, 8894, 8985, 8986, 8993, 9021, 9295, 9355, 9369, 9370, 9397, 9498, 9801, 9860, 9869, 9873, 9926, 9927, 9932, 9938, 9939, 9961, 10104, 10149, 10177, 10187, 10205, 10272, 10717, 10901, 10948, 10969, 11103, 11191, 11195, 11361, 11442, 11453, 11458, 11554, 11601, 11697, 11731, 11781, 11789, 11804, 11806, 11843, 11857, 11880, 11909, 11911, 11921, 11926, 12002, 12009, 12056, 12176, 12400, 12524, 12528, 12533, 12539, 12608, 12629, 12668, 12670, 12680, 12741, 12756, 12974, 12992, 13001, 13160, 13163, 13171, 13173, 13175, 13179, 13197, 13278, 13380, 13469, 13541, 13588, 13591, 13643, 13648, 13670, 13715, 13731, 13735, 13751, 13755, 13778, 13844, 13878, 13881, 14141, 14301, 14302, 14455, 14465, 14470, 14478, 14630, 14722, 14731, 14920, 15039, 15083, 15092, 15157, 15161, 15172, 15177, 15195, 15242, 15252)
      Backtrace
      • app/Services/BusinessListingService.php:1053
      • app/Http/Controllers/FranchiseDirectoryController.php:744
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#783hattch2022prod2.65msselect * from `post_codes` where `suburb` in ('Rosebud') and `state` = 'VIC' and `postcode` = '3939' limit 1
      Bindings
      • 0: Rosebud
      • 1: VIC
      • 2: 3939
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:783
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • BusinessListingService.php#498hattch2022prod11.28msselect count(*) as aggregate from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null)
      Bindings
      • 0: open
      • 1: 1
      Backtrace
      • app/Services/BusinessListingService.php:498
      • app/Http/Controllers/FranchiseDirectoryController.php:810
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#498hattch2022prod29.57msselect distinct `listings`.* from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) order by `post_codes`.`postcode` asc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      Backtrace
      • app/Services/BusinessListingService.php:498
      • app/Http/Controllers/FranchiseDirectoryController.php:810
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#615hattch2022prod18.14msselect count(*) as aggregate from (select distinct `brands`.`id`, `brands`.`id` as `brand_id`, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `brands`.`minimum_investment`, `brands`.`maximum_investment`, `brands`.`country_code`, `industries`.`industry`, `industries`.`industry_slug`, MIN(post_codes.suburb) as suburb, MIN(post_codes.state) as state, MIN(post_codes.postcode) as postcode, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_brand_logo")) as mobile_brand_logo, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_listing_image")) as mobile_listing_image, JSON_UNQUOTE(JSON_EXTRACT(homepages.section2, "$.business_intro_subtext")) as business_intro_subtext from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) group by `brands`.`id`) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      Backtrace
      • app/Services/BusinessListingService.php:615
      • app/Http/Controllers/FranchiseDirectoryController.php:811
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#615hattch2022prod19.31msselect distinct `brands`.`id`, `brands`.`id` as `brand_id`, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `brands`.`minimum_investment`, `brands`.`maximum_investment`, `brands`.`country_code`, `industries`.`industry`, `industries`.`industry_slug`, MIN(post_codes.suburb) as suburb, MIN(post_codes.state) as state, MIN(post_codes.postcode) as postcode, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_brand_logo")) as mobile_brand_logo, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_listing_image")) as mobile_listing_image, JSON_UNQUOTE(JSON_EXTRACT(homepages.section2, "$.business_intro_subtext")) as business_intro_subtext from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) group by `brands`.`id` order by `listings`.`created_at` desc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      Backtrace
      • app/Services/BusinessListingService.php:615
      • app/Http/Controllers/FranchiseDirectoryController.php:811
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#615hattch2022prod3.37msselect * from `brands` where `brands`.`id` in (7017918, 7017929, 7017930, 7017931, 7017932, 7017934, 7017937, 7017940, 7017941, 7017943, 7017944, 7017945, 7017946, 7017947, 7017948, 7017949, 7017950, 7017951, 7017953, 7017956, 7017959, 7017960, 7017962, 7017963, 7017964, 7017965, 7017967, 7017968, 7017969, 7017970, 7017971, 7017972, 7017973, 7017978, 7017981, 7017984)
      Backtrace
      • app/Services/BusinessListingService.php:615
      • app/Http/Controllers/FranchiseDirectoryController.php:811
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#615hattch2022prod7.63msselect * from `homepages` where `homepages`.`brand_id` in (7017918, 7017929, 7017930, 7017931, 7017932, 7017934, 7017937, 7017940, 7017941, 7017943, 7017944, 7017945, 7017946, 7017947, 7017948, 7017949, 7017950, 7017951, 7017953, 7017956, 7017959, 7017960, 7017962, 7017963, 7017964, 7017965, 7017967, 7017968, 7017969, 7017970, 7017971, 7017972, 7017973, 7017978, 7017981, 7017984)
      Backtrace
      • app/Services/BusinessListingService.php:615
      • app/Http/Controllers/FranchiseDirectoryController.php:811
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#615hattch2022prod2.56msselect * from `industries` where `industries`.`id` in (1, 2, 3, 4, 5, 6, 7, 8) and `industries`.`deleted_at` is null
      Backtrace
      • app/Services/BusinessListingService.php:615
      • app/Http/Controllers/FranchiseDirectoryController.php:811
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#615hattch2022prod2.48msselect * 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.53msselect `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.92msselect 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` = '3939' and `post_codes`.`state` = 'VIC' and `post_codes`.`suburb` in ('Rosebud') and `listings`.`status` = 'open' and (`brands`.`industry_id` = 1 or `brands`.`secondary_industry_id` = 1)
      Bindings
      • 0: 3939
      • 1: VIC
      • 2: Rosebud
      • 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#34hattch2022prod2.56msselect `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#1488hattch2022prod7.37msselect 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(-38.37094)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.91382)) + sin(radians(-38.37094)) * 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 <= 100) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 100
      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#1488hattch2022prod7.22msselect 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(-38.37094)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.91382)) + sin(radians(-38.37094)) * 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 <= 100 order by `distance_km` asc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 100
      Backtrace
      • app/Services/BusinessListingService.php:1488
      • app/Http/Controllers/FranchiseDirectoryController.php:905
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1488hattch2022prod3.37msselect * from `brands` where `brands`.`id` in (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#1488hattch2022prod3.85msselect * from `homepages` where `homepages`.`brand_id` in (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.55msselect * 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.72msselect * from `post_codes` where `post_codes`.`id` in (4816, 4819, 5075, 5079, 5084, 5101, 5416, 5665, 5669, 5673, 5691, 5715, 5716, 5970, 6353, 6354, 6452, 6456, 6470, 6854, 7236, 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#1264hattch2022prod3.09msselect * from `brands` where `id` in (7017949, 7017951, 7017945, 7017948, 7017941, 7017973, 7017960)
      Bindings
      • 0: 7017949
      • 1: 7017951
      • 2: 7017945
      • 3: 7017948
      • 4: 7017941
      • 5: 7017973
      • 6: 7017960
      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.8msselect * from `post_codes` where `id` in (6456, 6452, 6470, 5416, 5716, 5715, 5970, 5084, 5673, 5669, 4819, 4816, 5101, 5079, 5665, 5075, 7249, 5691, 6353, 6354, 6854, 7236)
      Bindings
      • 0: 6456
      • 1: 6452
      • 2: 6470
      • 3: 5416
      • 4: 5716
      • 5: 5715
      • 6: 5970
      • 7: 5084
      • 8: 5673
      • 9: 5669
      • 10: 4819
      • 11: 4816
      • 12: 5101
      • 13: 5079
      • 14: 5665
      • 15: 5075
      • 16: 7249
      • 17: 5691
      • 18: 6353
      • 19: 6354
      • 20: 6854
      • 21: 7236
      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.65msselect * 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.61msselect * 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.87msselect * from `survey_questions` where `brand_id` in (7017949, 7017951, 7017945, 7017948, 7017941, 7017973, 7017960) and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017949
      • 1: 7017951
      • 2: 7017945
      • 3: 7017948
      • 4: 7017941
      • 5: 7017973
      • 6: 7017960
      • 7: 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.69msselect * from `homepages` where `brand_id` in (7017949, 7017951, 7017945, 7017948, 7017941, 7017973, 7017960)
      Bindings
      • 0: 7017949
      • 1: 7017951
      • 2: 7017945
      • 3: 7017948
      • 4: 7017941
      • 5: 7017973
      • 6: 7017960
      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.7msselect `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.76msselect `postcode` from `post_codes` where `postcode` = '3939' limit 10
      Bindings
      • 0: 3939
      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.59msselect * from `post_codes` where `postcode` in ('3939', 3939, 3939, 3939, 3939)
      Bindings
      • 0: 3939
      • 1: 3939
      • 2: 3939
      • 3: 3939
      • 4: 3939
      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.6msselect * from `post_codes` where `id` = 6456 limit 1
      Bindings
      • 0: 6456
      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.66msselect * 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.46msselect * 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.67msselect * from `post_codes` where `id` = 6456 limit 1
      Bindings
      • 0: 6456
      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.52msselect * 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.6msselect * from `post_codes` where `id` = 6456 limit 1
      Bindings
      • 0: 6456
      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#99hattch2022prod4.5msSELECT minimum_investment from `brands` GROUP BY minimum_investment ORDER BY minimum_investment ASC;
      Backtrace
      • view::pages.home.partials.header-filters:99
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • header-filters.blade.php#118hattch2022prod3.37msSELECT 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.86msselect * 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
    547Listing.php#?
    App\Models\PostCode
    349PostCode.php#?
    App\Models\Brand
    55Brand.php#?
    App\Models\Homepage
    55Homepage.php#?
    App\Models\Industry
    24Industry.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-07-03 18:38:03GET/businesses-for-sale/within-cafe-food-beverage/in-rosebud-vic-3939?distance=1004824561030