Manifesting Heaven On Earth

“…giving liberates the soul of the giver.” - Maya Angelou

“For it is in giving that we receive.” ― St. Francis of Assisi

“Kindness in giving creates love.” ― Lao Tzu

"Being willing is not enough, we must do." — Leonardo da Vinci

“Never believe that a few caring people can’t change the world. For, indeed, that’s all who ever have.” — Margaret Mead

You are here: Home

COTC eStore

Home
Contributions

Contributions

Cash Contributions to Specific Funds

$0.00

Details

Contribute -

One Time Cash Contribution - Tax Deductible - Select $ amount, select quantity. Add to Cart. Total Contribution = $ selected x Quantity selected.

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1728702429,
                "last": 1728702429,
                "now": 1728702429
            },
            "token": "4YEh6ebmo2BMqKx8rJ7XmwFbTUawlXgj"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

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

#	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

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

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

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

Profile

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

Call Stack

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

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

Query Time: 0.34 ms After last query: 6.11 ms Query memory: 0.021 MB Memory before query: 1.123 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

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

Call Stack

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

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

Query Time: 0.40 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 1.135 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

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

Call Stack

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

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

Query Time: 0.40 ms After last query: 4.79 ms Query memory: 0.021 MB Memory before query: 1.515 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

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.]

Query Time: 0.34 ms After last query: 17.33 ms Query memory: 0.021 MB Memory before query: 2.411 MB Rows returned: 1

Duplicate queries: #42 #64 #88 #165 #166

SELECT `params`

  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

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_instantpaypal/router.php:295
10	InstantpaypalRouter->loadParams()	JROOT/components/com_instantpaypal/router.php:464
9	InstantpaypalRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.80 ms After last query: 3.38 ms Query memory: 0.005 MB Memory before query: 2.488 MB

UPDATE `zov5y_extensions`

  SET `params` = '{\"mediaversion\":\"1e631ba0426ee2bff3c28ed2e70cb50c\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
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.]

Query Time: 0.41 ms After last query: 1.68 ms Query memory: 0.022 MB Memory before query: 2.601 MB Rows returned: 4

Duplicate queries: #14 #37 #44 #46 #50 #52 #84 #86 #89 #91 #93 #95 #113 #115 #117

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

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/settings.php:182
9	InstantpaypalSettings->__construct()	JROOT/administrator/components/com_instantpaypal/framework/settings.php:270
8	InstantpaypalhelperSettings::_load()	JROOT/components/com_instantpaypal/controller.php:17
7	InstantpaypalController->__construct()	JROOT/components/com_instantpaypal/instantpaypal.php:35
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.43 ms After last query: 0.07 ms Query memory: 0.031 MB Memory before query: 2.608 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

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/settings.php:194
9	InstantpaypalSettings->__construct()	JROOT/administrator/components/com_instantpaypal/framework/settings.php:270
8	InstantpaypalhelperSettings::_load()	JROOT/components/com_instantpaypal/controller.php:17
7	InstantpaypalController->__construct()	JROOT/components/com_instantpaypal/instantpaypal.php:35
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.37 ms After last query: 0.20 ms Query memory: 0.022 MB Memory before query: 2.642 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

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_instantpaypal/framework/db.php:136
11	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:366
10	InstantpaypalDb->getObj()	JROOT/administrator/components/com_instantpaypal/framework/settings.php:207
9	InstantpaypalSettings->getSettings()	JROOT/administrator/components/com_instantpaypal/framework/settings.php:271
8	InstantpaypalhelperSettings::_load()	JROOT/components/com_instantpaypal/controller.php:17
7	InstantpaypalController->__construct()	JROOT/components/com_instantpaypal/instantpaypal.php:35
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.29 ms After last query: 1.19 ms Query memory: 0.022 MB Memory before query: 2.641 MB Rows returned: 1

Duplicate queries: #82

SELECT `id`

  FROM `zov5y_instantpaypal_templates`

  WHERE `default`='1'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_instantpaypal/framework/db.php:354
10	InstantpaypalDb->getResult()	JROOT/administrator/components/com_instantpaypal/framework/templates.php:100
9	InstantpaypalTemplates->getDefault()	JROOT/components/com_instantpaypal/controller.php:63
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.32 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 2.648 MB Rows returned: 1

Duplicate queries: #83

SELECT `id`,`name`,`alias`,`default`,`params`

  FROM `zov5y_instantpaypal_templates`

  WHERE `id`='1'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_instantpaypal/framework/db.php:136
