Shop Page

Messages Timeline Exceptions Views22 Route Queries108 Models356 Mails Gate Session Request

8.2.19865ms34MBGET shopView/{id}

Booting (210ms)time
Application (655ms)time
1 x Application (75.77%)
655ms
1 x Booting (24.23%)
210ms

22 templates were rendered

web-views.seller-view.shopviewshopview.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
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 shopView/{id}
middleware: web
controller: App\Http\Controllers\Web\ShopViewController@seller_shop
namespace: App\Http\Controllers\Web
prefix
where
as: shopView
file: app/Http/Controllers/Web/ShopViewController.php:28-38

108 statements were executed, 60 of which were duplicates, 48 unique. Show only duplicated114ms

# Query soft limit for Debugbar is reached after 100 queries, additional 8 queries only show the query. Limit can be raised in the config. Limits can be raised in the config (debugbar.options.db.soft_limit)

select * from `business_settings` where (`type` = 'business_mode') limit 1

1.23msshankar_betahelpers.php#167

Bindings	0: business_mode
Backtrace	16. app/Utils/helpers.php:167 17. app/Http/Controllers/Web/ShopViewController.php:41 18. app/Http/Controllers/Web/ShopViewController.php:33 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `sellers` where (`status` = 'approved') and `sellers`.`id` = '0' limit 1

350μsshankar_betaShopViewController.php#43

Bindings	0: approved 1: 0
Backtrace	17. app/Http/Controllers/Web/ShopViewController.php:43 18. app/Http/Controllers/Web/ShopViewController.php:33 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `business_settings` where (`type` = 'business_mode') limit 1

550μsshankar_betasettings.php#15

Bindings	0: business_mode
Backtrace	16. app/Utils/settings.php:15 26. app/Http/Controllers/Web/ShopViewController.php:55 27. app/Http/Controllers/Web/ShopViewController.php:33 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

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 (`added_by` = 'admin')

30.66msshankar_betaShopViewController.php#61

Bindings	0: 1 1: admin 2: 1 3: 1 4: 1 5: 1 6: approved 7: admin 8: 1 9: physical 10: admin
Backtrace	14. app/Http/Controllers/Web/ShopViewController.php:61 15. app/Http/Controllers/Web/ShopViewController.php:33 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 avg(`rating`) as aggregate from `reviews` where `status` = 1 and `product_id` in (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 14, 15, 17, 18, 19, 20, 21, 22, 23, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 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, 78, 79, 81, 82, 83, 84, 85, 88, 90, 91, 92, 95, 97, 98, 99, 100, 101, 102, 103, 107, 108, 109, 110, 111, 112, 113, 116, 117, 119, 120, 121, 125, 126, 127, 128, 129, 130, 131, 134, 135, 136, 137, 138, 142, 143, 144, 145, 149, 150, 151, 152, 153, 157, 159, 160, 164, 165, 166, 167, 168, 173, 174, 178, 179, 180, 181, 182, 184, 186, 187, 188, 189, 191, 192, 194, 195, 198, 199, 201, 202, 206, 210, 211, 213, 214, 216, 217, 218, 219, 220, 221, 222, 224, 226, 227, 228, 230, 231, 232, 234, 235, 236, 237, 238, 240, 242, 243, 244, 245, 246, 247, 248, 250, 251, 252, 254, 255, 256, 257, 258, 259, 260, 263, 265, 266, 267) and `status` = 1

1.15msshankar_betaShopViewController.php#62

Bindings

0: 1
1: 1
2: 2
3: 3
4: 4
5: 5
6: 6
7: 8
8: 9
9: 10
10: 11
11: 12
12: 14
13: 15
14: 17
15: 18
16: 19
17: 20
18: 21
19: 22
20: 23
21: 25
22: 26
23: 27
24: 28
25: 29
26: 30
27: 31
28: 32
29: 33
30: 34
31: 35
32: 37
33: 38
34: 39
35: 40
36: 41
37: 42
38: 43
39: 44
40: 45
41: 46
42: 48
43: 49
44: 50
45: 51
46: 52
47: 53
48: 54
49: 55
50: 56
51: 57
52: 58
53: 59
54: 60
55: 61
56: 62
57: 63
58: 64
59: 65
60: 66
61: 67
62: 68
63: 69
64: 70
65: 71
66: 72
67: 73
68: 74
69: 75
70: 78
71: 79
72: 81
73: 82
74: 83
75: 84
76: 85
77: 88
78: 90
79: 91
80: 92
81: 95
82: 97
83: 98
84: 99
85: 100
86: 101
87: 102
88: 103
89: 107
90: 108
91: 109
92: 110
93: 111
94: 112
95: 113
96: 116
97: 117
98: 119
99: 120
100: 121
101: 125
102: 126
103: 127
104: 128
105: 129
106: 130
107: 131
108: 134
109: 135
110: 136
111: 137
112: 138
113: 142
114: 143
115: 144
116: 145
117: 149
118: 150
119: 151
120: 152
121: 153
122: 157
123: 159
124: 160
125: 164
126: 165
127: 166
128: 167
129: 168
130: 173
131: 174
132: 178
133: 179
134: 180
135: 181
136: 182
137: 184
138: 186
139: 187
140: 188
141: 189
142: 191
143: 192
144: 194
145: 195
146: 198
147: 199
148: 201
149: 202
150: 206
151: 210
152: 211
153: 213
154: 214
155: 216
156: 217
157: 218
158: 219
159: 220
160: 221
161: 222
162: 224
163: 226
164: 227
165: 228
166: 230
167: 231
168: 232
169: 234
170: 235
171: 236
172: 237
173: 238
174: 240
175: 242
176: 243
177: 244
178: 245
179: 246
180: 247
181: 248
182: 250
183: 251
184: 252
185: 254
186: 255
187: 256
188: 257
189: 258
190: 259
191: 260
192: 263
193: 265
194: 266
195: 267
196: 1

