NAN 1 & 2

Messages Timeline Exceptions Views32 Route Queries33 Models47 Mails Gate Session Request

Request history8.1.321.34s18MBGET product/{slug}

Booting (904ms)time
Application (441ms)time
1 x Booting (67.23%)
904ms
1 x Application (32.77%)
441ms

32 templates were rendered

web-views.products.detailsdetails.blade.php#?blade
web-views.partials._productSEOMetaContentData_productSEOMetaContentData.blade.php#?blade
web-views.partials._product-reviews_product-reviews.blade.php#?blade
web-views.partials._seller-products-product-details_seller-products-product-details.blade.php#?blade
web-views.partials._seller-products-product-details_seller-products-product-details.blade.php#?blade
web-views.partials._seller-products-product-details_seller-products-product-details.blade.php#?blade
web-views.partials._seller-products-product-details_seller-products-product-details.blade.php#?blade
web-views.partials._seller-products-product-details_seller-products-product-details.blade.php#?blade
web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
layouts.front-end.partials.modal._chatting_chatting.blade.php#?blade
layouts.front-end.appapp.blade.php#?blade
web-views.partials._robotsMetaContentData_robotsMetaContentData.blade.php#?blade
layouts.front-end.partials._modals_modals.blade.php#?blade
layouts.front-end.partials._quick-view-modal_quick-view-modal.blade.php#?blade
layouts.front-end.partials.modal._buy-now_buy-now.blade.php#?blade
layouts.front-end.partials._header_header.blade.php#?blade
layouts.front-end.partials._cart_cart.blade.php#?blade
layouts.front-end.partials._alert-message_alert-message.blade.php#?blade
layouts.front-end.partials._footer_footer.blade.php#?blade
layouts.front-end.partials.modal._dynamic-modals_dynamic-modals.blade.php#?blade
layouts.front-end.partials._firebase-script_firebase-script.blade.php#?blade

uri: GET product/{slug}
middleware: web, maintenance_mode, guestCheck
controller: App\Http\Controllers\Web\ProductDetailsController@index
namespace: App\Http\Controllers\Web
prefix
where
as: product
file: app/Http/Controllers/Web/ProductDetailsController.php:54-63

33 statements were executed (4 duplicates)Show only duplicates133ms

insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('3.137.153.39', '2025-04-03 15:05:06', '2025-04-03 15:05:06')
7.69msamnauqwg_amnaGuestMiddleware.php#26
Bindings
Backtrace
select * from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `slug` = 'nan-1-2-nZjXaO' limit 1
5.55msamnauqwg_amnaProductRepository.php#126
Bindings
Backtrace
select * from `translations` where `translations`.`translationable_id` in (159) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
1.17msamnauqwg_amnaProductRepository.php#126
Bindings
Backtrace
select * from `reviews` where `reviews`.`product_id` in (159) and `delivery_man_id` is null and `status` = 1
1.04msamnauqwg_amnaProductRepository.php#126
Bindings
Backtrace
select * from `product_seos` where `product_seos`.`product_id` = 159 limit 1
1.11msamnauqwg_amnaProductDetailsController.php#72
Bindings
Backtrace
select * from `digital_product_authors` where `digital_product_authors`.`product_id` = 159 and `digital_product_authors`.`product_id` is not null
1.82msamnauqwg_amnaProductService.php#904
Bindings
Backtrace
select * from `digital_product_publishing_houses` where `digital_product_publishing_houses`.`product_id` = 159 and `digital_product_publishing_houses`.`product_id` is not null
1.36msamnauqwg_amnaProductService.php#925
Bindings
Backtrace
select count(*) as aggregate from `wishlists` where (`product_id` = 159)
4.3msamnauqwg_amnaWishlistRepository.php#62
Bindings
Backtrace
select count(*) as aggregate from `reviews` where (`product_id` = 159) and `status` = 1
2.74msamnauqwg_amnaReviewRepository.php#70
Bindings
Backtrace
select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`added_by` = 'seller') and `user_id` = 1 and `id` not in (159)
2.12msamnauqwg_amnaProductRepository.php#343
Bindings
Backtrace
select * from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`added_by` = 'seller') and `user_id` = 1 and `id` not in (159) order by `id` desc limit 5 offset 0
1.63msamnauqwg_amnaProductRepository.php#343
Bindings
Backtrace
select * from `translations` where `translations`.`translationable_id` in (198, 199, 200, 201, 202) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
1.18msamnauqwg_amnaProductRepository.php#343
Bindings
Backtrace
select * from `reviews` where `reviews`.`product_id` in (198, 199, 200, 201, 202) and `delivery_man_id` is null and `status` = 1
960μsamnauqwg_amnaProductRepository.php#343
Bindings
Backtrace
select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`added_by` = 'seller') and `user_id` = 1
4.71msamnauqwg_amnaProductRepository.php#343
Bindings
Backtrace
select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1 and `status` = 1) as `reviews_count` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`added_by` = 'seller') and `user_id` = 1 limit 25 offset 0
7.48msamnauqwg_amnaProductRepository.php#343
Bindings
Backtrace
select * from `translations` where `translations`.`translationable_id` in (65, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
12.06msamnauqwg_amnaProductRepository.php#343
Bindings
Backtrace
select * from `reviews` where `reviews`.`product_id` in (65, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90) and `delivery_man_id` is null and `status` = 1
5.71msamnauqwg_amnaProductRepository.php#343
Bindings
Backtrace
select count(*) as aggregate from `order_details` where (`product_id` = 159)
5.95msamnauqwg_amnaOrderDetailRepository.php#82
Bindings
Backtrace
select count(*) as aggregate from `wishlists` where (`product_id` = 159)
1.54msamnauqwg_amnaWishlistRepository.php#62
Bindings
Backtrace
select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`category_id` = 10) and `id` not in (159)
2.18msamnauqwg_amnaProductRepository.php#343
Bindings
Backtrace
select * from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`category_id` = 10) and `id` not in (159) limit 12 offset 0
8.64msamnauqwg_amnaProductRepository.php#343
Bindings
Backtrace
select * from `reviews` where `reviews`.`product_id` in (74, 75, 83, 86, 87, 88, 93, 115, 116, 126, 130, 140) and `delivery_man_id` is null and `status` = 1
2.43msamnauqwg_amnaProductRepository.php#343
Bindings
Backtrace
select * from `translations` where `translations`.`translationable_id` in (74, 75, 83, 86, 87, 88, 93, 115, 116, 126, 130, 140) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
1.83msamnauqwg_amnaProductRepository.php#343
Bindings
Backtrace
select * from `deal_of_the_days` where (`product_id` = 159 and `status` = 1) limit 1
5.21msamnauqwg_amnaDealOfTheDayRepository.php#24
Bindings
Backtrace
select * from `sellers` where `sellers`.`id` = 1 limit 1
10.93msamnauqwg_amnaProductDetailsController.php#132
Bindings
Backtrace
select * from `shops` where `shops`.`seller_id` = 1 and `shops`.`seller_id` is not null limit 1
5.37msamnauqwg_amnaProductDetailsController.php#132
Bindings
Backtrace
select * from `digital_product_variations` where `digital_product_variations`.`product_id` = 159 and `digital_product_variations`.`product_id` is not null
1.35msamnauqwg_amnaproduct.php#82
Bindings
Backtrace
select * from `currencies` where `status` = 1
5.9msamnauqwg_amna_header.blade.php#38
Bindings
Backtrace
select `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) and (`customer_id` = 659154 and `is_guest` = 1) group by `cart_group_id`
7.38msamnauqwg_amnacart-manager.php#100
Bindings
Backtrace
select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) and 0 = 1
2.35msamnauqwg_amnacart-manager.php#65
Bindings
Backtrace
select `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) and (`customer_id` = 659154 and `is_guest` = 1) group by `cart_group_id`
4.17msamnauqwg_amnacart-manager.php#100
Bindings
Backtrace
select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) and 0 = 1 and (`is_checked` = 1)
2.82msamnauqwg_amnacart-manager.php#65
Bindings
Backtrace
select * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-04-03' and date(`end_date`) >= '2025-04-03' limit 1
2.23msamnauqwg_amna_footer.blade.php#109
Bindings
Backtrace

App\Models\Product: 43Product.php#?
App\Models\Review: 1Review.php#?
App\Models\Seller: 1Seller.php#?
App\Models\Shop: 1Shop.php#?
App\Models\Currency: 1Currency.php#?