12	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:366
11	InstantpaypalDb->getObj()	JROOT/administrator/components/com_instantpaypal/framework/templates.php:37
10	InstantpaypalTemplates->getTemplate()	JROOT/administrator/components/com_instantpaypal/framework/templates.php:105
9	InstantpaypalTemplates->getDefault()	JROOT/components/com_instantpaypal/controller.php:63
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.40 ms After last query: 8.03 ms Query memory: 0.022 MB Memory before query: 2.674 MB Rows returned: 4

Duplicate queries: #9 #37 #44 #46 #50 #52 #84 #86 #89 #91 #93 #95 #113 #115 #117

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

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:433
11	InstantpaypalFoundation->loadAccessLevels()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:61
10	InstantpaypalCategories->__construct()	JROOT/components/com_instantpaypal/views/category/view.html.php:23
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 4.99 ms After last query: 0.51 ms Query memory: 0.024 MB Memory before query: 2.752 MB Rows returned: 0

Duplicate queries: #20 #24 #28 #32 #71 #76 #138 #141 #145 #152 #157

SELECT `id`,`hash`,`ip`,`time`

  FROM `zov5y_instantpaypal_cookies`

  WHERE `time`<'1728616029'

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	20	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_instantpaypal/framework/db.php:131
15	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:375
14	InstantpaypalDb->getAssocList()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:31
13	InstantpaypalCookies->purgeCookies()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:26
12	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.26 ms After last query: 0.13 ms Query memory: 0.008 MB Memory before query: 2.760 MB

Duplicate queries: #149

DELETE 

  FROM `zov5y_instantpaypal_uniques`

  WHERE `time`<'1728698829'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
17	JDatabase->query()	JROOT/administrator/components/com_instantpaypal/framework/db.php:325
16	InstantpaypalDb->deleteData()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:188
15	InstantpaypalFoundation->uniqId()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:43
14	InstantpaypalCookies->setCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:40
13	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
12	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.30 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 2.770 MB Rows returned: 0

SELECT `id`

  FROM `zov5y_instantpaypal_cookies`

  WHERE `hash`='TZuhpfOojOqxOPx9'

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	20	Using where

Profile

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

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/foundation.php:206
15	InstantpaypalFoundation->uniqId()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:43
14	InstantpaypalCookies->setCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:40
13	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
12	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.64 ms After last query: 0.13 ms Query memory: 0.008 MB Memory before query: 2.780 MB

INSERT INTO `zov5y_instantpaypal_cookies`
(`hash`,`ip`,`time`) 
  VALUES 
('TZuhpfOojOqxOPx9','44.220.184.63','1728702429')

Explain

EXPLAIN not possible on query: INSERT INTO `zov5y_instantpaypal_cookies` (`hash`,`ip`,`time`) VALUES ('TZuhpfOojOqxOPx9','44.220.184.63','1728702429')

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
16	JDatabase->query()	JROOT/administrator/components/com_instantpaypal/framework/db.php:264
15	InstantpaypalDb->insertData()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:48
14	InstantpaypalCookies->setCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:40
13	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
12	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.46 ms After last query: 0.40 ms Query memory: 0.023 MB Memory before query: 2.796 MB Rows returned: 0

SELECT `value`

  FROM `zov5y_instantpaypal_cookie_vars`

  WHERE `cookie`='TZuhpfOojOqxOPx9' 
  AND `name`='categories.sort'

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

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_instantpaypal/framework/db.php:354
13	InstantpaypalDb->getResult()	JROOT/administrator/components/com_instantpaypal/framework/cookievars.php:27
12	InstantpaypalCookievars->getVar()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:90
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.23 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 2.800 MB Rows returned: 0

Duplicate queries: #15 #24 #28 #32 #71 #76 #138 #141 #145 #152 #157

SELECT `id`,`hash`,`ip`,`time`

  FROM `zov5y_instantpaypal_cookies`

  WHERE `time`<'1728616029'

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	20	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_instantpaypal/framework/db.php:131
15	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:375
14	InstantpaypalDb->getAssocList()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:31
13	InstantpaypalCookies->purgeCookies()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:26
12	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.26 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 2.808 MB Rows returned: 1

Duplicate queries: #25 #29 #33 #72 #77 #139 #142 #146 #153 #158

SELECT `id`,`hash`,`ip`,`time`

  FROM `zov5y_instantpaypal_cookies`

  WHERE `hash`='TZuhpfOojOqxOPx9'

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	20	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_instantpaypal/framework/db.php:135
16	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:372
15	InstantpaypalDb->getAssoc()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:55
14	InstantpaypalCookies->checkCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:38
13	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
12	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.29 ms After last query: 0.20 ms Query memory: 0.008 MB Memory before query: 2.817 MB

