YumBox Coupons

Shop now

Active YumBox Lunchbox Coupons & Promo codes

20%

Off

20% OFF Your First Yumbox Purchase

Details: Get 20% OFF your first Yumbox purchase with this code!

Expires On going

Show Code TRY20

Free

Shipping

FREE Shipping On All Orders Over $56

Details: Enjoy FREE Shipping On All Orders Over $56 at Yumbox!

Expires On going

Get Deal

Deal

Sign Up For Yumbox News And Special Discounts

Details: Sign up for Yumbox news and special discounts! Join now!

Expires On going

Get Deal

Deal

Yumbox Original For Only $28

Details: Buy Yumbox Original For Only $28 now!

Expires On going

Get Deal

Messages Timeline Exceptions Views15 Route Queries24 Mails Auth Gate Session Request

375.58ms2MBGET {category}/{store}

Booting (34.21ms)
Application (343.3ms)

15 templates were rendered

frontend.store.list (resources/views/frontend/store/list.blade.php)12blade


store
title
storeNameTracking
storeIdTracking
slug
activeCoupons
breadcrumbs
unreliableCoupons
relatedStores
category
relatedCategories
activeCouponsSearch

Params
0	`store`
1	`title`
2	`storeNameTracking`
3	`storeIdTracking`
4	`slug`
5	`activeCoupons`
6	`breadcrumbs`
7	`unreliableCoupons`
8	`relatedStores`
9	`category`
10	`relatedCategories`
11	`activeCouponsSearch`

frontend.layout.meta (resources/views/frontend/layout/meta.blade.php)20blade


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
store
title
storeNameTracking
storeIdTracking
slug
activeCoupons
breadcrumbs
unreliableCoupons
relatedStores
category
relatedCategories
activeCouponsSearch
data

frontend.common.breadcrumbs (resources/views/frontend/common/breadcrumbs.blade.php)1blade
Params
0
breadcrumbs

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`remarketingType`
5	`popularStoresConfig`
6	`popularCategoriesConfig`
7	`store`
8	`title`
9	`storeNameTracking`
10	`storeIdTracking`
11	`slug`
12	`activeCoupons`
13	`breadcrumbs`
14	`unreliableCoupons`
15	`relatedStores`
16	`category`
17	`relatedCategories`
18	`activeCouponsSearch`
19	`data`

Params
0	`breadcrumbs`

frontend.common.item (resources/views/frontend/common/item.blade.php)27blade


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
store
title
storeNameTracking
storeIdTracking
slug
activeCoupons
breadcrumbs
unreliableCoupons
relatedStores
category
relatedCategories
activeCouponsSearch
couponSchema
numberCouponCode
numberDeal
numberPrintAble
coupon
listRouteNameCategoryStore
activeCoupon
item

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`remarketingType`
5	`popularStoresConfig`
6	`popularCategoriesConfig`
7	`store`
8	`title`
9	`storeNameTracking`
10	`storeIdTracking`
11	`slug`
12	`activeCoupons`
13	`breadcrumbs`
14	`unreliableCoupons`
15	`relatedStores`
16	`category`
17	`relatedCategories`
18	`activeCouponsSearch`
19	`couponSchema`
20	`numberCouponCode`
21	`numberDeal`
22	`numberPrintAble`
23	`coupon`
24	`listRouteNameCategoryStore`
25	`activeCoupon`
26	`item`

frontend.common.item (resources/views/frontend/common/item.blade.php)27blade


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
store
title
storeNameTracking
storeIdTracking
slug
activeCoupons
breadcrumbs
unreliableCoupons
relatedStores
category
relatedCategories
activeCouponsSearch
couponSchema
numberCouponCode
numberDeal
numberPrintAble
coupon
listRouteNameCategoryStore
activeCoupon
item

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`remarketingType`
5	`popularStoresConfig`
6	`popularCategoriesConfig`
7	`store`
8	`title`
9	`storeNameTracking`
10	`storeIdTracking`
11	`slug`
12	`activeCoupons`
13	`breadcrumbs`
14	`unreliableCoupons`
15	`relatedStores`
16	`category`
17	`relatedCategories`
18	`activeCouponsSearch`
19	`couponSchema`
20	`numberCouponCode`
21	`numberDeal`
22	`numberPrintAble`
23	`coupon`
24	`listRouteNameCategoryStore`
25	`activeCoupon`
26	`item`