system_default_currency_info: App\Models\Currency {#2538 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
currency_code: NGN
currency_symbol: ₦
currency_exchange_rate: 1
usd: 1
_token: HhM16EYCVYkiL43MVdi0FDIskjfL8wJa7MBg3NAp
guest_id: 659154
local: en
direction: ltr
_previous: array:1 [ "url" => "https://amna.ng/product/nan-1-2-nZjXaO" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/product/nan-1-2-nZjXaO

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:18 [▼
  "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"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "host" => array:1 [▶
    0 => "amna.ng"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.137.153.39"
  ]
  "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"
  ]
  "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"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "x-https" => array:1 [▶
    0 => "on"
  ]
]

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 => "Thu, 03 Apr 2025 14:05:07 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InVmVWFLZkgzZmsrRytBNDhHdWxsaWc9PSIsInZhbHVlIjoiWEhTYUs5WHpVSmlFdVByUUszREc0K2dlZ1FCWXdMTE42SlpiK0hoYzIvaDI0QnZGNE9wU2N3bVhMVDZlMG9RbFdDeTQ5TWtTOU1XeFFvWlBwbk54UHJ1VlBmVHB0eUtjYml6ajB5RUQxY3hSQk1qL0h3Nkx0SjBiVmJHcEVlVnIiLCJtYWMiOiJlNjI5OTQxOTdiN2ZlN2E4NWEzZjYxMThkODQ5NzAyOWNlZTAzOTRlM2I5OWE1ZTI3ZWE1YWQyYzE2NTQ1ZTE3IiwidGFnIjoiIn0%3D; expires=Thu, 03 Apr 2025 15:05:07 GMT; Max-Age=3600; path=/ ◀XSRF-TOKEN=eyJpdiI6InVmVWFLZkgzZmsrRytBNDhHdWxsaWc9PSIsInZhbHVlIjoiWEhTYUs5WHpVSmlFdVByUUszREc0K2dlZ1FCWXdMTE42SlpiK0hoYzIvaDI0QnZGNE9wU2N3bVhMVDZlMG9RbFdDeTQ5T ▶"
    1 => "6valley1733189058_session=eyJpdiI6IkVkQUpSZ2xJNzI5Q3lVMXMzTUVrV0E9PSIsInZhbHVlIjoiTU53ejNnUG5FOHkwd3JBREJJZFNoMmp5RHc2Y3d3M21ONWswc2FwWGZXMzJFRHpEUWZNR1JDSUIrOEpsTWloellvZFlVSVByQjhPRzJjaU9zZ2UxRmFHM1ZvYzc0YndKN2FxRDJ3eEZuK0RocXc2WThtam5ISS9WeWI5VHFvc3EiLCJtYWMiOiJjYmM0ZmE5MjVkZGQ4M2Q1YTNlODYyMzEzMjcyYzQxYmE0NWM1YzY5ZWI5MzQwYTQ3OWZjNDJhYzUwM2M2ZmY1IiwidGFnIjoiIn0%3D; expires=Thu, 03 Apr 2025 15:05:07 GMT; Max-Age=3600; path=/; httponly ◀6valley1733189058_session=eyJpdiI6IkVkQUpSZ2xJNzI5Q3lVMXMzTUVrV0E9PSIsInZhbHVlIjoiTU53ejNnUG5FOHkwd3JBREJJZFNoMmp5RHc2Y3d3M21ONWswc2FwWGZXMzJFRHpEUWZNR1JDSUIrOE ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InVmVWFLZkgzZmsrRytBNDhHdWxsaWc9PSIsInZhbHVlIjoiWEhTYUs5WHpVSmlFdVByUUszREc0K2dlZ1FCWXdMTE42SlpiK0hoYzIvaDI0QnZGNE9wU2N3bVhMVDZlMG9RbFdDeTQ5TWtTOU1XeFFvWlBwbk54UHJ1VlBmVHB0eUtjYml6ajB5RUQxY3hSQk1qL0h3Nkx0SjBiVmJHcEVlVnIiLCJtYWMiOiJlNjI5OTQxOTdiN2ZlN2E4NWEzZjYxMThkODQ5NzAyOWNlZTAzOTRlM2I5OWE1ZTI3ZWE1YWQyYzE2NTQ1ZTE3IiwidGFnIjoiIn0%3D; expires=Thu, 03-Apr-2025 15:05:07 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InVmVWFLZkgzZmsrRytBNDhHdWxsaWc9PSIsInZhbHVlIjoiWEhTYUs5WHpVSmlFdVByUUszREc0K2dlZ1FCWXdMTE42SlpiK0hoYzIvaDI0QnZGNE9wU2N3bVhMVDZlMG9RbFdDeTQ5T ▶"
    1 => "6valley1733189058_session=eyJpdiI6IkVkQUpSZ2xJNzI5Q3lVMXMzTUVrV0E9PSIsInZhbHVlIjoiTU53ejNnUG5FOHkwd3JBREJJZFNoMmp5RHc2Y3d3M21ONWswc2FwWGZXMzJFRHpEUWZNR1JDSUIrOEpsTWloellvZFlVSVByQjhPRzJjaU9zZ2UxRmFHM1ZvYzc0YndKN2FxRDJ3eEZuK0RocXc2WThtam5ISS9WeWI5VHFvc3EiLCJtYWMiOiJjYmM0ZmE5MjVkZGQ4M2Q1YTNlODYyMzEzMjcyYzQxYmE0NWM1YzY5ZWI5MzQwYTQ3OWZjNDJhYzUwM2M2ZmY1IiwidGFnIjoiIn0%3D; expires=Thu, 03-Apr-2025 15:05:07 GMT; path=/; httponly ◀6valley1733189058_session=eyJpdiI6IkVkQUpSZ2xJNzI5Q3lVMXMzTUVrV0E9PSIsInZhbHVlIjoiTU53ejNnUG5FOHkwd3JBREJJZFNoMmp5RHc2Y3d3M21ONWswc2FwWGZXMzJFRHpEUWZNR1JDSUIrOE ▶"
  ]
]

