Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9827  AG06000246 06 661          View Edit Delete
9826  AG06000245 06 661          View Edit Delete
9825  AG06000244 06 661          View Edit Delete
9824  AG06000243 06 661          View Edit Delete
9823  AG06000242 06 661          View Edit Delete
9822  AG06000241 06 661          View Edit Delete
9821  AG06000240 06 661          View Edit Delete
9820  AG06000239 06 661          View Edit Delete
9819  AG06000238 06 661          View Edit Delete
9818  AG06000237 06 661          View Edit Delete
9817  AG06000236 06 661          View Edit Delete
9816  AG06000235 06 661          View Edit Delete
9815  AG06000234 06 661          View Edit Delete
9814  AG06000233 06 661          View Edit Delete
9813  AG06000232 06 661          View Edit Delete
9812  AG06000231 06 661          View Edit Delete
9811  AG06000230 06 661          View Edit Delete
9810  AG06000229 06 661          View Edit Delete
9809  AG06000228 06 661          View Edit Delete
9808  AG06000227 06 661          View Edit Delete

Page 270 of 373, showing 20 records out of 7458 total, starting on record 5381, ending on 5400

(default) 2 queries took 37 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`.`id` desc LIMIT 5380, 20202020
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