Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10212  AG06000631 06 661          View Edit Delete
10210  AG06000629 06 661          View Edit Delete
10206  AG06000625 06 661          View Edit Delete
10214  AG06000633 06 661          View Edit Delete
10219  AG06000638 06 661          View Edit Delete
10217  AG06000636 06 661          View Edit Delete
10213  AG06000632 06 661          View Edit Delete
10205  AG06000624 06 661          View Edit Delete
10189  AG06000608 06 661          View Edit Delete
10157  AG06000576 06 661          View Edit Delete
10093  AG06000512 06 661          View Edit Delete
9983  AG06000402 06 661          View Edit Delete
10232  AG06000651 06 661          View Edit Delete
10224  AG06000643 06 661          View Edit Delete
10223  AG06000642 06 661          View Edit Delete
10222  AG06000641 06 661          View Edit Delete
10221  AG06000640 06 661          View Edit Delete
10220  AG06000639 06 661          View Edit Delete
9982  AG06000401 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete

Page 45 of 373, showing 20 records out of 7458 total, starting on record 881, ending on 900

(default) 2 queries took 27 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`.`insert_user` asc LIMIT 880, 2020209
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 = 11118