Cant create new product

INSERT IGNORE INTO `g4r9h_hikashop_product` ( `product_name`,`product_code`,`product_quantity`,`product_manufacturer_id`,`product_published`,`product_tax_id`,`product_msrp`,`product_page_title`,`product_url`,`product_meta_description`,`product_keywords`,`product_alias`,`product_canonical`,`product_min_per_order`,`product_max_per_order`,`product_sale_start`,`product_sale_end`,`product_access`,`product_warehouse_id`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_height`,`product_dimension_unit`,`product_layout`,`product_quantity_layout`,`beskrivelse`,`product_group_after_purchase`,`product_id`,`product_description`,`product_modified`,`product_created`,`product_type` ) VALUES ( 'test','test-008','-1','','1','488','','','','','','test','','0','0','','','all','','','kg','','','','m','','','','','0','<p>fgsdfsdgs</p>','1465458642','1465458642','main' ) **Explain** **EXPLAIN not possible on query: INSERT IGNORE INTO `g4r9h_hikashop_product` ( `product_name`,`product_code`,`product_quantity`,`product_manufacturer_id`,`product_published`,`product_tax_id`,`product_msrp`,`product_page_title`,`product_url`,`product_meta_description`,`product_keywords`,`product_alias`,`product_canonical`,`product_min_per_order`,`product_max_per_order`,`product_sale_start`,`product_sale_end`,`product_access`,`product_warehouse_id`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_height`,`product_dimension_unit`,`product_layout`,`product_quantity_layout`,`beskrivelse`,`product_group_after_purchase`,`product_id`,`product_description`,`product_modified`,`product_created`,`product_type` ) VALUES ( 'test','test-008','-1','','1','488','','','','','','test','','0','0','','','all','','','kg','','','','m','','','','','0','<p>fgsdfsdgs</p>','1465458642','1465458642','main' )** **Profile** **Call Stack** # **Caller** **File and line number** 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 15 JDatabase->query() JROOT/administrator/components/com_hikashop/helpers/helper.php:1702 14 hikashopClass->save() JROOT/administrator/components/com_hikashop/classes/product.php:1594 13 hikashopProductClass->save() JROOT/administrator/components/com_hikashop/classes/product.php:586 12 hikashopProductClass->backSaveForm() JROOT/administrator/components/com_hikashop/classes/product.php:50 11 hikashopProductClass->saveForm() JROOT/administrator/components/com_hikashop/helpers/helper.php:1465 10 hikashopController->store() JROOT/administrator/components/com_hikashop/helpers/helper.php:1401 9 hikashopController->apply() JROOT/libraries/legacy/controller/legacy.php:728 8 JControllerLegacy->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1630 7 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:54 6 require_once JROOT/administrator/components/com_hikashop/hikashop.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/administrator.php:98 3 JApplicationAdministrator->dispatch() JROOT/libraries/cms/application/administrator.php:152 2 JApplicationAdministrator->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/administrator/index.php:51 [**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

`g4r9h_extensions` SET `params` = '{\"mediaversion\":\"dfa3561fe8fe73d4a7c6e2f9abacc38c\"}' WHERE `type` = 'library' AND `element` = 'joomla' **Explain** id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g4r9h_extensions range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where **Profile** Status Duration starting 0.05 ms checking permissions 0.02 ms Opening tables 0.02 ms init 0.03 ms System lock 0.10 ms updating 176.41 ms end 0.05 ms query end 0.11 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.02 ms **Call Stack** # **Caller** **File and line number** 10 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/library/helper.php:119 9 JLibraryHelper::saveParams() JROOT/libraries/cms/version/version.php:325 8 JVersion->setMediaVersion() JROOT/libraries/cms/version/version.php:284 7 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:737 6 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 5 JFactory::getDocument() JROOT/libraries/joomla/application/web.php:991 4 JApplicationWeb->loadDocument() JROOT/libraries/cms/application/administrator.php:68 3 JApplicationAdministrator->dispatch() JROOT/libraries/cms/application/administrator.php:152 2 JApplicationAdministrator->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/administrator/index.php:51

