Books

Support and assistance

Round the clock support and assistance for an enjoyable shopping experience. You can also contact us through the user page (support and assistance)

shop with confidence

Our Customer Protection Policy applies to your entire purchase

Secure payment

We use our most secure payment method

Fast shipping

Fast shipping to all customer addresses through the services of our available shipping partners

Great value

We do our best to provide the best and lowest prices, and our sellers guarantee this


Request history8.0.30PHP Version2.15sRequest Duration11MBMemory UsageGET category/{category_slug}Route
    • Booting (32.41ms)time
    • Application (2.11s)time
    • 1 x Application (98.49%)
      2.11s
      1 x Booting (1.51%)
      32.41ms
      12 templates were rendered
      • frontend.product_listingproduct_listing.blade.php#?blade
      • pagination::bootstrap-4bootstrap-4.blade.php#?blade
      • frontend.layouts.appapp.blade.php#?blade
      • frontend.inc.navnav.blade.php#?blade
      • frontend.megamart.partials.comparecompare.blade.php#?blade
      • frontend.megamart.partials.wishlistwishlist.blade.php#?blade
      • frontend.megamart.partials.cartcart.blade.php#?blade
      • frontend.megamart.partials.category_menucategory_menu.blade.php#?blade
      • frontend.inc.footerfooter.blade.php#?blade
      • frontend.megamart.partials.modalmodal.blade.php#?blade
      • frontend.megamart.partials.login_modallogin_modal.blade.php#?blade
      • frontend.megamart.partials.account_delete_modalaccount_delete_modal.blade.php#?blade
      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:149-156
      30 statements were executed (9 duplicates)Show only duplicates9.32ms
      • select * from `categories` where `slug` = 'books-ozwpz' limit 1
        1.06msu669433489_loomSearchController.php#151
        Bindings
        • 0: books-ozwpz
        Backtrace
        • app/Http/Controllers/SearchController.php:151
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `category_translations` where `category_translations`.`category_id` in (30)
        230μsu669433489_loomSearchController.php#151
        Backtrace
        • app/Http/Controllers/SearchController.php:151
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `attributes`
        170μsu669433489_loomSearchController.php#25
        Backtrace
        • app/Http/Controllers/SearchController.php:25
        • app/Http/Controllers/SearchController.php:153
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `attribute_translations` where `attribute_translations`.`attribute_id` in (1, 2)
        230μsu669433489_loomSearchController.php#25
        Backtrace
        • app/Http/Controllers/SearchController.php:25
        • app/Http/Controllers/SearchController.php:153
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `colors`
        820μsu669433489_loomSearchController.php#27
        Backtrace
        • app/Http/Controllers/SearchController.php:27
        • app/Http/Controllers/SearchController.php:153
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `categories` where `parent_id` = 30 order by `order_level` desc
        200μsu669433489_loomCategoryUtility.php#12
        Bindings
        • 0: 30
        Backtrace
        • app/Utility/CategoryUtility.php:12
        • app/Utility/CategoryUtility.php:34
        • app/Utility/CategoryUtility.php:50
        • app/Http/Controllers/SearchController.php:48
        • app/Http/Controllers/SearchController.php:153
      • select * from `categories` where `categories`.`id` = 30 limit 1
        150μsu669433489_loomSearchController.php#50
        Bindings
        • 0: 30
        Backtrace
        • app/Http/Controllers/SearchController.php:50
        • app/Http/Controllers/SearchController.php:153
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `category_translations` where `category_translations`.`category_id` in (30)
        160μsu669433489_loomSearchController.php#50
        Backtrace
        • app/Http/Controllers/SearchController.php:50
        • app/Http/Controllers/SearchController.php:153
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `categories` where `categories`.`parent_id` in (30)
        160μsu669433489_loomSearchController.php#50
        Backtrace
        • app/Http/Controllers/SearchController.php:50
        • app/Http/Controllers/SearchController.php:153
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select `attribute_id` from `attribute_category` where `category_id` in (30)
        120μsu669433489_loomSearchController.php#54
        Bindings
        • 0: 30
        Backtrace
        • app/Http/Controllers/SearchController.php:54
        • app/Http/Controllers/SearchController.php:153
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `attributes` where 0 = 1
        100μsu669433489_loomSearchController.php#55
        Backtrace
        • app/Http/Controllers/SearchController.php:55
        • app/Http/Controllers/SearchController.php:153
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select count(*) as aggregate from `products` inner join `product_categories` on `products`.`id` = `product_categories`.`product_id` where `product_categories`.`category_id` = 30 and `published` = '1' and `auction_product` = 0 and `approved` = '1' and `wholesale_product` = 0 and (`added_by` = 'admin' or (`user_id` in (63, 70, 71, 72, 73, 74, 76, 77, 82)))
        290μsu669433489_loomSearchController.php#139
        Bindings
        • 0: 30
        • 1: 1
        • 2: 0
        • 3: 1
        • 4: 0
        • 5: admin
        • 6: 63
        • 7: 70
        • 8: 71
        • 9: 72
        • 10: 73
        • 11: 74
        • 12: 76
        • 13: 77
        • 14: 82
        Backtrace
        • app/Http/Controllers/SearchController.php:139
        • app/Http/Controllers/SearchController.php:153
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select count(*) as aggregate from `products` where `approved` = '1' and `published` = 1
        260μsu669433489_loomHelpers.php#1686
        Bindings
        • 0: 1
        • 1: 1
        Backtrace
        • app/Http/Helpers.php:1686
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select min(`unit_price`) as aggregate from `products` where `approved` = '1' and `published` = 1
        240μsu669433489_loomHelpers.php#1698
        Bindings
        • 0: 1
        • 1: 1
        Backtrace
        • app/Http/Helpers.php:1698
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select max(`unit_price`) as aggregate from `products` where `approved` = '1' and `published` = 1
        250μsu669433489_loomHelpers.php#1710
        Bindings
        • 0: 1
        • 1: 1
        Backtrace
        • app/Http/Helpers.php:1710
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `languages` where `code` = 'en' limit 1
        270μsu669433489_loomHelpers.php#1632
        Bindings
        • 0: en
        Backtrace
        • app/Http/Helpers.php:1632
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `uploads` where `uploads`.`id` = '2' and `uploads`.`deleted_at` is null limit 1
        220μsu669433489_loomHelpers.php#1171
        Bindings
        • 0: 2
        Backtrace
        • app/Http/Helpers.php:1171
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `uploads` where `uploads`.`id` = '19' and `uploads`.`deleted_at` is null limit 1
        340μsu669433489_loomHelpers.php#1171
        Bindings
        • 0: 19
        Backtrace
        • app/Http/Helpers.php:1171
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `addons`
        250μsu669433489_loomColorCodeConverter.php#35
        Backtrace
        • vendor/aiz-packages/color-code-converter/src/Services/ColorCodeConverter.php:35
        • app/Http/Helpers.php:1284
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • select * from `languages` where `code` = 'en' limit 1
        290μsu669433489_loomHelpers.php#1613
        Bindings
        • 0: en
        Backtrace
        • app/Http/Helpers.php:1613
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 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μsu669433489_loomHelpers.php#1171
        Backtrace
        • app/Http/Helpers.php:1171
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `languages` where `status` = 1
        230μsu669433489_loomHelpers.php#1623
        Bindings
        • 0: 1
        Backtrace
        • app/Http/Helpers.php:1623
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `currencies` where `id` = '29' limit 1
        230μsu669433489_loomHelpers.php#1647
        Bindings
        • 0: 29
        Backtrace
        • app/Http/Helpers.php:1647
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `currencies` where `status` = 1
        270μsu669433489_loomHelpers.php#1657
        Bindings
        • 0: 1
        Backtrace
        • app/Http/Helpers.php:1657
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `uploads` where `uploads`.`id` = '2' and `uploads`.`deleted_at` is null limit 1
        230μsu669433489_loomHelpers.php#1171
        Bindings
        • 0: 2
        Backtrace
        • app/Http/Helpers.php:1171
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `level` = 0 order by `order_level` desc
        480μsu669433489_loomHelpers.php#1894
        Bindings
        • 0: 0
        Backtrace
        • app/Http/Helpers.php:1894
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `category_translations` where `category_translations`.`category_id` in (1, 2, 3, 5, 7, 8, 9, 11, 23, 29, 30, 31, 32, 33, 34, 35, 37, 38, 39, 40, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 74, 75, 76, 78, 79, 80, 81, 83, 84, 85, 86, 87, 88, 89)
        420μsu669433489_loomHelpers.php#1894
        Backtrace
        • app/Http/Helpers.php:1894
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `uploads` where `uploads`.`id` in (2816, 2817, 2819, 2821, 2838, 2840, 2841, 2842, 2843, 2844, 2845, 2846, 2847, 2848, 2849, 2850, 2853, 2854, 2860, 2867, 2868, 2869, 2870, 2879, 2881, 2882, 2883, 2885, 2886, 2887, 2889, 2891, 2892, 2893, 2894, 2895, 2896, 2897, 2898, 2901, 2902, 2903, 2905, 2906, 2907, 2908, 2909, 2910, 2911, 2912, 2915, 2916, 2917, 2919, 2920, 2921, 2922, 2925, 2926, 2927, 2928, 2929, 2930, 2931) and `uploads`.`deleted_at` is null
        610μsu669433489_loomHelpers.php#1894
        Backtrace
        • app/Http/Helpers.php:1894
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `uploads` where `uploads`.`id` in (2816, 2817, 2819, 2821, 2838, 2840, 2841, 2842, 2843, 2844, 2845, 2846, 2847, 2848, 2849, 2850, 2853, 2854, 2860, 2867, 2868, 2869, 2870, 2879, 2881, 2882, 2883, 2885, 2886, 2887, 2889, 2891, 2892, 2893, 2894, 2895, 2896, 2897, 2898, 2901, 2902, 2903, 2905, 2906, 2907, 2908, 2909, 2910, 2911, 2912, 2915, 2916, 2917, 2919, 2920, 2921, 2922, 2925, 2926, 2927, 2928, 2929, 2930, 2931) and `uploads`.`deleted_at` is null
        570μsu669433489_loomHelpers.php#1894
        Backtrace
        • app/Http/Helpers.php:1894
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `uploads` where `uploads`.`id` = '2' and `uploads`.`deleted_at` is null limit 1
        290μsu669433489_loomHelpers.php#1171
        Bindings
        • 0: 2
        Backtrace
        • app/Http/Helpers.php:1171
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • vendor/laravel/framework/src/Illuminate/View/View.php:195
      App\Models\Color
      143Color.php#?
      App\Models\CategoryTranslation
      132CategoryTranslation.php#?
      App\Models\Upload
      132Upload.php#?
      App\Models\Category
      66Category.php#?
      App\Models\Language
      4Language.php#?
      App\Models\Attribute
      2Attribute.php#?
      App\Models\Currency
      2Currency.php#?
      App\Models\Addon
      1Addon.php#?
          _token
          8KKvIJLzAd5csof5OeGkvmkDDob2cJzSVaxseZiq
          locale
          en
          path_info
          /category/books-ozwpz
          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 => "loomshope.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_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 => "Fri, 03 Jan 2025 13:35:41 GMT" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=8KKvIJLzAd5csof5OeGkvmkDDob2cJzSVaxseZiq; expires=Fri, 03-Jan-2025 15:35:43 GMT; Max-Age=7200; path=/; domain=loomshope.com" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=8KKvIJLzAd5csof5OeGkvmkDDob2cJzSVaxseZiq; expires=Fri, 03-Jan-2025 15:35:43 GMT; domain=loomshope.com; path=/" ] ]
          session_attributes
          0 of 0
          array:2 [ "_token" => "8KKvIJLzAd5csof5OeGkvmkDDob2cJzSVaxseZiq" "locale" => "en" ]
          ClearShow all
          Date ↕MethodURLData
          #12025-01-03 15:35:43GET/category/books-ozwpz1230482