Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10647  AG06001066 06 661          View Edit Delete
10646  AG06001065 06 661          View Edit Delete
10645  AG06001064 06 661          View Edit Delete
10644  AG06001063 06 661          View Edit Delete
10643  AG06001062 06 661          View Edit Delete
10642  AG06001061 06 661          View Edit Delete
10641  AG06001060 06 661          View Edit Delete
10640  AG06001059 06 661          View Edit Delete
10639  AG06001058 06 661          View Edit Delete
10638  AG06001057 06 661          View Edit Delete
10637  AG06001056 06 661          View Edit Delete
10636  AG06001055 06 661          View Edit Delete
10635  AG06001054 06 661          View Edit Delete
10634  AG06001053 06 661          View Edit Delete
10633  AG06001052 06 661          View Edit Delete
10632  AG06001051 06 661          View Edit Delete
10631  AG06001050 06 661          View Edit Delete
10630  AG06001049 06 661          View Edit Delete
10629  AG06001048 06 661          View Edit Delete
10628  AG06001047 06 661          View Edit Delete

Page 229 of 373, showing 20 records out of 7458 total, starting on record 4561, ending on 4580

(default) 2 queries took 38 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`.`id` desc LIMIT 4560, 20202016
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 = 11122