{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1732348904,
                "last": 1732348904,
                "now": 1732348904
            },
            "token": "IVtWWPxpoISkE250SiYVuvCznKD0fsBx"
        },
        "registry": {
            "users": {
                "login": {
                    "form": {
                        "data": []
                    }
                }
            }
        },
        "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

63 Queries Logged 59.91 ms

1. Query Time: 9.24 ms Query memory: 0.023 MB Memory before query: 1.029 MB Rows returned: 0

   SELECT `data`
   
     FROM `zov5y_session`
   
     WHERE `session_id` = X'636f7068363036756a6933386e68306e356a363861746b727531'

   Explain

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

   Profile

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	8.39 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.03 ms
   Unlocking tables	0.03 ms
   closing tables	0.01 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.41 ms
   Preparing	0.01 ms
   Executing	0.02 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Query Time: 0.82 ms After last query: 1.31 ms Query memory: 0.020 MB Memory before query: 1.043 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `zov5y_session`
   
     WHERE `session_id` = X'636f7068363036756a6933386e68306e356a363861746b727531' 
     LIMIT 1

   Explain

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

   Profile

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Executing	0.02 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.01 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:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Query Time: 0.95 ms After last query: 0.13 ms Query memory: 0.004 MB Memory before query: 1.048 MB

   INSERT INTO `zov5y_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'636f7068363036756a6933386e68306e356a363861746b727531', 1, 1732348904, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `zov5y_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'636f7068363036756a6933386e68306e356a363861746b727531', 1, 1732348904, 0, '', 0)

   Profile

   Status	Duration
   Starting	0.08 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init for update	0.02 ms
   Update	0.09 ms
   Waiting for query cache lock	0.01 ms
   Update	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.60 ms
   closing tables	0.01 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.01 ms
   Reset for next command	0.00 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:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Query Time: 2.07 ms After last query: 3.97 ms Query memory: 0.025 MB Memory before query: 1.086 MB Rows returned: 41

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.64 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.04 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.06 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   Sending data	0.27 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

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

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

   ---

5. Query Time: 2.21 ms After last query: 2.95 ms Query memory: 0.021 MB Memory before query: 1.116 MB Rows returned: 4

   SELECT id, rules
   
     FROM `zov5y_viewlevels`

   Explain

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

   Profile

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	1.83 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.02 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.09 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   closing tables	0.03 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.01 ms
   Reset for next command	0.00 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:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Query Time: 1.67 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 1.127 MB Rows returned: 1

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	1.25 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.02 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.05 ms
   Preparing	0.01 ms
   Unlocking tables	0.00 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.09 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.00 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:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Query Time: 1.17 ms After last query: 0.81 ms Query memory: 0.030 MB Memory before query: 1.152 MB Rows returned: 101

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.04 ms
   Preparing	0.02 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.54 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Query Time: 0.63 ms After last query: 14.26 ms Query memory: 0.021 MB Memory before query: 1.513 MB Rows returned: 1

   SELECT `custom_data` 
     FROM `zov5y_extensions` 
     WHERE `type` = 'component' 
     AND `element` = 'com_sef'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	zov5y_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

   Profile

   Status	Duration
   Starting	0.07 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.10 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   Sending data	0.19 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sef/classes/config.php:752
   10	SEFConfig->__construct()	JROOT/administrator/components/com_sef/classes/config.php:954
   9	SEFConfig::getConfig()	JROOT/plugins/system/joomsef/joomsef.php:247
   8	plgSystemJoomsef->_isEnabled()	JROOT/plugins/system/joomsef/joomsef.php:31
   7	plgSystemJoomsef->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 6.37 ms After last query: 17.52 ms Query memory: 0.171 MB Memory before query: 1.770 MB Rows returned: 112

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	m	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	186	Using where; Using filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	churchofthecreator.m.component_id	1	Using where

   Profile

   Status	Duration
   Starting	0.09 ms
   checking permissions	0.01 ms
   Opening tables	1.71 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.05 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.03 ms
   Preparing	0.03 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.02 ms
   Creating sort index	0.86 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

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

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

   ---

