Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10188  AG06000607 06 661          View Edit Delete
10187  AG06000606 06 661          View Edit Delete
10186  AG06000605 06 661          View Edit Delete
10185  AG06000604 06 661          View Edit Delete
10184  AG06000603 06 661          View Edit Delete
10183  AG06000602 06 661          View Edit Delete
10182  AG06000601 06 661          View Edit Delete
10181  AG06000600 06 661          View Edit Delete
10180  AG06000599 06 661          View Edit Delete
10179  AG06000598 06 661          View Edit Delete
10178  AG06000597 06 661          View Edit Delete
10177  AG06000596 06 661          View Edit Delete
10176  AG06000595 06 661          View Edit Delete
10175  AG06000594 06 661          View Edit Delete
10174  AG06000593 06 661          View Edit Delete
10173  AG06000592 06 661          View Edit Delete
10172  AG06000591 06 661          View Edit Delete
10171  AG06000590 06 661          View Edit Delete
10170  AG06000589 06 661          View Edit Delete
10169  AG06000588 06 661          View Edit Delete

Page 37 of 373, showing 20 records out of 7458 total, starting on record 721, ending on 740

(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 720, 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