Church Of The Creator® | Church Of The Creator®

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

Featured products

$17.00

Transfiguration-Sacred Codes Of Palenque

Collectively Aligned & Infused, sound frequency interpretation of “Palenque Transfiguration Codes.” Activates the Zohar Body of Light - stabilize, harmonize, a Collective Consciousness Vehicle as understood within Principles & Practices, GRIDS of Consciousness Unification – Group Responsibility In Divine Structure. Audio CD. Orders of 12 CDs or more receive $5.00 per CD discount. 12 CD's $144.00 + shipping.

$22.00

DRO Stamp

Places Ink Graphic of Divine Right Order® on paper or other printable materials. Visual Reminder that help is available, when we ask.

$0.00

Contribute -

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

$75.00

Annual Credential Renewal Fee

Return flow of financial support to the Church, necessary to maintaining Registrations, Legal Standing, Professional License for next 12 months, calendar year.

$100.00

Ordination Fee

Fee paid by Candidate for Ordination/Witness prior to Ordination.

$20.00

A.M. Certificate Replacement

A Signed and Sealed Certificate Of Credential.

$20.00

P.P. Certificate Replacement

Pastoral Pastor Certificate Of Witness.

$20.00

Photo ID Replacement

COTC Associate Minister and/or Pastoral Pastor, TE-TA-MA Truth Foundation-Family Of URI

$12.00

DRO Magnetic Decal

Magnetic Decal, a visual reminder to use, Decree, Divine Right Order® in all circumstances that you believe may be improved, requesting Divine Intervention, adjustment to the benefit of the Whole of Creation.

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1745666201,
                "last": 1745666201,
                "now": 1745666201
            },
            "token": "0KrAITOaAQN8MNVonDhAiyZoseRu2GLP"
        },
        "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'30627665336f6463766e3037716d63316767643665343263666a', 1, 1745666201, 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.59 ms After last query: 0.89 ms Query memory: 0.025 MB Memory before query: 1.086 MB Rows returned: 41

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `zov5y_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.38 ms After last query: 3.60 ms Query memory: 0.021 MB Memory before query: 1.116 MB Rows returned: 4

SELECT id, rules

  FROM `zov5y_viewlevels`

Explain

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

Profile

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.42 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 1.127 MB Rows returned: 1

SELECT b.id

  FROM zov5y_usergroups AS a

  LEFT JOIN zov5y_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 1

Explain

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

Profile

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.82 ms After last query: 0.35 ms Query memory: 0.030 MB Memory before query: 1.152 MB Rows returned: 101

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM zov5y_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1)

  ORDER BY ordering

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.36 ms After last query: 2.19 ms Query memory: 0.021 MB Memory before query: 1.513 MB Rows returned: 1

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

Explain

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

Profile

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: 4.54 ms After last query: 19.57 ms Query memory: 0.171 MB Memory before query: 1.770 MB Rows returned: 112

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM zov5y_menu AS m

  LEFT JOIN zov5y_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.58 ms After last query: 3.85 ms Query memory: 0.021 MB Memory before query: 2.350 MB Rows returned: 1

SELECT id, home, template, s.params

  FROM zov5y_template_styles as s

  LEFT JOIN zov5y_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.36 ms After last query: 0.88 ms Query memory: 0.022 MB Memory before query: 2.377 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `zov5y_extensions`

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

Explain

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

Profile

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

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

Query Time: 0.60 ms After last query: 0.24 ms Query memory: 0.005 MB Memory before query: 2.367 MB

UPDATE `zov5y_extensions`

  SET `params` = '{\"mediaversion\":\"02eee758ea1de71f9d2e52bd02b6a7b0\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `zov5y_extensions` SET `params` = '{\"mediaversion\":\"02eee758ea1de71f9d2e52bd02b6a7b0\"}' 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.36 ms After last query: 0.38 ms Query memory: 0.019 MB Memory before query: 2.389 MB Rows returned: 1

SELECT *

  FROM zov5y_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.40 ms After last query: 8.29 ms Query memory: 0.021 MB Memory before query: 2.483 MB Rows returned: 4

Duplicate queries: #19 #22 #30 #36 #42 #48 #51 #59 #62 #65 #68 #71 #74 #77 #79 #81 #116 #118 #120 #136 #138 #140 #157 #159 #161 #175 #177 #179 #197 #199 #201 #216 #218 #220 #237 #239 #241 #255 #257 #259 #276 #278 #280 #294 #296 #298 #315 #317 #319 #333 #335 #337 #354 #356 #358 #372 #374 #376 #393 #395 #397 #411 #413 #415 #432 #434 #436

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.490 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.29 ms After last query: 0.20 ms Query memory: 0.022 MB Memory before query: 2.524 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.64 ms After last query: 1.83 ms Query memory: 0.022 MB Memory before query: 2.587 MB Rows returned: 1

Duplicate queries: #54

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.27 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 2.595 MB Rows returned: 1

Duplicate queries: #55

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.50 ms After last query: 19.59 ms Query memory: 0.022 MB Memory before query: 2.622 MB Rows returned: 4

Duplicate queries: #14 #22 #30 #36 #42 #48 #51 #59 #62 #65 #68 #71 #74 #77 #79 #81 #116 #118 #120 #136 #138 #140 #157 #159 #161 #175 #177 #179 #197 #199 #201 #216 #218 #220 #237 #239 #241 #255 #257 #259 #276 #278 #280 #294 #296 #298 #315 #317 #319 #333 #335 #337 #354 #356 #358 #372 #374 #376 #393 #395 #397 #411 #413 #415 #432 #434 #436

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/home/view.html.php:24
9	InstantpaypalViewHome->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.94 ms After last query: 0.74 ms Query memory: 0.022 MB Memory before query: 2.628 MB Rows returned: 4

Duplicate queries: #60

SELECT  DISTINCT `z`.`id`

  FROM `zov5y_instantpaypal_categories` AS `z`

  WHERE `status`='1' 
  AND `featured`!='2'

  ORDER BY `z`.`sort` ASC 
  LIMIT 0,999999

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
12	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_instantpaypal/framework/db.php:234
11	InstantpaypalDb->getSearch()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:93
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.38 ms After last query: 0.44 ms Query memory: 0.023 MB Memory before query: 2.638 MB Rows returned: 1

Duplicate queries: #61

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`='1'

