Contractors

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

Page 232 of 373, showing 20 records out of 7458 total, starting on record 4621, ending on 4640

(default) 2 queries took 39 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`.`id` desc LIMIT 4620, 20202018
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 = 11121