101 Construction or Automotive businesses for sale in Clyde North VIC 3978

101 businesses for sale

Couriers Please: Run 601 (Vic)

(more)

Total Investment: From $25K

Business Type: Franchise Resale

Couriers Please: Run 224 (Vic)

(more)

Total Investment: From $25K

Business Type: Franchise Resale

G.J. Gardner Homes: Hawthorn East

G.J. Gardner Homes presents a rare opportunity to establish a premium home building franchise in the prestigious suburb of Hawthorn East, Victoria. This affluent eastern Melbourne...(more)

Total Investment: From $500K

Business Type: New Franchise

Smith & Sons: Balwyn

Balwyn, VIC 3103 42.7 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

Total Fitouts: Doncaster

Join the premier commercial fit-out specialists in Australia and establish your business presence in Doncaster, a thriving commercial hub in Melbourne's east with exceptional growt...(more)

Total Investment: From $50K

Business Type: New Franchise

Couriers Please: Run 266 (Vic)

(more)

Total Investment: From $25K

Business Type: New Franchise

Smith & Sons: Toorak

Toorak, VIC 3142 44.0 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

Smith & Sons: Hawthorn

Smith & Sons offers a rare opportunity to join Australia's premier home renovation franchise in the thriving suburb of Hawthorn, Victoria. This established eastern Melbourne locati...(more)

Total Investment: From $50K

Business Type: New Franchise

Total Fitouts: Hawthorn

(more)

Total Investment: From $50K

Business Type: New Franchise

Smith & Sons: St Kilda

Smith & Sons offers a rare opportunity to establish a premium renovation and extension business in the vibrant coastal suburb of St Kilda, where property values continue to rise an...(more)

Total Investment: From $50K

Business Type: New Franchise

Couriers Please: Run 174 (Vic)

Join Couriers Please as we establish our delivery network in the vibrant suburb of St Kilda, Melbourne. Located just 6km from Melbourne's CBD, St Kilda combines bustling retail pre...(more)

Total Investment: From $25K

Business Type: New Franchise

Total Fitouts: Yarra

Join the premier commercial fit-out specialists in one of Melbourne's most prestigious inner-city suburbs. South Yarra offers an exceptional business landscape with its thriving re...(more)

Total Investment: From $50K

Business Type: New Franchise

Couriers Please: Run 68

(more)

Total Investment: From $50K

Business Type: New Franchise

Smith & Sons: Kew

Kew, VIC 3101 46.5 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

Smith & Sons: Coldstream

Smith & Sons presents a rare opportunity to join Australia's leading renovation building company in the picturesque Coldstream region of Victoria's Yarra Valley. This thriving area...(more)

Total Investment: From $50K

Business Type: New Franchise

Freedom Cars: Melbourne

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

Smith & Sons: South Melbourne

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

Couriers Please: Run 7 (Vic)

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

Smith & Sons: Heidelberg

(more)

Total Investment: From $50K

Business Type: New Franchise

Couriers Please: Run 7 (Vic)

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

Couriers Please: Run 7 (Vic)

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

Smith & Sons: Fitzroy

Fitzroy, VIC 3065 49.9 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

Couriers Please: Run 46 (Vic)

(more)

Total Investment: From $50K

Business Type: New Franchise

Total Fitouts: Port Melbourne

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

Couriers Please: Run 32 (Vic)

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

Freedom Cars: Williamstown

(more)

Total Investment: From $50K

Business Type: New Franchise

Couriers Please: Run 193 (Vic)

(more)

Total Investment: From $25K

Business Type: Franchise Resale

Freedom Cars: Preston

Preston, VIC 3072 53.3 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

Smith & Sons: Warragul

(more)

Total Investment: From $50K

Business Type: New Franchise

Smith & Sons: Brunswick

(more)

Total Investment: From $50K

Business Type: New Franchise

Total Fitouts: Brunswick

(more)

Total Investment: From $50K

Business Type: New Franchise

Freedom Cars: Bundoora

(more)

Total Investment: From $50K

Business Type: New Franchise

Total Fitouts: Flemington

(more)

Total Investment: From $50K

Business Type: New Franchise

Couriers Please: Run 231 (Vic)

(more)

Total Investment: From $25K

Business Type: Franchise Resale

Smith & Sons: Essendon

(more)

Total Investment: From $50K

Business Type: New Franchise

Couriers Please: Run 229 (Vic)

(more)

Total Investment: From $50K

Business Type: New Franchise

