Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9967  AG06000386 06 661          View Edit Delete
9972  AG06000391 06 661          View Edit Delete
9974  AG06000393 06 661          View Edit Delete
9973  AG06000392 06 661          View Edit Delete
9971  AG06000390 06 661          View Edit Delete
9976  AG06000395 06 661          View Edit Delete
9978  AG06000397 06 661          View Edit Delete
9977  AG06000396 06 661          View Edit Delete
9975  AG06000394 06 661          View Edit Delete
9980  AG06000399 06 661          View Edit Delete
9982  AG06000401 06 661          View Edit Delete
9981  AG06000400 06 661          View Edit Delete
9979  AG06000398 06 661          View Edit Delete
9983  AG06000402 06 661          View Edit Delete
9984  AG06000403 06 661          View Edit Delete
9655  AG06000074 06 661          View Edit Delete
10339  AG06000758 06 661          View Edit Delete
10470  AG06000889 06 661          View Edit Delete
9704  AG06000123 06 661          View Edit Delete
9963  AG06000382 06 661          View Edit Delete

Page 59 of 373, showing 20 records out of 7458 total, starting on record 1161, ending on 1180

(default) 2 queries took 26 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`.`company_cd` desc LIMIT 1160, 2020209
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