Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10467  AG06000886 06 661          View Edit Delete
10466  AG06000885 06 661          View Edit Delete
10465  AG06000884 06 661          View Edit Delete
10464  AG06000883 06 661          View Edit Delete
10463  AG06000882 06 661          View Edit Delete
10462  AG06000881 06 661          View Edit Delete
10461  AG06000880 06 661          View Edit Delete
10460  AG06000879 06 661          View Edit Delete
10459  AG06000878 06 661          View Edit Delete
10458  AG06000877 06 661          View Edit Delete
10457  AG06000876 06 661          View Edit Delete
10456  AG06000875 06 661          View Edit Delete
10455  AG06000874 06 661          View Edit Delete
10454  AG06000873 06 661          View Edit Delete
10453  AG06000872 06 661          View Edit Delete
10452  AG06000871 06 661          View Edit Delete
10451  AG06000870 06 661          View Edit Delete
10450  AG06000869 06 661          View Edit Delete
10449  AG06000868 06 661          View Edit Delete
10448  AG06000867 06 661          View Edit Delete

Page 238 of 373, showing 20 records out of 7458 total, starting on record 4741, ending on 4760

(default) 2 queries took 34 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`.`id` desc LIMIT 4740, 20202017
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