Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 0.68 ms / 0.68 ms Memory: 0.045 MB / 0.38 MB Application: afterLoad

Time: 16.40 ms / 17.08 ms Memory: 1.334 MB / 1.71 MB Application: afterInitialise

Time: 15.69 ms / 32.76 ms Memory: 0.683 MB / 2.39 MB Application: afterRoute

Time: 0.62 ms / 33.38 ms Memory: 0.013 MB / 2.41 MB Application: beforeRenderComponent com_jshopping

Time: 27.92 ms / 61.30 ms Memory: 0.637 MB / 3.04 MB Application: afterRenderComponent com_jshopping

Time: 7.24 ms / 68.54 ms Memory: 0.118 MB / 3.16 MB Application: afterDispatch

Time: 8.68 ms / 77.23 ms Memory: 0.147 MB / 3.31 MB Application: beforeRenderModule mod_languages (Сменить язык (внизу))

Time: 1.27 ms / 78.50 ms Memory: 0.078 MB / 3.39 MB Application: afterRenderModule mod_languages (Сменить язык (внизу))

Time: 0.36 ms / 78.86 ms Memory: 0.005 MB / 3.39 MB Application: beforeRenderModule mod_whosonline (Ziyarətçilər)

Time: 2.64 ms / 81.50 ms Memory: 0.029 MB / 3.42 MB Application: afterRenderModule mod_whosonline (Ziyarətçilər)

Time: 0.27 ms / 81.77 ms Memory: 0.003 MB / 3.42 MB Application: beforeRenderModule mod_easycookieinfo (EasyCookieInfo)

Time: 0.31 ms / 82.08 ms Memory: 0.012 MB / 3.44 MB Application: afterRenderModule mod_easycookieinfo (EasyCookieInfo)

Time: 0.04 ms / 82.12 ms Memory: 0.000 MB / 3.43 MB Application: beforeRenderModule mod_breadcrumbs (Хлебные крошки (верх))

Time: 0.31 ms / 82.43 ms Memory: 0.009 MB / 3.44 MB Application: afterRenderModule mod_breadcrumbs (Хлебные крошки (верх))

Time: 0.36 ms / 82.79 ms Memory: 0.158 MB / 3.60 MB Application: beforeRenderModule mod_jshopping_products_compare (Malların müqayisəsi)

Time: 0.33 ms / 83.12 ms Memory: 0.010 MB / 3.61 MB Application: afterRenderModule mod_jshopping_products_compare (Malların müqayisəsi)

Time: 0.03 ms / 83.16 ms Memory: 0.000 MB / 3.60 MB Application: beforeRenderModule mod_jshopping_search (Поиск товаров)

Time: 0.32 ms / 83.47 ms Memory: 0.009 MB / 3.61 MB Application: afterRenderModule mod_jshopping_search (Поиск товаров)

Time: 0.30 ms / 83.77 ms Memory: 0.157 MB / 3.77 MB Application: beforeRenderModule mod_jshopping_products_compare (Malların müqayisəsi)

Time: 0.18 ms / 83.96 ms Memory: 0.008 MB / 3.78 MB Application: afterRenderModule mod_jshopping_products_compare (Malların müqayisəsi)

Time: 0.04 ms / 84.00 ms Memory: 0.000 MB / 3.77 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs (навигатор))

Time: 0.10 ms / 84.10 ms Memory: 0.006 MB / 3.78 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs (навигатор))

Time: 0.04 ms / 84.15 ms Memory: 0.000 MB / 3.78 MB Application: beforeRenderModule mod_jcart_ajax (Cart Ajax)

Time: 0.67 ms / 84.81 ms Memory: 0.025 MB / 3.80 MB Application: afterRenderModule mod_jcart_ajax (Cart Ajax)

Time: 0.33 ms / 85.15 ms Memory: 0.007 MB / 3.81 MB Application: beforeRenderModule mod_languages ( Language Switcher )

Time: 0.43 ms / 85.58 ms Memory: 0.005 MB / 3.81 MB Application: afterRenderModule mod_languages ( Language Switcher )

Time: 248.23 ms / 333.81 ms Memory: 0.848 MB / 4.66 MB Application: afterRender

Database queries total: 45.13 ms

Memory Usage

Database Queries

59 Queries Logged 45.13 ms

8 duplicate found!

2 duplicates: #11 #12

2 duplicates: #53 #56

2 duplicates: #54 #57

2 duplicates: #55 #58

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

