{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1597416055,
                "last": 1597416055,
                "now": 1597416055
            },
            "token": "nNjIr70RcR86IPZIEGPt5oSoC4tzSEXM"
        },
        "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": "2",
        "js_id_currency": "2",
        "js_history_sel_lang": "ru-RU",
        "js_prev_user_id": 0,
        "jshop_checked_language": [
            "en-GB",
            "ru-RU"
        ],
        "jshop_end_page_buy_product": "\/shop\/%D1%82%D1%80%D0%BA-%D0%B8-%D0%B3%D1%80%D0%BA\/%D1%82%D1%80%D0%BA-gilbarco-sk700-ii-or-8-0-8-c-stp",
        "product_back_value": []
    }
}

Time

Memory

65 SQL-запросов зафиксировано 51.59 ms

1. Query Time: 0.22 ms Query memory: 0.004 MB Memory before query: 0.716 MB

   DELETE 
   
     FROM `nbg4p_session`
   
     WHERE `time` < '1597415155'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	nbg4p_session	range	time	time	59	const	1	100.00	Using where

   Profile

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.01 ms
   System lock	0.04 ms
   updating	0.03 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.02 ms
   freeing items	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:818
   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:412
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

2. Query Time: 0.31 ms After last query: 0.27 ms Query memory: 0.027 MB Memory before query: 0.726 MB Rows returned: 0

   SELECT `data`
   
     FROM `nbg4p_session`
   
     WHERE `session_id` = 'edcde8b0b979e835505057a89808fbae'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	nbg4p_session	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

   Profile

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   init	0.00 ms
   checking query cache for query	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   freeing items	0.07 ms
   Waiting for query cache lock	0.01 ms
   Waiting on query cache mutex	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.00 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
   10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
   9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
   8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
   7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
   6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:825
   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:412
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

3. Query Time: 0.28 ms After last query: 0.36 ms Query memory: 0.023 MB Memory before query: 0.745 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `nbg4p_session`
   
     WHERE `session_id` = 'edcde8b0b979e835505057a89808fbae' 
     LIMIT 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	nbg4p_session	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

   Profile

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   init	0.00 ms
   checking query cache for query	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   freeing items	0.07 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
   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:412
   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.]

   ---

4. Query Time: 0.26 ms After last query: 0.17 ms Query memory: 0.005 MB Memory before query: 0.751 MB

   INSERT INTO `nbg4p_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('edcde8b0b979e835505057a89808fbae', 1, '1597416055', 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `nbg4p_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('edcde8b0b979e835505057a89808fbae', 1, '1597416055', 0, '', 0)

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   update	0.07 ms
   Waiting for query cache lock	0.00 ms
   update	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.04 ms
   freeing items	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
   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:412
   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.]

   ---

5. Query Time: 0.16 ms After last query: 0.91 ms Query memory: 0.024 MB Memory before query: 0.916 MB Rows returned: 1

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where

   Profile

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   init	0.00 ms
   checking query cache for query	0.01 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.01 ms
   sending cached result to clien	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
   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:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

6. Query Time: 0.11 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 0.923 MB Rows returned: 7

   SELECT id, rules
   
     FROM `nbg4p_viewlevels`

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	nbg4p_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7	100.00	NULL

   Profile

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   init	0.00 ms
   checking query cache for query	0.00 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.00 ms
   sending cached result to clien	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
   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:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

7. Query Time: 2.14 ms After last query: 8.80 ms Query memory: 0.059 MB Memory before query: 2.625 MB Rows returned: 140

   SHOW FULL COLUMNS 
     FROM `nbg4p_jshopping_config`

   Explain

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

   Profile

   Status	Duration
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   Sending data	0.14 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   removing tmp table	0.13 ms
   closing tables	0.00 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
   18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
   17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
   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:1560
   11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:212
   10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
   9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
   8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
   7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
   6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
   5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

