Order from

Part Number	MFR	Qty	Actions
DCP4R242006FD2MSSD	WIMA	640	View Details
SSD-550-102	BIVR	4000	View Details
E-750	BIVR	4500	View Details
3BC-3-CA-F	BIVR	5000	View Details
SMFLP	BIVR	1000	View Details
CP-86 WE	BIVR	2800	View Details
908-335 BE	BIVR	6000	View Details
908-315	BIVR	23000	View Details
939-375	BIVR	40000	View Details
906-6MM	BIVR	1000	View Details
903-120	BIVR	4000	View Details
903-030	BIVR	1000	View Details
902-030	BIVR	5000	View Details
939-250	BIVR	5000	View Details
905-080	BIVR	8000	View Details
938-060	BIVR	30000	View Details
SM2-SGC-20	BIVR	3000	View Details
ELM 2-895	BIVR	5000	View Details
ELM 1-895	BIVR	1000	View Details
ELM 4-5MM	BIVR	500	View Details
ELM 2-385	BIVR	1000	View Details
ELM 3-450	BIVR	300	View Details
ELM 1-210	BIVR	2000	View Details
ELM 3-310	BIVR	1000	View Details
ELM 2-700	BIVR	13000	View Details
ELM 1-20MM	BIVR	5000	View Details
ELM 3-320	BIVR	5000	View Details
LP-06 WE	BIVR	1500	View Details
303-250	BIVR	5000	View Details
VLP-400-R	BIVR	1500	View Details
8100-4030	Sumitomo	19300	View Details
8100-4027	Sumitomo	350	View Details
8100-3459	Sumitomo	500	View Details
8100-3455	Sumitomo	13296	View Details
7165-1647	Sumitomo	4895	View Details
7165-1565	Sumitomo	15	View Details
7165-0797	Sumitomo	20	View Details
7116-2641	Sumitomo	12	View Details
7114-2251	Sumitomo	6	View Details
6810-6152	Sumitomo	4800	View Details
6189-7065	Sumitomo	40	View Details
6189-1231	Sumitomo	19	View Details
6189-0249	Sumitomo	60	View Details
6098-5310	Sumitomo	300	View Details
6098-5271	Sumitomo	70	View Details
6098-5269	Sumitomo	69	View Details
6098-5267	Sumitomo	300	View Details
6098-4944	Sumitomo	350	View Details
CL-HVC80024A-50	Smart green	4	View Details
CL-HVC80021A-S	Smart green	4	View Details

Messages Timeline Exceptions Views5 Route Queries5 Models550 Mails Gate Session Request

8.1.293.47ms4MBGET products/{part_number?}

Booting (14.62ms)
Application (78.85ms)
1 x Application (84.35%)
78.85ms
1 x Booting (15.64%)
14.62ms

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 unique48.92ms

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

13.39ms/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 20300

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

6.4ms/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.61ms/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.56ms/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: rlJgZxvqP5koiNZmkYpTTGJR0zcoKEk48Jcsic1x
_previous: array:1 [ "url" => "https://staging.univatech.com/products?page=407" ]
_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" => "407"
]

