Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9853  AG06000272 06 661          View Edit Delete
9855  AG06000274 06 661          View Edit Delete
9876  AG06000295 06 661          View Edit Delete
9879  AG06000298 06 661          View Edit Delete
9873  AG06000292 06 661          View Edit Delete
9877  AG06000296 06 661          View Edit Delete
9863  AG06000282 06 661          View Edit Delete
9872  AG06000291 06 661          View Edit Delete
9890  AG06000309 06 661          View Edit Delete
9883  AG06000302 06 661          View Edit Delete
9889  AG06000308 06 661          View Edit Delete
9884  AG06000303 06 661          View Edit Delete
9878  AG06000297 06 661          View Edit Delete
9871  AG06000290 06 661          View Edit Delete
9881  AG06000300 06 661          View Edit Delete
9882  AG06000301 06 661          View Edit Delete
9892  AG06000311 06 661          View Edit Delete
9894  AG06000313 06 661          View Edit Delete
9897  AG06000316 06 661          View Edit Delete
9893  AG06000312 06 661          View Edit Delete

Page 56 of 373, showing 20 records out of 7458 total, starting on record 1101, ending on 1120

(default) 2 queries took 27 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 1100, 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 = 11118