Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
5392  AG01001257 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5394  AG01001875 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5395  AG01001296 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5396  AG01001678 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5398  AG01001805 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5400  AG01001878 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5401  AG01001353 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
9588  AG06000007 06 661          View Edit Delete
9595  AG06000014 06 661          View Edit Delete
9591  AG06000010 06 661          View Edit Delete
9589  AG06000008 06 661          View Edit Delete
9596  AG06000015 06 661          View Edit Delete
9587  AG06000006 06 661          View Edit Delete
9592  AG06000011 06 661          View Edit Delete
9590  AG06000009 06 661          View Edit Delete
9586  AG06000005 06 661          View Edit Delete
9594  AG06000013 06 661          View Edit Delete
9597  AG06000016 06 661          View Edit Delete
9593  AG06000012 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete

Page 11 of 373, showing 20 records out of 7458 total, starting on record 201, ending on 220

(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 200, 2020206
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 = 11119