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
49955  01  036  105689  5689_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50211  01  033  58240  8240_農産物  広島農産08240  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50467  01  033  58461  8461_農産物  広島農産08461  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50723  01  033  58328  8328_農産物  広島農産08328  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50979  01  036  105859  5859_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 10:04:47  MG00000007  2023-11-28 10:04:47  MG00000007  View Edit Delete
51235  01  031  696920  696920_農産物20    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51491  01  033  50788  50788_農産物  岡山農産00788  のうさんぶつ    2024-01-19 00:00:00    2024-01-19 11:10:01  MG00000007  2024-01-19 11:10:01  MG00000007  View Edit Delete
36  01  001  36  大根    だいこん    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1060  01  005  11162  とうもろこし 2P    とうもろこし2    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
1572  01  007  6234  キャンディーランタン  近郷野菜134  きゃんでぃーらんたん    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2596  01  006  7152  野菜  産直野菜152  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5156  07  81  34  農産物34    のうさんぶつ34    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5412  02  53  42  農産物42    のうさんぶつ42    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6180  08  93  496241001058  ししとう    ししとう    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6436  01  004  398709  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6692  01  002  20110600  茄子    なす    2018-08-29 00:00:00    2018-08-29 16:12:59  MG00000001  2018-08-29 16:12:59  MG00000001  View Edit Delete
6948  08  96  711  メロン    めろん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7204  08  97  647  プルーン    ぷるーん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7716  01  102  2400033508920   みかん    みかん    2019-05-20 00:00:00            View Edit Delete
7972  03  62  53  農産物53    のうさんぶつ53    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete

Page 304 of 2156, showing 20 records out of 43118 total, starting on record 6061, ending on 6080

(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`.`use_end_day` desc LIMIT 6060, 20202022
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117