Top-rated Products
137 Items found
Top
8.2.19PHP Version822msRequest Duration34MBMemory UsageGET productsRoute
    • Booting (201ms)time
    • Application (621ms)time
    • 1 x Application (75.53%)
      621ms
      1 x Booting (24.47%)
      201ms
      27 templates were rendered
      • web-views.products.viewview.blade.phpblade
      • web-views.products._ajax-products_ajax-products.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • pagination::bootstrap-4bootstrap-4.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
      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
      57 statements were executed, 15 of which were duplicates, 42 unique. Show only duplicated61.19ms
      • select * from `business_settings` where (`type` = 'business_mode') limit 1
        910μsshankar_betasettings.php#15
        Bindings
        • 0: business_mode
        Backtrace
        • 16. app/Utils/settings.php:15
        • 26. app/Http/Controllers/Web/ProductListController.php:40
        • 27. app/Http/Controllers/Web/ProductListController.php:29
        • 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select `product_id`, AVG(rating) as count from `reviews` where `status` = 1 group by `product_id` order by `count` desc
        850μsshankar_betaProductListController.php#69
        Bindings
        • 0: 1
        Backtrace
        • 15. app/Http/Controllers/Web/ProductListController.php:69
        • 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 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 ('physical') and exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `status` = 1) and `id` in (218, 134, 222, 215, 133, 239, 137, 248, 72, 186, 102, 202, 92, 220, 231, 112, 86, 118, 260, 111, 245, 157, 91, 16, 56, 66, 68, 70, 71, 75, 81, 82, 87, 95, 97, 109, 115, 122, 123, 128, 129, 135, 136, 149, 150, 154, 163, 165, 167, 170, 173, 175, 176, 183, 187, 189, 191, 193, 198, 199, 200, 206, 212, 216, 230, 237, 243, 247, 249, 251, 253, 254, 256, 257, 258, 25, 33, 223, 188, 240, 73, 12, 28, 31, 49, 1, 203, 217, 146, 78, 252, 210, 138, 192, 108, 224, 77, 101, 127, 57, 172, 162, 67, 59, 130, 85, 144, 151, 152, 211, 5, 18, 79, 246, 61, 181, 244, 2, 4, 6, 15, 20, 21, 22, 27, 40, 42, 43, 8, 14, 29, 30, 35, 37, 46, 47, 50, 205, 242, 214, 180, 185, 235, 142, 229, 58, 64, 103, 234, 93, 105, 195, 126, 156, 7, 62, 74, 76, 83, 84, 89, 96, 98, 99, 100, 104, 106, 107, 113, 125, 132, 139, 140, 145, 147, 153, 160, 164, 174, 178, 194, 196, 197, 221, 228, 250, 3, 10, 19, 23, 36, 38, 41, 45, 48, 51, 53, 54, 9, 13, 39, 44, 55, 11, 26, 32, 52, 17, 24, 34)
        2.71msshankar_betaProductListController.php#180
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: approved
        • 6: admin
        • 7: 1
        • 8: physical
        • 9: 1
        • 10: 218
        • 11: 134
        • 12: 222
        • 13: 215
        • 14: 133
        • 15: 239
        • 16: 137
        • 17: 248
        • 18: 72
        • 19: 186
        • 20: 102
        • 21: 202
        • 22: 92
        • 23: 220
        • 24: 231
        • 25: 112
        • 26: 86
        • 27: 118
        • 28: 260
        • 29: 111
        • 30: 245
        • 31: 157
        • 32: 91
        • 33: 16
        • 34: 56
        • 35: 66
        • 36: 68
        • 37: 70
        • 38: 71
        • 39: 75
        • 40: 81
        • 41: 82
        • 42: 87
        • 43: 95
        • 44: 97
        • 45: 109
        • 46: 115
        • 47: 122
        • 48: 123
        • 49: 128
        • 50: 129
        • 51: 135
        • 52: 136
        • 53: 149
        • 54: 150
        • 55: 154
        • 56: 163
        • 57: 165
        • 58: 167
        • 59: 170
        • 60: 173
        • 61: 175
        • 62: 176
        • 63: 183
        • 64: 187
        • 65: 189
        • 66: 191
        • 67: 193
        • 68: 198
        • 69: 199
        • 70: 200
        • 71: 206
        • 72: 212
        • 73: 216
        • 74: 230
        • 75: 237
        • 76: 243
        • 77: 247
        • 78: 249
        • 79: 251
        • 80: 253
        • 81: 254
        • 82: 256
        • 83: 257
        • 84: 258
        • 85: 25
        • 86: 33
        • 87: 223
        • 88: 188
        • 89: 240
        • 90: 73
        • 91: 12
        • 92: 28
        • 93: 31
        • 94: 49
        • 95: 1
        • 96: 203
        • 97: 217
        • 98: 146
        • 99: 78
        • 100: 252
        • 101: 210
        • 102: 138
        • 103: 192
        • 104: 108
        • 105: 224
        • 106: 77
        • 107: 101
        • 108: 127
        • 109: 57
        • 110: 172
        • 111: 162
        • 112: 67
        • 113: 59
        • 114: 130
        • 115: 85
        • 116: 144
        • 117: 151
        • 118: 152
        • 119: 211
        • 120: 5
        • 121: 18
        • 122: 79
        • 123: 246
        • 124: 61
        • 125: 181
        • 126: 244
        • 127: 2
        • 128: 4
        • 129: 6
        • 130: 15
        • 131: 20
        • 132: 21
        • 133: 22
        • 134: 27
        • 135: 40
        • 136: 42
        • 137: 43
        • 138: 8
        • 139: 14
        • 140: 29
        • 141: 30
        • 142: 35
        • 143: 37
        • 144: 46
        • 145: 47
        • 146: 50
        • 147: 205
        • 148: 242
        • 149: 214
        • 150: 180
        • 151: 185
        • 152: 235
        • 153: 142
        • 154: 229
        • 155: 58
        • 156: 64
        • 157: 103
        • 158: 234
        • 159: 93
        • 160: 105
        • 161: 195
        • 162: 126
        • 163: 156
        • 164: 7
        • 165: 62
        • 166: 74
        • 167: 76
        • 168: 83
        • 169: 84
        • 170: 89
        • 171: 96
        • 172: 98
        • 173: 99
        • 174: 100
        • 175: 104
        • 176: 106
        • 177: 107
        • 178: 113
        • 179: 125
        • 180: 132
        • 181: 139
        • 182: 140
        • 183: 145
        • 184: 147
        • 185: 153
        • 186: 160
        • 187: 164
        • 188: 174
        • 189: 178
        • 190: 194
        • 191: 196
        • 192: 197
        • 193: 221
        • 194: 228
        • 195: 250
        • 196: 3
        • 197: 10
        • 198: 19
        • 199: 23
        • 200: 36
        • 201: 38
        • 202: 41
        • 203: 45
        • 204: 48
        • 205: 51
        • 206: 53
        • 207: 54
        • 208: 9
        • 209: 13
        • 210: 39
        • 211: 44
        • 212: 55
        • 213: 11
        • 214: 26
        • 215: 32
        • 216: 52
        • 217: 17
        • 218: 24
        • 219: 34
        Backtrace
        • 16. app/Http/Controllers/Web/ProductListController.php:180
        • 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 `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null 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 ('physical') and exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `status` = 1) and `id` in (218, 134, 222, 215, 133, 239, 137, 248, 72, 186, 102, 202, 92, 220, 231, 112, 86, 118, 260, 111, 245, 157, 91, 16, 56, 66, 68, 70, 71, 75, 81, 82, 87, 95, 97, 109, 115, 122, 123, 128, 129, 135, 136, 149, 150, 154, 163, 165, 167, 170, 173, 175, 176, 183, 187, 189, 191, 193, 198, 199, 200, 206, 212, 216, 230, 237, 243, 247, 249, 251, 253, 254, 256, 257, 258, 25, 33, 223, 188, 240, 73, 12, 28, 31, 49, 1, 203, 217, 146, 78, 252, 210, 138, 192, 108, 224, 77, 101, 127, 57, 172, 162, 67, 59, 130, 85, 144, 151, 152, 211, 5, 18, 79, 246, 61, 181, 244, 2, 4, 6, 15, 20, 21, 22, 27, 40, 42, 43, 8, 14, 29, 30, 35, 37, 46, 47, 50, 205, 242, 214, 180, 185, 235, 142, 229, 58, 64, 103, 234, 93, 105, 195, 126, 156, 7, 62, 74, 76, 83, 84, 89, 96, 98, 99, 100, 104, 106, 107, 113, 125, 132, 139, 140, 145, 147, 153, 160, 164, 174, 178, 194, 196, 197, 221, 228, 250, 3, 10, 19, 23, 36, 38, 41, 45, 48, 51, 53, 54, 9, 13, 39, 44, 55, 11, 26, 32, 52, 17, 24, 34) order by `created_at` desc limit 20 offset 120
        6.44msshankar_betaProductListController.php#180
        Bindings
        • 0: 1
        • 1: admin
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: approved
        • 7: admin
        • 8: 1
        • 9: physical
        • 10: 1
        • 11: 218
        • 12: 134
        • 13: 222
        • 14: 215
        • 15: 133
        • 16: 239
        • 17: 137
        • 18: 248
        • 19: 72
        • 20: 186
        • 21: 102
        • 22: 202
        • 23: 92
        • 24: 220
        • 25: 231
        • 26: 112
        • 27: 86
        • 28: 118
        • 29: 260
        • 30: 111
        • 31: 245
        • 32: 157
        • 33: 91
        • 34: 16
        • 35: 56
        • 36: 66
        • 37: 68
        • 38: 70
        • 39: 71
        • 40: 75
        • 41: 81
        • 42: 82
        • 43: 87
        • 44: 95
        • 45: 97
        • 46: 109
        • 47: 115
        • 48: 122
        • 49: 123
        • 50: 128
        • 51: 129
        • 52: 135
        • 53: 136
        • 54: 149
        • 55: 150
        • 56: 154
        • 57: 163
        • 58: 165
        • 59: 167
        • 60: 170
        • 61: 173
        • 62: 175
        • 63: 176
        • 64: 183
        • 65: 187
        • 66: 189
        • 67: 191
        • 68: 193
        • 69: 198
        • 70: 199
        • 71: 200
        • 72: 206
        • 73: 212
        • 74: 216
        • 75: 230
        • 76: 237
        • 77: 243
        • 78: 247
        • 79: 249
        • 80: 251
        • 81: 253
        • 82: 254
        • 83: 256
        • 84: 257
        • 85: 258
        • 86: 25
        • 87: 33
        • 88: 223
        • 89: 188
        • 90: 240
        • 91: 73
        • 92: 12
        • 93: 28
        • 94: 31
        • 95: 49
        • 96: 1
        • 97: 203
        • 98: 217
        • 99: 146
        • 100: 78
        • 101: 252
        • 102: 210
        • 103: 138
        • 104: 192
        • 105: 108
        • 106: 224
        • 107: 77
        • 108: 101
        • 109: 127
        • 110: 57
        • 111: 172
        • 112: 162
        • 113: 67
        • 114: 59
        • 115: 130
        • 116: 85
        • 117: 144
        • 118: 151
        • 119: 152
        • 120: 211
        • 121: 5
        • 122: 18
        • 123: 79
        • 124: 246
        • 125: 61
        • 126: 181
        • 127: 244
        • 128: 2
        • 129: 4
        • 130: 6
        • 131: 15
        • 132: 20
        • 133: 21
        • 134: 22
        • 135: 27
        • 136: 40
        • 137: 42
        • 138: 43
        • 139: 8
        • 140: 14
        • 141: 29
        • 142: 30
        • 143: 35
        • 144: 37
        • 145: 46
        • 146: 47
        • 147: 50
        • 148: 205
        • 149: 242
        • 150: 214
        • 151: 180
        • 152: 185
        • 153: 235
        • 154: 142
        • 155: 229
        • 156: 58
        • 157: 64
        • 158: 103
        • 159: 234
        • 160: 93
        • 161: 105
        • 162: 195
        • 163: 126
        • 164: 156
        • 165: 7
        • 166: 62
        • 167: 74
        • 168: 76
        • 169: 83
        • 170: 84
        • 171: 89
        • 172: 96
        • 173: 98
        • 174: 99
        • 175: 100
        • 176: 104
        • 177: 106
        • 178: 107
        • 179: 113
        • 180: 125
        • 181: 132
        • 182: 139
        • 183: 140
        • 184: 145
        • 185: 147
        • 186: 153
        • 187: 160
        • 188: 164
        • 189: 174
        • 190: 178
        • 191: 194
        • 192: 196
        • 193: 197
        • 194: 221
        • 195: 228
        • 196: 250
        • 197: 3
        • 198: 10
        • 199: 19
        • 200: 23
        • 201: 36
        • 202: 38
        • 203: 41
        • 204: 45
        • 205: 48
        • 206: 51
        • 207: 53
        • 208: 54
        • 209: 9
        • 210: 13
        • 211: 39
        • 212: 44
        • 213: 55
        • 214: 11
        • 215: 26
        • 216: 32
        • 217: 52
        • 218: 17
        • 219: 24
        • 220: 34
        Backtrace
        • 16. app/Http/Controllers/Web/ProductListController.php:180
        • 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 `reviews` where `reviews`.`product_id` in (1, 237, 240, 242, 243, 244, 245, 246, 247, 248, 250, 251, 252, 254, 256, 257, 258) and `delivery_man_id` is null and `status` = 1
        940μsshankar_betaProductListController.php#180
        Bindings
        • 0: 1
        Backtrace
        • 21. app/Http/Controllers/Web/ProductListController.php:180
        • 22. app/Http/Controllers/Web/ProductListController.php:29
        • 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 `translations` where `translations`.`translationable_id` in (1, 237, 240, 242, 243, 244, 245, 246, 247, 248, 250, 251, 252, 254, 256, 257, 258) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
        840μsshankar_betaProductListController.php#180
        Bindings
        • 0: App\Models\Product
        • 1: en
        Backtrace
        • 21. app/Http/Controllers/Web/ProductListController.php:180
        • 22. app/Http/Controllers/Web/ProductListController.php:29
        • 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 `business_settings` where (`type` = 'business_mode') limit 1
        1.06msshankar_betasettings.php#15
        Bindings
        • 0: business_mode
        Backtrace
        • 16. app/Utils/settings.php:15
        • 26. app/Models/Brand.php:42
        • 32. app/Utils/brand-manager.php:33
        • 33. view::web-views.products.view:228
        • 35. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • select * from `business_settings` where (`type` = 'business_mode') limit 1
        720μsshankar_betasettings.php#15
        Bindings
        • 0: business_mode
        Backtrace
        • 16. app/Utils/settings.php:15
        • 26. app/Models/Brand.php:42
        • 34. app/Utils/brand-manager.php:33
        • 35. view::web-views.products.view:228
        • 37. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 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 ('physical')) as `brand_products_count` from `brands` where `status` = 1 and exists (select *, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where `brands`.`id` = `products`.`brand_id` and exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `status` = 1) 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 ('physical')) order by `created_at` desc
        2.07msshankar_betabrand-manager.php#35
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: approved
        • 6: admin
        • 7: 1
        • 8: physical
        • 9: 1
        • 10: 1
        • 11: 1
        • 12: admin
        • 13: 1
        • 14: 1
        • 15: 1
        • 16: 1
        • 17: approved
        • 18: admin
        • 19: 1
        • 20: physical
        Backtrace
        • 15. app/Utils/brand-manager.php:35
        • 16. view::web-views.products.view: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
      • select * from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'
        540μsshankar_betabrand-manager.php#35
        Bindings
        • 0: App\Models\Brand
        • 1: en
        Backtrace
        • 20. app/Utils/brand-manager.php:35
        • 21. view::web-views.products.view: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
      • select * from `categories` where `position` = 0 and `status` = 1 order by `priority` asc
        2.01msshankar_betacategory-manager.php#13
        Bindings
        • 0: 0
        • 1: 1
        Backtrace
        • 15. app/Utils/category-manager.php:13
        • 16. view::web-views.products.view:257
        • 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, 3, 4, 5, 6, 7, 8) order by `priority` asc
        740μsshankar_betacategory-manager.php#13
        Backtrace
        • 20. app/Utils/category-manager.php:13
        • 21. view::web-views.products.view:257
        • 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 (15) order by `priority` asc
        1.26msshankar_betacategory-manager.php#13
        Backtrace
        • 25. app/Utils/category-manager.php:13
        • 26. view::web-views.products.view:257
        • 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 (16) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
        320μsshankar_betacategory-manager.php#13
        Bindings
        • 0: App\Models\Category
        • 1: en
        Backtrace
        • 30. app/Utils/category-manager.php:13
        • 31. view::web-views.products.view:257
        • 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
      • select * from `translations` where `translations`.`translationable_id` in (15) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
        1.27msshankar_betacategory-manager.php#13
        Bindings
        • 0: App\Models\Category
        • 1: en
        Backtrace
        • 25. app/Utils/category-manager.php:13
        • 26. view::web-views.products.view:257
        • 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, 3, 4, 5, 6, 7, 8) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
        700μsshankar_betacategory-manager.php#13
        Bindings
        • 0: App\Models\Category
        • 1: en
        Backtrace
        • 20. app/Utils/category-manager.php:13
        • 21. view::web-views.products.view:257
        • 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` = 'currency_symbol_position') limit 1
        370μsshankar_betasettings.php#15
        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` = 'google_tag_manager_id') limit 1
        1.06msshankar_betasettings.php#15
        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
        2.61msshankar_betasettings.php#15
        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 `shipping_addresses` where `id` is null limit 1
        320μsshankar_beta_modals.blade.php#34
        Backtrace
        • 16. view::layouts.front-end.partials._modals:34
        • 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 `countries`
        410μsshankar_beta_modals.blade.php#102
        Backtrace
        • 16. view::layouts.front-end.partials._modals:102
        • 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 `states` where `country_id` = 101 order by `name` asc
        420μsshankar_beta_modals.blade.php#115
        Bindings
        • 0: 101
        Backtrace
        • 15. view::layouts.front-end.partials._modals:115
        • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 20. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `cities` where `state_id` is null order by `name` asc
        2msshankar_beta_modals.blade.php#132
        Backtrace
        • 15. view::layouts.front-end.partials._modals:132
        • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 20. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'map_api_key') limit 1
        410μsshankar_betasettings.php#15
        Bindings
        • 0: map_api_key
        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
        710μsshankar_betasettings.php#15
        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` = 0 and `is_guest` = 1) group by `cart_group_id`
        500μsshankar_betacart-manager.php#87
        Bindings
        • 0: 0
        • 1: 1
        Backtrace
        • 14. app/Utils/cart-manager.php:87
        • 15. app/Utils/cart-manager.php:47
        • 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 exists (select *, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where `carts`.`product_id` = `products`.`id` and exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `status` = 1) and `status` = 1) and `cart_group_id` in ('guest-6MjsR-1716359425')
        630μsshankar_betacart-manager.php#47
        Bindings
        • 0: 1
        • 1: 1
        • 2: 1
        • 3: guest-6MjsR-1716359425
        Backtrace
        • 15. app/Utils/cart-manager.php:47
        • 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` = 0 and `is_guest` = 1) group by `cart_group_id`
        770μsshankar_betacart-manager.php#87
        Bindings
        • 0: 0
        • 1: 1
        Backtrace
        • 14. app/Utils/cart-manager.php:87
        • 15. app/Utils/cart-manager.php:47
        • 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 exists (select *, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where `carts`.`product_id` = `products`.`id` and exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `status` = 1) and `status` = 1) and `cart_group_id` in ('guest-6MjsR-1716359425')
        1.03msshankar_betacart-manager.php#47
        Bindings
        • 0: 1
        • 1: 1
        • 2: 1
        • 3: guest-6MjsR-1716359425
        Backtrace
        • 15. app/Utils/cart-manager.php:47
        • 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 `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where `products`.`id` = 15 limit 1
        1.29msshankar_beta_cart.blade.php#73
        Bindings
        • 0: 1
        • 1: 15
        Backtrace
        • 20. view::layouts.front-end.partials._cart:73
        • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 25. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `translations` where `translations`.`translationable_id` in (15) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
        1.52msshankar_beta_cart.blade.php#73
        Bindings
        • 0: App\Models\Product
        • 1: en
        Backtrace
        • 25. view::layouts.front-end.partials._cart:73
        • 27. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 28. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 29. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 30. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `reviews` where `reviews`.`product_id` in (15) and `delivery_man_id` is null and `status` = 1
        1.21msshankar_beta_cart.blade.php#73
        Bindings
        • 0: 1
        Backtrace
        • 25. view::layouts.front-end.partials._cart:73
        • 27. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 28. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 29. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 30. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where `products`.`id` = 1 limit 1
        1.45msshankar_beta_cart.blade.php#73
        Bindings
        • 0: 1
        • 1: 1
        Backtrace
        • 20. view::layouts.front-end.partials._cart:73
        • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 25. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
        960μsshankar_beta_cart.blade.php#73
        Bindings
        • 0: App\Models\Product
        • 1: en
        Backtrace
        • 25. view::layouts.front-end.partials._cart:73
        • 27. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 28. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 29. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 30. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `reviews` where `reviews`.`product_id` in (1) and `delivery_man_id` is null and `status` = 1
        580μsshankar_beta_cart.blade.php#73
        Bindings
        • 0: 1
        Backtrace
        • 25. view::layouts.front-end.partials._cart:73
        • 27. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 28. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 29. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 30. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'free_delivery_status') limit 1
        1.16msshankar_betahelpers.php#167
        Bindings
        • 0: free_delivery_status
        Backtrace
        • 16. app/Utils/helpers.php:167
        • 17. app/Utils/order-manager.php:1206
        • 18. view::layouts.front-end.partials._cart:162
        • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select * from `business_settings` where (`type` = 'free_delivery_responsibility') limit 1
        650μsshankar_betahelpers.php#167
        Bindings
        • 0: free_delivery_responsibility
        Backtrace
        • 16. app/Utils/helpers.php:167
        • 17. app/Utils/order-manager.php:1207
        • 18. view::layouts.front-end.partials._cart:162
        • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select * from `business_settings` where (`type` = 'free_delivery_over_amount') limit 1
        270μsshankar_betahelpers.php#167
        Bindings
        • 0: free_delivery_over_amount
        Backtrace
        • 16. app/Utils/helpers.php:167
        • 17. app/Utils/order-manager.php:1208
        • 18. view::layouts.front-end.partials._cart:162
        • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select * from `business_settings` where (`type` = 'free_delivery_over_amount_seller') limit 1
        920μsshankar_betahelpers.php#167
        Bindings
        • 0: free_delivery_over_amount_seller
        Backtrace
        • 16. app/Utils/helpers.php:167
        • 17. app/Utils/order-manager.php:1209
        • 18. view::layouts.front-end.partials._cart:162
        • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select count(*) as aggregate from `categories` where `position` = 0 and `status` = 1
        1.51msshankar_beta_header.blade.php#257
        Bindings
        • 0: 0
        • 1: 1
        Backtrace
        • 16. view::layouts.front-end.partials._header:257
        • 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 and `status` = 1 order by `priority` asc limit 11 offset 66
        1.22msshankar_beta_header.blade.php#257
        Bindings
        • 0: 0
        • 1: 1
        Backtrace
        • 16. view::layouts.front-end.partials._header:257
        • 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` = 'business_mode') limit 1
        1.15msshankar_betasettings.php#15
        Bindings
        • 0: business_mode
        Backtrace
        • 16. app/Utils/settings.php:15
        • 26. app/Models/Brand.php:42
        • 32. app/Utils/brand-manager.php:33
        • 33. view::layouts.front-end.partials._header:344
        • 35. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • select * from `business_settings` where (`type` = 'business_mode') limit 1
        1.42msshankar_betasettings.php#15
        Bindings
        • 0: business_mode
        Backtrace
        • 16. app/Utils/settings.php:15
        • 26. app/Models/Brand.php:42
        • 34. app/Utils/brand-manager.php:33
        • 35. view::layouts.front-end.partials._header:344
        • 37. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 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 ('physical')) as `brand_products_count` from `brands` where `status` = 1 and exists (select *, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where `brands`.`id` = `products`.`brand_id` and exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `status` = 1) 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 ('physical')) order by `created_at` desc
        1.4msshankar_betabrand-manager.php#35
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: approved
        • 6: admin
        • 7: 1
        • 8: physical
        • 9: 1
        • 10: 1
        • 11: 1
        • 12: admin
        • 13: 1
        • 14: 1
        • 15: 1
        • 16: 1
        • 17: approved
        • 18: admin
        • 19: 1
        • 20: physical
        Backtrace
        • 15. app/Utils/brand-manager.php:35
        • 16. view::layouts.front-end.partials._header:344
        • 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) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'
        880μsshankar_betabrand-manager.php#35
        Bindings
        • 0: App\Models\Brand
        • 1: en
        Backtrace
        • 20. app/Utils/brand-manager.php:35
        • 21. view::layouts.front-end.partials._header:344
        • 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` = 'business_mode') limit 1
        810μsshankar_betasettings.php#15
        Bindings
        • 0: business_mode
        Backtrace
        • 16. app/Utils/settings.php:15
        • 23. view::layouts.front-end.partials._header:371
        • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 27. 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 ('physical') and `discount` != 0
        1.56msshankar_beta_header.blade.php#371
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: approved
        • 6: admin
        • 7: 1
        • 8: physical
        • 9: 0
        Backtrace
        • 16. view::layouts.front-end.partials._header:371
        • 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` = 'business_mode') limit 1
        320μsshankar_betasettings.php#15
        Bindings
        • 0: business_mode
        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
        570μsshankar_betasettings.php#15
        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 `flash_deals` where exists (select * from `flash_deal_products` where `flash_deals`.`id` = `flash_deal_products`.`flash_deal_id` and exists (select *, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where `flash_deal_products`.`product_id` = `products`.`id` and exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `status` = 1))) and (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-07-11' and date(`end_date`) >= '2025-07-11' limit 1
        910μsshankar_beta_footer.blade.php#105
        Bindings
        • 0: 1
        • 1: 1
        • 2: 1
        • 3: flash_deal
        • 4: 2025-07-11
        • 5: 2025-07-11
        Backtrace
        • 16. view::layouts.front-end.partials._footer:105
        • 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
        1.1msshankar_betasettings.php#15
        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
        410μsshankar_betasettings.php#15
        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
        900μsshankar_betasettings.php#15
        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
        490μsshankar_betasettings.php#15
        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
        350μsshankar_betasettings.php#15
        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
        620μsshankar_betasettings.php#15
        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
        940μsshankar_betasettings.php#15
        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\Review
      251
      App\Models\State
      36
      App\Models\BusinessSetting
      22
      App\Models\Product
      19
      App\Models\Category
      10
      App\Models\Cart
      4
      App\Models\Brand
      2
      App\Models\Country
      1
          decimal_point_settings
          0
          product_brand
          1
          digital_product
          0
          currency_model
          single_currency
          language
          array:2 [ 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 {#3674 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
          currency_code
          INR
          currency_symbol
          currency_exchange_rate
          60
          _token
          ZxJkoqHMN2fw6z2Ebk4Wt0148mQcZj337WDl8wWs
          currency_symbol_position
          left
          company_email
          info@shankarmasala.com
          _previous
          array:1 [ "url" => "https://shankar-beta.mydemoapp.us/products?data_from=top-rated&page=7&page_no=...
          _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" => "top-rated" "page" => "7" "page_no" => "6" ]
          request_request
          []
          
          request_headers
          0 of 0
          array:15 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "shankar-beta.mydemoapp.us" ] ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Fri, 11 Jul 2025 03:03:56 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InRUc0g4VFNwNlo1VzJMUHF1Y0Rwb1E9PSIsInZhbHVlIjoiY3BFOC84VHN3ZkkwUUErZ3lkMzBlK2orcDBTdWcyei9DZEVvUFdxNGtDWDVrK1JZbFM2RmNmWVVaWmxIaExsdkFTMWc3cVdSVGdZS244QmRob0xDR0NPRmZwTHl3dndsWTBZa1d5dFJDbG5rMHJVRjZGVWNTbVBtVlhxbU5TTmMiLCJtYWMiOiJjOTJiMTY2ZjRiMzNiMjg3YjIxNjM2YjRmZmQ2MWRlMTM0YjgxMzVjYjM5ZWFjM2IwMGNiOGU2ZTM0ZjgyMDI3IiwidGFnIjoiIn0%3D; expires=Fri, 11 Jul 2025 05:03:56 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6InRUc0g4VFNwNlo1VzJMUHF1Y0Rwb1E9PSIsInZhbHVlIjoiY3BFOC84VHN3ZkkwUUErZ3lkMzBlK2orcDBTdWcyei9DZEVvUFdxNGtDWDVrK1JZbFM2RmNmWVVaWmxIaExsdkFTMWc3c" 1 => "laravel_session=eyJpdiI6IlVFSll1ejhUL2duS2w0SmJlWEVLaXc9PSIsInZhbHVlIjoiUVRJTlRIcU5pMlQ4VUlUaUsvWmkwRzk3OC9PQWErZ0pVbk5CNjNqRXVHbVAzU2hraWozZ3BWREd5N3NtTzlpMUlvS2JIZmdHUjZzejk5dEh6dWN6NCs3ZGhkM1BEbXJTajNZWThnQkRiaXBBTDVhTkNsVXRJeUhHM1pVcmxpTWkiLCJtYWMiOiIxZmUwY2VmMzg3M2VjMTNhY2RlODQ1ZjMxYWIyMjhlYTg0OTNhMTE2YTZiODZlOWJjMDAzNjg1NGZlNmVkM2U3IiwidGFnIjoiIn0%3D; expires=Fri, 11 Jul 2025 05:03:56 GMT; Max-Age=7200; path=/; httponlylaravel_session=eyJpdiI6IlVFSll1ejhUL2duS2w0SmJlWEVLaXc9PSIsInZhbHVlIjoiUVRJTlRIcU5pMlQ4VUlUaUsvWmkwRzk3OC9PQWErZ0pVbk5CNjNqRXVHbVAzU2hraWozZ3BWREd5N3NtTzlpMUlv" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InRUc0g4VFNwNlo1VzJMUHF1Y0Rwb1E9PSIsInZhbHVlIjoiY3BFOC84VHN3ZkkwUUErZ3lkMzBlK2orcDBTdWcyei9DZEVvUFdxNGtDWDVrK1JZbFM2RmNmWVVaWmxIaExsdkFTMWc3cVdSVGdZS244QmRob0xDR0NPRmZwTHl3dndsWTBZa1d5dFJDbG5rMHJVRjZGVWNTbVBtVlhxbU5TTmMiLCJtYWMiOiJjOTJiMTY2ZjRiMzNiMjg3YjIxNjM2YjRmZmQ2MWRlMTM0YjgxMzVjYjM5ZWFjM2IwMGNiOGU2ZTM0ZjgyMDI3IiwidGFnIjoiIn0%3D; expires=Fri, 11-Jul-2025 05:03:56 GMT; path=/XSRF-TOKEN=eyJpdiI6InRUc0g4VFNwNlo1VzJMUHF1Y0Rwb1E9PSIsInZhbHVlIjoiY3BFOC84VHN3ZkkwUUErZ3lkMzBlK2orcDBTdWcyei9DZEVvUFdxNGtDWDVrK1JZbFM2RmNmWVVaWmxIaExsdkFTMWc3c" 1 => "laravel_session=eyJpdiI6IlVFSll1ejhUL2duS2w0SmJlWEVLaXc9PSIsInZhbHVlIjoiUVRJTlRIcU5pMlQ4VUlUaUsvWmkwRzk3OC9PQWErZ0pVbk5CNjNqRXVHbVAzU2hraWozZ3BWREd5N3NtTzlpMUlvS2JIZmdHUjZzejk5dEh6dWN6NCs3ZGhkM1BEbXJTajNZWThnQkRiaXBBTDVhTkNsVXRJeUhHM1pVcmxpTWkiLCJtYWMiOiIxZmUwY2VmMzg3M2VjMTNhY2RlODQ1ZjMxYWIyMjhlYTg0OTNhMTE2YTZiODZlOWJjMDAzNjg1NGZlNmVkM2U3IiwidGFnIjoiIn0%3D; expires=Fri, 11-Jul-2025 05:03:56 GMT; path=/; httponlylaravel_session=eyJpdiI6IlVFSll1ejhUL2duS2w0SmJlWEVLaXc9PSIsInZhbHVlIjoiUVRJTlRIcU5pMlQ4VUlUaUsvWmkwRzk3OC9PQWErZ0pVbk5CNjNqRXVHbVAzU2hraWozZ3BWREd5N3NtTzlpMUlv" ] ]
          session_attributes
          0 of 0
          array:18 [ "decimal_point_settings" => 0 "product_brand" => 1 "digital_product" => 0 "currency_model" => "single_currency" "language" => array:2 [ 0 => array:6 [ "id" => "1" "name" => "english" "direction" => "ltr" "code" => "en" "status" => 1 "default" => true ] 1 => array:6 [ "id" => 2 "name" => "Hindi" "direction" => "ltr" "code" => "in" "status" => 1 "default" => false ] ] "local" => "en" "direction" => "ltr" "system_default_currency" => 3 "system_default_currency_info" => App\Models\Currency {#3674 #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 22:53:04" "updated_at" => "2021-06-04 23:56:38" ] #original: array:8 [ "id" => 3 "name" => "Indian Rupi" "symbol" => "" "code" => "INR" "exchange_rate" => "60" "status" => 1 "created_at" => "2020-10-15 22:53:04" "updated_at" => "2021-06-04 23:56: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" => "ZxJkoqHMN2fw6z2Ebk4Wt0148mQcZj337WDl8wWs" "currency_symbol_position" => "left" "company_email" => "info@shankarmasala.com" "_previous" => array:1 [ "url" => "https://shankar-beta.mydemoapp.us/products?data_from=top-rated&page=7&page_no=6" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]