Traders Farmers

Farmer Trader Farmer Cd Created Insert User Modified Update User Actions
AG01003000 01 400017          View Edit Delete
AG01003291 01 430108          View Edit Delete
AG01003273 01 430004          View Edit Delete
AG01003275 01 430014          View Edit Delete
AG01003004 01 400020          View Edit Delete
AG01003014 01 400028          View Edit Delete
AG01003025 01 240006  2017-09-25 00:00:00        View Edit Delete
AG01003028 01 240009  2017-09-25 00:00:00        View Edit Delete
AG01003016 01 260043          View Edit Delete
AG01002999 01 400016          View Edit Delete
AG01003008 01 400024          View Edit Delete
AG01002994 01 400011          View Edit Delete
AG01003301 01 430117          View Edit Delete
AG02000009 02 MZ009  2017-02-22 00:00:00  MG00000001      View Edit Delete
AG02000011 02 MZ011  2017-02-22 00:00:00  MG00000001      View Edit Delete
AG01003303 01 430119          View Edit Delete
AG01003286 01 430104          View Edit Delete
AG01003295 01 240016          View Edit Delete
AG01003297 01 430102          View Edit Delete
AG01003010 01 400025          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 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`.`update_user` asc LIMIT 60, 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