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
43278  01  031  787625  787625_農産物25    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
43534  01  031  621529  621529_農産物29    のうさんぶつ    2023-06-23 00:00:00    2023-06-23 00:00:00  MG00000001  2023-06-23 00:00:00  MG00000001  View Edit Delete
43790  01  031  647715  647715_農産物15    のうさんぶつ    2023-06-23 00:00:00    2023-06-23 00:00:00  MG00000001  2023-06-23 00:00:00  MG00000001  View Edit Delete
44046  04  710  99448  農産物    のうさんぶつ    2023-06-28 00:00:00    2023-06-28 08:56:05  MG00000001  2023-06-28 08:56:05  MG00000001  View Edit Delete
44302  01  033  50148  50148_農産物  岡山農産00148  のうさんぶつ    2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
44558  01  033  50404  50404_農産物  岡山農産00404  のうさんぶつ    2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
44814  01  033  50660  50660_農産物  岡山農産00660  のうさんぶつ    2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
45070  01  034  80459  04590_農産物    のうさんぶつ    2023-07-19 00:00:00    2023-07-19 00:00:00  MG00000001  2023-07-19 00:00:00  MG00000001  View Edit Delete
46350  01  035  120240  12024_農産物  産地直送 果物24  のうさんぶつ    2023-08-25 00:00:00    2023-08-25 00:00:00  MG00000001  2023-08-25 00:00:00  MG00000001  View Edit Delete
46606  01  033  56518  56518_農産物  岡山農産06518  のうさんぶつ    2023-08-31 00:00:00    2023-08-31 00:00:00  MG00000001  2023-08-31 00:00:00  MG00000001  View Edit Delete
46862  01  033  57511  57511_農産物  岡山農産07511  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47118  01  033  57375  57375_農産物  岡山農産07375  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47374  01  033  59030  59030_農産物  岡山農産09030  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47630  01  032  51371  13710_農産物    のうさんぶつ    2023-09-29 00:00:00    2023-09-29 09:17:51  MG00000007  2023-09-29 09:17:51  MG00000007  View Edit Delete
47886  01  033  59305  59305_農産物  岡山農産09305  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:11:53  MG00000007  2023-10-19 13:11:53  MG00000007  View Edit Delete
48142  01  036  105188  5188_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48398  01  036  105451  5451_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48654  01  036  108203  8203_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48910  01  036  108466  8466_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49166  01  036  108731  8731_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete

Page 126 of 2156, showing 20 records out of 43118 total, starting on record 2501, ending on 2520

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