{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1732184452,
                "last": 1732184452,
                "now": 1732184452
            },
            "token": "xnNroLGYeeRD0eS09dwqtT6roy41FrI5"
        },
        "registry": {
            "users": {
                "login": {
                    "form": {
                        "data": {
                            "return": "https://old.churchofthecreator.com/office-of-the-christ/christ-michael/order-of-michael"
                        }
                    }
                }
            }
        },
        "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
        },
        "application": {
            "queue": []
        }
    }
}

Time

Memory

55 Queries Logged 22.78 ms

1. Query Time: 0.34 ms Query memory: 0.023 MB Memory before query: 1.032 MB Rows returned: 1

   SELECT `data`
   
     FROM `zov5y_session`
   
     WHERE `session_id` = X'66316e686d36766e3571656f757534306f6165673867396d3634'

   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.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	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.05 ms
   Preparing	0.01 ms
   Unlocking tables	0.02 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.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 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.25 ms After last query: 1.09 ms Query memory: 0.021 MB Memory before query: 1.124 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.02 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
   Executing	0.00 ms
   Sending data	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
   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.]

   ---

3. Query Time: 0.37 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 1.136 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.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.06 ms
   Preparing	0.01 ms
   Unlocking tables	0.03 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.04 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 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.01 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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.]

   ---

4. Query Time: 0.34 ms After last query: 2.00 ms Query memory: 0.021 MB Memory before query: 1.453 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.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.02 ms
   Optimizing	0.02 ms
   Statistics	0.06 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.05 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: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.]

   ---

5. Query Time: 0.38 ms After last query: 16.47 ms Query memory: 0.005 MB Memory before query: 2.480 MB

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.05 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 for update	0.08 ms
   Updating	0.05 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.03 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.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.]

   ---

6. Query Time: 0.46 ms After last query: 3.13 ms Query memory: 0.025 MB Memory before query: 2.715 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.06 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.03 ms
   Statistics	0.09 ms
   Preparing	0.04 ms
   Executing	0.01 ms
   Sending data	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.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/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.]

   ---

7. Query Time: 0.33 ms After last query: 4.16 ms Query memory: 0.026 MB Memory before query: 2.748 MB Rows returned: 1
   Duplicate queries: #9

   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.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.01 ms
   Preparing	0.01 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	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.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.]

   ---

8. Query Time: 1.18 ms After last query: 0.50 ms Query memory: 0.027 MB Memory before query: 2.774 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.13 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.03 ms
   Statistics	0.09 ms
   Preparing	0.04 ms
   Creating tmp table	0.06 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.44 ms
   Creating sort index	0.03 ms
   Removing tmp table	0.09 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
   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.]

   ---

9. Query Time: 0.31 ms After last query: 1.42 ms Query memory: 0.028 MB Memory before query: 2.789 MB Rows returned: 1
   Duplicate queries: #7

   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.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.01 ms
   Preparing	0.01 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.05 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
   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.]

   ---

10. Query Time: 0.98 ms After last query: 8.64 ms Query memory: 0.024 MB Memory before query: 2.964 MB Rows returned: 6

    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-21 10:20:52') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-21 10:20:52') 
      AND m.access IN (1) 
      AND m.client_id = 0 
      AND (mm.menuid = 101 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.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.05 ms
    Optimizing	0.05 ms
    Statistics	0.10 ms
    Preparing	0.05 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    Creating sort index	0.34 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.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.]

    ---

11. Query Time: 0.30 ms After last query: 1.97 ms Query memory: 0.024 MB Memory before query: 3.037 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.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
    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.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: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.]

    ---

12. Query Time: 0.30 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 3.048 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.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.05 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
    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.]

    ---

13. Query Time: 0.26 ms After last query: 0.15 ms Query memory: 0.025 MB Memory before query: 3.066 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.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.02 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.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 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.]

    ---

14. Query Time: 0.32 ms After last query: 0.18 ms Query memory: 0.023 MB Memory before query: 3.081 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.05 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: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.]

    ---

15. Query Time: 0.41 ms After last query: 0.07 ms Query memory: 0.033 MB Memory before query: 3.090 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.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
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.15 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
    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.]

    ---

16. Query Time: 0.32 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 3.125 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.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.01 ms
    Unlocking tables	0.02 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.04 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.]

    ---

17. Query Time: 0.32 ms After last query: 0.19 ms Query memory: 0.026 MB Memory before query: 3.118 MB Rows returned: 0
    Duplicate queries: #21  #25  #32  #37  #42  #47

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

    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	103	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.07 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
    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.]

    ---

