Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9810  AG06000229 06 661          View Edit Delete
9809  AG06000228 06 661          View Edit Delete
9807  AG06000226 06 661          View Edit Delete
9812  AG06000231 06 661          View Edit Delete
9814  AG06000233 06 661          View Edit Delete
9813  AG06000232 06 661          View Edit Delete
9811  AG06000230 06 661          View Edit Delete
9816  AG06000235 06 661          View Edit Delete
9818  AG06000237 06 661          View Edit Delete
9817  AG06000236 06 661          View Edit Delete
9815  AG06000234 06 661          View Edit Delete
9819  AG06000238 06 661          View Edit Delete
9821  AG06000240 06 661          View Edit Delete
9781  AG06000200 06 661          View Edit Delete
9820  AG06000239 06 661          View Edit Delete
9822  AG06000241 06 661          View Edit Delete
9823  AG06000242 06 661          View Edit Delete
9824  AG06000243 06 661          View Edit Delete
10310  AG06000729 06 661          View Edit Delete
10295  AG06000714 06 661          View Edit Delete

Page 51 of 373, showing 20 records out of 7458 total, starting on record 1001, ending on 1020

(default) 2 queries took 34 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 1000, 20202013
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 = 11121