Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10228  AG06000647 06 661          View Edit Delete
10227  AG06000646 06 661          View Edit Delete
10226  AG06000645 06 661          View Edit Delete
10225  AG06000644 06 661          View Edit Delete
10224  AG06000643 06 661          View Edit Delete
10223  AG06000642 06 661          View Edit Delete
10222  AG06000641 06 661          View Edit Delete
10221  AG06000640 06 661          View Edit Delete
10220  AG06000639 06 661          View Edit Delete
10219  AG06000638 06 661          View Edit Delete
10218  AG06000637 06 661          View Edit Delete
10217  AG06000636 06 661          View Edit Delete
10216  AG06000635 06 661          View Edit Delete
10215  AG06000634 06 661          View Edit Delete
10214  AG06000633 06 661          View Edit Delete
10213  AG06000632 06 661          View Edit Delete
10212  AG06000631 06 661          View Edit Delete
10211  AG06000630 06 661          View Edit Delete
10210  AG06000629 06 661          View Edit Delete
10209  AG06000628 06 661          View Edit Delete

Page 35 of 373, showing 20 records out of 7458 total, starting on record 681, ending on 700

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