business for sale hattch logo mobile

Selected Location

Melbourne Airport (3045)
From
To
×

73 Construction or Automotive businesses for sale in Melbourne Airport VIC 3045

Target Icon
Which franchises are thebest match for you?

73 businesses for sale

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

Total Fitouts: Tullamarine

Tullamarine, VIC 3043 4.1 km away

Join the leading commercial fit-out specialists in Australia and establish your business in the thriving industrial hub of Tullamarine, VIC. This strategic location offers exceptio...(more)

Total Investment: From $50K

Business Type: New Franchise

View
business for sale Smith & Sons logo
A graphic representing a compatibility score out of 100%
?%
match

Smith & Sons: Keilor

Keilor, VIC 3036 4.1 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

View
business for sale G.J. Gardner Homes logo
A graphic representing a compatibility score out of 100%
?%
match

G.J. Gardner Homes: Westmeadows

Westmeadows, VIC 3049 5.4 km away

(more)

Total Investment: From $500K

Business Type: New Franchise

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

Freedom Cars: Airport West

Airport West, VIC 3042 6.8 km away

(more)

Total Investment: From $100K

Business Type: New Franchise

View
business for sale Smith & Sons logo
A graphic representing a compatibility score out of 100%
?%
match

Smith & Sons: St Albans

St Albans, VIC 3021 9.0 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

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

Couriers Please: Run 134 (Vic)

Roxburgh Park, VIC 3064 10.2 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

View
business for sale Smith & Sons logo
A graphic representing a compatibility score out of 100%
?%
match

Smith & Sons: Pascoe Vale

Pascoe Vale, VIC 3044 11.0 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

View
business for sale Smith & Sons logo
A graphic representing a compatibility score out of 100%
?%
match

Smith & Sons: Essendon

Essendon, VIC 3040 11.2 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

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

Couriers Please: Run 229 (Vic)

Essendon, VIC 3040 11.2 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

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

Couriers Please: Run 231 (Vic)

Moonee Ponds, VIC 3039 13.1 km away

(more)

Total Investment: From $25K

Business Type: Franchise Resale

View
business for sale Smith & Sons logo
A graphic representing a compatibility score out of 100%
?%
match

Smith & Sons: Sunshine

Sunshine, VIC 3020 13.4 km away

Establish your building and renovation business with Smith & Sons in the thriving suburb of Sunshine, just 13km west of Melbourne's CBD. As one of Victoria's fastest-developing reg...(more)

Total Investment: From $50K

Business Type: New Franchise

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

Freedom Cars: Sunshine

Sunshine, VIC 3020 13.4 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

View
business for sale G.J. Gardner Homes logo
A graphic representing a compatibility score out of 100%
?%
match

G.J. Gardner Homes: Craigieburn

Craigieburn, VIC 3064 13.7 km away

(more)

Total Investment: From $500K

Business Type: New Franchise

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

Freedom Cars: Craigieburn

Craigieburn, VIC 3064 13.7 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

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

Total Fitouts: Flemington

Flemington, VIC 3031 15.4 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

View
business for sale Smith & Sons logo
A graphic representing a compatibility score out of 100%
?%
match

Smith & Sons: Brunswick

Brunswick, VIC 3056 16.0 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

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

Total Fitouts: Brunswick

Brunswick, VIC 3056 16.0 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

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

Total Fitouts: Thomastown

Thomastown, VIC 3074 16.4 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

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

Couriers Please: Run 205 (Vic)

Epping, VIC 3076 16.7 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

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

Freedom Cars: Epping

Epping, VIC 3076 16.7 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

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

Couriers Please: Run 32 (Vic)

North Melbourne, VIC 3051 17.6 km away

Join the trusted delivery network that businesses and consumers rely on daily with this exceptional franchise opportunity in North Melbourne, VIC. Positioned in a thriving commerci...(more)

Total Investment: From $50K

Business Type: New Franchise

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

Freedom Cars: Preston

Preston, VIC 3072 17.9 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

View
business for sale Smith & Sons logo
A graphic representing a compatibility score out of 100%
?%
match

Smith & Sons: Sunbury

Sunbury, VIC 3429 18.8 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

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

Couriers Please: Run 46 (Vic)

Fitzroy North, VIC 3068 18.9 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

View
business for sale Smith & Sons logo
A graphic representing a compatibility score out of 100%
?%
match

Smith & Sons: Fitzroy