8. Query Time: 0.34 ms After last query: 0.65 ms Query memory: 0.083 MB Memory before query: 2.928 MB Rows returned: 1

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	nbg4p_jshopping_config	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

   Profile

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   init	0.00 ms
   checking query cache for query	0.01 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.01 ms
   sending cached result to clien	0.03 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
   16	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
   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:1560
   11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:212
   10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
   9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
   8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
   7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
   6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
   5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 0.63 ms After last query: 0.34 ms Query memory: 0.036 MB Memory before query: 2.948 MB Rows returned: 8

   SHOW FULL COLUMNS 
     FROM `nbg4p_jshopping_currencies`

   Explain

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

   Profile

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.18 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.01 ms
   Opening tables	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   Sending data	0.03 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   removing tmp table	0.09 ms
   closing tables	0.00 ms
   freeing items	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
   22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
   21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
   20	JTable->__construct()	JROOT/components/com_jshopping/tables/currency.php:14
   19	jshopCurrency->__construct()	JROOT/libraries/joomla/table/table.php:311
   18	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
   17	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:548
   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:1560
   11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:212
   10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
   9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
   8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
   7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
   6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
   5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

10. Query Time: 0.12 ms After last query: 0.17 ms Query memory: 0.031 MB Memory before query: 2.977 MB Rows returned: 3

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nbg4p_jshopping_currencies	ALL	currency_publish	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/currency.php:22
    17	jshopCurrency->getAllCurrencies()	JROOT/components/com_jshopping/lib/factory.php:549
    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:1560
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:212
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 1.05 ms After last query: 0.19 ms Query memory: 0.045 MB Memory before query: 2.998 MB Rows returned: 53
    Duplicate queries: #12

    SHOW FULL COLUMNS 
      FROM `nbg4p_jshopping_users`

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.18 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 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.03 ms
    checking permissions	0.02 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.11 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    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:299
    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:1560
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:212
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 0.98 ms After last query: 0.75 ms Query memory: 0.045 MB Memory before query: 3.191 MB Rows returned: 53
    Duplicate queries: #11

    SHOW FULL COLUMNS 
      FROM `nbg4p_jshopping_users`

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.17 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.06 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.10 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    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:299
    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:1560
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:212
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 0.63 ms After last query: 0.31 ms Query memory: 0.037 MB Memory before query: 3.305 MB Rows returned: 10

    SHOW FULL COLUMNS 
      FROM `nbg4p_jshopping_usergroups`

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.17 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	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
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    23	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    22	JTable->__construct()	JROOT/components/com_jshopping/tables/usergroup.php:14
    21	jshopUserGroup->__construct()	JROOT/libraries/joomla/table/table.php:311
    20	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    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:299
    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:1560
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:212
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

