Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9659  AG06000078 06 661          View Edit Delete
9654  AG06000073 06 661          View Edit Delete
9676  AG06000095 06 661          View Edit Delete
9671  AG06000090 06 661          View Edit Delete
9667  AG06000086 06 661          View Edit Delete
9670  AG06000089 06 661          View Edit Delete
9678  AG06000097 06 661          View Edit Delete
9679  AG06000098 06 661          View Edit Delete
9674  AG06000093 06 661          View Edit Delete
9669  AG06000088 06 661          View Edit Delete
9653  AG06000072 06 661          View Edit Delete
9681  AG06000100 06 661          View Edit Delete
9687  AG06000106 06 661          View Edit Delete
9683  AG06000102 06 661          View Edit Delete
9688  AG06000107 06 661          View Edit Delete
9682  AG06000101 06 661          View Edit Delete
9649  AG06000068 06 661          View Edit Delete
9689  AG06000108 06 661          View Edit Delete
9651  AG06000070 06 661          View Edit Delete
9692  AG06000111 06 661          View Edit Delete

Page 13 of 373, showing 20 records out of 7458 total, starting on record 241, ending on 260

(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 240, 2020206
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