Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
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
10168  AG06000587 06 661          View Edit Delete

Page 252 of 373, showing 20 records out of 7458 total, starting on record 5021, ending on 5040

(default) 2 queries took 37 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 5020, 20202019
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 = 11118