Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
6973  AG01003270 01 010  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
6974  AG01003271 01 010  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
6975  AG01003272 01 010  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
6977  AG01003274 01 010  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
6978  AG01003275 01 010  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
6982  AG01003279 01 010  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
6984  AG01003281 01 010  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
6988  AG01003285 01 010  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
6995  AG01003292 01 010          View Edit Delete
6996  AG02000060 02 51          View Edit Delete
6997  AG01003293 01 010          View Edit Delete
6998  AG02000061 02 51          View Edit Delete
6999  AG05000001 05 71  2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete
7000  AG05000002 05 71  2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete
7001  AG05000003 05 71  2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete
7002  AG05000004 05 71  2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete
7003  AG05000005 05 71  2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete
7004  AG05000006 05 71  2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete
7005  AG05000007 05 71  2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete
7006  AG05000008 05 71  2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete

Page 25 of 373, showing 20 records out of 7458 total, starting on record 481, ending on 500

(default) 2 queries took 20 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Contractor`.`id`, `Contractor`.`farmer_id`, `Contractor`.`trader_id`, `Contractor`.`company_cd`, `Contractor`.`created`, `Contractor`.`insert_user`, `Contractor`.`modified`, `Contractor`.`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`, `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` FROM `sato_agri`.`contractors` AS `Contractor` LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`Contractor`.`farmer_id` = `Farmer`.`user_id`) LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`Contractor`.`trader_id` = `Trader`.`id`) WHERE 1 = 1 ORDER BY `Contractor`.`id` asc LIMIT 480, 2020203
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`contractors` AS `Contractor` LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`Contractor`.`farmer_id` = `Farmer`.`user_id`) LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`Contractor`.`trader_id` = `Trader`.`id`) WHERE 1 = 11117