Category Reference Books

Reference Books don't have any coupons

Messages Timeline Exceptions Views10 Route Queries18 Mails Auth Gate Session Request

391.99ms4MBGET coupon-category/{slug}

Booting (28.83ms)
Application (364.85ms)

10 templates were rendered

frontend.category.list (resources/views/frontend/category/list.blade.php)10blade


recommendStores
unreliableCoupons
breadcrumbs
category
activeCoupons
slug
title
relatedCoupon
dataCoupon
activeCouponsSearch

Params
0	`recommendStores`
1	`unreliableCoupons`
2	`breadcrumbs`
3	`category`
4	`activeCoupons`
5	`slug`
6	`title`
7	`relatedCoupon`
8	`dataCoupon`
9	`activeCouponsSearch`

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


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
recommendStores
unreliableCoupons
breadcrumbs
category
activeCoupons
slug
title
relatedCoupon
dataCoupon
activeCouponsSearch
data

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`remarketingType`
5	`popularStoresConfig`
6	`popularCategoriesConfig`
7	`recommendStores`
8	`unreliableCoupons`
9	`breadcrumbs`
10	`category`
11	`activeCoupons`
12	`slug`
13	`title`
14	`relatedCoupon`
15	`dataCoupon`
16	`activeCouponsSearch`
17	`data`

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


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
recommendStores
unreliableCoupons
breadcrumbs
category
activeCoupons
slug
title
relatedCoupon
dataCoupon
activeCouponsSearch
numberCouponCode
numberDeal
numberPrintAble
includeParams
item
countDealAvaiable
relatedStores
typeItem

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`remarketingType`
5	`popularStoresConfig`
6	`popularCategoriesConfig`
7	`recommendStores`
8	`unreliableCoupons`
9	`breadcrumbs`
10	`category`
11	`activeCoupons`
12	`slug`
13	`title`
14	`relatedCoupon`
15	`dataCoupon`
16	`activeCouponsSearch`
17	`numberCouponCode`
18	`numberDeal`
19	`numberPrintAble`
20	`includeParams`
21	`item`
22	`countDealAvaiable`
23	`relatedStores`
24	`typeItem`

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


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
recommendStores
unreliableCoupons
breadcrumbs
category
activeCoupons
slug
title
relatedCoupon
dataCoupon
activeCouponsSearch
numberCouponCode
numberDeal
numberPrintAble
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	`recommendStores`
8	`unreliableCoupons`
9	`breadcrumbs`
10	`category`
11	`activeCoupons`
12	`slug`
13	`title`
14	`relatedCoupon`
15	`dataCoupon`
16	`activeCouponsSearch`
17	`numberCouponCode`
18	`numberDeal`
19	`numberPrintAble`
20	`includeParams`

Params
0	`breadcrumbs`

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


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
recommendStores
unreliableCoupons
breadcrumbs
category
activeCoupons
slug
title
relatedCoupon
dataCoupon
activeCouponsSearch
numberCouponCode
numberDeal
numberPrintAble
includeParams

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`remarketingType`
5	`popularStoresConfig`
6	`popularCategoriesConfig`
7	`recommendStores`
8	`unreliableCoupons`
9	`breadcrumbs`
10	`category`
11	`activeCoupons`
12	`slug`
13	`title`
14	`relatedCoupon`
15	`dataCoupon`
16	`activeCouponsSearch`
17	`numberCouponCode`
18	`numberDeal`
19	`numberPrintAble`
20	`includeParams`

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


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
recommendStores
unreliableCoupons
breadcrumbs
category
activeCoupons
slug
title
relatedCoupon
dataCoupon
activeCouponsSearch
numberCouponCode
numberDeal
numberPrintAble
includeParams
couponTitle
uId

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`remarketingType`
5	`popularStoresConfig`
6	`popularCategoriesConfig`
7	`recommendStores`
8	`unreliableCoupons`
9	`breadcrumbs`
10	`category`
11	`activeCoupons`
12	`slug`
13	`title`
14	`relatedCoupon`
15	`dataCoupon`
16	`activeCouponsSearch`
17	`numberCouponCode`
18	`numberDeal`
19	`numberPrintAble`
20	`includeParams`
21	`couponTitle`
22	`uId`

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


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
recommendStores
unreliableCoupons
breadcrumbs
category
activeCoupons
slug
title
relatedCoupon
dataCoupon
activeCouponsSearch
numberCouponCode
numberDeal
numberPrintAble
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	`recommendStores`
8	`unreliableCoupons`
9	`breadcrumbs`
10	`category`
11	`activeCoupons`
12	`slug`
13	`title`
14	`relatedCoupon`
15	`dataCoupon`
16	`activeCouponsSearch`
17	`numberCouponCode`
18	`numberDeal`
19	`numberPrintAble`
20	`includeParams`
21	`couponTitle`
22	`uId`
23	`categoriesMenu`
24	`storesMenu`
25	`keywordsConfigForSearch`
26	`keywordsLink`
27	`keywordConfigs`
28	`item`
29	`searchKeyNoFollow`

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


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
recommendStores
unreliableCoupons
breadcrumbs
category
activeCoupons
slug
title
relatedCoupon
dataCoupon
activeCouponsSearch
numberCouponCode
numberDeal
numberPrintAble
includeParams
couponTitle
uId

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`remarketingType`
5	`popularStoresConfig`
6	`popularCategoriesConfig`
7	`recommendStores`
8	`unreliableCoupons`
9	`breadcrumbs`
10	`category`
11	`activeCoupons`
12	`slug`
13	`title`
14	`relatedCoupon`
15	`dataCoupon`
16	`activeCouponsSearch`
17	`numberCouponCode`
18	`numberDeal`
19	`numberPrintAble`
20	`includeParams`
21	`couponTitle`
22	`uId`

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


