Home > Mobiles >
Category Products (Headphones)
0 Items found
No product found
Top
8.3.14PHP Version118msRequest Duration7MBMemory UsageGET productsRoute
    • Booting (38.79ms)time
    • Application (78.97ms)time
    • 1 x Application (67.06%)
      78.97ms
      1 x Booting (32.94%)
      38.79ms
      9 templates were rendered
      • web-views.products.viewview.blade.phpblade
      • web-views.products._ajax-products_ajax-products.blade.phpblade
      • layouts.front-end.appapp.blade.phpblade
      • layouts.front-end.partials._modals_modals.blade.phpblade
      • layouts.front-end.partials._quick-view-modal_quick-view-modal.blade.phpblade
      • layouts.front-end.partials._header_header.blade.phpblade
      • layouts.front-end.partials._cart_cart.blade.phpblade
      • layouts.front-end.partials._footer_footer.blade.phpblade
      • layouts.front-end.partials.modal._dynamic-modals_dynamic-modals.blade.phpblade
      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:24-34
      44 statements were executed, 16 of which were duplicated, 28 unique. Show only duplicated12.05ms
      • select * from `business_settings` where (`type` = 'maintenance_mode') limit 1
        250μshelpers.php#167cityexpresskart
        Metadata
        Bindings
        • 0. maintenance_mode
        Backtrace
        • 16. app/Utils/helpers.php:167
        • 17. middleware::maintenance_mode:20
        • 18. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • 19. middleware::api_lang:22
        • 20. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • insert into `guest_users` (`ip_address`, `created_at`) values ('108.162.216.253', '2025-01-04 22:52:35')
        330μsGuestMiddleware.php#23cityexpresskart
        Metadata
        Bindings
        • 0. 108.162.216.253
        • 1. 2025-01-04 22:52:35
        Backtrace
        • 16. middleware::guestCheck:23
        • 17. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • 18. middleware::maintenance_mode:27
        • 19. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • 20. middleware::api_lang:22
      • select * from `products` where (exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) or (`brand_id` is null and `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')
        1.76msProductListController.php#42cityexpresskart
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        • 2. 1
        • 3. 1
        • 4. approved
        • 5. admin
        • 6. 1
        • 7. digital
        • 8. physical
        Backtrace
        • 15. app/Http/Controllers/Web/ProductListController.php:42
        • 16. app/Http/Controllers/Web/ProductListController.php:29
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select * from `reviews` where `reviews`.`product_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50) and `delivery_man_id` is null and `status` = 1
        270μsProductListController.php#42cityexpresskart
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 20. app/Http/Controllers/Web/ProductListController.php:42
        • 21. app/Http/Controllers/Web/ProductListController.php:29
        • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
        300μsProductListController.php#42cityexpresskart
        Metadata
        Bindings
        • 0. App\Models\Product
        • 1. en
        Backtrace
        • 20. app/Http/Controllers/Web/ProductListController.php:42
        • 21. app/Http/Controllers/Web/ProductListController.php:29
        • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select count(*) as aggregate from `products` where (exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) or (`brand_id` is null and `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
        230μsProductListController.php#174cityexpresskart
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        • 2. 1
        • 3. 1
        • 4. approved
        • 5. admin
        • 6. 1
        • 7. digital
        • 8. physical
        Backtrace
        • 16. app/Http/Controllers/Web/ProductListController.php:174
        • 17. app/Http/Controllers/Web/ProductListController.php:29
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select * from `categories` where `categories`.`id` = 4 limit 1
        300μsProductListController.php#184cityexpresskart
        Metadata
        Bindings
        • 0. 4
        Backtrace
        • 20. app/Http/Controllers/Web/ProductListController.php:184
        • 21. app/Http/Controllers/Web/ProductListController.php:29
        • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select * from `translations` where `translations`.`translationable_id` in (4) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
        220μsProductListController.php#184cityexpresskart
        Metadata
        Bindings
        • 0. App\Models\Category
        • 1. en
        Backtrace
        • 25. app/Http/Controllers/Web/ProductListController.php:184
        • 26. app/Http/Controllers/Web/ProductListController.php:29
        • 27. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 28. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select `id`, `name` from `categories`
        200μsview.blade.php#75cityexpresskart
        Metadata
        Backtrace
        • 13. view::web-views.products.view:75
        • 15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 17. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 18. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select `brands`.*, (select count(*) from `products` where `brands`.`id` = `products`.`brand_id` and (exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) or (`brand_id` is null and `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
        670μsbrand-manager.php#31cityexpresskart
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        • 2. 1
        • 3. 1
        • 4. approved
        • 5. admin
        • 6. 1
        • 7. digital
        • 8. physical
        • 9. 1
        Backtrace
        • 15. app/Utils/brand-manager.php:31
        • 16. view::web-views.products.view:248
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'
        230μsbrand-manager.php#31cityexpresskart
        Metadata
        Bindings
        • 0. App\Models\Brand
        • 1. en
        Backtrace
        • 20. app/Utils/brand-manager.php:31
        • 21. view::web-views.products.view:248
        • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `categories` where `position` = 0 order by `priority` asc
        230μscategory-manager.php#13cityexpresskart
        Metadata
        Bindings
        • 0. 0
        Backtrace
        • 15. app/Utils/category-manager.php:13
        • 16. view::web-views.products.view:277
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `categories` where `categories`.`parent_id` in (1, 2, 6, 8, 15) order by `priority` asc
        240μscategory-manager.php#13cityexpresskart
        Metadata
        Backtrace
        • 20. app/Utils/category-manager.php:13
        • 21. view::web-views.products.view:277
        • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `categories` where `categories`.`parent_id` in (4, 5, 7, 9, 10, 11, 12, 13, 14, 16, 17, 18, 19) order by `priority` asc
        180μscategory-manager.php#13cityexpresskart
        Metadata
        Backtrace
        • 25. app/Utils/category-manager.php:13
        • 26. view::web-views.products.view:277
        • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `translations` where `translations`.`translationable_id` in (4, 5, 7, 9, 10, 11, 12, 13, 14, 16, 17, 18, 19) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
        310μscategory-manager.php#13cityexpresskart
        Metadata
        Bindings
        • 0. App\Models\Category
        • 1. en
        Backtrace
        • 25. app/Utils/category-manager.php:13
        • 26. view::web-views.products.view:277
        • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `translations` where `translations`.`translationable_id` in (1, 2, 6, 8, 15) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
        250μscategory-manager.php#13cityexpresskart
        Metadata
        Bindings
        • 0. App\Models\Category
        • 1. en
        Backtrace
        • 20. app/Utils/category-manager.php:13
        • 21. view::web-views.products.view:277
        • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `business_settings` where (`type` = 'google_tag_manager_id') limit 1
        210μssettings.php#15cityexpresskart
        Metadata
        Bindings
        • 0. google_tag_manager_id
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'pixel_analytics') limit 1
        260μssettings.php#15cityexpresskart
        Metadata
        Bindings
        • 0. pixel_analytics
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'announcement') limit 1
        240μssettings.php#15cityexpresskart
        Metadata
        Bindings
        • 0. announcement
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select `cart_group_id` from `carts` where (`customer_id` = 69775 and `is_guest` = 1) group by `cart_group_id`
        300μscart-manager.php#74cityexpresskart
        Metadata
        Bindings
        • 0. 69775
        • 1. 1
        Backtrace
        • 14. app/Utils/cart-manager.php:74
        • 15. app/Utils/cart-manager.php:43
        • 16. view::layouts.front-end.partials._cart:5
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select * from `carts` where 0 = 1
        200μscart-manager.php#43cityexpresskart
        Metadata
        Backtrace
        • 15. app/Utils/cart-manager.php:43
        • 16. view::layouts.front-end.partials._cart:5
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select `cart_group_id` from `carts` where (`customer_id` = 69775 and `is_guest` = 1) group by `cart_group_id`
        200μscart-manager.php#74cityexpresskart
        Metadata
        Bindings
        • 0. 69775
        • 1. 1
        Backtrace
        • 14. app/Utils/cart-manager.php:74
        • 15. app/Utils/cart-manager.php:43
        • 16. view::layouts.front-end.partials._cart:14
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select * from `carts` where 0 = 1
        140μscart-manager.php#43cityexpresskart
        Metadata
        Backtrace
        • 15. app/Utils/cart-manager.php:43
        • 16. view::layouts.front-end.partials._cart:14
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `business_settings` where (`type` = 'currency_symbol_position') limit 1
        190μssettings.php#15cityexpresskart
        Metadata
        Bindings
        • 0. currency_symbol_position
        Backtrace
        • 16. app/Utils/settings.php:15
        • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 24. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select count(*) as aggregate from `categories` where `position` = 0
        180μs_header.blade.php#228cityexpresskart
        Metadata
        Bindings
        • 0. 0
        Backtrace
        • 16. view::layouts.front-end.partials._header:228
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 21. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `categories` where `position` = 0 order by `priority` asc limit 11 offset 0
        170μs_header.blade.php#228cityexpresskart
        Metadata
        Bindings
        • 0. 0
        Backtrace
        • 16. view::layouts.front-end.partials._header:228
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 21. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `categories` where `categories`.`parent_id` in (1, 2, 6, 8, 15) order by `priority` asc
        180μs_header.blade.php#228cityexpresskart
        Metadata
        Backtrace
        • 21. view::layouts.front-end.partials._header:228
        • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 26. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `categories` where `categories`.`parent_id` in (4, 5, 7, 9, 10, 11, 12, 13, 14, 16, 17, 18, 19) order by `priority` asc
        160μs_header.blade.php#228cityexpresskart
        Metadata
        Backtrace
        • 26. view::layouts.front-end.partials._header:228
        • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 31. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `translations` where `translations`.`translationable_id` in (4, 5, 7, 9, 10, 11, 12, 13, 14, 16, 17, 18, 19) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
        180μs_header.blade.php#228cityexpresskart
        Metadata
        Bindings
        • 0. App\Models\Category
        • 1. en
        Backtrace
        • 26. view::layouts.front-end.partials._header:228
        • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 31. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `translations` where `translations`.`translationable_id` in (1, 2, 6, 8, 15) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
        160μs_header.blade.php#228cityexpresskart
        Metadata
        Bindings
        • 0. App\Models\Category
        • 1. en
        Backtrace
        • 21. view::layouts.front-end.partials._header:228
        • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 26. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select `brands`.*, (select count(*) from `products` where `brands`.`id` = `products`.`brand_id` and (exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) or (`brand_id` is null and `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
        660μsbrand-manager.php#31cityexpresskart
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        • 2. 1
        • 3. 1
        • 4. approved
        • 5. admin
        • 6. 1
        • 7. digital
        • 8. physical
        • 9. 1
        Backtrace
        • 15. app/Utils/brand-manager.php:31
        • 16. view::layouts.front-end.partials._header:318
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'
        180μsbrand-manager.php#31cityexpresskart
        Metadata
        Bindings
        • 0. App\Models\Brand
        • 1. en
        Backtrace
        • 20. app/Utils/brand-manager.php:31
        • 21. view::layouts.front-end.partials._header:318
        • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select count(*) as aggregate from `products` where (exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) or (`brand_id` is null and `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 `discount` != 0
        490μs_header.blade.php#348cityexpresskart
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        • 2. 1
        • 3. 1
        • 4. approved
        • 5. admin
        • 6. 1
        • 7. digital
        • 8. physical
        • 9. 0
        Backtrace
        • 16. view::layouts.front-end.partials._header:348
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 21. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'seller_registration') limit 1
        220μssettings.php#15cityexpresskart
        Metadata
        Bindings
        • 0. seller_registration
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'loader_gif') limit 1
        220μssettings.php#15cityexpresskart
        Metadata
        Bindings
        • 0. loader_gif
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'country_code') limit 1
        140μssettings.php#15cityexpresskart
        Metadata
        Bindings
        • 0. country_code
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-01-04' and date(`end_date`) >= '2025-01-04' limit 1
        200μs_footer.blade.php#107cityexpresskart
        Metadata
        Bindings
        • 0. 1
        • 1. flash_deal
        • 2. 2025-01-04
        • 3. 2025-01-04
        Backtrace
        • 16. view::layouts.front-end.partials._footer:107
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 21. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'refund-policy') limit 1
        200μssettings.php#15cityexpresskart
        Metadata
        Bindings
        • 0. refund-policy
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'return-policy') limit 1
        200μssettings.php#15cityexpresskart
        Metadata
        Bindings
        • 0. return-policy
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'cancellation-policy') limit 1
        170μssettings.php#15cityexpresskart
        Metadata
        Bindings
        • 0. cancellation-policy
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'company_phone') limit 1
        140μssettings.php#15cityexpresskart
        Metadata
        Bindings
        • 0. company_phone
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'company_email') limit 1
        140μssettings.php#15cityexpresskart
        Metadata
        Bindings
        • 0. company_email
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'shop_address') limit 1
        170μssettings.php#15cityexpresskart
        Metadata
        Bindings
        • 0. shop_address
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'whatsapp') limit 1
        180μssettings.php#15cityexpresskart
        Metadata
        Bindings
        • 0. whatsapp
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      App\Models\BusinessSetting
      12
      App\Models\Brand
      18
      App\Models\Category
      37
      App\Models\Product
      50
          decimal_point_settings
          2
          product_brand
          1
          digital_product
          1
          business_mode
          multi
          currency_model
          single_currency
          language
          array:1 [ 0 => array:6 [ "id" => "1" "name" => "english" "direction" => "ltr" "cod...
          local
          en
          direction
          ltr
          system_default_currency
          3
          system_default_currency_info
          App\Models\Currency {#3486 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
          currency_code
          INR
          currency_symbol
          currency_exchange_rate
          60
          _token
          XhLQ8gnOhb8QxE9xpBR0cYeZXyyylGVw5YCTdAKQ
          guest_id
          69775
          currency_symbol_position
          left
          company_email
          wecubeenterprises@gmail.com
          _previous
          array:1 [ "url" => "https://cityexpresskart.com/products?data_from=category&id=4&page=1" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          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 [ "data_from" => "category" "id" => "4" "page" => "1" ]
          request_request
          []
          
          request_headers
          0 of 0
          array:25 [ "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" ] "cdn-loop" => array:1 [ 0 => "cloudflare; loops=1" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "priority" => array:1 [ 0 => "u=0, i" ] "cf-connecting-ip" => array:1 [ 0 => "18.218.150.72" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "cf-visitor" => array:1 [ 0 => "{"scheme":"https"}" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "cf-ipcountry" => array:1 [ 0 => "US" ] "accept-encoding" => array:1 [ 0 => "gzip, br" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "cf-ray" => array:1 [ 0 => "8fcce95a4afde213-ORD" ] "connection" => array:1 [ 0 => "close" ] "x-forwarded-for" => array:1 [ 0 => "18.218.150.72, 108.162.216.253" ] "x-real-ip" => array:1 [ 0 => "108.162.216.253" ] "x-forwarded-host" => array:1 [ 0 => "cityexpresskart.com" ] "host" => array:1 [ 0 => "cityexpresskart.com" ] ]
          request_server
          0 of 0
          array:64 [ "USER" => "cityexpresskart" "HOME" => "/home/cityexpresskart" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_CDN_LOOP" => "cloudflare; loops=1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_PRIORITY" => "u=0, i" "HTTP_CF_CONNECTING_IP" => "18.218.150.72" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_CF_VISITOR" => "{"scheme":"https"}" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_CF_IPCOUNTRY" => "US" "HTTP_ACCEPT_ENCODING" => "gzip, br" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_CF_RAY" => "8fcce95a4afde213-ORD" "HTTP_CONNECTION" => "close" "HTTP_X_FORWARDED_FOR" => "18.218.150.72, 108.162.216.253" "HTTP_X_REAL_IP" => "108.162.216.253" "HTTP_X_FORWARDED_HOST" => "cityexpresskart.com" "HTTP_HOST" => "cityexpresskart.com" "PHP_VALUE" => """ \n error_log=/home/cityexpresskart/logs/php/error.log;\n memory_limit=5G;\n max_execution_time=1800;\n max_input_time=1800;\n max_input_vars=100000;\n post_max_size=4G;\n upload_max_filesize=4G;\n date.timezone=IST;\n display_errors=off; """ "HTTPS" => "on" "MGT" => "1" "GEOIP_LONGITUDE" => "-122.3933" "GEOIP_LATITUDE" => "37.7697" "GEOIP_CITY_CONTINENT_CODE" => "NA" "GEOIP_POSTAL_CODE" => "94107" "GEOIP_CITY" => "San Francisco" "GEOIP_REGION" => "CA" "GEOIP_CITY_COUNTRY_NAME" => "United States" "GEOIP_CITY_COUNTRY_CODE3" => "USA" "GEOIP_CITY_COUNTRY_CODE" => "US" "GEOIP_COUNTRY_NAME" => "United States" "GEOIP_COUNTRY_CODE3" => "USA" "GEOIP_COUNTRY_CODE" => "US" "REDIRECT_STATUS" => "200" "SERVER_NAME" => "cityexpresskart.com" "SERVER_PORT" => "443" "SERVER_ADDR" => "127.0.0.1" "REMOTE_PORT" => "" "REMOTE_ADDR" => "108.162.216.253" "SERVER_SOFTWARE" => "nginx/1.21.4" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.0" "DOCUMENT_ROOT" => "/home/cityexpresskart/htdocs/cityexpresskart.com" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/products?data_from=category&id=4&page=1" "SCRIPT_NAME" => "/index.php" "SCRIPT_FILENAME" => "/home/cityexpresskart/htdocs/cityexpresskart.com/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "data_from=category&id=4&page=1" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1736011355.5788 "REQUEST_TIME" => 1736011355 ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:7 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "private, must-revalidate" ] "date" => array:1 [ 0 => "Sat, 04 Jan 2025 17:22:35 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InFqMmU4T0dRRFhiUlBSQjNEcDhIWUE9PSIsInZhbHVlIjoiYi9aM0hzYXRqa3NmZCtoaTE2Zm1qODlaZTR2NFgzbmxEMUFVV1d0N1lybHh5L24xRlIwTEhWL2VuME9hellJdmtXcXBoZU40dVNubVAwWWhXbDVndGttNm9YYkxDbEdZMkxjWUNHVVljU1Nza1NBSkJVdHFvdlZGMzhzRk5GdlYiLCJtYWMiOiIwZmQyY2QxODM5ZDU3MTdjNjE3NGI3Y2Y0MTU0MDgzNjc5ZjViOGQ0ZGJmZGFjMTZjMWFiNGUzOGU2Y2JhMzE0IiwidGFnIjoiIn0%3D; expires=Sat, 04 Jan 2025 19:22:35 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6InFqMmU4T0dRRFhiUlBSQjNEcDhIWUE9PSIsInZhbHVlIjoiYi9aM0hzYXRqa3NmZCtoaTE2Zm1qODlaZTR2NFgzbmxEMUFVV1d0N1lybHh5L24xRlIwTEhWL2VuME9hellJdmtXcXBoZ" 1 => "laravel_session=eyJpdiI6Ii9HRkVvYmZZdkFiNnVvQ2lXM3NzTXc9PSIsInZhbHVlIjoiTDFIdzVza3Z3aHNXRG1OVCtZMC9YcVVKcnJyRVlBT3hlZ3hOeFRJajBST0JBRVlhRjM0ZWdMMENXNmJvK0xFMDZ3VUpKZmdlK1Naa0w4NWR5NVdPZ3dmOEFXOE13QTFzMERVdWZIOEJUb1B2a3oyc2hrUkV4ZmFUc2FaYU9XOEIiLCJtYWMiOiIyMmI4MjkwOTQ2ZjkyZDk2YWY5NzhjMmVhOThkNjcwMDQ3NzYzZjg4ZDI0ODNkN2RlYjcxZmU0OWYzNzg3N2FlIiwidGFnIjoiIn0%3D; expires=Sat, 04 Jan 2025 19:22:35 GMT; Max-Age=7200; path=/; httponlylaravel_session=eyJpdiI6Ii9HRkVvYmZZdkFiNnVvQ2lXM3NzTXc9PSIsInZhbHVlIjoiTDFIdzVza3Z3aHNXRG1OVCtZMC9YcVVKcnJyRVlBT3hlZ3hOeFRJajBST0JBRVlhRjM0ZWdMMENXNmJvK0xFMDZ3" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InFqMmU4T0dRRFhiUlBSQjNEcDhIWUE9PSIsInZhbHVlIjoiYi9aM0hzYXRqa3NmZCtoaTE2Zm1qODlaZTR2NFgzbmxEMUFVV1d0N1lybHh5L24xRlIwTEhWL2VuME9hellJdmtXcXBoZU40dVNubVAwWWhXbDVndGttNm9YYkxDbEdZMkxjWUNHVVljU1Nza1NBSkJVdHFvdlZGMzhzRk5GdlYiLCJtYWMiOiIwZmQyY2QxODM5ZDU3MTdjNjE3NGI3Y2Y0MTU0MDgzNjc5ZjViOGQ0ZGJmZGFjMTZjMWFiNGUzOGU2Y2JhMzE0IiwidGFnIjoiIn0%3D; expires=Sat, 04-Jan-2025 19:22:35 GMT; path=/XSRF-TOKEN=eyJpdiI6InFqMmU4T0dRRFhiUlBSQjNEcDhIWUE9PSIsInZhbHVlIjoiYi9aM0hzYXRqa3NmZCtoaTE2Zm1qODlaZTR2NFgzbmxEMUFVV1d0N1lybHh5L24xRlIwTEhWL2VuME9hellJdmtXcXBoZ" 1 => "laravel_session=eyJpdiI6Ii9HRkVvYmZZdkFiNnVvQ2lXM3NzTXc9PSIsInZhbHVlIjoiTDFIdzVza3Z3aHNXRG1OVCtZMC9YcVVKcnJyRVlBT3hlZ3hOeFRJajBST0JBRVlhRjM0ZWdMMENXNmJvK0xFMDZ3VUpKZmdlK1Naa0w4NWR5NVdPZ3dmOEFXOE13QTFzMERVdWZIOEJUb1B2a3oyc2hrUkV4ZmFUc2FaYU9XOEIiLCJtYWMiOiIyMmI4MjkwOTQ2ZjkyZDk2YWY5NzhjMmVhOThkNjcwMDQ3NzYzZjg4ZDI0ODNkN2RlYjcxZmU0OWYzNzg3N2FlIiwidGFnIjoiIn0%3D; expires=Sat, 04-Jan-2025 19:22:35 GMT; path=/; httponlylaravel_session=eyJpdiI6Ii9HRkVvYmZZdkFiNnVvQ2lXM3NzTXc9PSIsInZhbHVlIjoiTDFIdzVza3Z3aHNXRG1OVCtZMC9YcVVKcnJyRVlBT3hlZ3hOeFRJajBST0JBRVlhRjM0ZWdMMENXNmJvK0xFMDZ3" ] ]
          session_attributes
          0 of 0
          array:20 [ "decimal_point_settings" => 2 "product_brand" => 1 "digital_product" => 1 "business_mode" => "multi" "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 {#3486 #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" => "XhLQ8gnOhb8QxE9xpBR0cYeZXyyylGVw5YCTdAKQ" "guest_id" => 69775 "currency_symbol_position" => "left" "company_email" => "wecubeenterprises@gmail.com" "_previous" => array:1 [ "url" => "https://cityexpresskart.com/products?data_from=category&id=4&page=1" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]