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
6252  09  101  38006  農産物    のうさんぶつ    2018-06-16 00:00:00    2018-06-16 23:55:53  MG00000002  2018-06-16 23:55:53  MG00000002  View Edit Delete
6508  01  004  499376  果物    くだもの    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6764  08  96  010  ビーツ    びーつ    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7020  02  54  83135  農産物    のうさんぶつ    2018-10-24 00:00:00    2018-10-24 10:21:58  MG00000001  2018-10-24 10:21:58  MG00000001  View Edit Delete
7276  02  54  44172  農産物    のうさんぶつ    2018-12-19 00:00:00    2018-12-19 13:15:01  MG00000001  2018-12-19 13:15:01  MG00000001  View Edit Delete
10860  01  002  20905064  農産物    のうさんぶつ    2021-10-28 00:00:00    2021-10-28 10:40:13  MG00000001  2021-10-28 10:40:13  MG00000001  View Edit Delete
12908  01  002  20904976  野菜④    やさい    2022-09-08 00:00:00    2022-09-08 11:25:06  MG00000001  2022-09-08 11:25:06  MG00000001  View Edit Delete
18540  01  113  20903103  03103_農産物    のうさんぶつ    2023-02-27 00:00:00    2023-02-27 15:46:58  MG00000001  2023-02-28 11:10:11  MG00000001  View Edit Delete
42604  01  034  80165  80165_農産物    のうさんぶつ    2023-04-18 00:00:00    2023-04-18 13:56:08  MG00000001  2023-04-18 13:56:08  MG00000001  View Edit Delete
43372  01  033  56548  56548_農産物  岡山農産06548  のうさんぶつ    2023-06-01 00:00:00    2023-06-01 11:04:43  MG00000001  2023-06-01 11:04:43  MG00000001  View Edit Delete
47980  01  036  108920  8920_農産物4    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 12:34:00  MG00000007  2023-10-20 12:34:00  MG00000007  View Edit Delete
50540  02  51  359  さつま芋(紅はるか)    さつまいもべにはるか    2023-11-10 00:00:00    2023-11-10 11:26:18  MG00000001  2023-11-10 11:26:18  MG00000001  View Edit Delete
109  01  001  55  ぶなしめじ    ぶなふめじ    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1133  01  005  15091  新ごぼう 1P    しんごぼう    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
2669  02  51  272  キウイ    きうい    2017-02-27 00:00:00            View Edit Delete
5229  01  011  60758  農産物    のうさんぶつ    2018-01-09 00:00:00    2017-11-15 11:34:46  MG00000001  2017-11-15 11:34:46  MG00000001  View Edit Delete
5485  02  54  76988  農産物    のうさんぶつ    2018-03-05 00:00:00    2018-03-05 00:00:00  MG00000001  2018-03-05 00:00:00  MG00000001  View Edit Delete
6253  09  101  38007  農産物    のうさんぶつ    2018-06-16 00:00:00    2018-06-16 23:58:12  MG00000002  2018-06-16 23:58:12  MG00000002  View Edit Delete
6509  01  004  343376  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6765  08  96  051  はくさい    はくさい    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete

Page 108 of 2156, showing 20 records out of 43118 total, starting on record 2141, ending on 2160

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