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
49692  01  036  105600  5600_農産物    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 00:00:00  MG00000001  2023-10-25 00:00:00  MG00000001  View Edit Delete
49948  01  036  105682  5682_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50204  01  033  58228  8228_農産物  広島農産08228  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50460  01  033  58454  8454_農産物  広島農産08454  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50716  01  033  58321  8321_農産物  広島農産08321  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50972  01  036  105852  5852_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 09:46:50  MG00000007  2023-11-28 09:46:50  MG00000007  View Edit Delete
51228  01  031  696913  696913_農産物13    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51484  01  033  50781  50781_農産物  岡山農産00781  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:51:39  MG00000007  2024-01-18 17:51:39  MG00000007  View Edit Delete
29  01  001  29  レタス    れたす    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1053  01  005  11101  万願寺とうがらし 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
1565  01  007  6227  ミョウガ  近郷野菜127  みょうが    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2589  01  006  7145  野菜  産直野菜145  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
4125  01  006  7219  野菜  産直野菜219  やさい    2016-08-29 00:00:00    2017-10-20 19:37:34  MG00000001  2017-10-20 19:37:34  MG00000001  View Edit Delete
5149  07  81  27  農産物27    のうさんぶつ27    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5405  02  53  35  農産物35    のうさんぶつ35    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6173  08  93  496241001051  からし菜    からしな    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6429  01  004  398307  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6685  02  54  83062  農産物    のうさんぶつ    2018-08-20 00:00:00    2018-08-20 14:52:46  MG00000001  2018-08-20 14:52:46  MG00000001  View Edit Delete
6941  08  96  676  ナガノパープル    ながのぱーぷる    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7197  08  97  622  ネクタリン    ねくたりん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete

Page 245 of 2156, showing 20 records out of 43118 total, starting on record 4881, ending on 4900

(default) 2 queries took 27 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` desc LIMIT 4880, 20202020
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117