14. Query Time: 0.58 ms After last query: 0.30 ms Query memory: 0.035 MB Memory before query: 3.341 MB Rows returned: 4

    SHOW FULL COLUMNS 
      FROM `nbg4p_jshopping_config_display_prices`

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.19 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.01 ms
    Opening tables	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.08 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    20	JTable->__construct()	JROOT/components/com_jshopping/tables/configdisplayprice.php:14
    19	jshopConfigDisplayPrice->__construct()	JROOT/libraries/joomla/table/table.php:311
    18	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    17	JSFactory::getTable()	JROOT/components/com_jshopping/tables/config.php:82
    16	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:299
    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:1560
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:212
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 0.11 ms After last query: 0.15 ms Query memory: 0.030 MB Memory before query: 3.363 MB Rows returned: 1

    SELECT * 
      FROM `nbg4p_jshopping_config_display_prices`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nbg4p_jshopping_config_display_prices	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    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:299
    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:1560
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:212
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 0.16 ms After last query: 0.42 ms Query memory: 0.044 MB Memory before query: 3.378 MB Rows returned: 189

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nbg4p_jshopping_categories	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	189	100.00	Using where

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:242
    11	JSFactory::getAliasCategory()	JROOT/components/com_jshopping/router.php:289
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 4.19 ms After last query: 0.34 ms Query memory: 0.255 MB Memory before query: 3.414 MB Rows returned: 1796

    select product_id as id, `alias_ru-RU` as alias 
      from nbg4p_jshopping_products 
      where `alias_ru-RU`!=''

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nbg4p_jshopping_products	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1605	100.00	Using where

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    System lock	0.03 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.48 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.57 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.41 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	1.14 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.79 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.36 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:276
    11	JSFactory::getAliasProduct()	JROOT/components/com_jshopping/router.php:300
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 0.54 ms After last query: 2.81 ms Query memory: 0.011 MB Memory before query: 3.668 MB

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nbg4p_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	2	100.00	Using where

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.18 ms
    updating	0.07 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.02 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
    16	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
    15	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
    14	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    13	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    12	JFactory::getDocument()	JROOT/libraries/cms/html/behavior.php:352
    11	JHtmlBehavior::modal()	JROOT/libraries/cms/html/html.php:233
    10	JHtml::call()	JROOT/libraries/cms/html/html.php:140
    9	JHtml::_()	JROOT/plugins/system/k2/k2.php:41
    8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 2.40 ms After last query: 43.34 ms Query memory: 0.037 MB Memory before query: 4.255 MB Rows returned: 22

    SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM nbg4p_modules AS m
    
      LEFT JOIN nbg4p_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN nbg4p_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 <= '2020-08-14 14:40:55') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-08-14 14:40:55') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 965 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	50	100.00	Using index condition; Using where; Using filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	adminazst_sw.m.module,const	1	100.00	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	adminazst_sw.m.id	3	100.00	Using where; Using index

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.09 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.04 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	1.52 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Creating sort index	0.32 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.03 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:382
    16	JModuleHelper::_load()	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:104
    15	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
    14	JDocumentHtml->countModules()	JROOT/plugins/system/jat3/jat3/core/template.php:1213
    13	T3Template->countModules()	JROOT/plugins/system/jat3/jat3/core/template.php:710
    12	T3Template->hasBlock()	JROOT/plugins/system/jat3/jat3/core/template.php:1065
    11	T3Template->parseLayout()	JROOT/plugins/system/jat3/jat3/core/template.php:727
    10	T3Template->loadLayout()	JROOT/plugins/system/jat3/jat3/core/framework.php:153
    9	T3Framework::init_layout()	JROOT/plugins/system/jat3/jat3.php:276
    8	plgSystemJAT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 0.17 ms After last query: 3.15 ms Query memory: 0.026 MB Memory before query: 4.338 MB Rows returned: 2

    select * 
      from nbg4p_jshopping_languages

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nbg4p_jshopping_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	NULL

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    9	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/functions.php:290
    8	installNewLanguages()	JROOT/components/com_jshopping/loadparams.php:33
    7	require JROOT/components/com_jshopping/loadparams.php	JROOT/components/com_jshopping/jshopping.php:16
    6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 1.98 ms After last query: 1.18 ms Query memory: 0.050 MB Memory before query: 4.402 MB Rows returned: 91

    SHOW FULL COLUMNS 
      FROM `nbg4p_jshopping_products`

    Explain

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

    Profile

    Status	Duration
    Opening tables	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.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.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 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
    Sending data	0.11 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.45 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:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    12	JTable->__construct()	JROOT/components/com_jshopping/tables/product.php:15
    11	jshopProduct->__construct()	JROOT/libraries/joomla/table/table.php:311
    10	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    9	JSFactory::getTable()	JROOT/components/com_jshopping/controllers/product.php:43
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

22. Query Time: 0.53 ms After last query: 0.37 ms Query memory: 0.057 MB Memory before query: 4.582 MB Rows returned: 1
    Duplicate queries: #51

    SELECT *
    
      FROM nbg4p_jshopping_products
    
      WHERE `product_id` = '27'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nbg4p_jshopping_products	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    System lock	0.03 ms
    optimizing	0.01 ms
    statistics	0.10 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.11 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.05 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.11 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
    9	JTable->load()	JROOT/components/com_jshopping/controllers/product.php:44
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 0.87 ms After last query: 0.27 ms Query memory: 0.035 MB Memory before query: 4.600 MB Rows returned: 25

    SHOW FULL COLUMNS 
      FROM `nbg4p_jshopping_categories`

    Explain

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

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.18 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.01 ms
    Opening tables	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.15 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    12	JTable->__construct()	JROOT/components/com_jshopping/tables/category.php:15
    11	jshopCategory->__construct()	JROOT/libraries/joomla/table/table.php:311
    10	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    9	JSFactory::getTable()	JROOT/components/com_jshopping/controllers/product.php:46
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 0.34 ms After last query: 0.26 ms Query memory: 0.033 MB Memory before query: 4.658 MB Rows returned: 1

    SELECT *
    
      FROM nbg4p_jshopping_categories
    
      WHERE `category_id` = '5'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nbg4p_jshopping_categories	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
    9	JTable->load()	JROOT/components/com_jshopping/controllers/product.php:47
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

