• search

  • filter_list Filter

Categories

Food Voucher


Download the New Pricepally Mobile App

download-img

Dedicated Service

We are committed to serve you the best products

Free Return

We stand behind what we serve you

Contact us

Mon to Fri: 8am to 10pm.
Saturday: 8am to 6pm.

Call +2347045000375 , +2349160000375
WhatsApp: +2349160000375

8.0.30PHP Version148msRequest Duration6MBMemory UsagePOST products/category/{slug}Route
    • Booting (16.35ms)
    • Application (132ms)
    • 1 x Application (88.88%)
      131.92ms
      1 x Booting (11.02%)
      16.35ms
      7 templates were rendered
      • front.products.index (resources/views/front/products/index.blade.php)14blade
        Params
        0
        category
        1
        title
        2
        description
        3
        class
        4
        table
        5
        prodImageUrl
        6
        category_name
        7
        top_category
        8
        top_sub_category
        9
        offset
        10
        limit
        11
        categories
        12
        subCategoriesFooter
        13
        productsCount
      • front.home.downloadLoad (resources/views/front/home/downloadLoad.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        category
        5
        title
        6
        description
        7
        class
        8
        table
        9
        prodImageUrl
        10
        category_name
        11
        top_category
        12
        top_sub_category
        13
        offset
        14
        limit
        15
        categories
        16
        subCategoriesFooter
        17
        productsCount
      • front.home.shippingLoad (resources/views/front/home/shippingLoad.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        category
        5
        title
        6
        description
        7
        class
        8
        table
        9
        prodImageUrl
        10
        category_name
        11
        top_category
        12
        top_sub_category
        13
        offset
        14
        limit
        15
        categories
        16
        subCategoriesFooter
        17
        productsCount
      • front.categories.subCategoriesLoad (resources/views/front/categories/subCategoriesLoad.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        category
        5
        title
        6
        description
        7
        class
        8
        table
        9
        prodImageUrl
        10
        category_name
        11
        top_category
        12
        top_sub_category
        13
        offset
        14
        limit
        15
        categories
        16
        subCategoriesFooter
        17
        productsCount
      • front.template (resources/views/front/template.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        category
        5
        title
        6
        description
        7
        class
        8
        table
        9
        prodImageUrl
        10
        category_name
        11
        top_category
        12
        top_sub_category
        13
        offset
        14
        limit
        15
        categories
        16
        subCategoriesFooter
        17
        productsCount
      • front.header (resources/views/front/header.blade.php)20blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        category
        5
        title
        6
        description
        7
        class
        8
        table
        9
        prodImageUrl
        10
        category_name
        11
        top_category
        12
        top_sub_category
        13
        offset
        14
        limit
        15
        categories
        16
        subCategoriesFooter
        17
        productsCount
        18
        getSettings
        19
        normal_days
      • front.footer (resources/views/front/footer.blade.php)20blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        category
        5
        title
        6
        description
        7
        class
        8
        table
        9
        prodImageUrl
        10
        category_name
        11
        top_category
        12
        top_sub_category
        13
        offset
        14
        limit
        15
        categories
        16
        subCategoriesFooter
        17
        productsCount
        18
        getSettings
        19
        normal_days
      uri
      POST products/category/{slug}
      middleware
      web
      controller
      App\Http\Controllers\Front\ProductControllor@categoryProducts
      namespace
      App\Http\Controllers
      prefix
      where
      file
      app/Http/Controllers/Front/ProductControllor.php:181-216
      12 statements were executed, 2 of which were duplicated, 10 unique111ms
      • select * from `categories` where `slug` = 'food-voucher-6592' limit 1
        1.81ms/app/Http/Controllers/Front/ProductControllor.php:183staging_pricepally
        Metadata
        Bindings
        • 0. food-voucher-6592
        Backtrace
        • 15. /app/Http/Controllers/Front/ProductControllor.php:183
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196
      • select `id` from `categories` where `slug` = 'food-voucher-6592' and `status` = 0 limit 1
        240μs/app/Http/Controllers/Front/ProductControllor.php:193staging_pricepally
        Metadata
        Bindings
        • 0. food-voucher-6592
        • 1. 0
        Backtrace
        • 15. /app/Http/Controllers/Front/ProductControllor.php:193
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196
      • select `id`, `title`, `slug` from `categories` where `parent_id` = 0 and `region_id` is null and `status` = 0
        160μs/app/Http/Controllers/Front/ProductControllor.php:204staging_pricepally
        Metadata
        Bindings
        • 0. 0
        • 1. 0
        Backtrace
        • 14. /app/Http/Controllers/Front/ProductControllor.php:204
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196
      • select `id`, `title`, `slug` from `categories` where `parent_id` = 71 and `region_id` is null and `status` = 0
        170μs/app/Http/Controllers/Front/ProductControllor.php:205staging_pricepally
        Metadata
        Bindings
        • 0. 71
        • 1. 0
        Backtrace
        • 14. /app/Http/Controllers/Front/ProductControllor.php:205
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196
      • select `products`.`id`, `products`.`product_id`, `products`.`product_title`, `products`.`slug`, `products`.`cat_id`, `products`.`product_images`, `products`.`product_price`, `categories`.`title` as `categories_title`, `products`.`product_unit`, `products`.`bulk_price` from `products` inner join `categories` on `products`.`cat_id` = `categories`.`id` where `products`.`cat_id` = 71 and `products`.`status` = 1 and `products`.`is_make_list` = 0 and `products`.`is_pre_orders` = 0 and `products`.`region_id` is null
        200μs/app/Http/Controllers/Front/ProductControllor.php:213staging_pricepally
        Metadata
        Bindings
        • 0. 71
        • 1. 1
        • 2. 0
        • 3. 0
        Backtrace
        • 14. /app/Http/Controllers/Front/ProductControllor.php:213
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196
      • select * from `settings` limit 1
        240μs/app/Classes/CommonLibrary.php:819staging_pricepally
        Metadata
        Backtrace
        • 18. /app/Classes/CommonLibrary.php:819
        • 19. view::5c87ad3d2863cc2931683b9cd1bef51efea0984f:4
        • 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57
        • 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
        • 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • select count(*) as aggregate from `cart_items` where `user_id` is null and `region_id` is null
        200μs/app/Classes/CommonLibrary.php:880staging_pricepally
        Metadata
        Backtrace
        • 15. /app/Classes/CommonLibrary.php:880
        • 16. view::fb8f261e0d8309481a224f358c4085f3a2db11a5:101
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57
        • 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • select * from `categories` where `status` = 0 and `parent_id` = 0 and `region_id` is null order by `category_order` asc limit 10
        220μs/app/Classes/CommonLibrary.php:1070staging_pricepally
        Metadata
        Bindings
        • 0. 0
        • 1. 0
        Backtrace
        • 14. /app/Classes/CommonLibrary.php:1070
        • 15. view::82dd65bf07dd1c755462ba8e1c1aea8bcc25dc70:1
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57
        • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • select count(*) as aggregate from `cart_items` where `user_id` is null and `region_id` is null
        190μs/app/Classes/CommonLibrary.php:880staging_pricepally
        Metadata
        Backtrace
        • 15. /app/Classes/CommonLibrary.php:880
        • 16. view::82dd65bf07dd1c755462ba8e1c1aea8bcc25dc70:100
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57
        • 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • select count(*) as aggregate from `notifications` where `reciever_user_id` is null and `status` = 0
        210μs/app/Classes/CommonLibrary.php:815staging_pricepally
        Metadata
        Bindings
        • 0. 0
        Backtrace
        • 15. /app/Classes/CommonLibrary.php:815
        • 16. view::82dd65bf07dd1c755462ba8e1c1aea8bcc25dc70:123
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57
        • 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • select count(*) as aggregate from `orders` where date(`created_at`) = '2025-06-15' and `status` != 'Pending'
        54.29msview::5c87ad3d2863cc2931683b9cd1bef51efea0984f:388staging_pricepally
        Metadata
        Bindings
        • 0. 2025-06-15
        • 1. Pending
        Backtrace
        • 15. view::5c87ad3d2863cc2931683b9cd1bef51efea0984f:388
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57
        • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:139
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:122
      • select count(*) as aggregate from `orders` where `created_at` >= '2025-06-15 00:00:00'
        53.34msview::5c87ad3d2863cc2931683b9cd1bef51efea0984f:390staging_pricepally
        Metadata
        Bindings
        • 0. 2025-06-15 00:00:00
        Backtrace
        • 15. view::5c87ad3d2863cc2931683b9cd1bef51efea0984f:390
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57
        • 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:139
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:122
      App\Models\Setting
      1
      App\Models\Category
      2
          _token
          leyHm0wSKFIfs51g6KYYBjjjJYICUJYCSxIszX3H
          _previous
          array:1 [ "url" => "https://staging.pricepally.com/products/category/food-voucher-6592" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /products/category/food-voucher-6592
          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-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "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" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "staging.pricepally.com" ] ]
          request_server
          0 of 0
          array:52 [ "USER" => "staging" "HOME" => "/home/staging" "SCRIPT_NAME" => "/index.php" "REQUEST_URI" => "/products/category/food-voucher-6592" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/1.1" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/products/category/food-voucher-6592" "REMOTE_PORT" => "4650" "SCRIPT_FILENAME" => "/home/staging/public_html/index.php" "SERVER_ADMIN" => "webmaster@staging.pricepally.com" "CONTEXT_DOCUMENT_ROOT" => "/home/staging/public_html" "CONTEXT_PREFIX" => "" "REQUEST_SCHEME" => "https" "DOCUMENT_ROOT" => "/home/staging/public_html" "REMOTE_ADDR" => "216.73.216.141" "SERVER_PORT" => "443" "SERVER_ADDR" => "148.251.11.3" "SERVER_NAME" => "staging.pricepally.com" "SERVER_SOFTWARE" => "Apache" "SERVER_SIGNATURE" => "" "PATH" => "/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bi" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "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_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_CONNECTION" => "keep-alive" "HTTP_HOST" => "staging.pricepally.com" "proxy-nokeepalive" => "1" "SSL_TLS_SNI" => "staging.pricepally.com" "HTTPS" => "on" "UNIQUE_ID" => "aE88ONrZFLxOmgHBloR9SgAAAIc" "REDIRECT_STATUS" => "200" "REDIRECT_SSL_TLS_SNI" => "staging.pricepally.com" "REDIRECT_HTTPS" => "on" "REDIRECT_UNIQUE_ID" => "aE88ONrZFLxOmgHBloR9SgAAAIc" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1750023224.278 "REQUEST_TIME" => 1750023224 "argv" => [] "argc" => 0 ]
          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 => "Sun, 15 Jun 2025 21:33:44 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlZ3UHE0Q0IySEROQ3R5VDN3UlB5RHc9PSIsInZhbHVlIjoiZStrTUZzZld5eTBWUExiUkdFZzhtak13VXhBbkhTUENIZzRWT2RpNE15N05lY3VqWnlmK2VqbUQwMlJ0aHdEaTdXUTRZSVBzSVF4N2R1Ymw0ZFpPOWNldXVORDRVTlNKV29ueW1wYWdsR2JvNklpSVphRVVjTjRDZmpjZGU3THQiLCJtYWMiOiIxZGZlYWNhNDRhODY3YzlhZTBiNzFhYzZlOWJiOTY1NjlkMTAzMTA1M2EzZjhlNmY0ZGQ5OWExOGMzNDNjZjQ4In0%3D; expires=Thu, 26-Jun-2025 07:33:44 GMT; Max-Age=900000; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6IlZ3UHE0Q0IySEROQ3R5VDN3UlB5RHc9PSIsInZhbHVlIjoiZStrTUZzZld5eTBWUExiUkdFZzhtak13VXhBbkhTUENIZzRWT2RpNE15N05lY3VqWnlmK2VqbUQwMlJ0aHdEaTdXUTRZS" 1 => "laravel_session=eyJpdiI6InVJLzd5bU5CaC9OYkdkNklST1VVMEE9PSIsInZhbHVlIjoic2hORTlwUHE1UXRRRG1zaGkvWWd3TzRqdENLZFRXK3M3SkpNMU02VUJPWjAwdEM0TFVUWWc4eThlUkgreFF6Wk5XVy9Waml4RnpLa3pzbjVIRGhsMm5PS29MM2psY2RBZWc1dVdkNGx6UktKTFAremk5Z21FaVVWcmszYU15dDYiLCJtYWMiOiI5MGUyMTk3N2QxYzdkNjI5ZTdiNTQxMjYxYWIzMjQyZjE0M2M2YTkwMmFiN2FlYmJlYzU3N2NjYWUxOGU4NWJkIn0%3D; expires=Thu, 26-Jun-2025 07:33:44 GMT; Max-Age=900000; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6InVJLzd5bU5CaC9OYkdkNklST1VVMEE9PSIsInZhbHVlIjoic2hORTlwUHE1UXRRRG1zaGkvWWd3TzRqdENLZFRXK3M3SkpNMU02VUJPWjAwdEM0TFVUWWc4eThlUkgreFF6Wk5X" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlZ3UHE0Q0IySEROQ3R5VDN3UlB5RHc9PSIsInZhbHVlIjoiZStrTUZzZld5eTBWUExiUkdFZzhtak13VXhBbkhTUENIZzRWT2RpNE15N05lY3VqWnlmK2VqbUQwMlJ0aHdEaTdXUTRZSVBzSVF4N2R1Ymw0ZFpPOWNldXVORDRVTlNKV29ueW1wYWdsR2JvNklpSVphRVVjTjRDZmpjZGU3THQiLCJtYWMiOiIxZGZlYWNhNDRhODY3YzlhZTBiNzFhYzZlOWJiOTY1NjlkMTAzMTA1M2EzZjhlNmY0ZGQ5OWExOGMzNDNjZjQ4In0%3D; expires=Thu, 26-Jun-2025 07:33:44 GMT; path=/XSRF-TOKEN=eyJpdiI6IlZ3UHE0Q0IySEROQ3R5VDN3UlB5RHc9PSIsInZhbHVlIjoiZStrTUZzZld5eTBWUExiUkdFZzhtak13VXhBbkhTUENIZzRWT2RpNE15N05lY3VqWnlmK2VqbUQwMlJ0aHdEaTdXUTRZS" 1 => "laravel_session=eyJpdiI6InVJLzd5bU5CaC9OYkdkNklST1VVMEE9PSIsInZhbHVlIjoic2hORTlwUHE1UXRRRG1zaGkvWWd3TzRqdENLZFRXK3M3SkpNMU02VUJPWjAwdEM0TFVUWWc4eThlUkgreFF6Wk5XVy9Waml4RnpLa3pzbjVIRGhsMm5PS29MM2psY2RBZWc1dVdkNGx6UktKTFAremk5Z21FaVVWcmszYU15dDYiLCJtYWMiOiI5MGUyMTk3N2QxYzdkNjI5ZTdiNTQxMjYxYWIzMjQyZjE0M2M2YTkwMmFiN2FlYmJlYzU3N2NjYWUxOGU4NWJkIn0%3D; expires=Thu, 26-Jun-2025 07:33:44 GMT; path=/; httponlylaravel_session=eyJpdiI6InVJLzd5bU5CaC9OYkdkNklST1VVMEE9PSIsInZhbHVlIjoic2hORTlwUHE1UXRRRG1zaGkvWWd3TzRqdENLZFRXK3M3SkpNMU02VUJPWjAwdEM0TFVUWWc4eThlUkgreFF6Wk5X" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "leyHm0wSKFIfs51g6KYYBjjjJYICUJYCSxIszX3H" "_previous" => array:1 [ "url" => "https://staging.pricepally.com/products/category/food-voucher-6592" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]