Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9748  AG06000167 06 661          View Edit Delete
9747  AG06000166 06 661          View Edit Delete
9746  AG06000165 06 661          View Edit Delete
9745  AG06000164 06 661          View Edit Delete
9744  AG06000163 06 661          View Edit Delete
9743  AG06000162 06 661          View Edit Delete
9742  AG06000161 06 661          View Edit Delete
9741  AG06000160 06 661          View Edit Delete
9740  AG06000159 06 661          View Edit Delete
9739  AG06000158 06 661          View Edit Delete
9738  AG06000157 06 661          View Edit Delete
9737  AG06000156 06 661          View Edit Delete
9736  AG06000155 06 661          View Edit Delete
9735  AG06000154 06 661          View Edit Delete
9734  AG06000153 06 661          View Edit Delete
9733  AG06000152 06 661          View Edit Delete
9732  AG06000151 06 661          View Edit Delete
9731  AG06000150 06 661          View Edit Delete
9730  AG06000149 06 661          View Edit Delete
9729  AG06000148 06 661          View Edit Delete

Page 59 of 373, showing 20 records out of 7458 total, starting on record 1161, ending on 1180

(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`.`farmer_id` desc LIMIT 1160, 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