Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9717  AG06000136 06 661          View Edit Delete
9712  AG06000131 06 661          View Edit Delete
9704  AG06000123 06 661          View Edit Delete
9701  AG06000120 06 661          View Edit Delete
9722  AG06000141 06 661          View Edit Delete
9723  AG06000142 06 661          View Edit Delete
9711  AG06000130 06 661          View Edit Delete
9726  AG06000145 06 661          View Edit Delete
9718  AG06000137 06 661          View Edit Delete
9715  AG06000134 06 661          View Edit Delete
9703  AG06000122 06 661          View Edit Delete
9702  AG06000121 06 661          View Edit Delete
9698  AG06000117 06 661          View Edit Delete
9613  AG06000032 06 661          View Edit Delete
9614  AG06000033 06 661          View Edit Delete
9615  AG06000034 06 661          View Edit Delete
9616  AG06000035 06 661          View Edit Delete
9617  AG06000036 06 661          View Edit Delete
9618  AG06000037 06 661          View Edit Delete
9620  AG06000039 06 661          View Edit Delete

Page 17 of 373, showing 20 records out of 7458 total, starting on record 321, ending on 340

(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`.`trader_id` desc LIMIT 320, 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 = 11118