Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10406  AG06000825 06 661          View Edit Delete
10404  AG06000823 06 661          View Edit Delete
10401  AG06000820 06 661          View Edit Delete
10394  AG06000813 06 661          View Edit Delete
10381  AG06000800 06 661          View Edit Delete
10349  AG06000768 06 661          View Edit Delete
10410  AG06000829 06 661          View Edit Delete
10417  AG06000836 06 661          View Edit Delete
10421  AG06000840 06 661          View Edit Delete
10419  AG06000838 06 661          View Edit Delete
10416  AG06000835 06 661          View Edit Delete
10409  AG06000828 06 661          View Edit Delete
10423  AG06000842 06 661          View Edit Delete
10422  AG06000841 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete
9982  AG06000401 06 661          View Edit Delete
10220  AG06000639 06 661          View Edit Delete
10348  AG06000767 06 661          View Edit Delete
10407  AG06000826 06 661          View Edit Delete
10408  AG06000827 06 661          View Edit Delete

Page 50 of 373, showing 20 records out of 7458 total, starting on record 981, ending on 1000

(default) 2 queries took 38 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`.`insert_user` asc LIMIT 980, 20202012
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 = 11126