Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
5516  AG02000017 02 51          View Edit Delete
5507  AG02000008 02 51          View Edit Delete
5534  AG02000035 02 51          View Edit Delete
5531  AG02000032 02 51          View Edit Delete
5527  AG02000028 02 51          View Edit Delete
5540  AG01001264 01 002          View Edit Delete
5545  AG01001633 01 002          View Edit Delete
5543  AG01001272 01 002          View Edit Delete
5538  AG01001269 01 002          View Edit Delete
5523  AG02000024 02 51          View Edit Delete
5506  AG02000007 02 51          View Edit Delete
5555  AG01001918 01 002          View Edit Delete
5551  AG01001278 01 002          View Edit Delete
5560  AG01001888 01 002          View Edit Delete
5559  AG01002724 01 002          View Edit Delete
5549  AG01001741 01 002          View Edit Delete
5547  AG01001892 01 002          View Edit Delete
5505  AG02000006 02 51          View Edit Delete
5346  AG01001269 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5344  AG01001516 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete

Page 9 of 373, showing 20 records out of 7458 total, starting on record 161, ending on 180

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