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
17173  01  066  091  ぶどう(種無し)    ぶどう    2022-10-21 00:00:00    2022-10-21 14:11:11  MG00000001  2022-10-21 14:11:11  MG00000001  View Edit Delete
17429  01  911  103775  農産物71    のうさんぶつ    2022-11-01 00:00:00    2022-11-01 13:43:13  MG00000001  2022-11-01 13:43:13  MG00000001  View Edit Delete
17685  01  911  104017  農産物⑬    のうさんぶつ    2022-11-01 00:00:00    2022-11-01 13:43:13  MG00000001  2022-11-01 13:43:13  MG00000001  View Edit Delete
17941  01  911  104266  農産物112    のうさんぶつ    2022-11-01 00:00:00    2022-11-01 13:43:13  MG00000001  2022-11-01 13:43:13  MG00000001  View Edit Delete
18197  01  911  104508  農産物54    のうさんぶつ    2022-11-01 00:00:00    2022-11-01 13:43:13  MG00000001  2022-11-01 13:43:13  MG00000001  View Edit Delete
18453  01  002  20110417  野菜    やさい    2022-12-20 00:00:00    2022-12-20 11:01:12  MG00000001  2022-12-20 11:01:12  MG00000001  View Edit Delete
18709  01  032  85362  85362_野菜    やさい    2023-03-27 00:00:00    2023-03-27 10:18:00  MG00000001  2023-03-27 10:18:00  MG00000001  View Edit Delete
18965  01  034  80439  80439_農産物    のうさんぶつ    2023-03-27 00:00:00    2023-03-27 14:32:06  MG00000001  2023-03-27 14:32:06  MG00000001  View Edit Delete
19221  01  031  665814  665814_農産物14    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
19477  01  031  694730  694730_農産物30    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
19733  01  031  657216  657216_農産物16    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
19989  01  031  666002  666002_農産物02    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
20245  01  031  659618  659618_農産物18    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
20501  01  031  685304  685304_農産物04    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
20757  01  031  680220  680220_農産物20    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
21013  01  031  671806  671806_農産物06    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
21269  01  031  689422  689422_農産物22    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
21525  01  031  658808  658808_農産物08    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
21781  01  031  657424  657424_農産物24    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
22037  01  031  642810  642810_農産物10    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete

Page 180 of 2156, showing 20 records out of 43118 total, starting on record 3581, ending on 3600

(default) 2 queries took 54 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 3580, 20202037
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 11117