Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9979  AG06000398 06 661          View Edit Delete
9621  AG06000040 06 661          View Edit Delete
9767  AG06000186 06 661          View Edit Delete
9619  AG06000038 06 661          View Edit Delete
9853  AG06000272 06 661          View Edit Delete
9983  AG06000402 06 661          View Edit Delete
9849  AG06000268 06 661          View Edit Delete
9857  AG06000276 06 661          View Edit Delete
9855  AG06000274 06 661          View Edit Delete
9852  AG06000271 06 661          View Edit Delete
9847  AG06000266 06 661          View Edit Delete
9851  AG06000270 06 661          View Edit Delete
9856  AG06000275 06 661          View Edit Delete
9771  AG06000190 06 661          View Edit Delete
9623  AG06000042 06 661          View Edit Delete
9626  AG06000045 06 661          View Edit Delete
9985  AG06000404 06 661          View Edit Delete
9858  AG06000277 06 661          View Edit Delete
9627  AG06000046 06 661          View Edit Delete
9629  AG06000048 06 661          View Edit Delete

Page 35 of 373, showing 20 records out of 7458 total, starting on record 681, ending on 700

(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 680, 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