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
46735  01  034  81120  81120_農産物1    のうさんぶつ    2023-09-08 00:00:00    2023-09-08 00:00:00  MG00000001  2023-09-08 00:00:00  MG00000001  View Edit Delete
46736  01  034  81121  81121_農産物2    のうさんぶつ    2023-09-08 00:00:00    2023-09-08 00:00:00  MG00000001  2023-09-08 00:00:00  MG00000001  View Edit Delete
46737  01  034  81122  81122_農産物3    のうさんぶつ    2023-09-08 00:00:00    2023-09-08 00:00:00  MG00000001  2023-09-08 00:00:00  MG00000001  View Edit Delete
46738  01  034  81123  81123_農産物4    のうさんぶつ    2023-09-08 00:00:00    2023-09-08 00:00:00  MG00000001  2023-09-08 00:00:00  MG00000001  View Edit Delete
46739  01  034  81124  81124_農産物5    のうさんぶつ    2023-09-08 00:00:00    2023-09-08 00:00:00  MG00000001  2023-09-08 00:00:00  MG00000001  View Edit Delete
46740  01  034  81125  81125_農産物6    のうさんぶつ    2023-09-08 00:00:00    2023-09-08 00:00:00  MG00000001  2023-09-08 00:00:00  MG00000001  View Edit Delete
46741  01  034  81126  81126_農産物7    のうさんぶつ    2023-09-08 00:00:00    2023-09-08 00:00:00  MG00000001  2023-09-08 00:00:00  MG00000001  View Edit Delete
46742  01  034  81127  81127_農産物8    のうさんぶつ    2023-09-08 00:00:00    2023-09-08 00:00:00  MG00000001  2023-09-08 00:00:00  MG00000001  View Edit Delete
46743  01  034  81128  81128_農産物9    のうさんぶつ    2023-09-08 00:00:00    2023-09-08 00:00:00  MG00000001  2023-09-08 00:00:00  MG00000001  View Edit Delete
46744  01  034  81129  81129_農産物10    のうさんぶつ    2023-09-08 00:00:00    2023-09-08 00:00:00  MG00000001  2023-09-08 00:00:00  MG00000001  View Edit Delete
46622  01  035  101920  10192_野菜  産地直送 野菜192  のうさんぶつ    2023-09-01 00:00:00    2023-09-01 00:00:00  MG00000001  2023-09-01 00:00:00  MG00000001  View Edit Delete
46623  01  035  101940  10194_野菜  産地直送 野菜194  のうさんぶつ    2023-09-01 00:00:00    2023-09-01 00:00:00  MG00000001  2023-09-01 00:00:00  MG00000001  View Edit Delete
46624  01  035  101950  10195_野菜  産地直送 野菜195  のうさんぶつ    2023-09-01 00:00:00    2023-09-01 00:00:00  MG00000001  2023-09-01 00:00:00  MG00000001  View Edit Delete
46625  01  035  101960  10196_野菜  産地直送 野菜196  のうさんぶつ    2023-09-01 00:00:00    2023-09-01 00:00:00  MG00000001  2023-09-01 00:00:00  MG00000001  View Edit Delete
46626  01  035  101970  10197_野菜  産地直送 野菜197  のうさんぶつ    2023-09-01 00:00:00    2023-09-01 00:00:00  MG00000001  2023-09-01 00:00:00  MG00000001  View Edit Delete
46627  01  035  101980  10198_野菜  産地直送 野菜198  のうさんぶつ    2023-09-01 00:00:00    2023-09-01 00:00:00  MG00000001  2023-09-01 00:00:00  MG00000001  View Edit Delete
46628  01  035  101990  10199_野菜  産地直送 野菜199  のうさんぶつ    2023-09-01 00:00:00    2023-09-01 00:00:00  MG00000001  2023-09-01 00:00:00  MG00000001  View Edit Delete
46629  01  035  102000  10200_野菜  産地直送 野菜200  のうさんぶつ    2023-09-01 00:00:00    2023-09-01 00:00:00  MG00000001  2023-09-01 00:00:00  MG00000001  View Edit Delete
46630  01  035  110650  11065_その他  産地直送 その他65  のうさんぶつ    2023-09-01 00:00:00    2023-09-01 00:00:00  MG00000001  2023-09-01 00:00:00  MG00000001  View Edit Delete
46631  01  035  110670  11067_その他  産地直送 その他65  のうさんぶつ    2023-09-01 00:00:00    2023-09-01 00:00:00  MG00000001  2023-09-01 00:00:00  MG00000001  View Edit Delete

Page 243 of 2156, showing 20 records out of 43118 total, starting on record 4841, ending on 4860

(default) 2 queries took 32 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_start_day` desc LIMIT 4840, 20202025
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117