{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1772596880,
                "last": 1772596880,
                "now": 1772596881
            },
            "token": "pMmJ3bbl446fGuk7rzUJlDcN2hFQZQMj"
        },
        "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\/manufadzturers-az\/manufacturer\/view\/28",
        "jshop_end_page_list_product": "\/index.php\/az\/manufadzturers-az\/manufacturer\/view\/28"
    }
}

Time

Memory

50 Queries Logged 35.81 ms

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

   SELECT `data`
   
     FROM `bm_session`
   
     WHERE `session_id` = '0325dc2f353d286512d91e80f1aa7b89'

   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` = '0325dc2f353d286512d91e80f1' at line 1 SQL=EXPLAIN EXTENDED SELECT `data` FROM `#__session` WHERE `session_id` = '0325dc2f353d286512d91e80f1aa7b89'

   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.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.09 ms
   preparing	0.02 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   cleaning up	0.01 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.46 ms After last query: 0.20 ms Query memory: 0.003 MB Memory before query: 0.674 MB

   DELETE 
   
     FROM `bm_session`
   
     WHERE `time` < '1772236881'

   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 'DELETE FROM `#__session` WHERE `time` < '1772236881'' at line 1 SQL=EXPLAIN EXTENDED DELETE FROM `#__session` WHERE `time` < '1772236881'

   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.01 ms
   System lock	0.07 ms
   updating	0.04 ms
   end	0.01 ms
   query end	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
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
   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.]

   ---

3. Query Time: 0.49 ms After last query: 0.52 ms Query memory: 0.021 MB Memory before query: 0.727 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.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.04 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.08 ms
   preparing	0.04 ms
   executing	0.05 ms
   end	0.01 ms
   query end	0.01 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: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.]

   ---

4. Query Time: 0.36 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 0.731 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.04 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.02 ms
   executing	0.08 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   cleaning up	0.01 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.]

   ---

5. Query Time: 1.41 ms After last query: 0.43 ms Query memory: 0.025 MB Memory before query: 0.742 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.05 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.03 ms
   statistics	0.09 ms
   preparing	0.04 ms
   executing	0.93 ms
   end	0.01 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
   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.]

   ---

6. Query Time: 0.63 ms After last query: 2.82 ms Query memory: 0.021 MB Memory before query: 1.085 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.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.02 ms
   statistics	0.09 ms
   preparing	0.03 ms
   executing	0.08 ms
   end	0.01 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
   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.]

   ---

7. Query Time: 0.74 ms After last query: 1.48 ms Query memory: 0.007 MB Memory before query: 1.249 MB

   UPDATE `bm_extensions`
   
     SET `params` = '{\"mediaversion\":\"1d3ebf296d0e7d167bfc5bf4803fc33a\"}'
   
     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\":\"1d3ebf296d0e7d167bfc5' at line 1 SQL=EXPLAIN EXTENDED UPDATE `#__extensions` SET `params` = '{\"mediaversion\":\"1d3ebf296d0e7d167bfc5bf4803fc33a\"}' WHERE `type` = 'library' AND `element` = 'joomla'

   Profile

   Status	Duration
   starting	0.07 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.05 ms
   init	0.01 ms
   System lock	0.12 ms
   updating	0.10 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.16 ms
   closing tables	0.01 ms
   freeing items	0.06 ms
   cleaning up	0.01 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.]

   ---

8. Query Time: 2.71 ms After last query: 0.16 ms Query memory: 0.077 MB Memory before query: 1.273 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.11 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.06 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.09 ms
   preparing	0.06 ms
   executing	2.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.03 ms
   cleaning up	0.01 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.]

   ---

