Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9667  AG06000086 06 661          View Edit Delete
9659  AG06000078 06 661          View Edit Delete
9681  AG06000100 06 661          View Edit Delete
9679  AG06000098 06 661          View Edit Delete
9675  AG06000094 06 661          View Edit Delete
9683  AG06000102 06 661          View Edit Delete
9688  AG06000107 06 661          View Edit Delete
9686  AG06000105 06 661          View Edit Delete
9682  AG06000101 06 661          View Edit Delete
9674  AG06000093 06 661          View Edit Delete
9658  AG06000077 06 661          View Edit Delete
9690  AG06000109 06 661          View Edit Delete
9689  AG06000108 06 661          View Edit Delete
9657  AG06000076 06 661          View Edit Delete
9656  AG06000075 06 661          View Edit Delete
9977  AG06000396 06 661          View Edit Delete
9708  AG06000127 06 661          View Edit Delete
10217  AG06000636 06 661          View Edit Delete
10220  AG06000639 06 661          View Edit Delete
10218  AG06000637 06 661          View Edit Delete

Page 49 of 373, showing 20 records out of 7458 total, starting on record 961, ending on 980

(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`.`trader_id` desc LIMIT 960, 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