Explain

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

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:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_instantpaypal/framework/db.php:136
13	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:366
12	InstantpaypalDb->getObj()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:106
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.34 ms After last query: 2.14 ms Query memory: 0.023 MB Memory before query: 2.655 MB Rows returned: 4

Duplicate queries: #14 #19 #30 #36 #42 #48 #51 #59 #62 #65 #68 #71 #74 #77 #79 #81 #116 #118 #120 #136 #138 #140 #157 #159 #161 #175 #177 #179 #197 #199 #201 #216 #218 #220 #237 #239 #241 #255 #257 #259 #276 #278 #280 #294 #296 #298 #315 #317 #319 #333 #335 #337 #354 #356 #358 #372 #374 #376 #393 #395 #397 #411 #413 #415 #432 #434 #436

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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:433
14	InstantpaypalFoundation->loadAccessLevels()	JROOT/administrator/components/com_instantpaypal/framework/items.php:165
13	InstantpaypalItems->__construct()	JROOT/administrator/components/com_instantpaypal/framework/items.php:790
12	InstantpaypalhelperItems::_count()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:114
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.69 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 2.663 MB Rows returned: 3

Duplicate queries: #63 #180 #202

SELECT  DISTINCT `z`.`id`

  FROM `zov5y_instantpaypal_items` AS `z`

  WHERE (`category_id` LIKE '%\"1\"%')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_instantpaypal/framework/db.php:182
13	InstantpaypalDb->getCount()	JROOT/administrator/components/com_instantpaypal/framework/items.php:794
12	InstantpaypalhelperItems::_count()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:114
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.31 ms After last query: 0.94 ms Query memory: 0.025 MB Memory before query: 2.666 MB Rows returned: 4

SELECT DISTINCT
 zov5y_instantpaypal_categories.id AS `category_id`
 
  FROM `zov5y_instantpaypal_categories`
 
  WHERE zov5y_instantpaypal_categories.status = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_instantpaypal/router.php:147
19	InstantpaypalRouter->routeHelper()	JROOT/components/com_instantpaypal/router.php:316
18	InstantpaypalRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:116
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.04 ms Query memory: 0.026 MB Memory before query: 2.678 MB Rows returned: 4

SELECT
 zov5y_instantpaypal_categories.parent AS `parent`,
 zov5y_instantpaypal_categories.id AS `child`
 
  FROM `zov5y_instantpaypal_categories`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zov5y_instantpaypal_categories	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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/components/com_instantpaypal/router.php:153
19	InstantpaypalRouter->routeHelper()	JROOT/components/com_instantpaypal/router.php:316
18	InstantpaypalRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:116
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.27 ms After last query: 0.39 ms Query memory: 0.025 MB Memory before query: 2.694 MB Rows returned: 1

SELECT `parent`

  FROM `zov5y_instantpaypal_categories`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_instantpaypal/router.php:229
19	InstantpaypalRouter->routeHelper()	JROOT/components/com_instantpaypal/router.php:316
18	InstantpaypalRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:116
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.27 ms After last query: 0.26 ms Query memory: 0.025 MB Memory before query: 2.701 MB Rows returned: 1

Duplicate queries: #33 #39 #45 #106 #151 #191 #231 #270 #309 #348 #387 #426 #482 #483

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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_instantpaypal/router.php:295
19	InstantpaypalRouter->loadParams()	JROOT/components/com_instantpaypal/router.php:385
18	InstantpaypalRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:116
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.27 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 2.717 MB Rows returned: 1

SELECT name

  FROM zov5y_instantpaypal_categories

  WHERE `id`=1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_instantpaypal/router.php:71
19	InstantpaypalRouter->resolveAlias()	JROOT/components/com_instantpaypal/router.php:398
18	InstantpaypalRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:116
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.31 ms After last query: 1.35 ms Query memory: 0.023 MB Memory before query: 2.724 MB Rows returned: 1

Duplicate queries: #64

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`='2' 
  AND `status`='1'

Explain

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

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:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_instantpaypal/framework/db.php:136
13	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:366
12	InstantpaypalDb->getObj()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:106
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.32 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 2.735 MB Rows returned: 4

Duplicate queries: #14 #19 #22 #36 #42 #48 #51 #59 #62 #65 #68 #71 #74 #77 #79 #81 #116 #118 #120 #136 #138 #140 #157 #159 #161 #175 #177 #179 #197 #199 #201 #216 #218 #220 #237 #239 #241 #255 #257 #259 #276 #278 #280 #294 #296 #298 #315 #317 #319 #333 #335 #337 #354 #356 #358 #372 #374 #376 #393 #395 #397 #411 #413 #415 #432 #434 #436

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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:433
14	InstantpaypalFoundation->loadAccessLevels()	JROOT/administrator/components/com_instantpaypal/framework/items.php:165
13	InstantpaypalItems->__construct()	JROOT/administrator/components/com_instantpaypal/framework/items.php:790
12	InstantpaypalhelperItems::_count()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:114
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.34 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 2.743 MB Rows returned: 5

Duplicate queries: #66 #221 #242 #260 #281 #299 #320 #338 #359 #377 #398

SELECT  DISTINCT `z`.`id`

  FROM `zov5y_instantpaypal_items` AS `z`

  WHERE (`category_id` LIKE '%\"2\"%')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_instantpaypal/framework/db.php:182
13	InstantpaypalDb->getCount()	JROOT/administrator/components/com_instantpaypal/framework/items.php:794
12	InstantpaypalhelperItems::_count()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:114
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.11 ms Query memory: 0.025 MB Memory before query: 2.747 MB Rows returned: 1

SELECT `parent`

  FROM `zov5y_instantpaypal_categories`

  WHERE `id`=2 
  AND `status`= 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_instantpaypal/router.php:229
19	InstantpaypalRouter->routeHelper()	JROOT/components/com_instantpaypal/router.php:316
18	InstantpaypalRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:116
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.07 ms Query memory: 0.027 MB Memory before query: 2.763 MB Rows returned: 1

Duplicate queries: #27 #39 #45 #106 #151 #191 #231 #270 #309 #348 #387 #426 #482 #483

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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_instantpaypal/router.php:295
19	InstantpaypalRouter->loadParams()	JROOT/components/com_instantpaypal/router.php:385
18	InstantpaypalRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:116
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.27 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 2.781 MB Rows returned: 1

SELECT name

  FROM zov5y_instantpaypal_categories

  WHERE `id`=2

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_instantpaypal/router.php:71
19	InstantpaypalRouter->resolveAlias()	JROOT/components/com_instantpaypal/router.php:398
18	InstantpaypalRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:116
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.11 ms Query memory: 0.023 MB Memory before query: 2.786 MB Rows returned: 1

Duplicate queries: #67

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`='3' 
  AND `status`='1'

