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
47622  01  034  81290  12900_農産物    のうさんぶつ    2023-09-28 00:00:00    2023-09-28 16:37:16  MG00000007  2023-09-28 16:37:16  MG00000007  View Edit Delete
47878  01  033  59297  59297_農産物  岡山農産09297  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 11:53:15  MG00000007  2023-10-19 11:53:15  MG00000007  View Edit Delete
49670  01  031  820602  820602_農産物2    のうさんぶつ    2023-10-24 00:00:00    2023-10-24 11:42:19  MG00000007  2023-10-24 11:42:19  MG00000007  View Edit Delete
47623  01  034  81291  12910_農産物    のうさんぶつ    2023-09-28 00:00:00    2023-09-28 16:38:47  MG00000007  2023-09-28 16:38:47  MG00000007  View Edit Delete
47879  01  033  59298  59298_農産物  岡山農産09298  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 11:54:38  MG00000007  2023-10-19 11:54:38  MG00000007  View Edit Delete
49671  01  031  820603  820603_農産物3    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 11:42:31  MG00000007  2023-10-25 11:42:31  MG00000007  View Edit Delete
51463  01  033  50804  50804_農産物  岡山農産00804  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:12:33  MG00000007  2024-01-18 17:12:33  MG00000007  View Edit Delete
47624  01  034  81292  12920_農産物    のうさんぶつ    2023-09-28 00:00:00    2023-09-28 16:40:07  MG00000007  2023-09-28 16:40:07  MG00000007  View Edit Delete
47880  01  033  59299  59299_農産物  岡山農産09299  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 11:58:33  MG00000007  2023-10-19 11:58:33  MG00000007  View Edit Delete
49672  01  031  820604  820604_農産物4    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 11:43:43  MG00000007  2023-10-25 11:43:43  MG00000007  View Edit Delete
51464  01  033  50805  50805_農産物  岡山農産00805  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:14:02  MG00000007  2024-01-18 17:14:02  MG00000007  View Edit Delete
47625  01  034  81293  12930_農産物    のうさんぶつ    2023-09-28 00:00:00    2023-09-28 16:41:15  MG00000007  2023-09-28 16:41:15  MG00000007  View Edit Delete
47881  01  033  59300  59300_農産物  岡山農産09300  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:03:11  MG00000007  2023-10-19 13:03:11  MG00000007  View Edit Delete
49673  01  031  820605  820605_農産物5    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 11:44:41  MG00000007  2023-10-25 11:44:41  MG00000007  View Edit Delete
51465  01  033  50806  50806_農産物  岡山農産00806  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:15:29  MG00000007  2024-01-18 17:15:29  MG00000007  View Edit Delete
47626  01  034  81294  12940_農産物    のうさんぶつ    2023-09-28 00:00:00    2023-09-28 16:42:16  MG00000007  2023-09-28 16:42:16  MG00000007  View Edit Delete
47882  01  033  59301  59301_農産物  岡山農産09301  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:05:33  MG00000007  2023-10-19 13:05:33  MG00000007  View Edit Delete
49674  01  031  820606  820606_農産物6    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 11:45:44  MG00000007  2023-10-25 11:45:44  MG00000007  View Edit Delete
51466  01  033  50807  50807_農産物  岡山農産00807  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:16:36  MG00000007  2024-01-18 17:16:36  MG00000007  View Edit Delete
47627  01  032  51368  13680_農産物    のうさんぶつ    2023-09-28 00:00:00    2023-09-28 17:13:26  MG00000007  2023-09-28 17:13:26  MG00000007  View Edit Delete

Page 2 of 2156, showing 20 records out of 43118 total, starting on record 21, ending on 40

(default) 2 queries took 28 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`.`update_user` desc LIMIT 20, 20202020
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1118