Email Us to Know more
marketing@univatech.com
For Technical Support call us at
+65 64931567
1 x Application (62.69%) | 28.51ms |
1 x Booting (37.3%) | 16.96ms |
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
select `item_master`.*, `supplier_items`.`supplier`, `supplier_items`.`datecode`, `supplier_items`.`active`, (SELECT SUM(quantity) FROM supplier_items WHERE supplier_items.item = item_master.id) as quantity, supplier_items.quantity as supplier_items_quantity, (select supplier_master.supplier_category from supplier_category_master join supplier_master on supplier_master.user_id = supplier_items.supplier limit 1) as s_cat, (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 from `item_master` left join `supplier_items` on `supplier_items`.`item` = `item_master`.`id` where `mfr` is not null and `item_master`.`mfr` = '' and `item_master`.`active` = 1 and `part_number` like 'rc0603' group by `supplier_items`.`supplier`, `supplier_items`.`datecode`
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `item_master`.*, (SELECT SUM(quantity) FROM supplier_items WHERE supplier_items.item = item_master.id) as quantity, SUM(supplier_items.quantity) as supplier_items_quantity, (select item_category_master.name from item_category_master where item_category_master.id = item_master.item_category order by id desc limit 1) as cat_name, (select item_category_master.name from item_category_master where item_category_master.id = item_master.item_subcategory order by id desc limit 1) as subcat_name, (select item_category_master.name from item_category_master where item_category_master.id = item_master.item_subcategory1 order by id desc limit 1) as subcat_two_name, (select manufacturer_master.name from manufacturer_master where manufacturer_master.id = item_master.mfr order by id desc limit 1) as mfr_name, (select manufacturer_master.image_name from manufacturer_master where manufacturer_master.id = item_master.mfr order by id desc limit 1) as mfr_image_name, (select manufacturer_master.image from manufacturer_master where manufacturer_master.id = item_master.mfr order by id desc limit 1) as mfr_image from `item_master` left join `supplier_items` on `supplier_items`.`item` = `item_master`.`id` where `mfr` is not null and `item_master`.`mfr` = '' and `item_master`.`active` = 1 and `part_number` like 'rc0603' order by `id` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
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
Metadata | |
---|---|
Backtrace |
|
select * from `country`
Metadata | |
---|---|
Backtrace |
|
select * from `country`
Metadata | |
---|---|
Backtrace |
|
200
[]
[]
0 of 0array: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" ] ]
0 of 0array:48 [▼ "REDIRECT_SCRIPT_URL" => "/product-search/8734/rc0603" "REDIRECT_SCRIPT_URI" => "https://staging.univatech.com/product-search/8734/rc0603" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI" => "staging.univatech.com" "REDIRECT_STATUS" => "200" "SCRIPT_URL" => "/product-search/8734/rc0603" "SCRIPT_URI" => "https://staging.univatech.com/product-search/8734/rc0603" "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.243" "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" => "9569" "REDIRECT_URL" => "/product-search/8734/rc0603" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/product-search/8734/rc0603" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1752976413.4775 "REQUEST_TIME" => 1752976413 ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Sun, 20 Jul 2025 01:53:33 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkhKZmZpQVFLc3F5RHg0T0I5L2FtMWc9PSIsInZhbHVlIjoiUDZhVXRxQXV2YWhIdVBlTlN1Z3RUam1jU2N4UldSVFV3NEk1WmkySHBxTnkvTForMkJtQ0hhZ0I5ZnVncWRRZWtLWU1nZy9Ua3Jkek1MaWJGN0QyUEtwdEgxdUxOVjZEOVlwSFB2cjQxSkpJUzA3T1NKdWlZeXlCeHJ1NHlsMnMiLCJtYWMiOiI4OTIyYjljNzI5NjZhMmVmNzBhNzEwMzQwMzEyNGUzMDM0Yzg0M2Q1ZWExY2QyODk1ZjNkNjFhNzc5ZTFhYTQ2IiwidGFnIjoiIn0%3D; expires=Sun, 20-Jul-2025 03:53:33 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkhKZmZpQVFLc3F5RHg0T0I5L2FtMWc9PSIsInZhbHVlIjoiUDZhVXRxQXV2YWhIdVBlTlN1Z3RUam1jU2N4UldSVFV3NEk1WmkySHBxTnkvTForMkJtQ0hhZ0I5ZnVncWRRZWtLWU1nZ ▶" 1 => "univa_session=eyJpdiI6IkJjZGkyZk0wYlFMNFBRbzV6c1NXYXc9PSIsInZhbHVlIjoiaWF1aXlkYXJSMk1zb3hZamFHZ3A5Tnk1b0tKTnRFeGwyeDdXWlNGaVNDU2tKU0JuSzJjMGYxOGN4Q3gwcGxoL0JaMm5wRE5LM3lmdncvTW16aS9uNExKc1ppMDY4ZU90bDh6cFBIbE1XMStzNDI4a0g1VFRuMzM5c2o5dThtZmkiLCJtYWMiOiJiNTI2Y2NlMDI1NjI3ZjJjMzBmZWE5N2RiODU0Y2RmMDRkZGI0ZjAyMjlkNWNjYWU0ZmMwNjFiZWFjZTMwMWQzIiwidGFnIjoiIn0%3D; expires=Sun, 20-Jul-2025 03:53:33 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀univa_session=eyJpdiI6IkJjZGkyZk0wYlFMNFBRbzV6c1NXYXc9PSIsInZhbHVlIjoiaWF1aXlkYXJSMk1zb3hZamFHZ3A5Tnk1b0tKTnRFeGwyeDdXWlNGaVNDU2tKU0JuSzJjMGYxOGN4Q3gwcGxoL0JaMm ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkhKZmZpQVFLc3F5RHg0T0I5L2FtMWc9PSIsInZhbHVlIjoiUDZhVXRxQXV2YWhIdVBlTlN1Z3RUam1jU2N4UldSVFV3NEk1WmkySHBxTnkvTForMkJtQ0hhZ0I5ZnVncWRRZWtLWU1nZy9Ua3Jkek1MaWJGN0QyUEtwdEgxdUxOVjZEOVlwSFB2cjQxSkpJUzA3T1NKdWlZeXlCeHJ1NHlsMnMiLCJtYWMiOiI4OTIyYjljNzI5NjZhMmVmNzBhNzEwMzQwMzEyNGUzMDM0Yzg0M2Q1ZWExY2QyODk1ZjNkNjFhNzc5ZTFhYTQ2IiwidGFnIjoiIn0%3D; expires=Sun, 20-Jul-2025 03:53:33 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkhKZmZpQVFLc3F5RHg0T0I5L2FtMWc9PSIsInZhbHVlIjoiUDZhVXRxQXV2YWhIdVBlTlN1Z3RUam1jU2N4UldSVFV3NEk1WmkySHBxTnkvTForMkJtQ0hhZ0I5ZnVncWRRZWtLWU1nZ ▶" 1 => "univa_session=eyJpdiI6IkJjZGkyZk0wYlFMNFBRbzV6c1NXYXc9PSIsInZhbHVlIjoiaWF1aXlkYXJSMk1zb3hZamFHZ3A5Tnk1b0tKTnRFeGwyeDdXWlNGaVNDU2tKU0JuSzJjMGYxOGN4Q3gwcGxoL0JaMm5wRE5LM3lmdncvTW16aS9uNExKc1ppMDY4ZU90bDh6cFBIbE1XMStzNDI4a0g1VFRuMzM5c2o5dThtZmkiLCJtYWMiOiJiNTI2Y2NlMDI1NjI3ZjJjMzBmZWE5N2RiODU0Y2RmMDRkZGI0ZjAyMjlkNWNjYWU0ZmMwNjFiZWFjZTMwMWQzIiwidGFnIjoiIn0%3D; expires=Sun, 20-Jul-2025 03:53:33 GMT; path=/; httponly ◀univa_session=eyJpdiI6IkJjZGkyZk0wYlFMNFBRbzV6c1NXYXc9PSIsInZhbHVlIjoiaWF1aXlkYXJSMk1zb3hZamFHZ3A5Tnk1b0tKTnRFeGwyeDdXWlNGaVNDU2tKU0JuSzJjMGYxOGN4Q3gwcGxoL0JaMm ▶" ] ]
0 of 0array:4 [▼ "_token" => "4VRQSMToAgjp6egG0SDw6Lwb16EXYTaOBVieBla8" "_previous" => array:1 [▶ "url" => "https://staging.univatech.com/product-search/8734/rc0603" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]