25. Query Time: 0.35 ms After last query: 0.16 ms Query memory: 0.026 MB Memory before query: 4.663 MB Rows returned: 3

    SELECT * 
      FROM `nbg4p_jshopping_products_to_categories` 
      WHERE product_id=27

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nbg4p_jshopping_products_to_categories	ref	PRIMARY,product_id,product_id_2	product_id_2	4	const	3	100.00	Using index

    Profile

    Status	Duration
    starting	0.00 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:260
    10	jshopProduct->getCategories()	JROOT/components/com_jshopping/models/productshop.php:79
    9	jshopProductShop->getCategories()	JROOT/components/com_jshopping/controllers/product.php:52
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

26. Query Time: 0.77 ms After last query: 0.22 ms Query memory: 0.035 MB Memory before query: 4.678 MB Rows returned: 11

    SHOW FULL COLUMNS 
      FROM `nbg4p_jshopping_attr`

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.17 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.20 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    17	JTable->__construct()	JROOT/components/com_jshopping/tables/attribut.php:14
    16	jshopAttribut->__construct()	JROOT/libraries/joomla/table/table.php:311
    15	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    14	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:290
    13	JSFactory::getAllAttributes()	JROOT/components/com_jshopping/tables/product.php:106
    12	jshopProduct->getRequireAttribute()	JROOT/components/com_jshopping/tables/product.php:185
    11	jshopProduct->getAttributesDatas()	JROOT/components/com_jshopping/tables/product.php:213
    10	jshopProduct->getInitLoadAttribute()	JROOT/components/com_jshopping/models/productshop.php:92
    9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:54
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

27. Query Time: 0.14 ms After last query: 0.17 ms Query memory: 0.035 MB Memory before query: 4.712 MB Rows returned: 22

    SELECT A.attr_id, A.`name_ru-RU` as name, A.`description_ru-RU` as description, A.attr_type, A.independent, A.allcats, A.cats, A.attr_ordering, G.`name_ru-RU` as groupname
                      
      FROM `nbg4p_jshopping_attr` as A 
      left join `nbg4p_jshopping_attr_groups` as G 
      on A.`
      group`=G.id
                      
      ORDER BY G.ordering, A.attr_ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	A	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	22	100.00	Using temporary; Using filesort
    1	SIMPLE	G	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	4	75.00	Using where; Using join buffer (Block Nested Loop)

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/attribut.php:28
    14	jshopAttribut->getAllAttributes()	JROOT/components/com_jshopping/lib/factory.php:291
    13	JSFactory::getAllAttributes()	JROOT/components/com_jshopping/tables/product.php:106
    12	jshopProduct->getRequireAttribute()	JROOT/components/com_jshopping/tables/product.php:185
    11	jshopProduct->getAttributesDatas()	JROOT/components/com_jshopping/tables/product.php:213
    10	jshopProduct->getInitLoadAttribute()	JROOT/components/com_jshopping/models/productshop.php:92
    9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:54
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

28. Query Time: 0.40 ms After last query: 0.19 ms Query memory: 0.039 MB Memory before query: 4.768 MB Rows returned: 0

    SELECT * 
      FROM `nbg4p_jshopping_products_attr` 
      WHERE product_id=27 
      ORDER BY product_attr_id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nbg4p_jshopping_products_attr	ref	product_id	product_id	4	const	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.02 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:137
    13	jshopProduct->getAttributes()	JROOT/components/com_jshopping/tables/product.php:111
    12	jshopProduct->getRequireAttribute()	JROOT/components/com_jshopping/tables/product.php:185
    11	jshopProduct->getAttributesDatas()	JROOT/components/com_jshopping/tables/product.php:213
    10	jshopProduct->getInitLoadAttribute()	JROOT/components/com_jshopping/models/productshop.php:92
    9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:54
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