Explain

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

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:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_instantpaypal/framework/db.php:136
13	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:366
12	InstantpaypalDb->getObj()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:106
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.34 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 2.796 MB Rows returned: 4

Duplicate queries: #14 #19 #22 #30 #42 #48 #51 #59 #62 #65 #68 #71 #74 #77 #79 #81 #116 #118 #120 #136 #138 #140 #157 #159 #161 #175 #177 #179 #197 #199 #201 #216 #218 #220 #237 #239 #241 #255 #257 #259 #276 #278 #280 #294 #296 #298 #315 #317 #319 #333 #335 #337 #354 #356 #358 #372 #374 #376 #393 #395 #397 #411 #413 #415 #432 #434 #436

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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:433
14	InstantpaypalFoundation->loadAccessLevels()	JROOT/administrator/components/com_instantpaypal/framework/items.php:165
13	InstantpaypalItems->__construct()	JROOT/administrator/components/com_instantpaypal/framework/items.php:790
12	InstantpaypalhelperItems::_count()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:114
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.09 ms Query memory: 0.022 MB Memory before query: 2.804 MB Rows returned: 2

Duplicate queries: #69 #141 #162 #416 #437

SELECT  DISTINCT `z`.`id`

  FROM `zov5y_instantpaypal_items` AS `z`

  WHERE (`category_id` LIKE '%\"3\"%')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_instantpaypal/framework/db.php:182
13	InstantpaypalDb->getCount()	JROOT/administrator/components/com_instantpaypal/framework/items.php:794
12	InstantpaypalhelperItems::_count()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:114
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.27 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 2.809 MB Rows returned: 1

SELECT `parent`

  FROM `zov5y_instantpaypal_categories`

  WHERE `id`=3 
  AND `status`= 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_instantpaypal/router.php:229
19	InstantpaypalRouter->routeHelper()	JROOT/components/com_instantpaypal/router.php:316
18	InstantpaypalRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:116
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.09 ms Query memory: 0.025 MB Memory before query: 2.818 MB Rows returned: 1

Duplicate queries: #27 #33 #45 #106 #151 #191 #231 #270 #309 #348 #387 #426 #482 #483

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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_instantpaypal/router.php:295
19	InstantpaypalRouter->loadParams()	JROOT/components/com_instantpaypal/router.php:385
18	InstantpaypalRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:116
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.025 MB Memory before query: 2.834 MB Rows returned: 1

SELECT name

  FROM zov5y_instantpaypal_categories

  WHERE `id`=3

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_instantpaypal/router.php:71
19	InstantpaypalRouter->resolveAlias()	JROOT/components/com_instantpaypal/router.php:398
18	InstantpaypalRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:116
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.32 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 2.839 MB Rows returned: 1