frontend.common.item (resources/views/frontend/common/item.blade.php)27blade


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
store
title
storeNameTracking
storeIdTracking
slug
activeCoupons
breadcrumbs
unreliableCoupons
relatedStores
category
relatedCategories
activeCouponsSearch
couponSchema
numberCouponCode
numberDeal
numberPrintAble
coupon
listRouteNameCategoryStore
activeCoupon
item

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`remarketingType`
5	`popularStoresConfig`
6	`popularCategoriesConfig`
7	`store`
8	`title`
9	`storeNameTracking`
10	`storeIdTracking`
11	`slug`
12	`activeCoupons`
13	`breadcrumbs`
14	`unreliableCoupons`
15	`relatedStores`
16	`category`
17	`relatedCategories`
18	`activeCouponsSearch`
19	`couponSchema`
20	`numberCouponCode`
21	`numberDeal`
22	`numberPrintAble`
23	`coupon`
24	`listRouteNameCategoryStore`
25	`activeCoupon`
26	`item`

frontend.common.item (resources/views/frontend/common/item.blade.php)27blade


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
store
title
storeNameTracking
storeIdTracking
slug
activeCoupons
breadcrumbs
unreliableCoupons
relatedStores
category
relatedCategories
activeCouponsSearch
couponSchema
numberCouponCode
numberDeal
numberPrintAble
coupon
listRouteNameCategoryStore
activeCoupon
item

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`remarketingType`
5	`popularStoresConfig`
6	`popularCategoriesConfig`
7	`store`
8	`title`
9	`storeNameTracking`
10	`storeIdTracking`
11	`slug`
12	`activeCoupons`
13	`breadcrumbs`
14	`unreliableCoupons`
15	`relatedStores`
16	`category`
17	`relatedCategories`
18	`activeCouponsSearch`
19	`couponSchema`
20	`numberCouponCode`
21	`numberDeal`
22	`numberPrintAble`
23	`coupon`
24	`listRouteNameCategoryStore`
25	`activeCoupon`
26	`item`

frontend.common.sidebar-category-store (resources/views/frontend/common/sidebar-category-store.blade.php)30blade


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
store
title
storeNameTracking
storeIdTracking
slug
activeCoupons
breadcrumbs
unreliableCoupons
relatedStores
category
relatedCategories
activeCouponsSearch
couponSchema
numberCouponCode
numberDeal
numberPrintAble
coupon
listRouteNameCategoryStore
activeCoupon
includeParams
item
countDealAvaiable
typeItem

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`remarketingType`
5	`popularStoresConfig`
6	`popularCategoriesConfig`
7	`store`
8	`title`
9	`storeNameTracking`
10	`storeIdTracking`
11	`slug`
12	`activeCoupons`
13	`breadcrumbs`
14	`unreliableCoupons`
15	`relatedStores`
16	`category`
17	`relatedCategories`
18	`activeCouponsSearch`
19	`couponSchema`
20	`numberCouponCode`
21	`numberDeal`
22	`numberPrintAble`
23	`coupon`
24	`listRouteNameCategoryStore`
25	`activeCoupon`
26	`includeParams`
27	`item`
28	`countDealAvaiable`
29	`typeItem`

frontend.common.popular-box (resources/views/frontend/common/popular-box.blade.php)27blade


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
store
title
storeNameTracking
storeIdTracking
slug
activeCoupons
breadcrumbs
unreliableCoupons
relatedStores
category
relatedCategories
activeCouponsSearch
couponSchema
numberCouponCode
numberDeal
numberPrintAble
coupon
listRouteNameCategoryStore
activeCoupon
includeParams

frontend.common.breadcrumbs (resources/views/frontend/common/breadcrumbs.blade.php)1blade
Params
0
breadcrumbs

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`remarketingType`
5	`popularStoresConfig`
6	`popularCategoriesConfig`
7	`store`
8	`title`
9	`storeNameTracking`
10	`storeIdTracking`
11	`slug`
12	`activeCoupons`
13	`breadcrumbs`
14	`unreliableCoupons`
15	`relatedStores`
16	`category`
17	`relatedCategories`
18	`activeCouponsSearch`
19	`couponSchema`
20	`numberCouponCode`
21	`numberDeal`
22	`numberPrintAble`
23	`coupon`
24	`listRouteNameCategoryStore`
25	`activeCoupon`
26	`includeParams`

Params
0	`breadcrumbs`