Backtrace

16. app/Http/Controllers/Web/ShopViewController.php:62
17. app/Http/Controllers/Web/ShopViewController.php:33
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 `reviews` where `status` = 1 and `product_id` in (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 14, 15, 17, 18, 19, 20, 21, 22, 23, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 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, 78, 79, 81, 82, 83, 84, 85, 88, 90, 91, 92, 95, 97, 98, 99, 100, 101, 102, 103, 107, 108, 109, 110, 111, 112, 113, 116, 117, 119, 120, 121, 125, 126, 127, 128, 129, 130, 131, 134, 135, 136, 137, 138, 142, 143, 144, 145, 149, 150, 151, 152, 153, 157, 159, 160, 164, 165, 166, 167, 168, 173, 174, 178, 179, 180, 181, 182, 184, 186, 187, 188, 189, 191, 192, 194, 195, 198, 199, 201, 202, 206, 210, 211, 213, 214, 216, 217, 218, 219, 220, 221, 222, 224, 226, 227, 228, 230, 231, 232, 234, 235, 236, 237, 238, 240, 242, 243, 244, 245, 246, 247, 248, 250, 251, 252, 254, 255, 256, 257, 258, 259, 260, 263, 265, 266, 267) and `status` = 1

650μsshankar_betaShopViewController.php#63

Bindings

0: 1
1: 1
2: 2
3: 3
4: 4
5: 5
6: 6
7: 8
8: 9
9: 10
10: 11
11: 12
12: 14
13: 15
14: 17
15: 18
16: 19
17: 20
18: 21
19: 22
20: 23
21: 25
22: 26
23: 27
24: 28
25: 29
26: 30
27: 31
28: 32
29: 33
30: 34
31: 35
32: 37
33: 38
34: 39
35: 40
36: 41
37: 42
38: 43
39: 44
40: 45
41: 46
42: 48
43: 49
44: 50
45: 51
46: 52
47: 53
48: 54
49: 55
50: 56
51: 57
52: 58
53: 59
54: 60
55: 61
56: 62
57: 63
58: 64
59: 65
60: 66
61: 67
62: 68
63: 69
64: 70
65: 71
66: 72
67: 73
68: 74
69: 75
70: 78
71: 79
72: 81
73: 82
74: 83
75: 84
76: 85
77: 88
78: 90
79: 91
80: 92
81: 95
82: 97
83: 98
84: 99
85: 100
86: 101
87: 102
88: 103
89: 107
90: 108
91: 109
92: 110
93: 111
94: 112
95: 113
96: 116
97: 117
98: 119
99: 120
100: 121
101: 125
102: 126
103: 127
104: 128
105: 129
106: 130
107: 131
108: 134
109: 135
110: 136
111: 137
112: 138
113: 142
114: 143
115: 144
116: 145
117: 149
118: 150
119: 151
120: 152
121: 153
122: 157
123: 159
124: 160
125: 164
126: 165
127: 166
128: 167
129: 168
130: 173
131: 174
132: 178
133: 179
134: 180
135: 181
136: 182
137: 184
138: 186
139: 187
140: 188
141: 189
142: 191
143: 192
144: 194
145: 195
146: 198
147: 199
148: 201
149: 202
150: 206
151: 210
152: 211
153: 213
154: 214
155: 216
156: 217
157: 218
158: 219
159: 220
160: 221
161: 222
162: 224
163: 226
164: 227
165: 228
166: 230
167: 231
168: 232
169: 234
170: 235
171: 236
172: 237
173: 238
174: 240
175: 242
176: 243
177: 244
178: 245
179: 246
180: 247
181: 248
182: 250
183: 251
184: 252
185: 254
186: 255
187: 256
188: 257
189: 258
190: 259
191: 260
192: 263
193: 265
194: 266
195: 267
196: 1

Backtrace

16. app/Http/Controllers/Web/ShopViewController.php:63
17. app/Http/Controllers/Web/ShopViewController.php:33
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' and `order_type` = 'default_type'

440μsshankar_betaShopViewController.php#65

