business for sale hattch logo mobile

Selected Location

Gilles Plains (5086)
From
To
×

99 Retail or Convenience businesses for sale in Gilles Plains SA 5086

Target Icon
Which franchises are thebest match for you?

99 businesses for sale

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

Celebrity Ink: Firle

Firle, SA 5070 6.3 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Churchill

Kilburn, SA 5084 7.3 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Hollywood Plaza

Salisbury Downs, SA 5108 10.0 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Myer Centre

Adelaide, SA 5000 10.5 km away

Celebrity Ink presents a rare opportunity to own a premium tattoo studio in Adelaide, South Australia's vibrant cultural hub with its thriving arts scene and steady population grow...(more)

Total Investment: From $300K

Business Type: New Franchise

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

Carpet Court: Port Adelaide Carpet Court

Port Adelaide, SA 5015 14.5 km away

Carpet Court presents a rare opportunity to join Australia's largest flooring retailer in the historic maritime hub of Port Adelaide, SA. This vibrant waterfront precinct is experi...(more)

Total Investment: From $100K

Business Type: New Franchise

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

Celebrity Ink: Elizabeth

Elizabeth, SA 5112 15.6 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: West Lakes

West Lakes, SA 5021 16.2 km away

Celebrity Ink presents a rare opportunity to establish a premium tattoo studio in the thriving retail hub of West Lakes, South Australia. This coastal suburb offers an ideal demogr...(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Mitcham Square

Torrens Park, SA 5062 16.5 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Colonnades

Noarlunga Centre, SA 5168 37.6 km away

Become part of Celebrity Ink's expansion into Noarlunga Centre, SA, where the growing population and strategic location within Adelaide's southern retail hub presents an exceptiona...(more)

Total Investment: From $300K

Business Type: New Franchise

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

Carpet Court: Mildura Carpet Court

Mildura, VIC 3500 345.5 km away

(more)

Total Investment: From $100K

Business Type: New Franchise

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

Celebrity Ink: Bendigo

Bendigo, VIC 3550 581.9 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Ballarat

Ballarat Central, VIC 3350 587.5 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Woodgrove

Melton West, VIC 3337 649.6 km away

Begin your business ownership journey with Celebrity Ink in Melbourne's rapidly expanding western suburb of Melton West. This growing community, characterised by its young demograp...(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Corio

Corio, VIC 3214 660.9 km away

Become part of the world-class tattoo industry with a Celebrity Ink franchise opportunity in Corio, VIC, where our premium studios deliver exceptional artistry and customer experie...(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Waurn Ponds

Waurn Ponds, VIC 3216 662.0 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Shepparton

Shepparton, VIC 3630 669.2 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Watergardens

Taylors Lakes, VIC 3038 671.6 km away

Join Celebrity Ink's expansion into Taylors Lakes, one of Melbourne's thriving north-western suburbs. Located within a rapidly growing residential corridor and anchored by the bust...(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Werribee

Hoppers Crossing, VIC 3029 674.2 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Brimbank

Deer Park, VIC 3023 674.3 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Craigieburn

Craigieburn, VIC 3064 676.4 km away

Celebrity Ink presents a rare opportunity to establish a premium tattoo studio in the rapidly expanding suburb of Craigieburn, one of Melbourne's fastest-growing northern communiti...(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Point Cook

Point Cook, VIC 3030 679.8 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Airport West

Airport West, VIC 3042 680.4 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Broadmeadows

Broadmeadows, VIC 3047 682.4 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Altona

Altona North, VIC 3025 682.8 km away

Secure your position in Melbourne's west with Celebrity Ink's latest franchise territory in Altona North, Victoria. This rapidly developing suburb, located just 10km from Melbourne...(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Epping

Epping, VIC 3076 687.0 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Barkly Square

Brunswick, VIC 3056 689.7 km away

Pioneer the first Celebrity Ink studio in Brunswick, a dynamic inner-Melbourne suburb known for its thriving arts and cultural scene. As Melbourne's tattoo industry continues to ex...(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: DFO South Wharf

South Wharf, VIC 3006 692.1 km away

Celebrity Ink presents a rare opportunity to establish a premium tattoo studio in South Wharf, VIC, where the vibrant waterfront precinct attracts a steady flow of fashion-forward...(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Northland

Preston, VIC 3072 692.2 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Plenty Valley

Mill Park, VIC 3082 692.7 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Victoria Gardens

Richmond, VIC 3121 696.1 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Warringal

Heidelberg, VIC 3084 697.8 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Malvern Central

Armadale, VIC 3143 699.5 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: The Pines

Doncaster East, VIC 3109 706.9 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Chadstone

Chadstone, VIC 3148 707.5 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: Clarinda

Clarinda, VIC 3169 711.3 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

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

Celebrity Ink: The Glen

Glen Waverley, VIC 3150 713.3 km away

(more)

Total Investment: From $300K

Business Type: New Franchise

View
Messages50RequestTimelineExceptionsViews25Queries59Models844Livewire0MailsGate
SettingsRequest history459msRequest Duration8MBMemory Usage9.x
Laravel Version
9.52.20
PHP Version
8.2.15
Environment
test
Debug Mode
Enabled
URL
testing.hattch.net
Timezone
Australia/Melbourne
Locale
en
GET {viewType}/within-{industry}/in-{location}
status
200 OK
full_url
http://directory.testing.hattch.net/businesses-for-sale/within-retail-convenience/in-gilles-plains-s...
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": "gilles-plains-...
  • infolog[18:50:41] LOG.info: Processing single location parameter { "location": "gilles-plains-sa-5086",...
  • infolog[18:50:41] LOG.info: Successfully parsed location parameter { "location": "gilles-plains-sa-5086...
  • infolog[18:50:41] LOG.info: Cookie debugging in FranchiseDirectoryController { "path": "businesses-for-...
  • infolog[18:50:41] LOG.info: Parameters received: { "industry": "retail-convenience", "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": "gilles-plains", ...
  • infolog[18:50:41] LOG.info: Starting getFilteredListings with filters: { "locations": [], "business...
  • infolog[18:50:41] LOG.info: Applying industry filter: { "industry": "retail-convenience" }
  • infolog[18:50:41] LOG.info: Using single known industry: { "industry": "retail-convenience" }
  • infolog[18:50:41] LOG.info: Applying location filters: { "suburb": [ "gilles-plains" ], ...
  • infolog[18:50:41] LOG.info: Using postcodes for filtering: { "postcodes": [ "5086" ] }
  • infolog[18:50:41] LOG.info: Including nearby postcodes: { "count": 44, "postcodes": [ 5086,...
  • 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": 3, "per_page": 36, "curr...
  • infolog[18:50:41] LOG.info: Listings retrieved: { "count": 3, "total": 3 }
  • 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": [ 7017911 ] }
  • infolog[18:50:41] LOG.info: Retrieved postcode record for brand filters: { "postcode": "5086", "has...
  • infolog[18:50:41] LOG.info: Adding coordinates to brand filters for distance search: { "lat": "-34.8780...
  • infolog[18:50:41] LOG.info: Setting distance parameter for brands: { "max_distance": 99999 }
  • infolog[18:50:41] LOG.info: Local brand count check (exact postcode): { "postcode": "5086", "localB...
  • infolog[18:50:41] LOG.info: Starting getFilteredBrands with filters: { "locations": [], "businessTy...
  • infolog[18:50:41] LOG.info: Applying industry filter: { "industry": "retail-convenience" }
  • infolog[18:50:41] LOG.info: Using single known industry: { "industry": "retail-convenience" }
  • infolog[18:50:41] LOG.info: Using coordinates for distance-based search: { "lat": -34.87803, "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": 3, "per_page": 36, "curren...
  • infolog[18:50:41] LOG.info: Postcode found: { "id": 11806, "suburb": "Gilles Plains" }
  • 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:42] LOG.info: Successfully retrieved listings { "total": 42, "per_page": 36, "cur...
  • infolog[18:50:42] LOG.info: Exact location listing count { "suburb": "gilles-plains", "state": "SA"...
  • infolog[18:50:42] LOG.info: Starting getNearbyListings with filters: { "locations": [], "businessTy...
  • infolog[18:50:42] LOG.info: Applying industry filter: { "industry": "retail-convenience" }
  • infolog[18:50:42] LOG.info: Using where for single industry { "industry": "retail-convenience" }
  • debuglog[18:50:42] LOG.debug: Final SQL query for nearby listings: { "sql": "select distinct `listings`....
  • infolog[18:50:42] LOG.info: Successfully retrieved nearby listings { "total": 99, "per_page": 36, ...
  • infolog[18:50:42] LOG.info: Display flags: { "hasExactLocationSearch": true, "originalBrandCount": ...
  • infolog[18:50:42] LOG.info: Getting industry IDs from slug { "slug": "retail-convenience" }
  • infolog[18:50:42] LOG.info: Found industry from direct lookup { "slug": "retail-convenience", "id":...
  • infolog[18:50:42] LOG.info: Final industry IDs from slug { "slug": "retail-convenience", "ids": [ ...
  • infolog[18:50:42] LOG.info: View data prepared successfully
infodebugerror
status
200 OK
full_url
http://directory.testing.hattch.net/businesses-for-sale/within-retail-convenience/in-gilles-plains-s...
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
462ms
peak_memory
10MB
response
text/html; charset=UTF-8
request_format
html
request_query
  0 of 0   
array:1 [▼
  "distance" => "99999"
]
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-46ac274e686a31b84a9762c8"
  ]
  "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:42 GMT"
  ]
]
session_attributes
  0 of 0   
array:1 [▼
  "_token" => "MKzI5m0ExMoa0YMohrR8Okb3lotD7im9c6JEsx3Q"
]
  • Booting (17.14ms)time
  • Application (442ms)time
  • Routing (1.76ms)
  • View: pages.home.brandviews
  • View: pages.home.breadcrumbviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.dir_empty_resultsviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.summaryviews
  • View: pages.home.partials.lazy-load-scriptviews
  • View: brand.common.frontpage-layoutviews
  • View: brand.common.tracking-codesviews
  • View: pages.home.universal-headerviews
  • View: pages.home.partials.header-filtersviews
  • View: pages.home.skeleton-loadersviews
  • View: pages.home.profile_slider_menuviews
  • View: pages.home.partials._main_optionsviews
  • View: pages.home.partials._account_detailsviews
  • View: pages.home.partials._franchise_compatibilityviews
  • View: pages.home.partials._enquiries_invitationsviews
  • View: pages.home.partials._investment_calculatorviews
  • View: pages.home.partials._notification_settingsviews
  • View: pages.home.partials._securityviews
  • View: pages.widget.summaryviews
  • View: layouts.common.footerviews
  • View: partials.welcome-collection-modalviews
  • 1 x Application (96.27%)
    442ms
    1 x Booting (3.73%)
    17.14ms
    1 x Routing (0.38%)
    1.76ms
    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 (15 duplicates)Show only duplicates346ms
    • 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#328hattch2022prod31.12msselect exists(select * from `industries` where `industry_slug` = 'retail-convenience' and `industries`.`deleted_at` is null) as `exists`
      Bindings
      • 0: retail-convenience
      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#333hattch2022prod3.69msselect `id` from `industries` where `industry_slug` = 'retail-convenience' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: retail-convenience
      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.24msselect `id` from `industries` where `industry_slug` = 'retail-convenience' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: retail-convenience
      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.15msselect `to_postcode` from `distances` where `from_postcode` in ('5086') order by `distance_km` asc
      Bindings
      • 0: 5086
      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#446hattch2022prod4.66msselect 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 ('5086') where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and (`brands`.`industry_id` in (2) or `brands`.`secondary_industry_id` in (2)) and `post_codes`.`postcode` in (5086, 5088, 5086, 5087, 5075, 5093, 5085, 5090, 5098, 5074, 5092, 5089, 5083, 5081, 5070, 5073, 5084, 5095, 5094, 5069, 5082, 5068, 5127, 5096, 5097, 5072, 5106, 5010, 5067, 5107, 5006, 5091, 5066, 5008, 5076, 5065, 5013, 5012, 5007, 5126, 5000, 5132, 5136, '5086')
      Bindings
      • 0: 5086
      • 1: open
      • 2: 1
      • 3: 2
      • 4: 2
      • 5: 5086
      • 6: 5088
      • 7: 5086
      • 8: 5087
      • 9: 5075
      • 10: 5093
      • 11: 5085
      • 12: 5090
      • 13: 5098
      • 14: 5074
      • 15: 5092
      • 16: 5089
      • 17: 5083
      • 18: 5081
      • 19: 5070
      • 20: 5073
      • 21: 5084
      • 22: 5095
      • 23: 5094
      • 24: 5069
      • 25: 5082
      • 26: 5068
      • 27: 5127
      • 28: 5096
      • 29: 5097
      • 30: 5072
      • 31: 5106
      • 32: 5010
      • 33: 5067
      • 34: 5107
      • 35: 5006
      • 36: 5091
      • 37: 5066
      • 38: 5008
      • 39: 5076
      • 40: 5065
      • 41: 5013
      • 42: 5012
      • 43: 5007
      • 44: 5126
      • 45: 5000
      • 46: 5132
      • 47: 5136
      • 48: 5086
      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.63msselect 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 ('5086') where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and (`brands`.`industry_id` in (2) or `brands`.`secondary_industry_id` in (2)) and `post_codes`.`postcode` in (5086, 5088, 5086, 5087, 5075, 5093, 5085, 5090, 5098, 5074, 5092, 5089, 5083, 5081, 5070, 5073, 5084, 5095, 5094, 5069, 5082, 5068, 5127, 5096, 5097, 5072, 5106, 5010, 5067, 5107, 5006, 5091, 5066, 5008, 5076, 5065, 5013, 5012, 5007, 5126, 5000, 5132, 5136, '5086') order by CASE WHEN post_codes.postcode IN ('5086') THEN 0 ELSE 1 END, `distances`.`distance_km` asc, `post_codes`.`postcode` asc limit 36 offset 0
      Bindings
      • 0: 5086
      • 1: open
      • 2: 1
      • 3: 2
      • 4: 2
      • 5: 5086
      • 6: 5088
      • 7: 5086
      • 8: 5087
      • 9: 5075
      • 10: 5093
      • 11: 5085
      • 12: 5090
      • 13: 5098
      • 14: 5074
      • 15: 5092
      • 16: 5089
      • 17: 5083
      • 18: 5081
      • 19: 5070
      • 20: 5073
      • 21: 5084
      • 22: 5095
      • 23: 5094
      • 24: 5069
      • 25: 5082
      • 26: 5068
      • 27: 5127
      • 28: 5096
      • 29: 5097
      • 30: 5072
      • 31: 5106
      • 32: 5010
      • 33: 5067
      • 34: 5107
      • 35: 5006
      • 36: 5091
      • 37: 5066
      • 38: 5008
      • 39: 5076
      • 40: 5065
      • 41: 5013
      • 42: 5012
      • 43: 5007
      • 44: 5126
      • 45: 5000
      • 46: 5132
      • 47: 5136
      • 48: 5086
      • 49: 5086
      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.67msselect * from `brands` where `brands`.`id` in (7017911)
      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#446hattch2022prod7.03msselect * from `homepages` where `homepages`.`brand_id` in (7017911)
      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.77msselect * from `industries` where `industries`.`id` in (2) 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#446hattch2022prod4.3msselect * from `post_codes` where `post_codes`.`id` in (10717, 11693, 11814)
      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.53msselect * 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.75msselect * 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#1096hattch2022prod4.82msselect * 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.47msselect * from `post_codes` where `postcode` = '5086' limit 1
      Bindings
      • 0: 5086
      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#721hattch2022prod3.11msselect `id` from `industries` where `industry_slug` = 'retail-convenience' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: retail-convenience
      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.04msselect 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` = '5086' and (`brands`.`industry_id` = 2 or `brands`.`secondary_industry_id` = 2)
      Bindings
      • 0: open
      • 1: 1
      • 2: 5086
      • 3: 2
      • 4: 2
      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.76msselect `id` from `industries` where `industry_slug` = 'retail-convenience' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: retail-convenience
      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#1053hattch2022prod4.68msselect 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(-34.87803)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(138.62208)) + sin(radians(-34.87803)) * 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 (2) or `brands`.`secondary_industry_id` in (2)) group by `brands`.`id`) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 2
      • 3: 2
      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.94msselect 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(-34.87803)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(138.62208)) + sin(radians(-34.87803)) * 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 (2) or `brands`.`secondary_industry_id` in (2)) group by `brands`.`id` order by MIN((6751 * acos(cos(radians(-34.87803)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(138.62208)) + sin(radians(-34.87803)) * sin(radians(post_codes.lat))))) asc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      • 2: 2
      • 3: 2
      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#1053hattch2022prod10.37msselect * from `homepages` where `homepages`.`brand_id` in (7017911, 7017932, 7017956)
      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.76msselect * 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.8msselect * from `listings` where `listings`.`brand_id` in (7017911, 7017932, 7017956)
      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.5msselect * from `post_codes` where `post_codes`.`id` in (3, 5, 16, 50, 70, 101, 120, 129, 133, 208, 233, 252, 254, 364, 376, 386, 535, 621, 657, 689, 720, 751, 813, 883, 923, 1020, 1137, 1155, 1163, 1246, 1311, 1439, 1486, 1521, 1668, 1690, 1711, 1804, 1927, 2014, 2114, 2157, 2309, 2340, 2361, 2375, 2517, 2591, 2639, 2650, 2752, 2776, 2780, 2819, 2921, 3025, 3054, 3073, 3079, 3110, 3180, 3193, 3209, 3236, 3400, 3444, 3514, 3586, 3645, 3691, 3722, 3781, 3880, 3981, 3989, 4038, 4099, 4112, 4247, 4295, 4319, 4340, 4527, 4618, 4680, 4694, 4695, 4773, 4813, 4822, 4868, 4876, 4891, 4982, 5056, 5084, 5147, 5293, 5301, 5416, 5493, 5591, 5608, 5665, 5670, 5681, 5684, 5703, 5704, 5715, 5732, 5856, 5867, 5900, 5913, 5919, 5954, 5956, 5979, 5998, 6136, 6141, 6179, 6188, 6191, 6196, 6214, 6215, 6224, 6324, 6348, 6354, 6356, 6366, 6369, 6422, 6437, 6456, 6556, 6706, 6752, 6809, 6851, 6889, 6918, 7105, 7211, 7220, 7221, 7223, 7235, 7242, 7243, 7249, 7253, 7267, 7466, 7484, 7593, 7746, 7786, 7797, 7842, 7843, 7858, 7864, 7906, 7945, 7956, 8056, 8057, 8100, 8109, 8186, 8434, 8486, 8589, 8773, 8819, 8821, 8840, 8870, 8898, 8993, 9080, 9224, 9355, 9377, 9397, 9507, 9556, 9664, 9869, 9877, 9931, 9961, 9966, 10101, 10149, 10176, 10177, 10337, 10415, 10434, 10717, 10839, 10901, 10948, 10997, 11040, 11361, 11534, 11552, 11554, 11601, 11635, 11693, 11731, 11781, 11801, 11814, 11820, 11843, 11857, 11907, 11909, 12070, 12149, 12400, 12528, 12536, 12608, 12629, 12674, 12680, 12705, 12974, 12998, 13001, 13123, 13155, 13197, 13220, 13317, 13378, 13380, 13530, 13540, 13545, 13611, 13639, 13718, 13720, 13747, 13755, 14286, 14302, 14343, 14459, 14462, 14630, 14640, 14790, 14855, 14936, 14942, 14988, 15157, 15189, 15195, 15242)
      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#783hattch2022prod3.34msselect * from `post_codes` where `suburb` in ('Gilles Plains', 'Gilles-plains') and `state` = 'SA' and `postcode` = '5086' limit 1
      Bindings
      • 0: Gilles Plains
      • 1: Gilles-plains
      • 2: SA
      • 3: 5086
      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.96msselect 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#498hattch2022prod31.77msselect 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.94msselect 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#615hattch2022prod23.74msselect 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#615hattch2022prod10.21msselect * 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#615hattch2022prod9.78msselect * 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.59msselect * 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.55msselect * 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.64msselect `id` from `industries` where `industry_slug` = 'retail-convenience' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: retail-convenience
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:856
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FranchiseDirectoryController.php#870hattch2022prod3.08msselect 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` = '5086' and `post_codes`.`state` = 'SA' and `post_codes`.`suburb` in ('Gilles Plains', 'Gilles-plains') and `listings`.`status` = 'open' and (`brands`.`industry_id` = 2 or `brands`.`secondary_industry_id` = 2)
      Bindings
      • 0: 5086
      • 1: SA
      • 2: Gilles Plains
      • 3: Gilles-plains
      • 4: open
      • 5: 2
      • 6: 2
      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.6msselect `id` from `industries` where `industry_slug` = 'retail-convenience' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: retail-convenience
      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#1488hattch2022prod4.03msselect count(*) as aggregate from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and (`brands`.`industry_id` in (2) or `brands`.`secondary_industry_id` in (2))
      Bindings
      • 0: open
      • 1: 1
      • 2: 2
      • 3: 2
      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.98msselect 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(-34.85157)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(138.66031)) + sin(radians(-34.85157)) * 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 (2) or `brands`.`secondary_industry_id` in (2)) order by `distance_km` asc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      • 2: 2
      • 3: 2
      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.21msselect * from `brands` where `brands`.`id` in (7017911, 7017956)
      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.44msselect * from `homepages` where `homepages`.`brand_id` in (7017911, 7017956)
      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.94msselect * from `industries` where `industries`.`id` in (2) 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#1488hattch2022prod3.5msselect * from `post_codes` where `post_codes`.`id` in (4618, 4680, 4876, 4891, 5293, 5591, 5681, 5704, 5732, 5856, 5900, 5913, 5954, 6136, 6196, 6215, 6224, 6348, 6356, 6369, 6422, 6851, 7211, 7220, 7235, 7249, 7267, 10717, 10948, 11534, 11693, 11731, 11781, 11814, 11843, 11909)
      Backtrace
      • app/Services/BusinessListingService.php:1488
      • app/Http/Controllers/FranchiseDirectoryController.php:905
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#1264hattch2022prod3.36msselect * from `brands` where `id` in (7017911, 7017956)
      Bindings
      • 0: 7017911
      • 1: 7017956
      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#1270hattch2022prod3.36msselect * from `post_codes` where `id` in (11693, 11814, 11909, 10717, 11843, 11781, 10948, 11534, 11731, 6224, 5591, 4618, 6215, 5681, 5704, 5732, 4876, 7235, 4891, 5913, 7249, 6369, 5900, 5856, 7211, 6422, 6196, 5293, 7220, 7267, 4680, 6851, 6136, 6348, 5954, 6356)
      Bindings
      • 0: 11693
      • 1: 11814
      • 2: 11909
      • 3: 10717
      • 4: 11843
      • 5: 11781
      • 6: 10948
      • 7: 11534
      • 8: 11731
      • 9: 6224
      • 10: 5591
      • 11: 4618
      • 12: 6215
      • 13: 5681
      • 14: 5704
      • 15: 5732
      • 16: 4876
      • 17: 7235
      • 18: 4891
      • 19: 5913
      • 20: 7249
      • 21: 6369
      • 22: 5900
      • 23: 5856
      • 24: 7211
      • 25: 6422
      • 26: 6196
      • 27: 5293
      • 28: 7220
      • 29: 7267
      • 30: 4680
      • 31: 6851
      • 32: 6136
      • 33: 6348
      • 34: 5954
      • 35: 6356
      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.92msselect * 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.87msselect * from `industries` where `id` in (2)
      Bindings
      • 0: 2
      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#1295hattch2022prod4.71msselect * from `survey_questions` where `brand_id` in (7017911, 7017956) and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017911
      • 1: 7017956
      • 2: 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#1301hattch2022prod6.71msselect * from `homepages` where `brand_id` in (7017911, 7017956)
      Bindings
      • 0: 7017911
      • 1: 7017956
      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#1123hattch2022prod4.85msselect `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.99msselect `postcode` from `post_codes` where `postcode` = '5086' limit 10
      Bindings
      • 0: 5086
      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#1139hattch2022prod3.13msselect * from `post_codes` where `postcode` in ('5086', 5086, 5086, 5086, 5086, 5086, 5086)
      Bindings
      • 0: 5086
      • 1: 5086
      • 2: 5086
      • 3: 5086
      • 4: 5086
      • 5: 5086
      • 6: 5086
      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#60hattch2022prod3.09msselect * from `post_codes` where `id` = 11806 limit 1
      Bindings
      • 0: 11806
      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#257hattch2022prod3.04msselect * from `industries` where `industry_slug` = 'retail-convenience' limit 1
      Bindings
      • 0: retail-convenience
      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.94msselect * from `industries` where `id` = 2 limit 1
      Bindings
      • 0: 2
      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#383hattch2022prod10.6msselect * from `post_codes` where `id` = 11806 limit 1
      Bindings
      • 0: 11806
      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.88msselect * from `industries` where `industry_slug` = 'retail-convenience' limit 1
      Bindings
      • 0: retail-convenience
      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.06msselect * from `post_codes` where `id` = 11806 limit 1
      Bindings
      • 0: 11806
      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#99hattch2022prod3.13msSELECT minimum_investment from `brands` GROUP BY minimum_investment ORDER BY minimum_investment ASC;
      Backtrace
      • view::pages.home.partials.header-filters:99
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • header-filters.blade.php#118hattch2022prod3.14msSELECT 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#172hattch2022prod3.04msselect * 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
    409Listing.php#?
    App\Models\PostCode
    312PostCode.php#?
    App\Models\Brand
    42Brand.php#?
    App\Models\Homepage
    42Homepage.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:42GET/businesses-for-sale/within-retail-convenience/in-gilles-plains-sa-5086?distance=99999502559844