Duplicate queries: #70

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`='4' 
  AND `status`='1'

Explain

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

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:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_instantpaypal/framework/db.php:136
13	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:366
12	InstantpaypalDb->getObj()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:106
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.31 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 2.849 MB Rows returned: 4

Duplicate queries: #14 #19 #22 #30 #36 #48 #51 #59 #62 #65 #68 #71 #74 #77 #79 #81 #116 #118 #120 #136 #138 #140 #157 #159 #161 #175 #177 #179 #197 #199 #201 #216 #218 #220 #237 #239 #241 #255 #257 #259 #276 #278 #280 #294 #296 #298 #315 #317 #319 #333 #335 #337 #354 #356 #358 #372 #374 #376 #393 #395 #397 #411 #413 #415 #432 #434 #436

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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:433
14	InstantpaypalFoundation->loadAccessLevels()	JROOT/administrator/components/com_instantpaypal/framework/items.php:165
13	InstantpaypalItems->__construct()	JROOT/administrator/components/com_instantpaypal/framework/items.php:790
12	InstantpaypalhelperItems::_count()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:114
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.022 MB Memory before query: 2.858 MB Rows returned: 1

Duplicate queries: #72 #82 #121

SELECT  DISTINCT `z`.`id`

  FROM `zov5y_instantpaypal_items` AS `z`

  WHERE (`category_id` LIKE '%\"4\"%')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_instantpaypal/framework/db.php:182
13	InstantpaypalDb->getCount()	JROOT/administrator/components/com_instantpaypal/framework/items.php:794
12	InstantpaypalhelperItems::_count()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:114
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.10 ms Query memory: 0.025 MB Memory before query: 2.862 MB Rows returned: 1

SELECT `parent`

  FROM `zov5y_instantpaypal_categories`

  WHERE `id`=4 
  AND `status`= 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_instantpaypal/router.php:229
19	InstantpaypalRouter->routeHelper()	JROOT/components/com_instantpaypal/router.php:316
18	InstantpaypalRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:116
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.27 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 2.872 MB Rows returned: 1

Duplicate queries: #27 #33 #39 #106 #151 #191 #231 #270 #309 #348 #387 #426 #482 #483

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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_instantpaypal/router.php:295
19	InstantpaypalRouter->loadParams()	JROOT/components/com_instantpaypal/router.php:385
18	InstantpaypalRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:116
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.27 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 2.888 MB Rows returned: 1

SELECT name

  FROM zov5y_instantpaypal_categories

  WHERE `id`=4

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_instantpaypal/router.php:71
19	InstantpaypalRouter->resolveAlias()	JROOT/components/com_instantpaypal/router.php:398
18	InstantpaypalRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:116
11	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.44 ms Query memory: 0.022 MB Memory before query: 2.890 MB Rows returned: 4

Duplicate queries: #73

SELECT  DISTINCT `z`.`id`

  FROM `zov5y_instantpaypal_categories` AS `z`

  WHERE `status`='1' 
  AND `featured`!='2'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_instantpaypal/framework/db.php:182
12	InstantpaypalDb->getCount()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:266
11	InstantpaypalFoundation->getCount()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:98
10	InstantpaypalCategories->getCategories()	JROOT/components/com_instantpaypal/views/home/view.html.php:25
9	InstantpaypalViewHome->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.32 ms After last query: 0.34 ms Query memory: 0.022 MB Memory before query: 2.901 MB Rows returned: 4

Duplicate queries: #14 #19 #22 #30 #36 #42 #51 #59 #62 #65 #68 #71 #74 #77 #79 #81 #116 #118 #120 #136 #138 #140 #157 #159 #161 #175 #177 #179 #197 #199 #201 #216 #218 #220 #237 #239 #241 #255 #257 #259 #276 #278 #280 #294 #296 #298 #315 #317 #319 #333 #335 #337 #354 #356 #358 #372 #374 #376 #393 #395 #397 #411 #413 #415 #432 #434 #436

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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:433
12	InstantpaypalFoundation->loadAccessLevels()	JROOT/administrator/components/com_instantpaypal/framework/items.php:165
11	InstantpaypalItems->__construct()	JROOT/administrator/components/com_instantpaypal/framework/items.php:808
10	InstantpaypalhelperItems::getFeaturedIds()	JROOT/components/com_instantpaypal/views/home/view.html.php:28
9	InstantpaypalViewHome->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: 3.87 ms After last query: 0.15 ms Query memory: 0.023 MB Memory before query: 2.910 MB Rows returned: 9

SELECT  DISTINCT `z`.`id`

  FROM `zov5y_instantpaypal_items` AS `z`

  LEFT JOIN `zov5y_instantpaypal_categories` AS `c` 
  ON (`z`.`category_id` LIKE CONCAT("%",`c`.`id`,"%"))

  WHERE (`z`.`featured` LIKE '%1%') 
  AND (`z`.`status` LIKE '%1%') 
  AND `z`.`status`='1'

  ORDER BY `z`.`sort` ASC 
  LIMIT 0,20

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	11	Using where; Using temporary; Using filesort
1	SIMPLE	c	index	NULL	PRIMARY	2	NULL	4	Using where; Using index; Using join buffer (flat, BNL join)

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:1506
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_instantpaypal/framework/db.php:234
13	InstantpaypalDb->getSearch()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:260
12	InstantpaypalFoundation->getSearch()	JROOT/administrator/components/com_instantpaypal/framework/items.php:247
11	InstantpaypalItems->getSearch()	JROOT/administrator/components/com_instantpaypal/framework/items.php:826
10	InstantpaypalhelperItems::getFeaturedIds()	JROOT/components/com_instantpaypal/views/home/view.html.php:28
9	InstantpaypalViewHome->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.43 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 2.919 MB Rows returned: 9

Duplicate queries: #76

SELECT  DISTINCT `z`.`id`

  FROM `zov5y_instantpaypal_items` AS `z`

  LEFT JOIN `zov5y_instantpaypal_categories` AS `c` 
  ON (`z`.`category_id` LIKE CONCAT("%",`c`.`id`,"%"))

  WHERE (`z`.`featured` LIKE '%1%') 
  AND (`z`.`status` LIKE '%1%') 
  AND `z`.`status`='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	11	Using where; Using temporary
1	SIMPLE	c	index	NULL	PRIMARY	2	NULL	4	Using where; Using index; Using join buffer (flat, BNL join)

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_instantpaypal/framework/db.php:182
13	InstantpaypalDb->getCount()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:266
12	InstantpaypalFoundation->getCount()	JROOT/administrator/components/com_instantpaypal/framework/items.php:249
11	InstantpaypalItems->getSearch()	JROOT/administrator/components/com_instantpaypal/framework/items.php:826
10	InstantpaypalhelperItems::getFeaturedIds()	JROOT/components/com_instantpaypal/views/home/view.html.php:28
9	InstantpaypalViewHome->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.34 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 2.922 MB Rows returned: 4

Duplicate queries: #14 #19 #22 #30 #36 #42 #48 #59 #62 #65 #68 #71 #74 #77 #79 #81 #116 #118 #120 #136 #138 #140 #157 #159 #161 #175 #177 #179 #197 #199 #201 #216 #218 #220 #237 #239 #241 #255 #257 #259 #276 #278 #280 #294 #296 #298 #315 #317 #319 #333 #335 #337 #354 #356 #358 #372 #374 #376 #393 #395 #397 #411 #413 #415 #432 #434 #436

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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:433
12	InstantpaypalFoundation->loadAccessLevels()	JROOT/administrator/components/com_instantpaypal/framework/items.php:165
11	InstantpaypalItems->__construct()	JROOT/administrator/components/com_instantpaypal/framework/items.php:832
10	InstantpaypalhelperItems::getNewIds()	JROOT/components/com_instantpaypal/views/home/view.html.php:31
9	InstantpaypalViewHome->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.44 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 2.931 MB Rows returned: 2

SELECT  DISTINCT `z`.`id`

  FROM `zov5y_instantpaypal_items` AS `z`

  LEFT JOIN `zov5y_instantpaypal_categories` AS `c` 
  ON (`z`.`category_id` LIKE CONCAT("%",`c`.`id`,"%"))

  WHERE (`z`.`status` LIKE '%1%') 
  AND `z`.`status`='1'

  ORDER BY `z`.`added` DESC 
  LIMIT 0,2

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	11	Using where; Using temporary; Using filesort
1	SIMPLE	c	index	NULL	PRIMARY	2	NULL	4	Using where; Using index; Using join buffer (flat, BNL join)

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:1506
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_instantpaypal/framework/db.php:234
13	InstantpaypalDb->getSearch()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:260
12	InstantpaypalFoundation->getSearch()	JROOT/administrator/components/com_instantpaypal/framework/items.php:247
11	InstantpaypalItems->getSearch()	JROOT/administrator/components/com_instantpaypal/framework/items.php:844
10	InstantpaypalhelperItems::getNewIds()	JROOT/components/com_instantpaypal/views/home/view.html.php:31
9	InstantpaypalViewHome->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.44 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 2.940 MB Rows returned: 9

SELECT  DISTINCT `z`.`id`

  FROM `zov5y_instantpaypal_items` AS `z`

  LEFT JOIN `zov5y_instantpaypal_categories` AS `c` 
  ON (`z`.`category_id` LIKE CONCAT("%",`c`.`id`,"%"))

  WHERE (`z`.`status` LIKE '%1%') 
  AND `z`.`status`='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	11	Using where; Using temporary
1	SIMPLE	c	index	NULL	PRIMARY	2	NULL	4	Using where; Using index; Using join buffer (flat, BNL join)

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_instantpaypal/framework/db.php:182
13	InstantpaypalDb->getCount()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:266
12	InstantpaypalFoundation->getCount()	JROOT/administrator/components/com_instantpaypal/framework/items.php:249
11	InstantpaypalItems->getSearch()	JROOT/administrator/components/com_instantpaypal/framework/items.php:844
10	InstantpaypalhelperItems::getNewIds()	JROOT/components/com_instantpaypal/views/home/view.html.php:31
9	InstantpaypalViewHome->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.36 ms Query memory: 0.022 MB Memory before query: 2.940 MB Rows returned: 1

Duplicate queries: #17

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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_instantpaypal/framework/db.php:354
11	InstantpaypalDb->getResult()	JROOT/administrator/components/com_instantpaypal/framework/templates.php:100
10	InstantpaypalTemplates->getDefault()	JROOT/components/com_instantpaypal/views/home/view.html.php:36
9	InstantpaypalViewHome->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.947 MB Rows returned: 1

Duplicate queries: #18

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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_instantpaypal/framework/db.php:136
13	InstantpaypalDb->getData()	JROOT/administrator/components/com_instantpaypal/framework/db.php:366
12	InstantpaypalDb->getObj()	JROOT/administrator/components/com_instantpaypal/framework/templates.php:37
11	InstantpaypalTemplates->getTemplate()	JROOT/administrator/components/com_instantpaypal/framework/templates.php:105
10	InstantpaypalTemplates->getDefault()	JROOT/components/com_instantpaypal/views/home/view.html.php:36
9	InstantpaypalViewHome->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.66 ms After last query: 2.23 ms Query memory: 0.025 MB Memory before query: 2.983 MB Rows returned: 2

SELECT `id`

  FROM `zov5y_instantpaypal_widgets`

  WHERE `views`LIKE'%\"home\":\"1\"%'

  ORDER BY `sort` ASC

Explain

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

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: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/template.php:48
14	InstantpaypalTemplate->getWidgets()	JROOT/administrator/components/com_instantpaypal/framework/template.php:67
13	InstantpaypalhelperTemplate::_showWidgets()	JROOT/components/com_instantpaypal/templates/default/views/home/default.php:28
12	include JROOT/components/com_instantpaypal/templates/default/views/home/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_instantpaypal/views/home/view.html.php:47
9	InstantpaypalViewHome->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.60 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 2.993 MB Rows returned: 1

SELECT `id`,`name`,`alias`,`params`,`views`,`sort`,`status`,`about`

  FROM `zov5y_instantpaypal_widgets`

  WHERE `id`='1'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/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/template.php:55
15	InstantpaypalTemplate->getWidget()	JROOT/administrator/components/com_instantpaypal/framework/template.php:50
14	InstantpaypalTemplate->getWidgets()	JROOT/administrator/components/com_instantpaypal/framework/template.php:67
13	InstantpaypalhelperTemplate::_showWidgets()	JROOT/components/com_instantpaypal/templates/default/views/home/default.php:28
12	include JROOT/components/com_instantpaypal/templates/default/views/home/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_instantpaypal/views/home/view.html.php:47
9	InstantpaypalViewHome->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.11 ms Query memory: 0.025 MB Memory before query: 3.004 MB Rows returned: 1

SELECT `id`,`name`,`alias`,`params`,`views`,`sort`,`status`,`about`

  FROM `zov5y_instantpaypal_widgets`

  WHERE `id`='2'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/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/template.php:55
15	InstantpaypalTemplate->getWidget()	JROOT/administrator/components/com_instantpaypal/framework/template.php:50
14	InstantpaypalTemplate->getWidgets()	JROOT/administrator/components/com_instantpaypal/framework/template.php:67
13	InstantpaypalhelperTemplate::_showWidgets()	JROOT/components/com_instantpaypal/templates/default/views/home/default.php:28
12	include JROOT/components/com_instantpaypal/templates/default/views/home/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_instantpaypal/views/home/view.html.php:47
9	InstantpaypalViewHome->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.32 ms After last query: 0.34 ms Query memory: 0.025 MB Memory before query: 3.018 MB Rows returned: 4

Duplicate queries: #14 #19 #22 #30 #36 #42 #48 #51 #62 #65 #68 #71 #74 #77 #79 #81 #116 #118 #120 #136 #138 #140 #157 #159 #161 #175 #177 #179 #197 #199 #201 #216 #218 #220 #237 #239 #241 #255 #257 #259 #276 #278 #280 #294 #296 #298 #315 #317 #319 #333 #335 #337 #354 #356 #358 #372 #374 #376 #393 #395 #397 #411 #413 #415 #432 #434 #436

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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:433
17	InstantpaypalFoundation->loadAccessLevels()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:61
16	InstantpaypalCategories->__construct()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:340
15	InstantpaypalhelperCategories::_load()	JROOT/administrator/components/com_instantpaypal/framework/template.php:130
14	InstantpaypalhelperTemplate::_showWidget()	JROOT/administrator/components/com_instantpaypal/framework/template.php:72
13	InstantpaypalhelperTemplate::_showWidgets()	JROOT/components/com_instantpaypal/templates/default/views/home/default.php:28
12	include JROOT/components/com_instantpaypal/templates/default/views/home/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_instantpaypal/views/home/view.html.php:47
9	InstantpaypalViewHome->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.34 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 3.027 MB Rows returned: 4

Duplicate queries: #20

SELECT  DISTINCT `z`.`id`

  FROM `zov5y_instantpaypal_categories` AS `z`

  WHERE `status`='1' 
  AND `featured`!='2'

  ORDER BY `z`.`sort` ASC 
  LIMIT 0,999999

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_instantpaypal/framework/db.php:234
17	InstantpaypalDb->getSearch()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:93
16	InstantpaypalCategories->getCategories()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:344
15	InstantpaypalhelperCategories::_load()	JROOT/administrator/components/com_instantpaypal/framework/template.php:130
14	InstantpaypalhelperTemplate::_showWidget()	JROOT/administrator/components/com_instantpaypal/framework/template.php:72
13	InstantpaypalhelperTemplate::_showWidgets()	JROOT/components/com_instantpaypal/templates/default/views/home/default.php:28
12	include JROOT/components/com_instantpaypal/templates/default/views/home/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_instantpaypal/views/home/view.html.php:47
9	InstantpaypalViewHome->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.06 ms Query memory: 0.026 MB Memory before query: 3.040 MB Rows returned: 1

Duplicate queries: #21

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`='1'