Bindings	0: admin 1: default_type
Backtrace	16. app/Http/Controllers/Web/ShopViewController.php:65 17. app/Http/Controllers/Web/ShopViewController.php:33 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 `products` where `id` in (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 14, 15, 17, 18, 19, 20, 21, 22, 23, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 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, 78, 79, 81, 82, 83, 84, 85, 88, 90, 91, 92, 95, 97, 98, 99, 100, 101, 102, 103, 107, 108, 109, 110, 111, 112, 113, 116, 117, 119, 120, 121, 125, 126, 127, 128, 129, 130, 131, 134, 135, 136, 137, 138, 142, 143, 144, 145, 149, 150, 151, 152, 153, 157, 159, 160, 164, 165, 166, 167, 168, 173, 174, 178, 179, 180, 181, 182, 184, 186, 187, 188, 189, 191, 192, 194, 195, 198, 199, 201, 202, 206, 210, 211, 213, 214, 216, 217, 218, 219, 220, 221, 222, 224, 226, 227, 228, 230, 231, 232, 234, 235, 236, 237, 238, 240, 242, 243, 244, 245, 246, 247, 248, 250, 251, 252, 254, 255, 256, 257, 258, 259, 260, 263, 265, 266, 267)

1.39msshankar_betaShopViewController.php#72

Bindings

0: 1
1: 2
2: 3
3: 4
4: 5
5: 6
6: 8
7: 9
8: 10
9: 11
10: 12
11: 14
12: 15
13: 17
14: 18
15: 19
16: 20
17: 21
18: 22
19: 23
20: 25
21: 26
22: 27
23: 28
24: 29
25: 30
26: 31
27: 32
28: 33
29: 34
30: 35
31: 37
32: 38
33: 39
34: 40
35: 41
36: 42
37: 43
38: 44
39: 45
40: 46
41: 48
42: 49
43: 50
44: 51
45: 52
46: 53
47: 54
48: 55
49: 56
50: 57
51: 58
52: 59
53: 60
54: 61
55: 62
56: 63
57: 64
58: 65
59: 66
60: 67
61: 68
62: 69
63: 70
64: 71
65: 72
66: 73
67: 74
68: 75
69: 78
70: 79
71: 81
72: 82
73: 83
74: 84
75: 85
76: 88
77: 90
78: 91
79: 92
80: 95
81: 97
82: 98
83: 99
84: 100
85: 101
86: 102
87: 103
88: 107
89: 108
90: 109
91: 110
92: 111
93: 112
94: 113
95: 116
96: 117
97: 119
98: 120
99: 121
100: 125
101: 126
102: 127
103: 128
104: 129
105: 130
106: 131
107: 134
108: 135
109: 136
110: 137
111: 138
112: 142
113: 143
114: 144
115: 145
116: 149
117: 150
118: 151
119: 152
120: 153
121: 157
122: 159
123: 160
124: 164
125: 165
126: 166
127: 167
128: 168
129: 173
130: 174
131: 178
132: 179
133: 180
134: 181
135: 182
136: 184
137: 186
138: 187
139: 188
140: 189
141: 191
142: 192
143: 194
144: 195
145: 198
146: 199
147: 201
148: 202
149: 206
150: 210
151: 211
152: 213
153: 214
154: 216
155: 217
156: 218
157: 219
158: 220
159: 221
160: 222
161: 224
162: 226
163: 227
164: 228
165: 230
166: 231
167: 232
168: 234
169: 235
170: 236
171: 237
172: 238
173: 240
174: 242
175: 243
176: 244
177: 245
178: 246
179: 247
180: 248
181: 250
182: 251
183: 252
184: 254
185: 255
186: 256
187: 257
188: 258
189: 259
190: 260
191: 263
192: 265
193: 266
194: 267

Backtrace

16. app/Http/Controllers/Web/ShopViewController.php:72
17. app/Http/Controllers/Web/ShopViewController.php:33
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 `id` in (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 14, 15, 17, 18, 19, 20, 21, 22, 23, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 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, 78, 79, 81, 82, 83, 84, 85, 88, 90, 91, 92, 95, 97, 98, 99, 100, 101, 102, 103, 107, 108, 109, 110, 111, 112, 113, 116, 117, 119, 120, 121, 125, 126, 127, 128, 129, 130, 131, 134, 135, 136, 137, 138, 142, 143, 144, 145, 149, 150, 151, 152, 153, 157, 159, 160, 164, 165, 166, 167, 168, 173, 174, 178, 179, 180, 181, 182, 184, 186, 187, 188, 189, 191, 192, 194, 195, 198, 199, 201, 202, 206, 210, 211, 213, 214, 216, 217, 218, 219, 220, 221, 222, 224, 226, 227, 228, 230, 231, 232, 234, 235, 236, 237, 238, 240, 242, 243, 244, 245, 246, 247, 248, 250, 251, 252, 254, 255, 256, 257, 258, 259, 260, 263, 265, 266, 267) limit 12 offset 108

2.46msshankar_betaShopViewController.php#72

Bindings