frontend.layout.master (resources/views/frontend/layout/master.blade.php)27blade


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
store
title
storeNameTracking
storeIdTracking
slug
activeCoupons
breadcrumbs
unreliableCoupons
relatedStores
category
relatedCategories
activeCouponsSearch
couponSchema
numberCouponCode
numberDeal
numberPrintAble
coupon
listRouteNameCategoryStore
activeCoupon
includeParams

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`remarketingType`
5	`popularStoresConfig`
6	`popularCategoriesConfig`
7	`store`
8	`title`
9	`storeNameTracking`
10	`storeIdTracking`
11	`slug`
12	`activeCoupons`
13	`breadcrumbs`
14	`unreliableCoupons`
15	`relatedStores`
16	`category`
17	`relatedCategories`
18	`activeCouponsSearch`
19	`couponSchema`
20	`numberCouponCode`
21	`numberDeal`
22	`numberPrintAble`
23	`coupon`
24	`listRouteNameCategoryStore`
25	`activeCoupon`
26	`includeParams`

frontend.layout.header (resources/views/frontend/layout/header.blade.php)29blade


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
store
title
storeNameTracking
storeIdTracking
slug
activeCoupons
breadcrumbs
unreliableCoupons
relatedStores
category
relatedCategories
activeCouponsSearch
couponSchema
numberCouponCode
numberDeal
numberPrintAble
coupon
listRouteNameCategoryStore
activeCoupon
includeParams
couponTitle
uId

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`remarketingType`
5	`popularStoresConfig`
6	`popularCategoriesConfig`
7	`store`
8	`title`
9	`storeNameTracking`
10	`storeIdTracking`
11	`slug`
12	`activeCoupons`
13	`breadcrumbs`
14	`unreliableCoupons`
15	`relatedStores`
16	`category`
17	`relatedCategories`
18	`activeCouponsSearch`
19	`couponSchema`
20	`numberCouponCode`
21	`numberDeal`
22	`numberPrintAble`
23	`coupon`
24	`listRouteNameCategoryStore`
25	`activeCoupon`
26	`includeParams`
27	`couponTitle`
28	`uId`

frontend.common.logo (resources/views/frontend/common/logo.blade.php)36blade


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
store
title
storeNameTracking
storeIdTracking
slug
activeCoupons
breadcrumbs
unreliableCoupons
relatedStores
category
relatedCategories
activeCouponsSearch
couponSchema
numberCouponCode
numberDeal
numberPrintAble
coupon
listRouteNameCategoryStore
activeCoupon
includeParams
couponTitle
uId
categoriesMenu
storesMenu
keywordsConfigForSearch
keywordsLink
keywordConfigs
item
searchKeyNoFollow

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`remarketingType`
5	`popularStoresConfig`
6	`popularCategoriesConfig`
7	`store`
8	`title`
9	`storeNameTracking`
10	`storeIdTracking`
11	`slug`
12	`activeCoupons`
13	`breadcrumbs`
14	`unreliableCoupons`
15	`relatedStores`
16	`category`
17	`relatedCategories`
18	`activeCouponsSearch`
19	`couponSchema`
20	`numberCouponCode`
21	`numberDeal`
22	`numberPrintAble`
23	`coupon`
24	`listRouteNameCategoryStore`
25	`activeCoupon`
26	`includeParams`
27	`couponTitle`
28	`uId`
29	`categoriesMenu`
30	`storesMenu`
31	`keywordsConfigForSearch`
32	`keywordsLink`
33	`keywordConfigs`
34	`item`
35	`searchKeyNoFollow`

frontend.layout.footer (resources/views/frontend/layout/footer.blade.php)29blade


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
store
title
storeNameTracking
storeIdTracking
slug
activeCoupons
breadcrumbs
unreliableCoupons
relatedStores
category
relatedCategories
activeCouponsSearch
couponSchema
numberCouponCode
numberDeal
numberPrintAble
coupon
listRouteNameCategoryStore
activeCoupon
includeParams
couponTitle
uId

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`remarketingType`
5	`popularStoresConfig`
6	`popularCategoriesConfig`
7	`store`
8	`title`
9	`storeNameTracking`
10	`storeIdTracking`
11	`slug`
12	`activeCoupons`
13	`breadcrumbs`
14	`unreliableCoupons`
15	`relatedStores`
16	`category`
17	`relatedCategories`
18	`activeCouponsSearch`
19	`couponSchema`
20	`numberCouponCode`
21	`numberDeal`
22	`numberPrintAble`
23	`coupon`
24	`listRouteNameCategoryStore`
25	`activeCoupon`
26	`includeParams`
27	`couponTitle`
28	`uId`

