Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9868  AG06000287 06 661          View Edit Delete
9870  AG06000289 06 661          View Edit Delete
9869  AG06000288 06 661          View Edit Delete
9867  AG06000286 06 661          View Edit Delete
9872  AG06000291 06 661          View Edit Delete
9874  AG06000293 06 661          View Edit Delete
9873  AG06000292 06 661          View Edit Delete
9871  AG06000290 06 661          View Edit Delete
9876  AG06000295 06 661          View Edit Delete
9878  AG06000297 06 661          View Edit Delete
9877  AG06000296 06 661          View Edit Delete
9875  AG06000294 06 661          View Edit Delete
9879  AG06000298 06 661          View Edit Delete
9880  AG06000299 06 661          View Edit Delete
9642  AG06000061 06 661          View Edit Delete
10152  AG06000571 06 661          View Edit Delete
10153  AG06000572 06 661          View Edit Delete
9884  AG06000303 06 661          View Edit Delete
9882  AG06000301 06 661          View Edit Delete
9860  AG06000279 06 661          View Edit Delete

Page 54 of 373, showing 20 records out of 7458 total, starting on record 1061, ending on 1080

(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`.`company_cd` desc LIMIT 1060, 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