Contractors

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

Page 29 of 373, showing 20 records out of 7458 total, starting on record 561, ending on 580

(default) 2 queries took 26 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`.`farmer_id` desc LIMIT 560, 2020208
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 = 11118