বেস্ট সেলিং বই

8.1.31PHP Version1.04sRequest Duration6MBMemory UsageGET category/{category_slug}Route
    • Booting (23.43ms)
    • Application (1.01s)
    • 1 x Application (97.73%)
      1.01s
      1 x Booting (2.26%)
      23.43ms
      10 templates were rendered
      • frontend.product_listing (resources/views/frontend/product_listing.blade.php)12bladefile
        Params
        0
        products
        1
        query
        2
        category_id
        3
        brand_id
        4
        sort_by
        5
        seller_id
        6
        min_price
        7
        max_price
        8
        attributes
        9
        selected_attribute_values
        10
        colors
        11
        selected_color
      • pagination::bootstrap-4 (vendor/laravel/framework/src/Illuminate/Pagination/resources/views/bootstrap-4.blade.php)2bladefile
        Params
        0
        paginator
        1
        elements
      • frontend.layouts.app (resources/views/frontend/layouts/app.blade.php)22bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        products
        4
        query
        5
        category_id
        6
        brand_id
        7
        sort_by
        8
        seller_id
        9
        min_price
        10
        max_price
        11
        attributes
        12
        selected_attribute_values
        13
        colors
        14
        selected_color
        15
        meta_title
        16
        meta_description
        17
        __currentLoopData
        18
        loop
        19
        attribute
        20
        show
        21
        attribute_value
      • frontend.inc.nav (resources/views/frontend/inc/nav.blade.php)22bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        products
        4
        query
        5
        category_id
        6
        brand_id
        7
        sort_by
        8
        seller_id
        9
        min_price
        10
        max_price
        11
        attributes
        12
        selected_attribute_values
        13
        colors
        14
        selected_color
        15
        meta_title
        16
        meta_description
        17
        __currentLoopData
        18
        loop
        19
        attribute
        20
        show
        21
        attribute_value
      • frontend.partials.wishlist (resources/views/frontend/partials/wishlist.blade.php)23bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        products
        4
        query
        5
        category_id
        6
        brand_id
        7
        sort_by
        8
        seller_id
        9
        min_price
        10
        max_price
        11
        attributes
        12
        selected_attribute_values
        13
        colors
        14
        selected_color
        15
        meta_title
        16
        meta_description
        17
        __currentLoopData
        18
        loop
        19
        attribute
        20
        show
        21
        attribute_value
        22
        header_logo
      • frontend.partials.cart (resources/views/frontend/partials/cart.blade.php)23bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        products
        4
        query
        5
        category_id
        6
        brand_id
        7
        sort_by
        8
        seller_id
        9
        min_price
        10
        max_price
        11
        attributes
        12
        selected_attribute_values
        13
        colors
        14
        selected_color
        15
        meta_title
        16
        meta_description
        17
        __currentLoopData
        18
        loop
        19
        attribute
        20
        show
        21
        attribute_value
        22
        header_logo
      • frontend.inc.footer (resources/views/frontend/inc/footer.blade.php)22bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        products
        4
        query
        5
        category_id
        6
        brand_id
        7
        sort_by
        8
        seller_id
        9
        min_price
        10
        max_price
        11
        attributes
        12
        selected_attribute_values
        13
        colors
        14
        selected_color
        15
        meta_title
        16
        meta_description
        17
        __currentLoopData
        18
        loop
        19
        attribute
        20
        show
        21
        attribute_value
      • frontend.partials.modal (resources/views/frontend/partials/modal.blade.php)22bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        products
        4
        query
        5
        category_id
        6
        brand_id
        7
        sort_by
        8
        seller_id
        9
        min_price
        10
        max_price
        11
        attributes
        12
        selected_attribute_values
        13
        colors
        14
        selected_color
        15
        meta_title
        16
        meta_description
        17
        __currentLoopData
        18
        loop
        19
        attribute
        20
        show
        21
        attribute_value
      • frontend.partials.login_modal (resources/views/frontend/partials/login_modal.blade.php)22bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        products
        4
        query
        5
        category_id
        6
        brand_id
        7
        sort_by
        8
        seller_id
        9
        min_price
        10
        max_price
        11
        attributes
        12
        selected_attribute_values
        13
        colors
        14
        selected_color
        15
        meta_title
        16
        meta_description
        17
        __currentLoopData
        18
        loop
        19
        attribute
        20
        show
        21
        attribute_value
      • frontend.partials.account_delete_modal (resources/views/frontend/partials/account_delete_modal.blade.php)22bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        products
        4
        query
        5
        category_id
        6
        brand_id
        7
        sort_by
        8
        seller_id
        9
        min_price
        10
        max_price
        11
        attributes
        12
        selected_attribute_values
        13
        colors
        14
        selected_color
        15
        meta_title
        16
        meta_description
        17
        __currentLoopData
        18
        loop
        19
        attribute
        20
        show
        21
        attribute_value
      uri
      GET category/{category_slug}
      middleware
      web
      controller
      App\Http\Controllers\SearchController@listingByCategory
      namespace
      prefix
      where
      as
      products.category
      file
      app/Http/Controllers/SearchController.php:192-199
      41 statements were executed, 26 of which were duplicated, 15 unique. Show only duplicated778ms
      • select * from `categories` where `slug` = 'best-selling-book' limit 1
        269ms/app/Http/Controllers/SearchController.php:194u145862214_boipok
        Metadata
        Bindings
        • 0. best-selling-book
        Backtrace
        • 15. /app/Http/Controllers/SearchController.php:194
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `category_translations` where `category_translations`.`category_id` in (10)
        1.03ms/app/Http/Controllers/SearchController.php:194u145862214_boipok
        Metadata
        Backtrace
        • 20. /app/Http/Controllers/SearchController.php:194
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `attributes`
        19.44ms/app/Http/Controllers/SearchController.php:32u145862214_boipok
        Metadata
        Backtrace
        • 15. /app/Http/Controllers/SearchController.php:32
        • 16. /app/Http/Controllers/SearchController.php:196
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `attribute_translations` where `attribute_translations`.`attribute_id` in (3, 4, 5)
        1.56ms/app/Http/Controllers/SearchController.php:32u145862214_boipok
        Metadata
        Backtrace
        • 20. /app/Http/Controllers/SearchController.php:32
        • 21. /app/Http/Controllers/SearchController.php:196
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `colors`
        5.34ms/app/Http/Controllers/SearchController.php:34u145862214_boipok
        Metadata
        Backtrace
        • 15. /app/Http/Controllers/SearchController.php:34
        • 16. /app/Http/Controllers/SearchController.php:196
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `categories` where `parent_id` = 10 order by `order_level` desc
        1.19ms/app/Utility/CategoryUtility.php:12u145862214_boipok
        Metadata
        Bindings
        • 0. 10
        Backtrace
        • 14. /app/Utility/CategoryUtility.php:12
        • 15. /app/Utility/CategoryUtility.php:34
        • 16. /app/Utility/CategoryUtility.php:50
        • 17. /app/Http/Controllers/SearchController.php:69
        • 18. /app/Http/Controllers/SearchController.php:196
      • select `attribute_id` from `attribute_category` where `category_id` in (10)
        4.58ms/app/Http/Controllers/SearchController.php:74u145862214_boipok
        Metadata
        Bindings
        • 0. 10
        Backtrace
        • 13. /app/Http/Controllers/SearchController.php:74
        • 14. /app/Http/Controllers/SearchController.php:196
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `attributes` where `id` in (3, 4, 5)
        7.61ms/app/Http/Controllers/SearchController.php:75u145862214_boipok
        Metadata
        Bindings
        • 0. 3
        • 1. 4
        • 2. 5
        Backtrace
        • 14. /app/Http/Controllers/SearchController.php:75
        • 15. /app/Http/Controllers/SearchController.php:196
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `attribute_translations` where `attribute_translations`.`attribute_id` in (3, 4, 5)
        670μs/app/Http/Controllers/SearchController.php:75u145862214_boipok
        Metadata
        Backtrace
        • 19. /app/Http/Controllers/SearchController.php:75
        • 20. /app/Http/Controllers/SearchController.php:196
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select count(*) as aggregate from `products` where `category_id` in (10) and `published` = '1' and `auction_product` = 0 and `approved` = '1' and `wholesale_product` = 0 and `added_by` = 'admin'
        9.48ms/app/Http/Controllers/SearchController.php:170u145862214_boipok
        Metadata
        Bindings
        • 0. 10
        • 1. 1
        • 2. 0
        • 3. 1
        • 4. 0
        • 5. admin
        Backtrace
        • 15. /app/Http/Controllers/SearchController.php:170
        • 16. /app/Http/Controllers/SearchController.php:196
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `categories` where `categories`.`id` = 10 limit 1
        240μsview::frontend.product_listing:3u145862214_boipok
        Metadata
        Bindings
        • 0. 10
        Backtrace
        • 19. view::frontend.product_listing:3
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `category_translations` where `category_translations`.`category_id` in (10)
        300μsview::frontend.product_listing:3u145862214_boipok
        Metadata
        Backtrace
        • 24. view::frontend.product_listing:3
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 10 limit 1
        450μsview::frontend.product_listing:4u145862214_boipok
        Metadata
        Bindings
        • 0. 10
        Backtrace
        • 19. view::frontend.product_listing:4
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `category_translations` where `category_translations`.`category_id` in (10)
        18.07msview::frontend.product_listing:4u145862214_boipok
        Metadata
        Backtrace
        • 24. view::frontend.product_listing:4
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 10 limit 1
        35.43msview::frontend.product_listing:77u145862214_boipok
        Metadata
        Bindings
        • 0. 10
        Backtrace
        • 19. view::frontend.product_listing:77
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `category_translations` where `category_translations`.`category_id` in (10)
        1.77msview::frontend.product_listing:77u145862214_boipok
        Metadata
        Backtrace
        • 24. view::frontend.product_listing:77
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 10 limit 1
        1.01msview::frontend.product_listing:87u145862214_boipok
        Metadata
        Bindings
        • 0. 10
        Backtrace
        • 19. view::frontend.product_listing:87
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `category_translations` where `category_translations`.`category_id` in (10)
        13.75msview::frontend.product_listing:87u145862214_boipok
        Metadata
        Backtrace
        • 24. view::frontend.product_listing:87
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 10 limit 1
        580μsview::frontend.product_listing:89u145862214_boipok
        Metadata
        Bindings
        • 0. 10
        Backtrace
        • 19. view::frontend.product_listing:89
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `category_translations` where `category_translations`.`category_id` in (10)
        1.9msview::frontend.product_listing:89u145862214_boipok
        Metadata
        Backtrace
        • 24. view::frontend.product_listing:89
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `parent_id` = 10 order by `order_level` desc
        830μs/app/Utility/CategoryUtility.php:12u145862214_boipok
        Metadata
        Bindings
        • 0. 10
        Backtrace
        • 14. /app/Utility/CategoryUtility.php:12
        • 15. /app/Utility/CategoryUtility.php:21
        • 16. view::frontend.product_listing:93
        • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select count(*) as aggregate from `products` where `published` = 1
        1.91msview::frontend.product_listing:113u145862214_boipok
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 15. view::frontend.product_listing:113
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select min(`unit_price`) as aggregate from `products` where `published` = 1
        20.34msview::frontend.product_listing:113u145862214_boipok
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 15. view::frontend.product_listing:113
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select count(*) as aggregate from `products` where `published` = 1
        15.8msview::frontend.product_listing:114u145862214_boipok
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 15. view::frontend.product_listing:114
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select max(`unit_price`) as aggregate from `products` where `published` = 1
        75.44msview::frontend.product_listing:114u145862214_boipok
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 15. view::frontend.product_listing:114
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `attribute_values` where `attribute_values`.`attribute_id` = 3 and `attribute_values`.`attribute_id` is not null
        660μsview::frontend.product_listing:162u145862214_boipok
        Metadata
        Bindings
        • 0. 3
        Backtrace
        • 19. view::frontend.product_listing:162
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `attribute_values` where `attribute_values`.`attribute_id` = 4 and `attribute_values`.`attribute_id` is not null
        370μsview::frontend.product_listing:162u145862214_boipok
        Metadata
        Bindings
        • 0. 4
        Backtrace
        • 19. view::frontend.product_listing:162
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `attribute_values` where `attribute_values`.`attribute_id` = 5 and `attribute_values`.`attribute_id` is not null
        3.63msview::frontend.product_listing:162u145862214_boipok
        Metadata
        Bindings
        • 0. 5
        Backtrace
        • 19. view::frontend.product_listing:162
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 10 limit 1
        300μsview::frontend.product_listing:247u145862214_boipok
        Metadata
        Bindings
        • 0. 10
        Backtrace
        • 19. view::frontend.product_listing:247
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `category_translations` where `category_translations`.`category_id` in (10)
        290μsview::frontend.product_listing:247u145862214_boipok
        Metadata
        Backtrace
        • 24. view::frontend.product_listing:247
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 10 limit 1
        210μsview::frontend.product_listing:258u145862214_boipok
        Metadata
        Bindings
        • 0. 10
        Backtrace
        • 19. view::frontend.product_listing:258
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `category_translations` where `category_translations`.`category_id` in (10)
        250μsview::frontend.product_listing:258u145862214_boipok
        Metadata
        Backtrace
        • 24. view::frontend.product_listing:258
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `languages` where `code` = 'en' limit 1
        220μsview::frontend.layouts.app:2u145862214_boipok
        Metadata
        Bindings
        • 0. en
        Backtrace
        • 15. view::frontend.layouts.app:2
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `uploads` where `uploads`.`id` is null and `uploads`.`deleted_at` is null limit 1
        148ms/app/Http/Helpers.php:1131u145862214_boipok
        Metadata
        Backtrace
        • 19. /app/Http/Helpers.php:1131
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 25. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `uploads` where `uploads`.`id` is null and `uploads`.`deleted_at` is null limit 1
        180μs/app/Http/Helpers.php:1131u145862214_boipok
        Metadata
        Backtrace
        • 19. /app/Http/Helpers.php:1131
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 25. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `uploads` where `uploads`.`id` is null and `uploads`.`deleted_at` is null limit 1
        2.55ms/app/Http/Helpers.php:1131u145862214_boipok
        Metadata
        Backtrace
        • 19. /app/Http/Helpers.php:1131
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 25. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `uploads` where `uploads`.`id` = '43' and `uploads`.`deleted_at` is null limit 1
        270μs/app/Http/Helpers.php:1131u145862214_boipok
        Metadata
        Bindings
        • 0. 43
        Backtrace
        • 19. /app/Http/Helpers.php:1131
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 25. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `languages` where `code` = 'en' limit 1
        54.53msview::frontend.layouts.app:57u145862214_boipok
        Metadata
        Bindings
        • 0. en
        Backtrace
        • 15. view::frontend.layouts.app:57
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `uploads` where `uploads`.`id` = '37' and `uploads`.`deleted_at` is null limit 1
        260μs/app/Http/Helpers.php:1131u145862214_boipok
        Metadata
        Bindings
        • 0. 37
        Backtrace
        • 19. /app/Http/Helpers.php:1131
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 25. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `uploads` where `uploads`.`id` = '42' and `uploads`.`deleted_at` is null limit 1
        580μs/app/Http/Helpers.php:1131u145862214_boipok
        Metadata
        Bindings
        • 0. 42
        Backtrace
        • 19. /app/Http/Helpers.php:1131
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 25. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select `code` from `countries` where `status` = 1
        58.54msview::frontend.layouts.app:659u145862214_boipok
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 13. view::frontend.layouts.app:659
        • 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 18. /vendor/laravel/framework/src/Illuminate/View/View.php:195
      App\Models\Upload
      3
      App\Models\Language
      2
      App\Models\AttributeValue
      4
      App\Models\Color
      87
      App\Models\AttributeTranslation
      6
      App\Models\Attribute
      6
      App\Models\CategoryTranslation
      8
      App\Models\Category
      8
        _token
        ABZ6RxoVfqfiNABbUd73Olfo8nMDZ6KOJq62Owjp
        locale
        en
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /category/best-selling-book
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:15 [ "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "host" => array:1 [ 0 => "boipokbd.com" ] "pragma" => array:1 [ 0 => "no-cache" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cache-control" => array:1 [ 0 => "no-cache" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "priority" => array:1 [ 0 => "u=0, i" ] ]
        request_server
        0 of 0
        array:53 [ "LSPHP_ProcessGroup" => "on" "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_HOST" => "boipokbd.com" "HTTP_PRAGMA" => "no-cache" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_PRIORITY" => "u=0, i" "DOCUMENT_ROOT" => "/home/u145862214/domains/boipokbd.com/public_html" "REMOTE_ADDR" => "3.134.112.111" "REMOTE_PORT" => "48122" "SERVER_ADDR" => "151.106.114.35" "SERVER_NAME" => "boipokbd.com" "SERVER_ADMIN" => "" "SERVER_PORT" => "443" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/category/best-selling-book" "REDIRECT_URL" => "/category/best-selling-book" "REDIRECT_REQUEST_METHOD" => "GET" "HTTPS" => "on" "CRAWLER_USLEEP" => "1000" "CRAWLER_LOAD_LIMIT_ENFORCE" => "25" "H_PLATFORM" => "Hostinger" "H_TYPE" => "business" "H_CANARY" => "false" "H_STAGING" => "false" "REDIRECT_STATUS" => "200" "X_SPDY" => "HTTP2" "SSL_PROTOCOL" => "TLSv1.3" "SSL_CIPHER" => "TLS_AES_128_GCM_SHA256" "SSL_CIPHER_USEKEYSIZE" => "128" "SSL_CIPHER_ALGKEYSIZE" => "128" "SCRIPT_FILENAME" => "/home/u145862214/domains/boipokbd.com/public_html/index.php" "QUERY_STRING" => "" "SCRIPT_URI" => "https://boipokbd.com/category/best-selling-book" "SCRIPT_URL" => "/category/best-selling-book" "SCRIPT_NAME" => "/index.php" "SERVER_PROTOCOL" => "HTTP/1.1" "SERVER_SOFTWARE" => "LiteSpeed" "REQUEST_METHOD" => "GET" "X-LSCACHE" => "on,crawler,esi,combine" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744623154.431 "REQUEST_TIME" => 1744623154 ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Mon, 14 Apr 2025 09:32:34 GMT" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=ABZ6RxoVfqfiNABbUd73Olfo8nMDZ6KOJq62Owjp; expires=Mon, 14 Apr 2025 11:32:35 GMT; Max-Age=7200; path=/" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=ABZ6RxoVfqfiNABbUd73Olfo8nMDZ6KOJq62Owjp; expires=Mon, 14-Apr-2025 11:32:35 GMT; path=/" ] ]
        session_attributes
        0 of 0
        array:3 [ "_token" => "ABZ6RxoVfqfiNABbUd73Olfo8nMDZ6KOJq62Owjp" "locale" => "en" "PHPDEBUGBAR_STACK_DATA" => [] ]