Featured deal Products
5 Items found
SettingsRequest history8.3.23PHP Version4.05sRequest Duration10MBMemory UsageGET products
status
200 OK
full_url
https://matjariq.com/products?offer_type=featured_deal
action_name
products
controller_action
App\Http\Controllers\Web\ProductListController@products
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
status
200 OK
full_url
https://matjariq.com/products?offer_type=featured_deal
action_name
products
controller_action
App\Http\Controllers\Web\ProductListController@products
uri
GET products
controller
App\Http\Controllers\Web\ProductListController@products
namespace
App\Http\Controllers\Web
file
app/Http/Controllers/Web/ProductListController.php:28-37
middleware
web, maintenance_mode, guestCheck
duration
4.07s
peak_memory
12MB
response
text/html; charset=UTF-8
request_format
html
request_query
0 of 0
array:1 [ "offer_type" => "featured_deal" ]
request_request
[]
request_headers
0 of 0
array:26 [ "cf-connecting-ip" => array:1 [ 0 => "216.73.216.147" ] "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" ] "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" ] "cdn-loop" => array:1 [ 0 => "cloudflare; loops=1; subreqs=1" ] "cf-ew-via" => array:1 [ 0 => "15" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "cf-ipcountry" => array:1 [ 0 => "US" ] "cf-visitor" => array:1 [ 0 => "{"scheme":"https"}" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept-encoding" => array:1 [ 0 => "gzip, br" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "priority" => array:1 [ 0 => "u=0, i" ] "cf-ray" => array:1 [ 0 => "95f79db780c71132-ORD" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-forwarded-for" => array:1 [ 0 => "216.73.216.147" ] "x-real-ip" => array:1 [ 0 => "172.69.58.247" ] "host" => array:1 [ 0 => "matjariq.com" ] ]
request_cookies
[]
response_headers
0 of 0
array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "private, must-revalidate" ] "date" => array:1 [ 0 => "Tue, 15 Jul 2025 07:41:13 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] ]
session_attributes
0 of 0
array:9 [ "local" => "en" "direction" => "ltr" "system_default_currency_info" => App\Models\Currency {#737 #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" => 8 "name" => "IQD" "symbol" => "IQD" "code" => "IQD" "exchange_rate" => "1" "status" => 1 "created_at" => "2024-07-25 05:37:48" "updated_at" => "2024-08-28 08:59:47" ] #original: array:8 [ "id" => 8 "name" => "IQD" "symbol" => "IQD" "code" => "IQD" "exchange_rate" => "1" "status" => 1 "created_at" => "2024-07-25 05:37:48" "updated_at" => "2024-08-28 08:59:47" ] #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" => "IQD" "currency_symbol" => "IQD" "currency_exchange_rate" => "1" "usd" => 1 "_token" => "idyDhmOKvXk2KzriIslE52LHYewMJh9ns0KwHGN6" "guest_id" => 211056 ]
    • Booting (818ms)time
    • Application (3.24s)time
    • Routing (20.72ms)
    • Preparing Response (3s)
    • 1 x Application (79.82%)
      3.24s
      1 x Preparing Response (74%)
      3.00s
      1 x Booting (20.18%)
      818ms
      1 x Routing (0.51%)
      20.72ms
      30 templates were rendered
      • web-views.products.viewview.blade.php#?blade
      • web-views.products.partials._product-list-header_product-list-header.blade.php#?blade
      • web-views.partials._svg-icon-container_svg-icon-container.blade.php#?blade
      • web-views.partials._svg-icon-container_svg-icon-container.blade.php#?blade
      • web-views.products.partials._filter-product-type_filter-product-type.blade.php#?blade
      • web-views.products.partials._filter-product-sort_filter-product-sort.blade.php#?blade
      • web-views.products.partials._filter-product-price_filter-product-price.blade.php#?blade
      • web-views.products.partials._filter-product-categories_filter-product-categories.blade.php#?blade
      • web-views.products.partials._filter-product-brands_filter-product-brands.blade.php#?blade
      • web-views.products.partials._filter-publishing-houses_filter-publishing-houses.blade.php#?blade
      • web-views.products.partials._filter-product-authors_filter-product-authors.blade.php#?blade
      • web-views.products._ajax-products_ajax-products.blade.php#?blade
      • web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
      • web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
      • web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
      • web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
      • web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
      • pagination::bootstrap-4bootstrap-4.blade.php#?blade
      • layouts.front-end.appapp.blade.php#?blade
      • web-views.partials._robotsMetaContentData_robotsMetaContentData.blade.php#?blade
      • system-partials._analytics_script_analytics_script.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 products
      middleware
      web, maintenance_mode, guestCheck
      controller
      App\Http\Controllers\Web\ProductListController@products
      namespace
      App\Http\Controllers\Web
      as
      products
      file
      app/Http/Controllers/Web/ProductListController.php:28-37
      37 statements were executed (11 duplicates)Show only duplicates39.92ms
      • GuestMiddleware.php#24maindb3.32msinsert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('172.69.58.247', '2025-07-15 10:41:13', '2025-07-15 10:41:13')
        Bindings
        • 0: 172.69.58.247
        • 1: 2025-07-15 10:41:13
        • 2: 2025-07-15 10:41:13
        Backtrace
        • middleware::guestCheck:24
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • middleware::maintenance_mode:30
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • category-manager.php#89maindb700μsselect `id` from `flash_deals` where (`deal_type` = 'feature_deal' and `status` = 1) and date(`start_date`) <= '2025-07-15' and date(`end_date`) >= '2025-07-15'
        Bindings
        • 0: feature_deal
        • 1: 1
        • 2: 2025-07-15
        • 3: 2025-07-15
        Backtrace
        • app/Utils/category-manager.php:89
        • app/Http/Controllers/Web/ProductListController.php:52
        • app/Http/Controllers/Web/ProductListController.php:33
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • category-manager.php#91maindb720μsselect * from `products` where 0 = 1
        Backtrace
        • app/Utils/category-manager.php:91
        • app/Http/Controllers/Web/ProductListController.php:52
        • app/Http/Controllers/Web/ProductListController.php:33
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • category-manager.php#152maindb1.14msselect `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_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 0 = 1) as `product_count` from `categories` where `position` = 0
        Bindings
        • 0: 1
        • 1: 1
        • 2: approved
        • 3: admin
        • 4: 1
        • 5: digital
        • 6: physical
        • 7: 0
        Backtrace
        • app/Utils/category-manager.php:152
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Utils/category-manager.php:95
        • app/Http/Controllers/Web/ProductListController.php:52
      • category-manager.php#152maindb1.98msselect `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (5, 6, 7, 8, 9, 11, 14, 17, 18, 19) 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')
        Bindings
        • 0: 1
        • 1: 1
        • 2: approved
        • 3: admin
        • 4: 1
        • 5: digital
        • 6: physical
        Backtrace
        • app/Utils/category-manager.php:152
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Utils/category-manager.php:95
        • app/Http/Controllers/Web/ProductListController.php:52
      • category-manager.php#152maindb770μsselect * from `stock_clearance_products` where `stock_clearance_products`.`product_id` in (6, 7, 8, 9, 10, 12, 13, 14) and (`is_active` = 1) and `added_by` in ('admin', 'vendor') and exists (select * from `stock_clearance_setups` where `stock_clearance_products`.`setup_id` = `stock_clearance_setups`.`id` and `is_active` = 1 and date(`duration_start_date`) <= '2025-07-15' and date(`duration_end_date`) >= '2025-07-15' and ((`offer_active_time` = 'specific_time' and time(`offer_active_range_start`) <= '10:41:13' and time(`offer_active_range_end`) >= '10:41:13') or (`offer_active_time` = 'always' and `offer_active_range_start` is null and `offer_active_range_end` is null)))
        Bindings
        • 0: 1
        • 1: admin
        • 2: vendor
        • 3: 1
        • 4: 2025-07-15
        • 5: 2025-07-15
        • 6: specific_time
        • 7: 10:41:13
        • 8: 10:41:13
        • 9: always
        Backtrace
        • app/Utils/category-manager.php:152
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Utils/category-manager.php:95
        • app/Http/Controllers/Web/ProductListController.php:52
      • category-manager.php#152maindb760μsselect * from `translations` where `translations`.`translationable_id` in (6, 7, 8, 9, 10, 12, 13, 14) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
        Bindings
        • 0: App\Models\Product
        • 1: en
        Backtrace
        • app/Utils/category-manager.php:152
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Utils/category-manager.php:95
        • app/Http/Controllers/Web/ProductListController.php:52
      • category-manager.php#152maindb760μsselect * from `reviews` where `reviews`.`product_id` in (6, 7, 8, 9, 10, 12, 13, 14) and `delivery_man_id` is null and `status` = 1
        Bindings
        • 0: 1
        Backtrace
        • app/Utils/category-manager.php:152
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Utils/category-manager.php:95
        • app/Http/Controllers/Web/ProductListController.php:52
      • category-manager.php#152maindb1.22msselect `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_category_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 0 = 1) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (5, 6, 7, 8, 9, 11, 14, 17, 18, 19) and `position` = 1 order by `priority` asc
        Bindings
        • 0: 1
        • 1: 1
        • 2: approved
        • 3: admin
        • 4: 1
        • 5: digital
        • 6: physical
        • 7: 1
        Backtrace
        • app/Utils/category-manager.php:152
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Utils/category-manager.php:95
        • app/Http/Controllers/Web/ProductListController.php:52
      • category-manager.php#152maindb1.24msselect `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_sub_category_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 0 = 1) as `sub_sub_category_product_count` from `categories` where `categories`.`parent_id` in (20) and `position` = 2 order by `priority` asc
        Bindings
        • 0: 1
        • 1: 1
        • 2: approved
        • 3: admin
        • 4: 1
        • 5: digital
        • 6: physical
        • 7: 2
        Backtrace
        • app/Utils/category-manager.php:152
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Utils/category-manager.php:95
        • app/Http/Controllers/Web/ProductListController.php:52
      • category-manager.php#152maindb950μsselect * from `translations` where `translations`.`translationable_id` in (20) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
        Bindings
        • 0: App\Models\Category
        • 1: en
        Backtrace
        • app/Utils/category-manager.php:152
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Utils/category-manager.php:95
        • app/Http/Controllers/Web/ProductListController.php:52
      • category-manager.php#152maindb890μsselect * from `translations` where `translations`.`translationable_id` in (5, 6, 7, 8, 9, 11, 14, 17, 18, 19) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
        Bindings
        • 0: App\Models\Category
        • 1: en
        Backtrace
        • app/Utils/category-manager.php:152
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Utils/category-manager.php:95
        • app/Http/Controllers/Web/ProductListController.php:52
      • brand-manager.php#82maindb1.41msselect `brands`.*, (select count(*) from `products` where `brands`.`id` = `products`.`brand_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 (`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')) as `brand_products_count` from `brands` where `status` = 1 order by `created_at` desc
        Bindings
        • 0: 1
        • 1: 1
        • 2: approved
        • 3: admin
        • 4: 1
        • 5: digital
        • 6: physical
        • 7: 1
        • 8: 1
        • 9: approved
        • 10: admin
        • 11: 1
        • 12: digital
        • 13: physical
        • 14: 1
        Backtrace
        • app/Utils/brand-manager.php:82
        • app/Utils/brand-manager.php:56
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Utils/brand-manager.php:44
      • brand-manager.php#82maindb1.27msselect * from `translations` where `translations`.`translationable_id` in (1, 2) and `translations`.`translationable_type` = 'App\\Models\\Brand' and `locale` = 'en'
        Bindings
        • 0: App\Models\Brand
        • 1: en
        Backtrace
        • app/Utils/brand-manager.php:82
        • app/Utils/brand-manager.php:56
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Utils/brand-manager.php:44
      • product-manager.php#1956maindb1.2msselect `publishing_houses`.*, (select count(*) from `digital_product_publishing_houses` where `publishing_houses`.`id` = `digital_product_publishing_houses`.`publishing_house_id` and exists (select * from `products` where `digital_product_publishing_houses`.`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'))) as `publishing_house_products_count` from `publishing_houses` where exists (select * from `digital_product_publishing_houses` where `publishing_houses`.`id` = `digital_product_publishing_houses`.`publishing_house_id` and exists (select * from `products` where `digital_product_publishing_houses`.`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')))
        Bindings
        • 0: 1
        • 1: 1
        • 2: approved
        • 3: admin
        • 4: 1
        • 5: digital
        • 6: physical
        • 7: 1
        • 8: 1
        • 9: approved
        • 10: admin
        • 11: 1
        • 12: digital
        • 13: physical
        Backtrace
        • app/Utils/product-manager.php:1956
        • app/Http/Controllers/Web/ProductListController.php:68
        • app/Http/Controllers/Web/ProductListController.php:33
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • product-manager.php#1965maindb950μsselect `id` 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 (`product_type` = 'digital') and 1 = 1
        Bindings
        • 0: 1
        • 1: 1
        • 2: approved
        • 3: admin
        • 4: 1
        • 5: digital
        • 6: physical
        • 7: digital
        Backtrace
        • app/Utils/product-manager.php:1965
        • app/Http/Controllers/Web/ProductListController.php:68
        • app/Http/Controllers/Web/ProductListController.php:33
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • product-manager.php#1971maindb1.14msselect `authors`.*, (select count(*) from `digital_product_authors` where `authors`.`id` = `digital_product_authors`.`author_id` and exists (select * from `products` where `digital_product_authors`.`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'))) as `digital_product_author_count` from `authors`
        Bindings
        • 0: 1
        • 1: 1
        • 2: approved
        • 3: admin
        • 4: 1
        • 5: digital
        • 6: physical
        Backtrace
        • app/Utils/product-manager.php:1971
        • app/Http/Controllers/Web/ProductListController.php:68
        • app/Http/Controllers/Web/ProductListController.php:33
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • product-manager.php#1979maindb1.22msselect `id` 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 (`product_type` = 'digital') and 1 = 1
        Bindings
        • 0: 1
        • 1: 1
        • 2: approved
        • 3: admin
        • 4: 1
        • 5: digital
        • 6: physical
        • 7: digital
        Backtrace
        • app/Utils/product-manager.php:1979
        • app/Http/Controllers/Web/ProductListController.php:68
        • app/Http/Controllers/Web/ProductListController.php:33
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • product-manager.php#2184maindb690μsselect `id` from `flash_deals` where (`deal_type` = 'feature_deal' and `status` = 1) and date(`start_date`) <= '2025-07-15' and date(`end_date`) >= '2025-07-15'
        Bindings
        • 0: feature_deal
        • 1: 1
        • 2: 2025-07-15
        • 3: 2025-07-15
        Backtrace
        • app/Utils/product-manager.php:2184
        • vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
        • app/Utils/product-manager.php:2182
        • app/Http/Controllers/Web/ProductListController.php:68
        • app/Http/Controllers/Web/ProductListController.php:33
      • product-manager.php#1393maindb2.27msselect `products`.*, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select sum(`order_details`.`qty`) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_sum_qty`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` 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 0 = 1 and exists (select * from `flash_deal_products` where `products`.`id` = `flash_deal_products`.`product_id` and exists (select * from `flash_deals` where `flash_deal_products`.`flash_deal_id` = `flash_deals`.`id` and date(`start_date`) <= '2025-07-15' and date(`end_date`) >= '2025-07-15' and (`deal_type` = 'feature_deal' and `status` = 1))) and ((`added_by` = 'seller') and exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and exists (select * from `shops` where `sellers`.`id` = `shops`.`seller_id` and (`temporary_close` = 0)))) or ((`added_by` = 'admin')) and (`product_type` = 'digital' or (`product_type` = 'physical' and `current_stock` > 0)) order by `id` desc
        Bindings
        • 0: 1
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: approved
        • 7: admin
        • 8: 1
        • 9: digital
        • 10: physical
        • 11: 2025-07-15
        • 12: 2025-07-15
        • 13: feature_deal
        • 14: 1
        • 15: seller
        • 16: 0
        • 17: admin
        • 18: digital
        • 19: physical
        • 20: 0
        Backtrace
        • app/Utils/product-manager.php:1393
        • app/Utils/product-manager.php:2234
        • app/Http/Controllers/Web/ProductListController.php:68
        • app/Http/Controllers/Web/ProductListController.php:33
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • product-manager.php#1393maindb700μsselect * from `categories` where `categories`.`id` in (6, 8, 11)
        Backtrace
        • app/Utils/product-manager.php:1393
        • app/Utils/product-manager.php:2234
        • app/Http/Controllers/Web/ProductListController.php:68
        • app/Http/Controllers/Web/ProductListController.php:33
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • product-manager.php#1393maindb920μsselect * from `translations` where `translations`.`translationable_id` in (6, 8, 11) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
        Bindings
        • 0: App\Models\Category
        • 1: en
        Backtrace
        • app/Utils/product-manager.php:1393
        • app/Utils/product-manager.php:2234
        • app/Http/Controllers/Web/ProductListController.php:68
        • app/Http/Controllers/Web/ProductListController.php:33
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • product-manager.php#1393maindb750μsselect * from `reviews` where `reviews`.`product_id` in (6, 7, 12, 13, 14) and `delivery_man_id` is null and `status` = 1
        Bindings
        • 0: 1
        Backtrace
        • app/Utils/product-manager.php:1393
        • app/Utils/product-manager.php:2234
        • app/Http/Controllers/Web/ProductListController.php:68
        • app/Http/Controllers/Web/ProductListController.php:33
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • product-manager.php#1393maindb740μsselect avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (6, 7, 12, 13, 14) and `status` = 1 group by `product_id`
        Bindings
        • 0: 1
        Backtrace
        • app/Utils/product-manager.php:1393
        • app/Utils/product-manager.php:2234
        • app/Http/Controllers/Web/ProductListController.php:68
        • app/Http/Controllers/Web/ProductListController.php:33
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • product-manager.php#1393maindb820μsselect * from `sellers` where `sellers`.`id` in (1)
        Backtrace
        • app/Utils/product-manager.php:1393
        • app/Utils/product-manager.php:2234
        • app/Http/Controllers/Web/ProductListController.php:68
        • app/Http/Controllers/Web/ProductListController.php:33
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • product-manager.php#1393maindb1.03msselect * from `stock_clearance_products` where `stock_clearance_products`.`product_id` in (6, 7, 12, 13, 14) and (`is_active` = 1) and `added_by` in ('admin', 'vendor') and exists (select * from `stock_clearance_setups` where `stock_clearance_products`.`setup_id` = `stock_clearance_setups`.`id` and `is_active` = 1 and date(`duration_start_date`) <= '2025-07-15' and date(`duration_end_date`) >= '2025-07-15' and ((`offer_active_time` = 'specific_time' and time(`offer_active_range_start`) <= '10:41:13' and time(`offer_active_range_end`) >= '10:41:13') or (`offer_active_time` = 'always' and `offer_active_range_start` is null and `offer_active_range_end` is null)))
        Bindings
        • 0: 1
        • 1: admin
        • 2: vendor
        • 3: 1
        • 4: 2025-07-15
        • 5: 2025-07-15
        • 6: specific_time
        • 7: 10:41:13
        • 8: 10:41:13
        • 9: always
        Backtrace
        • app/Utils/product-manager.php:1393
        • app/Utils/product-manager.php:2234
        • app/Http/Controllers/Web/ProductListController.php:68
        • app/Http/Controllers/Web/ProductListController.php:33
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • product-manager.php#1393maindb670μsselect * from `flash_deal_products` where `flash_deal_products`.`product_id` in (6, 7, 12, 13, 14)
        Backtrace
        • app/Utils/product-manager.php:1393
        • app/Utils/product-manager.php:2234
        • app/Http/Controllers/Web/ProductListController.php:68
        • app/Http/Controllers/Web/ProductListController.php:33
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • product-manager.php#1393maindb800μsselect * from `translations` where `translations`.`translationable_id` in (6, 7, 12, 13, 14) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
        Bindings
        • 0: App\Models\Product
        • 1: en
        Backtrace
        • app/Utils/product-manager.php:1393
        • app/Utils/product-manager.php:2234
        • app/Http/Controllers/Web/ProductListController.php:68
        • app/Http/Controllers/Web/ProductListController.php:33
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • product-manager.php#2389maindb1.23msselect * 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` = 211056 and `is_guest` = 1)
        Bindings
        • 0: 1
        • 1: 1
        • 2: approved
        • 3: admin
        • 4: 1
        • 5: digital
        • 6: physical
        • 7: 1
        • 8: 211056
        • 9: 1
        Backtrace
        • app/Utils/product-manager.php:2389
        • app/Utils/cart-manager.php:50
        • view::layouts.front-end.partials._cart:1
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • cart-manager.php#130maindb850μsselect `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` = 211056 and `is_guest` = 1) group by `cart_group_id`
        Bindings
        • 0: 1
        • 1: 1
        • 2: approved
        • 3: admin
        • 4: 1
        • 5: digital
        • 6: physical
        • 7: 1
        • 8: 211056
        • 9: 1
        Backtrace
        • app/Utils/cart-manager.php:130
        • app/Utils/cart-manager.php:61
        • vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
        • app/Utils/cart-manager.php:60
        • view::layouts.front-end.partials._cart:1
      • cart-manager.php#69maindb950μsselect * 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
        Bindings
        • 0: 1
        • 1: 1
        • 2: approved
        • 3: admin
        • 4: 1
        • 5: digital
        • 6: physical
        • 7: 1
        Backtrace
        • app/Utils/cart-manager.php:69
        • view::layouts.front-end.partials._cart:1
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • product-manager.php#2389maindb1.13msselect * 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` = 211056 and `is_guest` = 1)
        Bindings
        • 0: 1
        • 1: 1
        • 2: approved
        • 3: admin
        • 4: 1
        • 5: digital
        • 6: physical
        • 7: 1
        • 8: 211056
        • 9: 1
        Backtrace
        • app/Utils/product-manager.php:2389
        • app/Utils/cart-manager.php:50
        • view::layouts.front-end.partials._cart:2
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • cart-manager.php#130maindb1.2msselect `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` = 211056 and `is_guest` = 1) group by `cart_group_id`
        Bindings
        • 0: 1
        • 1: 1
        • 2: approved
        • 3: admin
        • 4: 1
        • 5: digital
        • 6: physical
        • 7: 1
        • 8: 211056
        • 9: 1
        Backtrace
        • app/Utils/cart-manager.php:130
        • app/Utils/cart-manager.php:61
        • vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
        • app/Utils/cart-manager.php:60
        • view::layouts.front-end.partials._cart:2
      • cart-manager.php#69maindb1msselect * 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)
        Bindings
        • 0: 1
        • 1: 1
        • 2: approved
        • 3: admin
        • 4: 1
        • 5: digital
        • 6: physical
        • 7: 1
        • 8: 1
        Backtrace
        • app/Utils/cart-manager.php:69
        • view::layouts.front-end.partials._cart:2
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • category-manager.php#89maindb880μsselect `id` from `flash_deals` where (`deal_type` = 'feature_deal' and `status` = 1) and date(`start_date`) <= '2025-07-15' and date(`end_date`) >= '2025-07-15'
        Bindings
        • 0: feature_deal
        • 1: 1
        • 2: 2025-07-15
        • 3: 2025-07-15
        Backtrace
        • app/Utils/category-manager.php:89
        • view::layouts.front-end.partials._header:238
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • category-manager.php#91maindb730μsselect * from `products` where 0 = 1
        Backtrace
        • app/Utils/category-manager.php:91
        • view::layouts.front-end.partials._header:238
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • _footer.blade.php#130maindb920μsselect * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-07-15' and date(`end_date`) >= '2025-07-15' limit 1
        Bindings
        • 0: 1
        • 1: flash_deal
        • 2: 2025-07-15
        • 3: 2025-07-15
        Backtrace
        • view::layouts.front-end.partials._footer:130
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/ViewEngineDecorator.php:47
      App\Models\Category
      14Category.php#?
      App\Models\Product
      13Product.php#?
      App\Models\Brand
      2Brand.php#?
          local
          en
          direction
          ltr
          system_default_currency_info
          App\Models\Currency {#737 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyTy...
          currency_code
          IQD
          currency_symbol
          IQD
          currency_exchange_rate
          1
          usd
          1
          _token
          idyDhmOKvXk2KzriIslE52LHYewMJh9ns0KwHGN6
          guest_id
          211056
          ClearShow all
          Date ↕MethodURLData
          #12025-07-15 10:41:16GET/products?offer_type=featured_deal303729