Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10108  AG06000527 06 661          View Edit Delete
10107  AG06000526 06 661          View Edit Delete
10106  AG06000525 06 661          View Edit Delete
10105  AG06000524 06 661          View Edit Delete
10104  AG06000523 06 661          View Edit Delete
10103  AG06000522 06 661          View Edit Delete
10102  AG06000521 06 661          View Edit Delete
10101  AG06000520 06 661          View Edit Delete
10100  AG06000519 06 661          View Edit Delete
10099  AG06000518 06 661          View Edit Delete
10098  AG06000517 06 661          View Edit Delete
10097  AG06000516 06 661          View Edit Delete
10096  AG06000515 06 661          View Edit Delete
10095  AG06000514 06 661          View Edit Delete
10094  AG06000513 06 661          View Edit Delete
10093  AG06000512 06 661          View Edit Delete
10092  AG06000511 06 661          View Edit Delete
10091  AG06000510 06 661          View Edit Delete
10090  AG06000509 06 661          View Edit Delete
10089  AG06000508 06 661          View Edit Delete

Page 41 of 373, showing 20 records out of 7458 total, starting on record 801, ending on 820

(default) 2 queries took 41 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 800, 20202011
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 = 11130