First Aid don't have any coupons

93.67msRequest Duration4MBMemory UsageGET coupon-category/{slug}RouteAuth status
    • Booting (15.87ms)
    • Application (80.05ms)
      10 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.popular-box (resources/views/frontend/common/popular-box.blade.php)21blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        remarketingType
        5
        popularStoresConfig
        6
        popularCategoriesConfig
        7
        recommendStores
        8
        unreliableCoupons
        9
        breadcrumbs
        10
        category
        11
        activeCoupons
        12
        slug
        13
        title
        14
        relatedCoupon
        15
        dataCoupon
        16
        activeCouponsSearch
        17
        numberCouponCode
        18
        numberDeal
        19
        numberPrintAble
        20
        includeParams
      • frontend.common.breadcrumbs (resources/views/frontend/common/breadcrumbs.blade.php)1blade
        Params
        0
        breadcrumbs
      • frontend.layout.master (resources/views/frontend/layout/master.blade.php)21blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        remarketingType
        5
        popularStoresConfig
        6
        popularCategoriesConfig
        7
        recommendStores
        8
        unreliableCoupons
        9
        breadcrumbs
        10
        category
        11
        activeCoupons
        12
        slug
        13
        title
        14
        relatedCoupon
        15
        dataCoupon
        16
        activeCouponsSearch
        17
        numberCouponCode
        18
        numberDeal
        19
        numberPrintAble
        20
        includeParams
      • frontend.layout.header (resources/views/frontend/layout/header.blade.php)23blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        remarketingType
        5
        popularStoresConfig
        6
        popularCategoriesConfig
        7
        recommendStores
        8
        unreliableCoupons
        9
        breadcrumbs
        10
        category
        11
        activeCoupons
        12
        slug
        13
        title
        14
        relatedCoupon
        15
        dataCoupon
        16
        activeCouponsSearch
        17
        numberCouponCode
        18
        numberDeal
        19
        numberPrintAble
        20
        includeParams
        21
        couponTitle
        22
        uId
      • frontend.common.logo (resources/views/frontend/common/logo.blade.php)30blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        remarketingType
        5
        popularStoresConfig
        6
        popularCategoriesConfig
        7
        recommendStores
        8
        unreliableCoupons
        9
        breadcrumbs
        10
        category
        11
        activeCoupons
        12
        slug
        13
        title
        14
        relatedCoupon
        15
        dataCoupon
        16
        activeCouponsSearch
        17
        numberCouponCode
        18
        numberDeal
        19
        numberPrintAble
        20
        includeParams
        21
        couponTitle
        22
        uId
        23
        categoriesMenu
        24
        storesMenu
        25
        keywordsConfigForSearch
        26
        keywordsLink
        27
        keywordConfigs
        28
        item
        29
        searchKeyNoFollow
      • frontend.layout.footer (resources/views/frontend/layout/footer.blade.php)23blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        remarketingType
        5
        popularStoresConfig
        6
        popularCategoriesConfig
        7
        recommendStores
        8
        unreliableCoupons
        9
        breadcrumbs
        10
        category
        11
        activeCoupons
        12
        slug
        13
        title
        14
        relatedCoupon
        15
        dataCoupon
        16
        activeCouponsSearch
        17
        numberCouponCode
        18
        numberDeal
        19
        numberPrintAble
        20
        includeParams
        21
        couponTitle
        22
        uId
      • frontend.common.subscribe (resources/views/frontend/common/subscribe.blade.php)23blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        remarketingType
        5
        popularStoresConfig
        6
        popularCategoriesConfig
        7
        recommendStores
        8
        unreliableCoupons
        9
        breadcrumbs
        10
        category
        11
        activeCoupons
        12
        slug
        13
        title
        14
        relatedCoupon
        15
        dataCoupon
        16
        activeCouponsSearch
        17
        numberCouponCode
        18
        numberDeal
        19
        numberPrintAble
        20
        includeParams
        21
        couponTitle
        22
        uId
      uri
      GET coupon-category/{slug}
      middleware
      web, redirect
      as
      frontend::category::listByCategory
      controller
      App\Http\Controllers\Frontend\CategoryController@listByCategory
      namespace
      App\Http\Controllers\Frontend
      prefix
      null
      where
      file
      app/Http/Controllers/Frontend/CategoryController.php:13-51
      18 statements were executed59.8ms
      • select * from `link_redirect` where `link` = 'https://couponsyr.com/coupon-category/first-aid' limit 16.02ms/app/Models/Redirect.php:23couponsyr
        Metadata
        Bindings
        • 0. https://couponsyr.com/coupon-category/first-aid
        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` desc570μ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` desc510μ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` desc270μ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` desc340μ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` = 'first-aid' and `category`.`status` = 'enable' order by `category`.`id` desc2.33ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. first-aid
        • 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` <= '1153' and `right_value` >= '1156' order by `id` asc2.25ms/app/Http/Controllers/Services/CategoryService.php:488couponsyr
        Metadata
        Bindings
        • 0. enable
        • 1. 1153
        • 2. 1156
        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` = '4731' order by `coupon`.`sorder_in_category` desc limit 25 offset 019.05ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. active
        • 1. 4731
        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` = '4731' order by `coupon`.`sorder_in_category` desc limit 10 offset 019.35ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. unreliable
        • 1. 4731
        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` = '4731' order by `store`.`id` desc limit 5 offset 03.19ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. enable
        • 1. 4731
        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 1270μ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 1220μ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/first-aid' limit 1240μsview::frontend.layout.meta:15couponsyr
        Metadata
        Bindings
        • 0. /coupon-category/first-aid
        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 9910μ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.64ms/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 1220μ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
          9dg1fZatMSjpGKOQyZOWOrKk25F0XxjmtMpoPdrl
          _previous
          array:1 [ "url" => "https://couponsyr.com/coupon-category/first-aid" ]
          uId
          894d7dr5acmknsm38dc6g4aqvesyp
          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" => "Z3wP3VElYPP1I90yxMB49gAAAAM" "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/first-aid
          session_attributes
          array:4 [ "_token" => "9dg1fZatMSjpGKOQyZOWOrKk25F0XxjmtMpoPdrl" "_previous" => array:1 [ "u...