29. Query Time: 0.48 ms After last query: 0.15 ms Query memory: 0.028 MB Memory before query: 4.778 MB Rows returned: 0

    SELECT * 
      FROM `nbg4p_jshopping_products_attr2` 
      WHERE product_id=27 
      ORDER BY id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nbg4p_jshopping_products_attr2	ref	product_id	product_id	4	const	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.16 ms
    init	0.00 ms
    checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    System lock	0.02 ms
    optimizing	0.00 ms
    statistics	0.03 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:146
    13	jshopProduct->getAttributes2()	JROOT/components/com_jshopping/tables/product.php:122
    12	jshopProduct->getRequireAttribute()	JROOT/components/com_jshopping/tables/product.php:185
    11	jshopProduct->getAttributesDatas()	JROOT/components/com_jshopping/tables/product.php:213
    10	jshopProduct->getInitLoadAttribute()	JROOT/components/com_jshopping/models/productshop.php:92
    9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:54
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

30. Query Time: 0.65 ms After last query: 0.27 ms Query memory: 0.036 MB Memory before query: 4.854 MB Rows returned: 11

    SHOW FULL COLUMNS 
      FROM `nbg4p_jshopping_products_extra_fields`

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.17 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.01 ms
    Opening tables	0.03 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.02 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.14 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    19	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    18	JTable->__construct()	JROOT/components/com_jshopping/tables/productfield.php:14
    17	jshopProductField->__construct()	JROOT/libraries/joomla/table/table.php:311
    16	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    15	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:475
    14	JSFactory::getAllProductExtraField()	JROOT/components/com_jshopping/lib/functions.php:1110
    13	getQueryListProductsExtraFields()	JROOT/components/com_jshopping/lib/jtableauto.php:214
    12	JTableAvto->getBuildQueryListProductSimpleList()	JROOT/components/com_jshopping/tables/product.php:810
    11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:503
    10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:101
    9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:54
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

31. Query Time: 0.14 ms After last query: 0.19 ms Query memory: 0.041 MB Memory before query: 4.888 MB Rows returned: 45

    SELECT F.id, F.`name_ru-RU` as name, F.`description_ru-RU` as description, F.allcats, F.type, F.cats, F.ordering, F.`
      group`, G.`name_ru-RU` as groupname, multilist 
      FROM `nbg4p_jshopping_products_extra_fields` as F 
      left join `nbg4p_jshopping_products_extra_field_groups` as G 
      on G.id=F.
      group 
      order by G.ordering, F.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	F	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	45	100.00	Using temporary; Using filesort
    1	SIMPLE	G	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	6	83.33	Using where; Using join buffer (Block Nested Loop)

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productfield.php:48
    15	jshopProductField->getList()	JROOT/components/com_jshopping/lib/factory.php:476
    14	JSFactory::getAllProductExtraField()	JROOT/components/com_jshopping/lib/functions.php:1110
    13	getQueryListProductsExtraFields()	JROOT/components/com_jshopping/lib/jtableauto.php:214
    12	JTableAvto->getBuildQueryListProductSimpleList()	JROOT/components/com_jshopping/tables/product.php:810
    11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:503
    10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:101
    9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:54
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

