Contractors

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

Page 146 of 373, showing 20 records out of 7458 total, starting on record 2901, ending on 2920

(default) 2 queries took 27 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 LIMIT 2900, 20202010
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