Lagence Discount Codes

Shop now

Active Lagence Holiday Coupons & Promo codes

15%

Off

15% OFF On Full Priced Orders + FREE Shipping

Details: Apply this code and get 15% OFF on full priced orders + FREE shipping at Lagence. Hurry up!

Expires On going

Show Code ATTE7WHFQL

Unreliable Lagence Holiday Coupons & Promo codes

Deal

Holiday Gifts From $58 Only

Details: Enjoy holiday gifts from $58 only at Lagence. Go for it now!

Expired Dec 25, 2024

Get Deal

Messages Timeline Exceptions Views13 Route Queries24 Mails Auth Gate Session Request

521.8ms4MBGET {category}/{store}

Booting (27.58ms)
Application (496.94ms)

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)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)28blade


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
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	`coupon`
24	`listRouteNameCategoryStore`
25	`activeCoupon`
26	`unreliableCoupon`
27	`item`

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


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
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	`coupon`
24	`listRouteNameCategoryStore`
25	`activeCoupon`
26	`unreliableCoupon`
27	`includeParams`
28	`item`
29	`countDealAvaiable`
30	`typeItem`

frontend.common.popular-box (resources/views/frontend/common/popular-box.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
coupon
listRouteNameCategoryStore
activeCoupon
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	`coupon`
24	`listRouteNameCategoryStore`
25	`activeCoupon`
26	`unreliableCoupon`
27	`includeParams`

Params
0	`breadcrumbs`

frontend.layout.master (resources/views/frontend/layout/master.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
coupon
listRouteNameCategoryStore
activeCoupon
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	`coupon`
24	`listRouteNameCategoryStore`
25	`activeCoupon`
26	`unreliableCoupon`
27	`includeParams`

frontend.layout.header (resources/views/frontend/layout/header.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
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	`coupon`
24	`listRouteNameCategoryStore`
25	`activeCoupon`
26	`unreliableCoupon`
27	`includeParams`
28	`couponTitle`
29	`uId`

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


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
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	`coupon`
24	`listRouteNameCategoryStore`
25	`activeCoupon`
26	`unreliableCoupon`
27	`includeParams`
28	`couponTitle`
29	`uId`
30	`categoriesMenu`
31	`storesMenu`
32	`keywordsConfigForSearch`
33	`keywordsLink`
34	`keywordConfigs`
35	`item`
36	`searchKeyNoFollow`

frontend.layout.footer (resources/views/frontend/layout/footer.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
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	`coupon`
24	`listRouteNameCategoryStore`
25	`activeCoupon`
26	`unreliableCoupon`
27	`includeParams`
28	`couponTitle`
29	`uId`

frontend.common.subscribe (resources/views/frontend/common/subscribe.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
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	`coupon`
24	`listRouteNameCategoryStore`
25	`activeCoupon`
26	`unreliableCoupon`
27	`includeParams`
28	`couponTitle`
29	`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 unique465.52ms

select * from `link_redirect` where `link` = 'https://couponsyr.com/holiday/lagence' limit 15.18ms/app/Models/Redirect.php:23couponsyr

Metadata
Bindings	0. https://couponsyr.com/holiday/lagence
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` desc670μ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

9.19ms/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` desc340μ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

470μ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` = 'lagence' and `store`.`status` = 'enable' order by `store`.`id` desc88.52ms/app/Repositories/BaseRepository.php:39couponsyr

Metadata
Bindings	0. lagence 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` = 'holiday' and `category`.`status` = 'enable' order by `category`.`id` desc

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

Metadata
Bindings	0. holiday 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` >= '993' and `category`.`left_value` <= '954' and `category`.`depth` <= '1' order by `category`.`depth` desc

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

Metadata
Bindings	0. enable 1. 993 2. 954 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 ('363') order by `store`.`id` desc limit 10 offset 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Metadata
Bindings	0. enable 1. 640 2. 905
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.65ms/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 1240μ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 1380μ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` = '/holiday/lagence' limit 1540μsview::frontend.layout.meta:15couponsyr

Metadata
Bindings	0. /holiday/lagence
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

27.56ms/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 99.76ms/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 1340μ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: f4PQsuQcXPoUCcBg0M8LfX8bH6FCP0k7YfHE9tvN
_previous: array:1 [ "url" => "https://couponsyr.com/holiday/lagence" ]
uId: am80xlk0fpiwqmxb30ypflzoiudjy
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" => "Z@zhLInE7j6tlq3AvWNUJgAAAAk" "REDIRECT_SCRIPT_URL" => "/holi...
request_cookies: []
response_headers: array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "content-type" => array:1 [ 0...
path_info: /holiday/lagence
session_attributes: array:4 [ "_token" => "f4PQsuQcXPoUCcBg0M8LfX8bH6FCP0k7YfHE9tvN" "_previous" => array:1 [ "u...