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
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
48137  01  036  105183  5183_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48393  01  036  105446  5446_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48649  01  036  108198  8198_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48905  01  036  108461  8461_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49161  01  036  108726  8726_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49417  01  033  57928  57928_農産物  岡山農産07928  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  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
49929  01  036  109026  9026_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50185  01  033  58718  8718_農産物  岡山農産08718  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50441  01  033  58435  8435_農産物  広島農産08435  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50697  01  033  58302  8302_農産物  広島農産08302  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50953  01  036  109146  9146_農産物1    のうさんぶつ    2023-11-27 00:00:00    2023-11-27 00:00:00  MG00000001  2023-11-27 00:00:00  MG00000001  View Edit Delete
51209  01  031  600324  600324_農産物24    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  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
10  01  001  10  とうがん    とうがん    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1290  01  005  24023  オレンジ 3P    おれんじ3    2016-07-01 00:00:00    2016-08-30 12:24:45  MG00000001  2016-08-30 12:24:45  MG00000001  View Edit Delete
1546  01  007  6208  きゅうり  近郷野菜108  きゅうり    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2570  01  006  7126  野菜  産直野菜126  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete

Page 237 of 2156, showing 20 records out of 43118 total, starting on record 4721, ending on 4740

(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`.`trader_id` desc LIMIT 4720, 20202021
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1118