Fitzroy, VIC 3065 19.9 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

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

Total Fitouts: Port Melbourne

Port Melbourne, VIC 3207 20.4 km away

Total Fitouts presents a rare opportunity to establish a commercial fitout business in the thriving Port Melbourne area, where industrial heritage meets modern development and a gr...(more)

Total Investment: From $50K

Business Type: New Franchise

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

Couriers Please: Run 7 (Vic)

South Wharf, VIC 3006 20.7 km away

Couriers Please offers a rare franchise opportunity in the thriving commercial hub of South Wharf, Victoria, where your logistics business can leverage the area's strategic positio...(more)

Total Investment: From $50K

Business Type: New Franchise

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

Couriers Please: Run 7 (Vic)

Southbank, VIC 3006 21.0 km away

Join Couriers Please as we expand our delivery network into the dynamic Southbank precinct of Melbourne. Positioned in one of Melbourne's premier business and residential hubs, thi...(more)

Total Investment: From $50K

Business Type: New Franchise

View
business for sale Smith & Sons logo
A graphic representing a compatibility score out of 100%
?%
match

Smith & Sons: Melton

Melton, VIC 3337 21.3 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

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

Freedom Cars: Bundoora

Bundoora, VIC 3083 21.5 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

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

Couriers Please: Run 7 (Vic)

South Melbourne, VIC 3205 21.8 km away

Couriers Please offers a rare opportunity to acquire an established delivery franchise in the thriving business hub of South Melbourne, where proximity to the CBD, Port Melbourne i...(more)

Total Investment: From $25K

Business Type: Franchise Resale

View
business for sale Smith & Sons logo
A graphic representing a compatibility score out of 100%
?%
match

Smith & Sons: South Melbourne

South Melbourne, VIC 3205 21.8 km away

Smith & Sons presents a rare opportunity to join Australia's leading renovation and extension specialists in the thriving South Melbourne market. South Melbourne's blend of histori...(more)

Total Investment: From $50K

Business Type: New Franchise

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

Freedom Cars: Melbourne

Melbourne, VIC 3000 21.9 km away

Join Freedom Cars as we expand our successful vehicle rental network into Melbourne's thriving business district. As Australia's fastest-growing city and a major transport hub, Mel...(more)

Total Investment: From $50K

Business Type: New Franchise

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

Freedom Cars: Williamstown

Williamstown, VIC 3016 22.3 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

View
business for sale Smith & Sons logo
A graphic representing a compatibility score out of 100%
?%
match

Smith & Sons: Kew

Kew, VIC 3101 23.4 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

View
business for sale Smith & Sons logo
A graphic representing a compatibility score out of 100%
?%
match

Smith & Sons: Heidelberg

Heidelberg, VIC 3084 23.7 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

