36 Cafe, Food & Beverage businesses for sale in Lilyfield NSW 2040

San Churro: Leichhardt

(more)

Total Investment: From $300K

Business Type: New Franchise

San Churro: Ultimo

Ultimo, NSW 2007 3.8 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Jamaica Blue: Ashfield Mall

(more)

Total Investment: From $300K

Business Type: New Franchise

Muffin Break: Ashfield Mall

(more)

Total Investment: From $200K

Business Type: New Franchise

San Churro: Haymarket

(more)

Total Investment: From $300K

Business Type: New Franchise

Muffin Break: Marrickville Metro

(more)

Total Investment: From $200K

Business Type: New Franchise

San Churro: Burwood

(more)

Total Investment: From $300K

Business Type: New Franchise

San Churro: Moore Park

(more)

Total Investment: From $300K

Business Type: New Franchise

San Churro: Paddington

(more)

Total Investment: From $300K

Business Type: New Franchise

San Churro: Crows Nest

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

San Churro: Strathfield

(more)

Total Investment: From $300K

Business Type: New Franchise

San Churro: Rhodes

Rhodes, NSW 2138 8.6 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

San Churro: Ryde

Ryde, NSW 2112 8.8 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

San Churro: Bondi Junction

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

Jamaica Blue: Westfield Bondi Junction

(more)

Total Investment: From $100K

Business Type: Franchise Resale

Muffin Break: Westfield Eastgardens

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

San Churro: Coogee

Coogee, NSW 2034 10.9 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

San Churro: Bondi Beach

(more)

Total Investment: From $300K

Business Type: New Franchise

Muffin Break: Macquarie Park

(more)

Total Investment: From $200K

Business Type: New Franchise

San Churro: Macquarie Park

(more)

Total Investment: From $300K

Business Type: New Franchise

San Churro: Maroubra

(more)

Total Investment: From $300K

Business Type: New Franchise

Muffin Break: Maroubra

(more)

Total Investment: From $200K

Business Type: New Franchise

San Churro: Hurstville

(more)

Total Investment: From $300K

Business Type: New Franchise

Muffin Break: Broadway Plaza

(more)

Total Investment: From $200K

Business Type: New Franchise

Liv Eat: Balgowlah

(more)

Total Investment: From $100K

Business Type: New Franchise

San Churro: Manly Beach

Manly, NSW 2095 15.0 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Milky Lane: Manly

Manly, NSW 2095 15.0 km away

Milky Lane brings its iconic burger and cocktail culture to the vibrant beachside suburb of Manly, offering a rare opportunity to own a piece of Australia's most talked-about food...(more)

Total Investment: From $500K

Business Type: New Franchise

Muffin Break: Westfield Parramatta

(more)

Total Investment: From $200K

Business Type: New Franchise

San Churro: Parramatta

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

Degani Bakery Cafe: Warringah

(more)

Total Investment: From $300K

Business Type: New Franchise

Muffin Break: Westfield Warringah Mall

(more)

Total Investment: From $200K

Business Type: New Franchise

San Churro: Brookvale

(more)

Total Investment: From $300K

Business Type: New Franchise

Degani Bakery Cafe: Merrylands

(more)

Total Investment: From $400K

Business Type: New Franchise

San Churro: Merrylands

(more)

Total Investment: From $300K

Business Type: New Franchise

Liv Eat: Westmead

(more)

Total Investment: From $200K

Business Type: New Franchise

San Churro: Dee Why

Dee Why, NSW 2099 19.0 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

Want to see more listings?

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