0: 1
1: 1
2: 2
3: 3
4: 4
5: 5
6: 6
7: 8
8: 9
9: 10
10: 11
11: 12
12: 14
13: 15
14: 17
15: 18
16: 19
17: 20
18: 21
19: 22
20: 23
21: 25
22: 26
23: 27
24: 28
25: 29
26: 30
27: 31
28: 32
29: 33
30: 34
31: 35
32: 37
33: 38
34: 39
35: 40
36: 41
37: 42
38: 43
39: 44
40: 45
41: 46
42: 48
43: 49
44: 50
45: 51
46: 52
47: 53
48: 54
49: 55
50: 56
51: 57
52: 58
53: 59
54: 60
55: 61
56: 62
57: 63
58: 64
59: 65
60: 66
61: 67
62: 68
63: 69
64: 70
65: 71
66: 72
67: 73
68: 74
69: 75
70: 78
71: 79
72: 81
73: 82
74: 83
75: 84
76: 85
77: 88
78: 90
79: 91
80: 92
81: 95
82: 97
83: 98
84: 99
85: 100
86: 101
87: 102
88: 103
89: 107
90: 108
91: 109
92: 110
93: 111
94: 112
95: 113
96: 116
97: 117
98: 119
99: 120
100: 121
101: 125
102: 126
103: 127
104: 128
105: 129
106: 130
107: 131
108: 134
109: 135
110: 136
111: 137
112: 138
113: 142
114: 143
115: 144
116: 145
117: 149
118: 150
119: 151
120: 152
121: 153
122: 157
123: 159
124: 160
125: 164
126: 165
127: 166
128: 167
129: 168
130: 173
131: 174
132: 178
133: 179
134: 180
135: 181
136: 182
137: 184
138: 186
139: 187
140: 188
141: 189
142: 191
143: 192
144: 194
145: 195
146: 198
147: 199
148: 201
149: 202
150: 206
151: 210
152: 211
153: 213
154: 214
155: 216
156: 217
157: 218
158: 219
159: 220
160: 221
161: 222
162: 224
163: 226
164: 227
165: 228
166: 230
167: 231
168: 232
169: 234
170: 235
171: 236
172: 237
173: 238
174: 240
175: 242
176: 243
177: 244
178: 245
179: 246
180: 247
181: 248
182: 250
183: 251
184: 252
185: 254
186: 255
187: 256
188: 257
189: 258
190: 259
191: 260
192: 263
193: 265
194: 266
195: 267

Backtrace

16. app/Http/Controllers/Web/ShopViewController.php:72
17. app/Http/Controllers/Web/ShopViewController.php:33
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 (135, 136, 137, 138, 142, 143, 144, 145, 149, 150, 151, 152) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

870μsshankar_betaShopViewController.php#72

Bindings	0: App\Models\Product 1: en
Backtrace	21. app/Http/Controllers/Web/ShopViewController.php:72 22. app/Http/Controllers/Web/ShopViewController.php:33 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 (135, 136, 137, 138, 142, 143, 144, 145, 149, 150, 151, 152) and `delivery_man_id` is null and `status` = 1

640μsshankar_betaShopViewController.php#72

Bindings	0: 1
Backtrace	21. app/Http/Controllers/Web/ShopViewController.php:72 22. app/Http/Controllers/Web/ShopViewController.php:33 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 `categories` where `position` = 0 and `categories`.`id` = '3' limit 1

310μsshankar_betaShopViewController.php#94

Bindings	0: 0 1: 3
Backtrace	17. app/Http/Controllers/Web/ShopViewController.php:94 18. app/Http/Controllers/Web/ShopViewController.php:33 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `categories`.`parent_id` in (3) order by `priority` asc

250μsshankar_betaShopViewController.php#94

Backtrace

22. app/Http/Controllers/Web/ShopViewController.php:94
23. app/Http/Controllers/Web/ShopViewController.php:33
24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (3) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

290μsshankar_betaShopViewController.php#94

Bindings	0: App\Models\Category 1: en
Backtrace	22. app/Http/Controllers/Web/ShopViewController.php:94 23. app/Http/Controllers/Web/ShopViewController.php:33 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `position` = 0 and `categories`.`id` = '1' limit 1

740μsshankar_betaShopViewController.php#94

Bindings	0: 0 1: 1
Backtrace	17. app/Http/Controllers/Web/ShopViewController.php:94 18. app/Http/Controllers/Web/ShopViewController.php:33 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `categories`.`parent_id` in (1) order by `priority` asc

300μsshankar_betaShopViewController.php#94

Backtrace

22. app/Http/Controllers/Web/ShopViewController.php:94
23. app/Http/Controllers/Web/ShopViewController.php:33
24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `categories`.`parent_id` in (15) order by `priority` asc

1.46msshankar_betaShopViewController.php#94

Backtrace

27. app/Http/Controllers/Web/ShopViewController.php:94
28. app/Http/Controllers/Web/ShopViewController.php:33
29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
30. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
31. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (16) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

350μsshankar_betaShopViewController.php#94

Bindings	0: App\Models\Category 1: en
Backtrace	32. app/Http/Controllers/Web/ShopViewController.php:94 33. app/Http/Controllers/Web/ShopViewController.php:33 34. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 35. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 36. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (15) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

770μsshankar_betaShopViewController.php#94

Bindings	0: App\Models\Category 1: en
Backtrace	27. app/Http/Controllers/Web/ShopViewController.php:94 28. app/Http/Controllers/Web/ShopViewController.php:33 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 30. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 31. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

260μsshankar_betaShopViewController.php#94

Bindings	0: App\Models\Category 1: en
Backtrace	22. app/Http/Controllers/Web/ShopViewController.php:94 23. app/Http/Controllers/Web/ShopViewController.php:33 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `position` = 0 and `categories`.`id` = '4' limit 1

230μsshankar_betaShopViewController.php#94

