Near Me Listing Near Me Listing

Advanced Search Hide Filter

Top 10 Water Heater Installation/Repair in Nashua, NH

  1. Home
  2. Nashua, NH
  3. Water Heater Installation/Repair

Get Best Water Heater Installation/Repair in Nashua, NH With Just One Click

To offer you the best, here we are suggesting the uppermost Water Heater Installation/Repair in Nashua, NH 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 Nashua, NH 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 Nashua, NH — Here’s What We Have Found For You

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

Showing 10 out of 10 Water Heater Installation/Repair in Nashua, NH local business services from USA.

Showing 1 - 10 of 10 results

Photos of Joyce Cooling & Heating Nashua, NH

Joyce Cooling & Heating
  • 51 Lake St NH 03060, Nashua, Nashua, NH
  • Home Services
  • Water heater installationrepair
  • ( 20 Reviews )
Established in 1995, Joyce Cooling & Heating Inc. continues to serve Nashua, NH and surrounding areas as a family-oriented business. Staying true to our roots, we provide the area with an honest, straightforward, and affordable source for a wide range of skilled residential and commercial servic
Photos of Joyce Cooling & Heating Nashua, NH
  • ( 20 Reviews )

(603) 889-1991

Photos of Ethical Home Pro Nashua, NH

Ethical Home Pro
  • 4 Old Nashua RdnSte 2 NH 03053, Londonderry, Nashua, NH
  • Home Services
  • Water heater installationrepair
  • ( 3 Reviews )
When we started Ethical Home Pro we wanted to be build something special, something different. Many companies talk about customer service, we focus our energy on providing a great customer experience. Our team is dedicated to being informative, answering your questions and providing options for you
Photos of Ethical Home Pro Nashua, NH
  • ( 3 Reviews )

(603) 216-2593

Photos of Andrew Plumbing & Heating Nashua, NH

Andrew Plumbing & Heating
  • 250 Canal St MA 01840, Lawrence , Nashua, NH
  • Plumbing
  • Water heater installationrepair
  • ( 2 Reviews )
We are a full service plumbing, heating company. We offer 24Hr. Emergency service. We specialize in Oil to Gas Heating system conversions,Water heater replacments, we also do complete bathroom remodels and much more. If you are not sure if we do something please don't hesitate to call and ask. Odds
Photos of Andrew Plumbing & Heating Nashua, NH
  • ( 2 Reviews )

(978) 764-9559

Photos of Derry Plumbing, Heating & Air Conditioning Nashua, NH

Derry Plumbing, Heating & Air Conditioning
  • 41 Birch St NH 03038, Derry, Nashua, NH
  • Heating & Air Conditioning/HVAC
  • Water heater installationrepair
  • ( 0 Review )
Proudly serving our community for over 30-years
Photos of Derry Plumbing, Heating & Air Conditioning Nashua, NH
  • ( 0 Review )

(603) 432-8564

Photos of Rick Jean Plumbing & Heating Nashua, NH

Rick Jean Plumbing & Heating
  • MA 01826, Dracut, Nashua, NH
  • Plumbing
  • Water heater installationrepair
  • ( 0 Review )
Rick Jean Plumbing & Heating Is located at Nashua, NH MA 01826, Dracut You can try dialing the following number: (978) 957-6023
Photos of Rick Jean Plumbing & Heating Nashua, NH
  • ( 0 Review )

(978) 957-6023

Photos of Doug Anderson Plumbing & Heating Nashua, NH

Doug Anderson Plumbing & Heating
  • MA 01824, Chelmsford, Nashua, NH
  • Plumbing
  • Water heater installationrepair
  • ( 0 Review )
Specializing in water heater installation & repair & plumbing. Customer Service is Our #1 Priority. Looking for a Plumber? Call today! 978-983-2111 Plumbing Service! New or Old Construction/Remodels! Boilers, Water Heaters and more!
Photos of Doug Anderson Plumbing & Heating Nashua, NH
  • ( 0 Review )

(978) 983-2111

Photos of J Ellis Plumbing and Heating Nashua, NH

J Ellis Plumbing and Heating
  • 70 Spaulding St MA 01469, Townsend, Nashua, NH
  • Plumbing
  • Water heater installationrepair
  • ( 0 Review )
