Get Best Water Heater Installation/Repair in Fort Morgan, CO With Just One Click

Showing 1 - 4 of 4 results

Bob Staley’s Plumbing Heating & Air

  • 308 W Railroad Ave CO 80701, Fort Morgan, Fort Morgan, CO
  • Home Services
  • Water heater installationrepair
  • ( 6 Reviews )
At Bob Staley's Plumbing Heating & Air, we're proud of our 50+ years of a family owned and operated service to the Fort Morgan & Eastern Colorado area. We look forward to helping you with your plumbing, air conditioning, and heating needs. We're pleased to serve both residential and commerci
  • ( 6 Reviews )

(970) 867-5262

Mon - Fri, 8:00am - 5:00pm

Bershinsky Plumbing and Heating

  • 6395 Aviation Cir CO 80538, Loveland, Fort Morgan, CO
  • Home Services
  • Water heater installationrepair
  • ( 4 Reviews )
New construction and remodels Hot and tank-less water heaters Repairs and installation Pipe repairs and replacement Boilers and furnaces From simple plumbing repairs to the installation and replacement of water fixtures and piping, you can count on our team of professionals to get the job done right
  • ( 4 Reviews )

(970) 493-4355

Mon - Fri, 8:00am - 4:00pm

Cool Ducts

  • 2612 12th Ave CO 80631, Greeley, Fort Morgan, CO
  • Home Services
  • Water heater installationrepair
  • ( 1 Review )
Family locally owned Hvac company, Furnace repair and installation. Quality work at affordable prices.
  • ( 1 Review )

(720) 713-0202

All Day, 24x7 Hour

Bellendir Mechanical

  • CO 80701, Fort Morgan, Fort Morgan, CO
  • Home Services
  • Water heater installationrepair
  • ( 0 Review )
Bellendir Mechanical has been family owned and operated for over 6 generations. We are licensed, bonded and insured. Our Master Plumber is available to offer a variety of services, including hot water heat repair, service and install, camera service, radiant in floor heat, hot water heater service a
  • ( 0 Review )

(970) 867-7413

