Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10218  AG06000637 06 661          View Edit Delete
10220  AG06000639 06 661          View Edit Delete
10221  AG06000640 06 661          View Edit Delete
10684  AG06001103 06 661          View Edit Delete
10222  AG06000641 06 661          View Edit Delete
10223  AG06000642 06 661          View Edit Delete
10224  AG06000643 06 661          View Edit Delete
10225  AG06000644 06 661          View Edit Delete
10226  AG06000645 06 661          View Edit Delete
10191  AG06000610 06 661          View Edit Delete
10114  AG06000533 06 661          View Edit Delete
10685  AG06001104 06 661          View Edit Delete
10687  AG06001106 06 661          View Edit Delete
10227  AG06000646 06 661          View Edit Delete
10228  AG06000647 06 661          View Edit Delete
10229  AG06000648 06 661          View Edit Delete
10014  AG06000433 06 661          View Edit Delete
10012  AG06000431 06 661          View Edit Delete
10233  AG06000652 06 661          View Edit Delete
10232  AG06000651 06 661          View Edit Delete

Page 64 of 373, showing 20 records out of 7458 total, starting on record 1261, ending on 1280

(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`.`trader_id` desc LIMIT 1260, 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