Call us - you'll see why people love us!
Photos of J Ellis Plumbing and Heating Nashua, NH
  • ( 0 Review )

(978) 877-0295

Photos of JAD Plumbing Heating and Cooling Nashua, NH

JAD Plumbing Heating and Cooling
  • MA 01879, Tyngsborough, Nashua, NH
  • Plumbing
  • Water heater installationrepair
  • ( 0 Review )
With 20 years experience we we offer the best new technology in the trades with an old school work ethic and morals. We are happy when the customer is comfortable and happy.
Photos of JAD Plumbing Heating and Cooling Nashua, NH
  • ( 0 Review )

(978) 512-0859

Photos of ABH Plumbing & Heating Contractors Nashua, NH

ABH Plumbing & Heating Contractors
  • 190 Fairmount St MA 01420, Fitchburg, Nashua, NH
  • Plumbing
  • Water heater installationrepair
  • ( 0 Review )
ABH Plumbing & Heating continues to be your trusted plumbing and heating contractor with expert Master Plumbers, Oil Burner Technicians, and Gas Fitters. Specializing in all aspects of plumbing and heating, the ABH Team is involved in new/renovation home projects, real-estate foreclosures, resta
Photos of ABH Plumbing & Heating Contractors Nashua, NH
  • ( 0 Review )

(978) 668-5643

Photos of Roger Larose Plumbing and Heating Nashua, NH

Roger Larose Plumbing and Heating
  • MA 01469, Townsend, Nashua, NH
  • Plumbing
  • Water heater installationrepair
  • ( 0 Review )
Bathroom and Kitchen remodels. On demand water heaters,all types of service calls including boiler trouble shooting. New construction,gas lines,washer and dryer hookups.
Photos of Roger Larose Plumbing and Heating Nashua, NH
  • ( 0 Review )

(978) 835-6942

Related Categories

Show More >

Top Categories

Frequently Asked Questions:


How to find Water Heater Installation/Repair In Nashua, NH?

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


How to find best Water Heater Installation/Repair in Nashua, NH?

To find the best Water Heater Installation/Repair in Nashua, NH, 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 Nashua, NH?

To find the 24/7 Water Heater Installation/Repair service in Nashua, NH, 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 Nashua, NH?