Bindings	0: 0 1: 4
Backtrace	17. app/Http/Controllers/Web/ShopViewController.php:94 18. app/Http/Controllers/Web/ShopViewController.php:33 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `categories`.`parent_id` in (4) order by `priority` asc

860μsshankar_betaShopViewController.php#94

Backtrace

22. app/Http/Controllers/Web/ShopViewController.php:94
23. app/Http/Controllers/Web/ShopViewController.php:33
24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (4) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

340μsshankar_betaShopViewController.php#94

Bindings	0: App\Models\Category 1: en
Backtrace	22. app/Http/Controllers/Web/ShopViewController.php:94 23. app/Http/Controllers/Web/ShopViewController.php:33 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `position` = 0 and `categories`.`id` = '5' limit 1

560μsshankar_betaShopViewController.php#94

Bindings	0: 0 1: 5
Backtrace	17. app/Http/Controllers/Web/ShopViewController.php:94 18. app/Http/Controllers/Web/ShopViewController.php:33 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `categories`.`parent_id` in (5) order by `priority` asc

330μsshankar_betaShopViewController.php#94

Backtrace

22. app/Http/Controllers/Web/ShopViewController.php:94
23. app/Http/Controllers/Web/ShopViewController.php:33
24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (5) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

370μsshankar_betaShopViewController.php#94

Bindings	0: App\Models\Category 1: en
Backtrace	22. app/Http/Controllers/Web/ShopViewController.php:94 23. app/Http/Controllers/Web/ShopViewController.php:33 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `position` = 0 and `categories`.`id` = '3' limit 1

250μsshankar_betaShopViewController.php#94

Bindings	0: 0 1: 3
Backtrace	17. app/Http/Controllers/Web/ShopViewController.php:94 18. app/Http/Controllers/Web/ShopViewController.php:33 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `categories`.`parent_id` in (3) order by `priority` asc

300μsshankar_betaShopViewController.php#94

Backtrace

22. app/Http/Controllers/Web/ShopViewController.php:94
23. app/Http/Controllers/Web/ShopViewController.php:33
24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (3) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

290μsshankar_betaShopViewController.php#94

Bindings	0: App\Models\Category 1: en
Backtrace	22. app/Http/Controllers/Web/ShopViewController.php:94 23. app/Http/Controllers/Web/ShopViewController.php:33 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `position` = 0 and `categories`.`id` = '2' limit 1

310μsshankar_betaShopViewController.php#94

Bindings	0: 0 1: 2
Backtrace	17. app/Http/Controllers/Web/ShopViewController.php:94 18. app/Http/Controllers/Web/ShopViewController.php:33 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `categories`.`parent_id` in (2) order by `priority` asc

510μsshankar_betaShopViewController.php#94

Backtrace

22. app/Http/Controllers/Web/ShopViewController.php:94
23. app/Http/Controllers/Web/ShopViewController.php:33
24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (2) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

770μsshankar_betaShopViewController.php#94

Bindings	0: App\Models\Category 1: en
Backtrace	22. app/Http/Controllers/Web/ShopViewController.php:94 23. app/Http/Controllers/Web/ShopViewController.php:33 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `position` = 0 and `categories`.`id` = '1' limit 1

300μsshankar_betaShopViewController.php#94

Bindings	0: 0 1: 1
Backtrace	17. app/Http/Controllers/Web/ShopViewController.php:94 18. app/Http/Controllers/Web/ShopViewController.php:33 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `categories`.`parent_id` in (1) order by `priority` asc

280μsshankar_betaShopViewController.php#94

Backtrace

22. app/Http/Controllers/Web/ShopViewController.php:94
23. app/Http/Controllers/Web/ShopViewController.php:33
24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `categories`.`parent_id` in (15) order by `priority` asc

330μsshankar_betaShopViewController.php#94

Backtrace

27. app/Http/Controllers/Web/ShopViewController.php:94
28. app/Http/Controllers/Web/ShopViewController.php:33
29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
30. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
31. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (16) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

340μsshankar_betaShopViewController.php#94

Bindings	0: App\Models\Category 1: en
Backtrace	32. app/Http/Controllers/Web/ShopViewController.php:94 33. app/Http/Controllers/Web/ShopViewController.php:33 34. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 35. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 36. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (15) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

430μsshankar_betaShopViewController.php#94

Bindings	0: App\Models\Category 1: en
Backtrace	27. app/Http/Controllers/Web/ShopViewController.php:94 28. app/Http/Controllers/Web/ShopViewController.php:33 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 30. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 31. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

260μsshankar_betaShopViewController.php#94

Bindings	0: App\Models\Category 1: en
Backtrace	22. app/Http/Controllers/Web/ShopViewController.php:94 23. app/Http/Controllers/Web/ShopViewController.php:33 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `position` = 0 and `categories`.`id` = '5' limit 1

220μsshankar_betaShopViewController.php#94

Bindings	0: 0 1: 5
Backtrace	17. app/Http/Controllers/Web/ShopViewController.php:94 18. app/Http/Controllers/Web/ShopViewController.php:33 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `categories`.`parent_id` in (5) order by `priority` asc

930μsshankar_betaShopViewController.php#94

Backtrace

22. app/Http/Controllers/Web/ShopViewController.php:94
23. app/Http/Controllers/Web/ShopViewController.php:33
24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (5) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

