Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10568  AG06000987 06 661          View Edit Delete
10567  AG06000986 06 661          View Edit Delete
10566  AG06000985 06 661          View Edit Delete
10565  AG06000984 06 661          View Edit Delete
10564  AG06000983 06 661          View Edit Delete
10563  AG06000982 06 661          View Edit Delete
10562  AG06000981 06 661          View Edit Delete
10561  AG06000980 06 661          View Edit Delete
10560  AG06000979 06 661          View Edit Delete
10559  AG06000978 06 661          View Edit Delete
10558  AG06000977 06 661          View Edit Delete
10557  AG06000976 06 661          View Edit Delete
10556  AG06000975 06 661          View Edit Delete
10555  AG06000974 06 661          View Edit Delete
10554  AG06000973 06 661          View Edit Delete
10553  AG06000972 06 661          View Edit Delete
10552  AG06000971 06 661          View Edit Delete
10551  AG06000970 06 661          View Edit Delete
10550  AG06000969 06 661          View Edit Delete
10549  AG06000968 06 661          View Edit Delete

Page 18 of 373, showing 20 records out of 7458 total, starting on record 341, ending on 360

(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 ORDER BY `Contractor`.`farmer_id` desc LIMIT 340, 2020207
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