35 Cafe, Food & Beverage businesses for sale in Queens Park WA 6107

Noodle Box: Cannington

(more)

Total Investment: From $200K

Business Type: New Franchise

Jamaica Blue: Riverton

(more)

Total Investment: From $300K

Business Type: New Franchise

Muffin Break: Waterford Plaza

(more)

Total Investment: From $200K

Business Type: New Franchise

Noodle Box: Forrestfield

(more)

Total Investment: From $200K

Business Type: New Franchise

San Churro: Ascot

Ascot, WA 6104 8.3 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

San Churro: Willetton

(more)

Total Investment: From $300K

Business Type: New Franchise

Jamaica Blue: Link @ Langley East

(more)

Total Investment: From $300K

Business Type: New Franchise

Jamaica Blue: The Mount Hospital

Perth, WA 6000 10.7 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

San Churro: Perth

Perth, WA 6000 10.7 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

San Churro: Mt Lawley

(more)

Total Investment: From $300K

Business Type: New Franchise

Noodle Box: Bassendean

(more)

Total Investment: From $200K

Business Type: New Franchise

Muffin Break: Kalamunda Central

(more)

Total Investment: From $200K

Business Type: New Franchise

San Churro: Booragoon

(more)

Total Investment: From $300K

Business Type: New Franchise

Liv Eat: Leederville

(more)

Total Investment: From $100K

Business Type: New Franchise

San Churro: Morley

Morley, WA 6062 14.0 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Jamaica Blue: The Saleyard

Midland, WA 6056 14.7 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Jamaica Blue: Shenton Quarter

(more)

Total Investment: From $300K

Business Type: New Franchise

Jamaica Blue: Orchard Ave

Midvale, WA 6056 16.2 km away

Establish your business future with Jamaica Blue, bringing premium café culture to the growing community of Midvale, WA. Positioned in one of Western Australia's rapidly developing...(more)

Total Investment: From $300K

Business Type: New Franchise

San Churro: Claremont

(more)

Total Investment: From $300K

Business Type: New Franchise

Jamaica Blue: Dayton Central

Dayton, WA 6055 17.8 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Noodle Box: Success

Success, WA 6164 19.1 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

San Churro: Innaloo

Innaloo, WA 6018 19.9 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Jamaica Blue: Woolstores

Lead the expansion of Jamaica Blue into Fremantle, WA, where historic charm meets modern café culture. Positioned in one of Western Australia's most vibrant port cities, this oppor...(more)

Total Investment: From $300K

Business Type: New Franchise

San Churro: Scarborough

Indulge in the opportunity to bring San Churro's authentic Spanish chocolate experience to the vibrant coastal suburb of Scarborough, WA. This beachside location offers a perfect b...(more)

Total Investment: From $300K

Business Type: New Franchise

Jamaica Blue: Warwick Grove

Warwick, WA 6024 23.8 km away

Join Jamaica Blue's strategic expansion in Warwick, one of Perth's fastest-growing northern suburbs. Located within the thriving Warwick Grove Shopping Centre, this territory prese...(more)

Total Investment: From $300K

Business Type: New Franchise

San Churro: Ellenbrook

(more)

Total Investment: From $300K

Business Type: New Franchise

Jamaica Blue: Ellenbrook

(more)

Total Investment: From $100K

Business Type: Franchise Resale

Noodle Box: Ellenbrook

(more)

Total Investment: From $200K

Business Type: New Franchise

Muffin Break: Woodvale Boulevard

Woodvale, WA 6026 29.4 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

San Churro: Hillarys

Hillarys, WA 6025 30.5 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Jamaica Blue: Kwinana Marketplace

Join Jamaica Blue's success story in the growing hub of Kwinana Town Centre, Western Australia. Located in Perth's southern corridor, this strategic retail destination serves a rap...(more)

Total Investment: From $300K

Business Type: New Franchise

Jamaica Blue: Currambine Central

(more)

Total Investment: From $300K

Business Type: New Franchise

San Churro: Baldivis

Baldivis, WA 6171 40.2 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Jamaica Blue: Woolworths Clarkson

Clarkson, WA 6030 43.5 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Jamaica Blue: Warnbro

Warnbro, WA 6169 44.7 km away

(more)

Total Investment: From $100K

Business Type: Franchise Resale

Want to see more listings?

You've reached the end of listings within 50 km of your location. Expand your search radius to find more businesses (you'll stay on the current page):

