{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1596752210,
                "last": 1596752210,
                "now": 1596752210
            },
            "token": "wJNuO5FmyMa5T72Mze9nD1bnT6s9QiVR"
        },
        "registry": {
            "com_djcatalog2": {
                "items": {
                    "recent": [
                        4636
                    ]
                }
            }
        },
        "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
        }
    }
}

Time

Memory

67 Queries Logged 93.81 ms

1. Query Time: 0.25 ms Query memory: 0.020 MB Memory before query: 1.021 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `wfj4d_session`
   
     WHERE `session_id` = X'3830636336396632646438356162386565396632333930356235653165303036' 
     LIMIT 1

   Explain

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

   Profile

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.12 ms

   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:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   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: 2.19 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 1.026 MB

   INSERT INTO `wfj4d_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3830636336396632646438356162386565396632333930356235653165303036', 1, 1596752210, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `wfj4d_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3830636336396632646438356162386565396632333930356235653165303036', 1, 1596752210, 0, '', 0)

   Profile

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

   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:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   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: 0.21 ms After last query: 2.86 ms Query memory: 0.021 MB Memory before query: 1.120 MB Rows returned: 6

   SELECT id, rules
   
     FROM `wfj4d_viewlevels`

   Explain

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

   Profile

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

   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:321
   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:196
   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.]

   ---