frontend.common.subscribe (resources/views/frontend/common/subscribe.blade.php)29blade


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
store
title
storeNameTracking
storeIdTracking
slug
activeCoupons
breadcrumbs
unreliableCoupons
relatedStores
category
relatedCategories
activeCouponsSearch
couponSchema
numberCouponCode
numberDeal
numberPrintAble
coupon
listRouteNameCategoryStore
activeCoupon
includeParams
couponTitle
uId

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`remarketingType`
5	`popularStoresConfig`
6	`popularCategoriesConfig`
7	`store`
8	`title`
9	`storeNameTracking`
10	`storeIdTracking`
11	`slug`
12	`activeCoupons`
13	`breadcrumbs`
14	`unreliableCoupons`
15	`relatedStores`
16	`category`
17	`relatedCategories`
18	`activeCouponsSearch`
19	`couponSchema`
20	`numberCouponCode`
21	`numberDeal`
22	`numberPrintAble`
23	`coupon`
24	`listRouteNameCategoryStore`
25	`activeCoupon`
26	`includeParams`
27	`couponTitle`
28	`uId`

uri: GET {category}/{store}
middleware: web, redirect
as: frontend::by::category::store
controller: App\Http\Controllers\Frontend\StoreController@listByCategoryStore
namespace: App\Http\Controllers\Frontend
prefix: null
where
file: app/Http/Controllers/Frontend/StoreController.php:88-154

24 statements were executed, 2 of which were duplicated, 22 unique286.94ms

select * from `link_redirect` where `link` = 'https://couponsyr.com/lunchbox/yumbox' limit 14.83ms/app/Models/Redirect.php:23couponsyr

Metadata
Bindings	0. https://couponsyr.com/lunchbox/yumbox
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /app/Models/Redirect.php:23 13. /app/Http/Middleware/LinkRedirect.php:21 51. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 61. middleware::throttle:111 70. /public/index.php:53

select * from `config` where `config`.`key` = 'site.popularStores' order by `config`.`id` desc2.23ms/app/Repositories/BaseRepository.php:39couponsyr

Metadata
Bindings	0. site.popularStores
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /app/Repositories/BaseRepository.php:39 12. /app/Http/Controllers/Controller.php:264 13. /app/Http/Controllers/Controller.php:281 14. /app/Http/Controllers/Controller.php:34 26. /app/Http/Middleware/LinkRedirect.php:25 64. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 74. middleware::throttle:111 83. /public/index.php:53

select `id`, `title`, `slug` from `store` where `store`.`status` = 'enable' and `store`.`id` in ('772', '361', '1624', '712', '411', '430', '666', '710', '2217', '444', '6303', '7806', '512', '668', '2378', '2467', '3237', '7928', '367', '551') order by `store`.`id` desc

440μs/app/Repositories/BaseRepository.php:39couponsyr

Metadata
Bindings	0. enable 1. 772 2. 361 3. 1624 4. 712 5. 411 6. 430 7. 666 8. 710 9. 2217 10. 444 11. 6303 12. 7806 13. 512 14. 668 15. 2378 16. 2467 17. 3237 18. 7928 19. 367 20. 551
Backtrace	11. /app/Repositories/BaseRepository.php:39 12. /app/Http/Controllers/Controller.php:285 13. /app/Http/Controllers/Controller.php:34 25. /app/Http/Middleware/LinkRedirect.php:25 63. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 73. middleware::throttle:111 82. /public/index.php:53

select * from `config` where `config`.`key` = 'site.popularCategories' order by `config`.`id` desc240μs/app/Repositories/BaseRepository.php:39couponsyr

Metadata
Bindings	0. site.popularCategories
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /app/Repositories/BaseRepository.php:39 12. /app/Http/Controllers/Controller.php:264 13. /app/Http/Controllers/Controller.php:290 14. /app/Http/Controllers/Controller.php:34 26. /app/Http/Middleware/LinkRedirect.php:25 64. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 74. middleware::throttle:111 83. /public/index.php:53

select `id`, `title`, `slug` from `category` where `category`.`status` = 'enable' and `category`.`id` in ('273', '4', '376', '365', '362', '370', '460', '374', '368', '3', '448', '1118', '379', '421', '631', '531', '442', '461', '1380', '217') order by `category`.`id` desc

350μs/app/Repositories/BaseRepository.php:39couponsyr

Metadata
Bindings	0. enable 1. 273 2. 4 3. 376 4. 365 5. 362 6. 370 7. 460 8. 374 9. 368 10. 3 11. 448 12. 1118 13. 379 14. 421 15. 631 16. 531 17. 442 18. 461 19. 1380 20. 217
Backtrace	11. /app/Repositories/BaseRepository.php:39 12. /app/Http/Controllers/Controller.php:294 13. /app/Http/Controllers/Controller.php:34 25. /app/Http/Middleware/LinkRedirect.php:25 63. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 73. middleware::throttle:111 82. /public/index.php:53