SettingsRequest history382msRequest 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-lilyfield-nsw-2...
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:37:57] LOG.info: ValidateBusinessListingUrl processing request { "path": "businesses-for-sal...
  • infolog[18:37:57] LOG.info: Route has location parameter, passing through { "location": "lilyfield-nsw-...
  • infolog[18:37:57] LOG.info: Processing single location parameter { "location": "lilyfield-nsw-2040", ...
  • infolog[18:37:57] LOG.info: Successfully parsed location parameter { "location": "lilyfield-nsw-2040", ...
  • infolog[18:37:57] LOG.info: Cookie debugging in FranchiseDirectoryController { "path": "businesses-for-...
  • infolog[18:37:57] LOG.info: Parameters received: { "industry": "cafe-food-beverage", "franchiseType...
  • infolog[18:37:57] LOG.info: User is not authenticated on filtered listings page { "host": "directory.te...
  • infolog[18:37:57] LOG.info: Populated filter arrays from parsed location { "suburb": "lilyfield", "...
  • infolog[18:37:57] LOG.info: Starting getFilteredListings with filters: { "locations": [], "business...
  • infolog[18:37:57] LOG.info: Applying industry filter: { "industry": "cafe-food-beverage" }
  • infolog[18:37:57] LOG.info: Using single known industry: { "industry": "cafe-food-beverage" }
  • infolog[18:37:57] LOG.info: Applying location filters: { "suburb": [ "lilyfield" ], "st...
  • infolog[18:37:57] LOG.info: Using postcodes for filtering: { "postcodes": [ "2040" ] }
  • infolog[18:37:57] LOG.info: Including nearby postcodes: { "count": 76, "postcodes": [ 2040,...
  • infolog[18:37:57] LOG.info: Adding distance_km to select for sorting by distance
  • debuglog[18:37:57] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.*, `brands`.`id` as ...
  • infolog[18:37:57] LOG.info: Successfully retrieved listings { "total": 16, "per_page": 36, "cur...
  • infolog[18:37:57] LOG.info: Listings retrieved: { "count": 15, "total": 16 }
  • infolog[18:37:57] LOG.info: Brand IDs found: { "ids": { "0": 7017941, "2": 7017948, ...
  • infolog[18:37:57] LOG.info: Retrieved postcode record for brand filters: { "postcode": "2040", "has...
  • infolog[18:37:57] LOG.info: Adding coordinates to brand filters for distance search: { "lat": "-33.8814...
  • infolog[18:37:57] LOG.info: Setting distance parameter for brands: { "max_distance": 20 }
  • infolog[18:37:57] LOG.info: Local brand count check (exact postcode): { "postcode": "2040", "localB...
  • infolog[18:37:57] LOG.info: Starting getFilteredBrands with filters: { "locations": [], "businessTy...
  • infolog[18:37:57] LOG.info: Applying industry filter: { "industry": "cafe-food-beverage" }
  • infolog[18:37:57] LOG.info: Using single known industry: { "industry": "cafe-food-beverage" }
  • infolog[18:37:57] LOG.info: Using coordinates for distance-based search: { "lat": -33.88143, "lng":...
  • debuglog[18:37:57] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:37:57] LOG.info: Successfully retrieved brands { "total": 6, "per_page": 36, "curren...
  • infolog[18:37:57] LOG.info: Postcode found: { "id": 2388, "suburb": "Lilyfield" }
  • infolog[18:37:57] LOG.info: Final postcodeArray before passing to view: { "postcodeArray": [ { ...
  • infolog[18:37:57] LOG.info: Starting getDefaultListings without filters
  • debuglog[18:37:57] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.* from `listings` in...
  • infolog[18:37:57] LOG.info: Successfully retrieved listings { "total": 2552, "per_page": 36, "c...
  • infolog[18:37:57] LOG.info: Starting getDefaultBrands without filters
  • debuglog[18:37:57] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:37:57] LOG.info: Successfully retrieved listings { "total": 42, "per_page": 36, "cur...
  • infolog[18:37:57] LOG.info: Exact location listing count { "suburb": "lilyfield", "state": "NSW", ...
  • infolog[18:37:57] LOG.info: Starting getNearbyListings with filters: { "locations": [], "businessTy...
  • infolog[18:37:57] LOG.info: Applying industry filter: { "industry": "cafe-food-beverage" }
  • infolog[18:37:57] LOG.info: Using where for single industry { "industry": "cafe-food-beverage" }
  • debuglog[18:37:57] LOG.debug: Final SQL query for nearby listings: { "sql": "select distinct `listings`....
  • infolog[18:37:57] LOG.info: Successfully retrieved nearby listings { "total": 36, "per_page": 36, ...
  • infolog[18:37:57] LOG.info: Display flags: { "hasExactLocationSearch": true, "originalBrandCount": ...
  • infolog[18:37:57] LOG.info: Getting industry IDs from slug { "slug": "cafe-food-beverage" }
  • infolog[18:37:57] LOG.info: Found industry from direct lookup { "slug": "cafe-food-beverage", "id":...
  • infolog[18:37:57] LOG.info: Final industry IDs from slug { "slug": "cafe-food-beverage", "ids": [ ...
  • infolog[18:37:57] LOG.info: View data prepared successfully
status
200 OK
full_url
http://directory.testing.hattch.net/businesses-for-sale/within-cafe-food-beverage/in-lilyfield-nsw-2...
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
384ms
peak_memory
10MB
response
text/html; charset=UTF-8
request_format
html
request_query
0 of 0
array:1 [ "distance" => "20" ]
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-68664165-362c6b6b35dea69925ef64eb" ] "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:37:57 GMT" ] ]
session_attributes
0 of 0
array:1 [ "_token" => "n91a6i2yM5FvzvmuWAw9GjoYQAwUDqndAQ7n8bjj" ]
  • Booting (16.85ms)time
  • Application (365ms)time
  • Routing (1.88ms)
  • View: pages.home.brandviews
  • View: pages.home.breadcrumbviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.summaryviews
  • View: pages.home.partials.lazy-load-scriptviews
  • View: brand.common.frontpage-layoutviews
  • View: brand.common.tracking-codesviews
  • View: pages.home.universal-headerviews
  • View: pages.home.partials.header-filtersviews
  • View: pages.home.skeleton-loadersviews
  • View: pages.home.profile_slider_menuviews
  • View: pages.home.partials._main_optionsviews
  • View: pages.home.partials._account_detailsviews
  • View: pages.home.partials._franchise_compatibilityviews
  • View: pages.home.partials._enquiries_invitationsviews
  • View: pages.home.partials._investment_calculatorviews
  • View: pages.home.partials._notification_settingsviews
  • View: pages.home.partials._securityviews
  • View: pages.widget.summaryviews
  • View: layouts.common.footerviews
  • View: partials.welcome-collection-modalviews
  • 1 x Application (95.59%)
    365ms
    1 x Booting (4.41%)
    16.85ms
    1 x Routing (0.49%)
    1.88ms
    24 x View (0%)
    0μs
    24 templates were rendered
    • pages.home.brandbrand.blade.php#?blade
    • pages.home.breadcrumbbreadcrumb.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.brand_survey_bannerbrand_survey_banner.blade.php#?blade
    • pages.widget.summarysummary.blade.php#?blade
    • pages.home.partials.lazy-load-scriptlazy-load-script.blade.php#?blade
    • brand.common.frontpage-layoutfrontpage-layout.blade.php#?blade
    • brand.common.tracking-codestracking-codes.blade.php#?blade
    • pages.home.universal-headeruniversal-header.blade.php#?blade
    • pages.home.partials.header-filtersheader-filters.blade.php#?blade
    • pages.home.skeleton-loadersskeleton-loaders.blade.php#?blade
    • pages.home.profile_slider_menuprofile_slider_menu.blade.php#?blade
    • pages.home.partials._main_options_main_options.blade.php#?blade
    • pages.home.partials._account_details_account_details.blade.php#?blade
    • pages.home.partials._franchise_compatibility_franchise_compatibility.blade.php#?blade
    • pages.home.partials._enquiries_invitations_enquiries_invitations.blade.php#?blade
    • pages.home.partials._investment_calculator_investment_calculator.blade.php#?blade
    • pages.home.partials._notification_settings_notification_settings.blade.php#?blade
    • pages.home.partials._security_security.blade.php#?blade
    • pages.widget.summarysummary.blade.php#?blade
    • layouts.common.footerfooter.blade.php#?blade
    • partials.welcome-collection-modalwelcome-collection-modal.blade.php#?blade
    56 statements were executed (15 duplicates)Show only duplicates277ms
    • FranchiseDirectoryController.php#328hattch2022prodConnection Established
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:328
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FranchiseDirectoryController.php#328hattch2022prod14.88msselect exists(select * from `industries` where `industry_slug` = 'cafe-food-beverage' and `industries`.`deleted_at` is null) as `exists`
      Bindings
      • 0: cafe-food-beverage
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:328
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FranchiseDirectoryController.php#333hattch2022prod2.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: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#34hattch2022prod3.07msselect `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.47msselect `to_postcode` from `distances` where `from_postcode` in ('2040') order by `distance_km` asc
      Bindings
      • 0: 2040
      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#446hattch2022prod13.67msselect 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 ('2040') 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 (2040, 2040, 2039, 2038, 2047, 2046, 2009, 2045, 2048, 2037, 2049, 2050, 2007, 2042, 2041, 2130, 2131, 2008, 2110, 2000, 2132, 2204, 2203, 2193, 2016, 2015, 2043, 2061, 2111, 2137, 2136, 2134, 2060, 2044, 2017, 2010, 2206, 2205, 2011, 2064, 2089, 2133, 2021, 2207, 2194, 2033, 2191, 2140, 2138, 2018, 2135, 2028, 2062, 2025, 2065, 2090, 2066, 2067, 2216, 2032, 2063, 2192, 2023, 2027, 2020, 2022, 2190, 2141, 2088, 2195, 2019, 2112, 2029, 2127, 2208, '2040')
      Bindings
      • 0: 2040
      • 1: open
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 2040
      • 6: 2040
      • 7: 2039
      • 8: 2038
      • 9: 2047
      • 10: 2046
      • 11: 2009
      • 12: 2045
      • 13: 2048
      • 14: 2037
      • 15: 2049
      • 16: 2050
      • 17: 2007
      • 18: 2042
      • 19: 2041
      • 20: 2130
      • 21: 2131
      • 22: 2008
      • 23: 2110
      • 24: 2000
      • 25: 2132
      • 26: 2204
      • 27: 2203
      • 28: 2193
      • 29: 2016
      • 30: 2015
      • 31: 2043
      • 32: 2061
      • 33: 2111
      • 34: 2137
      • 35: 2136
      • 36: 2134
      • 37: 2060
      • 38: 2044
      • 39: 2017
      • 40: 2010
      • 41: 2206
      • 42: 2205
      • 43: 2011
      • 44: 2064
      • 45: 2089
      • 46: 2133
      • 47: 2021
      • 48: 2207
      • 49: 2194
      • 50: 2033
      • 51: 2191
      • 52: 2140
      • 53: 2138
      • 54: 2018
      • 55: 2135
      • 56: 2028
      • 57: 2062
      • 58: 2025
      • 59: 2065
      • 60: 2090
      • 61: 2066
      • 62: 2067
      • 63: 2216
      • 64: 2032
      • 65: 2063
      • 66: 2192
      • 67: 2023
      • 68: 2027
      • 69: 2020
      • 70: 2022
      • 71: 2190
      • 72: 2141
      • 73: 2088
      • 74: 2195
      • 75: 2019
      • 76: 2112
      • 77: 2029
      • 78: 2127
      • 79: 2208
      • 80: 2040
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#446hattch2022prod6.38msselect 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 ('2040') 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 (2040, 2040, 2039, 2038, 2047, 2046, 2009, 2045, 2048, 2037, 2049, 2050, 2007, 2042, 2041, 2130, 2131, 2008, 2110, 2000, 2132, 2204, 2203, 2193, 2016, 2015, 2043, 2061, 2111, 2137, 2136, 2134, 2060, 2044, 2017, 2010, 2206, 2205, 2011, 2064, 2089, 2133, 2021, 2207, 2194, 2033, 2191, 2140, 2138, 2018, 2135, 2028, 2062, 2025, 2065, 2090, 2066, 2067, 2216, 2032, 2063, 2192, 2023, 2027, 2020, 2022, 2190, 2141, 2088, 2195, 2019, 2112, 2029, 2127, 2208, '2040') order by CASE WHEN post_codes.postcode IN ('2040') THEN 0 ELSE 1 END, `distances`.`distance_km` asc, `post_codes`.`postcode` asc limit 36 offset 0
      Bindings
      • 0: 2040
      • 1: open
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 2040
      • 6: 2040
      • 7: 2039
      • 8: 2038
      • 9: 2047
      • 10: 2046
      • 11: 2009
      • 12: 2045
      • 13: 2048
      • 14: 2037
      • 15: 2049
      • 16: 2050
      • 17: 2007
      • 18: 2042
      • 19: 2041
      • 20: 2130
      • 21: 2131
      • 22: 2008
      • 23: 2110
      • 24: 2000
      • 25: 2132
      • 26: 2204
      • 27: 2203
      • 28: 2193
      • 29: 2016
      • 30: 2015
      • 31: 2043
      • 32: 2061
      • 33: 2111
      • 34: 2137
      • 35: 2136
      • 36: 2134
      • 37: 2060
      • 38: 2044
      • 39: 2017
      • 40: 2010
      • 41: 2206
      • 42: 2205
      • 43: 2011
      • 44: 2064
      • 45: 2089
      • 46: 2133
      • 47: 2021
      • 48: 2207
      • 49: 2194
      • 50: 2033
      • 51: 2191
      • 52: 2140
      • 53: 2138
      • 54: 2018
      • 55: 2135
      • 56: 2028
      • 57: 2062
      • 58: 2025
      • 59: 2065
      • 60: 2090
      • 61: 2066
      • 62: 2067
      • 63: 2216
      • 64: 2032
      • 65: 2063
      • 66: 2192
      • 67: 2023
      • 68: 2027
      • 69: 2020
      • 70: 2022
      • 71: 2190
      • 72: 2141
      • 73: 2088
      • 74: 2195
      • 75: 2019
      • 76: 2112
      • 77: 2029
      • 78: 2127
      • 79: 2208
      • 80: 2040
      • 81: 2040
      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.57msselect * 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#446hattch2022prod4.86msselect * 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.37msselect * from `industries` where `industries`.`id` in (1) and `industries`.`deleted_at` is null
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#446hattch2022prod2.66msselect * from `post_codes` where `post_codes`.`id` in (41, 561, 563, 710, 2387, 2637, 2927, 3180, 3484, 3494, 3495, 3505, 4038)
      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.42msselect * from `post_codes` where `postcode` = '2040' limit 1
      Bindings
      • 0: 2040
      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#721hattch2022prod6.46msselect `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.21msselect 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` = '2040' and (`brands`.`industry_id` = 1 or `brands`.`secondary_industry_id` = 1)
      Bindings
      • 0: open
      • 1: 1
      • 2: 2040
      • 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.85msselect `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.3msselect 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.88143)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(151.15595)) + sin(radians(-33.88143)) * 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.88143)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(151.15595)) + sin(radians(-33.88143)) * sin(radians(post_codes.lat))))) <= 20) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 20
      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.22msselect distinct `brands`.`id`, `brands`.`id` as `brand_id`, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `brands`.`minimum_investment`, `brands`.`maximum_investment`, `brands`.`country_code`, `industries`.`industry`, `industries`.`industry_slug`, MIN(post_codes.suburb) as suburb, MIN(post_codes.state) as state, MIN(post_codes.postcode) as postcode, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_brand_logo")) as mobile_brand_logo, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_listing_image")) as mobile_listing_image, JSON_UNQUOTE(JSON_EXTRACT(homepages.section2, "$.business_intro_subtext")) as business_intro_subtext, MIN((6751 * acos(cos(radians(-33.88143)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(151.15595)) + sin(radians(-33.88143)) * 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.88143)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(151.15595)) + sin(radians(-33.88143)) * sin(radians(post_codes.lat))))) <= 20 order by MIN((6751 * acos(cos(radians(-33.88143)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(151.15595)) + sin(radians(-33.88143)) * sin(radians(post_codes.lat))))) asc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 20
      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#1053hattch2022prod5.08msselect * 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#1053hattch2022prod2.21msselect * 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#1053hattch2022prod4.71msselect * 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#1053hattch2022prod4.28msselect * 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#783hattch2022prod2.78msselect * from `post_codes` where `suburb` in ('Lilyfield') and `state` = 'NSW' and `postcode` = '2040' limit 1
      Bindings
      • 0: Lilyfield
      • 1: NSW
      • 2: 2040
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:783
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • BusinessListingService.php#498hattch2022prod11.16msselect count(*) as aggregate from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null)
      Bindings
      • 0: open
      • 1: 1
      Backtrace
      • app/Services/BusinessListingService.php:498
      • app/Http/Controllers/FranchiseDirectoryController.php:810
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#498hattch2022prod29.8msselect distinct `listings`.* from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) order by `post_codes`.`postcode` asc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      Backtrace
      • app/Services/BusinessListingService.php:498
      • app/Http/Controllers/FranchiseDirectoryController.php:810
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#615hattch2022prod18.84msselect count(*) as aggregate from (select distinct `brands`.`id`, `brands`.`id` as `brand_id`, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `brands`.`minimum_investment`, `brands`.`maximum_investment`, `brands`.`country_code`, `industries`.`industry`, `industries`.`industry_slug`, MIN(post_codes.suburb) as suburb, MIN(post_codes.state) as state, MIN(post_codes.postcode) as postcode, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_brand_logo")) as mobile_brand_logo, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_listing_image")) as mobile_listing_image, JSON_UNQUOTE(JSON_EXTRACT(homepages.section2, "$.business_intro_subtext")) as business_intro_subtext from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) group by `brands`.`id`) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      Backtrace
      • app/Services/BusinessListingService.php:615
      • app/Http/Controllers/FranchiseDirectoryController.php:811
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#615hattch2022prod19.67msselect 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.16msselect * from `brands` where `brands`.`id` in (7017918, 7017929, 7017930, 7017931, 7017932, 7017934, 7017937, 7017940, 7017941, 7017943, 7017944, 7017945, 7017946, 7017947, 7017948, 7017949, 7017950, 7017951, 7017953, 7017956, 7017959, 7017960, 7017962, 7017963, 7017964, 7017965, 7017967, 7017968, 7017969, 7017970, 7017971, 7017972, 7017973, 7017978, 7017981, 7017984)
      Backtrace
      • app/Services/BusinessListingService.php:615
      • app/Http/Controllers/FranchiseDirectoryController.php:811
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#615hattch2022prod7.13msselect * from `homepages` where `homepages`.`brand_id` in (7017918, 7017929, 7017930, 7017931, 7017932, 7017934, 7017937, 7017940, 7017941, 7017943, 7017944, 7017945, 7017946, 7017947, 7017948, 7017949, 7017950, 7017951, 7017953, 7017956, 7017959, 7017960, 7017962, 7017963, 7017964, 7017965, 7017967, 7017968, 7017969, 7017970, 7017971, 7017972, 7017973, 7017978, 7017981, 7017984)
      Backtrace
      • app/Services/BusinessListingService.php:615
      • app/Http/Controllers/FranchiseDirectoryController.php:811
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#615hattch2022prod2.46msselect * 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.35msselect * 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.48msselect `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.78msselect 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` = '2040' and `post_codes`.`state` = 'NSW' and `post_codes`.`suburb` in ('Lilyfield') and `listings`.`status` = 'open' and (`brands`.`industry_id` = 1 or `brands`.`secondary_industry_id` = 1)
      Bindings
      • 0: 2040
      • 1: NSW
      • 2: Lilyfield
      • 3: open
      • 4: 1
      • 5: 1
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:870
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • BusinessListingService.php#34hattch2022prod2.4msselect `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.74msselect 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.87113)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(151.16107)) + sin(radians(-33.87113)) * 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 <= 20) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 20
      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.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.87113)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(151.16107)) + sin(radians(-33.87113)) * 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 <= 20 order by `distance_km` asc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 20
      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.64msselect * 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#1488hattch2022prod3.32msselect * 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.38msselect * 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 (41, 108, 543, 561, 563, 710, 1953, 1956, 1964, 2009, 2387, 2631, 2634, 2637, 2927, 3148, 3157, 3180, 3187, 3484, 3494, 3495, 3505, 3989, 3991, 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.65msselect * from `brands` where `id` in (7017941, 7017949, 7017948, 7017960, 7017934, 7017945)
      Bindings
      • 0: 7017941
      • 1: 7017949
      • 2: 7017948
      • 3: 7017960
      • 4: 7017934
      • 5: 7017945
      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.79msselect * from `post_codes` where `id` in (2387, 3505, 41, 3484, 2637, 561, 3494, 3495, 2927, 563, 710, 3180, 4038, 543, 3157, 4039, 3187, 3148, 2009, 108, 2631, 2634, 1964, 3989, 1956, 1953, 3991)
      Bindings
      • 0: 2387
      • 1: 3505
      • 2: 41
      • 3: 3484
      • 4: 2637
      • 5: 561
      • 6: 3494
      • 7: 3495
      • 8: 2927
      • 9: 563
      • 10: 710
      • 11: 3180
      • 12: 4038
      • 13: 543
      • 14: 3157
      • 15: 4039
      • 16: 3187
      • 17: 3148
      • 18: 2009
      • 19: 108
      • 20: 2631
      • 21: 2634
      • 22: 1964
      • 23: 3989
      • 24: 1956
      • 25: 1953
      • 26: 3991
      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.5msselect * 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.4msselect * 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.53msselect * from `survey_questions` where `brand_id` in (7017941, 7017949, 7017948, 7017960, 7017934, 7017945) and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017941
      • 1: 7017949
      • 2: 7017948
      • 3: 7017960
      • 4: 7017934
      • 5: 7017945
      • 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#1301hattch2022prod3.26msselect * from `homepages` where `brand_id` in (7017941, 7017949, 7017948, 7017960, 7017934, 7017945)
      Bindings
      • 0: 7017941
      • 1: 7017949
      • 2: 7017948
      • 3: 7017960
      • 4: 7017934
      • 5: 7017945
      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.4msselect `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.42msselect `postcode` from `post_codes` where `postcode` = '2040' limit 10
      Bindings
      • 0: 2040
      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.52msselect * from `post_codes` where `postcode` in ('2040', 2040, 2040)
      Bindings
      • 0: 2040
      • 1: 2040
      • 2: 2040
      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.47msselect * from `post_codes` where `id` = 2388 limit 1
      Bindings
      • 0: 2388
      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.44msselect * 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.3msselect * 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.3msselect * from `post_codes` where `id` = 2388 limit 1
      Bindings
      • 0: 2388
      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.35msselect * 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.46msselect * from `post_codes` where `id` = 2388 limit 1
      Bindings
      • 0: 2388
      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.77msSELECT 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.44msSELECT maximum_investment from `brands` GROUP BY maximum_investment ORDER BY maximum_investment ASC;
      Backtrace
      • view::pages.home.partials.header-filters:118
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • header-filters.blade.php#172hattch2022prod2.35msselect * 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
    466Listing.php#?
    App\Models\PostCode
    310PostCode.php#?
    App\Models\Brand
    51Brand.php#?
    App\Models\Homepage
    51Homepage.php#?
    App\Models\Industry
    24Industry.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-07-03 18:37:57GET/businesses-for-sale/within-cafe-food-beverage/in-lilyfield-nsw-2040?distance=20482456902