SELECT `data`

  FROM `bm_session`

  WHERE `session_id` = '81c00e7dedaa50411a7917d4aa756acf'

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

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.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.29 ms After last query: 1.03 ms Query memory: 0.021 MB Memory before query: 0.724 MB Rows returned: 2

SELECT b.id

  FROM bm_usergroups AS a

  LEFT JOIN bm_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 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
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.]

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

SELECT id, rules

  FROM `bm_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.04 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
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.]

Query Time: 0.32 ms After last query: 4.04 ms Query memory: 0.021 MB Memory before query: 1.078 MB Rows returned: 3

SELECT element

  FROM bm_extensions

  WHERE type = 'language' 
  AND client_id = 0 
  AND enabled = 1

Explain

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

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.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.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
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.]

Query Time: 0.39 ms After last query: 1.81 ms Query memory: 0.007 MB Memory before query: 1.242 MB

UPDATE `bm_extensions`

  SET `params` = '{\"mediaversion\":\"f852d890cc09fe97512f0e30b775e4bf\"}'

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

Profile

Status	Duration
starting	0.04 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.06 ms
updating	0.05 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.02 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 1.22 ms After last query: 0.21 ms Query memory: 0.077 MB Memory before query: 1.266 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.06 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.95 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 3.95 ms After last query: 4.15 ms Query memory: 0.047 MB Memory before query: 1.887 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.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.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.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.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.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.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.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.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.22 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.08 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.]

Query Time: 0.50 ms After last query: 0.86 ms Query memory: 0.097 MB Memory before query: 2.085 MB Rows returned: 1

SELECT *

  FROM bm_jshopping_config

  WHERE `id` = '1'

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.98 ms After last query: 0.40 ms Query memory: 0.028 MB Memory before query: 2.089 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.38 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.07 ms
checking permissions	0.05 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.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.05 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.]

Query Time: 0.23 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 2.108 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.]

Query Time: 1.51 ms After last query: 0.10 ms Query memory: 0.039 MB Memory before query: 2.124 MB Rows returned: 58

Duplicate queries: #12

SHOW FULL COLUMNS 
  FROM `bm_jshopping_users`

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.32 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.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.06 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.]

Query Time: 1.52 ms After last query: 0.34 ms Query memory: 0.039 MB Memory before query: 2.212 MB Rows returned: 58

Duplicate queries: #11

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.05 ms
Executing hook on transaction	0.00 ms
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.31 ms
init	0.00 ms
System lock	0.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.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.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.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.06 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.]

Query Time: 1.02 ms After last query: 0.28 ms Query memory: 0.029 MB Memory before query: 2.352 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.29 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.11 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.08 ms
checking permissions	0.04 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.02 ms
checking permissions	0.02 ms
checking permissions	0.02 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
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.]

Query Time: 0.82 ms After last query: 0.15 ms Query memory: 0.027 MB Memory before query: 2.378 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.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
executing	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.04 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.06 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.]

Query Time: 0.18 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 2.393 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.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.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.]

Query Time: 1.81 ms After last query: 9.65 ms Query memory: 0.031 MB Memory before query: 2.464 MB Rows returned: 34

SHOW FULL COLUMNS 
  FROM `bm_jshopping_categories`

Explain

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

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.47 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
executing	0.09 ms
checking permissions	0.07 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.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.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.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.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.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.06 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.30 ms After last query: 0.15 ms Query memory: 0.023 MB Memory before query: 2.513 MB Rows returned: 1

SELECT *

  FROM bm_jshopping_categories

  WHERE `category_id` = '155'

Explain

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

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.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 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.03 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.37 ms After last query: 0.49 ms Query memory: 0.022 MB Memory before query: 2.568 MB Rows returned: 3

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

Explain

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

Profile

Status	Duration
starting	0.05 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.02 ms
statistics	0.10 ms
preparing	0.02 ms
executing	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.03 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.76 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 2.578 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.05 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.00 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.48 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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:141
16	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:47
15	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:40
14	shopItemMenu::getInstance()	JROOT/components/com_jshopping/lib/functions.php:403
13	getShopMainPageItemid()	JROOT/components/com_jshopping/lib/functions.php:422
12	getDefaultItemid()	JROOT/components/com_jshopping/lib/functions.php:481
11	SEFLink()	JROOT/components/com_jshopping/tables/category.php:36
10	jshopCategory->getSubCategories()	JROOT/components/com_jshopping/tables/category.php:119
9	jshopCategory->getChildCategories()	JROOT/components/com_jshopping/controllers/category.php:69
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 2.608 MB Rows returned: 0

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

Explain

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

Profile

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

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

Query Time: 0.24 ms After last query: 0.25 ms Query memory: 0.024 MB Memory before query: 2.626 MB Rows returned: 1

SELECT *

  FROM bm_jshopping_categories

  WHERE `category_id` = '3'

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.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.03 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.21 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 2.633 MB Rows returned: 1

SELECT *

  FROM bm_jshopping_categories

  WHERE `category_id` = '345'

Explain

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

Profile

Status	Duration
starting	0.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.02 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 1.52 ms After last query: 0.44 ms Query memory: 0.033 MB Memory before query: 2.651 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.04 ms
Executing hook on transaction	0.00 ms
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.46 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
executing	0.06 ms
checking permissions	0.06 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.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.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.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/category.php:307
10	jshopCategory->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 2.699 MB Rows returned: 1

SELECT id 
  FROM bm_jshopping_vendors 
  WHERE `main`=1

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.19 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 2.709 MB Rows returned: 1

SELECT *

  FROM bm_jshopping_vendors

  WHERE `id` = '1'

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.90 ms After last query: 0.18 ms Query memory: 0.028 MB Memory before query: 2.719 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.31 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
executing	0.05 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.54 ms After last query: 0.07 ms Query memory: 0.040 MB Memory before query: 2.743 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.31 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.76 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 1.62 ms After last query: 0.44 ms Query memory: 0.026 MB Memory before query: 2.928 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.05 ms
Executing hook on transaction	0.00 ms
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.54 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
executing	0.09 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
checking permissions	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.07 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/joomla/database/driver/mysqli.php:440
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
19	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
18	JTable->__construct()	JROOT/components/com_jshopping/tables/tax.php:14
17	jshopTax->__construct()	JROOT/libraries/joomla/table/table.php:308
16	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
15	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:369
14	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:991
13	getCorrectedPriceForQueryFilter()	JROOT/components/com_jshopping/lib/jtableauto.php:101
12	JTableAvto->getBuildQueryListProductFilterPrice()	JROOT/components/com_jshopping/lib/jtableauto.php:88
11	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/category.php:179
10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.12 ms Query memory: 0.024 MB Memory before query: 2.943 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.04 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.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.41 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 2.948 MB Rows returned: 1

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

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT count() FROM `#__jshopping_products_to_categories` AS pr_cat ' at line 1 SQL=EXPLAIN EXTENDED SELECT count() FROM `#__jshopping_products_to_categories` AS pr_cat INNER JOIN `#__jshopping_products` AS prod ON pr_cat.product_id = prod.product_id WHERE pr_cat.category_id=155 AND prod.product_publish=1 AND prod.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
Opening tables	0.04 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.08 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:1728
11	JDatabaseDriver->loadResult()	JROOT/components/com_jshopping/tables/category.php:190
10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.90 ms After last query: 0.64 ms Query memory: 0.056 MB Memory before query: 2.963 MB Rows returned: 0

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

