Provide your vehicle details
Fit my Vehicle
Fit My Vehicle
Products
Roof Trays
Roof Racks
Sport & Awnings
Ute Tub
Work Solutions
New Products
Spares, Brackets & Components
Brands
Where to Buy
Learn
About Us
0
Home / Products / Spares, Brackets & Components / Roof Rack Parts / Complete Roof Racks / Vortex RVP Black 2 Bar Roof Rack

Vortex RVP Black 2 Bar Roof Rack

Part No: RVP27
Vortex RVP Black 2 Bar Roof Rack
$608.01
(Price inc GST)

The Vortex RVP roof rack system is specifically moulded to fit a select range of vehicles which feature factory mounting points and stylish flush Vortex bars. By attaching via these mounting points, you can be assured of a perfect fit.

Product Details

Overview

Utilising our highly regarded Vortex bars cut down to the exact length determined by your vehicle's roof, this stylish system offers you compatibility with a wide selection of Rhino-Rack accessories. So whether you're a traveller, cyclist, surfer or tradesperson - the Vortex RVP roof rack system has you covered.

Features:

  • Removeable and easy to install
  • Stylish flush bar design
  • Locking cover with a compartment for an Allen key
  • Engineered to specifically fit your vehicle
  • Low and High leg profiles available
  • Tested and approved to Australian Standards AS1235-2000
  • Comes with precision moulded insert cover pads when bars are not in use
# Of Bars
2
Bar Length
Front 951 mm, Rear 913 mm
Bar Style
Flush Bar
Base Kit
RCP27-BK
Colour
Black
Fixture
Removable
Installation Time
1 h
Leg Profile
RVL
Mount Style
Factory Mounting Point
Warranty
Lifetime
View Instructions View Kit Instructions View Leg Instructions

JEEP Grand Cherokee WK2 4dr 4WD With Metal Roof Rails (Excl. SRT8) 02/11 On

Overview

Utilising our highly regarded Vortex bars cut down to the exact length determined by your vehicle's roof, this stylish system offers you compatibility with a wide selection of Rhino-Rack accessories. So whether you're a traveller, cyclist, surfer or tradesperson - the Vortex RVP roof rack system has you covered.

Features:

  • Removeable and easy to install
  • Stylish flush bar design
  • Locking cover with a compartment for an Allen key
  • Engineered to specifically fit your vehicle
  • Low and High leg profiles available
  • Tested and approved to Australian Standards AS1235-2000
  • Comes with precision moulded insert cover pads when bars are not in use
Package length
1270 mm
Package width
240 mm
Package height
170 mm
# Of Bars
2
Bar Length
Front 951 mm, Rear 913 mm
Bar Style
Flush Bar
Base Kit
RCP27-BK
Colour
Black
Fixture
Removable
Installation Time
1 h
Leg Profile
RVL
Mount Style
Factory Mounting Point
Warranty
Lifetime
Country of Origin
Australia
View Instructions
View Kit Instructions
View Leg Instructions

JEEP Grand Cherokee WK2 4dr 4WD With Metal Roof Rails (Excl. SRT8) 02/11 On


Messages1TimelineExceptionsViews23RouteQueries83Models164Livewire0GateSessionRequest
8.1.29PHP Version314msRequest Duration11MBMemory UsagePOST {culture?}/products/{category_1}/{category_2?}/{category_3?}/{product_slug?}/{preview?}Route
  • warninglog[16:29:41] LOG.warning: preg_replace(): Passing null to parameter #3 ($subject) of type array|string...
