Traders Farmers

Farmer Trader Farmer Cd Created Insert User Modified Update User Actions
AG01002588 01 360720    MG00000001  2022-05-17 16:02:43  MG00000001  View Edit Delete
AG01003016 01 260043          View Edit Delete
AG01003282 01 430092          View Edit Delete
AG01003280 01 430048          View Edit Delete
AG01003281 01 430063          View Edit Delete
AG01003275 01 430014          View Edit Delete
AG01003009 01 290824          View Edit Delete
AG01003017 01 260044          View Edit Delete
AG01003015 01 400029          View Edit Delete
AG01003008 01 400024          View Edit Delete
AG01003273 01 430004          View Edit Delete
AG01003279 01 430034          View Edit Delete
AG01003278 01 430033          View Edit Delete
AG01003272 01 430003          View Edit Delete
AG01003012 01 400027          View Edit Delete
AG01003011 01 400026          View Edit Delete
AG01003007 01 400023          View Edit Delete
AG01003014 01 400028          View Edit Delete
AG01003270 01 430001          View Edit Delete
AG01003283 01 430095          View Edit Delete

Page 2 of 251, showing 20 records out of 5002 total, starting on record 21, ending on 40

(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`.`created` asc LIMIT 20, 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