Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9930  AG06000349 06 661          View Edit Delete
9931  AG06000350 06 661          View Edit Delete
9932  AG06000351 06 661          View Edit Delete
9933  AG06000352 06 661          View Edit Delete
9934  AG06000353 06 661          View Edit Delete
9935  AG06000354 06 661          View Edit Delete
9936  AG06000355 06 661          View Edit Delete
9937  AG06000356 06 661          View Edit Delete
9938  AG06000357 06 661          View Edit Delete
9939  AG06000358 06 661          View Edit Delete
9940  AG06000359 06 661          View Edit Delete
9941  AG06000360 06 661          View Edit Delete
9942  AG06000361 06 661          View Edit Delete
9943  AG06000362 06 661          View Edit Delete
9944  AG06000363 06 661          View Edit Delete
9945  AG06000364 06 661          View Edit Delete
9946  AG06000365 06 661          View Edit Delete
9947  AG06000366 06 661          View Edit Delete
9948  AG06000367 06 661          View Edit Delete
9949  AG06000368 06 661          View Edit Delete

Page 110 of 373, showing 20 records out of 7458 total, starting on record 2181, ending on 2200

(default) 2 queries took 29 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 LIMIT 2180, 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 = 11120