Traders Farmers

Farmer Trader Farmer Cd Created Insert User Modified Update User Actions
AG01002763 01 400002  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
AG01002764 01 400003  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
AG01002765 01 400004  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
AG01002766 01 400005  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
AG01002767 01 400006  2017-04-18 13:36:00  MG00000005  2021-01-25 16:07:48  MG00000005  View Edit Delete
AG01002768 01 400007  2017-04-18 13:36:00  MG00000001  2018-07-06 09:24:20  MG00000001  View Edit Delete
AG01002769 01 400008  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
AG01002770 01 400009  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
AG01002771 01 400010  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
AG01002994 01 400011          View Edit Delete
AG01002995 01 400012          View Edit Delete
AG01002996 01 400013          View Edit Delete
AG01002997 01 400014          View Edit Delete
AG01002998 01 400015          View Edit Delete
AG01002999 01 400016          View Edit Delete
AG01003000 01 400017          View Edit Delete
AG01003001 01 400018          View Edit Delete
AG01003002 01 410001          View Edit Delete
AG01003003 01 400019          View Edit Delete
AG01003004 01 400020          View Edit Delete

Page 14 of 251, showing 20 records out of 5002 total, starting on record 261, ending on 280

(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`.`trader_id` asc LIMIT 260, 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