Traders Farmers

Farmer Trader Farmer Cd Created Insert User Modified Update User Actions
AG01003004 01 400020          View Edit Delete
AG01002588 01 360720    MG00000001  2022-05-17 16:02:43  MG00000001  View Edit Delete
AG01002589 01 360719    MG00000002  2018-06-09 09:55:00  MG00000002  View Edit Delete
AG01002999 01 400016          View Edit Delete
AG01003000 01 400017          View Edit Delete
AG01002994 01 400011          View Edit Delete
AG01002997 01 400014          View Edit Delete
AG01002998 01 400015          View Edit Delete
AG01003003 01 400019          View Edit Delete
AG01003006 01 400022          View Edit Delete
AG01003007 01 400023          View Edit Delete
AG01003011 01 400026          View Edit Delete
AG01002995 01 400012          View Edit Delete
AG01003001 01 400018          View Edit Delete
AG01003002 01 410001          View Edit Delete
AG01002996 01 400013          View Edit Delete
AG01003005 01 400021          View Edit Delete
AG01003009 01 290824          View Edit Delete
AG01003008 01 400024          View Edit Delete
AG01003010 01 400025          View Edit Delete

Page 1 of 251, showing 20 records out of 5002 total, starting on record 1, ending on 20

< previous123456789
(default) 2 queries took 15 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `TradersFarmer`.`farmer_id`, `TradersFarmer`.`trader_id`, `TradersFarmer`.`farmer_cd`, `TradersFarmer`.`created`, `TradersFarmer`.`insert_user`, `TradersFarmer`.`modified`, `TradersFarmer`.`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`, `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` FROM `sato_agri`.`traders_farmers` AS `TradersFarmer` LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`TradersFarmer`.`trader_id` = `Trader`.`id`) LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`TradersFarmer`.`farmer_id` = `Farmer`.`user_id`) WHERE 1 = 1 ORDER BY `TradersFarmer`.`created` asc LIMIT 2020204
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`traders_farmers` AS `TradersFarmer` LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`TradersFarmer`.`trader_id` = `Trader`.`id`) LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`TradersFarmer`.`farmer_id` = `Farmer`.`user_id`) WHERE 1 = 11111