Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9950  AG06000369 06 661          View Edit Delete
9949  AG06000368 06 661          View Edit Delete
9947  AG06000366 06 661          View Edit Delete
9952  AG06000371 06 661          View Edit Delete
9954  AG06000373 06 661          View Edit Delete
9953  AG06000372 06 661          View Edit Delete
9951  AG06000370 06 661          View Edit Delete
9956  AG06000375 06 661          View Edit Delete
9958  AG06000377 06 661          View Edit Delete
9957  AG06000376 06 661          View Edit Delete
9955  AG06000374 06 661          View Edit Delete
9960  AG06000379 06 661          View Edit Delete
9962  AG06000381 06 661          View Edit Delete
9961  AG06000380 06 661          View Edit Delete
9959  AG06000378 06 661          View Edit Delete
9963  AG06000382 06 661          View Edit Delete
9964  AG06000383 06 661          View Edit Delete
10060  AG06000479 06 661          View Edit Delete
10073  AG06000492 06 661          View Edit Delete
9943  AG06000362 06 661          View Edit Delete

Page 58 of 373, showing 20 records out of 7458 total, starting on record 1141, ending on 1160

(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 1140, 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