Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9747  AG06000166 06 661          View Edit Delete
9741  AG06000160 06 661          View Edit Delete
9761  AG06000180 06 661          View Edit Delete
9759  AG06000178 06 661          View Edit Delete
9755  AG06000174 06 661          View Edit Delete
9763  AG06000182 06 661          View Edit Delete
9768  AG06000187 06 661          View Edit Delete
9766  AG06000185 06 661          View Edit Delete
9762  AG06000181 06 661          View Edit Delete
9754  AG06000173 06 661          View Edit Delete
9740  AG06000159 06 661          View Edit Delete
9724  AG06000143 06 661          View Edit Delete
9772  AG06000191 06 661          View Edit Delete
9780  AG06000199 06 661          View Edit Delete
9779  AG06000198 06 661          View Edit Delete
9771  AG06000190 06 661          View Edit Delete
9770  AG06000189 06 661          View Edit Delete
9769  AG06000188 06 661          View Edit Delete
9723  AG06000142 06 661          View Edit Delete
9722  AG06000141 06 661          View Edit Delete

Page 21 of 373, showing 20 records out of 7458 total, starting on record 401, ending on 420

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