Traders Farmers

Farmer Trader Farmer Cd Created Insert User Modified Update User Actions
AG01003279 01 430034          View Edit Delete
AG01003286 01 430104          View Edit Delete
AG01003285 01 430101          View Edit Delete
AG01003291 01 430108          View Edit Delete
AG01003290 01 430116          View Edit Delete
AG01002994 01 400011          View Edit Delete
AG01003276 01 430018          View Edit Delete
AG01003275 01 430014          View Edit Delete
AG01003271 01 430002          View Edit Delete
AG01003278 01 430033          View Edit Delete
AG01003282 01 430092          View Edit Delete
AG01003281 01 430063          View Edit Delete
AG01003277 01 430031          View Edit Delete
AG01003284 01 430096          View Edit Delete
AG01003288 01 430107          View Edit Delete
AG01003287 01 430105          View Edit Delete
AG01003269 01 240013  2017-05-11 00:00:00        View Edit Delete
AG01003270 01 430001          View Edit Delete
AG01003268 01 400031  2017-10-24 13:46:17        View Edit Delete
AG01003031 01 240012  2017-09-25 00:00:00        View Edit Delete

Page 3 of 251, showing 20 records out of 5002 total, starting on record 41, ending on 60

(default) 2 queries took 15 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 40, 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 = 11111