9. Query Time: 5.19 ms After last query: 3.61 ms Query memory: 0.047 MB Memory before query: 1.895 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.03 ms
   checking permissions	0.02 ms
   checking permissions	0.03 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.03 ms
   checking permissions	0.03 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.04 ms
   checking permissions	0.03 ms
   checking permissions	0.03 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.03 ms
   checking permissions	0.02 ms
   checking permissions	0.03 ms
   checking permissions	0.02 ms
   checking permissions	0.03 ms
   checking permissions	0.02 ms
   checking permissions	0.03 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.03 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.03 ms
   checking permissions	0.03 ms
   checking permissions	0.04 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.05 ms
   checking permissions	0.03 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.03 ms
   checking permissions	0.03 ms
   checking permissions	0.02 ms
   checking permissions	0.03 ms
   checking permissions	0.03 ms
   checking permissions	0.02 ms
   checking permissions	0.03 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.03 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.27 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.02 ms
   closing tables	0.02 ms
   freeing items	0.09 ms
   cleaning up	0.01 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.]

   ---

10. Query Time: 0.59 ms After last query: 0.35 ms Query memory: 0.097 MB Memory before query: 2.094 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.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.05 ms
    executing	0.14 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
    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.]

    ---

11. Query Time: 0.88 ms After last query: 0.19 ms Query memory: 0.027 MB Memory before query: 2.096 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.34 ms
    init	0.00 ms
    System lock	0.01 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.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.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 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.]

    ---

12. Query Time: 0.21 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 2.115 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.01 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.]

    ---

13. Query Time: 1.57 ms After last query: 0.06 ms Query memory: 0.039 MB Memory before query: 2.131 MB Rows returned: 58
    Duplicate queries: #14

    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.32 ms
    init	0.01 ms
    System lock	0.01 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.06 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.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.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.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.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.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.11 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.]

    ---

14. Query Time: 1.59 ms After last query: 0.22 ms Query memory: 0.039 MB Memory before query: 2.219 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.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.31 ms
    init	0.01 ms
    System lock	0.01 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.04 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.02 ms
    checking permissions	0.02 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.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.02 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.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 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.]

    ---

15. Query Time: 0.89 ms After last query: 0.17 ms Query memory: 0.029 MB Memory before query: 2.359 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.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.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.02 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
    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.]

    ---

16. Query Time: 0.77 ms After last query: 0.08 ms Query memory: 0.027 MB Memory before query: 2.385 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.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.31 ms
    init	0.01 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.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.]

    ---

17. Query Time: 0.15 ms After last query: 0.04 ms Query memory: 0.025 MB Memory before query: 2.402 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.]

    ---

