Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10468  AG06000887 06 661          View Edit Delete
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

Page 23 of 373, showing 20 records out of 7458 total, starting on record 441, ending on 460

(default) 2 queries took 23 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`.`farmer_id` desc LIMIT 440, 2020207
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