Traders Farmers

Farmer Trader Farmer Cd Created Insert User Modified Update User Actions
AG01003017 01 260044          View Edit Delete
AG01003000 01 400017          View Edit Delete
AG01003272 01 430003          View Edit Delete
AG01003291 01 430108          View Edit Delete
AG01003287 01 430105          View Edit Delete
AG01003270 01 430001          View Edit Delete
AG01002994 01 400011          View Edit Delete
AG01003007 01 400023          View Edit Delete
AG01002998 01 400015          View Edit Delete
AG01003015 01 400029          View Edit Delete
AG01003026 01 240007  2017-09-25 00:00:00        View Edit Delete
AG01003024 01 240005  2017-09-25 00:00:00        View Edit Delete
AG01003013 01 370162          View Edit Delete
AG01003003 01 400019          View Edit Delete
AG01003279 01 430034          View Edit Delete
AG01003277 01 430031          View Edit Delete
AG01003268 01 400031  2017-10-24 13:46:17        View Edit Delete
AG01003285 01 430101          View Edit Delete
AG01003292 01 401032          View Edit Delete
AG01003283 01 430095          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 16 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`.`insert_user` 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 = 11112