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
49927  01  036  109024  9024_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50183  01  033  58716  8716_農産物  岡山農産08716  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50439  01  033  58433  8433_農産物  広島農産08433  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50695  01  033  58300  8300_農産物  広島農産08300  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50951  01  036  109144  9144_農産物1    のうさんぶつ    2023-11-27 00:00:00    2023-11-27 00:00:00  MG00000001  2023-11-27 00:00:00  MG00000001  View Edit Delete
51207  01  031  600322  600322_農産物22    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  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
11016  06  661  00015  葉ごぼう    はごぼう    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-10 09:38:29  MG00000001  View Edit Delete

Page 68 of 2156, showing 20 records out of 43118 total, starting on record 1341, ending on 1360

(default) 2 queries took 25 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` asc LIMIT 1340, 20202018
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117