Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9730  AG06000149 06 661          View Edit Delete
10089  AG06000508 06 661          View Edit Delete
10090  AG06000509 06 661          View Edit Delete
10091  AG06000510 06 661          View Edit Delete
10141  AG06000560 06 661          View Edit Delete
9735  AG06000154 06 661          View Edit Delete
10093  AG06000512 06 661          View Edit Delete
9736  AG06000155 06 661          View Edit Delete
9870  AG06000289 06 661          View Edit Delete
9871  AG06000290 06 661          View Edit Delete
10095  AG06000514 06 661          View Edit Delete
9872  AG06000291 06 661          View Edit Delete
9873  AG06000292 06 661          View Edit Delete
9874  AG06000293 06 661          View Edit Delete
9875  AG06000294 06 661          View Edit Delete
9878  AG06000297 06 661          View Edit Delete
9879  AG06000298 06 661          View Edit Delete
9880  AG06000299 06 661          View Edit Delete
9881  AG06000300 06 661          View Edit Delete
9883  AG06000302 06 661          View Edit Delete

Page 41 of 373, showing 20 records out of 7458 total, starting on record 801, ending on 820

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