Explain

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

Profile

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

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/categories.php:106
17	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
16	InstantpaypalCategories->getCategories()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:344
15	InstantpaypalhelperCategories::_load()	JROOT/administrator/components/com_instantpaypal/framework/template.php:130
14	InstantpaypalhelperTemplate::_showWidget()	JROOT/administrator/components/com_instantpaypal/framework/template.php:72
13	InstantpaypalhelperTemplate::_showWidgets()	JROOT/components/com_instantpaypal/templates/default/views/home/default.php:28
12	include JROOT/components/com_instantpaypal/templates/default/views/home/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_instantpaypal/views/home/view.html.php:47
9	InstantpaypalViewHome->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.34 ms After last query: 0.09 ms Query memory: 0.026 MB Memory before query: 3.053 MB Rows returned: 4

Duplicate queries: #14 #19 #22 #30 #36 #42 #48 #51 #59 #65 #68 #71 #74 #77 #79 #81 #116 #118 #120 #136 #138 #140 #157 #159 #161 #175 #177 #179 #197 #199 #201 #216 #218 #220 #237 #239 #241 #255 #257 #259 #276 #278 #280 #294 #296 #298 #315 #317 #319 #333 #335 #337 #354 #356 #358 #372 #374 #376 #393 #395 #397 #411 #413 #415 #432 #434 #436

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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:433
20	InstantpaypalFoundation->loadAccessLevels()	JROOT/administrator/components/com_instantpaypal/framework/items.php:165
19	InstantpaypalItems->__construct()	JROOT/administrator/components/com_instantpaypal/framework/items.php:790
18	InstantpaypalhelperItems::_count()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:114
17	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
16	InstantpaypalCategories->getCategories()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:344
15	InstantpaypalhelperCategories::_load()	JROOT/administrator/components/com_instantpaypal/framework/template.php:130
14	InstantpaypalhelperTemplate::_showWidget()	JROOT/administrator/components/com_instantpaypal/framework/template.php:72
13	InstantpaypalhelperTemplate::_showWidgets()	JROOT/components/com_instantpaypal/templates/default/views/home/default.php:28
12	include JROOT/components/com_instantpaypal/templates/default/views/home/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_instantpaypal/views/home/view.html.php:47
9	InstantpaypalViewHome->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.33 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 3.065 MB Rows returned: 3