10. Query Time: 1.43 ms After last query: 7.48 ms Query memory: 0.021 MB Memory before query: 2.350 MB Rows returned: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	1
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	churchofthecreator.s.template,const	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.74 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.07 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.12 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.12 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:353
    9	T3::detect()	JROOT/plugins/system/t3/t3.php:87
    8	plgSystemT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 0.42 ms After last query: 1.21 ms Query memory: 0.022 MB Memory before query: 2.377 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.12 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 0.98 ms After last query: 0.36 ms Query memory: 0.005 MB Memory before query: 2.367 MB

    UPDATE `zov5y_extensions`
    
      SET `params` = '{\"mediaversion\":\"7b7b026aa3f80f0ad6f9020284c10a80\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    EXPLAIN not possible on query: UPDATE `zov5y_extensions` SET `params` = '{\"mediaversion\":\"7b7b026aa3f80f0ad6f9020284c10a80\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init for update	0.08 ms
    Updating	0.08 ms
    End of update loop	0.01 ms
    Waiting for query cache lock	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.60 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 1.17 ms After last query: 2.74 ms Query memory: 0.019 MB Memory before query: 2.390 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.68 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.05 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Query Time: 0.67 ms After last query: 23.91 ms Query memory: 0.025 MB Memory before query: 2.607 MB Rows returned: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	1	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	churchofthecreator.s.template,const	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.11 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.14 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    19	JDatabaseDriver->loadObject()	JROOT/plugins/system/t3/includes/core/t3.php:391
    18	T3::getDefaultTemplate()	JROOT/plugins/system/t3/t3.php:282
    17	plgSystemT3->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
    14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/login.php:110
    13	UsersModelLogin->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/login.php:35
    11	UsersModelLogin->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/login/view.html.php:40
    9	UsersViewLogin->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 2.34 ms After last query: 13.00 ms Query memory: 0.026 MB Memory before query: 2.640 MB Rows returned: 1
    Duplicate queries: #17

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	1.46 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.03 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.06 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/components/com_jce/editor/libraries/classes/application.php:202
    20	WFApplication->getProfile()	JROOT/administrator/components/com_jce/helpers/browser.php:74
    19	WfBrowserHelper::getMediaFieldOptions()	JROOT/plugins/system/jce/jce.php:54
    18	PlgSystemJce->getMediaRedirectOptions()	JROOT/plugins/system/jce/jce.php:215
    17	PlgSystemJce->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
    14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/login.php:110
    13	UsersModelLogin->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/login.php:35
    11	UsersModelLogin->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/login/view.html.php:40
    9	UsersViewLogin->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 3.26 ms After last query: 1.84 ms Query memory: 0.027 MB Memory before query: 2.667 MB Rows returned: 0

    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM zov5y_fields AS a
    
      LEFT JOIN `zov5y_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN zov5y_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN zov5y_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN zov5y_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN zov5y_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_users.login' 
      AND a.access IN (1) 
      AND (a.group_id = 0 OR g.access IN (1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access	idx_state	1	const	1	Using where; Using temporary; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	churchofthecreator.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	churchofthecreator.a.checked_out	1
    1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	churchofthecreator.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	churchofthecreator.a.group_id	1	Using where

    Profile

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	1.66 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.03 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.11 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.11 ms
    Preparing	0.05 ms
    Creating tmp table	0.06 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.42 ms
    Creating sort index	0.03 ms
    Removing tmp table	0.10 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    19	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
    18	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
    17	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
    14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/login.php:110
    13	UsersModelLogin->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/login.php:35
    11	UsersModelLogin->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/login/view.html.php:40
    9	UsersViewLogin->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 0.30 ms After last query: 1.51 ms Query memory: 0.028 MB Memory before query: 2.682 MB Rows returned: 1
    Duplicate queries: #15

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.04 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    26	JDatabaseDriver->loadObjectList()	JROOT/components/com_jce/editor/libraries/classes/application.php:202
    25	WFApplication->getProfile()	JROOT/administrator/components/com_jce/helpers/browser.php:74
    24	WfBrowserHelper::getMediaFieldOptions()	JROOT/plugins/system/jce/jce.php:54
    23	PlgSystemJce->getMediaRedirectOptions()	JROOT/plugins/system/jce/jce.php:215
    22	PlgSystemJce->onContentPrepareForm()	JROOT/plugins/system/jce/jce.php:35
    21	PlgSystemJce->onPlgSystemJceContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    18	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/content/jce/jce.php:22
    17	PlgContentJce->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
    14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/login.php:110
    13	UsersModelLogin->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/login.php:35
    11	UsersModelLogin->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/login/view.html.php:40
    9	UsersViewLogin->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 1.98 ms After last query: 26.83 ms Query memory: 0.023 MB Memory before query: 2.856 MB Rows returned: 3

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM zov5y_modules AS m
    
      LEFT JOIN zov5y_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN zov5y_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-23 08:01:44') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-23 08:01:44') 
      AND m.access IN (1) 
      AND m.client_id = 0 
      AND (mm.menuid = 0 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	28	Using where; Using filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	churchofthecreator.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	churchofthecreator.m.id	5	Using where; Using index

    Profile

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	1.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.04 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.08 ms
    Preparing	0.05 ms
    Sorting result	0.02 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.30 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/2015040702/library/Artx/Page.php:46
    8	ArtxPage->containsModules()	JROOT/templates/2015040702/index.php:83
    7	require JROOT/templates/2015040702/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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: 1.20 ms After last query: 2.29 ms Query memory: 0.024 MB Memory before query: 2.916 MB Rows returned: 1

    SELECT `id`
    
      FROM `zov5y_instantpaypal_payment_options`
    
      ORDER BY `sort` ASC

    Explain

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

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.88 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/db.php:132
    16	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:369
    15	InstantpaypalDb->getObjList()	JROOT/administrator/components/com_instantpaypal/framework/paymentoptions.php:35
    14	InstantpaypalPaymentoptions->getPaymentOptions()	JROOT/administrator/components/com_instantpaypal/framework/paymentoptions.php:128
    13	InstantpaypalhelperPaymentoptions::_load()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:34
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.54 ms After last query: 0.33 ms Query memory: 0.025 MB Memory before query: 2.927 MB Rows returned: 1

    SELECT `id`,`payment_method`,`name`,`sort`,`status`,`params`,`fee`,`fee_type`,`info`
    
      FROM `zov5y_instantpaypal_payment_options`
    
      WHERE `id`='1'

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_instantpaypal/framework/db.php:136
    17	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:366
    16	InstantpaypalDb->getObj()	JROOT/administrator/components/com_instantpaypal/framework/paymentoptions.php:47
    15	InstantpaypalPaymentoptions->getPaymentOption()	JROOT/administrator/components/com_instantpaypal/framework/paymentoptions.php:38
    14	InstantpaypalPaymentoptions->getPaymentOptions()	JROOT/administrator/components/com_instantpaypal/framework/paymentoptions.php:128
    13	InstantpaypalhelperPaymentoptions::_load()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:34
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 0.82 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 2.944 MB Rows returned: 1

    SELECT `id`,`name`,`alias`,`class`,`params`,`about`
    
      FROM `zov5y_instantpaypal_payment_methods`
    
      WHERE `id`='1'

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.49 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_instantpaypal/framework/db.php:136
    19	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:366
    18	InstantpaypalDb->getObj()	JROOT/administrator/components/com_instantpaypal/framework/paymentmethods.php:43
    17	InstantpaypalPaymentMethods->getPaymentMethod()	JROOT/administrator/components/com_instantpaypal/framework/paymentmethods.php:67
    16	InstantpaypalhelperPaymentMethods::_load()	JROOT/administrator/components/com_instantpaypal/framework/paymentoptions.php:52
    15	InstantpaypalPaymentoptions->getPaymentOption()	JROOT/administrator/components/com_instantpaypal/framework/paymentoptions.php:38
    14	InstantpaypalPaymentoptions->getPaymentOptions()	JROOT/administrator/components/com_instantpaypal/framework/paymentoptions.php:128
    13	InstantpaypalhelperPaymentoptions::_load()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:34
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.25 ms After last query: 0.20 ms Query memory: 0.023 MB Memory before query: 2.959 MB Rows returned: 4

    SELECT a.id, a.title
    
      FROM zov5y_viewlevels AS a
    
      GROUP BY a.id, a.title, a.ordering
    
      ORDER BY `title` ASC

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.04 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/settings.php:182
    14	InstantpaypalSettings->__construct()	JROOT/administrator/components/com_instantpaypal/framework/settings.php:270
    13	InstantpaypalhelperSettings::_load()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:36
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.91 ms After last query: 0.34 ms Query memory: 0.033 MB Memory before query: 2.969 MB Rows returned: 143

    SELECT c.name, c.code
    
      FROM zov5y_instantpaypal_currencies AS c
    
      ORDER BY `c`.`code` ASC

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.47 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.14 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/settings.php:194
    14	InstantpaypalSettings->__construct()	JROOT/administrator/components/com_instantpaypal/framework/settings.php:270
    13	InstantpaypalhelperSettings::_load()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:36
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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: 0.82 ms After last query: 0.86 ms Query memory: 0.025 MB Memory before query: 3.004 MB Rows returned: 1

    SELECT `id`,`name`,`email`,`language_id`,`template_id`,`ty_title`,`ty_content`,`login_attempts`,`login_delay`,`updates`,`updates_checked`,`address`,`address2`,`city`,`country`,`postcode`,`taxid`,`params`,`timer`,`wiretransfer_details`
    
      FROM `zov5y_instantpaypal_settings`
    
      WHERE `id`='1'

    Explain

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

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.47 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.03 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_instantpaypal/framework/db.php:136
    16	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:366
    15	InstantpaypalDb->getObj()	JROOT/administrator/components/com_instantpaypal/framework/settings.php:207
    14	InstantpaypalSettings->getSettings()	JROOT/administrator/components/com_instantpaypal/framework/settings.php:271
    13	InstantpaypalhelperSettings::_load()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:36
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.68 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 2.995 MB Rows returned: 0
    Duplicate queries: #29  #33  #40  #45  #50  #55

    SELECT `id`,`hash`,`ip`,`time`
    
      FROM `zov5y_instantpaypal_cookies`
    
      WHERE `time`<'1732262504'

    Explain

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

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.39 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    19	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_instantpaypal/framework/db.php:131
    18	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:375
    17	InstantpaypalDb->getAssocList()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:31
    16	InstantpaypalCookies->purgeCookies()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:26
    15	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:83
    14	InstantpaypalhelperCookies::_start()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:43
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Query Time: 0.63 ms After last query: 0.12 ms Query memory: 0.010 MB Memory before query: 3.003 MB
    Duplicate queries: #37

    DELETE 
    
      FROM `zov5y_instantpaypal_uniques`
    
      WHERE `time`<'1732345304'

    Explain

    EXPLAIN not possible on query: DELETE FROM `zov5y_instantpaypal_uniques` WHERE `time`<'1732345304'

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.41 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    init for update	0.02 ms
    Updating	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    20	JDatabase->query()	JROOT/administrator/components/com_instantpaypal/framework/db.php:325
    19	InstantpaypalDb->deleteData()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:188
    18	InstantpaypalFoundation->uniqId()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:43
    17	InstantpaypalCookies->setCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:40
    16	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
    15	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:83
    14	InstantpaypalhelperCookies::_start()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:43
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.21 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 3.013 MB Rows returned: 0

    SELECT `id`
    
      FROM `zov5y_instantpaypal_cookies`
    
      WHERE `hash`='4AGcKXauTFlxQwI5'

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	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 of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    20	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_instantpaypal/framework/db.php:354
    19	InstantpaypalDb->getResult()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:206
    18	InstantpaypalFoundation->uniqId()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:43
    17	InstantpaypalCookies->setCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:40
    16	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
    15	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:83
    14	InstantpaypalhelperCookies::_start()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:43
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.72 ms After last query: 0.13 ms Query memory: 0.009 MB Memory before query: 3.023 MB

    INSERT INTO `zov5y_instantpaypal_cookies`
    (`hash`,`ip`,`time`) 
      VALUES 
    ('4AGcKXauTFlxQwI5','13.59.134.65','1732348904')

    Explain

    EXPLAIN not possible on query: INSERT INTO `zov5y_instantpaypal_cookies` (`hash`,`ip`,`time`) VALUES ('4AGcKXauTFlxQwI5','13.59.134.65','1732348904')

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init for update	0.01 ms
    Update	0.04 ms
    Waiting for query cache lock	0.01 ms
    Update	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.52 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    19	JDatabase->query()	JROOT/administrator/components/com_instantpaypal/framework/db.php:264
    18	InstantpaypalDb->insertData()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:48
    17	InstantpaypalCookies->setCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:40
    16	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
    15	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:83
    14	InstantpaypalhelperCookies::_start()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:43
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.29 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 3.033 MB Rows returned: 0
    Duplicate queries: #25  #33  #40  #45  #50  #55

    SELECT `id`,`hash`,`ip`,`time`
    
      FROM `zov5y_instantpaypal_cookies`
    
      WHERE `time`<'1732262504'

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    19	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_instantpaypal/framework/db.php:131
    18	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:375
    17	InstantpaypalDb->getAssocList()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:31
    16	InstantpaypalCookies->purgeCookies()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:26
    15	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
    14	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:57
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.30 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 3.042 MB Rows returned: 1
    Duplicate queries: #34  #41  #46  #51  #56

    SELECT `id`,`hash`,`ip`,`time`
    
      FROM `zov5y_instantpaypal_cookies`
    
      WHERE `hash`='4AGcKXauTFlxQwI5'

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.10 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    20	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_instantpaypal/framework/db.php:135
    19	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:372
    18	InstantpaypalDb->getAssoc()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:55
    17	InstantpaypalCookies->checkCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:38
    16	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
    15	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
    14	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:57
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.27 ms After last query: 0.13 ms Query memory: 0.009 MB Memory before query: 3.052 MB
    Duplicate queries: #35  #42  #47  #52  #57

    UPDATE `zov5y_instantpaypal_cookies`
    
      SET `time`='1732348904'
    
      WHERE `id`='674806'

    Explain

    EXPLAIN not possible on query: UPDATE `zov5y_instantpaypal_cookies` SET `time`='1732348904' WHERE `id`='674806'

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init for update	0.03 ms
    Updating	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.07 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    19	JDatabase->query()	JROOT/administrator/components/com_instantpaypal/framework/db.php:296
    18	InstantpaypalDb->updateData()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:63
    17	InstantpaypalCookies->checkCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:38
    16	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
    15	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
    14	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:57
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Query Time: 0.98 ms After last query: 0.39 ms Query memory: 0.024 MB Memory before query: 3.069 MB Rows returned: 0

    SELECT `value`
    
      FROM `zov5y_instantpaypal_cookie_vars`
    
      WHERE `cookie`='4AGcKXauTFlxQwI5' 
      AND `name`='cartid'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	zov5y_instantpaypal_cookie_vars	ref	cookie	cookie	50	const	3	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.52 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.13 ms
    End of update loop	0.01 ms
    Query end	0.02 ms
    Commit	0.03 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_instantpaypal/framework/db.php:354
    16	InstantpaypalDb->getResult()	JROOT/administrator/components/com_instantpaypal/framework/cookievars.php:27
    15	InstantpaypalCookievars->getVar()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:90
    14	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:57
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.29 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 3.081 MB Rows returned: 0
    Duplicate queries: #25  #29  #40  #45  #50  #55

    SELECT `id`,`hash`,`ip`,`time`
    
      FROM `zov5y_instantpaypal_cookies`
    
      WHERE `time`<'1732262504'

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    19	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_instantpaypal/framework/db.php:131
    18	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:375
    17	InstantpaypalDb->getAssocList()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:31
    16	InstantpaypalCookies->purgeCookies()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:26
    15	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
    14	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:58
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.28 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 3.091 MB Rows returned: 1
    Duplicate queries: #30  #41  #46  #51  #56

    SELECT `id`,`hash`,`ip`,`time`
    
      FROM `zov5y_instantpaypal_cookies`
    
      WHERE `hash`='4AGcKXauTFlxQwI5'

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    20	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_instantpaypal/framework/db.php:135
    19	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:372
    18	InstantpaypalDb->getAssoc()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:55
    17	InstantpaypalCookies->checkCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:38
    16	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
    15	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
    14	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:58
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.27 ms After last query: 0.13 ms Query memory: 0.009 MB Memory before query: 3.101 MB
    Duplicate queries: #31  #42  #47  #52  #57

    UPDATE `zov5y_instantpaypal_cookies`
    
      SET `time`='1732348904'
    
      WHERE `id`='674806'

    Explain

    EXPLAIN not possible on query: UPDATE `zov5y_instantpaypal_cookies` SET `time`='1732348904' WHERE `id`='674806'

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init for update	0.02 ms
    Updating	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.07 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    19	JDatabase->query()	JROOT/administrator/components/com_instantpaypal/framework/db.php:296
    18	InstantpaypalDb->updateData()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:63
    17	InstantpaypalCookies->checkCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:38
    16	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
    15	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
    14	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:58
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.31 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 3.113 MB Rows returned: 0

    SELECT `value`
    
      FROM `zov5y_instantpaypal_cookie_vars`
    
      WHERE `cookie`='4AGcKXauTFlxQwI5' 
      AND `name`='carthash'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	zov5y_instantpaypal_cookie_vars	ref	cookie	cookie	50	const	3	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.08 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_instantpaypal/framework/db.php:354
    16	InstantpaypalDb->getResult()	JROOT/administrator/components/com_instantpaypal/framework/cookievars.php:27
    15	InstantpaypalCookievars->getVar()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:90
    14	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:58
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Query Time: 0.29 ms After last query: 0.11 ms Query memory: 0.008 MB Memory before query: 3.114 MB
    Duplicate queries: #26

    DELETE 
    
      FROM `zov5y_instantpaypal_uniques`
    
      WHERE `time`<'1732345304'

    Explain

    EXPLAIN not possible on query: DELETE FROM `zov5y_instantpaypal_uniques` WHERE `time`<'1732345304'

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init for update	0.02 ms
    Updating	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.10 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    16	JDatabase->query()	JROOT/administrator/components/com_instantpaypal/framework/db.php:325
    15	InstantpaypalDb->deleteData()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:188
    14	InstantpaypalFoundation->uniqId()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:68
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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: 1.25 ms After last query: 0.34 ms Query memory: 0.024 MB Memory before query: 3.122 MB Rows returned: 0

    SELECT `id`
    
      FROM `zov5y_instantpaypal_carts`
    
      WHERE `hash`='Ngl5Pp'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	zov5y_instantpaypal_carts	const	hash	hash	20	const	1	Using index

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.53 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.40 ms
    Preparing	0.01 ms
    Executing	0.07 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_instantpaypal/framework/db.php:354
    15	InstantpaypalDb->getResult()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:206
    14	InstantpaypalFoundation->uniqId()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:68
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.71 ms After last query: 0.11 ms Query memory: 0.007 MB Memory before query: 3.131 MB

    INSERT INTO `zov5y_instantpaypal_carts`
    (`hash`,`date`,`ip`) 
      VALUES 
    ('Ngl5Pp','2024-11-23 08:01:44','13.59.134.65')

    Explain

    EXPLAIN not possible on query: INSERT INTO `zov5y_instantpaypal_carts` (`hash`,`date`,`ip`) VALUES ('Ngl5Pp','2024-11-23 08:01:44','13.59.134.65')

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init for update	0.01 ms
    Update	0.04 ms
    Waiting for query cache lock	0.00 ms
    Update	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.49 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    15	JDatabase->query()	JROOT/administrator/components/com_instantpaypal/framework/db.php:264
    14	InstantpaypalDb->insertData()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:70
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. Query Time: 0.29 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 3.143 MB Rows returned: 0
    Duplicate queries: #25  #29  #33  #45  #50  #55

    SELECT `id`,`hash`,`ip`,`time`
    
      FROM `zov5y_instantpaypal_cookies`
    
      WHERE `time`<'1732262504'

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    19	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_instantpaypal/framework/db.php:131
    18	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:375
    17	InstantpaypalDb->getAssocList()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:31
    16	InstantpaypalCookies->purgeCookies()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:26
    15	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:95
    14	InstantpaypalhelperCookies::_setVar()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:71
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.30 ms After last query: 0.33 ms Query memory: 0.025 MB Memory before query: 3.152 MB Rows returned: 1
    Duplicate queries: #30  #34  #46  #51  #56

    SELECT `id`,`hash`,`ip`,`time`
    
      FROM `zov5y_instantpaypal_cookies`
    
      WHERE `hash`='4AGcKXauTFlxQwI5'

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    20	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_instantpaypal/framework/db.php:135
    19	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:372
    18	InstantpaypalDb->getAssoc()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:55
    17	InstantpaypalCookies->checkCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:38
    16	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
    15	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:95
    14	InstantpaypalhelperCookies::_setVar()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:71
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.26 ms After last query: 0.12 ms Query memory: 0.009 MB Memory before query: 3.162 MB
    Duplicate queries: #31  #35  #47  #52  #57

    UPDATE `zov5y_instantpaypal_cookies`
    
      SET `time`='1732348904'
    
      WHERE `id`='674806'

    Explain

    EXPLAIN not possible on query: UPDATE `zov5y_instantpaypal_cookies` SET `time`='1732348904' WHERE `id`='674806'

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init for update	0.02 ms
    Updating	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.07 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    19	JDatabase->query()	JROOT/administrator/components/com_instantpaypal/framework/db.php:296
    18	InstantpaypalDb->updateData()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:63
    17	InstantpaypalCookies->checkCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:38
    16	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
    15	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:95
    14	InstantpaypalhelperCookies::_setVar()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:71
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

43. Query Time: 0.34 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 3.175 MB Rows returned: 0

    SELECT `id`
    
      FROM `zov5y_instantpaypal_cookie_vars`
    
      WHERE `cookie`='4AGcKXauTFlxQwI5' 
      AND `name`='carthash'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	zov5y_instantpaypal_cookie_vars	ref	cookie	cookie	50	const	3	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.08 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_instantpaypal/framework/db.php:354
    16	InstantpaypalDb->getResult()	JROOT/administrator/components/com_instantpaypal/framework/cookievars.php:33
    15	InstantpaypalCookievars->setVar()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:97
    14	InstantpaypalhelperCookies::_setVar()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:71
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

44. Query Time: 0.66 ms After last query: 0.13 ms Query memory: 0.009 MB Memory before query: 3.184 MB

    INSERT INTO `zov5y_instantpaypal_cookie_vars`
    (`cookie`,`name`,`value`) 
      VALUES 
    ('4AGcKXauTFlxQwI5','carthash','Ngl5Pp')

    Explain

    EXPLAIN not possible on query: INSERT INTO `zov5y_instantpaypal_cookie_vars` (`cookie`,`name`,`value`) VALUES ('4AGcKXauTFlxQwI5','carthash','Ngl5Pp')

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init for update	0.01 ms
    Update	0.03 ms
    Waiting for query cache lock	0.01 ms
    Update	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.46 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    18	JDatabase->query()	JROOT/administrator/components/com_instantpaypal/framework/db.php:264
    17	InstantpaypalDb->insertData()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:338
    16	InstantpaypalFoundation->saveData()	JROOT/administrator/components/com_instantpaypal/framework/cookievars.php:34
    15	InstantpaypalCookievars->setVar()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:97
    14	InstantpaypalhelperCookies::_setVar()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:71
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

45. Query Time: 0.32 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 3.189 MB Rows returned: 0
    Duplicate queries: #25  #29  #33  #40  #50  #55

    SELECT `id`,`hash`,`ip`,`time`
    
      FROM `zov5y_instantpaypal_cookies`
    
      WHERE `time`<'1732262504'

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    19	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_instantpaypal/framework/db.php:131
    18	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:375
    17	InstantpaypalDb->getAssocList()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:31
    16	InstantpaypalCookies->purgeCookies()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:26
    15	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:95
    14	InstantpaypalhelperCookies::_setVar()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:72
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.30 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 3.198 MB Rows returned: 1
    Duplicate queries: #30  #34  #41  #51  #56

    SELECT `id`,`hash`,`ip`,`time`
    
      FROM `zov5y_instantpaypal_cookies`
    
      WHERE `hash`='4AGcKXauTFlxQwI5'

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    20	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_instantpaypal/framework/db.php:135
    19	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:372
    18	InstantpaypalDb->getAssoc()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:55
    17	InstantpaypalCookies->checkCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:38
    16	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
    15	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:95
    14	InstantpaypalhelperCookies::_setVar()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:72
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

47. Query Time: 0.26 ms After last query: 0.38 ms Query memory: 0.009 MB Memory before query: 3.208 MB
    Duplicate queries: #31  #35  #42  #52  #57

    UPDATE `zov5y_instantpaypal_cookies`
    
      SET `time`='1732348904'
    
      WHERE `id`='674806'

    Explain

    EXPLAIN not possible on query: UPDATE `zov5y_instantpaypal_cookies` SET `time`='1732348904' WHERE `id`='674806'

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init for update	0.02 ms
    Updating	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.07 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    19	JDatabase->query()	JROOT/administrator/components/com_instantpaypal/framework/db.php:296
    18	InstantpaypalDb->updateData()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:63
    17	InstantpaypalCookies->checkCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:38
    16	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
    15	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:95
    14	InstantpaypalhelperCookies::_setVar()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:72
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

48. Query Time: 0.36 ms After last query: 0.28 ms Query memory: 0.024 MB Memory before query: 3.221 MB Rows returned: 0

    SELECT `id`
    
      FROM `zov5y_instantpaypal_cookie_vars`
    
      WHERE `cookie`='4AGcKXauTFlxQwI5' 
      AND `name`='cartid'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	zov5y_instantpaypal_cookie_vars	ref	cookie	cookie	50	const	3	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.12 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_instantpaypal/framework/db.php:354
    16	InstantpaypalDb->getResult()	JROOT/administrator/components/com_instantpaypal/framework/cookievars.php:33
    15	InstantpaypalCookievars->setVar()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:97
    14	InstantpaypalhelperCookies::_setVar()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:72
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.62 ms After last query: 0.11 ms Query memory: 0.009 MB Memory before query: 3.230 MB

    INSERT INTO `zov5y_instantpaypal_cookie_vars`
    (`cookie`,`name`,`value`) 
      VALUES 
    ('4AGcKXauTFlxQwI5','cartid','672272')

    Explain

    EXPLAIN not possible on query: INSERT INTO `zov5y_instantpaypal_cookie_vars` (`cookie`,`name`,`value`) VALUES ('4AGcKXauTFlxQwI5','cartid','672272')

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init for update	0.01 ms
    Update	0.03 ms
    Waiting for query cache lock	0.01 ms
    Update	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.42 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    18	JDatabase->query()	JROOT/administrator/components/com_instantpaypal/framework/db.php:264
    17	InstantpaypalDb->insertData()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:338
    16	InstantpaypalFoundation->saveData()	JROOT/administrator/components/com_instantpaypal/framework/cookievars.php:34
    15	InstantpaypalCookievars->setVar()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:97
    14	InstantpaypalhelperCookies::_setVar()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:72
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

50. Query Time: 0.32 ms After last query: 1.03 ms Query memory: 0.026 MB Memory before query: 3.307 MB Rows returned: 0
    Duplicate queries: #25  #29  #33  #40  #45  #55

    SELECT `id`,`hash`,`ip`,`time`
    
      FROM `zov5y_instantpaypal_cookies`
    
      WHERE `time`<'1732262504'

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.10 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    22	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_instantpaypal/framework/db.php:131
    21	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:375
    20	InstantpaypalDb->getAssocList()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:31
    19	InstantpaypalCookies->purgeCookies()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:26
    18	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
    17	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:41
    16	InstantpaypalCurrencies->getActiveCurrency()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:127
    15	InstantpaypalhelperCurrencies::_getActive()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:77
    14	InstantpaypalCart->buildCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:73
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

51. Query Time: 0.29 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 3.317 MB Rows returned: 1
    Duplicate queries: #30  #34  #41  #46  #56

    SELECT `id`,`hash`,`ip`,`time`
    
      FROM `zov5y_instantpaypal_cookies`
    
      WHERE `hash`='4AGcKXauTFlxQwI5'

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    23	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_instantpaypal/framework/db.php:135
    22	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:372
    21	InstantpaypalDb->getAssoc()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:55
    20	InstantpaypalCookies->checkCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:38
    19	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
    18	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
    17	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:41
    16	InstantpaypalCurrencies->getActiveCurrency()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:127
    15	InstantpaypalhelperCurrencies::_getActive()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:77
    14	InstantpaypalCart->buildCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:73
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.28 ms After last query: 0.30 ms Query memory: 0.010 MB Memory before query: 3.328 MB
    Duplicate queries: #31  #35  #42  #47  #57

    UPDATE `zov5y_instantpaypal_cookies`
    
      SET `time`='1732348904'
    
      WHERE `id`='674806'

    Explain

    EXPLAIN not possible on query: UPDATE `zov5y_instantpaypal_cookies` SET `time`='1732348904' WHERE `id`='674806'

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init for update	0.04 ms
    Updating	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.07 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    22	JDatabase->query()	JROOT/administrator/components/com_instantpaypal/framework/db.php:296
    21	InstantpaypalDb->updateData()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:63
    20	InstantpaypalCookies->checkCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:38
    19	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
    18	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
    17	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:41
    16	InstantpaypalCurrencies->getActiveCurrency()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:127
    15	InstantpaypalhelperCurrencies::_getActive()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:77
    14	InstantpaypalCart->buildCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:73
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.33 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 3.341 MB Rows returned: 0

    SELECT `value`
    
      FROM `zov5y_instantpaypal_cookie_vars`
    
      WHERE `cookie`='4AGcKXauTFlxQwI5' 
      AND `name`='currency'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	zov5y_instantpaypal_cookie_vars	ref	cookie	cookie	50	const	3	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    20	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_instantpaypal/framework/db.php:354
    19	InstantpaypalDb->getResult()	JROOT/administrator/components/com_instantpaypal/framework/cookievars.php:27
    18	InstantpaypalCookievars->getVar()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:90
    17	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:41
    16	InstantpaypalCurrencies->getActiveCurrency()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:127
    15	InstantpaypalhelperCurrencies::_getActive()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:77
    14	InstantpaypalCart->buildCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:73
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

54. Query Time: 0.36 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 3.343 MB Rows returned: 1

    SELECT `id`
    
      FROM `zov5y_instantpaypal_currencies`
    
      WHERE `default`='1'

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.13 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    20	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_instantpaypal/framework/db.php:354
    19	InstantpaypalDb->getResult()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:81
    18	InstantpaypalCurrencies->getDefaultCurrency()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:58
    17	InstantpaypalCurrencies->setActiveCurrency()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:42
    16	InstantpaypalCurrencies->getActiveCurrency()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:127
    15	InstantpaypalhelperCurrencies::_getActive()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:77
    14	InstantpaypalCart->buildCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:73
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

55. Query Time: 0.60 ms After last query: 0.11 ms Query memory: 0.026 MB Memory before query: 3.358 MB Rows returned: 0
    Duplicate queries: #25  #29  #33  #40  #45  #50

    SELECT `id`,`hash`,`ip`,`time`
    
      FROM `zov5y_instantpaypal_cookies`
    
      WHERE `time`<'1732262504'

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    23	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_instantpaypal/framework/db.php:131
    22	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:375
    21	InstantpaypalDb->getAssocList()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:31
    20	InstantpaypalCookies->purgeCookies()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:26
    19	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:95
    18	InstantpaypalhelperCookies::_setVar()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:59
    17	InstantpaypalCurrencies->setActiveCurrency()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:42
    16	InstantpaypalCurrencies->getActiveCurrency()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:127
    15	InstantpaypalhelperCurrencies::_getActive()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:77
    14	InstantpaypalCart->buildCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:73
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

56. Query Time: 0.32 ms After last query: 0.08 ms Query memory: 0.027 MB Memory before query: 3.369 MB Rows returned: 1
    Duplicate queries: #30  #34  #41  #46  #51

    SELECT `id`,`hash`,`ip`,`time`
    
      FROM `zov5y_instantpaypal_cookies`
    
      WHERE `hash`='4AGcKXauTFlxQwI5'

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.12 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    24	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_instantpaypal/framework/db.php:135
    23	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:372
    22	InstantpaypalDb->getAssoc()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:55
    21	InstantpaypalCookies->checkCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:38
    20	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
    19	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:95
    18	InstantpaypalhelperCookies::_setVar()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:59
    17	InstantpaypalCurrencies->setActiveCurrency()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:42
    16	InstantpaypalCurrencies->getActiveCurrency()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:127
    15	InstantpaypalhelperCurrencies::_getActive()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:77
    14	InstantpaypalCart->buildCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:73
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

57. Query Time: 0.26 ms After last query: 0.13 ms Query memory: 0.011 MB Memory before query: 3.380 MB
    Duplicate queries: #31  #35  #42  #47  #52

    UPDATE `zov5y_instantpaypal_cookies`
    
      SET `time`='1732348904'
    
      WHERE `id`='674806'

    Explain

    EXPLAIN not possible on query: UPDATE `zov5y_instantpaypal_cookies` SET `time`='1732348904' WHERE `id`='674806'

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init for update	0.02 ms
    Updating	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.07 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    23	JDatabase->query()	JROOT/administrator/components/com_instantpaypal/framework/db.php:296
    22	InstantpaypalDb->updateData()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:63
    21	InstantpaypalCookies->checkCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:38
    20	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
    19	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:95
    18	InstantpaypalhelperCookies::_setVar()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:59
    17	InstantpaypalCurrencies->setActiveCurrency()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:42
    16	InstantpaypalCurrencies->getActiveCurrency()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:127
    15	InstantpaypalhelperCurrencies::_getActive()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:77
    14	InstantpaypalCart->buildCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:73
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

58. Query Time: 0.33 ms After last query: 0.09 ms Query memory: 0.026 MB Memory before query: 3.394 MB Rows returned: 0

    SELECT `id`
    
      FROM `zov5y_instantpaypal_cookie_vars`
    
      WHERE `cookie`='4AGcKXauTFlxQwI5' 
      AND `name`='currency'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	zov5y_instantpaypal_cookie_vars	ref	cookie	cookie	50	const	3	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_instantpaypal/framework/db.php:354
    20	InstantpaypalDb->getResult()	JROOT/administrator/components/com_instantpaypal/framework/cookievars.php:33
    19	InstantpaypalCookievars->setVar()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:97
    18	InstantpaypalhelperCookies::_setVar()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:59
    17	InstantpaypalCurrencies->setActiveCurrency()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:42
    16	InstantpaypalCurrencies->getActiveCurrency()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:127
    15	InstantpaypalhelperCurrencies::_getActive()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:77
    14	InstantpaypalCart->buildCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:73
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

59. Query Time: 0.65 ms After last query: 0.14 ms Query memory: 0.010 MB Memory before query: 3.404 MB

    INSERT INTO `zov5y_instantpaypal_cookie_vars`
    (`cookie`,`name`,`value`) 
      VALUES 
    ('4AGcKXauTFlxQwI5','currency','144')

    Explain

    EXPLAIN not possible on query: INSERT INTO `zov5y_instantpaypal_cookie_vars` (`cookie`,`name`,`value`) VALUES ('4AGcKXauTFlxQwI5','currency','144')

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init for update	0.01 ms
    Update	0.03 ms
    Waiting for query cache lock	0.01 ms
    Update	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.44 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    22	JDatabase->query()	JROOT/administrator/components/com_instantpaypal/framework/db.php:264
    21	InstantpaypalDb->insertData()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:338
    20	InstantpaypalFoundation->saveData()	JROOT/administrator/components/com_instantpaypal/framework/cookievars.php:34
    19	InstantpaypalCookievars->setVar()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:97
    18	InstantpaypalhelperCookies::_setVar()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:59
    17	InstantpaypalCurrencies->setActiveCurrency()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:42
    16	InstantpaypalCurrencies->getActiveCurrency()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:127
    15	InstantpaypalhelperCurrencies::_getActive()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:77
    14	InstantpaypalCart->buildCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:73
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

60. Query Time: 0.33 ms After last query: 0.36 ms Query memory: 0.025 MB Memory before query: 3.408 MB Rows returned: 1

    SELECT `id`,`name`,`code`,`symbol`,`status`,`default`,`xe`,`decimals`,`thousands`,`separator`,`checked`
    
      FROM `zov5y_instantpaypal_currencies`
    
      WHERE `id`='144'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	zov5y_instantpaypal_currencies	const	PRIMARY	PRIMARY	2	const	1

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Unlocking tables	0.07 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_instantpaypal/framework/db.php:136
    18	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:366
    17	InstantpaypalDb->getObj()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:72
    16	InstantpaypalCurrencies->getCurrency()	JROOT/administrator/components/com_instantpaypal/framework/currencies.php:128
    15	InstantpaypalhelperCurrencies::_getActive()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:77
    14	InstantpaypalCart->buildCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:73
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

61. Query Time: 1.11 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 3.421 MB Rows returned: 0
    Duplicate queries: #63

    SELECT `id`
    
      FROM `zov5y_instantpaypal_cart_items`
    
      WHERE `cart_id`='672272' 
      AND `hash`='Ngl5Pp'

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.60 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.25 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/db.php:132
    19	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:369
    18	InstantpaypalDb->getObjList()	JROOT/administrator/components/com_instantpaypal/framework/cartitems.php:44
    17	InstantpaypalCartitems->getItemsCount()	JROOT/administrator/components/com_instantpaypal/framework/cartitems.php:66
    16	InstantpaypalCartitems->getItems()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:263
    15	InstantpaypalCart->getItems()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:79
    14	InstantpaypalCart->buildCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:73
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

62. Query Time: 0.83 ms After last query: 0.44 ms Query memory: 0.026 MB Memory before query: 3.438 MB Rows returned: 0

    SELECT `id`
    
      FROM `zov5y_instantpaypal_cart_coupons`
    
      WHERE `status`='1'

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.52 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.08 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.16 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/db.php:132
    20	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:369
    19	InstantpaypalDb->getObjList()	JROOT/administrator/components/com_instantpaypal/framework/cartcoupons.php:40
    18	InstantpaypalCartcoupons->getCodes()	JROOT/administrator/components/com_instantpaypal/framework/cartitems.php:57
    17	InstantpaypalCartitems->getItemsCount()	JROOT/administrator/components/com_instantpaypal/framework/cartitems.php:66
    16	InstantpaypalCartitems->getItems()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:263
    15	InstantpaypalCart->getItems()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:79
    14	InstantpaypalCart->buildCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:73
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

63. Query Time: 0.51 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 3.445 MB Rows returned: 0
    Duplicate queries: #61

    SELECT `id`
    
      FROM `zov5y_instantpaypal_cart_items`
    
      WHERE `cart_id`='672272' 
      AND `hash`='Ngl5Pp'

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.31 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.75 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/db.php:132
    18	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:369
    17	InstantpaypalDb->getObjList()	JROOT/administrator/components/com_instantpaypal/framework/cartitems.php:68
    16	InstantpaypalCartitems->getItems()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:263
    15	InstantpaypalCart->getItems()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:79
    14	InstantpaypalCart->buildCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:73
    13	InstantpaypalCart->startCart()	JROOT/administrator/components/com_instantpaypal/framework/cart.php:38
    12	InstantpaypalCart->__construct()	JROOT/modules/mod_instantpaypal_cart/helper.php:16
    11	ModInstantpaypalCartHelper->getCart()	JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php:20
    10	include JROOT/modules/mod_instantpaypal_cart/mod_instantpaypal_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---