Order from

Part Number	MFR	Qty	Actions
CL21B182KBANNNC	WALSIN	448000	View Details
0603B182K500	WALSIN	8000	View Details
CL10B182KB8NNNC	WALSIN	64000	View Details
0402B182J500	WALSIN	70000	View Details
0805N182J500	WALSIN	28000	View Details
0603N182J500	WALSIN	32000	View Details
1206N182J101	WALSIN	140000	View Details
0603N182F500	WALSIN	180000	View Details
0201B181K500	WALSIN	15000	View Details
CL10B181KB8NNNC	WALSIN	184000	View Details
0402N181J500	WALSIN	220000	View Details
CL05C181JB5NNNC	WALSIN	260000	View Details
CL21C181JBANNNC	WALSIN	700000	View Details
0603N181J500	WALSIN	412000	View Details
CL10C181JB81PNC	WALSIN	36000	View Details
CL10C181JB8NNNC	WALSIN	28000	View Details
0603N181G500	WALSIN	156000	View Details
0201N180J500	WALSIN	4530000	View Details
RF15N180J500	WALSIN	30000	View Details
0402N180J500	WALSIN	200000	View Details
CL05C180JB51PNC	WALSIN	70000	View Details
CL05C180JB5NNNC	WALSIN	50000	View Details
0805N180J500	WALSIN	56000	View Details
0603N180J500	WALSIN	8000	View Details
CL10C180JB81PNC	WALSIN	48000	View Details
CL10C180JB8NNNC	WALSIN	12000	View Details
1206N180J101	WALSIN	16000	View Details
MT18N180J101	WALSIN	8000	View Details
0603N180J101	WALSIN	24000	View Details
CL10C180JC8NNNC	WALSIN	8000	View Details
0402N180G500	WALSIN	20000	View Details
0603N180G500	WALSIN	148000	View Details
0402N180F500	WALSIN	90000	View Details
0603N180F500	WALSIN	40000	View Details
0402N160J500	WALSIN	90000	View Details
0805N160J500	WALSIN	12000	View Details
0201N160G500	WALSIN	60000	View Details
0603N160G500	WALSIN	120000	View Details
1206B155K250	WALSIN	4000	View Details
0402X154K6R3	WALSIN	20000	View Details
0603B154K250	WALSIN	140000	View Details
CL10B154KA8NNNC	WALSIN	52000	View Details
1210B154K251	WALSIN	85000	View Details
0603B154K160	WALSIN	220000	View Details
CL10B154KO8VPNC	WALSIN	44000	View Details
CL10B154KO8NNNC	WALSIN	20000	View Details
0402X154K100	WALSIN	40000	View Details
1206B153K631	WALSIN	72000	View Details
0402B153K500	WALSIN	150000	View Details
CL05B153KB5VPNC	WALSIN	70000	View Details

Messages Timeline Exceptions Views5 Route Queries5 Models550 Mails Gate Session Request

8.1.295.31ms4MBGET products/{part_number?}

Booting (16.25ms)
Application (78.96ms)
1 x Application (82.84%)
78.96ms
1 x Booting (17.05%)
16.25ms

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 unique56.08ms

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

13.74ms/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 24350

32.26ms/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.39ms/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`

2.69ms/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`

2ms/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: TiSIgulWrFVOfh66idTDdfmvqNrrxZxy20WIFq77
_previous: array:1 [ "url" => "https://staging.univatech.com/products?page=488" ]
_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" => "488"
]

