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
46637  01  035  102040  10204_野菜  産地直送 野菜204  のうさんぶつ    2023-09-01 00:00:00    2023-09-01 00:00:00  MG00000001  2023-09-01 00:00:00  MG00000001  View Edit Delete
46893  01  033  57540  57540_農産物  岡山農産07540  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47149  01  033  57406  57406_農産物  岡山農産07406  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47405  01  033  57626  57626_農産物  岡山農産07626  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  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
47917  01  033  59336  59336_農産物  岡山農産09336  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 14:01:46  MG00000007  2023-10-19 14:01:46  MG00000007  View Edit Delete
48173  01  036  105220  5220_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48429  01  036  105482  5482_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48685  01  036  108238  8238_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48941  01  036  108497  8497_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49197  01  036  108762  8762_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49453  01  033  57827  57827_農産物  岡山農産07827  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  View Edit Delete
49709  01  036  105580  5580_農産物    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 00:00:00  MG00000001  2023-10-25 00:00:00  MG00000001  View Edit Delete
49965  01  036  105699  5699_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50221  01  033  58263  8263_農産物  広島農産08263  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50733  01  033  58579  58579_農産物  広島農産08579  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50989  01  036  105869  5869_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 10:30:43  MG00000007  2023-11-28 10:30:43  MG00000007  View Edit Delete
51245  01  031  696930  696930_農産物30    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51501  01  033  50798  50798_農産物  岡山農産00798  のうさんぶつ    2024-01-19 00:00:00    2024-01-19 11:29:49  MG00000007  2024-01-19 11:29:49  MG00000007  View Edit Delete
1070  01  005  12091  ハクサイ 1P    はくさい1    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete

Page 387 of 2156, showing 20 records out of 43118 total, starting on record 7721, ending on 7740

(default) 2 queries took 30 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`.`use_end_day` asc LIMIT 7720, 20202023
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117