Duplicate queries: #23 #180 #202

SELECT  DISTINCT `z`.`id`

  FROM `zov5y_instantpaypal_items` AS `z`

  WHERE (`category_id` LIKE '%\"1\"%')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_instantpaypal/framework/db.php:182
19	InstantpaypalDb->getCount()	JROOT/administrator/components/com_instantpaypal/framework/items.php:794
18	InstantpaypalhelperItems::_count()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:114
17	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
16	InstantpaypalCategories->getCategories()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:344
15	InstantpaypalhelperCategories::_load()	JROOT/administrator/components/com_instantpaypal/framework/template.php:130
14	InstantpaypalhelperTemplate::_showWidget()	JROOT/administrator/components/com_instantpaypal/framework/template.php:72
13	InstantpaypalhelperTemplate::_showWidgets()	JROOT/components/com_instantpaypal/templates/default/views/home/default.php:28
12	include JROOT/components/com_instantpaypal/templates/default/views/home/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_instantpaypal/views/home/view.html.php:47
9	InstantpaypalViewHome->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.33 ms After last query: 0.21 ms Query memory: 0.026 MB Memory before query: 3.073 MB Rows returned: 1

Duplicate queries: #29

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`='2' 
  AND `status`='1'

Explain

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

Profile

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

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/categories.php:106
17	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
16	InstantpaypalCategories->getCategories()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:344
15	InstantpaypalhelperCategories::_load()	JROOT/administrator/components/com_instantpaypal/framework/template.php:130
14	InstantpaypalhelperTemplate::_showWidget()	JROOT/administrator/components/com_instantpaypal/framework/template.php:72
13	InstantpaypalhelperTemplate::_showWidgets()	JROOT/components/com_instantpaypal/templates/default/views/home/default.php:28
12	include JROOT/components/com_instantpaypal/templates/default/views/home/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_instantpaypal/views/home/view.html.php:47
9	InstantpaypalViewHome->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.32 ms After last query: 0.09 ms Query memory: 0.032 MB Memory before query: 3.096 MB Rows returned: 4

Duplicate queries: #14 #19 #22 #30 #36 #42 #48 #51 #59 #62 #68 #71 #74 #77 #79 #81 #116 #118 #120 #136 #138 #140 #157 #159 #161 #175 #177 #179 #197 #199 #201 #216 #218 #220 #237 #239 #241 #255 #257 #259 #276 #278 #280 #294 #296 #298 #315 #317 #319 #333 #335 #337 #354 #356 #358 #372 #374 #376 #393 #395 #397 #411 #413 #415 #432 #434 #436

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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:433
20	InstantpaypalFoundation->loadAccessLevels()	JROOT/administrator/components/com_instantpaypal/framework/items.php:165
19	InstantpaypalItems->__construct()	JROOT/administrator/components/com_instantpaypal/framework/items.php:790
18	InstantpaypalhelperItems::_count()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:114
17	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
16	InstantpaypalCategories->getCategories()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:344
15	InstantpaypalhelperCategories::_load()	JROOT/administrator/components/com_instantpaypal/framework/template.php:130
14	InstantpaypalhelperTemplate::_showWidget()	JROOT/administrator/components/com_instantpaypal/framework/template.php:72
13	InstantpaypalhelperTemplate::_showWidgets()	JROOT/components/com_instantpaypal/templates/default/views/home/default.php:28
12	include JROOT/components/com_instantpaypal/templates/default/views/home/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_instantpaypal/views/home/view.html.php:47
9	InstantpaypalViewHome->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.32 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 3.113 MB Rows returned: 5

Duplicate queries: #31 #221 #242 #260 #281 #299 #320 #338 #359 #377 #398

SELECT  DISTINCT `z`.`id`

  FROM `zov5y_instantpaypal_items` AS `z`

  WHERE (`category_id` LIKE '%\"2\"%')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_instantpaypal/framework/db.php:182
19	InstantpaypalDb->getCount()	JROOT/administrator/components/com_instantpaypal/framework/items.php:794
18	InstantpaypalhelperItems::_count()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:114
17	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
16	InstantpaypalCategories->getCategories()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:344
15	InstantpaypalhelperCategories::_load()	JROOT/administrator/components/com_instantpaypal/framework/template.php:130
14	InstantpaypalhelperTemplate::_showWidget()	JROOT/administrator/components/com_instantpaypal/framework/template.php:72
13	InstantpaypalhelperTemplate::_showWidgets()	JROOT/components/com_instantpaypal/templates/default/views/home/default.php:28
12	include JROOT/components/com_instantpaypal/templates/default/views/home/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_instantpaypal/views/home/view.html.php:47
9	InstantpaypalViewHome->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.13 ms Query memory: 0.026 MB Memory before query: 3.121 MB Rows returned: 1

Duplicate queries: #35

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`='3' 
  AND `status`='1'