57 Queries Logged 10331.60 ms 8 duplicate found! 2 duplicates: #21 #25 2 duplicates: #22 #26 2 duplicates: #47 #49 2 duplicates: #48 #50 Query Time: 7173.37 ms Query memory: 0.028 MB Memory before query: 2.772 MB Rows returned: 1 SELECT `data` FROM `g4r9h_session` WHERE `session_id` = 'f3f4f62952a5eaa9bd9abbc6562a2837' Explain Profile Call Stack Query Time: 9.59 ms After last query: 10.19 ms Query memory: 0.016 MB Memory before query: 3.599 MB Rows returned: 74 SELECT folder AS type, element AS name, params FROM g4r9h_extensions WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1,2,3,6) ORDER BY ordering Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g4r9h_extensions ref extension extension 82 const 169 100.00 Using index condition; Using where; Using filesort Profile Call Stack Query Time: 4.00 ms After last query: 9.83 ms Query memory: 0.013 MB Memory before query: 4.882 MB Rows returned: 1 SELECT `enabled` FROM `g4r9h_extensions` WHERE `element` = 'com_akeeba' AND `type` = 'component' Explain Profile Call Stack Query Time: 3.58 ms After last query: 7.24 ms Query memory: 0.019 MB Memory before query: 5.674 MB Rows returned: 1 SELECT extension_id AS id, element AS "option", params, enabled FROM g4r9h_extensions WHERE `type` = 'library' AND `element` = 'joomla' Explain Profile Call Stack Query Time: 2425.74 ms After last query: 1.22 ms Query memory: 0.012 MB Memory before query: 5.782 MB UPDATE `g4r9h_extensions` SET `params` = '{\"mediaversion\":\"efa09cc633d93ce56c76f3ea409975f8\"}' WHERE `type` = 'library' AND `element` = 'joomla' Explain Profile Call Stack Query Time: 3.87 ms After last query: 1.61 ms Query memory: 0.010 MB Memory before query: 5.998 MB Rows returned: 1 SELECT template, s.params FROM g4r9h_template_styles as s LEFT JOIN g4r9h_extensions as e ON e.type='template' AND e.element=s.template AND e.client_id=s.client_id WHERE s.client_id = 1 AND home = '1' ORDER BY home Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s ref idx_home idx_home 28 const 2 100.00 Using index condition; Using where; Using filesort 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 brianronnow_phimp.s.template,const 1 100.00 Using where Profile Call Stack Query Time: 3.88 ms After last query: 1.48 ms Query memory: 0.017 MB Memory before query: 6.135 MB Rows returned: 33 SELECT extension_id AS id, element AS "option", params, enabled FROM g4r9h_extensions WHERE `type` = 'component' Explain Profile Call Stack Query Time: 10.68 ms After last query: 21.23 ms Query memory: 0.027 MB Memory before query: 8.761 MB Rows returned: 320 SELECT * FROM g4r9h_hikashop_config Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g4r9h_hikashop_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 320 100.00 NULL Profile Call Stack Query Time: 505.53 ms After last query: 24.79 ms Query memory: 0.029 MB Memory before query: 11.456 MB Rows returned: 2 SELECT hk_parent.* FROM g4r9h_hikashop_category AS hk_cat LEFT JOIN g4r9h_hikashop_category AS hk_parent ON (hk_parent.category_left <= hk_cat.category_left AND hk_parent.category_right >= hk_cat.category_right) WHERE hk_cat.category_id IN (2) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hk_cat const PRIMARY PRIMARY 4 const 1 100.00 Using temporary; Using filesort 1 SIMPLE hk_parent ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 394 100.00 Using where Profile Call Stack Query Time: 5.35 ms After last query: 0.96 ms Query memory: 0.024 MB Memory before query: 11.569 MB Rows returned: 1 SELECT a.id FROM g4r9h_user_usergroup_map AS map LEFT JOIN g4r9h_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 606 Explain Profile Call Stack Query Time: 5.25 ms After last query: 0.15 ms Query memory: 0.026 MB Memory before query: 11.589 MB Rows returned: 1 SELECT * FROM g4r9h_hikashop_field as a WHERE a.`field_published` = 1 AND a.field_table='product' AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%') AND ((((field_with_sub_categories=0 AND (field_categories="all" OR field_categories="" OR field_categories LIKE '%,2,%'))OR (field_with_sub_categories=1 AND (field_categories="all" OR field_categories="" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%'))) AND field_products="") OR (field_products LIKE '%,0,%')) ORDER BY a.`field_ordering` ASC Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 23 100.00 Using where; Using filesort Profile Call Stack Query Time: 4.95 ms After last query: 1.14 ms Query memory: 0.024 MB Memory before query: 11.631 MB Rows returned: 1 SELECT field.* FROM g4r9h_hikashop_field as field WHERE field.field_table = 'product' ORDER BY field.`field_ordering` ASC Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE field ALL NULL NO INDEX KEY COULD BE USED NULL NULL 23 100.00 Using where; Using filesort Profile Call Stack Query Time: 5.83 ms After last query: 0.15 ms Query memory: 0.019 MB Memory before query: 11.655 MB Rows returned: 0 SELECT shipping_id FROM g4r9h_hikashop_shipping WHERE shipping_published=1 Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Profile Call Stack Query Time: 5.74 ms After last query: 2.83 ms Query memory: 0.021 MB Memory before query: 11.963 MB Rows returned: 1 SELECT category_id FROM g4r9h_hikashop_category WHERE category_type='root' LIMIT 1 Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g4r9h_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 394 100.00 Using where Profile Call Stack Query Time: 4.24 ms After last query: 0.13 ms Query memory: 0.020 MB Memory before query: 11.983 MB Rows returned: 1 SELECT category_id FROM g4r9h_hikashop_category WHERE category_parent_id=1 AND category_type='product' LIMIT 1 Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g4r9h_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 394 100.00 Using where Profile Call Stack Query Time: 9.26 ms After last query: 1.72 ms Query memory: 0.019 MB Memory before query: 12.126 MB Rows returned: 2 SELECT product_id FROM g4r9h_hikashop_product WHERE product_alias='test' Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g4r9h_hikashop_product ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6168 100.00 Using where Profile Call Stack Query Time: 11.89 ms After last query: 30.15 ms Query memory: 0.028 MB Memory before query: 15.102 MB Rows returned: 0 SELECT * FROM g4r9h_hikashop_massaction WHERE massaction_published=1 && massaction_triggers!='' Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Profile Call Stack Query Time: 3.93 ms After last query: 0.60 ms Query memory: 0.020 MB Memory before query: 15.129 MB INSERT IGNORE INTO `g4r9h_hikashop_product` ( `product_name`,`product_code`,`product_quantity`,`product_manufacturer_id`,`product_published`,`product_tax_id`,`product_msrp`,`product_page_title`,`product_url`,`product_meta_description`,`product_keywords`,`product_alias`,`product_canonical`,`product_min_per_order`,`product_max_per_order`,`product_sale_start`,`product_sale_end`,`product_access`,`product_warehouse_id`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_height`,`product_dimension_unit`,`product_layout`,`product_quantity_layout`,`beskrivelse`,`product_group_after_purchase`,`product_id`,`product_description`,`product_modified`,`product_created`,`product_type` ) VALUES ( 'test','test-009','-1','','1','488','','','','','','test','','0','0','','','all','','','kg','','','','m','','','','','0','','1465459487','1465459487','main' ) Explain Profile Call Stack Query Time: 8.92 ms After last query: 0.20 ms Query memory: 0.019 MB Memory before query: 15.148 MB Rows returned: 0 SELECT product_id FROM g4r9h_hikashop_product WHERE product_code = 'test-009' AND NOT (product_id = 0) LIMIT 0, 1 Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g4r9h_hikashop_product ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6168 100.00 Using where Profile Call Stack Query Time: 3.09 ms After last query: 36.85 ms Query memory: 0.027 MB Memory before query: 17.534 MB Rows returned: 1 SELECT c.* FROM g4r9h_hikashop_category AS c WHERE c.category_id IN (2) Explain Profile Call Stack Query Time: 3.77 ms After last query: 3.82 ms Query memory: 0.023 MB Memory before query: 17.825 MB Rows returned: 0 Duplicate queries: #25 SHOW TABLES LIKE 'g4r9h_falang_content' Explain Profile Call Stack Query Time: 4.53 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 17.847 MB Rows returned: 0 Duplicate queries: #26 SHOW TABLES LIKE 'g4r9h_jf_content' Explain Profile Call Stack Query Time: 3.49 ms After last query: 0.27 ms Query memory: 0.026 MB Memory before query: 17.871 MB Rows returned: 3 SELECT * FROM g4r9h_hikashop_currency WHERE (currency_published = 1) OR (currency_id IN (47,47)) Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g4r9h_hikashop_currency ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 181 100.00 Using where Profile Call Stack Query Time: 4.40 ms After last query: 0.63 ms Query memory: 0.029 MB Memory before query: 17.910 MB Rows returned: 1 SELECT * FROM g4r9h_hikashop_field as a WHERE a.`field_published` = 1 AND a.`field_display` LIKE '%;field\_product\_form=1;%' AND a.field_table='product' AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%') AND ((((field_with_sub_categories=0 AND (field_categories="all" OR field_categories="" OR field_categories LIKE '%,2,%'))OR (field_with_sub_categories=1 AND (field_categories="all" OR field_categories="" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%'))) AND field_products="") OR (field_products LIKE '%,0,%')) ORDER BY a.`field_ordering` ASC Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 23 100.00 Using where; Using filesort Profile Call Stack Query Time: 4.41 ms After last query: 3.89 ms Query memory: 0.029 MB Memory before query: 18.299 MB Rows returned: 0 Duplicate queries: #21 SHOW TABLES LIKE 'g4r9h_falang_content' Explain Profile Call Stack Query Time: 4.54 ms After last query: 0.13 ms Query memory: 0.029 MB Memory before query: 18.327 MB Rows returned: 0 Duplicate queries: #22 SHOW TABLES LIKE 'g4r9h_jf_content' Explain Profile Call Stack Query Time: 4.40 ms After last query: 0.17 ms Query memory: 0.034 MB Memory before query: 18.360 MB Rows returned: 4 SELECT c.* FROM g4r9h_hikashop_category AS c WHERE c.category_type IN ('product','root','vendor','manufacturer') AND c.category_depth >= 0 AND c.category_depth <= 1 ORDER BY c.category_parent_id ASC, c.category_ordering LIMIT 0, 200 Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 394 100.00 Using where; Using filesort Profile Call Stack Query Time: 2.99 ms After last query: 0.22 ms Query memory: 0.033 MB Memory before query: 18.412 MB Rows returned: 1 SELECT c.* FROM g4r9h_hikashop_category AS c WHERE c.category_id IN (2) Explain Profile Call Stack Query Time: 3.09 ms After last query: 0.14 ms Query memory: 0.033 MB Memory before query: 18.425 MB Rows returned: 0 SELECT c.* FROM g4r9h_hikashop_category AS c INNER JOIN g4r9h_hikashop_category AS cp ON (c.category_left <= cp.category_left AND c.category_right >= cp.category_left) WHERE cp.category_id IN (1) AND c.category_id > 1 Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE cp const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 394 99.75 Using where Profile Call Stack Query Time: 3.69 ms After last query: 0.68 ms Query memory: 0.033 MB Memory before query: 18.442 MB Rows returned: 0 SELECT c.* FROM g4r9h_hikashop_category AS c WHERE c.category_type IN ('manufacturer') AND c.category_namekey NOT IN ('manufacturer') ORDER BY c.category_name ASC LIMIT 0, 10 Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c ALL category_namekey NO INDEX KEY COULD BE USED NULL NULL 394 100.00 Using where; Using filesort Profile Call Stack Query Time: 2.84 ms After last query: 8.58 ms Query memory: 0.032 MB Memory before query: 18.980 MB Rows returned: 0 SELECT DISTINCT a.id AS value, a.path, a.title AS text, a.level, a.published, a.lft FROM g4r9h_tags AS a LEFT JOIN `g4r9h_tags` AS b ON a.lft > b.lft AND a.rgt < b.rgt WHERE `a`.`lft` > 0 AND a.published IN (0,1) ORDER BY a.lft ASC Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a range tag_idx,idx_left_right idx_left_right 4 NULL 1 100.00 Using index condition; Using where; Using temporary 1 SIMPLE b ALL idx_left_right NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Range checked for each record (index map: 0x20); Distinct Profile Call Stack Query Time: 3.04 ms After last query: 4.54 ms Query memory: 0.028 MB Memory before query: 19.207 MB Rows returned: 1 SELECT category_id FROM g4r9h_hikashop_category WHERE category_parent_id=0 LIMIT 1 Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g4r9h_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 394 100.00 Using where Profile Call Stack Query Time: 4.12 ms After last query: 0.28 ms Query memory: 0.028 MB Memory before query: 19.237 MB Rows returned: 2 SELECT a.category_name,a.category_id,a.category_namekey FROM g4r9h_hikashop_category AS a WHERE (a.category_type = 'tax') AND (a.category_parent_id != 1) AND (a.category_published = 1) ORDER BY a.category_ordering ASC Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 394 100.00 Using where; Using filesort Profile Call Stack Query Time: 2.64 ms After last query: 0.41 ms Query memory: 0.029 MB Memory before query: 19.267 MB Rows returned: 1 SELECT * FROM g4r9h_hikashop_currency WHERE currency_id IN (47) Explain Profile Call Stack Query Time: 2.85 ms After last query: 1.36 ms Query memory: 0.032 MB Memory before query: 19.382 MB Rows returned: 9 SELECT a.*, a.title as text, a.id as value FROM `g4r9h_usergroups` AS a ORDER BY a.lft ASC Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 9 100.00 Using filesort Profile Call Stack Query Time: 3.10 ms After last query: 11.31 ms Query memory: 0.039 MB Memory before query: 20.213 MB Rows returned: 1 SELECT * FROM g4r9h_wf_profiles WHERE published = 1 ORDER BY ordering ASC Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g4r9h_wf_profiles ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 100.00 Using where; Using filesort Profile Call Stack Query Time: 4.64 ms After last query: 8.18 ms Query memory: 0.044 MB Memory before query: 20.505 MB Rows returned: 17 SHOW FULL COLUMNS FROM `g4r9h_extensions` Explain Profile Call Stack Query Time: 5.33 ms After last query: 1.45 ms Query memory: 0.036 MB Memory before query: 20.607 MB Rows returned: 1 SELECT `extension_id` FROM `g4r9h_extensions` WHERE type = 'component' AND element = 'com_hikashop' Explain Profile Call Stack Query Time: 3.71 ms After last query: 0.38 ms Query memory: 0.040 MB Memory before query: 20.645 MB Rows returned: 1 SELECT * FROM g4r9h_extensions WHERE `extension_id` = '10000' Explain Profile Call Stack Query Time: 3.31 ms After last query: 0.69 ms Query memory: 0.040 MB Memory before query: 20.698 MB Rows returned: 1 SELECT `extension_id` FROM `g4r9h_extensions` WHERE type = 'plugin' AND folder = 'editors' AND element = 'jce' Explain Profile Call Stack Query Time: 2.93 ms After last query: 0.34 ms Query memory: 0.044 MB Memory before query: 20.739 MB Rows returned: 1 SELECT * FROM g4r9h_extensions WHERE `extension_id` = '10124' Explain Profile Call Stack Query Time: 3.07 ms After last query: 0.39 ms Query memory: 0.040 MB Memory before query: 20.781 MB Rows returned: 1 SELECT `extension_id` FROM `g4r9h_extensions` WHERE type = 'component' AND element = 'com_jce' Explain Profile Call Stack Query Time: 3.17 ms After last query: 0.35 ms Query memory: 0.044 MB Memory before query: 20.822 MB Rows returned: 1 SELECT * FROM g4r9h_extensions WHERE `extension_id` = '10123' Explain Profile Call Stack Query Time: 2.74 ms After last query: 9.51 ms Query memory: 0.038 MB Memory before query: 21.110 MB Rows returned: 1 SELECT id, template FROM g4r9h_template_styles WHERE client_id = 0 AND home = '1' Explain Profile Call Stack Query Time: 2.29 ms After last query: 25.29 ms Query memory: 0.028 MB Memory before query: 22.401 MB Rows returned: 0 SELECT warehouse_id, warehouse_name FROM g4r9h_hikashop_warehouse WHERE warehouse_published = 1 ORDER BY warehouse_name LIMIT 0, 30 Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Profile Call Stack Query Time: 2.32 ms After last query: 1.78 ms Query memory: 0.031 MB Memory before query: 22.552 MB Rows returned: 0 SELECT characteristic_value, characteristic_alias, characteristic_id FROM g4r9h_hikashop_characteristic WHERE characteristic_parent_id = 0 Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Profile Call Stack Query Time: 2.99 ms After last query: 0.77 ms Query memory: 0.034 MB Memory before query: 22.556 MB Rows returned: 4 Duplicate queries: #49 SELECT c.*, 0 as `base_depth` FROM g4r9h_hikashop_category AS c WHERE c.category_type IN ('product','manufacturer','vendor','root') AND c.category_depth >= 0 AND c.category_depth <= 1 ORDER BY c.category_left ASC, c.category_name ASC Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 394 100.00 Using where; Using filesort Profile Call Stack Query Time: 3.38 ms After last query: 0.30 ms Query memory: 0.039 MB Memory before query: 22.609 MB Rows returned: 0 Duplicate queries: #50 SELECT p.*, c.category_id FROM g4r9h_hikashop_product AS p INNER JOIN g4r9h_hikashop_product_category AS pc ON p.product_id = pc.product_id INNER JOIN g4r9h_hikashop_category AS c ON c.category_id = pc.category_id WHERE pc.category_id IN (0) ORDER BY c.category_left ASC, c.category_name ASC, p.product_name ASC LIMIT 0, 200 Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Profile Call Stack Query Time: 2.60 ms After last query: 0.53 ms Query memory: 0.035 MB Memory before query: 22.613 MB Rows returned: 4 Duplicate queries: #47 SELECT c.*, 0 as `base_depth` FROM g4r9h_hikashop_category AS c WHERE c.category_type IN ('product','manufacturer','vendor','root') AND c.category_depth >= 0 AND c.category_depth <= 1 ORDER BY c.category_left ASC, c.category_name ASC Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 394 100.00 Using where; Using filesort Profile Call Stack Query Time: 3.38 ms After last query: 0.25 ms Query memory: 0.039 MB Memory before query: 22.667 MB Rows returned: 0 Duplicate queries: #48 SELECT p.*, c.category_id FROM g4r9h_hikashop_product AS p INNER JOIN g4r9h_hikashop_product_category AS pc ON p.product_id = pc.product_id INNER JOIN g4r9h_hikashop_category AS c ON c.category_id = pc.category_id WHERE pc.category_id IN (0) ORDER BY c.category_left ASC, c.category_name ASC, p.product_name ASC LIMIT 0, 200 Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Profile Call Stack Query Time: 2.48 ms After last query: 3.82 ms Query memory: 0.033 MB Memory before query: 22.725 MB Rows returned: 9 SELECT a.*, a.title as text, a.id as value FROM g4r9h_usergroups AS a ORDER BY a.lft ASC Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 9 100.00 Using filesort Profile Call Stack Query Time: 2.60 ms After last query: 0.55 ms Query memory: 0.036 MB Memory before query: 22.763 MB Rows returned: 0 SELECT b.*, a.*, c.currency_symbol FROM g4r9h_hikashop_shipping AS a LEFT JOIN g4r9h_hikashop_shipping_price AS b ON a.shipping_id = b.shipping_id AND b.shipping_price_ref_id = 0 INNER JOIN g4r9h_hikashop_currency AS c ON c.currency_id = a.shipping_currency_id WHERE (a.shipping_params LIKE '%s:20:\"shipping_per_product\";s:1:\"1\"%' OR a.shipping_params LIKE '%s:20:\"shipping_per_product\";i:1%') AND (b.shipping_price_ref_id IS NULL OR (b.shipping_price_ref_id = 0 AND b.shipping_price_ref_type = 'product')) ORDER BY a.shipping_id, b.shipping_price_min_quantity Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Profile Call Stack Query Time: 3.15 ms After last query: 4.55 ms Query memory: 0.019 MB Memory before query: 22.794 MB Rows returned: 11 SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM g4r9h_modules AS m LEFT JOIN g4r9h_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN g4r9h_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2016-06-09 08:04:47') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2016-06-09 08:04:47') AND m.access IN (1,1,2,3,6) AND m.client_id = 1 AND (mm.menuid = 0 OR mm.menuid <= 0) ORDER BY m.position, m.ordering Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 25 100.00 Using index condition; Using where; Using filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 brianronnow_phimp.m.id 1 100.00 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 brianronnow_phimp.m.module,const 1 100.00 Using index condition; Using where Profile Call Stack Query Time: 2.54 ms After last query: 5.55 ms Query memory: 0.017 MB Memory before query: 22.943 MB Rows returned: 1 SELECT COUNT(*) FROM g4r9h_messages WHERE state = 0 AND user_id_to = 606 Explain Profile Call Stack Query Time: 3.17 ms After last query: 0.18 ms Query memory: 0.017 MB Memory before query: 22.961 MB Rows returned: 1 SELECT COUNT(session_id) FROM g4r9h_session WHERE guest = 0 AND client_id = 1 Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g4r9h_session ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Profile Call Stack Query Time: 2.31 ms After last query: 0.24 ms Query memory: 0.017 MB Memory before query: 22.977 MB Rows returned: 1 SELECT COUNT(session_id) FROM g4r9h_session WHERE guest = 0 AND client_id = 0 Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g4r9h_session ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Profile Call Stack Query Time: 2.90 ms After last query: 13.55 ms Query memory: 0.024 MB Memory before query: 23.258 MB Rows returned: 34 SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element FROM g4r9h_menu AS m LEFT JOIN g4r9h_extensions AS e ON m.component_id = e.extension_id WHERE m.client_id = 1 AND e.enabled = 1 AND m.id > 1 ORDER BY m.lft Explain id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref PRIMARY,idx_client_id_parent_id_alias_language,idx_componentid idx_client_id_parent_id_alias_language 1 const 34 100.00 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 brianronnow_phimp.m.component_id 1 100.00 Using where Profile Call Stack 40 Query Types Logged, Sorted by Occurrences. SELECT Tables: 3 × SELECT c.* FROM g4r9h_hikashop_category AS c 3 × SELECT category_id FROM g4r9h_hikashop_category 3 × SELECT * FROM g4r9h_extensions 3 × SELECT `extension_id` FROM `g4r9h_extensions` 2 × SELECT c.*, 0 as `base_depth` FROM g4r9h_hikashop_category AS c 2 × SELECT * FROM g4r9h_hikashop_currency 2 × SELECT * FROM g4r9h_hikashop_field as a 2 × SELECT product_id FROM g4r9h_hikashop_product 2 × SELECT p.*, c.category_id FROM g4r9h_hikashop_product AS p INNER JOIN g4r9h_hikashop_product_category AS pc ON p.product_id = pc.product_id INNER JOIN g4r9h_hikashop_category AS c ON c.category_id = pc.category_id 2 × SELECT extension_id AS id, element AS "option", params, enabled FROM g4r9h_extensions 2 × SELECT COUNT(session_id) FROM g4r9h_session 1 × SELECT warehouse_id, warehouse_name FROM g4r9h_hikashop_warehouse 1 × SELECT id, template FROM g4r9h_template_styles 1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element FROM g4r9h_menu AS m LEFT JOIN g4r9h_extensions AS e ON m.component_id = e.extension_id 1 × SELECT COUNT(*) FROM g4r9h_messages 1 × SELECT a.*, a.title as text, a.id as value FROM g4r9h_usergroups AS a 1 × SELECT b.*, a.*, c.currency_symbol FROM g4r9h_hikashop_shipping AS a LEFT JOIN g4r9h_hikashop_shipping_price AS b ON a.shipping_id = b.shipping_id AND b.shipping_price_ref_id = 0 INNER JOIN g4r9h_hikashop_currency AS c ON c.currency_id = a.shipping_currency_id 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM g4r9h_modules AS m LEFT JOIN g4r9h_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN g4r9h_extensions AS e ON e.element = m.module AND e.client_id = m.client_id 1 × SELECT characteristic_value, characteristic_alias, characteristic_id FROM g4r9h_hikashop_characteristic 1 × SELECT * FROM g4r9h_wf_profiles 1 × SELECT c.* FROM g4r9h_hikashop_category AS c INNER JOIN g4r9h_hikashop_category AS cp ON (c.category_left <= cp.category_left AND c.category_right >= cp.category_left) 1 × SELECT hk_parent.* FROM g4r9h_hikashop_category AS hk_cat LEFT JOIN g4r9h_hikashop_category AS hk_parent ON (hk_parent.category_left <= hk_cat.category_left AND hk_parent.category_right >= hk_cat.category_right) 1 × SELECT a.id FROM g4r9h_user_usergroup_map AS map LEFT JOIN g4r9h_usergroups AS a ON a.id = map.group_id 1 × SELECT * FROM g4r9h_hikashop_confi 1 × SELECT template, s.params FROM g4r9h_template_styles as s LEFT JOIN g4r9h_extensions as e ON e.type='template' AND e.element=s.template AND e.client_id=s.client_id 1 × SELECT folder AS type, element AS name, params FROM g4r9h_extensions 1 × SELECT `enabled` FROM `g4r9h_extensions` 1 × SELECT field.* FROM g4r9h_hikashop_field as field 1 × SELECT shipping_id FROM g4r9h_hikashop_shipping 1 × SELECT DISTINCT a.id AS value, a.path, a.title AS text, a.level, a.published, a.lft FROM g4r9h_tags AS a LEFT JOIN `g4r9h_tags` AS b ON a.lft > b.lft AND a.rgt < b.rgt 1 × SELECT a.category_name,a.category_id,a.category_namekey FROM g4r9h_hikashop_category AS a 1 × SELECT `data` FROM `g4r9h_session` 1 × SELECT c.* [code] FROM g4r9h_hikashop_category AS c 1 × SELECT * FROM g4r9h_hikashop_massaction 1 × SELECT a.*, a.title as text, a.id as value FROM `g4r9h_usergroups` AS a OTHER Tables: 2 × SHOW TABLES LIKE 'g4r9h_jf_content 2 × SHOW TABLES LIKE 'g4r9h_falang_content 1 × SHOW FULL COLUMNS FROM `g4r9h_extensions 1 × INSERT IGNORE INTO `g4r9h_hikashop_product` ( `product_name`,`product_code`,`product_quantity`,`product_manufacturer_id`,`product_published`,`product_tax_id`,`product_msrp`,`product_page_title`,`product_url`,`product_meta_description`,`product_keywords`,`product_alias`,`product_canonical`,`product_min_per_order`,`product_max_per_order`,`product_sale_start`,`product_sale_end`,`product_access`,`product_warehouse_id`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_height`,`product_dimension_unit`,`product_layout`,`product_quantity_layout`,`beskrivelse`,`product_group_after_purchase`,`product_id`,`product_description`,`product_modified`,`product_created`,`product_type` ) VALUES ( 'test','test-009','-1','','1','488','','','','','','test','','0','0','','','all','','','kg','','','','m','','','','','0','','1465459487','1465459487','main' 1 × UPDATE `g4r9h_extensions` SET `params` = '{\"mediaversion\":\"efa09cc633d93ce56c76f3ea409975f8\"}'