Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10288  AG06000707 06 661          View Edit Delete
10287  AG06000706 06 661          View Edit Delete
10286  AG06000705 06 661          View Edit Delete
10285  AG06000704 06 661          View Edit Delete
10284  AG06000703 06 661          View Edit Delete
10283  AG06000702 06 661          View Edit Delete
10282  AG06000701 06 661          View Edit Delete
10281  AG06000700 06 661          View Edit Delete
10280  AG06000699 06 661          View Edit Delete
10279  AG06000698 06 661          View Edit Delete
10278  AG06000697 06 661          View Edit Delete
10277  AG06000696 06 661          View Edit Delete
10276  AG06000695 06 661          View Edit Delete
10275  AG06000694 06 661          View Edit Delete
10274  AG06000693 06 661          View Edit Delete
10273  AG06000692 06 661          View Edit Delete
10272  AG06000691 06 661          View Edit Delete
10271  AG06000690 06 661          View Edit Delete
10270  AG06000689 06 661          View Edit Delete
10269  AG06000688 06 661          View Edit Delete

Page 32 of 373, showing 20 records out of 7458 total, starting on record 621, ending on 640

(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 620, 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 = 11116