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
40749  01  033  55004  55004_農産物  岡山農産05004  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
41005  01  033  56066  56066_農産物  岡山農産06066  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
41261  01  033  56327  56327_農産物  香川農産06327  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
41517  01  033  55417  55417_農産物  岡山農産05417  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
41773  01  033  53473  53473_農産物  岡山農産03473  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
42029  01  033  52957  52957_農産物  岡山農産02957  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
42285  01  033  52713  52713_農産物  岡山農産02713  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
42541  01  033  53499  53499_農産物  岡山農産03499  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
42797  01  031  612906  612906_農産物6    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
43053  01  031  661808  661808_農産物08    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
43309  01  031  696726  696726_農産物26    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
43565  01  031  629130  629130_農産物30    のうさんぶつ    2023-06-23 00:00:00    2023-06-23 00:00:00  MG00000001  2023-06-23 00:00:00  MG00000001  View Edit Delete
43821  01  031  647916  647916_農産物16    のうさんぶつ    2023-06-23 00:00:00    2023-06-23 00:00:00  MG00000001  2023-06-23 00:00:00  MG00000001  View Edit Delete
44077  01  031  695518  695518_農産物18    のうさんぶつ    2023-06-28 00:00:00    2023-06-28 00:00:00  MG00000001  2023-06-28 00:00:00  MG00000001  View Edit Delete
44333  01  033  50179  50179_農産物  岡山農産00179  のうさんぶつ    2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
44589  01  033  50435  50435_農産物  岡山農産00435  のうさんぶつ    2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
44845  01  033  50691  50691_農産物  岡山農産00691  のうさんぶつ    2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
45101  01  033  51663  51663_農産物  岡山農産01663  のうさんぶつ    2023-07-25 00:00:00    2023-07-25 12:20:34  MG00000001  2023-07-25 12:20:34  MG00000001  View Edit Delete
46125  01  033  51198  51198_農産物  岡山農産01198  のうさんぶつ    2023-08-21 00:00:00    2023-08-21 16:19:29  MG00000001  2023-08-21 16:19:29  MG00000001  View Edit Delete
46381  01  035  101710  10171_農産物  産地直送 野菜171  のうさんぶつ    2023-08-25 00:00:00    2023-08-25 00:00:00  MG00000001  2023-08-25 00:00:00  MG00000001  View Edit Delete

Page 386 of 2156, showing 20 records out of 43118 total, starting on record 7701, ending on 7720

(default) 2 queries took 31 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 7700, 20202024
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117