Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
5451  AG01001281 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
5408  AG01001650 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5419  AG01001566 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
5359  AG01001278 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5371  AG01001704 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
5396  AG01001678 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5378  AG01001587 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
5492  AG01001775 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5508  AG02000009 02 51          View Edit Delete
5518  AG02000019 02 51          View Edit Delete
5520  AG02000021 02 51          View Edit Delete
5511  AG02000012 02 51          View Edit Delete
5447  AG01001870 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5502  AG02000003 02 51          View Edit Delete
5504  AG02000005 02 51          View Edit Delete

Page 4 of 373, showing 20 records out of 7458 total, starting on record 61, ending on 80

(default) 2 queries took 24 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 60, 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 = 11118