Traders Farmers

Farmer Trader Farmer Cd Created Insert User Modified Update User Actions
AG01003273 01 430004          View Edit Delete
AG01003272 01 430003          View Edit Delete
AG01003276 01 430018          View Edit Delete
AG01003275 01 430014          View Edit Delete
AG01003023 01 240004  2017-09-25 00:00:00        View Edit Delete
AG01003274 01 430013          View Edit Delete
AG01003278 01 430033          View Edit Delete
AG01003280 01 430048          View Edit Delete
AG01003279 01 430034          View Edit Delete
AG01003277 01 430031          View Edit Delete
AG01003282 01 430092          View Edit Delete
AG01003281 01 430063          View Edit Delete
AG01003014 01 400028          View Edit Delete
AG01003005 01 400021          View Edit Delete
AG01003015 01 400029          View Edit Delete
AG01003000 01 400017          View Edit Delete
AG01003017 01 260044          View Edit Delete
AG01003004 01 400020          View Edit Delete
AG01003021 01 240002  2017-09-15 00:00:00        View Edit Delete
AG01003020 01 240001  2017-09-15 00:00:00        View Edit Delete

Page 8 of 251, showing 20 records out of 5002 total, starting on record 141, ending on 160

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