Order from

Part Number	MFR	Qty	Actions
0402N120J500	WALSIN	40000	View Details
CL05C120JB51PNC	WALSIN	60000	View Details
CL05C120JB5NNNC	WALSIN	40000	View Details
0805N120J500	WALSIN	4000	View Details
CL21C120JBANNNC	WALSIN	196000	View Details
0603N120J500	WALSIN	500000	View Details
CL10C120JB81PNC	WALSIN	44000	View Details
RF03N120J250	WALSIN	30000	View Details
0201N120J250	WALSIN	105000	View Details
0201N120G500	WALSIN	930000	View Details
0402N120G500	WALSIN	200000	View Details
0603N120G500	WALSIN	24000	View Details
0201N120F500	WALSIN	120000	View Details
RF15N120F500	WALSIN	40000	View Details
0402N120F500	WALSIN	240000	View Details
HH18N120F500	WALSIN	472000	View Details
0603N120F500	WALSIN	48000	View Details
0603N111J500	WALSIN	4000	View Details
0402N110J500	WALSIN	20000	View Details
0603N110J500	WALSIN	4000	View Details
CL10C110JB8NNNC	WALSIN	36000	View Details
CL32A107MQVNNNE	WALSIN	40000	View Details
CL31A107MQHNNNE	WALSIN	2399000	View Details
CL32A107MPVNNNE	WALSIN	211000	View Details
1210F106Z160	WALSIN	9000	View Details
1206F106Z100	WALSIN	222000	View Details
CL31F106ZPHNNNE	WALSIN	36000	View Details
CL31F106ZPENNNE	WALSIN	4000	View Details
0805F106Z100	WALSIN	825000	View Details
CL21F106ZPFNNNE	WALSIN	90000	View Details
CL10Z106MQ9VPNC	WALSIN	28000	View Details
CL10B106MQ8NRNC	WALSIN	20000	View Details
CL10X106MQ8NNNC	WALSIN	200000	View Details
0402X106M6R3	WALSIN	1200000	View Details
CL05A106MQ5NUNC	WALSIN	180000	View Details
CL21A106MQFNNNE	WALSIN	58000	View Details
0603X106M6R3	WALSIN	48000	View Details
CL10A106MQ8NNNC	WALSIN	21148000	View Details
1210X106M500	WALSIN	302000	View Details
CL10X106MR8NNNC	WALSIN	1436000	View Details
1206X106M250	WALSIN	654000	View Details
CL31A106MAHNNNE	WALSIN	122000	View Details
CL31A106MOHNNNE	WALSIN	412000	View Details
0603X106M160	WALSIN	64000	View Details
CL10A106MO8NQNC	WALSIN	836000	View Details
0805F106M100	WALSIN	4464000	View Details
CL10X106MP8NRNC	WALSIN	68000	View Details
0402X106M100	WALSIN	850000	View Details
CL05A106MP5NUNC	WALSIN	70000	View Details
CL21A106MPFNNNE	WALSIN	214000	View Details

Messages Timeline Exceptions Views5 Route Queries5 Models550 Mails Gate Session Request

8.1.295.88ms4MBGET products/{part_number?}

Booting (17.21ms)
Application (78.56ms)
1 x Application (81.94%)
78.56ms
1 x Booting (17.95%)
17.21ms

5 templates were rendered

frontend.products.all (resources/views/frontend/products/all.blade.php)1blade
Params
0
products
pagination::bootstrap-4 (vendor/laravel/framework/src/Illuminate/Pagination/resources/views/bootstrap-4.blade.php)2blade
Params
0
paginator
1
elements
frontend.layouts.master (resources/views/frontend/layouts/master.blade.php)11blade
Params
0
__env
1
app
2
errors
3
products
4
__currentLoopData
5
product
6
key
7
loop
8
url_exist
9
ch
10
code
frontend.layouts.header (resources/views/frontend/layouts/header.blade.php)11blade
Params
0
__env
1
app
2
errors
3
products
4
__currentLoopData
5
product
6
key
7
loop
8
url_exist
9
ch
10
code
frontend.layouts.footer (resources/views/frontend/layouts/footer.blade.php)11blade
Params
0
__env
1
app
2
errors
3
products
4
__currentLoopData
5
product
6
key
7
loop
8
url_exist
9
ch
10
code

Params
0	`products`

Params
0	`paginator`
1	`elements`

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`__currentLoopData`
5	`product`
6	`key`
7	`loop`
8	`url_exist`
9	`ch`
10	`code`

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`__currentLoopData`
5	`product`
6	`key`
7	`loop`
8	`url_exist`
9	`ch`
10	`code`

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`__currentLoopData`
5	`product`
6	`key`
7	`loop`
8	`url_exist`
9	`ch`
10	`code`

uri: GET products/{part_number?}
middleware: web
controller: App\Http\Controllers\ProductsController@index
namespace
prefix
where
as: products
file: app/Http/Controllers/ProductsController.php:29-57

