Traders Farmers

Farmer Trader Farmer Cd Created Insert User Modified Update User Actions
AG01002995 01 400012          View Edit Delete
AG01003285 01 430101          View Edit Delete
AG01003283 01 430095          View Edit Delete
AG01003277 01 430031          View Edit Delete
AG01003278 01 430033          View Edit Delete
AG01003280 01 430048          View Edit Delete
AG01003281 01 430063          View Edit Delete
AG01003279 01 430034          View Edit Delete
AG01003276 01 430018          View Edit Delete
AG01003284 01 430096          View Edit Delete
AG01003301 01 430117          View Edit Delete
AG01003286 01 430104          View Edit Delete
AG01003287 01 430105          View Edit Delete
AG01003288 01 430107          View Edit Delete
AG01003290 01 430116          View Edit Delete
AG01003289 01 430113          View Edit Delete
AG02000005 02 MZ005  2017-02-22 00:00:00  MG00000001      View Edit Delete
AG02000007 02 MZ007  2017-02-22 00:00:00  MG00000001      View Edit Delete
AG02000002 02 MZ002  2017-02-22 00:00:00  MG00000001      View Edit Delete
AG01003297 01 430102          View Edit Delete

Page 4 of 251, showing 20 records out of 5002 total, starting on record 61, ending on 80

(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`.`modified` asc LIMIT 60, 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