Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10470  AG06000889 06 661          View Edit Delete
10471  AG06000890 06 661          View Edit Delete
10472  AG06000891 06 661          View Edit Delete
10473  AG06000892 06 661          View Edit Delete
10474  AG06000893 06 661          View Edit Delete
10475  AG06000894 06 661          View Edit Delete
10476  AG06000895 06 661          View Edit Delete
10477  AG06000896 06 661          View Edit Delete
10478  AG06000897 06 661          View Edit Delete
10479  AG06000898 06 661          View Edit Delete
10480  AG06000899 06 661          View Edit Delete
10481  AG06000900 06 661          View Edit Delete
10482  AG06000901 06 661          View Edit Delete
10483  AG06000902 06 661          View Edit Delete
10484  AG06000903 06 661          View Edit Delete
10485  AG06000904 06 661          View Edit Delete
10486  AG06000905 06 661          View Edit Delete
10487  AG06000906 06 661          View Edit Delete
10488  AG06000907 06 661          View Edit Delete
10489  AG06000908 06 661          View Edit Delete

Page 137 of 373, showing 20 records out of 7458 total, starting on record 2721, ending on 2740

(default) 2 queries took 25 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 2720, 2020209
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