Unreliable St. Patrick's Day Coupons & Promo codes

92.03msRequest Duration4MBMemory UsageGET coupon-category/{slug}RouteAuth status
    • Booting (16.06ms)
    • Application (78.2ms)
      11 templates were rendered
      • frontend.category.list (resources/views/frontend/category/list.blade.php)10blade
        Params
        0
        recommendStores
        1
        unreliableCoupons
        2
        breadcrumbs
        3
        category
        4
        activeCoupons
        5
        slug
        6
        title
        7
        relatedCoupon
        8
        dataCoupon
        9
        activeCouponsSearch
      • frontend.layout.meta (resources/views/frontend/layout/meta.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        remarketingType
        5
        popularStoresConfig
        6
        popularCategoriesConfig
        7
        recommendStores
        8
        unreliableCoupons
        9
        breadcrumbs
        10
        category
        11
        activeCoupons
        12
        slug
        13
        title
        14
        relatedCoupon
        15
        dataCoupon
        16
        activeCouponsSearch
        17
        data
      • frontend.common.sidebar-category-store (resources/views/frontend/common/sidebar-category-store.blade.php)25blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        remarketingType
        5
        popularStoresConfig
        6
        popularCategoriesConfig
        7
        recommendStores
        8
        unreliableCoupons
        9
        breadcrumbs
        10
        category
        11
        activeCoupons
        12
        slug
        13
        title
        14
        relatedCoupon
        15
        dataCoupon
        16
        activeCouponsSearch
        17
        numberCouponCode
        18
        numberDeal
        19
        numberPrintAble
        20
        includeParams
        21
        item
        22
        countDealAvaiable
        23
        relatedStores
        24
        typeItem
      • frontend.common.item (resources/views/frontend/common/item.blade.php)23blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        remarketingType
        5
        popularStoresConfig
        6
        popularCategoriesConfig
        7
        recommendStores
        8
        unreliableCoupons
        9
        breadcrumbs
        10
        category
        11
        activeCoupons
        12
        slug
        13
        title
        14
        relatedCoupon
        15
        dataCoupon
        16
        activeCouponsSearch
        17
        numberCouponCode
        18
        numberDeal
        19
        numberPrintAble
        20
        includeParams
        21
        unreliableCoupon
        22
        item
      • frontend.common.popular-box (resources/views/frontend/common/popular-box.blade.php)22blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        remarketingType
        5
        popularStoresConfig
        6
        popularCategoriesConfig
        7
        recommendStores
        8
        unreliableCoupons
        9
        breadcrumbs
        10
        category
        11
        activeCoupons
        12
        slug
        13
        title
        14
        relatedCoupon
        15
        dataCoupon
        16
        activeCouponsSearch
        17
        numberCouponCode
        18
        numberDeal
        19
        numberPrintAble
        20
        includeParams
        21
        unreliableCoupon
      • frontend.common.breadcrumbs (resources/views/frontend/common/breadcrumbs.blade.php)1blade
        Params
        0
        breadcrumbs
      • frontend.layout.master (resources/views/frontend/layout/master.blade.php)22blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        remarketingType
        5
        popularStoresConfig
        6
        popularCategoriesConfig
        7
        recommendStores
        8
        unreliableCoupons
        9
        breadcrumbs
        10
        category
        11
        activeCoupons
        12
        slug
        13
        title
        14
        relatedCoupon
        15
        dataCoupon
        16
        activeCouponsSearch
        17
        numberCouponCode
        18
        numberDeal
        19
        numberPrintAble
        20
        includeParams
        21
        unreliableCoupon
      • frontend.layout.header (resources/views/frontend/layout/header.blade.php)24blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        remarketingType
        5
        popularStoresConfig
        6
        popularCategoriesConfig
        7
        recommendStores
        8
        unreliableCoupons
        9
        breadcrumbs
        10
        category
        11
        activeCoupons
        12
        slug
        13
        title
        14
        relatedCoupon
        15
        dataCoupon
        16
        activeCouponsSearch
        17
        numberCouponCode
        18
        numberDeal
        19
        numberPrintAble
        20
        includeParams
        21
        unreliableCoupon
        22
        couponTitle
        23
        uId
      • frontend.common.logo (resources/views/frontend/common/logo.blade.php)31blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        remarketingType
        5
        popularStoresConfig
        6
        popularCategoriesConfig
        7
        recommendStores
        8
        unreliableCoupons
        9
        breadcrumbs
        10
        category
        11
        activeCoupons
        12
        slug
        13
        title
        14
        relatedCoupon
        15
        dataCoupon
        16
        activeCouponsSearch
        17
        numberCouponCode
        18
        numberDeal
        19
        numberPrintAble
        20
        includeParams
        21
        unreliableCoupon
        22
        couponTitle
        23
        uId
        24
        categoriesMenu
        25
        storesMenu
        26
        keywordsConfigForSearch
        27
        keywordsLink
        28
        keywordConfigs
        29
        item
        30
        searchKeyNoFollow
      • frontend.layout.footer (resources/views/frontend/layout/footer.blade.php)24blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        remarketingType
        5
        popularStoresConfig
        6
        popularCategoriesConfig
        7
        recommendStores
        8
        unreliableCoupons
        9
        breadcrumbs
        10
        category
        11
        activeCoupons
        12
        slug
        13
        title
        14
        relatedCoupon
        15
        dataCoupon
        16
        activeCouponsSearch
        17
        numberCouponCode
        18
        numberDeal
        19
        numberPrintAble
        20
        includeParams
        21
        unreliableCoupon
        22
        couponTitle
        23
        uId
      • frontend.common.subscribe (resources/views/frontend/common/subscribe.blade.php)24blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        remarketingType
        5
        popularStoresConfig
        6
        popularCategoriesConfig
        7
        recommendStores
        8
        unreliableCoupons
        9
        breadcrumbs
        10
        category
        11
        activeCoupons
        12
        slug
        13
        title
        14
        relatedCoupon
        15
        dataCoupon
        16
        activeCouponsSearch
        17
        numberCouponCode
        18
        numberDeal
        19
        numberPrintAble
        20
        includeParams
        21
        unreliableCoupon
        22
        couponTitle
        23
        uId
      uri
      GET coupon-category/{slug}
      middleware
      web, redirect
      as
      frontend::category::listByCategory
      controller
      App\Http\Controllers\Frontend\CategoryController@listByCategory
      namespace
      App\Http\Controllers\Frontend
      prefix
      null
      where
      file
      app/Http/Controllers/Frontend/CategoryController.php:13-51
      18 statements were executed58.72ms
      • select * from `link_redirect` where `link` = 'https://couponsyr.com/coupon-category/st-patrick-s-day' limit 14.31ms/app/Models/Redirect.php:23couponsyr
        Metadata
        Bindings
        • 0. https://couponsyr.com/coupon-category/st-patrick-s-day
        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` desc400μ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` desc400μs/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. enable
        • 1. 772
        • 2. 361
        • 3. 1624
        • 4. 712
        • 5. 411
        • 6. 430
        • 7. 666
        • 8. 710
        • 9. 2217
        • 10. 444
        • 11. 6303
        • 12. 7806
        • 13. 512
        • 14. 668
        • 15. 2378
        • 16. 2467
        • 17. 3237
        • 18. 7928
        • 19. 367
        • 20. 551
        Backtrace
        • 11. /app/Repositories/BaseRepository.php:39
        • 12. /app/Http/Controllers/Controller.php:285
        • 13. /app/Http/Controllers/Controller.php:34
        • 25. /app/Http/Middleware/LinkRedirect.php:25
        • 63. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38
        • 73. middleware::throttle:111
        • 82. /public/index.php:53
      • select * from `config` where `config`.`key` = 'site.popularCategories' order by `config`.`id` desc220μs/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. site.popularCategories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 11. /app/Repositories/BaseRepository.php:39
        • 12. /app/Http/Controllers/Controller.php:264
        • 13. /app/Http/Controllers/Controller.php:290
        • 14. /app/Http/Controllers/Controller.php:34
        • 26. /app/Http/Middleware/LinkRedirect.php:25
        • 64. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38
        • 74. middleware::throttle:111
        • 83. /public/index.php:53
      • select `id`, `title`, `slug` from `category` where `category`.`status` = 'enable' and `category`.`id` in ('273', '4', '376', '365', '362', '370', '460', '374', '368', '3', '448', '1118', '379', '421', '631', '531', '442', '461', '1380', '217') order by `category`.`id` 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 `category` where `category`.`slug` = 'st-patrick-s-day' and `category`.`status` = 'enable' order by `category`.`id` desc2.3ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. st-patrick-s-day
        • 1. enable
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 11. /app/Repositories/BaseRepository.php:39
        • 12. /app/Http/Controllers/Frontend/CategoryController.php:16
        • 28. /app/Http/Middleware/LinkRedirect.php:25
        • 66. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38
        • 76. middleware::throttle:111
        • 85. /public/index.php:53
      • select * from `category` where `status` = 'enable' and `left_value` <= '1' and `right_value` >= '2' order by `id` asc2.16ms/app/Http/Controllers/Services/CategoryService.php:488couponsyr
        Metadata
        Bindings
        • 0. enable
        • 1. 1
        • 2. 2
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 11. /app/Http/Controllers/Services/CategoryService.php:488
        • 27. /vendor/barryvdh/laravel-cors/src/HandleCors.php:36
        • 32. middleware::auth:34
        • 62. /vendor/dingo/api/src/Routing/Adapter/Laravel.php:81
        • 63. /vendor/dingo/api/src/Routing/Router.php:513
        • 64. /vendor/dingo/api/src/Dispatcher.php:541
        • 65. /vendor/dingo/api/src/Dispatcher.php:445
        • 66. /vendor/dingo/api/src/Dispatcher.php:358
        • 67. /app/Utils/Utils.php:448
        • 68. /app/Http/Controllers/Controller.php:43
        • 69. /app/Http/Controllers/Controller.php:93
        • 70. /app/Http/Controllers/Frontend/CategoryController.php:28
        • 86. /app/Http/Middleware/LinkRedirect.php:25
        • 124. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38
        • 134. middleware::throttle:111
        • 143. /public/index.php:53
      • select `coupon`.*, `store`.`slug` as `store_slug`, `store`.`image` as `store_image`, `store`.`title` as `store_title` from `coupon` inner join `store` on `coupon`.`store_id` = `store`.`id` inner join `coupon_n_category` on `coupon_n_category`.`coupon_id` = `coupon`.`id` where `coupon`.`status` = 'active' and `coupon_n_category`.`category_id` = '7824' order by `coupon`.`sorder_in_category` desc limit 25 offset 019.17ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. active
        • 1. 7824
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 11. /app/Repositories/BaseRepository.php:39
        • 12. /app/Http/Controllers/Frontend/CategoryController.php:30
        • 28. /app/Http/Middleware/LinkRedirect.php:25
        • 66. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38
        • 76. middleware::throttle:111
        • 85. /public/index.php:53
      • select `coupon`.*, `store`.`slug` as `store_slug`, `store`.`image` as `store_image`, `store`.`title` as `store_title` from `coupon` inner join `store` on `coupon`.`store_id` = `store`.`id` inner join `coupon_n_category` on `coupon_n_category`.`coupon_id` = `coupon`.`id` where `coupon`.`status` = 'unreliable' and `coupon_n_category`.`category_id` = '7824' order by `coupon`.`sorder_in_category` desc limit 10 offset 019.71ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. unreliable
        • 1. 7824
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 11. /app/Repositories/BaseRepository.php:39
        • 12. /app/Http/Controllers/Frontend/CategoryController.php:33
        • 28. /app/Http/Middleware/LinkRedirect.php:25
        • 66. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38
        • 76. middleware::throttle:111
        • 85. /public/index.php:53
      • select * from `store` inner join `store_n_category` on `store_n_category`.`store_id` = `store`.`id` where `store`.`status` = 'enable' and `store_n_category`.`category_id` = '7824' order by `store`.`id` desc limit 5 offset 03.5ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. enable
        • 1. 7824
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 11. /app/Repositories/BaseRepository.php:39
        • 12. /app/Http/Controllers/Frontend/CategoryController.php:35
        • 28. /app/Http/Middleware/LinkRedirect.php:25
        • 66. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38
        • 76. middleware::throttle:111
        • 85. /public/index.php:53
      • select * from `config` where `key` = 'site.defaultMetaTitle' limit 1330μs/app/Models/Config.php:27couponsyr
        Metadata
        Bindings
        • 0. site.defaultMetaTitle
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 12. /app/Models/Config.php:27
        • 13. view::frontend.layout.meta:8
        • 19. view::frontend.category.list:2
        • 26. /vendor/symfony/http-foundation/Response.php:201
        • 40. /app/Http/Middleware/LinkRedirect.php:25
        • 78. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38
        • 88. middleware::throttle:111
        • 97. /public/index.php:53
      • select * from `config` where `key` = 'site.defaultMetaDescription' limit 1210μs/app/Models/Config.php:27couponsyr
        Metadata
        Bindings
        • 0. site.defaultMetaDescription
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 12. /app/Models/Config.php:27
        • 13. view::frontend.layout.meta:9
        • 19. view::frontend.category.list:2
        • 26. /vendor/symfony/http-foundation/Response.php:201
        • 40. /app/Http/Middleware/LinkRedirect.php:25
        • 78. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38
        • 88. middleware::throttle:111
        • 97. /public/index.php:53
      • select * from `config` where `key` = 'site.defaultMetaKeywords' limit 1230μs/app/Models/Config.php:27couponsyr
        Metadata
        Bindings
        • 0. site.defaultMetaKeywords
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 12. /app/Models/Config.php:27
        • 13. view::frontend.layout.meta:10
        • 19. view::frontend.category.list:2
        • 26. /vendor/symfony/http-foundation/Response.php:201
        • 40. /app/Http/Middleware/LinkRedirect.php:25
        • 78. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38
        • 88. middleware::throttle:111
        • 97. /public/index.php:53
      • select * from `meta_data` where `url` = '/coupon-category/st-patrick-s-day' limit 1250μsview::frontend.layout.meta:15couponsyr
        Metadata
        Bindings
        • 0. /coupon-category/st-patrick-s-day
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 12. view::frontend.layout.meta:15
        • 18. view::frontend.category.list:2
        • 25. /vendor/symfony/http-foundation/Response.php:201
        • 39. /app/Http/Middleware/LinkRedirect.php:25
        • 77. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38
        • 87. middleware::throttle:111
        • 96. /public/index.php:53
      • select `id`, `title`, `slug`, `image` from `category` where `status` = 'enable' and `type` = 'category' order by `coupon_count` desc limit 9960μ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.category.list:89
        • 31. /vendor/symfony/http-foundation/Response.php:201
        • 45. /app/Http/Middleware/LinkRedirect.php:25
        • 83. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38
        • 93. middleware::throttle:111
        • 102. /public/index.php:53
      • select `id`, `title`, `slug`, `image` from `store` where `status` = 'enable' order by `coupon_count` desc limit 93.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.category.list:89
        • 31. /vendor/symfony/http-foundation/Response.php:201
        • 45. /app/Http/Middleware/LinkRedirect.php:25
        • 83. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38
        • 93. middleware::throttle:111
        • 102. /public/index.php:53
      • select * from `config` where `key` = 'site.keyword.for.search' limit 1270μ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.category.list:89
        • 32. /vendor/symfony/http-foundation/Response.php:201
        • 46. /app/Http/Middleware/LinkRedirect.php:25
        • 84. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38
        • 94. middleware::throttle:111
        • 103. /public/index.php:53
      • select * from `config` where `key` = 'site.menu' limit 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.category.list:89
        • 31. /vendor/symfony/http-foundation/Response.php:201
        • 45. /app/Http/Middleware/LinkRedirect.php:25
        • 83. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38
        • 93. middleware::throttle:111
        • 102. /public/index.php:53
        web
        array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
        api
        array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
          _token
          Yv7cRHX5r4r4ZOREH07dOjqx16c8IJJrSvNj4BWh
          _previous
          array:1 [ "url" => "https://couponsyr.com/coupon-category/st-patrick-s-day" ]
          uId
          wpcftsqsfv7fg9cuf4yn2t6dcsgzb
          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" => "Z3qpamZhILOaDQJn0ySfFQAAAAI" "REDIRECT_SCRIPT_URL" => "/coup...
          request_cookies
          []
          response_headers
          array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "content-type" => array:1 [ 0...
          path_info
          /coupon-category/st-patrick-s-day
          session_attributes
          array:4 [ "_token" => "Yv7cRHX5r4r4ZOREH07dOjqx16c8IJJrSvNj4BWh" "_previous" => array:1 [ "u...