Debug Message - Perch Runway 3.1.5
[1] SELECT u.*, r.* FROM perch3_users u, perch3_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='b02020c3a2464044d06c98ec13f517a4' LIMIT 1
UPDATE perch3_users SET userHash='b09472d067c31c24dd8dbe71ea4fb54c' WHERE userID='1'
[43] SELECT settingID, settingValue, userID FROM perch3_settings WHERE userID=1 OR userID=0 ORDER BY userID ASC
Adding: Perch Forms Recaptcha
Adding: UI Explorer
Adding: ML Shop
[15] SELECT itemValue FROM perch3_menu_items WHERE itemType='app'
[1] SELECT * FROM perch3_shop_products WHERE productID='847' AND productDeleted IS NULL LIMIT 1
Using template: /templates/shop/products/product.html
[1] SELECT * FROM perch3_shop_brands WHERE brandID='1' AND brandDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_categories WHERE catID=1 LIMIT 1
[1] SELECT * FROM perch3_shop_currencies WHERE currencyActive=1 ORDER BY currencyID=28 DESC, currencyCode
[1] SELECT * FROM perch3_shop_currencies WHERE currencyActive=1 ORDER BY currencyID=28 DESC, currencyCode
[1] SELECT * FROM perch3_shop_currencies WHERE currencyActive=1 ORDER BY currencyID=28 DESC, currencyCode
[1] SELECT * FROM perch3_shop_tax_groups WHERE groupID='1' AND groupDeleted IS NULL LIMIT 1
UPDATE perch3_shop_products SET title='2-Handknopf kompl. 12V-24V', sku='ZE.32930', stock_level='999', productDynamicFields='{\"title_fr\":null,\"description\":{\"_flang\":\"markdown\",\"raw\":\"\",\"processed\":\"\"},\"image\":null,\"slug\":\"ze32930\",\"status\":\"1\",\"brand\":\"1\",\"category\":[\"1\"],\"catalog_only\":\"1\",\"price\":{\"28\":\"140.7\",\"_default\":\"140.7\"},\"sale_price\":{\"28\":\"140.7\",\"_default\":\"140.7\"},\"trade_price\":{\"28\":\"140.7\",\"_default\":\"140.7\"},\"on_sale\":null,\"tax_group\":\"1\",\"stock_status\":\"0\",\"stock_location\":\"1\",\"max_in_cart\":\"999\",\"requires_shipping\":\"0\",\"weight\":\"0\",\"width\":\"0\",\"height\":\"0\",\"depth\":\"0\",\"unit\":\"Stk.\",\"subtitle\":null,\"subtitle_fr\":null,\"option_1_number\":\"9\",\"option_1_item_number\":\"ZE.53783\",\"option_1_title\":\"Halter zu Aussensteuerung 1 Knopf\",\"option_1_title_fr\":null,\"option_2_number\":null,\"option_2_item_number\":null,\"option_2_title\":null,\"option_2_title_fr\":null,\"option_3_number\":null,\"option_3_item_number\":null,\"option_3_title\":null,\"option_3_title_fr\":null,\"option_4_number\":null,\"option_4_item_number\":null,\"option_4_title\":null,\"option_4_title_fr\":null,\"option_5_number\":null,\"option_5_item_number\":null,\"option_5_title\":null,\"option_5_title_fr\":null,\"option_6_number\":null,\"option_6_item_number\":null,\"option_6_title\":null,\"option_6_title_fr\":null,\"option_7_number\":null,\"option_7_item_number\":null,\"option_7_title\":null,\"option_7_title_fr\":null,\"option_8_number\":null,\"option_8_item_number\":null,\"option_8_title\":null,\"option_8_title_fr\":null,\"option_9_number\":null,\"option_9_item_number\":null,\"option_9_title\":null,\"option_9_title_fr\":null,\"option_10_number\":null,\"option_10_item_number\":null,\"option_10_title\":null,\"option_10_title_fr\":null,\"option_11_number\":null,\"option_11_item_number\":null,\"option_11_title\":null,\"option_11_title_fr\":null,\"option_12_number\":null,\"option_12_item_number\":null,\"option_12_title\":null,\"option_12_title_fr\":null,\"option_13_number\":null,\"option_13_item_number\":null,\"option_13_title\":null,\"option_13_title_fr\":null,\"option_14_number\":null,\"option_14_item_number\":null,\"option_14_title\":null,\"option_14_title_fr\":null,\"option_15_number\":null,\"option_15_item_number\":null,\"option_15_title\":null,\"option_15_title_fr\":null,\"search_field_proffix\":\"ZE.32930\\u00bf2-HANDKNOPF KOMPL. 12V-24V\\u00bfB1006\\u00bfBOUTON DE COMMANDE COMPL.\\u00bf1219\\u00bf\",\"search_field\":\"ZE.32930 2-Handknopf kompl. 12V-24V ZE.32930\\u00bf2-HANDKNOPF KOMPL. 12V-24V\\u00bfB1006\\u00bfBOUTON DE COMMANDE COMPL.\\u00bf1219\\u00bf\"}', productStockOnParent='1', productSlug='ze32930', productStatus='1', productUpdated='2019-11-27 08:29:57' WHERE productID='847'
No ids to log.
DELETE FROM perch3_shop_index WHERE itemKey='productID' AND itemID='847'
[1] SELECT * FROM perch3_shop_brands WHERE brandID='1' AND brandDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_categories WHERE catID=1 LIMIT 1
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=28 LIMIT 1
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=0 LIMIT 1
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=28 LIMIT 1
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=0 LIMIT 1
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=28 LIMIT 1
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=0 LIMIT 1
[1] SELECT * FROM perch3_shop_tax_groups WHERE groupID='1' AND groupDeleted IS NULL LIMIT 1
INSERT INTO perch3_shop_index (itemKey, itemID, indexKey, indexValue) VALUES ('productID',847,'title_fr',''),('productID',847,'description',''),('productID',847,'image',''),('productID',847,'slug','ze32930'),('productID',847,'status','1'),('productID',847,'brand','1'),('productID',847,'brand.title','xxx'),('productID',847,'brand.slug','xxx'),('productID',847,'brand.image',''),('productID',847,'brand.status','1'),('productID',847,'brand.brandID','1'),('productID',847,'brand.brandTitle','xxx'),('productID',847,'brand.brandCreated','2019-11-12 05:38:33'),('productID',847,'brand.brandUpdated','2019-11-12 05:38:33'),('productID',847,'brand.brandDeleted',''),('productID',847,'_category','products/default/'),('productID',847,'catalog_only','1'),('productID',847,'price','140.7'),('productID',847,'price.chf','140.7'),('productID',847,'sale_price','140.7'),('productID',847,'sale_price.chf','140.7'),('productID',847,'trade_price','140.7'),('productID',847,'trade_price.chf','140.7'),('productID',847,'on_sale',''),('productID',847,'tax_group','1'),('productID',847,'tax_group.groupID','1'),('productID',847,'tax_group.groupTitle','default'),('productID',847,'tax_group.groupSlug','default'),('productID',847,'tax_group.groupTaxRate','seller'),('productID',847,'tax_group.groupCreated','2019-11-12 05:36:10'),('productID',847,'tax_group.groupUpdated',''),('productID',847,'tax_group.groupDeleted',''),('productID',847,'stock_status','0'),('productID',847,'stock_location','1'),('productID',847,'max_in_cart','999'),('productID',847,'requires_shipping','0'),('productID',847,'weight','0'),('productID',847,'width','0'),('productID',847,'height','0'),('productID',847,'depth','0'),('productID',847,'unit','Stk.'),('productID',847,'subtitle',''),('productID',847,'subtitle_fr',''),('productID',847,'option_1_number','9'),('productID',847,'option_1_item_number','ZE.53783'),('productID',847,'option_1_title','Halter zu Aussensteuerung 1 Knopf'),('productID',847,'option_1_title_fr',''),('productID',847,'option_2_number',''),('productID',847,'option_2_item_number',''),('productID',847,'option_2_title',''),('productID',847,'option_2_title_fr',''),('productID',847,'option_3_number',''),('productID',847,'option_3_item_number',''),('productID',847,'option_3_title',''),('productID',847,'option_3_title_fr',''),('productID',847,'option_4_number',''),('productID',847,'option_4_item_number',''),('productID',847,'option_4_title',''),('productID',847,'option_4_title_fr',''),('productID',847,'option_5_number',''),('productID',847,'option_5_item_number',''),('productID',847,'option_5_title',''),('productID',847,'option_5_title_fr',''),('productID',847,'option_6_number',''),('productID',847,'option_6_item_number',''),('productID',847,'option_6_title',''),('productID',847,'option_6_title_fr',''),('productID',847,'option_7_number',''),('productID',847,'option_7_item_number',''),('productID',847,'option_7_title',''),('productID',847,'option_7_title_fr',''),('productID',847,'option_8_number',''),('productID',847,'option_8_item_number',''),('productID',847,'option_8_title',''),('productID',847,'option_8_title_fr',''),('productID',847,'option_9_number',''),('productID',847,'option_9_item_number',''),('productID',847,'option_9_title',''),('productID',847,'option_9_title_fr',''),('productID',847,'option_10_number',''),('productID',847,'option_10_item_number',''),('productID',847,'option_10_title',''),('productID',847,'option_10_title_fr',''),('productID',847,'option_11_number',''),('productID',847,'option_11_item_number',''),('productID',847,'option_11_title',''),('productID',847,'option_11_title_fr',''),('productID',847,'option_12_number',''),('productID',847,'option_12_item_number',''),('productID',847,'option_12_title',''),('productID',847,'option_12_title_fr',''),('productID',847,'option_13_number',''),('productID',847,'option_13_item_number',''),('productID',847,'option_13_title',''),('productID',847,'option_13_title_fr',''),('productID',847,'option_14_number',''),('productID',847,'option_14_item_number',''),('productID',847,'option_14_title',''),('productID',847,'option_14_title_fr',''),('productID',847,'option_15_number',''),('productID',847,'option_15_item_number',''),('productID',847,'option_15_title',''),('productID',847,'option_15_title_fr',''),('productID',847,'search_field_proffix','ZE.32930¿2-HANDKNOPF KOMPL. 12V-24V¿B1006¿BOUTON DE COMMANDE COMPL.¿1219¿'),('productID',847,'search_field','ZE.32930 2-Handknopf kompl. 12V-24V ZE.32930¿2-HANDKNOPF KOMPL. 12V-24V¿B1006¿BOUTON DE COMMANDE COMPL.¿1219¿'),('productID',847,'productID','847'),('productID',847,'title','2-Handknopf kompl. 12V-24V'),('productID',847,'sku','ZE.32930'),('productID',847,'productSlug','ze32930'),('productID',847,'stock_level','999'),('productID',847,'parentID',''),('productID',847,'productVariantDesc',''),('productID',847,'productOrder','1'),('productID',847,'productHasVariants','0'),('productID',847,'productStockOnParent','1'),('productID',847,'productTemplate','product.html'),('productID',847,'productCreated','2019-11-14 11:44:24'),('productID',847,'productUpdated','2019-11-27 08:29:57'),('productID',847,'productDeleted',''),('productID',847,'productStatus','1'),('productID',847,'itemID',''),('productID',847,'itemRowID',''),('productID',847,'_id',847)
[1] OPTIMIZE TABLE perch3_shop_index
DELETE FROM perch3_shop_search WHERE itemKey=847 AND itemType='product'
INSERT INTO perch3_shop_search(itemKey,itemType,searchBody) VALUES(847,'product',' ZE.32930 2-Handknopf kompl. 12V-24V ze32930 1 1 xxx xxx 1 1 xxx 2019-11-12 05:38:33 2019-11-12 05:38:33 default 1 1 1 default default seller 2019-11-12 05:36:10 0 999 1 999 0 0 0 0 0 Stk. 9 ZE.53783 Halter zu Aussensteuerung 1 Knopf ZE.32930¿2-HANDKNOPF KOMPL. 12V-24V¿B1006¿BOUTON DE COMMANDE COMPL.¿1219¿ ZE.32930 2-Handknopf kompl. 12V-24V ZE.32930¿2-HANDKNOPF KOMPL. 12V-24V¿B1006¿BOUTON DE COMMANDE COMPL.¿1219¿ ')
[1] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 0, 1
[8] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=1 ORDER BY mi.itemOrder ASC
[1] SELECT itemTitle FROM perch3_menu_items WHERE itemType='app' AND itemValue='perch_shop_products' LIMIT 1
[1] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 1, 10
[2] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=2 ORDER BY mi.itemOrder ASC
File: /addons/apps/perch_shop_products/modes/product.edit.post.php
[1] SELECT * FROM perch3_shop_brands WHERE 1=1 AND brandDeleted IS NULL ORDER BY brandTitle ASC
[1] SELECT * FROM perch3_categories c, perch3_category_sets s WHERE c.setID=s.setID AND s.setSlug='products' ORDER BY catTreePosition ASC
[1] SELECT * FROM perch3_categories WHERE catID=1 LIMIT 1
[1] SELECT * FROM perch3_shop_currencies WHERE currencyActive=1 ORDER BY currencyID=28 DESC, currencyCode
[1] SELECT * FROM perch3_shop_currencies WHERE currencyActive=1 ORDER BY currencyID=28 DESC, currencyCode
[1] SELECT * FROM perch3_shop_currencies WHERE currencyActive=1 ORDER BY currencyID=28 DESC, currencyCode
[1] SELECT * FROM perch3_shop_tax_groups WHERE 1=1 AND groupDeleted IS NULL ORDER BY groupTitle ASC
Mode: product.edit
Queries: 42
Memory: 1.6276