obLevel
__env
app
errors
remarketingType
popularStoresConfig
popularCategoriesConfig
recommendStores
unreliableCoupons
breadcrumbs
category
activeCoupons
slug
title
relatedCoupon
dataCoupon
activeCouponsSearch
numberCouponCode
numberDeal
numberPrintAble
includeParams
couponTitle
uId

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`remarketingType`
5	`popularStoresConfig`
6	`popularCategoriesConfig`
7	`recommendStores`
8	`unreliableCoupons`
9	`breadcrumbs`
10	`category`
11	`activeCoupons`
12	`slug`
13	`title`
14	`relatedCoupon`
15	`dataCoupon`
16	`activeCouponsSearch`
17	`numberCouponCode`
18	`numberDeal`
19	`numberPrintAble`
20	`includeParams`
21	`couponTitle`
22	`uId`

uri: GET coupon-category/{slug}
middleware: web, redirect
as: frontend::category::listByCategory
controller: App\Http\Controllers\Frontend\CategoryController@listByCategory
namespace: App\Http\Controllers\Frontend
prefix: null
where
file: app/Http/Controllers/Frontend/CategoryController.php:13-51

18 statements were executed317.92ms

select * from `link_redirect` where `link` = 'https://couponsyr.com/coupon-category/reference-books' limit 15.54ms/app/Models/Redirect.php:23couponsyr

Metadata
Bindings	0. https://couponsyr.com/coupon-category/reference-books
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` desc16.98ms/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

640μ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` desc380μ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

8.71ms/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 `category` where `category`.`slug` = 'reference-books' and `category`.`status` = 'enable' order by `category`.`id` desc

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

Metadata
Bindings	0. reference-books 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/CategoryController.php:16 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 `status` = 'enable' and `left_value` <= '530' and `right_value` >= '543' order by `id` asc

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

Metadata
Bindings	0. enable 1. 530 2. 543
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:93 70. /app/Http/Controllers/Frontend/CategoryController.php:28 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 `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_n_category`.`category_id` = '228' order by `coupon`.`sorder_in_category` desc limit 25 offset 0

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

Metadata
Bindings	0. active 1. 228
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /app/Repositories/BaseRepository.php:39 12. /app/Http/Controllers/Frontend/CategoryController.php:30 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_n_category`.`category_id` = '228' order by `coupon`.`sorder_in_category` desc limit 10 offset 0

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

Metadata
Bindings	0. unreliable 1. 228
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /app/Repositories/BaseRepository.php:39 12. /app/Http/Controllers/Frontend/CategoryController.php:33 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` = '228' order by `store`.`id` desc limit 5 offset 0

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

Metadata
Bindings	0. enable 1. 228
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /app/Repositories/BaseRepository.php:39 12. /app/Http/Controllers/Frontend/CategoryController.php:35 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 12.53ms/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.category.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 1210μ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.category.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.category.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` = '/coupon-category/reference-books' limit 18.62msview::frontend.layout.meta:15couponsyr

Metadata
Bindings	0. /coupon-category/reference-books
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.category.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

12.12ms/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.category.list:89 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.36ms/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.category.list:89 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 121.75ms/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.category.list:89 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 1260μ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.category.list:89 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: 2EaTX7A4uJGLhg6Zj4gyfGsfN7fa0Iy98AWHLRT7
_previous: array:1 [ "url" => "https://couponsyr.com/coupon-category/reference-books" ]
uId: k4jo5ofsvenax7q1ooxtt9r91unsk
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:15 [ "host" => array:1 [ 0 => "couponsyr.com" ] "connection" => array:1 [ 0 => "...
request_server: array:50 [ "REDIRECT_UNIQUE_ID" => "Z9S5@qsfrtYQV2jLKBMNqAAAAAo" "REDIRECT_SCRIPT_URL" => "/coup...
request_cookies: []
response_headers: array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "content-type" => array:1 [ 0...
path_info: /coupon-category/reference-books
session_attributes: array:4 [ "_token" => "2EaTX7A4uJGLhg6Zj4gyfGsfN7fa0Iy98AWHLRT7" "_previous" => array:1 [ "u...