Near Me Listing Near Me Listing

Advanced Search Hide Filter

Top 10 Water Heater Installation/Repair in New Hampshire

  1. Home
  2. New Hampshire
  3. Water Heater Installation/Repair

Get Best Water Heater Installation/Repair in New Hampshire With Just One Click

To offer you the best, here we are suggesting the uppermost Water Heater Installation/Repair in New Hampshire providers all the way from your locality. Our top 10 enlisted local service providers from USA are the best among the rest as they qualify our top ranking criteria. We outrank them on the basis of their customer rating, quality of service, legitimacy, year of service experience, and so on.

Our motto here is not to offer you a list of Water Heater Installation/Repair in New Hampshire providers. But to help you in finding your preferred service that will go easy on your pocket and be trusted by the number of service receivers.

Water Heater Installation/Repair in New Hampshire — Here’s What We Have Found For You

  • We found top listed 10 Water Heater Installation/Repair in New Hampshire.
  • The first page contains the top 10 list of local Water Heater Installation/Repair in New Hampshire providers
  • Sorted list of all types of Water Heater Installation/Repair in New Hampshire with their reviews, photo, and contact info.

Showing 10 out of 10 Water Heater Installation/Repair in New Hampshire local business services from USA.

Showing 1 - 10 of 10 results

Photos of New Hampshire Ductless New Hampshire

New Hampshire Ductless
  • 40 Mt Fayal Road Holderness Nh 03245 NH 03245, Holderness, New Hampshire
  • Air Conditioning
  • Water heater installationrepair
  • ( 2 Reviews )
We specialize in service and repair of all Plumbing, heating and air conditioning systems. Additionally, we work very closely with all of the local utility companies to make sure you are able take advantage of every rebate and cost saving incentive available. Highly trained and certified. Special
Photos of New Hampshire Ductless New Hampshire
  • ( 2 Reviews )

(603) 323-0342

Photos of Key Heating & Air Conditioning New Hampshire

Key Heating & Air Conditioning
  • 6 Central Ave NH 03894, Wolfeboro, New Hampshire
  • Air Conditioning
  • Water heater installationrepair
  • ( 1 Review )
Key Heating & Air Conditioning is a family-run team of HVAC contractors based out of Exeter, NH. For over 25 years they've provided home energy assessments, HVAC maintenance, and installation of all types of HVAC systems. With 100% customer satisfaction as their ultimate goal, the local business
Photos of Key Heating & Air Conditioning New Hampshire
  • ( 1 Review )

(603) 436-8811

Photos of Jeff MacKay Mechanical New Hampshire

Jeff MacKay Mechanical
  • 185 School St NH 03561, Littleton, New Hampshire
  • Air Conditioning
  • Water heater installationrepair
  • ( 3 Reviews )
Hvac services backed by over 30 years of experience. We built a sterling reputation on helping customers troubleshoot HVAC problem
Photos of Jeff MacKay Mechanical New Hampshire
  • ( 3 Reviews )

(603) 444-6770

Photos of Meredith Plumbing and Heating New Hampshire

Meredith Plumbing and Heating
  • 9 Krainewood Dr NH 03254, Moultonborough, New Hampshire
  • Air Conditioning
  • Water heater installationrepair
  • ( 3 Reviews )
Meredith Plumbing and Heating is one of the top plumbing contractors in Meredith, NH. Call us today Authorized Brands Delta, Eljer, Goulds, Toto, Kohler, American Standard, Peerless More Meredith Plumbing and Heating is your complete source for all y
Photos of Meredith Plumbing and Heating New Hampshire
  • ( 3 Reviews )

(603) 455-9269

Photos of Sunrise Heating And AC New Hampshire

Sunrise Heating And AC
  • NH 03246, Laconia, New Hampshire
  • Air Conditioning
  • Water heater installationrepair
  • ( 0 Review )
Sunrise Heating And AC Is located at New Hampshire NH 03246, Laconia You can try dialing the following number: (603) 507-2600
Photos of Sunrise Heating And AC New Hampshire
  • ( 0 Review )

(603) 507-2600

Photos of Bigfoot HVAC New Hampshire

Bigfoot HVAC
  • NH 03220, Belmont, New Hampshire
  • Air Conditioning
  • Water heater installationrepair
  • ( 0 Review )
Is your air conditioner making strange sounds, shutting off occasionally or simply not working? Does your heating unit warm the air in some rooms, but not others? You shouldn't have to deal with these problems. Contact our team right away to arrange for expert HVAC repair services. We'll send a skil
Photos of Bigfoot HVAC New Hampshire
  • ( 0 Review )

(603) 801-1678

Photos of Minuteman Plumbing & Heating New Hampshire

Minuteman Plumbing & Heating
  • 1 Chemung Rd NH 03253, Meredith, New Hampshire
  • Air Conditioning
  • Water heater installationrepair
  • ( 0 Review )
J. Costa Plumbing & Heating Supplies has been proudly serving New Hampshire's beautiful lakes region for over 30 years. The one-stop-shop for all your plumbing, heating, well and water treatment supplies. Whether you are a plumbing professional or a do-it-yourselfer, we have the knowledge and
Photos of Minuteman Plumbing & Heating New Hampshire
  • ( 0 Review )

(603) 279-3323

Photos of Lang’s HVAC New Hampshire

Lang’s HVAC
  • NH 03810, Alton Bay, New Hampshire
  • Air Conditioning
  • Water heater installationrepair
  • ( 0 Review )
We are pleased to offer 24-hour emergency HVAC service in the areas we are licensed and insured in. We also offer free estimates for all HVAC work, including installing new AC units, running and repairing ducts, and repairing furnaces, boilers, and heat pumps. Our expert technicians are well-trained
Photos of Lang’s HVAC New Hampshire
  • ( 0 Review )

(603) 268-2187

Photos of RLD Heating and Cooling New Hampshire

RLD Heating and Cooling
  • NH 03276, Northfield, New Hampshire
  • Air Conditioning
  • Water heater installationrepair
  • ( 0 Review )
RLD Heating and Cooling Is located at New Hampshire NH 03276, Northfield You can try dialing the following number: (603) 361-9658
Photos of RLD Heating and Cooling New Hampshire
  • ( 0 Review )

