Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9675  AG06000094 06 661          View Edit Delete
9676  AG06000095 06 661          View Edit Delete
9677  AG06000096 06 661          View Edit Delete
9678  AG06000097 06 661          View Edit Delete
9680  AG06000099 06 661          View Edit Delete
9797  AG06000216 06 661          View Edit Delete
9796  AG06000215 06 661          View Edit Delete
9792  AG06000211 06 661          View Edit Delete
9808  AG06000227 06 661          View Edit Delete
9805  AG06000224 06 661          View Edit Delete
9804  AG06000223 06 661          View Edit Delete
9809  AG06000228 06 661          View Edit Delete
9807  AG06000226 06 661          View Edit Delete
9685  AG06000104 06 661          View Edit Delete
9687  AG06000106 06 661          View Edit Delete
9688  AG06000107 06 661          View Edit Delete
9691  AG06000110 06 661          View Edit Delete
9689  AG06000108 06 661          View Edit Delete
9813  AG06000232 06 661          View Edit Delete
9814  AG06000233 06 661          View Edit Delete

Page 20 of 373, showing 20 records out of 7458 total, starting on record 381, ending on 400

(default) 2 queries took 25 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 380, 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 = 11118