Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9664  AG06000083 06 661          View Edit Delete
9660  AG06000079 06 661          View Edit Delete
9652  AG06000071 06 661          View Edit Delete
9672  AG06000091 06 661          View Edit Delete
9668  AG06000087 06 661          View Edit Delete
9667  AG06000086 06 661          View Edit Delete
9651  AG06000070 06 661          View Edit Delete
9616  AG06000035 06 661          View Edit Delete
9611  AG06000030 06 661          View Edit Delete
9609  AG06000028 06 661          View Edit Delete
9605  AG06000024 06 661          View Edit Delete
9598  AG06000017 06 661          View Edit Delete
9590  AG06000009 06 661          View Edit Delete
9624  AG06000043 06 661          View Edit Delete
9627  AG06000046 06 661          View Edit Delete
9623  AG06000042 06 661          View Edit Delete
9615  AG06000034 06 661          View Edit Delete
9614  AG06000033 06 661          View Edit Delete
9613  AG06000032 06 661          View Edit Delete
9612  AG06000031 06 661          View Edit Delete

Page 18 of 373, showing 20 records out of 7458 total, starting on record 341, ending on 360

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