Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9616  AG06000035 06 661          View Edit Delete
9600  AG06000019 06 661          View Edit Delete
9634  AG06000053 06 661          View Edit Delete
9642  AG06000061 06 661          View Edit Delete
9647  AG06000066 06 661          View Edit Delete
9645  AG06000064 06 661          View Edit Delete
9641  AG06000060 06 661          View Edit Delete
9633  AG06000052 06 661          View Edit Delete
9655  AG06000074 06 661          View Edit Delete
9653  AG06000072 06 661          View Edit Delete
9649  AG06000068 06 661          View Edit Delete
9657  AG06000076 06 661          View Edit Delete
9662  AG06000081 06 661          View Edit Delete
9660  AG06000079 06 661          View Edit Delete
9656  AG06000075 06 661          View Edit Delete
9648  AG06000067 06 661          View Edit Delete
9632  AG06000051 06 661          View Edit Delete
9664  AG06000083 06 661          View Edit Delete
9663  AG06000082 06 661          View Edit Delete
9631  AG06000050 06 661          View Edit Delete

Page 12 of 373, showing 20 records out of 7458 total, starting on record 221, ending on 240

(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`.`insert_user` asc LIMIT 220, 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