Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10474  AG06000893 06 661          View Edit Delete
10117  AG06000536 06 661          View Edit Delete
10471  AG06000890 06 661          View Edit Delete
10109  AG06000528 06 661          View Edit Delete
10086  AG06000505 06 661          View Edit Delete
10478  AG06000897 06 661          View Edit Delete
10121  AG06000540 06 661          View Edit Delete
10119  AG06000538 06 661          View Edit Delete
10123  AG06000542 06 661          View Edit Delete
10605  AG06001024 06 661          View Edit Delete
10477  AG06000896 06 661          View Edit Delete
10041  AG06000460 06 661          View Edit Delete
10113  AG06000532 06 661          View Edit Delete
10125  AG06000544 06 661          View Edit Delete
10473  AG06000892 06 661          View Edit Delete
10090  AG06000509 06 661          View Edit Delete
10056  AG06000475 06 661          View Edit Delete
10583  AG06001002 06 661          View Edit Delete
10126  AG06000545 06 661          View Edit Delete
10127  AG06000546 06 661          View Edit Delete

Page 61 of 373, showing 20 records out of 7458 total, starting on record 1201, ending on 1220

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