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
51465  01  033  50806  50806_農産物  岡山農産00806  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:15:29  MG00000007  2024-01-18 17:15:29  MG00000007  View Edit Delete
10  01  001  10  とうがん    とうがん    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1290  01  005  24023  オレンジ 3P    おれんじ3    2016-07-01 00:00:00    2016-08-30 12:24:45  MG00000001  2016-08-30 12:24:45  MG00000001  View Edit Delete
1546  01  007  6208  きゅうり  近郷野菜108  きゅうり    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2570  01  006  7126  野菜  産直野菜126  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5130  01  011  60711  農産物    のうさんぶつ    2017-12-05 00:00:00    2017-12-05 11:34:46  MG00000001  2017-12-05 11:34:46  MG00000001  View Edit Delete
5386  02  53  16  農産物16    のうさんぶつ16    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6410  02  52  1968  農産物    のうさんぶつ    2018-07-30 00:00:00    2018-07-30 11:42:47  MG00000001  2018-07-30 11:42:47  MG00000001  View Edit Delete
6922  08  96  605  洋なし(ラ・フランス)    ようなしらふらんす    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7178  08  97  515  レモン    れもん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7690  01  102  2400033508555   パプリカ    ぱぷりか    2019-05-20 00:00:00            View Edit Delete
7946  03  62  27  農産物27    のうさんぶつ27    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
11018  06  661  00017  はちく    はちく    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-10 09:39:04  MG00000001  View Edit Delete
11274  06  661  00275  山もも    やまもも    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11530  06  661  00531  もみがら    もみがら    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11786  06  661  00798  とり肉    とりにく    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12042  06  661  01056  金時芋苗    きんときいもなえ    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12298  04  710  89650  農産物    のうさんぶつ    2022-06-23 00:00:00    2022-06-23 11:26:53  MG00000001  2022-06-23 11:26:53  MG00000001  View Edit Delete
12554  01  053  61190  農産物    のうさんぶつ    2022-07-29 00:00:00    2022-07-29 13:16:29  MG00000001  2022-07-29 13:16:29  MG00000001  View Edit Delete
12810  01  056  32788  農産物    のうさんぶつ    2022-08-22 00:00:00    2022-08-22 12:42:10  MG00000001  2022-08-22 12:42:10  MG00000001  View Edit Delete

Page 85 of 2156, showing 20 records out of 43118 total, starting on record 1681, ending on 1700

(default) 2 queries took 31 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` asc LIMIT 1680, 20202022
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1119