Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9699  AG06000118 06 661          View Edit Delete
9713  AG06000132 06 661          View Edit Delete
9712  AG06000131 06 661          View Edit Delete
9709  AG06000128 06 661          View Edit Delete
9715  AG06000134 06 661          View Edit Delete
9717  AG06000136 06 661          View Edit Delete
10236  AG06000655 06 661          View Edit Delete
10239  AG06000658 06 661          View Edit Delete
10237  AG06000656 06 661          View Edit Delete
10240  AG06000659 06 661          View Edit Delete
9716  AG06000135 06 661          View Edit Delete
9714  AG06000133 06 661          View Edit Delete
9708  AG06000127 06 661          View Edit Delete
9698  AG06000117 06 661          View Edit Delete
9666  AG06000085 06 661          View Edit Delete
9719  AG06000138 06 661          View Edit Delete
9718  AG06000137 06 661          View Edit Delete
9665  AG06000084 06 661          View Edit Delete
10198  AG06000617 06 661          View Edit Delete
10005  AG06000424 06 661          View Edit Delete

Page 50 of 373, showing 20 records out of 7458 total, starting on record 981, ending on 1000

(default) 2 queries took 24 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`.`trader_id` desc LIMIT 980, 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 = 11116