Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9663  AG06000082 06 661          View Edit Delete
9661  AG06000080 06 661          View Edit Delete
9668  AG06000087 06 661          View Edit Delete
9670  AG06000089 06 661          View Edit Delete
9669  AG06000088 06 661          View Edit Delete
9667  AG06000086 06 661          View Edit Delete
9672  AG06000091 06 661          View Edit Delete
9674  AG06000093 06 661          View Edit Delete
9673  AG06000092 06 661          View Edit Delete
9671  AG06000090 06 661          View Edit Delete
9677  AG06000096 06 661          View Edit Delete
9679  AG06000098 06 661          View Edit Delete
9678  AG06000097 06 661          View Edit Delete
9676  AG06000095 06 661          View Edit Delete
9681  AG06000100 06 661          View Edit Delete
9683  AG06000102 06 661          View Edit Delete
9682  AG06000101 06 661          View Edit Delete
9680  AG06000099 06 661          View Edit Delete
9687  AG06000106 06 661          View Edit Delete
9686  AG06000105 06 661          View Edit Delete

Page 28 of 373, showing 20 records out of 7458 total, starting on record 541, ending on 560

(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`.`modified` asc LIMIT 540, 2020206
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