Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10430  AG06000849 06 661          View Edit Delete
10431  AG06000850 06 661          View Edit Delete
10432  AG06000851 06 661          View Edit Delete
10433  AG06000852 06 661          View Edit Delete
10434  AG06000853 06 661          View Edit Delete
10435  AG06000854 06 661          View Edit Delete
10436  AG06000855 06 661          View Edit Delete
10437  AG06000856 06 661          View Edit Delete
10438  AG06000857 06 661          View Edit Delete
10439  AG06000858 06 661          View Edit Delete
10440  AG06000859 06 661          View Edit Delete
10441  AG06000860 06 661          View Edit Delete
10442  AG06000861 06 661          View Edit Delete
10443  AG06000862 06 661          View Edit Delete
10444  AG06000863 06 661          View Edit Delete
10445  AG06000864 06 661          View Edit Delete
10446  AG06000865 06 661          View Edit Delete
10447  AG06000866 06 661          View Edit Delete
10448  AG06000867 06 661          View Edit Delete
10449  AG06000868 06 661          View Edit Delete

Page 135 of 373, showing 20 records out of 7458 total, starting on record 2681, ending on 2700

(default) 2 queries took 29 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 2680, 20202011
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 = 11118