Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9648  AG06000067 06 661          View Edit Delete
9646  AG06000065 06 661          View Edit Delete
9634  AG06000053 06 661          View Edit Delete
9631  AG06000050 06 661          View Edit Delete
9655  AG06000074 06 661          View Edit Delete
9643  AG06000062 06 661          View Edit Delete
9642  AG06000061 06 661          View Edit Delete
9664  AG06000083 06 661          View Edit Delete
9659  AG06000078 06 661          View Edit Delete
9650  AG06000069 06 661          View Edit Delete
9647  AG06000066 06 661          View Edit Delete
9670  AG06000089 06 661          View Edit Delete
9658  AG06000077 06 661          View Edit Delete
9657  AG06000076 06 661          View Edit Delete
9678  AG06000097 06 661          View Edit Delete
9665  AG06000084 06 661          View Edit Delete
9662  AG06000081 06 661          View Edit Delete
9649  AG06000068 06 661          View Edit Delete
9679  AG06000098 06 661          View Edit Delete
9676  AG06000095 06 661          View Edit Delete

Page 16 of 373, showing 20 records out of 7458 total, starting on record 301, ending on 320

(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`.`trader_id` desc LIMIT 300, 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