Explain

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

Profile

Status	Duration
starting	0.14 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.28 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
Creating tmp table	0.13 ms
executing	0.08 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.01 ms

Call Stack

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

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

Query Time: 0.51 ms After last query: 0.32 ms Query memory: 0.021 MB Memory before query: 2.966 MB Rows returned: 0

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

Explain

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

Profile

Status	Duration
starting	0.06 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.08 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.08 ms
executing	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.01 ms

Call Stack

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

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

Query Time: 1.26 ms After last query: 0.13 ms Query memory: 0.027 MB Memory before query: 2.990 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.04 ms
Executing hook on transaction	0.00 ms
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.46 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
Creating tmp table	0.04 ms
executing	0.07 ms
checking permissions	0.02 ms
checking permissions	0.01 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.02 ms
checking permissions	0.02 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.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 1.48 ms After last query: 0.99 ms Query memory: 0.027 MB Memory before query: 3.024 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.06 ms
Executing hook on transaction	0.00 ms
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.55 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
executing	0.09 ms
checking permissions	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 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.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.12 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.30 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 3.042 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.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.01 ms
preparing	0.02 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 1.48 ms After last query: 0.38 ms Query memory: 0.023 MB Memory before query: 3.051 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.04 ms
Executing hook on transaction	0.00 ms
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.57 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
executing	0.08 ms
checking permissions	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 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.05 ms
freeing items	0.06 ms
cleaning up	0.01 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.]