select * from `store` where `store`.`slug` = 'yumbox' and `store`.`status` = 'enable' order by `store`.`id` desc35.73ms/app/Repositories/BaseRepository.php:39couponsyr

Metadata
Bindings	0. yumbox 1. enable
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /app/Repositories/BaseRepository.php:39 12. /app/Http/Controllers/Frontend/StoreController.php:90 28. /app/Http/Middleware/LinkRedirect.php:25 66. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 76. middleware::throttle:111 85. /public/index.php:53

select * from `category` where `category`.`slug` = 'lunchbox' and `category`.`status` = 'enable' order by `category`.`id` desc

3.04ms/app/Repositories/BaseRepository.php:39couponsyr

Metadata
Bindings	0. lunchbox 1. enable
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /app/Repositories/BaseRepository.php:39 12. /app/Http/Controllers/Frontend/StoreController.php:96 28. /app/Http/Middleware/LinkRedirect.php:25 66. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 76. middleware::throttle:111 85. /public/index.php:53

select `category`.`id`, `category`.`parent_id`, `category`.`title` from `category` where `category`.`status` = 'enable' and `category`.`right_value` >= '166' and `category`.`left_value` <= '165' and `category`.`depth` <= '2' order by `category`.`depth` desc

1.31ms/app/Repositories/BaseRepository.php:39couponsyr

Metadata
Bindings	0. enable 1. 166 2. 165 3. 2
Backtrace	11. /app/Repositories/BaseRepository.php:39 12. /app/Http/Controllers/Frontend/StoreController.php:105 28. /app/Http/Middleware/LinkRedirect.php:25 66. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 76. middleware::throttle:111 85. /public/index.php:53

select * from `store` inner join `store_n_category` on `store_n_category`.`store_id` = `store`.`id` where `store`.`status` = 'enable' and `store_n_category`.`category_id` in ('70', '4') order by `store`.`id` desc limit 10 offset 0

29.5ms/app/Repositories/BaseRepository.php:39couponsyr

Metadata
Bindings	0. enable 1. 70 2. 4
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /app/Repositories/BaseRepository.php:39 12. /app/Http/Controllers/Frontend/StoreController.php:115 28. /app/Http/Middleware/LinkRedirect.php:25 66. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 76. middleware::throttle:111 85. /public/index.php:53

select `coupon`.*, `store`.`slug` as `store_slug`, `store`.`image` as `store_image`, `store`.`title` as `store_title` from `coupon` inner join `store` on `coupon`.`store_id` = `store`.`id` inner join `coupon_n_category` on `coupon_n_category`.`coupon_id` = `coupon`.`id` where `coupon`.`status` = 'active' and `coupon`.`store_id` = '5298' and `coupon_n_category`.`category_id` = '70' order by `coupon`.`sorder_in_category` desc limit 20 offset 0

68.97ms/app/Repositories/BaseRepository.php:39couponsyr

Metadata
Bindings	0. active 1. 5298 2. 70
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /app/Repositories/BaseRepository.php:39 12. /app/Http/Controllers/Frontend/StoreController.php:127 28. /app/Http/Middleware/LinkRedirect.php:25 66. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 76. middleware::throttle:111 85. /public/index.php:53

select `coupon`.*, `store`.`slug` as `store_slug`, `store`.`image` as `store_image`, `store`.`title` as `store_title` from `coupon` inner join `store` on `coupon`.`store_id` = `store`.`id` inner join `coupon_n_category` on `coupon_n_category`.`coupon_id` = `coupon`.`id` where `coupon`.`status` = 'unreliable' and `coupon`.`store_id` = '5298' and `coupon_n_category`.`category_id` = '70' order by `coupon`.`sorder_in_category` desc limit 10 offset 0

77.44ms/app/Repositories/BaseRepository.php:39couponsyr

Metadata
Bindings	0. unreliable 1. 5298 2. 70
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /app/Repositories/BaseRepository.php:39 12. /app/Http/Controllers/Frontend/StoreController.php:130 28. /app/Http/Middleware/LinkRedirect.php:25 66. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 76. middleware::throttle:111 85. /public/index.php:53

select * from `category` inner join `store_n_category` on `store_n_category`.`category_id` = `category`.`id` where `category`.`status` = 'enable' and `store_n_category`.`store_id` = '5298' order by `category`.`id` desc limit 10 offset 0

2.53ms/app/Repositories/BaseRepository.php:39couponsyr

Metadata
Bindings	0. enable 1. 5298
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /app/Repositories/BaseRepository.php:39 12. /app/Http/Controllers/Frontend/StoreController.php:134 28. /app/Http/Middleware/LinkRedirect.php:25 66. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 76. middleware::throttle:111 85. /public/index.php:53

