Our Products

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1778411689,
                "last": 1778411689,
                "now": 1778411689
            },
            "client": {
                "forwarded": "18.97.14.88"
            },
            "token": "SpsSiCpYZgAzstKkliteA8NEzRo5Bt1R"
        },
        "registry": {
            "limit": "20",
            "sort_options": "a.ordering-ASC",
            "from_view": "category"
        },
        "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
        },
        "continue_shopping_url": "https://evgun.com/products"
    }
}

Time

Memory

445 Queries Logged 85.27 ms

1. Query Time: 0.19 ms Query memory: 0.023 MB Memory before query: 1.028 MB Rows returned: 0

   SELECT `data`
   
     FROM `fywef_session`
   
     WHERE `session_id` = X'3362353134323762373336343066636230653866353063306330366366343733'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	fywef_session	const	PRIMARY	PRIMARY	194	const	1

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   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:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::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.09 ms After last query: 0.29 ms Query memory: 0.020 MB Memory before query: 1.043 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `fywef_session`
   
     WHERE `session_id` = X'3362353134323762373336343066636230653866353063306330366366343733' 
     LIMIT 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	fywef_session	const	PRIMARY	PRIMARY	194	const	1	Using index

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Query Time: 2.54 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 1.048 MB

   INSERT INTO `fywef_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3362353134323762373336343066636230653866353063306330366366343733', 1, 1778411689, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `fywef_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3362353134323762373336343066636230653866353063306330366366343733', 1, 1778411689, 0, '', 0)

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::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.49 ms After last query: 0.47 ms Query memory: 0.040 MB Memory before query: 1.079 MB Rows returned: 47

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `fywef_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	fywef_extensions	ref	extension	extension	82	const	47	Using index condition; Using where

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

5. Query Time: 0.16 ms After last query: 0.66 ms Query memory: 0.021 MB Memory before query: 1.133 MB Rows returned: 5

   SELECT id, rules
   
     FROM `fywef_viewlevels`

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->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.20 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 1.145 MB Rows returned: 2

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

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Query Time: 0.64 ms After last query: 0.15 ms Query memory: 0.035 MB Memory before query: 1.166 MB Rows returned: 130

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	fywef_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	402	Using where; Using filesort

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->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.22 ms After last query: 3.65 ms Query memory: 0.022 MB Memory before query: 1.603 MB Rows returned: 1

   SELECT `value`
   
     FROM `fywef_admintools_storage`
   
     WHERE `key` = 'cparams'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	fywef_admintools_storage	const	PRIMARY	PRIMARY	402	const	1

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:122
   12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
   11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:49
   10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:409
   9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:892
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
   7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->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.14 ms After last query: 0.36 ms Query memory: 0.021 MB Memory before query: 1.634 MB Rows returned: 0

   SELECT *
   
     FROM `fywef_admintools_wafexceptions`
   
     WHERE NOT(`option` LIKE 'com_%')

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:729
   10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:640
   9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:901
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
   7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->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.24 ms After last query: 9.11 ms Query memory: 0.021 MB Memory before query: 2.417 MB Rows returned: 0

    SELECT *
    
      FROM `fywef_admintools_ipautoban`
    
      WHERE `ip` = '18.97.14.88'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:74
    11	AtsystemFeatureAutoipfiltering->isIPBlocked()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:23
    10	AtsystemFeatureAutoipfiltering->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
    8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 0.15 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 2.422 MB Rows returned: 77

    SELECT `ip`
    
      FROM `fywef_admintools_ipblock`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/plugins/system/admintools/feature/ipblacklist.php:143
    11	AtsystemFeatureIpblacklist->isIPBlocked()	JROOT/plugins/system/admintools/feature/ipblacklist.php:37
    10	AtsystemFeatureIpblacklist->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
    8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.13 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 2.429 MB Rows returned: 1

    SELECT *
    
      FROM `fywef_admintools_storage`
    
      WHERE `key` LIKE 'timestamp_%'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_admintools_storage	range	PRIMARY	PRIMARY	402	NULL	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    13	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/feature/abstract.php:277
    12	AtsystemFeatureAbstract->loadTimestamps()	JROOT/plugins/system/admintools/feature/abstract.php:356
    11	AtsystemFeatureAbstract->getTimestamp()	JROOT/plugins/system/admintools/feature/disableobsoleteadmins.php:115
    10	AtsystemFeatureDisableobsoleteadmins->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
    8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.16 ms After last query: 0.33 ms Query memory: 0.021 MB Memory before query: 2.438 MB Rows returned: 0

    SELECT `source`,`keepurlparams`
    
      FROM `fywef_admintools_redirects`
    
      WHERE ((`dest` = 'products') OR (`dest` = 'products') OR ('products' LIKE `dest`)) 
      AND `published` = '1'
    
      ORDER BY `ordering` DESC 
      LIMIT 1

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
    11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:91
    10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
    8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.15 ms After last query: 2.47 ms Query memory: 0.023 MB Memory before query: 2.592 MB Rows returned: 27

    SELECT *
    
      FROM fywef_rsform_config

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
    11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
    10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:102
    9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28
    8	plgSystemRsformdeletesubmissions->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.62 ms After last query: 0.94 ms Query memory: 0.087 MB Memory before query: 2.709 MB Rows returned: 43

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	49	Using index condition; Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	evgun_db.m.component_id	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
    13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
    11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
    10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
    8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
    6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.32 ms After last query: 2.63 ms Query memory: 0.021 MB Memory before query: 3.058 MB Rows returned: 1

    SELECT *
    
      FROM `fywef_admintools_wafblacklists`
    
      WHERE `verb` IN('','GET') 
      AND `option` IN('','com_eshop') 
      AND `view` IN('','category') 
      AND `task` IN('','category.') 
      AND `enabled` = '1'
    
      GROUP BY `query`
    
      ORDER BY `query` ASC

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/admintools/feature/wafblacklist.php:92
    10	AtsystemFeatureWafblacklist->onAfterRoute()	JROOT/plugins/system/admintools/admintools/main.php:308
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:154
    8	plgSystemAdmintools->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 0.29 ms After last query: 0.27 ms Query memory: 0.022 MB Memory before query: 3.067 MB Rows returned: 4

    SELECT id, home, template, s.params
    
      FROM fywef_template_styles as s
    
      LEFT JOIN fywef_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	evgun_db.s.template,const	1	Using index condition; Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:353
    9	T3::detect()	JROOT/plugins/system/t3/t3.php:87
    8	plgSystemT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.15 ms After last query: 1.15 ms Query memory: 0.024 MB Memory before query: 3.188 MB Rows returned: 8

    SELECT * 
      FROM fywef_rokcandy 
      WHERE published=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_rokcandy	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27
    13	RokCandyHelper::getUserMacros()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    10	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17
    9	RokCandyHelper::getMacros()	JROOT/plugins/system/rokcandy/rokcandy.php:28
    8	plgSystemRokCandy->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 0.15 ms After last query: 0.18 ms Query memory: 0.024 MB Memory before query: 3.200 MB Rows returned: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `fywef_extensions`
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
    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/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 1.73 ms After last query: 0.10 ms Query memory: 0.006 MB Memory before query: 3.192 MB

    UPDATE `fywef_extensions`
    
      SET `params` = '{\"mediaversion\":\"22deb612ba27c020fdab432aef234683\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    EXPLAIN not possible on query: UPDATE `fywef_extensions` SET `params` = '{\"mediaversion\":\"22deb612ba27c020fdab432aef234683\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
    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/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 0.20 ms After last query: 0.98 ms Query memory: 0.022 MB Memory before query: 3.251 MB Rows returned: 1

    SELECT *
    
      FROM fywef_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    12	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    11	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:254
    10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:244
    9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:390
    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/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.44 ms After last query: 11.02 ms Query memory: 0.041 MB Memory before query: 3.567 MB Rows returned: 268

    SELECT config_key, config_value
    
      FROM fywef_eshop_configs

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    10	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:32
    9	EshopHelper::getConfig()	JROOT/components/com_eshop/helpers/helper.php:134
    8	EshopHelper::getConfigValue()	JROOT/administrator/components/com_eshop/libraries/rad/bootstrap.php:8
    7	require_once JROOT/administrator/components/com_eshop/libraries/rad/bootstrap.php	JROOT/components/com_eshop/eshop.php:27
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 1.50 ms After last query: 5.02 ms Query memory: 0.029 MB Memory before query: 3.967 MB Rows returned: 22

    SHOW FULL COLUMNS 
      FROM `fywef_eshop_productdetails`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_eshop/libraries/rad/model/list.php:110
    14	RADModelList->__construct()	JROOT/components/com_eshop/models/products.php:35
    13	EshopModelProducts->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
    11	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
    10	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
    9	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 1.01 ms After last query: 0.26 ms Query memory: 0.023 MB Memory before query: 4.000 MB Rows returned: 1

    SELECT a.*, b.category_name, b.category_alias, b.category_desc, b.category_page_title, b.category_page_heading, b.category_alt_image, b.meta_key, b.meta_desc
    
      FROM fywef_eshop_categories AS a
    
      INNER JOIN fywef_eshop_categorydetails AS b 
      ON a.id = b.category_id
    
      WHERE a.id = 4 
      AND a.published = 1 
      AND b.language = "en-GB"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY,published	PRIMARY	4	const	1
    1	SIMPLE	b	ref	category_id	category_id	5	const	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:262
    14	EshopHelper::getCategory()	JROOT/components/com_eshop/models/products.php:44
    13	EshopModelProducts->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
    11	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
    10	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
    9	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.10 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 4.010 MB Rows returned: 1

    SELECT params
    
      FROM fywef_eshop_categories
    
      WHERE id = 4

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_categories	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:6742
    14	EshopHelper::getDefaultSortingCategory()	JROOT/components/com_eshop/models/products.php:92
    13	EshopModelProducts->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
    11	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
    10	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
    9	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.21 ms After last query: 0.23 ms Query memory: 0.022 MB Memory before query: 4.033 MB Rows returned: 1

    SELECT a.*, b.category_name, b.category_alias, b.category_desc, b.category_page_title, b.category_page_heading, b.category_alt_image, b.meta_key, b.meta_desc
    
      FROM fywef_eshop_categories AS a
    
      INNER JOIN fywef_eshop_categorydetails AS b 
      ON a.id = b.category_id
    
      WHERE a.id = 4 
      AND a.published = 1 
      AND b.language = "en-GB" 
      AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY,published	PRIMARY	4	const	1
    1	SIMPLE	b	ref	category_id	category_id	5	const	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    11	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:262
    10	EshopHelper::getCategory()	JROOT/components/com_eshop/views/category/view.html.php:29
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.17 ms After last query: 0.32 ms Query memory: 0.022 MB Memory before query: 4.042 MB Rows returned: 7

    SELECT a.id, a.category_parent_id, b.category_name
    
      FROM fywef_eshop_categories AS a
    
      INNER JOIN fywef_eshop_categorydetails AS b 
      ON (a.id = b.category_id)
    
      WHERE a.published = 1 
      AND b.language = 'en-GB'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b	ALL	category_id	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where
    1	SIMPLE	a	eq_ref	PRIMARY,published	PRIMARY	4	evgun_db.b.category_id	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:4932
    10	EshopHelper::getCategoriesBreadcrumb()	JROOT/components/com_eshop/views/category/view.html.php:57
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.11 ms After last query: 0.04 ms Query memory: 0.005 MB Memory before query: 4.047 MB

    UPDATE fywef_eshop_categories
    
      SET hits = hits + 1
    
      WHERE id = 4

    Explain

    EXPLAIN not possible on query: UPDATE fywef_eshop_categories SET hits = hits + 1 WHERE id = 4

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/components/com_eshop/helpers/helper.php:606
    10	EshopHelper::updateHits()	JROOT/components/com_eshop/views/category/view.html.php:70
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.23 ms After last query: 0.24 ms Query memory: 0.023 MB Memory before query: 4.059 MB Rows returned: 6
    Duplicate queries: #107

    SELECT a.id, a.category_parent_id, a.category_image, b.category_name, b.category_desc
    
      FROM fywef_eshop_categories AS a
    
      INNER JOIN fywef_eshop_categorydetails AS b 
      ON (a.id = b.category_id)
    
      WHERE a.category_parent_id = 4 
      AND a.published = 1 
      AND b.language = 'en-GB' 
      AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))
    
      ORDER BY b.category_name ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b	ALL	category_id	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where; Using filesort
    1	SIMPLE	a	eq_ref	PRIMARY,category_parent_id,published	PRIMARY	4	evgun_db.b.category_id	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1008
    14	EshopHelper::getCategories()	JROOT/components/com_eshop/helpers/helper.php:1023
    13	EshopHelper::getAllChildCategories()	JROOT/components/com_eshop/models/category.php:28
    12	EShopModelCategory->_buildQueryWhere()	JROOT/administrator/components/com_eshop/libraries/rad/model/list.php:148
    11	RADModelList->getData()	JROOT/components/com_eshop/models/products.php:116
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.37 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 4.072 MB Rows returned: 0
    Duplicate queries: #108

    SELECT a.id, a.category_parent_id, a.category_image, b.category_name, b.category_desc
    
      FROM fywef_eshop_categories AS a
    
      INNER JOIN fywef_eshop_categorydetails AS b 
      ON (a.id = b.category_id)
    
      WHERE a.category_parent_id = 7 
      AND a.published = 1 
      AND b.language = 'en-GB' 
      AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))
    
      ORDER BY b.category_name ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	PRIMARY,category_parent_id,published	category_parent_id	5	const	1	Using where; Using temporary; Using filesort
    1	SIMPLE	b	ref	category_id	category_id	5	evgun_db.a.id	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1008
    15	EshopHelper::getCategories()	JROOT/components/com_eshop/helpers/helper.php:1023
    14	EshopHelper::getAllChildCategories()	JROOT/components/com_eshop/helpers/helper.php:1028
    13	EshopHelper::getAllChildCategories()	JROOT/components/com_eshop/models/category.php:28
    12	EShopModelCategory->_buildQueryWhere()	JROOT/administrator/components/com_eshop/libraries/rad/model/list.php:148
    11	RADModelList->getData()	JROOT/components/com_eshop/models/products.php:116
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.33 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 4.080 MB Rows returned: 0
    Duplicate queries: #109

    SELECT a.id, a.category_parent_id, a.category_image, b.category_name, b.category_desc
    
      FROM fywef_eshop_categories AS a
    
      INNER JOIN fywef_eshop_categorydetails AS b 
      ON (a.id = b.category_id)
    
      WHERE a.category_parent_id = 3 
      AND a.published = 1 
      AND b.language = 'en-GB' 
      AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))
    
      ORDER BY b.category_name ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	PRIMARY,category_parent_id,published	category_parent_id	5	const	1	Using where; Using temporary; Using filesort
    1	SIMPLE	b	ref	category_id	category_id	5	evgun_db.a.id	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1008
    15	EshopHelper::getCategories()	JROOT/components/com_eshop/helpers/helper.php:1023
    14	EshopHelper::getAllChildCategories()	JROOT/components/com_eshop/helpers/helper.php:1028
    13	EshopHelper::getAllChildCategories()	JROOT/components/com_eshop/models/category.php:28
    12	EShopModelCategory->_buildQueryWhere()	JROOT/administrator/components/com_eshop/libraries/rad/model/list.php:148
    11	RADModelList->getData()	JROOT/components/com_eshop/models/products.php:116
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Query Time: 0.35 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 4.089 MB Rows returned: 0
    Duplicate queries: #110

    SELECT a.id, a.category_parent_id, a.category_image, b.category_name, b.category_desc
    
      FROM fywef_eshop_categories AS a
    
      INNER JOIN fywef_eshop_categorydetails AS b 
      ON (a.id = b.category_id)
    
      WHERE a.category_parent_id = 6 
      AND a.published = 1 
      AND b.language = 'en-GB' 
      AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))
    
      ORDER BY b.category_name ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	PRIMARY,category_parent_id,published	category_parent_id	5	const	1	Using where; Using temporary; Using filesort
    1	SIMPLE	b	ref	category_id	category_id	5	evgun_db.a.id	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1008
    15	EshopHelper::getCategories()	JROOT/components/com_eshop/helpers/helper.php:1023
    14	EshopHelper::getAllChildCategories()	JROOT/components/com_eshop/helpers/helper.php:1028
    13	EshopHelper::getAllChildCategories()	JROOT/components/com_eshop/models/category.php:28
    12	EShopModelCategory->_buildQueryWhere()	JROOT/administrator/components/com_eshop/libraries/rad/model/list.php:148
    11	RADModelList->getData()	JROOT/components/com_eshop/models/products.php:116
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.43 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 4.104 MB Rows returned: 0
    Duplicate queries: #111

    SELECT a.id, a.category_parent_id, a.category_image, b.category_name, b.category_desc
    
      FROM fywef_eshop_categories AS a
    
      INNER JOIN fywef_eshop_categorydetails AS b 
      ON (a.id = b.category_id)
    
      WHERE a.category_parent_id = 2 
      AND a.published = 1 
      AND b.language = 'en-GB' 
      AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))
    
      ORDER BY b.category_name ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	PRIMARY,category_parent_id,published	category_parent_id	5	const	1	Using where; Using temporary; Using filesort
    1	SIMPLE	b	ref	category_id	category_id	5	evgun_db.a.id	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1008
    15	EshopHelper::getCategories()	JROOT/components/com_eshop/helpers/helper.php:1023
    14	EshopHelper::getAllChildCategories()	JROOT/components/com_eshop/helpers/helper.php:1028
    13	EshopHelper::getAllChildCategories()	JROOT/components/com_eshop/models/category.php:28
    12	EShopModelCategory->_buildQueryWhere()	JROOT/administrator/components/com_eshop/libraries/rad/model/list.php:148
    11	RADModelList->getData()	JROOT/components/com_eshop/models/products.php:116
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.31 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 4.114 MB Rows returned: 0
    Duplicate queries: #112

    SELECT a.id, a.category_parent_id, a.category_image, b.category_name, b.category_desc
    
      FROM fywef_eshop_categories AS a
    
      INNER JOIN fywef_eshop_categorydetails AS b 
      ON (a.id = b.category_id)
    
      WHERE a.category_parent_id = 1 
      AND a.published = 1 
      AND b.language = 'en-GB' 
      AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))
    
      ORDER BY b.category_name ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	PRIMARY,category_parent_id,published	category_parent_id	5	const	1	Using where; Using temporary; Using filesort
    1	SIMPLE	b	ref	category_id	category_id	5	evgun_db.a.id	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1008
    15	EshopHelper::getCategories()	JROOT/components/com_eshop/helpers/helper.php:1023
    14	EshopHelper::getAllChildCategories()	JROOT/components/com_eshop/helpers/helper.php:1028
    13	EshopHelper::getAllChildCategories()	JROOT/components/com_eshop/models/category.php:28
    12	EShopModelCategory->_buildQueryWhere()	JROOT/administrator/components/com_eshop/libraries/rad/model/list.php:148
    11	RADModelList->getData()	JROOT/components/com_eshop/models/products.php:116
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.42 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 4.123 MB Rows returned: 0
    Duplicate queries: #113

    SELECT a.id, a.category_parent_id, a.category_image, b.category_name, b.category_desc
    
      FROM fywef_eshop_categories AS a
    
      INNER JOIN fywef_eshop_categorydetails AS b 
      ON (a.id = b.category_id)
    
      WHERE a.category_parent_id = 5 
      AND a.published = 1 
      AND b.language = 'en-GB' 
      AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))
    
      ORDER BY b.category_name ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	PRIMARY,category_parent_id,published	category_parent_id	5	const	1	Using where; Using temporary; Using filesort
    1	SIMPLE	b	ref	category_id	category_id	5	evgun_db.a.id	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1008
    15	EshopHelper::getCategories()	JROOT/components/com_eshop/helpers/helper.php:1023
    14	EshopHelper::getAllChildCategories()	JROOT/components/com_eshop/helpers/helper.php:1028
    13	EshopHelper::getAllChildCategories()	JROOT/components/com_eshop/models/category.php:28
    12	EShopModelCategory->_buildQueryWhere()	JROOT/administrator/components/com_eshop/libraries/rad/model/list.php:148
    11	RADModelList->getData()	JROOT/components/com_eshop/models/products.php:116
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Query Time: 2.57 ms After last query: 0.05 ms Query memory: 0.070 MB Memory before query: 4.124 MB Rows returned: 17

    SELECT a.*,b.product_name,b.product_alias,b.product_desc,b.product_short_desc,b.product_page_title,b.product_page_heading,b.product_alt_image,b.meta_key,b.meta_desc
    
      FROM fywef_eshop_products AS a
    
      INNER JOIN fywef_eshop_productdetails AS b 
      ON a.id = b.product_id
    
      WHERE a.published = 1 
      AND b.language='en-GB' 
      AND ((a.product_customergroups = "") OR (a.product_customergroups IS NULL) OR (a.product_customergroups = "1") OR (a.product_customergroups LIKE "1,%") OR (a.product_customergroups LIKE "%,1,%") OR (a.product_customergroups LIKE "%,1")) 
      AND (a.product_available_date = "0000-00-00 00:00:00" OR a.product_available_date <= '2026-05-10 11:14:49') 
      AND (a.product_end_date = "0000-00-00 00:00:00" OR a.product_end_date >= '2026-05-10 11:14:49') 
      AND ((a.product_languages = "") OR (a.product_languages IS NULL) OR (a.product_languages = "en-GB") OR (a.product_languages LIKE "en-GB,%") OR (a.product_languages LIKE "%,en-GB,%") OR (a.product_languages LIKE "%,en-GB")) 
      AND a.id IN (
    SELECT pc.product_id 
      FROM fywef_eshop_productcategories AS pc 
      WHERE pc.category_id IN (4,7,3,6,2,1,5))
    
      ORDER BY a.ordering ASC,a.ordering 
      LIMIT 20

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	ref	PRIMARY,published	published	2	const	17	Using where; Using filesort
    1	PRIMARY	<subquery2>	eq_ref	distinct_key	distinct_key	4	func	1
    1	PRIMARY	b	ref	product_id	product_id	5	evgun_db.a.id	1	Using where
    2	MATERIALIZED	pc	range	product_id,category_id	category_id	5	NULL	91	Using index condition; Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_eshop/libraries/rad/model/list.php:153
    11	RADModelList->getData()	JROOT/components/com_eshop/models/products.php:116
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.53 ms After last query: 0.26 ms Query memory: 0.022 MB Memory before query: 4.211 MB Rows returned: 1

    SELECT pi.*
    
      FROM fywef_eshop_productimages AS pi
    
      WHERE product_id = 2
    
      ORDER BY pi.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pi	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	151	Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1565
    11	EshopHelper::getProductImages()	JROOT/components/com_eshop/models/products.php:167
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.54 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 4.219 MB Rows returned: 0

    SELECT DISTINCT(label_id)
    
      FROM fywef_eshop_labelelements
    
      WHERE (element_type = "product" 
      AND element_id = 2) OR (element_type = "manufacturer" 
      AND element_id = (SELECT manufacturer_id 
      FROM fywef_eshop_products 
      WHERE id = 2)) OR (element_type = "category" 
      AND element_id IN (SELECT category_id 
      FROM fywef_eshop_productcategories 
      WHERE product_id = 2))

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    3	DEPENDENT SUBQUERY	fywef_eshop_productcategories	ref	product_id,category_id	product_id	5	const	2	Using where
    2	SUBQUERY	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_eshop/helpers/helper.php:5146
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.09 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 4.225 MB Rows returned: 1

    SELECT product_quantity
    
      FROM fywef_eshop_products
    
      WHERE id = 2

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:5154
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.10 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 4.231 MB Rows returned: 1
    Duplicate queries: #136  #137

    SELECT product_manage_stock, product_stock_display, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id
    
      FROM fywef_eshop_products
    
      WHERE id = 2

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:2459
    11	EshopHelper::getProductInventory()	JROOT/components/com_eshop/models/products.php:201
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.15 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 4.238 MB Rows returned: 1

    SELECT pi.*
    
      FROM fywef_eshop_productimages AS pi
    
      WHERE product_id = 6
    
      ORDER BY pi.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pi	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	151	Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1565
    11	EshopHelper::getProductImages()	JROOT/components/com_eshop/models/products.php:167
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.20 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 4.245 MB Rows returned: 0

    SELECT DISTINCT(label_id)
    
      FROM fywef_eshop_labelelements
    
      WHERE (element_type = "product" 
      AND element_id = 6) OR (element_type = "manufacturer" 
      AND element_id = (SELECT manufacturer_id 
      FROM fywef_eshop_products 
      WHERE id = 6)) OR (element_type = "category" 
      AND element_id IN (SELECT category_id 
      FROM fywef_eshop_productcategories 
      WHERE product_id = 6))

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    3	DEPENDENT SUBQUERY	fywef_eshop_productcategories	ref	product_id,category_id	product_id	5	const	2	Using where
    2	SUBQUERY	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_eshop/helpers/helper.php:5146
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.09 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 4.250 MB Rows returned: 1

    SELECT product_quantity
    
      FROM fywef_eshop_products
    
      WHERE id = 6

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:5154
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.09 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 4.257 MB Rows returned: 1
    Duplicate queries: #150  #151

    SELECT product_manage_stock, product_stock_display, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id
    
      FROM fywef_eshop_products
    
      WHERE id = 6

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:2459
    11	EshopHelper::getProductInventory()	JROOT/components/com_eshop/models/products.php:201
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.12 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 4.263 MB Rows returned: 0

    SELECT pi.*
    
      FROM fywef_eshop_productimages AS pi
    
      WHERE product_id = 7
    
      ORDER BY pi.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pi	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	151	Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1565
    11	EshopHelper::getProductImages()	JROOT/components/com_eshop/models/products.php:167
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.18 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 4.268 MB Rows returned: 0

    SELECT DISTINCT(label_id)
    
      FROM fywef_eshop_labelelements
    
      WHERE (element_type = "product" 
      AND element_id = 7) OR (element_type = "manufacturer" 
      AND element_id = (SELECT manufacturer_id 
      FROM fywef_eshop_products 
      WHERE id = 7)) OR (element_type = "category" 
      AND element_id IN (SELECT category_id 
      FROM fywef_eshop_productcategories 
      WHERE product_id = 7))

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    3	DEPENDENT SUBQUERY	fywef_eshop_productcategories	ref	product_id,category_id	product_id	5	const	2	Using where
    2	SUBQUERY	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_eshop/helpers/helper.php:5146
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.08 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.274 MB Rows returned: 1

    SELECT product_quantity
    
      FROM fywef_eshop_products
    
      WHERE id = 7

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:5154
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.08 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.280 MB Rows returned: 1
    Duplicate queries: #167  #168

    SELECT product_manage_stock, product_stock_display, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id
    
      FROM fywef_eshop_products
    
      WHERE id = 7

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:2459
    11	EshopHelper::getProductInventory()	JROOT/components/com_eshop/models/products.php:201
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->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.11 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 4.287 MB Rows returned: 0

    SELECT pi.*
    
      FROM fywef_eshop_productimages AS pi
    
      WHERE product_id = 8
    
      ORDER BY pi.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pi	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	151	Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1565
    11	EshopHelper::getProductImages()	JROOT/components/com_eshop/models/products.php:167
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

50. Query Time: 0.16 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 4.293 MB Rows returned: 0

    SELECT DISTINCT(label_id)
    
      FROM fywef_eshop_labelelements
    
      WHERE (element_type = "product" 
      AND element_id = 8) OR (element_type = "manufacturer" 
      AND element_id = (SELECT manufacturer_id 
      FROM fywef_eshop_products 
      WHERE id = 8)) OR (element_type = "category" 
      AND element_id IN (SELECT category_id 
      FROM fywef_eshop_productcategories 
      WHERE product_id = 8))

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    3	DEPENDENT SUBQUERY	fywef_eshop_productcategories	ref	product_id,category_id	product_id	5	const	2	Using where
    2	SUBQUERY	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_eshop/helpers/helper.php:5146
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

51. Query Time: 0.08 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.299 MB Rows returned: 1

    SELECT product_quantity
    
      FROM fywef_eshop_products
    
      WHERE id = 8

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:5154
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

52. Query Time: 0.08 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.305 MB Rows returned: 1
    Duplicate queries: #184  #185

    SELECT product_manage_stock, product_stock_display, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id
    
      FROM fywef_eshop_products
    
      WHERE id = 8

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:2459
    11	EshopHelper::getProductInventory()	JROOT/components/com_eshop/models/products.php:201
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

53. Query Time: 0.12 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 4.312 MB Rows returned: 0

    SELECT pi.*
    
      FROM fywef_eshop_productimages AS pi
    
      WHERE product_id = 9
    
      ORDER BY pi.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pi	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	151	Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1565
    11	EshopHelper::getProductImages()	JROOT/components/com_eshop/models/products.php:167
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

54. Query Time: 0.17 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 4.318 MB Rows returned: 0

    SELECT DISTINCT(label_id)
    
      FROM fywef_eshop_labelelements
    
      WHERE (element_type = "product" 
      AND element_id = 9) OR (element_type = "manufacturer" 
      AND element_id = (SELECT manufacturer_id 
      FROM fywef_eshop_products 
      WHERE id = 9)) OR (element_type = "category" 
      AND element_id IN (SELECT category_id 
      FROM fywef_eshop_productcategories 
      WHERE product_id = 9))

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    3	DEPENDENT SUBQUERY	fywef_eshop_productcategories	ref	product_id,category_id	product_id	5	const	2	Using where
    2	SUBQUERY	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_eshop/helpers/helper.php:5146
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

55. Query Time: 0.08 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.324 MB Rows returned: 1

    SELECT product_quantity
    
      FROM fywef_eshop_products
    
      WHERE id = 9

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:5154
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

56. Query Time: 0.08 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.331 MB Rows returned: 1
    Duplicate queries: #201  #202

    SELECT product_manage_stock, product_stock_display, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id
    
      FROM fywef_eshop_products
    
      WHERE id = 9

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:2459
    11	EshopHelper::getProductInventory()	JROOT/components/com_eshop/models/products.php:201
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

57. Query Time: 0.12 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 4.337 MB Rows returned: 0

    SELECT pi.*
    
      FROM fywef_eshop_productimages AS pi
    
      WHERE product_id = 10
    
      ORDER BY pi.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pi	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	151	Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1565
    11	EshopHelper::getProductImages()	JROOT/components/com_eshop/models/products.php:167
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

58. Query Time: 0.16 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.343 MB Rows returned: 0

    SELECT DISTINCT(label_id)
    
      FROM fywef_eshop_labelelements
    
      WHERE (element_type = "product" 
      AND element_id = 10) OR (element_type = "manufacturer" 
      AND element_id = (SELECT manufacturer_id 
      FROM fywef_eshop_products 
      WHERE id = 10)) OR (element_type = "category" 
      AND element_id IN (SELECT category_id 
      FROM fywef_eshop_productcategories 
      WHERE product_id = 10))

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    3	DEPENDENT SUBQUERY	fywef_eshop_productcategories	ref	product_id,category_id	product_id	5	const	2	Using where
    2	SUBQUERY	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_eshop/helpers/helper.php:5146
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

59. Query Time: 0.08 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.349 MB Rows returned: 1

    SELECT product_quantity
    
      FROM fywef_eshop_products
    
      WHERE id = 10

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:5154
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

60. Query Time: 0.08 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.356 MB Rows returned: 1
    Duplicate queries: #218  #219

    SELECT product_manage_stock, product_stock_display, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id
    
      FROM fywef_eshop_products
    
      WHERE id = 10

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:2459
    11	EshopHelper::getProductInventory()	JROOT/components/com_eshop/models/products.php:201
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

61. Query Time: 0.12 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 4.362 MB Rows returned: 0

    SELECT pi.*
    
      FROM fywef_eshop_productimages AS pi
    
      WHERE product_id = 11
    
      ORDER BY pi.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pi	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	151	Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1565
    11	EshopHelper::getProductImages()	JROOT/components/com_eshop/models/products.php:167
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

62. Query Time: 0.16 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 4.369 MB Rows returned: 0

    SELECT DISTINCT(label_id)
    
      FROM fywef_eshop_labelelements
    
      WHERE (element_type = "product" 
      AND element_id = 11) OR (element_type = "manufacturer" 
      AND element_id = (SELECT manufacturer_id 
      FROM fywef_eshop_products 
      WHERE id = 11)) OR (element_type = "category" 
      AND element_id IN (SELECT category_id 
      FROM fywef_eshop_productcategories 
      WHERE product_id = 11))

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    3	DEPENDENT SUBQUERY	fywef_eshop_productcategories	ref	product_id,category_id	product_id	5	const	2	Using where
    2	SUBQUERY	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_eshop/helpers/helper.php:5146
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

63. Query Time: 0.08 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.374 MB Rows returned: 1

    SELECT product_quantity
    
      FROM fywef_eshop_products
    
      WHERE id = 11

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:5154
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

64. Query Time: 0.08 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.381 MB Rows returned: 1
    Duplicate queries: #235  #236

    SELECT product_manage_stock, product_stock_display, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id
    
      FROM fywef_eshop_products
    
      WHERE id = 11

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:2459
    11	EshopHelper::getProductInventory()	JROOT/components/com_eshop/models/products.php:201
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

65. Query Time: 0.21 ms After last query: 0.25 ms Query memory: 0.028 MB Memory before query: 4.397 MB Rows returned: 4

    SELECT pi.*
    
      FROM fywef_eshop_productimages AS pi
    
      WHERE product_id = 12
    
      ORDER BY pi.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pi	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	151	Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1565
    11	EshopHelper::getProductImages()	JROOT/components/com_eshop/models/products.php:167
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

66. Query Time: 0.22 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 4.413 MB Rows returned: 0

    SELECT DISTINCT(label_id)
    
      FROM fywef_eshop_labelelements
    
      WHERE (element_type = "product" 
      AND element_id = 12) OR (element_type = "manufacturer" 
      AND element_id = (SELECT manufacturer_id 
      FROM fywef_eshop_products 
      WHERE id = 12)) OR (element_type = "category" 
      AND element_id IN (SELECT category_id 
      FROM fywef_eshop_productcategories 
      WHERE product_id = 12))

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    3	DEPENDENT SUBQUERY	fywef_eshop_productcategories	ref	product_id,category_id	product_id	5	const	2	Using where
    2	SUBQUERY	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_eshop/helpers/helper.php:5146
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

67. Query Time: 0.09 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 4.419 MB Rows returned: 1

    SELECT product_quantity
    
      FROM fywef_eshop_products
    
      WHERE id = 12

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:5154
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

68. Query Time: 0.09 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.425 MB Rows returned: 1
    Duplicate queries: #252  #253

    SELECT product_manage_stock, product_stock_display, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id
    
      FROM fywef_eshop_products
    
      WHERE id = 12

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:2459
    11	EshopHelper::getProductInventory()	JROOT/components/com_eshop/models/products.php:201
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

69. Query Time: 0.13 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 4.432 MB Rows returned: 4

    SELECT pi.*
    
      FROM fywef_eshop_productimages AS pi
    
      WHERE product_id = 13
    
      ORDER BY pi.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pi	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	151	Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1565
    11	EshopHelper::getProductImages()	JROOT/components/com_eshop/models/products.php:167
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

70. Query Time: 0.18 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 4.438 MB Rows returned: 0

    SELECT DISTINCT(label_id)
    
      FROM fywef_eshop_labelelements
    
      WHERE (element_type = "product" 
      AND element_id = 13) OR (element_type = "manufacturer" 
      AND element_id = (SELECT manufacturer_id 
      FROM fywef_eshop_products 
      WHERE id = 13)) OR (element_type = "category" 
      AND element_id IN (SELECT category_id 
      FROM fywef_eshop_productcategories 
      WHERE product_id = 13))

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    3	DEPENDENT SUBQUERY	fywef_eshop_productcategories	ref	product_id,category_id	product_id	5	const	2	Using where
    2	SUBQUERY	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_eshop/helpers/helper.php:5146
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

71. Query Time: 0.11 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.444 MB Rows returned: 1

    SELECT product_quantity
    
      FROM fywef_eshop_products
    
      WHERE id = 13

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:5154
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

72. Query Time: 0.09 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.450 MB Rows returned: 1
    Duplicate queries: #269  #270

    SELECT product_manage_stock, product_stock_display, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id
    
      FROM fywef_eshop_products
    
      WHERE id = 13

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:2459
    11	EshopHelper::getProductInventory()	JROOT/components/com_eshop/models/products.php:201
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

73. Query Time: 0.13 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 4.457 MB Rows returned: 3

    SELECT pi.*
    
      FROM fywef_eshop_productimages AS pi
    
      WHERE product_id = 14
    
      ORDER BY pi.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pi	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	151	Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1565
    11	EshopHelper::getProductImages()	JROOT/components/com_eshop/models/products.php:167
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

74. Query Time: 0.18 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 4.462 MB Rows returned: 0

    SELECT DISTINCT(label_id)
    
      FROM fywef_eshop_labelelements
    
      WHERE (element_type = "product" 
      AND element_id = 14) OR (element_type = "manufacturer" 
      AND element_id = (SELECT manufacturer_id 
      FROM fywef_eshop_products 
      WHERE id = 14)) OR (element_type = "category" 
      AND element_id IN (SELECT category_id 
      FROM fywef_eshop_productcategories 
      WHERE product_id = 14))

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    3	DEPENDENT SUBQUERY	fywef_eshop_productcategories	ref	product_id,category_id	product_id	5	const	2	Using where
    2	SUBQUERY	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_eshop/helpers/helper.php:5146
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

75. Query Time: 0.15 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.468 MB Rows returned: 1

    SELECT product_quantity
    
      FROM fywef_eshop_products
    
      WHERE id = 14

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:5154
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

76. Query Time: 0.10 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.474 MB Rows returned: 1
    Duplicate queries: #286  #287

    SELECT product_manage_stock, product_stock_display, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id
    
      FROM fywef_eshop_products
    
      WHERE id = 14

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:2459
    11	EshopHelper::getProductInventory()	JROOT/components/com_eshop/models/products.php:201
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

77. Query Time: 0.16 ms After last query: 0.47 ms Query memory: 0.022 MB Memory before query: 4.481 MB Rows returned: 3

    SELECT pi.*
    
      FROM fywef_eshop_productimages AS pi
    
      WHERE product_id = 15
    
      ORDER BY pi.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pi	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	151	Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1565
    11	EshopHelper::getProductImages()	JROOT/components/com_eshop/models/products.php:167
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

78. Query Time: 0.25 ms After last query: 0.69 ms Query memory: 0.022 MB Memory before query: 4.487 MB Rows returned: 0

    SELECT DISTINCT(label_id)
    
      FROM fywef_eshop_labelelements
    
      WHERE (element_type = "product" 
      AND element_id = 15) OR (element_type = "manufacturer" 
      AND element_id = (SELECT manufacturer_id 
      FROM fywef_eshop_products 
      WHERE id = 15)) OR (element_type = "category" 
      AND element_id IN (SELECT category_id 
      FROM fywef_eshop_productcategories 
      WHERE product_id = 15))

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    3	DEPENDENT SUBQUERY	fywef_eshop_productcategories	ref	product_id,category_id	product_id	5	const	2	Using where
    2	SUBQUERY	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_eshop/helpers/helper.php:5146
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

79. Query Time: 0.09 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.493 MB Rows returned: 1

    SELECT product_quantity
    
      FROM fywef_eshop_products
    
      WHERE id = 15

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:5154
    11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:198
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

80. Query Time: 0.09 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.499 MB Rows returned: 1
    Duplicate queries: #303  #304

    SELECT product_manage_stock, product_stock_display, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id
    
      FROM fywef_eshop_products
    
      WHERE id = 15

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fywef_eshop_products	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:2459
    11	EshopHelper::getProductInventory()	JROOT/components/com_eshop/models/products.php:201
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

81. Query Time: 0.13 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 4.506 MB Rows returned: 3

    SELECT pi.*
    
      FROM fywef_eshop_productimages AS pi
    
      WHERE product_id = 16
    
      ORDER BY pi.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pi	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	151	Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1565
    11	EshopHelper::getProductImages()	JROOT/components/com_eshop/models/products.php:167
    10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:90
    9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:108
    6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

82. Query Time: 0.18 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 4.512 MB Rows returned: 0