Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9940  AG06000359 06 661          View Edit Delete
9942  AG06000361 06 661          View Edit Delete
9943  AG06000362 06 661          View Edit Delete
9946  AG06000365 06 661          View Edit Delete
9947  AG06000366 06 661          View Edit Delete
9949  AG06000368 06 661          View Edit Delete
9950  AG06000369 06 661          View Edit Delete
9952  AG06000371 06 661          View Edit Delete
9953  AG06000372 06 661          View Edit Delete
9955  AG06000374 06 661          View Edit Delete
9956  AG06000375 06 661          View Edit Delete
9957  AG06000376 06 661          View Edit Delete
9960  AG06000379 06 661          View Edit Delete
9961  AG06000380 06 661          View Edit Delete
9962  AG06000381 06 661          View Edit Delete
9963  AG06000382 06 661          View Edit Delete
9964  AG06000383 06 661          View Edit Delete
9965  AG06000384 06 661          View Edit Delete
9967  AG06000386 06 661          View Edit Delete
9968  AG06000387 06 661          View Edit Delete

Page 29 of 373, showing 20 records out of 7458 total, starting on record 561, ending on 580

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