429 Construction or Automotive businesses for sale in Chirnside Park VIC 3116

429 businesses for sale

Couriers Please: Run 46 (Vic)

(more)

Total Investment: From $50K

Business Type: New Franchise

Smith & Sons: Caulfield

(more)

Total Investment: From $50K

Business Type: New Franchise

Smith & Sons: Fitzroy

Fitzroy, VIC 3065 32.0 km away

(more)

Total Investment: From $50K

Business Type: New Franchise

Couriers Please: Run 68

(more)

Total Investment: From $50K

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

Total Fitouts: Narre Warren

Total Fitouts seeks to establish its first franchise in Narre Warren, a rapidly expanding commercial hub in Melbourne's southeast growth corridor. Located just 40km from Melbourne'...(more)

Total Investment: From $50K

Business Type: New Franchise

Total Fitouts: Brunswick

(more)

Total Investment: From $50K

Business Type: New Franchise

Smith & Sons: Brunswick

(more)

Total Investment: From $50K

Business Type: New Franchise

Smith & Sons: Bentleigh

(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: Keysborough

(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

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 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 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

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: Cheltenham

(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: Pascoe Vale

(more)

Total Investment: From $50K

Business Type: New Franchise

Smith & Sons: Beaconsfield

(more)

Total Investment: From $50K

Business Type: New Franchise

G.J. Gardner Homes: Casey

(more)

Total Investment: From $500K

Business Type: New Franchise

Couriers Please: Run 231 (Vic)

(more)

Total Investment: From $25K

Business Type: Franchise Resale

Total Fitouts: Flemington

(more)

Total Investment: From $50K

Business Type: New Franchise

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

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 134 (Vic)

(more)

Total Investment: From $50K

Business Type: New Franchise

G.J. Gardner Homes: Westmeadows

(more)

Total Investment: From $500K

Business Type: New Franchise

Freedom Cars: Airport West

(more)

Total Investment: From $100K

Business Type: New Franchise

G.J. Gardner Homes: Craigieburn

(more)

Total Investment: From $500K

Business Type: New Franchise

Freedom Cars: Craigieburn

(more)

Total Investment: From $50K

Business Type: New Franchise

Smith & Sons: Patterson Lake

(more)

Total Investment: From $50K

Business Type: New Franchise

Total Fitouts: Tullamarine

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

G.J. Gardner Homes: Pakenham

(more)

Total Investment: From $500K

Business Type: New Franchise

Freedom Cars: Williamstown

(more)

Total Investment: From $50K

Business Type: New Franchise

SettingsRequest history427msRequest 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-chirnside-...
action_name
directory.industry-location-search.single
controller_action
App\Http\Controllers\FranchiseDirectoryController@showFilteredListings
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
  • infolog[18:37:56] LOG.info: ValidateBusinessListingUrl processing request { "path": "businesses-for-sal...
  • infolog[18:37:56] LOG.info: Route has location parameter, passing through { "location": "chirnside-park...
  • infolog[18:37:56] LOG.info: Processing single location parameter { "location": "chirnside-park-vic-3116...
  • infolog[18:37:56] LOG.info: Successfully parsed location parameter { "location": "chirnside-park-vic-31...
  • infolog[18:37:56] LOG.info: Cookie debugging in FranchiseDirectoryController { "path": "businesses-for-...
  • infolog[18:37:56] LOG.info: Parameters received: { "industry": "construction-automotive", "franchis...
  • infolog[18:37:56] LOG.info: User is not authenticated on filtered listings page { "host": "directory.te...
  • infolog[18:37:57] LOG.info: Populated filter arrays from parsed location { "suburb": "chirnside-park", ...
  • infolog[18:37:57] LOG.info: Starting getFilteredListings with filters: { "locations": [], "business...
  • infolog[18:37:57] LOG.info: Applying industry filter: { "industry": "construction-automotive" }
  • infolog[18:37:57] LOG.info: Using single known industry: { "industry": "construction-automotive" }
  • infolog[18:37:57] LOG.info: Applying location filters: { "suburb": [ "chirnside-park" ], ...
  • infolog[18:37:57] LOG.info: Using postcodes for filtering: { "postcodes": [ "3116" ] }
  • infolog[18:37:57] LOG.info: Including nearby postcodes: { "count": 16, "postcodes": [ 3116,...
  • infolog[18:37:57] LOG.info: Adding distance_km to select for sorting by distance
  • debuglog[18:37:57] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.*, `brands`.`id` as ...
  • infolog[18:37:57] LOG.info: Successfully retrieved listings { "total": 5, "per_page": 36, "curr...
  • infolog[18:37:57] LOG.info: Listings retrieved: { "count": 0, "total": 5 }
  • infolog[18:37:57] LOG.info: Brand IDs found: { "ids": [] }
  • infolog[18:37:57] LOG.info: Retrieved postcode record for brand filters: { "postcode": "3116", "has...
  • infolog[18:37:57] LOG.info: Adding coordinates to brand filters for distance search: { "lat": "-37.7419...
  • infolog[18:37:57] LOG.info: Setting distance parameter for brands: { "max_distance": 99999 }
  • infolog[18:37:57] LOG.info: Local brand count check (exact postcode): { "postcode": "3116", "localB...
  • infolog[18:37:57] LOG.info: Starting getFilteredBrands with filters: { "locations": [], "businessTy...
  • infolog[18:37:57] LOG.info: Applying industry filter: { "industry": "construction-automotive" }
  • infolog[18:37:57] LOG.info: Using single known industry: { "industry": "construction-automotive" }
  • infolog[18:37:57] LOG.info: Using coordinates for distance-based search: { "lat": -37.74195, "lng":...
  • debuglog[18:37:57] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:37:57] LOG.info: Successfully retrieved brands { "total": 8, "per_page": 36, "curren...
  • infolog[18:37:57] LOG.info: Postcode found: { "id": 7242, "suburb": "Chirnside Park" }
  • infolog[18:37:57] LOG.info: Final postcodeArray before passing to view: { "postcodeArray": [ { ...
  • infolog[18:37:57] LOG.info: Starting getDefaultListings without filters
  • debuglog[18:37:57] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.* from `listings` in...
  • infolog[18:37:57] LOG.info: Successfully retrieved listings { "total": 2552, "per_page": 36, "c...
  • infolog[18:37:57] LOG.info: Starting getDefaultBrands without filters
  • debuglog[18:37:57] LOG.debug: Final SQL query for brands: { "sql": "select distinct `brands`.`id`, `bran...
  • infolog[18:37:57] LOG.info: Successfully retrieved listings { "total": 42, "per_page": 36, "cur...
  • infolog[18:37:57] LOG.info: Exact location listing count { "suburb": "chirnside-park", "state": "VI...
  • infolog[18:37:57] LOG.info: Starting getNearbyListings with filters: { "locations": [], "businessTy...
  • infolog[18:37:57] LOG.info: Applying industry filter: { "industry": "construction-automotive" }
  • infolog[18:37:57] LOG.info: Using where for single industry { "industry": "construction-automotive" }
  • debuglog[18:37:57] LOG.debug: Final SQL query for nearby listings: { "sql": "select distinct `listings`....
  • infolog[18:37:57] LOG.info: Successfully retrieved nearby listings { "total": 429, "per_page": 36, ...
  • infolog[18:37:57] LOG.info: Display flags: { "hasExactLocationSearch": true, "originalBrandCount": ...
  • infolog[18:37:57] LOG.info: Getting industry IDs from slug { "slug": "construction-automotive" }
  • infolog[18:37:57] LOG.info: Found industry from direct lookup { "slug": "construction-automotive", ...
  • infolog[18:37:57] LOG.info: Final industry IDs from slug { "slug": "construction-automotive", "ids"...
  • infolog[18:37:57] LOG.info: View data prepared successfully
status
200 OK
full_url
http://directory.testing.hattch.net/businesses-for-sale/within-construction-automotive/in-chirnside-...
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
429ms
peak_memory
8MB
response
text/html; charset=UTF-8
request_format
html
request_query
0 of 0
array:2 [ "distance" => "99999" "page" => "2" ]
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-68664164-2a4257027ca9d5775cca385b" ] "host" => array:1 [ 0 => "directory.testing.hattch.net" ] "x-forwarded-port" => array:1 [ 0 => "80" ] "x-forwarded-proto" => array:1 [ 0 => "http" ] "x-forwarded-for" => array:1 [ 0 => "10.1.3.136, 216.73.216.89" ] ]
request_cookies
[]
response_headers
0 of 0
array:3 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Thu, 03 Jul 2025 08:37:57 GMT" ] ]
session_attributes
0 of 0
array:1 [ "_token" => "ILiFz1SjeHqiVYvkXc7Kpp0nGe7e5GIQAIgb37NM" ]
  • Booting (44.96ms)time
  • Application (382ms)time
  • Routing (1.71ms)
  • 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.46%)
    382ms
    1 x Booting (10.53%)
    44.96ms
    1 x Routing (0.4%)
    1.71ms
    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
    48 statements were executed (11 duplicates)Show only duplicates302ms
    • 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#328hattch2022prod23.12msselect 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.52msselect `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#34hattch2022prod3.22msselect `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#267hattch2022prod3.23msselect `to_postcode` from `distances` where `from_postcode` in ('3116') order by `distance_km` asc
      Bindings
      • 0: 3116
      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.93msselect 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 ('3116') 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 (3116, 3116, 3115, 3136, 3138, 3134, 3140, 3113, 3137, 3765, 3796, 3097, 3114, 3135, 3153, '3116')
      Bindings
      • 0: 3116
      • 1: open
      • 2: 1
      • 3: 5
      • 4: 5
      • 5: 3116
      • 6: 3116
      • 7: 3115
      • 8: 3136
      • 9: 3138
      • 10: 3134
      • 11: 3140
      • 12: 3113
      • 13: 3137
      • 14: 3765
      • 15: 3796
      • 16: 3097
      • 17: 3114
      • 18: 3135
      • 19: 3153
      • 20: 3116
      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.66msselect 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 ('3116') 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 (3116, 3116, 3115, 3136, 3138, 3134, 3140, 3113, 3137, 3765, 3796, 3097, 3114, 3135, 3153, '3116') order by CASE WHEN post_codes.postcode IN ('3116') THEN 0 ELSE 1 END, `distances`.`distance_km` asc, `post_codes`.`postcode` asc limit 36 offset 36
      Bindings
      • 0: 3116
      • 1: open
      • 2: 1
      • 3: 5
      • 4: 5
      • 5: 3116
      • 6: 3116
      • 7: 3115
      • 8: 3136
      • 9: 3138
      • 10: 3134
      • 11: 3140
      • 12: 3113
      • 13: 3137
      • 14: 3765
      • 15: 3796
      • 16: 3097
      • 17: 3114
      • 18: 3135
      • 19: 3153
      • 20: 3116
      • 21: 3116
      Backtrace
      • app/Services/BusinessListingService.php:446
      • app/Http/Controllers/FranchiseDirectoryController.php:547
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#624hattch2022prod2.43msselect * from `post_codes` where `postcode` = '3116' limit 1
      Bindings
      • 0: 3116
      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.65msselect `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#730hattch2022prod3.23msselect 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` = '3116' and (`brands`.`industry_id` = 5 or `brands`.`secondary_industry_id` = 5)
      Bindings
      • 0: open
      • 1: 1
      • 2: 3116
      • 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.06msselect `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#1053hattch2022prod9.15msselect 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.74195)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(145.31482)) + sin(radians(-37.74195)) * 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`) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 5
      • 3: 5
      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#1053hattch2022prod9.79msselect 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.74195)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(145.31482)) + sin(radians(-37.74195)) * 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` order by MIN((6751 * acos(cos(radians(-37.74195)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(145.31482)) + sin(radians(-37.74195)) * sin(radians(post_codes.lat))))) asc limit 36 offset 36
      Bindings
      • 0: open
      • 1: 1
      • 2: 5
      • 3: 5
      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.6msselect * from `post_codes` where `suburb` in ('Chirnside Park', 'Chirnside-park') and `state` = 'VIC' and `postcode` = '3116' limit 1
      Bindings
      • 0: Chirnside Park
      • 1: Chirnside-park
      • 2: VIC
      • 3: 3116
      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#498hattch2022prod20.17msselect 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.5msselect 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.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#615hattch2022prod19.98msselect 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.65msselect * 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#615hattch2022prod4.84msselect * 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#615hattch2022prod2.47msselect * 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#615hattch2022prod2.35msselect * from `post_codes` where 0 = 1
      Backtrace
      • app/Services/BusinessListingService.php:615
      • app/Http/Controllers/FranchiseDirectoryController.php:811
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#856hattch2022prod5.65msselect `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#870hattch2022prod13.49msselect 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` = '3116' and `post_codes`.`state` = 'VIC' and `post_codes`.`suburb` in ('Chirnside Park', 'Chirnside-park') and `listings`.`status` = 'open' and (`brands`.`industry_id` = 5 or `brands`.`secondary_industry_id` = 5)
      Bindings
      • 0: 3116
      • 1: VIC
      • 2: Chirnside Park
      • 3: Chirnside-park
      • 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#34hattch2022prod2.3msselect `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#1488hattch2022prod4.78msselect count(*) as aggregate from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and (`brands`.`industry_id` in (5) or `brands`.`secondary_industry_id` in (5))
      Bindings
      • 0: open
      • 1: 1
      • 2: 5
      • 3: 5
      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#1488hattch2022prod11.04msselect 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.74195)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(145.31482)) + sin(radians(-37.74195)) * 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)) order by `distance_km` asc limit 36 offset 36
      Bindings
      • 0: open
      • 1: 1
      • 2: 5
      • 3: 5
      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.54msselect * 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.68msselect * 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.4msselect * 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#1488hattch2022prod2.62msselect * from `post_codes` where `post_codes`.`id` in (4819, 4882, 5056, 5060, 5078, 5079, 5472, 5480, 5669, 5863, 5906, 5909, 5913, 5970, 6193, 6195, 6196, 6198, 6200, 6204, 6206, 6363, 6364, 6369, 6422, 6424, 6426, 6702, 6706, 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.72msselect * from `brands` where `id` in (7017959, 7017929, 7017943, 7017964, 7017924)
      Bindings
      • 0: 7017959
      • 1: 7017929
      • 2: 7017943
      • 3: 7017964
      • 4: 7017924
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:1264
      • app/Http/Controllers/FranchiseDirectoryController.php:1097
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FranchiseDirectoryController.php#1270hattch2022prod2.69msselect * from `post_codes` where `id` in (6424, 5472, 7254, 6198, 5078, 6422, 5480, 6193, 5669, 6702, 6195, 6200, 6706, 4819, 6196, 6426, 5060, 5079, 6363, 6206, 6364, 6204, 5909, 5906, 6369, 5913, 5970, 4882, 5056, 5863)
      Bindings
      • 0: 6424
      • 1: 5472
      • 2: 7254
      • 3: 6198
      • 4: 5078
      • 5: 6422
      • 6: 5480
      • 7: 6193
      • 8: 5669
      • 9: 6702
      • 10: 6195
      • 11: 6200
      • 12: 6706
      • 13: 4819
      • 14: 6196
      • 15: 6426
      • 16: 5060
      • 17: 5079
      • 18: 6363
      • 19: 6206
      • 20: 6364
      • 21: 6204
      • 22: 5909
      • 23: 5906
      • 24: 6369
      • 25: 5913
      • 26: 5970
      • 27: 4882
      • 28: 5056
      • 29: 5863
      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.44msselect * 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#1287hattch2022prod2.68msselect * 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#1295hattch2022prod17.56msselect * from `survey_questions` where `brand_id` in (7017959, 7017929, 7017943, 7017964, 7017924) and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017959
      • 1: 7017929
      • 2: 7017943
      • 3: 7017964
      • 4: 7017924
      • 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.22msselect * from `homepages` where `brand_id` in (7017959, 7017929, 7017943, 7017964, 7017924)
      Bindings
      • 0: 7017959
      • 1: 7017929
      • 2: 7017943
      • 3: 7017964
      • 4: 7017924
      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.56msselect `postcode` from `post_codes` where `postcode` = '3116' limit 10
      Bindings
      • 0: 3116
      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.04msselect * from `post_codes` where `postcode` in ('3116', 3116)
      Bindings
      • 0: 3116
      • 1: 3116
      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.63msselect * from `post_codes` where `id` = 7242 limit 1
      Bindings
      • 0: 7242
      Backtrace
      • view::pages.home.breadcrumb:60
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • frontpage-layout.blade.php#257hattch2022prod3.96msselect * 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.13msselect * 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#383hattch2022prod6.32msselect * from `post_codes` where `id` = 7242 limit 1
      Bindings
      • 0: 7242
      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#416hattch2022prod3.7msselect * 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.4msselect * from `post_codes` where `id` = 7242 limit 1
      Bindings
      • 0: 7242
      Backtrace
      • view::pages.home.partials.header-filters:50
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • header-filters.blade.php#99hattch2022prod3.86msSELECT 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.41msSELECT 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#172hattch2022prod6.47msselect * 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
    32PostCode.php#?
    App\Models\Industry
    20Industry.php#?
    App\Models\Brand
    11Brand.php#?
    App\Models\Homepage
    11Homepage.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-07-03 18:37:57GET/businesses-for-sale/within-construction-automotive/in-chirnside-park-vic-3116?distance=99999&page=2482548152