Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9828  AG06000247 06 661          View Edit Delete
9831  AG06000250 06 661          View Edit Delete
9827  AG06000246 06 661          View Edit Delete
9819  AG06000238 06 661          View Edit Delete
9818  AG06000237 06 661          View Edit Delete
9786  AG06000205 06 661          View Edit Delete
9722  AG06000141 06 661          View Edit Delete
9648  AG06000067 06 661          View Edit Delete
9644  AG06000063 06 661          View Edit Delete
9637  AG06000056 06 661          View Edit Delete
9629  AG06000048 06 661          View Edit Delete
9613  AG06000032 06 661          View Edit Delete
9663  AG06000082 06 661          View Edit Delete
9666  AG06000085 06 661          View Edit Delete
9662  AG06000081 06 661          View Edit Delete
9654  AG06000073 06 661          View Edit Delete
9653  AG06000072 06 661          View Edit Delete
9652  AG06000071 06 661          View Edit Delete
9690  AG06000109 06 661          View Edit Delete
9651  AG06000070 06 661          View Edit Delete

Page 20 of 373, showing 20 records out of 7458 total, starting on record 381, ending on 400

(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`.`insert_user` asc LIMIT 380, 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 = 11117