business for sale hattch logo mobile

Selected Location

North Strathfield (2137)
From
To
×

64 Cafe, Food & Beverage businesses for sale in North Strathfield NSW 2137

Target Icon
Which franchises are thebest match for you?

64 businesses for sale

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

San Churro: Strathfield

Strathfield, NSW 2135 2.6 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

San Churro: Burwood

Burwood, NSW 2134 2.8 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

San Churro: Rhodes

Rhodes, NSW 2138 3.3 km away

Indulge in the opportunity to bring San Churro's authentic Spanish chocolate experience to Rhodes, NSW, a vibrant waterfront suburb experiencing significant residential and commerc...(more)

Total Investment: From $300K

Business Type: New Franchise

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

Jamaica Blue: Ashfield Mall

Ashfield, NSW 2131 5.3 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Muffin Break: Ashfield Mall

Ashfield, NSW 2131 5.3 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

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

San Churro: Ryde

Ryde, NSW 2112 6.4 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

San Churro: Leichhardt

Leichhardt, NSW 2040 7.1 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Muffin Break: Broadway Plaza

Punchbowl, NSW 2196 9.1 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

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

Muffin Break: Marrickville Metro

Marrickville, NSW 2204 9.2 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

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

Muffin Break: Westfield Parramatta

Parramatta, NSW 2150 9.3 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

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

San Churro: Parramatta

Parramatta, NSW 2150 9.3 km away

Indulge in the opportunity to bring San Churro's authentic Spanish chocolate experience to the vibrant heart of Western Sydney. Parramatta's thriving commercial district, with its...(more)

Total Investment: From $300K

Business Type: New Franchise

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

San Churro: Macquarie Park

Macquarie Park, NSW 2113 10.0 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Muffin Break: Macquarie Park

Macquarie Park, NSW 2113 10.0 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

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

San Churro: Merrylands

Merrylands, NSW 2160 10.5 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Degani Bakery Cafe: Merrylands

Merrylands, NSW 2160 10.5 km away

(more)

Total Investment: From $400K

Business Type: New Franchise

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

San Churro: Ultimo

Ultimo, NSW 2007 11.0 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Liv Eat: Westmead

Westmead, NSW 2145 11.5 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

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

San Churro: Haymarket

Haymarket, NSW 2000 11.7 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

San Churro: Crows Nest

Crows Nest, NSW 2065 11.9 km away

Indulge in the opportunity to bring the authentic Spanish chocolate café experience to the vibrant community of Crows Nest, NSW. This bustling North Shore suburb offers a perfect b...(more)

Total Investment: From $300K

Business Type: New Franchise

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

San Churro: Hurstville

Hurstville, NSW 2220 12.4 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Jamaica Blue: Fairfield City Central

Fairfield, NSW 2165 13.5 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Muffin Break: Fairfield City Central

Fairfield, NSW 2165 13.5 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

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

San Churro: Moore Park

Moore Park, NSW 2021 13.8 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

San Churro: Paddington

Paddington, NSW 2021 13.9 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

San Churro: Bondi Junction

Bondi Junction, NSW 2022 16.3 km away

Indulge in the opportunity to bring San Churro's authentic Spanish chocolate experience to the vibrant heart of Bondi Junction, NSW. This premium retail location offers exceptional...(more)

Total Investment: From $300K

Business Type: New Franchise

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

Jamaica Blue: Westfield Bondi Junction

Bondi Junction, NSW 2022 16.3 km away

(more)

Total Investment: From $100K

Business Type: Franchise Resale

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

Muffin Break: Westfield Eastgardens

Eastgardens, NSW 2036 16.9 km away

Secure your future with Muffin Break in the thriving retail hub of Eastgardens, NSW. Located within Westfield Eastgardens, this franchise opportunity positions you in a major shopp...(more)

Total Investment: From $200K

Business Type: New Franchise

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

Muffin Break: Castle Towers

Castle Hill, NSW 2154 17.6 km away

Launch your business future with Muffin Break in Castle Hill, one of Sydney's fastest-growing commercial and residential hubs. Located in Sydney's thriving Hills District, Castle H...(more)

Total Investment: From $200K

Business Type: New Franchise

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

San Churro: Coogee

Coogee, NSW 2034 17.9 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

San Churro: Bondi Beach

Bondi Beach, NSW 2026 18.4 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Milky Lane: Liverpool

