Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10710  AG06001129 06 661          View Edit Delete
10711  AG06001130 06 661          View Edit Delete
10712  AG06001131 06 661          View Edit Delete
10713  AG06001132 06 661          View Edit Delete
10714  AG06001133 06 661          View Edit Delete
10715  AG06001134 06 661          View Edit Delete
10716  AG06001135 06 661          View Edit Delete
10717  AG06001136 06 661          View Edit Delete
10718  AG06001137 06 661          View Edit Delete
10719  AG06001138 06 661          View Edit Delete
10720  AG06001139 06 661          View Edit Delete
10721  AG06001140 06 661          View Edit Delete
10722  AG06001141 06 661          View Edit Delete
10723  AG06001142 06 661          View Edit Delete
10724  AG06001143 06 661          View Edit Delete
10725  AG06001144 06 661          View Edit Delete
10726  AG06001145 06 661          View Edit Delete
10727  AG06001146 06 661          View Edit Delete
10728  AG06001147 06 661          View Edit Delete
10729  AG06001148 06 661          View Edit Delete

Page 149 of 373, showing 20 records out of 7458 total, starting on record 2961, ending on 2980

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