View
Messages50RequestTimelineExceptionsViews25Queries59Models926Livewire0MailsGate
SettingsRequest history537msRequest 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-construction-automotive/in-melbourne-...
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": "melbourne-airp...
  • infolog[18:50:41] LOG.info: Processing single location parameter { "location": "melbourne-airport-vic-3...
  • infolog[18:50:41] LOG.info: Successfully parsed location parameter { "location": "melbourne-airport-vic...
  • infolog[18:50:41] LOG.info: Cookie debugging in FranchiseDirectoryController { "path": "businesses-for-...
  • infolog[18:50:41] LOG.info: Parameters received: { "industry": "construction-automotive", "franchis...
  • 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": "melbourne-airport...
  • infolog[18:50:41] LOG.info: Starting getFilteredListings with filters: { "locations": [], "business...
  • infolog[18:50:41] LOG.info: Applying industry filter: { "industry": "construction-automotive" }
  • infolog[18:50:41] LOG.info: Using single known industry: { "industry": "construction-automotive" }
  • infolog[18:50:41] LOG.info: Applying location filters: { "suburb": [ "melbourne-airport" ],...
  • infolog[18:50:41] LOG.info: Using postcodes for filtering: { "postcodes": [ "3045" ] }
  • infolog[18:50:41] LOG.info: Including nearby postcodes: { "count": 18, "postcodes": [ 3045,...
  • 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": 7, "per_page": 36, "curr...
  • infolog[18:50:41] LOG.info: Listings retrieved: { "count": 7, "total": 7 }
  • infolog[18:50:41] LOG.info: Caching filter options for 30 minutes
  • errorlog[18:50:41] LOG.error: Error getting filter options: file_put_contents(/var/app/current/storage/frame...
  • infolog[18:50:41] LOG.info: Brand IDs found: { "ids": { "0": 7017929, "1": 7017943, ...
  • infolog[18:50:41] LOG.info: Retrieved postcode record for brand filters: { "postcode": "3045", "has...
  • infolog[18:50:41] LOG.info: Adding coordinates to brand filters for distance search: { "lat": "-37.6757...
  • infolog[18:50:41] LOG.info: Setting distance parameter for brands: { "max_distance": 50 }
  • infolog[18:50:41] LOG.info: Local brand count check (exact postcode): { "postcode": "3045", "localB...
  • infolog[18:50:41] LOG.info: Starting getFilteredBrands with filters: { "locations": [], "businessTy...
  • infolog[18:50:41] LOG.info: Applying industry filter: { "industry": "construction-automotive" }
  • infolog[18:50:41] LOG.info: Using single known industry: { "industry": "construction-automotive" }
  • infolog[18:50:41] LOG.info: Using coordinates for distance-based search: { "lat": -37.6757, "lng": ...
  • debuglog[18:50:41] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:50:41] LOG.info: Successfully retrieved brands { "total": 6, "per_page": 36, "curren...
  • infolog[18:50:41] LOG.info: Postcode found: { "id": 5907, "suburb": "Melbourne Airport" }
  • infolog[18:50:41] LOG.info: Final postcodeArray before passing to view: { "postcodeArray": [ { ...
  • infolog[18:50:41] LOG.info: Starting getDefaultListings without filters
  • debuglog[18:50:41] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.* from `listings` in...
  • infolog[18:50:41] LOG.info: Successfully retrieved listings { "total": 2552, "per_page": 36, "c...
  • infolog[18:50:41] LOG.info: Starting getDefaultBrands without filters
  • debuglog[18:50:41] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:50:41] LOG.info: Successfully retrieved listings { "total": 42, "per_page": 36, "cur...
  • infolog[18:50:41] LOG.info: Exact location listing count { "suburb": "melbourne-airport", "state": ...
  • infolog[18:50:41] LOG.info: Starting getNearbyListings with filters: { "locations": [], "businessTy...
  • infolog[18:50:41] LOG.info: Applying industry filter: { "industry": "construction-automotive" }
  • infolog[18:50:41] LOG.info: Using where for single industry { "industry": "construction-automotive" }
  • debuglog[18:50:41] LOG.debug: Final SQL query for nearby listings: { "sql": "select distinct `listings`....
  • infolog[18:50:41] LOG.info: Successfully retrieved nearby listings { "total": 73, "per_page": 36, ...
  • infolog[18:50:41] LOG.info: Display flags: { "hasExactLocationSearch": true, "originalBrandCount": ...
  • infolog[18:50:41] LOG.info: Getting industry IDs from slug { "slug": "construction-automotive" }
  • infolog[18:50:41] LOG.info: Found industry from direct lookup { "slug": "construction-automotive", ...
  • infolog[18:50:41] LOG.info: Final industry IDs from slug { "slug": "construction-automotive", "ids"...
  • infolog[18:50:41] LOG.info: View data prepared successfully
infodebugerror
status
200 OK
full_url
http://directory.testing.hattch.net/businesses-for-sale/within-construction-automotive/in-melbourne-...
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
538ms
peak_memory
12MB
response
text/html; charset=UTF-8
request_format
html
request_query
  0 of 0   
array:1 [▼
  "distance" => "50"
]
request_request
[]
request_headers
  0 of 0   
array:12 [▼
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "via" => array:1 [▶
    0 => "1.1 squid-proxy-5b5d847c96-kml6h (squid/6.10)"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "x-amzn-trace-id" => array:1 [▶
    0 => "Root=1-68664461-4f9456432f25c8305f4041c0"
  ]
  "host" => array:1 [▶
    0 => "directory.testing.hattch.net"
  ]
  "x-forwarded-port" => array:1 [▶
    0 => "80"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "http"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "10.1.3.136, 216.73.216.89"
  ]
]
request_cookies
[]
response_headers
  0 of 0   
array:3 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Thu, 03 Jul 2025 08:50:41 GMT"
  ]
]
session_attributes
  0 of 0   
array:1 [▼
  "_token" => "ulabZ0af5A8fmooZAUqt6q9cRUeNY9lnCAUB0fAs"
]
  • Booting (53.75ms)time
  • Application (483ms)time
  • Routing (1.96ms)
  • 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 (89.98%)
    483ms
    1 x Booting (10.02%)
    53.75ms
    1 x Routing (0.36%)
    1.96ms
    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 duplicates374ms
    • 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#328hattch2022prod12.87msselect exists(select * from `industries` where `industry_slug` = 'construction-automotive' and `industries`.`deleted_at` is null) as `exists`
      Bindings
      • 0: construction-automotive
      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.38msselect `id` from `industries` where `industry_slug` = 'construction-automotive' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: construction-automotive
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:333
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • BusinessListingService.php#34hattch2022prod2.61msselect `id` from `industries` where `industry_slug` = 'construction-automotive' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: construction-automotive
      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#267hattch2022prod5.07msselect `to_postcode` from `distances` where `from_postcode` in ('3045') order by `distance_km` asc
      Bindings
      • 0: 3045
      Backtrace
      • app/Services/BusinessListingService.php:267
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#446hattch2022prod5.57msselect 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 ('3045') where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and (`brands`.`industry_id` in (5) or `brands`.`secondary_industry_id` in (5)) and `post_codes`.`postcode` in (3045, 3045, 3036, 3038, 3059, 3049, 3037, 3043, 3042, 3428, 3021, 3033, 3023, 3041, 3047, 3020, 3048, '3045')
      Bindings
      • 0: 3045
      • 1: open
      • 2: 1
      • 3: 5
      • 4: 5
      • 5: 3045
      • 6: 3045
      • 7: 3036
      • 8: 3038
      • 9: 3059
      • 10: 3049
      • 11: 3037
      • 12: 3043
      • 13: 3042
      • 14: 3428
      • 15: 3021
      • 16: 3033
      • 17: 3023
      • 18: 3041
      • 19: 3047
      • 20: 3020
      • 21: 3048
      • 22: 3045
      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.83msselect 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 ('3045') where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and (`brands`.`industry_id` in (5) or `brands`.`secondary_industry_id` in (5)) and `post_codes`.`postcode` in (3045, 3045, 3036, 3038, 3059, 3049, 3037, 3043, 3042, 3428, 3021, 3033, 3023, 3041, 3047, 3020, 3048, '3045') order by CASE WHEN post_codes.postcode IN ('3045') THEN 0 ELSE 1 END, `distances`.`distance_km` asc, `post_codes`.`postcode` asc limit 36 offset 0
      Bindings
      • 0: 3045
      • 1: open
      • 2: 1
      • 3: 5
      • 4: 5
      • 5: 3045
      • 6: 3045
      • 7: 3036
      • 8: 3038
      • 9: 3059
      • 10: 3049
      • 11: 3037
      • 12: 3043
      • 13: 3042
      • 14: 3428
      • 15: 3021
      • 16: 3033
      • 17: 3023
      • 18: 3041
      • 19: 3047
      • 20: 3020
      • 21: 3048
      • 22: 3045
      • 23: 3045
      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.62msselect * from `brands` where `brands`.`id` in (7017924, 7017929, 7017943, 7017964)
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#446hattch2022prod5.28msselect * from `homepages` where `homepages`.`brand_id` in (7017924, 7017929, 7017943, 7017964)
      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.49msselect * from `industries` where `industries`.`id` in (5) and `industries`.`deleted_at` is null
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#446hattch2022prod3.26msselect * from `post_codes` where `post_codes`.`id` in (4872, 4873, 4882, 4887, 5906, 6369)
      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.4msselect * 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#1095hattch2022prod2.32msselect * 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#1096hattch2022prod2.96msselect * 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.8msselect * from `post_codes` where `postcode` = '3045' limit 1
      Bindings
      • 0: 3045
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:624
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FranchiseDirectoryController.php#721hattch2022prod2.72msselect `id` from `industries` where `industry_slug` = 'construction-automotive' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: construction-automotive
      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#730hattch2022prod6.67msselect 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` = '3045' and (`brands`.`industry_id` = 5 or `brands`.`secondary_industry_id` = 5)
      Bindings
      • 0: open
      • 1: 1
      • 2: 3045
      • 3: 5
      • 4: 5
      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.16msselect `id` from `industries` where `industry_slug` = 'construction-automotive' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: construction-automotive
      Backtrace
      • app/Services/BusinessListingService.php:34
      • app/Services/BusinessListingService.php:724
      • app/Http/Controllers/FranchiseDirectoryController.php:744
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • BusinessListingService.php#1053hattch2022prod7.59msselect 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(-37.6757)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.83596)) + sin(radians(-37.6757)) * 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 (5) or `brands`.`secondary_industry_id` in (5)) group by `brands`.`id` having MIN((6751 * acos(cos(radians(-37.6757)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.83596)) + sin(radians(-37.6757)) * sin(radians(post_codes.lat))))) <= 50) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 5
      • 3: 5
      • 4: 50
      Backtrace
      • app/Services/BusinessListingService.php:1053
      • app/Http/Controllers/FranchiseDirectoryController.php:744
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1053hattch2022prod10.29msselect distinct `brands`.`id`, `brands`.`id` as `brand_id`, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `brands`.`minimum_investment`, `brands`.`maximum_investment`, `brands`.`country_code`, `industries`.`industry`, `industries`.`industry_slug`, MIN(post_codes.suburb) as suburb, MIN(post_codes.state) as state, MIN(post_codes.postcode) as postcode, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_brand_logo")) as mobile_brand_logo, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_listing_image")) as mobile_listing_image, JSON_UNQUOTE(JSON_EXTRACT(homepages.section2, "$.business_intro_subtext")) as business_intro_subtext, MIN((6751 * acos(cos(radians(-37.6757)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.83596)) + sin(radians(-37.6757)) * 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 (5) or `brands`.`secondary_industry_id` in (5)) group by `brands`.`id` having MIN((6751 * acos(cos(radians(-37.6757)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.83596)) + sin(radians(-37.6757)) * sin(radians(post_codes.lat))))) <= 50 order by MIN((6751 * acos(cos(radians(-37.6757)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.83596)) + sin(radians(-37.6757)) * sin(radians(post_codes.lat))))) asc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      • 2: 5
      • 3: 5
      • 4: 50
      Backtrace
      • app/Services/BusinessListingService.php:1053
      • app/Http/Controllers/FranchiseDirectoryController.php:744
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1053hattch2022prod10.13msselect * from `homepages` where `homepages`.`brand_id` in (7017924, 7017929, 7017940, 7017943, 7017959, 7017964)
      Backtrace
      • app/Services/BusinessListingService.php:1053
      • app/Http/Controllers/FranchiseDirectoryController.php:744
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1053hattch2022prod8.39msselect * from `industries` where 0 = 1 and `industries`.`deleted_at` is null
      Backtrace
      • app/Services/BusinessListingService.php:1053
      • app/Http/Controllers/FranchiseDirectoryController.php:744
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1053hattch2022prod8.33msselect * from `listings` where `listings`.`brand_id` in (7017924, 7017929, 7017940, 7017943, 7017959, 7017964)
      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.75msselect * from `post_codes` where `post_codes`.`id` in (5, 16, 47, 48, 70, 101, 107, 108, 126, 133, 207, 217, 231, 370, 385, 451, 536, 561, 580, 676, 689, 714, 729, 730, 813, 883, 923, 1020, 1163, 1285, 1292, 1296, 1417, 1447, 1451, 1804, 1925, 1959, 1964, 2009, 2277, 2370, 2391, 2395, 2517, 2536, 2598, 2635, 2639, 2761, 2889, 2930, 3066, 3067, 3073, 3118, 3148, 3152, 3285, 3295, 3341, 3443, 3483, 3495, 3498, 3508, 3514, 3697, 3991, 4035, 4043, 4099, 4618, 4680, 4685, 4687, 4710, 4773, 4819, 4861, 4862, 4864, 4868, 4869, 4870, 4872, 4873, 4882, 4887, 4982, 5033, 5056, 5060, 5078, 5079, 5084, 5102, 5147, 5293, 5296, 5416, 5417, 5472, 5480, 5500, 5541, 5591, 5665, 5669, 5679, 5691, 5732, 5863, 5892, 5906, 5909, 5913, 5919, 5970, 5978, 5986, 5998, 6138, 6141, 6191, 6193, 6195, 6196, 6198, 6200, 6204, 6206, 6214, 6224, 6281, 6285, 6351, 6355, 6360, 6363, 6364, 6369, 6422, 6424, 6426, 6467, 6470, 6472, 6702, 6706, 6752, 6809, 6850, 6851, 6918, 7012, 7105, 7200, 7211, 7221, 7223, 7236, 7241, 7249, 7253, 7254, 7260, 7307, 7368, 7466, 7725, 7786, 7789, 7791, 7800, 7878, 7918, 7945, 8057, 8058, 8109, 8186, 8225, 8434, 8589, 8694, 8695, 8773, 8820, 8821, 8826, 8857, 8869, 8870, 8874, 8898, 8985, 9080, 9224, 9369, 9397, 9491, 9507, 9512, 9556, 9664, 9731, 9869, 9923, 9932, 9934, 9961, 9975, 10101, 10149, 10177, 10272, 10336, 10353, 10717, 10718, 10924, 10971, 11109, 11361, 11554, 11580, 11601, 11711, 11725, 11731, 11734, 11774, 11843, 11848, 11910, 12056, 12151, 12235, 12499, 12533, 12608, 12629, 12663, 12674, 12680, 12741, 12992, 13155, 13271, 13317, 13530, 13588, 13639, 13735, 13751, 13755, 13844, 14141, 14343, 14465, 14630, 14855, 14920, 15172, 15174, 15203)
      Backtrace
      • app/Services/BusinessListingService.php:1053
      • app/Http/Controllers/FranchiseDirectoryController.php:744
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#783hattch2022prod4.98msselect * from `post_codes` where `suburb` in ('Melbourne Airport', 'Melbourne-airport') and `state` = 'VIC' and `postcode` = '3045' limit 1
      Bindings
      • 0: Melbourne Airport
      • 1: Melbourne-airport
      • 2: VIC
      • 3: 3045
      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#498hattch2022prod22.86msselect 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#498hattch2022prod52.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#615hattch2022prod20.07msselect 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#615hattch2022prod21.35msselect 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.15msselect * from `brands` where `brands`.`id` in (7017918, 7017929, 7017930, 7017931, 7017932, 7017934, 7017937, 7017940, 7017941, 7017943, 7017944, 7017945, 7017946, 7017947, 7017948, 7017949, 7017950, 7017951, 7017953, 7017956, 7017959, 7017960, 7017962, 7017963, 7017964, 7017965, 7017967, 7017968, 7017969, 7017970, 7017971, 7017972, 7017973, 7017978, 7017981, 7017984)
      Backtrace
      • app/Services/BusinessListingService.php:615
      • app/Http/Controllers/FranchiseDirectoryController.php:811
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#615hattch2022prod15.06msselect * 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.57msselect * 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#615hattch2022prod3.21msselect * from `post_codes` where 0 = 1
      Backtrace
      • app/Services/BusinessListingService.php:615
      • app/Http/Controllers/FranchiseDirectoryController.php:811
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#856hattch2022prod3.02msselect `id` from `industries` where `industry_slug` = 'construction-automotive' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: construction-automotive
      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.67msselect 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` = '3045' and `post_codes`.`state` = 'VIC' and `post_codes`.`suburb` in ('Melbourne Airport', 'Melbourne-airport') and `listings`.`status` = 'open' and (`brands`.`industry_id` = 5 or `brands`.`secondary_industry_id` = 5)
      Bindings
      • 0: 3045
      • 1: VIC
      • 2: Melbourne Airport
      • 3: Melbourne-airport
      • 4: open
      • 5: 5
      • 6: 5
      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#34hattch2022prod8.7msselect `id` from `industries` where `industry_slug` = 'construction-automotive' and `industries`.`deleted_at` is null limit 1
      Bindings
      • 0: construction-automotive
      Backtrace
      • app/Services/BusinessListingService.php:34
      • app/Services/BusinessListingService.php:1276
      • app/Http/Controllers/FranchiseDirectoryController.php:905
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • BusinessListingService.php#1488hattch2022prod7.63msselect 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(-37.6757)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.83596)) + sin(radians(-37.6757)) * 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 (5) or `brands`.`secondary_industry_id` in (5)) having distance_km <= 50) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 5
      • 3: 5
      • 4: 50
      Backtrace
      • app/Services/BusinessListingService.php:1488
      • app/Http/Controllers/FranchiseDirectoryController.php:905
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1488hattch2022prod7.38msselect 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(-37.6757)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(144.83596)) + sin(radians(-37.6757)) * 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 (5) or `brands`.`secondary_industry_id` in (5)) having distance_km <= 50 order by `distance_km` asc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      • 2: 5
      • 3: 5
      • 4: 50
      Backtrace
      • app/Services/BusinessListingService.php:1488
      • app/Http/Controllers/FranchiseDirectoryController.php:905
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1488hattch2022prod2.97msselect * from `brands` where `brands`.`id` in (7017924, 7017929, 7017943, 7017959, 7017964)
      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#1488hattch2022prod4.12msselect * from `homepages` where `homepages`.`brand_id` in (7017924, 7017929, 7017943, 7017959, 7017964)
      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.45msselect * from `industries` where `industries`.`id` in (5) 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#1488hattch2022prod6.08msselect * from `post_codes` where `post_codes`.`id` in (4680, 4687, 4870, 4872, 4873, 4882, 4887, 5293, 5863, 5906, 5909, 5913, 5919, 6193, 6195, 6196, 6200, 6204, 6206, 6214, 6363, 6364, 6369, 6422, 6424, 6426, 6706, 7211, 7221, 7254)
      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.79msselect * from `brands` where `id` in (7017943, 7017929, 7017924, 7017964, 7017959)
      Bindings
      • 0: 7017943
      • 1: 7017929
      • 2: 7017924
      • 3: 7017964
      • 4: 7017959
      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.29msselect * from `post_codes` where `id` in (4882, 4872, 5906, 6369, 4873, 5909, 6426, 6364, 6363, 4887, 5913, 6206, 6422, 7221, 7211, 6200, 5293, 5919, 6424, 7254, 6204, 6196, 6195, 6214, 4687, 6706, 6193, 5863, 4870, 4680)
      Bindings
      • 0: 4882
      • 1: 4872
      • 2: 5906
      • 3: 6369
      • 4: 4873
      • 5: 5909
      • 6: 6426
      • 7: 6364
      • 8: 6363
      • 9: 4887
      • 10: 5913
      • 11: 6206
      • 12: 6422
      • 13: 7221
      • 14: 7211
      • 15: 6200
      • 16: 5293
      • 17: 5919
      • 18: 6424
      • 19: 7254
      • 20: 6204
      • 21: 6196
      • 22: 6195
      • 23: 6214
      • 24: 4687
      • 25: 6706
      • 26: 6193
      • 27: 5863
      • 28: 4870
      • 29: 4680
      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, 3)
      Bindings
      • 0: 1
      • 1: 3
      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.58msselect * from `industries` where `id` in (5)
      Bindings
      • 0: 5
      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.73msselect * from `survey_questions` where `brand_id` in (7017943, 7017929, 7017924, 7017964, 7017959) and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017943
      • 1: 7017929
      • 2: 7017924
      • 3: 7017964
      • 4: 7017959
      • 5: 1
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:1295
      • app/Http/Controllers/FranchiseDirectoryController.php:1097
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#1301hattch2022prod4.27msselect * from `homepages` where `brand_id` in (7017943, 7017929, 7017924, 7017964, 7017959)
      Bindings
      • 0: 7017943
      • 1: 7017929
      • 2: 7017924
      • 3: 7017964
      • 4: 7017959
      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.35msselect `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.64msselect `postcode` from `post_codes` where `postcode` = '3045' limit 10
      Bindings
      • 0: 3045
      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.72msselect * from `post_codes` where `postcode` in ('3045', 3045)
      Bindings
      • 0: 3045
      • 1: 3045
      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.68msselect * from `post_codes` where `id` = 5907 limit 1
      Bindings
      • 0: 5907
      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#257hattch2022prod7.09msselect * from `industries` where `industry_slug` = 'construction-automotive' limit 1
      Bindings
      • 0: construction-automotive
      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.4msselect * from `industries` where `id` = 5 limit 1
      Bindings
      • 0: 5
      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.59msselect * from `post_codes` where `id` = 5907 limit 1
      Bindings
      • 0: 5907
      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.51msselect * from `industries` where `industry_slug` = 'construction-automotive' limit 1
      Bindings
      • 0: construction-automotive
      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.48msselect * from `post_codes` where `id` = 5907 limit 1
      Bindings
      • 0: 5907
      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.87msSELECT 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.6msSELECT 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.55msselect * 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
    480Listing.php#?
    App\Models\PostCode
    305PostCode.php#?
    App\Models\Brand
    51Brand.php#?
    App\Models\Homepage
    51Homepage.php#?
    App\Models\Industry
    32Industry.php#?
    App\Models\FranchiseType
    4FranchiseType.php#?
    App\Models\Category
    3Category.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-07-03 18:50:41GET/businesses-for-sale/within-construction-automotive/in-melbourne-airport-vic-3045?distance=50502559926