{
    "__default": {
        "session": {
            "counter": 14,
            "timer": {
                "start": 1772593307,
                "last": 1772593314,
                "now": 1772593314
            },
            "token": "ffV9Xvf5By7Ffn4Jmo8i7KC42qXHTfSU"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "js_id_currency_orig": "3",
        "js_id_currency": "3",
        "js_history_sel_lang": "az-AZ",
        "js_prev_user_id": 0,
        "jshop_checked_language": [
            "az-AZ",
            "az-AZ",
            "az-AZ",
            "en-GB",
            "ru-RU",
            "ru-RU",
            "ru-RU"
        ],
        "jshop_end_page_buy_product": "\/index.php\/az\/category\/view\/77",
        "jshop_end_page_list_product": "\/index.php\/az\/category\/view\/77"
    }
}

Time

Memory

47 Queries Logged 33.43 ms

1. Query Time: 0.22 ms Query memory: 0.022 MB Memory before query: 0.656 MB Rows returned: 1

   SELECT `data`
   
     FROM `bm_session`
   
     WHERE `session_id` = '7d182a29b75529674f1c1ee94f5d7b44'

   Explain

   Error
   You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `data` FROM `#__session` WHERE `session_id` = '7d182a29b75529674f1c1ee94f' at line 1 SQL=EXPLAIN EXTENDED SELECT `data` FROM `#__session` WHERE `session_id` = '7d182a29b75529674f1c1ee94f5d7b44'

   Profile

   Status	Duration
   starting	0.02 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.00 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Same as call in the line below.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

2. Query Time: 0.34 ms After last query: 1.43 ms Query memory: 0.021 MB Memory before query: 0.724 MB Rows returned: 2

   SELECT b.id
   
     FROM bm_usergroups AS a
   
     LEFT JOIN bm_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Explain

   Error
   You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT b.id FROM #__usergroups AS a LEFT JOIN #__usergroups AS b ON b.lft <= a.l' at line 1 SQL=EXPLAIN EXTENDED SELECT b.id FROM #__usergroups AS a LEFT JOIN #__usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9

   Profile

   Status	Duration
   starting	0.05 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.03 ms
   init	0.00 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.02 ms
   executing	0.03 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.03 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

3. Query Time: 0.23 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 0.728 MB Rows returned: 6

   SELECT id, rules
   
     FROM `bm_viewlevels`

   Explain

   Error
   You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id, rules FROM `#__viewlevels`' at line 1 SQL=EXPLAIN EXTENDED SELECT id, rules FROM `#__viewlevels`

   Profile

   Status	Duration
   starting	0.02 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.00 ms
   System lock	0.00 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.03 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.00 ms
   closing tables	0.00 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

4. Query Time: 5.76 ms After last query: 0.78 ms Query memory: 0.025 MB Memory before query: 0.739 MB Rows returned: 73

   SELECT folder AS type, element AS name, params
   
     FROM bm_extensions
   
     WHERE enabled = 1 
     AND type ='plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Explain

   Error

   You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT folder AS type, element AS name, params FROM #__extensions WHERE enabled ' at line 1 SQL=EXPLAIN EXTENDED SELECT folder AS type, element AS name, params FROM #__extensions WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY ordering

   Profile

   Status	Duration
   starting	0.08 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.03 ms
   statistics	0.08 ms
   preparing	0.04 ms
   executing	5.21 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

5. Query Time: 0.36 ms After last query: 4.35 ms Query memory: 0.021 MB Memory before query: 1.082 MB Rows returned: 3

   SELECT element
   
     FROM bm_extensions
   
     WHERE type = 'language' 
     AND client_id = 0 
     AND enabled = 1

   Explain

   Error
   You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT element FROM #__extensions WHERE type = 'language' AND client_id = 0 AND ' at line 1 SQL=EXPLAIN EXTENDED SELECT element FROM #__extensions WHERE type = 'language' AND client_id = 0 AND enabled = 1

   Profile

   Status	Duration
   starting	0.04 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.03 ms
   init	0.00 ms
   System lock	0.01 ms
   optimizing	0.04 ms
   statistics	0.07 ms
   preparing	0.02 ms
   executing	0.03 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.00 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:90
   8	JLanguageMultilang::getSiteLangs()	JROOT/plugins/system/languagefilter/languagefilter.php:108
   7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

6. Query Time: 0.32 ms After last query: 2.24 ms Query memory: 0.007 MB Memory before query: 1.246 MB

   UPDATE `bm_extensions`
   
     SET `params` = '{\"mediaversion\":\"c26deb6d592cae9801a6f59cbd0c1dfc\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   Error
   You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `#__extensions` SET `params` = '{\"mediaversion\":\"c26deb6d592cae9801a6f' at line 1 SQL=EXPLAIN EXTENDED UPDATE `#__extensions` SET `params` = '{\"mediaversion\":\"c26deb6d592cae9801a6f59cbd0c1dfc\"}' WHERE `type` = 'library' AND `element` = 'joomla'

   Profile

   Status	Duration
   starting	0.03 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.00 ms
   System lock	0.05 ms
   updating	0.04 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.08 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
   15	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
   14	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
   13	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
   12	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   11	JFactory::getDocument()	JROOT/plugins/system/helix/core/helix.php:50
   10	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:36
   9	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:21
   8	plgSystemHelix->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

7. Query Time: 1.20 ms After last query: 0.25 ms Query memory: 0.077 MB Memory before query: 1.270 MB Rows returned: 61

   SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
   
     FROM bm_menu AS m
   
     LEFT JOIN bm_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   Explain

   Error

   You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.ty' at line 1 SQL=EXPLAIN EXTENDED SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM #__menu AS m LEFT JOIN #__extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft

   Profile

   Status	Duration
   starting	0.05 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.03 ms
   init	0.00 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.03 ms
   executing	0.93 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
   20	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
   19	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
   18	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
   17	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
   16	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   15	JApplicationSite->getMenu()	JROOT/libraries/cms/application/site.php:438
   14	JApplicationSite->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
   13	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:114
   12	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:302
   11	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:290
   10	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1592
   9	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:22
   8	plgSystemHelix->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

8. Query Time: 2.92 ms After last query: 4.29 ms Query memory: 0.047 MB Memory before query: 1.891 MB Rows returned: 140

   SHOW FULL COLUMNS 
     FROM `bm_jshopping_config`

   Explain

   EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bm_jshopping_config`

   Profile

   Status	Duration
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.04 ms
   checking permissions	0.01 ms
   checking permissions	0.03 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.03 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.15 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.06 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
   18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
   17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
   16	JTable->__construct()	JROOT/components/com_jshopping/tables/config.php:14
   15	jshopConfig->__construct()	JROOT/components/com_jshopping/lib/factory.php:24
   14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
   13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
   12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
   11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:225
   10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
   9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
   8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
   7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
   6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
   5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

9. Query Time: 0.40 ms After last query: 0.36 ms Query memory: 0.098 MB Memory before query: 2.090 MB Rows returned: 1

   SELECT *
   
     FROM bm_jshopping_config
   
     WHERE `id` = '1'

   Explain

   Error
   You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__jshopping_config WHERE `id` = '1'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM #__jshopping_config WHERE `id` = '1'

   Profile

   Status	Duration
   starting	0.03 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.05 ms
   init	0.00 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.06 ms
   preparing	0.03 ms
   executing	0.10 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
   16	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
   15	JTable->load()	JROOT/components/com_jshopping/lib/factory.php:30
   14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
   13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
   12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
   11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:225
   10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
   9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
   8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
   7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
   6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
   5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

10. Query Time: 0.90 ms After last query: 0.24 ms Query memory: 0.027 MB Memory before query: 2.093 MB Rows returned: 8

    SHOW FULL COLUMNS 
      FROM `bm_jshopping_currencies`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bm_jshopping_currencies`

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.32 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    executing	0.05 ms
    checking permissions	0.08 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    20	JTable->__construct()	JROOT/components/com_jshopping/tables/currency.php:14
    19	jshopCurrency->__construct()	JROOT/libraries/joomla/table/table.php:308
    18	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
    17	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:569
    16	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
    15	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
    14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:225
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

11. Query Time: 0.20 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 2.112 MB Rows returned: 1

    SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
      FROM `bm_jshopping_currencies` 
      WHERE currency_publish = '1' 
      ORDER BY currency_ordering

    Explain

    Error

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_va' at line 1 SQL=EXPLAIN EXTENDED SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `#__jshopping_currencies` WHERE currency_publish = '1' ORDER BY currency_ordering

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/currency.php:22
    17	jshopCurrency->getAllCurrencies()	JROOT/components/com_jshopping/lib/factory.php:570
    16	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
    15	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
    14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:225
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

12. Query Time: 1.44 ms After last query: 0.06 ms Query memory: 0.039 MB Memory before query: 2.128 MB Rows returned: 58
    Duplicate queries: #13

    SHOW FULL COLUMNS 
      FROM `bm_jshopping_users`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bm_jshopping_users`

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.31 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    executing	0.05 ms
    checking permissions	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.07 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    20	JTable->__construct()	JROOT/components/com_jshopping/tables/usershopbase.php:14
    19	jshopUserShopBase->__construct()	JROOT/components/com_jshopping/tables/usershop.php:15
    18	jshopUserShop->__construct()	JROOT/components/com_jshopping/lib/factory.php:47
    17	JSFactory::getUserShop()	JROOT/components/com_jshopping/tables/config.php:70
    16	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:296
    15	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
    14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:225
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

13. Query Time: 1.48 ms After last query: 0.18 ms Query memory: 0.039 MB Memory before query: 2.216 MB Rows returned: 58
    Duplicate queries: #12

    SHOW FULL COLUMNS 
      FROM `bm_jshopping_users`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bm_jshopping_users`

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.28 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    executing	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.07 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    20	JTable->__construct()	JROOT/components/com_jshopping/tables/usershopbase.php:14
    19	jshopUserShopBase->__construct()	JROOT/components/com_jshopping/models/userguest.php:16
    18	jshopUserGust->__construct()	JROOT/components/com_jshopping/lib/factory.php:66
    17	JSFactory::getUserShopGuest()	JROOT/components/com_jshopping/tables/config.php:74
    16	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:296
    15	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
    14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:225
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

14. Query Time: 0.81 ms After last query: 0.13 ms Query memory: 0.029 MB Memory before query: 2.356 MB Rows returned: 12

    SHOW FULL COLUMNS 
      FROM `bm_jshopping_usergroups`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bm_jshopping_usergroups`

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.30 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.03 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    executing	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    23	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    22	JTable->__construct()	JROOT/components/com_jshopping/tables/usergroup.php:14
    21	jshopUserGroup->__construct()	JROOT/libraries/joomla/table/table.php:308
    20	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
    19	JSFactory::getTable()	JROOT/components/com_jshopping/models/userguest.php:30
    18	jshopUserGust->load()	JROOT/components/com_jshopping/lib/factory.php:67
    17	JSFactory::getUserShopGuest()	JROOT/components/com_jshopping/tables/config.php:74
    16	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:296
    15	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
    14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:225
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

15. Query Time: 0.71 ms After last query: 0.07 ms Query memory: 0.027 MB Memory before query: 2.382 MB Rows returned: 4

    SHOW FULL COLUMNS 
      FROM `bm_jshopping_config_display_prices`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bm_jshopping_config_display_prices`

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.29 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    executing	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    20	JTable->__construct()	JROOT/components/com_jshopping/tables/configdisplayprice.php:14
    19	jshopConfigDisplayPrice->__construct()	JROOT/libraries/joomla/table/table.php:308
    18	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
    17	JSFactory::getTable()	JROOT/components/com_jshopping/tables/config.php:82
    16	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:296
    15	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
    14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:225
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

16. Query Time: 0.15 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 2.397 MB Rows returned: 1

    SELECT * 
      FROM `bm_jshopping_config_display_prices`

    Explain

    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__jshopping_config_display_prices`' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__jshopping_config_display_prices`

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/configdisplayprice.php:33
    17	jshopConfigDisplayPrice->getList()	JROOT/components/com_jshopping/tables/config.php:83
    16	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:296
    15	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
    14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:225
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

17. Query Time: 1.14 ms After last query: 5.73 ms Query memory: 0.032 MB Memory before query: 2.469 MB Rows returned: 34

    SHOW FULL COLUMNS 
      FROM `bm_jshopping_categories`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bm_jshopping_categories`

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.31 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    executing	0.05 ms
    checking permissions	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    12	JTable->__construct()	JROOT/components/com_jshopping/tables/category.php:15
    11	jshopCategory->__construct()	JROOT/libraries/joomla/table/table.php:308
    10	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
    9	JSFactory::getTable()	JROOT/components/com_jshopping/controllers/category.php:59
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

18. Query Time: 0.21 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 2.517 MB Rows returned: 1

    SELECT *
    
      FROM bm_jshopping_categories
    
      WHERE `category_id` = '77'

    Explain

    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__jshopping_categories WHERE `category_id` = '77'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM #__jshopping_categories WHERE `category_id` = '77'

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    9	JTable->load()	JROOT/components/com_jshopping/controllers/category.php:60
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

19. Query Time: 0.52 ms After last query: 0.37 ms Query memory: 0.034 MB Memory before query: 2.572 MB Rows returned: 80

    SELECT `name_az-AZ` as name,`description_az-AZ` as description,`short_description_az-AZ` as short_description, category_id, category_publish, ordering, category_image 
      FROM `bm_jshopping_categories`
                       
      WHERE category_parent_id = '77'  
      AND category_publish = '1'  
      AND access IN (1,1,5)
                       
      ORDER BY `name_az-AZ` asc

    Explain

    Error

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `name_az-AZ` as name,`description_az-AZ` as description,`short_descriptio' at line 1 SQL=EXPLAIN EXTENDED SELECT `name_az-AZ` as name,`description_az-AZ` as description,`short_description_az-AZ` as short_description, category_id, category_publish, ordering, category_image FROM `#__jshopping_categories` WHERE category_parent_id = '77' AND category_publish = '1' AND access IN (1,1,5) ORDER BY `name_az-AZ` asc

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.27 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    10	jshopCategory->getSubCategories()	JROOT/components/com_jshopping/tables/category.php:119
    9	jshopCategory->getChildCategories()	JROOT/components/com_jshopping/controllers/category.php:69
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

20. Query Time: 0.57 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 2.644 MB Rows returned: 17

    select id,link 
      from bm_menu 
    			          
      where `type`='component' 
      and published=1 
      and link like '%option=com_jshopping%' 
      and client_id=0 
    					  
      and (language='*' or language='az-AZ') 
      and access IN (1,1,5)

    Explain

    Error

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select id,link from #__menu where `type`='component' and publishe' at line 1 SQL=EXPLAIN EXTENDED select id,link from #__menu where `type`='component' and published=1 and link like '%option=com_jshopping%' and client_id=0 and (language='*' or language='az-AZ') and access IN (1,1,5)

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.35 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:141
    16	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:47
    15	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:40
    14	shopItemMenu::getInstance()	JROOT/components/com_jshopping/lib/functions.php:403
    13	getShopMainPageItemid()	JROOT/components/com_jshopping/lib/functions.php:422
    12	getDefaultItemid()	JROOT/components/com_jshopping/lib/functions.php:481
    11	SEFLink()	JROOT/components/com_jshopping/tables/category.php:36
    10	jshopCategory->getSubCategories()	JROOT/components/com_jshopping/tables/category.php:119
    9	jshopCategory->getChildCategories()	JROOT/components/com_jshopping/controllers/category.php:69
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

21. Query Time: 0.46 ms After last query: 0.15 ms Query memory: 0.025 MB Memory before query: 2.674 MB Rows returned: 0

    select category_id as id, `alias_az-AZ` as alias 
      from bm_jshopping_categories 
      where `alias_az-AZ`!=''

    Explain

    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select category_id as id, `alias_az-AZ` as alias from #__jshopping_categories wh' at line 1 SQL=EXPLAIN EXTENDED select category_id as id, `alias_az-AZ` as alias from #__jshopping_categories where `alias_az-AZ`!=''

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.30 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.04 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:255
    19	JSFactory::getAliasCategory()	JROOT/components/com_jshopping/router.php:63
    18	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    14	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    12	JRoute::_()	JROOT/components/com_jshopping/lib/functions.php:496
    11	SEFLink()	JROOT/components/com_jshopping/tables/category.php:36
    10	jshopCategory->getSubCategories()	JROOT/components/com_jshopping/tables/category.php:119
    9	jshopCategory->getChildCategories()	JROOT/components/com_jshopping/controllers/category.php:69
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

22. Query Time: 0.28 ms After last query: 2.38 ms Query memory: 0.024 MB Memory before query: 2.775 MB Rows returned: 1

    SELECT *
    
      FROM bm_jshopping_categories
    
      WHERE `category_id` = '345'

    Explain

    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__jshopping_categories WHERE `category_id` = '345'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM #__jshopping_categories WHERE `category_id` = '345'

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    12	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    11	JTable->load()	JROOT/components/com_jshopping/tables/category.php:81
    10	jshopCategory->getTreeChild()	JROOT/components/com_jshopping/helpers/metadata.php:53
    9	JshopHelpersMetadata::category()	JROOT/components/com_jshopping/controllers/category.php:72
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

23. Query Time: 1.00 ms After last query: 0.35 ms Query memory: 0.033 MB Memory before query: 2.792 MB Rows returned: 31

    SHOW FULL COLUMNS 
      FROM `bm_jshopping_vendors`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bm_jshopping_vendors`

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.28 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    executing	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    16	JTable->__construct()	JROOT/components/com_jshopping/tables/vendor.php:15
    15	jshopVendor->__construct()	JROOT/libraries/joomla/table/table.php:308
    14	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
    13	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:435
    12	JSFactory::getMainVendor()	JROOT/components/com_jshopping/lib/functions.php:1449
    11	getBuildFilterListProduct()	JROOT/components/com_jshopping/tables/category.php:307
    10	jshopCategory->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

24. Query Time: 0.17 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 2.832 MB Rows returned: 1

    SELECT id 
      FROM bm_jshopping_vendors 
      WHERE `main`=1

    Explain

    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id FROM #__jshopping_vendors WHERE `main`=1' at line 1 SQL=EXPLAIN EXTENDED SELECT id FROM #__jshopping_vendors WHERE `main`=1

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    14	JDatabaseDriver->loadResult()	JROOT/components/com_jshopping/tables/vendor.php:23
    13	jshopVendor->loadMain()	JROOT/components/com_jshopping/lib/factory.php:436
    12	JSFactory::getMainVendor()	JROOT/components/com_jshopping/lib/functions.php:1449
    11	getBuildFilterListProduct()	JROOT/components/com_jshopping/tables/category.php:307
    10	jshopCategory->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

25. Query Time: 0.17 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 2.843 MB Rows returned: 1

    SELECT *
    
      FROM bm_jshopping_vendors
    
      WHERE `id` = '1'

    Explain

    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__jshopping_vendors WHERE `id` = '1'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM #__jshopping_vendors WHERE `id` = '1'

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    15	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    14	JTable->load()	JROOT/components/com_jshopping/tables/vendor.php:24
    13	jshopVendor->loadMain()	JROOT/components/com_jshopping/lib/factory.php:436
    12	JSFactory::getMainVendor()	JROOT/components/com_jshopping/lib/functions.php:1449
    11	getBuildFilterListProduct()	JROOT/components/com_jshopping/tables/category.php:307
    10	jshopCategory->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

26. Query Time: 0.80 ms After last query: 0.09 ms Query memory: 0.028 MB Memory before query: 2.852 MB Rows returned: 14

    SHOW FULL COLUMNS 
      FROM `bm_jshopping_products_extra_fields`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bm_jshopping_products_extra_fields`

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.28 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    executing	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    17	JTable->__construct()	JROOT/components/com_jshopping/tables/productfield.php:14
    16	jshopProductField->__construct()	JROOT/libraries/joomla/table/table.php:308
    15	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
    14	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:496
    13	JSFactory::getAllProductExtraField()	JROOT/components/com_jshopping/lib/functions.php:1136
    12	getQueryListProductsExtraFields()	JROOT/components/com_jshopping/lib/jtableauto.php:37
    11	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/category.php:179
    10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

27. Query Time: 0.49 ms After last query: 0.04 ms Query memory: 0.040 MB Memory before query: 2.877 MB Rows returned: 84

    SELECT F.id, F.`name_az-AZ` as name, F.`description_az-AZ` as description, F.allcats, F.type, F.cats, F.ordering, F.`
      group`, G.`name_az-AZ` as groupname, multilist 
      FROM `bm_jshopping_products_extra_fields` as F 
      left join `bm_jshopping_products_extra_field_groups` as G 
      on G.id=F.
      group 
      order by G.ordering, F.ordering

    Explain

    Error

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT F.id, F.`name_az-AZ` as name, F.`description_az-AZ` as description, F.all' at line 1 SQL=EXPLAIN EXTENDED SELECT F.id, F.`name_az-AZ` as name, F.`description_az-AZ` as description, F.allcats, F.type, F.cats, F.ordering, F.`group`, G.`name_az-AZ` as groupname, multilist FROM `#__jshopping_products_extra_fields` as F left join `#__jshopping_products_extra_field_groups` as G on G.id=F.group order by G.ordering, F.ordering

    Profile

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.02 ms
    preparing	0.01 ms
    Creating tmp table	0.02 ms
    executing	0.29 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productfield.php:48
    14	jshopProductField->getList()	JROOT/components/com_jshopping/lib/factory.php:497
    13	JSFactory::getAllProductExtraField()	JROOT/components/com_jshopping/lib/functions.php:1136
    12	getQueryListProductsExtraFields()	JROOT/components/com_jshopping/lib/jtableauto.php:37
    11	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/category.php:179
    10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

28. Query Time: 0.67 ms After last query: 0.29 ms Query memory: 0.026 MB Memory before query: 3.061 MB Rows returned: 3

    SHOW FULL COLUMNS 
      FROM `bm_jshopping_taxes`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bm_jshopping_taxes`

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.28 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    executing	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    19	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    18	JTable->__construct()	JROOT/components/com_jshopping/tables/tax.php:14
    17	jshopTax->__construct()	JROOT/libraries/joomla/table/table.php:308
    16	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
    15	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:369
    14	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:991
    13	getCorrectedPriceForQueryFilter()	JROOT/components/com_jshopping/lib/jtableauto.php:101
    12	JTableAvto->getBuildQueryListProductFilterPrice()	JROOT/components/com_jshopping/lib/jtableauto.php:88
    11	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/category.php:179
    10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

29. Query Time: 0.13 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 3.076 MB Rows returned: 2

    SELECT tax_id, tax_name, tax_value 
      FROM `bm_jshopping_taxes`

    Explain

    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT tax_id, tax_name, tax_value FROM `#__jshopping_taxes`' at line 1 SQL=EXPLAIN EXTENDED SELECT tax_id, tax_name, tax_value FROM `#__jshopping_taxes`

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/tax.php:21
    16	jshopTax->getAllTaxes()	JROOT/components/com_jshopping/lib/factory.php:355
    15	JSFactory::getAllTaxesOriginal()	JROOT/components/com_jshopping/lib/factory.php:370
    14	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:991
    13	getCorrectedPriceForQueryFilter()	JROOT/components/com_jshopping/lib/jtableauto.php:101
    12	JTableAvto->getBuildQueryListProductFilterPrice()	JROOT/components/com_jshopping/lib/jtableauto.php:88
    11	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/category.php:179
    10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

30. Query Time: 0.24 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 3.081 MB Rows returned: 1

    SELECT count(*) 
      FROM `bm_jshopping_products_to_categories` AS pr_cat
                      
      INNER JOIN `bm_jshopping_products` AS prod 
      ON pr_cat.product_id = prod.product_id
                       
                      
      WHERE pr_cat.category_id=77 
      AND prod.product_publish=1  
      AND prod.access IN (1,1,5)

    Explain

    Error

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT count(*) FROM `#__jshopping_products_to_categories` AS pr_cat ' at line 1 SQL=EXPLAIN EXTENDED SELECT count(*) FROM `#__jshopping_products_to_categories` AS pr_cat INNER JOIN `#__jshopping_products` AS prod ON pr_cat.product_id = prod.product_id WHERE pr_cat.category_id=77 AND prod.product_publish=1 AND prod.access IN (1,1,5)

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.06 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    11	JDatabaseDriver->loadResult()	JROOT/components/com_jshopping/tables/category.php:190
    10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

31. Query Time: 0.57 ms After last query: 0.34 ms Query memory: 0.056 MB Memory before query: 3.096 MB Rows returned: 0

    SELECT prod.product_id, pr_cat.category_id, prod.`name_az-AZ` as name, prod.`short_description_az-AZ` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_1` , prod.`extra_field_29` , prod.`extra_field_98` , prod.`extra_field_100` , prod.`extra_field_169` , prod.`extra_field_103` , prod.`extra_field_156` , prod.`extra_field_157` , prod.`extra_field_158` , prod.`extra_field_159` , prod.`extra_field_173` , prod.`extra_field_3` , prod.`extra_field_5` , prod.`extra_field_41` , prod.`extra_field_8` , prod.`extra_field_10` , prod.`extra_field_13` , prod.`extra_field_74` , prod.`extra_field_14` , prod.`extra_field_38` , prod.`extra_field_22` , prod.`extra_field_24` , prod.`extra_field_37` , prod.`extra_field_57` , prod.`extra_field_2` , prod.`extra_field_55` , prod.`extra_field_59` , prod.`extra_field_76` , prod.`extra_field_77` , prod.`extra_field_78` , prod.`extra_field_80` , prod.`extra_field_81` , prod.`extra_field_82` , prod.`extra_field_83` , prod.`extra_field_84` , prod.`extra_field_86` , prod.`extra_field_89` , prod.`extra_field_91` , prod.`extra_field_94` , prod.`extra_field_96` , prod.`extra_field_104` , prod.`extra_field_105` , prod.`extra_field_106` , prod.`extra_field_112` , prod.`extra_field_107` , prod.`extra_field_109` , prod.`extra_field_110` , prod.`extra_field_111` , prod.`extra_field_114` , prod.`extra_field_115` , prod.`extra_field_125` , prod.`extra_field_162` , prod.`extra_field_163` , prod.`extra_field_126` , prod.`extra_field_128` , prod.`extra_field_174` , prod.`extra_field_131` , prod.`extra_field_132` , prod.`extra_field_133` , prod.`extra_field_134` , prod.`extra_field_137` , prod.`extra_field_139` , prod.`extra_field_155` , prod.`extra_field_160` , prod.`extra_field_161` , prod.`extra_field_168` , prod.`extra_field_170` , prod.`extra_field_171` , prod.`extra_field_172` , prod.`extra_field_184` , prod.`extra_field_193` , prod.`extra_field_194` , prod.`extra_field_195` , prod.`extra_field_204` , prod.`extra_field_205` , prod.`extra_field_206`  
      FROM `bm_jshopping_products` AS prod
                      
      LEFT JOIN `bm_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
                      
      WHERE pr_cat.category_id=77 
      AND prod.product_publish=1  
      AND prod.access IN (1,1,5)  
      ORDER BY prod.average_rating DESC 
      LIMIT 0, 12

    Explain

    Error

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT prod.product_id, pr_cat.category_id, prod.`name_az-AZ` as name, prod.`sho' at line 1 SQL=EXPLAIN EXTENDED SELECT prod.product_id, pr_cat.category_id, prod.`name_az-AZ` as name, prod.`short_description_az-AZ` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_1` , prod.`extra_field_29` , prod.`extra_field_98` , prod.`extra_field_100` , prod.`extra_field_169` , prod.`extra_field_103` , prod.`extra_field_156` , prod.`extra_field_157` , prod.`extra_field_158` , prod.`extra_field_159` , prod.`extra_field_173` , prod.`extra_field_3` , prod.`extra_field_5` , prod.`extra_field_41` , prod.`extra_field_8` , prod.`extra_field_10` , prod.`extra_field_13` , prod.`extra_field_74` , prod.`extra_field_14` , prod.`extra_field_38` , prod.`extra_field_22` , prod.`extra_field_24` , prod.`extra_field_37` , prod.`extra_field_57` , prod.`extra_field_2` , prod.`extra_field_55` , prod.`extra_field_59` , prod.`extra_field_76` , prod.`extra_field_77` , prod.`extra_field_78` , prod.`extra_field_80` , prod.`extra_field_81` , prod.`extra_field_82` , prod.`extra_field_83` , prod.`extra_field_84` , prod.`extra_field_86` , prod.`extra_field_89` , prod.`extra_field_91` , prod.`extra_field_94` , prod.`extra_field_96` , prod.`extra_field_104` , prod.`extra_field_105` , prod.`extra_field_106` , prod.`extra_field_112` , prod.`extra_field_107` , prod.`extra_field_109` , prod.`extra_field_110` , prod.`extra_field_111` , prod.`extra_field_114` , prod.`extra_field_115` , prod.`extra_field_125` , prod.`extra_field_162` , prod.`extra_field_163` , prod.`extra_field_126` , prod.`extra_field_128` , prod.`extra_field_174` , prod.`extra_field_131` , prod.`extra_field_132` , prod.`extra_field_133` , prod.`extra_field_134` , prod.`extra_field_137` , prod.`extra_field_139` , prod.`extra_field_155` , prod.`extra_field_160` , prod.`extra_field_161` , prod.`extra_field_168` , prod.`extra_field_170` , prod.`extra_field_171` , prod.`extra_field_172` , prod.`extra_field_184` , prod.`extra_field_193` , prod.`extra_field_194` , prod.`extra_field_195` , prod.`extra_field_204` , prod.`extra_field_205` , prod.`extra_field_206` FROM `#__jshopping_products` AS prod LEFT JOIN `#__jshopping_products_to_categories` AS pr_cat USING (product_id) WHERE pr_cat.category_id=77 AND prod.product_publish=1 AND prod.access IN (1,1,5) ORDER BY prod.average_rating DESC LIMIT 0, 12

    Profile

    Status	Duration
    starting	0.09 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.17 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Creating tmp table	0.10 ms
    executing	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:171
    10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

32. Query Time: 0.34 ms After last query: 0.19 ms Query memory: 0.021 MB Memory before query: 3.099 MB Rows returned: 0

    SELECT distinct man.manufacturer_id as id, man.`name_az-AZ` as name 
      FROM `bm_jshopping_products` AS prod
                      
      LEFT JOIN `bm_jshopping_products_to_categories` AS categ USING (product_id)
                      
      LEFT JOIN `bm_jshopping_manufacturers` as man 
      on prod.product_manufacturer_id=man.manufacturer_id 
                      
      WHERE categ.category_id=77 
      AND prod.product_publish=1 
      AND prod.product_manufacturer_id!=0  
      AND prod.access IN (1,1,5) 
      order by name

    Explain

    Error

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT distinct man.manufacturer_id as id, man.`name_az-AZ` as name FROM `#__jsh' at line 1 SQL=EXPLAIN EXTENDED SELECT distinct man.manufacturer_id as id, man.`name_az-AZ` as name FROM `#__jshopping_products` AS prod LEFT JOIN `#__jshopping_products_to_categories` AS categ USING (product_id) LEFT JOIN `#__jshopping_manufacturers` as man on prod.product_manufacturer_id=man.manufacturer_id WHERE categ.category_id=77 AND prod.product_publish=1 AND prod.product_manufacturer_id!=0 AND prod.access IN (1,1,5) order by name

    Profile

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Creating tmp table	0.05 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:230
    10	jshopCategory->getManufacturers()	JROOT/components/com_jshopping/models/productlist.php:205
    9	jshopProductList->getHtmlSelectFilterManufacturer()	JROOT/components/com_jshopping/controllers/category.php:89
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

33. Query Time: 0.72 ms After last query: 0.08 ms Query memory: 0.027 MB Memory before query: 3.123 MB Rows returned: 10

    SHOW FULL COLUMNS 
      FROM `bm_jshopping_products_reviews`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bm_jshopping_products_reviews`

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.27 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    executing	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    14	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    13	JTable->__construct()	JROOT/components/com_jshopping/tables/review.php:14
    12	jshopReview->__construct()	JROOT/libraries/joomla/table/table.php:308
    11	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
    10	JSFactory::getTable()	JROOT/components/com_jshopping/models/productlist.php:252
    9	jshopProductList->getAllowReview()	JROOT/components/com_jshopping/controllers/category.php:90
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

34. Query Time: 0.70 ms After last query: 0.45 ms Query memory: 0.027 MB Memory before query: 3.157 MB Rows returned: 8

    SHOW FULL COLUMNS 
      FROM `bm_jshopping_addons`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bm_jshopping_addons`

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.27 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    executing	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    17	JTable->__construct()	JROOT/components/com_jshopping/tables/addon.php:20
    16	jshopAddon->__construct()	JROOT/libraries/joomla/table/table.php:308
    15	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
    14	JSFactory::getTable()	JROOT/components/com_jshopping/lib/functions.php:1151
    13	getLicenseKeyAddon()	JROOT/plugins/jshoppingproducts/products_compare/products_compare.php:106
    12	plgJshoppingProductsProducts_Compare->checkLicKey()	JROOT/plugins/jshoppingproducts/products_compare/products_compare.php:26
    11	plgJshoppingProductsProducts_Compare->onBeforeDisplayProductListView()	JROOT/libraries/joomla/event/event.php:69
    10	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    9	JEventDispatcher->trigger()	JROOT/components/com_jshopping/controllers/category.php:131
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

35. Query Time: 0.15 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 3.175 MB Rows returned: 1

    select `key` 
      from bm_jshopping_addons 
      where `alias`='products_compare'

    Explain

    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select `key` from #__jshopping_addons where `alias`='products_compare'' at line 1 SQL=EXPLAIN EXTENDED select `key` from #__jshopping_addons where `alias`='products_compare'

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    15	JDatabaseDriver->loadResult()	JROOT/components/com_jshopping/tables/addon.php:43
    14	jshopAddon->getKeyForAlias()	JROOT/components/com_jshopping/lib/functions.php:1152
    13	getLicenseKeyAddon()	JROOT/plugins/jshoppingproducts/products_compare/products_compare.php:106
    12	plgJshoppingProductsProducts_Compare->checkLicKey()	JROOT/plugins/jshoppingproducts/products_compare/products_compare.php:26
    11	plgJshoppingProductsProducts_Compare->onBeforeDisplayProductListView()	JROOT/libraries/joomla/event/event.php:69
    10	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    9	JEventDispatcher->trigger()	JROOT/components/com_jshopping/controllers/category.php:131
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

36. Query Time: 0.76 ms After last query: 0.34 ms Query memory: 0.023 MB Memory before query: 3.371 MB Rows returned: 8

    SHOW FULL COLUMNS 
      FROM `bm_template_styles`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bm_template_styles`

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.27 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    executing	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    12	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    11	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    10	JTable->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
    9	TemplatesTableStyle->__construct()	JROOT/libraries/joomla/table/table.php:308
    8	JTable::getInstance()	JROOT/plugins/system/helix/helix.php:83
    7	plgSystemHelix->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

37. Query Time: 0.20 ms After last query: 0.10 ms Query memory: 0.060 MB Memory before query: 3.389 MB Rows returned: 1

    SELECT *
    
      FROM bm_template_styles
    
      WHERE `id` = '141'

    Explain

    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__template_styles WHERE `id` = '141'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM #__template_styles WHERE `id` = '141'

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    9	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    8	JTable->load()	JROOT/plugins/system/helix/helix.php:84
    7	plgSystemHelix->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

38. Query Time: 0.48 ms After last query: 0.24 ms Query memory: 0.021 MB Memory before query: 3.514 MB Rows returned: 3

    SELECT language,id
    
      FROM `bm_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    Explain

    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT language,id FROM `#__menu` WHERE home = 1 AND published = 1 AND client_id' at line 1 SQL=EXPLAIN EXTENDED SELECT language,id FROM `#__menu` WHERE home = 1 AND published = 1 AND client_id = 0

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.31 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:121
    8	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:697
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

39. Query Time: 0.27 ms After last query: 0.26 ms Query memory: 0.021 MB Memory before query: 3.526 MB Rows returned: 2

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `bm_menu` AS `c`
    
      INNER JOIN `bm_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `bm_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `bm_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 1340

    Explain

    Error

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `c2`.`language`,`c2`.`id` FROM `#__menu` AS `c` INNER JOIN `#__associatio' at line 1 SQL=EXPLAIN EXTENDED SELECT `c2`.`language`,`c2`.`id` FROM `#__menu` AS `c` INNER JOIN `#__associations` AS `a` ON a.id = c.`id` AND a.context='com_menus.item' INNER JOIN `#__associations` AS `a2` ON a.key = a2.key INNER JOIN `#__menu` AS `c2` ON a2.id = c2.`id` WHERE c.id = 1340

    Profile

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
    10	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:284
    9	MenusHelper::getAssociations()	JROOT/components/com_jshopping/helpers/association.php:30
    8	JshoppingHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:729
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

40. Query Time: 0.57 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 3.531 MB Rows returned: 23

    select id,link 
      from bm_menu 
    			          
      where `type`='component' 
      and published=1 
      and link like '%option=com_jshopping%' 
      and client_id=0 
    					  
      and (language='*' or language='ru-RU') 
      and access IN (1,1,5)

    Explain

    Error

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select id,link from #__menu where `type`='component' and publishe' at line 1 SQL=EXPLAIN EXTENDED select id,link from #__menu where `type`='component' and published=1 and link like '%option=com_jshopping%' and client_id=0 and (language='*' or language='ru-RU') and access IN (1,1,5)

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.36 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:141
    17	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:47
    16	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:40
    15	shopItemMenu::getInstance()	JROOT/components/com_jshopping/router.php:16
    14	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    13	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    12	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    11	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    10	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    8	JRoute::_()	JROOT/plugins/system/languagefilter/languagefilter.php:756
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

41. Query Time: 0.42 ms After last query: 0.11 ms Query memory: 0.024 MB Memory before query: 3.565 MB Rows returned: 0

    select category_id as id, `alias_ru-RU` as alias 
      from bm_jshopping_categories 
      where `alias_ru-RU`!=''

    Explain

    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select category_id as id, `alias_ru-RU` as alias from #__jshopping_categories wh' at line 1 SQL=EXPLAIN EXTENDED select category_id as id, `alias_ru-RU` as alias from #__jshopping_categories where `alias_ru-RU`!=''

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.29 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:255
    15	JSFactory::getAliasCategory()	JROOT/components/com_jshopping/router.php:63
    14	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    13	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    12	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    11	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    10	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    8	JRoute::_()	JROOT/plugins/system/languagefilter/languagefilter.php:756
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

42. Query Time: 0.79 ms After last query: 2.68 ms Query memory: 0.027 MB Memory before query: 3.564 MB Rows returned: 18

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM bm_modules AS m
    
      LEFT JOIN bm_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN bm_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 <= '2026-03-04 03:01:54') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-03-04 03:01:54') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 1340 OR mm.menuid <= 0) 
      AND m.language IN ('az-AZ','*')
    
      ORDER BY m.position, m.ordering

    Explain

    Error

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm' at line 1 SQL=EXPLAIN EXTENDED SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM #__modules AS m LEFT JOIN #__modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN #__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 <= '2026-03-04 03:01:54') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-03-04 03:01:54') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 1340 OR mm.menuid <= 0) AND m.language IN ('az-AZ','*') ORDER BY m.position, m.ordering

    Profile

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.08 ms
    preparing	0.03 ms
    executing	0.40 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:413
    15	JModuleHelper::getModuleList()	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:356
    14	JModuleHelper::load()	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:84
    13	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
    12	JDocumentHtml->countModules()	JROOT/plugins/system/helix/core/helix.php:735
    11	Helix::countModules()	JROOT/plugins/system/helix/core/helix.php:351
    10	Helix::showRow()	JROOT/plugins/system/helix/core/helix.php:448
    9	Helix::generatelayout()	JROOT/plugins/system/helix/core/helix.php:713
    8	Helix::layout()	JROOT/templates/vina_veneno/index.php:54
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

