Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10630  AG06001049 06 661          View Edit Delete
10631  AG06001050 06 661          View Edit Delete
10632  AG06001051 06 661          View Edit Delete
10633  AG06001052 06 661          View Edit Delete
10634  AG06001053 06 661          View Edit Delete
10635  AG06001054 06 661          View Edit Delete
10636  AG06001055 06 661          View Edit Delete
10637  AG06001056 06 661          View Edit Delete
10638  AG06001057 06 661          View Edit Delete
10639  AG06001058 06 661          View Edit Delete
10640  AG06001059 06 661          View Edit Delete
10641  AG06001060 06 661          View Edit Delete
10642  AG06001061 06 661          View Edit Delete
10643  AG06001062 06 661          View Edit Delete
10644  AG06001063 06 661          View Edit Delete
10645  AG06001064 06 661          View Edit Delete
10646  AG06001065 06 661          View Edit Delete
10647  AG06001066 06 661          View Edit Delete
10648  AG06001067 06 661          View Edit Delete
10649  AG06001068 06 661          View Edit Delete

Page 145 of 373, showing 20 records out of 7458 total, starting on record 2881, ending on 2900

(default) 2 queries took 25 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 2880, 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 = 11116