Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10670  AG06001089 06 661          View Edit Delete
10671  AG06001090 06 661          View Edit Delete
10672  AG06001091 06 661          View Edit Delete
10673  AG06001092 06 661          View Edit Delete
10674  AG06001093 06 661          View Edit Delete
10675  AG06001094 06 661          View Edit Delete
10676  AG06001095 06 661          View Edit Delete
10677  AG06001096 06 661          View Edit Delete
10678  AG06001097 06 661          View Edit Delete
10679  AG06001098 06 661          View Edit Delete
10680  AG06001099 06 661          View Edit Delete
10681  AG06001100 06 661          View Edit Delete
10682  AG06001101 06 661          View Edit Delete
10683  AG06001102 06 661          View Edit Delete
10684  AG06001103 06 661          View Edit Delete
10685  AG06001104 06 661          View Edit Delete
10686  AG06001105 06 661          View Edit Delete
10687  AG06001106 06 661          View Edit Delete
10688  AG06001107 06 661          View Edit Delete
10689  AG06001108 06 661          View Edit Delete

Page 147 of 373, showing 20 records out of 7458 total, starting on record 2921, ending on 2940

(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 LIMIT 2920, 20202010
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