Pier 1 Coupons

Shop now

Active Pier 1 Coupons & Promo codes

Unreliable Pier 1 Coupons & Promo codes

133.37msRequest Duration4MBMemory UsageGET store/{slug}RouteAuth status
    • Booting (15.01ms)
    • Application (121ms)
      30 templates were rendered
      • frontend.store.list (resources/views/frontend/store/list.blade.php)11blade
        Params
        0
        store
        1
        title
        2
        storeNameTracking
        3
        storeIdTracking
        4
        slug
        5
        activeCoupons
        6
        breadcrumbs
        7
        unreliableCoupons
        8
        relatedStores
        9
        relatedCategories
        10
        activeCouponsSearch
      • frontend.layout.meta (resources/views/frontend/layout/meta.blade.php)19blade
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        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)26blade
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        item
      • frontend.common.item (resources/views/frontend/common/item.blade.php)26blade
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        item
      • frontend.common.item (resources/views/frontend/common/item.blade.php)26blade
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        item
      • frontend.common.item (resources/views/frontend/common/item.blade.php)26blade
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        item
      • frontend.common.item (resources/views/frontend/common/item.blade.php)26blade
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        item
      • frontend.common.item (resources/views/frontend/common/item.blade.php)26blade
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        item
      • frontend.common.item (resources/views/frontend/common/item.blade.php)26blade
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        item
      • frontend.common.item (resources/views/frontend/common/item.blade.php)26blade
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        item
      • frontend.common.item (resources/views/frontend/common/item.blade.php)26blade
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        item
      • frontend.common.item (resources/views/frontend/common/item.blade.php)26blade
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        item
      • frontend.common.item (resources/views/frontend/common/item.blade.php)26blade
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        unreliableCoupon
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        unreliableCoupon
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        unreliableCoupon
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        unreliableCoupon
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        unreliableCoupon
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        unreliableCoupon
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        unreliableCoupon
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        unreliableCoupon
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        unreliableCoupon
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        unreliableCoupon
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        unreliableCoupon
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        unreliableCoupon
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        unreliableCoupon
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        unreliableCoupon
        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
        relatedCategories
        17
        activeCouponsSearch
        18
        couponSchema
        19
        numberCouponCode
        20
        numberDeal
        21
        numberPrintAble
        22
        coupon
        23
        listRouteNameCategoryStore
        24
        activeCoupon
        25
        unreliableCoupon
        26
        includeParams
        27
        couponTitle
        28
        uId
      uri
      GET store/{slug}
      middleware
      web, redirect
      as
      frontend::store::listByStore
      controller
      App\Http\Controllers\Frontend\StoreController@listByStore
      namespace
      App\Http\Controllers\Frontend
      prefix
      null
      where
      file
      app/Http/Controllers/Frontend/StoreController.php:18-81
      24 statements were executed, 2 of which were duplicated, 22 unique92.49ms
      • select * from `link_redirect` where `link` = 'https://couponsyr.com/store/pier-1' limit 16.16ms/app/Models/Redirect.php:23couponsyr
        Metadata
        Bindings
        • 0. https://couponsyr.com/store/pier-1
        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` desc430μ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` desc490μ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` desc290μ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` desc420μ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` = 'pier-1' and `store`.`status` = 'enable' order by `store`.`id` desc13.02ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. pier-1
        • 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:21
        • 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`.`left_value`, `category`.`right_value`, `category`.`depth` 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` = '682' order by `category`.`id` desc2.33ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. enable
        • 1. 682
        Backtrace
        • 11. /app/Repositories/BaseRepository.php:39
        • 12. /app/Http/Controllers/Frontend/StoreController.php:27
        • 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` >= '1286' and `category`.`left_value` <= '1285' and `category`.`depth` <= '2' order by `category`.`depth` desc1.03ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. enable
        • 1. 1286
        • 2. 1285
        • 3. 2
        Backtrace
        • 11. /app/Repositories/BaseRepository.php:39
        • 12. /app/Http/Controllers/Frontend/StoreController.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` in ('384', '376') order by `store`.`id` desc limit 10 offset 05.02ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. enable
        • 1. 384
        • 2. 376
        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:43
        • 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` where `coupon`.`status` = 'active' and `coupon`.`store_id` = '682' order by `coupon`.`sorder` desc limit 20 offset 024.55ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. active
        • 1. 682
        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:55
        • 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` where `coupon`.`status` = 'unreliable' and `coupon`.`store_id` = '682' order by `coupon`.`sorder` desc limit 8 offset 023.63ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. unreliable
        • 1. 682
        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:58
        • 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` = '682' order by `category`.`id` desc limit 10 offset 02.68ms/app/Repositories/BaseRepository.php:39couponsyr
        Metadata
        Bindings
        • 0. enable
        • 1. 682
        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:62
        • 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 1260μ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:67
        • 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` = '682' order by `p`.`id` desc1.95ms/app/Http/Controllers/Services/BaseService.php:68couponsyr
        Metadata
        Bindings
        • 0. 682
        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:74
        • 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` = '682' order by `p`.`id` desc2.1ms/app/Http/Controllers/Services/BaseService.php:70couponsyr
        Metadata
        Bindings
        • 0. 682
        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:74
        • 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` <= '1285' and `right_value` >= '1286' order by `id` asc2.06ms/app/Http/Controllers/Services/CategoryService.php:488couponsyr
        Metadata
        Bindings
        • 0. enable
        • 1. 1285
        • 2. 1286
        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:74
        • 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 1250μ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 1220μ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 1200μ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` = '/store/pier-1' limit 1260μsview::frontend.layout.meta:15couponsyr
        Metadata
        Bindings
        • 0. /store/pier-1
        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 9890μ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 93.75ms/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 1280μ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
          nPXTQKXSONkvvwAySnTpziDxmb2tOKon3W2Gkk6g
          _previous
          array:1 [ "url" => "https://couponsyr.com/store/pier-1" ]
          uId
          3w0mlqdijumzbrzeybfvsr2jwn8ap
          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" => "Z3xeeasPOcqwD@f6wWbCjQAAAAY" "REDIRECT_SCRIPT_URL" => "/stor...
          request_cookies
          []
          response_headers
          array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "content-type" => array:1 [ 0...
          path_info
          /store/pier-1
          session_attributes
          array:4 [ "_token" => "nPXTQKXSONkvvwAySnTpziDxmb2tOKon3W2Gkk6g" "_previous" => array:1 [ "u...