18. Query Time: 1.09 ms After last query: 5.86 ms Query memory: 0.027 MB Memory before query: 2.473 MB Rows returned: 28

    SHOW FULL COLUMNS 
      FROM `bm_jshopping_manufacturers`

    Explain

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

    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.29 ms
    init	0.01 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.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.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.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.05 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/manufacturer.php:15
    11	jshopManufacturer->__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/manufacturer.php:53
    8	JshoppingControllerManufacturer->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.23 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 2.513 MB Rows returned: 1

    SELECT *
    
      FROM bm_jshopping_manufacturers
    
      WHERE `manufacturer_id` = '28'

    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_manufacturers WHERE `manufacturer_id` = '28'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM #__jshopping_manufacturers WHERE `manufacturer_id` = '28'

    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.03 ms
    init	0.00 ms
    System lock	0.02 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/manufacturer.php:54
    8	JshoppingControllerManufacturer->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.62 ms After last query: 0.42 ms Query memory: 0.023 MB Memory before query: 2.568 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.06 ms
    preparing	0.02 ms
    executing	0.38 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:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:141
    13	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:47
    12	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:40
    11	shopItemMenu::getInstance()	JROOT/components/com_jshopping/lib/functions.php:415
    10	getShopManufacturerPageItemid()	JROOT/components/com_jshopping/helpers/metadata.php:115
    9	JshopHelpersMetadata::manufacturer()	JROOT/components/com_jshopping/controllers/manufacturer.php:64
    8	JshoppingControllerManufacturer->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: 1.01 ms After last query: 0.33 ms Query memory: 0.033 MB Memory before query: 2.611 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.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.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
    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/manufacturer.php:225
    10	jshopManufacturer->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/manufacturer.php:68
    8	JshoppingControllerManufacturer->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.18 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 2.651 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.01 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/manufacturer.php:225
    10	jshopManufacturer->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/manufacturer.php:68
    8	JshoppingControllerManufacturer->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: 0.18 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 2.662 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/manufacturer.php:225
    10	jshopManufacturer->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/manufacturer.php:68
    8	JshoppingControllerManufacturer->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.85 ms After last query: 0.09 ms Query memory: 0.028 MB Memory before query: 2.671 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.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.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.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.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/manufacturer.php:111
    10	jshopManufacturer->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/manufacturer.php:68
    8	JshoppingControllerManufacturer->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.52 ms After last query: 0.06 ms Query memory: 0.040 MB Memory before query: 2.703 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.30 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
    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/manufacturer.php:111
    10	jshopManufacturer->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/manufacturer.php:68
    8	JshoppingControllerManufacturer->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.70 ms After last query: 0.30 ms Query memory: 0.026 MB Memory before query: 2.825 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.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.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.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 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
    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/manufacturer.php:111
    10	jshopManufacturer->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/manufacturer.php:68
    8	JshoppingControllerManufacturer->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.14 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 2.840 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/manufacturer.php:111
    10	jshopManufacturer->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/manufacturer.php:68
    8	JshoppingControllerManufacturer->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.38 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 2.845 MB Rows returned: 1

    SELECT COUNT(distinct prod.product_id) 
      FROM `bm_jshopping_products` as prod
                      
      LEFT JOIN `bm_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `bm_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_manufacturer_id=28 
      AND prod.product_publish=1 
      AND cat.category_publish=1  
      AND prod.access IN (1,1,5) 
      AND cat.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(distinct prod.product_id) FROM `#__jshopping_products` as prod ' at line 1 SQL=EXPLAIN EXTENDED SELECT COUNT(distinct prod.product_id) FROM `#__jshopping_products` as prod LEFT JOIN `#__jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `#__jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_manufacturer_id=28 AND prod.product_publish=1 AND cat.category_publish=1 AND prod.access IN (1,1,5) AND cat.access IN (1,1,5)

    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
    checking permissions	0.00 ms
    Opening tables	0.07 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.05 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.03 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/manufacturer.php:123
    10	jshopManufacturer->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/manufacturer.php:68
    8	JshoppingControllerManufacturer->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.24 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 2.917 MB Rows returned: 0

    select manufacturer_id as id, `alias_az-AZ` as alias 
      from bm_jshopping_manufacturers 
      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 manufacturer_id as id, `alias_az-AZ` as alias from #__jshopping_manufactu' at line 1 SQL=EXPLAIN EXTENDED select manufacturer_id as id, `alias_az-AZ` as alias from #__jshopping_manufacturers 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.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.10 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
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:279
    19	JSFactory::getAliasManufacturer()	JROOT/components/com_jshopping/router.php:110
    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/libraries/cms/pagination/pagination.php:773
    11	JPagination->_buildDataObject()	JROOT/libraries/cms/pagination/pagination.php:319
    10	JPagination->getPagesLinks()	JROOT/components/com_jshopping/models/productlist.php:180
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/manufacturer.php:68
    8	JshoppingControllerManufacturer->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.66 ms After last query: 0.28 ms Query memory: 0.056 MB Memory before query: 2.934 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)
                      
      LEFT JOIN `bm_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id                  
                      
                      
      WHERE prod.product_manufacturer_id=28 
      AND prod.product_publish=1 
      AND cat.category_publish=1  
      AND prod.access IN (1,1,5) 
      AND cat.access IN (1,1,5)
                      
      GROUP BY prod.product_id  
      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) LEFT JOIN `#__jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_manufacturer_id=28 AND prod.product_publish=1 AND cat.category_publish=1 AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) GROUP BY prod.product_id ORDER BY prod.average_rating DESC LIMIT 0, 12

    Profile

    Status	Duration
    starting	0.10 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.19 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    Creating tmp table	0.05 ms
    executing	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
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/manufacturer.php:104
    10	jshopManufacturer->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/manufacturer.php:68
    8	JshoppingControllerManufacturer->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.36 ms After last query: 0.20 ms Query memory: 0.021 MB Memory before query: 2.937 MB Rows returned: 0

    SELECT distinct cat.category_id as id, cat.`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_categories` as cat 
      on cat.category_id=categ.category_id
                      
      WHERE prod.product_publish=1 
      AND prod.product_manufacturer_id=28 
      AND cat.category_publish=1  
      AND prod.access IN (1,1,5) 
      AND cat.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 cat.category_id as id, cat.`name_az-AZ` as name FROM `#__jshoppi' at line 1 SQL=EXPLAIN EXTENDED SELECT distinct cat.category_id as id, cat.`name_az-AZ` as name FROM `#__jshopping_products` AS prod LEFT JOIN `#__jshopping_products_to_categories` AS categ USING (product_id) LEFT JOIN `#__jshopping_categories` as cat on cat.category_id=categ.category_id WHERE prod.product_publish=1 AND prod.product_manufacturer_id=28 AND cat.category_publish=1 AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) order by name

    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
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.01 ms
    Creating tmp table	0.02 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/manufacturer.php:142
    10	jshopManufacturer->getCategorys()	JROOT/components/com_jshopping/models/productlist.php:225
    9	jshopProductList->getHtmlSelectFilterCategory()	JROOT/components/com_jshopping/controllers/manufacturer.php:81
    8	JshoppingControllerManufacturer->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.82 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 2.954 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.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.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.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.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.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
    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/manufacturer.php:82
    8	JshoppingControllerManufacturer->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.80 ms After last query: 0.48 ms Query memory: 0.028 MB Memory before query: 2.994 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.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.32 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.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/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/manufacturer.php:116
    8	JshoppingControllerManufacturer->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.16 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 3.013 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.02 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/manufacturer.php:116
    8	JshoppingControllerManufacturer->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.78 ms After last query: 0.19 ms Query memory: 0.023 MB Memory before query: 3.008 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.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.30 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.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 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.]

    ---

