Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9829  AG06000248 06 661          View Edit Delete
9834  AG06000253 06 661          View Edit Delete
9832  AG06000251 06 661          View Edit Delete
9837  AG06000256 06 661          View Edit Delete
9838  AG06000257 06 661          View Edit Delete
9841  AG06000260 06 661          View Edit Delete
9849  AG06000268 06 661          View Edit Delete
9850  AG06000269 06 661          View Edit Delete
9853  AG06000272 06 661          View Edit Delete
9851  AG06000270 06 661          View Edit Delete
9857  AG06000276 06 661          View Edit Delete
9855  AG06000274 06 661          View Edit Delete
9860  AG06000279 06 661          View Edit Delete
9858  AG06000277 06 661          View Edit Delete
9864  AG06000283 06 661          View Edit Delete
9865  AG06000284 06 661          View Edit Delete
9868  AG06000287 06 661          View Edit Delete
9866  AG06000285 06 661          View Edit Delete
9872  AG06000291 06 661          View Edit Delete
9870  AG06000289 06 661          View Edit Delete

Page 39 of 373, showing 20 records out of 7458 total, starting on record 761, ending on 780

(default) 2 queries took 24 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`.`trader_id` desc LIMIT 760, 2020207
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