Query Time: 0.31 ms After last query: 0.27 ms Query memory: 0.060 MB Memory before query: 3.068 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.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.04 ms
preparing	0.01 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.61 ms After last query: 0.81 ms Query memory: 0.021 MB Memory before query: 3.193 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.05 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.04 ms
preparing	0.01 ms
executing	0.34 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
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.]

Query Time: 0.34 ms After last query: 0.68 ms Query memory: 0.021 MB Memory before query: 3.206 MB Rows returned: 2

SELECT `c2`.`language`,`c2`.`id`

  FROM `bm_menu` AS `c`

  INNER JOIN `bm_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `bm_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `bm_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 1340

Explain

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

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.08 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.]

Query Time: 0.70 ms After last query: 0.23 ms Query memory: 0.025 MB Memory before query: 3.211 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.04 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.41 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
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.]

Query Time: 0.54 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 3.245 MB Rows returned: 0

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

Explain

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

Profile

Status	Duration
starting	0.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.01 ms
preparing	0.01 ms
executing	0.33 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:1689
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:255
15	JSFactory::getAliasCategory()	JROOT/components/com_jshopping/router.php:63
14	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
13	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
12	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
11	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
10	JRouter->build()	JROOT/libraries/cms/router/site.php:147
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/languagefilter/languagefilter.php:756
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.82 ms After last query: 6.00 ms Query memory: 0.027 MB Memory before query: 3.244 MB Rows returned: 18

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM bm_modules AS m

  LEFT JOIN bm_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN bm_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-03-04 03:02:36') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-03-04 03:02:36') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 1340 OR mm.menuid <= 0) 
  AND m.language IN ('az-AZ','*')

  ORDER BY m.position, m.ordering

Explain

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

Profile

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.00 ms
starting	0.01 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.01 ms
optimizing	0.03 ms
statistics	0.10 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.]

Query Time: 1.06 ms After last query: 4.76 ms Query memory: 0.151 MB Memory before query: 3.412 MB Rows returned: 2307

SELECT guest, client_id

  FROM bm_session

  WHERE client_id = 0

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.73 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.]

Query Time: 0.36 ms After last query: 8.20 ms Query memory: 0.004 MB Memory before query: 4.519 MB

LOCK TABLES `bm_extensions` WRITE

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.20 ms
System lock	0.01 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
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.]

Query Time: 0.34 ms After last query: 0.04 ms Query memory: 0.004 MB Memory before query: 4.524 MB

UPDATE `bm_extensions`

  SET `params` = '{\"lastrun\":1772593356}'

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

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.07 ms
updating	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.09 ms
closing tables	0.00 ms
freeing items	0.02 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.]

Query Time: 0.08 ms After last query: 0.10 ms Query memory: 0.004 MB Memory before query: 4.530 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.00 ms
waiting for handler commit	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 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.]

Query Time: 0.36 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 4.540 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.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.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
executing	0.12 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
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.]

Query Time: 0.17 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 4.552 MB Rows returned: 1

SELECT `name`

  FROM `bm_update_sites`

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.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.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
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.]

Query Time: 0.23 ms After last query: 0.08 ms Query memory: 0.006 MB Memory before query: 4.559 MB

UPDATE `bm_update_sites`

  SET `enabled` = '0'

  WHERE `update_site_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 'UPDATE `#__update_sites` SET `enabled` = '0' WHERE `update_site_id` = '1'' at line 1 SQL=EXPLAIN EXTENDED UPDATE `#__update_sites` SET `enabled` = '0' WHERE `update_site_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.02 ms
updating	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.06 ms
closing tables	0.01 ms
freeing items	0.02 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.]

Query Time: 0.71 ms After last query: 225.07 ms Query memory: 0.006 MB Memory before query: 4.577 MB

UPDATE `bm_update_sites`

  SET `enabled` = '1'

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

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.06 ms
updating	0.08 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.19 ms
closing tables	0.02 ms
freeing items	0.09 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.]

Query Time: 2.44 ms After last query: 1.27 ms Query memory: 0.026 MB Memory before query: 4.586 MB Rows returned: 14

SHOW FULL COLUMNS 
  FROM `bm_updates`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
15	JTable->__construct()	JROOT/libraries/joomla/table/update.php:31
14	JTableUpdate->__construct()	JROOT/libraries/joomla/table/table.php:308
13	JTable::getInstance()	JROOT/libraries/joomla/updater/adapters/collection.php:117
12	JUpdaterCollection->_startElement()	Same as call in the line below.
11	xml_parse()	JROOT/libraries/joomla/updater/adapters/collection.php:234
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.]

Query Time: 2.54 ms After last query: 1.32 ms Query memory: 0.026 MB Memory before query: 4.606 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `bm_extensions`

Explain

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

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.40 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
executing	0.06 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.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.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.02 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.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/libraries/joomla/table/extension.php:31
11	JTableExtension->__construct()	JROOT/libraries/joomla/table/table.php:308
10	JTable::getInstance()	JROOT/libraries/joomla/updater/updater.php:311
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.]

Query Time: 1.87 ms After last query: 0.31 ms Query memory: 0.021 MB Memory before query: 4.635 MB Rows returned: 1

Duplicate queries: #56

SELECT `update_id`

  FROM `bm_updates`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

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 `update_id` FROM `#__updates` WHERE element = 'joomla' AND type = 'file' ' at line 1 SQL=EXPLAIN EXTENDED SELECT `update_id` FROM `#__updates` WHERE element = 'joomla' AND type = 'file' AND client_id = '0' AND folder = ''

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.29 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 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/libraries/joomla/table/update.php:110
10	JTableUpdate->find()	JROOT/libraries/joomla/updater/updater.php:319
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.]

