Contractors

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

Page 136 of 373, showing 20 records out of 7458 total, starting on record 2701, ending on 2720

(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 LIMIT 2700, 2020209
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