Order from

Part Number	MFR	Qty	Actions
2-1718644-1	TE	80	View Details
2-1718324-1	TE	20	View Details
2-1703639-1	TE	10	View Details
2169806-1	TE	1183	View Details
2169797-1	TE	200	View Details
2-1649329-2	TE	20	View Details
2-1630186-5（HSA5060R）	TE	5	View Details
2-1622824-0(RL73H2BR33FTD)	TE	10000	View Details
2159460-1	TE	85	View Details
2-1586041-0	TE	2400	View Details
2-1586019-0	TE	30	View Details
2-1563759-1	TE	60	View Details
2154829-2	TE	3200	View Details
2154829-1	TE	3000	View Details
215083-4	TE	37500	View Details
2149490-6	TE	13	View Details
2-1473562-4	TE	6195	View Details
2-1440002-9（OZ-SS-124LM1,200）	TE	150	View Details
2-1440002-8(OZ-SS-124L,200)	TE	4	View Details
2-1437285-2	TE	7	View Details
214357-E	TE	4	View Details
2-1418479-1	TE	5	View Details
2141784-2	TE	27	View Details
2141783-2	TE	42	View Details
2141212-1	TE	6	View Details
2141211-2	TE	16	View Details
2141156-2	TE	6	View Details
2141155-2	TE	5	View Details
2138558-1	TE	9001	View Details
2-1318116-3	TE	100	View Details
2-1318114-9	TE	4286	View Details
2-1318114-3	TE	909	View Details
2129567-1	TE	10	View Details
211401-1	TE	649	View Details
2110989-1	TE	64050	View Details
2108610-5	TE	120	View Details
2106646-1	TE	2400	View Details
2106489-3	TE	211	View Details
2106431-2	TE	48	View Details
2106136-4	TE	2500	View Details
2106091-4	TE	4	View Details
2106091-3	TE	250	View Details
2106091-1	TE	9	View Details
2103414-1	TE	4	View Details
2103181-3	TE	5	View Details
2103168-2	TE	10	View Details
2103157-1	TE	42	View Details
2103155-1	TE	57	View Details
2103124-2	TE	42	View Details
2098978-1	TE	10	View Details

Messages Timeline Exceptions Views5 Route Queries5 Models550 Mails Gate Session Request

8.1.298.03ms4MBGET products/{part_number?}

Booting (21.55ms)
Application (76.47ms)
1 x Application (78.01%)
76.47ms
1 x Booting (21.99%)
21.55ms

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 unique50.88ms

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

13.24ms/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 21300

27.24ms/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

6ms/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.29ms/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.11ms/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: hfUoFTeiAyghcrAzmkSvLQVniHDNMnJUbyQCs9WY
_previous: array:1 [ "url" => "https://staging.univatech.com/products?page=427" ]
_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" => "427"
]

