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
1404795  AG01005497 442 2024-01-15 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]
 
30100  ALL9  100  2024-01-14 00:00:00  1764772201001  17647722  36  36004 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-14 14:36:39  AG01005497      View Edit Delete
1404794  AG01005497 442 2024-01-15 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]
 
30100  ALL9  150  2024-01-14 00:00:00  1764772201506  17647722  36  36004 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-14 14:36:06  AG01005497      View Edit Delete
1404793  AG01005022 1556912 2024-01-17 00:00:00  01  911 
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]
 
30300  ALL9  100  100  138  2024-01-14 00:00:00  2510104001387  25101040  42  42112 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-14 14:35:44  AG01005022      View Edit Delete
1404792  AG01005497 442 2024-01-15 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]
 
30100  ALL9  160  2024-01-14 00:00:00  1764772201605  17647722  36  36004 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-14 14:35:40  AG01005497      View Edit Delete
1404791  AG01005497 449 2024-01-15 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]
 
33200  ALL9  130  2024-01-14 00:00:00  1764772901307  17647729  36  36004 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-14 14:35:10  AG01005497      View Edit Delete
1404790  AG01005022 16684609 2024-01-17 00:00:00  01  066 
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]
 
30300  ALL9  60  60  138  2024-01-14 00:00:00  2404200501387  24042005  42  42112 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-14 14:35:03  AG01005022      View Edit Delete
1404789  AG01003855 1724860 2024-01-15 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]
 
33300  ALL9  80  2024-01-14 00:00:00  1772500100809  17725001  37  37003 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-14 14:34:53  AG01003855      View Edit Delete
1404788  AG01004359 16680497 2024-01-14 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]
 
34460  ALL9  36  36  198  2024-01-14 00:00:00  0254333501981  0254333  33  33015 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-14 14:34:35  AG01004359      View Edit Delete
1404787  AG01004359 16680498 2024-01-14 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]
 
34460  ALL9  36  36  198  2024-01-14 00:00:00  0254334501980  0254334  33  33015 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-14 14:34:18  AG01004359      View Edit Delete
1404786  AG01005022 16684609 2024-01-16 00:00:00  01  066 
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]
 
30300  ALL9  60  60  138  2024-01-14 00:00:00  2404200501387  24042005  42  42112 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-14 14:34:11  AG01005022      View Edit Delete
1404785  AG01004359 16677921 2024-01-14 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]
 
34400  ALL9  32  32  198  2024-01-14 00:00:00  0254331501983  0254331  33  33015 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-14 14:34:00  AG01004359      View Edit Delete
1404784  AG01006029 16686188 2024-01-15 00:00:00  01  036 
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]
 
31100  ALL9  140  2024-01-14 00:00:00  2510922901401  25109229  42  41002 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-14 14:32:48  AG01006029      View Edit Delete
1404783  AG01005022 1556912 2024-01-16 00:00:00  01  911 
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]
 
30300  ALL9  100  100  138  2024-01-14 00:00:00  2510104001387  25101040  42  42112 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-14 14:32:30  AG01005022      View Edit Delete
1404782  AG01006029 16686190 2024-01-15 00:00:00  01  036 
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]
 
36300  ALL9  200  2024-01-14 00:00:00  2510923102005  25109231  42  41002 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-14 14:32:06  AG01006029      View Edit Delete
1404781  AG01006029 16686194 2024-01-15 00:00:00  01  036 
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]
 
36200  ALL9  10  10  140  2024-01-14 00:00:00  2510923501402  25109235  42  41002 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-14 14:31:15  AG01006029      View Edit Delete
1404780  AG01003636 1731880 2024-01-15 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]
 
38100  ALL9  400  400  280  2024-01-14 00:00:00  1770280102808  17702801  37  37006 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-14 14:29:16  AG01003636      View Edit Delete
1404779  AG01003855 1724860 2024-01-15 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]
 
33300  ALL9  43  43  80  2024-01-14 00:00:00  1772500100809  17725001  37  37003 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-14 14:28:43  AG01003855      View Edit Delete
1404778  AG01003636 1731880 2024-01-15 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]
 
38100  ALL9  100  100  128  2024-01-14 00:00:00  1770280101283  17702801  37  37006 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-14 14:27:22  AG01003636      View Edit Delete
1404777  AG01005082 1557074 2024-01-15 00:00:00  01  911 
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  130  2024-01-14 00:00:00  2510134601304  25101346  42  42112 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-14 14:11:21  AG01005082      View Edit Delete
1404776  AG01004982 1556959 2024-01-15 00:00:00  01  911 
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]
 
34270  ALL9  107  107  130  2024-01-14 00:00:00  2510109101303  25101091  42  42112 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-14 14:10:29  AG01004982      View Edit Delete

Page 665 of 70806, showing 20 records out of 1416111 total, starting on record 13281, ending on 13300

(default) 2 queries took 6226 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`.`id` desc LIMIT 13280, 20202056
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 = 1116170