Yes, you can use NearMeListing to find the Water Heater Installation/Repair in Nashua, NH 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

                 
Messages1TimelineExceptionsViews33RouteQueries98Models6501MailsGateSessionRequest
8.2.27PHP Version1.16sRequest Duration21MBMemory UsageGET best/{slug?}Route
  • warninglog[09:04:47] LOG.warning: Callables of the form ["Swift_SmtpTransport", "Swift_Transport_EsmtpTranspor...
  • Booting (14.6ms)
  • Application (1.15s)
  • 1 x Application (98.74%)
    1.15s
    1 x Booting (1.26%)
    14.60ms
    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)27blade
      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
      parts
      26
      parent_city
    • Property::frontend.layouts.form-search.fields.sidebar.option (modules/Property/Views/frontend/layouts/form-search/fields/sidebar/option.blade.php)37blade
      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
      parts
      26
      parent_city
      27
      property_search_fields
      28
      list_number
      29
      list_garages_value
      30
      current_year
      31
      list_year
      32
      year
      33
      field
      34
      list
      35
      holder
      36
      name
    • Property::frontend.layouts.form-search.fields.sidebar.option (modules/Property/Views/frontend/layouts/form-search/fields/sidebar/option.blade.php)37blade
      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
      parts
      26
      parent_city
      27
      property_search_fields
      28
      list_number
      29
      list_garages_value
      30
      current_year
      31
      list_year
      32
      year
      33
      field
      34
      list
      35
      holder
      36
      name
    • Property::frontend.layouts.search.loop.orderby (modules/Property/Views/frontend/layouts/search/loop/orderby.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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)39blade
      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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)39blade
      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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)39blade
      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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)39blade
      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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)39blade
      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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)39blade
      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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)39blade
      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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)39blade
      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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)39blade
      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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)39blade
      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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      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)44blade
      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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
      39
      i
      40
      related_category
      41
      slug
      42
      category_slug
      43
      loc
    • Layout::app (modules/Layout/app.blade.php)44blade
      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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
      39
      i
      40
      related_category
      41
      slug
      42
      category_slug
      43
      loc
    • Layout::parts.seo-meta (modules/Layout/parts/seo-meta.blade.php)46blade
      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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
      39
      i
      40
      related_category
      41
      slug
      42
      category_slug
      43
      loc
      44
      favicon
      45
      file
    • Layout::parts.secondary_header (modules/Layout/parts/secondary_header.blade.php)46blade
      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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
      39
      i
      40
      related_category
      41
      slug
      42
      category_slug
      43
      loc
      44
      favicon
      45
      file
    • Property::frontend.layouts.form-search.topbar (modules/Property/Views/frontend/layouts/form-search/topbar.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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
      39
      i
      40
      related_category
      41
      slug
      42
      category_slug
      43
      loc
      44
      favicon
      45
      file
      46
      user_listings_count
      47
      rold_id
      48
      gmapkey
      49
      mapkey
    • Property::frontend.layouts.form-search.fields.sidebar.attribute (modules/Property/Views/frontend/layouts/form-search/fields/sidebar/attribute.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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
      39
      i
      40
      related_category
      41
      slug
      42
      category_slug
      43
      loc
      44
      favicon
      45
      file
      46
      user_listings_count
      47
      rold_id
      48
      gmapkey
      49
      mapkey
      50
      location_input_field
      51
      pass_id
      52
      property_search_fields
      53
      field
      54
      key
      55
      holder
    • Property::frontend.layouts.form-search.fields.sidebar.option (modules/Property/Views/frontend/layouts/form-search/fields/sidebar/option.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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
      39
      i
      40
      related_category
      41
      slug
      42
      category_slug
      43
      loc
      44
      favicon
      45
      file
      46
      user_listings_count
      47
      rold_id
      48
      gmapkey
      49
      mapkey
      50
      location_input_field
      51
      pass_id
      52
      property_search_fields
      53
      field
      54
      list
      55
      holder
      56
      name
    • Property::frontend.layouts.form-search.fields.sidebar.option (modules/Property/Views/frontend/layouts/form-search/fields/sidebar/option.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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
      39
      i
      40
      related_category
      41
      slug
      42
      category_slug
      43
      loc
      44
      favicon
      45
      file
      46
      user_listings_count
      47
      rold_id
      48
      gmapkey
      49
      mapkey
      50
      location_input_field
      51
      pass_id
      52
      property_search_fields
      53
      field
      54
      list
      55
      holder
      56
      name
    • Property::frontend.layouts.form-search.fields.sidebar.attribute (modules/Property/Views/frontend/layouts/form-search/fields/sidebar/attribute.blade.php)58blade
      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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
      39
      i
      40
      related_category
      41
      slug
      42
      category_slug
      43
      loc
      44
      favicon
      45
      file
      46
      user_listings_count
      47
      rold_id
      48
      gmapkey
      49
      mapkey
      50
      location_input_field
      51
      pass_id
      52
      property_search_fields
      53
      field
      54
      categories
      55
      locations
      56
      key
      57
      holder
    • Core::frontend.currency-switcher (modules/Core/Views/frontend/currency-switcher.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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
      39
      i
      40
      related_category
      41
      slug
      42
      category_slug
      43
      loc
      44
      favicon
      45
      file
      46
      user_listings_count
      47
      rold_id
      48
      gmapkey
      49
      mapkey
    • Language::frontend.switcher (modules/Language/Views/frontend/switcher.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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
      39
      i
      40
      related_category
      41
      slug
      42
      category_slug
      43
      loc
      44
      favicon
      45
      file
      46
      user_listings_count
      47
      rold_id
      48
      gmapkey
      49
      mapkey
    • Layout::parts.notifications (modules/Layout/parts/notifications.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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
      39
      i
      40
      related_category
      41
      slug
      42
      category_slug
      43
      loc
      44
      favicon
      45
      file
      46
      user_listings_count
      47
      rold_id
      48
      gmapkey
      49
      mapkey
    • Language::frontend.switcher (modules/Language/Views/frontend/switcher.blade.php)53blade
      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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
      39
      i
      40
      related_category
      41
      slug
      42
      category_slug
      43
      loc
      44
      favicon
      45
      file
      46
      user_listings_count
      47
      rold_id
      48
      gmapkey
      49
      mapkey
      50
      logo_id
      51
      logo
      52
      mobile
    • Layout::parts.footer (modules/Layout/parts/footer.blade.php)46blade
      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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
      39
      i
      40
      related_category
      41
      slug
      42
      category_slug
      43
      loc
      44
      favicon
      45
      file
    • Layout::parts.login-register-modal (modules/Layout/parts/login-register-modal.blade.php)51blade
      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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
      39
      i
      40
      related_category
      41
      slug
      42
      category_slug
      43
      loc
      44
      favicon
      45
      file
      46
      path
      47
      endpath
      48
      list_widget_footers
      49
      item
      50
      key
    • Layout::auth.login-form (modules/Layout/auth/login-form.blade.php)51blade
      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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
      39
      i
      40
      related_category
      41
      slug
      42
      category_slug
      43
      loc
      44
      favicon
      45
      file
      46
      path
      47
      endpath
      48
      list_widget_footers
      49
      item
      50
      key
    • Layout::auth.register-form (modules/Layout/auth/register-form.blade.php)51blade
      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
      parts
      26
      parent_city
      27
      page_title
      28
      search_title1
      29
      serv1
      30
      loc1
      31
      protocol
      32
      CurPageURL1
      33
      CurPageURL
      34
      content
      35
      faq_detail
      36
      layout
      37
      j
      38
      count1
      39
      i
      40
      related_category
      41
      slug
      42
      category_slug
      43
      loc
      44
      favicon
      45
      file
      46
      path
      47
      endpath
      48
      list_widget_footers
      49
      item
      50
      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 unique919ms
    nearmelisting_db
    • select * from `bc_locations` where `slug` = 'nashua-nh' and `status` = 'publish' and `bc_locations`.`deleted_at` is null limit 1
      1.75ms/app/Http/Controllers/UriController.php:51nearmelisting_db
      Metadata
      Bindings
      • 0. nashua-nh
      • 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
      460μ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
      2.32ms/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)
      980μs/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
      3.64ms/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'
      680μ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` = 1141 and `pcs`.`category_id` = 353 and `bc_properties`.`deleted_at` is null group by `bc_properties`.`id`) as `aggregate_table`
      455ms/modules/Property/Models/Property.php:1121nearmelisting_db
      Metadata
      Bindings
      • 0. 12
      • 1. 141
      • 2. publish
      • 3. 1141
      • 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` = 1141 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
      115ms/modules/Property/Models/Property.php:1121nearmelisting_db
      Metadata
      Bindings
      • 0. 12
      • 1. 141
      • 2. publish
      • 3. 1141
      • 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 (1141) and `bc_locations`.`deleted_at` is null
      460μs/modules/Property/Models/Property.php:1121nearmelisting_db
      Metadata
      Bindings
      • 0. 1141
      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 (1141)
      400μ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 (67332, 83555, 585534, 585655, 585661, 585681, 585764, 585946, 586076, 586107)
      470μ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 (67332, 83555, 585534, 585655, 585661, 585681, 585764, 585946, 586076, 586107) and `bc_property_translations`.`deleted_at` is null
      330μ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
      390μ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 (67332, 83555, 585534, 585655, 585661, 585681, 585764, 585946, 586076, 586107) and `bc_property_category`.`deleted_at` is null
      1.41ms/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
      300μ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
      250μ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
      250μ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
      570μ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
      270ms/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` = 67332
      560μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 67332
      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` = 1141
      380μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 1141
      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` = 83555
      930μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 83555
      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` = 1141
      280μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 1141
      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` = 586107
      250μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 586107
      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` = 1141
      320μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 1141
      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` = 585534
      340μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585534
      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` = 1141
      350μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 1141
      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` = 585655
      280μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585655
      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` = 1141
      300μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 1141
      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` = 585661
      260μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585661
      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` = 1141
      350μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 1141
      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` = 585681
      240μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585681
      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` = 1141
      270μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 1141
      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` = 585764
      220μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585764
      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` = 1141
      250μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 1141
      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` = 585946
      220μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585946
      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` = 1141
      290μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 1141
      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` = 586076
      250μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 586076
      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` = 1141
      240μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 1141
      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` = 67332 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      2.15ms/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 67332
      • 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` = 67332
      390μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 67332
      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` = 67332
      360μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 67332
      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` = 67332
      590μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 67332
      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` = 83555 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      1.56ms/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 83555
      • 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` = 83555
      460μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 83555
      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` = 83555
      270μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 83555
      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` = 83555
      340μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 83555
      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` = 586107 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      2.44ms/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 586107
      • 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` = 586107
      320μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 586107
      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` = 586107
      270μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 586107
      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` = 586107
      320μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 586107
      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` = 585534 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      800μs/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 585534
      • 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` = 585534
      300μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585534
      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` = 585534
      340μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585534
      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` = 585534
      310μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585534
      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` = 585655 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      420μs/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 585655
      • 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` = 585655
      250μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585655
      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` = 585655
      240μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585655
      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` = 585655
      310μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585655
      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` = 585661 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      730μs/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 585661
      • 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` = 585661
      300μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585661
      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` = 585661
      360μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585661
      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` = 585661
      770μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585661
      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` = 585681 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      620μs/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 585681
      • 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` = 585681
      370μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585681
      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` = 585681
      530μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585681
      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` = 585681
      470μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585681
      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` = 585764 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      1.24ms/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 585764
      • 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` = 585764
      280μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585764
      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` = 585764
      550μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585764
      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` = 585764
      530μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585764
      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` = 585946 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      510μs/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 585946
      • 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` = 585946
      240μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585946
      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` = 585946
      280μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585946
      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` = 585946
      610μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 585946
      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` = 586076 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      490μs/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 586076
      • 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` = 586076
      250μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 586076
      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` = 586076
      270μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 586076
      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` = 586076
      350μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 586076
      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
      250μ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
      230μ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
      210μ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
      220μ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
      190μ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
      250μ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
      170μ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
      240μ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` = 586076
      250μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 586076
      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
      7.08msview::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
      6.39msview::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'
      790μsview::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'
      1.55msview::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'
      8.78msview::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
      630μ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
      3.02msview::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)
      1.08msview::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'
      2.06msview::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'
      2.14msview::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
    2948
    Modules\Location\Models\Location
    3074
        _token
        wAPFUyolgFXuqykGStJ6IDs9zhMxM4kgyK1AWfNj
        bc_current_currency
        jpy
        _previous
        array:1 [ "url" => "https://nearmelisting.com/best/nashua-nh/water-heater-installationrepair" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /best/nashua-nh/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=eyJpdiI6IkJrQ2w2WGxQOUNmVUd5RkdOQWFMRkE9PSIsInZhbHVlIjoiUlo3VEJFajAxZGNxSlhrQ2p3dGxsNEpxeW9RWnpYa2pRWHVxL3hidXo5S3JvbUpQOURqQ0Z0aXZUMDJZbGplSWlvMkZlSFFUdXdkNWF2dDhHMnZPaHZuRmFWSjdjOW1tdm5hODVMWFFhRmlvTEUvWGxYajhESXNjdGtBR3g0b2EiLCJtYWMiOiIyZTE2YWVlYWQ1YWI1ODg2YTE5MmZlMjFkMTVjNjI5MWUyNDMyMTg3NWZiNjc0MjM2NzhhNGIyZjFjOTMxZTVhIiwidGFnIjoiIn0%3D; nearmelisting_session=eyJpdiI6ImdRa3dMTC9PYkxFTE9OQmxrNUVaZ0E9PSIsInZhbHVlIjoic2EwOXZKUWR2UThuaXpBRlN5Q0twQUtXN0ZDWjRBSHVRY241OHlmVWlQYUVPTE02cXJacEFaWWR6bk1EVnpicXZkbTIzcWlhQmZ2TjRNYjg2Z2E1VXkrb3pIY0lla3J1MnRWRHNzdzhaQkkrVGNsZHYwTWhXNXZHK1k1Q0M4ZmQiLCJtYWMiOiI2YWQ3MTdiZDAyZTZiZDNiNjMwMGNiMTRkNjg5YWY4ZDk3NTU3NzE0NmI2YTQyYzlmNjcxODc0YzJlODliZmIyIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IkJrQ2w2WGxQOUNmVUd5RkdOQWFMRkE9PSIsInZhbHVlIjoiUlo3VEJFajAxZGNxSlhrQ2p3dGxsNEpxeW9RWnpYa2pRWHVxL3hidXo5S3JvbUpQOURqQ0Z0aXZUMDJZbGplSWlvMkZlS ▶"
  ]
  "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=eyJpdiI6IkJrQ2w2WGxQOUNmVUd5RkdOQWFMRkE9PSIsInZhbHVlIjoiUlo3VEJFajAxZGNxSlhrQ2p3dGxsNEpxeW9RWnpYa2pRWHVxL3hidXo5S3JvbUpQOURqQ0Z0aXZUMDJZbGplSWlvMkZlSFFUdXdkNWF2dDhHMnZPaHZuRmFWSjdjOW1tdm5hODVMWFFhRmlvTEUvWGxYajhESXNjdGtBR3g0b2EiLCJtYWMiOiIyZTE2YWVlYWQ1YWI1ODg2YTE5MmZlMjFkMTVjNjI5MWUyNDMyMTg3NWZiNjc0MjM2NzhhNGIyZjFjOTMxZTVhIiwidGFnIjoiIn0%3D; nearmelisting_session=eyJpdiI6ImdRa3dMTC9PYkxFTE9OQmxrNUVaZ0E9PSIsInZhbHVlIjoic2EwOXZKUWR2UThuaXpBRlN5Q0twQUtXN0ZDWjRBSHVRY241OHlmVWlQYUVPTE02cXJacEFaWWR6bk1EVnpicXZkbTIzcWlhQmZ2TjRNYjg2Z2E1VXkrb3pIY0lla3J1MnRWRHNzdzhaQkkrVGNsZHYwTWhXNXZHK1k1Q0M4ZmQiLCJtYWMiOiI2YWQ3MTdiZDAyZTZiZDNiNjMwMGNiMTRkNjg5YWY4ZDk3NTU3NzE0NmI2YTQyYzlmNjcxODc0YzJlODliZmIyIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IkJrQ2w2WGxQOUNmVUd5RkdOQWFMRkE9PSIsInZhbHVlIjoiUlo3VEJFajAxZGNxSlhrQ2p3dGxsNEpxeW9RWnpYa2pRWHVxL3hidXo5S3JvbUpQOURqQ0Z0aXZUMDJZbGplSWlvMkZlS ▶"
  "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" => "44003"
  "REMOTE_ADDR" => "52.14.162.200"
  "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/nashua-nh/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" => 1742634287.8176
  "REQUEST_TIME" => 1742634287
]
        request_cookies
          0 of 0   
        array:2 [▼
  "XSRF-TOKEN" => "wAPFUyolgFXuqykGStJ6IDs9zhMxM4kgyK1AWfNj"
  "nearmelisting_session" => "xZQCzetZ0Quu7SDZ2g2m8a0WzggmXxu4tCk7u2fC"
]
        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 09:04:48 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ink1a21KaFVQdWcyOHFvT0h1RTYzcFE9PSIsInZhbHVlIjoiSmdweW1PK21mdy9WT3ZaYTE1aVNjUnhaYjlWL3hRRXMzN1JWRVZ5UGwzRDlzcUEyUUsrT25JZi8yQU9Ta2p0ZnlYYUFlVFlZS0dMcks0ZDJQREtSVmsrb3pLaHE2TXI1dnRZbFhoRlIwbGE2NFhBYkM3WkQzdVYvdjd0VmxEUksiLCJtYWMiOiJkZTQ4YmE0ODg0ZGM2NTg1ZDg4ZTk1MDYwMzAyZjVjMWRiOWU0YTEwYTBjYTk0NzIyNDlkNjNhOGMyMWUyZmVmIiwidGFnIjoiIn0%3D; expires=Sat, 22-Mar-2025 11:04:48 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6Ink1a21KaFVQdWcyOHFvT0h1RTYzcFE9PSIsInZhbHVlIjoiSmdweW1PK21mdy9WT3ZaYTE1aVNjUnhaYjlWL3hRRXMzN1JWRVZ5UGwzRDlzcUEyUUsrT25JZi8yQU9Ta2p0ZnlYYUFlV ▶"
    1 => "nearmelisting_session=eyJpdiI6InFtaE9xK0lZbjM3d1pyOGx6NmdVWVE9PSIsInZhbHVlIjoibDgvMk81OWFlTXNIVVhLbWhCK0M1OHI2bzdPMVRQRnJvbForQ2w4bEFZZzFWcStZWTJTS3c0dGhqSHJTTjdFMVdsKzloWjZGalNnVzAvaldtWHBrL0JYc2EraE5uWDhsbTFvbHp1anZ3SHlIN3hhdXNXTzVkK1pUMThpNDNSb08iLCJtYWMiOiJmNzI2MDM2Y2FiNzA3NjVkYjUyZTM0MTVmZTM1Mjg5OTUzNjg5ZWZlZTFiNjJiZjQ0NTJkZjg0MjFlNzM0YzMzIiwidGFnIjoiIn0%3D; expires=Sat, 22-Mar-2025 11:04:48 GMT; Max-Age=7200; path=/; httponly ◀nearmelisting_session=eyJpdiI6InFtaE9xK0lZbjM3d1pyOGx6NmdVWVE9PSIsInZhbHVlIjoibDgvMk81OWFlTXNIVVhLbWhCK0M1OHI2bzdPMVRQRnJvbForQ2w4bEFZZzFWcStZWTJTS3c0dGhqSHJTTj ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ink1a21KaFVQdWcyOHFvT0h1RTYzcFE9PSIsInZhbHVlIjoiSmdweW1PK21mdy9WT3ZaYTE1aVNjUnhaYjlWL3hRRXMzN1JWRVZ5UGwzRDlzcUEyUUsrT25JZi8yQU9Ta2p0ZnlYYUFlVFlZS0dMcks0ZDJQREtSVmsrb3pLaHE2TXI1dnRZbFhoRlIwbGE2NFhBYkM3WkQzdVYvdjd0VmxEUksiLCJtYWMiOiJkZTQ4YmE0ODg0ZGM2NTg1ZDg4ZTk1MDYwMzAyZjVjMWRiOWU0YTEwYTBjYTk0NzIyNDlkNjNhOGMyMWUyZmVmIiwidGFnIjoiIn0%3D; expires=Sat, 22-Mar-2025 11:04:48 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ink1a21KaFVQdWcyOHFvT0h1RTYzcFE9PSIsInZhbHVlIjoiSmdweW1PK21mdy9WT3ZaYTE1aVNjUnhaYjlWL3hRRXMzN1JWRVZ5UGwzRDlzcUEyUUsrT25JZi8yQU9Ta2p0ZnlYYUFlV ▶"
    1 => "nearmelisting_session=eyJpdiI6InFtaE9xK0lZbjM3d1pyOGx6NmdVWVE9PSIsInZhbHVlIjoibDgvMk81OWFlTXNIVVhLbWhCK0M1OHI2bzdPMVRQRnJvbForQ2w4bEFZZzFWcStZWTJTS3c0dGhqSHJTTjdFMVdsKzloWjZGalNnVzAvaldtWHBrL0JYc2EraE5uWDhsbTFvbHp1anZ3SHlIN3hhdXNXTzVkK1pUMThpNDNSb08iLCJtYWMiOiJmNzI2MDM2Y2FiNzA3NjVkYjUyZTM0MTVmZTM1Mjg5OTUzNjg5ZWZlZTFiNjJiZjQ0NTJkZjg0MjFlNzM0YzMzIiwidGFnIjoiIn0%3D; expires=Sat, 22-Mar-2025 11:04:48 GMT; path=/; httponly ◀nearmelisting_session=eyJpdiI6InFtaE9xK0lZbjM3d1pyOGx6NmdVWVE9PSIsInZhbHVlIjoibDgvMk81OWFlTXNIVVhLbWhCK0M1OHI2bzdPMVRQRnJvbForQ2w4bEFZZzFWcStZWTJTS3c0dGhqSHJTTj ▶"
  ]
]
        session_attributes
          0 of 0   
        array:5 [▼
  "_token" => "wAPFUyolgFXuqykGStJ6IDs9zhMxM4kgyK1AWfNj"
  "bc_current_currency" => "jpy"
  "_previous" => array:1 [▶
    "url" => "https://nearmelisting.com/best/nashua-nh/water-heater-installationrepair"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]