request_request

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

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.205"
  "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" => "3566"
  "REDIRECT_URL" => "/products"
  "REDIRECT_QUERY_STRING" => "page=427"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "page=427"
  "REQUEST_URI" => "/products?page=427"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1753342480.9762
  "REQUEST_TIME" => 1753342480
]

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 => "Thu, 24 Jul 2025 07:34:41 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImJFakFwMFd0aHdtQ0puMFdTU0c1WXc9PSIsInZhbHVlIjoiVUxFQjlZMHhqSndGMkQ4ZHJXcXlkRjBodkZGSHNNeEV3bWxCUFpsWTFMK3MwK1ZyRm5wWklvSW51ZkZvTXJoL3NjRHN6UUJpM2FOOE1XMG5DdXRjR0NEVXRzTXU1Z2tRbC8yTDJaYm1oZ3psWDg2WENkNzBtWCtDejNkelNqa0IiLCJtYWMiOiI3NWNlNzYwNTM1MDU2MzUwYzlkMjBlZWRiYjE4NDRhMzVjM2U5NGJlOTM5MDQxZmVmMjU2ZTVjZGFlMGEyZTNmIiwidGFnIjoiIn0%3D; expires=Thu, 24-Jul-2025 09:34:41 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImJFakFwMFd0aHdtQ0puMFdTU0c1WXc9PSIsInZhbHVlIjoiVUxFQjlZMHhqSndGMkQ4ZHJXcXlkRjBodkZGSHNNeEV3bWxCUFpsWTFMK3MwK1ZyRm5wWklvSW51ZkZvTXJoL3NjRHN6U ▶"
    1 => "univa_session=eyJpdiI6Ii8vRnJJTmtnT2dkK0lHNnhLZXcrdXc9PSIsInZhbHVlIjoiNk15K21xYlh1Q1B0ZEJESXM3R0FtQ28rcGlGbnhMVWxMRjdma3hzRTN6d2ZxWFJ5RlJ3Mm5IYVJad1VlWkZSc2ljR3JJdWpCVXVuaHRQYmMwL3ltalpkemZzMXNBV043Qzd5dTVUWjBCNkZFbUlNUGlGRVd6TldHVndtRUlWK2ciLCJtYWMiOiJkYWIyZDIzNTY3MjBjMTQ5NWI1NmNmNTkwZmUyZmM2MTY0ZjlhN2JkNTM0YzRhNmFmYTE0NWI0MzJjM2MwMGZiIiwidGFnIjoiIn0%3D; expires=Thu, 24-Jul-2025 09:34:41 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀univa_session=eyJpdiI6Ii8vRnJJTmtnT2dkK0lHNnhLZXcrdXc9PSIsInZhbHVlIjoiNk15K21xYlh1Q1B0ZEJESXM3R0FtQ28rcGlGbnhMVWxMRjdma3hzRTN6d2ZxWFJ5RlJ3Mm5IYVJad1VlWkZSc2ljR3 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImJFakFwMFd0aHdtQ0puMFdTU0c1WXc9PSIsInZhbHVlIjoiVUxFQjlZMHhqSndGMkQ4ZHJXcXlkRjBodkZGSHNNeEV3bWxCUFpsWTFMK3MwK1ZyRm5wWklvSW51ZkZvTXJoL3NjRHN6UUJpM2FOOE1XMG5DdXRjR0NEVXRzTXU1Z2tRbC8yTDJaYm1oZ3psWDg2WENkNzBtWCtDejNkelNqa0IiLCJtYWMiOiI3NWNlNzYwNTM1MDU2MzUwYzlkMjBlZWRiYjE4NDRhMzVjM2U5NGJlOTM5MDQxZmVmMjU2ZTVjZGFlMGEyZTNmIiwidGFnIjoiIn0%3D; expires=Thu, 24-Jul-2025 09:34:41 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImJFakFwMFd0aHdtQ0puMFdTU0c1WXc9PSIsInZhbHVlIjoiVUxFQjlZMHhqSndGMkQ4ZHJXcXlkRjBodkZGSHNNeEV3bWxCUFpsWTFMK3MwK1ZyRm5wWklvSW51ZkZvTXJoL3NjRHN6U ▶"
    1 => "univa_session=eyJpdiI6Ii8vRnJJTmtnT2dkK0lHNnhLZXcrdXc9PSIsInZhbHVlIjoiNk15K21xYlh1Q1B0ZEJESXM3R0FtQ28rcGlGbnhMVWxMRjdma3hzRTN6d2ZxWFJ5RlJ3Mm5IYVJad1VlWkZSc2ljR3JJdWpCVXVuaHRQYmMwL3ltalpkemZzMXNBV043Qzd5dTVUWjBCNkZFbUlNUGlGRVd6TldHVndtRUlWK2ciLCJtYWMiOiJkYWIyZDIzNTY3MjBjMTQ5NWI1NmNmNTkwZmUyZmM2MTY0ZjlhN2JkNTM0YzRhNmFmYTE0NWI0MzJjM2MwMGZiIiwidGFnIjoiIn0%3D; expires=Thu, 24-Jul-2025 09:34:41 GMT; path=/; httponly ◀univa_session=eyJpdiI6Ii8vRnJJTmtnT2dkK0lHNnhLZXcrdXc9PSIsInZhbHVlIjoiNk15K21xYlh1Q1B0ZEJESXM3R0FtQ28rcGlGbnhMVWxMRjdma3hzRTN6d2ZxWFJ5RlJ3Mm5IYVJad1VlWkZSc2ljR3 ▶"
  ]
]

session_attributes

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

1 x Application (78.01%)	76.47ms
1 x Booting (21.99%)	21.55ms

26951 Products Found