Traders Farmers

Farmer Trader Farmer Cd Created Insert User Modified Update User Actions
AG01003020 01 240001  2017-09-15 00:00:00        View Edit Delete
AG01003024 01 240005  2017-09-25 00:00:00        View Edit Delete
AG01003026 01 240007  2017-09-25 00:00:00        View Edit Delete
AG01003025 01 240006  2017-09-25 00:00:00        View Edit Delete
AG01003023 01 240004  2017-09-25 00:00:00        View Edit Delete
AG01003017 01 260044          View Edit Delete
AG01003029 01 240010  2017-09-25 00:00:00        View Edit Delete
AG01003031 01 240012  2017-09-25 00:00:00        View Edit Delete
AG01003030 01 240011  2017-09-25 00:00:00        View Edit Delete
AG01003028 01 240009  2017-09-25 00:00:00        View Edit Delete
AG01003269 01 240013  2017-05-11 00:00:00        View Edit Delete
AG01003271 01 430002          View Edit Delete
AG01003270 01 430001          View Edit Delete
AG01003268 01 400031  2017-10-24 13:46:17        View Edit Delete
AG01003276 01 430018          View Edit Delete
AG01003275 01 430014          View Edit Delete
AG01003273 01 430004          View Edit Delete
AG01003278 01 430033          View Edit Delete
AG01002999 01 400016          View Edit Delete
AG01003277 01 430031          View Edit Delete

Page 5 of 251, showing 20 records out of 5002 total, starting on record 81, ending on 100

(default) 2 queries took 17 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 ORDER BY `TradersFarmer`.`modified` asc LIMIT 80, 2020204
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 = 11113