Order from

Part Number	MFR	Qty	Actions
RK73H1JTTD3302D	KOA	5000	View Details
RK73H1JTTD3301F	KOA	10000	View Details
RK73H1JTTD1001F	KOA	10000	View Details
SG73P2BTTD62R0F	KOA	5300	View Details
SG73P1JTTD3901F	KOA	600	View Details
SG73G2BTTD3301C	KOA	400	View Details
SG73G2BTTD2201C	KOA	400	View Details
WK73R3ATTE1502F	KOA	4600	View Details
RK73H1JTTD3002F	KOA	5000	View Details
RK73H1JTTD3001F	KOA	5000	View Details
RK73H1JTTD2702D	KOA	5000	View Details
RK73H1JTTD1102D	KOA	10000	View Details
RK73H1JTTD10R0F	KOA	5000	View Details
RK73H1JTTD1004D	KOA	5000	View Details
LGU2C222MELC	NICHICON	400	View Details
CL05C101JB51PNC	SAMSUNG	10000	View Details
CL10B682KB8WPNC	SAMSUNG	4000	View Details
CL10B332KB8WPNC	SAMSUNG	4000	View Details
CL31B475KBHVPNE	SAMSUNG	6000	View Details
CL31B106KOHVPNE	SAMSUNG	2000	View Details
CL10C101JB81PNC	SAMSUNG	4000	View Details
CL31B475KAHVPNE	SAMSUNG	2000	View Details
CL10B103KC8WPNC	SAMSUNG	4000	View Details
CL21B225KAFVPNE	SAMSUNG	2000	View Details
CL21B105KAFVPNE	SAMSUNG	2000	View Details
CL21B224KBFVPNE	SAMSUNG	2000	View Details
CL05C100JB51PNC	SAMSUNG	10000	View Details
CL05B472KB5VPNC	SAMSUNG	10000	View Details
CL05B104KO5VPNC	SAMSUNG	10000	View Details
CL10C102JB81PNC	SAMSUNG	4000	View Details
967067-2	TE/AMP	100000	View Details
85202-1	TE/AMP	4500	View Details
206306-1	TE/AMP	1600	View Details
206037-1	TE/AMP	5402	View Details
282106-1	TE/AMP	131	View Details
102241-1	TE/AMP	15000	View Details
521204-1	TE/AMP	6500	View Details
104257-4	TE/AMP	5000	View Details
3-350819-2	TE/AMP	36000	View Details
3-521057-2	TE/AMP	1400	View Details
87523-6	TE/AMP	80	View Details
828904-1	TE/AMP	23010	View Details
41729	TE/AMP	4000	View Details
350779-1	TE/AMP	14000	View Details
350778-1	TE/AMP	121655	View Details
282104-1	TE/AMP	2500	View Details
211772-1	TE/AMP	200	View Details
1-1123722-0	TE/AMP	12800	View Details
171830-1	TE/AMP	500	View Details
173645-2	TE/AMP	21000	View Details

Messages Timeline Exceptions Views5 Route Queries5 Models550 Mails Gate Session Request

8.1.266.96ms4MBGET products/{part_number?}

Booting (13.75ms)
Application (53.16ms)
1 x Application (79.39%)
53.16ms
1 x Booting (20.54%)
13.75ms

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 unique29.09ms

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

13.02ms/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 4150

