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
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
6190  01  007  6007  モロヘイヤ  近郷野菜8  もろへいや    2018-04-18 00:00:00    2018-04-18 12:24:48  MG00000001  2018-04-18 12:24:48  MG00000001  View Edit Delete
6446  01  004  398727  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6702  01  002  20110610  胡瓜    きゅうり    2018-08-31 00:00:00    2018-08-31 10:07:26  MG00000001  2018-08-31 10:07:26  MG00000001  View Edit Delete
7726  01  102  2400033509033   柿    かき    2019-05-20 00:00:00            View Edit Delete
8238  01  002  20110595  菌床栽培生しいたけ    きんしょうさいばいなましいたけ    2019-12-23 00:00:00    2019-12-23 08:57:57  MG00000001  2022-02-01 09:33:42  MG00000001  View Edit Delete
8494  01  011  68783  農産物    のうさんぶつ    2020-06-10 00:00:00    2020-06-10 13:42:51  MG00000005  2020-06-10 13:42:51  MG00000005  View Edit Delete

Page 358 of 2156, showing 20 records out of 43118 total, starting on record 7141, ending on 7160

(default) 2 queries took 33 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`.`trader_id` asc LIMIT 7140, 20202025
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1118