Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10628  AG06001047 06 661          View Edit Delete
10627  AG06001046 06 661          View Edit Delete
10626  AG06001045 06 661          View Edit Delete
10625  AG06001044 06 661          View Edit Delete
10624  AG06001043 06 661          View Edit Delete
10623  AG06001042 06 661          View Edit Delete
10622  AG06001041 06 661          View Edit Delete
10621  AG06001040 06 661          View Edit Delete
10620  AG06001039 06 661          View Edit Delete
10619  AG06001038 06 661          View Edit Delete
10618  AG06001037 06 661          View Edit Delete
10617  AG06001036 06 661          View Edit Delete
10616  AG06001035 06 661          View Edit Delete
10615  AG06001034 06 661          View Edit Delete
10614  AG06001033 06 661          View Edit Delete
10613  AG06001032 06 661          View Edit Delete
10612  AG06001031 06 661          View Edit Delete
10611  AG06001030 06 661          View Edit Delete
10610  AG06001029 06 661          View Edit Delete
10609  AG06001028 06 661          View Edit Delete

Page 15 of 373, showing 20 records out of 7458 total, starting on record 281, ending on 300

(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`.`farmer_id` desc LIMIT 280, 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