Order from

Part Number	MFR	Qty	Actions
0603X474K100	WALSIN	864000	View Details
1210B474K101	WALSIN	3000	View Details
1206B474K101	WALSIN	2000	View Details
0805B474K101	WALSIN	3000	View Details
0201X473K6R3	WALSIN	15000	View Details
1812B473K631	WALSIN	7000	View Details
0402B473K500	WALSIN	210000	View Details
1206B473K500	WALSIN	20000	View Details
0805B473K500	WALSIN	716000	View Details
CL21B473KBCNNNC	WALSIN	44000	View Details
MT18B473K500	WALSIN	8000	View Details
0603B473K500	WALSIN	468000	View Details
CL10B473KB8WPNC	WALSIN	44000	View Details
CL10B473KB8NNNC	WALSIN	228000	View Details
0402B473K250	WALSIN	390000	View Details
0603B473K250	WALSIN	244000	View Details
1206B473K251	WALSIN	436000	View Details
0805B473K251	WALSIN	6000	View Details
0402B473K160	WALSIN	100000	View Details
0603B473K160	WALSIN	208000	View Details
0402B473K100	WALSIN	190000	View Details
CL05B473KP5NNNC	WALSIN	6400000	View Details
0201X473K100	WALSIN	300000	View Details
CL05A473KP5NNNC	WALSIN	5870000	View Details
1206B473K101	WALSIN	104000	View Details
CL10B473KC8WPNC	WALSIN	40000	View Details
0402B473J160	WALSIN	220000	View Details
1206B472K631	WALSIN	1731000	View Details
0402B472K500	WALSIN	650000	View Details
CL05B472KB5NNNC	WALSIN	260000	View Details
1206B472K500	WALSIN	16000	View Details
CL31B472KBCNNNC	WALSIN	8000	View Details
0805B472K500	WALSIN	60000	View Details
CL21B472KBANNNC	WALSIN	100000	View Details
0603B472K500	WALSIN	152000	View Details
CL10B472KB8WPNC	WALSIN	60000	View Details
CL10B472KB8NNNC	WALSIN	124000	View Details
S255B472K502	WALSIN	6000	View Details
1206B472K501	WALSIN	6000	View Details
0805B472K501	WALSIN	12000	View Details
1210B472K202	WALSIN	367000	View Details
1812B472K202	WALSIN	96000	View Details
0201B472K250	WALSIN	30000	View Details
0402B472K250	WALSIN	110000	View Details
CL05B472KA5VPNC	WALSIN	100000	View Details
1206B472K251	WALSIN	39000	View Details
0603B472K251	WALSIN	20000	View Details
0201B472K100	WALSIN	45000	View Details
0603B472K101	WALSIN	48000	View Details
CL10B472KC8WPNC	WALSIN	56000	View Details

Messages Timeline Exceptions Views5 Route Queries5 Models550 Mails Gate Session Request

8.1.299.17ms4MBGET products/{part_number?}

Booting (18.51ms)
Application (80.55ms)
1 x Application (81.22%)
80.55ms
1 x Booting (18.66%)
18.51ms

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.3ms

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

14.86ms/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 23600

31.17ms/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.82ms/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.47ms/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.98ms/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: Z1XLMnqZccbgGHjydhKmY46qNC7COyzlnVuo5o7T
_previous: array:1 [ "url" => "https://staging.univatech.com/products?page=473" ]
_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" => "473"
]

