Traders Farmers
Page 16 of 251, showing 20 records out of 5002 total, starting on record 301, ending on 320
Page 16 of 251, showing 20 records out of 5002 total, starting on record 301, ending on 320
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SELECT `TradersFarmer`.`farmer_id`, `TradersFarmer`.`trader_id`, `TradersFarmer`.`farmer_cd`, `TradersFarmer`.`created`, `TradersFarmer`.`insert_user`, `TradersFarmer`.`modified`, `TradersFarmer`.`update_user`, `Trader`.`id`, `Trader`.`formal_trader_nm`, `Trader`.`formal_trader_fk`, `Trader`.`designation_file`, `Trader`.`use_start_day`, `Trader`.`use_end_day`, `Trader`.`margin_price_yen`, `Trader`.`created`, `Trader`.`insert_user`, `Trader`.`modified`, `Trader`.`update_user`, `Farmer`.`user_id`, `Farmer`.`agreement_start_day`, `Farmer`.`agreement_end_day`, `Farmer`.`plan_code`, `Farmer`.`agreement_amount`, `Farmer`.`rental_printer_sn`, `Farmer`.`rental_tablet_sn`, `Farmer`.`rental_tablet_tel`, `Farmer`.`rental_tablet_gmail`, `Farmer`.`label_flg`, `Farmer`.`seal_flg`, `Farmer`.`blog_flg`, `Farmer`.`log_save_number`, `Farmer`.`user_post_number`, `Farmer`.`user_address`, `Farmer`.`user_tel`, `Farmer`.`qr_url`, `Farmer`.`notification_file`, `Farmer`.`plain_password`, `Farmer`.`admin_memo`, `Farmer`.`biz_browser_authorized_devices_count`, `Farmer`.`biz_browser_authorized_devices_limit`, `Farmer`.`created`, `Farmer`.`insert_user`, `Farmer`.`modified`, `Farmer`.`update_user` FROM `sato_agri`.`traders_farmers` AS `TradersFarmer` LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`TradersFarmer`.`trader_id` = `Trader`.`id`) LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`TradersFarmer`.`farmer_id` = `Farmer`.`user_id`) WHERE 1 = 1 LIMIT 300, 20 | 20 | 20 | 2 | |
2 | SELECT COUNT(*) AS `count` FROM `sato_agri`.`traders_farmers` AS `TradersFarmer` LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`TradersFarmer`.`trader_id` = `Trader`.`id`) LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`TradersFarmer`.`farmer_id` = `Farmer`.`user_id`) WHERE 1 = 1 | 1 | 1 | 12 |
No post data.
No querystring data.
To view Cookies, add CookieComponent to Controller
Peak Memory Use 9.58 MB
Message | Memory use |
---|---|
Component initialization | 3.57 MB |
Controller action start | 3.80 MB |
Controller render start | 6.01 MB |
View render complete | 7.63 MB |
Total Request Time: 74 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 17.92 | |
Event: Controller.initialize | 0.03 | |
Event: Controller.startup | 0.23 | |
Controller action | 26.28 | |
Event: Controller.beforeRender | 5.60 | |
» Processing toolbar data | 5.52 | |
Rendering View | 10.21 | |
» Event: View.beforeRender | 0.03 | |
» Rendering APP/View/TradersFarmers/index.ctp | 8.72 | |
» Event: View.afterRender | 0.02 | |
» Event: View.beforeLayout | 0.02 | |
» Rendering APP/View/Layouts/default.ctp | 0.82 | |
» » Rendering CORE/Cake/View/Elements/sql_dump.ctp | 0.22 | |
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 | aA4XoiZo1@eGX45RglpThQAAAEQ |
Redirect Redirect Kounotori Deploy Env | stg |
Redirect Redirect Status | 200 |
Redirect Unique Id | aA4XoiZo1@eGX45RglpThQAAAEQ |
Redirect Kounotori Deploy Env | stg |
Redirect Status | 200 |
Unique Id | aA4XoiZo1@eGX45RglpThQAAAEQ |
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 | 3.134.92.193 |
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 | 44102 |
Redirect Url | /app/webroot/TradersFarmers/index/page:16 |
Gateway Interface | CGI/1.1 |
Server Protocol | HTTP/1.1 |
Request Method | GET |
Query String | |
Request Uri | /TradersFarmers/index/page:16 |
Script Name | /app/webroot/index.php |
Php Self | /app/webroot/index.php |
Request Time Float | 1745754018.7569 |
Request Time | 1745754018 |