Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10290  AG06000709 06 661          View Edit Delete
10291  AG06000710 06 661          View Edit Delete
10292  AG06000711 06 661          View Edit Delete
10293  AG06000712 06 661          View Edit Delete
10294  AG06000713 06 661          View Edit Delete
10295  AG06000714 06 661          View Edit Delete
10296  AG06000715 06 661          View Edit Delete
10297  AG06000716 06 661          View Edit Delete
10298  AG06000717 06 661          View Edit Delete
10299  AG06000718 06 661          View Edit Delete
10300  AG06000719 06 661          View Edit Delete
10301  AG06000720 06 661          View Edit Delete
10302  AG06000721 06 661          View Edit Delete
10303  AG06000722 06 661          View Edit Delete
10304  AG06000723 06 661          View Edit Delete
10305  AG06000724 06 661          View Edit Delete
10306  AG06000725 06 661          View Edit Delete
10307  AG06000726 06 661          View Edit Delete
10308  AG06000727 06 661          View Edit Delete
10309  AG06000728 06 661          View Edit Delete

Page 128 of 373, showing 20 records out of 7458 total, starting on record 2541, ending on 2560

(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`.`id` asc LIMIT 2540, 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 = 11117