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
6430  01  004  398353  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6686  02  52  2018  農産物    のうさんぶつ    2018-08-20 00:00:00    2018-08-20 14:54:18  MG00000001  2018-08-20 14:54:18  MG00000001  View Edit Delete
6942  08  96  677  シャインマスカット    しゃいんますかっと    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7198  08  97  641  プラム    ぷらむ    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7710  01  102  2400033508838   とうもろこし    とうもろこし    2019-05-20 00:00:00            View Edit Delete
7966  03  62  47  農産物47    のうさんぶつ47    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
10782  01  011  68568  農産物    のうさんぶつ    2021-07-26 00:00:00    2021-07-26 16:52:48  MG00000001  2021-07-26 16:52:48  MG00000001  View Edit Delete
18462  01  002  20110341  野菜    やさい    2022-12-21 00:00:00    2022-12-21 10:50:59  MG00000001  2022-12-21 10:50:59  MG00000001  View Edit Delete
47646  01  033  56564  56564_農産物  岡山農産06564  のうさんぶつ    2023-09-29 00:00:00    2023-09-29 13:22:23  MG00000007  2023-09-29 13:22:23  MG00000007  View Edit Delete
47902  01  033  59321  59321_農産物  岡山農産09321  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:42:47  MG00000007  2023-10-19 13:42:47  MG00000007  View Edit Delete
50974  01  036  105854  5854_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 09:49:50  MG00000007  2023-11-28 09:49:50  MG00000007  View Edit Delete
51486  01  033  50783  50783_農産物  岡山農産00783  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:55:53  MG00000007  2024-01-18 17:55:53  MG00000007  View Edit Delete
31  01  001  31  グリーンリーフ    ぐりーんりーふ    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1055  01  005  11121  南瓜 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
2591  01  006  7147  野菜  産直野菜147  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5151  07  81  29  農産物29    のうさんぶつ29    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5407  02  53  37  農産物37    のうさんぶつ37    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6175  08  93  496241001053  モロヘイヤ    もろへいや    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6431  01  004  398361  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6687  02  52  2019  農産物    のうさんぶつ    2018-08-20 00:00:00    2018-08-20 14:56:02  MG00000001  2018-08-20 14:56:02  MG00000001  View Edit Delete

Page 30 of 2156, showing 20 records out of 43118 total, starting on record 581, ending on 600

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