280μsshankar_betaShopViewController.php#94

Bindings	0: App\Models\Category 1: en
Backtrace	22. app/Http/Controllers/Web/ShopViewController.php:94 23. app/Http/Controllers/Web/ShopViewController.php:33 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `position` = 0 and `categories`.`id` = '3' limit 1

700μsshankar_betaShopViewController.php#94

Bindings	0: 0 1: 3
Backtrace	17. app/Http/Controllers/Web/ShopViewController.php:94 18. app/Http/Controllers/Web/ShopViewController.php:33 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `categories`.`parent_id` in (3) order by `priority` asc

310μsshankar_betaShopViewController.php#94

Backtrace

22. app/Http/Controllers/Web/ShopViewController.php:94
23. app/Http/Controllers/Web/ShopViewController.php:33
24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (3) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

280μsshankar_betaShopViewController.php#94

Bindings	0: App\Models\Category 1: en
Backtrace	22. app/Http/Controllers/Web/ShopViewController.php:94 23. app/Http/Controllers/Web/ShopViewController.php:33 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `position` = 0 and `categories`.`id` = '2' limit 1

370μsshankar_betaShopViewController.php#94

Bindings	0: 0 1: 2
Backtrace	17. app/Http/Controllers/Web/ShopViewController.php:94 18. app/Http/Controllers/Web/ShopViewController.php:33 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `categories`.`parent_id` in (2) order by `priority` asc

320μsshankar_betaShopViewController.php#94

Backtrace

22. app/Http/Controllers/Web/ShopViewController.php:94
23. app/Http/Controllers/Web/ShopViewController.php:33
24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (2) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

530μsshankar_betaShopViewController.php#94

Bindings	0: App\Models\Category 1: en
Backtrace	22. app/Http/Controllers/Web/ShopViewController.php:94 23. app/Http/Controllers/Web/ShopViewController.php:33 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `position` = 0 and `categories`.`id` = '4' limit 1

1.11msshankar_betaShopViewController.php#94

Bindings	0: 0 1: 4
Backtrace	17. app/Http/Controllers/Web/ShopViewController.php:94 18. app/Http/Controllers/Web/ShopViewController.php:33 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `categories`.`parent_id` in (4) order by `priority` asc

350μsshankar_betaShopViewController.php#94

Backtrace

22. app/Http/Controllers/Web/ShopViewController.php:94
23. app/Http/Controllers/Web/ShopViewController.php:33
24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (4) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

290μsshankar_betaShopViewController.php#94

Bindings	0: App\Models\Category 1: en
Backtrace	22. app/Http/Controllers/Web/ShopViewController.php:94 23. app/Http/Controllers/Web/ShopViewController.php:33 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `position` = 0 and `categories`.`id` = '1' limit 1

410μsshankar_betaShopViewController.php#94

Bindings	0: 0 1: 1
Backtrace	17. app/Http/Controllers/Web/ShopViewController.php:94 18. app/Http/Controllers/Web/ShopViewController.php:33 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `categories`.`parent_id` in (1) order by `priority` asc

440μsshankar_betaShopViewController.php#94

Backtrace

22. app/Http/Controllers/Web/ShopViewController.php:94
23. app/Http/Controllers/Web/ShopViewController.php:33
24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `categories`.`parent_id` in (15) order by `priority` asc

380μsshankar_betaShopViewController.php#94

Backtrace

27. app/Http/Controllers/Web/ShopViewController.php:94
28. app/Http/Controllers/Web/ShopViewController.php:33
29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
30. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
31. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (16) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

340μsshankar_betaShopViewController.php#94

Bindings	0: App\Models\Category 1: en
Backtrace	32. app/Http/Controllers/Web/ShopViewController.php:94 33. app/Http/Controllers/Web/ShopViewController.php:33 34. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 35. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 36. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (15) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

2.66msshankar_betaShopViewController.php#94

Bindings	0: App\Models\Category 1: en
Backtrace	27. app/Http/Controllers/Web/ShopViewController.php:94 28. app/Http/Controllers/Web/ShopViewController.php:33 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 30. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 31. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

750μsshankar_betaShopViewController.php#94

Bindings	0: App\Models\Category 1: en
Backtrace	22. app/Http/Controllers/Web/ShopViewController.php:94 23. app/Http/Controllers/Web/ShopViewController.php:33 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `business_settings` where (`type` = 'business_mode') limit 1

440μsshankar_betasettings.php#15

Bindings	0: business_mode
Backtrace	16. app/Utils/settings.php:15 26. app/Http/Controllers/Web/ShopViewController.php:101 27. app/Http/Controllers/Web/ShopViewController.php:33 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

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 (`added_by` = 'admin')

1.48msshankar_betaShopViewController.php#149

Bindings	0: admin 1: 1 2: 1 3: 1 4: 1 5: approved 6: admin 7: 1 8: physical 9: admin
Backtrace	16. app/Http/Controllers/Web/ShopViewController.php:149 17. app/Http/Controllers/Web/ShopViewController.php:33 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 (`added_by` = 'admin') limit 12 offset 108

3.06msshankar_betaShopViewController.php#149

