Jos A Bank Promo Code 03 2025: Find Jos A Bank Coupons & Discount Codes

Jos A Bank Coupons

Unreliable Jos A Bank Men's Shoes Coupons & Promo codes

85%

Off

Up To 85% OFF Clearance When You Take An Extra 60% OFF Original Prices | Green Monday Sale

Details: Grab this promo and enjoy up to 85% OFF clearance when you take an extra 60% OFF original prices during Green Monday sale at Jos A Bank. Shop now!

...More »

Expired Dec 11, 2018

Get Deal

Deal

Buy One Get One FREE Sale

Details: Buy One Get One FREE Sale at Jos A Bank. Shop now!

Expired Mar 18, 2018

Get Deal

Messages Timeline Exceptions Views13 Route Queries24 Mails Auth Gate Session Request

136.14ms2MBGET {category}/{store}

Booting (13.41ms)
Application (124.73ms)

13 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.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 unique93.69ms

select * from `link_redirect` where `link` = 'https://couponsyr.com/men-s-shoes/jos-a-bank' limit 15.62ms/app/Models/Redirect.php:23couponsyr

Metadata
Bindings	0. https://couponsyr.com/men-s-shoes/jos-a-bank
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` desc430μ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

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

310μ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` = 'jos-a-bank' and `store`.`status` = 'enable' order by `store`.`id` desc12.41ms/app/Repositories/BaseRepository.php:39couponsyr

Metadata
Bindings	0. jos-a-bank 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` = 'men-s-shoes' and `category`.`status` = 'enable' order by `category`.`id` desc

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

Metadata
Bindings	0. men-s-shoes 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` >= '932' and `category`.`left_value` <= '929' and `category`.`depth` <= '2' order by `category`.`depth` desc

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

Metadata
Bindings	0. enable 1. 932 2. 929 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 ('1344', '362') order by `store`.`id` desc limit 10 offset 0

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

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

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

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

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

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

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

Metadata
Bindings	0. enable 1. 1390
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 1320μ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` = '1390' order by `p`.`id` desc

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

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

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

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

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

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` <= '699' and `right_value` >= '714' order by `id` asc

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

Metadata
Bindings	0. enable 1. 699 2. 714
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 1500μ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 1290μ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 1260μ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` = '/men-s-shoes/jos-a-bank' limit 1320μsview::frontend.layout.meta:15couponsyr

Metadata
Bindings	0. /men-s-shoes/jos-a-bank
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.27ms/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 95.11ms/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 1450μ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 1350μ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: D35ATeaOSOgOW5ubFucVRNN4C8xkeVNzQre5Rl6L
_previous: array:1 [ "url" => "https://couponsyr.com/men-s-shoes/jos-a-bank" ]
uId: 2yrpc4u2guqyhpon25hkcmus59mti
PHPDEBUGBAR_STACK_DATA: []
flash: array:2 [ "old" => [] "new" => [] ]

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" => "Z9UssUGwVH6uGCihO4cAbQAAAAI" "REDIRECT_SCRIPT_URL" => "/men-...
request_cookies: array:1 [ "laravel_session" => "6871ca1667013d4bb8d31dc50fa60197d52f80bd" ]
response_headers: array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "content-type" => array:1 [ 0...
path_info: /men-s-shoes/jos-a-bank
session_attributes: array:5 [ "_token" => "D35ATeaOSOgOW5ubFucVRNN4C8xkeVNzQre5Rl6L" "_previous" => array:1 [ "u...