Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9678  AG06000097 06 661          View Edit Delete
9674  AG06000093 06 661          View Edit Delete
9687  AG06000106 06 661          View Edit Delete
9686  AG06000105 06 661          View Edit Delete
9685  AG06000104 06 661          View Edit Delete
9689  AG06000108 06 661          View Edit Delete
9691  AG06000110 06 661          View Edit Delete
9690  AG06000109 06 661          View Edit Delete
9688  AG06000107 06 661          View Edit Delete
9684  AG06000103 06 661          View Edit Delete
9695  AG06000114 06 661          View Edit Delete
9694  AG06000113 06 661          View Edit Delete
9693  AG06000112 06 661          View Edit Delete
9697  AG06000116 06 661          View Edit Delete
9699  AG06000118 06 661          View Edit Delete
9698  AG06000117 06 661          View Edit Delete
9696  AG06000115 06 661          View Edit Delete
9692  AG06000111 06 661          View Edit Delete
9702  AG06000121 06 661          View Edit Delete
9701  AG06000120 06 661          View Edit Delete

Page 36 of 373, showing 20 records out of 7458 total, starting on record 701, ending on 720

(default) 2 queries took 24 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`.`created` asc LIMIT 700, 2020207
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