Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9777  AG06000196 06 661          View Edit Delete
9781  AG06000200 06 661          View Edit Delete
9783  AG06000202 06 661          View Edit Delete
9782  AG06000201 06 661          View Edit Delete
9780  AG06000199 06 661          View Edit Delete
9776  AG06000195 06 661          View Edit Delete
9784  AG06000203 06 661          View Edit Delete
9655  AG06000074 06 661          View Edit Delete
9654  AG06000073 06 661          View Edit Delete
9657  AG06000076 06 661          View Edit Delete
9659  AG06000078 06 661          View Edit Delete
9658  AG06000077 06 661          View Edit Delete
9656  AG06000075 06 661          View Edit Delete
9653  AG06000072 06 661          View Edit Delete
9663  AG06000082 06 661          View Edit Delete
9662  AG06000081 06 661          View Edit Delete
9661  AG06000080 06 661          View Edit Delete
9665  AG06000084 06 661          View Edit Delete
9664  AG06000083 06 661          View Edit Delete
9660  AG06000079 06 661          View Edit Delete

Page 39 of 373, showing 20 records out of 7458 total, starting on record 761, ending on 780

(default) 2 queries took 23 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`.`modified` asc LIMIT 760, 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 = 11116