Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9768  AG06000187 06 661          View Edit Delete
9767  AG06000186 06 661          View Edit Delete
9766  AG06000185 06 661          View Edit Delete
9765  AG06000184 06 661          View Edit Delete
9764  AG06000183 06 661          View Edit Delete
9763  AG06000182 06 661          View Edit Delete
9762  AG06000181 06 661          View Edit Delete
9761  AG06000180 06 661          View Edit Delete
9760  AG06000179 06 661          View Edit Delete
9759  AG06000178 06 661          View Edit Delete
9758  AG06000177 06 661          View Edit Delete
9757  AG06000176 06 661          View Edit Delete
9756  AG06000175 06 661          View Edit Delete
9755  AG06000174 06 661          View Edit Delete
9754  AG06000173 06 661          View Edit Delete
9753  AG06000172 06 661          View Edit Delete
9752  AG06000171 06 661          View Edit Delete
9751  AG06000170 06 661          View Edit Delete
9750  AG06000169 06 661          View Edit Delete
9749  AG06000168 06 661          View Edit Delete

Page 58 of 373, showing 20 records out of 7458 total, starting on record 1141, ending on 1160

(default) 2 queries took 26 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`.`farmer_id` desc LIMIT 1140, 2020209
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