Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10667  AG06001086 06 661          View Edit Delete
10666  AG06001085 06 661          View Edit Delete
10665  AG06001084 06 661          View Edit Delete
10664  AG06001083 06 661          View Edit Delete
10663  AG06001082 06 661          View Edit Delete
10662  AG06001081 06 661          View Edit Delete
10661  AG06001080 06 661          View Edit Delete
10660  AG06001079 06 661          View Edit Delete
10659  AG06001078 06 661          View Edit Delete
10658  AG06001077 06 661          View Edit Delete
10657  AG06001076 06 661          View Edit Delete
10656  AG06001075 06 661          View Edit Delete
10655  AG06001074 06 661          View Edit Delete
10654  AG06001073 06 661          View Edit Delete
10653  AG06001072 06 661          View Edit Delete
10652  AG06001071 06 661          View Edit Delete
10651  AG06001070 06 661          View Edit Delete
10650  AG06001069 06 661          View Edit Delete
10649  AG06001068 06 661          View Edit Delete
10648  AG06001067 06 661          View Edit Delete

Page 228 of 373, showing 20 records out of 7458 total, starting on record 4541, ending on 4560

(default) 2 queries took 32 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 4540, 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 = 11116