Explain

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

Profile

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

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/categories.php:106
17	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
16	InstantpaypalCategories->getCategories()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:344
15	InstantpaypalhelperCategories::_load()	JROOT/administrator/components/com_instantpaypal/framework/template.php:130
14	InstantpaypalhelperTemplate::_showWidget()	JROOT/administrator/components/com_instantpaypal/framework/template.php:72
13	InstantpaypalhelperTemplate::_showWidgets()	JROOT/components/com_instantpaypal/templates/default/views/home/default.php:28
12	include JROOT/components/com_instantpaypal/templates/default/views/home/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_instantpaypal/views/home/view.html.php:47
9	InstantpaypalViewHome->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.35 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 3.135 MB Rows returned: 4

Duplicate queries: #14 #19 #22 #30 #36 #42 #48 #51 #59 #62 #65 #71 #74 #77 #79 #81 #116 #118 #120 #136 #138 #140 #157 #159 #161 #175 #177 #179 #197 #199 #201 #216 #218 #220 #237 #239 #241 #255 #257 #259 #276 #278 #280 #294 #296 #298 #315 #317 #319 #333 #335 #337 #354 #356 #358 #372 #374 #376 #393 #395 #397 #411 #413 #415 #432 #434 #436

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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:433
20	InstantpaypalFoundation->loadAccessLevels()	JROOT/administrator/components/com_instantpaypal/framework/items.php:165
19	InstantpaypalItems->__construct()	JROOT/administrator/components/com_instantpaypal/framework/items.php:790
18	InstantpaypalhelperItems::_count()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:114
17	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
16	InstantpaypalCategories->getCategories()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:344
15	InstantpaypalhelperCategories::_load()	JROOT/administrator/components/com_instantpaypal/framework/template.php:130
14	InstantpaypalhelperTemplate::_showWidget()	JROOT/administrator/components/com_instantpaypal/framework/template.php:72
13	InstantpaypalhelperTemplate::_showWidgets()	JROOT/components/com_instantpaypal/templates/default/views/home/default.php:28
12	include JROOT/components/com_instantpaypal/templates/default/views/home/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_instantpaypal/views/home/view.html.php:47
9	InstantpaypalViewHome->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.34 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 3.146 MB Rows returned: 2

Duplicate queries: #37 #141 #162 #416 #437

SELECT  DISTINCT `z`.`id`

  FROM `zov5y_instantpaypal_items` AS `z`

  WHERE (`category_id` LIKE '%\"3\"%')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_instantpaypal/framework/db.php:182
19	InstantpaypalDb->getCount()	JROOT/administrator/components/com_instantpaypal/framework/items.php:794
18	InstantpaypalhelperItems::_count()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:114
17	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
16	InstantpaypalCategories->getCategories()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:344
15	InstantpaypalhelperCategories::_load()	JROOT/administrator/components/com_instantpaypal/framework/template.php:130
14	InstantpaypalhelperTemplate::_showWidget()	JROOT/administrator/components/com_instantpaypal/framework/template.php:72
13	InstantpaypalhelperTemplate::_showWidgets()	JROOT/components/com_instantpaypal/templates/default/views/home/default.php:28
12	include JROOT/components/com_instantpaypal/templates/default/views/home/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_instantpaypal/views/home/view.html.php:47
9	InstantpaypalViewHome->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.33 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 3.155 MB Rows returned: 1