18. Query Time: 0.26 ms After last query: 0.12 ms Query memory: 0.010 MB Memory before query: 3.127 MB
    Duplicate queries: #29

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

    Explain

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

    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.00 ms
    Commit	0.02 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.05 ms
    Reset for next command	0.02 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.]

    ---

19. Query Time: 0.33 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 3.137 MB Rows returned: 0

    SELECT `id`
    
      FROM `zov5y_instantpaypal_cookies`
    
      WHERE `hash`='Sc6qBPjXHrAntOdz'

    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	103	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.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.04 ms
    Starting cleanup	0.02 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
    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.]

    ---

20. Query Time: 0.64 ms After last query: 0.13 ms Query memory: 0.009 MB Memory before query: 3.147 MB

    INSERT INTO `zov5y_instantpaypal_cookies`
    (`hash`,`ip`,`time`) 
      VALUES 
    ('Sc6qBPjXHrAntOdz','18.188.140.232','1732184452')

    Explain

    EXPLAIN not possible on query: INSERT INTO `zov5y_instantpaypal_cookies` (`hash`,`ip`,`time`) VALUES ('Sc6qBPjXHrAntOdz','18.188.140.232','1732184452')

    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.06 ms
    Waiting for query cache lock	0.01 ms
    Update	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.39 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.02 ms
    Reset for next command	0.01 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.]

    ---

21. Query Time: 0.31 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 3.157 MB Rows returned: 0
    Duplicate queries: #17  #25  #32  #37  #42  #47

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

    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	103	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.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.03 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: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.]

    ---

22. Query Time: 0.33 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 3.166 MB Rows returned: 1
    Duplicate queries: #26  #33  #38  #43  #48

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

    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	103	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.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.04 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Reset for next command	0.01 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.]

    ---

23. Query Time: 0.28 ms After last query: 0.16 ms Query memory: 0.009 MB Memory before query: 3.176 MB
    Duplicate queries: #27  #34  #39  #44  #49

    UPDATE `zov5y_instantpaypal_cookies`
    
      SET `time`='1732184452'
    
      WHERE `id`='674783'

    Explain

    EXPLAIN not possible on query: UPDATE `zov5y_instantpaypal_cookies` SET `time`='1732184452' WHERE `id`='674783'

    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.02 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.06 ms
    Reset for next command	0.01 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.]

    ---

24. Query Time: 0.36 ms After last query: 0.14 ms Query memory: 0.024 MB Memory before query: 3.192 MB Rows returned: 0

    SELECT `value`
    
      FROM `zov5y_instantpaypal_cookie_vars`
    
      WHERE `cookie`='Sc6qBPjXHrAntOdz' 
      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.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	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.04 ms
    Starting cleanup	0.02 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: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.]

    ---

25. Query Time: 0.27 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 3.198 MB Rows returned: 0
    Duplicate queries: #17  #21  #32  #37  #42  #47

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

    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	103	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.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.00 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: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.]

    ---

26. Query Time: 0.27 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 3.207 MB Rows returned: 1
    Duplicate queries: #22  #33  #38  #43  #48

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

    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	103	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.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
    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.]

    ---

27. Query Time: 0.21 ms After last query: 0.12 ms Query memory: 0.009 MB Memory before query: 3.217 MB
    Duplicate queries: #23  #34  #39  #44  #49

    UPDATE `zov5y_instantpaypal_cookies`
    
      SET `time`='1732184452'
    
      WHERE `id`='674783'

    Explain

    EXPLAIN not possible on query: UPDATE `zov5y_instantpaypal_cookies` SET `time`='1732184452' WHERE `id`='674783'

    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.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/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.]

    ---

28. Query Time: 0.34 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 3.229 MB Rows returned: 0

    SELECT `value`
    
      FROM `zov5y_instantpaypal_cookie_vars`
    
      WHERE `cookie`='Sc6qBPjXHrAntOdz' 
      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.06 ms
    Executing	0.01 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: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.]

    ---

29. Query Time: 0.21 ms After last query: 0.11 ms Query memory: 0.008 MB Memory before query: 3.230 MB
    Duplicate queries: #18

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

    Explain

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

    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.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.02 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.]

    ---

30. Query Time: 2.83 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 3.239 MB Rows returned: 0

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

    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.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	2.61 ms
    Preparing	0.01 ms
    Executing	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.02 ms
    Reset for next command	0.01 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.]

    ---

