Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10167  AG06000586 06 661          View Edit Delete
10168  AG06000587 06 661          View Edit Delete
9614  AG06000033 06 661          View Edit Delete
10170  AG06000589 06 661          View Edit Delete
10171  AG06000590 06 661          View Edit Delete
10172  AG06000591 06 661          View Edit Delete
10173  AG06000592 06 661          View Edit Delete
10174  AG06000593 06 661          View Edit Delete
10175  AG06000594 06 661          View Edit Delete
10176  AG06000595 06 661          View Edit Delete
10177  AG06000596 06 661          View Edit Delete
10178  AG06000597 06 661          View Edit Delete
10179  AG06000598 06 661          View Edit Delete
10354  AG06000773 06 661          View Edit Delete
9606  AG06000025 06 661          View Edit Delete
9597  AG06000016 06 661          View Edit Delete
9596  AG06000015 06 661          View Edit Delete
10142  AG06000561 06 661          View Edit Delete
10347  AG06000766 06 661          View Edit Delete
10326  AG06000745 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 25 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 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 = 11117