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
47895  01  033  59314  59314_農産物  岡山農産09314  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:29:02  MG00000007  2023-10-19 13:29:02  MG00000007  View Edit Delete
48151  01  036  105198  5198_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48407  01  036  105460  5460_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48663  01  036  108212  8212_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48919  01  036  108475  8475_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49175  01  036  108740  8740_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49431  01  033  57805  57805_農産物  岡山農産07805  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  View Edit Delete
49687  01  036  105595  5595_農産物    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 00:00:00  MG00000001  2023-10-25 00:00:00  MG00000001  View Edit Delete
49943  01  036  105677  5677_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50199  01  033  58231  8231_農産物  広島農産08231  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50455  01  033  58449  8449_農産物  広島農産08449  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50711  01  033  58316  8316_農産物  広島農産08316  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50967  01  036  105847  5847_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 09:40:31  MG00000007  2023-11-28 09:40:31  MG00000007  View Edit Delete
51223  01  031  696908  696908_農産物08    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51479  01  033  50776  50776_農産物  岡山農産00776  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:41:56  MG00000007  2024-01-18 17:41:56  MG00000007  View Edit Delete
24  01  001  24  キャベツ    きゃべつ    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1048  01  005  11072  ナス 2P    なす2    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
1304  01  005  25021  干し芋 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
2584  01  006  7140  野菜  産直野菜140  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
6424  01  004  343394  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete

Page 187 of 2156, showing 20 records out of 43118 total, starting on record 3721, ending on 3740

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