32. Query Time: 1.17 ms After last query: 0.26 ms Query memory: 0.033 MB Memory before query: 4.995 MB Rows returned: 0

    SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, 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.delivery_times_id, prod.`description_ru-RU` as full_description  
      FROM `nbg4p_jshopping_products_relations` AS relation
                    
      INNER JOIN `nbg4p_jshopping_products` AS prod 
      ON relation.product_related_id = prod.product_id
                    
      LEFT JOIN `nbg4p_jshopping_products_to_categories` AS pr_cat 
      ON pr_cat.product_id = relation.product_related_id
                    
      LEFT JOIN `nbg4p_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                    
                    
      WHERE relation.product_id=27 
      AND cat.category_publish=1 
      AND prod.product_publish=1  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
    				
      group by prod.product_id 
      order by relation.id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	relation	ref	product_id,product_id_2,product_related_id	product_id	4	const	1	100.00	Using where; Using index; Using temporary; Using filesort
    1	SIMPLE	prod	eq_ref	PRIMARY,product_manufacturer_id,parent_id,product_ean,unlimited,product_publish,product_tax_id,currency_id,product_price,min_price,add_price_unit_id,average_rating,reviews_count,delivery_times_id,hits,basic_price_unit_id,label_id,vendor_id,access	PRIMARY	4	adminazst_sw.relation.product_related_id	1	100.00	Using where
    1	SIMPLE	pr_cat	ref	PRIMARY,category_id,product_id,product_id_2	PRIMARY	4	adminazst_sw.relation.product_related_id	1	100.00	Using index
    1	SIMPLE	cat	eq_ref	PRIMARY,category_publish,access,category_publish_2	PRIMARY	4	adminazst_sw.pr_cat.category_id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.05 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.08 ms
    System lock	0.03 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.02 ms
    Creating tmp table	0.04 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.27 ms
    Creating sort index	0.04 ms
    end	0.01 ms
    removing tmp table	0.18 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.18 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:823
    11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:503
    10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:101
    9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:54
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

33. Query Time: 0.58 ms After last query: 0.27 ms Query memory: 0.035 MB Memory before query: 5.015 MB Rows returned: 3

    SHOW FULL COLUMNS 
      FROM `nbg4p_jshopping_taxes`

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.17 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.01 ms
    Opening tables	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.13 ms
    closing tables	0.01 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    17	JTable->__construct()	JROOT/components/com_jshopping/tables/tax.php:14
    16	jshopTax->__construct()	JROOT/libraries/joomla/table/table.php:311
    15	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    14	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:342
    13	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:654
    12	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:827
    11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:503
    10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:101
    9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:54
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

34. Query Time: 0.14 ms After last query: 0.20 ms Query memory: 0.030 MB Memory before query: 5.037 MB Rows returned: 3

    SELECT tax_id, tax_name, tax_value 
      FROM `nbg4p_jshopping_taxes`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nbg4p_jshopping_taxes	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	NULL

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/tax.php:21
    15	jshopTax->getAllTaxes()	JROOT/components/com_jshopping/lib/factory.php:328
    14	JSFactory::getAllTaxesOriginal()	JROOT/components/com_jshopping/lib/factory.php:343
    13	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:654
    12	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:827
    11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:503
    10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:101
    9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:54
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

35. Query Time: 0.16 ms After last query: 0.15 ms Query memory: 0.027 MB Memory before query: 5.047 MB Rows returned: 3

    select id, `name_ru-RU` as name 
      from nbg4p_jshopping_delivery_times

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nbg4p_jshopping_delivery_times	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	NULL

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.04 ms
    init	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:445
    13	JSFactory::getAllDeliveryTime()	JROOT/components/com_jshopping/lib/functions.php:662
    12	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:827
    11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:503
    10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:101
    9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:54
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

36. Query Time: 0.67 ms After last query: 0.27 ms Query memory: 0.033 MB Memory before query: 5.059 MB Rows returned: 10

    SHOW FULL COLUMNS 
      FROM `nbg4p_jshopping_products_reviews`

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.18 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.17 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:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    14	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    13	JTable->__construct()	JROOT/components/com_jshopping/tables/review.php:14
    12	jshopReview->__construct()	JROOT/libraries/joomla/table/table.php:311
    11	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    10	JSFactory::getTable()	JROOT/components/com_jshopping/models/productshop.php:114
    9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:54
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

37. Query Time: 0.12 ms After last query: 0.21 ms Query memory: 0.029 MB Memory before query: 5.089 MB Rows returned: 18

    select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url 
      from nbg4p_jshopping_manufacturers 
      where manufacturer_publish='1'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nbg4p_jshopping_manufacturers	ref	manufacturer_publish	manufacturer_publish	1	const	18	100.00	NULL

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.01 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:401
    11	JSFactory::getAllManufacturer()	JROOT/components/com_jshopping/tables/product.php:409
    10	jshopProduct->getManufacturerInfo()	JROOT/components/com_jshopping/models/productshop.php:130
    9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:54
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

38. Query Time: 0.60 ms After last query: 0.22 ms Query memory: 0.033 MB Memory before query: 5.114 MB Rows returned: 5

    SHOW FULL COLUMNS 
      FROM `nbg4p_jshopping_products_extra_field_values`

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.17 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.01 ms
    Opening tables	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.13 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    15	JTable->__construct()	JROOT/components/com_jshopping/tables/productfieldvalue.php:15
    14	jshopProductFieldValue->__construct()	JROOT/libraries/joomla/table/table.php:311
    13	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    12	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:484
    11	JSFactory::getAllProductExtraFieldValue()	JROOT/components/com_jshopping/tables/product.php:732
    10	jshopProduct->getExtraFields()	JROOT/components/com_jshopping/models/productshop.php:152
    9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:54
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

39. Query Time: 0.14 ms After last query: 0.15 ms Query memory: 0.031 MB Memory before query: 5.136 MB Rows returned: 37

    SELECT id, `name_ru-RU` as name, field_id 
      FROM `nbg4p_jshopping_products_extra_field_values` 
      order by ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nbg4p_jshopping_products_extra_field_values	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	37	100.00	Using filesort

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.01 ms
    init	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productfieldvalue.php:26
    12	jshopProductFieldValue->getAllList()	JROOT/components/com_jshopping/lib/factory.php:485
    11	JSFactory::getAllProductExtraFieldValue()	JROOT/components/com_jshopping/tables/product.php:732
    10	jshopProduct->getExtraFields()	JROOT/components/com_jshopping/models/productshop.php:152
    9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:54
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

40. Query Time: 0.66 ms After last query: 0.22 ms Query memory: 0.026 MB Memory before query: 5.149 MB Rows returned: 0

    SELECT FA.id, FA.required, FA.`name_ru-RU` as name, FA.`description_ru-RU` as description, FA.type 
    				  
      FROM `nbg4p_jshopping_products_free_attr` as PFA 
    				  
      left join `nbg4p_jshopping_free_attr` as FA 
      on FA.id=PFA.attr_id
                      
      WHERE PFA.product_id=27 
      order by FA.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	PFA	ref	product_id	product_id	4	const	1	100.00	Using temporary; Using filesort
    1	SIMPLE	FA	eq_ref	PRIMARY	PRIMARY	4	adminazst_sw.PFA.attr_id	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.01 ms
    init	0.00 ms
    checking query cache for query	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.02 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    System lock	0.03 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Creating tmp table	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.15 ms
    Creating sort index	0.02 ms
    end	0.00 ms
    removing tmp table	0.11 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.02 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:236
    10	jshopProduct->getListFreeAttributes()	JROOT/components/com_jshopping/models/productshop.php:158
    9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:54
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

41. Query Time: 0.13 ms After last query: 2.23 ms Query memory: 0.039 MB Memory before query: 5.437 MB Rows returned: 46

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `nbg4p_assets`
    
      WHERE `name` IN ('com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_downloadmanager','com_fields','com_finder','com_installer','com_jaextmanager','com_jcomments','com_joomlaupdate','com_jotcache','com_jshopping','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_phocagallery','com_phocaguestbook','com_plugins','com_postinstall','com_quickdownload','com_redirect','com_scriptmerge','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nbg4p_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	185	100.00	Using where

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
    22	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
    21	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
    20	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
    19	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    18	JUser->authorise()	JROOT/administrator/components/com_fields/models/fields.php:231
    17	FieldsModelFields->getListQuery()	JROOT/libraries/legacy/model/list.php:132
    16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:186
    15	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_jshopping/lib/functions.php:926
    10	changeDataUsePluginContent()	JROOT/components/com_jshopping/models/productshop.php:199
    9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:54
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

42. Query Time: 0.16 ms After last query: 0.41 ms Query memory: 0.040 MB Memory before query: 5.510 MB Rows returned: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM nbg4p_fields AS a
    
      LEFT JOIN `nbg4p_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN nbg4p_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN nbg4p_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN nbg4p_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN nbg4p_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_content.article' 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	func	1	100.00	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	adminazst_sw.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	adminazst_sw.a.access	1	100.00	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	adminazst_sw.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	adminazst_sw.a.group_id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    17	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    16	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
    15	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_jshopping/lib/functions.php:926
    10	changeDataUsePluginContent()	JROOT/components/com_jshopping/models/productshop.php:199
    9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:54
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