request_request

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

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.44"
  "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" => "56570"
  "REDIRECT_URL" => "/products"
  "REDIRECT_QUERY_STRING" => "page=407"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "page=407"
  "REQUEST_URI" => "/products?page=407"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1753483259.3921
  "REQUEST_TIME" => 1753483259
]

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 => "Fri, 25 Jul 2025 22:40:59 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Imt1c0Q3ZzB5c0NUREE2Y1dBY3hkb1E9PSIsInZhbHVlIjoiQUl1R2U4dGdvK216VTdwWTRTWHUvWHlqbTVLVFFheFNXZnJQY04xTGF2L25KOUpXNUZiZmNpd1ZlMFNvUVZUTmhUNWpMUGdLbUt5KzVMc0J6L3BjdUV3amdsL0NLeU5DWE8zaXFKQnZFMUZpR0VUQnU3OEc3aW1jVFpiZE0wOUUiLCJtYWMiOiI5Y2EwNmY5MTdiYjM2NDhjY2IzZDIwMjI4NDc3OTZjZGI3MjA5NTZmM2FjMDkwZTYwOGM1ZjE0ZGYxMGQ2ZjRjIiwidGFnIjoiIn0%3D; expires=Sat, 26-Jul-2025 00:40:59 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Imt1c0Q3ZzB5c0NUREE2Y1dBY3hkb1E9PSIsInZhbHVlIjoiQUl1R2U4dGdvK216VTdwWTRTWHUvWHlqbTVLVFFheFNXZnJQY04xTGF2L25KOUpXNUZiZmNpd1ZlMFNvUVZUTmhUNWpMU ▶"
    1 => "univa_session=eyJpdiI6IkZMRzlpVnBSV2JaQ2svRENkSmFIY3c9PSIsInZhbHVlIjoiZHY2RVdyb1lzc2NxcWZHRjZ2bHZDM09MUVV4ZEFCQm9GS2h0UW0xRWVEN1VLNXAwc1orR2ZQaHhqTEtGU25Way9jZytwek02TmNKU1FZK0tDQnlqYU1BQ1hHRVBkVy9WSVQyTmw2OXdJaHpmeUVReEZIdmIrTkIzdG1tSGdEbFEiLCJtYWMiOiI3ZjNlMjJkNmI1NjViN2ZlODI0MGQ5Y2M3NDBkNDEwYjUzMjZjMDE3ZjE4ZDAzZGI0Mjg5NWY4YmVlOGI3M2E1IiwidGFnIjoiIn0%3D; expires=Sat, 26-Jul-2025 00:40:59 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀univa_session=eyJpdiI6IkZMRzlpVnBSV2JaQ2svRENkSmFIY3c9PSIsInZhbHVlIjoiZHY2RVdyb1lzc2NxcWZHRjZ2bHZDM09MUVV4ZEFCQm9GS2h0UW0xRWVEN1VLNXAwc1orR2ZQaHhqTEtGU25Way9jZy ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Imt1c0Q3ZzB5c0NUREE2Y1dBY3hkb1E9PSIsInZhbHVlIjoiQUl1R2U4dGdvK216VTdwWTRTWHUvWHlqbTVLVFFheFNXZnJQY04xTGF2L25KOUpXNUZiZmNpd1ZlMFNvUVZUTmhUNWpMUGdLbUt5KzVMc0J6L3BjdUV3amdsL0NLeU5DWE8zaXFKQnZFMUZpR0VUQnU3OEc3aW1jVFpiZE0wOUUiLCJtYWMiOiI5Y2EwNmY5MTdiYjM2NDhjY2IzZDIwMjI4NDc3OTZjZGI3MjA5NTZmM2FjMDkwZTYwOGM1ZjE0ZGYxMGQ2ZjRjIiwidGFnIjoiIn0%3D; expires=Sat, 26-Jul-2025 00:40:59 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Imt1c0Q3ZzB5c0NUREE2Y1dBY3hkb1E9PSIsInZhbHVlIjoiQUl1R2U4dGdvK216VTdwWTRTWHUvWHlqbTVLVFFheFNXZnJQY04xTGF2L25KOUpXNUZiZmNpd1ZlMFNvUVZUTmhUNWpMU ▶"
    1 => "univa_session=eyJpdiI6IkZMRzlpVnBSV2JaQ2svRENkSmFIY3c9PSIsInZhbHVlIjoiZHY2RVdyb1lzc2NxcWZHRjZ2bHZDM09MUVV4ZEFCQm9GS2h0UW0xRWVEN1VLNXAwc1orR2ZQaHhqTEtGU25Way9jZytwek02TmNKU1FZK0tDQnlqYU1BQ1hHRVBkVy9WSVQyTmw2OXdJaHpmeUVReEZIdmIrTkIzdG1tSGdEbFEiLCJtYWMiOiI3ZjNlMjJkNmI1NjViN2ZlODI0MGQ5Y2M3NDBkNDEwYjUzMjZjMDE3ZjE4ZDAzZGI0Mjg5NWY4YmVlOGI3M2E1IiwidGFnIjoiIn0%3D; expires=Sat, 26-Jul-2025 00:40:59 GMT; path=/; httponly ◀univa_session=eyJpdiI6IkZMRzlpVnBSV2JaQ2svRENkSmFIY3c9PSIsInZhbHVlIjoiZHY2RVdyb1lzc2NxcWZHRjZ2bHZDM09MUVV4ZEFCQm9GS2h0UW0xRWVEN1VLNXAwc1orR2ZQaHhqTEtGU25Way9jZy ▶"
  ]
]

session_attributes

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

1 x Application (84.35%)	78.85ms
1 x Booting (15.64%)	14.62ms

26951 Products Found