Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9586  AG06000005 06 661          View Edit Delete
9594  AG06000013 06 661          View Edit Delete
9599  AG06000018 06 661          View Edit Delete
9597  AG06000016 06 661          View Edit Delete
9593  AG06000012 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete
9606  AG06000025 06 661          View Edit Delete
9602  AG06000021 06 661          View Edit Delete
9610  AG06000029 06 661          View Edit Delete
9615  AG06000034 06 661          View Edit Delete
9613  AG06000032 06 661          View Edit Delete
9609  AG06000028 06 661          View Edit Delete
9601  AG06000020 06 661          View Edit Delete
9623  AG06000042 06 661          View Edit Delete
9621  AG06000040 06 661          View Edit Delete
9617  AG06000036 06 661          View Edit Delete
9625  AG06000044 06 661          View Edit Delete
9624  AG06000043 06 661          View Edit Delete
9616  AG06000035 06 661          View Edit Delete
9600  AG06000019 06 661          View Edit Delete

Page 11 of 373, showing 20 records out of 7458 total, starting on record 201, ending on 220

(default) 2 queries took 25 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`.`insert_user` asc LIMIT 200, 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 = 11118