warning
  • Booting (6.39ms)
  • Application (308ms)
  • 1 x Application (97.95%)
    307.98ms
    1 x Booting (2.03%)
    6.39ms
    23 templates were rendered
    • products.show (resources/views/products/show.blade.php)15bladefile
      Params
      0
      meta
      1
      isLoadRatingActiveForProductCategories
      2
      isComponentWithCompatibleVehicles
      3
      Product
      4
      VehiclePaginator
      5
      vehiclePageSize
      6
      vehicleTotal
      7
      shippingPolicy
      8
      enableLocally
      9
      AssociatedProductsSpareparts
      10
      AssociatedProductBanners
      11
      AssociatedZwiflocRetrofitProducts
      12
      showSparepartsInstructions
      13
      isAlwaysInStock
      14
      Setting
    • modules.breadcrumbs (resources/views/modules/breadcrumbs.blade.php)63bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
    • partials.breadcrumbs (resources/views/partials/breadcrumbs.blade.php)1bladefile
      Params
      0
      breadcrumbs
    • products.modules.product-header (resources/views/products/modules/product-header.blade.php)63bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
    • products.modules.product-banner (resources/views/products/modules/product-banner.blade.php)63bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
    • products.modules.windfairing (resources/views/products/modules/windfairing.blade.php)63bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
    • products.modules.product-components (resources/views/products/modules/product-components.blade.php)63bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
    • products.modules.product-details (resources/views/products/modules/product-details.blade.php)63bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
    • products.modules.compatible-vehicles (resources/views/products/modules/compatible-vehicles.blade.php)71bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
      63
      warning_type
      64
      __currentLoopData
      65
      SpecificationProperties
      66
      title
      67
      loop
      68
      value
      69
      name
      70
      link
    • products.modules.product-load-rating (resources/views/products/modules/product-load-rating.blade.php)71bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
      63
      warning_type
      64
      __currentLoopData
      65
      SpecificationProperties
      66
      title
      67
      loop
      68
      value
      69
      name
      70
      link
    • products.modules.compatible-vehicles (resources/views/products/modules/compatible-vehicles.blade.php)71bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
      63
      warning_type
      64
      __currentLoopData
      65
      SpecificationProperties
      66
      title
      67
      loop
      68
      value
      69
      name
      70
      link
    • products.modules.product-load-rating (resources/views/products/modules/product-load-rating.blade.php)71bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
      63
      warning_type
      64
      __currentLoopData
      65
      SpecificationProperties
      66
      title
      67
      loop
      68
      value
      69
      name
      70
      link
    • products.modules.compatible-products (resources/views/products/modules/compatible-products.blade.php)63bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
    • products.modules.product-video (resources/views/products/modules/product-video.blade.php)63bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
    • products.modules.product-links (resources/views/products/modules/product-links.blade.php)63bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
    • products.modules.related-products (resources/views/products/modules/related-products.blade.php)63bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
    • layouts.main (resources/views/layouts/main.blade.php)63bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
    • site.hreflang (resources/views/site/hreflang.blade.php)63bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
    • site.header (resources/views/site/header.blade.php)63bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
    • global.language (resources/views/global/language.blade.php)70bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
      63
      __currentLoopData
      64
      Menu
      65
      loop
      66
      MainCategory
      67
      url
      68
      ChildCategory
      69
      ChildMenu
    • site.strip-banner-announcement (resources/views/site/strip-banner-announcement.blade.php)63bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
    • site.cookieconsent (resources/views/site/cookieconsent.blade.php)63bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
    • site.footer (resources/views/site/footer.blade.php)63bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      reset_cookie_user_vehicle_id
      4
      Countries
      5
      culture
      6
      language
      7
      page_widget_locale
      8
      dealerModeKey
      9
      dealerModeValue
      10
      Menus
      11
      FooterMenus
      12
      BottomMenus
      13
      MainCategoryMenu
      14
      settings
      15
      default_meta_title
      16
      price_disclaimer_heading
      17
      default_meta_desc
      18
      enable_b2c
      19
      enable_b2b
      20
      hide_dealer
      21
      enable_custom_b2c
      22
      enable_spare_parts
      23
      enable_truck_bed_load_rating_calulator
      24
      netsuite_url
      25
      netsuite_app_url
      26
      cookie_bar_text
      27
      cookie_bar_show
      28
      cookie_bar_enforce
      29
      imperial_system
      30
      netsuite_session_variable
      31
      country
      32
      currency
      33
      tax
      34
      find_a_dealer_url
      35
      hide_price_global_value
      36
      hide_wishlist_subscribe
      37
      enable_wishlist
      38
      load_rating_disclaimer
      39
      load_rating_disclaimer_truck_bed
      40
      enable_order_pad
      41
      DealerSessionService
      42
      UserLocaleService
      43
      analytics_tag
      44
      footer_subscribe_form_id
      45
      footer_subscribe_form_guid
      46
      enable_product_load_rating
      47
      cart_url_params
      48
      meta
      49
      isLoadRatingActiveForProductCategories
      50
      isComponentWithCompatibleVehicles
      51
      Product
      52
      VehiclePaginator
      53
      vehiclePageSize
      54
      vehicleTotal
      55
      shippingPolicy
      56
      enableLocally
      57
      AssociatedProductsSpareparts
      58
      AssociatedProductBanners
      59
      AssociatedZwiflocRetrofitProducts
      60
      showSparepartsInstructions
      61
      isAlwaysInStock
      62
      Setting
    uri
    POST {culture?}/products/{category_1}/{category_2?}/{category_3?}/{product_slug?}/{preview?}
    middleware
    country
    as
    list.products
    controller
    App\Http\Controllers\ProductController@list
    namespace
    App\Http\Controllers
    prefix
    {culture?}/products
    where
    file
    app/Http/Controllers/ProductController.php:265-463
    83 statements were executed, 51 of which were duplicated, 32 unique. Show only duplicated249ms
    wen_rhino_rack
    • select * from `PR_Categories` where `parentId` is null and `slug` = 'spares-brackets-components' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
      8.25ms/app/Repositories/CategoryRepository.php:27wen_rhino_rack
      Metadata
      Bindings
      • 0. spares-brackets-components
      • 1. 2
      • 2. 1
      • 3. 0
      Backtrace
      • 15. /app/Repositories/CategoryRepository.php:27
      • 16. /app/Models/Services/Cache/ProductCacheService.php:91
      • 17. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 18. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 20. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_Categories` where `parentId` = '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7' and `slug` = 'roof-rack-parts' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
      3.59ms/app/Repositories/CategoryRepository.php:27wen_rhino_rack
      Metadata
      Bindings
      • 0. 3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7
      • 1. roof-rack-parts
      • 2. 2
      • 3. 1
      • 4. 0
      Backtrace
      • 15. /app/Repositories/CategoryRepository.php:27
      • 16. /app/Models/Services/Cache/ProductCacheService.php:91
      • 17. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 18. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 20. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_Categories` where `parentId` = '1F1129D9-79D8-4138-A3E2-926E9090C4FE' and `slug` = 'complete-roof-racks' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
      3.35ms/app/Repositories/CategoryRepository.php:27wen_rhino_rack
      Metadata
      Bindings
      • 0. 1F1129D9-79D8-4138-A3E2-926E9090C4FE
      • 1. complete-roof-racks
      • 2. 2
      • 3. 1
      • 4. 0
      Backtrace
      • 15. /app/Repositories/CategoryRepository.php:27
      • 16. /app/Models/Services/Cache/ProductCacheService.php:91
      • 17. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 18. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 20. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_Products` where `stockCode` like 'rvp27' and (title like 'vortex%rvp%black%2%bar%roof%rack' or title_US_CA like 'vortex%rvp%black%2%bar%roof%rack') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
      4.64ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. rvp27
      • 1. 2
      • 2. 1
      Backtrace
      • 14. /app/Repositories/ProductRepository.php:153
      • 15. /app/Http/Controllers/ProductController.php:309
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `PR_Medias` where `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '2') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`productId` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '2') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
      4.53ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 
      • 1. 1
      • 2. 2
      • 3. 1
      • 4. 2
      • 5. 1
      • 6. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 7. 2
      • 8. 1
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:153
      • 20. /app/Http/Controllers/ProductController.php:309
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `PR_Medias` where `embedCode` is not null and `embedCode` <> '' and `PR_Medias`.`productId` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '2') and `isActive` = 1 order by `vehicleId` asc, `order` asc, `lngId` desc, `order` asc
      2.98ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 
      • 1. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 2. 2
      • 3. 1
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:153
      • 20. /app/Http/Controllers/ProductController.php:309
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `PR_Links` where `vehicleId` is null and `PR_Links`.`productId` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and `PR_Links`.`deleted_at` is null and (`PR_Links`.`lngId` is null or `PR_Links`.`lngId` = '2') order by `order` asc, `lngId` desc, `order` asc
      2.93ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 1. 2
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:153
      • 20. /app/Http/Controllers/ProductController.php:309
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `PR_LinkNames` where `PR_LinkNames`.`linkNameId` in ('36E7D6FB-AFAB-471F-A556-E3C994B740B5', '4A65457B-DF19-4771-99C7-D4BE4B313755', '6F803376-8210-4FCB-823C-0D1ED8CF52AF') and `PR_LinkNames`.`deleted_at` is null and (`PR_LinkNames`.`lngId` is null or `PR_LinkNames`.`lngId` = 2) order by `lngId` desc, `order` asc
      2.78ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 36E7D6FB-AFAB-471F-A556-E3C994B740B5
      • 1. 4A65457B-DF19-4771-99C7-D4BE4B313755
      • 2. 6F803376-8210-4FCB-823C-0D1ED8CF52AF
      • 3. 2
      Backtrace
      • 24. /app/Repositories/ProductRepository.php:153
      • 25. /app/Http/Controllers/ProductController.php:309
      • 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `PR_ProductCompatibilities` where exists (select * from `PR_Products` where `PR_ProductCompatibilities`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_ProductCompatibilities`.`productId1` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and `PR_ProductCompatibilities`.`deleted_at` is null and (`PR_ProductCompatibilities`.`lngId` is null or `PR_ProductCompatibilities`.`lngId` = '2') order by `order` asc, `lngId` desc, `order` asc
      3.02ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 2
      • 1. 1
      • 2. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 3. 2
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:153
      • 20. /app/Http/Controllers/ProductController.php:309
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `PR_ProductSpareParts` where exists (select * from `PR_Products` where `PR_ProductSpareParts`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_ProductSpareParts`.`productId1` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and `PR_ProductSpareParts`.`deleted_at` is null order by `order` asc
      2.71ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 2
      • 1. 1
      • 2. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:153
      • 20. /app/Http/Controllers/ProductController.php:309
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `PR_WindFairings` where exists (select * from `PR_Products` where `PR_WindFairings`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_WindFairings`.`productId1` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and `lngId` = 2 and `PR_WindFairings`.`deleted_at` is null order by `id` asc
      2.83ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 2
      • 1. 1
      • 2. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 3. 2
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:153
      • 20. /app/Http/Controllers/ProductController.php:309
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `PR_ProductSpecifications` where `PR_ProductSpecifications`.`productId` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and `PR_ProductSpecifications`.`deleted_at` is null
      3.28ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:153
      • 20. /app/Http/Controllers/ProductController.php:309
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '2261BB38-5354-44FE-B45C-849D201849B0', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '6284DBED-EF43-4436-A768-B530DA94D027', '65DE24DC-83D6-4790-8EDE-0DEAD147EF02', '65EBFA01-7744-4861-803E-BA026DFC9BA0', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', '7A90BAEF-94DE-4E35-9446-A53AE478B8C7', 'AEF3ACA8-93E7-4674-B28B-1AECF6611583') and `PR_Specifications`.`deleted_at` is null order by `order` asc
      3.15ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF
      • 1. 14F3FB81-8947-4E5E-BB23-2F17B1452EF2
      • 2. 2261BB38-5354-44FE-B45C-849D201849B0
      • 3. 2A37E3E3-CB54-453A-9EE9-53B3406A76CB
      • 4. 6284DBED-EF43-4436-A768-B530DA94D027
      • 5. 65DE24DC-83D6-4790-8EDE-0DEAD147EF02
      • 6. 65EBFA01-7744-4861-803E-BA026DFC9BA0
      • 7. 6FEC7B95-51EA-498A-A900-8FD5DA6C89D2
      • 8. 7A90BAEF-94DE-4E35-9446-A53AE478B8C7
      • 9. AEF3ACA8-93E7-4674-B28B-1AECF6611583
      Backtrace
      • 24. /app/Repositories/ProductRepository.php:153
      • 25. /app/Http/Controllers/ProductController.php:309
      • 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `PR_ProductSpecificationProperties` where `PR_ProductSpecificationProperties`.`productId` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and `PR_ProductSpecificationProperties`.`deleted_at` is null
      3.14ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      Backtrace
      • 24. /app/Repositories/ProductRepository.php:153
      • 25. /app/Http/Controllers/ProductController.php:309
      • 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `PR_PackageComponents` where exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`productId` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
      2.49ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 2
      • 1. 1
      • 2. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:153
      • 20. /app/Http/Controllers/ProductController.php:309
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `CM_CanopyProducts` where `CM_CanopyProducts`.`productId` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and `CM_CanopyProducts`.`deleted_at` is null and (`CM_CanopyProducts`.`lngId` is null or `CM_CanopyProducts`.`lngId` = '2') order by `lngId` desc
      2.11ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 1. 2
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:153
      • 20. /app/Http/Controllers/ProductController.php:309
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `PR_BarTypeProductCompatibilities` inner join `PR_BarTypes` on `PR_BarTypeProductCompatibilities`.`barTypeId` = `PR_BarTypes`.`barTypeId` where `PR_BarTypeProductCompatibilities`.`productId` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and PR_BarTypes.lngId=2 and `PR_BarTypeProductCompatibilities`.`deleted_at` is null order by `PR_BarTypes`.`order` asc
      3.31ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:153
      • 20. /app/Http/Controllers/ProductController.php:309
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `PR_BarTypes` where `PR_BarTypes`.`barTypeId` in ('B07CD0CA-94E0-4DF5-BB74-38F1371DE605') and `PR_BarTypes`.`deleted_at` is null and (`PR_BarTypes`.`lngId` is null or `PR_BarTypes`.`lngId` = 2) order by `lngId` desc, `order` asc
      2.7ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. B07CD0CA-94E0-4DF5-BB74-38F1371DE605
      • 1. 2
      Backtrace
      • 24. /app/Repositories/ProductRepository.php:153
      • 25. /app/Http/Controllers/ProductController.php:309
      • 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
      4.09ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 2
      • 1. 1
      Backtrace
      • 24. /app/Repositories/ProductRepository.php:153
      • 25. /app/Http/Controllers/ProductController.php:309
      • 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `productId2`, `order`, `lngId` from `PR_RelatedProducts` where `productId1` = '09275ABC-3D09-4369-A939-ED6CF9CF7549' and `PR_RelatedProducts`.`deleted_at` is null and (`PR_RelatedProducts`.`lngId` is null or `PR_RelatedProducts`.`lngId` = '2') order by `order` asc, `id` desc, `lngId` desc, `order` asc
      1.65ms/app/Models/Services/Cache/ProductCacheService.php:210wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 1. 2
      Backtrace
      • 14. /app/Models/Services/Cache/ProductCacheService.php:210
      • 15. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 16. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 18. /app/Models/Services/Cache/CacheServiceBase.php:40
      • 19. /app/Models/Services/Cache/ProductCacheService.php:240
    • select `productId2`, `order`, `lngId` from `PR_RelatedProducts` where 0 = 1 and `PR_RelatedProducts`.`deleted_at` is null and (`PR_RelatedProducts`.`lngId` is null or `PR_RelatedProducts`.`lngId` = '2') order by `order` asc, `id` desc, `lngId` desc, `order` asc
      1.44ms/app/Models/Services/Cache/ProductCacheService.php:220wen_rhino_rack
      Metadata
      Bindings
      • 0. 2
      Backtrace
      • 14. /app/Models/Services/Cache/ProductCacheService.php:220
      • 15. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 16. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 18. /app/Models/Services/Cache/CacheServiceBase.php:40
      • 19. /app/Models/Services/Cache/ProductCacheService.php:240
    • select * from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
      4.12ms/app/Models/Services/Cache/ProductCacheService.php:225wen_rhino_rack
      Metadata
      Bindings
      • 0. 2
      • 1. 1
      Backtrace
      • 14. /app/Models/Services/Cache/ProductCacheService.php:225
      • 15. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 16. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 18. /app/Models/Services/Cache/CacheServiceBase.php:40
      • 19. /app/Models/Services/Cache/ProductCacheService.php:240
    • select * from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
      4.16ms/app/Models/Services/Cache/ProductCacheService.php:231wen_rhino_rack
      Metadata
      Bindings
      • 0. 2
      • 1. 1
      Backtrace
      • 14. /app/Models/Services/Cache/ProductCacheService.php:231
      • 15. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 16. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 18. /app/Models/Services/Cache/CacheServiceBase.php:40
      • 19. /app/Models/Services/Cache/ProductCacheService.php:240
    • select * from `PR_ProductSpecificationProperties` where `PR_ProductSpecificationProperties`.`productId` = '09275ABC-3D09-4369-A939-ED6CF9CF7549' and `PR_ProductSpecificationProperties`.`productId` is not null and exists (select * from `PR_SpecificationProperties` where `PR_ProductSpecificationProperties`.`specificationPropertyId` = `PR_SpecificationProperties`.`specificationPropertyId` and `PR_SpecificationProperties`.`deleted_at` is null order by `order` asc) and `PR_ProductSpecificationProperties`.`deleted_at` is null
      3.35ms/app/Models/Services/Cache/ProductCacheService.php:329wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      Backtrace
      • 19. /app/Models/Services/Cache/ProductCacheService.php:329
      • 20. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 21. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 23. /app/Models/Services/Cache/CacheServiceBase.php:40
      • 24. /app/Models/Services/Cache/ProductCacheService.php:360
    • select * from `PR_SpecificationProperties` where `PR_SpecificationProperties`.`specificationPropertyId` in ('1404128B-8306-4A41-926F-05ACF8F3B461', '22D06B2F-4F51-4E1B-B599-B3E1C01E8627', '3178C8C8-BCD1-49B2-8B42-5D6A9F870FE9', '36233E8D-5640-404E-BE06-765E3B9EE8FB', '3678388B-7153-434F-B245-0795D8AD6E60', '48062BB7-CD0E-41B9-88D0-4C6174AD6AAF', '6B65CCB5-C611-4252-AC40-B081C6520F2E', 'B2B090A4-D7F1-48B1-BB9A-7979E5D901D2', 'BDB99B83-7053-4913-94AA-4A53DBDE5668', 'D78F6505-9766-4732-A858-73785505B425') and `PR_SpecificationProperties`.`deleted_at` is null order by `order` asc
      3.42ms/app/Models/Services/Cache/ProductCacheService.php:329wen_rhino_rack
      Metadata
      Bindings
      • 0. 1404128B-8306-4A41-926F-05ACF8F3B461
      • 1. 22D06B2F-4F51-4E1B-B599-B3E1C01E8627
      • 2. 3178C8C8-BCD1-49B2-8B42-5D6A9F870FE9
      • 3. 36233E8D-5640-404E-BE06-765E3B9EE8FB
      • 4. 3678388B-7153-434F-B245-0795D8AD6E60
      • 5. 48062BB7-CD0E-41B9-88D0-4C6174AD6AAF
      • 6. 6B65CCB5-C611-4252-AC40-B081C6520F2E
      • 7. B2B090A4-D7F1-48B1-BB9A-7979E5D901D2
      • 8. BDB99B83-7053-4913-94AA-4A53DBDE5668
      • 9. D78F6505-9766-4732-A858-73785505B425
      Backtrace
      • 24. /app/Models/Services/Cache/ProductCacheService.php:329
      • 25. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 26. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 28. /app/Models/Services/Cache/CacheServiceBase.php:40
      • 29. /app/Models/Services/Cache/ProductCacheService.php:360
    • select * from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '2261BB38-5354-44FE-B45C-849D201849B0', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '6284DBED-EF43-4436-A768-B530DA94D027', '65DE24DC-83D6-4790-8EDE-0DEAD147EF02', '65EBFA01-7744-4861-803E-BA026DFC9BA0', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', '7A90BAEF-94DE-4E35-9446-A53AE478B8C7', 'AEF3ACA8-93E7-4674-B28B-1AECF6611583') and `PR_Specifications`.`deleted_at` is null order by `order` asc
      3.1ms/app/Models/Services/Cache/ProductCacheService.php:329wen_rhino_rack
      Metadata
      Bindings
      • 0. 1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF
      • 1. 14F3FB81-8947-4E5E-BB23-2F17B1452EF2
      • 2. 2261BB38-5354-44FE-B45C-849D201849B0
      • 3. 2A37E3E3-CB54-453A-9EE9-53B3406A76CB
      • 4. 6284DBED-EF43-4436-A768-B530DA94D027
      • 5. 65DE24DC-83D6-4790-8EDE-0DEAD147EF02
      • 6. 65EBFA01-7744-4861-803E-BA026DFC9BA0
      • 7. 6FEC7B95-51EA-498A-A900-8FD5DA6C89D2
      • 8. 7A90BAEF-94DE-4E35-9446-A53AE478B8C7
      • 9. AEF3ACA8-93E7-4674-B28B-1AECF6611583
      Backtrace
      • 29. /app/Models/Services/Cache/ProductCacheService.php:329
      • 30. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 31. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 33. /app/Models/Services/Cache/CacheServiceBase.php:40
      • 34. /app/Models/Services/Cache/ProductCacheService.php:360
    • select * from `PR_SpecificationPropertyMasterData` where `PR_SpecificationPropertyMasterData`.`specificationPropertyMasterDataId` in ('13EE9F51-90CA-4128-9C57-2DB36ED18057', '3492BB0B-E151-4006-B785-A2E65269871B', '66E7F1BA-B555-492C-9374-8F26C71C15F1', '6C9D3CFB-941F-4A87-8D5E-75DD2A98D884', '706802A1-C753-4C62-AFE7-AC2A34C21017', '8AFDD8CE-13F0-489B-8D12-7884C00198C7', '8EF674CE-D4B8-47C0-96B6-C33136A7E039', '97623ACD-37D7-43A6-88A9-F7EB6B05B75D', 'F470CCED-097A-485C-BF94-55F0676561A7') and `PR_SpecificationPropertyMasterData`.`deleted_at` is null order by `order` asc
      3.26ms/app/Models/Services/Cache/ProductCacheService.php:329wen_rhino_rack
      Metadata
      Bindings
      • 0. 13EE9F51-90CA-4128-9C57-2DB36ED18057
      • 1. 3492BB0B-E151-4006-B785-A2E65269871B
      • 2. 66E7F1BA-B555-492C-9374-8F26C71C15F1
      • 3. 6C9D3CFB-941F-4A87-8D5E-75DD2A98D884
      • 4. 706802A1-C753-4C62-AFE7-AC2A34C21017
      • 5. 8AFDD8CE-13F0-489B-8D12-7884C00198C7
      • 6. 8EF674CE-D4B8-47C0-96B6-C33136A7E039
      • 7. 97623ACD-37D7-43A6-88A9-F7EB6B05B75D
      • 8. F470CCED-097A-485C-BF94-55F0676561A7
      Backtrace
      • 24. /app/Models/Services/Cache/ProductCacheService.php:329
      • 25. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 26. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 28. /app/Models/Services/Cache/CacheServiceBase.php:40
      • 29. /app/Models/Services/Cache/ProductCacheService.php:360
    • select `id`, `specificationPropertyMasterDataId`, `key`, `name`, `value` from `PR_SpecificationPropertyMasterData_Features` where `PR_SpecificationPropertyMasterData_Features`.`specificationPropertyMasterDataId` in ('13EE9F51-90CA-4128-9C57-2DB36ED18057', '3492BB0B-E151-4006-B785-A2E65269871B', '66E7F1BA-B555-492C-9374-8F26C71C15F1', '6C9D3CFB-941F-4A87-8D5E-75DD2A98D884', '706802A1-C753-4C62-AFE7-AC2A34C21017', '8AFDD8CE-13F0-489B-8D12-7884C00198C7', '8EF674CE-D4B8-47C0-96B6-C33136A7E039', '97623ACD-37D7-43A6-88A9-F7EB6B05B75D', 'F470CCED-097A-485C-BF94-55F0676561A7') and `PR_SpecificationPropertyMasterData_Features`.`deleted_at` is null and (`PR_SpecificationPropertyMasterData_Features`.`lngId` is null or `PR_SpecificationPropertyMasterData_Features`.`lngId` = 2) order by `order` asc, `lngId` desc, `order` asc
      2.96ms/app/Models/Services/Cache/ProductCacheService.php:329wen_rhino_rack
      Metadata
      Bindings
      • 0. 13EE9F51-90CA-4128-9C57-2DB36ED18057
      • 1. 3492BB0B-E151-4006-B785-A2E65269871B
      • 2. 66E7F1BA-B555-492C-9374-8F26C71C15F1
      • 3. 6C9D3CFB-941F-4A87-8D5E-75DD2A98D884
      • 4. 706802A1-C753-4C62-AFE7-AC2A34C21017
      • 5. 8AFDD8CE-13F0-489B-8D12-7884C00198C7
      • 6. 8EF674CE-D4B8-47C0-96B6-C33136A7E039
      • 7. 97623ACD-37D7-43A6-88A9-F7EB6B05B75D
      • 8. F470CCED-097A-485C-BF94-55F0676561A7
      • 9. 2
      Backtrace
      • 29. /app/Models/Services/Cache/ProductCacheService.php:329
      • 30. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 31. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 33. /app/Models/Services/Cache/CacheServiceBase.php:40
      • 34. /app/Models/Services/Cache/ProductCacheService.php:360
    • select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '09275ABC-3D09-4369-A939-ED6CF9CF7549' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
      2.8ms/app/Models/Entities/Product/Product.php:477wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 1. 2
      • 2. 1
      • 3. 0
      Backtrace
      • 19. /app/Models/Entities/Product/Product.php:477
      • 20. /app/Repositories/ProductRepository.php:171
      • 21. /app/Http/Controllers/ProductController.php:309
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '9EAD993D-3F7F-434C-914C-C1AB0B64EC6C') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
      3.41ms/app/Models/Entities/Product/Product.php:477wen_rhino_rack
      Metadata
      Bindings
      • 0. 2C0FB2F9-F310-435A-BFC0-27BFB884CEE5
      • 1. 3B393703-FAA0-4701-A5B4-DFA329A3DC9B
      • 2. 9EAD993D-3F7F-434C-914C-C1AB0B64EC6C
      • 3. 2
      • 4. 1
      • 5. 0
      Backtrace
      • 24. /app/Models/Entities/Product/Product.php:477
      • 25. /app/Repositories/ProductRepository.php:171
      • 26. /app/Http/Controllers/ProductController.php:309
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `specificationId` from `PR_CategorySpecifications` where `categoryId` in ('9EAD993D-3F7F-434C-914C-C1AB0B64EC6C', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `isVisibleOnProduct` = 1 and `PR_CategorySpecifications`.`deleted_at` is null order by `order` asc
      1.84ms/app/Models/Entities/Product/Product.php:478wen_rhino_rack
      Metadata
      Bindings
      • 0. 9EAD993D-3F7F-434C-914C-C1AB0B64EC6C
      • 1. 3B393703-FAA0-4701-A5B4-DFA329A3DC9B
      • 2. 2C0FB2F9-F310-435A-BFC0-27BFB884CEE5
      • 3. 1
      Backtrace
      • 13. /app/Models/Entities/Product/Product.php:478
      • 14. /app/Repositories/ProductRepository.php:171
      • 15. /app/Http/Controllers/ProductController.php:309
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `title` from `PR_Specifications` where `specificationId` in ('AEF3ACA8-93E7-4674-B28B-1AECF6611583', '7A90BAEF-94DE-4E35-9446-A53AE478B8C7', '65EBFA01-7744-4861-803E-BA026DFC9BA0', '6284DBED-EF43-4436-A768-B530DA94D027', '1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', '2261BB38-5354-44FE-B45C-849D201849B0', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2', 'AEF3ACA8-93E7-4674-B28B-1AECF6611583', '7A90BAEF-94DE-4E35-9446-A53AE478B8C7', '65EBFA01-7744-4861-803E-BA026DFC9BA0', '6284DBED-EF43-4436-A768-B530DA94D027', '1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', '2261BB38-5354-44FE-B45C-849D201849B0', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2') and `PR_Specifications`.`deleted_at` is null order by `order` asc
      1.99ms/app/Models/Entities/Product/Product.php:479wen_rhino_rack
      Metadata
      Bindings
      • 0. AEF3ACA8-93E7-4674-B28B-1AECF6611583
      • 1. 7A90BAEF-94DE-4E35-9446-A53AE478B8C7
      • 2. 65EBFA01-7744-4861-803E-BA026DFC9BA0
      • 3. 6284DBED-EF43-4436-A768-B530DA94D027
      • 4. 1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF
      • 5. 6FEC7B95-51EA-498A-A900-8FD5DA6C89D2
      • 6. 2261BB38-5354-44FE-B45C-849D201849B0
      • 7. 2A37E3E3-CB54-453A-9EE9-53B3406A76CB
      • 8. 14F3FB81-8947-4E5E-BB23-2F17B1452EF2
      • 9. AEF3ACA8-93E7-4674-B28B-1AECF6611583
      • 10. 7A90BAEF-94DE-4E35-9446-A53AE478B8C7
      • 11. 65EBFA01-7744-4861-803E-BA026DFC9BA0
      • 12. 6284DBED-EF43-4436-A768-B530DA94D027
      • 13. 1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF
      • 14. 6FEC7B95-51EA-498A-A900-8FD5DA6C89D2
      • 15. 2261BB38-5354-44FE-B45C-849D201849B0
      • 16. 2A37E3E3-CB54-453A-9EE9-53B3406A76CB
      • 17. 14F3FB81-8947-4E5E-BB23-2F17B1452EF2
      Backtrace
      • 13. /app/Models/Entities/Product/Product.php:479
      • 14. /app/Repositories/ProductRepository.php:171
      • 15. /app/Http/Controllers/ProductController.php:309
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `PR_ProductCustomSpecification` where `PR_ProductCustomSpecification`.`ProductId` = '09275ABC-3D09-4369-A939-ED6CF9CF7549' and `PR_ProductCustomSpecification`.`ProductId` is not null and `PR_ProductCustomSpecification`.`deleted_at` is null order by `order` asc, `order` asc
      3.27ms/app/Models/Entities/Product/Product.php:572wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      Backtrace
      • 19. /app/Models/Entities/Product/Product.php:572
      • 20. /app/Repositories/ProductRepository.php:172
      • 21. /app/Http/Controllers/ProductController.php:309
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `PR_VehicleProducts` where `PR_VehicleProducts`.`productId` = '09275ABC-3D09-4369-A939-ED6CF9CF7549' and `PR_VehicleProducts`.`productId` is not null and exists (select * from `VM_Vehicles` where `PR_VehicleProducts`.`vehicleId` = `VM_Vehicles`.`vehicleId` and exists (select * from `VM_Models` where `VM_Vehicles`.`modelId` = `VM_Models`.`modelId` and `VM_Models`.`deleted_at` is null and (`VM_Models`.`lngId` is null or `VM_Models`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc) and `VM_Vehicles`.`deleted_at` is null and (`VM_Vehicles`.`lngId` is null or `VM_Vehicles`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc) and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '2') order by `lngId` desc
      3.34ms/app/Http/Controllers/ProductController.php:326wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 1. 2
      • 2. 1
      • 3. 2
      • 4. 1
      • 5. 2
      Backtrace
      • 19. /app/Http/Controllers/ProductController.php:326
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `VM_Vehicles` where `VM_Vehicles`.`vehicleId` in ('9CB2AAFC-B8C0-4F27-9BA2-C174B48AA5C5') and `VM_Vehicles`.`deleted_at` is null and (`VM_Vehicles`.`lngId` is null or `VM_Vehicles`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc
      3.18ms/app/Http/Controllers/ProductController.php:326wen_rhino_rack
      Metadata
      Bindings
      • 0. 9CB2AAFC-B8C0-4F27-9BA2-C174B48AA5C5
      • 1. 2
      • 2. 1
      Backtrace
      • 24. /app/Http/Controllers/ProductController.php:326
      • 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 26. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select count(*) as aggregate from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '09275ABC-3D09-4369-A939-ED6CF9CF7549' and `PR_ProductCategories`.`productId` is not null and `categoryId` in ('2B39426A-55C6-45D5-9418-5A79A0166DEA', '23C6863F-91C0-44EE-B8DB-949A42E96573', 'DBE8AFC5-A2D9-4715-BB32-79424DBECA14', 'F7380C9C-AF6D-4B3D-82C9-17E81216DCA2') and `PR_ProductCategories`.`deleted_at` is null
      1.37ms/app/Models/Entities/Product/Product.php:162wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 1. 2B39426A-55C6-45D5-9418-5A79A0166DEA
      • 2. 23C6863F-91C0-44EE-B8DB-949A42E96573
      • 3. DBE8AFC5-A2D9-4715-BB32-79424DBECA14
      • 4. F7380C9C-AF6D-4B3D-82C9-17E81216DCA2
      Backtrace
      • 18. /app/Models/Entities/Product/Product.php:162
      • 19. /app/Http/Controllers/ProductController.php:375
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `PR_CategoryProductImages` where `categoryId` in ('9EAD993D-3F7F-434C-914C-C1AB0B64EC6C', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `lngId` = 2 and `categoryId1` is not null and `categoryId2` is not null and `deleted_at` is null
      2.61ms/app/Repositories/ProductRepository.php:243wen_rhino_rack
      Metadata
      Bindings
      • 0. 9EAD993D-3F7F-434C-914C-C1AB0B64EC6C
      • 1. 3B393703-FAA0-4701-A5B4-DFA329A3DC9B
      • 2. 2C0FB2F9-F310-435A-BFC0-27BFB884CEE5
      • 3. 2
      Backtrace
      • 12. /app/Repositories/ProductRepository.php:243
      • 13. /app/Http/Controllers/ProductController.php:378
      • 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `parentId` from `PR_Categories` where `categoryId` in ('9EAD993D-3F7F-434C-914C-C1AB0B64EC6C', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `lngId` = 2 and `deleted_at` is null
      1.38ms/app/Repositories/ProductRepository.php:247wen_rhino_rack
      Metadata
      Bindings
      • 0. 9EAD993D-3F7F-434C-914C-C1AB0B64EC6C
      • 1. 3B393703-FAA0-4701-A5B4-DFA329A3DC9B
      • 2. 2C0FB2F9-F310-435A-BFC0-27BFB884CEE5
      • 3. 2
      Backtrace
      • 12. /app/Repositories/ProductRepository.php:247
      • 13. /app/Http/Controllers/ProductController.php:378
      • 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `PR_CategoryProductImages` where `categoryId` in ('5480AA8E-3C8D-4831-8005-8E1D56C668EA', '13674F82-0F17-442D-AD28-13A8C7683425', '1F1129D9-79D8-4138-A3E2-926E9090C4FE') and `lngId` = 2 and `categoryId1` is not null and (`categoryId2` = '' or `categoryId2` is null) and `deleted_at` is null
      2.61ms/app/Repositories/ProductRepository.php:250wen_rhino_rack
      Metadata
      Bindings
      • 0. 5480AA8E-3C8D-4831-8005-8E1D56C668EA
      • 1. 13674F82-0F17-442D-AD28-13A8C7683425
      • 2. 1F1129D9-79D8-4138-A3E2-926E9090C4FE
      • 3. 2
      • 4. 
      Backtrace
      • 12. /app/Repositories/ProductRepository.php:250
      • 13. /app/Http/Controllers/ProductController.php:378
      • 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `parentId` from `PR_Categories` where `categoryId` in ('5480AA8E-3C8D-4831-8005-8E1D56C668EA', '13674F82-0F17-442D-AD28-13A8C7683425', '1F1129D9-79D8-4138-A3E2-926E9090C4FE') and `lngId` = 2 and `deleted_at` is null
      1.37ms/app/Repositories/ProductRepository.php:255wen_rhino_rack
      Metadata
      Bindings
      • 0. 5480AA8E-3C8D-4831-8005-8E1D56C668EA
      • 1. 13674F82-0F17-442D-AD28-13A8C7683425
      • 2. 1F1129D9-79D8-4138-A3E2-926E9090C4FE
      • 3. 2
      Backtrace
      • 12. /app/Repositories/ProductRepository.php:255
      • 13. /app/Http/Controllers/ProductController.php:378
      • 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `PR_CategoryProductImages` where `categoryId` in ('5C2DD4F5-056B-4961-B309-A37BA1BC5A4E', '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7', 'F1D7419B-13D1-4D95-8AF7-0D95AED30BF2') and `lngId` = 2 and (`categoryId1` = '' or `categoryId1` is null) and (`categoryId2` = '' or `categoryId2` is null) and `deleted_at` is null
      2.63ms/app/Repositories/ProductRepository.php:260wen_rhino_rack
      Metadata
      Bindings
      • 0. 5C2DD4F5-056B-4961-B309-A37BA1BC5A4E
      • 1. 3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7
      • 2. F1D7419B-13D1-4D95-8AF7-0D95AED30BF2
      • 3. 2
      • 4. 
      • 5. 
      Backtrace
      • 12. /app/Repositories/ProductRepository.php:260
      • 13. /app/Http/Controllers/ProductController.php:378
      • 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `PR_ProductBanners` where `PR_ProductBanners`.`productId` = '09275ABC-3D09-4369-A939-ED6CF9CF7549' and `PR_ProductBanners`.`productId` is not null and `PR_ProductBanners`.`deleted_at` is null
      2.14ms/app/Repositories/ProductRepository.php:274wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:274
      • 20. /app/Http/Controllers/ProductController.php:378
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `PR_ZwiflocRetrofit` where `PR_ZwiflocRetrofit`.`productId1` = '09275ABC-3D09-4369-A939-ED6CF9CF7549' and `PR_ZwiflocRetrofit`.`productId1` is not null and exists (select * from `PR_Products` where `PR_ZwiflocRetrofit`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_ZwiflocRetrofit`.`deleted_at` is null and (`PR_ZwiflocRetrofit`.`lngId` is null or `PR_ZwiflocRetrofit`.`lngId` = 2) order by `id` asc, `lngId` desc
      2.73ms/app/Repositories/ProductRepository.php:350wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 1. 2
      • 2. 1
      • 3. 2
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:350
      • 20. /app/Http/Controllers/ProductController.php:379
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `settings` where `key` = 'enable_locally' and `settings`.`deleted_at` is null and (`settings`.`lngId` is null or `settings`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc limit 1
      2.21ms/app/Models/Entities/Shared/Setting.php:78wen_rhino_rack
      Metadata
      Bindings
      • 0. enable_locally
      • 1. 2
      • 2. 1
      Backtrace
      • 15. /app/Models/Entities/Shared/Setting.php:78
      • 16. /app/Models/Services/Cache/SystemCacheService.php:96
      • 17. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 18. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 20. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_Categories` where `parentId` is null and `slug` = 'spares-brackets-components' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
      3.3ms/app/Repositories/CategoryRepository.php:27wen_rhino_rack
      Metadata
      Bindings
      • 0. spares-brackets-components
      • 1. 2
      • 2. 0
      Backtrace
      • 15. /app/Repositories/CategoryRepository.php:27
      • 16. /app/Models/Services/Cache/ProductCacheService.php:106
      • 17. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 18. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 20. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_Categories` where `parentId` = '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7' and `slug` = 'roof-rack-parts' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
      3.46ms/app/Repositories/CategoryRepository.php:27wen_rhino_rack
      Metadata
      Bindings
      • 0. 3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7
      • 1. roof-rack-parts
      • 2. 2
      • 3. 0
      Backtrace
      • 15. /app/Repositories/CategoryRepository.php:27
      • 16. /app/Models/Services/Cache/ProductCacheService.php:106
      • 17. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 18. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 20. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_Categories` where `parentId` = '1F1129D9-79D8-4138-A3E2-926E9090C4FE' and `slug` = 'complete-roof-racks' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
      3.23ms/app/Repositories/CategoryRepository.php:27wen_rhino_rack
      Metadata
      Bindings
      • 0. 1F1129D9-79D8-4138-A3E2-926E9090C4FE
      • 1. complete-roof-racks
      • 2. 2
      • 3. 0
      Backtrace
      • 15. /app/Repositories/CategoryRepository.php:27
      • 16. /app/Models/Services/Cache/ProductCacheService.php:106
      • 17. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 18. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 20. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_Products` where `stockCode` like 'rvp27' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) order by `lngId` desc
      4.52ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. rvp27
      • 1. 2
      Backtrace
      • 14. /app/Repositories/ProductRepository.php:153
      • 15. /app/Models/Services/Cache/ProductCacheService.php:164
      • 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 19. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_Medias` where `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '2') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`productId` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '2') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
      4.27ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 
      • 1. 1
      • 2. 2
      • 3. 1
      • 4. 2
      • 5. 1
      • 6. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 7. 2
      • 8. 1
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:153
      • 20. /app/Models/Services/Cache/ProductCacheService.php:164
      • 21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 24. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_Medias` where `embedCode` is not null and `embedCode` <> '' and `PR_Medias`.`productId` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '2') and `isActive` = 1 order by `vehicleId` asc, `order` asc, `lngId` desc, `order` asc
      2.97ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 
      • 1. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 2. 2
      • 3. 1
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:153
      • 20. /app/Models/Services/Cache/ProductCacheService.php:164
      • 21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 24. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_Links` where `vehicleId` is null and `PR_Links`.`productId` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and `PR_Links`.`deleted_at` is null and (`PR_Links`.`lngId` is null or `PR_Links`.`lngId` = '2') order by `order` asc, `lngId` desc, `order` asc
      3ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 1. 2
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:153
      • 20. /app/Models/Services/Cache/ProductCacheService.php:164
      • 21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 24. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_LinkNames` where `PR_LinkNames`.`linkNameId` in ('36E7D6FB-AFAB-471F-A556-E3C994B740B5', '4A65457B-DF19-4771-99C7-D4BE4B313755', '6F803376-8210-4FCB-823C-0D1ED8CF52AF') and `PR_LinkNames`.`deleted_at` is null and (`PR_LinkNames`.`lngId` is null or `PR_LinkNames`.`lngId` = 2) order by `lngId` desc, `order` asc
      2.79ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 36E7D6FB-AFAB-471F-A556-E3C994B740B5
      • 1. 4A65457B-DF19-4771-99C7-D4BE4B313755
      • 2. 6F803376-8210-4FCB-823C-0D1ED8CF52AF
      • 3. 2
      Backtrace
      • 24. /app/Repositories/ProductRepository.php:153
      • 25. /app/Models/Services/Cache/ProductCacheService.php:164
      • 26. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 27. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 29. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_ProductCompatibilities` where exists (select * from `PR_Products` where `PR_ProductCompatibilities`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_ProductCompatibilities`.`productId1` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and `PR_ProductCompatibilities`.`deleted_at` is null and (`PR_ProductCompatibilities`.`lngId` is null or `PR_ProductCompatibilities`.`lngId` = '2') order by `order` asc, `lngId` desc, `order` asc
      3.05ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 2
      • 1. 1
      • 2. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 3. 2
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:153
      • 20. /app/Models/Services/Cache/ProductCacheService.php:164
      • 21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 24. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_ProductSpareParts` where exists (select * from `PR_Products` where `PR_ProductSpareParts`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_ProductSpareParts`.`productId1` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and `PR_ProductSpareParts`.`deleted_at` is null order by `order` asc
      2.73ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 2
      • 1. 1
      • 2. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:153
      • 20. /app/Models/Services/Cache/ProductCacheService.php:164
      • 21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 24. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_WindFairings` where exists (select * from `PR_Products` where `PR_WindFairings`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_WindFairings`.`productId1` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and `lngId` = 2 and `PR_WindFairings`.`deleted_at` is null order by `id` asc
      2.82ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 2
      • 1. 1
      • 2. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 3. 2
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:153
      • 20. /app/Models/Services/Cache/ProductCacheService.php:164
      • 21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 24. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_ProductSpecifications` where `PR_ProductSpecifications`.`productId` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and `PR_ProductSpecifications`.`deleted_at` is null
      2.8ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:153
      • 20. /app/Models/Services/Cache/ProductCacheService.php:164
      • 21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 24. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '2261BB38-5354-44FE-B45C-849D201849B0', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '6284DBED-EF43-4436-A768-B530DA94D027', '65DE24DC-83D6-4790-8EDE-0DEAD147EF02', '65EBFA01-7744-4861-803E-BA026DFC9BA0', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', '7A90BAEF-94DE-4E35-9446-A53AE478B8C7', 'AEF3ACA8-93E7-4674-B28B-1AECF6611583') and `PR_Specifications`.`deleted_at` is null order by `order` asc
      3.09ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF
      • 1. 14F3FB81-8947-4E5E-BB23-2F17B1452EF2
      • 2. 2261BB38-5354-44FE-B45C-849D201849B0
      • 3. 2A37E3E3-CB54-453A-9EE9-53B3406A76CB
      • 4. 6284DBED-EF43-4436-A768-B530DA94D027
      • 5. 65DE24DC-83D6-4790-8EDE-0DEAD147EF02
      • 6. 65EBFA01-7744-4861-803E-BA026DFC9BA0
      • 7. 6FEC7B95-51EA-498A-A900-8FD5DA6C89D2
      • 8. 7A90BAEF-94DE-4E35-9446-A53AE478B8C7
      • 9. AEF3ACA8-93E7-4674-B28B-1AECF6611583
      Backtrace
      • 24. /app/Repositories/ProductRepository.php:153
      • 25. /app/Models/Services/Cache/ProductCacheService.php:164
      • 26. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 27. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 29. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_ProductSpecificationProperties` where `PR_ProductSpecificationProperties`.`productId` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and `PR_ProductSpecificationProperties`.`deleted_at` is null
      2.99ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      Backtrace
      • 24. /app/Repositories/ProductRepository.php:153
      • 25. /app/Models/Services/Cache/ProductCacheService.php:164
      • 26. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 27. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 29. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_PackageComponents` where exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`productId` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
      2.49ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 2
      • 1. 1
      • 2. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:153
      • 20. /app/Models/Services/Cache/ProductCacheService.php:164
      • 21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 24. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `CM_CanopyProducts` where `CM_CanopyProducts`.`productId` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and `CM_CanopyProducts`.`deleted_at` is null and (`CM_CanopyProducts`.`lngId` is null or `CM_CanopyProducts`.`lngId` = '2') order by `lngId` desc
      2.16ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 1. 2
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:153
      • 20. /app/Models/Services/Cache/ProductCacheService.php:164
      • 21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 24. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_BarTypeProductCompatibilities` inner join `PR_BarTypes` on `PR_BarTypeProductCompatibilities`.`barTypeId` = `PR_BarTypes`.`barTypeId` where `PR_BarTypeProductCompatibilities`.`productId` in ('09275ABC-3D09-4369-A939-ED6CF9CF7549') and PR_BarTypes.lngId=2 and `PR_BarTypeProductCompatibilities`.`deleted_at` is null order by `PR_BarTypes`.`order` asc
      3.29ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      Backtrace
      • 19. /app/Repositories/ProductRepository.php:153
      • 20. /app/Models/Services/Cache/ProductCacheService.php:164
      • 21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 24. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_BarTypes` where `PR_BarTypes`.`barTypeId` in ('B07CD0CA-94E0-4DF5-BB74-38F1371DE605') and `PR_BarTypes`.`deleted_at` is null and (`PR_BarTypes`.`lngId` is null or `PR_BarTypes`.`lngId` = 2) order by `lngId` desc, `order` asc
      2.74ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. B07CD0CA-94E0-4DF5-BB74-38F1371DE605
      • 1. 2
      Backtrace
      • 24. /app/Repositories/ProductRepository.php:153
      • 25. /app/Models/Services/Cache/ProductCacheService.php:164
      • 26. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 27. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 29. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
      4.14ms/app/Repositories/ProductRepository.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 2
      • 1. 1
      Backtrace
      • 24. /app/Repositories/ProductRepository.php:153
      • 25. /app/Models/Services/Cache/ProductCacheService.php:164
      • 26. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 27. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 29. /app/Models/Services/Cache/CacheServiceBase.php:40
    • select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '09275ABC-3D09-4369-A939-ED6CF9CF7549' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
      2.79ms/app/Models/Entities/Product/Product.php:477wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 1. 2
      • 2. 1
      • 3. 0
      Backtrace
      • 19. /app/Models/Entities/Product/Product.php:477
      • 20. /app/Repositories/ProductRepository.php:171
      • 21. /app/Models/Services/Cache/ProductCacheService.php:164
      • 22. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 23. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
    • select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '9EAD993D-3F7F-434C-914C-C1AB0B64EC6C') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
      3.43ms/app/Models/Entities/Product/Product.php:477wen_rhino_rack
      Metadata
      Bindings
      • 0. 2C0FB2F9-F310-435A-BFC0-27BFB884CEE5
      • 1. 3B393703-FAA0-4701-A5B4-DFA329A3DC9B
      • 2. 9EAD993D-3F7F-434C-914C-C1AB0B64EC6C
      • 3. 2
      • 4. 1
      • 5. 0
      Backtrace
      • 24. /app/Models/Entities/Product/Product.php:477
      • 25. /app/Repositories/ProductRepository.php:171
      • 26. /app/Models/Services/Cache/ProductCacheService.php:164
      • 27. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 28. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
    • select `specificationId` from `PR_CategorySpecifications` where `categoryId` in ('9EAD993D-3F7F-434C-914C-C1AB0B64EC6C', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `isVisibleOnProduct` = 1 and `PR_CategorySpecifications`.`deleted_at` is null order by `order` asc
      1.86ms/app/Models/Entities/Product/Product.php:478wen_rhino_rack
      Metadata
      Bindings
      • 0. 9EAD993D-3F7F-434C-914C-C1AB0B64EC6C
      • 1. 3B393703-FAA0-4701-A5B4-DFA329A3DC9B
      • 2. 2C0FB2F9-F310-435A-BFC0-27BFB884CEE5
      • 3. 1
      Backtrace
      • 13. /app/Models/Entities/Product/Product.php:478
      • 14. /app/Repositories/ProductRepository.php:171
      • 15. /app/Models/Services/Cache/ProductCacheService.php:164
      • 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
    • select `title` from `PR_Specifications` where `specificationId` in ('AEF3ACA8-93E7-4674-B28B-1AECF6611583', '7A90BAEF-94DE-4E35-9446-A53AE478B8C7', '65EBFA01-7744-4861-803E-BA026DFC9BA0', '6284DBED-EF43-4436-A768-B530DA94D027', '1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', '2261BB38-5354-44FE-B45C-849D201849B0', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2', 'AEF3ACA8-93E7-4674-B28B-1AECF6611583', '7A90BAEF-94DE-4E35-9446-A53AE478B8C7', '65EBFA01-7744-4861-803E-BA026DFC9BA0', '6284DBED-EF43-4436-A768-B530DA94D027', '1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', '2261BB38-5354-44FE-B45C-849D201849B0', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2') and `PR_Specifications`.`deleted_at` is null order by `order` asc
      1.99ms/app/Models/Entities/Product/Product.php:479wen_rhino_rack
      Metadata
      Bindings
      • 0. AEF3ACA8-93E7-4674-B28B-1AECF6611583
      • 1. 7A90BAEF-94DE-4E35-9446-A53AE478B8C7
      • 2. 65EBFA01-7744-4861-803E-BA026DFC9BA0
      • 3. 6284DBED-EF43-4436-A768-B530DA94D027
      • 4. 1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF
      • 5. 6FEC7B95-51EA-498A-A900-8FD5DA6C89D2
      • 6. 2261BB38-5354-44FE-B45C-849D201849B0
      • 7. 2A37E3E3-CB54-453A-9EE9-53B3406A76CB
      • 8. 14F3FB81-8947-4E5E-BB23-2F17B1452EF2
      • 9. AEF3ACA8-93E7-4674-B28B-1AECF6611583
      • 10. 7A90BAEF-94DE-4E35-9446-A53AE478B8C7
      • 11. 65EBFA01-7744-4861-803E-BA026DFC9BA0
      • 12. 6284DBED-EF43-4436-A768-B530DA94D027
      • 13. 1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF
      • 14. 6FEC7B95-51EA-498A-A900-8FD5DA6C89D2
      • 15. 2261BB38-5354-44FE-B45C-849D201849B0
      • 16. 2A37E3E3-CB54-453A-9EE9-53B3406A76CB
      • 17. 14F3FB81-8947-4E5E-BB23-2F17B1452EF2
      Backtrace
      • 13. /app/Models/Entities/Product/Product.php:479
      • 14. /app/Repositories/ProductRepository.php:171
      • 15. /app/Models/Services/Cache/ProductCacheService.php:164
      • 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
    • select * from `PR_ProductCustomSpecification` where `PR_ProductCustomSpecification`.`ProductId` = '09275ABC-3D09-4369-A939-ED6CF9CF7549' and `PR_ProductCustomSpecification`.`ProductId` is not null and `PR_ProductCustomSpecification`.`deleted_at` is null order by `order` asc, `order` asc
      2.79ms/app/Models/Entities/Product/Product.php:572wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      Backtrace
      • 19. /app/Models/Entities/Product/Product.php:572
      • 20. /app/Repositories/ProductRepository.php:172
      • 21. /app/Models/Services/Cache/ProductCacheService.php:164
      • 22. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 23. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
    • select * from `PR_ProductCategories` where `productId` = '09275ABC-3D09-4369-A939-ED6CF9CF7549' and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc limit 1
      2.6ms/app/Models/Entities/Product/Product.php:68wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 1. 2
      • 2. 1
      • 3. 0
      Backtrace
      • 15. /app/Models/Entities/Product/Product.php:68
      • 16. view::products.modules.product-header:6
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
    • select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('9EAD993D-3F7F-434C-914C-C1AB0B64EC6C') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
      3.24ms/app/Models/Entities/Product/Product.php:68wen_rhino_rack
      Metadata
      Bindings
      • 0. 9EAD993D-3F7F-434C-914C-C1AB0B64EC6C
      • 1. 2
      • 2. 1
      • 3. 0
      Backtrace
      • 20. /app/Models/Entities/Product/Product.php:68
      • 21. view::products.modules.product-header:6
      • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
    • select * from `PR_Medias` where `PR_Medias`.`productId` = '09275ABC-3D09-4369-A939-ED6CF9CF7549' and `PR_Medias`.`productId` is not null and `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '2') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '2') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
      4.24ms/app/Models/Entities/Product/Product.php:763wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 1. 
      • 2. 1
      • 3. 2
      • 4. 1
      • 5. 2
      • 6. 1
      • 7. 2
      • 8. 1
      Backtrace
      • 15. /app/Models/Entities/Product/Product.php:763
      • 16. view::products.modules.product-header:78
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
    • select * from `PR_Medias` where `PR_Medias`.`productId` = '09275ABC-3D09-4369-A939-ED6CF9CF7549' and `PR_Medias`.`productId` is not null and `embedCode` is not null and `embedCode` <> '' and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '2') and `isActive` = 1 order by `vehicleId` asc, `order` asc, `lngId` desc, `order` asc
      2.98ms/app/Models/Entities/Product/Product.php:764wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 1. 
      • 2. 2
      • 3. 1
      Backtrace
      • 15. /app/Models/Entities/Product/Product.php:764
      • 16. view::products.modules.product-header:78
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
    • select * from `PR_VehicleProducts` where `PR_VehicleProducts`.`productId` = '09275ABC-3D09-4369-A939-ED6CF9CF7549' and `PR_VehicleProducts`.`productId` is not null and exists (select * from `VM_Vehicles` where `PR_VehicleProducts`.`vehicleId` = `VM_Vehicles`.`vehicleId` and exists (select * from `VM_Models` where `VM_Vehicles`.`modelId` = `VM_Models`.`modelId` and `VM_Models`.`deleted_at` is null and (`VM_Models`.`lngId` is null or `VM_Models`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc) and `VM_Vehicles`.`deleted_at` is null and (`VM_Vehicles`.`lngId` is null or `VM_Vehicles`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc) and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '2') order by `lngId` desc
      3.41msview::products.modules.compatible-vehicles:3wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 1. 2
      • 2. 1
      • 3. 2
      • 4. 1
      • 5. 2
      Backtrace
      • 20. view::products.modules.compatible-vehicles:3
      • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `VM_Vehicles` where `VM_Vehicles`.`vehicleId` in ('9CB2AAFC-B8C0-4F27-9BA2-C174B48AA5C5') and `VM_Vehicles`.`deleted_at` is null and (`VM_Vehicles`.`lngId` is null or `VM_Vehicles`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc
      3.14msview::products.modules.compatible-vehicles:3wen_rhino_rack
      Metadata
      Bindings
      • 0. 9CB2AAFC-B8C0-4F27-9BA2-C174B48AA5C5
      • 1. 2
      • 2. 1
      Backtrace
      • 25. view::products.modules.compatible-vehicles:3
      • 27. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 29. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • 30. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `VM_Models` where `VM_Models`.`modelId` = 'E28C451D-7D82-443E-9262-9D34866A20EB' and exists (select * from `VM_Manufacturers` where `VM_Models`.`manufacturerId` = `VM_Manufacturers`.`manufacturerId` and `VM_Manufacturers`.`deleted_at` is null and (`VM_Manufacturers`.`lngId` is null or `VM_Manufacturers`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc) and (`VM_Models`.`lngId` is null or `VM_Models`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc limit 1
      2.99ms/app/Models/Entities/Vehicle/Vehicle.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. E28C451D-7D82-443E-9262-9D34866A20EB
      • 1. 2
      • 2. 1
      • 3. 2
      • 4. 1
      Backtrace
      • 18. /app/Models/Entities/Vehicle/Vehicle.php:153
      • 19. view::products.modules.compatible-vehicles:8
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
    • select * from `VM_Manufacturers` where `VM_Manufacturers`.`manufacturerId` in ('676C7930-4605-4F6E-84FB-9AABF9157121') and `VM_Manufacturers`.`deleted_at` is null and (`VM_Manufacturers`.`lngId` is null or `VM_Manufacturers`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc
      2.84ms/app/Models/Entities/Vehicle/Vehicle.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 676C7930-4605-4F6E-84FB-9AABF9157121
      • 1. 2
      • 2. 1
      Backtrace
      • 23. /app/Models/Entities/Vehicle/Vehicle.php:153
      • 24. view::products.modules.compatible-vehicles:8
      • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 28. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
    • select * from `VM_BodyTypes` where `VM_BodyTypes`.`bodyTypeId` = 'FD5D1A23-C587-4F27-A8D9-B2B5F9A53D82' and `VM_BodyTypes`.`deleted_at` is null and (`VM_BodyTypes`.`lngId` is null or `VM_BodyTypes`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc limit 1
      2.79ms/app/Models/Entities/Vehicle/Vehicle.php:154wen_rhino_rack
      Metadata
      Bindings
      • 0. FD5D1A23-C587-4F27-A8D9-B2B5F9A53D82
      • 1. 2
      • 2. 1
      Backtrace
      • 20. /app/Models/Entities/Vehicle/Vehicle.php:154
      • 21. view::products.modules.compatible-vehicles:8
      • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
    • select * from `VM_Attributes` where `VM_Attributes`.`attributeId` = '9840B134-92C0-4900-8A67-ADF49C502226' and `VM_Attributes`.`deleted_at` is null and (`VM_Attributes`.`lngId` is null or `VM_Attributes`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc limit 1
      3.1ms/app/Models/Entities/Vehicle/Vehicle.php:155wen_rhino_rack
      Metadata
      Bindings
      • 0. 9840B134-92C0-4900-8A67-ADF49C502226
      • 1. 2
      • 2. 1
      Backtrace
      • 20. /app/Models/Entities/Vehicle/Vehicle.php:155
      • 21. view::products.modules.compatible-vehicles:8
      • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
    • select count(*) as aggregate from `PR_Categories` where `categoryId` in ('9EAD993D-3F7F-434C-914C-C1AB0B64EC6C', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `isRoofRackCategory` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
      1.61ms/app/Models/Entities/Product/Product.php:496wen_rhino_rack
      Metadata
      Bindings
      • 0. 9EAD993D-3F7F-434C-914C-C1AB0B64EC6C
      • 1. 3B393703-FAA0-4701-A5B4-DFA329A3DC9B
      • 2. 2C0FB2F9-F310-435A-BFC0-27BFB884CEE5
      • 3. 1
      • 4. 2
      • 5. 1
      • 6. 0
      Backtrace
      • 15. /app/Models/Entities/Product/Product.php:496
      • 16. view::products.modules.product-details:215
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
    • select `categoryId` from `PR_Categories` where `categoryType` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
      2.14ms/app/Models/Services/Cache/ProductCacheService.php:427wen_rhino_rack
      Metadata
      Bindings
      • 0. 1
      • 1. 2
      • 2. 1
      • 3. 0
      Backtrace
      • 13. /app/Models/Services/Cache/ProductCacheService.php:427
      • 14. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:397
      • 15. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:408
      • 17. /app/Models/Services/Cache/CacheServiceBase.php:40
      • 18. /app/Models/Services/Cache/ProductCacheService.php:430
    • select * from `fmv_product_specifications` where `fmv_product_specifications`.`productId` = '09275ABC-3D09-4369-A939-ED6CF9CF7549' and `fmv_product_specifications`.`productId` is not null and `fmv_product_specifications`.`deleted_at` is null and (`fmv_product_specifications`.`lngId` is null or `fmv_product_specifications`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
      2.9msview::products.modules.product-details:343wen_rhino_rack
      Metadata
      Bindings
      • 0. 09275ABC-3D09-4369-A939-ED6CF9CF7549
      • 1. 2
      • 2. 1
      Backtrace
      • 19. view::products.modules.product-details:343
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `VM_Models` where `VM_Models`.`modelId` = 'E28C451D-7D82-443E-9262-9D34866A20EB' and exists (select * from `VM_Manufacturers` where `VM_Models`.`manufacturerId` = `VM_Manufacturers`.`manufacturerId` and `VM_Manufacturers`.`deleted_at` is null and (`VM_Manufacturers`.`lngId` is null or `VM_Manufacturers`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc) and (`VM_Models`.`lngId` is null or `VM_Models`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc limit 1
      3.05ms/app/Models/Entities/Vehicle/Vehicle.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. E28C451D-7D82-443E-9262-9D34866A20EB
      • 1. 2
      • 2. 1
      • 3. 2
      • 4. 1
      Backtrace
      • 18. /app/Models/Entities/Vehicle/Vehicle.php:153
      • 19. view::products.modules.compatible-vehicles:8
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
    • select * from `VM_Manufacturers` where `VM_Manufacturers`.`manufacturerId` in ('676C7930-4605-4F6E-84FB-9AABF9157121') and `VM_Manufacturers`.`deleted_at` is null and (`VM_Manufacturers`.`lngId` is null or `VM_Manufacturers`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc
      2.85ms/app/Models/Entities/Vehicle/Vehicle.php:153wen_rhino_rack
      Metadata
      Bindings
      • 0. 676C7930-4605-4F6E-84FB-9AABF9157121
      • 1. 2
      • 2. 1
      Backtrace
      • 23. /app/Models/Entities/Vehicle/Vehicle.php:153
      • 24. view::products.modules.compatible-vehicles:8
      • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 28. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69
    App\Models\Entities\Vehicle\Attribute
    1
    App\Models\Entities\Vehicle\BodyType
    1
    App\Models\Entities\Vehicle\Manufacturer
    2
    App\Models\Entities\Vehicle\VModel
    2
    App\Models\Entities\Shared\Setting
    1
    App\Models\Entities\Vehicle\Vehicle
    2
    App\Models\Entities\Vehicle\VehicleProduct
    2
    App\Models\Entities\Product\ProductCustomSpecification
    2
    App\Models\Entities\Product\ProductCategory
    7
    App\Models\Entities\Product\SpecificationPropertyMasterDataFeature
    8
    App\Models\Entities\Product\SpecificationPropertyMasterData
    9
    App\Models\Entities\Product\SpecificationProperty
    10
    App\Models\Entities\Product\BarType
    2
    App\Models\Entities\Product\BarTypeProduct
    2
    App\Models\Entities\Product\ProductSpecificationProperty
    30
    App\Models\Entities\Product\Specification
    30
    App\Models\Entities\Product\ProductSpecification
    20
    App\Models\Entities\Product\LinkName
    6
    App\Models\Entities\Product\Link
    6
    App\Models\Entities\Product\Media
    6
    App\Models\Entities\Product\Product
    2
    App\Models\Entities\Product\Category
    13
      _token
      dQkPYRe7lGV8mE03yI61CnjM1U92LSoq3KQl5Yor
      country
      nz
      _flash
      array:2 [ "old" => [] "new" => [] ]
      lngId
      2
      session_culture
      en-nz
      random_number
      66
      locale
      en
      _previous
      array:1 [ "url" => "https://rrweb.webexpertsnepal.com/en-nz/products/spares-brackets-components/ro...
      PHPDEBUGBAR_STACK_DATA
      []
      path_info
      /en-nz/products/spares-brackets-components/roof-rack-parts/complete-roof-racks/vortex-rvp-black-2-bar-roof-rack_rvp27
      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 [▼
  "host" => array:1 [▶
    0 => "rrweb.webexpertsnepal.com"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "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"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
]
      request_server
        0 of 0   
      array:48 [▼
  "REDIRECT_SCRIPT_URL" => "/en-nz/products/spares-brackets-components/roof-rack-parts/complete-roof-racks/vortex-rvp-black-2-bar-roof-rack_rvp27"
  "REDIRECT_SCRIPT_URI" => "https://rrweb.webexpertsnepal.com/en-nz/products/spares-brackets-components/roof-rack-parts/complete-roof-racks/vortex-rvp-black-2-bar-roof-rack_rvp27"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_SSL_TLS_SNI" => "rrweb.webexpertsnepal.com"
  "REDIRECT_STATUS" => "200"
  "SCRIPT_URL" => "/en-nz/products/spares-brackets-components/roof-rack-parts/complete-roof-racks/vortex-rvp-black-2-bar-roof-rack_rvp27"
  "SCRIPT_URI" => "https://rrweb.webexpertsnepal.com/en-nz/products/spares-brackets-components/roof-rack-parts/complete-roof-racks/vortex-rvp-black-2-bar-roof-rack_rvp27"
  "HTTPS" => "on"
  "SSL_TLS_SNI" => "rrweb.webexpertsnepal.com"
  "HTTP_HOST" => "rrweb.webexpertsnepal.com"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "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_SEC_FETCH_SITE" => "none"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"
  "SERVER_SIGNATURE" => "<address>Apache/2.4.52 (Ubuntu) Server at rrweb.webexpertsnepal.com Port 443</address>\n"
  "SERVER_SOFTWARE" => "Apache/2.4.52 (Ubuntu)"
  "SERVER_NAME" => "rrweb.webexpertsnepal.com"
  "SERVER_ADDR" => "192.168.2.5"
  "SERVER_PORT" => "443"
  "REMOTE_ADDR" => "192.168.2.1"
  "DOCUMENT_ROOT" => "/var/www/rhinorack/web/public"
  "REQUEST_SCHEME" => "https"
  "CONTEXT_PREFIX" => ""
  "CONTEXT_DOCUMENT_ROOT" => "/var/www/rhinorack/web/public"
  "SERVER_ADMIN" => "webmaster@"
  "SCRIPT_FILENAME" => "/var/www/rhinorack/web/public/index.php"
  "REMOTE_PORT" => "17168"
  "REDIRECT_URL" => "/en-nz/products/spares-brackets-components/roof-rack-parts/complete-roof-racks/vortex-rvp-black-2-bar-roof-rack_rvp27"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/en-nz/products/spares-brackets-components/roof-rack-parts/complete-roof-racks/vortex-rvp-black-2-bar-roof-rack_rvp27"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1741969781.7123
  "REQUEST_TIME" => 1741969781
]
      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 => "Fri, 14 Mar 2025 16:29:41 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InBORzczelczRW85bzEyc2VubDdSMFE9PSIsInZhbHVlIjoiNXNHVWtmaEVVSTdLOHBaQkFBZUtmSWNFVWJIaUpuSGkza1RzYkp6cDgrWlNXQ0h0aTU3QVpyRUF5VEoyZWhMUXZ5OHNIM0hoS0lUd1cyMlg1ZGtUcTErY1ZTT0crU1I4RnJhVEtJa1cwWFNXenY4eExXdVJwcytSOHQ4TDVLdnUiLCJtYWMiOiJlYTNmMjhiM2E0Njg3ZGQzYzQ5ZDUyYmVlMWUyNjZiMTQ2MDkzYmQyNTg2ZTJjOTYwMjI3NjJjNWIxOTdjZWFhIiwidGFnIjoiIn0%3D; expires=Mon, 14 Apr 2025 02:29:42 GMT; Max-Age=2628000; path=/ ◀XSRF-TOKEN=eyJpdiI6InBORzczelczRW85bzEyc2VubDdSMFE9PSIsInZhbHVlIjoiNXNHVWtmaEVVSTdLOHBaQkFBZUtmSWNFVWJIaUpuSGkza1RzYkp6cDgrWlNXQ0h0aTU3QVpyRUF5VEoyZWhMUXZ5OHNIM ▶"
    1 => "rhino_rack_session=eyJpdiI6IkZVNWVWanVjekozT1VTYTRzQmthVlE9PSIsInZhbHVlIjoiTk1UdmxFdGg1RnJJaHF4aTBsdEJrV3Ura2lscmd5Nk1FNHZrS3VuZXN1b2xXTWFmaG16c2ZtZ1B1bWpRUkVZS00zaEVML3pTajFZUkw3QjM4QlZzK09BNWhhZEVUOTM3RElRNXhXSkVocFFGc1Zpc0Z0dzNIVTJhS2JUTGVOVW4iLCJtYWMiOiI4NDU0YTI0MmVlNWI1Y2Q4ZjY1YWY2ZDM0M2JkNzY2MzIwNjE3ODRkNGY1NzhkNDg5YWRmMmRkMzIxYjJlODM1IiwidGFnIjoiIn0%3D; expires=Mon, 14 Apr 2025 02:29:42 GMT; Max-Age=2628000; path=/; httponly ◀rhino_rack_session=eyJpdiI6IkZVNWVWanVjekozT1VTYTRzQmthVlE9PSIsInZhbHVlIjoiTk1UdmxFdGg1RnJJaHF4aTBsdEJrV3Ura2lscmd5Nk1FNHZrS3VuZXN1b2xXTWFmaG16c2ZtZ1B1bWpRUkVZS ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InBORzczelczRW85bzEyc2VubDdSMFE9PSIsInZhbHVlIjoiNXNHVWtmaEVVSTdLOHBaQkFBZUtmSWNFVWJIaUpuSGkza1RzYkp6cDgrWlNXQ0h0aTU3QVpyRUF5VEoyZWhMUXZ5OHNIM0hoS0lUd1cyMlg1ZGtUcTErY1ZTT0crU1I4RnJhVEtJa1cwWFNXenY4eExXdVJwcytSOHQ4TDVLdnUiLCJtYWMiOiJlYTNmMjhiM2E0Njg3ZGQzYzQ5ZDUyYmVlMWUyNjZiMTQ2MDkzYmQyNTg2ZTJjOTYwMjI3NjJjNWIxOTdjZWFhIiwidGFnIjoiIn0%3D; expires=Mon, 14-Apr-2025 02:29:42 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InBORzczelczRW85bzEyc2VubDdSMFE9PSIsInZhbHVlIjoiNXNHVWtmaEVVSTdLOHBaQkFBZUtmSWNFVWJIaUpuSGkza1RzYkp6cDgrWlNXQ0h0aTU3QVpyRUF5VEoyZWhMUXZ5OHNIM ▶"
    1 => "rhino_rack_session=eyJpdiI6IkZVNWVWanVjekozT1VTYTRzQmthVlE9PSIsInZhbHVlIjoiTk1UdmxFdGg1RnJJaHF4aTBsdEJrV3Ura2lscmd5Nk1FNHZrS3VuZXN1b2xXTWFmaG16c2ZtZ1B1bWpRUkVZS00zaEVML3pTajFZUkw3QjM4QlZzK09BNWhhZEVUOTM3RElRNXhXSkVocFFGc1Zpc0Z0dzNIVTJhS2JUTGVOVW4iLCJtYWMiOiI4NDU0YTI0MmVlNWI1Y2Q4ZjY1YWY2ZDM0M2JkNzY2MzIwNjE3ODRkNGY1NzhkNDg5YWRmMmRkMzIxYjJlODM1IiwidGFnIjoiIn0%3D; expires=Mon, 14-Apr-2025 02:29:42 GMT; path=/; httponly ◀rhino_rack_session=eyJpdiI6IkZVNWVWanVjekozT1VTYTRzQmthVlE9PSIsInZhbHVlIjoiTk1UdmxFdGg1RnJJaHF4aTBsdEJrV3Ura2lscmd5Nk1FNHZrS3VuZXN1b2xXTWFmaG16c2ZtZ1B1bWpRUkVZS ▶"
  ]
]
      session_attributes
        0 of 0   
      array:9 [▼
  "_token" => "dQkPYRe7lGV8mE03yI61CnjM1U92LSoq3KQl5Yor"
  "country" => "nz"
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "lngId" => 2
  "session_culture" => "en-nz"
  "random_number" => 66
  "locale" => "en"
  "_previous" => array:1 [▶
    "url" => "https://rrweb.webexpertsnepal.com/en-nz/products/spares-brackets-components/roof-rack-parts/complete-roof-racks/vortex-rvp-black-2-bar-roof-rack_rvp27"
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]