Query Time: 0.39 ms After last query: 0.19 ms Query memory: 0.021 MB Memory before query: 4.640 MB Rows returned: 1

Duplicate queries: #57

SELECT `extension_id`

  FROM `bm_extensions`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

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 `extension_id` FROM `#__extensions` WHERE element = 'joomla' AND type = '' at line 1 SQL=EXPLAIN EXTENDED SELECT `extension_id` FROM `#__extensions` WHERE element = 'joomla' AND type = 'file' AND client_id = '0' AND folder = ''

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.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	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:1728
11	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:109
10	JTableExtension->find()	JROOT/libraries/joomla/updater/updater.php:329
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.]

Query Time: 0.58 ms After last query: 0.13 ms Query memory: 0.021 MB Memory before query: 4.646 MB Rows returned: 1

Duplicate queries: #58

SELECT *

  FROM bm_updates

  WHERE `update_id` = '62'

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 #__updates WHERE `update_id` = '62'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM #__updates WHERE `update_id` = '62'

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.01 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:1453
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
10	JTable->load()	JROOT/libraries/joomla/updater/updater.php:356
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.]

Query Time: 0.61 ms After last query: 0.23 ms Query memory: 0.021 MB Memory before query: 4.651 MB Rows returned: 1

Duplicate queries: #53

SELECT `update_id`

  FROM `bm_updates`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

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 `update_id` FROM `#__updates` WHERE element = 'joomla' AND type = 'file' ' at line 1 SQL=EXPLAIN EXTENDED SELECT `update_id` FROM `#__updates` WHERE element = 'joomla' AND type = 'file' AND client_id = '0' AND folder = ''

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.28 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:1728
11	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/update.php:110
10	JTableUpdate->find()	JROOT/libraries/joomla/updater/updater.php:319
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.]

Query Time: 0.31 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 4.656 MB Rows returned: 1

Duplicate queries: #54

SELECT `extension_id`

  FROM `bm_extensions`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

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 `extension_id` FROM `#__extensions` WHERE element = 'joomla' AND type = '' at line 1 SQL=EXPLAIN EXTENDED SELECT `extension_id` FROM `#__extensions` WHERE element = 'joomla' AND type = 'file' AND client_id = '0' AND folder = ''

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.01 ms
executing	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.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
11	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:109
10	JTableExtension->find()	JROOT/libraries/joomla/updater/updater.php:329
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.]

Query Time: 0.21 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 4.662 MB Rows returned: 1

Duplicate queries: #55

SELECT *

  FROM bm_updates

  WHERE `update_id` = '62'

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 #__updates WHERE `update_id` = '62'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM #__updates WHERE `update_id` = '62'

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.01 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:1453
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
10	JTable->load()	JROOT/libraries/joomla/updater/updater.php:356
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.]

Query Time: 0.28 ms After last query: 0.09 ms Query memory: 0.005 MB Memory before query: 4.662 MB

UPDATE `bm_update_sites`

  SET `last_check_timestamp` = '1772593356'

  WHERE `update_site_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 'UPDATE `#__update_sites` SET `last_check_timestamp` = '1772593356' WHERE `update' at line 1 SQL=EXPLAIN EXTENDED UPDATE `#__update_sites` SET `last_check_timestamp` = '1772593356' WHERE `update_site_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.03 ms
updating	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.08 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
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.]

52 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

