Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9674  AG06000093 06 661          View Edit Delete
9677  AG06000096 06 661          View Edit Delete
9673  AG06000092 06 661          View Edit Delete
9665  AG06000084 06 661          View Edit Delete
9649  AG06000068 06 661          View Edit Delete
9617  AG06000036 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete
9590  AG06000009 06 661          View Edit Delete
9588  AG06000007 06 661          View Edit Delete
9597  AG06000016 06 661          View Edit Delete
9593  AG06000012 06 661          View Edit Delete
9601  AG06000020 06 661          View Edit Delete
9606  AG06000025 06 661          View Edit Delete
9604  AG06000023 06 661          View Edit Delete
9600  AG06000019 06 661          View Edit Delete
9592  AG06000011 06 661          View Edit Delete
9612  AG06000031 06 661          View Edit Delete
9608  AG06000027 06 661          View Edit Delete
9607  AG06000026 06 661          View Edit Delete
9591  AG06000010 06 661          View Edit Delete

Page 15 of 373, showing 20 records out of 7458 total, starting on record 281, ending on 300

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