5 statements were executed, 2 of which were duplicated, 3 unique55.37ms

select count(*) as aggregate from `item_master` where `item_master`.`active` = 1 and `item_master`.`mfr` is not null and `quantity` > 0

12.33ms/app/Http/Controllers/ProductsController.php:41univa_staging_april2025

Metadata
Bindings	0. 1 1. 0
Backtrace	15. /app/Http/Controllers/ProductsController.php:41 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:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `item_master`.*, (SELECT SUM(quantity) FROM supplier_items WHERE supplier_items.item = item_master.id) as quantity, (select manufacturer_master.image from `manufacturer_master` where `manufacturer_master`.`id` = item_master.mfr and `item_master`.`mfr` is not null order by `created_at` desc limit 1) as mfr_image, (select manufacturer_master.name from `manufacturer_master` where `manufacturer_master`.`id` = item_master.mfr and `item_master`.`mfr` is not null order by `created_at` desc limit 1) as mfr_name, (select item_category_master.name from `item_category_master` where `item_category_master`.`id` = item_master.item_category  order by `created_at` desc limit 1) as item_category_name from `item_master` where `item_master`.`active` = 1 and `item_master`.`mfr` is not null and `quantity` > 0 order by `id` desc limit 50 offset 24500

32.4ms/app/Http/Controllers/ProductsController.php:41univa_staging_april2025

Metadata
Bindings	0. 1 1. 0
Backtrace	15. /app/Http/Controllers/ProductsController.php:41 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:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `item_category_master` where exists ( select * from `item_master` where `item_category_master`.`id` = `item_master`.`item_category` ) and `parent_category` is null

5.62ms/app/Helpers/helpers.php:29univa_staging_april2025

Metadata
Backtrace	14. /app/Helpers/helpers.php:29 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `country`

3.05ms/app/Helpers/helpers.php:44univa_staging_april2025

Metadata
Backtrace	15. /app/Helpers/helpers.php:44 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `country`

1.97ms/app/Helpers/helpers.php:44univa_staging_april2025

Metadata
Backtrace	15. /app/Helpers/helpers.php:44 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

App\Models\Country: 500
App\Models\ItemMaster: 50

_token: PrOElmIgNl7v1Kgt65lyteJf3bGirwj5ZpXsQyip
_previous: array:1 [ "url" => "https://staging.univatech.com/products?page=491" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/products

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "page" => "491"
]

request_request

  0 of 0   
array:1 [▼
  "page" => "491"
]

request_headers

  0 of 0   
array:15 [▼
  "host" => array:1 [▶
    0 => "staging.univatech.com"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "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"
  ]
  "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"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
]

request_server

  0 of 0   
