Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10220  AG06000639 06 661          View Edit Delete
9863  AG06000282 06 661          View Edit Delete
10221  AG06000640 06 661          View Edit Delete
10092  AG06000511 06 661          View Edit Delete
9864  AG06000283 06 661          View Edit Delete
9865  AG06000284 06 661          View Edit Delete
10003  AG06000422 06 661          View Edit Delete
10004  AG06000423 06 661          View Edit Delete
10005  AG06000424 06 661          View Edit Delete
10006  AG06000425 06 661          View Edit Delete
10007  AG06000426 06 661          View Edit Delete
10008  AG06000427 06 661          View Edit Delete
10224  AG06000643 06 661          View Edit Delete
10009  AG06000428 06 661          View Edit Delete
9734  AG06000153 06 661          View Edit Delete
9742  AG06000161 06 661          View Edit Delete
9744  AG06000163 06 661          View Edit Delete
9735  AG06000154 06 661          View Edit Delete
9736  AG06000155 06 661          View Edit Delete
9737  AG06000156 06 661          View Edit Delete

Page 47 of 373, showing 20 records out of 7458 total, starting on record 921, ending on 940

(default) 2 queries took 25 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`.`company_cd` desc LIMIT 920, 2020208
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