request_request

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

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" => "3.143.254.10"
  "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" => "46902"
  "REDIRECT_URL" => "/products"
  "REDIRECT_QUERY_STRING" => "page=488"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "page=488"
  "REQUEST_URI" => "/products?page=488"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1746295732.1779
  "REQUEST_TIME" => 1746295732
]

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 => "Sat, 03 May 2025 18:08:52 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkswQ3Jlekc2Z3VCQmJvQzlpOXVldGc9PSIsInZhbHVlIjoiWVBmenF2NDJ0OW40Z1c0VUM2akNLaGJiZlhERHM5bU9XUU9ZczlIUWVJMHRmdDQzR0dmY0dGSlFUUC95dURVMDQyWUVxSGNTNUJWN1FUVXcwajl5TmlONzdQNkQrc1M5OTZnRmZLQTVlUFdGWStoR1YzNTNPTlhKVUhxZDVHZjgiLCJtYWMiOiI0Zjc0ZDNjODBhNWZlODk2OGU2YTA5YWE4MTQyYzI3NmQwN2Y5NDUxMWViNTk1ZWVjOWI3YmFjYzIxNGJhN2Y2IiwidGFnIjoiIn0%3D; expires=Sat, 03-May-2025 20:08:52 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkswQ3Jlekc2Z3VCQmJvQzlpOXVldGc9PSIsInZhbHVlIjoiWVBmenF2NDJ0OW40Z1c0VUM2akNLaGJiZlhERHM5bU9XUU9ZczlIUWVJMHRmdDQzR0dmY0dGSlFUUC95dURVMDQyWUVxS ▶"
    1 => "univa_session=eyJpdiI6IjRveUJqQ3hiWmluV2VOa1BuTUgwcHc9PSIsInZhbHVlIjoibGpUU29UeUZaY0VvZ1lVeTJyWHRWS3lyVENCSkM0TksvOHg2L1ZvTXE1MURRME9tOEhtLzRkNEdvbEk5ZjJ6YWFHaGFvbGdPVThSUE1Da3cvbDBVT3VOMnFPQWEwY09hcUVxZk1MYy9PbW8ydC9BeXdkdTBaQTdsRUdlWElpSEMiLCJtYWMiOiJjODQ3MzQxZmEzMDIxMjA0MTk3MjQwZjUyNzZhYzRiOTA3OWIwNTA0MDA1MzBkMjc5NDE0OTdkMTZhYTcxY2NkIiwidGFnIjoiIn0%3D; expires=Sat, 03-May-2025 20:08:52 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀univa_session=eyJpdiI6IjRveUJqQ3hiWmluV2VOa1BuTUgwcHc9PSIsInZhbHVlIjoibGpUU29UeUZaY0VvZ1lVeTJyWHRWS3lyVENCSkM0TksvOHg2L1ZvTXE1MURRME9tOEhtLzRkNEdvbEk5ZjJ6YWFHaG ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkswQ3Jlekc2Z3VCQmJvQzlpOXVldGc9PSIsInZhbHVlIjoiWVBmenF2NDJ0OW40Z1c0VUM2akNLaGJiZlhERHM5bU9XUU9ZczlIUWVJMHRmdDQzR0dmY0dGSlFUUC95dURVMDQyWUVxSGNTNUJWN1FUVXcwajl5TmlONzdQNkQrc1M5OTZnRmZLQTVlUFdGWStoR1YzNTNPTlhKVUhxZDVHZjgiLCJtYWMiOiI0Zjc0ZDNjODBhNWZlODk2OGU2YTA5YWE4MTQyYzI3NmQwN2Y5NDUxMWViNTk1ZWVjOWI3YmFjYzIxNGJhN2Y2IiwidGFnIjoiIn0%3D; expires=Sat, 03-May-2025 20:08:52 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkswQ3Jlekc2Z3VCQmJvQzlpOXVldGc9PSIsInZhbHVlIjoiWVBmenF2NDJ0OW40Z1c0VUM2akNLaGJiZlhERHM5bU9XUU9ZczlIUWVJMHRmdDQzR0dmY0dGSlFUUC95dURVMDQyWUVxS ▶"
    1 => "univa_session=eyJpdiI6IjRveUJqQ3hiWmluV2VOa1BuTUgwcHc9PSIsInZhbHVlIjoibGpUU29UeUZaY0VvZ1lVeTJyWHRWS3lyVENCSkM0TksvOHg2L1ZvTXE1MURRME9tOEhtLzRkNEdvbEk5ZjJ6YWFHaGFvbGdPVThSUE1Da3cvbDBVT3VOMnFPQWEwY09hcUVxZk1MYy9PbW8ydC9BeXdkdTBaQTdsRUdlWElpSEMiLCJtYWMiOiJjODQ3MzQxZmEzMDIxMjA0MTk3MjQwZjUyNzZhYzRiOTA3OWIwNTA0MDA1MzBkMjc5NDE0OTdkMTZhYTcxY2NkIiwidGFnIjoiIn0%3D; expires=Sat, 03-May-2025 20:08:52 GMT; path=/; httponly ◀univa_session=eyJpdiI6IjRveUJqQ3hiWmluV2VOa1BuTUgwcHc9PSIsInZhbHVlIjoibGpUU29UeUZaY0VvZ1lVeTJyWHRWS3lyVENCSkM0TksvOHg2L1ZvTXE1MURRME9tOEhtLzRkNEdvbEk5ZjJ6YWFHaG ▶"
  ]
]

session_attributes

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

1 x Application (82.84%)	78.96ms
1 x Booting (17.05%)	16.25ms

26951 Products Found