Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9660  AG06000079 06 661          View Edit Delete
9656  AG06000075 06 661          View Edit Delete
9648  AG06000067 06 661          View Edit Delete
9670  AG06000089 06 661          View Edit Delete
9668  AG06000087 06 661          View Edit Delete
9664  AG06000083 06 661          View Edit Delete
9672  AG06000091 06 661          View Edit Delete
9677  AG06000096 06 661          View Edit Delete
9675  AG06000094 06 661          View Edit Delete
9671  AG06000090 06 661          View Edit Delete
9663  AG06000082 06 661          View Edit Delete
9647  AG06000066 06 661          View Edit Delete
9684  AG06000103 06 661          View Edit Delete
9680  AG06000099 06 661          View Edit Delete
9688  AG06000107 06 661          View Edit Delete
9691  AG06000110 06 661          View Edit Delete
9687  AG06000106 06 661          View Edit Delete
9679  AG06000098 06 661          View Edit Delete
9678  AG06000097 06 661          View Edit Delete
9646  AG06000065 06 661          View Edit Delete

Page 13 of 373, showing 20 records out of 7458 total, starting on record 241, ending on 260

(default) 2 queries took 23 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`.`insert_user` asc LIMIT 240, 2020206
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