Get Best Windows Installation in New Jersey With Just One Click

Showing 1 - 5 of 5 results

Leisure Living

  • 311 US Highway 46 NJ 07004, Fairfield, New Jersey
  • Decks
  • Windows installation
  • ( 0 Review )
Leisure Living, Inc. is the premier sunroom dealer certified to sell and install a line of three season and all season sunrooms in North and Central New Jersey. Leisure Living, Inc. has been satisfying customers since 1989 with its superb installation and total customer satisfaction. Please check o
  • ( 0 Review )

(973) 808-0305

Mon - Sat, 10:00am - 2:00pm

A&K Artistic Masonry

  • 127 Pacific Ave NJ 07026, Garfield, New Jersey
  • Decks
  • Windows installation
  • ( 0 Review )
A&K Artistic Masonry Is located at New Jersey 127 Pacific Ave NJ 07026, Garfield You can try dialing the following number: (862) 264-8871
  • ( 0 Review )

(862) 264-8871

All Day, 24x7 Hour

American Eagle Brothers

  • NJ 07208, Elizabeth, New Jersey
  • Decks
  • Windows installation
  • ( 0 Review )
American Eagle Brothers Is located at New Jersey NJ 07208, Elizabeth You can try dialing the following number: (908) 966-7729
  • ( 0 Review )

(908) 966-7729

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

C&C Brother’s Construction

  • NJ 07109, Belleville, New Jersey
  • Decks
  • Windows installation
  • ( 0 Review )
C&C Brother’s Construction Is located at New Jersey NJ 07109, Belleville You can try dialing the following number: (201) 691-4334
  • ( 0 Review )

(201) 691-4334

American Affordable Quality

  • NJ 07050, City of Orange, New Jersey
  • Decks
  • Windows installation
  • ( 0 Review )
We do commercial roofing, commercial concrete
  • ( 0 Review )

(862) 438-3531

