Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9930  AG06000349 06 661          View Edit Delete
9789  AG06000208 06 661          View Edit Delete
9790  AG06000209 06 661          View Edit Delete
9931  AG06000350 06 661          View Edit Delete
9791  AG06000210 06 661          View Edit Delete
9792  AG06000211 06 661          View Edit Delete
9933  AG06000352 06 661          View Edit Delete
9934  AG06000353 06 661          View Edit Delete
10151  AG06000570 06 661          View Edit Delete
10152  AG06000571 06 661          View Edit Delete
10153  AG06000572 06 661          View Edit Delete
10154  AG06000573 06 661          View Edit Delete
10027  AG06000446 06 661          View Edit Delete
10028  AG06000447 06 661          View Edit Delete
10029  AG06000448 06 661          View Edit Delete
10031  AG06000450 06 661          View Edit Delete
9948  AG06000367 06 661          View Edit Delete
9794  AG06000213 06 661          View Edit Delete
9939  AG06000358 06 661          View Edit Delete
10032  AG06000451 06 661          View Edit Delete

Page 44 of 373, showing 20 records out of 7458 total, starting on record 861, ending on 880

(default) 2 queries took 26 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 860, 2020209
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