Label Logs

Id User Farmer Product Arrival Day Trader Company Cd Company Product Cd Company Product Nm Company Product Reciept Nm Sys Product Cd Shop Cd Label Issue Number Real Issue Number Price Amount Recycling Mark Flg Issue Day Brc Info Brc Shipment Product Characters Brc Shipment Product Cd Brc Price Cd Brc Price Characters Locality Cd Pickup Point Cd Amount Not Sel Flg Brc Not Print Flg Print Status Created Insert User Modified Update User Actions
1233921  AG01003807 1725682 2023-08-29 00:00:00  01  031 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34100  ALL9  40  2023-08-29 00:00:00  1770711300407  17707113  37  37002 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-08-29 08:42:59  AG01003807      View Edit Delete
1176833  AG01003807 2023-07-14 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34100  ALL9  40  2023-07-14 00:00:00  1770710300408  17707103  37  37002 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-07-14 09:13:41  AG01003807      View Edit Delete
188930  AG01001569 2019-03-12 00:00:00  01  002 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
31700  ALL9  18  18  40  2019-03-12 00:00:00  2011040400406  20110404  36  36001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2019-03-12 10:51:15  AG01001569      View Edit Delete
51972  AG01003303 44598 0000-00-00 00:00:00  01  011 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
31900  ALL9  40  2018-03-24 00:00:00  2760617800438  2760617  43  43001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2018-03-24 13:57:20  AG01003303      View Edit Delete
549125  AG01004465 2021-05-07 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
32800  ALL9  40  2021-05-07 00:00:00  1772423200402  17724232  37  37006 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2021-05-07 07:51:26  AG01004465      View Edit Delete
888581  AG03000001 55618 2022-08-01 00:00:00  03  61 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34100  SUR001  40  2022-08-01 00:00:00  0250125600405  0250125  20  SR01 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2022-08-01 06:57:16  AG03000001      View Edit Delete
687622  AG01004465 2021-10-18 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
41410  ALL9  40  2021-10-18 00:00:00  1772427200408  17724272  37  37006 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2021-10-18 09:31:31  AG01004465      View Edit Delete
1238534  AG03000001 55607 2023-09-02 00:00:00  03  61 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
31800  SUR001  40  2023-09-01 00:00:00  0250114600409  0250114  20  SR01 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-09-01 18:55:57  AG03000001      View Edit Delete
780294  AG01004360 2022-02-28 00:00:00  01  012 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
90001  ALL9  40  2022-02-28 00:00:00  0291320600401  0291320  33  33015 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2022-02-28 07:17:48  AG01004360      View Edit Delete
1005063  AG01004403 2022-12-21 00:00:00  01  012 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
30100  ALL9  40  2022-12-21 00:00:00  0291659600400  0291659  33  33015 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2022-12-21 07:47:01  AG01004403      View Edit Delete
1035783  AG01005249 2023-02-06 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
30100  ALL9  40  2023-02-06 00:00:00  1764763600400  17647636  36  36002 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-02-06 09:43:32  AG01005249      View Edit Delete
197384  AG03000004 55955 2019-04-08 00:00:00  03  61 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
30100  SUR001  40  2019-04-08 00:00:00  0250622600403  0250622  20  SR01 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2019-04-08 07:43:40  AG03000004      View Edit Delete
1381896  AG01004370 1743998 2023-12-24 00:00:00  01  033 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
90001  ALL9  40  2023-12-24 00:00:00  0254418600400  0254418  33  33015 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-12-24 12:56:50  AG01004370      View Edit Delete
1188617  AG03000001 55607 2023-07-24 00:00:00  03  61 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
31800  SUR001  40  2023-07-23 00:00:00  0250114600409  0250114  20  SR01 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-07-23 19:41:02  AG03000001      View Edit Delete
780041  AG01004428 2022-02-27 00:00:00  01  012 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
30100  ALL9  15  15  40  2022-02-27 00:00:00  0292223600406  0292223  33  33015 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2022-02-27 09:40:39  AG01004428      View Edit Delete
933387  AG01004453 2022-09-21 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
90006  ALL9  40  2022-09-21 00:00:00  1770773900409  17707739  37  37006 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2022-09-21 09:32:47  AG01004453      View Edit Delete
1264395  AG01005562 16675123 2023-09-24 00:00:00  01  033 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34300  ALL9  40  2023-09-24 00:00:00  0251713600401  0251713  33  33037 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-09-24 07:19:52  AG01005562      View Edit Delete
549133  AG01004469 2021-05-07 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
32800  ALL9  40  2021-05-07 00:00:00  1772833200405  17728332  37  37006 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2021-05-07 07:53:48  AG01004469      View Edit Delete
878605  AG03000014 56258 2022-07-22 00:00:00  03  61 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34100  SUR001  40  2022-07-22 00:00:00  0251325600400  0251325  20  SR01 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2022-07-22 07:00:36  AG03000014      View Edit Delete
1120015  AG01005249 1663349 2023-05-24 00:00:00  01  006 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
30100  ALL9  18  18  40  2023-05-24 00:00:00  0217078000447  0217078  36  36002 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-05-24 10:01:44  AG01005249      View Edit Delete

