Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10176  AG06000595 06 661          View Edit Delete
10174  AG06000593 06 661          View Edit Delete
10171  AG06000590 06 661          View Edit Delete
10178  AG06000597 06 661          View Edit Delete
10182  AG06000601 06 661          View Edit Delete
10180  AG06000599 06 661          View Edit Delete
10177  AG06000596 06 661          View Edit Delete
10170  AG06000589 06 661          View Edit Delete
10156  AG06000575 06 661          View Edit Delete
10128  AG06000547 06 661          View Edit Delete
10072  AG06000491 06 661          View Edit Delete
9978  AG06000397 06 661          View Edit Delete
10194  AG06000613 06 661          View Edit Delete
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
9977  AG06000396 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete

Page 45 of 373, showing 20 records out of 7458 total, starting on record 881, ending on 900

(default) 2 queries took 25 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`.`update_user` asc LIMIT 880, 2020208
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