Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9732  AG06000151 06 661          View Edit Delete
9728  AG06000147 06 661          View Edit Delete
9742  AG06000161 06 661          View Edit Delete
9741  AG06000160 06 661          View Edit Delete
9738  AG06000157 06 661          View Edit Delete
9744  AG06000163 06 661          View Edit Delete
9747  AG06000166 06 661          View Edit Delete
9746  AG06000165 06 661          View Edit Delete
9743  AG06000162 06 661          View Edit Delete
9737  AG06000156 06 661          View Edit Delete
9727  AG06000146 06 661          View Edit Delete
9719  AG06000138 06 661          View Edit Delete
9751  AG06000170 06 661          View Edit Delete
9757  AG06000176 06 661          View Edit Delete
9756  AG06000175 06 661          View Edit Delete
9750  AG06000169 06 661          View Edit Delete
9749  AG06000168 06 661          View Edit Delete
9748  AG06000167 06 661          View Edit Delete
9718  AG06000137 06 661          View Edit Delete
9717  AG06000136 06 661          View Edit Delete

Page 21 of 373, showing 20 records out of 7458 total, starting on record 401, ending on 420

(default) 2 queries took 25 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`.`update_user` asc LIMIT 400, 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 = 11118