Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10688  AG06001107 06 661          View Edit Delete
10687  AG06001106 06 661          View Edit Delete
10686  AG06001105 06 661          View Edit Delete
10685  AG06001104 06 661          View Edit Delete
10684  AG06001103 06 661          View Edit Delete
10683  AG06001102 06 661          View Edit Delete
10682  AG06001101 06 661          View Edit Delete
10681  AG06001100 06 661          View Edit Delete
10680  AG06001099 06 661          View Edit Delete
10679  AG06001098 06 661          View Edit Delete
10678  AG06001097 06 661          View Edit Delete
10677  AG06001096 06 661          View Edit Delete
10676  AG06001095 06 661          View Edit Delete
10675  AG06001094 06 661          View Edit Delete
10674  AG06001093 06 661          View Edit Delete
10673  AG06001092 06 661          View Edit Delete
10672  AG06001091 06 661          View Edit Delete
10671  AG06001090 06 661          View Edit Delete
10670  AG06001089 06 661          View Edit Delete
10669  AG06001088 06 661          View Edit Delete

Page 12 of 373, showing 20 records out of 7458 total, starting on record 221, ending on 240

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