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
142  01  001  88  虫・魚    むし・さかな    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
1166  01  005  17091  みょうが 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
2446  01  006  7002  野菜  産直野菜2  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
2702  02  51  747  イタドリ    いたどり    2017-02-27 00:00:00            View Edit Delete
3982  01  003  19  菊菜    きくな    2017-03-15 00:00:00            View Edit Delete
4494  02  51  122  チマサンチュ    ちまさんちゅ    2017-10-27 00:00:00            View Edit Delete
5006  05  71  89621  農産物    のうさんぶつ    2017-11-01 00:00:00    2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete
5262  02  52  1667  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
5518  08  91  496241001023  長葱    ながねぎ    2018-03-02 00:00:00    2018-03-02 00:00:00  MG00000001  2018-03-02 09:21:23  MG00000001  View Edit Delete
6030  08  93  496241001033  ナ花    なばな    2018-03-20 00:00:00    2018-03-20 11:25:12  MG00000001  2018-03-20 11:25:12  MG00000001  View Edit Delete
6286  09  101  38063  農産物    のうさんぶつ    2018-06-18 00:00:00    2018-06-18 13:01:14  MG00000001  2018-06-18 13:01:14  MG00000001  View Edit Delete
6542  01  004  499628  果物    くだもの    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6798  08  96  111  パセリ    ぱせり    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 17:08:09  MG00000001  View Edit Delete
7054  08  97  067  ターサイ    たーさい    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 17:03:00  MG00000001  View Edit Delete
7310  01  101  2082891039435   トリコフルーツ 青果4  トリコフルーツ 青果4  とりこふるーつせいかよん    2019-03-05 00:00:00    2019-03-05 00:00:00  MG00000001  2019-03-05 00:00:00  MG00000001  View Edit Delete
7822  02  51  752  えごま    えごま    2019-06-25 00:00:00    2019-06-25 08:58:49  MG00000001  2019-06-25 08:58:49  MG00000001  View Edit Delete
8590  01  004  499553  刀根柿    とねがき    2020-09-29 00:00:00    2020-09-29 11:25:40  MG00000005  2020-10-15 10:41:46  MG00000005  View Edit Delete
10894  01  112  20905068  農産物    のうさんぶつ    2021-11-08 00:00:00    2021-11-08 11:59:22  MG00000001  2021-11-08 11:59:22  MG00000001  View Edit Delete
12174  01  002  20110759  野菜    やさい    2022-06-06 00:00:00    2022-06-06 11:17:56  MG00000001  2022-06-06 11:17:56  MG00000001  View Edit Delete
12686  01  002  20120255  果実    かじつ    2022-08-16 00:00:00    2022-08-16 12:07:56  MG00000001  2022-08-16 12:07:56  MG00000001  View Edit Delete

Page 146 of 2156, showing 20 records out of 43118 total, starting on record 2901, ending on 2920

(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`.`limited_user_id` asc LIMIT 2900, 20202019
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1118