Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10607  AG06001026 06 661          View Edit Delete
10606  AG06001025 06 661          View Edit Delete
10605  AG06001024 06 661          View Edit Delete
10604  AG06001023 06 661          View Edit Delete
10603  AG06001022 06 661          View Edit Delete
10602  AG06001021 06 661          View Edit Delete
10601  AG06001020 06 661          View Edit Delete
10600  AG06001019 06 661          View Edit Delete
10599  AG06001018 06 661          View Edit Delete
10598  AG06001017 06 661          View Edit Delete
10597  AG06001016 06 661          View Edit Delete
10596  AG06001015 06 661          View Edit Delete
10595  AG06001014 06 661          View Edit Delete
10594  AG06001013 06 661          View Edit Delete
10593  AG06001012 06 661          View Edit Delete
10592  AG06001011 06 661          View Edit Delete
10591  AG06001010 06 661          View Edit Delete
10590  AG06001009 06 661          View Edit Delete
10589  AG06001008 06 661          View Edit Delete
10588  AG06001007 06 661          View Edit Delete

Page 231 of 373, showing 20 records out of 7458 total, starting on record 4601, ending on 4620

(default) 2 queries took 33 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 4600, 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 = 11117