36. Query Time: 0.20 ms After last query: 0.07 ms Query memory: 0.060 MB Memory before query: 3.025 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.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.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.]

    ---

37. Query Time: 0.49 ms After last query: 0.27 ms Query memory: 0.021 MB Memory before query: 3.150 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.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.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.]

    ---

38. Query Time: 0.27 ms After last query: 0.30 ms Query memory: 0.021 MB Memory before query: 3.162 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 = 1182

    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 = 1182

    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.06 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.]

    ---

39. Query Time: 0.61 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 3.167 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.02 ms
    executing	0.39 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.]

    ---

40. Query Time: 0.24 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 3.202 MB Rows returned: 9

    select manufacturer_id as id, `alias_ru-RU` as alias 
      from bm_jshopping_manufacturers 
      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 manufacturer_id as id, `alias_ru-RU` as alias from #__jshopping_manufactu' at line 1 SQL=EXPLAIN EXTENDED select manufacturer_id as id, `alias_ru-RU` as alias from #__jshopping_manufacturers 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.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.10 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:279
    15	JSFactory::getAliasManufacturer()	JROOT/components/com_jshopping/router.php:110
    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.75 ms After last query: 3.01 ms Query memory: 0.027 MB Memory before query: 3.202 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 04:01:21') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-03-04 04:01:21') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 1182 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 04:01:21') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-03-04 04:01:21') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 1182 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.09 ms
    preparing	0.04 ms
    executing	0.33 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
    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.]

    ---

42. Query Time: 1.02 ms After last query: 2.77 ms Query memory: 0.155 MB Memory before query: 3.370 MB Rows returned: 2446

    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.05 ms
    preparing	0.01 ms
    executing	0.74 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.]

    ---

43. Query Time: 0.56 ms After last query: 7.81 ms Query memory: 0.004 MB Memory before query: 4.470 MB

    LOCK TABLES `bm_extensions` WRITE

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.32 ms
    System lock	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.00 ms
    freeing items	0.04 ms
    cleaning up	0.00 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.]

    ---

44. Query Time: 0.53 ms After last query: 0.03 ms Query memory: 0.004 MB Memory before query: 4.475 MB

    UPDATE `bm_extensions`
    
      SET `params` = '{\"lastrun\":1772596881}'
    
      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\":1772596881}' WHERE `type` = ' at line 1 SQL=EXPLAIN EXTENDED UPDATE `#__extensions` SET `params` = '{\"lastrun\":1772596881}' WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'updatenotification'

    Profile

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.10 ms
    updating	0.07 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.19 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.00 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.]

    ---