Duplicate queries: #41

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`='4' 
  AND `status`='1'

Explain

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

Profile

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

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/categories.php:106
17	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
16	InstantpaypalCategories->getCategories()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:344
15	InstantpaypalhelperCategories::_load()	JROOT/administrator/components/com_instantpaypal/framework/template.php:130
14	InstantpaypalhelperTemplate::_showWidget()	JROOT/administrator/components/com_instantpaypal/framework/template.php:72
13	InstantpaypalhelperTemplate::_showWidgets()	JROOT/components/com_instantpaypal/templates/default/views/home/default.php:28
12	include JROOT/components/com_instantpaypal/templates/default/views/home/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_instantpaypal/views/home/view.html.php:47
9	InstantpaypalViewHome->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.33 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 3.168 MB Rows returned: 4

Duplicate queries: #14 #19 #22 #30 #36 #42 #48 #51 #59 #62 #65 #68 #74 #77 #79 #81 #116 #118 #120 #136 #138 #140 #157 #159 #161 #175 #177 #179 #197 #199 #201 #216 #218 #220 #237 #239 #241 #255 #257 #259 #276 #278 #280 #294 #296 #298 #315 #317 #319 #333 #335 #337 #354 #356 #358 #372 #374 #376 #393 #395 #397 #411 #413 #415 #432 #434 #436

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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:433
20	InstantpaypalFoundation->loadAccessLevels()	JROOT/administrator/components/com_instantpaypal/framework/items.php:165
19	InstantpaypalItems->__construct()	JROOT/administrator/components/com_instantpaypal/framework/items.php:790
18	InstantpaypalhelperItems::_count()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:114
17	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
16	InstantpaypalCategories->getCategories()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:344
15	InstantpaypalhelperCategories::_load()	JROOT/administrator/components/com_instantpaypal/framework/template.php:130
14	InstantpaypalhelperTemplate::_showWidget()	JROOT/administrator/components/com_instantpaypal/framework/template.php:72
13	InstantpaypalhelperTemplate::_showWidgets()	JROOT/components/com_instantpaypal/templates/default/views/home/default.php:28
12	include JROOT/components/com_instantpaypal/templates/default/views/home/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_instantpaypal/views/home/view.html.php:47
9	InstantpaypalViewHome->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.09 ms Query memory: 0.025 MB Memory before query: 3.179 MB Rows returned: 1

Duplicate queries: #43 #82 #121

SELECT  DISTINCT `z`.`id`

  FROM `zov5y_instantpaypal_items` AS `z`

  WHERE (`category_id` LIKE '%\"4\"%')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_instantpaypal/framework/db.php:182
19	InstantpaypalDb->getCount()	JROOT/administrator/components/com_instantpaypal/framework/items.php:794
18	InstantpaypalhelperItems::_count()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:114
17	InstantpaypalCategories->getCategory()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:95
16	InstantpaypalCategories->getCategories()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:344
15	InstantpaypalhelperCategories::_load()	JROOT/administrator/components/com_instantpaypal/framework/template.php:130
14	InstantpaypalhelperTemplate::_showWidget()	JROOT/administrator/components/com_instantpaypal/framework/template.php:72
13	InstantpaypalhelperTemplate::_showWidgets()	JROOT/components/com_instantpaypal/templates/default/views/home/default.php:28
12	include JROOT/components/com_instantpaypal/templates/default/views/home/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_instantpaypal/views/home/view.html.php:47
9	InstantpaypalViewHome->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: 3.185 MB Rows returned: 4

Duplicate queries: #47

SELECT  DISTINCT `z`.`id`

  FROM `zov5y_instantpaypal_categories` AS `z`

  WHERE `status`='1' 
  AND `featured`!='2'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_instantpaypal/framework/db.php:182
18	InstantpaypalDb->getCount()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:266
17	InstantpaypalFoundation->getCount()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:98
16	InstantpaypalCategories->getCategories()	JROOT/administrator/components/com_instantpaypal/framework/categories.php:344
15	InstantpaypalhelperCategories::_load()	JROOT/administrator/components/com_instantpaypal/framework/template.php:130
14	InstantpaypalhelperTemplate::_showWidget()	JROOT/administrator/components/com_instantpaypal/framework/template.php:72
13	InstantpaypalhelperTemplate::_showWidgets()	JROOT/components/com_instantpaypal/templates/default/views/home/default.php:28
12	include JROOT/components/com_instantpaypal/templates/default/views/home/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_instantpaypal/views/home/view.html.php:47
9	InstantpaypalViewHome->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.52 ms After last query: 161.33 ms Query memory: 0.025 MB Memory before query: 3.196 MB Rows returned: 4

Duplicate queries: #14 #19 #22 #30 #36 #42 #48 #51 #59 #62 #65 #68 #71 #77 #79 #81 #116 #118 #120 #136 #138 #140 #157 #159 #161 #175 #177 #179 #197 #199 #201 #216 #218 #220 #237 #239 #241 #255 #257 #259 #276 #278 #280 #294 #296 #298 #315 #317 #319 #333 #335 #337 #354 #356 #358 #372 #374 #376 #393 #395 #397 #411 #413 #415 #432 #434 #436

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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:433
17	InstantpaypalFoundation->loadAccessLevels()	JROOT/administrator/components/com_instantpaypal/framework/items.php:165
16	InstantpaypalItems->__construct()	JROOT/administrator/components/com_instantpaypal/framework/items.php:808
15	InstantpaypalhelperItems::getFeaturedIds()	JROOT/administrator/components/com_instantpaypal/framework/template.php:87
14	InstantpaypalhelperTemplate::_showWidget()	JROOT/administrator/components/com_instantpaypal/framework/template.php:72
13	InstantpaypalhelperTemplate::_showWidgets()	JROOT/components/com_instantpaypal/templates/default/views/home/default.php:28
12	include JROOT/components/com_instantpaypal/templates/default/views/home/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_instantpaypal/views/home/view.html.php:47
9	InstantpaypalViewHome->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.57 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 3.207 MB Rows returned: 9

SELECT  DISTINCT `z`.`id`

  FROM `zov5y_instantpaypal_items` AS `z`

  LEFT JOIN `zov5y_instantpaypal_categories` AS `c` 
  ON (`z`.`category_id` LIKE CONCAT("%",`c`.`id`,"%"))

  WHERE (`z`.`featured` LIKE '%1%') 
  AND (`z`.`status` LIKE '%1%') 
  AND `z`.`status`='1'

  ORDER BY `z`.`sort` ASC 
  LIMIT 0,24

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	11	Using where; Using temporary; Using filesort
1	SIMPLE	c	index	NULL	PRIMARY	2	NULL	4	Using where; Using index; Using join buffer (flat, BNL join)

Profile

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

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:234
18	InstantpaypalDb->getSearch()	JROOT/administrator/components/com_instantpaypal/framework/foundation.php:260
17	InstantpaypalFoundation->getSearch()	JROOT/administrator/components/com_instantpaypal/framework/items.php:247
16	InstantpaypalItems->getSearch()	JROOT/administrator/components/com_instantpaypal/framework/items.php:826
15	InstantpaypalhelperItems::getFeaturedIds()	JROOT/administrator/components/com_instantpaypal/framework/template.php:87
14	InstantpaypalhelperTemplate::_showWidget()	JROOT/administrator/components/com_instantpaypal/framework/template.php:72
13	InstantpaypalhelperTemplate::_showWidgets()	JROOT/components/com_instantpaypal/templates/default/views/home/default.php:28
12	include JROOT/components/com_instantpaypal/templates/default/views/home/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_instantpaypal/views/home/view.html.php:47
9	InstantpaypalViewHome->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.42 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 3.220 MB Rows returned: 9

Manifesting Heaven On Earth

COTC eStore

Categories

Featured products

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

483 Queries Logged 190.30 ms

414 duplicate found!