Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10570  AG06000989 06 661          View Edit Delete
10571  AG06000990 06 661          View Edit Delete
10572  AG06000991 06 661          View Edit Delete
10573  AG06000992 06 661          View Edit Delete
10574  AG06000993 06 661          View Edit Delete
10575  AG06000994 06 661          View Edit Delete
10576  AG06000995 06 661          View Edit Delete
10577  AG06000996 06 661          View Edit Delete
10578  AG06000997 06 661          View Edit Delete
10579  AG06000998 06 661          View Edit Delete
10580  AG06000999 06 661          View Edit Delete
10581  AG06001000 06 661          View Edit Delete
10582  AG06001001 06 661          View Edit Delete
10583  AG06001002 06 661          View Edit Delete
10584  AG06001003 06 661          View Edit Delete
10585  AG06001004 06 661          View Edit Delete
10586  AG06001005 06 661          View Edit Delete
10587  AG06001006 06 661          View Edit Delete
10588  AG06001007 06 661          View Edit Delete
10589  AG06001008 06 661          View Edit Delete

Page 142 of 373, showing 20 records out of 7458 total, starting on record 2821, ending on 2840

(default) 2 queries took 27 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 2820, 20202010
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