Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
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
10548  AG06000967 06 661          View Edit Delete

Page 233 of 373, showing 20 records out of 7458 total, starting on record 4641, ending on 4660

(default) 2 queries took 34 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 4640, 20202017
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