Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9737  AG06000156 06 661          View Edit Delete
9726  AG06000145 06 661          View Edit Delete
9725  AG06000144 06 661          View Edit Delete
9733  AG06000152 06 661          View Edit Delete
9730  AG06000149 06 661          View Edit Delete
9718  AG06000137 06 661          View Edit Delete
9686  AG06000105 06 661          View Edit Delete
9741  AG06000160 06 661          View Edit Delete
9682  AG06000101 06 661          View Edit Delete
9915  AG06000334 06 661          View Edit Delete
9738  AG06000157 06 661          View Edit Delete
9739  AG06000158 06 661          View Edit Delete
9925  AG06000344 06 661          View Edit Delete
9926  AG06000345 06 661          View Edit Delete
9927  AG06000346 06 661          View Edit Delete
9928  AG06000347 06 661          View Edit Delete
9929  AG06000348 06 661          View Edit Delete
9930  AG06000349 06 661          View Edit Delete
9931  AG06000350 06 661          View Edit Delete
9932  AG06000351 06 661          View Edit Delete

Page 25 of 373, showing 20 records out of 7458 total, starting on record 481, ending on 500

(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`.`trader_id` desc LIMIT 480, 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