31. Query Time: 0.57 ms After last query: 0.11 ms Query memory: 0.007 MB Memory before query: 3.247 MB

    INSERT INTO `zov5y_instantpaypal_carts`
    (`hash`,`date`,`ip`) 
      VALUES 
    ('dm6OkP','2024-11-21 10:20:52','18.188.140.232')

    Explain

    EXPLAIN not possible on query: INSERT INTO `zov5y_instantpaypal_carts` (`hash`,`date`,`ip`) VALUES ('dm6OkP','2024-11-21 10:20:52','18.188.140.232')

    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.02 ms
    Update	0.05 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.34 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.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.]

    ---

32. Query Time: 0.31 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 3.259 MB Rows returned: 0
    Duplicate queries: #17  #21  #25  #37  #42  #47

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

    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	103	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.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.03 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: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.]

    ---

33. Query Time: 0.33 ms After last query: 0.08 ms Query memory: 0.027 MB Memory before query: 3.275 MB Rows returned: 1
    Duplicate queries: #22  #26  #38  #43  #48

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

    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	103	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.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.03 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
    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.]

    ---

34. Query Time: 0.27 ms After last query: 0.12 ms Query memory: 0.009 MB Memory before query: 3.286 MB
    Duplicate queries: #23  #27  #39  #44  #49

    UPDATE `zov5y_instantpaypal_cookies`
    
      SET `time`='1732184452'
    
      WHERE `id`='674783'

    Explain

    EXPLAIN not possible on query: UPDATE `zov5y_instantpaypal_cookies` SET `time`='1732184452' WHERE `id`='674783'

    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.02 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.07 ms
    Reset for next command	0.01 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.]

    ---

35. Query Time: 0.33 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 3.299 MB Rows returned: 0

    SELECT `id`
    
      FROM `zov5y_instantpaypal_cookie_vars`
    
      WHERE `cookie`='Sc6qBPjXHrAntOdz' 
      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.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.03 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	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.04 ms
    Starting cleanup	0.02 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: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.]

    ---

36. Query Time: 0.48 ms After last query: 0.14 ms Query memory: 0.009 MB Memory before query: 3.308 MB

    INSERT INTO `zov5y_instantpaypal_cookie_vars`
    (`cookie`,`name`,`value`) 
      VALUES 
    ('Sc6qBPjXHrAntOdz','carthash','dm6OkP')

    Explain

    EXPLAIN not possible on query: INSERT INTO `zov5y_instantpaypal_cookie_vars` (`cookie`,`name`,`value`) VALUES ('Sc6qBPjXHrAntOdz','carthash','dm6OkP')

    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.28 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.02 ms
    Reset for next command	0.01 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.]

    ---

37. Query Time: 0.30 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 3.313 MB Rows returned: 0
    Duplicate queries: #17  #21  #25  #32  #42  #47

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

    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	103	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.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.03 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: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.]

    ---

38. Query Time: 0.32 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 3.322 MB Rows returned: 1
    Duplicate queries: #22  #26  #33  #43  #48

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

    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	103	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.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.03 ms
    Freeing items	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.01 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.]

    ---

39. Query Time: 0.25 ms After last query: 0.12 ms Query memory: 0.009 MB Memory before query: 3.332 MB
    Duplicate queries: #23  #27  #34  #44  #49

    UPDATE `zov5y_instantpaypal_cookies`
    
      SET `time`='1732184452'
    
      WHERE `id`='674783'

    Explain

    EXPLAIN not possible on query: UPDATE `zov5y_instantpaypal_cookies` SET `time`='1732184452' WHERE `id`='674783'

    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.02 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.04 ms
    Reset for next command	0.01 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.]

    ---

40. Query Time: 0.37 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 3.344 MB Rows returned: 0

    SELECT `id`
    
      FROM `zov5y_instantpaypal_cookie_vars`
    
      WHERE `cookie`='Sc6qBPjXHrAntOdz' 
      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.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.03 ms
    Preparing	0.06 ms
    Executing	0.01 ms
    Sending data	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.03 ms
    Updating status	0.03 ms
    Reset for next command	0.01 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.]

    ---

41. Query Time: 0.56 ms After last query: 0.11 ms Query memory: 0.009 MB Memory before query: 3.354 MB

    INSERT INTO `zov5y_instantpaypal_cookie_vars`
    (`cookie`,`name`,`value`) 
      VALUES 
    ('Sc6qBPjXHrAntOdz','cartid','672249')

    Explain

    EXPLAIN not possible on query: INSERT INTO `zov5y_instantpaypal_cookie_vars` (`cookie`,`name`,`value`) VALUES ('Sc6qBPjXHrAntOdz','cartid','672249')

    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.03 ms
    Update	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.32 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
    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.]

    ---