select * from `config` where `key` = 'site.defaultMetaTitle' limit 18.78ms/app/Models/Config.php:27couponsyr

Metadata
Bindings	0. site.defaultMetaTitle
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /app/Models/Config.php:27 13. /app/Http/Controllers/Frontend/StoreController.php:139 29. /app/Http/Middleware/LinkRedirect.php:25 67. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 77. middleware::throttle:111 86. /public/index.php:53

select count(*) as aggregate from `store` as `p` inner join `store_n_category` on `p`.`id` = `store_n_category`.`store_id` inner join `category` on `store_n_category`.`category_id` = `category`.`id` where 1 = 1 and `store_n_category`.`store_id` = '5298' order by `p`.`id` desc

2.07ms/app/Http/Controllers/Services/BaseService.php:68couponsyr

Metadata
Bindings	0. 5298
Backtrace	13. /app/Http/Controllers/Services/BaseService.php:68 14. /app/Http/Controllers/Services/StoreService.php:281 30. /vendor/barryvdh/laravel-cors/src/HandleCors.php:36 35. middleware::auth:34 65. /vendor/dingo/api/src/Routing/Adapter/Laravel.php:81 66. /vendor/dingo/api/src/Routing/Router.php:513 67. /vendor/dingo/api/src/Dispatcher.php:541 68. /vendor/dingo/api/src/Dispatcher.php:445 69. /vendor/dingo/api/src/Dispatcher.php:358 70. /app/Utils/Utils.php:448 71. /app/Utils/Utils.php:462 72. /app/Http/Controllers/Controller.php:51 73. /app/Http/Controllers/Controller.php:70 74. /app/Http/Controllers/Frontend/StoreController.php:146 90. /app/Http/Middleware/LinkRedirect.php:25 128. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 138. middleware::throttle:111 147. /public/index.php:53

Metadata

Bindings

0. 5298

Backtrace

13. /app/Http/Controllers/Services/BaseService.php:68
14. /app/Http/Controllers/Services/StoreService.php:281
30. /vendor/barryvdh/laravel-cors/src/HandleCors.php:36
35. middleware::auth:34
65. /vendor/dingo/api/src/Routing/Adapter/Laravel.php:81
66. /vendor/dingo/api/src/Routing/Router.php:513
67. /vendor/dingo/api/src/Dispatcher.php:541
68. /vendor/dingo/api/src/Dispatcher.php:445
69. /vendor/dingo/api/src/Dispatcher.php:358
70. /app/Utils/Utils.php:448
71. /app/Utils/Utils.php:462
72. /app/Http/Controllers/Controller.php:51
73. /app/Http/Controllers/Controller.php:70
74. /app/Http/Controllers/Frontend/StoreController.php:146
90. /app/Http/Middleware/LinkRedirect.php:25
128. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38
138. middleware::throttle:111
147. /public/index.php:53

select `p`.`id`, `p`.`title`, `p`.`slug`, `p`.`type`, `p`.`description`, `p`.`sorder`, `p`.`image` as `coverImage`, `p`.`auto_text` as `autoText`, `p`.`website` as `websiteUrl`, `p`.`affiliate_link` as `affiliateUrl`, `p`.`origin_link` as `originUrl`, `p`.`related_store` as `relatedTerms`, `p`.`status`, `p`.`vote_up` as `voteUp`, `p`.`vote_down` as `voteDown`, `p`.`meta_title` as `metaTitle`, `p`.`meta_description` as `metaDescription`, `p`.`meta_keywords` as `metaKeywords`, `p`.`views`, `p`.`clicks`, `p`.`creator_id` as `creatorId`, `p`.`create_name` as `creatorName`, `p`.`modifier_id` as `modifierId`, `p`.`modifier_name` as `modifierName`, `p`.`create_time` as `createTime`, `p`.`update_time` as `modifyTime`, `p`.`coupon_count` as `couponCount`, `p`.`inactive_affiliate` as `isInactiveAffiliate`, `p`.`content`, `p`.`config`, `category`.`id`, `category`.`parent_id` as `parentId`, `category`.`left_value` as `leftValue`, `category`.`right_value` as `rightValue`, `category`.`depth`, `category`.`title`, `category`.`image`, `category`.`description`, `category`.`slug`, `category`.`type`, `category`.`related_category` as `relatedCategory`, `category`.`sorder`, `category`.`vote_up` as `voteUp`, `category`.`vote_down` as `voteDown`, `category`.`meta_title` as `metaTitle`, `category`.`meta_description` as `metaDescription`, `category`.`meta_keywords` as `metaKeywords`, `category`.`status`, `category`.`creator_id` as `categoryId`, `category`.`creator_name` as `creatorName`, `category`.`modifier_id` as `modifierId`, `category`.`modifier_name` as `modifierName`, `category`.`create_time` as `createTime`, `category`.`update_time` as `modifyTime`, `category`.`coupon_count` as `couponCount` from `store` as `p` inner join `store_n_category` on `p`.`id` = `store_n_category`.`store_id` inner join `category` on `store_n_category`.`category_id` = `category`.`id` where 1 = 1 and `store_n_category`.`store_id` = '5298' order by `p`.`id` desc

