Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10346  AG06000765 06 661          View Edit Delete
10344  AG06000763 06 661          View Edit Delete
10341  AG06000760 06 661          View Edit Delete
10335  AG06000754 06 661          View Edit Delete
10324  AG06000743 06 661          View Edit Delete
10296  AG06000715 06 661          View Edit Delete
10350  AG06000769 06 661          View Edit Delete
10357  AG06000776 06 661          View Edit Delete
10361  AG06000780 06 661          View Edit Delete
10359  AG06000778 06 661          View Edit Delete
10356  AG06000775 06 661          View Edit Delete
10349  AG06000768 06 661          View Edit Delete
10363  AG06000782 06 661          View Edit Delete
10362  AG06000781 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete
9977  AG06000396 06 661          View Edit Delete
10183  AG06000602 06 661          View Edit Delete
10295  AG06000714 06 661          View Edit Delete
10347  AG06000766 06 661          View Edit Delete
10348  AG06000767 06 661          View Edit Delete

Page 50 of 373, showing 20 records out of 7458 total, starting on record 981, ending on 1000

(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`.`update_user` asc LIMIT 980, 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