Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9742  AG06000161 06 661          View Edit Delete
9740  AG06000159 06 661          View Edit Delete
9737  AG06000156 06 661          View Edit Delete
9730  AG06000149 06 661          View Edit Delete
9749  AG06000168 06 661          View Edit Delete
9747  AG06000166 06 661          View Edit Delete
9744  AG06000163 06 661          View Edit Delete
9751  AG06000170 06 661          View Edit Delete
9755  AG06000174 06 661          View Edit Delete
9753  AG06000172 06 661          View Edit Delete
9750  AG06000169 06 661          View Edit Delete
9743  AG06000162 06 661          View Edit Delete
9729  AG06000148 06 661          View Edit Delete
9701  AG06000120 06 661          View Edit Delete
9757  AG06000176 06 661          View Edit Delete
9756  AG06000175 06 661          View Edit Delete
9700  AG06000119 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

Page 56 of 373, showing 20 records out of 7458 total, starting on record 1101, ending on 1120

(default) 2 queries took 26 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 1100, 2020209
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