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
6096  03  61  49  農産物49    のうさんぶつ49    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
6352  09  101  38038  農産物    のうさんぶつ    2018-07-06 00:00:00    2018-07-06 11:06:38  MG00000001  2018-07-06 11:06:38  MG00000001  View Edit Delete
6864  08  96  308  しそ    しそ    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7120  08  97  259  じゃがいも(とうや)    じゃがいもとうや    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7376  01  101  2082891040516   トリコフルーツ 青果70  トリコフルーツ 青果70  とりこふるーつせいかななじゅう    2019-03-05 00:00:00    2019-03-05 00:00:00  MG00000001  2019-03-05 00:00:00  MG00000001  View Edit Delete
7888  02  55  2132358  農産物    のうさんぶつ    2019-07-12 00:00:00    2019-07-12 10:33:24  MG00000001  2019-07-12 10:33:24  MG00000001  View Edit Delete
8144  01  021  2027198567212  白ねぎ    しろねぎ    2019-11-15 00:00:00    2019-11-15 09:55:26  MG00000001  2019-11-15 09:55:26  MG00000001  View Edit Delete
8400  08  96  272  里芋(赤目)    さといもあかめ    2020-04-20 00:00:00    2020-04-20 11:04:41  MG00000001  2020-04-20 11:04:41  MG00000001  View Edit Delete
9168  02  56  48  農産物48    のうさんぶつ48    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
10704  01  006  7208  野菜  産直野菜208  やさい    2021-06-21 00:00:00    2021-06-21 10:28:48  MG00000001  2021-06-21 10:28:48  MG00000001  View Edit Delete
12240  01  002  20110019  野菜    やさい    2022-06-22 00:00:00    2022-06-22 10:31:43  MG00000001  2022-06-22 10:31:43  MG00000001  View Edit Delete
18384  01  056  33222  農産物    のうさんぶつ    2022-11-28 00:00:00    2022-11-28 15:22:38  MG00000001  2022-11-28 15:22:38  MG00000001  View Edit Delete
47568  01  033  57785  57785_農産物  岡山農産07785  のうさんぶつ    2023-09-28 00:00:00    2023-09-28 14:16:46  MG00000007  2023-09-28 14:16:46  MG00000007  View Edit Delete
47824  01  033  59244  59244_農産物  岡山農産09244  のうさんぶつ    2023-10-18 00:00:00    2023-10-18 09:51:58  MG00000007  2023-10-18 09:51:58  MG00000007  View Edit Delete
50640  01  036  109102  農産物5_9102    のうさんぶつ    2023-11-13 00:00:00    2023-11-13 17:43:16  MG00000007  2023-11-13 17:43:16  MG00000007  View Edit Delete
51408  01  036  109219  2510921900000_農産物    のうさんぶつ    2023-12-26 00:00:00    2023-12-26 10:15:25  MG00000007  2023-12-26 10:15:25  MG00000007  View Edit Delete
977  01  003  457122595633  京の野菜ジャム九条ねぎ    きょうのやさいじゃむくじょうねぎ    2016-08-29 00:00:00    2016-08-30 12:24:43  MG00000001  2016-08-30 12:24:43  MG00000001  View Edit Delete
1233  01  005  21131  りんご 1P    りんご1    2016-07-01 00:00:00    2016-08-30 12:24:45  MG00000001  2016-08-30 12:24:45  MG00000001  View Edit Delete
1489  01  007  6080  トマト  近郷野菜81  とまと    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2513  01  006  7069  野菜  産直野菜69  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete

Page 219 of 2156, showing 20 records out of 43118 total, starting on record 4361, ending on 4380

(default) 2 queries took 34 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 4360, 20202025
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1119