Bindings	0: 1 1: admin 2: 1 3: 1 4: 1 5: 1 6: approved 7: admin 8: 1 9: physical 10: admin
Backtrace	16. app/Http/Controllers/Web/ShopViewController.php:149 17. app/Http/Controllers/Web/ShopViewController.php:33 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 (135, 136, 137, 138, 142, 143, 144, 145, 149, 150, 151, 152) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

620μsshankar_betaShopViewController.php#149

Bindings	0: App\Models\Product 1: en
Backtrace	21. app/Http/Controllers/Web/ShopViewController.php:149 22. app/Http/Controllers/Web/ShopViewController.php:33 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 (135, 136, 137, 138, 142, 143, 144, 145, 149, 150, 151, 152) and `delivery_man_id` is null and `status` = 1

980μsshankar_betaShopViewController.php#149

Bindings	0: 1
Backtrace	21. app/Http/Controllers/Web/ShopViewController.php:149 22. app/Http/Controllers/Web/ShopViewController.php:33 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` = 'company_name') limit 1

500μsshankar_betahelpers.php#167

Bindings	0: company_name
Backtrace	16. app/Utils/helpers.php:167 17. app/Http/Controllers/Web/ShopViewController.php:158 18. app/Http/Controllers/Web/ShopViewController.php:33 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `business_settings` where (`type` = 'temporary_close') limit 1

280μsshankar_betahelpers.php#167

Bindings	0: temporary_close
Backtrace	16. app/Utils/helpers.php:167 17. app/Http/Controllers/Web/ShopViewController.php:174 18. app/Http/Controllers/Web/ShopViewController.php:33 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `business_settings` where (`type` = 'vacation_add') limit 1

340μsshankar_betahelpers.php#167

Bindings	0: vacation_add
Backtrace	16. app/Utils/helpers.php:167 17. app/Http/Controllers/Web/ShopViewController.php:175 18. app/Http/Controllers/Web/ShopViewController.php:33 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `business_settings` where (`type` = 'shop_banner') limit 1

1.99msshankar_betasettings.php#15

Bindings	0: shop_banner
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` = 'minimum_order_amount_status') limit 1

510μsshankar_betasettings.php#15

Bindings	0: minimum_order_amount_status
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` = 'minimum_order_amount_by_seller') limit 1

990μsshankar_betasettings.php#15

Bindings	0: minimum_order_amount_by_seller
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` = 'currency_symbol_position') limit 1

880μ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.01msshankar_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

1.31msshankar_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

250μ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`

420μ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

410μ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

1.94msshankar_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

510μ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

400μ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`

1.34msshankar_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')

2.22msshankar_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`

1.25msshankar_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')

920μ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: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.35msshankar_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.49msshankar_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

690μ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 `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

830μsshankar_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'

410μ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

960μ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

910μsshankar_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

750μ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

580μ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

500μ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

420μsshankar_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 99

430μsshankar_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.53msshankar_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.16msshankar_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

2.09msshankar_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'

380μ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

700μ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.86msshankar_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

1.15msshankar_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

1.01msshankar_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-26' and date(`end_date`) >= '2025-07-26' limit 1
770μsshankar_beta
select * from `business_settings` where (`type` = 'refund-policy') limit 1
880μsshankar_beta
select * from `business_settings` where (`type` = 'return-policy') limit 1
1.23msshankar_beta
select * from `business_settings` where (`type` = 'cancellation-policy') limit 1
870μsshankar_beta
select * from `business_settings` where (`type` = 'company_phone') limit 1
1.22msshankar_beta
select * from `business_settings` where (`type` = 'company_email') limit 1
810μsshankar_beta
select * from `business_settings` where (`type` = 'shop_address') limit 1
790μsshankar_beta
select * from `business_settings` where (`type` = 'whatsapp') limit 1
970μsshankar_beta