43. Query Time: 0.18 ms After last query: 0.76 ms Query memory: 0.029 MB Memory before query: 5.552 MB Rows returned: 23

    select id,link 
      from nbg4p_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)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nbg4p_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	163	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:130
    13	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:41
    12	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:35
    11	shopItemMenu::getInstance()	JROOT/components/com_jshopping/lib/functions.php:396
    10	getShopMainPageItemid()	JROOT/components/com_jshopping/helpers/metadata.php:200
    9	JshopHelpersMetadata::product()	JROOT/components/com_jshopping/controllers/product.php:65
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

44. Query Time: 0.52 ms After last query: 0.67 ms Query memory: 0.007 MB Memory before query: 5.596 MB

    UPDATE nbg4p_jshopping_products
    
      SET `hits` = (`hits` + 1)
    
      WHERE `product_id` = '27'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nbg4p_jshopping_products	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.05 ms
    updating	0.17 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.06 ms
    query end	0.05 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
    9	JTable->hit()	JROOT/components/com_jshopping/controllers/product.php:67
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

45. Query Time: 0.52 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 5.601 MB Rows returned: 1

    SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
      FROM `nbg4p_jshopping_products_images` as I 
    				 
      left join `nbg4p_jshopping_products` as P 
      on P.product_id=I.product_id
                     
      WHERE I.product_id=27 
      ORDER BY sort, I.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	I	ref	product_id	product_id	4	const	1	100.00	Using temporary; Using filesort
    1	SIMPLE	P	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.01 ms
    System lock	0.03 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    Creating tmp table	0.03 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.07 ms
    Creating sort index	0.03 ms
    end	0.00 ms
    removing tmp table	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    10	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:341
    9	jshopProduct->getImages()	JROOT/components/com_jshopping/controllers/product.php:77
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

