TicketLeap Discount Codes

Shop now

Active TicketLeap Business Software Coupons & Promo codes

Deal

FREE Online Event Registration

Details: Find FREE Online Event Registration at TicketLeap!

Expires On going

Get Deal

Unreliable TicketLeap Business Software Coupons & Promo codes

50%

Off

Up To 50% OFF General Admission And VIP Packages For Indie 2 Major Nye 2017 Celebration In Mobile, AL

Details: Use this discount code during checkout to get Up To 50% OFF General Admission And VIP Packages For Indie 2 Major Nye 2017 Celebration In Mobile, AL!

...More »

Expired Dec 28, 2016

Show Code BlackFriday

Messages Timeline Exceptions Views13 Route Queries24 Mails Auth Gate Session Request

502.53ms4MBGET {category}/{store}

Booting (33.68ms)
Application (470.34ms)

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 unique432.08ms

select * from `link_redirect` where `link` = 'https://couponsyr.com/business-software/ticketleap' limit 14.24ms/app/Models/Redirect.php:23couponsyr

Metadata
Bindings	0. https://couponsyr.com/business-software/ticketleap
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` desc450μ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

7.63ms/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` desc300μ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` = 'ticketleap' and `store`.`status` = 'enable' order by `store`.`id` desc64.31ms/app/Repositories/BaseRepository.php:39couponsyr

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

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

Metadata
Bindings	0. business-software 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` >= '2196' and `category`.`left_value` <= '2193' and `category`.`depth` <= '2' order by `category`.`depth` desc

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

Metadata
Bindings	0. enable 1. 2196 2. 2193 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 ('973', '867') order by `store`.`id` desc limit 10 offset 0

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

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

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

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

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

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

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

Metadata
Bindings	0. enable 1. 972
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 112.8ms/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` = '972' order by `p`.`id` desc

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

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

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

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

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

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

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

Metadata
Bindings	0. enable 1. 2193 2. 2196
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 110.61ms/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 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.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 1210μ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` = '/business-software/ticketleap' limit 1240μsview::frontend.layout.meta:15couponsyr

Metadata
Bindings	0. /business-software/ticketleap
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

19.84ms/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 910.98ms/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 15.49ms/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 14.38msview::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: HOXgie6oSIz8QqvoMSILVyrGX9tVDGpolkRwHTkx
_previous: array:1 [ "url" => "https://couponsyr.com/business-software/ticketleap" ]
uId: ikzhtzi6t7sb3u0nxa1dgg95pij0b
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" => "Z9QLkSpcviYVguvKwv9sUgAAABE" "REDIRECT_SCRIPT_URL" => "/busi...
request_cookies: []
response_headers: array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "content-type" => array:1 [ 0...
path_info: /business-software/ticketleap
session_attributes: array:4 [ "_token" => "HOXgie6oSIz8QqvoMSILVyrGX9tVDGpolkRwHTkx" "_previous" => array:1 [ "u...