Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9759  AG06000178 06 661          View Edit Delete
9757  AG06000176 06 661          View Edit Delete
9762  AG06000181 06 661          View Edit Delete
9764  AG06000183 06 661          View Edit Delete
9763  AG06000182 06 661          View Edit Delete
9761  AG06000180 06 661          View Edit Delete
9765  AG06000184 06 661          View Edit Delete
6995  AG01003292 01 010          View Edit Delete
6996  AG02000060 02 51          View Edit Delete
6997  AG01003293 01 010          View Edit Delete
6998  AG02000061 02 51          View Edit Delete
9654  AG06000073 06 661          View Edit Delete
9653  AG06000072 06 661          View Edit Delete
9652  AG06000071 06 661          View Edit Delete
9658  AG06000077 06 661          View Edit Delete
9660  AG06000079 06 661          View Edit Delete
9659  AG06000078 06 661          View Edit Delete
9657  AG06000076 06 661          View Edit Delete
9662  AG06000081 06 661          View Edit Delete
9661  AG06000080 06 661          View Edit Delete

Page 25 of 373, showing 20 records out of 7458 total, starting on record 481, ending on 500

(default) 2 queries took 23 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`.`modified` asc LIMIT 480, 2020206
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