45. Query Time: 0.11 ms After last query: 0.30 ms Query memory: 0.004 MB Memory before query: 4.481 MB

    UNLOCK TABLES

    Explain

    EXPLAIN not possible on query: UNLOCK TABLES

    Profile

    Status	Duration
    starting	0.01 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    waiting for handler commit	0.01 ms
    query end	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
    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.]

    ---

46. Query Time: 0.52 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 4.491 MB Rows returned: 1

    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.06 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.04 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    Creating tmp table	0.04 ms
    executing	0.18 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.03 ms
    cleaning up	0.00 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.]

    ---

47. Query Time: 0.23 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 4.503 MB Rows returned: 1

    SELECT `name`
    
      FROM `bm_update_sites`
    
      WHERE `update_site_id` = '2'

    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` FROM `#__update_sites` WHERE `update_site_id` = '2'' at line 1 SQL=EXPLAIN EXTENDED SELECT `name` FROM `#__update_sites` WHERE `update_site_id` = '2'

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/updater/updateadapter.php:188
    12	JUpdateAdapter->getUpdateSiteName()	JROOT/libraries/joomla/updater/updateadapter.php:215
    11	JUpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/joomla/updater/adapters/collection.php:223
    10	JUpdaterCollection->findUpdate()	JROOT/libraries/joomla/updater/updater.php:267
    9	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
    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.]

    ---

48. Query Time: 0.33 ms After last query: 0.03 ms Query memory: 0.006 MB Memory before query: 4.510 MB

    UPDATE `bm_update_sites`
    
      SET `enabled` = '0'
    
      WHERE `update_site_id` = '2'

    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 `#__update_sites` SET `enabled` = '0' WHERE `update_site_id` = '2'' at line 1 SQL=EXPLAIN EXTENDED UPDATE `#__update_sites` SET `enabled` = '0' WHERE `update_site_id` = '2'

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/updater/updateadapter.php:153
    12	JUpdateAdapter->toggleUpdateSite()	JROOT/libraries/joomla/updater/updateadapter.php:238
    11	JUpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/joomla/updater/adapters/collection.php:223
    10	JUpdaterCollection->findUpdate()	JROOT/libraries/joomla/updater/updater.php:267
    9	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
    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.]

    ---

49. Query Time: 0.71 ms After last query: 231.78 ms Query memory: 0.006 MB Memory before query: 4.520 MB

    UPDATE `bm_update_sites`
    
      SET `enabled` = '1'
    
      WHERE `update_site_id` = '2'

    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 `#__update_sites` SET `enabled` = '1' WHERE `update_site_id` = '2'' at line 1 SQL=EXPLAIN EXTENDED UPDATE `#__update_sites` SET `enabled` = '1' WHERE `update_site_id` = '2'

    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.05 ms
    init	0.01 ms
    System lock	0.06 ms
    updating	0.09 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.13 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/updater/updateadapter.php:153
    12	JUpdateAdapter->toggleUpdateSite()	JROOT/libraries/joomla/updater/updateadapter.php:254
    11	JUpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/joomla/updater/adapters/collection.php:223
    10	JUpdaterCollection->findUpdate()	JROOT/libraries/joomla/updater/updater.php:267
    9	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
    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.]

    ---

50. Query Time: 0.46 ms After last query: 1.20 ms Query memory: 0.005 MB Memory before query: 4.522 MB

    UPDATE `bm_update_sites`
    
      SET `last_check_timestamp` = '1772596881'
    
      WHERE `update_site_id` = '2'

    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 `#__update_sites` SET `last_check_timestamp` = '1772596881' WHERE `update' at line 1 SQL=EXPLAIN EXTENDED UPDATE `#__update_sites` SET `last_check_timestamp` = '1772596881' WHERE `update_site_id` = '2'

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/updater/updater.php:429
    9	JUpdater->updateLastCheckTimestamp()	JROOT/libraries/joomla/updater/updater.php:165
    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.]

    ---