Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10410  AG06000829 06 661          View Edit Delete
10411  AG06000830 06 661          View Edit Delete
10412  AG06000831 06 661          View Edit Delete
10413  AG06000832 06 661          View Edit Delete
10414  AG06000833 06 661          View Edit Delete
10415  AG06000834 06 661          View Edit Delete
10416  AG06000835 06 661          View Edit Delete
10417  AG06000836 06 661          View Edit Delete
10418  AG06000837 06 661          View Edit Delete
10419  AG06000838 06 661          View Edit Delete
10420  AG06000839 06 661          View Edit Delete
10421  AG06000840 06 661          View Edit Delete
10422  AG06000841 06 661          View Edit Delete
10423  AG06000842 06 661          View Edit Delete
10424  AG06000843 06 661          View Edit Delete
10425  AG06000844 06 661          View Edit Delete
10426  AG06000845 06 661          View Edit Delete
10427  AG06000846 06 661          View Edit Delete
10428  AG06000847 06 661          View Edit Delete
10429  AG06000848 06 661          View Edit Delete

Page 134 of 373, showing 20 records out of 7458 total, starting on record 2661, ending on 2680

(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 LIMIT 2660, 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