6.81ms/app/Http/Controllers/Services/BaseService.php:70couponsyr

Metadata
Bindings	0. 5298
Backtrace	11. /app/Http/Controllers/Services/BaseService.php:70 12. /app/Http/Controllers/Services/StoreService.php:281 28. /vendor/barryvdh/laravel-cors/src/HandleCors.php:36 33. middleware::auth:34 63. /vendor/dingo/api/src/Routing/Adapter/Laravel.php:81 64. /vendor/dingo/api/src/Routing/Router.php:513 65. /vendor/dingo/api/src/Dispatcher.php:541 66. /vendor/dingo/api/src/Dispatcher.php:445 67. /vendor/dingo/api/src/Dispatcher.php:358 68. /app/Utils/Utils.php:448 69. /app/Utils/Utils.php:462 70. /app/Http/Controllers/Controller.php:51 71. /app/Http/Controllers/Controller.php:70 72. /app/Http/Controllers/Frontend/StoreController.php:146 88. /app/Http/Middleware/LinkRedirect.php:25 126. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 136. middleware::throttle:111 145. /public/index.php:53

Metadata

Bindings

0. 5298

Backtrace

11. /app/Http/Controllers/Services/BaseService.php:70
12. /app/Http/Controllers/Services/StoreService.php:281
28. /vendor/barryvdh/laravel-cors/src/HandleCors.php:36
33. middleware::auth:34
63. /vendor/dingo/api/src/Routing/Adapter/Laravel.php:81
64. /vendor/dingo/api/src/Routing/Router.php:513
65. /vendor/dingo/api/src/Dispatcher.php:541
66. /vendor/dingo/api/src/Dispatcher.php:445
67. /vendor/dingo/api/src/Dispatcher.php:358
68. /app/Utils/Utils.php:448
69. /app/Utils/Utils.php:462
70. /app/Http/Controllers/Controller.php:51
71. /app/Http/Controllers/Controller.php:70
72. /app/Http/Controllers/Frontend/StoreController.php:146
88. /app/Http/Middleware/LinkRedirect.php:25
126. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38
136. middleware::throttle:111
145. /public/index.php:53

select * from `category` where `status` = 'enable' and `left_value` <= '165' and `right_value` >= '166' order by `id` asc

10.06ms/app/Http/Controllers/Services/CategoryService.php:488couponsyr

Metadata
Bindings	0. enable 1. 165 2. 166
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /app/Http/Controllers/Services/CategoryService.php:488 27. /vendor/barryvdh/laravel-cors/src/HandleCors.php:36 32. middleware::auth:34 62. /vendor/dingo/api/src/Routing/Adapter/Laravel.php:81 63. /vendor/dingo/api/src/Routing/Router.php:513 64. /vendor/dingo/api/src/Dispatcher.php:541 65. /vendor/dingo/api/src/Dispatcher.php:445 66. /vendor/dingo/api/src/Dispatcher.php:358 67. /app/Utils/Utils.php:448 68. /app/Http/Controllers/Controller.php:43 69. /app/Http/Controllers/Controller.php:76 70. /app/Http/Controllers/Frontend/StoreController.php:146 86. /app/Http/Middleware/LinkRedirect.php:25 124. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 134. middleware::throttle:111 143. /public/index.php:53

select * from `config` where `key` = 'site.defaultMetaTitle' limit 112.33ms/app/Models/Config.php:27couponsyr

Metadata
Bindings	0. site.defaultMetaTitle
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /app/Models/Config.php:27 13. view::frontend.layout.meta:8 19. view::frontend.store.list:2 26. /vendor/symfony/http-foundation/Response.php:201 40. /app/Http/Middleware/LinkRedirect.php:25 78. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 88. middleware::throttle:111 97. /public/index.php:53

select * from `config` where `key` = 'site.defaultMetaDescription' limit 112.6ms/app/Models/Config.php:27couponsyr

