New arrivals
Brands
Shop By School
Top
Not found
8.3.7PHP Version293msRequest Duration12MBMemory UsageGET /Route
  • warninglog[07:38:20] LOG.warning: addslashes(): Passing null to parameter #1 ($string) of type string is depre...
  • Booting (79.81ms)time
  • Application (214ms)time
  • 1 x Application (72.79%)
    214ms
    1 x Booting (27.21%)
    79.81ms
    26 templates were rendered
    • web-views.homehome.blade.phpblade
    • web-views.partials._home-top-slider_home-top-slider.blade.phpblade
    • web-views.partials._category-section-home_category-section-home.blade.phpblade
    • web-views.partials._deal-of-the-day_deal-of-the-day.blade.phpblade
    • web-views.partials._product-card-2_product-card-2.blade.phpblade
    • web-views.partials._product-card-2_product-card-2.blade.phpblade
    • web-views.partials._product-card-2_product-card-2.blade.phpblade
    • web-views.partials._product-card-2_product-card-2.blade.phpblade
    • web-views.partials._product-card-2_product-card-2.blade.phpblade
    • web-views.partials._product-card-2_product-card-2.blade.phpblade
    • web-views.partials._product-card-2_product-card-2.blade.phpblade
    • web-views.partials._product-card-2_product-card-2.blade.phpblade
    • web-views.partials._best-selling_best-selling.blade.phpblade
    • web-views.partials._top-rated_top-rated.blade.phpblade
    • web-views.partials._category-wise-product_category-wise-product.blade.phpblade
    • web-views.partials._category-single-product_category-single-product.blade.phpblade
    • web-views.partials._category-single-product_category-single-product.blade.phpblade
    • web-views.partials._category-wise-product_category-wise-product.blade.phpblade
    • web-views.partials._company-reliability_company-reliability.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 /
    middleware
    web, maintenance_mode, guestCheck
    controller
    App\Http\Controllers\Web\HomeController@index
    namespace
    App\Http\Controllers\Web
    prefix
    where
    as
    home
    file
    app/Http/Controllers/Web/HomeController.php:48-58
    82 statements were executed, 26 of which were duplicated, 56 unique. Show only duplicated77.68ms
    • select * from `business_settings` where (`type` = 'maintenance_mode') limit 1
      500μshelpers.php#167pustaklab
      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
    • select * from `business_settings` where `type` = 'product_brand' limit 1
      390μsHomeController.php#63pustaklab
      Metadata
      Bindings
      • 0. product_brand
      Backtrace
      • 16. app/Http/Controllers/Web/HomeController.php:63
      • 17. app/Http/Controllers/Web/HomeController.php:53
      • 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 `home_status` = 1 order by `priority` asc
      570μsHomeController.php#64pustaklab
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:64
      • 16. app/Http/Controllers/Web/HomeController.php:53
      • 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 `translations` where `translations`.`translationable_id` in (1, 2) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
      400μsHomeController.php#64pustaklab
      Metadata
      Bindings
      • 0. App\Models\Category
      • 1. en
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:64
      • 21. app/Http/Controllers/Web/HomeController.php:53
      • 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 `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count` 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) 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 `category_ids` like '%\"1\"%' order by RAND() limit 12
      3.69msHomeController.php#70pustaklab
      Metadata
      Bindings
      • 0. 1
      • 1. admin
      • 2. 1
      • 3. 1
      • 4. 1
      • 5. 1
      • 6. approved
      • 7. admin
      • 8. 1
      • 9. digital
      • 10. physical
      • 11. %"1"%
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:70
      • 20. app/Http/Controllers/Web/HomeController.php:65
      • 21. app/Http/Controllers/Web/HomeController.php:53
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `translations` where `translations`.`translationable_id` in (9) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
      480μsHomeController.php#70pustaklab
      Metadata
      Bindings
      • 0. App\Models\Product
      • 1. en
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:70
      • 25. app/Http/Controllers/Web/HomeController.php:65
      • 26. app/Http/Controllers/Web/HomeController.php:53
      • 27. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `reviews` where `reviews`.`product_id` in (9) and `delivery_man_id` is null and `status` = 1
      360μsHomeController.php#70pustaklab
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:70
      • 25. app/Http/Controllers/Web/HomeController.php:65
      • 26. app/Http/Controllers/Web/HomeController.php:53
      • 27. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count` 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) 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 `category_ids` like '%\"2\"%' order by RAND() limit 12
      3.62msHomeController.php#70pustaklab
      Metadata
      Bindings
      • 0. 1
      • 1. admin
      • 2. 1
      • 3. 1
      • 4. 1
      • 5. 1
      • 6. approved
      • 7. admin
      • 8. 1
      • 9. digital
      • 10. physical
      • 11. %"2"%
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:70
      • 20. app/Http/Controllers/Web/HomeController.php:65
      • 21. app/Http/Controllers/Web/HomeController.php:53
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `shops`.*, (select count(*) from `products` where (`shops`.`seller_id` = `products`.`user_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) 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 (`added_by` = 'seller' and `status` = 1 and `request_status` = 1)) as `products_count` from `shops` where exists (select * from `sellers` where `shops`.`seller_id` = `sellers`.`id` and (`status` = 'approved'))
      700μsHomeController.php#86pustaklab
      Metadata
      Bindings
      • 0. admin
      • 1. 1
      • 2. 1
      • 3. 1
      • 4. 1
      • 5. approved
      • 6. admin
      • 7. 1
      • 8. digital
      • 9. physical
      • 10. seller
      • 11. 1
      • 12. 1
      • 13. approved
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:86
      • 16. app/Http/Controllers/Web/HomeController.php:53
      • 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 `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count` 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) 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 (`added_by` = 'admin')
      9.78msHomeController.php#99pustaklab
      Metadata
      Bindings
      • 0. 1
      • 1. admin
      • 2. 1
      • 3. 1
      • 4. 1
      • 5. 1
      • 6. approved
      • 7. admin
      • 8. 1
      • 9. digital
      • 10. physical
      • 11. admin
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:99
      • 16. app/Http/Controllers/Web/HomeController.php:53
      • 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 (8, 9, 10, 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, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257) and `delivery_man_id` is null and `status` = 1
      670μsHomeController.php#99pustaklab
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:99
      • 21. app/Http/Controllers/Web/HomeController.php:53
      • 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 avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (8, 9, 10, 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, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257) and `status` = 1 group by `product_id`
      600μsHomeController.php#99pustaklab
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:99
      • 21. app/Http/Controllers/Web/HomeController.php:53
      • 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 (8, 9, 10, 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, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
      730μsHomeController.php#99pustaklab
      Metadata
      Bindings
      • 0. App\Models\Product
      • 1. en
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:99
      • 21. app/Http/Controllers/Web/HomeController.php:53
      • 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 `reviews` where `status` = 1 and `product_id` in (8, 9, 10, 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, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257) and `status` = 1
      760μsHomeController.php#103pustaklab
      Metadata
      Bindings
      • 0. 1
      • 1. 8
      • 2. 9
      • 3. 10
      • 4. 14
      • 5. 15
      • 6. 16
      • 7. 17
      • 8. 18
      • 9. 19
      • 10. 20
      • 11. 21
      • 12. 22
      • 13. 23
      • 14. 24
      • 15. 25
      • 16. 26
      • 17. 27
      • 18. 28
      • 19. 29
      • 20. 30
      • 21. 31
      • 22. 32
      • 23. 33
      • 24. 34
      • 25. 35
      • 26. 36
      • 27. 37
      • 28. 38
      • 29. 39
      • 30. 40
      • 31. 41
      • 32. 42
      • 33. 43
      • 34. 44
      • 35. 45
      • 36. 46
      • 37. 47
      • 38. 48
      • 39. 49
      • 40. 50
      • 41. 51
      • 42. 52
      • 43. 53
      • 44. 54
      • 45. 55
      • 46. 56
      • 47. 57
      • 48. 58
      • 49. 59
      • 50. 60
      • 51. 61
      • 52. 62
      • 53. 63
      • 54. 64
      • 55. 65
      • 56. 66
      • 57. 67
      • 58. 68
      • 59. 69
      • 60. 70
      • 61. 71
      • 62. 72
      • 63. 73
      • 64. 74
      • 65. 75
      • 66. 76
      • 67. 77
      • 68. 78
      • 69. 79
      • 70. 80
      • 71. 81
      • 72. 82
      • 73. 83
      • 74. 84
      • 75. 85
      • 76. 86
      • 77. 87
      • 78. 88
      • 79. 89
      • 80. 90
      • 81. 91
      • 82. 92
      • 83. 93
      • 84. 94
      • 85. 95
      • 86. 96
      • 87. 97
      • 88. 98
      • 89. 99
      • 90. 100
      • 91. 101
      • 92. 103
      • 93. 104
      • 94. 105
      • 95. 106
      • 96. 107
      • 97. 108
      • 98. 109
      • 99. 110
      • 100. 111
      • 101. 112
      • 102. 113
      • 103. 114
      • 104. 115
      • 105. 116
      • 106. 117
      • 107. 118
      • 108. 119
      • 109. 120
      • 110. 121
      • 111. 122
      • 112. 123
      • 113. 124
      • 114. 125
      • 115. 126
      • 116. 127
      • 117. 128
      • 118. 129
      • 119. 130
      • 120. 131
      • 121. 132
      • 122. 133
      • 123. 134
      • 124. 135
      • 125. 136
      • 126. 137
      • 127. 138
      • 128. 139
      • 129. 140
      • 130. 141
      • 131. 142
      • 132. 143
      • 133. 144
      • 134. 145
      • 135. 146
      • 136. 147
      • 137. 148
      • 138. 149
      • 139. 150
      • 140. 151
      • 141. 152
      • 142. 153
      • 143. 154
      • 144. 155
      • 145. 156
      • 146. 157
      • 147. 158
      • 148. 159
      • 149. 160
      • 150. 161
      • 151. 162
      • 152. 163
      • 153. 164
      • 154. 165
      • 155. 166
      • 156. 167
      • 157. 168
      • 158. 169
      • 159. 170
      • 160. 171
      • 161. 172
      • 162. 173
      • 163. 174
      • 164. 175
      • 165. 176
      • 166. 177
      • 167. 178
      • 168. 179
      • 169. 180
      • 170. 181
      • 171. 182
      • 172. 183
      • 173. 184
      • 174. 185
      • 175. 186
      • 176. 187
      • 177. 188
      • 178. 189
      • 179. 190
      • 180. 191
      • 181. 192
      • 182. 193
      • 183. 194
      • 184. 195
      • 185. 196
      • 186. 197
      • 187. 198
      • 188. 199
      • 189. 200
      • 190. 201
      • 191. 202
      • 192. 203
      • 193. 204
      • 194. 205
      • 195. 207
      • 196. 208
      • 197. 209
      • 198. 210
      • 199. 211
      • 200. 212
      • 201. 213
      • 202. 214
      • 203. 215
      • 204. 216
      • 205. 217
      • 206. 218
      • 207. 219
      • 208. 220
      • 209. 221
      • 210. 222
      • 211. 223
      • 212. 224
      • 213. 225
      • 214. 226
      • 215. 227
      • 216. 228
      • 217. 229
      • 218. 230
      • 219. 231
      • 220. 232
      • 221. 233
      • 222. 234
      • 223. 235
      • 224. 236
      • 225. 237
      • 226. 238
      • 227. 239
      • 228. 240
      • 229. 241
      • 230. 242
      • 231. 243
      • 232. 244
      • 233. 245
      • 234. 246
      • 235. 247
      • 236. 248
      • 237. 249
      • 238. 250
      • 239. 251
      • 240. 252
      • 241. 253
      • 242. 254
      • 243. 255
      • 244. 256
      • 245. 257
      • 246. 1
      Backtrace
      • 16. app/Http/Controllers/Web/HomeController.php:103
      • 17. app/Http/Controllers/Web/HomeController.php:53
      • 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 `rating` from `reviews` where `status` = 1 and `product_id` in (8, 9, 10, 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, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257) and `status` = 1
      660μsHomeController.php#105pustaklab
      Metadata
      Bindings
      • 0. 1
      • 1. 8
      • 2. 9
      • 3. 10
      • 4. 14
      • 5. 15
      • 6. 16
      • 7. 17
      • 8. 18
      • 9. 19
      • 10. 20
      • 11. 21
      • 12. 22
      • 13. 23
      • 14. 24
      • 15. 25
      • 16. 26
      • 17. 27
      • 18. 28
      • 19. 29
      • 20. 30
      • 21. 31
      • 22. 32
      • 23. 33
      • 24. 34
      • 25. 35
      • 26. 36
      • 27. 37
      • 28. 38
      • 29. 39
      • 30. 40
      • 31. 41
      • 32. 42
      • 33. 43
      • 34. 44
      • 35. 45
      • 36. 46
      • 37. 47
      • 38. 48
      • 39. 49
      • 40. 50
      • 41. 51
      • 42. 52
      • 43. 53
      • 44. 54
      • 45. 55
      • 46. 56
      • 47. 57
      • 48. 58
      • 49. 59
      • 50. 60
      • 51. 61
      • 52. 62
      • 53. 63
      • 54. 64
      • 55. 65
      • 56. 66
      • 57. 67
      • 58. 68
      • 59. 69
      • 60. 70
      • 61. 71
      • 62. 72
      • 63. 73
      • 64. 74
      • 65. 75
      • 66. 76
      • 67. 77
      • 68. 78
      • 69. 79
      • 70. 80
      • 71. 81
      • 72. 82
      • 73. 83
      • 74. 84
      • 75. 85
      • 76. 86
      • 77. 87
      • 78. 88
      • 79. 89
      • 80. 90
      • 81. 91
      • 82. 92
      • 83. 93
      • 84. 94
      • 85. 95
      • 86. 96
      • 87. 97
      • 88. 98
      • 89. 99
      • 90. 100
      • 91. 101
      • 92. 103
      • 93. 104
      • 94. 105
      • 95. 106
      • 96. 107
      • 97. 108
      • 98. 109
      • 99. 110
      • 100. 111
      • 101. 112
      • 102. 113
      • 103. 114
      • 104. 115
      • 105. 116
      • 106. 117
      • 107. 118
      • 108. 119
      • 109. 120
      • 110. 121
      • 111. 122
      • 112. 123
      • 113. 124
      • 114. 125
      • 115. 126
      • 116. 127
      • 117. 128
      • 118. 129
      • 119. 130
      • 120. 131
      • 121. 132
      • 122. 133
      • 123. 134
      • 124. 135
      • 125. 136
      • 126. 137
      • 127. 138
      • 128. 139
      • 129. 140
      • 130. 141
      • 131. 142
      • 132. 143
      • 133. 144
      • 134. 145
      • 135. 146
      • 136. 147
      • 137. 148
      • 138. 149
      • 139. 150
      • 140. 151
      • 141. 152
      • 142. 153
      • 143. 154
      • 144. 155
      • 145. 156
      • 146. 157
      • 147. 158
      • 148. 159
      • 149. 160
      • 150. 161
      • 151. 162
      • 152. 163
      • 153. 164
      • 154. 165
      • 155. 166
      • 156. 167
      • 157. 168
      • 158. 169
      • 159. 170
      • 160. 171
      • 161. 172
      • 162. 173
      • 163. 174
      • 164. 175
      • 165. 176
      • 166. 177
      • 167. 178
      • 168. 179
      • 169. 180
      • 170. 181
      • 171. 182
      • 172. 183
      • 173. 184
      • 174. 185
      • 175. 186
      • 176. 187
      • 177. 188
      • 178. 189
      • 179. 190
      • 180. 191
      • 181. 192
      • 182. 193
      • 183. 194
      • 184. 195
      • 185. 196
      • 186. 197
      • 187. 198
      • 188. 199
      • 189. 200
      • 190. 201
      • 191. 202
      • 192. 203
      • 193. 204
      • 194. 205
      • 195. 207
      • 196. 208
      • 197. 209
      • 198. 210
      • 199. 211
      • 200. 212
      • 201. 213
      • 202. 214
      • 203. 215
      • 204. 216
      • 205. 217
      • 206. 218
      • 207. 219
      • 208. 220
      • 209. 221
      • 210. 222
      • 211. 223
      • 212. 224
      • 213. 225
      • 214. 226
      • 215. 227
      • 216. 228
      • 217. 229
      • 218. 230
      • 219. 231
      • 220. 232
      • 221. 233
      • 222. 234
      • 223. 235
      • 224. 236
      • 225. 237
      • 226. 238
      • 227. 239
      • 228. 240
      • 229. 241
      • 230. 242
      • 231. 243
      • 232. 244
      • 233. 245
      • 234. 246
      • 235. 247
      • 236. 248
      • 237. 249
      • 238. 250
      • 239. 251
      • 240. 252
      • 241. 253
      • 242. 254
      • 243. 255
      • 244. 256
      • 245. 257
      • 246. 1
      Backtrace
      • 14. app/Http/Controllers/Web/HomeController.php:105
      • 15. app/Http/Controllers/Web/HomeController.php:53
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `business_settings` where (`type` = 'vacation_add') limit 1
      410μssettings.php#15pustaklab
      Metadata
      Bindings
      • 0. vacation_add
      Backtrace
      • 16. app/Utils/settings.php:15
      • 18. app/Http/Controllers/Web/HomeController.php:109
      • 19. app/Http/Controllers/Web/HomeController.php:53
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'company_name') limit 1
      300μssettings.php#15pustaklab
      Metadata
      Bindings
      • 0. company_name
      Backtrace
      • 16. app/Utils/settings.php:15
      • 18. app/Http/Controllers/Web/HomeController.php:109
      • 19. app/Http/Controllers/Web/HomeController.php:53
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'shop_address') limit 1
      420μssettings.php#15pustaklab
      Metadata
      Bindings
      • 0. shop_address
      Backtrace
      • 16. app/Utils/settings.php:15
      • 18. app/Http/Controllers/Web/HomeController.php:109
      • 19. app/Http/Controllers/Web/HomeController.php:53
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'company_phone') limit 1
      290μssettings.php#15pustaklab
      Metadata
      Bindings
      • 0. company_phone
      Backtrace
      • 16. app/Utils/settings.php:15
      • 18. app/Http/Controllers/Web/HomeController.php:109
      • 19. app/Http/Controllers/Web/HomeController.php:53
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'company_fav_icon') limit 1
      300μssettings.php#15pustaklab
      Metadata
      Bindings
      • 0. company_fav_icon
      Backtrace
      • 16. app/Utils/settings.php:15
      • 18. app/Http/Controllers/Web/HomeController.php:109
      • 19. app/Http/Controllers/Web/HomeController.php:53
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'bottom_banner') limit 1
      370μssettings.php#15pustaklab
      Metadata
      Bindings
      • 0. bottom_banner
      Backtrace
      • 16. app/Utils/settings.php:15
      • 18. app/Http/Controllers/Web/HomeController.php:109
      • 19. app/Http/Controllers/Web/HomeController.php:53
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'offer_banner') limit 1
      390μssettings.php#15pustaklab
      Metadata
      Bindings
      • 0. offer_banner
      Backtrace
      • 16. app/Utils/settings.php:15
      • 18. app/Http/Controllers/Web/HomeController.php:109
      • 19. app/Http/Controllers/Web/HomeController.php:53
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'temporary_close') limit 1
      380μssettings.php#15pustaklab
      Metadata
      Bindings
      • 0. temporary_close
      Backtrace
      • 16. app/Utils/settings.php:15
      • 18. app/Http/Controllers/Web/HomeController.php:109
      • 19. app/Http/Controllers/Web/HomeController.php:53
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'temporary_close') limit 1
      380μssettings.php#15pustaklab
      Metadata
      Bindings
      • 0. temporary_close
      Backtrace
      • 16. app/Utils/settings.php:15
      • 18. app/Http/Controllers/Web/HomeController.php:109
      • 19. app/Http/Controllers/Web/HomeController.php:53
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'shop_banner') limit 1
      430μssettings.php#15pustaklab
      Metadata
      Bindings
      • 0. shop_banner
      Backtrace
      • 16. app/Utils/settings.php:15
      • 18. app/Http/Controllers/Web/HomeController.php:109
      • 19. app/Http/Controllers/Web/HomeController.php:53
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `admins` where (`id` = 1) limit 1
      440μsInHouseTrait.php#37pustaklab
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 16. app/Traits/InHouseTrait.php:37
      • 17. app/Http/Controllers/Web/HomeController.php:109
      • 18. app/Http/Controllers/Web/HomeController.php:53
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `admins` where (`id` = 1) limit 1
      360μsInHouseTrait.php#37pustaklab
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 16. app/Traits/InHouseTrait.php:37
      • 17. app/Http/Controllers/Web/HomeController.php:109
      • 18. app/Http/Controllers/Web/HomeController.php:53
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select avg(`rating`) as aggregate from `reviews` where `status` = 1 and `product_id` in (8, 9, 10, 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, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257) and `status` = 1
      690μsHomeController.php#114pustaklab
      Metadata
      Bindings
      • 0. 1
      • 1. 8
      • 2. 9
      • 3. 10
      • 4. 14
      • 5. 15
      • 6. 16
      • 7. 17
      • 8. 18
      • 9. 19
      • 10. 20
      • 11. 21
      • 12. 22
      • 13. 23
      • 14. 24
      • 15. 25
      • 16. 26
      • 17. 27
      • 18. 28
      • 19. 29
      • 20. 30
      • 21. 31
      • 22. 32
      • 23. 33
      • 24. 34
      • 25. 35
      • 26. 36
      • 27. 37
      • 28. 38
      • 29. 39
      • 30. 40
      • 31. 41
      • 32. 42
      • 33. 43
      • 34. 44
      • 35. 45
      • 36. 46
      • 37. 47
      • 38. 48
      • 39. 49
      • 40. 50
      • 41. 51
      • 42. 52
      • 43. 53
      • 44. 54
      • 45. 55
      • 46. 56
      • 47. 57
      • 48. 58
      • 49. 59
      • 50. 60
      • 51. 61
      • 52. 62
      • 53. 63
      • 54. 64
      • 55. 65
      • 56. 66
      • 57. 67
      • 58. 68
      • 59. 69
      • 60. 70
      • 61. 71
      • 62. 72
      • 63. 73
      • 64. 74
      • 65. 75
      • 66. 76
      • 67. 77
      • 68. 78
      • 69. 79
      • 70. 80
      • 71. 81
      • 72. 82
      • 73. 83
      • 74. 84
      • 75. 85
      • 76. 86
      • 77. 87
      • 78. 88
      • 79. 89
      • 80. 90
      • 81. 91
      • 82. 92
      • 83. 93
      • 84. 94
      • 85. 95
      • 86. 96
      • 87. 97
      • 88. 98
      • 89. 99
      • 90. 100
      • 91. 101
      • 92. 103
      • 93. 104
      • 94. 105
      • 95. 106
      • 96. 107
      • 97. 108
      • 98. 109
      • 99. 110
      • 100. 111
      • 101. 112
      • 102. 113
      • 103. 114
      • 104. 115
      • 105. 116
      • 106. 117
      • 107. 118
      • 108. 119
      • 109. 120
      • 110. 121
      • 111. 122
      • 112. 123
      • 113. 124
      • 114. 125
      • 115. 126
      • 116. 127
      • 117. 128
      • 118. 129
      • 119. 130
      • 120. 131
      • 121. 132
      • 122. 133
      • 123. 134
      • 124. 135
      • 125. 136
      • 126. 137
      • 127. 138
      • 128. 139
      • 129. 140
      • 130. 141
      • 131. 142
      • 132. 143
      • 133. 144
      • 134. 145
      • 135. 146
      • 136. 147
      • 137. 148
      • 138. 149
      • 139. 150
      • 140. 151
      • 141. 152
      • 142. 153
      • 143. 154
      • 144. 155
      • 145. 156
      • 146. 157
      • 147. 158
      • 148. 159
      • 149. 160
      • 150. 161
      • 151. 162
      • 152. 163
      • 153. 164
      • 154. 165
      • 155. 166
      • 156. 167
      • 157. 168
      • 158. 169
      • 159. 170
      • 160. 171
      • 161. 172
      • 162. 173
      • 163. 174
      • 164. 175
      • 165. 176
      • 166. 177
      • 167. 178
      • 168. 179
      • 169. 180
      • 170. 181
      • 171. 182
      • 172. 183
      • 173. 184
      • 174. 185
      • 175. 186
      • 176. 187
      • 177. 188
      • 178. 189
      • 179. 190
      • 180. 191
      • 181. 192
      • 182. 193
      • 183. 194
      • 184. 195
      • 185. 196
      • 186. 197
      • 187. 198
      • 188. 199
      • 189. 200
      • 190. 201
      • 191. 202
      • 192. 203
      • 193. 204
      • 194. 205
      • 195. 207
      • 196. 208
      • 197. 209
      • 198. 210
      • 199. 211
      • 200. 212
      • 201. 213
      • 202. 214
      • 203. 215
      • 204. 216
      • 205. 217
      • 206. 218
      • 207. 219
      • 208. 220
      • 209. 221
      • 210. 222
      • 211. 223
      • 212. 224
      • 213. 225
      • 214. 226
      • 215. 227
      • 216. 228
      • 217. 229
      • 218. 230
      • 219. 231
      • 220. 232
      • 221. 233
      • 222. 234
      • 223. 235
      • 224. 236
      • 225. 237
      • 226. 238
      • 227. 239
      • 228. 240
      • 229. 241
      • 230. 242
      • 231. 243
      • 232. 244
      • 233. 245
      • 234. 246
      • 235. 247
      • 236. 248
      • 237. 249
      • 238. 250
      • 239. 251
      • 240. 252
      • 241. 253
      • 242. 254
      • 243. 255
      • 244. 256
      • 245. 257
      • 246. 1
      Backtrace
      • 16. app/Http/Controllers/Web/HomeController.php:114
      • 17. app/Http/Controllers/Web/HomeController.php:53
      • 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 count(*) as aggregate from `orders` where (`seller_is` = 'admin')
      340μsHomeController.php#116pustaklab
      Metadata
      Bindings
      • 0. admin
      Backtrace
      • 16. app/Http/Controllers/Web/HomeController.php:116
      • 17. app/Http/Controllers/Web/HomeController.php:53
      • 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 `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` 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) 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 `featured` = 1 order by `order_details_count` desc limit 12
      3.35msHomeController.php#124pustaklab
      Metadata
      Bindings
      • 0. admin
      • 1. 1
      • 2. 1
      • 3. 1
      • 4. 1
      • 5. approved
      • 6. admin
      • 7. 1
      • 8. digital
      • 9. physical
      • 10. 1
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:124
      • 16. app/Http/Controllers/Web/HomeController.php:53
      • 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 `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) 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') order by `id` desc limit 8
      1msHomeController.php#127pustaklab
      Metadata
      Bindings
      • 0. admin
      • 1. 1
      • 2. 1
      • 3. 1
      • 4. 1
      • 5. approved
      • 6. admin
      • 7. 1
      • 8. digital
      • 9. physical
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:127
      • 16. app/Http/Controllers/Web/HomeController.php:53
      • 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 (250, 251, 252, 253, 254, 255, 256, 257) and `delivery_man_id` is null and `status` = 1
      420μsHomeController.php#127pustaklab
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:127
      • 21. app/Http/Controllers/Web/HomeController.php:53
      • 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 (250, 251, 252, 253, 254, 255, 256, 257) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
      430μsHomeController.php#127pustaklab
      Metadata
      Bindings
      • 0. App\Models\Product
      • 1. en
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:127
      • 21. app/Http/Controllers/Web/HomeController.php:53
      • 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 `categories` where (`position` = 0) order by `priority` asc limit 8
      480μsHomeController.php#128pustaklab
      Metadata
      Bindings
      • 0. 0
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:128
      • 16. app/Http/Controllers/Web/HomeController.php:53
      • 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 `categories` where `categories`.`parent_id` in (1, 2, 3, 4, 64) order by `priority` asc
      510μsHomeController.php#128pustaklab
      Metadata
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:128
      • 21. app/Http/Controllers/Web/HomeController.php:53
      • 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 `categories` where `categories`.`parent_id` in (5, 6, 7, 8, 9, 37, 38, 39, 40, 41, 42, 43, 44, 45, 70, 71, 72, 73, 74, 75, 76, 97, 98, 99, 100) order by `priority` asc
      700μsHomeController.php#128pustaklab
      Metadata
      Backtrace
      • 25. app/Http/Controllers/Web/HomeController.php:128
      • 26. app/Http/Controllers/Web/HomeController.php:53
      • 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 * from `translations` where `translations`.`translationable_id` in (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, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 142, 143, 144) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
      750μsHomeController.php#128pustaklab
      Metadata
      Bindings
      • 0. App\Models\Category
      • 1. en
      Backtrace
      • 30. app/Http/Controllers/Web/HomeController.php:128
      • 31. app/Http/Controllers/Web/HomeController.php:53
      • 32. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 33. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 34. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `translations` where `translations`.`translationable_id` in (5, 6, 7, 8, 9, 37, 38, 39, 40, 41, 42, 43, 44, 45, 70, 71, 72, 73, 74, 75, 76, 97, 98, 99, 100) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
      440μsHomeController.php#128pustaklab
      Metadata
      Bindings
      • 0. App\Models\Category
      • 1. en
      Backtrace
      • 25. app/Http/Controllers/Web/HomeController.php:128
      • 26. app/Http/Controllers/Web/HomeController.php:53
      • 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 * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 64) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
      470μsHomeController.php#128pustaklab
      Metadata
      Bindings
      • 0. App\Models\Category
      • 1. en
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:128
      • 21. app/Http/Controllers/Web/HomeController.php:53
      • 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 `brands` where `status` = 1 limit 15
      420μsHomeController.php#129pustaklab
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:129
      • 16. app/Http/Controllers/Web/HomeController.php:53
      • 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 `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'
      430μsHomeController.php#129pustaklab
      Metadata
      Bindings
      • 0. App\Models\Brand
      • 1. en
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:129
      • 21. app/Http/Controllers/Web/HomeController.php:53
      • 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 `product_id`, COUNT(product_id) as count from `order_details` where exists (select * from `products` where (`order_details`.`product_id` = `products`.`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) 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 `status` = 1) group by `product_id` order by `count` desc limit 6
      1.95msHomeController.php#139pustaklab
      Metadata
      Bindings
      • 0. admin
      • 1. 1
      • 2. 1
      • 3. 1
      • 4. 1
      • 5. approved
      • 6. admin
      • 7. 1
      • 8. digital
      • 9. physical
      • 10. 1
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:139
      • 16. app/Http/Controllers/Web/HomeController.php:53
      • 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 `products` where `status` = 1 and `products`.`id` in (9)
      520μsHomeController.php#139pustaklab
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:139
      • 21. app/Http/Controllers/Web/HomeController.php:53
      • 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 `reviews` where `reviews`.`product_id` in (9) and `delivery_man_id` is null and `status` = 1
      380μsHomeController.php#139pustaklab
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 25. app/Http/Controllers/Web/HomeController.php:139
      • 26. app/Http/Controllers/Web/HomeController.php:53
      • 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 * from `translations` where `translations`.`translationable_id` in (9) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
      480μsHomeController.php#139pustaklab
      Metadata
      Bindings
      • 0. App\Models\Product
      • 1. en
      Backtrace
      • 25. app/Http/Controllers/Web/HomeController.php:139
      • 26. app/Http/Controllers/Web/HomeController.php:53
      • 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 `product_id`, AVG(rating) as count from `reviews` where exists (select * from `products` where (`reviews`.`product_id` = `products`.`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) 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 `status` = 1 group by `product_id` order by `count` desc limit 6
      1.81msHomeController.php#150pustaklab
      Metadata
      Bindings
      • 0. admin
      • 1. 1
      • 2. 1
      • 3. 1
      • 4. 1
      • 5. approved
      • 6. admin
      • 7. 1
      • 8. digital
      • 9. physical
      • 10. 1
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:150
      • 16. app/Http/Controllers/Web/HomeController.php:53
      • 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 `deal_of_the_days`.*, `products`.`unit_price` from `deal_of_the_days` inner join `products` on `products`.`id` = `deal_of_the_days`.`product_id` where `products`.`status` = 1 and `deal_of_the_days`.`status` = 1 limit 1
      450μsHomeController.php#160pustaklab
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      Backtrace
      • 16. app/Http/Controllers/Web/HomeController.php:160
      • 17. app/Http/Controllers/Web/HomeController.php:53
      • 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 `banners` where (`banner_type` = 'Main Banner' and `theme` = 'default' and `published` = 1) order by `created_at` desc
      410μsHomeController.php#161pustaklab
      Metadata
      Bindings
      • 0. Main Banner
      • 1. default
      • 2. 1
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:161
      • 16. app/Http/Controllers/Web/HomeController.php:53
      • 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 `banners` where (`banner_type` = 'Main Section Banner' and `theme` = 'default' and `published` = 1) order by `id` desc, `created_at` desc limit 1
      360μsHomeController.php#162pustaklab
      Metadata
      Bindings
      • 0. Main Section Banner
      • 1. default
      • 2. 1
      Backtrace
      • 16. app/Http/Controllers/Web/HomeController.php:162
      • 17. app/Http/Controllers/Web/HomeController.php:53
      • 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 `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) 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') order by RAND() limit 1
      8.21msHomeController.php#164pustaklab
      Metadata
      Bindings
      • 0. admin
      • 1. 1
      • 2. 1
      • 3. 1
      • 4. 1
      • 5. approved
      • 6. admin
      • 7. 1
      • 8. digital
      • 9. physical
      Backtrace
      • 16. app/Http/Controllers/Web/HomeController.php:164
      • 17. app/Http/Controllers/Web/HomeController.php:53
      • 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 `translations` where `translations`.`translationable_id` in (20) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
      480μsHomeController.php#164pustaklab
      Metadata
      Bindings
      • 0. App\Models\Product
      • 1. en
      Backtrace
      • 21. app/Http/Controllers/Web/HomeController.php:164
      • 22. app/Http/Controllers/Web/HomeController.php:53
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `reviews` where `reviews`.`product_id` in (20) and `delivery_man_id` is null and `status` = 1
      360μsHomeController.php#164pustaklab
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 21. app/Http/Controllers/Web/HomeController.php:164
      • 22. app/Http/Controllers/Web/HomeController.php:53
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `banners` where `banner_type` = 'Footer Banner' and `theme` = 'default' and `published` = 1 order by `id` desc
      360μsHomeController.php#165pustaklab
      Metadata
      Bindings
      • 0. Footer Banner
      • 1. default
      • 2. 1
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:165
      • 16. app/Http/Controllers/Web/HomeController.php:53
      • 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 `business_settings` where (`type` = 'currency_symbol_position') limit 1
      570μssettings.php#15pustaklab
      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 * from `business_settings` where (`type` = 'company_reliability') limit 1
      610μssettings.php#15pustaklab
      Metadata
      Bindings
      • 0. company_reliability
      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` = 'google_tag_manager_id') limit 1
      500μssettings.php#15pustaklab
      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
      410μssettings.php#15pustaklab
      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
      360μssettings.php#15pustaklab
      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` = 72838 and `is_guest` = 1) group by `cart_group_id`
      480μscart-manager.php#74pustaklab
      Metadata
      Bindings
      • 0. 72838
      • 1. 1
      Backtrace
      • 14. app/Utils/cart-manager.php:74
      • 15. app/Utils/cart-manager.php:43
      • 16. view::layouts.front-end.partials._cart:21
      • 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
      320μscart-manager.php#43pustaklab
      Metadata
      Backtrace
      • 15. app/Utils/cart-manager.php:43
      • 16. view::layouts.front-end.partials._cart:21
      • 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` = 72838 and `is_guest` = 1) group by `cart_group_id`
      450μscart-manager.php#74pustaklab
      Metadata
      Bindings
      • 0. 72838
      • 1. 1
      Backtrace
      • 14. app/Utils/cart-manager.php:74
      • 15. app/Utils/cart-manager.php:43
      • 16. view::layouts.front-end.partials._cart:31
      • 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
      290μscart-manager.php#43pustaklab
      Metadata
      Backtrace
      • 15. app/Utils/cart-manager.php:43
      • 16. view::layouts.front-end.partials._cart:31
      • 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 count(*) as aggregate from `categories` where `position` = 0
      410μs_header.blade.php#228pustaklab
      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
      460μs_header.blade.php#228pustaklab
      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, 3, 4, 64) order by `priority` asc
      570μs_header.blade.php#228pustaklab
      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 (5, 6, 7, 8, 9, 37, 38, 39, 40, 41, 42, 43, 44, 45, 70, 71, 72, 73, 74, 75, 76, 97, 98, 99, 100) order by `priority` asc
      760μs_header.blade.php#228pustaklab
      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 (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, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 142, 143, 144) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
      710μs_header.blade.php#228pustaklab
      Metadata
      Bindings
      • 0. App\Models\Category
      • 1. en
      Backtrace
      • 31. view::layouts.front-end.partials._header:228
      • 33. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 34. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 35. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 36. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `translations` where `translations`.`translationable_id` in (5, 6, 7, 8, 9, 37, 38, 39, 40, 41, 42, 43, 44, 45, 70, 71, 72, 73, 74, 75, 76, 97, 98, 99, 100) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
      470μs_header.blade.php#228pustaklab
      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, 3, 4, 64) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
      360μs_header.blade.php#228pustaklab
      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 ((`added_by` = 'admin') 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
      8.51msbrand-manager.php#31pustaklab
      Metadata
      Bindings
      • 0. admin
      • 1. 1
      • 2. 1
      • 3. 1
      • 4. 1
      • 5. approved
      • 6. admin
      • 7. 1
      • 8. digital
      • 9. physical
      • 10. 1
      Backtrace
      • 15. app/Utils/brand-manager.php:31
      • 16. view::layouts.front-end.partials._header:315
      • 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, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'
      550μsbrand-manager.php#31pustaklab
      Metadata
      Bindings
      • 0. App\Models\Brand
      • 1. en
      Backtrace
      • 20. app/Utils/brand-manager.php:31
      • 21. view::layouts.front-end.partials._header:315
      • 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 ((`added_by` = 'admin') 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') and `discount` != 0
      2.25ms_header.blade.php#342pustaklab
      Metadata
      Bindings
      • 0. admin
      • 1. 1
      • 2. 1
      • 3. 1
      • 4. 1
      • 5. approved
      • 6. admin
      • 7. 1
      • 8. digital
      • 9. physical
      • 10. 0
      Backtrace
      • 16. view::layouts.front-end.partials._header:342
      • 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` = 'loader_gif') limit 1
      560μssettings.php#15pustaklab
      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
      500μssettings.php#15pustaklab
      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-07' and date(`end_date`) >= '2025-01-07' limit 1
      420μs_footer.blade.php#104pustaklab
      Metadata
      Bindings
      • 0. 1
      • 1. flash_deal
      • 2. 2025-01-07
      • 3. 2025-01-07
      Backtrace
      • 16. view::layouts.front-end.partials._footer:104
      • 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
      390μssettings.php#15pustaklab
      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
      350μssettings.php#15pustaklab
      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
      370μssettings.php#15pustaklab
      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
      400μssettings.php#15pustaklab
      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
      300μssettings.php#15pustaklab
      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
      330μssettings.php#15pustaklab
      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
      440μssettings.php#15pustaklab
      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\Banner
    4
    App\Models\OrderDetail
    1
    App\Models\Brand
    43
    App\Models\Admin
    2
    App\Models\Product
    256
    App\Models\Category
    264
    App\Models\BusinessSetting
    20
        decimal_point_settings
        2
        product_brand
        1
        digital_product
        1
        business_mode
        single
        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 {#3661 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
        currency_code
        INR
        currency_symbol
        currency_exchange_rate
        60
        _token
        IA8s8J7V9P9xNMOjq6uXNu5xpvVy7huWLPazzQtP
        guest_id
        72838
        _flash
        array:2 [ "new" => [] "old" => [] ]
        _previous
        array:1 [ "url" => "https://pustaklab.in" ]
        company_name
        Pustaklab
        currency_symbol_position
        right
        company_email
        info@pustaklab.in
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:20 [ "cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6InptS0Z5Uis5a21ia0wxNC8wVWtFbkE9PSIsInZhbHVlIjoiSVpGMVBKRWZmaWYzUXQzRk9YZU5oN2ZsemJ2Tk84NG9YRGFaVjZ5WldkcFhzb2lHWnpqWXJ6U3QrV2UzRmdxam9zY3RjOVhiaDl6ODNCNTVyeC93VGYvekNyRDkreFBqTHB2d05RSkhGUjA4YzdEVThHcGNYRTRxZnBEeWFBL2ciLCJtYWMiOiJlOWUzZWUyOTMzMTg5NDRkZTcyYjRjMzEzNWZkZmViMzQyN2I4M2QzNzc0YmQyMjMyODkxOTllMmMyMWQ1MGU0IiwidGFnIjoiIn0%3D; 6valley1730651901_session=eyJpdiI6Ikp4SGxnUFZhcGV4M1BjWHpXQXhPN0E9PSIsInZhbHVlIjoiL2ErbjVKU1VmZ1pyMmdSNU5HMlpNNDMvK0R6MndXM1Q1LzI4OGI2RjQzMitkV3JnZHc1UlZJUXhhOG5VZ3ZxYmFaaFZhN2JndlZpV0g2YnV6VWZQVVJ0QlQxMXZNaUREakdkTkRlaWJMYzdrZ3FtVldjOUg4cGpOdlViY2k0OXciLCJtYWMiOiIxMzMyNGZlM2I4M2Q0MjZmY2E5YzViM2Y2ZTRlMDU4ZmI0NTM5NTU2ZGM3NTA0ZjU5NDBiNGQ0ZTg3MjExNDEwIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6InptS0Z5Uis5a21ia0wxNC8wVWtFbkE9PSIsInZhbHVlIjoiSVpGMVBKRWZmaWYzUXQzRk9YZU5oN2ZsemJ2Tk84NG9YRGFaVjZ5WldkcFhzb2lHWnpqWXJ6U3QrV2UzRmdxam9zY3RjO" ] "priority" => array:1 [ 0 => "u=0, i" ] "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 => "close" ] "x-forwarded-for" => array:1 [ 0 => "18.188.113.141" ] "x-real-ip" => array:1 [ 0 => "18.188.113.141" ] "x-forwarded-host" => array:1 [ 0 => "pustaklab.in" ] "host" => array:1 [ 0 => "pustaklab.in" ] ]
        request_server
        0 of 0
        array:59 [ "USER" => "pustaklab" "HOME" => "/home/pustaklab" "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6InptS0Z5Uis5a21ia0wxNC8wVWtFbkE9PSIsInZhbHVlIjoiSVpGMVBKRWZmaWYzUXQzRk9YZU5oN2ZsemJ2Tk84NG9YRGFaVjZ5WldkcFhzb2lHWnpqWXJ6U3QrV2UzRmdxam9zY3RjOVhiaDl6ODNCNTVyeC93VGYvekNyRDkreFBqTHB2d05RSkhGUjA4YzdEVThHcGNYRTRxZnBEeWFBL2ciLCJtYWMiOiJlOWUzZWUyOTMzMTg5NDRkZTcyYjRjMzEzNWZkZmViMzQyN2I4M2QzNzc0YmQyMjMyODkxOTllMmMyMWQ1MGU0IiwidGFnIjoiIn0%3D; 6valley1730651901_session=eyJpdiI6Ikp4SGxnUFZhcGV4M1BjWHpXQXhPN0E9PSIsInZhbHVlIjoiL2ErbjVKU1VmZ1pyMmdSNU5HMlpNNDMvK0R6MndXM1Q1LzI4OGI2RjQzMitkV3JnZHc1UlZJUXhhOG5VZ3ZxYmFaaFZhN2JndlZpV0g2YnV6VWZQVVJ0QlQxMXZNaUREakdkTkRlaWJMYzdrZ3FtVldjOUg4cGpOdlViY2k0OXciLCJtYWMiOiIxMzMyNGZlM2I4M2Q0MjZmY2E5YzViM2Y2ZTRlMDU4ZmI0NTM5NTU2ZGM3NTA0ZjU5NDBiNGQ0ZTg3MjExNDEwIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6InptS0Z5Uis5a21ia0wxNC8wVWtFbkE9PSIsInZhbHVlIjoiSVpGMVBKRWZmaWYzUXQzRk9YZU5oN2ZsemJ2Tk84NG9YRGFaVjZ5WldkcFhzb2lHWnpqWXJ6U3QrV2UzRmdxam9zY3RjO" "HTTP_PRIORITY" => "u=0, i" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "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_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "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_CONNECTION" => "close" "HTTP_X_FORWARDED_FOR" => "18.188.113.141" "HTTP_X_REAL_IP" => "18.188.113.141" "HTTP_X_FORWARDED_HOST" => "pustaklab.in" "PHP_VALUE" => """ \n error_log=/home/pustaklab/logs/php/error.log;\n memory_limit=512M;\n max_execution_time=60;\n max_input_time=60;\n max_input_vars=10000;\n post_max_size=64M;\n upload_max_filesize=64M;\n date.timezone=UTC;\n display_errors=off; """ "HTTPS" => "on" "MGT" => "1" "GEOIP_LONGITUDE" => "-71.1028" "GEOIP_LATITUDE" => "42.3646" "GEOIP_CITY_CONTINENT_CODE" => "NA" "GEOIP_POSTAL_CODE" => "02139" "GEOIP_CITY" => "Cambridge" "GEOIP_REGION" => "MA" "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" "HTTP_HOST" => "pustaklab.in" "SERVER_NAME" => "pustaklab.in" "SERVER_PORT" => "443" "SERVER_ADDR" => "127.0.0.1" "REMOTE_PORT" => "" "REMOTE_ADDR" => "18.188.113.141" "SERVER_SOFTWARE" => "nginx/1.26.0" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.0" "DOCUMENT_ROOT" => "/home/pustaklab/htdocs/pustaklab.in/public" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/" "SCRIPT_NAME" => "/index.php" "SCRIPT_FILENAME" => "/home/pustaklab/htdocs/pustaklab.in/public/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1736215700.3878 "REQUEST_TIME" => 1736215700 ]
        request_cookies
        0 of 0
        array:2 [ "XSRF-TOKEN" => "IA8s8J7V9P9xNMOjq6uXNu5xpvVy7huWLPazzQtP" "6valley1730651901_session" => "iZet2m66CDB19eLZZtyG11e9iXA3yyr2HNIt3OhP" ]
        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 => "Tue, 07 Jan 2025 02:08:20 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IlU4ZHNUOFlISHExcHQyWTZBUXJGRlE9PSIsInZhbHVlIjoid2ptUlkraHpWQWRHb1NSZGM5d1p5MlV5UTVuVjYxMFVCT0hXcWRnOEN2dndVYXNGUUdJN3pKWVJjUStGS0hjTW9CQ0RIZjJnamRxNWxzNzFKQXF2Szk0U1FRa1lNYjBCYjJRTzdQYUZCQXNrUDZwM05kWE43aFc0bnZRaVU4MDAiLCJtYWMiOiI3NjgxN2ViZjlkMTk0YTYzYmRiNzk5MWU1ODVjOTM2ZDY2MGEyYzFmNTliNDg3MDBiZmY4OGM1ZTQ4ZWM3ZjBhIiwidGFnIjoiIn0%3D; expires=Tue, 07 Jan 2025 03:08:20 GMT; Max-Age=3600; path=/XSRF-TOKEN=eyJpdiI6IlU4ZHNUOFlISHExcHQyWTZBUXJGRlE9PSIsInZhbHVlIjoid2ptUlkraHpWQWRHb1NSZGM5d1p5MlV5UTVuVjYxMFVCT0hXcWRnOEN2dndVYXNGUUdJN3pKWVJjUStGS0hjTW9CQ0RIZ" 1 => "6valley1730651901_session=eyJpdiI6ImhGeUd3ckl4UXp2NmlHWld3dVN3eFE9PSIsInZhbHVlIjoiWGRxWmFMYnYrY2FFYjJ0TmwxejZjUy9nQ0l5bEliTFNwdGpySUZSMnY0THdNRlo3V3BRb2hScE82ZWlqRVZ1UGErbFNGaUQ1VURUc0RnazBqdEU4UlJBcEZ5TGxrQ1ZRUTE2TFIxMFRYL0lNeDVML3VVZEdFT1JNSmE2RlFvUHgiLCJtYWMiOiJjYzVhYWViMjE3NGY5NDM1MjBkMjgyM2Q0MGQ2NTI5ODUxZjgyMzdlMzRkZDc2MzMxNjM4YWM1Y2ZjNTYyNWM4IiwidGFnIjoiIn0%3D; expires=Tue, 07 Jan 2025 03:08:20 GMT; Max-Age=3600; path=/; httponly6valley1730651901_session=eyJpdiI6ImhGeUd3ckl4UXp2NmlHWld3dVN3eFE9PSIsInZhbHVlIjoiWGRxWmFMYnYrY2FFYjJ0TmwxejZjUy9nQ0l5bEliTFNwdGpySUZSMnY0THdNRlo3V3BRb2hScE82ZW" 2 => "popup_banner=eyJpdiI6InlvMXUwZ3M2ZTZNeHcxNTVRZkFGYXc9PSIsInZhbHVlIjoibXhSend5czg4OWdzbkYwYmJsZGszMUpFM2ViemNGWmxpaGJzQUFsSEZaRXhoNkNIcjBwelV0SmR4MUh3Kyt5RyIsIm1hYyI6ImQ1YzNlYTRmNzI4YmY0ZjI5YzM5MzdjOTE5YzRkYzVjZjYzOGM0OGM5YzIyNzM2YzNiZmUzZDI4MDI1ZmI5MWMiLCJ0YWciOiIifQ%3D%3D; expires=Tue, 07 Jan 2025 02:09:20 GMT; Max-Age=60; path=/; httponlypopup_banner=eyJpdiI6InlvMXUwZ3M2ZTZNeHcxNTVRZkFGYXc9PSIsInZhbHVlIjoibXhSend5czg4OWdzbkYwYmJsZGszMUpFM2ViemNGWmxpaGJzQUFsSEZaRXhoNkNIcjBwelV0SmR4MUh3Kyt5RyIsIm1" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IlU4ZHNUOFlISHExcHQyWTZBUXJGRlE9PSIsInZhbHVlIjoid2ptUlkraHpWQWRHb1NSZGM5d1p5MlV5UTVuVjYxMFVCT0hXcWRnOEN2dndVYXNGUUdJN3pKWVJjUStGS0hjTW9CQ0RIZjJnamRxNWxzNzFKQXF2Szk0U1FRa1lNYjBCYjJRTzdQYUZCQXNrUDZwM05kWE43aFc0bnZRaVU4MDAiLCJtYWMiOiI3NjgxN2ViZjlkMTk0YTYzYmRiNzk5MWU1ODVjOTM2ZDY2MGEyYzFmNTliNDg3MDBiZmY4OGM1ZTQ4ZWM3ZjBhIiwidGFnIjoiIn0%3D; expires=Tue, 07-Jan-2025 03:08:20 GMT; path=/XSRF-TOKEN=eyJpdiI6IlU4ZHNUOFlISHExcHQyWTZBUXJGRlE9PSIsInZhbHVlIjoid2ptUlkraHpWQWRHb1NSZGM5d1p5MlV5UTVuVjYxMFVCT0hXcWRnOEN2dndVYXNGUUdJN3pKWVJjUStGS0hjTW9CQ0RIZ" 1 => "6valley1730651901_session=eyJpdiI6ImhGeUd3ckl4UXp2NmlHWld3dVN3eFE9PSIsInZhbHVlIjoiWGRxWmFMYnYrY2FFYjJ0TmwxejZjUy9nQ0l5bEliTFNwdGpySUZSMnY0THdNRlo3V3BRb2hScE82ZWlqRVZ1UGErbFNGaUQ1VURUc0RnazBqdEU4UlJBcEZ5TGxrQ1ZRUTE2TFIxMFRYL0lNeDVML3VVZEdFT1JNSmE2RlFvUHgiLCJtYWMiOiJjYzVhYWViMjE3NGY5NDM1MjBkMjgyM2Q0MGQ2NTI5ODUxZjgyMzdlMzRkZDc2MzMxNjM4YWM1Y2ZjNTYyNWM4IiwidGFnIjoiIn0%3D; expires=Tue, 07-Jan-2025 03:08:20 GMT; path=/; httponly6valley1730651901_session=eyJpdiI6ImhGeUd3ckl4UXp2NmlHWld3dVN3eFE9PSIsInZhbHVlIjoiWGRxWmFMYnYrY2FFYjJ0TmwxejZjUy9nQ0l5bEliTFNwdGpySUZSMnY0THdNRlo3V3BRb2hScE82ZW" 2 => "popup_banner=eyJpdiI6InlvMXUwZ3M2ZTZNeHcxNTVRZkFGYXc9PSIsInZhbHVlIjoibXhSend5czg4OWdzbkYwYmJsZGszMUpFM2ViemNGWmxpaGJzQUFsSEZaRXhoNkNIcjBwelV0SmR4MUh3Kyt5RyIsIm1hYyI6ImQ1YzNlYTRmNzI4YmY0ZjI5YzM5MzdjOTE5YzRkYzVjZjYzOGM0OGM5YzIyNzM2YzNiZmUzZDI4MDI1ZmI5MWMiLCJ0YWciOiIifQ%3D%3D; expires=Tue, 07-Jan-2025 02:09:20 GMT; path=/; httponlypopup_banner=eyJpdiI6InlvMXUwZ3M2ZTZNeHcxNTVRZkFGYXc9PSIsInZhbHVlIjoibXhSend5czg4OWdzbkYwYmJsZGszMUpFM2ViemNGWmxpaGJzQUFsSEZaRXhoNkNIcjBwelV0SmR4MUh3Kyt5RyIsIm1" ] ]
        session_attributes
        0 of 0
        array:21 [ "decimal_point_settings" => 2 "product_brand" => 1 "digital_product" => 1 "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 {#3661 #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" => "IA8s8J7V9P9xNMOjq6uXNu5xpvVy7huWLPazzQtP" "guest_id" => 72838 "_flash" => array:2 [ "new" => [] "old" => [] ] "_previous" => array:1 [ "url" => "https://pustaklab.in" ] "company_name" => "Pustaklab" "currency_symbol_position" => "right" "company_email" => "info@pustaklab.in" "PHPDEBUGBAR_STACK_DATA" => [] ]