Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10065  AG06000484 06 661          View Edit Delete
9700  AG06000119 06 661          View Edit Delete
9696  AG06000115 06 661          View Edit Delete
9699  AG06000118 06 661          View Edit Delete
9692  AG06000111 06 661          View Edit Delete
9694  AG06000113 06 661          View Edit Delete
9707  AG06000126 06 661          View Edit Delete
9708  AG06000127 06 661          View Edit Delete
9710  AG06000129 06 661          View Edit Delete
9711  AG06000130 06 661          View Edit Delete
9713  AG06000132 06 661          View Edit Delete
9967  AG06000386 06 661          View Edit Delete
9715  AG06000134 06 661          View Edit Delete
9716  AG06000135 06 661          View Edit Delete
9721  AG06000140 06 661          View Edit Delete
9722  AG06000141 06 661          View Edit Delete
9724  AG06000143 06 661          View Edit Delete
9725  AG06000144 06 661          View Edit Delete
9728  AG06000147 06 661          View Edit Delete
9729  AG06000148 06 661          View Edit Delete

Page 33 of 373, showing 20 records out of 7458 total, starting on record 641, ending on 660

(default) 2 queries took 23 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 640, 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 = 11116