YumBox Coupons

Shop now

Active YumBox Lunchbox Coupons & Promo codes

266.9msRequest Duration2MBMemory UsageGET {category}/{store}RouteAuth status
    • Booting (25.31ms)
    • Application (243.12ms)
      15 templates were rendered
      • frontend.store.list (resources/views/frontend/store/list.blade.php)12blade
        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
        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
      • frontend.common.breadcrumbs (resources/views/frontend/common/breadcrumbs.blade.php)1blade
        Params
        0
        breadcrumbs
      • frontend.common.item (resources/views/frontend/common/item.blade.php)27blade
        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)27blade
        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)27blade
        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)27blade
        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.sidebar-category-store (resources/views/frontend/common/sidebar-category-store.blade.php)30blade
        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
        includeParams
        27
        item
        28
        countDealAvaiable
        29
        typeItem
      • frontend.common.popular-box (resources/views/frontend/common/popular-box.blade.php)27blade
        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
        includeParams
      • frontend.common.breadcrumbs (resources/views/frontend/common/breadcrumbs.blade.php)1blade
        Params
        0
        breadcrumbs
      • frontend.layout.master (resources/views/frontend/layout/master.blade.php)27blade
        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
        includeParams
      • frontend.layout.header (resources/views/frontend/layout/header.blade.php)29blade
        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
        includeParams
        27
        couponTitle
        28
        uId
      • frontend.common.logo (resources/views/frontend/common/logo.blade.php)36blade
        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
        includeParams
        27
        couponTitle
        28
        uId
        29
        categoriesMenu
        30
        storesMenu
        31
        keywordsConfigForSearch
        32
        keywordsLink
        33
        keywordConfigs
        34
        item
        35
        searchKeyNoFollow
      • frontend.layout.footer (resources/views/frontend/layout/footer.blade.php)29blade
        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
        includeParams
        27
        couponTitle
        28
        uId
      • frontend.common.subscribe (resources/views/frontend/common/subscribe.blade.php)29blade
        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
        includeParams
        27
        couponTitle
        28
        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 unique202.5ms
      • select * from `link_redirect` where `link` = 'https://couponsyr.com/lunchbox/yumbox' limit 112.1ms/app/Models/Redirect.php:23couponsyr
        Metadata
        Bindings
        • 0. https://couponsyr.com/lunchbox/yumbox
        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` desc10.26ms/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` desc430μ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` desc230μ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` desc330μ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` = 'yumbox' and `store`.`status` = 'enable' order by `store`.`id` desc31.66ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. yumbox
        • 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` = 'lunchbox' and `category`.`status` = 'enable' order by `category`.`id` desc2.46ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. lunchbox
        • 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` >= '166' and `category`.`left_value` <= '165' and `category`.`depth` <= '2' order by `category`.`depth` desc2.76ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. enable
        • 1. 166
        • 2. 165
        • 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 ('70', '4') order by `store`.`id` desc limit 10 offset 05.96ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. enable
        • 1. 70
        • 2. 4
        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` = '5298' and `coupon_n_category`.`category_id` = '70' order by `coupon`.`sorder_in_category` desc limit 20 offset 046.14ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. active
        • 1. 5298
        • 2. 70
        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` = '5298' and `coupon_n_category`.`category_id` = '70' order by `coupon`.`sorder_in_category` desc limit 10 offset 044.08ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. unreliable
        • 1. 5298
        • 2. 70
        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` = '5298' order by `category`.`id` desc limit 10 offset 02.53ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. enable
        • 1. 5298
        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 1440μ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` = '5298' order by `p`.`id` desc7.15ms/app/Http/Controllers/Services/BaseService.php:68couponsyr
        Metadata
        Bindings
        • 0. 5298
        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` = '5298' order by `p`.`id` desc6.71ms/app/Http/Controllers/Services/BaseService.php:70couponsyr
        Metadata
        Bindings
        • 0. 5298
        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` <= '165' and `right_value` >= '166' order by `id` asc5.35ms/app/Http/Controllers/Services/CategoryService.php:488couponsyr
        Metadata
        Bindings
        • 0. enable
        • 1. 165
        • 2. 166
        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 11.17ms/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 1720μ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 13.71ms/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` = '/lunchbox/yumbox' limit 1280μsview::frontend.layout.meta:15couponsyr
        Metadata
        Bindings
        • 0. /lunchbox/yumbox
        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 9940μs/app/Models/Category.php:33couponsyr
        Metadata
        Bindings
        • 0. enable
        • 1. category
        Backtrace
        • 11. /app/Models/Category.php:33
        • 12. view::frontend.layout.header:1
        • 18. view::frontend.layout.master:114
        • 24. view::frontend.store.list:138
        • 31. /vendor/symfony/http-foundation/Response.php:201
        • 45. /app/Http/Middleware/LinkRedirect.php:25
        • 83. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38
        • 93. middleware::throttle:111
        • 102. /public/index.php:53
      • select `id`, `title`, `slug`, `image` from `store` where `status` = 'enable' order by `coupon_count` desc limit 95ms/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 111.88ms/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 1210μ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
          8MKMp4CroIFDnLzBWfBrpwKgzKlHFKA8eTLPmD14
          _previous
          array:1 [ "url" => "https://couponsyr.com/lunchbox/yumbox" ]
          uId
          u5y8qlmldwcfh8f2dzlfv5kyr23a9
          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" => "Z9UhoeYnbK6SQ@PllSl12QAAAAs" "REDIRECT_SCRIPT_URL" => "/lunc...
          request_cookies
          array:1 [ "laravel_session" => "da174623c4cb21b190550c6860012017bb85c245" ]
          response_headers
          array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "content-type" => array:1 [ 0...
          path_info
          /lunchbox/yumbox
          session_attributes
          array:5 [ "_token" => "8MKMp4CroIFDnLzBWfBrpwKgzKlHFKA8eTLPmD14" "_previous" => array:1 [ "u...