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
6984  01  002  20110560  野菜    やさい    2018-10-11 00:00:00    2018-10-11 10:20:11  MG00000001  2018-10-11 10:20:11  MG00000001  View Edit Delete
7240  08  97  762  ドライプルーン    どらいぷるーん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 16:50:00  MG00000001  View Edit Delete
7752  01  102  2400033509422   目玉商品    めだましょうひん    2019-05-20 00:00:00            View Edit Delete
8008  03  62  89  農産物89    のうさんぶつ89    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8264  02  51  886  小菜    こな    2020-03-18 00:00:00    2020-03-18 15:06:50  MG00000001  2020-03-18 15:06:50  MG00000001  View Edit Delete
18504  01  002  20110826  野菜    やさい    2023-01-25 00:00:00    2023-01-25 15:13:44  MG00000001  2023-01-25 15:13:44  MG00000001  View Edit Delete
42568  01  114  11870  1870_農産物2    のうさんぶつ    2023-04-18 00:00:00    2023-04-18 10:14:56  MG00000001  2023-04-18 10:14:56  MG00000001  View Edit Delete
46664  01  911  102120  農産物10_2120    のうさんぶつ    2023-09-01 00:00:00    2023-09-01 11:06:47  MG00000001  2023-09-01 11:06:47  MG00000001  View Edit Delete
47688  01  035  102090  2510209000000_農産物  産地直送 野菜209  のうさんぶつ    2023-10-12 00:00:00    2023-10-12 14:15:21  MG00000007  2023-10-12 14:15:21  MG00000007  View Edit Delete
47944  01  036  105569  5569_農産物4    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 11:52:52  MG00000007  2023-10-20 11:52:52  MG00000007  View Edit Delete
51016  01  036  109176  9176_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 15:33:17  MG00000007  2023-11-28 15:33:17  MG00000007  View Edit Delete
1097  01  005  13061  枝豆 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
1609  01  007  6271  しょうが  近郷野菜171  しょうが    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2633  02  51  161  白菜    はくさい    2017-02-27 00:00:00            View Edit Delete
5193  07  81  71  農産物71    のうさんぶつ71    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5449  02  53  79  農産物79    のうさんぶつ79    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6217  02  51  294  ライム    らいむ    2018-05-22 00:00:00    2018-05-22 13:26:49  MG00000001  2018-05-22 13:26:49  MG00000001  View Edit Delete
6473  01  004  472724  果物    くだもの    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6729  01  002  20110635  その他葉物・茎物    そのたはものくきもの    2018-09-04 00:00:00    2018-09-04 09:17:51  MG00000001  2018-09-04 09:17:51  MG00000001  View Edit Delete
6985  01  002  20110565  野菜    やさい    2018-10-11 00:00:00    2018-10-11 10:21:08  MG00000001  2018-10-11 10:21:08  MG00000001  View Edit Delete

Page 74 of 2156, showing 20 records out of 43118 total, starting on record 1461, ending on 1480

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