Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9738  AG06000157 06 661          View Edit Delete
9728  AG06000147 06 661          View Edit Delete
9696  AG06000115 06 661          View Edit Delete
9749  AG06000168 06 661          View Edit Delete
9755  AG06000174 06 661          View Edit Delete
9762  AG06000181 06 661          View Edit Delete
9761  AG06000180 06 661          View Edit Delete
9759  AG06000178 06 661          View Edit Delete
9764  AG06000183 06 661          View Edit Delete
9765  AG06000184 06 661          View Edit Delete
9763  AG06000182 06 661          View Edit Delete
9758  AG06000177 06 661          View Edit Delete
9754  AG06000173 06 661          View Edit Delete
9748  AG06000167 06 661          View Edit Delete
9695  AG06000114 06 661          View Edit Delete
9603  AG06000022 06 661          View Edit Delete
10428  AG06000847 06 661          View Edit Delete
9774  AG06000193 06 661          View Edit Delete
9776  AG06000195 06 661          View Edit Delete
9779  AG06000198 06 661          View Edit Delete

Page 52 of 373, showing 20 records out of 7458 total, starting on record 1021, ending on 1040

(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 1020, 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 = 11116