Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9872  AG06000291 06 661          View Edit Delete
9640  AG06000059 06 661          View Edit Delete
9644  AG06000063 06 661          View Edit Delete
10003  AG06000422 06 661          View Edit Delete
9874  AG06000293 06 661          View Edit Delete
9877  AG06000296 06 661          View Edit Delete
9646  AG06000065 06 661          View Edit Delete
9641  AG06000060 06 661          View Edit Delete
10004  AG06000423 06 661          View Edit Delete
9784  AG06000203 06 661          View Edit Delete
9789  AG06000208 06 661          View Edit Delete
9787  AG06000206 06 661          View Edit Delete
9785  AG06000204 06 661          View Edit Delete
9786  AG06000205 06 661          View Edit Delete
9782  AG06000201 06 661          View Edit Delete
10006  AG06000425 06 661          View Edit Delete
9788  AG06000207 06 661          View Edit Delete
9638  AG06000057 06 661          View Edit Delete
9648  AG06000067 06 661          View Edit Delete
9650  AG06000069 06 661          View Edit Delete

Page 36 of 373, showing 20 records out of 7458 total, starting on record 701, ending on 720

(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`.`company_cd` desc LIMIT 700, 2020208
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