Contractors

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

Page 26 of 373, showing 20 records out of 7458 total, starting on record 501, ending on 520

(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 ORDER BY `Contractor`.`farmer_id` desc LIMIT 500, 2020208
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