Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10125  AG06000544 06 661          View Edit Delete
10126  AG06000545 06 661          View Edit Delete
9638  AG06000057 06 661          View Edit Delete
10180  AG06000599 06 661          View Edit Delete
10178  AG06000597 06 661          View Edit Delete
9910  AG06000329 06 661          View Edit Delete
9911  AG06000330 06 661          View Edit Delete
9912  AG06000331 06 661          View Edit Delete
9617  AG06000036 06 661          View Edit Delete
10113  AG06000532 06 661          View Edit Delete
9777  AG06000196 06 661          View Edit Delete
9913  AG06000332 06 661          View Edit Delete
10183  AG06000602 06 661          View Edit Delete
9778  AG06000197 06 661          View Edit Delete
10133  AG06000552 06 661          View Edit Delete
10134  AG06000553 06 661          View Edit Delete
10182  AG06000601 06 661          View Edit Delete
10175  AG06000594 06 661          View Edit Delete
10173  AG06000592 06 661          View Edit Delete
9914  AG06000333 06 661          View Edit Delete

Page 43 of 373, showing 20 records out of 7458 total, starting on record 841, ending on 860

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