4. Query Time: 0.25 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 1.132 MB Rows returned: 2

   SELECT b.id
   
     FROM wfj4d_usergroups AS a
   
     LEFT JOIN wfj4d_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	filtered	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	100.00	Using where; Using index

   Profile

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

   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:321
   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:196
   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.29 ms After last query: 6.85 ms Query memory: 0.022 MB Memory before query: 1.587 MB Rows returned: 1

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

   Explain

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

   Profile

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

   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:406
   9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:889
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
   7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   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:625
   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:196
   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.21 ms After last query: 0.64 ms Query memory: 0.021 MB Memory before query: 1.615 MB Rows returned: 0

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

   Explain

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

   Profile

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

   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:726
   10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:637
   9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:898
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
   7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   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:625
   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:196
   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.21 ms After last query: 10.41 ms Query memory: 0.021 MB Memory before query: 2.093 MB Rows returned: 0

   SELECT *
   
     FROM `wfj4d_admintools_ipautoban`
   
     WHERE `ip` = '35.172.233.215'

   Explain

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

   Profile

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

   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:305
   9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:141
   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:626
   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:196
   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.17 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 2.099 MB Rows returned: 2

   SELECT `ip`
   
     FROM `wfj4d_admintools_ipblock`

   Explain

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

   Profile

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

   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:305
   9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:141
   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:626
   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:196
   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.19 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 2.106 MB Rows returned: 1

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

   Explain

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

   Profile

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

   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:305
   9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:141
   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:626
   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:196
   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: 0.33 ms Query memory: 0.021 MB Memory before query: 2.116 MB Rows returned: 0

    SELECT `source`,`keepurlparams`
    
      FROM `wfj4d_admintools_redirects`
    
      WHERE ((`dest` = 'fishing-shop/item/spinning-accessories/westin-pro-shallow-screw/preview.html') OR (`dest` = 'fishing-shop/item/spinning-accessories/westin-pro-shallow-screw/preview.html') OR ('fishing-shop/item/spinning-accessories/westin-pro-shallow-screw/preview.html' LIKE `dest`)) 
      AND `published` = '1'
    
      ORDER BY `ordering` DESC 
      LIMIT 1

    Explain

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

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    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:305
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:141
    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:626
    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:196
    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.36 ms After last query: 0.43 ms Query memory: 0.006 MB Memory before query: 2.123 MB

    UPDATE `wfj4d_extensions`
    
      SET `params` = '{\"mediaversion\":\"0fcc16b22eab2a09a8c67a1f2a2d5b09\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/djcookiemonster/djcookiemonster.php:359
    9	PlgSystemDjcookiemonster->_initialChecks()	JROOT/plugins/system/djcookiemonster/djcookiemonster.php:79
    8	PlgSystemDjcookiemonster->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:626
    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:196
    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: 1.11 ms After last query: 12.64 ms Query memory: 0.345 MB Memory before query: 2.797 MB Rows returned: 81

    SELECT c.*  
      FROM wfj4d_djc2_categories AS c  
      WHERE c.published=1 
      AND c.access IN (1,5)  
      ORDER BY c.parent_id ASC, c.name ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	ref	idx_published,idx_access,idx_published_parent_ordering	idx_published	4	const	81	100.00	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.75 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.21 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:320
    15	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:195
    14	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:233
    13	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/route.php:729
    12	DJCatalogHelperRoute::getUrlParts()	JROOT/components/com_djcatalog2/helpers/route.php:697
    11	DJCatalogHelperRoute::parseAlias()	JROOT/components/com_djcatalog2/router.php:483
    10	DJCatalog2ParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    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:196
    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: 2.13 ms After last query: 0.26 ms Query memory: 0.033 MB Memory before query: 3.251 MB Rows returned: 78
    Duplicate queries: #24

    SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
    
      FROM wfj4d_djc2_categories as i
    
      INNER JOIN wfj4d_djc2_images as img 
      on img.id=(select id 
      from wfj4d_djc2_images 
      where type='category' 
      and item_id=i.id 
      order by ordering asc 
      limit 1)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	i	index	NULL	idx_parent_id	4	NULL	65	100.00	Using index
    1	PRIMARY	img	eq_ref	PRIMARY	PRIMARY	4	func	1	100.00	Using where
    2	DEPENDENT SUBQUERY	wfj4d_djc2_images	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_type_item	262	const,ulspinni_01.i.id	1	100.00	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.01 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    cleaning up	0.06 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:327
    15	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:195
    14	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:233
    13	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/route.php:729
    12	DJCatalogHelperRoute::getUrlParts()	JROOT/components/com_djcatalog2/helpers/route.php:697
    11	DJCatalogHelperRoute::parseAlias()	JROOT/components/com_djcatalog2/router.php:483
    10	DJCatalog2ParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    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:196
    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.28 ms After last query: 0.47 ms Query memory: 0.022 MB Memory before query: 3.393 MB Rows returned: 1

    SELECT id
    
      FROM wfj4d_djc2_categories
    
      WHERE alias LIKE 'spinning-accessories'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/helpers/route.php:790
    12	DJCatalogHelperRoute::getUrlParts()	JROOT/components/com_djcatalog2/helpers/route.php:697
    11	DJCatalogHelperRoute::parseAlias()	JROOT/components/com_djcatalog2/router.php:483
    10	DJCatalog2ParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    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:196
    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: 1.35 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 3.399 MB Rows returned: 1

    SELECT id, cat_id
    
      FROM wfj4d_djc2_items
    
      WHERE alias LIKE 'westin-pro-shallow-screw'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/helpers/route.php:734
    12	DJCatalogHelperRoute::getUrlParts()	JROOT/components/com_djcatalog2/helpers/route.php:697
    11	DJCatalogHelperRoute::parseAlias()	JROOT/components/com_djcatalog2/router.php:487
    10	DJCatalog2ParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    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:196
    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.35 ms After last query: 0.13 ms Query memory: 0.021 MB Memory before query: 3.469 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Creating tmp table	0.04 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.05 ms
    Creating sort index	0.01 ms
    end	0.00 ms
    removing tmp table	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.13 ms

    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:87
    10	AtsystemFeatureWafblacklist->onAfterRoute()	JROOT/plugins/system/admintools/admintools/main.php:305
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:151
    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:1122
    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:196
    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.62 ms After last query: 14.15 ms Query memory: 0.024 MB Memory before query: 4.264 MB Rows returned: 96

    select alias 
      from wfj4d_djc2_items_extra_fields 
      where type='checkbox' or type='radio' or type='select'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	wfj4d_djc2_items_extra_fields	range	idx_type	idx_type	202	NULL	97	100.00	Using index condition

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.27 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.11 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    9	JDatabaseDriver->loadColumn()	JROOT/components/com_djcatalog2/controller.php:125
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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.74 ms After last query: 1.98 ms Query memory: 0.029 MB Memory before query: 4.333 MB Rows returned: 41

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `wfj4d_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_acym','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djcatalog2','com_djmediatools','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_phocacommander','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	wfj4d_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	220	19.55	Using where

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.11 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.30 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.09 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    16	Joomla\CMS\User\User->authorise()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:137
    15	Djcatalog2Helper::getUser()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:455
    14	Djcatalog2Helper::getUserProfile()	JROOT/components/com_djcatalog2/models/item.php:44
    13	DJCatalog2ModelItem->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:45
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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.25 ms After last query: 2.04 ms Query memory: 0.024 MB Memory before query: 4.418 MB Rows returned: 0

    SELECT id
    
      FROM wfj4d_djc2_customer_groups
    
      WHERE (user_group IN (1,9) OR is_default=1)
    
      ORDER BY ordering DESC 
      LIMIT 1

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.02 ms
    end	0.00 ms
    query end	0.02 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:191
    15	Djcatalog2Helper::getUser()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:455
    14	Djcatalog2Helper::getUserProfile()	JROOT/components/com_djcatalog2/models/item.php:44
    13	DJCatalog2ModelItem->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:45
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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: 0.25 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 4.427 MB Rows returned: 1

    select * 
      from wfj4d_djc2_countries 
      where is_default=1

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    16	JDatabaseDriver->loadObject()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:251
    15	Djcatalog2Helper::getUser()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:455
    14	Djcatalog2Helper::getUserProfile()	JROOT/components/com_djcatalog2/models/item.php:44
    13	DJCatalog2ModelItem->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:45
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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: 3.89 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 4.440 MB Rows returned: 1

    SELECT vrul.id as rule_id, vrul.name, vrat.*
    
      FROM wfj4d_djc2_vat_rules AS vrul
    
      INNER JOIN wfj4d_djc2_vat_rules_xref AS vx 
      ON vx.rule_id = vrul.id
    
      INNER JOIN wfj4d_djc2_vat_rates AS vrat 
      ON vx.rate_id = vrat.id
    
      WHERE (vrat.country_id=222 OR vrat.country_id=0) 
      AND vrat.state_id=0 
      AND (vrat.client_type='A' OR vrat.client_type='R')
    
      ORDER BY vrat.client_type ASC, vrat.country_id ASC, vrat.state_id ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	vrul	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using temporary; Using filesort
    1	SIMPLE	vx	ref	idx_rule_rate	idx_rule_rate	4	ulspinni_01.vrul.id	1	100.00	Using index
    1	SIMPLE	vrat	eq_ref	PRIMARY,idx_country_client	PRIMARY	4	ulspinni_01.vx.rate_id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Creating tmp table	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	3.49 ms
    Creating sort index	0.02 ms
    end	0.00 ms
    removing tmp table	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.10 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:323
    15	Djcatalog2Helper::getUser()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:455
    14	Djcatalog2Helper::getUserProfile()	JROOT/components/com_djcatalog2/models/item.php:44
    13	DJCatalog2ModelItem->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:45
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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.64 ms After last query: 0.16 ms Query memory: 0.039 MB Memory before query: 4.450 MB Rows returned: 1

    SELECT i.*, 
      CASE WHEN (i.special_price > 0.0 
      AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email,gc.price as group_price, gc.available as group_available,countries.country_name ,states.name as state_name
    
      FROM wfj4d_djc2_items as i
    
      LEFT JOIN wfj4d_djc2_categories AS c 
      ON c.id = i.cat_id
    
      LEFT JOIN wfj4d_djc2_producers AS p 
      ON p.id = i.producer_id
    
      LEFT JOIN wfj4d_users AS ua 
      ON ua.id = i.created_by
    
      LEFT JOIN wfj4d_djc2_prices AS gc 
      ON gc.item_id = i.id 
      AND gc.group_id=0
    
      LEFT JOIN wfj4d_djc2_countries AS countries 
      ON countries.id = i.country
    
      LEFT JOIN wfj4d_djc2_countries_states AS states 
      ON states.id = i.state
    
      WHERE i.id =4636 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-08-06 22:16:50') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-08-06 22:16:50')
    
      GROUP BY i.id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	gc	const	item_group,group_item	item_group	8	const,const	0	0.00	unique row not found
    1	SIMPLE	countries	const	PRIMARY	PRIMARY	2	const	0	0.00	unique row not found
    1	SIMPLE	states	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.07 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.12 ms
    preparing	0.04 ms
    executing	0.00 ms
    Sending data	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.06 ms
    freeing items	0.03 ms
    cleaning up	0.07 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/components/com_djcatalog2/models/item.php:197
    12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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: 0.79 ms After last query: 0.06 ms Query memory: 0.365 MB Memory before query: 4.469 MB Rows returned: 86

    SELECT c.*  
      FROM wfj4d_djc2_categories AS c  
      ORDER BY c.parent_id ASC, c.name ASC

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.62 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:320
    15	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:195
    14	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:233
    13	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/models/item.php:219
    12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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: 2.08 ms After last query: 0.38 ms Query memory: 0.033 MB Memory before query: 4.951 MB Rows returned: 78
    Duplicate queries: #13

    SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
    
      FROM wfj4d_djc2_categories as i
    
      INNER JOIN wfj4d_djc2_images as img 
      on img.id=(select id 
      from wfj4d_djc2_images 
      where type='category' 
      and item_id=i.id 
      order by ordering asc 
      limit 1)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	i	index	NULL	idx_parent_id	4	NULL	65	100.00	Using index
    1	PRIMARY	img	eq_ref	PRIMARY	PRIMARY	4	func	1	100.00	Using where
    2	DEPENDENT SUBQUERY	wfj4d_djc2_images	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_type_item	262	const,ulspinni_01.i.id	1	100.00	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.02 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:327
    15	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:195
    14	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:233
    13	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/models/item.php:219
    12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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.20 ms After last query: 0.45 ms Query memory: 0.023 MB Memory before query: 5.171 MB Rows returned: 4

    SELECT category_id
    
      FROM wfj4d_djc2_items_categories
    
      WHERE item_id=4636

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	wfj4d_djc2_items_categories	ref	item_category	item_category	4	const	4	100.00	Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    14	JDatabaseDriver->loadColumn()	JROOT/components/com_djcatalog2/models/item.php:541
    13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:258
    12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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: 1.54 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 5.208 MB Rows returned: 0

    SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value, fieldoptions.params as option_params
    
      FROM wfj4d_djc2_items_extra_fields_values_int as fieldvalues
    
      INNER JOIN wfj4d_djc2_items as items 
      on items.id=fieldvalues.item_id
    
      INNER JOIN wfj4d_djc2_items_extra_fields as fields 
      ON fields.id = fieldvalues.field_id
    
      LEFT JOIN wfj4d_djc2_items_extra_fields_options as fieldoptions 
      ON fieldoptions.id = fieldvalues.value 
      AND fieldoptions.field_id = fields.id
    
      WHERE fieldvalues.item_id=4636 
      AND fields.cart_variant=2 
      AND fields.published = 1
    
      ORDER BY fields.ordering asc, fieldoptions.ordering asc

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index; Using temporary; Using filesort
    1	SIMPLE	fieldvalues	ref	idx_item_field	idx_item_field	4	const	1	100.00	NULL
    1	SIMPLE	fields	eq_ref	PRIMARY,idx_published	PRIMARY	4	ulspinni_01.fieldvalues.field_id	1	100.00	Using where
    1	SIMPLE	fieldoptions	eq_ref	PRIMARY,idx_field_id	PRIMARY	4	ulspinni_01.fieldvalues.value	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.01 ms
    Creating tmp table	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.81 ms
    Creating sort index	0.02 ms
    end	0.00 ms
    removing tmp table	0.37 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:588
    13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:258
    12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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.88 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 5.215 MB Rows returned: 0

    SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value, fieldoptions.params as option_params
    
      FROM wfj4d_djc2_items_extra_fields_values_int as fieldvalues
    
      INNER JOIN wfj4d_djc2_items as items 
      on items.id=fieldvalues.item_id
    
      INNER JOIN wfj4d_djc2_items_extra_fields as fields 
      ON fields.id = fieldvalues.field_id
    
      LEFT JOIN wfj4d_djc2_items_extra_fields_options as fieldoptions 
      ON fieldoptions.id = fieldvalues.value 
      AND fieldoptions.field_id = fields.id
    
      WHERE fieldvalues.item_id=4636 
      AND (fields.visibility = 1 OR fields.visibility = 3) 
      AND fields.published = 1
    
      ORDER BY fields.ordering asc, fieldoptions.ordering asc

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index; Using temporary; Using filesort
    1	SIMPLE	fieldvalues	ref	idx_item_field	idx_item_field	4	const	1	100.00	NULL
    1	SIMPLE	fields	eq_ref	PRIMARY,idx_published	PRIMARY	4	ulspinni_01.fieldvalues.field_id	1	100.00	Using where
    1	SIMPLE	fieldoptions	eq_ref	PRIMARY,idx_field_id	PRIMARY	4	ulspinni_01.fieldvalues.value	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    Creating tmp table	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.37 ms
    Creating sort index	0.01 ms
    end	0.00 ms
    removing tmp table	0.23 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:590
    13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:258
    12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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.23 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 5.223 MB Rows returned: 0

    SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
    
      FROM wfj4d_djc2_items_extra_fields_values_text as fieldvalues
    
      INNER JOIN wfj4d_djc2_items as items 
      on items.id=fieldvalues.item_id
    
      INNER JOIN wfj4d_djc2_items_extra_fields as fields 
      ON fields.id = fieldvalues.field_id
    
      WHERE fieldvalues.item_id=4636 
      AND (fields.visibility = 1 OR fields.visibility = 3) 
      AND fields.published = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
    1	SIMPLE	fieldvalues	ref	idx_item_field	idx_item_field	4	const	1	100.00	NULL
    1	SIMPLE	fields	eq_ref	PRIMARY,idx_published	PRIMARY	4	ulspinni_01.fieldvalues.field_id	1	100.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:592
    13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:258
    12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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.24 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 5.230 MB Rows returned: 0

    SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
    
      FROM wfj4d_djc2_items_extra_fields_values_date as fieldvalues
    
      INNER JOIN wfj4d_djc2_items as items 
      on items.id=fieldvalues.item_id
    
      INNER JOIN wfj4d_djc2_items_extra_fields as fields 
      ON fields.id = fieldvalues.field_id
    
      WHERE fieldvalues.item_id=4636 
      AND (fields.visibility = 1 OR fields.visibility = 3) 
      AND fields.published = 1
    
      ORDER BY fields.ordering asc

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index; Using temporary; Using filesort
    1	SIMPLE	fieldvalues	ref	item_field	item_field	4	const	1	100.00	NULL
    1	SIMPLE	fields	eq_ref	PRIMARY,idx_published	PRIMARY	4	ulspinni_01.fieldvalues.field_id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Creating tmp table	0.03 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.01 ms
    end	0.00 ms
    removing tmp table	0.00 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.08 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:594
    13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:258
    12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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.20 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 5.237 MB Rows returned: 0

    SELECT l.*, li.item_id
    
      FROM wfj4d_djc2_labels as l
    
      INNER JOIN wfj4d_djc2_labels_items AS li 
      ON li.label_id=l.id
    
      WHERE li.item_id=4636
    
      ORDER BY l.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	l	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using filesort
    1	SIMPLE	li	eq_ref	PRIMARY	PRIMARY	8	const,ulspinni_01.l.id	1	100.00	Using index

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:597
    13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:258
    12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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.16 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 5.247 MB Rows returned: 0

    SELECT cg.*, p.price, p.available
    
      FROM wfj4d_djc2_customer_groups AS cg
    
      INNER JOIN wfj4d_djc2_prices AS p 
      ON p.group_id=cg.id
    
      WHERE p.item_id = 4636 
      AND (p.available = 1 OR p.price > 0.0)
    
      ORDER BY cg.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cg	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using filesort
    1	SIMPLE	p	eq_ref	item_group,group_item	item_group	8	const,ulspinni_01.cg.id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.07 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:611
    13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:258
    12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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: 1.34 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 5.254 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM wfj4d_djc2_items_combinations
    
      WHERE item_id =4636

    Explain

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

    Profile

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.00 ms
    Sending data	1.21 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:618
    13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:258
    12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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.22 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 5.271 MB Rows returned: 0

    SELECT *
    
      FROM wfj4d_djc2_price_rules
    
      WHERE published=1 
      AND (start_date = '0000-00-00 00:00:00' OR start_date <= '2020-08-06 22:16:50') 
      AND (expire_date = '0000-00-00 00:00:00' OR expire_date >= '2020-08-06 22:16:50')
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.04 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/helpers/price.php:400
    15	Djcatalog2HelperPrice::getPriceRules()	JROOT/components/com_djcatalog2/helpers/price.php:189
    14	Djcatalog2HelperPrice::applyPriceRules()	JROOT/components/com_djcatalog2/models/item.php:695
    13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:258
    12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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.16 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 5.280 MB Rows returned: 0

    SELECT *
    
      FROM wfj4d_djc2_items_price_tiers
    
      WHERE item_id=4636
    
      ORDER BY quantity ASC

    Explain

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

    Profile

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.02 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:1200
    14	DJCatalog2ModelItem->getTierPrices()	JROOT/components/com_djcatalog2/models/item.php:698
    13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:258
    12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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.10 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 5.261 MB Rows returned: 1
    Duplicate queries: #36  #41  #42  #49

    SELECT sections
    
      FROM `wfj4d_djc2_categories`
    
      WHERE `id` = 22

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:280
    13	DJCatalog2ModelItem->getSectionByCategory()	JROOT/components/com_djcatalog2/models/item.php:262
    12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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: 0.15 ms After last query: 1.50 ms Query memory: 0.023 MB Memory before query: 5.264 MB Rows returned: 1
    Duplicate queries: #35  #41  #42  #49

    SELECT sections
    
      FROM `wfj4d_djc2_categories`
    
      WHERE `id` = 22

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:280
    14	DJCatalog2ModelItem->getSectionByCategory()	JROOT/components/com_djcatalog2/models/item.php:262
    13	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:75
    12	DJCatalog2ModelItem->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:47
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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: 2.47 ms After last query: 0.44 ms Query memory: 0.069 MB Memory before query: 5.271 MB Rows returned: 963

    select id, producer_id 
      from wfj4d_djc2_items 
      where published=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	wfj4d_djc2_items	ref	idx_published	idx_published	4	const	962	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/helpers/route.php:69
    11	DJCatalogHelperRoute::getItemRoute()	JROOT/components/com_djcatalog2/views/item/view.html.php:136
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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: 7.49 ms After last query: 4.72 ms Query memory: 0.285 MB Memory before query: 5.417 MB Rows returned: 606

    SELECT f.*, group_concat(fo.id separator '|') as options
    
      FROM wfj4d_djc2_items_extra_fields as f
    
      LEFT JOIN wfj4d_djc2_items_extra_fields_options as fo 
      ON fo.field_id=f.id
    
      WHERE f.published = 1
    
      GROUP BY f.id
    
      ORDER BY f.group_id asc, f.ordering asc

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	f	index	PRIMARY,idx_published,idx_filterable,idx_searchable,idx_separate_column,idx_type,idx_group_id	PRIMARY	4	NULL	587	75.13	Using where; Using temporary; Using filesort
    1	SIMPLE	fo	ref	idx_field_id	idx_field_id	4	ulspinni_01.f.id	4	100.00	Using index

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    Creating tmp table	0.03 ms
    Sorting for group	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	4.52 ms
    Creating sort index	2.12 ms
    end	0.01 ms
    removing tmp table	0.45 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.03 ms
    freeing items	0.01 ms
    removing tmp table	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.08 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/plugins/djcatalog2/customfield/customfield.php:41
    13	plgDJCatalog2Customfield->onPrepareItemDescription()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_djcatalog2/views/item/view.html.php:180
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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.19 ms After last query: 1.18 ms Query memory: 0.022 MB Memory before query: 6.406 MB Rows returned: 0

    SELECT related_item
    
      FROM wfj4d_djc2_items_related
    
      WHERE item_id=4636

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	wfj4d_djc2_items_related	ref	item_related	item_related	4	const	1	100.00	Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_djcatalog2/models/item.php:305
    11	DJCatalog2ModelItem->getRelatedItems()	JROOT/components/com_djcatalog2/views/item/view.html.php:204
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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: 1.32 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 6.415 MB Rows returned: 0

    SELECT f.*, g.name as group_name, g.label as group_label, g.id as fgroup_id
    
      FROM wfj4d_djc2_items_extra_fields as f
    
      LEFT JOIN wfj4d_djc2_items_extra_fields_groups as g 
      ON g.id=f.group_id
    
      WHERE (f.visibility = 1 or f.visibility = 3) 
      and f.published = 1 
      AND (f.cart_variant = 0 OR f.cart_variant = 2)
    
      ORDER BY IFNULL(g.ordering,0) asc , g.ordering asc, f.ordering asc

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	f	ALL	idx_published	NO INDEX KEY COULD BE USED	NULL	NULL	587	75.13	Using where; Using temporary; Using filesort
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ulspinni_01.f.group_id	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    Creating tmp table	0.03 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.92 ms
    Creating sort index	0.02 ms
    end	0.00 ms
    removing tmp table	0.12 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.16 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:371
    11	DJCatalog2ModelItem->getAttributes()	JROOT/components/com_djcatalog2/views/item/view.html.php:205
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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.20 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 6.419 MB Rows returned: 1
    Duplicate queries: #35  #36  #42  #49

    SELECT sections
    
      FROM `wfj4d_djc2_categories`
    
      WHERE `id` = 22

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:280
    13	DJCatalog2ModelItem->getSectionByCategory()	JROOT/components/com_djcatalog2/models/item.php:262
    12	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:466
    11	DJCatalog2ModelItem->getCartVariants()	JROOT/components/com_djcatalog2/views/item/view.html.php:207
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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.09 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 6.426 MB Rows returned: 1
    Duplicate queries: #35  #36  #41  #49

    SELECT sections
    
      FROM `wfj4d_djc2_categories`
    
      WHERE `id` = 22

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:280
    14	DJCatalog2ModelItem->getSectionByCategory()	JROOT/components/com_djcatalog2/models/item.php:262
    13	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:897
    12	DJCatalog2ModelItem->getCombinations()	JROOT/components/com_djcatalog2/models/item.php:467
    11	DJCatalog2ModelItem->getCartVariants()	JROOT/components/com_djcatalog2/views/item/view.html.php:207
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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: 4.13 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 6.435 MB Rows returned: 2
    Duplicate queries: #50

    SELECT c.*, gc.price as group_price
    
      FROM wfj4d_djc2_items_combinations AS c
    
      LEFT JOIN wfj4d_djc2_combination_prices AS gc 
      ON gc.combination_id = c.id 
      AND gc.group_id=0
    
      WHERE item_id = 4636

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7170	100.00	Using where
    1	SIMPLE	gc	eq_ref	item_group,group_item	item_group	8	ulspinni_01.c.id,const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:910
    12	DJCatalog2ModelItem->getCombinations()	JROOT/components/com_djcatalog2/models/item.php:467
    11	DJCatalog2ModelItem->getCartVariants()	JROOT/components/com_djcatalog2/views/item/view.html.php:207
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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: 3.01 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 6.445 MB Rows returned: 2
    Duplicate queries: #51

    SELECT cf.*, f.name as field_name, fo.value as field_value, fo.params
    
      FROM wfj4d_djc2_items_combinations_fields AS cf
    
      LEFT JOIN wfj4d_djc2_items_extra_fields as f 
      ON f.id = cf.field_id
    
      LEFT JOIN wfj4d_djc2_items_extra_fields_options as fo 
      ON fo.id = cf.value 
      AND fo.field_id = cf.field_id 
      AND fo.field_id = f.id
    
      WHERE cf.combination_id IN (13491,13492)
    
      ORDER BY f.ordering, fo.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cf	range	idx_combination_field_value	idx_combination_field_value	4	NULL	2	100.00	Using where; Using index; Using temporary; Using filesort
    1	SIMPLE	f	eq_ref	PRIMARY	PRIMARY	4	ulspinni_01.cf.field_id	1	100.00	NULL
    1	SIMPLE	fo	eq_ref	PRIMARY,idx_field_id	PRIMARY	4	ulspinni_01.cf.value	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	2.04 ms
    preparing	0.02 ms
    Creating tmp table	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.48 ms
    Creating sort index	0.03 ms
    end	0.00 ms
    removing tmp table	0.20 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    cleaning up	0.14 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:922
    12	DJCatalog2ModelItem->getCombinations()	JROOT/components/com_djcatalog2/models/item.php:467
    11	DJCatalog2ModelItem->getCartVariants()	JROOT/components/com_djcatalog2/views/item/view.html.php:207
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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: 3.87 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 6.454 MB Rows returned: 0

    SELECT *  
      FROM wfj4d_djc2_images  
      WHERE item_id=13491 	
      AND type='combination' 
      AND exclude=0 
      ORDER BY ordering ASC, name ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	wfj4d_djc2_images	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_type_item	262	const,const	1	100.00	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	3.64 ms
    preparing	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.07 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/helpers/image.php:77
    13	DJCatalog2ImageHelper::getImages()	JROOT/components/com_djcatalog2/models/item.php:935
    12	DJCatalog2ModelItem->getCombinations()	JROOT/components/com_djcatalog2/models/item.php:467
    11	DJCatalog2ModelItem->getCartVariants()	JROOT/components/com_djcatalog2/views/item/view.html.php:207
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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.20 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 6.461 MB Rows returned: 0

    SELECT *  
      FROM wfj4d_djc2_images  
      WHERE item_id=13492 	
      AND type='combination' 
      AND exclude=0 
      ORDER BY ordering ASC, name ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	wfj4d_djc2_images	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_type_item	262	const,const	1	100.00	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/helpers/image.php:77
    13	DJCatalog2ImageHelper::getImages()	JROOT/components/com_djcatalog2/models/item.php:935
    12	DJCatalog2ModelItem->getCombinations()	JROOT/components/com_djcatalog2/models/item.php:467
    11	DJCatalog2ModelItem->getCartVariants()	JROOT/components/com_djcatalog2/views/item/view.html.php:207
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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: 6.89 ms After last query: 0.04 ms Query memory: 0.288 MB Memory before query: 6.467 MB Rows returned: 606

    SELECT f.*, g.name as group_name, g.label as group_label, g.id as fgroup_id
    
      FROM wfj4d_djc2_items_extra_fields as f
    
      LEFT JOIN wfj4d_djc2_items_extra_fields_groups as g 
      ON g.id=f.group_id
    
      WHERE (f.cart_variant=1 OR f.cart_variant=2) 
      and f.published = 1
    
      ORDER BY IFNULL(g.ordering,0) asc , g.ordering asc, f.ordering asc

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	f	ALL	idx_published	NO INDEX KEY COULD BE USED	NULL	NULL	587	75.13	Using where; Using temporary; Using filesort
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ulspinni_01.f.group_id	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    Creating tmp table	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	4.67 ms
    Creating sort index	1.62 ms
    end	0.00 ms
    removing tmp table	0.24 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:429
    12	DJCatalog2ModelItem->getCartAttributes()	JROOT/components/com_djcatalog2/models/item.php:468
    11	DJCatalog2ModelItem->getCartVariants()	JROOT/components/com_djcatalog2/views/item/view.html.php:207
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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: 9.71 ms After last query: 0.99 ms Query memory: 0.975 MB Memory before query: 7.474 MB Rows returned: 5401

    SELECT *
    
      FROM wfj4d_djc2_items_extra_fields_options
    
      WHERE field_id in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,33,35,44,45,47,54,59,60,62,68,69,78,80,85,93,96,103,108,251,455,495,496,497,498,499,501,509,522,555,564,617,649,51,151,155,194,540,651,64,65,66,67,71,76,95,109,110,502,545,546,547,548,550,562,661,662,667,669,670,671,672,673,79,503,541,560,573,94,104,166,249,260,261,262,263,264,265,266,267,268,269,270,271,272,273,284,285,286,287,288,289,290,490,643,647,658,681,111,113,114,115,116,117,118,119,120,121,122,123,124,125,126,257,258,259,381,476,552,112,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,146,149,154,156,161,453,454,467,468,469,472,473,474,478,504,514,534,539,542,549,556,558,559,561,582,584,591,592,629,631,660,679,147,148,153,477,535,536,551,588,589,590,596,597,598,626,150,152,157,470,471,557,585,587,610,158,159,160,241,242,243,244,245,246,247,248,475,652,654,655,163,164,165,255,256,167,168,169,170,171,172,173,356,379,380,382,520,521,553,630,632,633,634,174,175,176,177,178,179,180,182,183,532,533,574,575,576,577,578,579,580,581,583,586,593,594,595,600,601,602,603,604,605,606,607,608,609,611,612,613,615,616,646,650,659,674,184,185,186,187,188,189,526,527,528,529,530,531,644,645,198,199,200,201,202,203,204,205,489,510,511,518,236,237,238,239,240,191,192,193,195,300,301,373,375,554,627,628,657,663,668,196,197,302,303,304,305,306,307,308,206,207,309,310,312,563,641,642,656,676,677,208,209,210,283,482,483,484,485,486,519,211,513,680,212,213,214,215,216,217,218,219,220,221,355,389,390,481,517,222,223,224,225,226,494,505,506,227,228,229,230,231,487,565,566,567,568,569,570,599,635,636,637,638,639,640,675,232,314,233,234,235,276,277,291,313,250,252,253,254,274,275,512,278,279,281,282,292,293,294,295,296,297,298,299,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,340,341,342,343,344,345,347,348,349,351,352,353,354,357,358,359,360,362,363,364,365,366,367,368,369,370,377,378,383,384,385,371,372,376,386,387,388,571,572,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,435,436,437,438,439,440,441,442,443,537,433,434,444,445,447,448,449,450,451,452,456,457,458,459,460,461,462,463,464,465,466,479,480,500,524,525,678,491,492,493,543,544,507,508,515,516,523,538,618,619,620,622,623,624,625,664,665,666)
    
      ORDER BY field_id asc, ordering asc

    Explain

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

    Profile

    Status	Duration
    starting	0.13 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.08 ms
    System lock	0.00 ms
    optimizing	0.02 ms
    statistics	0.43 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	8.68 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:439
    12	DJCatalog2ModelItem->getCartAttributes()	JROOT/components/com_djcatalog2/models/item.php:468
    11	DJCatalog2ModelItem->getCartVariants()	JROOT/components/com_djcatalog2/views/item/view.html.php:207
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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.39 ms After last query: 192.22 ms Query memory: 0.023 MB Memory before query: 12.239 MB Rows returned: 1
    Duplicate queries: #35  #36  #41  #42

    SELECT sections
    
      FROM `wfj4d_djc2_categories`
    
      WHERE `id` = 22

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:280
    13	DJCatalog2ModelItem->getSectionByCategory()	JROOT/components/com_djcatalog2/models/item.php:262
    12	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:897
    11	DJCatalog2ModelItem->getCombinations()	JROOT/components/com_djcatalog2/views/item/view.html.php:208
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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: 4.25 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 12.247 MB Rows returned: 2
    Duplicate queries: #43

    SELECT c.*, gc.price as group_price
    
      FROM wfj4d_djc2_items_combinations AS c
    
      LEFT JOIN wfj4d_djc2_combination_prices AS gc 
      ON gc.combination_id = c.id 
      AND gc.group_id=0
    
      WHERE item_id = 4636

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7170	100.00	Using where
    1	SIMPLE	gc	eq_ref	item_group,group_item	item_group	8	ulspinni_01.c.id,const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	3.94 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.10 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:910
    11	DJCatalog2ModelItem->getCombinations()	JROOT/components/com_djcatalog2/views/item/view.html.php:208
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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: 1.61 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 12.257 MB Rows returned: 2
    Duplicate queries: #44

    SELECT cf.*, f.name as field_name, fo.value as field_value, fo.params
    
      FROM wfj4d_djc2_items_combinations_fields AS cf
    
      LEFT JOIN wfj4d_djc2_items_extra_fields as f 
      ON f.id = cf.field_id
    
      LEFT JOIN wfj4d_djc2_items_extra_fields_options as fo 
      ON fo.id = cf.value 
      AND fo.field_id = cf.field_id 
      AND fo.field_id = f.id
    
      WHERE cf.combination_id IN (13491,13492)
    
      ORDER BY f.ordering, fo.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cf	range	idx_combination_field_value	idx_combination_field_value	4	NULL	2	100.00	Using where; Using index; Using temporary; Using filesort
    1	SIMPLE	f	eq_ref	PRIMARY	PRIMARY	4	ulspinni_01.cf.field_id	1	100.00	NULL
    1	SIMPLE	fo	eq_ref	PRIMARY,idx_field_id	PRIMARY	4	ulspinni_01.cf.value	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Creating tmp table	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.90 ms
    Creating sort index	0.04 ms
    end	0.00 ms
    removing tmp table	0.20 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.06 ms
    freeing items	0.03 ms
    cleaning up	0.22 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:922
    11	DJCatalog2ModelItem->getCombinations()	JROOT/components/com_djcatalog2/views/item/view.html.php:208
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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.96 ms After last query: 0.19 ms Query memory: 0.022 MB Memory before query: 12.265 MB Rows returned: 0

    SELECT ic.*, c.name, c.input_params, c.type, c.tax_rule_id, c.price_modifier
    
      FROM wfj4d_djc2_items_customisations AS ic
    
      INNER JOIN wfj4d_djc2_customisations AS c 
      ON c.id=ic.customisation_id
    
      WHERE item_id = 4636 
      AND c.type='i'
    
      ORDER BY c.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ic	ref	item_id	item_id	4	const	1	100.00	Using temporary; Using filesort
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	ulspinni_01.ic.customisation_id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Creating tmp table	0.03 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.40 ms
    Creating sort index	0.02 ms
    end	0.00 ms
    removing tmp table	0.16 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.15 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:1045
    11	DJCatalog2ModelItem->getCustomisations()	JROOT/components/com_djcatalog2/views/item/view.html.php:209
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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.25 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 12.271 MB Rows returned: 0

    SELECT c.*, id as customisation_id, 0 as item_id
    
      FROM wfj4d_djc2_customisations AS c
    
      WHERE (c.type='c' OR c.type='a')
    
      ORDER BY c.ordering

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:1045
    11	DJCatalog2ModelItem->getCustomisations()	JROOT/components/com_djcatalog2/views/item/view.html.php:210
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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: 2.03 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 12.278 MB Rows returned: 1

    SELECT subq.position 
      FROM (SELECT k.*, @num := @num + 1 AS position 
      FROM (SELECT @num := 0) AS n, (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, 
      CASE WHEN (i.special_price > 0.0 
      AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price 
      FROM wfj4d_djc2_items AS i  
      LEFT JOIN wfj4d_djc2_categories as c 
      ON c.id = i.cat_id  
      LEFT JOIN wfj4d_djc2_producers as p 
      ON p.id = i.producer_id  
      WHERE i.parent_id = 0 
      AND i.published = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-08-06 22:16:50') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-08-06 22:16:50') 
      AND c.published = 1  
      AND i.cat_id=22 
      ORDER BY  i.name desc , i.ordering, c.ordering ) as k) as subq 
      WHERE subq.id = 4636 
      ORDER BY subq.position DESC 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	const	5	100.00	Using where; Using filesort
    2	DERIVED	<derived3>	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
    2	DERIVED	<derived4>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	55	100.00	NULL
    4	DERIVED	c	const	PRIMARY,idx_published,idx_published_parent_ordering	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
    4	DERIVED	i	index_merge	idx_cat_id,idx_parent_id,idx_published	idx_cat_id,idx_published	4,4	NULL	73	75.34	Using intersect(idx_cat_id,idx_published); Using where
    4	DERIVED	p	eq_ref	PRIMARY	PRIMARY	4	ulspinni_01.i.producer_id	1	100.00	Using index; Distinct
    3	DERIVED	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	No tables used

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.12 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.00 ms
    optimizing	0.00 ms
    optimizing	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.10 ms
    preparing	0.01 ms
    Creating tmp table	0.02 ms
    Sorting result	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    Sorting result	0.00 ms
    executing	0.01 ms
    Sending data	0.00 ms
    executing	0.00 ms
    Sending data	0.00 ms
    executing	0.00 ms
    Sending data	0.93 ms
    Creating sort index	0.26 ms
    removing tmp table	0.01 ms
    Creating sort index	0.19 ms
    Creating sort index	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.02 ms
    closing tables	0.00 ms
    removing tmp table	0.02 ms
    closing tables	0.00 ms
    removing tmp table	0.02 ms
    closing tables	0.04 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:811
    11	DJCatalog2ModelItem->getNavigation()	JROOT/components/com_djcatalog2/views/item/view.html.php:216
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:135
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:56
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:196
    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: 1.85 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 12.285 MB Rows returned: 1
    <