session_attributes

  0 of 0   
array:11 [▼
  "system_default_currency_info" => App\Models\Currency {#2538 ▶
    #connection: "mysql"
    #table: "currencies"
    #primaryKey: "id"
    #keyType: "int"
    +incrementing: true
    #with: []
    #withCount: []
    +preventsLazyLoading: false
    #perPage: 15
    +exists: true
    +wasRecentlyCreated: false
    #escapeWhenCastingToString: false
    #attributes: array:8 [▶
      "id" => "11"
      "name" => "Naira"
      "symbol" => "₦"
      "code" => "NGN"
      "exchange_rate" => "1"
      "status" => "1"
      "created_at" => "2022-08-19 09:19:09"
      "updated_at" => "2024-07-19 13:31:58"
    ]
    #original: array:8 [▶
      "id" => "11"
      "name" => "Naira"
      "symbol" => "₦"
      "code" => "NGN"
      "exchange_rate" => "1"
      "status" => "1"
      "created_at" => "2022-08-19 09:19:09"
      "updated_at" => "2024-07-19 13:31:58"
    ]
    #changes: []
    #casts: array:4 [▶
      "id" => "integer"
      "status" => "boolean"
      "created_at" => "datetime"
      "updated_at" => "datetime"
    ]
    #classCastCache: []
    #attributeCastCache: []
    #dateFormat: null
    #appends: []
    #dispatchesEvents: []
    #observables: []
    #relations: []
    #touches: []
    +timestamps: true
    +usesUniqueIds: false
    #hidden: []
    #visible: []
    #fillable: array:5 [▶
      0 => "name"
      1 => "symbol"
      2 => "code"
      3 => "exchange_rate"
      4 => "status"
    ]
    #guarded: array:1 [▶
      0 => "*"
    ]
  }
  "currency_code" => "NGN"
  "currency_symbol" => "₦"
  "currency_exchange_rate" => "1"
  "usd" => 1
  "_token" => "HhM16EYCVYkiL43MVdi0FDIskjfL8wJa7MBg3NAp"
  "guest_id" => 659154
  "local" => "en"
  "direction" => "ltr"
  "_previous" => array:1 [▶
    "url" => "https://amna.ng/product/nan-1-2-nZjXaO"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-03 15:05:07	GET	/product/nan-1-2-nZjXaO	32 33 47

1 x Booting (67.23%)	904ms
1 x Application (32.77%)	441ms

Bindings
Backtrace

Bindings
Backtrace

Bindings
Backtrace

Shopping cart

NAN 1 & 2

Amna Shop

Similar products

Out of stock

Product added to wishlist

Please Sign in

Delete this address?