Duplicate queries: #26 #30 #34 #73 #78 #140 #143 #147 #154 #159

UPDATE `zov5y_instantpaypal_cookies`

  SET `time`='1728702429'

  WHERE `id`='674051'

Explain

EXPLAIN not possible on query: UPDATE `zov5y_instantpaypal_cookies` SET `time`='1728702429' WHERE `id`='674051'

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
16	JDatabase->query()	JROOT/administrator/components/com_instantpaypal/framework/db.php:296
15	InstantpaypalDb->updateData()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:63
14	InstantpaypalCookies->checkCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:38
13	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
12	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.25 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 2.828 MB Rows returned: 0

SELECT `value`

  FROM `zov5y_instantpaypal_cookie_vars`

  WHERE `cookie`='TZuhpfOojOqxOPx9' 
  AND `name`='categories.dir'

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

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_instantpaypal/framework/db.php:354
13	InstantpaypalDb->getResult()	JROOT/administrator/components/com_instantpaypal/framework/cookievars.php:27
12	InstantpaypalCookievars->getVar()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:90
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.23 ms After last query: 0.11 ms Query memory: 0.024 MB Memory before query: 2.832 MB Rows returned: 0

Duplicate queries: #15 #20 #28 #32 #71 #76 #138 #141 #145 #152 #157

SELECT `id`,`hash`,`ip`,`time`

  FROM `zov5y_instantpaypal_cookies`

  WHERE `time`<'1728616029'

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	20	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_instantpaypal/framework/db.php:131
15	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:375
14	InstantpaypalDb->getAssocList()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:31
13	InstantpaypalCookies->purgeCookies()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:26
12	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.26 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 2.841 MB Rows returned: 1

Duplicate queries: #21 #29 #33 #72 #77 #139 #142 #146 #153 #158

SELECT `id`,`hash`,`ip`,`time`

  FROM `zov5y_instantpaypal_cookies`

  WHERE `hash`='TZuhpfOojOqxOPx9'

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	20	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_instantpaypal/framework/db.php:135
16	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:372
15	InstantpaypalDb->getAssoc()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:55
14	InstantpaypalCookies->checkCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:38
13	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
12	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.22 ms After last query: 0.12 ms Query memory: 0.008 MB Memory before query: 2.849 MB

Duplicate queries: #22 #30 #34 #73 #78 #140 #143 #147 #154 #159

UPDATE `zov5y_instantpaypal_cookies`

  SET `time`='1728702429'

  WHERE `id`='674051'

Explain

EXPLAIN not possible on query: UPDATE `zov5y_instantpaypal_cookies` SET `time`='1728702429' WHERE `id`='674051'

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
16	JDatabase->query()	JROOT/administrator/components/com_instantpaypal/framework/db.php:296
15	InstantpaypalDb->updateData()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:63
14	InstantpaypalCookies->checkCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:38
13	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
12	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.25 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 2.860 MB Rows returned: 0

SELECT `value`

  FROM `zov5y_instantpaypal_cookie_vars`

  WHERE `cookie`='TZuhpfOojOqxOPx9' 
  AND `name`='categories.
  limit'

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

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_instantpaypal/framework/db.php:354
13	InstantpaypalDb->getResult()	JROOT/administrator/components/com_instantpaypal/framework/cookievars.php:27
12	InstantpaypalCookievars->getVar()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:90
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.23 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 2.864 MB Rows returned: 0

Duplicate queries: #15 #20 #24 #32 #71 #76 #138 #141 #145 #152 #157

SELECT `id`,`hash`,`ip`,`time`

  FROM `zov5y_instantpaypal_cookies`

  WHERE `time`<'1728616029'

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	20	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_instantpaypal/framework/db.php:131
15	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:375
14	InstantpaypalDb->getAssocList()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:31
13	InstantpaypalCookies->purgeCookies()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:26
12	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.23 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 2.873 MB Rows returned: 1

Duplicate queries: #21 #25 #33 #72 #77 #139 #142 #146 #153 #158

SELECT `id`,`hash`,`ip`,`time`

  FROM `zov5y_instantpaypal_cookies`

  WHERE `hash`='TZuhpfOojOqxOPx9'

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	20	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_instantpaypal/framework/db.php:135
16	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:372
15	InstantpaypalDb->getAssoc()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:55
14	InstantpaypalCookies->checkCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:38
13	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
12	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.19 ms After last query: 0.14 ms Query memory: 0.008 MB Memory before query: 2.881 MB

