Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10260  AG06000679 06 661          View Edit Delete
10258  AG06000677 06 661          View Edit Delete
10263  AG06000682 06 661          View Edit Delete
10261  AG06000680 06 661          View Edit Delete
10266  AG06000685 06 661          View Edit Delete
10264  AG06000683 06 661          View Edit Delete
10267  AG06000686 06 661          View Edit Delete
10268  AG06000687 06 661          View Edit Delete
10271  AG06000690 06 661          View Edit Delete
10269  AG06000688 06 661          View Edit Delete
10274  AG06000693 06 661          View Edit Delete
10272  AG06000691 06 661          View Edit Delete
10277  AG06000696 06 661          View Edit Delete
10275  AG06000694 06 661          View Edit Delete
10280  AG06000699 06 661          View Edit Delete
10278  AG06000697 06 661          View Edit Delete
10283  AG06000702 06 661          View Edit Delete
10281  AG06000700 06 661          View Edit Delete
10287  AG06000706 06 661          View Edit Delete
10285  AG06000704 06 661          View Edit Delete

Page 66 of 373, showing 20 records out of 7458 total, starting on record 1301, ending on 1320

(default) 2 queries took 26 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 1300, 2020209
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