6.49ms/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.63ms/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`

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

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

request_request

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

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.138.151.162"
  "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" => "50196"
  "REDIRECT_URL" => "/products"
  "REDIRECT_QUERY_STRING" => "page=84"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "page=84"
  "REQUEST_URI" => "/products?page=84"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1748152518.3994
  "REQUEST_TIME" => 1748152518
]

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, 25 May 2025 05:55:18 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InNSck40Tzd4OUFpQUxydVBSV1h1OEE9PSIsInZhbHVlIjoiOGFOUTNWQnFKUnZoSk9tS2p2V1hpY01GclpVK0R2Smp2WFlhSmNhQmtnTW83QWU3aHF6czNBWFlyVFgrT3FrRk5TaEFLV3VVVlc5SU1teDJVTGRPS0kyOEhnNGdLUUlWNURob2IvRWRlN2MxKzJrRi8vNTFqV1BVMkxuZ01XaS8iLCJtYWMiOiIyNjE2MzQ3ZTBmZDRiZmI0MjFkOWFmOTVkY2ZmNDgwYWVjMjhlMmE3MGFmNzE3M2E0Zjk2Y2QwMTdlNTI3NGQ2IiwidGFnIjoiIn0%3D; expires=Sun, 25-May-2025 07:55:18 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InNSck40Tzd4OUFpQUxydVBSV1h1OEE9PSIsInZhbHVlIjoiOGFOUTNWQnFKUnZoSk9tS2p2V1hpY01GclpVK0R2Smp2WFlhSmNhQmtnTW83QWU3aHF6czNBWFlyVFgrT3FrRk5TaEFLV ▶"
    1 => "univa_session=eyJpdiI6IlVTTzBhdm5tbWp3NUNKblBzUHN5ZFE9PSIsInZhbHVlIjoieWdCdk9LcnNEWkZoYkVaTEwxemRwYVkvVlFzbkVVTFBpZlo5MkpEcmZSYWI5MDV6VjczNjcrVnZGNHAzbWdud3Z5NmJ4VFNFUHpJWitPc05VcllpMTlTOHFFaGtnS241VHYzY2M1QWNBaVVzck5PN0psNlFkTnNxYXkxdGFPckwiLCJtYWMiOiJjNDA2YzY2ODZhNDZmZWQ2ZWE2ZWU2ZmM2ODU5NzVjNzY0MzAwNDBlYjgwMWRiMjQ1NWM2MWVkZmQ4ZWQ3OTllIiwidGFnIjoiIn0%3D; expires=Sun, 25-May-2025 07:55:18 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀univa_session=eyJpdiI6IlVTTzBhdm5tbWp3NUNKblBzUHN5ZFE9PSIsInZhbHVlIjoieWdCdk9LcnNEWkZoYkVaTEwxemRwYVkvVlFzbkVVTFBpZlo5MkpEcmZSYWI5MDV6VjczNjcrVnZGNHAzbWdud3Z5Nm ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InNSck40Tzd4OUFpQUxydVBSV1h1OEE9PSIsInZhbHVlIjoiOGFOUTNWQnFKUnZoSk9tS2p2V1hpY01GclpVK0R2Smp2WFlhSmNhQmtnTW83QWU3aHF6czNBWFlyVFgrT3FrRk5TaEFLV3VVVlc5SU1teDJVTGRPS0kyOEhnNGdLUUlWNURob2IvRWRlN2MxKzJrRi8vNTFqV1BVMkxuZ01XaS8iLCJtYWMiOiIyNjE2MzQ3ZTBmZDRiZmI0MjFkOWFmOTVkY2ZmNDgwYWVjMjhlMmE3MGFmNzE3M2E0Zjk2Y2QwMTdlNTI3NGQ2IiwidGFnIjoiIn0%3D; expires=Sun, 25-May-2025 07:55:18 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InNSck40Tzd4OUFpQUxydVBSV1h1OEE9PSIsInZhbHVlIjoiOGFOUTNWQnFKUnZoSk9tS2p2V1hpY01GclpVK0R2Smp2WFlhSmNhQmtnTW83QWU3aHF6czNBWFlyVFgrT3FrRk5TaEFLV ▶"
    1 => "univa_session=eyJpdiI6IlVTTzBhdm5tbWp3NUNKblBzUHN5ZFE9PSIsInZhbHVlIjoieWdCdk9LcnNEWkZoYkVaTEwxemRwYVkvVlFzbkVVTFBpZlo5MkpEcmZSYWI5MDV6VjczNjcrVnZGNHAzbWdud3Z5NmJ4VFNFUHpJWitPc05VcllpMTlTOHFFaGtnS241VHYzY2M1QWNBaVVzck5PN0psNlFkTnNxYXkxdGFPckwiLCJtYWMiOiJjNDA2YzY2ODZhNDZmZWQ2ZWE2ZWU2ZmM2ODU5NzVjNzY0MzAwNDBlYjgwMWRiMjQ1NWM2MWVkZmQ4ZWQ3OTllIiwidGFnIjoiIn0%3D; expires=Sun, 25-May-2025 07:55:18 GMT; path=/; httponly ◀univa_session=eyJpdiI6IlVTTzBhdm5tbWp3NUNKblBzUHN5ZFE9PSIsInZhbHVlIjoieWdCdk9LcnNEWkZoYkVaTEwxemRwYVkvVlFzbkVVTFBpZlo5MkpEcmZSYWI5MDV6VjczNjcrVnZGNHAzbWdud3Z5Nm ▶"
  ]
]

session_attributes

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

1 x Application (79.39%)	53.16ms
1 x Booting (20.54%)	13.75ms

26951 Products Found