46. Query Time: 0.33 ms After last query: 0.16 ms Query memory: 0.026 MB Memory before query: 5.610 MB Rows returned: 0

    SELECT  video_name, video_id, video_preview, video_code 
      FROM `nbg4p_jshopping_products_videos` 
      WHERE product_id=27

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nbg4p_jshopping_products_videos	ref	product_id	product_id	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.00 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.05 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.04 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    10	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:361
    9	jshopProduct->getVideos()	JROOT/components/com_jshopping/controllers/product.php:78
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

47. Query Time: 0.58 ms After last query: 0.18 ms Query memory: 0.027 MB Memory before query: 5.617 MB Rows returned: 2

    SELECT * 
      FROM `nbg4p_jshopping_products_files` 
      WHERE product_id=27 
      and demo!='' 
      order by `ordering`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nbg4p_jshopping_products_files	ref	product_id	product_id	4	const	2	100.00	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.10 ms
    init	0.00 ms
    checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.14 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.09 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    10	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:389
    9	jshopProduct->getDemoFiles()	JROOT/components/com_jshopping/controllers/product.php:79
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

48. Query Time: 0.44 ms After last query: 0.35 ms Query memory: 0.027 MB Memory before query: 5.635 MB Rows returned: 3

    SELECT pr_cat.category_id 
      FROM `nbg4p_jshopping_products_to_categories` AS pr_cat
                    
      LEFT JOIN `nbg4p_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                    
      WHERE pr_cat.product_id=27 
      AND cat.category_publish=1  
      AND cat.access IN (1,1)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	pr_cat	ref	PRIMARY,category_id,product_id,product_id_2	product_id	4	const	3	100.00	Using index
    1	SIMPLE	cat	eq_ref	PRIMARY,category_publish,access,category_publish_2	PRIMARY	4	adminazst_sw.pr_cat.category_id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.09 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.00 ms
    storing result in query cache	0.07 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    13	JDatabaseDriver->loadResult()	JROOT/components/com_jshopping/tables/product.php:437
    12	jshopProduct->getCategory()	JROOT/plugins/jshoppingproducts/product_canonical/product_canonical.php:11
    11	plgJshoppingProductsProduct_canonical->onBeforeDisplayProduct()	JROOT/libraries/joomla/event/event.php:70
    10	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    9	JEventDispatcher->trigger()	JROOT/components/com_jshopping/controllers/product.php:85
    8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
    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:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

49. Query Time: 0.29 ms After last query: 0.52 ms Query memory: 0.025 MB Memory before query: 5.715 MB Rows returned: 1