Art Scroll Coupons

Shop now

Active Art Scroll Booksellers Coupons & Promo codes

151.43msRequest Duration4MBMemory UsageGET {category}/{store}RouteAuth status
    • Booting (16.26ms)
    • Application (137.25ms)
      14 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.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 unique101.28ms
      • select * from `link_redirect` where `link` = 'https://couponsyr.com/booksellers/art-scroll' limit 16.41ms/app/Models/Redirect.php:23couponsyr
        Metadata
        Bindings
        • 0. https://couponsyr.com/booksellers/art-scroll
        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` desc510μ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` desc400μ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` = 'art-scroll' and `store`.`status` = 'enable' order by `store`.`id` desc15.72ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. art-scroll
        • 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` = 'booksellers' and `category`.`status` = 'enable' order by `category`.`id` desc3.18ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. booksellers
        • 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` >= '545' and `category`.`left_value` <= '544' and `category`.`depth` <= '3' order by `category`.`depth` desc1.41ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. enable
        • 1. 545
        • 2. 544
        • 3. 3
        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 ('234', '217', '216') order by `store`.`id` desc limit 10 offset 05.21ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. enable
        • 1. 234
        • 2. 217
        • 3. 216
        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` = '4611' and `coupon_n_category`.`category_id` = '234' order by `coupon`.`sorder_in_category` desc limit 20 offset 023.44ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. active
        • 1. 4611
        • 2. 234
        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` = '4611' and `coupon_n_category`.`category_id` = '234' order by `coupon`.`sorder_in_category` desc limit 10 offset 020.42ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. unreliable
        • 1. 4611
        • 2. 234
        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` = '4611' order by `category`.`id` desc limit 10 offset 03.32ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. enable
        • 1. 4611
        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 1520μ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` = '4611' order by `p`.`id` desc3.55ms/app/Http/Controllers/Services/BaseService.php:68couponsyr
        Metadata
        Bindings
        • 0. 4611
        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` = '4611' order by `p`.`id` desc3.56ms/app/Http/Controllers/Services/BaseService.php:70couponsyr
        Metadata
        Bindings
        • 0. 4611
        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` <= '544' and `right_value` >= '545' order by `id` asc3.4ms/app/Http/Controllers/Services/CategoryService.php:488couponsyr
        Metadata
        Bindings
        • 0. enable
        • 1. 544
        • 2. 545
        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 1490μ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.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 1280μ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 1260μ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` = '/booksellers/art-scroll' limit 1330μsview::frontend.layout.meta:15couponsyr
        Metadata
        Bindings
        • 0. /booksellers/art-scroll
        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 91.67ms/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 95.82ms/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 1380μs/app/Models/Config.php:27couponsyr
        Metadata
        Bindings
        • 0. site.keyword.for.search
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 12. /app/Models/Config.php:27
        • 13. view::frontend.layout.header:11
        • 19. view::frontend.layout.master:114
        • 25. view::frontend.store.list:138
        • 32. /vendor/symfony/http-foundation/Response.php:201
        • 46. /app/Http/Middleware/LinkRedirect.php:25
        • 84. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38
        • 94. middleware::throttle:111
        • 103. /public/index.php:53
      • select * from `config` where `key` = 'site.menu' limit 1220μsview::frontend.layout.header:85couponsyr
        Metadata
        Bindings
        • 0. site.menu
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 12. view::frontend.layout.header:85
        • 18. view::frontend.layout.master:114
        • 24. view::frontend.store.list:138
        • 31. /vendor/symfony/http-foundation/Response.php:201
        • 45. /app/Http/Middleware/LinkRedirect.php:25
        • 83. /vendor/barryvdh/laravel-cors/src/HandlePreflight.php:38
        • 93. middleware::throttle:111
        • 102. /public/index.php:53
        web
        array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
        api
        array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
          _token
          1PNSP4yKJGUGuSXQOcoEaNUImV9PxLIxrZYggh1z
          _previous
          array:1 [ "url" => "https://couponsyr.com/booksellers/art-scroll" ]
          uId
          q5tjctwzbriy7i9b9mwo013fokcdw
          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" => "Z3wSa0b6aPSg4uLZKYsStAAAAAA" "REDIRECT_SCRIPT_URL" => "/book...
          request_cookies
          []
          response_headers
          array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "content-type" => array:1 [ 0...
          path_info
          /booksellers/art-scroll
          session_attributes
          array:4 [ "_token" => "1PNSP4yKJGUGuSXQOcoEaNUImV9PxLIxrZYggh1z" "_previous" => array:1 [ "u...