Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9614  AG06000033 06 661          View Edit Delete
9615  AG06000034 06 661          View Edit Delete
9616  AG06000035 06 661          View Edit Delete
9617  AG06000036 06 661          View Edit Delete
10044  AG06000463 06 661          View Edit Delete
9746  AG06000165 06 661          View Edit Delete
9604  AG06000023 06 661          View Edit Delete
9605  AG06000024 06 661          View Edit Delete
9748  AG06000167 06 661          View Edit Delete
9606  AG06000025 06 661          View Edit Delete
9831  AG06000250 06 661          View Edit Delete
9837  AG06000256 06 661          View Edit Delete
9838  AG06000257 06 661          View Edit Delete
10047  AG06000466 06 661          View Edit Delete
9750  AG06000169 06 661          View Edit Delete
9749  AG06000168 06 661          View Edit Delete
9609  AG06000028 06 661          View Edit Delete
9607  AG06000026 06 661          View Edit Delete
9610  AG06000029 06 661          View Edit Delete
9611  AG06000030 06 661          View Edit Delete

Page 34 of 373, showing 20 records out of 7458 total, starting on record 661, ending on 680

(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`.`company_cd` desc LIMIT 660, 2020208
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