8.2.27PHP Version742msRequest Duration24MBMemory UsageGET best/{slug?}Route
  • warninglog[23:18:26] LOG.warning: Callables of the form ["Swift_SmtpTransport", "Swift_Transport_EsmtpTranspor...
  • Booting (19.11ms)
  • Application (723ms)
  • 1 x Application (97.42%)
    723ms
    1 x Booting (2.57%)
    19.11ms
    28 templates were rendered
    • Property::frontend.category.detail-static-page (modules/Property/Views/frontend/category/detail-static-page.blade.php)16blade
      Params
      0
      row
      1
      translation
      2
      list_location
      3
      list_category
      4
      property_min_max_price
      5
      rows
      6
      seo_meta
      7
      location_name
      8
      cat_name
      9
      get_related_category
      10
      getTopCategory
      11
      category_name
      12
      bg_image_url
      13
      enable_category_box
      14
      hide_form_search
      15
      service_types
    • Property::frontend.layouts.search.filter-search-mobile (modules/Property/Views/frontend/layouts/search/filter-search-mobile.blade.php)26blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
    • Property::frontend.layouts.form-search.fields.sidebar.option (modules/Property/Views/frontend/layouts/form-search/fields/sidebar/option.blade.php)36blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      property_search_fields
      27
      list_number
      28
      list_garages_value
      29
      current_year
      30
      list_year
      31
      year
      32
      field
      33
      list
      34
      holder
      35
      name
    • Property::frontend.layouts.form-search.fields.sidebar.option (modules/Property/Views/frontend/layouts/form-search/fields/sidebar/option.blade.php)36blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      property_search_fields
      27
      list_number
      28
      list_garages_value
      29
      current_year
      30
      list_year
      31
      year
      32
      field
      33
      list
      34
      holder
      35
      name
    • Property::frontend.layouts.search.loop.orderby (modules/Property/Views/frontend/layouts/search/loop/orderby.blade.php)35blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)38blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)38blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)38blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)38blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
    • Property::frontend.layouts.search.loop.loop-list-static (modules/Property/Views/frontend/layouts/search/loop/loop-list-static.blade.php)38blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
    • pagination::bootstrap-4 (resources/views/vendor/pagination/bootstrap-4.blade.php)2blade
      Params
      0
      paginator
      1
      elements
    • layouts.app (resources/views/layouts/app.blade.php)43blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
    • Layout::app (modules/Layout/app.blade.php)43blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
    • Layout::parts.seo-meta (modules/Layout/parts/seo-meta.blade.php)45blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
    • Layout::parts.secondary_header (modules/Layout/parts/secondary_header.blade.php)45blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
    • Property::frontend.layouts.form-search.topbar (modules/Property/Views/frontend/layouts/form-search/topbar.blade.php)49blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      user_listings_count
      46
      rold_id
      47
      gmapkey
      48
      mapkey
    • Property::frontend.layouts.form-search.fields.sidebar.attribute (modules/Property/Views/frontend/layouts/form-search/fields/sidebar/attribute.blade.php)55blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      user_listings_count
      46
      rold_id
      47
      gmapkey
      48
      mapkey
      49
      location_input_field
      50
      pass_id
      51
      property_search_fields
      52
      field
      53
      key
      54
      holder
    • Property::frontend.layouts.form-search.fields.sidebar.option (modules/Property/Views/frontend/layouts/form-search/fields/sidebar/option.blade.php)56blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      user_listings_count
      46
      rold_id
      47
      gmapkey
      48
      mapkey
      49
      location_input_field
      50
      pass_id
      51
      property_search_fields
      52
      field
      53
      list
      54
      holder
      55
      name
    • Property::frontend.layouts.form-search.fields.sidebar.option (modules/Property/Views/frontend/layouts/form-search/fields/sidebar/option.blade.php)56blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      user_listings_count
      46
      rold_id
      47
      gmapkey
      48
      mapkey
      49
      location_input_field
      50
      pass_id
      51
      property_search_fields
      52
      field
      53
      list
      54
      holder
      55
      name
    • Property::frontend.layouts.form-search.fields.sidebar.attribute (modules/Property/Views/frontend/layouts/form-search/fields/sidebar/attribute.blade.php)57blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      user_listings_count
      46
      rold_id
      47
      gmapkey
      48
      mapkey
      49
      location_input_field
      50
      pass_id
      51
      property_search_fields
      52
      field
      53
      categories
      54
      locations
      55
      key
      56
      holder
    • Core::frontend.currency-switcher (modules/Core/Views/frontend/currency-switcher.blade.php)49blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      user_listings_count
      46
      rold_id
      47
      gmapkey
      48
      mapkey
    • Language::frontend.switcher (modules/Language/Views/frontend/switcher.blade.php)49blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      user_listings_count
      46
      rold_id
      47
      gmapkey
      48
      mapkey
    • Layout::parts.notifications (modules/Layout/parts/notifications.blade.php)49blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      user_listings_count
      46
      rold_id
      47
      gmapkey
      48
      mapkey
    • Language::frontend.switcher (modules/Language/Views/frontend/switcher.blade.php)52blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      user_listings_count
      46
      rold_id
      47
      gmapkey
      48
      mapkey
      49
      logo_id
      50
      logo
      51
      mobile
    • Layout::parts.footer (modules/Layout/parts/footer.blade.php)45blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
    • Layout::parts.login-register-modal (modules/Layout/parts/login-register-modal.blade.php)50blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      path
      46
      endpath
      47
      list_widget_footers
      48
      item
      49
      key
    • Layout::auth.login-form (modules/Layout/auth/login-form.blade.php)50blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      path
      46
      endpath
      47
      list_widget_footers
      48
      item
      49
      key
    • Layout::auth.register-form (modules/Layout/auth/register-form.blade.php)50blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      row
      4
      translation
      5
      list_location
      6
      list_category
      7
      property_min_max_price
      8
      rows
      9
      seo_meta
      10
      location_name
      11
      cat_name
      12
      get_related_category
      13
      getTopCategory
      14
      category_name
      15
      bg_image_url
      16
      enable_category_box
      17
      hide_form_search
      18
      service_types
      19
      __currentLoopData
      20
      loop
      21
      gallery
      22
      location_details
      23
      location_slug
      24
      searchForValue
      25
      parent_city
      26
      page_title
      27
      search_title1
      28
      serv1
      29
      loc1
      30
      protocol
      31
      CurPageURL1
      32
      CurPageURL
      33
      content
      34
      faq_detail
      35
      layout
      36
      j
      37
      count1
      38
      i
      39
      related_category
      40
      slug
      41
      category_slug
      42
      loc
      43
      favicon
      44
      file
      45
      path
      46
      endpath
      47
      list_widget_footers
      48
      item
      49
      key
    uri
    GET best/{slug?}
    middleware
    web
    uses
    App\Http\Controllers\UriController@__invoke
    controller
    App\Http\Controllers\UriController
    namespace
    App\Http\Controllers
    prefix
    /best
    where
    as
    page_url
    67 statements were executed, 32 of which were duplicated, 35 unique531ms
    • select * from `bc_locations` where `slug` = 'new-jersey' and `status` = 'publish' and `bc_locations`.`deleted_at` is null limit 1
      3.85ms/app/Http/Controllers/UriController.php:51nearmelisting_db
      Metadata
      Bindings
      • 0. new-jersey
      • 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` = 'windows-installation' and `status` = 'publish' and `bc_property_category`.`deleted_at` is null limit 1
      1.39ms/app/Http/Controllers/UriController.php:61nearmelisting_db
      Metadata
      Bindings
      • 0. windows-installation
      • 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.75ms/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.11ms/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.37ms/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'
      750μ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` = 6 and `pcs`.`category_id` = 486 and `bc_properties`.`deleted_at` is null group by `bc_properties`.`id`) as `aggregate_table`
      163ms/modules/Property/Models/Property.php:1121nearmelisting_db
      Metadata
      Bindings
      • 0. 12
      • 1. 141
      • 2. publish
      • 3. 6
      • 4. 486
      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` = 6 and `pcs`.`category_id` = 486 and `bc_properties`.`deleted_at` is null group by `bc_properties`.`id` order by `points` desc limit 10 offset 0
      6.33ms/modules/Property/Models/Property.php:1121nearmelisting_db
      Metadata
      Bindings
      • 0. 12
      • 1. 141
      • 2. publish
      • 3. 6
      • 4. 486
      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 (6) and `bc_locations`.`deleted_at` is null
      360μs/modules/Property/Models/Property.php:1121nearmelisting_db
      Metadata
      Bindings
      • 0. 6
      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 (6)
      320μ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 (628610, 628677, 628767, 628802, 628856)
      450μ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 (628610, 628677, 628767, 628802, 628856) and `bc_property_translations`.`deleted_at` is null
      370μs/modules/Property/Models/Property.php:1121nearmelisting_db
      Metadata
      Backtrace
      • 20. /modules/Property/Models/Property.php:1121
      • 21. /app/Http/Controllers/UriController.php:79
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
    • select * from `users` where `users`.`id` in (0) and `users`.`deleted_at` is null
      630μ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 (628610, 628677, 628767, 628802, 628856) and `bc_property_category`.`deleted_at` is null
      990μ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` = 486
      540μs/app/Helpers/AppHelper.php:1170nearmelisting_db
      Metadata
      Bindings
      • 0. 486
      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` = 15
      1.02ms/app/Helpers/AppHelper.php:1170nearmelisting_db
      Metadata
      Bindings
      • 0. 15
      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 `name`, `slug` from `bc_property_category` where `parent_id` = 15
      800μ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
      307ms/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` = 628610
      460μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628610
      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` = 6
      270μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 6
      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` = 628802
      230μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628802
      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` = 6
      280μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 6
      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` = 628856
      290μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628856
      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` = 6
      240μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 6
      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` = 628677
      220μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628677
      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` = 6
      250μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 6
      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` = 628767
      260μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628767
      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` = 6
      250μs/app/Helpers/AppHelper.php:1155nearmelisting_db
      Metadata
      Bindings
      • 0. 6
      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` = 628610 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      1.12ms/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 628610
      • 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` = 628610
      260μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628610
      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` = 628610
      190μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628610
      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` = 628610
      250μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628610
      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` = 628802 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      750μs/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 628802
      • 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` = 628802
      330μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628802
      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` = 628802
      340μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628802
      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` = 628802
      470μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628802
      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` = 628856 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      520μs/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 628856
      • 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` = 628856
      320μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628856
      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` = 628856
      320μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628856
      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` = 628856
      260μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628856
      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` = 628677 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      1.15ms/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 628677
      • 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` = 628677
      370μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628677
      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` = 628677
      470μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628677
      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` = 628677
      710μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628677
      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` = 628767 and `object_model` = 'property' and `status` = 'approved' and `bc_review`.`deleted_at` is null limit 1
      600μs/modules/Review/Models/Review.php:164nearmelisting_db
      Metadata
      Bindings
      • 0. 628767
      • 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` = 628767
      390μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628767
      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` = 628767
      280μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628767
      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` = 628767
      270μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628767
      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
      290μ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
      260μ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
      230μ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
      280μs/app/Helpers/AppHelper.php:1211nearmelisting_db
      Metadata
      Bindings
      • 0. 92
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1211
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `slug`, `name` from `bc_property_category` where `id` = 366
      250μs/app/Helpers/AppHelper.php:1211nearmelisting_db
      Metadata
      Bindings
      • 0. 366
      Backtrace
      • 12. /app/Helpers/AppHelper.php:1211
      • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
    • select `slug`, `name` from `bc_property_category` where `id` = 354
      260μ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
      240μ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
      300μ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` = 628767
      310μs/app/Models/nbImages.php:27nearmelisting_db
      Metadata
      Bindings
      • 0. 628767
      Backtrace
      • 12. /app/Models/nbImages.php:27
      • 13. /app/Models/nbImages.php:343
      • 14. /app/Helpers/CustomHelper.php:46
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select * from `bc_locations` where `status` = 'publish' and `bc_locations`.`deleted_at` is null
      5.02msview::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
      4.02msview::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'
      570μ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.3msview::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'
      3.56msview::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
      570μ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.93msview::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)
      880μ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.25msview::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.44msview::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
    5
    Modules\Property\Models\Property
    5
    Modules\Property\Models\PropertyCategory
    2941
    Modules\Location\Models\Location
    3074
        _token
        5kkdSmYlE6GDzJXDwrR8fXjN54ydsBscgmFgy5A2
        _previous
        array:1 [ "url" => "https://nearmelisting.com/best/new-jersey/windows-installation" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /best/new-jersey/windows-installation
        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:15 [ "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:43 [ "USER" => "www-data" "HOME" => "/var/www" "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" => "21440" "REMOTE_ADDR" => "3.137.187.238" "SERVER_SOFTWARE" => "nginx/1.18.0" "GATEWAY_INTERFACE" => "CGI/1.1" "HTTPS" => "on" "REQUEST_SCHEME" => "https" "SERVER_PROTOCOL" => "HTTP/1.1" "DOCUMENT_ROOT" => "/var/www/nearmelisting.com/public_html/public" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/best/new-jersey/windows-installation" "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" => 1742426306.0112 "REQUEST_TIME" => 1742426306 ]
        request_cookies
        []
        
        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 => "Wed, 19 Mar 2025 23:18:26 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjFKZTc3RXBBc0p0UjF4ZWNUM3NndUE9PSIsInZhbHVlIjoiNXA3OFh4TW9vV2dwQ2hURDBDdWlkK0ZQUlVpZjVFcEJWVXlwaXBZdDcrQ240SkdPN3lSMm5RdktJWmEvQWNtR1hSYWNDMEdvSXdGTkVNSFVoK28vZWhGSGgzWDhONGltc1RFcHBnRjNPdTB1MExJOWNjVDUzeWZJajZNdm9IYXoiLCJtYWMiOiI1NzQyODU5Y2QwMzQ3MTIyZWE5YWFhYzk1MzE0ZmNiMzJiMjE3ODg2ZmFmOTc4ZWE5ODIxZjk1MzgyYjBkMTk3IiwidGFnIjoiIn0%3D; expires=Thu, 20-Mar-2025 01:18:26 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IjFKZTc3RXBBc0p0UjF4ZWNUM3NndUE9PSIsInZhbHVlIjoiNXA3OFh4TW9vV2dwQ2hURDBDdWlkK0ZQUlVpZjVFcEJWVXlwaXBZdDcrQ240SkdPN3lSMm5RdktJWmEvQWNtR1hSYWNDM" 1 => "nearmelisting_session=eyJpdiI6InAzaTVDRUpJcml5bEdHV3k3VDRIbEE9PSIsInZhbHVlIjoiTzEwNVZSUUJ0UGV0MkVtTkdyY09aYnUxRzE2SzlvRmdZWmVOZmlJd2ZMQmRBN2RXWjNLZnBtTUdGVjltcDBSeVBBYXFzK2NEZitqdDVQNkRwOFY4bU9DeDFLVHFrMlZkY1M4eVBJTHhtSUJQbzVBQUpiYWlSVFhmZUZHR250aWIiLCJtYWMiOiI2NzFhOGI2NDc0ZDMwZTk4YTg4YjczMDFkN2EyMDY4MGNjYjgxMDE2ZjcwNzJkMDI0ZGQ3ZTI4ZTZjYjQ4NTdhIiwidGFnIjoiIn0%3D; expires=Thu, 20-Mar-2025 01:18:26 GMT; Max-Age=7200; path=/; httponlynearmelisting_session=eyJpdiI6InAzaTVDRUpJcml5bEdHV3k3VDRIbEE9PSIsInZhbHVlIjoiTzEwNVZSUUJ0UGV0MkVtTkdyY09aYnUxRzE2SzlvRmdZWmVOZmlJd2ZMQmRBN2RXWjNLZnBtTUdGVjltcD" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjFKZTc3RXBBc0p0UjF4ZWNUM3NndUE9PSIsInZhbHVlIjoiNXA3OFh4TW9vV2dwQ2hURDBDdWlkK0ZQUlVpZjVFcEJWVXlwaXBZdDcrQ240SkdPN3lSMm5RdktJWmEvQWNtR1hSYWNDMEdvSXdGTkVNSFVoK28vZWhGSGgzWDhONGltc1RFcHBnRjNPdTB1MExJOWNjVDUzeWZJajZNdm9IYXoiLCJtYWMiOiI1NzQyODU5Y2QwMzQ3MTIyZWE5YWFhYzk1MzE0ZmNiMzJiMjE3ODg2ZmFmOTc4ZWE5ODIxZjk1MzgyYjBkMTk3IiwidGFnIjoiIn0%3D; expires=Thu, 20-Mar-2025 01:18:26 GMT; path=/XSRF-TOKEN=eyJpdiI6IjFKZTc3RXBBc0p0UjF4ZWNUM3NndUE9PSIsInZhbHVlIjoiNXA3OFh4TW9vV2dwQ2hURDBDdWlkK0ZQUlVpZjVFcEJWVXlwaXBZdDcrQ240SkdPN3lSMm5RdktJWmEvQWNtR1hSYWNDM" 1 => "nearmelisting_session=eyJpdiI6InAzaTVDRUpJcml5bEdHV3k3VDRIbEE9PSIsInZhbHVlIjoiTzEwNVZSUUJ0UGV0MkVtTkdyY09aYnUxRzE2SzlvRmdZWmVOZmlJd2ZMQmRBN2RXWjNLZnBtTUdGVjltcDBSeVBBYXFzK2NEZitqdDVQNkRwOFY4bU9DeDFLVHFrMlZkY1M4eVBJTHhtSUJQbzVBQUpiYWlSVFhmZUZHR250aWIiLCJtYWMiOiI2NzFhOGI2NDc0ZDMwZTk4YTg4YjczMDFkN2EyMDY4MGNjYjgxMDE2ZjcwNzJkMDI0ZGQ3ZTI4ZTZjYjQ4NTdhIiwidGFnIjoiIn0%3D; expires=Thu, 20-Mar-2025 01:18:26 GMT; path=/; httponlynearmelisting_session=eyJpdiI6InAzaTVDRUpJcml5bEdHV3k3VDRIbEE9PSIsInZhbHVlIjoiTzEwNVZSUUJ0UGV0MkVtTkdyY09aYnUxRzE2SzlvRmdZWmVOZmlJd2ZMQmRBN2RXWjNLZnBtTUdGVjltcD" ] ]
        session_attributes
        0 of 0
        array:4 [ "_token" => "5kkdSmYlE6GDzJXDwrR8fXjN54ydsBscgmFgy5A2" "_previous" => array:1 [ "url" => "https://nearmelisting.com/best/new-jersey/windows-installation" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]