Contractors

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

Page 240 of 373, showing 20 records out of 7458 total, starting on record 4781, ending on 4800

(default) 2 queries took 32 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`.`id` desc LIMIT 4780, 20202016
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