Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10390  AG06000809 06 661          View Edit Delete
10391  AG06000810 06 661          View Edit Delete
10392  AG06000811 06 661          View Edit Delete
10393  AG06000812 06 661          View Edit Delete
10394  AG06000813 06 661          View Edit Delete
10395  AG06000814 06 661          View Edit Delete
10396  AG06000815 06 661          View Edit Delete
10397  AG06000816 06 661          View Edit Delete
10398  AG06000817 06 661          View Edit Delete
10399  AG06000818 06 661          View Edit Delete
10400  AG06000819 06 661          View Edit Delete
10401  AG06000820 06 661          View Edit Delete
10402  AG06000821 06 661          View Edit Delete
10403  AG06000822 06 661          View Edit Delete
10404  AG06000823 06 661          View Edit Delete
10405  AG06000824 06 661          View Edit Delete
10406  AG06000825 06 661          View Edit Delete
10407  AG06000826 06 661          View Edit Delete
10408  AG06000827 06 661          View Edit Delete
10409  AG06000828 06 661          View Edit Delete

Page 133 of 373, showing 20 records out of 7458 total, starting on record 2641, ending on 2660

(default) 2 queries took 26 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` asc LIMIT 2640, 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 = 11117