Liverpool, NSW 2170 18.4 km away

(more)

Total Investment: From $500K

Business Type: New Franchise

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

San Churro: Liverpool

Liverpool, NSW 2170 18.4 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Liv Eat: Balgowlah

Balgowlah, NSW 2093 18.5 km away

(more)

Total Investment: From $100K

Business Type: New Franchise

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

San Churro: Maroubra

Maroubra, NSW 2035 18.5 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Muffin Break: Maroubra

Maroubra, NSW 2035 18.5 km away

(more)

Total Investment: From $200K

Business Type: New Franchise

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

Degani Bakery Cafe: Wetherill Park

Wetherill Park, NSW 2164 18.7 km away

(more)

Total Investment: From $400K

Business Type: New Franchise

View
Messages50RequestTimelineExceptionsViews25Queries59Models914Livewire0MailsGate
SettingsRequest history552msRequest 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-north-strathfie...
action_name
directory.industry-location-search.single
controller_action
App\Http\Controllers\FranchiseDirectoryController@showFilteredListings
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
  • infolog[18:50:41] LOG.info: ValidateBusinessListingUrl processing request { "path": "businesses-for-sal...
  • infolog[18:50:41] LOG.info: Route has location parameter, passing through { "location": "north-strathfi...
  • infolog[18:50:41] LOG.info: Processing single location parameter { "location": "north-strathfield-nsw-2...
  • infolog[18:50:41] LOG.info: Successfully parsed location parameter { "location": "north-strathfield-nsw...
  • infolog[18:50:41] LOG.info: Cookie debugging in FranchiseDirectoryController { "path": "businesses-for-...
  • infolog[18:50:41] LOG.info: Parameters received: { "industry": "cafe-food-beverage", "franchiseType...
  • infolog[18:50:41] LOG.info: User is not authenticated on filtered listings page { "host": "directory.te...
  • infolog[18:50:41] LOG.info: Populated filter arrays from parsed location { "suburb": "north-strathfield...
  • infolog[18:50:41] LOG.info: Starting getFilteredListings with filters: { "locations": [], "business...
  • infolog[18:50:41] LOG.info: Applying industry filter: { "industry": "cafe-food-beverage" }
  • infolog[18:50:41] LOG.info: Using single known industry: { "industry": "cafe-food-beverage" }
  • infolog[18:50:41] LOG.info: Applying location filters: { "suburb": [ "north-strathfield" ],...
  • infolog[18:50:41] LOG.info: Using postcodes for filtering: { "postcodes": [ "2137" ] }
  • infolog[18:50:41] LOG.info: Including nearby postcodes: { "count": 66, "postcodes": [ 2137,...
  • infolog[18:50:41] LOG.info: Adding distance_km to select for sorting by distance
  • debuglog[18:50:41] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.*, `brands`.`id` as ...
  • infolog[18:50:41] LOG.info: Successfully retrieved listings { "total": 13, "per_page": 36, "cur...
  • infolog[18:50:41] LOG.info: Listings retrieved: { "count": 13, "total": 13 }
  • infolog[18:50:41] LOG.info: Caching filter options for 30 minutes
  • errorlog[18:50:41] LOG.error: Error getting filter options: file_put_contents(/var/app/current/storage/frame...
  • infolog[18:50:41] LOG.info: Brand IDs found: { "ids": { "0": 7017941, "4": 7017948, ...
  • infolog[18:50:41] LOG.info: Retrieved postcode record for brand filters: { "postcode": "2137", "has...
  • infolog[18:50:41] LOG.info: Adding coordinates to brand filters for distance search: { "lat": "-33.8578...
  • infolog[18:50:41] LOG.info: Setting distance parameter for brands: { "max_distance": 50 }
  • infolog[18:50:41] LOG.info: Local brand count check (exact postcode): { "postcode": "2137", "localB...
  • infolog[18:50:41] LOG.info: Starting getFilteredBrands with filters: { "locations": [], "businessTy...
  • infolog[18:50:41] LOG.info: Applying industry filter: { "industry": "cafe-food-beverage" }
  • infolog[18:50:41] LOG.info: Using single known industry: { "industry": "cafe-food-beverage" }
  • infolog[18:50:41] LOG.info: Using coordinates for distance-based search: { "lat": -33.85783, "lng":...
  • debuglog[18:50:41] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:50:41] LOG.info: Successfully retrieved brands { "total": 6, "per_page": 36, "curren...
  • infolog[18:50:41] LOG.info: Postcode found: { "id": 707, "suburb": "North Strathfield" }
  • infolog[18:50:41] LOG.info: Final postcodeArray before passing to view: { "postcodeArray": [ { ...
  • infolog[18:50:41] LOG.info: Starting getDefaultListings without filters
  • debuglog[18:50:41] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.* from `listings` in...
  • infolog[18:50:41] LOG.info: Successfully retrieved listings { "total": 2552, "per_page": 36, "c...
  • infolog[18:50:41] LOG.info: Starting getDefaultBrands without filters
  • debuglog[18:50:41] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:50:41] LOG.info: Successfully retrieved listings { "total": 42, "per_page": 36, "cur...
  • infolog[18:50:41] LOG.info: Exact location listing count { "suburb": "north-strathfield", "state": ...
  • infolog[18:50:41] LOG.info: Starting getNearbyListings with filters: { "locations": [], "businessTy...
  • infolog[18:50:41] LOG.info: Applying industry filter: { "industry": "cafe-food-beverage" }
  • infolog[18:50:41] LOG.info: Using where for single industry { "industry": "cafe-food-beverage" }
  • debuglog[18:50:41] LOG.debug: Final SQL query for nearby listings: { "sql": "select distinct `listings`....
  • infolog[18:50:41] LOG.info: Successfully retrieved nearby listings { "total": 64, "per_page": 36, ...
  • infolog[18:50:41] LOG.info: Display flags: { "hasExactLocationSearch": true, "originalBrandCount": ...
  • infolog[18:50:41] LOG.info: Getting industry IDs from slug { "slug": "cafe-food-beverage" }
  • infolog[18:50:41] LOG.info: Found industry from direct lookup { "slug": "cafe-food-beverage", "id":...
  • infolog[18:50:41] LOG.info: Final industry IDs from slug { "slug": "cafe-food-beverage", "ids": [ ...
  • infolog[18:50:41] LOG.info: View data prepared successfully
infodebugerror
status
200 OK
full_url
http://directory.testing.hattch.net/businesses-for-sale/within-cafe-food-beverage/in-north-strathfie...
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
554ms
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:12 [▼
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "via" => array:1 [▶
    0 => "1.1 squid-proxy-5b5d847c96-kml6h (squid/6.10)"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "x-amzn-trace-id" => array:1 [▶
    0 => "Root=1-68664461-6395900617cdd3270471cd6a"
  ]
  "host" => array:1 [▶
    0 => "directory.testing.hattch.net"
  ]
  "x-forwarded-port" => array:1 [▶
    0 => "80"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "http"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "10.1.3.136, 216.73.216.89"
  ]
]
request_cookies
[]
response_headers
  0 of 0   
array:3 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Thu, 03 Jul 2025 08:50:41 GMT"
  ]
]
session_attributes
  0 of 0   
array:1 [▼
  "_token" => "DrnEH68JXZq4V8eFx3q9u2bYBdJWYjNdxQpDNcoW"
]
  • Booting (28.21ms)time
  • Application (524ms)time
  • Routing (1.8ms)
  • View: pages.home.brandviews
  • View: pages.home.breadcrumbviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.dir_empty_resultsviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.summaryviews
  • View: pages.home.partials.lazy-load-scriptviews
  • View: brand.common.frontpage-layoutviews
  • View: brand.common.tracking-codesviews
  • View: pages.home.universal-headerviews
  • View: pages.home.partials.header-filtersviews
  • View: pages.home.skeleton-loadersviews
  • View: pages.home.profile_slider_menuviews
  • View: pages.home.partials._main_optionsviews
  • View: pages.home.partials._account_detailsviews
  • View: pages.home.partials._franchise_compatibilityviews
  • View: pages.home.partials._enquiries_invitationsviews
  • View: pages.home.partials._investment_calculatorviews
  • View: pages.home.partials._notification_settingsviews
  • View: pages.home.partials._securityviews
  • View: pages.widget.summaryviews
  • View: layouts.common.footerviews
  • View: partials.welcome-collection-modalviews
  • 1 x Application (94.89%)
    524ms
    1 x Booting (5.11%)
    28.21ms
    1 x Routing (0.33%)
    1.80ms
    25 x View (0%)
    0μs
    25 templates were rendered
    • pages.home.brandbrand.blade.php#?blade
    • pages.home.breadcrumbbreadcrumb.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.dir_empty_resultsdir_empty_results.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.summarysummary.blade.php#?blade
    • pages.home.partials.lazy-load-scriptlazy-load-script.blade.php#?blade
    • brand.common.frontpage-layoutfrontpage-layout.blade.php#?blade
    • brand.common.tracking-codestracking-codes.blade.php#?blade
    • pages.home.universal-headeruniversal-header.blade.php#?blade
    • pages.home.partials.header-filtersheader-filters.blade.php#?blade
    • pages.home.skeleton-loadersskeleton-loaders.blade.php#?blade
    • pages.home.profile_slider_menuprofile_slider_menu.blade.php#?blade
    • pages.home.partials._main_options_main_options.blade.php#?blade
    • pages.home.partials._account_details_account_details.blade.php#?blade
    • pages.home.partials._franchise_compatibility_franchise_compatibility.blade.php#?blade
    • pages.home.partials._enquiries_invitations_enquiries_invitations.blade.php#?blade
    • pages.home.partials._investment_calculator_investment_calculator.blade.php#?blade
    • pages.home.partials._notification_settings_notification_settings.blade.php#?blade
    • pages.home.partials._security_security.blade.php#?blade
    • pages.widget.summarysummary.blade.php#?blade
    • layouts.common.footerfooter.blade.php#?blade
    • partials.welcome-collection-modalwelcome-collection-modal.blade.php#?blade
    59 statements were executed (17 duplicates)Show only duplicates420ms
    • 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#328hattch2022prod17.02msselect 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.36msselect `id` from `industries` where `industry_slug` = 'cafe-food-beverage' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: cafe-food-beverage
      Backtrace
      • app/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.35msselect `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#267hattch2022prod3.27msselect `to_postcode` from `distances` where `from_postcode` in ('2137') order by `distance_km` asc
      Bindings
      • 0: 2137
      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.23msselect 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 ('2137') 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 (2137, 2137, 2111, 2138, 2046, 2127, 2047, 2134, 2132, 2112, 2140, 2045, 2131, 2135, 2136, 2114, 2110, 2040, 2039, 2193, 2130, 2128, 2115, 2038, 2066, 2141, 2133, 2067, 2041, 2048, 2203, 2122, 2049, 2190, 2117, 2116, 2191, 2113, 2009, 2037, 2064, 2204, 2007, 2194, 2142, 2144, 2000, 2065, 2042, 2060, 2050, 2206, 2121, 2008, 2195, 2015, 2192, 2043, 2143, 2061, 2062, 2063, 2072, 2089, 2118, '2137')
      Bindings
      • 0: 2137
      • 1: open
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 2137
      • 6: 2137
      • 7: 2111
      • 8: 2138
      • 9: 2046
      • 10: 2127
      • 11: 2047
      • 12: 2134
      • 13: 2132
      • 14: 2112
      • 15: 2140
      • 16: 2045
      • 17: 2131
      • 18: 2135
      • 19: 2136
      • 20: 2114
      • 21: 2110
      • 22: 2040
      • 23: 2039
      • 24: 2193
      • 25: 2130
      • 26: 2128
      • 27: 2115
      • 28: 2038
      • 29: 2066
      • 30: 2141
      • 31: 2133
      • 32: 2067
      • 33: 2041
      • 34: 2048
      • 35: 2203
      • 36: 2122
      • 37: 2049
      • 38: 2190
      • 39: 2117
      • 40: 2116
      • 41: 2191
      • 42: 2113
      • 43: 2009
      • 44: 2037
      • 45: 2064
      • 46: 2204
      • 47: 2007
      • 48: 2194
      • 49: 2142
      • 50: 2144
      • 51: 2000
      • 52: 2065
      • 53: 2042
      • 54: 2060
      • 55: 2050
      • 56: 2206
      • 57: 2121
      • 58: 2008
      • 59: 2195
      • 60: 2015
      • 61: 2192
      • 62: 2043
      • 63: 2143
      • 64: 2061
      • 65: 2062
      • 66: 2063
      • 67: 2072
      • 68: 2089
      • 69: 2118
      • 70: 2137
      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.72msselect 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 ('2137') 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 (2137, 2137, 2111, 2138, 2046, 2127, 2047, 2134, 2132, 2112, 2140, 2045, 2131, 2135, 2136, 2114, 2110, 2040, 2039, 2193, 2130, 2128, 2115, 2038, 2066, 2141, 2133, 2067, 2041, 2048, 2203, 2122, 2049, 2190, 2117, 2116, 2191, 2113, 2009, 2037, 2064, 2204, 2007, 2194, 2142, 2144, 2000, 2065, 2042, 2060, 2050, 2206, 2121, 2008, 2195, 2015, 2192, 2043, 2143, 2061, 2062, 2063, 2072, 2089, 2118, '2137') order by CASE WHEN post_codes.postcode IN ('2137') THEN 0 ELSE 1 END, `distances`.`distance_km` asc, `post_codes`.`postcode` asc limit 36 offset 0
      Bindings
      • 0: 2137
      • 1: open
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 2137
      • 6: 2137
      • 7: 2111
      • 8: 2138
      • 9: 2046
      • 10: 2127
      • 11: 2047
      • 12: 2134
      • 13: 2132
      • 14: 2112
      • 15: 2140
      • 16: 2045
      • 17: 2131
      • 18: 2135
      • 19: 2136
      • 20: 2114
      • 21: 2110
      • 22: 2040
      • 23: 2039
      • 24: 2193
      • 25: 2130
      • 26: 2128
      • 27: 2115
      • 28: 2038
      • 29: 2066
      • 30: 2141
      • 31: 2133
      • 32: 2067
      • 33: 2041
      • 34: 2048
      • 35: 2203
      • 36: 2122
      • 37: 2049
      • 38: 2190
      • 39: 2117
      • 40: 2116
      • 41: 2191
      • 42: 2113
      • 43: 2009
      • 44: 2037
      • 45: 2064
      • 46: 2204
      • 47: 2007
      • 48: 2194
      • 49: 2142
      • 50: 2144
      • 51: 2000
      • 52: 2065
      • 53: 2042
      • 54: 2060
      • 55: 2050
      • 56: 2206
      • 57: 2121
      • 58: 2008
      • 59: 2195
      • 60: 2015
      • 61: 2192
      • 62: 2043
      • 63: 2143
      • 64: 2061
      • 65: 2062
      • 66: 2063
      • 67: 2072
      • 68: 2089
      • 69: 2118
      • 70: 2137
      • 71: 2137
      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.64msselect * from `brands` where `brands`.`id` in (7017941, 7017948, 7017949)
      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.72msselect * from `homepages` where `homepages`.`brand_id` in (7017941, 7017948, 7017949)
      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.79msselect * 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.01msselect * from `post_codes` where `post_codes`.`id` in (41, 561, 563, 710, 2387, 2637, 2927, 3180, 3187, 3484, 3505)
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1094hattch2022prod2.44msselect * from `industries` where `industries`.`deleted_at` is null order by `industry` asc
      Backtrace
      • app/Services/BusinessListingService.php:1094
      • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • app/Services/BusinessListingService.php:1090
      • app/Http/Controllers/FranchiseDirectoryController.php:597
    • BusinessListingService.php#1095hattch2022prod5.72msselect * from `franchise_types` order by `type` asc
      Backtrace
      • app/Services/BusinessListingService.php:1095
      • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • app/Services/BusinessListingService.php:1090
      • app/Http/Controllers/FranchiseDirectoryController.php:597
    • BusinessListingService.php#1096hattch2022prod3.23msselect * from `categories` where `categories`.`deleted_at` is null order by `category` asc
      Backtrace
      • app/Services/BusinessListingService.php:1096
      • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • app/Services/BusinessListingService.php:1090
      • app/Http/Controllers/FranchiseDirectoryController.php:597
    • FranchiseDirectoryController.php#624hattch2022prod2.53msselect * from `post_codes` where `postcode` = '2137' limit 1
      Bindings
      • 0: 2137
      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#721hattch2022prod5.79msselect `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.81msselect 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` = '2137' and (`brands`.`industry_id` = 1 or `brands`.`secondary_industry_id` = 1)
      Bindings
      • 0: open
      • 1: 1
      • 2: 2137
      • 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#34hattch2022prod3.25msselect `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#1053hattch2022prod9.19msselect 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(-33.85783)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(151.08877)) + sin(radians(-33.85783)) * 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(-33.85783)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(151.08877)) + sin(radians(-33.85783)) * 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#1053hattch2022prod11.29msselect 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(-33.85783)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(151.08877)) + sin(radians(-33.85783)) * 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(-33.85783)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(151.08877)) + sin(radians(-33.85783)) * sin(radians(post_codes.lat))))) <= 50 order by MIN((6751 * acos(cos(radians(-33.85783)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(151.08877)) + sin(radians(-33.85783)) * 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.89msselect * from `homepages` where `homepages`.`brand_id` in (7017934, 7017941, 7017945, 7017948, 7017949, 7017960)
      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.25msselect * 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.05msselect * from `listings` where `listings`.`brand_id` in (7017934, 7017941, 7017945, 7017948, 7017949, 7017960)
      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.4msselect * 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, 3148, 3157, 3180, 3187, 3202, 3209, 3443, 3452, 3484, 3494, 3495, 3505, 3989, 3991, 4038, 4039, 4201, 4286, 4381, 4618, 4680, 4685, 4687, 4773, 4819, 4864, 4868, 4875, 4882, 4887, 4891, 5056, 5079, 5084, 5147, 5293, 5416, 5591, 5608, 5665, 5669, 5673, 5681, 5691, 5704, 5856, 5900, 5913, 5919, 5971, 5978, 6138, 6178, 6179, 6181, 6191, 6193, 6204, 6211, 6224, 6353, 6354, 6356, 6363, 6364, 6376, 6427, 6456, 6470, 6556, 6706, 6851, 6852, 6854, 7105, 7150, 7200, 7204, 7207, 7211, 7223, 7236, 7237, 7242, 7249, 7253, 7267, 7466, 7733, 7755, 7781, 7786, 7789, 7791, 7804, 7820, 7828, 7854, 7856, 7858, 7878, 7913, 7915, 8056, 8095, 8109, 8181, 8186, 8434, 8589, 8773, 8811, 8812, 8818, 8821, 8846, 8855, 8985, 8986, 9021, 9355, 9369, 9370, 9397, 9801, 9860, 9869, 9873, 9926, 9932, 9939, 9961, 10149, 10177, 10272, 10717, 10901, 10948, 10969, 11191, 11361, 11442, 11453, 11554, 11601, 11697, 11731, 11781, 11804, 11806, 11843, 11857, 11880, 11909, 11911, 11921, 12002, 12009, 12056, 12176, 12400, 12528, 12533, 12539, 12608, 12629, 12668, 12670, 12741, 12974, 12992, 13001, 13160, 13163, 13171, 13173, 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, 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#783hattch2022prod4.61msselect * from `post_codes` where `suburb` in ('North Strathfield', 'North-strathfield') and `state` = 'NSW' and `postcode` = '2137' limit 1
      Bindings
      • 0: North Strathfield
      • 1: North-strathfield
      • 2: NSW
      • 3: 2137
      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#498hattch2022prod23.36msselect 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#498hattch2022prod59.65msselect 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#615hattch2022prod32.79msselect 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#615hattch2022prod36.2msselect 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.28msselect * 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.19msselect * 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.31msselect * 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.37msselect * from `post_codes` where 0 = 1
      Backtrace
      • app/Services/BusinessListingService.php:615
      • app/Http/Controllers/FranchiseDirectoryController.php:811
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#856hattch2022prod3.08msselect `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.91msselect 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` = '2137' and `post_codes`.`state` = 'NSW' and `post_codes`.`suburb` in ('North Strathfield', 'North-strathfield') and `listings`.`status` = 'open' and (`brands`.`industry_id` = 1 or `brands`.`secondary_industry_id` = 1)
      Bindings
      • 0: 2137
      • 1: NSW
      • 2: North Strathfield
      • 3: North-strathfield
      • 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#34hattch2022prod3.47msselect `id` from `industries` where `industry_slug` = 'cafe-food-beverage' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: cafe-food-beverage
      Backtrace
      • app/Services/BusinessListingService.php:34
      • app/Services/BusinessListingService.php:1276
      • app/Http/Controllers/FranchiseDirectoryController.php:905
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • BusinessListingService.php#1488hattch2022prod6.87msselect 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(-33.85783)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(151.08877)) + sin(radians(-33.85783)) * 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#1488hattch2022prod7.71msselect 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(-33.85783)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(151.08877)) + sin(radians(-33.85783)) * 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.65msselect * from `brands` where `brands`.`id` in (7017934, 7017941, 7017945, 7017948, 7017949, 7017960)
      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.3msselect * from `homepages` where `homepages`.`brand_id` in (7017934, 7017941, 7017945, 7017948, 7017949, 7017960)
      Backtrace
      • app/Services/BusinessListingService.php:1488
      • app/Http/Controllers/FranchiseDirectoryController.php:905
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1488hattch2022prod2.49msselect * from `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.59msselect * from `post_codes` where `post_codes`.`id` in (41, 108, 208, 543, 561, 563, 710, 1288, 1304, 1953, 1956, 1964, 2009, 2387, 2517, 2631, 2637, 2927, 3148, 3157, 3180, 3187, 3484, 3494, 3495, 3505, 4038, 4039)
      Backtrace
      • app/Services/BusinessListingService.php:1488
      • app/Http/Controllers/FranchiseDirectoryController.php:905
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#1264hattch2022prod2.81msselect * from `brands` where `id` in (7017941, 7017949, 7017948, 7017945, 7017960, 7017934)
      Bindings
      • 0: 7017941
      • 1: 7017949
      • 2: 7017948
      • 3: 7017945
      • 4: 7017960
      • 5: 7017934
      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.71msselect * from `post_codes` where `id` in (563, 561, 710, 41, 3180, 2387, 108, 2637, 1964, 3187, 1956, 3505, 1953, 3484, 2927, 2009, 1288, 3494, 3495, 4038, 543, 208, 3157, 4039, 2517, 2631, 3148, 1304)
      Bindings
      • 0: 563
      • 1: 561
      • 2: 710
      • 3: 41
      • 4: 3180
      • 5: 2387
      • 6: 108
      • 7: 2637
      • 8: 1964
      • 9: 3187
      • 10: 1956
      • 11: 3505
      • 12: 1953
      • 13: 3484
      • 14: 2927
      • 15: 2009
      • 16: 1288
      • 17: 3494
      • 18: 3495
      • 19: 4038
      • 20: 543
      • 21: 208
      • 22: 3157
      • 23: 4039
      • 24: 2517
      • 25: 2631
      • 26: 3148
      • 27: 1304
      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.4msselect * 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.43msselect * 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 (7017941, 7017949, 7017948, 7017945, 7017960, 7017934) and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017941
      • 1: 7017949
      • 2: 7017948
      • 3: 7017945
      • 4: 7017960
      • 5: 7017934
      • 6: 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.3msselect * from `homepages` where `brand_id` in (7017941, 7017949, 7017948, 7017945, 7017960, 7017934)
      Bindings
      • 0: 7017941
      • 1: 7017949
      • 2: 7017948
      • 3: 7017945
      • 4: 7017960
      • 5: 7017934
      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.49msselect `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.46msselect `postcode` from `post_codes` where `postcode` = '2137' limit 10
      Bindings
      • 0: 2137
      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.61msselect * from `post_codes` where `postcode` in ('2137', 2137, 2137, 2137, 2137, 2137)
      Bindings
      • 0: 2137
      • 1: 2137
      • 2: 2137
      • 3: 2137
      • 4: 2137
      • 5: 2137
      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.77msselect * from `post_codes` where `id` = 707 limit 1
      Bindings
      • 0: 707
      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#257hattch2022prod4.04msselect * 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.6msselect * 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#383hattch2022prod3.58msselect * from `post_codes` where `id` = 707 limit 1
      Bindings
      • 0: 707
      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#50hattch2022prod3.44msselect * from `post_codes` where `id` = 707 limit 1
      Bindings
      • 0: 707
      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.53msSELECT 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#118hattch2022prod14.91msSELECT maximum_investment from `brands` GROUP BY maximum_investment ORDER BY maximum_investment ASC;
      Backtrace
      • view::pages.home.partials.header-filters:118
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • header-filters.blade.php#172hattch2022prod4.81msselect * 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
    464Listing.php#?
    App\Models\PostCode
    309PostCode.php#?
    App\Models\Brand
    51Brand.php#?
    App\Models\Homepage
    51Homepage.php#?
    App\Models\Industry
    32Industry.php#?
    App\Models\FranchiseType
    4FranchiseType.php#?
    App\Models\Category
    3Category.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-07-03 18:50:41GET/businesses-for-sale/within-cafe-food-beverage/in-north-strathfield-nsw-2137?distance=50502559914