Cmp Products

Id Trader Company Cd Co Product Cd Co Product Nm Co Product Reciept Nm Co Product Fk Limited User Use Start Day Use End Day Created Insert User Modified Update User Actions
47655  01  031  100012  100012_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 15:55:32  MG00000007  2023-10-03 15:55:32  MG00000007  View Edit Delete
47656  01  031  100013  100013_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 15:58:24  MG00000007  2023-10-03 15:58:24  MG00000007  View Edit Delete
47657  01  031  100014  100014_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 15:59:44  MG00000007  2023-10-03 15:59:44  MG00000007  View Edit Delete
47658  01  031  100015  100015_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:01:53  MG00000007  2023-10-03 16:01:53  MG00000007  View Edit Delete
47659  01  031  100016  100016_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:03:14  MG00000007  2023-10-03 16:03:14  MG00000007  View Edit Delete
47660  01  031  100017  100017_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:15:59  MG00000007  2023-10-03 16:15:59  MG00000007  View Edit Delete
47661  01  031  100018  100018_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:17:53  MG00000007  2023-10-03 16:17:53  MG00000007  View Edit Delete
47662  01  031  100019  100019_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:19:06  MG00000007  2023-10-03 16:19:06  MG00000007  View Edit Delete
46132  01  035  100010  10001_農産物  産地直送 野菜1  のうさんぶつ    2023-08-24 00:00:00    2023-08-24 09:22:23  MG00000001  2023-08-24 09:22:23  MG00000001  View Edit Delete
47663  01  031  100020  100020_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:23:29  MG00000007  2023-10-03 16:23:29  MG00000007  View Edit Delete
47664  01  031  100021  100021_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:24:39  MG00000007  2023-10-03 16:24:39  MG00000007  View Edit Delete
47665  01  031  100022  100022_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:26:20  MG00000007  2023-10-03 16:26:20  MG00000007  View Edit Delete
47666  01  031  100023  100023_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:27:30  MG00000007  2023-10-03 16:27:30  MG00000007  View Edit Delete
47667  01  031  100024  100024_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:30:27  MG00000007  2023-10-03 16:30:27  MG00000007  View Edit Delete
47668  01  031  100025  100025_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:31:40  MG00000007  2023-10-03 16:31:40  MG00000007  View Edit Delete
47669  01  031  100026  100026_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:32:59  MG00000007  2023-10-03 16:32:59  MG00000007  View Edit Delete
47670  01  031  100027  100027_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:41:10  MG00000007  2023-10-03 16:41:10  MG00000007  View Edit Delete
47671  01  031  100028  100028_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:42:21  MG00000007  2023-10-03 16:42:21  MG00000007  View Edit Delete
47672  01  031  100029  100029_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:43:35  MG00000007  2023-10-03 16:43:35  MG00000007  View Edit Delete
46133  01  035  100020  10002_農産物  産地直送 野菜2  のうさんぶつ    2023-08-24 00:00:00    2023-08-24 09:22:48  MG00000001  2023-08-24 09:22:48  MG00000001  View Edit Delete

Page 6 of 2156, showing 20 records out of 43118 total, starting on record 101, ending on 120

(default) 2 queries took 29 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `CmpProduct`.`id`, `CmpProduct`.`trader_id`, `CmpProduct`.`company_cd`, `CmpProduct`.`co_product_cd`, `CmpProduct`.`co_product_nm`, `CmpProduct`.`co_product_reciept_nm`, `CmpProduct`.`co_product_fk`, `CmpProduct`.`sys_product_cd`, `CmpProduct`.`farmer_linked_flag`, `CmpProduct`.`limited_user_id`, `CmpProduct`.`barcode_generate_pattern`, `CmpProduct`.`barcode_display_format`, `CmpProduct`.`use_start_day`, `CmpProduct`.`use_end_day`, `CmpProduct`.`created`, `CmpProduct`.`insert_user`, `CmpProduct`.`modified`, `CmpProduct`.`update_user` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1 ORDER BY `CmpProduct`.`co_product_nm` asc LIMIT 100, 20202022
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117