8.2.27PHP Version1.38sRequest Duration21MBMemory UsageGET best/{slug?}Route
  • warninglog[06:38:20] LOG.warning: Callables of the form ["Swift_SmtpTransport", "Swift_Transport_EsmtpTranspor...
  • Booting (18.21ms)
  • Application (1.36s)
  • 1 x Application (98.68%)
    1.36s
    1 x Booting (1.32%)
    18.21ms
    27 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
    • 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
    62 statements were executed, 27 of which were duplicated, 35 unique1.16s
    • select * from `bc_locations` where `slug` = 'fort-morgan-co' and `status` = 'publish' and `bc_locations`.`deleted_at` is null limit 1
      1.79ms/app/Http/Controllers/UriController.php:51nearmelisting_db
      Metadata
      Bindings
      • 0. fort-morgan-co
      • 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
      660μs/app/Http/Controllers/UriController.php:61nearmelisting_db
      Metadata
      Bindings
      • 0. water-heater-installationrepair
      • 1. publish
      Backtrace
      • 15. /app/Http/Controllers/UriController.php:61
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `bc_locations` where `status` = 'publish' and `bc_locations`.`deleted_at` is null limit 1000
      3.91ms/app/Http/Controllers/UriController.php:76nearmelisting_db
      Metadata
      Bindings
      • 0. publish
      Backtrace
      • 14. /app/Http/Controllers/UriController.php:76
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `bc_location_translations` where `bc_location_translations`.`origin_id` in (1, 3, 4, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527, 528, 529, 530, 531, 532, 533, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 601, 602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 648, 649, 650, 651, 652, 653, 654, 655, 656, 657, 658, 659, 660, 661, 662, 663, 664, 665, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 692, 693, 694, 695, 696, 697, 698, 699, 700, 701, 702, 703, 704, 705, 706, 707, 708, 709, 710, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782, 783, 784, 785, 786, 787, 788, 789, 790, 791, 792, 793, 794, 795, 796, 797, 798, 799, 800, 801, 802, 803, 804, 805, 806, 807, 808, 809, 810, 811, 812, 813, 814, 815, 816, 817, 818, 819, 820, 821, 822, 823, 824, 825, 826, 827, 828, 829, 830, 831, 832, 833, 834, 835, 836, 837, 838, 839, 840, 841, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 989, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002)
      1.16ms/app/Http/Controllers/UriController.php:76nearmelisting_db
      Metadata
      Backtrace
      • 19. /app/Http/Controllers/UriController.php:76
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `bc_property_category` where `status` = 'publish' and `bc_property_category`.`deleted_at` is null
      4.58ms/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'
      830μ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` = 282 and `pcs`.`category_id` = 353 and `bc_properties`.`deleted_at` is null group by `bc_properties`.`id`) as `aggregate_table`
      24.09ms/modules/Property/Models/Property.php:1121nearmelisting_db
      Metadata
      Bindings
      • 0. 12
      • 1. 141
      • 2. publish
      • 3. 282
      • 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` = 282 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
      3.6ms/modules/Property/Models/Property.php:1121nearmelisting_db
      Metadata
      Bindings
      • 0. 12
      • 1. 141
      • 2. publish
      • 3. 282
      • 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 (282) and `bc_locations`.`deleted_at` is null
      470μs/modules/Property/Models/Property.php:1121nearmelisting_db
      Metadata
      Bindings
      • 0. 282
      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 (282)
      500μ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 (11799, 11834, 11948, 11955)
      620μ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 (11799, 11834, 11948, 11955) and `bc_property_translations`.`deleted_at` is null
      430μ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
      450μ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 (11799, 11834, 11948, 11955) and `bc_property_category`.`deleted_at` is null
      680μs/modules/Property/Models/Property.php:1121nearmelisting_db
      Metadata
      Backtrace
      • 19. /modules/Property/Models/Property.php:1121
      • 20. /app/Http/Controllers/UriController.php:79
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
    • select `id`, `name`, `parent_id` from `bc_property_category` where `id` = 353
      370μ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
      310μ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
      210μ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
      890μ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
      1.08s/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` = 11799
      1.31ms/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 11799
      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` = 282
      430μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 282
      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` = 11948
      650μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 11948
      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` = 282
      310μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 282
      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` = 11955
      290μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 11955
      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` = 282
      320μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 282
      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` = 11834
      320μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 11834
      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` = 282
      310μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 282
      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` = 11799 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      2.4ms/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 11799
      • 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` = 11799
      300μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 11799
      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` = 11799
      320μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 11799
      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` = 11799
      410μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 11799
      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` = 11948 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      1.05ms/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 11948
      • 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` = 11948
      420μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 11948
      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` = 11948
      260μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 11948
      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` = 11948
      260μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 11948
      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` = 11955 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      540μs/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 11955
      • 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` = 11955
      260μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 11955
      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` = 11955
      290μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 11955
      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` = 11955
      280μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 11955
      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` = 11834 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      450μs/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 11834
      • 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` = 11834
      300μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 11834
      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` = 11834
      270μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 11834
      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` = 11834
      340μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 11834
      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
      260μ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
      240μ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
      270μ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
      210μ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
      230μ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
      230μs/app/Helpers/AppHelper.php:1211nearmelisting_db
      Metadata
      Bindings
      • 0. 93
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1211
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `slug`, `name` from `bc_property_category` where `id` = 311
      260μs/app/Helpers/AppHelper.php:1211nearmelisting_db
      Metadata
      Bindings
      • 0. 311
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1211
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `image_dir` from `bc_properties` where `id` = 11834
      280μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 11834
      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
      8.13msview::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
      7.99msview::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'
      650μ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.74msview::ae48feb0b3f21c9fe6b5276e43fae42bc8e49c39:87nearmelisting_db
      Metadata
      Bindings
      • 0. publish
      Backtrace
      • 12. view::ae48feb0b3f21c9fe6b5276e43fae42bc8e49c39:87
      • 14. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 17. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select LOWER(name) as name from `bc_locations` where `status` = 'publish' and `parent_id` != '0'
      1.81msview::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
      440μsview::3598bd890c7f26491dfc8a0c263a2b668ba24af3:5nearmelisting_db
      Metadata
      Bindings
      • 0. property
      • 1. 1
      Backtrace
      • 16. view::3598bd890c7f26491dfc8a0c263a2b668ba24af3:5
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select * from `bc_terms` where `bc_terms`.`attr_id` in (1) and `bc_terms`.`deleted_at` is null
      1.44msview::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)
      700μsview::3598bd890c7f26491dfc8a0c263a2b668ba24af3:5nearmelisting_db
      Metadata
      Backtrace
      • 26. view::3598bd890c7f26491dfc8a0c263a2b668ba24af3:5
      • 28. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 29. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 30. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 31. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select LOWER(name) as name from `bc_property_category` where `status` = 'publish'
      1.29msview::dcb94a1209b2515f6c510112090436090ea192e3:420nearmelisting_db
      Metadata
      Bindings
      • 0. publish
      Backtrace
      • 12. view::dcb94a1209b2515f6c510112090436090ea192e3:420
      • 14. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 17. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select LOWER(name) as name from `bc_locations` where `status` = 'publish' and `parent_id` != '0'
      1.31msview::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
    4
    Modules\Property\Models\Property
    4
    Modules\Property\Models\PropertyCategory
    2936
    Modules\Location\Models\Location
    3074
        _token
        9yIOqDw4kKFv15ne6aFhnCkhurLjmg5ZaFWhGPjp
        bc_current_currency
        usd
        _previous
        array:1 [ "url" => "https://nearmelisting.com/best/fort-morgan-co/water-heater-installationrepair"...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /best/fort-morgan-co/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=eyJpdiI6IjlkQVIyeTV1MS8vU1JNcDVNT09FSVE9PSIsInZhbHVlIjoicytuR2hGWE5wcUkwa1JDNWw5WG54d2dsOW1Samhjakx3QTBJV080S0Y4aWRzb20zZXc2MWdNTjBubTYveTJjQ29wZkxOLzE5VTQrRmtQa0xEUHNJQW5UUndMR09zdys1SWt1aEREblF6WXNKTDFwNVVzenJhLzhYdnAzZDhlYnYiLCJtYWMiOiI5ZjQ2YmZlMzA1ZmRiYjdlOGI1NDkxNTllNmIyNzFiYjJlYjAzZGY0OGRmYTM3NzA3MDk2NWE4NTliY2ZlYWRkIiwidGFnIjoiIn0%3D; nearmelisting_session=eyJpdiI6IjFDdEZEd0E3WWQvWGJjS0JCNWlZMWc9PSIsInZhbHVlIjoiaDJ1cU90UVFVM2J5eG0vMmdRQmJWNnpPQVp1UmVkUXphS0ZZdzdPWWorSVRETXBycEpWd2xzUy9UaHNRNTBzMkU4MFJTbkJJNktKL3pQUkNtandZNng2cGZRTEFCeFJhWFFWZ2dlTkFuM0dFVVk0T3Jva2w0WVFoQmpwaEJJUlIiLCJtYWMiOiIyMTNjYTQwZjA3OTA4ZWU4Zjg3NWJhNDJiMDhlYjQ0N2Q4NWE3ZDI5Mzc2NjkxY2I2ZjkxNTg1N2M1YjY3NTdmIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6IjlkQVIyeTV1MS8vU1JNcDVNT09FSVE9PSIsInZhbHVlIjoicytuR2hGWE5wcUkwa1JDNWw5WG54d2dsOW1Samhjakx3QTBJV080S0Y4aWRzb20zZXc2MWdNTjBubTYveTJjQ29wZkxOL" ] "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=eyJpdiI6IjlkQVIyeTV1MS8vU1JNcDVNT09FSVE9PSIsInZhbHVlIjoicytuR2hGWE5wcUkwa1JDNWw5WG54d2dsOW1Samhjakx3QTBJV080S0Y4aWRzb20zZXc2MWdNTjBubTYveTJjQ29wZkxOLzE5VTQrRmtQa0xEUHNJQW5UUndMR09zdys1SWt1aEREblF6WXNKTDFwNVVzenJhLzhYdnAzZDhlYnYiLCJtYWMiOiI5ZjQ2YmZlMzA1ZmRiYjdlOGI1NDkxNTllNmIyNzFiYjJlYjAzZGY0OGRmYTM3NzA3MDk2NWE4NTliY2ZlYWRkIiwidGFnIjoiIn0%3D; nearmelisting_session=eyJpdiI6IjFDdEZEd0E3WWQvWGJjS0JCNWlZMWc9PSIsInZhbHVlIjoiaDJ1cU90UVFVM2J5eG0vMmdRQmJWNnpPQVp1UmVkUXphS0ZZdzdPWWorSVRETXBycEpWd2xzUy9UaHNRNTBzMkU4MFJTbkJJNktKL3pQUkNtandZNng2cGZRTEFCeFJhWFFWZ2dlTkFuM0dFVVk0T3Jva2w0WVFoQmpwaEJJUlIiLCJtYWMiOiIyMTNjYTQwZjA3OTA4ZWU4Zjg3NWJhNDJiMDhlYjQ0N2Q4NWE3ZDI5Mzc2NjkxY2I2ZjkxNTg1N2M1YjY3NTdmIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6IjlkQVIyeTV1MS8vU1JNcDVNT09FSVE9PSIsInZhbHVlIjoicytuR2hGWE5wcUkwa1JDNWw5WG54d2dsOW1Samhjakx3QTBJV080S0Y4aWRzb20zZXc2MWdNTjBubTYveTJjQ29wZkxOL" "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" => "49257" "REMOTE_ADDR" => "18.191.44.99" "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/fort-morgan-co/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" => 1743230300.8005 "REQUEST_TIME" => 1743230300 ]
        request_cookies
        0 of 0
        array:2 [ "XSRF-TOKEN" => "9yIOqDw4kKFv15ne6aFhnCkhurLjmg5ZaFWhGPjp" "nearmelisting_session" => "6R03zzEitxRvX6eGUSsj6bMjadx44zwgvrkFFXp5" ]
        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, 29 Mar 2025 06:38:22 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImV4OGhISThIQXpiQUlyK2JaMDJ1V0E9PSIsInZhbHVlIjoiMFc4OGpzL1JySU9GazVFVjFwdEltN1dCb2ZEeWNJTDFzTy9tNE9xakZOOXc0M0hrSnRoTEp2ZDNUa3VFQTR3NHppeHQrVjR6MVdJdkxSMi9KMFV2cmJoR3Nrd2dnQlF3NWhZZ1REVXNwYmhscFpBeXJkMjFTekEyeEdHdDNRZk4iLCJtYWMiOiI5ODc4MjQyMzZiYmY4NmU3MTUzNWFhY2NhODJhODFlZjdjYjg0N2VmZDRlMmZjNDkxNWFhMGU5NjY2N2ZmOWJhIiwidGFnIjoiIn0%3D; expires=Sat, 29-Mar-2025 08:38:22 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6ImV4OGhISThIQXpiQUlyK2JaMDJ1V0E9PSIsInZhbHVlIjoiMFc4OGpzL1JySU9GazVFVjFwdEltN1dCb2ZEeWNJTDFzTy9tNE9xakZOOXc0M0hrSnRoTEp2ZDNUa3VFQTR3NHppeHQrV" 1 => "nearmelisting_session=eyJpdiI6IjVydy80ZEdNcXBhaU1iQUQvaERXWnc9PSIsInZhbHVlIjoiZEw5aGpHRVhjOGRWVWlSendBTHZUZFMva084TmZlVTc5VjBlWFdGbUNtTEtXQ09sZHp2TlBjRkltVEhxVUZTSXQ1SXdYeHZ6akFRbklYRVRqOVBDRWFxMVcwYTN1bkZYOGpqc2ZabW5wMXdKWTdydzk2SktMa01aR1NPMFJjMVMiLCJtYWMiOiI5Mjk2MDc3ZjBiOWU5MzYyOTU2NzNlYTU5MDVlODU0MTI2YTJhZDRlOWE4MTliYzM0ZDBmMjg1MDJmNDY4ZWE1IiwidGFnIjoiIn0%3D; expires=Sat, 29-Mar-2025 08:38:22 GMT; Max-Age=7200; path=/; httponlynearmelisting_session=eyJpdiI6IjVydy80ZEdNcXBhaU1iQUQvaERXWnc9PSIsInZhbHVlIjoiZEw5aGpHRVhjOGRWVWlSendBTHZUZFMva084TmZlVTc5VjBlWFdGbUNtTEtXQ09sZHp2TlBjRkltVEhxVU" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImV4OGhISThIQXpiQUlyK2JaMDJ1V0E9PSIsInZhbHVlIjoiMFc4OGpzL1JySU9GazVFVjFwdEltN1dCb2ZEeWNJTDFzTy9tNE9xakZOOXc0M0hrSnRoTEp2ZDNUa3VFQTR3NHppeHQrVjR6MVdJdkxSMi9KMFV2cmJoR3Nrd2dnQlF3NWhZZ1REVXNwYmhscFpBeXJkMjFTekEyeEdHdDNRZk4iLCJtYWMiOiI5ODc4MjQyMzZiYmY4NmU3MTUzNWFhY2NhODJhODFlZjdjYjg0N2VmZDRlMmZjNDkxNWFhMGU5NjY2N2ZmOWJhIiwidGFnIjoiIn0%3D; expires=Sat, 29-Mar-2025 08:38:22 GMT; path=/XSRF-TOKEN=eyJpdiI6ImV4OGhISThIQXpiQUlyK2JaMDJ1V0E9PSIsInZhbHVlIjoiMFc4OGpzL1JySU9GazVFVjFwdEltN1dCb2ZEeWNJTDFzTy9tNE9xakZOOXc0M0hrSnRoTEp2ZDNUa3VFQTR3NHppeHQrV" 1 => "nearmelisting_session=eyJpdiI6IjVydy80ZEdNcXBhaU1iQUQvaERXWnc9PSIsInZhbHVlIjoiZEw5aGpHRVhjOGRWVWlSendBTHZUZFMva084TmZlVTc5VjBlWFdGbUNtTEtXQ09sZHp2TlBjRkltVEhxVUZTSXQ1SXdYeHZ6akFRbklYRVRqOVBDRWFxMVcwYTN1bkZYOGpqc2ZabW5wMXdKWTdydzk2SktMa01aR1NPMFJjMVMiLCJtYWMiOiI5Mjk2MDc3ZjBiOWU5MzYyOTU2NzNlYTU5MDVlODU0MTI2YTJhZDRlOWE4MTliYzM0ZDBmMjg1MDJmNDY4ZWE1IiwidGFnIjoiIn0%3D; expires=Sat, 29-Mar-2025 08:38:22 GMT; path=/; httponlynearmelisting_session=eyJpdiI6IjVydy80ZEdNcXBhaU1iQUQvaERXWnc9PSIsInZhbHVlIjoiZEw5aGpHRVhjOGRWVWlSendBTHZUZFMva084TmZlVTc5VjBlWFdGbUNtTEtXQ09sZHp2TlBjRkltVEhxVU" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "9yIOqDw4kKFv15ne6aFhnCkhurLjmg5ZaFWhGPjp" "bc_current_currency" => "usd" "_previous" => array:1 [ "url" => "https://nearmelisting.com/best/fort-morgan-co/water-heater-installationrepair" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]