Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9676  AG06000095 06 661          View Edit Delete
9668  AG06000087 06 661          View Edit Delete
9690  AG06000109 06 661          View Edit Delete
9688  AG06000107 06 661          View Edit Delete
9684  AG06000103 06 661          View Edit Delete
9692  AG06000111 06 661          View Edit Delete
9697  AG06000116 06 661          View Edit Delete
9695  AG06000114 06 661          View Edit Delete
9691  AG06000110 06 661          View Edit Delete
9683  AG06000102 06 661          View Edit Delete
9667  AG06000086 06 661          View Edit Delete
9704  AG06000123 06 661          View Edit Delete
9700  AG06000119 06 661          View Edit Delete
9708  AG06000127 06 661          View Edit Delete
9711  AG06000130 06 661          View Edit Delete
9707  AG06000126 06 661          View Edit Delete
9699  AG06000118 06 661          View Edit Delete
9698  AG06000117 06 661          View Edit Delete
9666  AG06000085 06 661          View Edit Delete
9602  AG06000021 06 661          View Edit Delete

Page 14 of 373, showing 20 records out of 7458 total, starting on record 261, ending on 280

(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 260, 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