request_request

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

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" => "52.15.191.6"
  "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" => "55946"
  "REDIRECT_URL" => "/products"
  "REDIRECT_QUERY_STRING" => "page=473"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "page=473"
  "REQUEST_URI" => "/products?page=473"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1748723729.6123
  "REQUEST_TIME" => 1748723729
]

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, 31 May 2025 20:35:29 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IndROHdFWE5SYnQ0VElsWjg0bFFqaEE9PSIsInZhbHVlIjoidDBsZHM1YkZIV3dqQnJVVk43NXpBVTl0MHk4U2RMb1lCU2x1aWlmTHhXM25yc2g1SmRDZjc4MnF5U3A4dWRSU3NmYU1CTXo3Z1ZaMDRTUkorWVpybDZJVEFRSGFKcHJ5bEVSc0J1eE5ranpCTlFqRlh6cEVId0tkV01KdXlNVXoiLCJtYWMiOiI4MTUxMTIyYmQ1N2EyY2NmZjQ5ZGVjMjVkODc5ZmRiOTY2ZmQ4NTZhNTViNTA2MjUyMzNiZWYxNzAwYTJjNDU2IiwidGFnIjoiIn0%3D; expires=Sat, 31-May-2025 22:35:29 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IndROHdFWE5SYnQ0VElsWjg0bFFqaEE9PSIsInZhbHVlIjoidDBsZHM1YkZIV3dqQnJVVk43NXpBVTl0MHk4U2RMb1lCU2x1aWlmTHhXM25yc2g1SmRDZjc4MnF5U3A4dWRSU3NmYU1CT ▶"
    1 => "univa_session=eyJpdiI6IjU2QlM1TExzbDljanRVRkRNYnpuN3c9PSIsInZhbHVlIjoiV0ZBUjB5Yk5jeEtNaXRPR3RuVmRBV21YNjBqclQ1cHFzMGtQcG04N0Z3c1lGK2VWeFd2eEJnUDNYT0JwZjlVOUVJbUVKU255eWZPUE9FLzY0N3RlemFUdGRhS2gxdCsvR2tBdWhNWlNXcnBLOG9uMmJUTW96SlU5NGhEVG1Ub3kiLCJtYWMiOiI2ZTNiMWJmM2NlZjY5Nzg2MzgxMjExNTljNmVlYTQ4ZTUyNDU3NjZjZTk0NWViYjcyZDYzZjhjZjE2MzdjMzI4IiwidGFnIjoiIn0%3D; expires=Sat, 31-May-2025 22:35:29 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀univa_session=eyJpdiI6IjU2QlM1TExzbDljanRVRkRNYnpuN3c9PSIsInZhbHVlIjoiV0ZBUjB5Yk5jeEtNaXRPR3RuVmRBV21YNjBqclQ1cHFzMGtQcG04N0Z3c1lGK2VWeFd2eEJnUDNYT0JwZjlVOUVJbU ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IndROHdFWE5SYnQ0VElsWjg0bFFqaEE9PSIsInZhbHVlIjoidDBsZHM1YkZIV3dqQnJVVk43NXpBVTl0MHk4U2RMb1lCU2x1aWlmTHhXM25yc2g1SmRDZjc4MnF5U3A4dWRSU3NmYU1CTXo3Z1ZaMDRTUkorWVpybDZJVEFRSGFKcHJ5bEVSc0J1eE5ranpCTlFqRlh6cEVId0tkV01KdXlNVXoiLCJtYWMiOiI4MTUxMTIyYmQ1N2EyY2NmZjQ5ZGVjMjVkODc5ZmRiOTY2ZmQ4NTZhNTViNTA2MjUyMzNiZWYxNzAwYTJjNDU2IiwidGFnIjoiIn0%3D; expires=Sat, 31-May-2025 22:35:29 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IndROHdFWE5SYnQ0VElsWjg0bFFqaEE9PSIsInZhbHVlIjoidDBsZHM1YkZIV3dqQnJVVk43NXpBVTl0MHk4U2RMb1lCU2x1aWlmTHhXM25yc2g1SmRDZjc4MnF5U3A4dWRSU3NmYU1CT ▶"
    1 => "univa_session=eyJpdiI6IjU2QlM1TExzbDljanRVRkRNYnpuN3c9PSIsInZhbHVlIjoiV0ZBUjB5Yk5jeEtNaXRPR3RuVmRBV21YNjBqclQ1cHFzMGtQcG04N0Z3c1lGK2VWeFd2eEJnUDNYT0JwZjlVOUVJbUVKU255eWZPUE9FLzY0N3RlemFUdGRhS2gxdCsvR2tBdWhNWlNXcnBLOG9uMmJUTW96SlU5NGhEVG1Ub3kiLCJtYWMiOiI2ZTNiMWJmM2NlZjY5Nzg2MzgxMjExNTljNmVlYTQ4ZTUyNDU3NjZjZTk0NWViYjcyZDYzZjhjZjE2MzdjMzI4IiwidGFnIjoiIn0%3D; expires=Sat, 31-May-2025 22:35:29 GMT; path=/; httponly ◀univa_session=eyJpdiI6IjU2QlM1TExzbDljanRVRkRNYnpuN3c9PSIsInZhbHVlIjoiV0ZBUjB5Yk5jeEtNaXRPR3RuVmRBV21YNjBqclQ1cHFzMGtQcG04N0Z3c1lGK2VWeFd2eEJnUDNYT0JwZjlVOUVJbU ▶"
  ]
]

session_attributes

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

1 x Application (81.22%)	80.55ms
1 x Booting (18.66%)	18.51ms

26951 Products Found