Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9630  AG06000049 06 661          View Edit Delete
9631  AG06000050 06 661          View Edit Delete
9632  AG06000051 06 661          View Edit Delete
9633  AG06000052 06 661          View Edit Delete
9634  AG06000053 06 661          View Edit Delete
9635  AG06000054 06 661          View Edit Delete
9636  AG06000055 06 661          View Edit Delete
9637  AG06000056 06 661          View Edit Delete
9638  AG06000057 06 661          View Edit Delete
9639  AG06000058 06 661          View Edit Delete
9640  AG06000059 06 661          View Edit Delete
9641  AG06000060 06 661          View Edit Delete
9642  AG06000061 06 661          View Edit Delete
9643  AG06000062 06 661          View Edit Delete
9644  AG06000063 06 661          View Edit Delete
9645  AG06000064 06 661          View Edit Delete
9646  AG06000065 06 661          View Edit Delete
9647  AG06000066 06 661          View Edit Delete
9648  AG06000067 06 661          View Edit Delete
9649  AG06000068 06 661          View Edit Delete

Page 95 of 373, showing 20 records out of 7458 total, starting on record 1881, ending on 1900

(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`.`id` asc LIMIT 1880, 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