Traders Farmers

Farmer Trader Farmer Cd Created Insert User Modified Update User Actions
AG01003279 01 430034          View Edit Delete
AG01003275 01 430014          View Edit Delete
AG01003031 01 240012  2017-09-25 00:00:00        View Edit Delete
AG01003289 01 430113          View Edit Delete
AG01003287 01 430105          View Edit Delete
AG01003283 01 430095          View Edit Delete
AG01003291 01 430108          View Edit Delete
AG01003296 01 240015          View Edit Delete
AG01003294 01 401034  2017-11-01 12:59:36        View Edit Delete
AG01003290 01 430116          View Edit Delete
AG01003282 01 430092          View Edit Delete
AG01003030 01 240011  2017-09-25 00:00:00        View Edit Delete
AG01002995 01 400012          View Edit Delete
AG01003300 01 430108          View Edit Delete
AG03000008 03 SR008  2017-05-11 00:00:00        View Edit Delete
AG03000009 03 SR009  2017-05-11 00:00:00        View Edit Delete
AG01003299 01 430107          View Edit Delete
AG01003298 01 430012          View Edit Delete
AG01003297 01 430102          View Edit Delete
AG02100027 02 MZS027  2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  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 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`.`insert_user` asc LIMIT 80, 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