(603) 361-9658

Photos of Just Hot Water New Hampshire

Just Hot Water
  • NH 03837, Gilmanton, New Hampshire
  • Air Conditioning
  • Water heater installationrepair
  • ( 0 Review )
Just Hot Water specializes in repair and maintenance service for all HVAC systems and domestic hot water. Our technicians are all seasoned professional with the background to properly diagnose and repair your system. No high pressure sale or forced sales and no hidden fees.
Photos of Just Hot Water New Hampshire
  • ( 0 Review )

(603) 404-8288

Related Categories

Show More >

Top Categories

Frequently Asked Questions:


How to find Water Heater Installation/Repair In New Hampshire?

Place your search on NearMeListing simply by entering Water Heater Installation/Repair and enter New Hampshire in the location box and you will find the Water Heater Installation/Repair in New Hampshire.


How to find best Water Heater Installation/Repair in New Hampshire?

To find the best Water Heater Installation/Repair in New Hampshire, there are few things to take into considerations to know your expert well before making a purchase or hire them such as Reviews/Ratings, Cost, Industry Experience, Certifications, Guarantees, Offers, Insurance Policy etc. You'll get the recommendations of top 10 Water Heater Installation/Repair to choose the best as per your needs on NearMeListing.


How to find 24/7 Water Heater Installation/Repair in New Hampshire?

To find the 24/7 Water Heater Installation/Repair service in New Hampshire, you can check the availability of the business from Monday to Sunday, and opening hours in a day.


Can I use Nearmelisting.com to find discounts, promotions and offers by Water Heater Installation/Repair in New Hampshire?

Yes, you can use NearMeListing to find the Water Heater Installation/Repair in New Hampshire who are on discounts, promotions and seasonal offers for their customers. You can also visit their website to know more about the business and their offers.

Our motto is to empower local business owners to make them reach every next door with ease and to offer a service support that people have never experienced before.
Take your Business on top, Build a stronger Business profile and get boundless network to grow.

Company

Subscribe

We don’t send spam so don’t worry.