SettingsRequest history417msRequest Duration6MBMemory 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-clyde-nort...
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:45] LOG.info: ValidateBusinessListingUrl processing request { "path": "businesses-for-sal...
  • infolog[18:50:45] LOG.info: Route has location parameter, passing through { "location": "clyde-north-vi...
  • infolog[18:50:45] LOG.info: Processing single location parameter { "location": "clyde-north-vic-3978", ...
  • infolog[18:50:45] LOG.info: Successfully parsed location parameter { "location": "clyde-north-vic-3978"...
  • infolog[18:50:45] LOG.info: Cookie debugging in FranchiseDirectoryController { "path": "businesses-for-...
  • infolog[18:50:45] LOG.info: Parameters received: { "industry": "construction-automotive", "franchis...
  • infolog[18:50:45] LOG.info: User is not authenticated on filtered listings page { "host": "directory.te...
  • infolog[18:50:45] LOG.info: Populated filter arrays from parsed location { "suburb": "clyde-north", ...
  • infolog[18:50:45] LOG.info: Starting getFilteredListings with filters: { "locations": [], "business...
  • infolog[18:50:45] LOG.info: Applying industry filter: { "industry": "construction-automotive" }
  • infolog[18:50:45] LOG.info: Using single known industry: { "industry": "construction-automotive" }
  • infolog[18:50:45] LOG.info: Applying location filters: { "suburb": [ "clyde-north" ], "...
  • infolog[18:50:45] LOG.info: Using postcodes for filtering: { "postcodes": [ "3978" ] }
  • infolog[18:50:45] LOG.info: Including nearby postcodes: { "count": 6, "postcodes": [ 3978, ...
  • infolog[18:50:45] LOG.info: Adding distance_km to select for sorting by distance
  • debuglog[18:50:45] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.*, `brands`.`id` as ...
  • infolog[18:50:45] LOG.info: Successfully retrieved listings { "total": 3, "per_page": 36, "curr...
  • infolog[18:50:45] LOG.info: Listings retrieved: { "count": 0, "total": 3 }
  • infolog[18:50:45] LOG.info: Caching filter options for 30 minutes
  • errorlog[18:50:45] LOG.error: Error getting filter options: file_put_contents(/var/app/current/storage/frame...
  • infolog[18:50:45] LOG.info: Brand IDs found: { "ids": [] }
  • infolog[18:50:45] LOG.info: Retrieved postcode record for brand filters: { "postcode": "3978", "has...
  • infolog[18:50:45] LOG.info: Adding coordinates to brand filters for distance search: { "lat": "-38.1436...
  • infolog[18:50:45] LOG.info: Setting distance parameter for brands: { "max_distance": 100 }
  • infolog[18:50:45] LOG.info: Local brand count check (exact postcode): { "postcode": "3978", "localB...
  • infolog[18:50:45] LOG.info: Starting getFilteredBrands with filters: { "locations": [], "businessTy...
  • infolog[18:50:45] LOG.info: Applying industry filter: { "industry": "construction-automotive" }
  • infolog[18:50:45] LOG.info: Using single known industry: { "industry": "construction-automotive" }
  • infolog[18:50:45] LOG.info: Using coordinates for distance-based search: { "lat": -38.14365, "lng":...
  • debuglog[18:50:45] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:50:45] LOG.info: Successfully retrieved brands { "total": 6, "per_page": 36, "curren...
  • infolog[18:50:45] LOG.info: Postcode found: { "id": 5101, "suburb": "Clyde North" }
  • infolog[18:50:45] LOG.info: Final postcodeArray before passing to view: { "postcodeArray": [ { ...
  • infolog[18:50:45] LOG.info: Starting getDefaultListings without filters
  • debuglog[18:50:45] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.* from `listings` in...
  • infolog[18:50:45] LOG.info: Successfully retrieved listings { "total": 2552, "per_page": 36, "c...
  • infolog[18:50:45] LOG.info: Starting getDefaultBrands without filters
  • debuglog[18:50:45] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:50:45] LOG.info: Successfully retrieved listings { "total": 42, "per_page": 36, "cur...
  • infolog[18:50:45] LOG.info: Exact location listing count { "suburb": "clyde-north", "state": "VIC",...
  • infolog[18:50:45] LOG.info: Starting getNearbyListings with filters: { "locations": [], "businessTy...
  • infolog[18:50:45] LOG.info: Applying industry filter: { "industry": "construction-automotive" }
  • infolog[18:50:45] LOG.info: Using where for single industry { "industry": "construction-automotive" }
  • debuglog[18:50:45] LOG.debug: Final SQL query for nearby listings: { "sql": "select distinct `listings`....
  • infolog[18:50:46] LOG.info: Successfully retrieved nearby listings { "total": 101, "per_page": 36, ...
  • infolog[18:50:46] LOG.info: Display flags: { "hasExactLocationSearch": true, "originalBrandCount": ...
  • infolog[18:50:46] LOG.info: Getting industry IDs from slug { "slug": "construction-automotive" }
  • infolog[18:50:46] LOG.info: Found industry from direct lookup { "slug": "construction-automotive", ...
  • infolog[18:50:46] LOG.info: Final industry IDs from slug { "slug": "construction-automotive", "ids"...
  • infolog[18:50:46] LOG.info: View data prepared successfully
status
200 OK
full_url
http://directory.testing.hattch.net/businesses-for-sale/within-construction-automotive/in-clyde-nort...
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
419ms
peak_memory
8MB
response
text/html; charset=UTF-8
request_format
html
request_query
0 of 0
array:2 [ "distance" => "100" "page" => "2" ]
request_request
[]
request_headers
0 of 0
array:13 [ "cache-control" => array:1 [ 0 => "no-cache" ] "via" => array:1 [ 0 => "1.1 squid-proxy-5b5d847c96-kml6h (squid/6.10)" ] "cookie" => array:1 [ 0 => "_clck=lwhbtr%7C2%7Cfxa%7C0%7C2010" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "pragma" => array:1 [ 0 => "no-cache" ] "x-amzn-trace-id" => array:1 [ 0 => "Root=1-68664465-1d6188223a998e850fd8b3f2" ] "host" => array:1 [ 0 => "directory.testing.hattch.net" ] "x-forwarded-port" => array:1 [ 0 => "80" ] "x-forwarded-proto" => array:1 [ 0 => "http" ] "x-forwarded-for" => array:1 [ 0 => "10.1.3.136, 216.73.216.89" ] ]
request_cookies
0 of 0
array:1 [ "_clck" => "lwhbtr|2|fxa|0|2010" ]
response_headers
0 of 0
array:3 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Thu, 03 Jul 2025 08:50:46 GMT" ] ]
session_attributes
0 of 0
array:1 [ "_token" => "ysWdOVl3MT2dAXR1Eu6SDRiiQw4hPNvFRlPeG2TV" ]
  • Booting (21.67ms)time
  • Application (396ms)time
  • Routing (1.89ms)
  • View: pages.home.brandviews
  • View: pages.home.breadcrumbviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.dir_empty_resultsviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.widget.summaryviews
  • View: pages.home.partials.lazy-load-scriptviews
  • View: brand.common.frontpage-layoutviews
  • View: brand.common.tracking-codesviews
  • View: pages.home.universal-headerviews
  • View: pages.home.partials.header-filtersviews
  • View: pages.home.skeleton-loadersviews
  • View: pages.home.profile_slider_menuviews
  • View: pages.home.partials._main_optionsviews
  • View: pages.home.partials._account_detailsviews
  • View: pages.home.partials._franchise_compatibilityviews
  • View: pages.home.partials._enquiries_invitationsviews
  • View: pages.home.partials._investment_calculatorviews
  • View: pages.home.partials._notification_settingsviews
  • View: pages.home.partials._securityviews
  • View: pages.widget.summaryviews
  • View: layouts.common.footerviews
  • View: partials.welcome-collection-modalviews
  • 1 x Application (94.81%)
    396ms
    1 x Booting (5.19%)
    21.67ms
    1 x Routing (0.45%)
    1.89ms
    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
    51 statements were executed (13 duplicates)Show only duplicates318ms
    • 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.58msselect 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.56msselect `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.54msselect `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#267hattch2022prod2.49msselect `to_postcode` from `distances` where `from_postcode` in ('3978') order by `distance_km` asc
      Bindings
      • 0: 3978
      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#446hattch2022prod3.26msselect 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 ('3978') 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 (3978, 3978, 3809, 3807, 3977, '3978')
      Bindings
      • 0: 3978
      • 1: open
      • 2: 1
      • 3: 5
      • 4: 5
      • 5: 3978
      • 6: 3978
      • 7: 3809
      • 8: 3807
      • 9: 3977
      • 10: 3978
      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.65msselect 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 ('3978') 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 (3978, 3978, 3809, 3807, 3977, '3978') order by CASE WHEN post_codes.postcode IN ('3978') THEN 0 ELSE 1 END, `distances`.`distance_km` asc, `post_codes`.`postcode` asc limit 36 offset 36
      Bindings
      • 0: 3978
      • 1: open
      • 2: 1
      • 3: 5
      • 4: 5
      • 5: 3978
      • 6: 3978
      • 7: 3809
      • 8: 3807
      • 9: 3977
      • 10: 3978
      • 11: 3978
      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.46msselect * 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.39msselect * 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.37msselect * 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.72msselect * from `post_codes` where `postcode` = '3978' limit 1
      Bindings
      • 0: 3978
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:624
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FranchiseDirectoryController.php#721hattch2022prod2.41msselect `id` from `industries` where `industry_slug` = '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#730hattch2022prod2.9msselect 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` = '3978' and (`brands`.`industry_id` = 5 or `brands`.`secondary_industry_id` = 5)
      Bindings
      • 0: open
      • 1: 1
      • 2: 3978
      • 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#34hattch2022prod2.42msselect `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.24msselect 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(-38.14365)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(145.41781)) + sin(radians(-38.14365)) * 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(-38.14365)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(145.41781)) + sin(radians(-38.14365)) * sin(radians(post_codes.lat))))) <= 100) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 5
      • 3: 5
      • 4: 100
      Backtrace
      • app/Services/BusinessListingService.php:1053
      • app/Http/Controllers/FranchiseDirectoryController.php:744
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#1053hattch2022prod6.72msselect 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(-38.14365)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(145.41781)) + sin(radians(-38.14365)) * 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(-38.14365)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(145.41781)) + sin(radians(-38.14365)) * sin(radians(post_codes.lat))))) <= 100 order by MIN((6751 * acos(cos(radians(-38.14365)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(145.41781)) + sin(radians(-38.14365)) * sin(radians(post_codes.lat))))) asc limit 36 offset 36
      Bindings
      • 0: open
      • 1: 1
      • 2: 5
      • 3: 5
      • 4: 100
      Backtrace
      • app/Services/BusinessListingService.php:1053
      • app/Http/Controllers/FranchiseDirectoryController.php:744
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#783hattch2022prod2.74msselect * from `post_codes` where `suburb` in ('Clyde North', 'Clyde-north') and `state` = 'VIC' and `postcode` = '3978' limit 1
      Bindings
      • 0: Clyde North
      • 1: Clyde-north
      • 2: VIC
      • 3: 3978
      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#498hattch2022prod10.65msselect 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#498hattch2022prod30.85msselect 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 36
      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#615hattch2022prod21.62msselect count(*) as aggregate from (select distinct `brands`.`id`, `brands`.`id` as `brand_id`, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `brands`.`minimum_investment`, `brands`.`maximum_investment`, `brands`.`country_code`, `industries`.`industry`, `industries`.`industry_slug`, MIN(post_codes.suburb) as suburb, MIN(post_codes.state) as state, MIN(post_codes.postcode) as postcode, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_brand_logo")) as mobile_brand_logo, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_listing_image")) as mobile_listing_image, JSON_UNQUOTE(JSON_EXTRACT(homepages.section2, "$.business_intro_subtext")) as business_intro_subtext from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) group by `brands`.`id`) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      Backtrace
      • app/Services/BusinessListingService.php:615
      • app/Http/Controllers/FranchiseDirectoryController.php:811
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • BusinessListingService.php#615hattch2022prod24.24msselect 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 36
      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#615hattch2022prod2.62msselect * from `brands` where `brands`.`id` in (7017911, 7017912, 7017916, 7017924, 7017925, 7017926)
      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#615hattch2022prod5.62msselect * from `homepages` where `homepages`.`brand_id` in (7017911, 7017912, 7017916, 7017924, 7017925, 7017926)
      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#615hattch2022prod13.41msselect * from `industries` where `industries`.`id` in (1, 2, 3, 5, 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#615hattch2022prod7.15msselect * 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.47msselect `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#870hattch2022prod5.05msselect 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` = '3978' and `post_codes`.`state` = 'VIC' and `post_codes`.`suburb` in ('Clyde North', 'Clyde-north') and `listings`.`status` = 'open' and (`brands`.`industry_id` = 5 or `brands`.`secondary_industry_id` = 5)
      Bindings
      • 0: 3978
      • 1: VIC
      • 2: Clyde North
      • 3: Clyde-north
      • 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#34hattch2022prod6.12msselect `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.03msselect 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(-38.10008)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(145.3588)) + sin(radians(-38.10008)) * 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 <= 100) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 5
      • 3: 5
      • 4: 100
      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.47msselect 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(-38.10008)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(145.3588)) + sin(radians(-38.10008)) * 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 <= 100 order by `distance_km` asc limit 36 offset 36
      Bindings
      • 0: open
      • 1: 1
      • 2: 5
      • 3: 5
      • 4: 100
      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.98msselect * 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#1488hattch2022prod3.8msselect * 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#1488hattch2022prod5.23msselect * 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#1488hattch2022prod5.97msselect * from `post_codes` where `post_codes`.`id` in (4680, 4685, 4687, 4773, 4861, 4862, 4868, 4869, 4870, 5293, 5863, 6138, 6193, 6195, 6196, 6198, 6200, 6204, 6206, 6363, 6364, 6422, 6424, 6702, 6706, 6850, 6851, 7254, 7307)
      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.83msselect * from `brands` where `id` in (7017959, 7017924, 7017929, 7017943, 7017964)
      Bindings
      • 0: 7017959
      • 1: 7017924
      • 2: 7017929
      • 3: 7017943
      • 4: 7017964
      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.44msselect * from `post_codes` where `id` in (4862, 6851, 4869, 4861, 6138, 6850, 4868, 6702, 6198, 4870, 7307, 6193, 6706, 4680, 6195, 6196, 7254, 6424, 6204, 6200, 5863, 4685, 5293, 4773, 6422, 4687, 6206, 6363, 6364)
      Bindings
      • 0: 4862
      • 1: 6851
      • 2: 4869
      • 3: 4861
      • 4: 6138
      • 5: 6850
      • 6: 4868
      • 7: 6702
      • 8: 6198
      • 9: 4870
      • 10: 7307
      • 11: 6193
      • 12: 6706
      • 13: 4680
      • 14: 6195
      • 15: 6196
      • 16: 7254
      • 17: 6424
      • 18: 6204
      • 19: 6200
      • 20: 5863
      • 21: 4685
      • 22: 5293
      • 23: 4773
      • 24: 6422
      • 25: 4687
      • 26: 6206
      • 27: 6363
      • 28: 6364
      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.49msselect * from `categories` where `id` in (3, 1)
      Bindings
      • 0: 3
      • 1: 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#1287hattch2022prod5.75msselect * 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#1295hattch2022prod3.51msselect * from `survey_questions` where `brand_id` in (7017959, 7017924, 7017929, 7017943, 7017964) and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017959
      • 1: 7017924
      • 2: 7017929
      • 3: 7017943
      • 4: 7017964
      • 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#1301hattch2022prod5.12msselect * from `homepages` where `brand_id` in (7017959, 7017924, 7017929, 7017943, 7017964)
      Bindings
      • 0: 7017959
      • 1: 7017924
      • 2: 7017929
      • 3: 7017943
      • 4: 7017964
      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.39msselect `industry_slug`, `industry` from `industries`
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:1123
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FranchiseDirectoryController.php#1136hattch2022prod2.46msselect `postcode` from `post_codes` where `postcode` = '3978' limit 10
      Bindings
      • 0: 3978
      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#1139hattch2022prod5.57msselect * from `post_codes` where `postcode` in ('3978', 3978, 3978, 3978)
      Bindings
      • 0: 3978
      • 1: 3978
      • 2: 3978
      • 3: 3978
      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.44msselect * from `post_codes` where `id` = 5101 limit 1
      Bindings
      • 0: 5101
      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.37msselect * 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#320hattch2022prod3.54msselect * 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.37msselect * from `post_codes` where `id` = 5101 limit 1
      Bindings
      • 0: 5101
      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.48msselect * 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#50hattch2022prod8.9msselect * from `post_codes` where `id` = 5101 limit 1
      Bindings
      • 0: 5101
      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#99hattch2022prod4.88msSELECT 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#118hattch2022prod22.35msSELECT 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#172hattch2022prod5.74msselect * 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
    78Listing.php#?
    App\Models\PostCode
    31PostCode.php#?
    App\Models\Industry
    28Industry.php#?
    App\Models\Brand
    11Brand.php#?
    App\Models\Homepage
    11Homepage.php#?
    App\Models\FranchiseType
    4FranchiseType.php#?
    App\Models\Category
    3Category.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-07-03 18:50:46GET/businesses-for-sale/within-construction-automotive/in-clyde-north-vic-3978?distance=100&page=2+502551166