Page 221 of 70806, showing 20 records out of 1416111 total, starting on record 4401, ending on 4420

(default) 2 queries took 5909 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `LabelLog`.`id`, `LabelLog`.`user_id`, `LabelLog`.`farmer_product_id`, `LabelLog`.`sameday_sequence_no`, `LabelLog`.`arrival_day`, `LabelLog`.`trader_id`, `LabelLog`.`company_cd`, `LabelLog`.`co_product_cd`, `LabelLog`.`co_product_nm`, `LabelLog`.`co_product_reciept_nm`, `LabelLog`.`sys_product_cd`, `LabelLog`.`sys_product_nm`, `LabelLog`.`display_product_nm`, `LabelLog`.`display_product_fk`, `LabelLog`.`shop_cd`, `LabelLog`.`label_issue_number`, `LabelLog`.`Real_issue_number`, `LabelLog`.`price`, `LabelLog`.`amount`, `LabelLog`.`recycling_mark_flg`, `LabelLog`.`issue_day`, `LabelLog`.`brc_info`, `LabelLog`.`brc_shipment_product_characters`, `LabelLog`.`brc_shipment_product_cd`, `LabelLog`.`brc_price_cd`, `LabelLog`.`brc_price_characters`, `LabelLog`.`brc_type_flag`, `LabelLog`.`brc_mid_flag`, `LabelLog`.`val_pos_pattern`, `LabelLog`.`mid_checkdigit_flag`, `LabelLog`.`locality_cd`, `LabelLog`.`locality_nm`, `LabelLog`.`pickup_point_cd`, `LabelLog`.`amount_not_sel_flg`, `LabelLog`.`print_Status`, `LabelLog`.`created`, `LabelLog`.`insert_user`, `LabelLog`.`modified`, `LabelLog`.`update_user`, `User`.`id`, `User`.`login_id`, `User`.`user_nm`, `User`.`user_fk`, `User`.`user_type`, `User`.`password`, `User`.`mail_address_1`, `User`.`mail_address_2`, `User`.`login_rock_flg`, `User`.`last_login_day`, `User`.`use_start_day`, `User`.`use_end_day`, `User`.`del_flg`, `User`.`init_pass_flg`, `User`.`created`, `User`.`insert_user`, `User`.`modified`, `User`.`update_user`, `FarmerProduct`.`id`, `FarmerProduct`.`farmer_id`, `FarmerProduct`.`trader_id`, `FarmerProduct`.`cmp_product_id`, `FarmerProduct`.`company_cd`, `FarmerProduct`.`co_product_cd`, `FarmerProduct`.`sys_product_cd`, `FarmerProduct`.`display_product_nm`, `FarmerProduct`.`display_product_fk`, `FarmerProduct`.`display_locality`, `FarmerProduct`.`farmer_edit_status`, `FarmerProduct`.`brc_shipment_product_characters`, `FarmerProduct`.`brc_shipment_product_cd`, `FarmerProduct`.`brc_price_cd`, `FarmerProduct`.`brc_price_characters`, `FarmerProduct`.`company_shipment_cd`, `FarmerProduct`.`brc_type_flag`, `FarmerProduct`.`brc_mid_flag`, `FarmerProduct`.`val_pos_pattern`, `FarmerProduct`.`mid_checkdigit_flag`, `FarmerProduct`.`shipment_start_month`, `FarmerProduct`.`shipment_end_month`, `FarmerProduct`.`use_start_day`, `FarmerProduct`.`use_end_day`, `FarmerProduct`.`del_flg`, `FarmerProduct`.`created`, `FarmerProduct`.`insert_user`, `FarmerProduct`.`modified`, `FarmerProduct`.`update_user` FROM `sato_agri`.`label_logs` AS `LabelLog` LEFT JOIN `sato_agri`.`users` AS `User` ON (`LabelLog`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`farmer_products` AS `FarmerProduct` ON (`LabelLog`.`farmer_product_id` = `FarmerProduct`.`id`) WHERE 1 = 1 ORDER BY `LabelLog`.`price` asc LIMIT 4400, 202020987
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`label_logs` AS `LabelLog` LEFT JOIN `sato_agri`.`users` AS `User` ON (`LabelLog`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`farmer_products` AS `FarmerProduct` ON (`LabelLog`.`farmer_product_id` = `FarmerProduct`.`id`) WHERE 1 = 1114922