Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9677  AG06000096 06 661          View Edit Delete
9681  AG06000100 06 661          View Edit Delete
9683  AG06000102 06 661          View Edit Delete
9682  AG06000101 06 661          View Edit Delete
9680  AG06000099 06 661          View Edit Delete
9676  AG06000095 06 661          View Edit Delete
9686  AG06000105 06 661          View Edit Delete
9685  AG06000104 06 661          View Edit Delete
9684  AG06000103 06 661          View Edit Delete
9687  AG06000106 06 661          View Edit Delete
9666  AG06000085 06 661          View Edit Delete
9665  AG06000084 06 661          View Edit Delete
9664  AG06000083 06 661          View Edit Delete
9663  AG06000082 06 661          View Edit Delete
9662  AG06000081 06 661          View Edit Delete
9657  AG06000076 06 661          View Edit Delete
9653  AG06000072 06 661          View Edit Delete
9652  AG06000071 06 661          View Edit Delete
9659  AG06000078 06 661          View Edit Delete
9658  AG06000077 06 661          View Edit Delete

Page 31 of 373, showing 20 records out of 7458 total, starting on record 601, ending on 620

(default) 2 queries took 22 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`.`modified` asc LIMIT 600, 2020206
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 = 11116