Traders Farmers

Farmer Trader Farmer Cd Created Insert User Modified Update User Actions
AG01003025 01 240006  2017-09-25 00:00:00        View Edit Delete
AG01003026 01 240007  2017-09-25 00:00:00        View Edit Delete
AG01003027 01 240008  2017-09-25 00:00:00  MG00000001  2022-06-16 08:48:51  MG00000001  View Edit Delete
AG01003028 01 240009  2017-09-25 00:00:00        View Edit Delete
AG01003029 01 240010  2017-09-25 00:00:00        View Edit Delete
AG01003030 01 240011  2017-09-25 00:00:00        View Edit Delete
AG01003031 01 240012  2017-09-25 00:00:00        View Edit Delete
AG01003268 01 400031  2017-10-24 13:46:17        View Edit Delete
AG01003269 01 240013  2017-05-11 00:00:00        View Edit Delete
AG01003270 01 430001          View Edit Delete
AG01003271 01 430002          View Edit Delete
AG01003272 01 430003          View Edit Delete
AG01003273 01 430004          View Edit Delete
AG01003274 01 430013          View Edit Delete
AG01003275 01 430014          View Edit Delete
AG01003276 01 430018          View Edit Delete
AG01003277 01 430031          View Edit Delete
AG01003278 01 430033          View Edit Delete
AG01003279 01 430034          View Edit Delete
AG01003280 01 430048          View Edit Delete

Page 16 of 251, showing 20 records out of 5002 total, starting on record 301, ending on 320

(default) 2 queries took 14 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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, 2020202
2SELECT 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 = 11112