Traders Farmers

Farmer Trader Farmer Cd Created Insert User Modified Update User Actions
AG01003273 01 430004          View Edit Delete
AG01003269 01 240013  2017-05-11 00:00:00        View Edit Delete
AG01003277 01 430031          View Edit Delete
AG01003282 01 430092          View Edit Delete
AG01003280 01 430048          View Edit Delete
AG01003276 01 430018          View Edit Delete
AG01003268 01 400031  2017-10-24 13:46:17        View Edit Delete
AG01003290 01 430116          View Edit Delete
AG01003288 01 430107          View Edit Delete
AG01003284 01 430096          View Edit Delete
AG01003292 01 401032          View Edit Delete
AG01003297 01 430102          View Edit Delete
AG01003295 01 240016          View Edit Delete
AG01003291 01 430108          View Edit Delete
AG01003283 01 430095          View Edit Delete
AG01003031 01 240012  2017-09-25 00:00:00        View Edit Delete
AG01002996 01 400013          View Edit Delete
AG01003299 01 430107          View Edit Delete
AG01003298 01 430012          View Edit Delete
AG01002995 01 400012          View Edit Delete

Page 8 of 251, showing 20 records out of 5002 total, starting on record 141, ending on 160

(default) 2 queries took 18 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`.`update_user` asc LIMIT 140, 2020205
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