Category Products (Kurta Pajama)
1 Items found
₹5.00
SettingsRequest history135msRequest Duration7MBMemory Usage10.x
Laravel Version
10.48.29
PHP Version
8.2.28
Environment
live
Debug Mode
Enabled
URL
pappushahwholesale.com
Timezone
Asia/Dhaka
Locale
en
GET products
status
200 OK
full_url
https://pappushahwholesale.com/products?data_from=category&id=11&page=1
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://pappushahwholesale.com/products?data_from=category&id=11&page=1
    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:34-44
    middleware
    web, maintenance_mode, guestCheck
    duration
    138ms
    peak_memory
    10MB
    response
    text/html; charset=UTF-8
    request_format
    html
    request_query
    0 of 0
    array:3 [ "data_from" => "category" "id" => "11" "page" => "1" ]
    request_request
    []
    
    request_headers
    0 of 0
    array:22 [ "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 => "br" ] "host" => array:1 [ 0 => "pappushahwholesale.com" ] "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 => "216.73.216.35" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "x-real-ip" => array:1 [ 0 => "216.73.216.35" ] "x-real-port" => array:1 [ 0 => "23409" ] "x-forwarded-port" => array:1 [ 0 => "443" ] "x-port" => array:1 [ 0 => "443" ] "x-lscache" => 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"" ] "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" ] ]
    request_cookies
    []
    
    response_headers
    0 of 0
    array:3 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sun, 13 Jul 2025 03:23:22 GMT" ] ]
    session_attributes
    0 of 0
    array:19 [ "storage_connection_type" => "local" "company_web_logo" => array:3 [ "key" => "2024-11-05-6729d93951b54.webp" "path" => null "status" => 404 ] "decimal_point_settings" => 2 "product_brand" => 1 "digital_product" => 0 "business_mode" => "single" "currency_model" => "single_currency" "language" => array:1 [ 0 => array:6 [ "id" => "1" "name" => "english" "direction" => "ltr" "code" => "en" "status" => 1 "default" => true ] ] "local" => "en" "direction" => "ltr" "system_default_currency" => 3 "system_default_currency_info" => App\Models\Currency {#1813 #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" => 3 "name" => "Indian Rupi" "symbol" => "" "code" => "INR" "exchange_rate" => "60" "status" => 1 "created_at" => "2020-10-15 17:23:04" "updated_at" => "2021-06-04 18:26:38" ] #original: array:8 [ "id" => 3 "name" => "Indian Rupi" "symbol" => "" "code" => "INR" "exchange_rate" => "60" "status" => 1 "created_at" => "2020-10-15 17:23:04" "updated_at" => "2021-06-04 18:26:38" ] #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" => "INR" "currency_symbol" => "" "currency_exchange_rate" => "60" "_token" => "KNlNvOOOTBgIvJNjCMmMvujqatuNjWJGvQgYk45P" "guest_id" => 38498 "currency_symbol_position" => "left" "company_email" => "pappushahwholesale@gmail.com" ]
    • Booting (42.15ms)time
    • Application (92.59ms)time
    • Routing (4.81ms)
    • Preparing Response (55.1ms)
    • View: web-views.products.viewviews
    • View: web-views.products._ajax-productsviews
    • View: web-views.partials._filter-single-productviews
    • View: pagination::bootstrap-4views
    • View: layouts.front-end.appviews
    • View: web-views.partials._robotsMetaContentDataviews
    • View: layouts.front-end.partials._modalsviews
    • View: layouts.front-end.partials._quick-view-modalviews
    • View: layouts.front-end.partials.modal._buy-nowviews
    • View: layouts.front-end.partials._headerviews
    • View: layouts.front-end.partials._cartviews
    • View: layouts.front-end.partials._alert-messageviews
    • View: layouts.front-end.partials._footerviews
    • View: layouts.front-end.partials.modal._dynamic-modalsviews
    • 1 x Application (68.71%)
      92.59ms
      1 x Preparing Response (40.89%)
      55.10ms
      1 x Booting (31.28%)
      42.15ms
      1 x Routing (3.57%)
      4.81ms
      14 x View (0%)
      0μs
      14 templates were rendered
      • web-views.products.viewview.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
      • pagination::bootstrap-4bootstrap-4.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
      59 statements were executed (28 duplicates)Show only duplicates15.88ms
      • helpers.php#167u542788397_6val190μsselect * from `business_settings` where (`type` = 'maintenance_mode') limit 1
        Bindings
        • 0: maintenance_mode
        Backtrace
        • app/Utils/helpers.php:167
        • middleware::maintenance_mode:20
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • middleware::api_lang:22
      • GuestMiddleware.php#24u542788397_6val280μsinsert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('216.73.216.35', '2025-07-13 08:53:22', '2025-07-13 08:53:22')
        Bindings
        • 0: 216.73.216.35
        • 1: 2025-07-13 08:53:22
        • 2: 2025-07-13 08:53:22
        Backtrace
        • middleware::guestCheck:24
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • middleware::maintenance_mode:27
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • category-manager.php#82u542788397_6val590μsselect `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id` and (`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) 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 ('physical')) as `product_count` from `categories` where `position` = 0
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        • 8: 0
        Backtrace
        • app/Utils/category-manager.php:82
        • app/Http/Controllers/Web/ProductListController.php:48
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • category-manager.php#82u542788397_6val940μsselect `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (1, 2) and (`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) 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 ('physical')
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        Backtrace
        • app/Utils/category-manager.php:82
        • app/Http/Controllers/Web/ProductListController.php:48
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • category-manager.php#82u542788397_6val220μsselect * from `translations` where `translations`.`translationable_id` in (15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 28, 29, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 110) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
        Bindings
        • 0: App\Models\Product
        • 1: en
        Backtrace
        • app/Utils/category-manager.php:82
        • app/Http/Controllers/Web/ProductListController.php:48
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • category-manager.php#82u542788397_6val160μsselect * from `reviews` where `reviews`.`product_id` in (15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 28, 29, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 110) and `delivery_man_id` is null and `status` = 1
        Bindings
        • 0: 1
        Backtrace
        • app/Utils/category-manager.php:82
        • app/Http/Controllers/Web/ProductListController.php:48
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • category-manager.php#82u542788397_6val520μsselect `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_category_id`) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (1, 2) and `position` = 1 order by `priority` asc
        Bindings
        • 0: 1
        Backtrace
        • app/Utils/category-manager.php:82
        • app/Http/Controllers/Web/ProductListController.php:48
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • category-manager.php#82u542788397_6val180μsselect `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_sub_category_id`) as `sub_sub_category_product_count` from `categories` where `categories`.`parent_id` in (3, 7, 8, 9, 10, 11, 12, 13, 14) and `position` = 2 order by `priority` asc
        Bindings
        • 0: 2
        Backtrace
        • app/Utils/category-manager.php:82
        • app/Http/Controllers/Web/ProductListController.php:48
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • category-manager.php#82u542788397_6val160μsselect * from `translations` where `translations`.`translationable_id` in (3, 7, 8, 9, 10, 11, 12, 13, 14) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
        Bindings
        • 0: App\Models\Category
        • 1: en
        Backtrace
        • app/Utils/category-manager.php:82
        • app/Http/Controllers/Web/ProductListController.php:48
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • category-manager.php#82u542788397_6val140μsselect * from `translations` where `translations`.`translationable_id` in (1, 2) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
        Bindings
        • 0: App\Models\Category
        • 1: en
        Backtrace
        • app/Utils/category-manager.php:82
        • app/Http/Controllers/Web/ProductListController.php:48
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • settings.php#16u542788397_6val150μsselect * from `business_settings` where (`type` = 'category_list_priority') limit 1
        Bindings
        • 0: category_list_priority
        Backtrace
        • app/Utils/settings.php:16
        • app/Utils/category-manager.php:82
        • app/Http/Controllers/Web/ProductListController.php:48
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • settings.php#16u542788397_6val140μsselect * from `business_settings` where (`type` = 'brand_list_priority') limit 1
        Bindings
        • 0: brand_list_priority
        Backtrace
        • app/Utils/settings.php:16
        • app/Utils/brand-manager.php:33
        • app/Http/Controllers/Web/ProductListController.php:49
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • brand-manager.php#58u542788397_6val750μsselect `brands`.*, (select count(*) from `products` where `brands`.`id` = `products`.`brand_id` and (`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) 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 ('physical')) as `brand_products_count` from `brands` where `status` = 1 order by `created_at` desc
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        • 8: 1
        Backtrace
        • app/Utils/brand-manager.php:58
        • app/Utils/brand-manager.php:33
        • app/Http/Controllers/Web/ProductListController.php:49
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • brand-manager.php#58u542788397_6val160μsselect * from `translations` where `translations`.`translationable_id` in (2, 3, 4, 6, 7) and `translations`.`translationable_type` = 'App\\Models\\Brand' and `locale` = 'en'
        Bindings
        • 0: App\Models\Brand
        • 1: en
        Backtrace
        • app/Utils/brand-manager.php:58
        • app/Utils/brand-manager.php:33
        • app/Http/Controllers/Web/ProductListController.php:49
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • ProductListController.php#63u542788397_6val130μsselect * from `categories` where `categories`.`id` = 11 limit 1
        Bindings
        • 0: 11
        Backtrace
        • app/Http/Controllers/Web/ProductListController.php:63
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • ProductListController.php#63u542788397_6val130μsselect * from `translations` where `translations`.`translationable_id` in (11) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
        Bindings
        • 0: App\Models\Category
        • 1: en
        Backtrace
        • app/Http/Controllers/Web/ProductListController.php:63
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • settings.php#16u542788397_6val140μsselect * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
        Bindings
        • 0: category_wise_product_list_priority
        Backtrace
        • app/Utils/settings.php:16
        • app/Http/Controllers/Web/ProductListController.php:111
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • product-manager.php#1147u542788397_6val880μsselect `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (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 (`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) 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 ('physical') and (`category_id` = '11') or (`sub_category_id` = '11') or (`sub_sub_category_id` = '11') order by `order_details_count` desc
        Bindings
        • 0: 1
        • 1: 1
        • 2: 1
        • 3: admin
        • 4: 1
        • 5: 1
        • 6: 1
        • 7: approved
        • 8: admin
        • 9: 1
        • 10: physical
        • 11: 11
        • 12: 11
        • 13: 11
        Backtrace
        • app/Utils/product-manager.php:1147
        • app/Http/Controllers/Web/ProductListController.php:111
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • product-manager.php#1147u542788397_6val150μsselect * from `reviews` where `reviews`.`product_id` in (110) and `delivery_man_id` is null and `status` = 1
        Bindings
        • 0: 1
        Backtrace
        • app/Utils/product-manager.php:1147
        • app/Http/Controllers/Web/ProductListController.php:111
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • product-manager.php#1147u542788397_6val130μsselect avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (110) and `status` = 1 group by `product_id`
        Bindings
        • 0: 1
        Backtrace
        • app/Utils/product-manager.php:1147
        • app/Http/Controllers/Web/ProductListController.php:111
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • product-manager.php#1147u542788397_6val130μsselect * from `sellers` where `sellers`.`id` in (1)
        Backtrace
        • app/Utils/product-manager.php:1147
        • app/Http/Controllers/Web/ProductListController.php:111
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • product-manager.php#1147u542788397_6val120μsselect * from `wishlists` where `wishlists`.`product_id` in (110) and `customer_id` = 0
        Bindings
        • 0: 0
        Backtrace
        • app/Utils/product-manager.php:1147
        • app/Http/Controllers/Web/ProductListController.php:111
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • product-manager.php#1147u542788397_6val130μsselect * from `product_compares` where `product_compares`.`product_id` in (110) and `user_id` = 0
        Bindings
        • 0: 0
        Backtrace
        • app/Utils/product-manager.php:1147
        • app/Http/Controllers/Web/ProductListController.php:111
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • product-manager.php#1147u542788397_6val160μsselect * from `translations` where `translations`.`translationable_id` in (110) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
        Bindings
        • 0: App\Models\Product
        • 1: en
        Backtrace
        • app/Utils/product-manager.php:1147
        • app/Http/Controllers/Web/ProductListController.php:111
        • app/Http/Controllers/Web/ProductListController.php:39
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • settings.php#16u542788397_6val190μsselect * from `business_settings` where (`type` = 'currency_symbol_position') limit 1
        Bindings
        • 0: currency_symbol_position
        Backtrace
        • app/Utils/settings.php:16
        • 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/laravel/framework/src/Illuminate/View/View.php:207
      • settings.php#16u542788397_6val180μsselect * from `business_settings` where (`type` = 'google_search_console_code') limit 1
        Bindings
        • 0: google_search_console_code
        Backtrace
        • app/Utils/settings.php:16
        • 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/laravel/framework/src/Illuminate/View/View.php:207
      • settings.php#16u542788397_6val140μsselect * from `business_settings` where (`type` = 'bing_webmaster_code') limit 1
        Bindings
        • 0: bing_webmaster_code
        Backtrace
        • app/Utils/settings.php:16
        • 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/laravel/framework/src/Illuminate/View/View.php:207
      • settings.php#16u542788397_6val140μsselect * from `business_settings` where (`type` = 'baidu_webmaster_code') limit 1
        Bindings
        • 0: baidu_webmaster_code
        Backtrace
        • app/Utils/settings.php:16
        • 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/laravel/framework/src/Illuminate/View/View.php:207
      • settings.php#16u542788397_6val220μsselect * from `business_settings` where (`type` = 'yandex_webmaster_code') limit 1
        Bindings
        • 0: yandex_webmaster_code
        Backtrace
        • app/Utils/settings.php:16
        • 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/laravel/framework/src/Illuminate/View/View.php:207
      • settings.php#16u542788397_6val310μsselect * from `business_settings` where (`type` = 'google_tag_manager_id') limit 1
        Bindings
        • 0: google_tag_manager_id
        Backtrace
        • app/Utils/settings.php:16
        • 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/laravel/framework/src/Illuminate/View/View.php:207
      • settings.php#16u542788397_6val180μsselect * from `business_settings` where (`type` = 'pixel_analytics') limit 1
        Bindings
        • 0: pixel_analytics
        Backtrace
        • app/Utils/settings.php:16
        • 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/laravel/framework/src/Illuminate/View/View.php:207
      • settings.php#16u542788397_6val200μsselect * from `business_settings` where (`type` = 'announcement') limit 1
        Bindings
        • 0: announcement
        Backtrace
        • app/Utils/settings.php:16
        • 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/laravel/framework/src/Illuminate/View/View.php:207
      • cart-manager.php#92u542788397_6val320μsselect `cart_group_id` from `carts` where (`customer_id` = 38498 and `is_guest` = 1) group by `cart_group_id`
        Bindings
        • 0: 38498
        • 1: 1
        Backtrace
        • app/Utils/cart-manager.php:92
        • app/Utils/cart-manager.php:51
        • vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
        • app/Utils/cart-manager.php:50
        • view::layouts.front-end.partials._cart:21
      • cart-manager.php#59u542788397_6val120μsselect * from `carts` where 0 = 1
        Backtrace
        • app/Utils/cart-manager.php:59
        • view::layouts.front-end.partials._cart:21
        • 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
      • cart-manager.php#92u542788397_6val130μsselect `cart_group_id` from `carts` where (`customer_id` = 38498 and `is_guest` = 1) group by `cart_group_id`
        Bindings
        • 0: 38498
        • 1: 1
        Backtrace
        • app/Utils/cart-manager.php:92
        • app/Utils/cart-manager.php:51
        • vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
        • app/Utils/cart-manager.php:50
        • view::layouts.front-end.partials._cart:31
      • cart-manager.php#59u542788397_6val110μsselect * from `carts` where 0 = 1
        Backtrace
        • app/Utils/cart-manager.php:59
        • view::layouts.front-end.partials._cart:31
        • 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#82u542788397_6val810μsselect `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id` and (`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) 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 ('physical')) as `product_count` from `categories` where `position` = 0
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        • 8: 0
        Backtrace
        • app/Utils/category-manager.php:82
        • view::layouts.front-end.partials._header:235
        • 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#82u542788397_6val1.01msselect `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (1, 2) and (`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) 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 ('physical')
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        Backtrace
        • app/Utils/category-manager.php:82
        • view::layouts.front-end.partials._header:235
        • 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#82u542788397_6val240μsselect * from `translations` where `translations`.`translationable_id` in (15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 28, 29, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 110) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
        Bindings
        • 0: App\Models\Product
        • 1: en
        Backtrace
        • app/Utils/category-manager.php:82
        • view::layouts.front-end.partials._header:235
        • 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#82u542788397_6val190μsselect * from `reviews` where `reviews`.`product_id` in (15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 28, 29, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 110) and `delivery_man_id` is null and `status` = 1
        Bindings
        • 0: 1
        Backtrace
        • app/Utils/category-manager.php:82
        • view::layouts.front-end.partials._header:235
        • 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#82u542788397_6val680μsselect `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_category_id`) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (1, 2) and `position` = 1 order by `priority` asc
        Bindings
        • 0: 1
        Backtrace
        • app/Utils/category-manager.php:82
        • view::layouts.front-end.partials._header:235
        • 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#82u542788397_6val200μsselect `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_sub_category_id`) as `sub_sub_category_product_count` from `categories` where `categories`.`parent_id` in (3, 7, 8, 9, 10, 11, 12, 13, 14) and `position` = 2 order by `priority` asc
        Bindings
        • 0: 2
        Backtrace
        • app/Utils/category-manager.php:82
        • view::layouts.front-end.partials._header:235
        • 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#82u542788397_6val160μsselect * from `translations` where `translations`.`translationable_id` in (3, 7, 8, 9, 10, 11, 12, 13, 14) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
        Bindings
        • 0: App\Models\Category
        • 1: en
        Backtrace
        • app/Utils/category-manager.php:82
        • view::layouts.front-end.partials._header:235
        • 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#82u542788397_6val160μsselect * from `translations` where `translations`.`translationable_id` in (1, 2) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
        Bindings
        • 0: App\Models\Category
        • 1: en
        Backtrace
        • app/Utils/category-manager.php:82
        • view::layouts.front-end.partials._header:235
        • 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
      • settings.php#16u542788397_6val180μsselect * from `business_settings` where (`type` = 'category_list_priority') limit 1
        Bindings
        • 0: category_list_priority
        Backtrace
        • app/Utils/settings.php:16
        • app/Utils/category-manager.php:82
        • view::layouts.front-end.partials._header:235
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • settings.php#16u542788397_6val170μsselect * from `business_settings` where (`type` = 'brand_list_priority') limit 1
        Bindings
        • 0: brand_list_priority
        Backtrace
        • app/Utils/settings.php:16
        • app/Utils/brand-manager.php:33
        • view::layouts.front-end.partials._header:336
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • brand-manager.php#58u542788397_6val1.12msselect `brands`.*, (select count(*) from `products` where `brands`.`id` = `products`.`brand_id` and (`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) 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 ('physical')) as `brand_products_count` from `brands` where `status` = 1 order by `created_at` desc
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        • 8: 1
        Backtrace
        • app/Utils/brand-manager.php:58
        • app/Utils/brand-manager.php:33
        • view::layouts.front-end.partials._header:336
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • brand-manager.php#58u542788397_6val190μsselect * from `translations` where `translations`.`translationable_id` in (2, 3, 4, 6, 7) and `translations`.`translationable_type` = 'App\\Models\\Brand' and `locale` = 'en'
        Bindings
        • 0: App\Models\Brand
        • 1: en
        Backtrace
        • app/Utils/brand-manager.php:58
        • app/Utils/brand-manager.php:33
        • view::layouts.front-end.partials._header:336
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • _header.blade.php#366u542788397_6val360μsselect count(*) as aggregate from `products` where (`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) 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 ('physical') and `discount` != 0
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        • 8: 0
        Backtrace
        • view::layouts.front-end.partials._header:366
        • 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/laravel/framework/src/Illuminate/View/View.php:207
      • settings.php#16u542788397_6val220μsselect * from `business_settings` where (`type` = 'loader_gif') limit 1
        Bindings
        • 0: loader_gif
        Backtrace
        • app/Utils/settings.php:16
        • 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/laravel/framework/src/Illuminate/View/View.php:207
      • settings.php#16u542788397_6val180μsselect * from `business_settings` where (`type` = 'country_code') limit 1
        Bindings
        • 0: country_code
        Backtrace
        • app/Utils/settings.php:16
        • 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/laravel/framework/src/Illuminate/View/View.php:207
      • _footer.blade.php#109u542788397_6val170μsselect * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-07-13' and date(`end_date`) >= '2025-07-13' limit 1
        Bindings
        • 0: 1
        • 1: flash_deal
        • 2: 2025-07-13
        • 3: 2025-07-13
        Backtrace
        • view::layouts.front-end.partials._footer:109
        • 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/laravel/framework/src/Illuminate/View/View.php:207
      • settings.php#16u542788397_6val140μsselect * from `business_settings` where (`type` = 'refund-policy') limit 1
        Bindings
        • 0: refund-policy
        Backtrace
        • app/Utils/settings.php:16
        • 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/laravel/framework/src/Illuminate/View/View.php:207
      • settings.php#16u542788397_6val140μsselect * from `business_settings` where (`type` = 'return-policy') limit 1
        Bindings
        • 0: return-policy
        Backtrace
        • app/Utils/settings.php:16
        • 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/laravel/framework/src/Illuminate/View/View.php:207
      • settings.php#16u542788397_6val130μsselect * from `business_settings` where (`type` = 'cancellation-policy') limit 1
        Bindings
        • 0: cancellation-policy
        Backtrace
        • app/Utils/settings.php:16
        • 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/laravel/framework/src/Illuminate/View/View.php:207
      • settings.php#16u542788397_6val120μsselect * from `business_settings` where (`type` = 'company_phone') limit 1
        Bindings
        • 0: company_phone
        Backtrace
        • app/Utils/settings.php:16
        • 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/laravel/framework/src/Illuminate/View/View.php:207
      • settings.php#16u542788397_6val110μsselect * from `business_settings` where (`type` = 'company_email') limit 1
        Bindings
        • 0: company_email
        Backtrace
        • app/Utils/settings.php:16
        • 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/laravel/framework/src/Illuminate/View/View.php:207
      • settings.php#16u542788397_6val120μsselect * from `business_settings` where (`type` = 'shop_address') limit 1
        Bindings
        • 0: shop_address
        Backtrace
        • app/Utils/settings.php:16
        • 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/laravel/framework/src/Illuminate/View/View.php:207
      • settings.php#16u542788397_6val160μsselect * from `business_settings` where (`type` = 'whatsapp') limit 1
        Bindings
        • 0: whatsapp
        Backtrace
        • app/Utils/settings.php:16
        • 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/laravel/framework/src/Illuminate/View/View.php:207
      App\Models\Product
      77Product.php#?
      App\Models\Category
      23Category.php#?
      App\Models\BusinessSetting
      15BusinessSetting.php#?
      App\Models\Brand
      10Brand.php#?
          ClearShow all
          Date ↕MethodURLData
          #12025-07-13 08:53:22GET/products?data_from=category&id=11&page=11459125