Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9606  AG06000025 06 661          View Edit Delete
9602  AG06000021 06 661          View Edit Delete
9594  AG06000013 06 661          View Edit Delete
9615  AG06000034 06 661          View Edit Delete
9611  AG06000030 06 661          View Edit Delete
9619  AG06000038 06 661          View Edit Delete
9624  AG06000043 06 661          View Edit Delete
9622  AG06000041 06 661          View Edit Delete
9618  AG06000037 06 661          View Edit Delete
9610  AG06000029 06 661          View Edit Delete
9632  AG06000051 06 661          View Edit Delete
9630  AG06000049 06 661          View Edit Delete
9626  AG06000045 06 661          View Edit Delete
9634  AG06000053 06 661          View Edit Delete
9637  AG06000056 06 661          View Edit Delete
9633  AG06000052 06 661          View Edit Delete
9625  AG06000044 06 661          View Edit Delete
9609  AG06000028 06 661          View Edit Delete
9586  AG06000005 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete

Page 10 of 373, showing 20 records out of 7458 total, starting on record 181, ending on 200

(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`.`insert_user` asc LIMIT 180, 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