Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SELECT COUNT(*) AS `count` FROM `sato_agri`.`sys_products` AS `SysProduct` WHERE `SysProduct`.`sys_product_cd` = '30100' | 1 | 1 | 0 | |
2 | SELECT `SysProduct`.`sys_product_cd`, `SysProduct`.`sys_product_nm`, `SysProduct`.`sys_product_fk`, `SysProduct`.`classify_cd`, `SysProduct`.`use_start_day`, `SysProduct`.`use_end_day`, `SysProduct`.`del_flg`, `SysProduct`.`created`, `SysProduct`.`insert_user`, `SysProduct`.`modified`, `SysProduct`.`update_user`, `SysProdctClassify`.`classify_cd`, `SysProdctClassify`.`classify_nm`, `SysProdctClassify`.`classify_fk`, `SysProdctClassify`.`amount_not_sel_flg`, `SysProdctClassify`.`brc_not_print_flg`, `SysProdctClassify`.`del_flg`, `SysProdctClassify`.`created`, `SysProdctClassify`.`insert_user`, `SysProdctClassify`.`modified`, `SysProdctClassify`.`update_user` FROM `sato_agri`.`sys_products` AS `SysProduct` LEFT JOIN `sato_agri`.`sys_prodct_classify` AS `SysProdctClassify` ON (`SysProduct`.`classify_cd` = `SysProdctClassify`.`classify_cd`) WHERE `SysProduct`.`sys_product_cd` = '30100' LIMIT 1 | 1 | 1 | 0 | |
3 | SELECT `FarmerProduct`.`id`, `FarmerProduct`.`farmer_id`, `FarmerProduct`.`trader_id`, `FarmerProduct`.`cmp_product_id`, `FarmerProduct`.`company_cd`, `FarmerProduct`.`co_product_cd`, `FarmerProduct`.`sys_product_cd`, `FarmerProduct`.`display_product_nm`, `FarmerProduct`.`display_product_fk`, `FarmerProduct`.`display_locality`, `FarmerProduct`.`farmer_edit_status`, `FarmerProduct`.`brc_shipment_product_characters`, `FarmerProduct`.`brc_shipment_product_cd`, `FarmerProduct`.`brc_price_cd`, `FarmerProduct`.`brc_price_characters`, `FarmerProduct`.`company_shipment_cd`, `FarmerProduct`.`brc_type_flag`, `FarmerProduct`.`brc_mid_flag`, `FarmerProduct`.`val_pos_pattern`, `FarmerProduct`.`mid_checkdigit_flag`, `FarmerProduct`.`shipment_start_month`, `FarmerProduct`.`shipment_end_month`, `FarmerProduct`.`use_start_day`, `FarmerProduct`.`use_end_day`, `FarmerProduct`.`del_flg`, `FarmerProduct`.`created`, `FarmerProduct`.`insert_user`, `FarmerProduct`.`modified`, `FarmerProduct`.`update_user` FROM `sato_agri`.`farmer_products` AS `FarmerProduct` WHERE `FarmerProduct`.`sys_product_cd` = ('30100') | 5407 | 5407 | 324 |
No querystring data.
To view Cookies, add CookieComponent to Controller
Peak Memory Use 161.29 MB
Message | Memory use |
---|---|
Component initialization | 3.56 MB |
Controller action start | 3.79 MB |
Controller render start | 35.76 MB |
View render complete | 37.49 MB |
Total Request Time: 1936 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 19.92 | |
Event: Controller.initialize | 0.03 | |
Event: Controller.startup | 0.21 | |
Controller action | 432.35 | |
Event: Controller.beforeRender | 243.38 | |
» Processing toolbar data | 243.26 | |
Rendering View | 9.32 | |
» Event: View.beforeRender | 0.03 | |
» Rendering APP/View/SysProducts/edit.ctp | 7.75 | |
» Event: View.afterRender | 0.02 | |
» Event: View.beforeLayout | 0.02 | |
» Rendering APP/View/Layouts/default.ctp | 0.83 | |
» » Rendering CORE/Cake/View/Elements/sql_dump.ctp | 0.21 | |
Event: View.afterLayout | 0.00 |
Constant | Value |
---|---|
BACKUP_DIR | /var/www/release/hounotori/app/tmp/backup |
IMPORT_DIR | /var/www/webdav/mab |
Constant | Value |
---|---|
APP | /var/www/release/hounotori/app/ |
APP_DIR | app |
APPLIBS | /var/www/release/hounotori/app/Lib/ |
CACHE | /var/www/release/hounotori/app/tmp/cache/ |
CAKE | /var/www/release/hounotori/lib/Cake/ |
CAKE_CORE_INCLUDE_PATH | /var/www/release/hounotori/lib |
CORE_PATH | /var/www/release/hounotori/lib/ |
CAKE_VERSION | 2.8.5 |
CSS | /var/www/release/hounotori/app/webroot/css/ |
CSS_URL | css/ |
DS | / |
FULL_BASE_URL | http://202.222.80.41 |
IMAGES | /var/www/release/hounotori/app/webroot/img/ |
IMAGES_URL | img/ |
JS | /var/www/release/hounotori/app/webroot/js/ |
JS_URL | js/ |
LOGS | /var/www/release/hounotori/app/tmp/logs/ |
ROOT | /var/www/release/hounotori |
TESTS | /var/www/release/hounotori/app/Test/ |
TMP | /var/www/release/hounotori/app/tmp/ |
VENDORS | /var/www/release/hounotori/vendors/ |
WEBROOT_DIR | webroot |
WWW_ROOT | /var/www/release/hounotori/app/webroot/ |
Environment Variable | Value |
---|---|
Php Version | 5.6.40 |
User | apache |
Home | /usr/share/httpd |
Fcgi Role | RESPONDER |
Redirect Redirect Unique Id | aA1La56hE@HsJDkIK848gQAAAdM |
Redirect Redirect Kounotori Deploy Env | stg |
Redirect Redirect Status | 200 |
Redirect Unique Id | aA1La56hE@HsJDkIK848gQAAAdM |
Redirect Kounotori Deploy Env | stg |
Redirect Status | 200 |
Unique Id | aA1La56hE@HsJDkIK848gQAAAdM |
Kounotori Deploy Env | stg |
Proxy-nokeepalive | 1 |
Http Accept | */* |
Http User Agent | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Http Accept Encoding | gzip, br, zstd, deflate |
Http Host | 202.222.80.41 |
Path | /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin |
Server Signature | |
Server Software | Apache/2.4.37 (Red Hat Enterprise Linux) OpenSSL/1.1.1g |
Server Name | 202.222.80.41 |
Server Addr | 192.168.1.3 |
Server Port | 80 |
Remote Addr | 18.119.136.32 |
Document Root | /var/www/html |
Request Scheme | http |
Context Prefix | |
Context Document Root | /var/www/html |
Server Admin | admin@agri-harvest.sato.co.jp |
Script Filename | /var/www/html/app/webroot/index.php |
Remote Port | 6962 |
Redirect Url | /app/webroot/sys_products/edit/30100 |
Gateway Interface | CGI/1.1 |
Server Protocol | HTTP/1.1 |
Request Method | GET |
Query String | |
Request Uri | /sys_products/edit/30100 |
Script Name | /app/webroot/index.php |
Php Self | /app/webroot/index.php |
Request Time Float | 1745701739.5161 |
Request Time | 1745701739 |