App\Models\Product: 221
App\Models\Review: 47
App\Models\State: 36
App\Models\BusinessSetting: 28
App\Models\Category: 18
App\Models\Cart: 4
App\Models\Country: 1
App\Models\Brand: 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 {#3717 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
currency_code: INR
currency_symbol: ₹
currency_exchange_rate: 60
_token: td8AlAcU3WRGapUrAT0UjnQrdnHHKppMDCt2ZkS0
company_name: Shankar Masala
currency_symbol_position: left
company_email: info@shankarmasala.com
_previous: array:1 [ "url" => "https://shankar-beta.mydemoapp.us/shopView/0?page=10" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/shopView/0

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "page" => "10"
]

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 => "Sat, 26 Jul 2025 15:40:06 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjdWQ0I5TmV6WkNiTmR5SzdWa2hWbVE9PSIsInZhbHVlIjoiNmh2eHZNVlBuS0JiY2Fpak9LaHZUV1dEWTVTNTNHd003WFhhVllsTytWSVl3ZHhuTVQzM002azdUWGxZbHFzWVkvUmNxTTc1dXZhRWV0THRTaEFoUXBKVmdUb2FRRkdvT0VzLzF1Z09MdFJJdEgzSlZ2ZUh4NWo0VklwQmFKUVoiLCJtYWMiOiI5MmY2MzYxMjI3ZDk3ZjE1NTc2YjgxYmYzZTI2ZDAyMjFhODk1YzMxZTI0MTg1NzExNDE3ZTUyNjE5ZThlMGZjIiwidGFnIjoiIn0%3D; expires=Sat, 26 Jul 2025 17:40:07 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IjdWQ0I5TmV6WkNiTmR5SzdWa2hWbVE9PSIsInZhbHVlIjoiNmh2eHZNVlBuS0JiY2Fpak9LaHZUV1dEWTVTNTNHd003WFhhVllsTytWSVl3ZHhuTVQzM002azdUWGxZbHFzWVkvUmNxT ▶"
    1 => "laravel_session=eyJpdiI6InhJNVJZc2FNZHgxOENEV1lOakhSNHc9PSIsInZhbHVlIjoiT3g4UGNzeTN0MU1udU5HUmVBM1F4N0JpV0ZWR1pDempUeDBnSVRWVzA0UE5KbUwwUjVFZVZIR2NiWHZMUThxNmRpSUhKakE5RStDWEtsbU1lS2dSaFpaSTFzVEJZSVB0NlRRa296dzcrY0gzVE0vMXpSNEFQcWl5Ry9NbmJZYVYiLCJtYWMiOiI5OWE4ZjQ2NmY5MTY1MTQ3MTQzNzc0YjkxMTEyNmQyNmNmMzEyMWNjM2MxMjdmOGVjNjBlOWFmYTk5NjA3NzJlIiwidGFnIjoiIn0%3D; expires=Sat, 26 Jul 2025 17:40:07 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6InhJNVJZc2FNZHgxOENEV1lOakhSNHc9PSIsInZhbHVlIjoiT3g4UGNzeTN0MU1udU5HUmVBM1F4N0JpV0ZWR1pDempUeDBnSVRWVzA0UE5KbUwwUjVFZVZIR2NiWHZMUThxNmRp ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjdWQ0I5TmV6WkNiTmR5SzdWa2hWbVE9PSIsInZhbHVlIjoiNmh2eHZNVlBuS0JiY2Fpak9LaHZUV1dEWTVTNTNHd003WFhhVllsTytWSVl3ZHhuTVQzM002azdUWGxZbHFzWVkvUmNxTTc1dXZhRWV0THRTaEFoUXBKVmdUb2FRRkdvT0VzLzF1Z09MdFJJdEgzSlZ2ZUh4NWo0VklwQmFKUVoiLCJtYWMiOiI5MmY2MzYxMjI3ZDk3ZjE1NTc2YjgxYmYzZTI2ZDAyMjFhODk1YzMxZTI0MTg1NzExNDE3ZTUyNjE5ZThlMGZjIiwidGFnIjoiIn0%3D; expires=Sat, 26-Jul-2025 17:40:07 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjdWQ0I5TmV6WkNiTmR5SzdWa2hWbVE9PSIsInZhbHVlIjoiNmh2eHZNVlBuS0JiY2Fpak9LaHZUV1dEWTVTNTNHd003WFhhVllsTytWSVl3ZHhuTVQzM002azdUWGxZbHFzWVkvUmNxT ▶"
    1 => "laravel_session=eyJpdiI6InhJNVJZc2FNZHgxOENEV1lOakhSNHc9PSIsInZhbHVlIjoiT3g4UGNzeTN0MU1udU5HUmVBM1F4N0JpV0ZWR1pDempUeDBnSVRWVzA0UE5KbUwwUjVFZVZIR2NiWHZMUThxNmRpSUhKakE5RStDWEtsbU1lS2dSaFpaSTFzVEJZSVB0NlRRa296dzcrY0gzVE0vMXpSNEFQcWl5Ry9NbmJZYVYiLCJtYWMiOiI5OWE4ZjQ2NmY5MTY1MTQ3MTQzNzc0YjkxMTEyNmQyNmNmMzEyMWNjM2MxMjdmOGVjNjBlOWFmYTk5NjA3NzJlIiwidGFnIjoiIn0%3D; expires=Sat, 26-Jul-2025 17:40:07 GMT; path=/; httponly ◀laravel_session=eyJpdiI6InhJNVJZc2FNZHgxOENEV1lOakhSNHc9PSIsInZhbHVlIjoiT3g4UGNzeTN0MU1udU5HUmVBM1F4N0JpV0ZWR1pDempUeDBnSVRWVzA0UE5KbUwwUjVFZVZIR2NiWHZMUThxNmRp ▶"
  ]
]

session_attributes

  0 of 0   
array:19 [▼
  "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 {#3717 ▶
    #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" => "td8AlAcU3WRGapUrAT0UjnQrdnHHKppMDCt2ZkS0"
  "company_name" => "Shankar Masala"
  "currency_symbol_position" => "left"
  "company_email" => "info@shankarmasala.com"
  "_previous" => array:1 [▶
    "url" => "https://shankar-beta.mydemoapp.us/shopView/0?page=10"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Coriander (કોથમીર)

Selam Turmeric Powder (સેલમ હળદર પાવડર)

Special

Account & shipping info

Newsletter

1 x Application (75.77%)	655ms
1 x Booting (24.23%)	210ms

Shopping cart

Coriander (કોથમીર)

Selam Turmeric Powder (સેલમ હળદર પાવડર)

Categories

Product has been removed from wishlist

Out of stock

Product added to wishlist

Please Login

Delete this address?