array:49 [▼
  "REDIRECT_SCRIPT_URL" => "/products"
  "REDIRECT_SCRIPT_URI" => "https://staging.univatech.com/products"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_SSL_TLS_SNI" => "staging.univatech.com"
  "REDIRECT_STATUS" => "200"
  "SCRIPT_URL" => "/products"
  "SCRIPT_URI" => "https://staging.univatech.com/products"
  "HTTPS" => "on"
  "SSL_TLS_SNI" => "staging.univatech.com"
  "HTTP_HOST" => "staging.univatech.com"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "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_SEC_FETCH_SITE" => "none"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"
  "SERVER_SIGNATURE" => "<address>Apache/2.4.52 (Ubuntu) Server at staging.univatech.com Port 443</address>\n"
  "SERVER_SOFTWARE" => "Apache/2.4.52 (Ubuntu)"
  "SERVER_NAME" => "staging.univatech.com"
  "SERVER_ADDR" => "172.31.46.4"
  "SERVER_PORT" => "443"
  "REMOTE_ADDR" => "216.73.216.139"
  "DOCUMENT_ROOT" => "/var/www/staging/public/"
  "REQUEST_SCHEME" => "https"
  "CONTEXT_PREFIX" => ""
  "CONTEXT_DOCUMENT_ROOT" => "/var/www/staging/public/"
  "SERVER_ADMIN" => "webmaster@localhost"
  "SCRIPT_FILENAME" => "/var/www/staging/public/index.php"
  "REMOTE_PORT" => "38101"
  "REDIRECT_URL" => "/products"
  "REDIRECT_QUERY_STRING" => "page=491"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "page=491"
  "REQUEST_URI" => "/products?page=491"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1752396145.7348
  "REQUEST_TIME" => 1752396145
]

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, 13 Jul 2025 08:42:25 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IitIM3ZML29LeUJRdXZtNk02TWlWZ0E9PSIsInZhbHVlIjoiendnaDdIM29INzlYTEhYYUdIdjZLK0FKT29kZkV1WFYyMytOajVLY2hSbEJtVUJHQTBUc0tvNDNia256UUJNMGN3REJaVkUzR0lEY2ZSMGI3Y2FpUHY5My9ka1pDL0owNkp5cm9KWm0zaENkNTMyek1TcE5CUEFPaFlrQWQzTFMiLCJtYWMiOiJkMjBiNjM0NDAxZjA1YTc4YTQyNDExYzAwYjQxOTU3ZjRiYjJiZmJkNTA5M2I1MmU1NzEyNjY5N2EwNTlhZTRiIiwidGFnIjoiIn0%3D; expires=Sun, 13-Jul-2025 10:42:25 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IitIM3ZML29LeUJRdXZtNk02TWlWZ0E9PSIsInZhbHVlIjoiendnaDdIM29INzlYTEhYYUdIdjZLK0FKT29kZkV1WFYyMytOajVLY2hSbEJtVUJHQTBUc0tvNDNia256UUJNMGN3REJaV ▶"
    1 => "univa_session=eyJpdiI6IjRmM1RnNkN1ZXhaNzlTU1dhOGRzYWc9PSIsInZhbHVlIjoiQjBiSTVCeXptZHQxTjM5ZWVxTVBXdnBVV3pVT1lzNi90a2w3T1k2VlhGSjd3OGpCWE9kLzNIUzFwVjgwMlJqNzlFaDRXUGF4RmhoQ0w3eUt2amhJdXZHY0FmUHpwemtRRDJiYnBGczB0RGVUZmUvaFc0c21tODk1Ujg4RkFOV3kiLCJtYWMiOiI4NGVjNmVjMjE0NWZjNzRiOTg4MmNkYTI3MmQyNzU2NzcwZDMzZjY2NzQ2ODk3MTc0OTcxZTcyODM5MjUzZjFmIiwidGFnIjoiIn0%3D; expires=Sun, 13-Jul-2025 10:42:25 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀univa_session=eyJpdiI6IjRmM1RnNkN1ZXhaNzlTU1dhOGRzYWc9PSIsInZhbHVlIjoiQjBiSTVCeXptZHQxTjM5ZWVxTVBXdnBVV3pVT1lzNi90a2w3T1k2VlhGSjd3OGpCWE9kLzNIUzFwVjgwMlJqNzlFaD ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IitIM3ZML29LeUJRdXZtNk02TWlWZ0E9PSIsInZhbHVlIjoiendnaDdIM29INzlYTEhYYUdIdjZLK0FKT29kZkV1WFYyMytOajVLY2hSbEJtVUJHQTBUc0tvNDNia256UUJNMGN3REJaVkUzR0lEY2ZSMGI3Y2FpUHY5My9ka1pDL0owNkp5cm9KWm0zaENkNTMyek1TcE5CUEFPaFlrQWQzTFMiLCJtYWMiOiJkMjBiNjM0NDAxZjA1YTc4YTQyNDExYzAwYjQxOTU3ZjRiYjJiZmJkNTA5M2I1MmU1NzEyNjY5N2EwNTlhZTRiIiwidGFnIjoiIn0%3D; expires=Sun, 13-Jul-2025 10:42:25 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IitIM3ZML29LeUJRdXZtNk02TWlWZ0E9PSIsInZhbHVlIjoiendnaDdIM29INzlYTEhYYUdIdjZLK0FKT29kZkV1WFYyMytOajVLY2hSbEJtVUJHQTBUc0tvNDNia256UUJNMGN3REJaV ▶"
    1 => "univa_session=eyJpdiI6IjRmM1RnNkN1ZXhaNzlTU1dhOGRzYWc9PSIsInZhbHVlIjoiQjBiSTVCeXptZHQxTjM5ZWVxTVBXdnBVV3pVT1lzNi90a2w3T1k2VlhGSjd3OGpCWE9kLzNIUzFwVjgwMlJqNzlFaDRXUGF4RmhoQ0w3eUt2amhJdXZHY0FmUHpwemtRRDJiYnBGczB0RGVUZmUvaFc0c21tODk1Ujg4RkFOV3kiLCJtYWMiOiI4NGVjNmVjMjE0NWZjNzRiOTg4MmNkYTI3MmQyNzU2NzcwZDMzZjY2NzQ2ODk3MTc0OTcxZTcyODM5MjUzZjFmIiwidGFnIjoiIn0%3D; expires=Sun, 13-Jul-2025 10:42:25 GMT; path=/; httponly ◀univa_session=eyJpdiI6IjRmM1RnNkN1ZXhaNzlTU1dhOGRzYWc9PSIsInZhbHVlIjoiQjBiSTVCeXptZHQxTjM5ZWVxTVBXdnBVV3pVT1lzNi90a2w3T1k2VlhGSjd3OGpCWE9kLzNIUzFwVjgwMlJqNzlFaD ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "PrOElmIgNl7v1Kgt65lyteJf3bGirwj5ZpXsQyip"
  "_previous" => array:1 [▶
    "url" => "https://staging.univatech.com/products?page=491"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Application (81.94%)	78.56ms
1 x Booting (17.95%)	17.21ms

26951 Products Found