Contractors

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

Page 143 of 373, showing 20 records out of 7458 total, starting on record 2841, ending on 2860

(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 ORDER BY `Contractor`.`id` asc LIMIT 2840, 20202010
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