Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9682  AG06000101 06 661          View Edit Delete
9694  AG06000113 06 661          View Edit Delete
9692  AG06000111 06 661          View Edit Delete
9686  AG06000105 06 661          View Edit Delete
9681  AG06000100 06 661          View Edit Delete
9696  AG06000115 06 661          View Edit Delete
9695  AG06000114 06 661          View Edit Delete
9680  AG06000099 06 661          View Edit Delete
9676  AG06000095 06 661          View Edit Delete
9699  AG06000118 06 661          View Edit Delete
9703  AG06000122 06 661          View Edit Delete
9702  AG06000121 06 661          View Edit Delete
9706  AG06000125 06 661          View Edit Delete
9678  AG06000097 06 661          View Edit Delete
9709  AG06000128 06 661          View Edit Delete
9710  AG06000129 06 661          View Edit Delete
9712  AG06000131 06 661          View Edit Delete
9711  AG06000130 06 661          View Edit Delete
9704  AG06000123 06 661          View Edit Delete
9597  AG06000016 06 661          View Edit Delete

Page 14 of 373, showing 20 records out of 7458 total, starting on record 261, ending on 280

(default) 2 queries took 26 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 260, 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 = 11119