Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9796  AG06000215 06 661          View Edit Delete
9795  AG06000214 06 661          View Edit Delete
9798  AG06000217 06 661          View Edit Delete
9797  AG06000216 06 661          View Edit Delete
9800  AG06000219 06 661          View Edit Delete
9799  AG06000218 06 661          View Edit Delete
9802  AG06000221 06 661          View Edit Delete
9801  AG06000220 06 661          View Edit Delete
9804  AG06000223 06 661          View Edit Delete
9803  AG06000222 06 661          View Edit Delete
9806  AG06000225 06 661          View Edit Delete
9805  AG06000224 06 661          View Edit Delete
9808  AG06000227 06 661          View Edit Delete
9807  AG06000226 06 661          View Edit Delete
9810  AG06000229 06 661          View Edit Delete
9809  AG06000228 06 661          View Edit Delete
9812  AG06000231 06 661          View Edit Delete
9811  AG06000230 06 661          View Edit Delete
9814  AG06000233 06 661          View Edit Delete
9813  AG06000232 06 661          View Edit Delete

Page 36 of 373, showing 20 records out of 7458 total, starting on record 701, ending on 720

(default) 2 queries took 38 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 700, 20202011
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 = 11127