Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9986  AG06000405 06 661          View Edit Delete
9988  AG06000407 06 661          View Edit Delete
9976  AG06000395 06 661          View Edit Delete
9960  AG06000379 06 661          View Edit Delete
9955  AG06000374 06 661          View Edit Delete
10494  AG06000913 06 661          View Edit Delete
9892  AG06000311 06 661          View Edit Delete
9992  AG06000411 06 661          View Edit Delete
9993  AG06000412 06 661          View Edit Delete
9980  AG06000399 06 661          View Edit Delete
9983  AG06000402 06 661          View Edit Delete
9982  AG06000401 06 661          View Edit Delete
9985  AG06000404 06 661          View Edit Delete
9984  AG06000403 06 661          View Edit Delete
10525  AG06000944 06 661          View Edit Delete
9987  AG06000406 06 661          View Edit Delete
9989  AG06000408 06 661          View Edit Delete
9895  AG06000314 06 661          View Edit Delete
9896  AG06000315 06 661          View Edit Delete
9893  AG06000312 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 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 1140, 2020208
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