Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9620  AG06000039 06 661          View Edit Delete
9621  AG06000040 06 661          View Edit Delete
9622  AG06000041 06 661          View Edit Delete
9623  AG06000042 06 661          View Edit Delete
9624  AG06000043 06 661          View Edit Delete
9625  AG06000044 06 661          View Edit Delete
9626  AG06000045 06 661          View Edit Delete
9627  AG06000046 06 661          View Edit Delete
9628  AG06000047 06 661          View Edit Delete
9629  AG06000048 06 661          View Edit Delete
9630  AG06000049 06 661          View Edit Delete
9631  AG06000050 06 661          View Edit Delete
9632  AG06000051 06 661          View Edit Delete
9633  AG06000052 06 661          View Edit Delete
9634  AG06000053 06 661          View Edit Delete
9635  AG06000054 06 661          View Edit Delete
9636  AG06000055 06 661          View Edit Delete
9637  AG06000056 06 661          View Edit Delete
9638  AG06000057 06 661          View Edit Delete
9640  AG06000059 06 661          View Edit Delete

Page 18 of 373, showing 20 records out of 7458 total, starting on record 341, ending on 360

(default) 2 queries took 33 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 340, 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 = 11126