43. Query Time: 1.00 ms After last query: 2.50 ms Query memory: 0.143 MB Memory before query: 3.732 MB Rows returned: 2298

    SELECT guest, client_id
    
      FROM bm_session
    
      WHERE client_id = 0

    Explain

    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT guest, client_id FROM #__session WHERE client_id = 0' at line 1 SQL=EXPLAIN EXTENDED SELECT guest, client_id FROM #__session WHERE client_id = 0

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.72 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_whosonline/helper.php:43
    11	ModWhosonlineHelper::getOnlineCount()	JROOT/modules/mod_whosonline/mod_whosonline.php:19
    10	include JROOT/modules/mod_whosonline/mod_whosonline.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

44. Query Time: 0.72 ms After last query: 7.67 ms Query memory: 0.004 MB Memory before query: 5.026 MB

    LOCK TABLES `bm_extensions` WRITE

    Explain

    EXPLAIN not possible on query: LOCK TABLES `bm_extensions` WRITE

    Profile

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.01 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.46 ms
    System lock	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:543
    8	JDatabaseDriverMysqli->lockTable()	JROOT/plugins/system/updatenotification/updatenotification.php:79
    7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

45. Query Time: 0.58 ms After last query: 0.03 ms Query memory: 0.004 MB Memory before query: 5.031 MB

    UPDATE `bm_extensions`
    
      SET `params` = '{\"lastrun\":1772593315}'
    
      WHERE `type` = 'plugin' 
      AND `folder` = 'system' 
      AND `element` = 'updatenotification'

    Explain

    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `#__extensions` SET `params` = '{\"lastrun\":1772593315}' WHERE `type` = ' at line 1 SQL=EXPLAIN EXTENDED UPDATE `#__extensions` SET `params` = '{\"lastrun\":1772593315}' WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'updatenotification'

    Profile

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.15 ms
    updating	0.10 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.10 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    8	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/updatenotification/updatenotification.php:90
    7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

46. Query Time: 0.15 ms After last query: 0.29 ms Query memory: 0.004 MB Memory before query: 5.037 MB

    UNLOCK TABLES

    Explain

    EXPLAIN not possible on query: UNLOCK TABLES

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    waiting for handler commit	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:918
    8	JDatabaseDriverMysqli->unlockTables()	JROOT/plugins/system/updatenotification/updatenotification.php:104
    7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

47. Query Time: 0.72 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 5.047 MB Rows returned: 0

    SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query
    
      FROM `bm_update_sites` AS `a`
    
      INNER JOIN bm_update_sites_extensions AS b 
      ON a.update_site_id = b.update_site_id
    
      WHERE a.enabled = 1 
      AND b.extension_id IN (700)

    Explain

    Error

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.' at line 1 SQL=EXPLAIN EXTENDED SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query FROM `#__update_sites` AS `a` INNER JOIN #__update_sites_extensions AS b ON a.update_site_id = b.update_site_id WHERE a.enabled = 1 AND b.extension_id IN (700)

    Profile

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.03 ms
    Creating tmp table	0.06 ms
    executing	0.24 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    10	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/updater/updater.php:229
    9	JUpdater->getUpdateSites()	JROOT/libraries/joomla/updater/updater.php:119
    8	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:123
    7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---