Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10088  AG06000507 06 661          View Edit Delete
10087  AG06000506 06 661          View Edit Delete
10086  AG06000505 06 661          View Edit Delete
10085  AG06000504 06 661          View Edit Delete
10084  AG06000503 06 661          View Edit Delete
10083  AG06000502 06 661          View Edit Delete
10082  AG06000501 06 661          View Edit Delete
10081  AG06000500 06 661          View Edit Delete
10080  AG06000499 06 661          View Edit Delete
10079  AG06000498 06 661          View Edit Delete
10078  AG06000497 06 661          View Edit Delete
10077  AG06000496 06 661          View Edit Delete
10076  AG06000495 06 661          View Edit Delete
10075  AG06000494 06 661          View Edit Delete
10074  AG06000493 06 661          View Edit Delete
10073  AG06000492 06 661          View Edit Delete
10072  AG06000491 06 661          View Edit Delete
10071  AG06000490 06 661          View Edit Delete
10070  AG06000489 06 661          View Edit Delete
10069  AG06000488 06 661          View Edit Delete

Page 42 of 373, showing 20 records out of 7458 total, starting on record 821, ending on 840

(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`.`farmer_id` desc LIMIT 820, 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