42. Query Time: 0.31 ms After last query: 0.19 ms Query memory: 0.026 MB Memory before query: 3.368 MB Rows returned: 0
    Duplicate queries: #17  #21  #25  #32  #37  #47

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

    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	103	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.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.04 ms
    Reset for next command	0.01 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.]

    ---

43. Query Time: 0.33 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 3.378 MB Rows returned: 1
    Duplicate queries: #22  #26  #33  #38  #48

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

    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	103	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.07 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.05 ms
    Reset for next command	0.01 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.]

    ---

44. Query Time: 0.29 ms After last query: 0.12 ms Query memory: 0.010 MB Memory before query: 3.389 MB
    Duplicate queries: #23  #27  #34  #39  #49

    UPDATE `zov5y_instantpaypal_cookies`
    
      SET `time`='1732184452'
    
      WHERE `id`='674783'

    Explain

    EXPLAIN not possible on query: UPDATE `zov5y_instantpaypal_cookies` SET `time`='1732184452' WHERE `id`='674783'

    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.05 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.02 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.06 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: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.]

    ---

45. Query Time: 0.32 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 3.403 MB Rows returned: 0

    SELECT `value`
    
      FROM `zov5y_instantpaypal_cookie_vars`
    
      WHERE `cookie`='Sc6qBPjXHrAntOdz' 
      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.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.03 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	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.02 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Reset for next command	0.01 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.]

    ---

46. Query Time: 0.32 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 3.405 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.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.03 ms
    Updating status	0.02 ms
    Reset for next command	0.01 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.]

    ---

47. Query Time: 0.31 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 3.419 MB Rows returned: 0
    Duplicate queries: #17  #21  #25  #32  #37  #42

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

    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	103	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.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.03 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: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.]

    ---

48. Query Time: 0.31 ms After last query: 0.08 ms Query memory: 0.027 MB Memory before query: 3.430 MB Rows returned: 1
    Duplicate queries: #22  #26  #33  #38  #43

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

    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	103	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.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.03 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
    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.]

    ---

49. Query Time: 0.27 ms After last query: 0.12 ms Query memory: 0.011 MB Memory before query: 3.441 MB
    Duplicate queries: #23  #27  #34  #39  #44

    UPDATE `zov5y_instantpaypal_cookies`
    
      SET `time`='1732184452'
    
      WHERE `id`='674783'

    Explain

    EXPLAIN not possible on query: UPDATE `zov5y_instantpaypal_cookies` SET `time`='1732184452' WHERE `id`='674783'

    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.02 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.04 ms
    Reset for next command	0.01 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.]

    ---

50. Query Time: 0.31 ms After last query: 0.09 ms Query memory: 0.026 MB Memory before query: 3.455 MB Rows returned: 0

    SELECT `id`
    
      FROM `zov5y_instantpaypal_cookie_vars`
    
      WHERE `cookie`='Sc6qBPjXHrAntOdz' 
      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.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	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.03 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: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.]

    ---

51. Query Time: 0.55 ms After last query: 0.11 ms Query memory: 0.010 MB Memory before query: 3.466 MB

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

    Explain

    EXPLAIN not possible on query: INSERT INTO `zov5y_instantpaypal_cookie_vars` (`cookie`,`name`,`value`) VALUES ('Sc6qBPjXHrAntOdz','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.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.33 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 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.]

    ---

52. Query Time: 0.33 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 3.470 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.02 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.03 ms
    Updating status	0.04 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.]

    ---

53. Query Time: 0.50 ms After last query: 0.15 ms Query memory: 0.025 MB Memory before query: 3.482 MB Rows returned: 0
    Duplicate queries: #55

    SELECT `id`
    
      FROM `zov5y_instantpaypal_cart_items`
    
      WHERE `cart_id`='672249' 
      AND `hash`='dm6OkP'

    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.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.23 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.03 ms
    Updating status	0.04 ms
    Reset for next command	0.01 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.]

    ---

54. Query Time: 0.28 ms After last query: 0.14 ms Query memory: 0.026 MB Memory before query: 3.500 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.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.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.04 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/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.]

    ---

55. Query Time: 0.47 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 3.506 MB Rows returned: 0
    Duplicate queries: #53

    SELECT `id`
    
      FROM `zov5y_instantpaypal_cart_items`
    
      WHERE `cart_id`='672249' 
      AND `hash`='dm6OkP'

    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.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.22 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.01 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Reset for next command	0.00 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.]

    ---