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
7994  03  62  75  農産物75    のうさんぶつ75    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8250  01  002  20120180  果実    かじつ    2020-01-31 00:00:00    2020-01-31 09:57:47  MG00000001  2020-01-31 09:57:47  MG00000001  View Edit Delete
10810  02  51  764  かいわれ大根    かいわれだいこん    2021-09-27 00:00:00    2021-09-27 14:05:54  MG00000001  2021-09-27 14:05:54  MG00000001  View Edit Delete
14394  01  063  646002  果実    かじつ    2022-10-20 00:00:00    2022-10-20 09:34:15  MG00000001  2022-10-20 09:34:15  MG00000001  View Edit Delete
18490  01  002  20110821  野菜    やさい    2023-01-06 00:00:00    2023-01-06 10:04:28  MG00000001  2023-01-06 10:04:28  MG00000001  View Edit Delete
44090  01  031  600530  600530_農産物30    のうさんぶつ    2023-06-28 00:00:00    2023-06-28 16:14:55  MG00000001  2023-06-28 16:14:55  MG00000001  View Edit Delete
46650  01  911  100476  農産物01_0476    のうさんぶつ    2023-09-01 00:00:00    2023-09-01 10:48:46  MG00000001  2023-09-01 10:48:46  MG00000001  View Edit Delete
47674  01  031  100031  100031_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:49:58  MG00000007  2023-10-03 16:49:58  MG00000007  View Edit Delete
47930  01  037  114811  4811_農産物4    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 09:39:30  MG00000007  2023-10-20 09:39:30  MG00000007  View Edit Delete
51002  01  036  109162  9162_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 11:54:19  MG00000007  2023-11-28 11:54:19  MG00000007  View Edit Delete
1083  01  005  12181  ほうれん草 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
1595  01  007  6257  アスパラ  近郷野菜157  あすぱら    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2619  02  51  129  小松菜    こまつな    2017-02-27 00:00:00            View Edit Delete
5179  07  81  57  農産物57    のうさんぶつ57    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5435  02  53  65  農産物65    のうさんぶつ65    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6203  02  52  1871  農産物    のうさんぶつ    2018-05-11 00:00:00    2018-05-11 09:25:04  MG00000001  2018-05-11 09:25:04  MG00000001  View Edit Delete
6459  01  004  472307  果物    くだもの    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6715  01  002  20110621  野菜    やさい    2018-09-03 00:00:00    2018-09-03 09:47:36  MG00000001  2018-09-03 09:47:36  MG00000001  View Edit Delete
6971  08  96  766  みかんジュース    みかんじゅーす    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7227  08  97  717  アンデスメロン    あんですめろん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete

Page 60 of 2156, showing 20 records out of 43118 total, starting on record 1181, ending on 1200

(default) 2 queries took 26 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 1180, 20202019
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117