Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9988  AG06000407 06 661          View Edit Delete
9987  AG06000406 06 661          View Edit Delete
9986  AG06000405 06 661          View Edit Delete
9985  AG06000404 06 661          View Edit Delete
9984  AG06000403 06 661          View Edit Delete
9983  AG06000402 06 661          View Edit Delete
9982  AG06000401 06 661          View Edit Delete
9981  AG06000400 06 661          View Edit Delete
9980  AG06000399 06 661          View Edit Delete
9979  AG06000398 06 661          View Edit Delete
9978  AG06000397 06 661          View Edit Delete
9977  AG06000396 06 661          View Edit Delete
9976  AG06000395 06 661          View Edit Delete
9975  AG06000394 06 661          View Edit Delete
9974  AG06000393 06 661          View Edit Delete
9973  AG06000392 06 661          View Edit Delete
9972  AG06000391 06 661          View Edit Delete
9971  AG06000390 06 661          View Edit Delete
9970  AG06000389 06 661          View Edit Delete
9969  AG06000388 06 661          View Edit Delete

Page 47 of 373, showing 20 records out of 7458 total, starting on record 921, ending on 940

(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`.`farmer_id` desc LIMIT 920, 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 = 11116