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
7975  03  62  56  農産物56    のうさんぶつ56    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
12583  01  002  20905112  農産物③    のうさんぶつ    2022-08-02 00:00:00    2022-08-02 09:30:00  MG00000001  2022-08-02 09:30:00  MG00000001  View Edit Delete
18471  01  002  20110803  野菜    やさい    2022-12-27 00:00:00    2022-12-27 10:46:14  MG00000001  2022-12-27 10:46:14  MG00000001  View Edit Delete
47655  01  031  100012  100012_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 15:55:32  MG00000007  2023-10-03 15:55:32  MG00000007  View Edit Delete
47911  01  033  59330  59330_農産物  岡山農産09330  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:54:44  MG00000007  2023-10-19 13:54:44  MG00000007  View Edit Delete
50983  01  036  105863  5863_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 10:11:23  MG00000007  2023-11-28 10:11:23  MG00000007  View Edit Delete
51495  01  033  50792  50792_農産物  岡山農産00792  のうさんぶつ    2024-01-19 00:00:00    2024-01-19 11:22:59  MG00000007  2024-01-19 11:22:59  MG00000007  View Edit Delete
40  01  001  40  ふき    ふき    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
296  01  002  20110282  野菜    やさい    2016-08-29 00:00:00    2016-08-30 12:24:40  MG00000001  2016-08-30 12:24:40  MG00000001  View Edit Delete
1064  01  005  12031  ブロッコリー 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
1576  01  007  6238  甘長しししとう  近郷野菜138  あまながししとう    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2600  01  006  7156  野菜  産直野菜156  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5160  07  81  38  農産物38    のうさんぶつ38    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5416  02  53  46  農産物46    のうさんぶつ46    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6184  05  71  89764  農産物    のうさんぶつ    2018-04-13 00:00:00    2018-04-13 11:34:46  MG00000001  2018-04-13 11:34:46  MG00000001  View Edit Delete
6440  01  004  398719  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6696  01  002  20110604  トマト    とまと    2018-08-30 00:00:00    2018-08-30 16:39:19  MG00000001  2019-04-25 09:16:36  MG00000001  View Edit Delete
6952  08  96  715  クインシー    くいんしー    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7208  08  97  664  ブラックチェリー    ぶらっくちぇりー    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7720  01  102  2400033508968   苺    いちご    2019-05-20 00:00:00            View Edit Delete

Page 39 of 2156, showing 20 records out of 43118 total, starting on record 761, ending on 780

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