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
39735  01  113  20903111  03111_農産物    のうさんぶつ    2023-04-11 00:00:00    2023-04-11 08:50:02  MG00000001  2023-04-11 08:50:02  MG00000001  View Edit Delete
39736  01  113  20903112  03112_農産物    のうさんぶつ    2023-04-11 00:00:00    2023-04-11 08:50:20  MG00000001  2023-04-11 08:50:20  MG00000001  View Edit Delete
39737  01  113  20903113  03113_農産物    のうさんぶつ    2023-04-11 00:00:00    2023-04-11 08:53:21  MG00000001  2023-04-11 08:53:21  MG00000001  View Edit Delete
39728  01  113  20903114  03114_農産物    のうさんぶつ    2023-04-11 00:00:00    2023-04-11 08:45:55  MG00000001  2023-04-11 08:45:55  MG00000001  View Edit Delete
39729  01  113  20903115  03115_農産物    のうさんぶつ    2023-04-11 00:00:00    2023-04-11 08:46:17  MG00000001  2023-04-11 08:46:17  MG00000001  View Edit Delete
39730  01  113  20903116  03116_農産物    のうさんぶつ    2023-04-11 00:00:00    2023-04-11 08:46:33  MG00000001  2023-04-11 08:46:33  MG00000001  View Edit Delete
19205  01  911  100415  0415_農産物1    のうさんぶつ    2023-04-10 00:00:00    2023-04-10 07:19:24  MG00000001  2023-04-10 07:19:24  MG00000001  View Edit Delete
19206  01  911  100416  0416_農産物2    のうさんぶつ    2023-04-10 00:00:00    2023-04-10 07:19:43  MG00000001  2023-04-10 07:19:43  MG00000001  View Edit Delete
19207  01  911  100417  0417_農産物3    のうさんぶつ    2023-04-10 00:00:00    2023-04-10 07:20:03  MG00000001  2023-04-10 07:20:03  MG00000001  View Edit Delete
42560  01  911  100422  0422_農産物1    のうさんぶつ    2023-04-14 00:00:00    2023-04-14 13:22:36  MG00000001  2023-04-14 13:22:36  MG00000001  View Edit Delete
42561  01  911  100423  0423_農産物2    のうさんぶつ    2023-04-14 00:00:00    2023-04-14 13:22:55  MG00000001  2023-04-14 13:22:55  MG00000001  View Edit Delete
42562  01  911  100424  0424_農産物3    のうさんぶつ    2023-04-14 00:00:00    2023-04-14 13:23:12  MG00000001  2023-04-14 13:23:12  MG00000001  View Edit Delete
42563  01  911  100425  0425_農産物1    のうさんぶつ    2023-04-14 00:00:00    2023-04-14 13:31:51  MG00000001  2023-04-14 13:31:51  MG00000001  View Edit Delete
42564  01  911  100426  0426_農産物2    のうさんぶつ    2023-04-14 00:00:00    2023-04-14 13:32:21  MG00000001  2023-04-14 13:32:21  MG00000001  View Edit Delete
42565  01  911  100427  0427_農産物3    のうさんぶつ    2023-04-14 00:00:00    2023-04-14 13:32:39  MG00000001  2023-04-14 13:32:39  MG00000001  View Edit Delete
42566  01  911  100428  0428_農産物4    のうさんぶつ    2023-04-14 00:00:00    2023-04-14 13:33:37  MG00000001  2023-04-14 13:33:37  MG00000001  View Edit Delete
43200  01  911  100429  0429_農産物1    のうさんぶつ    2022-11-01 00:00:00    2022-11-01 13:43:13  MG00000001  2022-11-01 13:43:13  MG00000001  View Edit Delete
43201  01  911  100430  0430_農産物2    のうさんぶつ    2022-11-01 00:00:00    2022-11-01 13:43:13  MG00000001  2022-11-01 13:43:13  MG00000001  View Edit Delete
43202  01  911  100431  0431_農産物3    のうさんぶつ    2022-11-01 00:00:00    2022-11-01 13:43:13  MG00000001  2022-11-01 13:43:13  MG00000001  View Edit Delete
43203  01  911  100432  0432_農産物4    のうさんぶつ    2022-11-01 00:00:00    2022-11-01 13:43:13  MG00000001  2022-11-01 13:43:13  MG00000001  View Edit Delete

Page 2 of 2156, showing 20 records out of 43118 total, starting on record 21, ending on 40

(default) 2 queries took 29 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`.`co_product_nm` asc LIMIT 20, 20202021
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1118