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
10759  02  51  784  ミント    みんと    2021-07-14 00:00:00    2021-07-14 15:41:41  MG00000001  2021-07-14 15:41:41  MG00000001  View Edit Delete
18439  01  113  20905278  野菜③    やさい    2022-12-19 00:00:00    2022-12-19 11:23:43  MG00000001  2022-12-19 11:23:43  MG00000001  View Edit Delete
19207  01  911  100417  0417_農産物3    のうさんぶつ    2023-04-10 00:00:00    2023-04-10 07:20:03  MG00000001  2023-04-10 07:20:03  MG00000001  View Edit Delete
46599  01  035  110600  11060_その他  産地直送 その他60  のうさんぶつ    2023-08-31 00:00:00    2023-08-31 13:49:24  MG00000001  2023-08-31 13:49:24  MG00000001  View Edit Delete
47623  01  034  81291  12910_農産物    のうさんぶつ    2023-09-28 00:00:00    2023-09-28 16:38:47  MG00000007  2023-09-28 16:38:47  MG00000007  View Edit Delete
47879  01  033  59298  59298_農産物  岡山農産09298  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 11:54:38  MG00000007  2023-10-19 11:54:38  MG00000007  View Edit Delete
49671  01  031  820603  820603_農産物3    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 11:42:31  MG00000007  2023-10-25 11:42:31  MG00000007  View Edit Delete
51463  01  033  50804  50804_農産物  岡山農産00804  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:12:33  MG00000007  2024-01-18 17:12:33  MG00000007  View Edit Delete
01  001  08  たかのつめ    たかのつめ    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1288  01  005  24021  オレンジ 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
1544  01  007  6206  伏見あまなが  近郷野菜106  ふしみあまなが    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2568  01  006  7124  野菜  産直野菜124  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5128  02  51  349  ポット苗    ぽっとなえ    2017-12-04 00:00:00            View Edit Delete
5384  02  53  14  農産物14    のうさんぶつ14    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6152  01  006  7293  小松菜  産直野菜293  こまつな    2018-04-02 00:00:00    2018-04-02 19:37:34  MG00000001  2018-04-02 19:37:34  MG00000001  View Edit Delete
6408  02  51  753  甘長とうがらし    あまながとうがらし    2018-07-19 00:00:00    2018-07-19 10:42:38  MG00000001  2018-07-19 10:42:38  MG00000001  View Edit Delete
6920  08  96  603  なし(南水)    なしなんすい    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7176  08  97  513  はっさく    はっさく    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7688  01  102  2400033508531   オクラ    おくら    2019-05-20 00:00:00            View Edit Delete
7944  03  62  25  農産物25    のうさんぶつ25    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete

Page 8 of 2156, showing 20 records out of 43118 total, starting on record 141, ending on 160

(default) 2 queries took 30 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 140, 20202020
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 11110