Copyright © 2023 by Near Me Listing

                 
Messages1TimelineExceptionsViews33RouteQueries98Models6507MailsGateSessionRequest
8.2.27PHP Version1.37sRequest Duration25MBMemory UsageGET best/{slug?}Route
  • warninglog[20:35:42] LOG.warning: Callables of the form ["Swift_SmtpTransport", "Swift_Transport_EsmtpTranspor...
  • Booting (15.92ms)
  • Application (1.35s)
  • 1 x Application (98.84%)
    1.35s
    1 x Booting (1.16%)
    15.92ms
    33 templates were rendered
    • Property::frontend.category.detail-static-page (modules/Property/Views/frontend/category/detail-static-page.blade.php)16blade
      Params
      0
      row
      1
      translation
      2
      list_location
      3
      list_category
      4
      property_min_max_price
      5
      rows
      6
      seo_meta
      7
      location_name
      8
      cat_name
      9
      get_related_category
      10
      getTopCategory
      11
      category_name
      12
      bg_image_url
      13
      enable_category_box
      14
      hide_form_search
      15
      service_types
    • Property::frontend.layouts.search.filter-search-mobile (modules/Property/Views/frontend/layouts/search/filter-search-mobile.blade.php)26blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
    • Property::frontend.layouts.form-search.fields.sidebar.option (modules/Property/Views/frontend/layouts/form-search/fields/sidebar/option.blade.php)36blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      property_search_fields
      27
      list_number
      28
      list_garages_value
      29
      current_year
      30
      list_year
      31
      year
      32
      field
      33
      list
      34
      holder
      35
      name
    • Property::frontend.layouts.form-search.fields.sidebar.option (modules/Property/Views/frontend/layouts/form-search/fields/sidebar/option.blade.php)36blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      property_search_fields
      27
      list_number
      28
      list_garages_value
      29
      current_year
      30
      list_year
      31
      year
      32
      field
      33
      list
      34
      holder
      35
      name
    • Property::frontend.layouts.search.loop.orderby (modules/Property/Views/frontend/layouts/search/loop/orderby.blade.php)35blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)38blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)38blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)38blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)38blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)38blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)38blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)38blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)38blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)38blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)38blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
    • pagination::bootstrap-4 (resources/views/vendor/pagination/bootstrap-4.blade.php)2blade
      Params
      0
      paginator
      1
      elements
    • layouts.app (resources/views/layouts/app.blade.php)43blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
    • Layout::app (modules/Layout/app.blade.php)43blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
    • Layout::parts.seo-meta (modules/Layout/parts/seo-meta.blade.php)45blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
    • Layout::parts.secondary_header (modules/Layout/parts/secondary_header.blade.php)45blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
    • Property::frontend.layouts.form-search.topbar (modules/Property/Views/frontend/layouts/form-search/topbar.blade.php)49blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      user_listings_count
      46
      rold_id
      47
      gmapkey
      48
      mapkey
    • Property::frontend.layouts.form-search.fields.sidebar.attribute (modules/Property/Views/frontend/layouts/form-search/fields/sidebar/attribute.blade.php)55blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      user_listings_count
      46
      rold_id
      47
      gmapkey
      48
      mapkey
      49
      location_input_field
      50
      pass_id
      51
      property_search_fields
      52
      field
      53
      key
      54
      holder
    • Property::frontend.layouts.form-search.fields.sidebar.option (modules/Property/Views/frontend/layouts/form-search/fields/sidebar/option.blade.php)56blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      user_listings_count
      46
      rold_id
      47
      gmapkey
      48
      mapkey
      49
      location_input_field
      50
      pass_id
      51
      property_search_fields
      52
      field
      53
      list
      54
      holder
      55
      name
    • Property::frontend.layouts.form-search.fields.sidebar.option (modules/Property/Views/frontend/layouts/form-search/fields/sidebar/option.blade.php)56blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      user_listings_count
      46
      rold_id
      47
      gmapkey
      48
      mapkey
      49
      location_input_field
      50
      pass_id
      51
      property_search_fields
      52
      field
      53
      list
      54
      holder
      55
      name
    • Property::frontend.layouts.form-search.fields.sidebar.attribute (modules/Property/Views/frontend/layouts/form-search/fields/sidebar/attribute.blade.php)57blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      user_listings_count
      46
      rold_id
      47
      gmapkey
      48
      mapkey
      49
      location_input_field
      50
      pass_id
      51
      property_search_fields
      52
      field
      53
      categories
      54
      locations
      55
      key
      56
      holder
    • Core::frontend.currency-switcher (modules/Core/Views/frontend/currency-switcher.blade.php)49blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      user_listings_count
      46
      rold_id
      47
      gmapkey
      48
      mapkey
    • Language::frontend.switcher (modules/Language/Views/frontend/switcher.blade.php)49blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      user_listings_count
      46
      rold_id
      47
      gmapkey
      48
      mapkey
    • Layout::parts.notifications (modules/Layout/parts/notifications.blade.php)49blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      user_listings_count
      46
      rold_id
      47
      gmapkey
      48
      mapkey
    • Language::frontend.switcher (modules/Language/Views/frontend/switcher.blade.php)52blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      user_listings_count
      46
      rold_id
      47
      gmapkey
      48
      mapkey
      49
      logo_id
      50
      logo
      51
      mobile
    • Layout::parts.footer (modules/Layout/parts/footer.blade.php)45blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
    • Layout::parts.login-register-modal (modules/Layout/parts/login-register-modal.blade.php)50blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      path
      46
      endpath
      47
      list_widget_footers
      48
      item
      49
      key
    • Layout::auth.login-form (modules/Layout/auth/login-form.blade.php)50blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      path
      46
      endpath
      47
      list_widget_footers
      48
      item
      49
      key
    • Layout::auth.register-form (modules/Layout/auth/register-form.blade.php)50blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      path
      46
      endpath
      47
      list_widget_footers
      48
      item
      49
      key
    uri
    GET best/{slug?}
    middleware
    web
    uses
    App\Http\Controllers\UriController@__invoke
    controller
    App\Http\Controllers\UriController
    namespace
    App\Http\Controllers
    prefix
    /best
    where
    as
    page_url
    98 statements were executed, 57 of which were duplicated, 41 unique1.15s
    nearmelisting_db
    • select * from `bc_locations` where `slug` = 'new-hampshire' and `status` = 'publish' and `bc_locations`.`deleted_at` is null limit 1
      2.6ms/app/Http/Controllers/UriController.php:51nearmelisting_db
      Metadata
      Bindings
      • 0. new-hampshire
      • 1. publish
      Backtrace
      • 15. /app/Http/Controllers/UriController.php:51
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `bc_property_category` where `slug` = 'water-heater-installationrepair' and `status` = 'publish' and `bc_property_category`.`deleted_at` is null limit 1
      620μs/app/Http/Controllers/UriController.php:61nearmelisting_db
      Metadata
      Bindings
      • 0. water-heater-installationrepair
      • 1. publish
      Backtrace
      • 15. /app/Http/Controllers/UriController.php:61
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `bc_locations` where `status` = 'publish' and `bc_locations`.`deleted_at` is null limit 1000
      3.61ms/app/Http/Controllers/UriController.php:76nearmelisting_db
      Metadata
      Bindings
      • 0. publish
      Backtrace
      • 14. /app/Http/Controllers/UriController.php:76
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `bc_location_translations` where `bc_location_translations`.`origin_id` in (1, 3, 4, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527, 528, 529, 530, 531, 532, 533, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 601, 602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 648, 649, 650, 651, 652, 653, 654, 655, 656, 657, 658, 659, 660, 661, 662, 663, 664, 665, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 692, 693, 694, 695, 696, 697, 698, 699, 700, 701, 702, 703, 704, 705, 706, 707, 708, 709, 710, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782, 783, 784, 785, 786, 787, 788, 789, 790, 791, 792, 793, 794, 795, 796, 797, 798, 799, 800, 801, 802, 803, 804, 805, 806, 807, 808, 809, 810, 811, 812, 813, 814, 815, 816, 817, 818, 819, 820, 821, 822, 823, 824, 825, 826, 827, 828, 829, 830, 831, 832, 833, 834, 835, 836, 837, 838, 839, 840, 841, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 989, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002)
      1.59ms/app/Http/Controllers/UriController.php:76nearmelisting_db
      Metadata
      Backtrace
      • 19. /app/Http/Controllers/UriController.php:76
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `bc_property_category` where `status` = 'publish' and `bc_property_category`.`deleted_at` is null
      4.31ms/app/Http/Controllers/UriController.php:77nearmelisting_db
      Metadata
      Bindings
      • 0. publish
      Backtrace
      • 14. /app/Http/Controllers/UriController.php:77
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `val` from `bc_settings` where `name` = 'default_search_location'
      860μs/modules/Property/Models/Property.php:1054nearmelisting_db
      Metadata
      Bindings
      • 0. default_search_location
      Backtrace
      • 12. /modules/Property/Models/Property.php:1054
      • 13. /app/Http/Controllers/UriController.php:79
      • 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
    • select count(*) as aggregate from (select `bc_properties`.* from `bc_properties` inner join `bc_property_category_relationships` as `pcs` on `pcs`.`property_id` = `bc_properties`.`id` inner join `bc_locations` on `bc_locations`.`id` = `bc_properties`.`location_id` and `bc_locations`.`_lft` >= 12 and `bc_locations`.`_rgt` <= 141 where `bc_properties`.`status` = 'publish' and `bc_properties`.`location_id` = 1126 and `pcs`.`category_id` = 353 and `bc_properties`.`deleted_at` is null group by `bc_properties`.`id`) as `aggregate_table`
      182ms/modules/Property/Models/Property.php:1121nearmelisting_db
      Metadata
      Bindings
      • 0. 12
      • 1. 141
      • 2. publish
      • 3. 1126
      • 4. 353
      Backtrace
      • 15. /modules/Property/Models/Property.php:1121
      • 16. /app/Http/Controllers/UriController.php:79
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
    • select `bc_properties`.* from `bc_properties` inner join `bc_property_category_relationships` as `pcs` on `pcs`.`property_id` = `bc_properties`.`id` inner join `bc_locations` on `bc_locations`.`id` = `bc_properties`.`location_id` and `bc_locations`.`_lft` >= 12 and `bc_locations`.`_rgt` <= 141 where `bc_properties`.`status` = 'publish' and `bc_properties`.`location_id` = 1126 and `pcs`.`category_id` = 353 and `bc_properties`.`deleted_at` is null group by `bc_properties`.`id` order by `points` desc limit 10 offset 0
      6.59ms/modules/Property/Models/Property.php:1121nearmelisting_db
      Metadata
      Bindings
      • 0. 12
      • 1. 141
      • 2. publish
      • 3. 1126
      • 4. 353
      Backtrace
      • 15. /modules/Property/Models/Property.php:1121
      • 16. /app/Http/Controllers/UriController.php:79
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
    • select * from `bc_locations` where `bc_locations`.`id` in (1126) and `bc_locations`.`deleted_at` is null
      450μs/modules/Property/Models/Property.php:1121nearmelisting_db
      Metadata
      Bindings
      • 0. 1126
      Backtrace
      • 20. /modules/Property/Models/Property.php:1121
      • 21. /app/Http/Controllers/UriController.php:79
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
    • select * from `bc_location_translations` where `bc_location_translations`.`origin_id` in (1126)
      420μs/modules/Property/Models/Property.php:1121nearmelisting_db
      Metadata
      Backtrace
      • 25. /modules/Property/Models/Property.php:1121
      • 26. /app/Http/Controllers/UriController.php:79
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
    • select * from `user_wishlist` where `object_model` = 'property' and `user_id` = 0 and `user_wishlist`.`object_id` in (108288, 473304, 473823, 473955, 474343, 474575, 474675, 474838, 474951, 475192)
      320μs/modules/Property/Models/Property.php:1121nearmelisting_db
      Metadata
      Bindings
      • 0. property
      • 1. 0
      Backtrace
      • 20. /modules/Property/Models/Property.php:1121
      • 21. /app/Http/Controllers/UriController.php:79
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
    • select * from `bc_property_translations` where `bc_property_translations`.`origin_id` in (108288, 473304, 473823, 473955, 474343, 474575, 474675, 474838, 474951, 475192) and `bc_property_translations`.`deleted_at` is null
      260μs/modules/Property/Models/Property.php:1121nearmelisting_db
      Metadata
      Backtrace
      • 20. /modules/Property/Models/Property.php:1121
      • 21. /app/Http/Controllers/UriController.php:79
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
    • select * from `users` where `users`.`id` in (0) and `users`.`deleted_at` is null
      370μs/modules/Property/Models/Property.php:1121nearmelisting_db
      Metadata
      Backtrace
      • 20. /modules/Property/Models/Property.php:1121
      • 21. /app/Http/Controllers/UriController.php:79
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
    • select `bc_property_category`.*, `bc_property_category_relationships`.`property_id` as `pivot_property_id`, `bc_property_category_relationships`.`category_id` as `pivot_category_id` from `bc_property_category` inner join `bc_property_category_relationships` on `bc_property_category`.`id` = `bc_property_category_relationships`.`category_id` where `bc_property_category_relationships`.`property_id` in (108288, 473304, 473823, 473955, 474343, 474575, 474675, 474838, 474951, 475192) and `bc_property_category`.`deleted_at` is null
      610μs/modules/Property/Models/Property.php:1121nearmelisting_db
      Metadata
      Backtrace
      • 19. /modules/Property/Models/Property.php:1121
      • 20. /app/Http/Controllers/UriController.php:79
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
    • select `id`, `name`, `parent_id` from `bc_property_category` where `id` = 353
      260μs/app/Helpers/AppHelper.php:1170nearmelisting_db
      Metadata
      Bindings
      • 0. 353
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1170
      • 14. /app/Http/Controllers/UriController.php:83
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
    • select `id`, `name`, `parent_id` from `bc_property_category` where `id` = 16
      260μs/app/Helpers/AppHelper.php:1170nearmelisting_db
      Metadata
      Bindings
      • 0. 16
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1170
      • 15. /app/Http/Controllers/UriController.php:83
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
    • select `id`, `name`, `parent_id` from `bc_property_category` where `id` = 15
      190μs/app/Helpers/AppHelper.php:1170nearmelisting_db
      Metadata
      Bindings
      • 0. 15
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1170
      • 16. /app/Http/Controllers/UriController.php:83
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
    • select `name`, `slug` from `bc_property_category` where `parent_id` = 15
      960μs/app/Http/Controllers/UriController.php:247nearmelisting_db
      Metadata
      Bindings
      • 0. 15
      Backtrace
      • 12. /app/Http/Controllers/UriController.php:247
      • 13. /app/Http/Controllers/UriController.php:83
      • 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
    • select `category_id`, COUNT(*) as occurrence from `bc_property_category_relationships` group by `category_id` order by `occurrence` desc limit 8
      889ms/app/Http/Controllers/UriController.php:252nearmelisting_db
      Metadata
      Backtrace
      • 12. /app/Http/Controllers/UriController.php:252
      • 13. /app/Http/Controllers/UriController.php:84
      • 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
    • select `image_dir` from `bc_properties` where `id` = 108288
      710μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 108288
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `name`, `slug` from `bc_locations` where `id` = 1126
      300μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 1126
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1155
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `image_dir` from `bc_properties` where `id` = 473304
      770μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 473304
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `name`, `slug` from `bc_locations` where `id` = 1126
      320μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 1126
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1155
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `image_dir` from `bc_properties` where `id` = 473955
      540μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 473955
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `name`, `slug` from `bc_locations` where `id` = 1126
      270μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 1126
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1155
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `image_dir` from `bc_properties` where `id` = 473823
      610μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 473823
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `name`, `slug` from `bc_locations` where `id` = 1126
      290μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 1126
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1155
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `image_dir` from `bc_properties` where `id` = 474343
      530μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 474343
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `name`, `slug` from `bc_locations` where `id` = 1126
      210μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 1126
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1155
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `image_dir` from `bc_properties` where `id` = 474575
      480μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 474575
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `name`, `slug` from `bc_locations` where `id` = 1126
      210μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 1126
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1155
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `image_dir` from `bc_properties` where `id` = 474675
      700μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 474675
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `name`, `slug` from `bc_locations` where `id` = 1126
      210μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 1126
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1155
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `image_dir` from `bc_properties` where `id` = 474838
      440μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 474838
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `name`, `slug` from `bc_locations` where `id` = 1126
      230μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 1126
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1155
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `image_dir` from `bc_properties` where `id` = 474951
      510μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 474951
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `name`, `slug` from `bc_locations` where `id` = 1126
      350μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 1126
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1155
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `image_dir` from `bc_properties` where `id` = 475192
      550μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 475192
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `name`, `slug` from `bc_locations` where `id` = 1126
      330μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 1126
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1155
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select AVG(rate_number) as sbc_total , COUNT(id) as total_review from `bc_review` where `object_id` = 108288 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      1.6ms/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 108288
      • 1. property
      • 2. approved
      Backtrace
      • 15. /modules/Review/Models/Review.php:164
      • 16. view::160424646aa6fb88435c3aad8a19da2a79ba2df9:3
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select `image_dir` from `bc_properties` where `id` = 108288
      340μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 108288
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `image_dir` from `bc_properties` where `id` = 108288
      420μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 108288
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `image_dir` from `bc_properties` where `id` = 108288
      370μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 108288
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select AVG(rate_number) as sbc_total , COUNT(id) as total_review from `bc_review` where `object_id` = 473304 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      1.98ms/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 473304
      • 1. property
      • 2. approved
      Backtrace
      • 15. /modules/Review/Models/Review.php:164
      • 16. view::160424646aa6fb88435c3aad8a19da2a79ba2df9:3
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select `image_dir` from `bc_properties` where `id` = 473304
      250μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 473304
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `image_dir` from `bc_properties` where `id` = 473304
      200μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 473304
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `image_dir` from `bc_properties` where `id` = 473304
      230μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 473304
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select AVG(rate_number) as sbc_total , COUNT(id) as total_review from `bc_review` where `object_id` = 473955 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      1.14ms/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 473955
      • 1. property
      • 2. approved
      Backtrace
      • 15. /modules/Review/Models/Review.php:164
      • 16. view::160424646aa6fb88435c3aad8a19da2a79ba2df9:3
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select `image_dir` from `bc_properties` where `id` = 473955
      250μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 473955
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `image_dir` from `bc_properties` where `id` = 473955
      220μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 473955
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `image_dir` from `bc_properties` where `id` = 473955
      220μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 473955
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select AVG(rate_number) as sbc_total , COUNT(id) as total_review from `bc_review` where `object_id` = 473823 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      820μs/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 473823
      • 1. property
      • 2. approved
      Backtrace
      • 15. /modules/Review/Models/Review.php:164
      • 16. view::160424646aa6fb88435c3aad8a19da2a79ba2df9:3
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select `image_dir` from `bc_properties` where `id` = 473823
      250μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 473823
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `image_dir` from `bc_properties` where `id` = 473823
      280μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 473823
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `image_dir` from `bc_properties` where `id` = 473823
      280μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 473823
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select AVG(rate_number) as sbc_total , COUNT(id) as total_review from `bc_review` where `object_id` = 474343 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      1.09ms/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 474343
      • 1. property
      • 2. approved
      Backtrace
      • 15. /modules/Review/Models/Review.php:164
      • 16. view::160424646aa6fb88435c3aad8a19da2a79ba2df9:3
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select `image_dir` from `bc_properties` where `id` = 474343
      280μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 474343
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `image_dir` from `bc_properties` where `id` = 474343
      250μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 474343
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `image_dir` from `bc_properties` where `id` = 474343
      260μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 474343
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select AVG(rate_number) as sbc_total , COUNT(id) as total_review from `bc_review` where `object_id` = 474575 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      700μs/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 474575
      • 1. property
      • 2. approved
      Backtrace
      • 15. /modules/Review/Models/Review.php:164
      • 16. view::160424646aa6fb88435c3aad8a19da2a79ba2df9:3
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select `image_dir` from `bc_properties` where `id` = 474575
      260μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 474575
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `image_dir` from `bc_properties` where `id` = 474575
      290μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 474575
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `image_dir` from `bc_properties` where `id` = 474575
      250μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 474575
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select AVG(rate_number) as sbc_total , COUNT(id) as total_review from `bc_review` where `object_id` = 474675 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      770μs/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 474675
      • 1. property
      • 2. approved
      Backtrace
      • 15. /modules/Review/Models/Review.php:164
      • 16. view::160424646aa6fb88435c3aad8a19da2a79ba2df9:3
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select `image_dir` from `bc_properties` where `id` = 474675
      200μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 474675
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `image_dir` from `bc_properties` where `id` = 474675
      220μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 474675
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `image_dir` from `bc_properties` where `id` = 474675
      230μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 474675
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select AVG(rate_number) as sbc_total , COUNT(id) as total_review from `bc_review` where `object_id` = 474838 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      560μs/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 474838
      • 1. property
      • 2. approved
      Backtrace
      • 15. /modules/Review/Models/Review.php:164
      • 16. view::160424646aa6fb88435c3aad8a19da2a79ba2df9:3
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select `image_dir` from `bc_properties` where `id` = 474838
      190μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 474838
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `image_dir` from `bc_properties` where `id` = 474838
      200μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 474838
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `image_dir` from `bc_properties` where `id` = 474838
      240μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 474838
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select AVG(rate_number) as sbc_total , COUNT(id) as total_review from `bc_review` where `object_id` = 474951 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      580μs/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 474951
      • 1. property
      • 2. approved
      Backtrace
      • 15. /modules/Review/Models/Review.php:164
      • 16. view::160424646aa6fb88435c3aad8a19da2a79ba2df9:3
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select `image_dir` from `bc_properties` where `id` = 474951
      250μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 474951
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `image_dir` from `bc_properties` where `id` = 474951
      180μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 474951
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `image_dir` from `bc_properties` where `id` = 474951
      260μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 474951
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select AVG(rate_number) as sbc_total , COUNT(id) as total_review from `bc_review` where `object_id` = 475192 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      600μs/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 475192
      • 1. property
      • 2. approved
      Backtrace
      • 15. /modules/Review/Models/Review.php:164
      • 16. view::160424646aa6fb88435c3aad8a19da2a79ba2df9:3
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select `image_dir` from `bc_properties` where `id` = 475192
      300μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 475192
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `image_dir` from `bc_properties` where `id` = 475192
      210μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 475192
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `image_dir` from `bc_properties` where `id` = 475192
      340μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 475192
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select `slug`, `name` from `bc_property_category` where `id` = 15
      310μs/app/Helpers/AppHelper.php:1211nearmelisting_db
      Metadata
      Bindings
      • 0. 15
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1211
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `slug`, `name` from `bc_property_category` where `id` = 988
      270μs/app/Helpers/AppHelper.php:1211nearmelisting_db
      Metadata
      Bindings
      • 0. 988
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1211
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `slug`, `name` from `bc_property_category` where `id` = 24
      260μs/app/Helpers/AppHelper.php:1211nearmelisting_db
      Metadata
      Bindings
      • 0. 24
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1211
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `slug`, `name` from `bc_property_category` where `id` = 92
      190μs/app/Helpers/AppHelper.php:1211nearmelisting_db
      Metadata
      Bindings
      • 0. 92
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1211
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `slug`, `name` from `bc_property_category` where `id` = 366
      250μs/app/Helpers/AppHelper.php:1211nearmelisting_db
      Metadata
      Bindings
      • 0. 366
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1211
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `slug`, `name` from `bc_property_category` where `id` = 354
      270μs/app/Helpers/AppHelper.php:1211nearmelisting_db
      Metadata
      Bindings
      • 0. 354
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1211
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `slug`, `name` from `bc_property_category` where `id` = 93
      220μs/app/Helpers/AppHelper.php:1211nearmelisting_db
      Metadata
      Bindings
      • 0. 93
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1211
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `slug`, `name` from `bc_property_category` where `id` = 311
      260μs/app/Helpers/AppHelper.php:1211nearmelisting_db
      Metadata
      Bindings
      • 0. 311
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1211
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `image_dir` from `bc_properties` where `id` = 475192
      260μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 475192
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select * from `bc_locations` where `status` = 'publish' and `bc_locations`.`deleted_at` is null
      5.83msview::dcb94a1209b2515f6c510112090436090ea192e3:7nearmelisting_db
      Metadata
      Bindings
      • 0. publish
      Backtrace
      • 14. view::dcb94a1209b2515f6c510112090436090ea192e3:7
      • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select * from `bc_property_category` where `status` = 'publish' and `bc_property_category`.`deleted_at` is null
      5.41msview::dcb94a1209b2515f6c510112090436090ea192e3:8nearmelisting_db
      Metadata
      Bindings
      • 0. publish
      Backtrace
      • 14. view::dcb94a1209b2515f6c510112090436090ea192e3:8
      • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `val` from `bc_settings` where `name` = 'map_gmap_key'
      1.64msview::dcb94a1209b2515f6c510112090436090ea192e3:21nearmelisting_db
      Metadata
      Bindings
      • 0. map_gmap_key
      Backtrace
      • 14. view::dcb94a1209b2515f6c510112090436090ea192e3:21
      • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select LOWER(name) as name from `bc_property_category` where `status` = 'publish'
      2.33msview::ae48feb0b3f21c9fe6b5276e43fae42bc8e49c39:87nearmelisting_db
      Metadata
      Bindings
      • 0. publish
      Backtrace
      • 12. view::ae48feb0b3f21c9fe6b5276e43fae42bc8e49c39:87
      • 14. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 17. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select LOWER(name) as name from `bc_locations` where `status` = 'publish' and `parent_id` != '0'
      1.95msview::ae48feb0b3f21c9fe6b5276e43fae42bc8e49c39:88nearmelisting_db
      Metadata
      Bindings
      • 0. publish
      • 1. 0
      Backtrace
      • 12. view::ae48feb0b3f21c9fe6b5276e43fae42bc8e49c39:88
      • 14. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 17. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select * from `bc_attrs` where `service` = 'property' and `bc_attrs`.`id` = '1' and `bc_attrs`.`deleted_at` is null limit 1
      680μsview::3598bd890c7f26491dfc8a0c263a2b668ba24af3:5nearmelisting_db
      Metadata
      Bindings
      • 0. property
      • 1. 1
      Backtrace
      • 16. view::3598bd890c7f26491dfc8a0c263a2b668ba24af3:5
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select * from `bc_terms` where `bc_terms`.`attr_id` in (1) and `bc_terms`.`deleted_at` is null
      1.19msview::3598bd890c7f26491dfc8a0c263a2b668ba24af3:5nearmelisting_db
      Metadata
      Backtrace
      • 21. view::3598bd890c7f26491dfc8a0c263a2b668ba24af3:5
      • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select * from `bc_terms_translations` where `bc_terms_translations`.`origin_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457)
      670μsview::3598bd890c7f26491dfc8a0c263a2b668ba24af3:5nearmelisting_db
      Metadata
      Backtrace
      • 26. view::3598bd890c7f26491dfc8a0c263a2b668ba24af3:5
      • 28. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 29. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 30. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 31. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select LOWER(name) as name from `bc_property_category` where `status` = 'publish'
      1.44msview::dcb94a1209b2515f6c510112090436090ea192e3:420nearmelisting_db
      Metadata
      Bindings
      • 0. publish
      Backtrace
      • 12. view::dcb94a1209b2515f6c510112090436090ea192e3:420
      • 14. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 17. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select LOWER(name) as name from `bc_locations` where `status` = 'publish' and `parent_id` != '0'
      1.32msview::dcb94a1209b2515f6c510112090436090ea192e3:421nearmelisting_db
      Metadata
      Bindings
      • 0. publish
      • 1. 0
      Backtrace
      • 12. view::dcb94a1209b2515f6c510112090436090ea192e3:421
      • 14. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 17. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    Modules\Core\Models\Terms
    457
    Modules\Core\Models\Attributes
    1
    Modules\Core\Models\Settings
    1
    Modules\Review\Models\Review
    10
    Modules\Property\Models\Property
    10
    Modules\Property\Models\PropertyCategory
    2954
    Modules\Location\Models\Location
    3074
        _token
        tRbwARh2nnWxhevpvF99xo6fjetnoCXdwlD68FQ8
        category_id
        driving-schools-near-me
        _previous
        array:1 [ "url" => "https://nearmelisting.com/best/new-hampshire/water-heater-installationrepair" ...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        bc_current_currency
        jpy
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /best/new-hampshire/water-heater-installationrepair
        status_code
        200
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        request_request
        []
        request_headers
          0 of 0   
        array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik9ZMWJQcmdXLytJVUsyNnRCdGp1ZFE9PSIsInZhbHVlIjoiaXBma3VhYVYxRFdjYUUxNDNRYnZmblhnRXFoQ3YxdlV4SWdKenQ0ZmRrZ2JLaENVemNrOXdkeHlVdktLd1FhVkEzWGJoanhVRzBJdDl4dlBLejd1dTdKL3JWMjhaY1QxQ0pScXg5VjRvU0VRU3JNRDJtUzZWUWw2Z09WVHlyREkiLCJtYWMiOiIzNzJmM2VkMzQ3NTA0YjgyZjc1ODA2YTY2OTY0NjkzMGIxZTQ1ZmZiNDdmYjEyMGYxNTYyNzkxNDdlN2Q1YjRmIiwidGFnIjoiIn0%3D; nearmelisting_session=eyJpdiI6Ilc3Tzg4ZzFWdkM3OTgvWWFqNnBvTHc9PSIsInZhbHVlIjoiU09BRUF0ZGxDaGV0RHdXL0tGN2liVVNhYTdhNkx0RWR3Y2hHcmJYdFFjejZ2d05QdU5MSkE5YlJvQ3RtRjdrRHRNVWV1enkvSFFieG1tV0xWV1NEMklFcnFwaTJ2SC9qY0NDVjlDbkVaWVl3clhpK2tjWDd3cS9aZzBBb0lzMlMiLCJtYWMiOiJmZmM5ZTljOWVlMDIwMjE5ZWE3MjZjNzlhYjM5Y2U1NDdmNGNmMDk4MDI5N2ZlMDA0M2M5YzFkODE4ZWY3YjJjIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6Ik9ZMWJQcmdXLytJVUsyNnRCdGp1ZFE9PSIsInZhbHVlIjoiaXBma3VhYVYxRFdjYUUxNDNRYnZmblhnRXFoQ3YxdlV4SWdKenQ0ZmRrZ2JLaENVemNrOXdkeHlVdktLd1FhVkEzWGJoa ▶"
  ]
  "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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "host" => array:1 [▶
    0 => "nearmelisting.com"
  ]
]
        request_server
          0 of 0   
        array:44 [▼
  "USER" => "www-data"
  "HOME" => "/var/www"
  "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6Ik9ZMWJQcmdXLytJVUsyNnRCdGp1ZFE9PSIsInZhbHVlIjoiaXBma3VhYVYxRFdjYUUxNDNRYnZmblhnRXFoQ3YxdlV4SWdKenQ0ZmRrZ2JLaENVemNrOXdkeHlVdktLd1FhVkEzWGJoanhVRzBJdDl4dlBLejd1dTdKL3JWMjhaY1QxQ0pScXg5VjRvU0VRU3JNRDJtUzZWUWw2Z09WVHlyREkiLCJtYWMiOiIzNzJmM2VkMzQ3NTA0YjgyZjc1ODA2YTY2OTY0NjkzMGIxZTQ1ZmZiNDdmYjEyMGYxNTYyNzkxNDdlN2Q1YjRmIiwidGFnIjoiIn0%3D; nearmelisting_session=eyJpdiI6Ilc3Tzg4ZzFWdkM3OTgvWWFqNnBvTHc9PSIsInZhbHVlIjoiU09BRUF0ZGxDaGV0RHdXL0tGN2liVVNhYTdhNkx0RWR3Y2hHcmJYdFFjejZ2d05QdU5MSkE5YlJvQ3RtRjdrRHRNVWV1enkvSFFieG1tV0xWV1NEMklFcnFwaTJ2SC9qY0NDVjlDbkVaWVl3clhpK2tjWDd3cS9aZzBBb0lzMlMiLCJtYWMiOiJmZmM5ZTljOWVlMDIwMjE5ZWE3MjZjNzlhYjM5Y2U1NDdmNGNmMDk4MDI5N2ZlMDA0M2M5YzFkODE4ZWY3YjJjIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6Ik9ZMWJQcmdXLytJVUsyNnRCdGp1ZFE9PSIsInZhbHVlIjoiaXBma3VhYVYxRFdjYUUxNDNRYnZmblhnRXFoQ3YxdlV4SWdKenQ0ZmRrZ2JLaENVemNrOXdkeHlVdktLd1FhVkEzWGJoa ▶"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_ACCEPT" => "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"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_HOST" => "nearmelisting.com"
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "nearmelisting.com"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "85.209.95.67"
  "REMOTE_USER" => ""
  "REMOTE_PORT" => "56411"
  "REMOTE_ADDR" => "18.227.209.106"
  "SERVER_SOFTWARE" => "nginx/1.18.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "HTTPS" => "on"
  "REQUEST_SCHEME" => "https"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "DOCUMENT_ROOT" => "/var/www/nearmelisting.com/public_html/public"
  "DOCUMENT_URI" => "/index.php"
  "REQUEST_URI" => "/best/new-hampshire/water-heater-installationrepair"
  "SCRIPT_NAME" => "/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "SCRIPT_FILENAME" => "/var/www/nearmelisting.com/public_html/public/index.php"
  "PATH_INFO" => ""
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1742675742.8673
  "REQUEST_TIME" => 1742675742
]
        request_cookies
          0 of 0   
        array:2 [▼
  "XSRF-TOKEN" => "tRbwARh2nnWxhevpvF99xo6fjetnoCXdwlD68FQ8"
  "nearmelisting_session" => "gsKgcRBNf5Hpv3i6GqpBLyKU7JCXW0xH3LnX13v6"
]
        response_headers
          0 of 0   
        array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sat, 22 Mar 2025 20:35:44 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im9KdlhPK3BKdjZUV0gwT1g1aURlRlE9PSIsInZhbHVlIjoiSUw0SityRVdtTkoyWlFLV2NqdTN5V0xBbUtkT2FmUTJiQVlDN09qTDJkTnhWQjJvRnhqbFEvQTdCK2hiWXRMTXlDaW9tajFqV3g2bDV6cm9SQnUrSXdVRzBEcWtyMTVzQ0N2QlBxSERQbDFsYTQrMHZGQmZaN2RraE9RVzNVcDQiLCJtYWMiOiIxMmUxZThmYTQ2MjE3NDkxNmE3MmRmYWY1ZGMzNWJhZWQ3ZDNiZjJjNjlhZDljYWNkMDFlZjBmZmVhYzNhZDYxIiwidGFnIjoiIn0%3D; expires=Sat, 22-Mar-2025 22:35:44 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6Im9KdlhPK3BKdjZUV0gwT1g1aURlRlE9PSIsInZhbHVlIjoiSUw0SityRVdtTkoyWlFLV2NqdTN5V0xBbUtkT2FmUTJiQVlDN09qTDJkTnhWQjJvRnhqbFEvQTdCK2hiWXRMTXlDaW9ta ▶"
    1 => "nearmelisting_session=eyJpdiI6Imo0QndZREJVZElxaG5YT0NTUlAxMWc9PSIsInZhbHVlIjoiRTNaVlBVTmp5ZVh5RjcvR21hb1dXRzlLbVVMVlVneHZDUWVXVjhVZFgyWko1WHJGY3oxcVpiTUttWUd5d0JZQVdDVmdSMWZOSU5OSzdibVlVZnZQTXNEWEpzNGJ1K2o4d3hjcnZSRjRjZUpMOTY0Z2pzRlZ6VjFNNnJCZWdiRk0iLCJtYWMiOiJmNWNmNzEzNzdkZjk2NGMwNDBhOGNjMTYzNTEwYzkzZjgxMmVmYmUyY2M1NWMzMmZjYzBiZWZiMTg2ZjBhOGI0IiwidGFnIjoiIn0%3D; expires=Sat, 22-Mar-2025 22:35:44 GMT; Max-Age=7200; path=/; httponly ◀nearmelisting_session=eyJpdiI6Imo0QndZREJVZElxaG5YT0NTUlAxMWc9PSIsInZhbHVlIjoiRTNaVlBVTmp5ZVh5RjcvR21hb1dXRzlLbVVMVlVneHZDUWVXVjhVZFgyWko1WHJGY3oxcVpiTUttWUd5d0 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im9KdlhPK3BKdjZUV0gwT1g1aURlRlE9PSIsInZhbHVlIjoiSUw0SityRVdtTkoyWlFLV2NqdTN5V0xBbUtkT2FmUTJiQVlDN09qTDJkTnhWQjJvRnhqbFEvQTdCK2hiWXRMTXlDaW9tajFqV3g2bDV6cm9SQnUrSXdVRzBEcWtyMTVzQ0N2QlBxSERQbDFsYTQrMHZGQmZaN2RraE9RVzNVcDQiLCJtYWMiOiIxMmUxZThmYTQ2MjE3NDkxNmE3MmRmYWY1ZGMzNWJhZWQ3ZDNiZjJjNjlhZDljYWNkMDFlZjBmZmVhYzNhZDYxIiwidGFnIjoiIn0%3D; expires=Sat, 22-Mar-2025 22:35:44 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Im9KdlhPK3BKdjZUV0gwT1g1aURlRlE9PSIsInZhbHVlIjoiSUw0SityRVdtTkoyWlFLV2NqdTN5V0xBbUtkT2FmUTJiQVlDN09qTDJkTnhWQjJvRnhqbFEvQTdCK2hiWXRMTXlDaW9ta ▶"
    1 => "nearmelisting_session=eyJpdiI6Imo0QndZREJVZElxaG5YT0NTUlAxMWc9PSIsInZhbHVlIjoiRTNaVlBVTmp5ZVh5RjcvR21hb1dXRzlLbVVMVlVneHZDUWVXVjhVZFgyWko1WHJGY3oxcVpiTUttWUd5d0JZQVdDVmdSMWZOSU5OSzdibVlVZnZQTXNEWEpzNGJ1K2o4d3hjcnZSRjRjZUpMOTY0Z2pzRlZ6VjFNNnJCZWdiRk0iLCJtYWMiOiJmNWNmNzEzNzdkZjk2NGMwNDBhOGNjMTYzNTEwYzkzZjgxMmVmYmUyY2M1NWMzMmZjYzBiZWZiMTg2ZjBhOGI0IiwidGFnIjoiIn0%3D; expires=Sat, 22-Mar-2025 22:35:44 GMT; path=/; httponly ◀nearmelisting_session=eyJpdiI6Imo0QndZREJVZElxaG5YT0NTUlAxMWc9PSIsInZhbHVlIjoiRTNaVlBVTmp5ZVh5RjcvR21hb1dXRzlLbVVMVlVneHZDUWVXVjhVZFgyWko1WHJGY3oxcVpiTUttWUd5d0 ▶"
  ]
]
        session_attributes
          0 of 0   
        array:6 [▼
  "_token" => "tRbwARh2nnWxhevpvF99xo6fjetnoCXdwlD68FQ8"
  "category_id" => "driving-schools-near-me"
  "_previous" => array:1 [▶
    "url" => "https://nearmelisting.com/best/new-hampshire/water-heater-installationrepair"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "bc_current_currency" => "jpy"
  "PHPDEBUGBAR_STACK_DATA" => []
]