Macy's Coupon Code 25 Off Family And Friends 2025 & Deals

Macy's Coupons

Shop now

Unreliable Macy's Labor Day Coupons & Promo codes

20%

Off

Extra 20% OFF Macy's Labor Day Sale + FREE Shipping On $49+

Details: Check out this code and get extra 20% OFF Macy's Labor Day sale + FREE shipping on orders of $49+. Be quick!

Expired Sep 03, 2018

Show Code WKND

Messages Timeline Exceptions Views12 Route Queries24 Mails Auth Gate Session Request

121.63ms2MBGET {category}/{store}

Booting (12.1ms)
Application (111.05ms)

12 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)26blade


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
store
title
storeNameTracking
storeIdTracking
slug
activeCoupons
breadcrumbs
unreliableCoupons
relatedStores
category
relatedCategories
activeCouponsSearch
couponSchema
numberCouponCode
numberDeal
numberPrintAble
listRouteNameCategoryStore
unreliableCoupon
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	`listRouteNameCategoryStore`
24	`unreliableCoupon`
25	`item`

frontend.common.sidebar-category-store (resources/views/frontend/common/sidebar-category-store.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
listRouteNameCategoryStore
unreliableCoupon
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	`listRouteNameCategoryStore`
24	`unreliableCoupon`
25	`includeParams`
26	`item`
27	`countDealAvaiable`
28	`typeItem`

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


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
store
title
storeNameTracking
storeIdTracking
slug
activeCoupons
breadcrumbs
unreliableCoupons
relatedStores
category
relatedCategories
activeCouponsSearch
couponSchema
numberCouponCode
numberDeal
numberPrintAble
listRouteNameCategoryStore
unreliableCoupon
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	`listRouteNameCategoryStore`
24	`unreliableCoupon`
25	`includeParams`

Params
0	`breadcrumbs`

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


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
store
title
storeNameTracking
storeIdTracking
slug
activeCoupons
breadcrumbs
unreliableCoupons
relatedStores
category
relatedCategories
activeCouponsSearch
couponSchema
numberCouponCode
numberDeal
numberPrintAble
listRouteNameCategoryStore
unreliableCoupon
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	`listRouteNameCategoryStore`
24	`unreliableCoupon`
25	`includeParams`

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


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
store
title
storeNameTracking
storeIdTracking
slug
activeCoupons
breadcrumbs
unreliableCoupons
relatedStores
category
relatedCategories
activeCouponsSearch
couponSchema
numberCouponCode
numberDeal
numberPrintAble
listRouteNameCategoryStore
unreliableCoupon
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	`listRouteNameCategoryStore`
24	`unreliableCoupon`
25	`includeParams`
26	`couponTitle`
27	`uId`

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


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
store
title
storeNameTracking
storeIdTracking
slug
activeCoupons
breadcrumbs
unreliableCoupons
relatedStores
category
relatedCategories
activeCouponsSearch
couponSchema
numberCouponCode
numberDeal
numberPrintAble
listRouteNameCategoryStore
unreliableCoupon
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	`listRouteNameCategoryStore`
24	`unreliableCoupon`
25	`includeParams`
26	`couponTitle`
27	`uId`
28	`categoriesMenu`
29	`storesMenu`
30	`keywordsConfigForSearch`
31	`keywordsLink`
32	`keywordConfigs`
33	`item`
34	`searchKeyNoFollow`

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


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
store
title
storeNameTracking
storeIdTracking
slug
activeCoupons
breadcrumbs
unreliableCoupons
relatedStores
category
relatedCategories
activeCouponsSearch
couponSchema
numberCouponCode
numberDeal
numberPrintAble
listRouteNameCategoryStore
unreliableCoupon
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	`listRouteNameCategoryStore`
24	`unreliableCoupon`
25	`includeParams`
26	`couponTitle`
27	`uId`

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


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
store
title
storeNameTracking
storeIdTracking
slug
activeCoupons
breadcrumbs
unreliableCoupons
relatedStores
category
relatedCategories
activeCouponsSearch
couponSchema
numberCouponCode
numberDeal
numberPrintAble
listRouteNameCategoryStore
unreliableCoupon
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	`listRouteNameCategoryStore`
24	`unreliableCoupon`
25	`includeParams`
26	`couponTitle`
27	`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 unique81.32ms

select * from `link_redirect` where `link` = 'https://couponsyr.com/labor-day/macy-s' limit 14.32ms/app/Models/Redirect.php:23couponsyr

Metadata
Bindings	0. https://couponsyr.com/labor-day/macy-s
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` desc300μs/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

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

320μ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` = 'macy-s' and `store`.`status` = 'enable' order by `store`.`id` desc11.54ms/app/Repositories/BaseRepository.php:39couponsyr

Metadata
Bindings	0. macy-s 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` = 'labor-day' and `category`.`status` = 'enable' order by `category`.`id` desc

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

Metadata
Bindings	0. labor-day 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` >= '2387' and `category`.`left_value` <= '2386' and `category`.`depth` <= '1' order by `category`.`depth` desc

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

Metadata
Bindings	0. enable 1. 2387 2. 2386 3. 1
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 ('7815') order by `store`.`id` desc limit 10 offset 0

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

Metadata
Bindings	0. enable 1. 7815
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` = '436' and `coupon_n_category`.`category_id` = '7815' order by `coupon`.`sorder_in_category` desc limit 20 offset 0

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

Metadata
Bindings	0. active 1. 436 2. 7815
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` = '436' and `coupon_n_category`.`category_id` = '7815' order by `coupon`.`sorder_in_category` desc limit 10 offset 0

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

Metadata
Bindings	0. unreliable 1. 436 2. 7815
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` = '436' order by `category`.`id` desc limit 10 offset 0

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

Metadata
Bindings	0. enable 1. 436
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 1270μs/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` = '436' order by `p`.`id` desc

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

Metadata
Bindings	0. 436
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. 436

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` = '436' order by `p`.`id` desc

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

Metadata
Bindings	0. 436
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. 436

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` <= '8' and `right_value` >= '11' order by `id` asc2ms/app/Http/Controllers/Services/CategoryService.php:488couponsyr

Metadata
Bindings	0. enable 1. 8 2. 11
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 1250μs/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 1220μs/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 1200μ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` = '/labor-day/macy-s' limit 1240μsview::frontend.layout.meta:15couponsyr

Metadata
Bindings	0. /labor-day/macy-s
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

870μs/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.29ms/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 1240μ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 1220μ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: SQOroqThSOjvD4GUhMUmUdS8HHbavpQGFMLHUqj8
_previous: array:1 [ "url" => "https://couponsyr.com/labor-day/macy-s" ]
flash: array:2 [ "old" => [] "new" => [] ]
uId: x6tb8f7cb1k7bosjfovq65cld1agm
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" => "Z9oKIYO-KolZz755R9cIbgAAAAU" "REDIRECT_SCRIPT_URL" => "/labo...
request_cookies: array:1 [ "laravel_session" => "2de747ad162e3dab34d6f73a92b7b1346bfa9031" ]
response_headers: array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "content-type" => array:1 [ 0...
path_info: /labor-day/macy-s
session_attributes: array:5 [ "_token" => "SQOroqThSOjvD4GUhMUmUdS8HHbavpQGFMLHUqj8" "_previous" => array:1 [ "u...