10 businesses for sale in Kellyville NSW 2155 from $200,000 to $10,000,000

business for sale REVL logo

REVL: Kellyville

(more)

Total Investment: From $200K

Business Type: New Franchise

business for sale San Churro logo

San Churro: Stanhope Gardens

(more)

Total Investment: From $300K

Business Type: New Franchise

business for sale San Churro logo

San Churro: Rouse Hill

(more)

Total Investment: From $300K

Business Type: New Franchise

business for sale REVL logo

REVL: The Ponds

(more)

Total Investment: From $200K

Business Type: New Franchise

business for sale San Churro logo

San Churro: Norwest

(more)

Total Investment: From $300K

Business Type: New Franchise

business for sale Muffin Break logo

Muffin Break: Norwest Marketown

(more)

Total Investment: From $200K

Business Type: New Franchise

business for sale Muffin Break logo

Muffin Break: Castle Towers

Launch your business future with Muffin Break in Castle Hill, one of Sydney's fastest-growing commercial and residential hubs. Located in Sydney's thriving Hills District, Castle H...(more)

Total Investment: From $200K

Business Type: New Franchise

business for sale REVL logo

REVL: Baulkham Hills

(more)

Total Investment: From $200K

Business Type: New Franchise

business for sale REVL logo

REVL: Marayong

(more)

Total Investment: From $200K

Business Type: New Franchise

business for sale REVL logo

REVL: Cherrybrook

(more)

Total Investment: From $200K

Business Type: New Franchise

Want to see more listings?

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