SettingsRequest history543msRequest Duration8MBMemory 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-queens-park-wa-...
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:00] LOG.info: ValidateBusinessListingUrl processing request { "path": "businesses-for-sal...
  • infolog[18:38:00] LOG.info: Route has location parameter, passing through { "location": "queens-park-wa...
  • infolog[18:38:00] LOG.info: Processing single location parameter { "location": "queens-park-wa-6107", ...
  • infolog[18:38:00] LOG.info: Successfully parsed location parameter { "location": "queens-park-wa-6107",...
  • infolog[18:38:00] LOG.info: Cookie debugging in FranchiseDirectoryController { "path": "businesses-for-...
  • infolog[18:38:00] LOG.info: Parameters received: { "industry": "cafe-food-beverage", "franchiseType...
  • infolog[18:38:00] LOG.info: User is not authenticated on filtered listings page { "host": "directory.te...
  • infolog[18:38:00] LOG.info: Populated filter arrays from parsed location { "suburb": "queens-park", ...
  • infolog[18:38:00] LOG.info: Starting getFilteredListings with filters: { "locations": [], "business...
  • infolog[18:38:00] LOG.info: Applying industry filter: { "industry": "cafe-food-beverage" }
  • infolog[18:38:00] LOG.info: Using single known industry: { "industry": "cafe-food-beverage" }
  • infolog[18:38:00] LOG.info: Applying location filters: { "suburb": [ "queens-park" ], "...
  • infolog[18:38:00] LOG.info: Using postcodes for filtering: { "postcodes": [ "6107" ] }
  • infolog[18:38:00] LOG.info: Including nearby postcodes: { "count": 17, "postcodes": [ 6107,...
  • infolog[18:38:00] LOG.info: Adding distance_km to select for sorting by distance
  • debuglog[18:38:00] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.*, `brands`.`id` as ...
  • infolog[18:38:00] LOG.info: Successfully retrieved listings { "total": 6, "per_page": 36, "curr...
  • infolog[18:38:00] LOG.info: Listings retrieved: { "count": 5, "total": 6 }
  • infolog[18:38:00] LOG.info: Brand IDs found: { "ids": { "0": 7017973, "2": 7017949, ...
  • infolog[18:38:00] LOG.info: Retrieved postcode record for brand filters: { "postcode": "6107", "has...
  • infolog[18:38:00] LOG.info: Adding coordinates to brand filters for distance search: { "lat": "-32.0224...
  • infolog[18:38:00] LOG.info: Setting distance parameter for brands: { "max_distance": 50 }
  • infolog[18:38:00] LOG.info: Local brand count check (exact postcode): { "postcode": "6107", "localB...
  • infolog[18:38:00] LOG.info: Starting getFilteredBrands with filters: { "locations": [], "businessTy...
  • infolog[18:38:00] LOG.info: Applying industry filter: { "industry": "cafe-food-beverage" }
  • infolog[18:38:00] LOG.info: Using single known industry: { "industry": "cafe-food-beverage" }
  • infolog[18:38:00] LOG.info: Using coordinates for distance-based search: { "lat": -32.02248, "lng":...
  • debuglog[18:38:00] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:38:00] LOG.info: Successfully retrieved brands { "total": 5, "per_page": 36, "curren...
  • infolog[18:38:00] LOG.info: Postcode found: { "id": 12679, "suburb": "Queens Park" }
  • infolog[18:38:00] LOG.info: Final postcodeArray before passing to view: { "postcodeArray": [ { ...
  • infolog[18:38:00] LOG.info: Starting getDefaultListings without filters
  • debuglog[18:38:00] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.* from `listings` in...
  • infolog[18:38:00] LOG.info: Successfully retrieved listings { "total": 2552, "per_page": 36, "c...
  • infolog[18:38:00] LOG.info: Starting getDefaultBrands without filters
  • debuglog[18:38:00] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:38:01] LOG.info: Successfully retrieved listings { "total": 42, "per_page": 36, "cur...
  • infolog[18:38:01] LOG.info: Exact location listing count { "suburb": "queens-park", "state": "WA", ...
  • infolog[18:38:01] LOG.info: Starting getNearbyListings with filters: { "locations": [], "businessTy...
  • infolog[18:38:01] LOG.info: Applying industry filter: { "industry": "cafe-food-beverage" }
  • infolog[18:38:01] LOG.info: Using where for single industry { "industry": "cafe-food-beverage" }
  • debuglog[18:38:01] LOG.debug: Final SQL query for nearby listings: { "sql": "select distinct `listings`....
  • infolog[18:38:01] LOG.info: Successfully retrieved nearby listings { "total": 35, "per_page": 36, ...
  • infolog[18:38:01] LOG.info: Display flags: { "hasExactLocationSearch": true, "originalBrandCount": ...
  • infolog[18:38:01] LOG.info: Getting industry IDs from slug { "slug": "cafe-food-beverage" }
  • infolog[18:38:01] LOG.info: Found industry from direct lookup { "slug": "cafe-food-beverage", "id":...
  • infolog[18:38:01] LOG.info: Final industry IDs from slug { "slug": "cafe-food-beverage", "ids": [ ...
  • infolog[18:38:01] LOG.info: View data prepared successfully
status
200 OK
full_url
http://directory.testing.hattch.net/businesses-for-sale/within-cafe-food-beverage/in-queens-park-wa-...
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
545ms
peak_memory
10MB
response
text/html; charset=UTF-8
request_format
html
request_query
0 of 0
array:1 [ "distance" => "50" ]
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-68664168-3d49a58f2b35ea9f71e8e96f" ] "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:01 GMT" ] ]
session_attributes
0 of 0
array:1 [ "_token" => "F9HUCQjU9iedCRrA5LQiMQ10CYvljJQgFHiCg4UV" ]
  • Booting (17.14ms)time
  • Application (526ms)time
  • Routing (1.69ms)
  • 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.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.84%)
    526ms
    1 x Booting (3.16%)
    17.14ms
    1 x Routing (0.31%)
    1.69ms
    23 x View (0%)
    0μs
    23 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.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 (15 duplicates)Show only duplicates438ms
    • 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.03msselect 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#333hattch2022prod4.66msselect `id` from `industries` where `industry_slug` = 'cafe-food-beverage' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: cafe-food-beverage
      Backtrace
      • app/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.57msselect `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#267hattch2022prod4.19msselect `to_postcode` from `distances` where `from_postcode` in ('6107') order by `distance_km` asc
      Bindings
      • 0: 6107
      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.62msselect 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 ('6107') 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 (6107, 6107, 6058, 6109, 6106, 6057, 6105, 6147, 6108, 6148, 6101, 6102, 6110, 6103, 6104, 6155, '6107')
      Bindings
      • 0: 6107
      • 1: open
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 6107
      • 6: 6107
      • 7: 6058
      • 8: 6109
      • 9: 6106
      • 10: 6057
      • 11: 6105
      • 12: 6147
      • 13: 6108
      • 14: 6148
      • 15: 6101
      • 16: 6102
      • 17: 6110
      • 18: 6103
      • 19: 6104
      • 20: 6155
      • 21: 6107
      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#446hattch2022prod16.84msselect 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 ('6107') 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 (6107, 6107, 6058, 6109, 6106, 6057, 6105, 6147, 6108, 6148, 6101, 6102, 6110, 6103, 6104, 6155, '6107') order by CASE WHEN post_codes.postcode IN ('6107') THEN 0 ELSE 1 END, `distances`.`distance_km` asc, `post_codes`.`postcode` asc limit 36 offset 0
      Bindings
      • 0: 6107
      • 1: open
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 6107
      • 6: 6107
      • 7: 6058
      • 8: 6109
      • 9: 6106
      • 10: 6057
      • 11: 6105
      • 12: 6147
      • 13: 6108
      • 14: 6148
      • 15: 6101
      • 16: 6102
      • 17: 6110
      • 18: 6103
      • 19: 6104
      • 20: 6155
      • 21: 6107
      • 22: 6107
      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.07msselect * from `brands` where `brands`.`id` in (7017941, 7017949, 7017973)
      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#446hattch2022prod12.29msselect * from `homepages` where `homepages`.`brand_id` in (7017941, 7017949, 7017973)
      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#446hattch2022prod8.85msselect * 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#446hattch2022prod3.75msselect * from `post_codes` where `post_codes`.`id` in (12539, 12668, 12670, 12680, 13175)
      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.34msselect * from `post_codes` where `postcode` = '6107' limit 1
      Bindings
      • 0: 6107
      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.41msselect `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.59msselect 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` = '6107' and (`brands`.`industry_id` = 1 or `brands`.`secondary_industry_id` = 1)
      Bindings
      • 0: open
      • 1: 1
      • 2: 6107
      • 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.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: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#1053hattch2022prod8.65msselect 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(-32.02248)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(115.91306)) + sin(radians(-32.02248)) * 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(-32.02248)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(115.91306)) + sin(radians(-32.02248)) * sin(radians(post_codes.lat))))) <= 50) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 50
      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.39msselect 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(-32.02248)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(115.91306)) + sin(radians(-32.02248)) * 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(-32.02248)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(115.91306)) + sin(radians(-32.02248)) * sin(radians(post_codes.lat))))) <= 50 order by MIN((6751 * acos(cos(radians(-32.02248)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(115.91306)) + sin(radians(-32.02248)) * sin(radians(post_codes.lat))))) asc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 50
      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.82msselect * from `homepages` where `homepages`.`brand_id` in (7017941, 7017948, 7017949, 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.54msselect * 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#1053hattch2022prod8.42msselect * from `listings` where `listings`.`brand_id` in (7017941, 7017948, 7017949, 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#1053hattch2022prod7.31msselect * 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, 1428, 1447, 1690, 1804, 1953, 1956, 1964, 2009, 2278, 2295, 2387, 2517, 2530, 2596, 2598, 2626, 2631, 2634, 2637, 2650, 2886, 2927, 3073, 3078, 3141, 3148, 3157, 3180, 3187, 3202, 3209, 3443, 3452, 3484, 3494, 3495, 3505, 3989, 3991, 4038, 4039, 4201, 4286, 4381, 4618, 4685, 4687, 4819, 4864, 4867, 4868, 4875, 4882, 4887, 4891, 5056, 5075, 5079, 5084, 5147, 5290, 5293, 5416, 5591, 5608, 5665, 5669, 5681, 5691, 5704, 5856, 5900, 5913, 5919, 5970, 5971, 5978, 6138, 6178, 6179, 6181, 6191, 6193, 6204, 6214, 6215, 6224, 6353, 6354, 6356, 6363, 6364, 6427, 6430, 6456, 6470, 6556, 6616, 6706, 6851, 6852, 6854, 7105, 7150, 7200, 7202, 7204, 7207, 7211, 7212, 7223, 7236, 7237, 7242, 7249, 7253, 7267, 7466, 7733, 7755, 7781, 7786, 7791, 7804, 7820, 7828, 7830, 7854, 7856, 7858, 7878, 7913, 7915, 8056, 8095, 8109, 8186, 8434, 8589, 8773, 8811, 8812, 8818, 8821, 8846, 8855, 8985, 8986, 9021, 9355, 9369, 9370, 9397, 9801, 9860, 9869, 9926, 9932, 9938, 9939, 9961, 10149, 10177, 10272, 10717, 10901, 10948, 10969, 11191, 11195, 11361, 11442, 11453, 11458, 11554, 11601, 11697, 11731, 11781, 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, 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.93msselect * from `post_codes` where `suburb` in ('Queens Park', 'Queens-park') and `state` = 'WA' and `postcode` = '6107' limit 1
      Bindings
      • 0: Queens Park
      • 1: Queens-park
      • 2: WA
      • 3: 6107
      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#498hattch2022prod19.5msselect 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#498hattch2022prod72.01msselect 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#615hattch2022prod46.01msselect 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#615hattch2022prod24.69msselect 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.45msselect * 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#615hattch2022prod15.93msselect * 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#615hattch2022prod4.94msselect * 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#615hattch2022prod9.86msselect * 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.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/Http/Controllers/FranchiseDirectoryController.php:856
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FranchiseDirectoryController.php#870hattch2022prod3.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` = '6107' and `post_codes`.`state` = 'WA' and `post_codes`.`suburb` in ('Queens Park', 'Queens-park') and `listings`.`status` = 'open' and (`brands`.`industry_id` = 1 or `brands`.`secondary_industry_id` = 1)
      Bindings
      • 0: 6107
      • 1: WA
      • 2: Queens Park
      • 3: Queens-park
      • 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#34hattch2022prod2.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/Services/BusinessListingService.php:34
      • app/Services/BusinessListingService.php:1276
      • app/Http/Controllers/FranchiseDirectoryController.php:905
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • BusinessListingService.php#1488hattch2022prod5.95msselect 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(-32.00385)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(115.94735)) + sin(radians(-32.00385)) * 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 <= 50) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 50
      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#1488hattch2022prod5.96msselect 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(-32.00385)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(115.94735)) + sin(radians(-32.00385)) * 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 <= 50 order by `distance_km` asc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 50
      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.97msselect * from `brands` where `brands`.`id` in (7017941, 7017948, 7017949, 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.97msselect * from `homepages` where `homepages`.`brand_id` in (7017941, 7017948, 7017949, 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.34msselect * 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.61msselect * from `post_codes` where `post_codes`.`id` in (12524, 12528, 12533, 12539, 12668, 12670, 12680, 12741, 12756, 12992, 13160, 13163, 13171, 13173, 13175, 13179, 13278, 13380, 13469, 13541, 13588, 13591, 13643, 13648, 13715, 13731, 13735, 13751, 13755, 13778, 13844, 13881)
      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#1264hattch2022prod4.95msselect * from `brands` where `id` in (7017973, 7017949, 7017948, 7017941, 7017960)
      Bindings
      • 0: 7017973
      • 1: 7017949
      • 2: 7017948
      • 3: 7017941
      • 4: 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.86msselect * from `post_codes` where `id` in (12680, 12670, 13715, 13175, 12539, 12668, 13591, 13588, 12533, 12524, 13179, 13380, 13844, 12528, 13755, 13541, 13469, 12741, 13778, 12756, 13731, 12992, 13735, 13173, 13751, 13171, 13163, 13278, 13160, 13648, 13881, 13643)
      Bindings
      • 0: 12680
      • 1: 12670
      • 2: 13715
      • 3: 13175
      • 4: 12539
      • 5: 12668
      • 6: 13591
      • 7: 13588
      • 8: 12533
      • 9: 12524
      • 10: 13179
      • 11: 13380
      • 12: 13844
      • 13: 12528
      • 14: 13755
      • 15: 13541
      • 16: 13469
      • 17: 12741
      • 18: 13778
      • 19: 12756
      • 20: 13731
      • 21: 12992
      • 22: 13735
      • 23: 13173
      • 24: 13751
      • 25: 13171
      • 26: 13163
      • 27: 13278
      • 28: 13160
      • 29: 13648
      • 30: 13881
      • 31: 13643
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:1270
      • app/Http/Controllers/FranchiseDirectoryController.php:1097
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#1277hattch2022prod5.86msselect * 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.68msselect * 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.7msselect * from `survey_questions` where `brand_id` in (7017973, 7017949, 7017948, 7017941, 7017960) and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017973
      • 1: 7017949
      • 2: 7017948
      • 3: 7017941
      • 4: 7017960
      • 5: 1
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:1295
      • app/Http/Controllers/FranchiseDirectoryController.php:1097
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#1301hattch2022prod4.16msselect * from `homepages` where `brand_id` in (7017973, 7017949, 7017948, 7017941, 7017960)
      Bindings
      • 0: 7017973
      • 1: 7017949
      • 2: 7017948
      • 3: 7017941
      • 4: 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.57msselect `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.41msselect `postcode` from `post_codes` where `postcode` = '6107' limit 10
      Bindings
      • 0: 6107
      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.71msselect * from `post_codes` where `postcode` in ('6107', 6107, 6107, 6107, 6107, 6107, 6107, 6107)
      Bindings
      • 0: 6107
      • 1: 6107
      • 2: 6107
      • 3: 6107
      • 4: 6107
      • 5: 6107
      • 6: 6107
      • 7: 6107
      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#60hattch2022prod5.38msselect * from `post_codes` where `id` = 12679 limit 1
      Bindings
      • 0: 12679
      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.61msselect * 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.52msselect * 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.48msselect * from `post_codes` where `id` = 12679 limit 1
      Bindings
      • 0: 12679
      Backtrace
      • view::brand.common.frontpage-layout:383
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • frontpage-layout.blade.php#416hattch2022prod2.58msselect * from `industries` where `industry_slug` = '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.71msselect * from `post_codes` where `id` = 12679 limit 1
      Bindings
      • 0: 12679
      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.6msSELECT minimum_investment from `brands` GROUP BY minimum_investment ORDER BY minimum_investment ASC;
      Backtrace
      • view::pages.home.partials.header-filters:99
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • header-filters.blade.php#118hattch2022prod2.55msSELECT maximum_investment from `brands` GROUP BY maximum_investment ORDER BY maximum_investment ASC;
      Backtrace
      • view::pages.home.partials.header-filters:118
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • header-filters.blade.php#172hattch2022prod11.19msselect * 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
    451Listing.php#?
    App\Models\PostCode
    316PostCode.php#?
    App\Models\Brand
    49Brand.php#?
    App\Models\Homepage
    49Homepage.php#?
    App\Models\Industry
    24Industry.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-07-03 18:38:01GET/businesses-for-sale/within-cafe-food-beverage/in-queens-park-wa-6107?distance=50482356889