Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
5429  AG01002728 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5422  AG01001562 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
5459  AG01001836 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5451  AG01001281 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5444  AG01001910 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5492  AG01001775 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5503  AG02000004 02 51          View Edit Delete
5501  AG02000002 02 51          View Edit Delete
5475  AG01001294 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5443  AG01001848 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
5346  AG01001269 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5507  AG02000008 02 51          View Edit Delete
5516  AG02000017 02 51          View Edit Delete
5515  AG02000016 02 51          View Edit Delete
5506  AG02000007 02 51          View Edit Delete
5505  AG02000006 02 51          View Edit Delete
5504  AG02000005 02 51          View Edit Delete
5344  AG01001516 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete

Page 5 of 373, showing 20 records out of 7458 total, starting on record 81, ending on 100

(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 80, 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