business for sale hattch logo mobile
SettingsRequest history2558msRequest Duration6MBMemory Usage9.x
Laravel Version
9.52.20
PHP Version
8.2.28
Environment
local
Debug Mode
Enabled
URL
testing.hattch.net
Timezone
Australia/Melbourne
Locale
en
GET {viewType}/between-{minInvestment}-{maxInvestment}/in-{suburb}-{state}-{postcode}
status
200 OK
full_url
http://directory.testing.hattch.net/businesses-for-sale/between-200000-10000000/in-kellyville-nsw-21...
action_name
directory.investment-location-search
controller_action
App\Http\Controllers\FranchiseDirectoryController@showFilteredListings
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
  • infolog[22:49:14] LOG.info: Cookie debugging in FranchiseDirectoryController { "path": "businesses-for-...
  • infolog[22:49:14] LOG.info: Parameters received: { "industry": "businesses-for-sale", "franchiseTyp...
  • infolog[22:49:14] LOG.info: User is not authenticated on filtered listings page { "host": "directory.te...
  • infolog[22:49:14] LOG.info: Starting getFilteredListings with filters: { "locations": [], "business...
  • infolog[22:49:14] LOG.info: Applying min investment filter: { "min": 200000 }
  • infolog[22:49:14] LOG.info: Applying max investment filter: { "max": 10000000 }
  • infolog[22:49:14] LOG.info: Applying location filters: { "suburb": [ "kellyville" ], "s...
  • infolog[22:49:14] LOG.info: Using postcodes for filtering: { "postcodes": [ "2155" ] }
  • infolog[22:49:14] LOG.info: Including nearby postcodes: { "count": 15, "postcodes": [ 2155,...
  • infolog[22:49:14] LOG.info: Adding distance_km to select for sorting by distance
  • debuglog[22:49:14] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.*, `brands`.`id` as ...
  • infolog[22:49:14] LOG.info: Successfully retrieved listings { "total": 15, "per_page": 36, "cur...
  • infolog[22:49:14] LOG.info: Listings retrieved: { "count": 15, "total": 15 }
  • infolog[22:49:14] LOG.info: Brand IDs found: { "ids": { "0": 7017941, "1": 7017918, ...
  • infolog[22:49:14] LOG.info: Starting getFilteredBrands with filters: { "locations": [], "businessTy...
  • infolog[22:49:14] LOG.info: Applying min investment filter: { "min": 200000 }
  • infolog[22:49:14] LOG.info: Applying max investment filter: { "max": 10000000 }
  • infolog[22:49:14] LOG.info: Applying location filters: { "suburb": [ "kellyville" ], "s...
  • infolog[22:49:14] LOG.info: Using postcodes for filtering brands: { "postcodes": [ "2155" ]...
  • infolog[22:49:14] LOG.info: Including nearby postcodes for brands: { "count": 15, "postcodes": [ ...
  • infolog[22:49:14] LOG.info: Adding distance_km to select for sorting by distance
  • debuglog[22:49:14] LOG.debug: Final SQL query for brands: { "sql": "select distinct `listings`.*, `brand...
  • infolog[22:49:14] LOG.info: Successfully retrieved brands { "total": 3, "per_page": 36, "curren...
  • infolog[22:49:14] LOG.info: Postcode found: { "id": 209 }
  • infolog[22:49:14] LOG.info: Starting getDefaultListings without filters
  • debuglog[22:49:14] LOG.debug: Final SQL query: { "sql": "select distinct `listings`.* from `listings` in...
  • infolog[22:49:14] LOG.info: Successfully retrieved listings { "total": 2552, "per_page": 36, "c...
  • infolog[22:49:14] LOG.info: Starting getDefaultBrands without filters
  • debuglog[22:49:14] LOG.debug: Final SQL query for brands: { "sql": "select distinct `listings`.*, `brand...
  • infolog[22:49:15] LOG.info: Successfully retrieved listings { "total": 42, "per_page": 36, "cur...
  • infolog[22:49:15] LOG.info: Starting getNearbyListings with filters: { "locations": [], "businessTy...
  • infolog[22:49:15] LOG.info: Applying min investment filter: { "min": 200000 }
  • infolog[22:49:15] LOG.info: Applying max investment filter: { "max": 10000000 }
  • debuglog[22:49:15] LOG.debug: Final SQL query for nearby listings: { "sql": "select distinct `listings`....
  • infolog[22:49:15] LOG.info: Successfully retrieved nearby listings { "total": 10, "per_page": 36, ...
  • infolog[22:49:15] LOG.info: View data prepared successfully
status
200 OK
full_url
http://directory.testing.hattch.net/businesses-for-sale/between-200000-10000000/in-kellyville-nsw-21...
action_name
directory.investment-location-search
controller_action
App\Http\Controllers\FranchiseDirectoryController@showFilteredListings
uri
GET {viewType}/between-{minInvestment}-{maxInvestment}/in-{suburb}-{state}-{postcode}
domain
directory.testing.hattch.net
controller
App\Http\Controllers\FranchiseDirectoryController@showFilteredListings
file
app/Http/Controllers/FranchiseDirectoryController.php:91-758
middleware
web, lowercase.state, validate.business.url
duration
563ms
peak_memory
12MB
response
text/html; charset=UTF-8
request_format
html
request_query
0 of 0
array:10 [ "validated_suburb" => "kellyville" "validated_state" => "nsw" "validated_state_upper" => "NSW" "validated_postcode" => "2155" "validated_industry" => null "validated_business_type" => null "validated_min_investment" => 200000 "validated_max_investment" => 10000000 "validated_franchise_type" => null "validated_category" => null ]
request_request
[]
request_headers
0 of 0
array:20 [ "cookie" => array:1 [ 0 => "XSRF-TOKEN=XONjjGi3QI9PxduhcNuZZ50lCJateefHORzvnpuN; hattch_test_session=IL1tFpAelYTK2GJ898i9YpYjYHFyGztqB5mY3n70" ] "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "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" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "x-amzn-trace-id" => array:1 [ 0 => "Root=1-682f1d4a-1db9c56a2c3777bf4c48a95f" ] "host" => array:1 [ 0 => "directory.testing.hattch.net" ] "x-forwarded-port" => array:1 [ 0 => "443" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "x-forwarded-for" => array:1 [ 0 => "18.117.120.35" ] ]
request_cookies
0 of 0
array:2 [ "XSRF-TOKEN" => "XONjjGi3QI9PxduhcNuZZ50lCJateefHORzvnpuN" "hattch_test_session" => "IL1tFpAelYTK2GJ898i9YpYjYHFyGztqB5mY3n70" ]
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, 22 May 2025 12:49:15 GMT" ] ]
session_attributes
0 of 0
array:4 [ "_token" => "XONjjGi3QI9PxduhcNuZZ50lCJateefHORzvnpuN" "PHPDEBUGBAR_STACK_DATA" => array:1 [ "01JVW0MTRERQ3TH0931BZW9ZW7" => null ] "_previous" => array:1 [ "url" => "http://directory.testing.hattch.net/businesses-for-sale/between-200000-10000000/in-kellyville-NSW-2155?page=22" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
  • Booting (22.48ms)time
  • Application (535ms)time
  • Routing (2.39ms)
  • View: pages.home.brandviews
  • View: pages.home.breadcrumbviews
  • View: pages.widget.brand_survey_bannerviews
  • View: pages.home.header_main_newviews
  • View: pages.widget.summaryviews
  • View: brand.common.frontpage-layoutviews
  • View: brand.common.tracking-codesviews
  • 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: layouts.common.footerviews
  • 1 x Application (95.97%)
    535ms
    1 x Booting (4.03%)
    22.48ms
    1 x Routing (0.43%)
    2.39ms
    17 x View (0%)
    0μs
    17 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.home.header_main_newheader_main_new.blade.php#?blade
    • pages.widget.summarysummary.blade.php#?blade
    • brand.common.frontpage-layoutfrontpage-layout.blade.php#?blade
    • brand.common.tracking-codestracking-codes.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
    • layouts.common.footerfooter.blade.php#?blade
    126 statements were executed (89 duplicates)Show only duplicateshattch2022prod409ms
    • # Query soft limit for Debugbar is reached after 100 queries, additional 26 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • ValidateBusinessListingUrl.php#613hattch2022prodConnection Established
      Backtrace
      • middleware::validate.business.url:613
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
      • middleware::lowercase.state:28
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
    • ValidateBusinessListingUrl.php#622hattch2022prod3.98msselect exists(select * from `post_codes` where (`suburb` = 'kellyville' and `postcode` = '2155' and (`state` = 'NSW' or `state` = 'nsw'))) as `exists`
      Bindings
      • 0: kellyville
      • 1: 2155
      • 2: NSW
      • 3: nsw
      Backtrace
      • middleware::validate.business.url:622
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
      • middleware::lowercase.state:28
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
    • BusinessListingService.php#214hattch2022prod8.18msselect `to_postcode` from `distances` where `from_postcode` in ('2155') order by `distance_km` asc
      Bindings
      • 0: 2155
      Backtrace
      • app/Services/BusinessListingService.php:214
      • app/Http/Controllers/FranchiseDirectoryController.php:474
      • 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#335hattch2022prod12.75msselect 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 ('2155') where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and `listings`.`min_investment` >= 200000 and `listings`.`min_investment` <= 10000000 and `post_codes`.`postcode` in (2155, 2155, 2768, 2156, 2769, 2154, 2763, 2153, 2762, 2147, 2148, 2158, 2126, 2765, '2155')
      Bindings
      • 0: 2155
      • 1: open
      • 2: 1
      • 3: 200000
      • 4: 10000000
      • 5: 2155
      • 6: 2155
      • 7: 2768
      • 8: 2156
      • 9: 2769
      • 10: 2154
      • 11: 2763
      • 12: 2153
      • 13: 2762
      • 14: 2147
      • 15: 2148
      • 16: 2158
      • 17: 2126
      • 18: 2765
      • 19: 2155
      Backtrace
      • app/Services/BusinessListingService.php:335
      • app/Http/Controllers/FranchiseDirectoryController.php:474
      • 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#335hattch2022prod22.17msselect 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 ('2155') where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and `listings`.`min_investment` >= 200000 and `listings`.`min_investment` <= 10000000 and `post_codes`.`postcode` in (2155, 2155, 2768, 2156, 2769, 2154, 2763, 2153, 2762, 2147, 2148, 2158, 2126, 2765, '2155') order by CASE WHEN post_codes.postcode IN ('2155') THEN 0 ELSE 1 END, `distances`.`distance_km` asc, `post_codes`.`postcode` asc limit 36 offset 0
      Bindings
      • 0: 2155
      • 1: open
      • 2: 1
      • 3: 200000
      • 4: 10000000
      • 5: 2155
      • 6: 2155
      • 7: 2768
      • 8: 2156
      • 9: 2769
      • 10: 2154
      • 11: 2763
      • 12: 2153
      • 13: 2762
      • 14: 2147
      • 15: 2148
      • 16: 2158
      • 17: 2126
      • 18: 2765
      • 19: 2155
      • 20: 2155
      Backtrace
      • app/Services/BusinessListingService.php:335
      • app/Http/Controllers/FranchiseDirectoryController.php:474
      • 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#335hattch2022prod1.01msselect * from `brands` where `brands`.`id` in (7017918, 7017941, 7017948)
      Backtrace
      • app/Services/BusinessListingService.php:335
      • app/Http/Controllers/FranchiseDirectoryController.php:474
      • 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#335hattch2022prod13.22msselect * from `homepages` where `homepages`.`brand_id` in (7017918, 7017941, 7017948)
      Backtrace
      • app/Services/BusinessListingService.php:335
      • app/Http/Controllers/FranchiseDirectoryController.php:474
      • 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#335hattch2022prod2.1msselect * from `industries` where `industries`.`id` in (1, 3) and `industries`.`deleted_at` is null
      Backtrace
      • app/Services/BusinessListingService.php:335
      • app/Http/Controllers/FranchiseDirectoryController.php:474
      • 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#335hattch2022prod860μsselect * from `post_codes` where `post_codes`.`id` in (206, 207, 208, 209, 213, 359, 368, 385, 1965, 4379)
      Backtrace
      • app/Services/BusinessListingService.php:335
      • app/Http/Controllers/FranchiseDirectoryController.php:474
      • 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#775hattch2022prod9.82msselect `to_postcode` from `distances` where `from_postcode` in ('2155') and `distance_km` <= 10 order by `distance_km` asc
      Bindings
      • 0: 2155
      • 1: 10
      Backtrace
      • app/Services/BusinessListingService.php:775
      • app/Http/Controllers/FranchiseDirectoryController.php:527
      • 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#913hattch2022prod21.08msselect count(*) as aggregate from (select distinct `listings`.*, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `brands`.`minimum_investment`, `brands`.`maximum_investment`, `brands`.`country_code`, `industries`.`industry`, `industries`.`industry_slug`, `post_codes`.`suburb`, `post_codes`.`state`, `post_codes`.`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` left join `distances` on `post_codes`.`postcode` = `distances`.`to_postcode` and `distances`.`from_postcode` in ('2155') where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and `listings`.`min_investment` >= 200000 and `listings`.`min_investment` <= 10000000 and `post_codes`.`postcode` in (2155, 2155, 2768, 2156, 2769, 2154, 2763, 2153, 2762, 2147, 2148, 2158, 2126, 2765, '2155') group by `brands`.`id`) as `aggregate_table`
      Bindings
      • 0: 2155
      • 1: open
      • 2: 1
      • 3: 200000
      • 4: 10000000
      • 5: 2155
      • 6: 2155
      • 7: 2768
      • 8: 2156
      • 9: 2769
      • 10: 2154
      • 11: 2763
      • 12: 2153
      • 13: 2762
      • 14: 2147
      • 15: 2148
      • 16: 2158
      • 17: 2126
      • 18: 2765
      • 19: 2155
      Backtrace
      • app/Services/BusinessListingService.php:913
      • app/Http/Controllers/FranchiseDirectoryController.php:527
      • 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#913hattch2022prod21.93msselect distinct `listings`.*, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `brands`.`minimum_investment`, `brands`.`maximum_investment`, `brands`.`country_code`, `industries`.`industry`, `industries`.`industry_slug`, `post_codes`.`suburb`, `post_codes`.`state`, `post_codes`.`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` left join `distances` on `post_codes`.`postcode` = `distances`.`to_postcode` and `distances`.`from_postcode` in ('2155') where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) and `listings`.`min_investment` >= 200000 and `listings`.`min_investment` <= 10000000 and `post_codes`.`postcode` in (2155, 2155, 2768, 2156, 2769, 2154, 2763, 2153, 2762, 2147, 2148, 2158, 2126, 2765, '2155') group by `brands`.`id` order by CASE WHEN post_codes.postcode IN ('2155') THEN 0 ELSE 1 END, `distances`.`distance_km` asc limit 36 offset 0
      Bindings
      • 0: 2155
      • 1: open
      • 2: 1
      • 3: 200000
      • 4: 10000000
      • 5: 2155
      • 6: 2155
      • 7: 2768
      • 8: 2156
      • 9: 2769
      • 10: 2154
      • 11: 2763
      • 12: 2153
      • 13: 2762
      • 14: 2147
      • 15: 2148
      • 16: 2158
      • 17: 2126
      • 18: 2765
      • 19: 2155
      • 20: 2155
      Backtrace
      • app/Services/BusinessListingService.php:913
      • app/Http/Controllers/FranchiseDirectoryController.php:527
      • 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#913hattch2022prod760μsselect * from `brands` where `brands`.`id` in (7017918, 7017941, 7017948)
      Backtrace
      • app/Services/BusinessListingService.php:913
      • app/Http/Controllers/FranchiseDirectoryController.php:527
      • 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#913hattch2022prod1.14msselect * from `homepages` where `homepages`.`brand_id` in (7017918, 7017941, 7017948)
      Backtrace
      • app/Services/BusinessListingService.php:913
      • app/Http/Controllers/FranchiseDirectoryController.php:527
      • 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#913hattch2022prod580μsselect * from `industries` where `industries`.`id` in (1, 3) and `industries`.`deleted_at` is null
      Backtrace
      • app/Services/BusinessListingService.php:913
      • app/Http/Controllers/FranchiseDirectoryController.php:527
      • 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#913hattch2022prod1.34msselect * from `post_codes` where `post_codes`.`id` in (206, 208, 385)
      Backtrace
      • app/Services/BusinessListingService.php:913
      • app/Http/Controllers/FranchiseDirectoryController.php:527
      • 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#541hattch2022prod880μsselect * from `post_codes` where `suburb` = 'kellyville' and `state` = 'NSW' and `postcode` = '2155' limit 1
      Bindings
      • 0: kellyville
      • 1: NSW
      • 2: 2155
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:541
      • 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#386hattch2022prod8.43msselect 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:386
      • app/Http/Controllers/FranchiseDirectoryController.php:551
      • 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#386hattch2022prod24.95msselect distinct `listings`.* from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) order by `post_codes`.`postcode` asc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      Backtrace
      • app/Services/BusinessListingService.php:386
      • app/Http/Controllers/FranchiseDirectoryController.php:551
      • 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#502hattch2022prod56.49msselect count(*) as aggregate from (select distinct `listings`.*, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `brands`.`minimum_investment`, `brands`.`maximum_investment`, `brands`.`country_code`, `industries`.`industry`, `industries`.`industry_slug`, `post_codes`.`suburb`, `post_codes`.`state`, `post_codes`.`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:502
      • app/Http/Controllers/FranchiseDirectoryController.php:552
      • 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#502hattch2022prod62.21msselect distinct `listings`.*, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `brands`.`minimum_investment`, `brands`.`maximum_investment`, `brands`.`country_code`, `industries`.`industry`, `industries`.`industry_slug`, `post_codes`.`suburb`, `post_codes`.`state`, `post_codes`.`postcode`, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_brand_logo")) as mobile_brand_logo, JSON_UNQUOTE(JSON_EXTRACT(homepages.section1, "$.mobile_listing_image")) as mobile_listing_image, JSON_UNQUOTE(JSON_EXTRACT(homepages.section2, "$.business_intro_subtext")) as business_intro_subtext from `listings` inner join `brands` on `listings`.`brand_id` = `brands`.`id` inner join `post_codes` on `listings`.`post_code_id` = `post_codes`.`id` inner join `industries` on `brands`.`industry_id` = `industries`.`id` left join `homepages` on `brands`.`id` = `homepages`.`brand_id` where `listings`.`status` = 'open' and (`homepages`.`page_published` = '1' or `homepages`.`page_published` is null) group by `brands`.`id` order by `listings`.`created_at` desc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      Backtrace
      • app/Services/BusinessListingService.php:502
      • app/Http/Controllers/FranchiseDirectoryController.php:552
      • 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#502hattch2022prod2.83msselect * from `brands` where `brands`.`id` in (7017918, 7017929, 7017930, 7017931, 7017932, 7017934, 7017937, 7017940, 7017941, 7017943, 7017944, 7017945, 7017946, 7017947, 7017948, 7017949, 7017950, 7017951, 7017953, 7017956, 7017959, 7017960, 7017962, 7017963, 7017964, 7017965, 7017967, 7017968, 7017969, 7017970, 7017971, 7017972, 7017973, 7017978, 7017981, 7017984)
      Backtrace
      • app/Services/BusinessListingService.php:502
      • app/Http/Controllers/FranchiseDirectoryController.php:552
      • 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#502hattch2022prod5.6msselect * from `homepages` where `homepages`.`brand_id` in (7017918, 7017929, 7017930, 7017931, 7017932, 7017934, 7017937, 7017940, 7017941, 7017943, 7017944, 7017945, 7017946, 7017947, 7017948, 7017949, 7017950, 7017951, 7017953, 7017956, 7017959, 7017960, 7017962, 7017963, 7017964, 7017965, 7017967, 7017968, 7017969, 7017970, 7017971, 7017972, 7017973, 7017978, 7017981, 7017984)
      Backtrace
      • app/Services/BusinessListingService.php:502
      • app/Http/Controllers/FranchiseDirectoryController.php:552
      • 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#502hattch2022prod2.14msselect * from `industries` where `industries`.`id` in (1, 2, 3, 4, 5, 6, 7, 8) and `industries`.`deleted_at` is null
      Backtrace
      • app/Services/BusinessListingService.php:502
      • app/Http/Controllers/FranchiseDirectoryController.php:552
      • 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#502hattch2022prod2.42msselect * from `post_codes` where `post_codes`.`id` in (41, 376, 1020, 2889, 3068, 3198, 3722, 4865, 5416, 5691, 5857, 5863, 6138, 6215, 6706, 6889, 7249, 7260, 7791, 7914, 8057, 8821, 9080, 12176, 12992, 14301, 14630, 15176, 15242)
      Backtrace
      • app/Services/BusinessListingService.php:502
      • app/Http/Controllers/FranchiseDirectoryController.php:552
      • 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#581hattch2022prod1.96msselect * from `post_codes` where `postcode` = '2155' limit 1
      Bindings
      • 0: 2155
      Backtrace
      • app/Http/Controllers/FranchiseDirectoryController.php:581
      • 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#1317hattch2022prod12.05msselect count(*) as aggregate from (select distinct `listings`.`id`, `listings`.`name`, `listings`.`overview`, `listings`.`min_investment`, `listings`.`max_investment`, `listings`.`new`, `listings`.`status`, `listings`.`post_code_id`, `listings`.`brand_id`, `listings`.`created_at`, `listings`.`updated_at`, `listings`.`category_id`, `brands`.`id` as `brand_id_relation`, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `industries`.`industry`, `industries`.`industry_slug`, `post_codes`.`suburb`, `post_codes`.`state`, `post_codes`.`postcode`, (6751 * acos(cos(radians(-33.69583)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(150.95622)) + sin(radians(-33.69583)) * 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 `listings`.`min_investment` >= 200000 and `listings`.`min_investment` <= 10000000 having distance_km <= 10) as `aggregate_table`
      Bindings
      • 0: open
      • 1: 1
      • 2: 200000
      • 3: 10000000
      • 4: 10
      Backtrace
      • app/Services/BusinessListingService.php:1317
      • app/Http/Controllers/FranchiseDirectoryController.php:599
      • 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#1317hattch2022prod10.43msselect distinct `listings`.`id`, `listings`.`name`, `listings`.`overview`, `listings`.`min_investment`, `listings`.`max_investment`, `listings`.`new`, `listings`.`status`, `listings`.`post_code_id`, `listings`.`brand_id`, `listings`.`created_at`, `listings`.`updated_at`, `listings`.`category_id`, `brands`.`id` as `brand_id_relation`, `brands`.`name` as `brand_name`, `brands`.`brand_subdomain`, `industries`.`industry`, `industries`.`industry_slug`, `post_codes`.`suburb`, `post_codes`.`state`, `post_codes`.`postcode`, (6751 * acos(cos(radians(-33.69583)) * cos(radians(post_codes.lat)) * cos(radians(post_codes.lng) - radians(150.95622)) + sin(radians(-33.69583)) * 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 `listings`.`min_investment` >= 200000 and `listings`.`min_investment` <= 10000000 having distance_km <= 10 order by `distance_km` asc limit 36 offset 0
      Bindings
      • 0: open
      • 1: 1
      • 2: 200000
      • 3: 10000000
      • 4: 10
      Backtrace
      • app/Services/BusinessListingService.php:1317
      • app/Http/Controllers/FranchiseDirectoryController.php:599
      • 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#1317hattch2022prod920μsselect * from `brands` where `brands`.`id` in (7017918, 7017941, 7017948)
      Backtrace
      • app/Services/BusinessListingService.php:1317
      • app/Http/Controllers/FranchiseDirectoryController.php:599
      • 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#1317hattch2022prod1.09msselect * from `homepages` where `homepages`.`brand_id` in (7017918, 7017941, 7017948)
      Backtrace
      • app/Services/BusinessListingService.php:1317
      • app/Http/Controllers/FranchiseDirectoryController.php:599
      • 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#1317hattch2022prod900μsselect * from `industries` where `industries`.`id` in (1, 3) and `industries`.`deleted_at` is null
      Backtrace
      • app/Services/BusinessListingService.php:1317
      • app/Http/Controllers/FranchiseDirectoryController.php:599
      • 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#1317hattch2022prod590μsselect * from `post_codes` where `post_codes`.`id` in (206, 207, 208, 209, 213, 359, 368, 1965, 4379)
      Backtrace
      • app/Services/BusinessListingService.php:1317
      • app/Http/Controllers/FranchiseDirectoryController.php:599
      • 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
    • breadcrumb.blade.php#60hattch2022prod600μsselect * from `post_codes` where `id` = 209 limit 1
      Bindings
      • 0: 209
      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
    • brand.blade.php#612hattch2022prod620μsselect * from `brands` where `id` = 7017918 limit 1
      Bindings
      • 0: 7017918
      Backtrace
      • view::pages.home.brand:612
      • 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
    • brand.blade.php#619hattch2022prod540μsselect * from `listings` where `id` = 4018332 limit 1
      Bindings
      • 0: 4018332
      Backtrace
      • view::pages.home.brand:619
      • 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
    • brand.blade.php#624hattch2022prod780μsselect * from `post_codes` where `id` = 209 limit 1
      Bindings
      • 0: 209
      Backtrace
      • view::pages.home.brand:624
      • 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
    • brand.blade.php#626hattch2022prod3.44msSELECT `listings`.`id`, `post_codes`.`postcode` as `postcode`, `listings`.`name` as `name` 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 `franchise_type_listing` ON `listings`.`id` = `franchise_type_listing`.`listing_id` INNER JOIN `homepages` ON `listings`.`brand_id` = `homepages`.`brand_id` WHERE 1=1 AND `listings`.`brand_id` = '7017918' GROUP BY listings.id ORDER BY `post_codes`.`postcode` ASC;
      Backtrace
      • view::pages.home.brand:626
      • 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
    • brand.blade.php#645hattch2022prod3.51msselect * from `survey_questions` where `brand_id` = 7017918 and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017918
      • 1: 1
      Backtrace
      • view::pages.home.brand:645
      • 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
    • brand.blade.php#652hattch2022prod3.18msselect * from `categories` where `id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • view::pages.home.brand:652
      • 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
    • brand.blade.php#657hattch2022prod1.46msselect * from `industries` where `id` = 3 limit 1
      Bindings
      • 0: 3
      Backtrace
      • view::pages.home.brand:657
      • 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
    • brand.blade.php#694hattch2022prod3.29msselect * from `opportunities` where `brand_id` = 7017918 and `user_id` = 0 limit 1
      Bindings
      • 0: 7017918
      • 1: 0
      Backtrace
      • view::pages.home.brand:694
      • 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
    • brand.blade.php#699hattch2022prod2.04msselect * from `homepages` where `brand_id` = 7017918 limit 1
      Bindings
      • 0: 7017918
      Backtrace
      • view::pages.home.brand:699
      • 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
    • brand.blade.php#612hattch2022prod1.9msselect * from `brands` where `id` = 7017941 limit 1
      Bindings
      • 0: 7017941
      Backtrace
      • view::pages.home.brand:612
      • 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
    • brand.blade.php#619hattch2022prod1.87msselect * from `listings` where `id` = 4019021 limit 1
      Bindings
      • 0: 4019021
      Backtrace
      • view::pages.home.brand:619
      • 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
    • brand.blade.php#624hattch2022prod1.71msselect * from `post_codes` where `id` = 368 limit 1
      Bindings
      • 0: 368
      Backtrace
      • view::pages.home.brand:624
      • 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
    • brand.blade.php#626hattch2022prod1.88msSELECT `listings`.`id`, `post_codes`.`postcode` as `postcode`, `listings`.`name` as `name` 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 `franchise_type_listing` ON `listings`.`id` = `franchise_type_listing`.`listing_id` INNER JOIN `homepages` ON `listings`.`brand_id` = `homepages`.`brand_id` WHERE 1=1 AND `listings`.`brand_id` = '7017941' GROUP BY listings.id ORDER BY `post_codes`.`postcode` ASC;
      Backtrace
      • view::pages.home.brand:626
      • 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
    • brand.blade.php#645hattch2022prod820μsselect * from `survey_questions` where `brand_id` = 7017941 and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017941
      • 1: 1
      Backtrace
      • view::pages.home.brand:645
      • 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
    • brand.blade.php#652hattch2022prod530μsselect * from `categories` where `id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • view::pages.home.brand:652
      • 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
    • brand.blade.php#657hattch2022prod520μsselect * from `industries` where `id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • view::pages.home.brand:657
      • 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
    • brand.blade.php#694hattch2022prod640μsselect * from `opportunities` where `brand_id` = 7017941 and `user_id` = 0 limit 1
      Bindings
      • 0: 7017941
      • 1: 0
      Backtrace
      • view::pages.home.brand:694
      • 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
    • brand.blade.php#699hattch2022prod870μsselect * from `homepages` where `brand_id` = 7017941 limit 1
      Bindings
      • 0: 7017941
      Backtrace
      • view::pages.home.brand:699
      • 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
    • brand.blade.php#612hattch2022prod680μsselect * from `brands` where `id` = 7017941 limit 1
      Bindings
      • 0: 7017941
      Backtrace
      • view::pages.home.brand:612
      • 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
    • brand.blade.php#619hattch2022prod620μsselect * from `listings` where `id` = 4019020 limit 1
      Bindings
      • 0: 4019020
      Backtrace
      • view::pages.home.brand:619
      • 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
    • brand.blade.php#624hattch2022prod520μsselect * from `post_codes` where `id` = 213 limit 1
      Bindings
      • 0: 213
      Backtrace
      • view::pages.home.brand:624
      • 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
    • brand.blade.php#626hattch2022prod1.79msSELECT `listings`.`id`, `post_codes`.`postcode` as `postcode`, `listings`.`name` as `name` 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 `franchise_type_listing` ON `listings`.`id` = `franchise_type_listing`.`listing_id` INNER JOIN `homepages` ON `listings`.`brand_id` = `homepages`.`brand_id` WHERE 1=1 AND `listings`.`brand_id` = '7017941' GROUP BY listings.id ORDER BY `post_codes`.`postcode` ASC;
      Backtrace
      • view::pages.home.brand:626
      • 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
    • brand.blade.php#645hattch2022prod740μsselect * from `survey_questions` where `brand_id` = 7017941 and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017941
      • 1: 1
      Backtrace
      • view::pages.home.brand:645
      • 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
    • brand.blade.php#652hattch2022prod470μsselect * from `categories` where `id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • view::pages.home.brand:652
      • 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
    • brand.blade.php#657hattch2022prod640μsselect * from `industries` where `id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • view::pages.home.brand:657
      • 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
    • brand.blade.php#694hattch2022prod640μsselect * from `opportunities` where `brand_id` = 7017941 and `user_id` = 0 limit 1
      Bindings
      • 0: 7017941
      • 1: 0
      Backtrace
      • view::pages.home.brand:694
      • 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
    • brand.blade.php#699hattch2022prod920μsselect * from `homepages` where `brand_id` = 7017941 limit 1
      Bindings
      • 0: 7017941
      Backtrace
      • view::pages.home.brand:699
      • 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
    • brand.blade.php#612hattch2022prod680μsselect * from `brands` where `id` = 7017918 limit 1
      Bindings
      • 0: 7017918
      Backtrace
      • view::pages.home.brand:612
      • 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
    • brand.blade.php#619hattch2022prod550μsselect * from `listings` where `id` = 4018333 limit 1
      Bindings
      • 0: 4018333
      Backtrace
      • view::pages.home.brand:619
      • 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
    • brand.blade.php#624hattch2022prod440μsselect * from `post_codes` where `id` = 4379 limit 1
      Bindings
      • 0: 4379
      Backtrace
      • view::pages.home.brand:624
      • 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
    • brand.blade.php#626hattch2022prod2.45msSELECT `listings`.`id`, `post_codes`.`postcode` as `postcode`, `listings`.`name` as `name` 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 `franchise_type_listing` ON `listings`.`id` = `franchise_type_listing`.`listing_id` INNER JOIN `homepages` ON `listings`.`brand_id` = `homepages`.`brand_id` WHERE 1=1 AND `listings`.`brand_id` = '7017918' GROUP BY listings.id ORDER BY `post_codes`.`postcode` ASC;
      Backtrace
      • view::pages.home.brand:626
      • 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
    • brand.blade.php#645hattch2022prod1.47msselect * from `survey_questions` where `brand_id` = 7017918 and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017918
      • 1: 1
      Backtrace
      • view::pages.home.brand:645
      • 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
    • brand.blade.php#652hattch2022prod660μsselect * from `categories` where `id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • view::pages.home.brand:652
      • 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
    • brand.blade.php#657hattch2022prod580μsselect * from `industries` where `id` = 3 limit 1
      Bindings
      • 0: 3
      Backtrace
      • view::pages.home.brand:657
      • 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
    • brand.blade.php#694hattch2022prod660μsselect * from `opportunities` where `brand_id` = 7017918 and `user_id` = 0 limit 1
      Bindings
      • 0: 7017918
      • 1: 0
      Backtrace
      • view::pages.home.brand:694
      • 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
    • brand.blade.php#699hattch2022prod740μsselect * from `homepages` where `brand_id` = 7017918 limit 1
      Bindings
      • 0: 7017918
      Backtrace
      • view::pages.home.brand:699
      • 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
    • brand.blade.php#612hattch2022prod620μsselect * from `brands` where `id` = 7017941 limit 1
      Bindings
      • 0: 7017941
      Backtrace
      • view::pages.home.brand:612
      • 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
    • brand.blade.php#619hattch2022prod530μsselect * from `listings` where `id` = 4019101 limit 1
      Bindings
      • 0: 4019101
      Backtrace
      • view::pages.home.brand:619
      • 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
    • brand.blade.php#624hattch2022prod620μsselect * from `post_codes` where `id` = 206 limit 1
      Bindings
      • 0: 206
      Backtrace
      • view::pages.home.brand:624
      • 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
    • brand.blade.php#626hattch2022prod3.69msSELECT `listings`.`id`, `post_codes`.`postcode` as `postcode`, `listings`.`name` as `name` 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 `franchise_type_listing` ON `listings`.`id` = `franchise_type_listing`.`listing_id` INNER JOIN `homepages` ON `listings`.`brand_id` = `homepages`.`brand_id` WHERE 1=1 AND `listings`.`brand_id` = '7017941' GROUP BY listings.id ORDER BY `post_codes`.`postcode` ASC;
      Backtrace
      • view::pages.home.brand:626
      • 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
    • brand.blade.php#645hattch2022prod870μsselect * from `survey_questions` where `brand_id` = 7017941 and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017941
      • 1: 1
      Backtrace
      • view::pages.home.brand:645
      • 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
    • brand.blade.php#652hattch2022prod600μsselect * from `categories` where `id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • view::pages.home.brand:652
      • 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
    • brand.blade.php#657hattch2022prod500μsselect * from `industries` where `id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • view::pages.home.brand:657
      • 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
    • brand.blade.php#694hattch2022prod840μsselect * from `opportunities` where `brand_id` = 7017941 and `user_id` = 0 limit 1
      Bindings
      • 0: 7017941
      • 1: 0
      Backtrace
      • view::pages.home.brand:694
      • 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
    • brand.blade.php#699hattch2022prod930μsselect * from `homepages` where `brand_id` = 7017941 limit 1
      Bindings
      • 0: 7017941
      Backtrace
      • view::pages.home.brand:699
      • 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
    • brand.blade.php#612hattch2022prod860μsselect * from `brands` where `id` = 7017948 limit 1
      Bindings
      • 0: 7017948
      Backtrace
      • view::pages.home.brand:612
      • 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
    • brand.blade.php#619hattch2022prod730μsselect * from `listings` where `id` = 4018930 limit 1
      Bindings
      • 0: 4018930
      Backtrace
      • view::pages.home.brand:619
      • 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
    • brand.blade.php#624hattch2022prod650μsselect * from `post_codes` where `id` = 206 limit 1
      Bindings
      • 0: 206
      Backtrace
      • view::pages.home.brand:624
      • 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
    • brand.blade.php#626hattch2022prod1.53msSELECT `listings`.`id`, `post_codes`.`postcode` as `postcode`, `listings`.`name` as `name` 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 `franchise_type_listing` ON `listings`.`id` = `franchise_type_listing`.`listing_id` INNER JOIN `homepages` ON `listings`.`brand_id` = `homepages`.`brand_id` WHERE 1=1 AND `listings`.`brand_id` = '7017948' GROUP BY listings.id ORDER BY `post_codes`.`postcode` ASC;
      Backtrace
      • view::pages.home.brand:626
      • 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
    • brand.blade.php#645hattch2022prod740μsselect * from `survey_questions` where `brand_id` = 7017948 and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017948
      • 1: 1
      Backtrace
      • view::pages.home.brand:645
      • 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
    • brand.blade.php#652hattch2022prod1.43msselect * from `categories` where `id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • view::pages.home.brand:652
      • 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
    • brand.blade.php#657hattch2022prod470μsselect * from `industries` where `id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • view::pages.home.brand:657
      • 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
    • brand.blade.php#694hattch2022prod570μsselect * from `opportunities` where `brand_id` = 7017948 and `user_id` = 0 limit 1
      Bindings
      • 0: 7017948
      • 1: 0
      Backtrace
      • view::pages.home.brand:694
      • 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
    • brand.blade.php#699hattch2022prod880μsselect * from `homepages` where `brand_id` = 7017948 limit 1
      Bindings
      • 0: 7017948
      Backtrace
      • view::pages.home.brand:699
      • 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
    • brand.blade.php#612hattch2022prod630μsselect * from `brands` where `id` = 7017948 limit 1
      Bindings
      • 0: 7017948
      Backtrace
      • view::pages.home.brand:612
      • 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
    • brand.blade.php#619hattch2022prod530μsselect * from `listings` where `id` = 4018934 limit 1
      Bindings
      • 0: 4018934
      Backtrace
      • view::pages.home.brand:619
      • 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
    • brand.blade.php#624hattch2022prod470μsselect * from `post_codes` where `id` = 208 limit 1
      Bindings
      • 0: 208
      Backtrace
      • view::pages.home.brand:624
      • 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
    • brand.blade.php#626hattch2022prod1.3msSELECT `listings`.`id`, `post_codes`.`postcode` as `postcode`, `listings`.`name` as `name` 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 `franchise_type_listing` ON `listings`.`id` = `franchise_type_listing`.`listing_id` INNER JOIN `homepages` ON `listings`.`brand_id` = `homepages`.`brand_id` WHERE 1=1 AND `listings`.`brand_id` = '7017948' GROUP BY listings.id ORDER BY `post_codes`.`postcode` ASC;
      Backtrace
      • view::pages.home.brand:626
      • 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
    • brand.blade.php#645hattch2022prod700μsselect * from `survey_questions` where `brand_id` = 7017948 and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017948
      • 1: 1
      Backtrace
      • view::pages.home.brand:645
      • 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
    • brand.blade.php#652hattch2022prod670μsselect * from `categories` where `id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • view::pages.home.brand:652
      • 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
    • brand.blade.php#657hattch2022prod580μsselect * from `industries` where `id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • view::pages.home.brand:657
      • 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
    • brand.blade.php#694hattch2022prod620μsselect * from `opportunities` where `brand_id` = 7017948 and `user_id` = 0 limit 1
      Bindings
      • 0: 7017948
      • 1: 0
      Backtrace
      • view::pages.home.brand:694
      • 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
    • brand.blade.php#699hattch2022prod790μsselect * from `homepages` where `brand_id` = 7017948 limit 1
      Bindings
      • 0: 7017948
      Backtrace
      • view::pages.home.brand:699
      • 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
    • brand.blade.php#612hattch2022prod640μsselect * from `brands` where `id` = 7017918 limit 1
      Bindings
      • 0: 7017918
      Backtrace
      • view::pages.home.brand:612
      • 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
    • brand.blade.php#619hattch2022prod1.07msselect * from `listings` where `id` = 4018331 limit 1
      Bindings
      • 0: 4018331
      Backtrace
      • view::pages.home.brand:619
      • 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
    • brand.blade.php#624hattch2022prod470μsselect * from `post_codes` where `id` = 207 limit 1
      Bindings
      • 0: 207
      Backtrace
      • view::pages.home.brand:624
      • 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
    • brand.blade.php#626hattch2022prod2.6msSELECT `listings`.`id`, `post_codes`.`postcode` as `postcode`, `listings`.`name` as `name` 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 `franchise_type_listing` ON `listings`.`id` = `franchise_type_listing`.`listing_id` INNER JOIN `homepages` ON `listings`.`brand_id` = `homepages`.`brand_id` WHERE 1=1 AND `listings`.`brand_id` = '7017918' GROUP BY listings.id ORDER BY `post_codes`.`postcode` ASC;
      Backtrace
      • view::pages.home.brand:626
      • 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
    • brand.blade.php#645hattch2022prod700μsselect * from `survey_questions` where `brand_id` = 7017918 and `brand_status` = 1 order by `sort_index` asc
      Bindings
      • 0: 7017918
      • 1: 1
      Backtrace
      • view::pages.home.brand:645
      • 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
    • hattch2022prod450μsselect * from `categories` where `id` = ? limit 1
    • hattch2022prod430μsselect * from `industries` where `id` = ? limit 1
    • hattch2022prod730μsselect * from `opportunities` where `brand_id` = ? and `user_id` = ? limit 1
    • hattch2022prod800μsselect * from `homepages` where `brand_id` = ? limit 1
    • hattch2022prod730μsselect * from `brands` where `id` = ? limit 1
    • hattch2022prod720μsselect * from `listings` where `id` = ? limit 1
    • hattch2022prod530μsselect * from `post_codes` where `id` = ? limit 1
    • hattch2022prod2.57msSELECT `listings`.`id`, `post_codes`.`postcode` as `postcode`, `listings`.`name` as `name` 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 `franchise_type_listing` ON `listings`.`id` = `franchise_type_listing`.`listing_id` INNER JOIN `homepages` ON `listings`.`brand_id` = `homepages`.`brand_id` WHERE 1=1 AND `listings`.`brand_id` = '7017918' GROUP BY listings.id ORDER BY `post_codes`.`postcode` ASC;
    • hattch2022prod770μsselect * from `survey_questions` where `brand_id` = ? and `brand_status` = ? order by `sort_index` asc
    • hattch2022prod560μsselect * from `categories` where `id` = ? limit 1
    • hattch2022prod440μsselect * from `industries` where `id` = ? limit 1
    • hattch2022prod770μsselect * from `opportunities` where `brand_id` = ? and `user_id` = ? limit 1
    • hattch2022prod970μsselect * from `homepages` where `brand_id` = ? limit 1
    • hattch2022prod710μsselect * from `brands` where `id` = ? limit 1
    • hattch2022prod500μsselect * from `listings` where `id` = ? limit 1
    • hattch2022prod450μsselect * from `post_codes` where `id` = ? limit 1
    • hattch2022prod2.4msSELECT `listings`.`id`, `post_codes`.`postcode` as `postcode`, `listings`.`name` as `name` 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 `franchise_type_listing` ON `listings`.`id` = `franchise_type_listing`.`listing_id` INNER JOIN `homepages` ON `listings`.`brand_id` = `homepages`.`brand_id` WHERE 1=1 AND `listings`.`brand_id` = '7017918' GROUP BY listings.id ORDER BY `post_codes`.`postcode` ASC;
    • hattch2022prod780μsselect * from `survey_questions` where `brand_id` = ? and `brand_status` = ? order by `sort_index` asc
    • hattch2022prod600μsselect * from `categories` where `id` = ? limit 1
    • hattch2022prod500μsselect * from `industries` where `id` = ? limit 1
    • hattch2022prod800μsselect * from `opportunities` where `brand_id` = ? and `user_id` = ? limit 1
    • hattch2022prod760μsselect * from `homepages` where `brand_id` = ? limit 1
    • hattch2022prod660μsselect * from `post_codes` where `id` = ? limit 1
    • hattch2022prod520μsSELECT minimum_investment from `brands` GROUP BY minimum_investment ORDER BY minimum_investment ASC;
    • hattch2022prod470μsSELECT maximum_investment from `brands` GROUP BY maximum_investment ORDER BY maximum_investment ASC;
    • hattch2022prod450μsselect * from `post_codes` where `id` = ? limit 1
    App\Models\Listing
    100Listing.php#?
    App\Models\PostCode
    53PostCode.php#?
    App\Models\Brand
    45Brand.php#?
    App\Models\Homepage
    45Homepage.php#?
    App\Models\Industry
    14Industry.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-05-22 22:49:14GET/businesses-for-sale/between-200000-10000000/in-kellyville-NSW-2155?page=22 (stacked)
        #22025-05-22 22:49:15GET/businesses-for-sale/between-200000-10000000/in-kellyville-nsw-21553617126257