Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9954  AG06000373 06 661          View Edit Delete
9953  AG06000372 06 661          View Edit Delete
9950  AG06000369 06 661          View Edit Delete
9956  AG06000375 06 661          View Edit Delete
9958  AG06000377 06 661          View Edit Delete
9955  AG06000374 06 661          View Edit Delete
9949  AG06000368 06 661          View Edit Delete
9937  AG06000356 06 661          View Edit Delete
9910  AG06000329 06 661          View Edit Delete
9846  AG06000265 06 661          View Edit Delete
9736  AG06000155 06 661          View Edit Delete
9598  AG06000017 06 661          View Edit Delete
9595  AG06000014 06 661          View Edit Delete
9589  AG06000008 06 661          View Edit Delete
9601  AG06000020 06 661          View Edit Delete
9600  AG06000019 06 661          View Edit Delete
9588  AG06000007 06 661          View Edit Delete
9587  AG06000006 06 661          View Edit Delete
9586  AG06000005 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete

Page 26 of 373, showing 20 records out of 7458 total, starting on record 501, ending on 520

(default) 2 queries took 24 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`.`insert_user` asc LIMIT 500, 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 = 11117