3 × SELECT * 
  FROM bm_jshopping_categories

```
2 × SELECT * 
  FROM bm_updates
```

2 × SELECT `extension_id` 
  FROM `bm_extensions`

2 × SELECT `update_id` 
  FROM `bm_updates`

```
2 × select id,link 
  from bm_menu
```

1 × 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)

1 × SELECT `name` 
  FROM `bm_update_sites`

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

1 × SELECT guest, client_id 
  FROM bm_session

1 × 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

1 × select category_id as id, `alias_ru-RU` as alias 
  from bm_jshopping_categories

1 × 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`

1 × SELECT language,id 
  FROM `bm_menu`

1 × SELECT * 
  FROM bm_template_styles

1 × select `key` 
  from bm_jshopping_addons

1 × SELECT distinct man.manufacturer_id as id, man.`name_az-AZ` as name 
  FROM `bm_jshopping_products` AS prod
                   
  LEFT JOIN `bm_jshopping_products_to_categories` AS categ USING (product_id)
                   
  LEFT JOIN `bm_jshopping_manufacturers` as man 
  on prod.product_manufacturer_id=man.manufacturer_id

1 × SELECT `data` 
  FROM `bm_session`

1 × SELECT count(*) 
  FROM `bm_jshopping_products_to_categories` AS pr_cat
                   
  INNER JOIN `bm_jshopping_products` AS prod 
  ON pr_cat.product_id = prod.product_id

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

1 × 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

1 × SELECT * 
  FROM bm_jshopping_vendors

1 × SELECT id 
  FROM bm_jshopping_vendors

1 × select category_id as id, `alias_az-AZ` as alias 
  from bm_jshopping_categories

1 × SELECT `name_az-AZ` as name,`description_az-AZ` as description,`short_description_az-AZ` as short_description, category_id, category_publish, ordering, category_image 
  FROM `bm_jshopping_categories`

1 × SELECT * 
  FROM `bm_jshopping_config_display_prices

1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `bm_jshopping_currencies`

1 × SELECT * 
  FROM bm_jshopping_config

1 × 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

1 × SELECT element 
  FROM bm_extensions

1 × SELECT id, rules 
  FROM `bm_viewlevels

1 × SELECT tax_id, tax_name, tax_value 
  FROM `bm_jshopping_taxes

OTHER Tables:

2 × SHOW FULL COLUMNS 
  FROM `bm_jshopping_users

1 × UPDATE `bm_extensions` 
  SET `params` = '{\"mediaversion\":\"f852d890cc09fe97512f0e30b775e4bf\"}'

1 × SHOW FULL COLUMNS 
  FROM `bm_template_styles

1 × SHOW FULL COLUMNS 
  FROM `bm_extensions

1 × SHOW FULL COLUMNS 
  FROM `bm_updates

1 × UPDATE `bm_update_sites` 
  SET `enabled` = '1'

1 × UPDATE `bm_update_sites` 
  SET `enabled` = '0'

```
1 × UNLOCK TABLE
```

1 × UPDATE `bm_extensions` 
  SET `params` = '{\"lastrun\":1772593356}'

```
1 × LOCK TABLES `bm_extensions` WRIT
```

1 × SHOW FULL COLUMNS 
  FROM `bm_jshopping_products_reviews

1 × SHOW FULL COLUMNS 
  FROM `bm_jshopping_addons

1 × SHOW FULL COLUMNS 
  FROM `bm_jshopping_config

1 × SHOW FULL COLUMNS 
  FROM `bm_jshopping_taxes

1 × SHOW FULL COLUMNS 
  FROM `bm_jshopping_products_extra_fields

1 × SHOW FULL COLUMNS 
  FROM `bm_jshopping_vendors

1 × SHOW FULL COLUMNS 
  FROM `bm_jshopping_categories

1 × SHOW FULL COLUMNS 
  FROM `bm_jshopping_config_display_prices

1 × SHOW FULL COLUMNS 
  FROM `bm_jshopping_usergroups

1 × SHOW FULL COLUMNS 
  FROM `bm_jshopping_currencies

1 × UPDATE `bm_update_sites` 
  SET `last_check_timestamp` = '1772593356'

Sizin səbətiniz boşdur

Mobil telefonlar

Mallar və xidmətlər

Malların müqayisəsi

Hüquqi məlumat

İstifadəçi menyusu

Ziyarətçilər

GİRİŞ / QEYDİYYAT

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

59 Queries Logged 45.13 ms

8 duplicate found!

52 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Qonaq 2307
İstif. 0