Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
5543  AG01001272 01 002          View Edit Delete
5547  AG01001892 01 002          View Edit Delete
5545  AG01001633 01 002          View Edit Delete
5534  AG02000035 02 51          View Edit Delete
5533  AG02000034 02 51          View Edit Delete
5344  AG01001516 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5346  AG01001269 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5348  AG01001264 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5349  AG01001739 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5350  AG01001687 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5351  AG01001272 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5352  AG01001569 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5353  AG01001633 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5355  AG01001892 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5357  AG01001741 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5359  AG01001278 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5360  AG01002709 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5361  AG01001258 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5362  AG01001307 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5363  AG01001918 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete

Page 10 of 373, showing 20 records out of 7458 total, starting on record 181, ending on 200

(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`.`modified` asc LIMIT 180, 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