Metadata
Bindings	0. site.defaultMetaDescription
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /app/Models/Config.php:27 13. view::frontend.layout.meta:9 19. view::frontend.store.list:2 26. /vendor/symfony/http-foundation/Response.php:201 40. /app/Http/Middleware/LinkRedirect.php:25 78. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 88. middleware::throttle:111 97. /public/index.php:53

select * from `config` where `key` = 'site.defaultMetaKeywords' limit 1290μs/app/Models/Config.php:27couponsyr

Metadata
Bindings	0. site.defaultMetaKeywords
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /app/Models/Config.php:27 13. view::frontend.layout.meta:10 19. view::frontend.store.list:2 26. /vendor/symfony/http-foundation/Response.php:201 40. /app/Http/Middleware/LinkRedirect.php:25 78. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 88. middleware::throttle:111 97. /public/index.php:53

select * from `meta_data` where `url` = '/lunchbox/yumbox' limit 1280μsview::frontend.layout.meta:15couponsyr

Metadata
Bindings	0. /lunchbox/yumbox
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. view::frontend.layout.meta:15 18. view::frontend.store.list:2 25. /vendor/symfony/http-foundation/Response.php:201 39. /app/Http/Middleware/LinkRedirect.php:25 77. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 87. middleware::throttle:111 96. /public/index.php:53

select `id`, `title`, `slug`, `image` from `category` where `status` = 'enable' and `type` = 'category' order by `coupon_count` desc limit 9

1.95ms/app/Models/Category.php:33couponsyr

Metadata
Bindings	0. enable 1. category
Backtrace	11. /app/Models/Category.php:33 12. view::frontend.layout.header:1 18. view::frontend.layout.master:114 24. view::frontend.store.list:138 31. /vendor/symfony/http-foundation/Response.php:201 45. /app/Http/Middleware/LinkRedirect.php:25 83. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 93. middleware::throttle:111 102. /public/index.php:53

select `id`, `title`, `slug`, `image` from `store` where `status` = 'enable' order by `coupon_count` desc limit 94.69ms/app/Models/Store.php:34couponsyr

Metadata
Bindings	0. enable
Backtrace	11. /app/Models/Store.php:34 12. view::frontend.layout.header:2 18. view::frontend.layout.master:114 24. view::frontend.store.list:138 31. /vendor/symfony/http-foundation/Response.php:201 45. /app/Http/Middleware/LinkRedirect.php:25 83. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 93. middleware::throttle:111 102. /public/index.php:53

select * from `config` where `key` = 'site.keyword.for.search' limit 1260μs/app/Models/Config.php:27couponsyr

Metadata
Bindings	0. site.keyword.for.search
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /app/Models/Config.php:27 13. view::frontend.layout.header:11 19. view::frontend.layout.master:114 25. view::frontend.store.list:138 32. /vendor/symfony/http-foundation/Response.php:201 46. /app/Http/Middleware/LinkRedirect.php:25 84. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 94. middleware::throttle:111 103. /public/index.php:53

select * from `config` where `key` = 'site.menu' limit 1210μsview::frontend.layout.header:85couponsyr

Metadata
Bindings	0. site.menu
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. view::frontend.layout.header:85 18. view::frontend.layout.master:114 24. view::frontend.store.list:138 31. /vendor/symfony/http-foundation/Response.php:201 45. /app/Http/Middleware/LinkRedirect.php:25 83. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38 93. middleware::throttle:111 102. /public/index.php:53

web: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
api: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]

_token: rdjeX3rUncwlUQ1Q9FZ3U6B9NJyEx4VRmPoOkKWO
_previous: array:1 [ "url" => "https://couponsyr.com/lunchbox/yumbox" ]
flash: array:2 [ "old" => [] "new" => [] ]
uId: m7556udtfa78om101wc6rpbu7i0h1
PHPDEBUGBAR_STACK_DATA: []

format: html
content_type: text/html; charset=UTF-8
status_text: OK
status_code: 200
request_query: []
request_request: []
request_headers: array:16 [ "host" => array:1 [ 0 => "couponsyr.com" ] "connection" => array:1 [ 0 => "...
request_server: array:51 [ "REDIRECT_UNIQUE_ID" => "Z9nK44WX4KxsW4F3B9GNvAAAAAs" "REDIRECT_SCRIPT_URL" => "/lunc...
request_cookies: array:1 [ "laravel_session" => "ea924749da806e7c64b94a51bd70b0b228833d7f" ]
response_headers: array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "content-type" => array:1 [ 0...
path_info: /lunchbox/yumbox
session_attributes: array:5 [ "_token" => "rdjeX3rUncwlUQ1Q9FZ3U6B9NJyEx4VRmPoOkKWO" "_previous" => array:1 [ "u...