Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9736  AG06000155 06 661          View Edit Delete
9789  AG06000208 06 661          View Edit Delete
9795  AG06000214 06 661          View Edit Delete
9802  AG06000221 06 661          View Edit Delete
9801  AG06000220 06 661          View Edit Delete
9799  AG06000218 06 661          View Edit Delete
9804  AG06000223 06 661          View Edit Delete
9805  AG06000224 06 661          View Edit Delete
9803  AG06000222 06 661          View Edit Delete
9798  AG06000217 06 661          View Edit Delete
9794  AG06000213 06 661          View Edit Delete
9788  AG06000207 06 661          View Edit Delete
9735  AG06000154 06 661          View Edit Delete
9643  AG06000062 06 661          View Edit Delete
9813  AG06000232 06 661          View Edit Delete
9815  AG06000234 06 661          View Edit Delete
9824  AG06000243 06 661          View Edit Delete
9826  AG06000245 06 661          View Edit Delete
9829  AG06000248 06 661          View Edit Delete
9825  AG06000244 06 661          View Edit Delete

Page 54 of 373, showing 20 records out of 7458 total, starting on record 1061, ending on 1080

(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`.`trader_id` desc LIMIT 1060, 2020208
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