Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10259  AG06000678 06 661          View Edit Delete
10257  AG06000676 06 661          View Edit Delete
10260  AG06000679 06 661          View Edit Delete
9728  AG06000147 06 661          View Edit Delete
9726  AG06000145 06 661          View Edit Delete
9720  AG06000139 06 661          View Edit Delete
9710  AG06000129 06 661          View Edit Delete
9678  AG06000097 06 661          View Edit Delete
9731  AG06000150 06 661          View Edit Delete
9737  AG06000156 06 661          View Edit Delete
9744  AG06000163 06 661          View Edit Delete
9743  AG06000162 06 661          View Edit Delete
9741  AG06000160 06 661          View Edit Delete
9745  AG06000164 06 661          View Edit Delete
9740  AG06000159 06 661          View Edit Delete
9736  AG06000155 06 661          View Edit Delete
9730  AG06000149 06 661          View Edit Delete
9677  AG06000096 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete
10034  AG06000453 06 661          View Edit Delete

Page 51 of 373, showing 20 records out of 7458 total, starting on record 1001, ending on 1020

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