Traders Farmers

Farmer Trader Farmer Cd Created Insert User Modified Update User Actions
AG01003026 01 240007  2017-09-25 00:00:00        View Edit Delete
AG01002999 01 400016          View Edit Delete
AG01003025 01 240006  2017-09-25 00:00:00        View Edit Delete
AG01003014 01 400028          View Edit Delete
AG01003006 01 400022          View Edit Delete
AG01003269 01 240013  2017-05-11 00:00:00        View Edit Delete
AG01003029 01 240010  2017-09-25 00:00:00        View Edit Delete
AG01003002 01 410001          View Edit Delete
AG01003020 01 240001  2017-09-15 00:00:00        View Edit Delete
AG01003016 01 260043          View Edit Delete
AG01003000 01 400017          View Edit Delete
AG01002994 01 400011          View Edit Delete
AG01003272 01 430003          View Edit Delete
AG01003270 01 430001          View Edit Delete
AG01003024 01 240005  2017-09-25 00:00:00        View Edit Delete
AG01003009 01 290824          View Edit Delete
AG01003007 01 400023          View Edit Delete
AG01002998 01 400015          View Edit Delete
AG01003015 01 400029          View Edit Delete
AG01003021 01 240002  2017-09-15 00:00:00        View Edit Delete

Page 2 of 251, showing 20 records out of 5002 total, starting on record 21, ending on 40

(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`.`update_user` asc LIMIT 20, 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