Error importing from virtuemart

Database Queries 27 Queries Logged 21.6 ms 14 duplicate found! 2 duplicates: #11 #18 2 duplicates: #12 #19 2 duplicates: #14 #20 2 duplicates: #15 #21 2 duplicates: #16 #22 2 duplicates: #17 #23 2 duplicates: #24 #25 Query Time: 0.16 ms Query memory: 0.013 MB Memory before query: 2.516 MB Rows returned: 1 SELECT `data` FROM `j3_session` WHERE `session_id` = 'bd80114189ccbbf84f300950750baa27' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_session const PRIMARY PRIMARY 602 const 1 Profile Error The 'SHOW PROFILES' feature is disabled; you need MySQL built with 'enable-profiling' to have it working SQL=SHOW PROFILES Call Stack JROOT/libraries/joomla/session/storage/database.php:44 JROOT/libraries/joomla/session/session.php:665 JROOT/libraries/joomla/session/session.php:603 JROOT/libraries/cms/application/cms.php:739 JROOT/libraries/cms/application/cms.php:131 JROOT/libraries/cms/application/administrator.php:45 JROOT/libraries/cms/application/cms.php:399 JROOT/libraries/joomla/factory.php:125 JROOT/administrator/index.php:39 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.17 ms After last query: 2.00 ms Query memory: 0.008 MB Memory before query: 2.694 MB DELETE FROM `j3_session` WHERE `time` '1430899767' Explain EXPLAIN not possible on query: DELETE FROM `j3_session` WHERE `time` '1430899767' Profile No SHOW PROFILE (maybe because there are more than 100 queries) Cal Stack JROOT/libraries/cms/application/cms.php:756 JROOT/libraries/cms/application/cms.php:131 JROOT/libraries/cms/application/administrator.php:45 JROOT/libraries/cms/application/cms.php:399 JROOT/libraries/joomla/factory.php:125 JROOT/administrator/index.php:39 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 1.53 ms After last query: 10.58 ms Query memory: 0.011 MB Memory before query: 3.325 MB Rows returned: 88 SELECT folder AS type, element AS name, params FROM j3_extensions WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1,2,3) ORDER BY ordering Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_extensions ref extension extension 62 const 160 Using where; Using filesort Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/cms/plugin/helper.php:310 JROOT/libraries/cms/plugin/helper.php:86 JROOT/libraries/cms/plugin/helper.php:128 JROOT/libraries/cms/application/cms.php:640 JROOT/libraries/cms/application/administrator.php:294 JROOT/libraries/cms/applicationadministrator.php:116 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.51 ms After last query: 32.76 ms Query memory: 0.018 MB Memory before query: 5.620 MB Rows returned: 38 SELECT extension_id AS id, element AS "option", params, enabled FROM j3_extensions WHERE `type` = 'component' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_extensions ref extension extension 62 const 38 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/cache/controller/callback.php:157 JROOT/libraries/cms/component/helper.php:434 JROOT/libraries/cms/component/helper.php:43 JROOT/libraries/cms/component/helper.php:119 JROOT/plugins/system/k2/k2.php:435 JROOT/libraries/joomla/event/event.php:69 JROOT/libraries/joomla/event/dispatcher.php:160 JROOT/libraries/joomla/application/base.php:83 JROOT/libraries/cms/application/cms.php:654 JROOT/libraries/cms/application/administrator.php:294 JROOT/libraries/cms/application/administrator.php:116 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.36 ms After last query: 14.37 ms Query memory: 0.022 MB Memory before query: 6.294 MB Rows returned: 1 SELECT extension_id AS id, element AS "option", params, enabled FROM j3_extensions WHERE `type` = 'library' AND `element` = 'joomla' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/cache/controller/callback.php:157 JROOT/libraries/cms/library/helper.php:156 JROOT/libraries/cms/library/helper.php:47 JROOT/libraries/cms/library/helper.php:90 JROOT/libraries/cms/version/version.php:177 JROOT/libraries/joomla/factory.php:736 JROOT/libraries/joomla/factory.php:216 JROOT/plugins/system/sef/sef.php:28 JROOT/libraries/joomla/event/event.php:69 JROOT/libraries/joomla/event/dispatcher.php:160 JROOT/libraries/joomla/application/base.php:83 JROOT/libraries/cms/application/administrator.php:457 JROOT/libraries/cms/application/administrator.php:137 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 9.13 ms After last query: 2.12 ms Query memory: 0.017 MB Memory before query: 6.402 MB UPDATE `j3_extensions` SET `params` = '{\"mediaversion\":\"6262967d85df0fcb2b9fa3a905fe000e\"}' WHERE `type` = 'library' AND `element` = 'joomla' Explain EXPLAIN not possible on query: UPDATE `j3_extensions` SET `params` = '{\"mediaversion\":\"6262967d85df0fcb2b9fa3a905fe000e\"}' WHERE `type` = 'library' AND `element` = 'joomla' Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/cms/library/helper.php:119 JROOT/libraries/cms/version/version.php:228 JROOT/libraries/cms/version/version.php:187 JROOT/libraries/joomla/factory.php:736 JROOT/libraries/joomla/factory.php:216 JROOT/plugins/system/sef/sef.php:28 JROOT/libraries/joomla/event/event.php:69 JROOT/libraries/joomla/event/dispatcher.php:160 JROOT/libraries/joomla/application/base.php:83 JROOT/libraries/cms/application/administrator.php:457 JROOT/libraries/cms/application/administrator.php:137 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.35 ms After last query: 2.75 ms Query memory: 0.008 MB Memory before query: 6.621 MB Rows returned: 1 SELECT template, s.params FROM j3_template_styles as s LEFT JOIN j3_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 Extra 1 SIMPLE s ref idx_home idx_home 21 const 1 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 303 ssahota_lec3.s.template,const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/cms/application/administrator.php:212 JROOT/libraries/cms/application/administrator.php:82 JROOT/libraries/cms/application/administrator.php:152 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.63 ms After last query: 36.56 ms Query memory: 0.015 MB Memory before query: 9.088 MB Rows returned: 367 SELECT * FROM j3_hikashop_config Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_hikashop_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 367 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/classes/config.php:16 JROOT/administrator/components/com_hikashop/helpers/helper.php:973 JROOT/administrator/components/com_hikashop/helpers/helper.php:3287 JROOT/administrator/components/com_hikashop/hikashop.php:14 JROOT/libraries/cms/component/helper.php:391 JROOT/libraries/cms/component/helper.php:371 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:152 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.28 ms After last query: 20.75 ms Query memory: 0.017 MB Memory before query: 11.098 MB Rows returned: 1 SELECT a.id FROM j3_user_usergroup_map AS map LEFT JOIN j3_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 630 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE map ref PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 ssahota_lec3.map.group_id 1 Using index Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/access/access.php:332 JROOT/administrator/components/com_hikashop/helpers/helper.php:152 JROOT/administrator/components/com_hikashop/classes/field.php:109 JROOT/administrator/components/com_hikashop/helpers/import.php:68 JROOT/administrator/components/com_hikashop/helpers/helper.php:1065 JROOT/administrator/components/com_hikashop/controllers/import.php:25 JROOT/administrator/components/com_hikashop/hikashop.php:52 JROOT/libraries/cms/component/helper.php:391 JROOT/libraries/cms/component/helper.php:371 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:152 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.19 ms After last query: 0.17 ms Query memory: 0.015 MB Memory before query: 11.112 MB Rows returned: 0 SELECT * FROM j3_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,%') ORDER BY a.`field_ordering` ASC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 15 Using where; Using filesort Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/classes/field.php:111 JROOT/administrator/components/com_hikashop/helpers/import.php:68 JROOT/administrator/components/com_hikashop/helpers/helper.php:1065 JROOT/administrator/components/com_hikashop/controllers/import.php:25 JROOT/administrator/components/com_hikashop/hikashop.php:52 JROOT/libraries/cms/component/helper.php:391 JROOT/libraries/cms/component/helper.php:371 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:152 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 1.41 ms After last query: 0.13 ms Query memory: 0.015 MB Memory before query: 11.131 MB Rows returned: 45 Duplicate queries: #18 SHOW FULL COLUMNS FROM `j3_hikashop_product` Explain EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `j3_hikashop_product` Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/helpers/import.php:85 JROOT/administrator/components/com_hikashop/helpers/helper.php:1065 JROOT/administrator/components/com_hikashop/controllers/import.php:25 JROOT/administrator/components/com_hikashop/hikashop.php:52 JROOT/libraries/cms/component/helper.php:391 JROOT/libraries/cms/component/helper.php:371 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:152 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.19 ms After last query: 1.56 ms Query memory: 0.015 MB Memory before query: 11.209 MB Rows returned: 6 Duplicate queries: #19 SELECT * FROM j3_hikashop_characteristic ORDER BY characteristic_parent_id ASC, characteristic_ordering ASC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_hikashop_characteristic ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6 Using filesort Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/classes/characteristic.php:82 JROOT/administrator/components/com_hikashop/helpers/import.php:89 JROOT/administrator/components/com_hikashop/helpers/helper.php:1065 JROOT/administrator/components/com_hikashop/controllers/import.php:25 JROOT/administrator/components/com_hikashop/hikashop.php:52 JROOT/libraries/cms/component/helper.php:391 JROOT/libraries/cms/component/helper.php:371 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:152 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.19 ms After last query: 5.48 ms Query memory: 0.016 MB Memory before query: 11.631 MB Rows returned: 1 SELECT category_id FROM j3_hikashop_category WHERE category_type='root' LIMIT 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 109 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/classes/category.php:397 JROOT/administrator/components/com_hikashop/classes/category.php:414 JROOT/administrator/components/com_hikashop/helpers/import.php:95 JROOT/administrator/components/com_hikashop/helpers/helper.php:1065 JROOT/administrator/components/com_hikashop/controllers/import.php:25 JROOT/administrator/components/com_hikashop/hikashop.php:52 JROOT/libraries/cms/component/helper.php:391 JROOT/libraries/cms/component/helper.php:371 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:152 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.09 ms After last query: 0.12 ms Query memory: 0.015 MB Memory before query: 11.647 MB Rows returned: 1 Duplicate queries: #20 SELECT category_id FROM j3_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 Extra 1 SIMPLE j3_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 109 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/classes/category.php:416 JROOT/administrator/components/com_hikashop/helpers/import.php:95 JROOT/administrator/components/com_hikashop/helpers/helper.php:1065 JROOT/administrator/components/com_hikashop/controllers/import.php:25 JROOT/administrator/components/com_hikashop/hikashop.php:52 JROOT/libraries/cms/component/helper.php:391 JROOT/libraries/cms/component/helper.php:371 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:152 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.09 ms After last query: 0.10 ms Query memory: 0.015 MB Memory before query: 11.663 MB Rows returned: 1 Duplicate queries: #21 SELECT category_id FROM j3_hikashop_category WHERE category_parent_id=1 AND category_type='manufacturer' LIMIT 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 109 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/classes/category.php:416 JROOT/administrator/components/com_hikashop/helpers/import.php:97 JROOT/administrator/components/com_hikashop/helpers/helper.php:1065 JROOT/administrator/components/com_hikashop/controllers/import.php:25 JROOT/administrator/components/com_hikashop/hikashop.php:52 JROOT/libraries/cms/component/helper.php:391 JROOT/libraries/cms/component/helper.php:371 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:152 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.08 ms After last query: 0.11 ms Query memory: 0.015 MB Memory before query: 11.678 MB Rows returned: 1 Duplicate queries: #22 SELECT category_id FROM j3_hikashop_category WHERE category_parent_id=1 AND category_type='tax' LIMIT 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 109 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/classes/category.php:416 JROOT/administrator/components/com_hikashop/helpers/import.php:99 JROOT/administrator/components/com_hikashop/helpers/helper.php:1065 JROOT/administrator/components/com_hikashop/controllers/import.php:25 JROOT/administrator/components/com_hikashop/hikashop.php:52 JROOT/libraries/cms/component/helper.php:391 JROOT/libraries/cms/component/helper.php:371 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:152 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.19 ms After last query: 0.10 ms Query memory: 0.014 MB Memory before query: 11.694 MB Rows returned: 3 Duplicate queries: #23 SELECT category_id FROM j3_hikashop_category WHERE category_type='tax' && category_parent_id=3 ORDER BY category_ordering DESC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 109 Using where; Using filesort Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/helpers/import.php:101 JROOT/administrator/components/com_hikashop/helpers/helper.php:1065 JROOT/administrator/components/com_hikashop/controllers/import.php:25 JROOT/administrator/components/com_hikashop/hikashop.php:52 JROOT/libraries/cms/component/helper.php:391 JROOT/libraries/cms/component/helper.php:371 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:152 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 1.49 ms After last query: 8.09 ms Query memory: 0.018 MB Memory before query: 12.415 MB Rows returned: 45 Duplicate queries: #11 SHOW FULL COLUMNS FROM `j3_hikashop_product` Explain EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `j3_hikashop_product` Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/helpers/import.php:85 JROOT/administrator/components/com_hikashop/helpers/importvm.php:24 JROOT/administrator/components/com_hikashop/helpers/helper.php:1062 JROOT/administrator/components/com_hikashop/controllers/import.php:50 JROOT/libraries/legacy/controller/legacy.php:728 JROOT/administrator/components/com_hikashop/helpers/helper.php:1489 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:391 JROOT/libraries/cms/component/helper.php:371 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:152 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.16 ms After last query: 0.73 ms Query memory: 0.018 MB Memory before query: 12.443 MB Rows returned: 6 Duplicate queries: #12 SELECT * FROM j3_hikashop_characteristic ORDER BY characteristic_parent_id ASC, characteristic_ordering ASC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_hikashop_characteristic ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6 Using filesort Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/classes/characteristic.php:82 JROOT/administrator/components/com_hikashop/helpers/import.php:89 JROOT/administrator/components/com_hikashop/helpers/importvm.php:24 JROOT/administrator/components/com_hikashop/helpers/helper.php:1062 JROOT/administrator/components/com_hikashop/controllers/import.php:50 JROOT/libraries/legacy/controller/legacy.php:728 JROOT/administrator/components/com_hikashop/helpers/helper.php:1489 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:391 JROOT/libraries/cms/component/helper.php:371 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:152 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.14 ms After last query: 0.47 ms Query memory: 0.018 MB Memory before query: 12.476 MB Rows returned: 1 Duplicate queries: #14 SELECT category_id FROM j3_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 Extra 1 SIMPLE j3_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 109 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/classes/category.php:416 JROOT/administrator/components/com_hikashop/helpers/import.php:95 JROOT/administrator/components/com_hikashop/helpers/importvm.php:24 JROOT/administrator/components/com_hikashop/helpers/helper.php:1062 JROOT/administrator/components/com_hikashop/controllers/import.php:50 JROOT/libraries/legacy/controller/legacy.php:728 JROOT/administrator/components/com_hikashop/helpers/helper.php:1489 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:391 JROOT/libraries/cms/component/helper.php:371 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:152 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.09 ms After last query: 0.12 ms Query memory: 0.018 MB Memory before query: 12.495 MB Rows returned: 1 Duplicate queries: #15 SELECT category_id FROM j3_hikashop_category WHERE category_parent_id=1 AND category_type='manufacturer' LIMIT 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 109 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/classes/category.php:416 JROOT/administrator/components/com_hikashop/helpers/import.php:97 JROOT/administrator/components/com_hikashop/helpers/importvm.php:24 JROOT/administrator/components/com_hikashop/helpers/helper.php:1062 JROOT/administrator/components/com_hikashop/controllers/import.php:50 JROOT/libraries/legacy/controller/legacy.php:728 JROOT/administrator/components/com_hikashop/helpers/helper.php:1489 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:391 JROOT/libraries/cms/component/helper.php:371 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:152 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.08 ms After last query: 0.10 ms Query memory: 0.018 MB Memory before query: 12.514 MB Rows returned: 1 Duplicate queries: #16 SELECT category_id FROM j3_hikashop_category WHERE category_parent_id=1 AND category_type='tax' LIMIT 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 109 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/classes/category.php:416 JROOT/administrator/components/com_hikashop/helpers/import.php:99 JROOT/administrator/components/com_hikashop/helpers/importvm.php:24 JROOT/administrator/components/com_hikashop/helpers/helper.php:1062 JROOT/administrator/components/com_hikashop/controllers/import.php:50 JROOT/libraries/legacy/controller/legacy.php:728 JROOT/administrator/components/com_hikashop/helpers/helper.php:1489 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:391 JROOT/libraries/cms/component/helper.php:371 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:152 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.18 ms After last query: 0.10 ms Query memory: 0.017 MB Memory before query: 12.533 MB Rows returned: 3 Duplicate queries: #17 SELECT category_id FROM j3_hikashop_category WHERE category_type='tax' && category_parent_id=3 ORDER BY category_ordering DESC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 109 Using where; Using filesort Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/helpers/import.php:101 JROOT/administrator/components/com_hikashop/helpers/importvm.php:24 JROOT/administrator/components/com_hikashop/helpers/helper.php:1062 JROOT/administrator/components/com_hikashop/controllers/import.php:50 JROOT/libraries/legacy/controller/legacy.php:728 JROOT/administrator/components/com_hikashop/helpers/helper.php:1489 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:391 JROOT/libraries/cms/component/helper.php:371 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:152 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.91 ms After last query: 0.15 ms Query memory: 0.014 MB Memory before query: 12.546 MB Rows returned: 1 Duplicate queries: #25 SHOW TABLES LIKE 'j3_virtuemart_products' Explain EXPLAIN not possible on query: SHOW TABLES LIKE 'j3_virtuemart_products' Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/controllers/import.php:53 JROOT/libraries/legacy/controller/legacy.php:728 JROOT/administrator/components/com_hikashop/helpers/helper.php:1489 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:391 JROOT/libraries/cms/component/helper.php:371 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:152 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.88 ms After last query: 0.28 ms Query memory: 0.017 MB Memory before query: 12.563 MB Rows returned: 1 Duplicate queries: #24 SHOW TABLES LIKE 'j3_virtuemart_products' Explain EXPLAIN not possible on query: SHOW TABLES LIKE 'j3_virtuemart_products' Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/helpers/importvm.php:101 JROOT/administrator/components/com_hikashop/helpers/importvm.php:63 JROOT/administrator/components/com_hikashop/controllers/import.php:120 JROOT/administrator/components/com_hikashop/controllers/import.php:73 JROOT/libraries/legacy/controller/legacy.php:728 JROOT/administrator/components/com_hikashop/helpers/helper.php:1489 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:391 JROOT/libraries/cms/component/helper.php:371 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:152 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 0.86 ms After last query: 0.14 ms Query memory: 0.017 MB Memory before query: 12.582 MB Rows returned: 1 SHOW TABLES LIKE 'j3_virtuemart_products_en_gb' Explain EXPLAIN not possible on query: SHOW TABLES LIKE 'j3_virtuemart_products_en_gb' Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/helpers/importvm.php:116 JROOT/administrator/components/com_hikashop/helpers/importvm.php:63 JROOT/administrator/components/com_hikashop/controllers/import.php:120 JROOT/administrator/components/com_hikashop/controllers/import.php:73 JROOT/libraries/legacy/controller/legacy.php:728 JROOT/administrator/components/com_hikashop/helpers/helper.php:1489 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:391 JROOT/libraries/cms/component/helper.php:371 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:152 JROOT/libraries/cms/application/cms.php:252 JROOT/administrator/index.php:42 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] Query Time: 1.29 ms After last query: 2.29 ms Query memory: 0.003 MB Memory before query: 12.741 MB UPDATE `j3_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:13;s:19:\"session.timer.start\";i:1430900528;s:18:\"session.timer.last\";i:1430900662;s:17:\"session.timer.now\";i:1430900667;s:22:\"session.client.browser\";s:109:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.135 Safari/537.36\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":4:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}s:10:\"com_config\";O:8:\"stdClass\":1:{s:6:\"config\";O:8:\"stdClass\":1:{s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"data\";a:91:{s:7:\"offline\";s:1:\"0\";s:15:\"offline_message\";s:69:\"This site is down for maintenance.Please check back again soon.\";s:23:\"display_offline_message\";s:1:\"1\";s:13:\"offline_image\";s:0:\"\";s:8:\"sitename\";s:3:\"LEC\";s:6:\"editor\";s:7:\"tinymce\";s:7:\"captcha\";s:9:\"recaptcha\";s:10:\"list_limit\";s:2:\"20\";s:6:\"access\";s:1:\"1\";s:5:\"debug\";s:1:\"1\";s:10:\"debug_lang\";s:1:\"0\";s:6:\"dbtype\";s:6:\"mysqli\";s:4:\"host\";s:9:\"localhost\";s:4:\"user\";s:13:\"ssahota_d3m03\";s:8:\"password\";s:8:\"W33tab!X\";s:2:\"db\";s:12:\"ssahota_lec3\";s:8:\"dbprefix\";s:3:\"j3_\";s:9:\"live_site\";s:0:\"\";s:6:\"secret\";s:16:\"VNPXIAXQprnBBNMk\";s:4:\"gzip\";s:1:\"0\";s:15:\"error_reporting\";s:7:\"maximum\";s:7:\"helpurl\";s:90:\"https://help.joomla.org/proxy/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\";s:8:\"ftp_host\";s:0:\"\";s:8:\"ftp_port\";s:0:\"\";s:8:\"ftp_user\";s:0:\"\";s:8:\"ftp_pass\";s:0:\"\";s:8:\"ftp_root\";s:0:\"\";s:10:\"ftp_enable\";s:1:\"0\";s:6:\"offset\";s:3:\"UTC\";s:10:\"mailonline\";s:1:\"1\";s:6:\"mailer\";s:4:\"mail\";s:8:\"mailfrom\";s:20:\"sales@leconcepts.com\";s:8:\"fromname\";s:21:\"Leading Edge Concepts\";s:8:\"sendmail\";s:18:\"/usr/sbin/sendmail\";s:8:\"smtpauth\";s:1:\"0\";s:8:\"smtpuser\";s:0:\"\";s:8:\"smtppass\";s:0:\"\";s:8:\"smtphost\";s:9:\"localhost\";s:10:\"smtpsecure\";s:4:\"none\";s:8:\"smtpport\";s:2:\"25\";s:7:\"caching\";s:1:\"0\";s:13:\"cache_handler\";s:4:\"file\";s:9:\"cachetime\";s:2:\"15\";s:8:\"MetaDesc\";s:0:\"\";s:8:\"MetaKeys\";s:0:\"\";s:9:\"MetaTitle\";s:1:\"1\";s:10:\"MetaAuthor\";s:1:\"0\";s:11:\"MetaVersion\";s:1:\"0\";s:6:\"robots\";s:0:\"\";s:3:\"sef\";s:1:\"1\";s:11:\"sef_rewrite\";s:1:\"1\";s:10:\"sef_suffix\";s:1:\"0\";s:12:\"unicodeslugs\";s:1:\"0\";s:10:\"feed_limit\";s:2:\"10\";s:8:\"log_path\";s:31:\"/home/demo3lec/public_html/logs\";s:8:\"tmp_path\";s:30:\"/home/demo3lec/public_html/tmp\";s:8:\"lifetime\";s:2:\"15\";s:15:\"session_handler\";s:8:\"database\";s:16:\"memcache_persist\";s:1:\"1\";s:17:\"memcache_compress\";s:1:\"0\";s:20:\"memcache_server_host\";s:9:\"localhost\";s:20:\"memcache_server_port\";s:5:\"11211\";s:17:\"memcached_persist\";s:1:\"1\";s:18:\"memcached_compress\";s:1:\"0\";s:21:\"memcached_server_host\";s:9:\"localhost\";s:21:\"memcached_server_port\";s:5:\"11211\";s:13:\"redis_persist\";s:1:\"1\";s:17:\"redis_server_host\";s:9:\"localhost\";s:17:\"redis_server_port\";s:4:\"6379\";s:17:\"redis_server_auth\";s:0:\"\";s:15:\"redis_server_db\";s:1:\"0\";s:12:\"proxy_enable\";s:1:\"0\";s:10:\"proxy_host\";s:0:\"\";s:10:\"proxy_port\";s:0:\"\";s:10:\"proxy_user\";s:0:\"\";s:10:\"proxy_pass\";s:0:\"\";s:11:\"massmailoff\";s:1:\"1\";s:10:\"MetaRights\";s:0:\"\";s:19:\"sitename_pagetitles\";s:1:\"1\";s:9:\"force_ssl\";s:1:\"0\";s:28:\"session_memcache_server_host\";s:9:\"localhost\";s:28:\"session_memcache_server_port\";s:5:\"11211\";s:29:\"session_memcached_server_host\";s:9:\"localhost\";s:29:\"session_memcached_server_port\";s:5:\"11211\";s:12:\"frontediting\";s:1:\"1\";s:10:\"feed_email\";s:6:\"author\";s:13:\"cookie_domain\";s:0:\"\";s:11:\"cookie_path\";s:0:\"\";s:8:\"asset_id\";i:1;s:7:\"filters\";a:8:{i:1;a:3:{s:11:\"filter_type\";s:2:\"NH\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:6;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:7;a:3:{s:11:\"filter_type\";s:4:\"NONE\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:2;a:3:{s:11:\"filter_type\";s:2:\"NH\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:3;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:4;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:5;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:8;a:3:{s:11:\"filter_type\";s:4:\"NONE\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}}s:5:\"rules\";a:10:{s:15:\"core.login.site\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:1:\"1\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:16:\"core.login.admin\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:18:\"core.login.offline\";a:8:{i:1;s:0:\"\";i:6;s:0:\"\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:10:\"core.admin\";a:8:{i:1;s:0:\"\";i:6;s:0:\"\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:1:\"1\";}s:11:\"core.manage\";a:8:{i:1;s:0:\"\";i:6;s:0:\"\";i:7;s:1:\"1\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:11:\"core.create\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:1:\"1\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:11:\"core.delete\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:9:\"core.edit\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:1:\"1\";i:5;s:0:\"\";i:8;s:0:\"\";}s:15:\"core.edit.state\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:1:\"1\";i:8;s:0:\"\";}s:13:\"core.edit.own\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:1:\"1\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}}}}}}s:22:\"com_hikashopvmvmPrefix\";s:3:\"j3_\";s:22:\"com_hikashopvmlanguage\";s:5:\"en_gb\";}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":28:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"630\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:22:\"nigel.lettin@gmail.com\";s:8:\"password\";s:60:\"$2y$10$NQW5I.ii0tULz4uDI7iz8OO8sN4OBq/DZXyil.OxYx131njqiIk5K\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2015-04-22 14:56:27\";s:13:\"lastvisitDate\";s:19:\"2015-05-05 16:37:17\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:12:\"requireReset\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:6:\"otpKey\";s:0:\"\";s:4:\"otep\";s:0:\"\";}s:13:\"session.token\";s:32:\"8b783d67e9b33ef3d3e0c37c8c692d80\";}check_anticopy_framing|N;check_contentprotect_framing|N;' , `time` = '1430900668' WHERE `session_id` = 'bd80114189ccbbf84f300950750baa27' Explain EXPLAIN not possible on query: UPDATE `j3_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:13;s:19:\"session.timer.start\";i:1430900528;s:18:\"session.timer.last\";i:1430900662;s:17:\"session.timer.now\";i:1430900667;s:22:\"session.client.browser\";s:109:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.135 Safari/537.36\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":4:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}s:10:\"com_config\";O:8:\"stdClass\":1:{s:6:\"config\";O:8:\"stdClass\":1:{s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"data\";a:91:{s:7:\"offline\";s:1:\"0\";s:15:\"offline_message\";s:69:\"This site is down for maintenance.Please check back again soon.\";s:23:\"display_offline_message\";s:1:\"1\";s:13:\"offline_image\";s:0:\"\";s:8:\"sitename\";s:3:\"LEC\";s:6:\"editor\";s:7:\"tinymce\";s:7:\"captcha\";s:9:\"recaptcha\";s:10:\"list_limit\";s:2:\"20\";s:6:\"access\";s:1:\"1\";s:5:\"debug\";s:1:\"1\";s:10:\"debug_lang\";s:1:\"0\";s:6:\"dbtype\";s:6:\"mysqli\";s:4:\"host\";s:9:\"localhost\";s:4:\"user\";s:13:\"ssahota_d3m03\";s:8:\"password\";s:8:\"W33tab!X\";s:2:\"db\";s:12:\"ssahota_lec3\";s:8:\"dbprefix\";s:3:\"j3_\";s:9:\"live_site\";s:0:\"\";s:6:\"secret\";s:16:\"VNPXIAXQprnBBNMk\";s:4:\"gzip\";s:1:\"0\";s:15:\"error_reporting\";s:7:\"maximum\";s:7:\"helpurl\";s:90:\"https://help.joomla.org/proxy/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\";s:8:\"ftp_host\";s:0:\"\";s:8:\"ftp_port\";s:0:\"\";s:8:\"ftp_user\";s:0:\"\";s:8:\"ftp_pass\";s:0:\"\";s:8:\"ftp_root\";s:0:\"\";s:10:\"ftp_enable\";s:1:\"0\";s:6:\"offset\";s:3:\"UTC\";s:10:\"mailonline\";s:1:\"1\";s:6:\"mailer\";s:4:\"mail\";s:8:\"mailfrom\";s:20:\"sales@leconcepts.com\";s:8:\"fromname\";s:21:\"Leading Edge Concepts\";s:8:\"sendmail\";s:18:\"/usr/sbin/sendmail\";s:8:\"smtpauth\";s:1:\"0\";s:8:\"smtpuser\";s:0:\"\";s:8:\"smtppass\";s:0:\"\";s:8:\"smtphost\";s:9:\"localhost\";s:10:\"smtpsecure\";s:4:\"none\";s:8:\"smtpport\";s:2:\"25\";s:7:\"caching\";s:1:\"0\";s:13:\"cache_handler\";s:4:\"file\";s:9:\"cachetime\";s:2:\"15\";s:8:\"MetaDesc\";s:0:\"\";s:8:\"MetaKeys\";s:0:\"\";s:9:\"MetaTitle\";s:1:\"1\";s:10:\"MetaAuthor\";s:1:\"0\";s:11:\"MetaVersion\";s:1:\"0\";s:6:\"robots\";s:0:\"\";s:3:\"sef\";s:1:\"1\";s:11:\"sef_rewrite\";s:1:\"1\";s:10:\"sef_suffix\";s:1:\"0\";s:12:\"unicodeslugs\";s:1:\"0\";s:10:\"feed_limit\";s:2:\"10\";s:8:\"log_path\";s:31:\"/home/demo3lec/public_html/logs\";s:8:\"tmp_path\";s:30:\"/home/demo3lec/public_html/tmp\";s:8:\"lifetime\";s:2:\"15\";s:15:\"session_handler\";s:8:\"database\";s:16:\"memcache_persist\";s:1:\"1\";s:17:\"memcache_compress\";s:1:\"0\";s:20:\"memcache_server_host\";s:9:\"localhost\";s:20:\"memcache_server_port\";s:5:\"11211\";s:17:\"memcached_persist\";s:1:\"1\";s:18:\"memcached_compress\";s:1:\"0\";s:21:\"memcached_server_host\";s:9:\"localhost\";s:21:\"memcached_server_port\";s:5:\"11211\";s:13:\"redis_persist\";s:1:\"1\";s:17:\"redis_server_host\";s:9:\"localhost\";s:17:\"redis_server_port\";s:4:\"6379\";s:17:\"redis_server_auth\";s:0:\"\";s:15:\"redis_server_db\";s:1:\"0\";s:12:\"proxy_enable\";s:1:\"0\";s:10:\"proxy_host\";s:0:\"\";s:10:\"proxy_port\";s:0:\"\";s:10:\"proxy_user\";s:0:\"\";s:10:\"proxy_pass\";s:0:\"\";s:11:\"massmailoff\";s:1:\"1\";s:10:\"MetaRights\";s:0:\"\";s:19:\"sitename_pagetitles\";s:1:\"1\";s:9:\"force_ssl\";s:1:\"0\";s:28:\"session_memcache_server_host\";s:9:\"localhost\";s:28:\"session_memcache_server_port\";s:5:\"11211\";s:29:\"session_memcached_server_host\";s:9:\"localhost\";s:29:\"session_memcached_server_port\";s:5:\"11211\";s:12:\"frontediting\";s:1:\"1\";s:10:\"feed_email\";s:6:\"author\";s:13:\"cookie_domain\";s:0:\"\";s:11:\"cookie_path\";s:0:\"\";s:8:\"asset_id\";i:1;s:7:\"filters\";a:8:{i:1;a:3:{s:11:\"filter_type\";s:2:\"NH\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:6;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:7;a:3:{s:11:\"filter_type\";s:4:\"NONE\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:2;a:3:{s:11:\"filter_type\";s:2:\"NH\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:3;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:4;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:5;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:8;a:3:{s:11:\"filter_type\";s:4:\"NONE\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}}s:5:\"rules\";a:10:{s:15:\"core.login.site\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:1:\"1\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:16:\"core.login.admin\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:18:\"core.login.offline\";a:8:{i:1;s:0:\"\";i:6;s:0:\"\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:10:\"core.admin\";a:8:{i:1;s:0:\"\";i:6;s:0:\"\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:1:\"1\";}s:11:\"core.manage\";a:8:{i:1;s:0:\"\";i:6;s:0:\"\";i:7;s:1:\"1\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:11:\"core.create\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:1:\"1\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:11:\"core.delete\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:9:\"core.edit\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:1:\"1\";i:5;s:0:\"\";i:8;s:0:\"\";}s:15:\"core.edit.state\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:1:\"1\";i:8;s:0:\"\";}s:13:\"core.edit.own\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:1:\"1\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}}}}}}s:22:\"com_hikashopvmvmPrefix\";s:3:\"j3_\";s:22:\"com_hikashopvmlanguage\";s:5:\"en_gb\";}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":28:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"630\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:22:\"nigel.lettin@gmail.com\";s:8:\"password\";s:60:\"$2y$10$NQW5I.ii0tULz4uDI7iz8OO8sN4OBq/DZXyil.OxYx131njqiIk5K\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2015-04-22 14:56:27\";s:13:\"lastvisitDate\";s:19:\"2015-05-05 16:37:17\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:12:\"requireReset\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:6:\"otpKey\";s:0:\"\";s:4:\"otep\";s:0:\"\";}s:13:\"session.token\";s:32:\"8b783d67e9b33ef3d3e0c37c8c692d80\";}check_anticopy_framing|N;check_contentprotect_framing|N;' , `time` = '1430900668' WHERE `session_id` = 'bd80114189ccbbf84f300950750baa27' Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/session/storage/database.php:84 [Add xdebug.file_link_format directive to your php.ini file to have links for files.] 15 Query Types Logged, Sorted by Occurrences. SELECT Tables: 9 × SELECT category_id FROM j3_hikashop_category 2 × SELECT * FROM j3_hikashop_characteristic 2 × SELECT extension_id AS id, element AS "option", params, enabled FROM j3_extensions 1 × SELECT * FROM j3_hikashop_field as a 1 × SELECT a.id FROM j3_user_usergroup_map AS map LEFT JOIN j3_usergroups AS a ON a.id = map.group_id 1 × SELECT * FROM j3_hikashop_confi 1 × SELECT folder AS type, element AS name, params FROM j3_extensions 1 × SELECT template, s.params FROM j3_template_styles as s LEFT JOIN j3_extensions as e ON e.type='template' AND e.element=s.template AND e.client_id=s.client_id 1 × SELECT `data` FROM `j3_session` OTHER Tables: 2 × SHOW TABLES LIKE 'j3_virtuemart_products 2 × SHOW FULL COLUMNS FROM `j3_hikashop_product 1 × UPDATE `j3_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:13;s:19:\"session.timer.start\";i:1430900528;s:18:\"session.timer.last\";i:1430900662;s:17:\"session.timer.now\";i:1430900667;s:22:\"session.client.browser\";s:109:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.135 Safari/537.36\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":4:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}s:10:\"com_config\";O:8:\"stdClass\":1:{s:6:\"config\";O:8:\"stdClass\":1:{s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"data\";a:91:{s:7:\"offline\";s:1:\"0\";s:15:\"offline_message\";s:69:\"This site is down for maintenance.Please check back again soon.\";s:23:\"display_offline_message\";s:1:\"1\";s:13:\"offline_image\";s:0:\"\";s:8:\"sitename\";s:3:\"LEC\";s:6:\"editor\";s:7:\"tinymce\";s:7:\"captcha\";s:9:\"recaptcha\";s:10:\"list_limit\";s:2:\"20\";s:6:\"access\";s:1:\"1\";s:5:\"debug\";s:1:\"1\";s:10:\"debug_lang\";s:1:\"0\";s:6:\"dbtype\";s:6:\"mysqli\";s:4:\"host\";s:9:\"localhost\";s:4:\"user\";s:13:\"ssahota_d3m03\";s:8:\"password\";s:8:\"W33tab!X\";s:2:\"db\";s:12:\"ssahota_lec3\";s:8:\"dbprefix\";s:3:\"j3_\";s:9:\"live_site\";s:0:\"\";s:6:\"secret\";s:16:\"VNPXIAXQprnBBNMk\";s:4:\"gzip\";s:1:\"0\";s:15:\"error_reporting\";s:7:\"maximum\";s:7:\"helpurl\";s:90:\"https://help.joomla.org/proxy/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\";s:8:\"ftp_host\";s:0:\"\";s:8:\"ftp_port\";s:0:\"\";s:8:\"ftp_user\";s:0:\"\";s:8:\"ftp_pass\";s:0:\"\";s:8:\"ftp_root\";s:0:\"\";s:10:\"ftp_enable\";s:1:\"0\";s:6:\"offset\";s:3:\"UTC\";s:10:\"mailonline\";s:1:\"1\";s:6:\"mailer\";s:4:\"mail\";s:8:\"mailfrom\";s:20:\"sales@leconcepts.com\";s:8:\"fromname\";s:21:\"Leading Edge Concepts\";s:8:\"sendmail\";s:18:\"/usr/sbin/sendmail\";s:8:\"smtpauth\";s:1:\"0\";s:8:\"smtpuser\";s:0:\"\";s:8:\"smtppass\";s:0:\"\";s:8:\"smtphost\";s:9:\"localhost\";s:10:\"smtpsecure\";s:4:\"none\";s:8:\"smtpport\";s:2:\"25\";s:7:\"caching\";s:1:\"0\";s:13:\"cache_handler\";s:4:\"file\";s:9:\"cachetime\";s:2:\"15\";s:8:\"MetaDesc\";s:0:\"\";s:8:\"MetaKeys\";s:0:\"\";s:9:\"MetaTitle\";s:1:\"1\";s:10:\"MetaAuthor\";s:1:\"0\";s:11:\"MetaVersion\";s:1:\"0\";s:6:\"robots\";s:0:\"\";s:3:\"sef\";s:1:\"1\";s:11:\"sef_rewrite\";s:1:\"1\";s:10:\"sef_suffix\";s:1:\"0\";s:12:\"unicodeslugs\";s:1:\"0\";s:10:\"feed_limit\";s:2:\"10\";s:8:\"log_path\";s:31:\"/home/demo3lec/public_html/logs\";s:8:\"tmp_path\";s:30:\"/home/demo3lec/public_html/tmp\";s:8:\"lifetime\";s:2:\"15\";s:15:\"session_handler\";s:8:\"database\";s:16:\"memcache_persist\";s:1:\"1\";s:17:\"memcache_compress\";s:1:\"0\";s:20:\"memcache_server_host\";s:9:\"localhost\";s:20:\"memcache_server_port\";s:5:\"11211\";s:17:\"memcached_persist\";s:1:\"1\";s:18:\"memcached_compress\";s:1:\"0\";s:21:\"memcached_server_host\";s:9:\"localhost\";s:21:\"memcached_server_port\";s:5:\"11211\";s:13:\"redis_persist\";s:1:\"1\";s:17:\"redis_server_host\";s:9:\"localhost\";s:17:\"redis_server_port\";s:4:\"6379\";s:17:\"redis_server_auth\";s:0:\"\";s:15:\"redis_server_db\";s:1:\"0\";s:12:\"proxy_enable\";s:1:\"0\";s:10:\"proxy_host\";s:0:\"\";s:10:\"proxy_port\";s:0:\"\";s:10:\"proxy_user\";s:0:\"\";s:10:\"proxy_pass\";s:0:\"\";s:11:\"massmailoff\";s:1:\"1\";s:10:\"MetaRights\";s:0:\"\";s:19:\"sitename_pagetitles\";s:1:\"1\";s:9:\"force_ssl\";s:1:\"0\";s:28:\"session_memcache_server_host\";s:9:\"localhost\";s:28:\"session_memcache_server_port\";s:5:\"11211\";s:29:\"session_memcached_server_host\";s:9:\"localhost\";s:29:\"session_memcached_server_port\";s:5:\"11211\";s:12:\"frontediting\";s:1:\"1\";s:10:\"feed_email\";s:6:\"author\";s:13:\"cookie_domain\";s:0:\"\";s:11:\"cookie_path\";s:0:\"\";s:8:\"asset_id\";i:1;s:7:\"filters\";a:8:{i:1;a:3:{s:11:\"filter_type\";s:2:\"NH\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:6;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:7;a:3:{s:11:\"filter_type\";s:4:\"NONE\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:2;a:3:{s:11:\"filter_type\";s:2:\"NH\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:3;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:4;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:5;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:8;a:3:{s:11:\"filter_type\";s:4:\"NONE\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}}s:5:\"rules\";a:10:{s:15:\"core.login.site\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:1:\"1\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:16:\"core.login.admin\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:18:\"core.login.offline\";a:8:{i:1;s:0:\"\";i:6;s:0:\"\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:10:\"core.admin\";a:8:{i:1;s:0:\"\";i:6;s:0:\"\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:1:\"1\";}s:11:\"core.manage\";a:8:{i:1;s:0:\"\";i:6;s:0:\"\";i:7;s:1:\"1\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:11:\"core.create\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:1:\"1\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:11:\"core.delete\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:9:\"core.edit\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:1:\"1\";i:5;s:0:\"\";i:8;s:0:\"\";}s:15:\"core.edit.state\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:1:\"1\";i:8;s:0:\"\";}s:13:\"core.edit.own\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:1:\"1\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}}}}}}s:22:\"com_hikashopvmvmPrefix\";s:3:\"j3_\";s:22:\"com_hikashopvmlanguage\";s:5:\"en_gb\";}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":28:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"630\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:22:\"nigel.lettin@gmail.com\";s:8:\"password\";s:60:\"$2y$10$NQW5I.ii0tULz4uDI7iz8OO8sN4OBq/DZXyil.OxYx131njqiIk5K\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2015-04-22 14:56:27\";s:13:\"lastvisitDate\";s:19:\"2015-05-05 16:37:17\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:12:\"requireReset\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:6:\"otpKey\";s:0:\"\";s:4:\"otep\";s:0:\"\";}s:13:\"session.token\";s:32:\"8b783d67e9b33ef3d3e0c37c8c692d80\";}check_anticopy_framing|N;check_contentprotect_framing|N;' , `time` = '1430900668' 1 × SHOW TABLES LIKE 'j3_virtuemart_products_en_gb 1 × UPDATE `j3_extensions` SET `params` = '{\"mediaversion\":\"6262967d85df0fcb2b9fa3a905fe000e\"}' 1 × DELETE FROM `j3_session`