Duplicate queries: #22 #26 #34 #73 #78 #140 #143 #147 #154 #159

UPDATE `zov5y_instantpaypal_cookies`

  SET `time`='1728702429'

  WHERE `id`='674051'

Explain

EXPLAIN not possible on query: UPDATE `zov5y_instantpaypal_cookies` SET `time`='1728702429' WHERE `id`='674051'

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
16	JDatabase->query()	JROOT/administrator/components/com_instantpaypal/framework/db.php:296
15	InstantpaypalDb->updateData()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:63
14	InstantpaypalCookies->checkCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:38
13	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
12	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.28 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 2.892 MB Rows returned: 0

SELECT `value`

  FROM `zov5y_instantpaypal_cookie_vars`

  WHERE `cookie`='TZuhpfOojOqxOPx9' 
  AND `name`='categories.page'

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

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_instantpaypal/framework/db.php:354
13	InstantpaypalDb->getResult()	JROOT/administrator/components/com_instantpaypal/framework/cookievars.php:27
12	InstantpaypalCookievars->getVar()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:90
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.28 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 2.896 MB Rows returned: 0

Duplicate queries: #15 #20 #24 #28 #71 #76 #138 #141 #145 #152 #157

SELECT `id`,`hash`,`ip`,`time`

  FROM `zov5y_instantpaypal_cookies`

  WHERE `time`<'1728616029'

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	20	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_instantpaypal/framework/db.php:131
15	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:375
14	InstantpaypalDb->getAssocList()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:31
13	InstantpaypalCookies->purgeCookies()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:26
12	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.24 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 2.911 MB Rows returned: 1

Duplicate queries: #21 #25 #29 #72 #77 #139 #142 #146 #153 #158

SELECT `id`,`hash`,`ip`,`time`

  FROM `zov5y_instantpaypal_cookies`

  WHERE `hash`='TZuhpfOojOqxOPx9'

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	20	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_instantpaypal/framework/db.php:135
16	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:372
15	InstantpaypalDb->getAssoc()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:55
14	InstantpaypalCookies->checkCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:38
13	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
12	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.20 ms After last query: 0.12 ms Query memory: 0.008 MB Memory before query: 2.921 MB

Duplicate queries: #22 #26 #30 #73 #78 #140 #143 #147 #154 #159

UPDATE `zov5y_instantpaypal_cookies`

  SET `time`='1728702429'

  WHERE `id`='674051'

Explain

EXPLAIN not possible on query: UPDATE `zov5y_instantpaypal_cookies` SET `time`='1728702429' WHERE `id`='674051'

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
16	JDatabase->query()	JROOT/administrator/components/com_instantpaypal/framework/db.php:296
15	InstantpaypalDb->updateData()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:63
14	InstantpaypalCookies->checkCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:38
13	InstantpaypalCookies->getCookie()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:27
12	InstantpaypalCookies->__construct()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:88
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.25 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 2.932 MB Rows returned: 0

SELECT `value`

  FROM `zov5y_instantpaypal_cookie_vars`

  WHERE `cookie`='TZuhpfOojOqxOPx9' 
  AND `name`='categories.total'

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

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_instantpaypal/framework/db.php:354
13	InstantpaypalDb->getResult()	JROOT/administrator/components/com_instantpaypal/framework/cookievars.php:27
12	InstantpaypalCookievars->getVar()	JROOT/administrator/components/com_instantpaypal/framework/cookies.php:90
11	InstantpaypalhelperCookies::_getVar()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:84
10	InstantpaypalFoundation->updateOrder()	JROOT/components/com_instantpaypal/views/category/view.html.php:24
9	InstantpaypalViewcategory->display()	JROOT/components/com_instantpaypal/controller.php:72
8	InstantpaypalController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_instantpaypal/instantpaypal.php:36
6	require_once JROOT/components/com_instantpaypal/instantpaypal.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.]

Query Time: 0.73 ms After last query: 0.54 ms Query memory: 0.022 MB Memory before query: 2.934 MB Rows returned: 1

Duplicate queries: #85

SELECT `id`,`parent`,`level`,`sort`,`name`,`alias`,`image`,`status`,`featured`,`access`,`desc`,`meta_title`,`meta_keys`,`meta_desc`,`params`,`language`

  FROM `zov5y_instantpaypal_categories`

  WHERE `id`='1' 
  AND `status`='

Manifesting Heaven On Earth

Contributions

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

166 Queries Logged 80.21 ms

124 duplicate found!