Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10330  AG06000749 06 661          View Edit Delete
10331  AG06000750 06 661          View Edit Delete
10332  AG06000751 06 661          View Edit Delete
10333  AG06000752 06 661          View Edit Delete
10334  AG06000753 06 661          View Edit Delete
10335  AG06000754 06 661          View Edit Delete
10336  AG06000755 06 661          View Edit Delete
10337  AG06000756 06 661          View Edit Delete
10338  AG06000757 06 661          View Edit Delete
10339  AG06000758 06 661          View Edit Delete
10340  AG06000759 06 661          View Edit Delete
10341  AG06000760 06 661          View Edit Delete
10342  AG06000761 06 661          View Edit Delete
10343  AG06000762 06 661          View Edit Delete
10344  AG06000763 06 661          View Edit Delete
10345  AG06000764 06 661          View Edit Delete
10346  AG06000765 06 661          View Edit Delete
10347  AG06000766 06 661          View Edit Delete
10348  AG06000767 06 661          View Edit Delete
10349  AG06000768 06 661          View Edit Delete

Page 130 of 373, showing 20 records out of 7458 total, starting on record 2581, ending on 2600

(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 2580, 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