Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9646  AG06000065 06 661          View Edit Delete
9678  AG06000097 06 661          View Edit Delete
9658  AG06000077 06 661          View Edit Delete
9652  AG06000071 06 661          View Edit Delete
9653  AG06000072 06 661          View Edit Delete
9655  AG06000074 06 661          View Edit Delete
9668  AG06000087 06 661          View Edit Delete
9626  AG06000045 06 661          View Edit Delete
9662  AG06000081 06 661          View Edit Delete
9672  AG06000091 06 661          View Edit Delete
9682  AG06000101 06 661          View Edit Delete
9673  AG06000092 06 661          View Edit Delete
9667  AG06000086 06 661          View Edit Delete
9635  AG06000054 06 661          View Edit Delete
9945  AG06000364 06 661          View Edit Delete
9683  AG06000102 06 661          View Edit Delete
9685  AG06000104 06 661          View Edit Delete
10043  AG06000462 06 661          View Edit Delete
10044  AG06000463 06 661          View Edit Delete
10045  AG06000464 06 661          View Edit Delete

Page 32 of 373, showing 20 records out of 7458 total, starting on record 621, ending on 640

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