Category Products (WOMEN'S WEAR)
0 Items found
No product found
Request history8.1.24PHP Version401msRequest Duration9MBMemory UsageGET productsRoute
    • Booting (292ms)time
    • Application (109ms)time
    • 1 x Booting (72.73%)
      292ms
      1 x Application (27.26%)
      109ms
      13 templates were rendered
      • web-views.products.viewview.blade.php#?blade
      • web-views.products._ajax-products_ajax-products.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 products
      middleware
      web, maintenance_mode, guestCheck
      controller
      App\Http\Controllers\Web\ProductListController@products
      namespace
      App\Http\Controllers\Web
      prefix
      where
      as
      products
      file
      app/Http/Controllers/Web/ProductListController.php:41-51
      22 statements were executed (13 duplicates)Show only duplicates20.1ms
      • insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('3.137.187.238', '2025-04-09 01:21:57', '2025-04-09 01:21:57')
        3.56msclothiiGuestMiddleware.php#26
        Bindings
          Backtrace
          • select * from `categories` where `categories`.`id` = 34 limit 1
            1.72msclothiiProductListController.php#60
            Bindings
              Backtrace
              • select * from `translations` where `translations`.`translationable_id` in (34) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
                910μsclothiiProductListController.php#60
                Bindings
                  Backtrace
                  • select `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')))
                    2.62msclothiiproduct-manager.php#2805
                    Bindings
                      Backtrace
                      • select `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
                        500μsclothiiproduct-manager.php#2814
                        Bindings
                          Backtrace
                          • select `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`
                            470μsclothiiproduct-manager.php#2820
                            Bindings
                              Backtrace
                              • select `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
                                350μsclothiiproduct-manager.php#2828
                                Bindings
                                  Backtrace
                                  • select * from `categories` where `id` in ('34')
                                    260μsclothiiproduct-manager.php#2890
                                    Bindings
                                      Backtrace
                                      • select * from `translations` where `translations`.`translationable_id` in (34) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
                                        290μsclothiiproduct-manager.php#2890
                                        Bindings
                                          Backtrace
                                          • select * from `categories` where `id` in (null)
                                            420μsclothiiproduct-manager.php#2891
                                            Bindings
                                              Backtrace
                                              • select * from `categories` where `id` in (null)
                                                480μsclothiiproduct-manager.php#2892
                                                Bindings
                                                  Backtrace
                                                  • select `products`.*, (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 `category_id` in (34) order by `order_details_count` desc
                                                    2.79msclothiiproduct-manager.php#1376
                                                    Bindings
                                                      Backtrace
                                                      • select * from `categories` where `id` in ('34')
                                                        230μsclothiiproduct-manager.php#3260
                                                        Bindings
                                                          Backtrace
                                                          • select * from `translations` where `translations`.`translationable_id` in (34) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
                                                            280μsclothiiproduct-manager.php#3260
                                                            Bindings
                                                              Backtrace
                                                              • select * from `categories` where `id` in (null)
                                                                310μsclothiiproduct-manager.php#3261
                                                                Bindings
                                                                  Backtrace
                                                                  • select * from `categories` where `id` in (null)
                                                                    190μsclothiiproduct-manager.php#3262
                                                                    Bindings
                                                                      Backtrace
                                                                      • select `products`.*, (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 `category_id` in (34) order by `order_details_count` desc
                                                                        1.09msclothiiproduct-manager.php#1376
                                                                        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` = 4048 and `is_guest` = 1) group by `cart_group_id`
                                                                            2.15msclothiicart-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
                                                                                330μsclothiicart-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` = 4048 and `is_guest` = 1) group by `cart_group_id`
                                                                                    360μsclothiicart-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)
                                                                                        260μsclothiicart-manager.php#65
                                                                                        Bindings
                                                                                          Backtrace
                                                                                          • select * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-04-09' and date(`end_date`) >= '2025-04-09' limit 1
                                                                                            530μsclothii_footer.blade.php#51
                                                                                            Bindings
                                                                                              Backtrace
                                                                                              App\Models\Category
                                                                                              3Category.php#?
                                                                                                  system_default_currency_info
                                                                                                  App\Models\Currency {#1750 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
                                                                                                  currency_code
                                                                                                  INR
                                                                                                  currency_symbol
                                                                                                  currency_exchange_rate
                                                                                                  60
                                                                                                  usd
                                                                                                  1
                                                                                                  _token
                                                                                                  LRiOWW50nCcIWVR6IPJlUTFoccb0lKdyxKc7NcmG
                                                                                                  guest_id
                                                                                                  4048
                                                                                                  local
                                                                                                  en
                                                                                                  direction
                                                                                                  ltr
                                                                                                  _previous
                                                                                                  array:1 [ "url" => "https://clothii.com/products?category_id=34&data_from=category&page=1" ]
                                                                                                  _flash
                                                                                                  array:2 [ "old" => [] "new" => [] ]
                                                                                                  path_info
                                                                                                  /products
                                                                                                  status_code
                                                                                                  200
                                                                                                  
                                                                                                  status_text
                                                                                                  OK
                                                                                                  format
                                                                                                  html
                                                                                                  content_type
                                                                                                  text/html; charset=UTF-8
                                                                                                  request_query
                                                                                                  0 of 0
                                                                                                  array:3 [ "category_id" => "34" "data_from" => "category" "page" => "1" ]
                                                                                                  request_request
                                                                                                  []
                                                                                                  
                                                                                                  request_headers
                                                                                                  0 of 0
                                                                                                  array:15 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "clothii.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 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 09 Apr 2025 01:21:57 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjEwc3ZFczF2NGx0aHp0MGdFWmg1MHc9PSIsInZhbHVlIjoiTEVyYlJ4VTJ4SDVpVE95cE9Hc0ZncjFqV3VhSWtEekZhZmtZbVhQYWdZRGRqN3RxN05sNHdJbVo1Rmx0cStEbEZRNFU3cGdxcm5wWVFxbkg1SE9USzAwek91ZngyNnhBRkJsLzUrY2djM0NwMlo4bUdFRFBaMVZ5UnM0OUFoS2MiLCJtYWMiOiJlMjdhNTIzZDhjYWMzY2EzMzg5ZTAyNDY2MTU1NGJmZmFlODRjOTgzMGNjYTNhMzkzMDkwZDdkZDFlZGI3NTU1IiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 02:21:57 GMT; Max-Age=3600; path=/XSRF-TOKEN=eyJpdiI6IjEwc3ZFczF2NGx0aHp0MGdFWmg1MHc9PSIsInZhbHVlIjoiTEVyYlJ4VTJ4SDVpVE95cE9Hc0ZncjFqV3VhSWtEekZhZmtZbVhQYWdZRGRqN3RxN05sNHdJbVo1Rmx0cStEbEZRNFU3c" 1 => "6valley1730876758_session=eyJpdiI6InBwUHE5Vzd6U2tSSWFHQTRiZG13MWc9PSIsInZhbHVlIjoiY0xhYWhreisrR0dSYTdoWVdRUC90T3hXQndZRU1XTTB2b2szOHNuRi83TmFTRlg3ajgyTUJlUWFlOWVDdUJMbE5kWjU3THVwdWV0V1V2cmtDV2RiYzByMmpGT2ZaYi9UWFBGYmVBSXBHM3BRWlZycUIwdTdLM2pYdmJyV0w0eHYiLCJtYWMiOiJiZGU2MGYzYWJjN2VkODE0MDZmY2ZiOGFmZDRiMmMzOTNiOTQ0Yjg5MGIwNTFhNDQwYTQ5MmVkYzIxNWY0ZGUwIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 02:21:57 GMT; Max-Age=3600; path=/; httponly6valley1730876758_session=eyJpdiI6InBwUHE5Vzd6U2tSSWFHQTRiZG13MWc9PSIsInZhbHVlIjoiY0xhYWhreisrR0dSYTdoWVdRUC90T3hXQndZRU1XTTB2b2szOHNuRi83TmFTRlg3ajgyTUJlUWFlOW" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjEwc3ZFczF2NGx0aHp0MGdFWmg1MHc9PSIsInZhbHVlIjoiTEVyYlJ4VTJ4SDVpVE95cE9Hc0ZncjFqV3VhSWtEekZhZmtZbVhQYWdZRGRqN3RxN05sNHdJbVo1Rmx0cStEbEZRNFU3cGdxcm5wWVFxbkg1SE9USzAwek91ZngyNnhBRkJsLzUrY2djM0NwMlo4bUdFRFBaMVZ5UnM0OUFoS2MiLCJtYWMiOiJlMjdhNTIzZDhjYWMzY2EzMzg5ZTAyNDY2MTU1NGJmZmFlODRjOTgzMGNjYTNhMzkzMDkwZDdkZDFlZGI3NTU1IiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 02:21:57 GMT; path=/XSRF-TOKEN=eyJpdiI6IjEwc3ZFczF2NGx0aHp0MGdFWmg1MHc9PSIsInZhbHVlIjoiTEVyYlJ4VTJ4SDVpVE95cE9Hc0ZncjFqV3VhSWtEekZhZmtZbVhQYWdZRGRqN3RxN05sNHdJbVo1Rmx0cStEbEZRNFU3c" 1 => "6valley1730876758_session=eyJpdiI6InBwUHE5Vzd6U2tSSWFHQTRiZG13MWc9PSIsInZhbHVlIjoiY0xhYWhreisrR0dSYTdoWVdRUC90T3hXQndZRU1XTTB2b2szOHNuRi83TmFTRlg3ajgyTUJlUWFlOWVDdUJMbE5kWjU3THVwdWV0V1V2cmtDV2RiYzByMmpGT2ZaYi9UWFBGYmVBSXBHM3BRWlZycUIwdTdLM2pYdmJyV0w0eHYiLCJtYWMiOiJiZGU2MGYzYWJjN2VkODE0MDZmY2ZiOGFmZDRiMmMzOTNiOTQ0Yjg5MGIwNTFhNDQwYTQ5MmVkYzIxNWY0ZGUwIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 02:21:57 GMT; path=/; httponly6valley1730876758_session=eyJpdiI6InBwUHE5Vzd6U2tSSWFHQTRiZG13MWc9PSIsInZhbHVlIjoiY0xhYWhreisrR0dSYTdoWVdRUC90T3hXQndZRU1XTTB2b2szOHNuRi83TmFTRlg3ajgyTUJlUWFlOW" ] ]
                                                                                                  session_attributes
                                                                                                  0 of 0
                                                                                                  array:11 [ "system_default_currency_info" => App\Models\Currency {#1750 #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" "usd" => 1 "_token" => "LRiOWW50nCcIWVR6IPJlUTFoccb0lKdyxKc7NcmG" "guest_id" => 4048 "local" => "en" "direction" => "ltr" "_previous" => array:1 [ "url" => "https://clothii.com/products?category_id=34&data_from=category&page=1" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
                                                                                                  ClearShow all
                                                                                                  Date ↕MethodURLData
                                                                                                  #12025-04-09 01:21:57GET/products?category_id=34&data_from=category&page=113223