Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9708  AG06000127 06 661          View Edit Delete
9707  AG06000126 06 661          View Edit Delete
9706  AG06000125 06 661          View Edit Delete
9705  AG06000124 06 661          View Edit Delete
9704  AG06000123 06 661          View Edit Delete
9703  AG06000122 06 661          View Edit Delete
9702  AG06000121 06 661          View Edit Delete
9701  AG06000120 06 661          View Edit Delete
9700  AG06000119 06 661          View Edit Delete
9699  AG06000118 06 661          View Edit Delete
9698  AG06000117 06 661          View Edit Delete
9697  AG06000116 06 661          View Edit Delete
9696  AG06000115 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
9692  AG06000111 06 661          View Edit Delete
9691  AG06000110 06 661          View Edit Delete
9690  AG06000109 06 661          View Edit Delete
9689  AG06000108 06 661          View Edit Delete

Page 61 of 373, showing 20 records out of 7458 total, starting on record 1201, ending on 1220

(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`.`farmer_id` desc LIMIT 1200, 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 = 11117