Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10528  AG06000947 06 661          View Edit Delete
10527  AG06000946 06 661          View Edit Delete
10526  AG06000945 06 661          View Edit Delete
10525  AG06000944 06 661          View Edit Delete
10524  AG06000943 06 661          View Edit Delete
10523  AG06000942 06 661          View Edit Delete
10522  AG06000941 06 661          View Edit Delete
10521  AG06000940 06 661          View Edit Delete
10520  AG06000939 06 661          View Edit Delete
10519  AG06000938 06 661          View Edit Delete
10518  AG06000937 06 661          View Edit Delete
10517  AG06000936 06 661          View Edit Delete
10516  AG06000935 06 661          View Edit Delete
10515  AG06000934 06 661          View Edit Delete
10514  AG06000933 06 661          View Edit Delete
10513  AG06000932 06 661          View Edit Delete
10512  AG06000931 06 661          View Edit Delete
10511  AG06000930 06 661          View Edit Delete
10510  AG06000929 06 661          View Edit Delete
10509  AG06000928 06 661          View Edit Delete

Page 20 of 373, showing 20 records out of 7458 total, starting on record 381, ending on 400

(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`.`farmer_id` desc LIMIT 380, 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