Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9801  AG06000220 06 661          View Edit Delete
9800  AG06000219 06 661          View Edit Delete
9803  AG06000222 06 661          View Edit Delete
9802  AG06000221 06 661          View Edit Delete
9805  AG06000224 06 661          View Edit Delete
9804  AG06000223 06 661          View Edit Delete
9807  AG06000226 06 661          View Edit Delete
9808  AG06000227 06 661          View Edit Delete
9809  AG06000228 06 661          View Edit Delete
9810  AG06000229 06 661          View Edit Delete
9813  AG06000232 06 661          View Edit Delete
9814  AG06000233 06 661          View Edit Delete
9816  AG06000235 06 661          View Edit Delete
9817  AG06000236 06 661          View Edit Delete
9818  AG06000237 06 661          View Edit Delete
9819  AG06000238 06 661          View Edit Delete
9822  AG06000241 06 661          View Edit Delete
9820  AG06000239 06 661          View Edit Delete
9825  AG06000244 06 661          View Edit Delete
9823  AG06000242 06 661          View Edit Delete

Page 37 of 373, showing 20 records out of 7458 total, starting on record 721, ending on 740

(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`.`trader_id` desc LIMIT 720, 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